12 | | | Calculates amortization | |
|
|
|
| schedule for first 12 |
|
|
|
| payments, but does not |
|
|
|
| display it. |
|
| Displays interest paid in | ||
|
| | ||
|
|
|
| first year. |
|
| Displays principal paid | ||
|
| | ||
|
|
|
| in first year. |
|
| Displays balance at end | ||
|
| | ||
|
|
|
| of first year. |
|
| Calculates amortization | ||
|
| | ||
|
|
|
| schedule for next 12 |
|
|
|
| payments. |
|
| Displays results for | ||
|
| | ||
|
|
|
| second year. |
To calculate the balance after 42 payments (3½ years), amortize 18 additional payments (42-24=18):
18 | | | Calculates amortization | |
|
|
|
| schedule for next 18 |
|
|
|
| months. |
|
| Displays results. | ||
|
| | ||
|
|
| |
|
5: Time Value of Money 81
File name :