Amortization Schedule Calculator
This amortization schedule calculator builds a monthly repayment table for a fixed-rate loan and optional extra principal payments. It calculates the contractual payment from the starting balance and term, then shows the payoff time, interest, and savings from paying extra.
By Dr. Hassan Khames EliwaLast updated
Result
- Payoff months
- 12
- Total interest
- $393.57
- Total paid
- $12,393.57
- Interest saved with extra payments
- $0.00
- Balance
Monthly amortization; calculations retain full precision
| Month | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | $1,032.80 | $972.80 | $60.00 | $11,027.20 |
| 2 | $1,032.80 | $977.66 | $55.14 | $10,049.54 |
| 3 | $1,032.80 | $982.55 | $50.25 | $9,066.99 |
| 4 | $1,032.80 | $987.46 | $45.33 | $8,079.53 |
| 5 | $1,032.80 | $992.40 | $40.40 | $7,087.13 |
| 6 | $1,032.80 | $997.36 | $35.44 | $6,089.77 |
| 7 | $1,032.80 | $1,002.35 | $30.45 | $5,087.42 |
| 8 | $1,032.80 | $1,007.36 | $25.44 | $4,080.06 |
| 9 | $1,032.80 | $1,012.40 | $20.40 | $3,067.66 |
| 10 | $1,032.80 | $1,017.46 | $15.34 | $2,050.20 |
| 11 | $1,032.80 | $1,022.55 | $10.25 | $1,027.66 |
| 12 | $1,032.80 | $1,027.66 | $5.14 | $0.00 |
How it works
Establish the scheduled payment
The starting balance is the amount still owed at the beginning of the modeled term. The annual rate is divided by 1,200 to obtain a monthly decimal rate. The scheduled payment is the level payment that amortizes the balance across the selected number of months.
The formula uses a fixed rate and monthly payments. Origination fees, insurance, property taxes, late charges, and other costs are outside the calculation. A disclosed APR can include fees, so the contract interest rate is generally the relevant input for reproducing a principal-and-interest schedule.
Apply extra principal month by month
Each month, interest is calculated on the opening balance. The scheduled payment plus your extra amount is then applied, capped at the amount needed to clear that balance and interest. Whatever remains after interest reduces principal. Future interest falls because it is charged on the smaller balance.
The scheduled monthly payment result excludes the extra amount. Your usual intended outlay is that result plus extra principal, except when the last payment is smaller. The calculator assumes the lender credits extra payments immediately to principal without a penalty and does not recast the contractual payment.
Compare against the same loan without extras
A separate baseline schedule uses the same starting balance, rate, and remaining term without extra payments. Interest saved is baseline interest minus interest on the extra-payment schedule. It is not a comparison with refinancing, changing the rate, or changing the original borrowing amount.
The table shows every actual payment month, including principal, interest, and remaining balance. Calculations retain full precision; currency is rounded only for display. Adding displayed rows can therefore differ slightly from a displayed total. Actual servicers may round interest monthly or use daily accrual, producing a different final payment.
Terms must be whole months from one to 1,200. The starting balance must be positive, extra payments nonnegative, and annual interest between zero and 100%. These boundaries keep the schedule finite and manageable; they do not describe typical lending terms.
Worked example
Paying a zero-interest balance ahead of schedule
Use a $12,000 starting balance, 0% annual interest, a 12-month remaining term, and $200 extra principal per month. The scheduled monthly payment is $1,000.00. Adding the extra payment creates a $1,200 monthly outlay.
The first table row shows payment $1,200.00, principal $1,200.00, interest $0.00, and balance $10,800.00. The loan clears in 10 months. The tenth row again has a $1,200.00 payment and finishes at $0.00.
Total interest is $0.00, total paid is $12,000.00, and interest saved is $0.00. Paying extra still removes two scheduled payment months, but there is no interest to save at a zero rate. This distinction matters: earlier payoff and interest savings measure different benefits.
A second independent scenario
A $6,000 balance at zero interest over twelve months without extra principal gives a $500.00 scheduled payment and 12 payoff months. Total paid is $6,000.00, with $0.00 total interest and $0.00 interest saved. Every monthly row allocates its entire payment to principal. Compare this baseline with an extra-payment plan while retaining the same initial balance and rate.
Expert tips
Common mistakes
- Entering a total mortgage bill that includes taxes or insurance as the principal-and-interest payment leads to a misleading comparison. This tool derives only the loan payment from the balance, rate, and term.
- Assuming extra payments automatically lower future required installments describes a recast, not this model. Here the scheduled payment stays fixed and the payoff date moves earlier.
- Treating the final cent as a payoff quote overlooks daily interest and lender rounding. Request the lender’s dated settlement figure before sending the last payment.
For education, not financial advice. Results are estimates based on the inputs you give. Lenders, tax authorities and advisers may use different rules, fees and rounding. Check the numbers with a qualified professional before you commit to anything.
Frequently asked questions
Can I use this for an existing loan?
Yes. Enter the current principal balance and remaining term, provided the loan uses fixed-rate monthly amortization. Daily-accrual or irregular-payment contracts may need a different schedule.
Does the scheduled payment include my extra amount?
No. The headline scheduled payment is the base principal-and-interest payment. Add your entered extra principal to estimate the usual outlay before the capped final payment.
Why might displayed rows not add exactly?
Internal calculations keep full precision, while each displayed currency amount is rounded to cents. Small display differences are possible when independently rounded rows are summed.
Are prepayment penalties included?
No. Fees, penalties, and contractual limits on extra payments are excluded. Review your loan agreement before treating the calculated interest reduction as a net financial saving.
Can the rate change later?
Not in this schedule. The rate remains fixed throughout. For an adjustable-rate loan, model separate periods and do not interpret this single-rate result as a guaranteed payoff path.
Related calculators
Related guides
FinancialCompound interest: three real savings scenariosThree practical savings examples show what comes from your deposits, what comes from growth, and which assumptions deserve scrutiny.14 November 2026 · 7 min read
FinancialHow mortgage amortization really worksEarly payments are mostly interest because the balance is still large—not because the lender charges all the interest upfront.14 November 2026 · 7 min readSources and standards
About the author
Dr. Hassan Khames Eliwa holds a PhD in Construction & Built Environment and has more than 20 years of international project controls experience. He is Director of Eliwa Project Controls Limited in Auckland and founder of PMMilestone.org and PMMilestone.com.
Buy me a coffee