A payment schedule calculator shows the regular payment on a fixed-rate, fully amortizing loan and estimates total interest over the stated term. Enter the loan amount, APR, and term to see the monthly payment and total interest; the calculation assumes equal monthly payments and does not include fees or other loan costs.
Formula
The calculator uses the standard fixed-payment amortization formula. It first calculates the monthly payment, then subtracts the original loan principal from all scheduled payments to estimate total interest:
Monthly payment = P × r ÷ [1 − (1 + r)−n]
Total interest = payment × n − P
- P is the starting loan principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 12 ÷ 100.
- n is the number of monthly payments: loan term in years × 12.
- payment is the calculated monthly amount, in dollars.
For example, an 8% APR corresponds to a monthly rate of 0.08 ÷ 12, or about 0.0066667. The formula accounts for interest accruing on the remaining balance as it is repaid. It is not simply the principal divided by the number of months, because each scheduled payment also covers interest.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term:
- Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
- Find the number of payments: 5 × 12 = 60.
- Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] ≈ $405.53 per month.
- Estimate total interest using the displayed monthly payment: $405.53 × 60 − $20,000 = $4,331.80.
The payment is rounded to cents for display, and the total-interest result uses that rounded payment. A lender’s payment schedule can differ slightly because of its exact rounding and interest-accrual methods.
Assumptions
- The interest rate remains fixed for the entire term.
- Payments are equal monthly installments, made at the end of each monthly period.
- Interest compounds monthly at APR divided by 12.
- The calculation excludes fees, taxes, insurance, PMI, escrow, and any optional or extra payments.
What a Payment Schedule Shows
A full amortization schedule expands these totals into a month-by-month record. Each row generally shows the payment, the amount applied to interest, the amount applied to principal, and the balance remaining after payment. Early in a fully amortizing loan, the balance is larger, so more of the payment goes toward interest. As the principal falls, the interest portion usually shrinks and more of each level payment reduces principal.
This calculator provides the regular payment and overall interest estimate, not the individual rows of that schedule. As a simple illustration, the first month’s interest on the example balance is approximately $20,000 × 0.0066667 = $133.33. The rest of the $405.53 payment—about $272.20—reduces principal, subject to rounding. In later months, interest is calculated on the lower outstanding balance.
When to Use It and How to Read the Results
Use the estimate to understand how loan size, APR, or term affects the scheduled payment under a consistent fixed-rate model. Change one input at a time to see its mathematical effect. Holding the other inputs constant, a larger principal raises the payment; a higher APR raises both payment and interest; and a longer term generally lowers the monthly payment while increasing the number of months over which interest is charged.
The monthly payment is not necessarily the entire amount due on a bill. A housing payment, for example, may also include items such as taxes, insurance, or escrow. The total-interest figure is an estimate for the principal-and-interest loan model, not a statement of every cost of borrowing. Enter the APR and term that apply to the specific loan offer, and obtain the lender’s actual figures directly from its disclosures.
Common Limitations and Mistakes
- Entering the wrong rate format: Enter APR as a percentage, such as 8 for 8%, not as 0.08. The formula converts the percentage to a monthly decimal.
- Confusing years and months: The term field is in years. A five-year term means 60 monthly payments, not five.
- Treating APR as every borrowing cost: APR may reflect costs differently from the simple interest rate used in a particular payment calculation. This calculator uses the entered APR directly as its annual rate and does not separately model fees.
- Expecting exact lender figures: Actual payment timing, daily interest calculations, rounding, fees, variable rates, or a first payment date that differs from a regular monthly cycle can change a schedule.
- Using it for a non-level payment plan: Interest-only periods, balloon payments, changing rates, irregular installments, and extra payments need a schedule designed for those terms.
Because the APR input must be at least 0.01%, the formula avoids division by a zero monthly rate. The model also assumes the rate and payment pattern stay unchanged; it does not forecast rate changes or account for missed payments.
Frequently Asked Questions
What is a payment schedule?
A payment schedule sets out when payments are due and how much is due. A loan amortization schedule also shows how each payment is divided between interest and principal and what balance remains.
How do I calculate a monthly loan payment?
Convert APR to a monthly decimal by dividing by 1,200, convert the term to months, and use the fixed-payment formula shown above. The calculator performs these steps for the entered values.
Does a longer loan term lower total interest?
Not generally when comparing the same principal and APR in this fixed-payment model. A longer term spreads repayment over more installments and usually lowers the monthly payment, but the borrower pays interest over more months, so modeled total interest usually rises.
Does this calculator include fees or insurance?
No. It estimates principal-and-interest payments from the entered principal, APR, and term. Fees, taxes, insurance, PMI, and escrow are not inputs and are not included.
Why might my lender’s payment differ?
The lender may use different rounding, payment dates, interest accrual, fees, or loan terms. Compare the calculator’s assumptions with the loan disclosure and use the lender’s stated schedule for the exact contractual figures.
This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.
Related
Formula used
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
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- June Balance Date: What It Means for Loan Balances$405.53
- L&T Finance Gold Loan: How It Works and What to Check
- Journal Entry to Correct a Beginning Balance
- JS Bank Gold Loan: Eligibility, Process and Costs
- Journal Entry for a Bank Loan: Debit and Credit$20,000.00
- Journal Entry to Adjust Beginning Balance