Amortization Chart

Amortization Chart is an Excel template that will allow you to view the amortization graph of your loan.

Loan amortization is a method of debt repayment in equal installments over a specific period of time where the payment amount consists of paying principal and interest with different amount every month.

There are four tabs in this dashboard with description as follow :

Data Tab: This is the tab where you have to type your loan amortization parameters. Type your loan amount, bank interest rate (percent/year), payment period (in month) and payment start date in corresponding cells. And the other three tabs will automatically reveal your loan amortization information based on your data.

Table Tab: This is the area where you can see the break down of your monthly payment. You will see how your principal payment gradually increased and interest payment decreased month by month. And you can see also how your total principal is decreased every month. And there is a scroll bar that you can use to scroll payment information from the first month until the end of payment period.

Chart Tab: This is a visualization of your payment per year (not per month). You can see that your interest payment (bar with pink color) is higher than principal payment (bar with dark red color) in the first half of your loan period. You will see that it is not economically wise to payoff your loan in the first half of your loan period. Those bar values are referred to the left side of the chart. And there is a balance amount that displayed with the blue line where the values referred to the right side of the chart.

Summary Tab: This is an area where you can see your monthly payment, the total amount of your monthly payment and the payoff date.