This payment schedule calculator estimates a fixed-rate loan’s monthly payment and total interest from the loan amount, APR, and term. It returns the scheduled payment and interest total; a full lender statement may differ if its fees, payment dates, or other terms differ.
Formula
The calculator uses the standard fixed-payment amortization formula. It first calculates the payment that would repay the principal and interest in equal monthly installments:
Monthly payment = P × r ÷ [1 − (1 + r)−n]
- P is the amount borrowed, in dollars.
- APR is the annual percentage rate entered as a percentage, such as 8 for 8% per year.
- r is the monthly rate, calculated as APR ÷ 1,200. At an 8% APR, r is 0.0066667 per month.
- n is the number of monthly payments, calculated as years × 12.
The monthly payment is rounded to the nearest cent. The estimated total interest is then (rounded monthly payment × n) − P. Because the total uses the rounded payment, it may differ slightly from an idealized calculation using unrounded values. A real final payment may also be adjusted to settle the remaining balance exactly.
Worked Example
Using the calculator’s default inputs—$20,000 borrowed, 8% APR, and a 5-year term—the monthly rate is 8 ÷ 1,200 = 0.0066667, and the number of payments is 5 × 12 = 60.
Substitute those values into the payment formula:
$20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 per month
The estimated total of the 60 rounded payments is $405.53 × 60 = $24,331.80. Subtracting the $20,000 principal gives $4,331.80 in estimated total interest. The calculator’s outputs are therefore $405.53 per month and $4,331.80 total interest.
How to Read a Loan Payment Schedule
A payment schedule, often called an amortization schedule, shows how each installment is allocated between interest and principal and what balance remains afterward. This calculator gives the recurring payment and estimated interest over the whole term, not a dated, row-by-row schedule. To create or check a full schedule, you need the payment dates and the lender’s balance and interest conventions as well as the basic loan figures.
For a standard monthly schedule, interest for a period is calculated on the outstanding balance. Early in repayment, that balance is larger, so more of a level payment generally goes to interest. As the principal falls, the interest portion falls and the principal portion rises. For example, at the default monthly rate, the first month’s estimated interest is $20,000 × 0.0066667, or about $133.33. The remainder of the $405.53 payment—about $272.20—reduces principal. Later rows will have different splits because the balance changes.
When This Estimate Is Useful
Use the calculation to understand the basic payment arithmetic for a fixed-rate loan or to compare scenarios by changing one input at a time. You can see how a larger principal, a different entered APR, or a longer term changes the scheduled monthly amount and the total interest implied by that payment. These are mathematical comparisons, not predictions of a lender’s offer or an assessment of whether a loan is suitable.
- Enter the amount borrowed, not the amount you hope to borrow after unspecified costs.
- Enter APR as a percent: type 8 for 8%, not 0.08 or 8.00% expressed as a decimal.
- Enter the term in years. The calculator converts it to months; 5 years means 60 monthly payments.
- Use figures supplied in the loan disclosure or by the lender for an actual estimate. Do not treat the defaults as a quoted rate or offer.
What the Schedule Does Not Include
The formula assumes a constant rate and equal monthly payments. It does not add origination or other fees, taxes, insurance, mortgage insurance, escrow, late charges, or optional products. It also does not model changing rates, skipped or irregular payments, daily-interest methods, payment holidays, or extra principal payments. If a lender finances fees into the loan, the amount financed may be higher than the amount you initially expected to borrow.
APR can include certain borrowing costs in the rate disclosure, but this calculator does not separately identify or reconstruct those costs. Entering an APR into a simple monthly amortization formula is a useful estimate, not a complete reproduction of every disclosure method. For an adjustable-rate loan, one fixed APR cannot describe future payment changes.
Common Payment-Schedule Questions
- Is a payment schedule the same as an amortization schedule?
A loan payment schedule commonly refers to the same idea: a dated list of installments and how each affects interest and principal. This calculator estimates the payment and total interest, but does not produce dated rows. - Why does the interest portion change if the payment stays the same?
With a fixed rate and a declining balance, each period’s interest charge generally gets smaller. The principal portion then grows so the scheduled payment remains level. - Does total interest include fees or insurance?
No. It is the estimated interest implied by the entered principal, APR, term, and rounded monthly payment. Fees, insurance, taxes, and escrow are not separate inputs and are not included. - Why might my lender’s payment or total differ?
The actual loan may have different financed costs, payment timing, rate treatment, rounding, or a final-payment adjustment. Check the lender’s disclosure and payment schedule for the terms that apply to that loan. - Can I use this for an adjustable-rate loan?
Only as a simplified estimate for a period represented by one fixed rate. It cannot forecast later adjustments or the payments that may result from them.
Assumptions
- The interest rate stays fixed for the entire term.
- Payments are equal, made monthly, and occur at the end of each monthly period.
- Interest compounds monthly using APR divided by 12.
- Fees, taxes, insurance, PMI, and escrow are not included unless reflected in an entered amount, and this calculator has no separate inputs for them.
This result is an estimate; 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