Declining Balance Loan Amortization Schedule Calculator

A declining balance loan amortization schedule shows how each payment is divided between interest and principal, and how the balance falls over time. Enter the loan amount, annual APR, and term to calculate the fixed monthly payment and total interest; the schedule is based on a standard fixed-rate, monthly-payment loan.

Formula

The schedule follows the declining balance method: interest for each period is calculated on the balance still owed, and the rest of the payment reduces principal. For a fixed monthly payment, the payment is calculated as:

Payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the original loan principal, in dollars.
• r is the monthly interest rate, calculated as annual APR ÷ 1,200. APR is entered as a percentage per year.
• n is the number of monthly payments, calculated as loan term in years × 12.

For payment number t, interest is the opening balance multiplied by r; principal paid is the payment minus that interest. The closing balance is opening balance minus principal paid. Total interest in this calculator is the displayed monthly payment multiplied by the number of payments, minus the original principal. The payment is rounded to cents before the total is calculated.

Worked Example

Using the calculator’s defaults: principal P = $20,000, APR = 8%, and term = 5 years.

1. Monthly rate: r = 8 ÷ 1,200 = 0.0066667, or about 0.66667%.
2. Number of payments: n = 5 × 12 = 60.
3. Monthly payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53, rounded to cents.
4. Total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The first payment’s interest is $20,000 × 0.0066667, about $133.33. The remaining $272.20 of the $405.53 payment reduces principal, leaving an approximate balance of $19,727.80. Later interest charges are lower as the balance declines. Small differences can arise if a lender uses a different rounding or payment-date convention.

Assumptions

• The interest rate is fixed for the entire loan term.
• Payments are monthly and made at the end of each period.
• Interest is calculated monthly at APR ÷ 12, with no separate daily-interest adjustment.
• Fees, taxes, insurance, PMI, and escrow are not included.

How to Read a Declining Balance Schedule

A full schedule normally has one row per payment, with columns for the payment number or date, opening balance, payment, interest, principal, and closing balance. The opening balance in the first row is the original amount borrowed. In each later row, the previous row’s closing balance becomes the new opening balance.

With a fixed rate and equal monthly payments, the interest portion generally gets smaller over time because it is calculated against a smaller balance. The principal portion generally gets larger, while the payment stays level. Near payoff, most of each payment goes to principal. This pattern is sometimes called a fixed-payment declining balance schedule; it is not the same as a plan that makes the payment itself shrink every month.

When This Calculation Applies

This formula is suitable for estimating a fully amortizing loan with a fixed APR, equal monthly payments, and no extra payments. It is useful for understanding the planned payment and the overall interest implied by those inputs, or for checking how principal reduction works.

It does not create a lender-issued, dated statement. The calculator gives aggregate results, not a separate output row for every month. To build a month-by-month table, repeat these steps for each period: multiply the current balance by the monthly rate to find interest; subtract that interest from the payment to find principal; subtract principal from the opening balance to find the closing balance. Carrying unrounded values internally can produce slightly different cents than rounding each monthly line.

Common Misconceptions and Limits

• APR is not the monthly rate. For this estimate, divide APR by 12 to get a monthly percentage, or by 1,200 to express it as a decimal. Entering 8 as the monthly rate instead of as an annual percentage would greatly distort the calculation.
• Declining balance does not always mean declining payments. Here, the balance and interest portion decline, but the scheduled payment is fixed. A lender may use a different structure, such as variable payments or a different payment frequency.
• Fees and timing can change the real figures. Origination charges, payment dates, daily interest, irregular first periods, late payments, and lender rounding may affect actual cash flows or payoff amounts.
• Extra payments are not modelled. An additional principal payment can change the balance path and may affect the payoff date or later payment amount according to the loan terms. This calculator assumes only the scheduled payments.

For a variable-rate loan, the rate can change, so one fixed payment and one fixed schedule cannot represent the whole term. Likewise, a balloon payment, interest-only period, or payment that does not fully amortize the debt requires a different calculation. Use the rate, term, and payment structure stated in the lender’s documents rather than treating an illustrative input as a quoted offer.

Frequently Asked Questions

What does declining balance mean on a loan?
It means interest is charged on the outstanding principal balance. As principal is repaid, the balance falls, so the interest portion of later payments generally falls too.

How do I calculate interest for one payment?
Multiply the opening balance for that period by the periodic interest rate. For this monthly estimate, the periodic rate is APR divided by 1,200. Subtract the interest from the payment to find the principal portion.

Why does my lender’s schedule differ by a few cents?
Payment rounding, the exact payment date, daily versus monthly interest calculations, and the lender’s treatment of the first or final period can create small differences. Compare the stated assumptions and use the lender’s schedule for its contractual figures.

Does paying extra reduce total interest?
Reducing principal sooner generally reduces the balance on which later interest is calculated. The effect on payment amounts and payoff timing depends on how the loan applies extra payments; this calculator does not include them.

Is declining balance the same as the Rule of 78?
No. A declining balance schedule calculates each period’s interest from the remaining principal. The Rule of 78 is a different method for allocating finance charges over time; it is not used in this calculator.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Weekly vs Monthly Loan Payment Calculator
• Balloon Loan Calculator: Monthly Payment and Balloon Amount
• Loan Amortization Schedule Calculator: Balance After Any Payment

in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2