Heres what you should put in each cell. This formula is copied across to the interest and principal columns and the absolute column reference ensures the new formulas still point to column G. Some of the basics needed to calculate amortization include knowledge on how to use.
Mathematically it is represented as Total Repayment P rn 1 rntn 1 rntn 1.
Fill out cells B1-B3 with information about your loan. Fill out cells B1-B3 with information about your loan. There is an equation built into Microsoft Excel that can really help you with calculating amortization. We use named ranges for the input cells.