A payment schedule calculator shows how a fixed-rate loan’s balance changes after each monthly payment, separating principal from interest. Enter the loan amount, annual percentage rate (APR), and term to estimate the monthly payment and total interest; the schedule follows from those figures.
Formula
The calculator uses the standard fixed-payment amortization formula. It calculates a level monthly payment that repays principal and interest over the selected number of months, assuming the rate remains unchanged:
Payment = round[P × r ÷ (1 − (1 + r)−n), 2]
- P is the starting loan principal in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200.
- n is the number of monthly payments: loan term in years × 12.
- Payment is the monthly amount, rounded to cents.
Total interest is estimated as monthly payment × number of payments − principal. The schedule’s usual month-by-month calculation applies interest to the balance before payment: monthly interest = opening balance × r; principal paid = payment − monthly interest; closing balance = opening balance − principal paid. In later months, the opening balance is smaller, so the interest portion generally falls while the principal portion rises.
Worked Example
Using the calculator’s default values—$20,000 principal, 8% APR, and a five-year term:
- Convert the annual rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667.
- Count the payments: n = 5 × 12 = 60.
- Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 after rounding to cents.
- Calculate estimated total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.
The first month’s estimated interest is $20,000 × 0.0066667, or about $133.33. The remaining $272.20 of the $405.53 payment reduces principal, leaving an estimated balance of $19,727.80. Actual lender calculations can differ slightly because of payment dates, rounding, or the contract’s rate and interest method.
Assumptions
- The rate is fixed for the whole term.
- Payments are equal, made monthly, and treated as occurring at the end of each monthly period.
- Interest compounds monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.
What a Payment Schedule Shows
A full payment schedule, often called an amortization schedule, lists each payment period and its effect on the loan. A typical table includes the payment number or date, payment amount, interest charged, principal repaid, and balance remaining. The calculator above supplies the recurring payment and total-interest estimate; those figures can be used to understand or build the period-by-period breakdown.
For the example, the first payment contains about $133.33 in interest. As principal is repaid, later interest charges are calculated on a lower balance. The final payment may differ by a few cents if the lender adjusts for rounding so the balance reaches zero. A schedule is a projection based on stated assumptions, not a record of transactions already made.
When to Use It and How to Read It
Use a payment schedule to see the estimated cost over time, understand why early payments may contain a larger interest share, or compare hypothetical combinations of principal, APR, and term. For a useful comparison, change one input at a time and keep the other assumptions constant. Use the rate and loan terms supplied in a lender’s written estimate or disclosure rather than treating the default 8% as a current market rate.
- Monthly payment: the calculated level payment for principal and interest.
- Total interest: the estimated interest across all scheduled payments, based on the payment rounded to cents.
- Remaining balance: the principal still unpaid after a given payment; it excludes any charges not represented in the formula.
A longer term generally spreads repayment across more months, which changes both the payment and accumulated interest under the same fixed-rate assumptions. The calculator does not determine whether a payment fits a person’s budget or whether a lender will approve an application.
Common Problems and Limits
One frequent mistake is entering an APR as a decimal rather than as a percentage. Enter 8 for 8%, not 0.08; the calculator itself converts the percentage to a monthly rate. Another is confusing the loan term in years with the number of payments: a five-year monthly schedule has 60 payments, not five.
The formula assumes a fixed rate and regular monthly periods. It is not a suitable exact schedule for a variable-rate loan, irregular payment dates, interest-only periods, deferred payments, balloon payments, or a loan with fees added to its balance unless those features are separately modelled. Extra principal payments can shorten repayment and reduce interest, but this calculator does not include them. A lender’s schedule may also reflect daily interest accrual, payment processing dates, or rounding conventions that produce small differences.
Total interest here is derived from the rounded monthly payment multiplied by the number of payments. It is an estimate of scheduled interest under the formula, not a complete measure of every possible borrowing cost. Check the loan documents for the amount financed, payment dates, rate terms, and any charges relevant to the actual schedule.
Frequently Asked Questions
What is a payment schedule?
A payment schedule lays out when payments are due and, for an amortizing loan, how each payment is divided between interest and principal, along with the remaining balance.
Is a payment schedule the same as an amortization schedule?
For a standard loan repaid through regular payments of principal and interest, the terms are commonly used for the same kind of breakdown. A basic payment calendar may show due dates and amounts without separating principal and interest.
Why does the interest portion change each month?
With a fixed rate, interest is calculated against the outstanding balance. As scheduled payments reduce that balance, the interest charged generally falls and more of each equal payment goes toward principal.
Does this calculator include fees or insurance?
No. It estimates principal-and-interest payments only. Fees, taxes, insurance, escrow, PMI, and other costs need separate information and are not included in these results.
Why might my lender’s payment schedule differ?
Differences can come from the contract’s exact rate, payment timing, interest accrual method, rounding, fees, or other loan features. Compare the calculator’s assumptions with the lender’s disclosure and payment 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