Loan Amortization Calculator
Loan Amortization
Build a full payment timeline for any loan — the principal/interest split and remaining balance for every period — and export it to Excel.
| Calculate By: | |
| Loan Amount: | |
| Monthly Payment*: | |
| APR Interest Rate: |
% |
| Next Payment Date: | |
| Additional Monthly Principal: | |
| One Time Extra Principal: |
| Period | Date | Original Interest Paid |
Original Principal Paid |
Original Principal Balance |
Additional Principal Adjusted Interest Paid |
Additional Principal Adjusted Principal Paid |
Additional Principal Adjusted Principal Balance |
|---|
Why the early payments barely move the balance
An amortization schedule is the payment-by-payment story of a loan: what each payment buys in interest, what it buys in principal, and what is left. It is also the clearest way to see what an extra payment does, because the effect is almost never what the size of the payment suggests.
Interest is charged on what you still owe, so it is largest at the start — when you owe the most. Early in a long loan the majority of each payment is interest and only a sliver is principal, which is why the balance seems to sit still for years. The proportion flips gradually, and on a 30-year mortgage the crossover point where principal finally exceeds interest arrives surprisingly late.
This is not a quirk to be annoyed at. It follows from a fixed payment against a falling balance, and it is the same arithmetic that makes the end of a loan cheap.
What paying extra actually does
Every extra dollar goes entirely to principal, so it removes not just itself but all the future interest that balance would have accrued. That is why an extra payment made early is worth several made late, and why modest regular overpayments shorten a loan by far more than their size implies.
The schedule takes both shapes: an additional amount every period, and a one-time lump sum applied at the start. Comparing the two is the useful exercise — a windfall now and a small monthly increase often land closer together than expected.
Two things to check against your own loan before acting on any of it. Some lenders apply extra money to the next payment rather than to principal unless you tell them otherwise, which achieves almost nothing; and a few carry prepayment penalties. Both are questions for the lender, not for a calculator.
Whether to overpay at all
Paying down a loan is a guaranteed return equal to its interest rate, which makes it a genuinely good deal against a high-rate debt and a closer call against a cheap one. The comparison worth making is against what the same money would do elsewhere — invested, or put toward a higher-rate balance first. Carrying several debts? The debt snowball calculator orders them, and the debt guide covers the snowball and avalanche approaches.
Assumes a fixed rate and consistent payments. Escrowed taxes and insurance, late fees, and variable-rate adjustments aren't modeled.
Debt Snowball vs. Avalanche
Carrying several debts? Compare paying the smallest balance first against the highest rate first — your debt-free date, total interest and payoff order under each.
| Debt | Balance | APR % | Monthly payment | Remove |
|---|---|---|---|---|
Smallest balance first
- Store card Jan 2027
- Personal loan Oct 2027
- Credit card Jun 2028
- Car loan Dec 2028
Highest interest rate first
- Store card Jan 2027
- Credit card Feb 2028
- Personal loan Jun 2028
- Car loan Dec 2028
The avalanche saves $227 in interest. Both clear their first debt in month 4, so the snowball's usual head start doesn't apply here.
Your extra $200 a month makes you debt-free 1 yr sooner and saves $1,986 in interest, compared with paying only the payments above.
Interest is charged monthly at the APR ÷ 12, and payments stay the same until a debt is paid off — then that payment rolls into the next debt in line. Real card statements charge daily and recalculate minimums as balances fall, so treat the dates as close estimates.
Snowball or avalanche?
Two ways to pay off several debts at once, compared side by side on your own numbers. Both keep every minimum paid and send all the extra money to one debt at a time. When that debt is gone, its whole payment rolls onto the next — which is where the "snowball" comes from, and why both plans speed up as they go. They differ only in which debt goes first.
The snowball starts with the smallest balance. You clear a debt sooner, which is a real motivation: a payment that disappears from your month is easier to believe in than a balance that is merely smaller. The avalanche starts with the highest interest rate, which always costs the same or less in interest — the calculator shows by how much. When the gap is small, the snowball's early win is often worth it. When it is large, the avalanche is paying you to be patient.
The extra payment does most of the work
The order matters less than the amount. Compare the result with the extra set to zero: that is the plan you are already on, and the difference is what a steady extra payment buys. Even a modest amount, kept up every month, usually moves the debt-free date by years — the rollover means each freed-up payment adds to it.
What the calculator assumes
Interest is charged monthly at the annual rate divided by twelve, and each payment stays the same until its debt is paid off. A real credit card charges interest daily and lowers its minimum as the balance falls, so the dates here are close estimates rather than a statement. A mortgage is usually left out of a snowball — its long term would set the debt-free date on its own — but you can add it as a row if you want it in.
With an account, the repayment strategies page runs the same comparison on the debts you track, using each one's own interest method, and follows your progress against the plan.
Refinance Exploration
Compare your current loan against a refinance offer — including the break-even point on closing costs.
When refinancing makes sense
A rate drop of 0.75–1%+ is the usual threshold, but the real test is the break-even point: if you'll sell or pay off before then, the closing costs outweigh the savings.
Refinancing into a shorter term (30 → 15 years) at a lower rate is where the biggest lifetime savings live — if the higher payment fits your budget.
Watch the term reset
Refinancing 25 remaining years into a fresh 30-year loan lowers the payment but adds five years of interest — a lower payment is not the same as a cheaper loan.
Compare total interest, not just the monthly number. The calculator above shows both.
Costs to expect
Origination fees, appraisal, title work, and (optionally) discount points. "No-closing-cost" offers roll the costs into the rate or balance — you still pay them.
Lenders must give you a standardized Loan Estimate — use it to compare offers line by line.
Estimates cover principal and interest only — taxes, insurance, and PMI are excluded. Actual rates depend on credit, equity, and market conditions.
Debt Payoff Calculator
See your debt-free date for a single balance — and what paying a little extra each month really buys you.
Have multiple debts?
This calculator models one balance. The Repayment Strategies tool builds a full snowball/avalanche plan from your actual accounts and budget, rolling freed-up payments into the next target.
New to the strategies? Debt Education explains snowball vs. avalanche and how APR works.
Minimum-payment trap
Card minimums are designed to keep you paying for years — often 2–3% of the balance, barely above the interest charge.
Fixing your payment at today's minimum (instead of letting it shrink with the balance) already cuts years off the payoff.
Where to find extra
One-time windfalls (tax refunds, bonuses) applied straight to principal skip the interest they would have accrued for the rest of the loan.
The Cash Flow Planner can show how much surplus each pay period actually has.
Assumes a fixed APR with monthly compounding and no new charges on the account. Card issuers may calculate interest daily; treat results as close estimates.
Debt Consolidation
See whether rolling multiple debts into one loan could lower your total cost — fees included.
Common options
- Balance-transfer card — 0% intro APR for 12–21 months, usually a 3–5% transfer fee; best for debt you can clear inside the intro window
- Personal consolidation loan — fixed rate and payoff date; rate depends heavily on credit score
- Home equity loan / HELOC — lowest rates, but converts unsecured debt into debt secured by your home
Watch for
Transfer and origination fees, intro periods that expire into high rates, and prepayment penalties on the new loan.
Deferred-interest offers ("no interest if paid in full") charge all the back interest if any balance remains at the deadline.
The real risk
Consolidation reorganizes debt — it doesn't reduce it. The most common failure mode is running the newly-cleared cards back up, ending with the loan and new card balances.
If overspending caused the debt, fix the budget first — the Cash Flow Planner is built for exactly that.
Models a fixed-rate loan with the fee financed into the balance. Balance-transfer intro periods and variable rates aren't modeled — compare offers with their actual terms.
Resource Directory
Trusted, free help for managing and reducing debt.
Nonprofit credit counseling
The National Foundation for Credit Counseling connects you with certified counselors for free or low-cost budget reviews and debt-management plans.
Legitimate counselors review your whole budget before recommending anything — be wary of anyone who leads with a product.
Government guidance
The Consumer Financial Protection Bureau publishes free plain-language guides on debt collection, credit repair, and loans — plus a complaint system that gets lender responses.
For housing trouble, HUD-approved housing counselors offer free foreclosure-avoidance help.
Your credit reports
AnnualCreditReport.com is the only federally authorized source for free reports from all three bureaus — now available weekly.
Dispute errors directly with the bureaus; roughly one in five reports contains one, and fixing them is free.
Know your rights
The Fair Debt Collection Practices Act bars collectors from harassment, threats, and calls at unreasonable hours — and you can demand contact stop in writing.
The CFPB's debt-collection hub includes sample letters for exercising those rights.
Student loans
StudentAid.gov is the official source for income-driven repayment, consolidation, deferment, and forgiveness programs for federal loans.
Never pay a company to enroll you in these programs — every federal option is free to apply for yourself.
⚠️ Debt-relief companies
For-profit "debt settlement" firms charge steep fees, tell you to stop paying creditors (wrecking your credit), and often settle for less than the fees cost you.
The FTC's guide to getting out of debt explains the warning signs before you sign anything.
Links are to nonprofit and government resources; Manage Your Means has no affiliation with them. This is general education, not personalized financial or legal advice.