A payment schedule document is a table showing when loan payments are due and how each payment is divided between principal and interest. Use this calculator to estimate the monthly payment and total interest from a loan amount, APR, and term; it does not create a lender-issued schedule with exact dates or fees.
Formula
The calculator uses the standard level-payment loan formula. It assumes equal monthly payments and a fixed annual percentage rate, converted to a monthly rate:
Monthly payment = round(P × r ÷ [1 − (1 + r)−n], 2)
Total interest = monthly payment × n − P
- P is the amount borrowed, in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200. For an 8% APR, r = 0.08 ÷ 12.
- n is the number of monthly payments, calculated as years × 12.
- APR is entered as a percentage per year, not as a decimal. The formula converts it to a monthly rate.
The monthly payment is rounded to the nearest cent before total interest is calculated. This makes the displayed total follow the displayed payment, though a lender’s actual final payment may be adjusted to clear a small remaining balance.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term:
- Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
- Convert the term to payments: 5 × 12 = 60 months.
- Apply the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = approximately $405.53 per month.
- Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.
The estimate is therefore a monthly payment of $405.53 and total interest of $4,331.80. A lender’s schedule can differ because of its payment dates, rounding rules, fees, or calculation method.
Assumptions
- The interest rate stays fixed throughout the stated term.
- Payments are made monthly, in equal installments, with the first payment one month after borrowing.
- Interest accrues monthly at APR divided by 12.
- The calculation excludes fees, taxes, insurance, PMI, escrow, and any separate charges unless they are included in the principal entered.
What a Payment Schedule Document Shows
A payment schedule—also called an amortization schedule—is the installment-by-installment breakdown of a loan. Common columns include the payment number or due date, payment amount, interest charged, principal repaid, and balance remaining after payment. Some documents also show fees or escrow separately, depending on the product and how the lender presents its statement.
For a typical fixed-rate, fully amortizing loan, the scheduled payment is level while its components change. Early payments generally allocate a larger portion to interest because interest is calculated on a larger outstanding balance. As principal is repaid, less interest accrues on the balance, so more of each later payment can reduce principal. The schedule reaches a zero balance after the required payments, subject to the lender’s rounding and servicing practices.
The document is useful for checking a projected payoff path, understanding how much principal remains at a particular point, and comparing the written payment breakdown with account statements. It is not the same thing as a list of payment due dates alone, nor does a calculator estimate replace the official schedule supplied for a specific account.
How to Read and Check a Schedule
Read across a row to see how one installment is applied; read down the balance column to follow the loan over time. For a basic schedule without extra charges, payment minus interest equals principal repaid, and the new balance equals the previous balance minus that principal amount.
- Confirm that the principal matches the amount financed, not necessarily the advertised purchase price.
- Check that the APR and term match the loan disclosure. An input rate is an assumption, not a statement of any current or typical rate.
- Look for whether the stated payment includes only principal and interest or also includes separately collected amounts.
- Compare the due dates and first-payment timing. A different first period can affect interest and the schedule.
- Check the final row: cent rounding can make the last payment slightly different from the regular installment.
A common misconception is that every payment reduces the principal by the same amount. In a standard amortizing loan, it generally does not: the interest portion changes as the balance falls, even when the total scheduled payment remains level.
Limits and Common Differences
This calculator estimates a conventional fixed-rate loan with equal monthly payments. It does not model a variable rate, interest-only period, balloon payment, skipped payment, irregular payment date, or extra principal payments. It also treats the APR as the rate used in the formula; a disclosed APR may reflect certain finance charges, while the note rate and payment calculation may be presented separately in the loan documents.
Actual schedules may differ because lenders can use different day-count conventions, payment posting dates, rounding methods, or treatment of fees. If payments are made early or late, or the rate changes, the remaining balance and interest can diverge from this estimate. For exact dates, amounts, and account-specific terms, use the schedule and disclosures issued by the lender. Rates, charges, and contractual details should be taken from those documents rather than inferred from this example.
Frequently Asked Questions
What is a payment schedule document?
A payment schedule document lists the planned installments for a loan and may break each one into principal, interest, and remaining balance. The lender’s version applies the terms and timing for that particular loan.
Is a payment schedule the same as an amortization schedule?
For an installment loan, the terms are often used for the same kind of table: a dated or numbered sequence of payments showing how the balance changes. A payment calendar without principal and interest detail may be less comprehensive.
Does this calculator generate an official loan schedule?
No. It estimates the level monthly payment and total interest from the three inputs. It does not create exact due dates or account for lender-specific fees, timing, or rounding.
Why does the interest portion change each month?
In a standard amortizing loan, interest is calculated on the outstanding balance. As principal is paid down, the balance used to calculate interest falls, changing the split between interest and principal.
Why might my lender’s payment differ from this result?
The actual loan may use different dates, fees, APR or note-rate treatment, payment timing, or rounding. Check the loan disclosure and lender-issued schedule for the applicable figures.
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