A repayment schedule format is a table showing each payment date or period, the amount due, how much goes to interest and principal, and the balance left afterward. This calculator estimates a fixed monthly payment and total interest from a loan amount, APR, and term; the schedule context below explains how to lay out and read the resulting figures.
Formula
For a fixed-rate loan with equal monthly payments, the payment is calculated using the standard amortization formula:
PMT = round[P × r ÷ (1 − (1 + r)−n), 2]
- PMT is the monthly payment in dollars.
- P is the starting loan principal in dollars.
- r is the monthly interest rate as a decimal, calculated here as APR ÷ 1,200.
- n is the number of monthly payments, calculated as years × 12.
Total interest is estimated as PMT × n − P. Since the monthly payment is rounded to cents before this total is calculated, the estimate reflects repeated payments of that rounded amount. A real loan’s 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 the APR to a monthly 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] = approximately $405.53 per month after rounding.
- Calculate estimated total interest: $405.53 × 60 − $20,000 = $4,331.80.
The outputs are an estimated monthly payment of $405.53 and estimated total interest of $4,331.80.
Assumptions
- The interest rate stays fixed for the full term.
- Payments are equal and made monthly, at the end of each payment period.
- Interest is modelled monthly at APR divided by 12.
- Fees, taxes, insurance, escrow, and any extra or missed payments are not included.
What a Repayment Schedule Shows
A repayment schedule—also called an amortization schedule—turns a loan’s payment formula into a period-by-period record. A useful schedule generally has one row for each payment and columns that identify the period, opening balance, scheduled payment, interest charge, principal repaid, and closing balance. Dates can be included when the actual payment calendar is known.
For a conventional fixed-rate, fully amortizing loan, the scheduled payment is usually level, but its components change. Interest for a period is calculated on the outstanding balance. The rest of that payment reduces principal. As the balance falls, the interest portion tends to fall and the principal portion tends to rise. The payment amount alone therefore does not show how quickly principal is being repaid.
A compact repayment schedule format could use these headings:
- Payment number or due date
- Opening principal balance
- Payment amount
- Interest charged
- Principal repaid
- Closing principal balance
How to Build and Read the Rows
For each period, calculate interest on the opening balance using the period’s rate. Subtract that interest from the scheduled payment to find the principal portion, then subtract principal repaid from the opening balance to find the closing balance. That closing balance becomes the next row’s opening balance.
For example, at the start of the illustrated loan, one month’s interest is approximately $20,000 × 0.0066667, or $133.33. With a $405.53 payment, about $272.20 goes toward principal, leaving an estimated closing balance of $19,727.80. The schedule may differ by a cent depending on when calculations are rounded; the lender’s accounting method and payment dates control the actual figures.
Check that interest plus principal equals the payment in each row, and that the balance generally declines when payments cover interest. The final row should bring the balance to zero or close to it, with a possible small adjustment for rounding. A schedule based on monthly periods is not necessarily a precise day-by-day ledger: actual interest can depend on contract terms and payment timing.
Choosing a Format and Understanding Limits
A spreadsheet is convenient when you need to review or adjust individual rows; a printable table works for a fixed, short schedule. For a long term, a summary by year can be easier to scan, but it hides the timing and changing composition of monthly payments. Keep a full period-by-period schedule when you need to trace a specific balance or payment.
Use the calculator to estimate the level payment and total interest, then use a schedule to see the progression. It does not create a dated lender ledger because it has no first due date, payment history, fees, or rules for daily interest. It also assumes the entered APR applies as a fixed annual rate for the whole term. Ask the lender for the exact payment schedule and the method used to apply payments.
A common misconception is that every dollar of a monthly payment reduces the amount borrowed. On an interest-bearing loan, part of each scheduled payment pays interest, so early payments can reduce principal by less than the full payment. Another source of confusion is APR versus the monthly rate: the formula converts an annual percentage rate to a monthly decimal by dividing by 1,200, not by 12 alone.
Common Schedule Differences
Not every repayment schedule has equal payments or a constant rate. A variable-rate loan may have payment amounts or interest allocations that change when its rate changes. An interest-only period can leave principal unchanged until repayment of principal begins, while a balloon structure can leave a large balance due at the end. These patterns require the applicable loan terms and cannot be represented accurately by this fixed-payment calculator.
Extra payments also change the schedule. If an extra amount is applied to principal, later interest is generally calculated on a lower balance, but the effect depends on how the servicer applies it and whether the required payment or term is recalculated. To model that accurately, each extra payment and its timing must be included; simply subtracting the extra amount from total interest is not a reliable method.
Frequently Asked Questions
What should a repayment schedule include?
A period or due date, opening balance, payment, interest, principal repaid, and closing balance are the core fields for a standard amortization schedule.
How do I calculate the interest part of a payment?
For this monthly fixed-rate example, multiply the opening balance by APR divided by 1,200. Subtract that interest from the payment to estimate the principal portion.
Does a repayment schedule include fees?
Not necessarily. This calculator excludes fees and other charges. A lender’s schedule may include or separately disclose applicable charges according to the loan terms.
Why can my schedule differ by a few cents?
Rounding, payment dates, the lender’s interest calculation method, and adjustments to the final payment can create small differences from a simplified monthly estimate.
Is APR the same as the monthly interest rate?
No. APR is entered as a yearly percentage here; the formula converts it to a monthly decimal by dividing by 1,200. The estimate does not model every fee that might affect a disclosed APR.
Can this format show extra payments?
The table can include an extra-principal column, but this calculator does not take extra payments as an input. A schedule that accounts for them needs their amounts, timing, and application to the balance.
This result is an estimate for educational use; 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
- Avalanche Game Schedule: Dates, Times and Where to Check
- Avalanche Hockey Schedule: Games, Dates and TV
- Avalanche Debt Payoff Tracker Calculator
- Avalanche Debt Repayment Calculator and Payoff Plan
- Avalanche Debt Payoff Calculator and Spreadsheet
- Avalanche Debt Payoff Calculator: Free Estimate