Return to site

Excel amortization schedule

broken image
broken image

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

broken image

These functions use similar definitions for the arguments: See the Excel help file on this function.

broken image

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.

broken image