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.
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.