The Loan Amortization Table is a great tool to use when looking at the financial impact of a loan.
This model contains an input section where loan detail can be entered such as the Number of Payments, Interest Rate, and Initial Loan Amount. The model will then calculate the information to give a breakdown of principal and interest paid each period and the remaining principal balance. This allows for additional payments to be entered into cell G8 to calculated the payoff period when additional payments are made. Rows will become highlighted in yellow to display when the loan has been paid off. Two charts are shown in the next worksheet to visualize the paydown period as well as the ratio of principal to the interest of each payment during the life of the loan.
All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.