How to Calculate Reducing Balance Interest Rate | Sapling

How to Calculate Reducing Balance Interest Rate

Written By
Robert Shaftoe
Robert Shaftoe
Jul 8, 2011
2 minute read
abstract computer graphics business financial statistics.
Use a spreadsheet to create an amortization table to track a reducing balance loan. Image Credit: Mirexon/iStock/Getty Images

Calculating a reducing balance interest payment is simple and straightforward. The interest rate is stated within the loan agreement. This is applied to the loan principal, which continuously reduces as interest and principal payments are made. If the interest rate is stated as an annual percent rate and payments are made more than once per year, the interest rate must be adjusted to match the number of periods per year payments are made. For example, if the APR is 12 percent, and monthly payments are made, the monthly interest rate equals the APR of 12 percent divided by 12 months, or 1 percent.

Amortization Table

Consider an initial loan amount of $1,000, at 2 percent interest per month for 6 months, with equal monthly installment payments of $178.53 per month. In the first month, interest is equal to the balance of $1,000 multiplied by 2 percent interest, or $20. In Month 1, the installment payment of $178.53 was allocated as: $20 to interest and principal reduction of $158.53.

This means that at the beginning of Month 2, the loan balance equals $1,000 minus the loan reduction of $158.53, or $841.47. Interest expense equals 2 percent multiplied by $841.47, or $16.83. The loan reduction this time is equal to $178.53 minus interest expense of $16.83, or $161.70. Continuing this exercise through Month 6 results in total loan reduction of $1,000 and total interest expense paid of $71.15, the sum of which happens to equal $1071.15. This figure, $1071.15, also is equal to the sum of the six monthly installment payments of $178.53.

Robert Shaftoe

Robert Shaftoe started his career in asset management before moving to consulting, where he has spent the past 10 years. His specialties include securities valuation and complex financial analysis. He has substantial experience in working…

Sapling Logo

We demystify personal finance and make financial adulting easier. From student loans to credit and investing, all the money questions you were ever afraid to ask are right here.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.