A free payment schedule calculator shows how each loan payment is divided between principal and interest, and how the balance changes over time. Enter the loan amount, APR, and term to estimate the monthly payment and total interest; this basic calculator does not produce a month-by-month table.
Formula
This calculator uses the standard fixed-rate, fully amortizing loan payment formula. It assumes equal monthly payments and a constant APR converted to a monthly rate:
Monthly payment = P × r ÷ [1 − (1 + r)−n]
- P is the starting loan principal in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200 when APR is entered as a percentage per year.
- n is the number of monthly payments, calculated as loan term in years × 12.
Total interest is estimated as (monthly payment × n) − P. The monthly payment is rounded to the nearest cent before total interest is calculated, so the displayed total uses the displayed payment. A lender’s final payment may differ slightly because of rounding and its payment schedule.
Worked Example
Using the calculator’s defaults: a $20,000 loan, 8% APR, and a five-year term.
- Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667.
- Find the number of payments: 5 × 12 = 60 months.
- Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53 per month.
- Calculate estimated total interest using the rounded payment: ($405.53 × 60) − $20,000 = $4,331.80.
For these inputs, the estimated monthly payment is $405.53 and estimated total interest is $4,331.80.
Assumptions
- The interest rate is fixed for the full term.
- Payments are equal, made monthly, and occur at the end of each payment period.
- Interest is compounded monthly using APR ÷ 12.
- Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.
What a Payment Schedule Shows
A full amortization schedule lays out one row for every payment. Each row typically lists the payment date or number, total payment, interest charged for that period, principal repaid, and remaining balance. Early in a standard amortizing loan, the balance is larger, so more of a level payment generally goes to interest. As the balance falls, the interest portion usually shrinks and more of the payment reduces principal.
For example, with a monthly rate of 0.0066667 and a starting balance of $20,000, the first month’s interest is about $133.33 ($20,000 × 0.0066667). If the payment is $405.53, about $272.20 goes toward principal, leaving an estimated balance of $19,727.80. The exact allocation can vary with the lender’s calculation method, dates, and rounding.
This page calculates the level payment and the total interest implied by the inputs. It does not display all 60 individual rows in the example, so use a lender’s statement or a dedicated amortization table when you need a dated payment-by-payment record.
How to Use the Estimate
Enter the principal you expect to borrow, the APR quoted for the loan, and the term in years. The displayed payment is a mathematical estimate for the entered figures, not an approval result or a personalized borrowing recommendation. For a quote-specific calculation, use the exact principal, rate, and repayment term shown in the lender’s documents.
To understand the result, distinguish the recurring payment from the overall cost:
- Monthly payment is the calculated principal-and-interest amount for each regular monthly period.
- Total interest is the estimated interest across the full term, based on the rounded monthly payment.
- Total of payments can be estimated as monthly payment × number of months; it includes principal and interest but not excluded charges.
A longer term usually means more payment periods, which can increase total interest under the same fixed rate and principal even if the monthly payment is lower. This is a result of the arithmetic, not a statement about whether a particular loan term is suitable.
Choosing Inputs and Understanding Limits
APR and interest rate are related but are not always interchangeable in actual loan documents. APR can reflect certain borrowing costs in addition to the stated interest rate, depending on how the product and disclosure are defined. This calculator uses the entered APR directly as the annual rate for the monthly payment formula; it does not separately model fees or convert a fee-inclusive APR into a detailed cash-flow schedule. Check the lender’s disclosed payment and total repayment figures for the exact treatment.
Common input and interpretation mistakes include:
- Entering 8 when the rate is 8% is correct; entering 0.08 would mean 0.08% in this calculator.
- Entering the loan term in years is required. A five-year term means 60 monthly payments, not five.
- Using the original purchase price instead of the actual amount financed can overstate the modeled principal.
- Assuming the result includes insurance, taxes, escrow, or fees will understate the total amount due if those costs apply.
- Rounding an APR or payment manually can create small differences from a lender’s figures.
The formula is for a fixed-rate loan with level monthly payments that fully repay principal and interest over the entered term. It is not a schedule for variable rates, interest-only periods, balloon payments, irregular payment dates, daily simple-interest calculations, or loans with skipped or extra payments. If your agreement has any of those features, its payment schedule may differ materially.
Frequently Asked Questions
Is this payment schedule calculator free?
Yes. The calculator is free to use. It estimates the monthly payment and total interest from the principal, APR, and term you enter.
Does it show every payment in the schedule?
No. It returns the estimated monthly payment and total interest, rather than a row-by-row amortization table. A lender’s account documents or a full schedule tool can show individual payment allocations.
Why does the interest portion change if the payment stays the same?
With a fixed rate, interest for a period is based on the remaining balance. As principal is repaid, the balance falls, so less interest accrues and more of the level payment can reduce principal.
Does the estimate include fees or insurance?
No. Fees, taxes, insurance, PMI, and escrow are not inputs in this calculation. Review the lender’s disclosure for any amounts that apply to the loan.
Why might my lender’s payment be different?
The lender may use different rounding, payment dates, rate conventions, financed charges, or loan terms. The calculator also assumes a fixed rate and ordinary monthly payments, so compare its assumptions with the loan documents.
This result is an estimate, 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
- Avalanche Game Schedule: Dates, Times and Where to Check
- Avalanche Hockey Schedule: Games, Dates and TV
- Avalanche Debt Payoff Tracker Calculator
- Avalanche Debt Repayment Calculator and Payoff Plan
- Avalanche Debt Payoff Calculator and Spreadsheet
- Avalanche Debt Payoff Calculator: Free Estimate