Understanding the Mathematics of Personal Finance
MY WEBSITE SPREADSHEET
If you’d like to try my website spreadsheet calculators, please take a moment and glance through Chapter 15. You’ll find instructions for obtaining a free spreadsheet program if you need one, as well as instructions for downloading and using my spreadsheets.
Tables 2.1 and 2.2 were generated with my spreadsheet Ch2CompoundInterest. xls. After opening the spreadsheet, click on the Basic tab. Table 2.3 shows part of Table 2.2 with the spreadsheet’s row and column designations added.
|
Table 2.3 Table 2.2 (First Few Entries Only Are Shown) in Spreadsheet Format
|
The first example above (Table 2.1) is generated using my spreadsheet with the following entries (to the left of the green line):
The number of years that interest is accruing The number of compounding intervals per year
This is the APR
Up-front fee. This hasn’t been discussed yet. Set it = 0 for now.
For the second example above (Table 2.2):
Nr Years = 2 The number of years that interest is accruing
Cmpds per Year = 12 Monthly compounding
Principal = $10,000.00
Rate = 10.00% APR
Up - front = $0.00
Your results should agree with Table 2.2. The spreadsheet (to the right of the green line) should look exactly like Table 2.3 (the first few lines of the spreadsheet, that is).
