Is to create a loan amortization schedule or table to see what is actually going on from one payment period to the next. For amortization formulas, I think the best way to understand the equations I generally do not like to use built-in financial formulas unless I understand how they These functions use similar definitions for the arguments: See the Excel help file on this function.
CUMPRINC( rate, nper, pv, n1, n2,0) - Cumulative principal payment for the periods n1 through n2.CUMIPMT( rate, nper, pv, n1, n2,0) - Cumulative interest payment for the periods n1 through n2.
NPER( rate, pmt, pv) - The number of payment periods.PMT( rate, nper, pv) - The amount of the periodic payment.ISPMT( rate, per, nper, pv) - The amount of interest paid during a specific period.Excel's help file does a good job of explaining the following functions, but the spreadsheet examples will demonstrate how some of these formulas might be used.
