Flat rate versus Reducing Balance Interest Calculator

Excel Spreadsheet to assist with comparing the difference in Total Payments made when a Bank/Financier uses

• The Flat rate method for interest Calculation versus The Reducing Balance method Or
• The Reducing Balance method for interest Calculation versus the Flat rate method

Easily Compare the total payments made from either method by keying in your loan amount, interest rate, and tenure on the template provided.

Product Features

The Template also helps you know how additional Principal payments can affect the Total Interest payments and reduce the Loan tenure.

• Downloadable Excel Spreadsheet with mock data (edit these to your own)
• The Template contains
• A Flat rate calculation Template
• A loan Amortization schedule for the reducing balance method
• Automated formulas and calculations