Balance Equation: Cost and Monthly Payment Calculator

A balance equation estimates a loan’s monthly payment and total interest from its principal, annual percentage rate (APR), and term. Enter those three figures to see the level monthly payment and the interest calculated over the full term; the example starts with a $20,000 loan at 8% APR for five years.

Formula

For a fixed-rate loan with equal monthly payments, the payment formula is:

M = P × r ÷ [1 − (1 + r)−n]

• M is the monthly payment in dollars.
• P is the original loan principal in dollars.
• r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200.
• n is the number of monthly payments, calculated as loan term in years × 12.

The calculator’s second result is total interest: I = M × n − P, where I is dollars of interest over the entire scheduled term. It uses the displayed monthly payment to the cent, so small differences from a lender’s final total can occur if the lender adjusts the last payment or rounds each month differently.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and five years—the monthly rate is 0.08 ÷ 12 = 0.0066667, and the payment count is 5 × 12 = 60.

1. Substitute the values: M = 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60].
2. The unrounded monthly payment is about $405.53; rounded to cents, it is $405.53 per month.
3. Total scheduled payments using that rounded amount are $405.53 × 60 = $24,331.80.
4. Subtract the original principal: $24,331.80 − $20,000 = $4,331.80 in total interest.

Assumptions

• The APR and payment remain fixed throughout the term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest is compounded monthly using APR divided by 12.
• The estimate excludes fees, taxes, insurance, PMI, escrow, and any other charges not entered as inputs.

What “Balance Equation” Means

“Balance equation” can refer to more than one calculation. In loan discussions, it often means the mathematics used to connect the starting balance, interest rate, payments, and remaining balance. This page calculates the scheduled payment and the total interest for a standard amortizing loan; it does not calculate a payoff quote or the balance on a particular date.

With an amortizing payment, each monthly payment covers the interest accrued for that period and reduces principal by whatever remains. Early in the schedule, interest generally makes up a larger portion of each payment because it is calculated on a larger outstanding balance. As the balance declines, the interest portion falls and more of a fixed payment goes toward principal. The payment formula spreads repayment across the selected number of months.

How to Use and Read the Results

Enter the principal amount, the loan’s stated APR as a percentage, and the term in years. For example, enter 8 for an 8% APR—not 0.08—because the formula converts the percentage into a monthly decimal rate. The term must be entered in years; a 30-month term is 2.5 years.

• Monthly payment is the modeled amount due each month for principal and interest. It is not necessarily the complete bill if the loan has other charges.
• Total interest is the modeled interest paid over all scheduled payments. It is not the total amount paid; add the principal to get scheduled payments.
• Loan amount should be the amount borrowed, rather than a home or vehicle’s purchase price unless that entire price is financed.

The APR is an input, not a quote. Use the figure supplied for the specific loan when estimating it, and check with the lender for the exact payment schedule and fees. This calculator does not retrieve rates or determine whether a borrower qualifies.

Factors That Change the Cost

For the same principal and APR, a longer term usually produces a lower scheduled monthly payment but more total interest, because interest accrues for more payment periods. A shorter term generally raises the monthly payment while reducing the number of periods over which interest is charged. These are mathematical effects, not a recommendation about which term to select.

A higher APR increases the periodic interest charge and normally raises both the payment and total interest. A larger principal also raises the payment and interest when the rate and term stay unchanged. Extra payments can alter the actual payoff path, but this calculator assumes the regular scheduled payment only. It does not model extra payments, skipped payments, variable rates, or a changing balance caused by fees.

Common Mistakes and Limits

• Mixing up APR and monthly rate: Enter APR as a yearly percentage. Do not enter the monthly rate in the APR field.
• Confusing payment with total cost: The first result is one monthly payment. Total scheduled payments are the payment multiplied by the number of months.
• Assuming every loan uses this structure: The formula applies to fixed-rate, fully amortizing loans with equal monthly payments. Interest-only, balloon, variable-rate, and irregular-payment arrangements need different calculations.
• Treating an estimate as a payoff amount: A payoff figure on a particular date may include accrued interest and other account-specific items that are not represented here.

Rounding is another source of small discrepancies. This estimate rounds the monthly payment to cents and uses that rounded figure to calculate total interest. A lender may calculate interest daily, round individual charges differently, or adjust the final payment, so its disclosed schedule can differ by a small amount.

Frequently Asked Questions

What does a balance equation calculate?
In this calculator, it determines the monthly payment for a fixed-rate amortizing loan and estimates the total interest across the scheduled term. It does not show a date-specific remaining balance.

How do I calculate the monthly payment by hand?
Convert APR to a monthly decimal by dividing it by 1,200, multiply the term in years by 12, and substitute the principal, monthly rate, and payment count into the formula above.

Does the monthly payment include fees or insurance?
No. The estimate covers modeled principal and interest only. Fees, taxes, insurance, PMI, and escrow are excluded unless separately included in an entered loan amount or another calculation.

Why is the lender’s total different?
Differences can result from daily rather than monthly interest calculations, payment dates, fees, rounding practices, or a final payment adjustment. Compare the calculator’s assumptions with the lender’s disclosure.

Can I use this for a variable-rate loan?
Only as a simplified estimate for a period with a specified rate. The calculator assumes that APR stays fixed for the entire term, so it cannot project future changes to a variable rate.

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

Related

• Loan Balance Formula: Calculate What You Still Owe
• Loan Balance Confirmation: What It Shows
• Loan Balance Equation: Formula and Calculator

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