Loan Schedule Calculator: Flat vs Reducing Balance (Free)
Compare a flat-rate loan with a reducing-balance loan side by side. Enter the loan, the monthly rate and the term to see the instalment, the total interest and a month-by-month repayment schedule.
| Flat rate | Reducing balance | Difference | |
|---|---|---|---|
| Monthly instalment | 196,667 | 184,598 | 12,069 |
| Total interest | 180,000 | 107,585 | 72,415 |
| Total repayment | 1,180,000 | 1,107,585 | 72,415 |
Reducing-balance schedule
| Month | Interest | Principal | Instalment | Closing balance |
|---|---|---|---|---|
| 1 | 30,000 | 154,598 | 184,598 | 845,402 |
| 2 | 25,362 | 159,235 | 184,598 | 686,167 |
| 3 | 20,585 | 164,012 | 184,598 | 522,155 |
| 4 | 15,665 | 168,933 | 184,598 | 353,222 |
| 5 | 10,597 | 174,001 | 184,598 | 179,221 |
| 6 | 5,377 | 179,221 | 184,598 | 0 |
See the APR of the flat-rate loan in the flat rate to APR calculator.
How it works
flat: interest = loan × rate × months
instalment = (loan + interest) ÷ months
reducing: instalment = loan × r ÷ (1 − (1 + r)^−months)
each month: interest = balance × r
principal = instalment − interest
balance = balance − principal
With a flat rate, interest is charged on the original loan every month. With reducing balance, it is charged only on what is still owed, so each month's interest is smaller and more of the instalment repays the loan. The last instalment is adjusted for rounding so the balance ends at exactly zero.
Worked example
A loan of 1,000,000 at 3% a month for 6 months costs 180,000 in interest at a flat rate (instalment 196,667) and about 107,585 on a reducing balance (instalment 184,598).
| Month | Interest | Principal | Instalment | Closing balance |
|---|---|---|---|---|
| 1 | 30,000 | 154,598 | 184,598 | 845,402 |
| 2 | 25,362 | 159,235 | 184,598 | 686,167 |
| 3 | 20,585 | 164,012 | 184,598 | 522,155 |
| 4 | 15,665 | 168,933 | 184,598 | 353,222 |
| 5 | 10,597 | 174,001 | 184,598 | 179,221 |
| 6 | 5,377 | 179,221 | 184,598 | 0 |
Good to know
- What is the difference between flat rate and reducing balance?
- A flat rate charges interest on the original loan every month. Reducing balance charges interest only on what is still owed, so the interest falls as the loan is repaid.
- Why is the reducing-balance instalment lower?
- Each month's interest is worked out on a smaller balance, so the total interest is lower and so is the equal monthly instalment that covers it.
- Which method should our group use?
- Either works if every member agrees and it is written in the group's rules. Reducing balance is fairer to borrowers; flat rate is easier to work out by hand and earns the group more.
Estimates for information only, not financial advice.