Loan Payment Calculator: How Compounding Interest Works

A loan payment calculator estimates the monthly payment and total interest for a fixed-rate, level-payment loan. Enter the amount borrowed, annual percentage rate (APR), and term in years to see the estimated payment and interest; the calculation assumes monthly payments and monthly compounding.

Formula

The monthly payment is calculated from the standard amortizing-loan formula:

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

• P is the original principal, or amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 12 ÷ 100. With an APR of 8%, for example, r = 0.08 ÷ 12.
• n is the total number of monthly payments: loan term in years × 12.

The calculator’s second result is total interest: monthly payment × number of payments − principal. In this calculator, the payment formula is displayed directly in the block: p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)). The APR input is a percentage, so dividing by 1,200 converts it to a monthly decimal rate.

Worked Example

Using the default inputs—$20,000 principal, 8% APR, and 5 years—the loan has 60 monthly payments.

1. Convert APR to a monthly rate: 8 ÷ 1,200 = 0.0066667.
2. Set the payment count: 5 × 12 = 60.
3. Substitute into the formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
4. The unrounded result is about $405.53 per month; the calculator displays $405.53.
5. Total interest using that displayed payment is $405.53 × 60 − $20,000 = $4,331.80.

Actual payment schedules can differ by a few cents because lenders may calculate interest and round each installment according to their own disclosures.

Assumptions

• The interest rate stays fixed throughout the term.
• Payments are equal, made monthly, and assumed to occur at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• Fees, taxes, insurance, private mortgage insurance, escrow, late charges, and extra payments are not included.

How Monthly Compounding Affects Payments

Compounding means interest is calculated on an outstanding balance that already reflects prior payments and interest charges. For this estimate, the annual rate is divided by 12 to get a monthly rate. Interest for a period is then applied to the remaining principal, rather than calculating the same amount of interest on the original loan for every month.

Each level payment includes interest for that month and repayment of some principal. Early in the schedule, the balance is relatively large, so more of the payment goes toward interest. As principal is paid down, the interest portion generally shrinks and the principal portion grows. This pattern is called amortization.

Compounding does not mean that the same interest charge is simply added to the original amount every month. The outstanding balance changes after payments. For a fully amortizing loan with the assumptions above, the formula finds a payment that pays the balance down to approximately zero over the stated number of installments.

When to Use the Calculator and Read the Results

Use this estimate to understand the relationship between the loan amount, APR, term, monthly installment, and total interest. It can also help you check a quoted payment, provided the quote uses the same principal, rate, term, payment frequency, and included charges.

• Monthly payment is the estimated regular installment, not necessarily the full amount due if the loan has separate charges.
• Total interest is the estimated interest over all scheduled payments, based on the displayed payment multiplied by the number of months.
• Total scheduled payments can be inferred by adding the principal to total interest. In this example, $20,000 + $4,331.80 = $24,331.80.

Try changing one input at a time to see its mathematical effect. For a fixed principal and rate, a longer term usually spreads repayment across more months, lowering the scheduled monthly payment while increasing the number of periods on which interest accrues. A higher principal or APR increases the calculated payment when the other inputs stay fixed. These are formula relationships, not judgments about a particular loan.

Compounding, APR, and Other Loan Calculators

APR is entered as an annual percentage, but this calculator uses a monthly periodic rate equal to APR divided by 12. That is a simplifying convention for a standard fixed-rate installment loan. Some disclosures may account for fees or use different conventions, so a disclosed APR and the rate used to accrue interest may not be interchangeable for every product. Enter the APR specified for the calculation and check the loan documents for how interest is actually computed.

A simple-interest estimate that charges interest only on the original principal for the whole term is not the same as an amortizing-loan calculation. Nor is this formula a credit-card balance model: card balances can involve changing rates, varying payments, new transactions, and issuer-specific calculation methods. An adjustable-rate loan also needs future rate changes to be modelled; one fixed APR cannot predict those changes.

Common Calculation Problems and Limits

• Entering 8 instead of 0.08: the APR field expects a percentage such as 8 for 8%, not a decimal fraction.
• Confusing years and months: the term field is in years, and the formula multiplies it by 12.
• Comparing unlike estimates: payment figures are not directly comparable if one includes fees or insurance and the other does not.
• Ignoring cent rounding: a lender’s rounding at each payment can create a small difference in the final installment or total.

The formula is for a positive-rate, fixed-rate loan with equal monthly payments and a fully amortizing schedule. It does not calculate a balloon payment, interest-only period, deferred interest, irregular payment dates, or a changing rate. The input APR minimum is 0.01% because the payment formula shown divides by the monthly rate; a true 0% loan requires the separate calculation principal ÷ number of payments.

Frequently Asked Questions

Does a loan payment calculator include compound interest?
Yes, this calculator models monthly compounding by applying APR ÷ 12 to the outstanding balance each month as the loan amortizes. It assumes a fixed rate and regular monthly payments.

Is loan interest compounded monthly or daily?
It depends on the loan’s terms and calculation method. This calculator assumes monthly compounding; check the lender’s disclosure for the actual method and payment schedule.

Why does the payment include more interest at the beginning?
The balance is largest at the start, so applying the monthly rate to it produces a larger interest charge. As payments reduce principal, the interest portion generally declines.

Does a longer loan term reduce total interest?
Not necessarily. For the same principal and fixed rate, a longer term usually lowers each scheduled payment but creates more payment periods, which generally increases total interest in this formula.

Why is my lender’s payment different?
The quote may include fees or other charges, use a different rate or day-count method, round payments differently, or have a different first payment date. Compare the assumptions and disclosures before interpreting the difference.

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

Related

• House Loan Payment Calculator: Estimate Monthly Costs
• House Down Payment Calculator: Estimate Cash Needed
• Home Payment Calculator: Estimate Your Monthly 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