A payment schedule sample shows each planned loan payment, how much goes to interest and principal, and the balance remaining afterward. Use this calculator to estimate the monthly payment and total interest for a fixed-rate loan; enter the loan amount, annual percentage rate (APR), and term.
Formula
For a fixed-rate loan with equal monthly payments, the payment is calculated using the standard amortization formula:
Payment = P × r ÷ [1 − (1 + r)−n]
- P is the original loan principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 12 ÷ 100.
- n is the number of monthly payments: years × 12.
The calculator rounds the monthly payment to cents for display. Estimated total interest is the rounded payment multiplied by the number of payments, minus the original principal. Because the formula assumes a level payment and fixed rate, it describes a conventional amortization schedule rather than every possible loan arrangement.
Worked Example
Using the calculator’s default values—$20,000 principal, 8% APR, and a five-year term:
- Convert the APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
- Find the number of monthly payments: 5 × 12 = 60.
- Apply the formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
- The monthly payment is approximately $405.53, rounded to the nearest cent.
- Using that rounded payment, total payments are $405.53 × 60 = $24,331.80. Estimated total interest is $24,331.80 − $20,000 = $4,331.80.
Assumptions
- The interest rate stays fixed for the entire term.
- Payments are equal, made monthly, and paid at the end of each monthly period.
- Interest compounds monthly at APR divided by 12.
- Fees, taxes, insurance, PMI, escrow, and other charges are not included.
What a Payment Schedule Shows
A full payment schedule, often called an amortization schedule, lays out the loan month by month. Each row normally includes the payment number or date, payment amount, interest charged, principal repaid, and remaining balance. The calculator above provides the payment and total-interest estimates, not a dated table; a lender’s schedule may include details such as payment dates, fees, or rounding conventions.
In the first months of a typical amortizing loan, the balance is relatively high, so more of each payment goes toward interest. As principal is paid down, the interest portion generally declines and the principal portion grows. The scheduled payment remains level when the rate and payment terms are fixed. This changing split explains why paying the monthly amount does not reduce the balance by that entire amount.
For a simple illustration, if a balance is $20,000 and the monthly rate is 0.0066667, the first month’s interest is about $133.33. With the example payment of $405.53, about $272.20 goes toward principal, leaving an estimated $19,727.80 balance. Later rows use the new balance to calculate interest. Actual statements can differ because of payment dates, daily-interest methods, fees, or rounding.
How to Read and Use the Estimate
Enter the principal you expect to borrow, not an amount that includes costs unless those costs are actually financed into the loan. Use the APR as a percentage per year: enter 8 for 8%, not 0.08 or 8.0 as a decimal fraction. Enter the term in years. For example, a 30-month term is 2.5 years.
The monthly payment is the amount implied by the inputs under the stated assumptions. Total interest is the estimated interest across all scheduled payments; it is not the total cost of borrowing if fees or other charges apply. To make a schedule independently, calculate each month’s interest from the opening balance, subtract that interest from the payment to find principal repaid, and subtract principal repaid from the opening balance.
- Check whether the stated APR and loan term match the figures supplied by the lender.
- Keep dollars, percentages, and years in the correct fields; avoid mixing monthly and annual rates.
- Compare the estimate with the lender’s payment disclosure, which may use different timing or rounding.
- Remember that a payment estimate is not an approval decision or a measure of affordability.
Limits and Common Differences
This sample models a fixed-rate loan repaid through equal monthly payments. It does not model variable rates, interest-only periods, balloon payments, skipped payments, late charges, irregular payment dates, or extra principal payments. Those features change the schedule and may require a different calculation.
A small difference between this estimate and a lender’s figure does not necessarily indicate an error. The lender may calculate interest using exact calendar days, include an amount in the financed principal, or round each period differently. The calculator rounds its displayed payment to cents, and its total-interest estimate uses that rounded payment. A schedule that rounds interest every month can therefore differ slightly from a calculation that carries extra decimal places throughout.
One common misconception is that the APR alone determines every amount a borrower pays. The APR is an important rate input, but this calculator does not include charges outside the principal and modeled interest. For the actual payment amount, payment dates, and itemized costs, use the lender’s disclosure and loan documents. This result is an estimate; the lender’s disclosure gives the exact figures.
Frequently Asked Questions
What is a payment schedule sample?
A payment schedule sample is an example showing planned payments over time, typically broken into interest, principal, and the remaining loan balance. It helps explain how an amortizing loan is repaid.
How do I make a monthly loan payment schedule?
Start with the opening balance. Calculate that period’s interest using the monthly rate, subtract interest from the payment to find principal repaid, then subtract the principal amount from the balance. Repeat for each month, allowing for the lender’s rounding method.
Does the monthly payment include fees and insurance?
Not in this calculator. It estimates principal and interest only. Fees, taxes, insurance, PMI, and escrow are excluded unless they are separately included in the loan amount or modeled with additional inputs.
Why does the interest portion change each month?
For a standard amortizing loan, interest is calculated on the remaining balance. As the balance declines, less interest accrues each period, so more of a level payment can go toward principal.
Can I use this sample for a variable-rate loan?
Not as a complete schedule. The calculation assumes a fixed APR throughout the term. A variable-rate loan may require recalculation when its rate changes, according to the loan’s terms.
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