Chapter 7 - Spreadsheets: Financial Functions

1 and is sometimes referred to as an amortization schedule. The loan would be paid off at the point where the remaining principal value is $0. Using Financial Functions to Calculate Compound Interest. As you can see, the calculation of compounding even for a few periods can become tedious. Imagine the calculation for a 30-year mortgage that is compounded monthly: there would be 12*30=360 ... ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download