This payment schedule calculator estimates a fixed monthly loan payment and total interest from the loan amount, APR, and term. Enter those three figures to see the payment and the interest charged across the full schedule, assuming every payment is made on time.
Formula
The calculator uses the standard amortizing-loan payment formula. It assumes the loan balance accrues interest monthly and is repaid through equal monthly payments:
Monthly payment = P × r / [1 − (1 + r)−n]
- P is the amount borrowed, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1200. For an 8% APR, r = 8 ÷ 1200, or about 0.006667 per month.
- n is the number of monthly payments: loan term in years × 12.
Total interest is calculated as the rounded monthly payment multiplied by the number of payments, minus the original principal: Total interest = monthly payment × n − P. The payment is rounded to cents before that total is calculated. Consequently, the estimate reflects the same rounded payment repeated each month; a lender’s final payment may be adjusted slightly to clear a remaining balance.
Worked Example
Using the calculator’s default inputs: P = $20,000, APR = 8%, and term = 5 years.
- Convert the APR to a monthly decimal rate: r = 8 ÷ 1200 = 0.0066667.
- Find the number of payments: n = 5 × 12 = 60.
- Substitute into the formula: payment = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
- The monthly payment, rounded to cents, is $405.53.
- Total of scheduled payments = $405.53 × 60 = $24,331.80. Estimated total interest = $24,331.80 − $20,000 = $4,331.80.
Assumptions
- The APR and payment amount remain fixed for the entire term.
- Payments are equal, made monthly, and treated as paid at the end of each monthly period.
- Interest compounds monthly at APR ÷ 12, represented as APR ÷ 1200 when APR is entered as a percentage.
- The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, and optional extra payments.
How to Read a Payment Schedule
A payment schedule, often called an amortization schedule, shows how each payment is split between interest and principal. Early in a typical fixed-rate loan, the outstanding balance is larger, so more of the payment goes toward interest. As principal is repaid, the balance falls and the interest portion generally shrinks; more of each later payment then reduces principal.
This calculator gives the regular payment and total interest, not a month-by-month table. To understand the pattern, consider the first month of the example: estimated interest is $20,000 × 0.0066667, or about $133.33. Subtracting that from the $405.53 payment leaves roughly $272.20 to reduce principal. The next month’s interest is calculated on the smaller balance, subject to rounding and the lender’s payment processing.
APR is an annualized rate expressed as a percentage, while the formula needs a monthly rate. Do not enter 8 as the monthly rate or divide 8 by 12 without converting the percentage to a decimal: the calculator’s APR ÷ 1200 conversion performs both steps. APR may also reflect certain borrowing costs depending on the loan and its disclosures; this calculator does not separately itemize any fees or model their effect.
When This Estimate Helps
Use the estimate to see how the principal, APR, and repayment period mathematically affect a level monthly payment. Holding two inputs constant while changing the third can illustrate the trade-off: a longer term generally spreads repayment over more months and increases the total interest in this fixed-rate model, while a higher APR increases the calculated payment and interest when the other inputs are unchanged.
For a real loan, use the amount, APR, and term shown in the lender’s current disclosure or offer. If the APR includes costs that are paid separately, financed fees, variable rates, irregular payment dates, or a different compounding method, the calculator may not reproduce the lender’s figures. Confirm which amount is being financed and whether the quoted payment includes any other charges.
Common Mistakes and Limits
- Confusing APR with a monthly percentage: enter the annual APR as a percentage, such as 8 for 8%, not 0.6667.
- Using the wrong term: the input is in years. A five-year term means 60 monthly payments, not five.
- Assuming the payment includes everything: the result covers principal and modeled interest only. Taxes, insurance, fees, and other charges may change the amount actually due.
- Expecting an exact payoff statement: daily interest accrual, payment dates, rounding, rate changes, extra payments, and a final-payment adjustment can make an actual schedule differ.
The formula is for a fully amortizing loan with a positive APR and equal monthly payments. It does not model interest-only periods, balloon payments, skipped or late payments, variable APR changes, or additional principal payments. For those details, a lender’s itemized payment schedule is needed.
Frequently Asked Questions
What does APR mean in a payment calculation?
APR is the annual percentage rate used here as the annual input. The formula converts it to a monthly decimal rate by dividing the percentage value by 1200.
Is APR the same as the interest rate?
Not necessarily. APR is an annualized disclosure measure and may account for certain borrowing costs, while a stated interest rate describes the rate used to accrue interest. What is included depends on the loan disclosure; this calculator treats the entered APR as the rate for monthly interest calculations.
Why does a longer term usually increase total interest?
In this fixed-rate model, a longer term means more monthly periods during which interest accrues. The payment may be lower because repayment is spread out, but multiplying that payment by more months can produce a higher total interest amount.
Does this calculator include taxes, insurance, or fees?
No. It estimates a level principal-and-interest payment and interest total. Entering a loan amount that already includes financed costs may affect the arithmetic, but separate charges are not calculated.
Why might my lender’s payment differ?
The lender may use a different financed balance, include charges, apply a variable rate, use different payment dates or rounding, or adjust the final payment. Check the lender’s disclosure for the exact terms and schedule.
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
- Closing Costs on a House Loan: What to Expect$405.53
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term