Interest and Annuity Calculation

An Excel file that teaches how to perform Interest and Annuity Calculation operation.

Excel Spreadsheet for Interest and Annuity Calculation

Principal, interest rate, and term information are entered into the table. The PMT function calculates the installment amount. The total interest and maturity difference are displayed in separate fields. The graph shows the decrease in debt. The results page is in the form of a payment plan.

Hope it is useful.