Create a payment schedule by entering a loan amount, annual interest rate, and term. This calculator estimates the fixed monthly payment and total interest for a standard fully amortizing loan, assuming monthly payments and a fixed rate.
Formula
The payment is calculated with the standard fixed-payment amortization formula. The interest rate entered as an annual percentage is divided by 1,200 to convert it to a monthly decimal rate, and the loan term in years is multiplied by 12 to find the number of payments.
- Monthly payment: M = round[P × r ÷ (1 − (1 + r)−n), 2]
- Total interest: I = M × n − P
- Monthly rate: r = APR ÷ 1,200
- Number of payments: n = years × 12
Here, P is the loan principal in dollars, APR is the annual percentage rate, r is the monthly rate as a decimal, n is the number of monthly payments, M is the monthly payment in dollars rounded to cents, and I is total interest in dollars. The total-interest result uses the rounded payment, so it reflects the schedule implied by paying that amount each month.
Worked Example
Using the calculator defaults: a $20,000 loan, an 8% APR, and a five-year term.
- Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
- Convert the term to payments: 5 × 12 = 60 monthly payments.
- Substitute in the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 after rounding to cents.
- Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.
The estimated monthly payment is $405.53, and estimated total interest is $4,331.80. A real lender may handle the final installment or rounding differently.
Assumptions
- The interest rate stays fixed throughout the modeled term.
- Payments are equal, monthly, and made at the end of each payment period.
- Interest compounds monthly using APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, escrow, and any charges not entered in the calculator.
How to Read a Payment Schedule
A payment schedule, often called an amortization schedule, shows how each installment is divided between interest and principal, along with the remaining balance. This calculator gives the regular payment and total interest, rather than listing every month. For an amortizing loan, interest is calculated on the outstanding balance. Early payments therefore generally devote a larger share to interest; as principal falls, the interest portion usually shrinks and more of each fixed payment goes toward principal.
For the example, the first month’s estimated 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 the lower balance, subject to the lender’s precise rounding and payment-date conventions. The balance declines over time and is intended to reach zero after the scheduled payments.
The total interest is not the total amount repaid. To estimate total scheduled payments, multiply the monthly payment by the number of months; then separate the original principal from the excess. In the example, scheduled payments total $24,331.80, of which $20,000 is principal and $4,331.80 is estimated interest.
When to Use This Calculator
Use the estimate to understand how payment size and term interact, or to check arithmetic against a payment amount supplied in loan documents. Enter the principal actually financed, not necessarily the item’s sticker price. If an amount is added to the loan balance, include it in the principal; if it is paid separately, it is not part of this calculation.
To compare hypothetical scenarios, change one input at a time. A longer term usually produces a lower scheduled payment but more payments over time, which can increase total interest under the same rate and principal. A higher APR increases the calculated payment and interest, holding the other inputs constant. These are mathematical effects, not a recommendation about borrowing. Use the figures and terms provided by the lender for a specific loan.
Limits and Common Mistakes
- Entering the wrong rate format: Enter 8 for 8% APR, not 0.08. The formula performs the percentage conversion.
- Confusing APR with the periodic rate: The input is an annual percentage. The formula divides it by 12 months and by 100 to get a monthly decimal rate.
- Using the wrong principal: A down payment reduces the amount financed; financed charges increase it. Include only amounts that are part of the loan balance you want to model.
- Expecting every month to be identical in practice: Variable rates, irregular payment dates, daily interest calculations, payment holidays, and changing balances can create different results.
- Rounding intermediate values: The calculator rounds the monthly payment to cents, then uses that rounded payment to compute total interest. Displayed totals can differ from calculations that retain unrounded values.
This formula describes a level-payment loan that is fully repaid over the specified term. It does not produce a complete month-by-month table, model extra payments, or calculate a balloon balance or interest-only period. For a variable-rate loan or a contract with unusual payment rules, a simple fixed-rate estimate may not represent the actual schedule.
Frequently Asked Questions
What information do I need to create a payment schedule?
For this estimate, enter the loan amount, annual APR, and term in years. A detailed lender schedule may also depend on payment dates, fees, rate changes, and the lender’s interest and rounding methods.
Does the monthly payment include taxes and insurance?
No. The calculated payment covers estimated principal and interest only. Taxes, insurance, PMI, escrow contributions, and other charges are excluded unless separately included in the loan amount or modeled with additional inputs.
Why does a longer loan term change total interest?
A longer term means more monthly payments. Even if each payment is smaller, interest accrues over more periods, so total interest can be higher when principal and APR stay the same.
Can I use this for a variable-rate loan?
Only as a fixed-rate illustration. The calculation holds APR constant for the full term; it does not forecast future rate changes or recalculate payments when a variable rate resets.
Why might my lender’s payment differ?
The lender may use a different starting balance, rate, term, payment date, compounding convention, fee treatment, or rounding procedure. Check the lender’s loan disclosure for the figures and assumptions used for the actual 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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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