Spreadsheets take the hard work out of financial calculations, but you still need to know how to do them. In this revised published version of her I Programmer e-book, Janet Swift explains how to use the spreadsheet of your choice to make financial decisions relating to investments and loans, to understand how inflation affects a cashflow and to get to grips with advanced concepts like the internal rate of return.

Author: Janet Swift
Publisher: I/O Press
Date: July 4, 2016
Pages: 120
ISBN: 978-1871962017
Print:1871962013
Category: Applications 
Audience: Every spreasheet user

Financial Functions With A Spreadsheet assumes that you are familiar with the fundamental operations of the spreadsheet of your choice, Excel, Google Sheets, LibreOffice Calc or similar, and introduces you to the built-in functions provided for making financial decisions. Throughout the book sample spreadsheets and charts are presented with details of how you can construct them for yourself and use them for you own investigations and investment decisions. 

• Understanding Percentages
• Time Is Money - Simple and Compound Interest
• Effective Interest Rate
• Introduction to Cashflow - Savings Plans
• Cashflow Continued - Annuities
• Exploring Repayment Loans
• Coping With Irregular Cashflow
• Investment Analysis
• Advanced Investment Analysis - Internal Rate of Return

Visit Book Watch Archive for hundreds more titles.

Subscribe to I Programmer's Books RSS feed 
or follow @bookwatchiprog on Twitter for news addition to Book Watch and for new reviews. Contact  BookWatch@i-programmer.info.