Loan Calculator Monthly Breakdown: Payment and Interest

A loan calculator monthly breakdown estimates your fixed monthly principal-and-interest payment and shows how much interest you would pay over the full term. Enter the loan amount, annual percentage rate (APR), and term in years to see the estimated payment and total interest; the schedule explains how each payment changes the balance.

Formula

The calculator uses the standard fixed-payment amortization formula. It assumes equal monthly payments and a constant rate over the full term:

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

• P is the amount borrowed, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
• n is the number of monthly payments, calculated as years × 12.
• Payment is the estimated monthly principal-and-interest amount, in dollars.

Total interest is calculated as monthly payment × number of payments − loan amount. The calculator uses the unrounded formula result for its displayed payment rounding, and the total-interest output is based on that payment result. For an actual payment schedule, lenders may calculate and round each period according to the loan contract.

Worked Example

Using the calculator’s default values—$20,000 borrowed, 8% APR, and a five-year term:

1. Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
2. Calculate the number of payments: 5 × 12 = 60.
3. Apply the formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = about $405.53 per month.
4. Calculate total interest using the displayed monthly payment: $405.53 × 60 − $20,000 = $4,331.80.

These are estimates rounded to cents. Payment is shown as $405.53; actual contract calculations may differ slightly because of rounding, payment dates, or other terms.

Assumptions

• The interest rate is fixed for the entire term.
• Payments are level, made monthly, and paid at the end of each period.
• Interest accrues monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, and any optional add-ons are not included.

What Each Monthly Payment Covers

For a fully amortizing loan, each payment has two main parts: interest for that period and principal that reduces the amount owed. Interest is calculated on the outstanding balance, so the interest portion is generally larger early in the schedule. As principal is repaid, the balance falls, and a greater share of later payments goes toward principal. The total payment remains level under the formula’s assumptions.

At the start of the example, estimated first-month interest is $20,000 × 0.0066667, or about $133.33. Subtracting that from the $405.53 payment leaves about $272.20 to reduce principal. The next month’s interest is calculated on a lower balance. Small differences can occur because a displayed example rounds intermediate figures.

A monthly breakdown or amortization schedule typically lists the payment number, payment amount, interest, principal, and remaining balance for each month. This calculator provides the fixed payment and full-term interest estimate, not a month-by-month table. To construct a schedule, repeat the process each month: calculate interest on the current balance, subtract it from the payment to find principal repaid, then subtract that principal from the balance.

How to Read and Use the Estimate

Use the loan amount that will actually be financed, the APR supplied for the specific loan, and the term in years. APR is an annual percentage input; do not enter a monthly rate in its place. If the term is given in months, divide by 12 before entering it, provided the result fits the calculator’s allowed range. Get the applicable rate, fees, and contract details from the lender rather than treating the example defaults as a quote.

The monthly payment is a principal-and-interest estimate, not necessarily the full amount due each month. Depending on the loan, separate charges or required payments may apply. The total-interest figure assumes every scheduled payment is made as calculated and the loan runs for the entire entered term. It does not show the effect of missed payments, extra payments, a changed rate, or early payoff.

For a variable-rate loan, the payment or total interest can change when the rate resets, so a fixed-rate calculation cannot forecast the full schedule. An interest-only period, balloon payment, irregular payment frequency, or fees rolled into the balance also requires a different model or additional inputs.

Common Mistakes and Limitations

• Confusing APR and monthly rate: enter an annual percentage such as 8, not 0.6667. The calculator converts annual APR to a monthly rate.
• Using the wrong financed amount: the principal should reflect the amount borrowed. If costs are added to the loan, include them only if they are part of the financed balance.
• Assuming payment means total monthly cost: taxes, insurance, fees, and other charges are outside this principal-and-interest estimate.
• Overlooking cent rounding: the displayed payment is rounded to two decimal places. A lender’s daily accrual, payment dates, and rounding method can produce a slightly different payoff or interest total.

The formula is designed for a conventional level-payment schedule with a positive APR and a fixed term. It does not determine eligibility, predict a lender’s offer, or replace the loan agreement. The result is an estimate, and the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What does a monthly loan payment include?
In this calculator, it includes estimated principal and interest only. Other charges may be separate or handled differently under the loan terms.

Why does the interest portion fall over time?
Each period’s interest is calculated on the remaining balance. As payments reduce that balance, less interest accrues, leaving more of a level payment for principal.

Does a longer loan term lower the monthly payment?
For the same principal and APR under this formula, spreading repayment across more months generally lowers the scheduled payment. It also means interest accrues over more periods, so total interest may be higher.

Why is my lender’s payment different from the calculator?
The lender may use different rounding, payment dates, fees, an adjusted financed amount, or terms not represented here. Compare the inputs and check the lender’s payment schedule and disclosure.

Does this calculator include extra payments?
No. It assumes the scheduled level payment only. Additional payments can change the balance and repayment timeline, so their effect is not included in these outputs.

Related

• EMI Calculator: How the Monthly Instalment of a Loan Is Calculated
• Loan Calculator With Down Payment: Payment on What You Borrow
• Loan Payment Calculator: Monthly Payment, Total Interest and Cost

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