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 rateReducing balanceDifference
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

MonthInterestPrincipalInstalmentClosing 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).

MonthInterestPrincipalInstalmentClosing balance
130,000154,598184,598845,402
225,362159,235184,598686,167
320,585164,012184,598522,155
415,665168,933184,598353,222
510,597174,001184,598179,221
65,377179,221184,5980

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.