Bank Loan Payment Plan Calculation

An Excel file that teaches how to perform Bank Loan Payment Plan Calculation operation.

Excel Template for Bank Loan Payment Plan Calculation

Principal and interest rates are calculated using a formula. Periodic installment amounts are listed. The total interest burden is shown separately. A payment curve is created using a graph. The report is dynamically updated.

Hope it is useful.