A payment schedule sheet 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, annual percentage rate (APR), and term.
Formula
This calculator uses the standard fixed-rate, fully amortizing loan payment formula:
M = P × r ÷ [1 − (1 + r)−n]
- M is the monthly payment in dollars.
- P is the original loan principal in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200. The APR is entered as a percentage per year.
- n is the number of monthly payments, calculated as the loan term in years × 12.
Total interest is estimated as M × n − P. The displayed monthly payment is rounded to cents; total interest uses that rounded payment multiplied by the number of scheduled payments, less principal. This makes the total consistent with the payment shown, though a real lender may adjust the final payment for rounding.
Worked Example
Using the defaults—$20,000 principal, 8% APR, and a five-year term:
- Convert APR to a monthly rate:
8 ÷ 1,200 = 0.0066667. - Find the number of payments:
5 × 12 = 60. - Substitute into the payment formula:
20,000 × 0.0066667 ÷ [1 − (1.0066667)−60]. - The monthly payment is $405.53 after rounding to cents.
- Total of scheduled payments:
$405.53 × 60 = $24,331.80. - Estimated total interest:
$24,331.80 − $20,000 = $4,331.80.
Assumptions
- The interest rate stays fixed for the entire term.
- Payments are equal, made monthly, and arrive at the end of each monthly period.
- Interest compounds monthly using APR divided by 12.
- The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, and any optional extra payments.
What a Payment Schedule Sheet Shows
A payment schedule sheet, often called an amortization schedule, lays out a loan’s payment dates and the way its balance changes over time. A full schedule commonly includes the payment number or due date, opening balance, payment amount, interest portion, principal portion, and closing balance. Some sheets also show cumulative interest and principal paid.
For a standard fixed-rate loan with equal monthly payments, interest is generally calculated on the outstanding balance. Early in the schedule, that balance is larger, so more of a payment goes toward interest. As principal is repaid, the balance falls and the interest portion typically shrinks. The payment itself can remain level while its components change.
This page estimates the payment and total interest; it does not print a row-by-row schedule. To build one, start with the opening balance, calculate that period’s interest, subtract interest from the payment to find principal repaid, then subtract principal from the opening balance. Repeat for each payment period. The last row may need adjustment to bring the balance to zero.
How to Use the Estimate
- Enter the principal amount being borrowed, not the total price of an item unless the entire price is financed.
- Enter the APR as a percentage per year. For example, enter 8 for 8%, not 0.08.
- Enter the term in years. The calculator converts it to monthly payments.
- Read the monthly payment and estimated interest as results for the stated assumptions, not as a lender’s offer or payoff quote.
For a practical comparison, use the same principal and term when testing different APR inputs, or the same rate and principal when comparing terms. A longer term usually means more scheduled payments, and can therefore increase total interest even if the monthly payment is lower. This arithmetic does not establish which borrowing arrangement is appropriate for an individual.
Common Problems and Limits
A payment estimate may differ from a payment schedule provided by a lender because the loan may have fees added to the balance, a variable rate, irregular payment dates, a different compounding convention, or a first payment date that does not follow a regular monthly interval. The lender’s schedule may also account for rounding differently, especially in the final payment.
A common misconception is that APR alone always determines every cash amount due. This calculator applies the entered APR to the principal as a fixed monthly rate and excludes separate costs and charges. If a fee is financed, the amount subject to interest may be higher than the amount originally borrowed. If payments are not level or the rate changes, this formula does not reproduce the complete schedule.
For an actual schedule, check the loan documents for the amount financed, rate type, payment dates, and listed payment amount. Use the lender’s figures for contractual obligations; this calculator is for estimating the standard mathematical case.
Frequently Asked Questions
What is a payment schedule sheet?
A payment schedule sheet is a list of scheduled loan payments, usually showing each payment’s date, amount, interest, principal, and remaining balance.
Is a payment schedule the same as an amortization schedule?
For a standard installment loan, the terms are often used for a table that tracks payments and the changing loan balance. A schedule may contain additional due-date or fee details.
How do I make a payment schedule sheet?
For each period, calculate interest on the opening balance, subtract that interest from the payment to get principal repaid, and subtract principal repaid from the balance. Repeat for each payment, checking the final balance and rounding against the loan’s stated terms.
Why does the interest portion change when my payment stays the same?
Interest is calculated on the remaining principal. As that balance decreases, the interest portion generally falls, leaving more of a level payment to reduce principal.
Does this calculator include fees or taxes?
No. It estimates principal-and-interest payments under the stated fixed-rate assumptions and does not include fees, taxes, insurance, PMI, or escrow.
The 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