Loan Amortization Calculator

Inspect full yearly and monthly payment schedules showing exact principal reduction vs interest over time.

View the complete financial lifecycle of your loan. Discover how much of every monthly check goes toward reducing your actual debt balance versus lining the lender pockets with financing profit.

How this calculator works

Period Interest = Balance * (Rate / Periods per Year). Period Principal = Periodic Payment – Period Interest. Ending Balance = Beginning Balance – Period Principal.

Key benefits

Assumptions & exclusions

Frequently asked questions

Why does early payment consist mostly of interest?

Interest is charged against the outstanding principal balance. Because your balance is highest at the beginning of the loan, interest charges consume the largest portion of early payments.

What does an amortization schedule show year by year?

For each year it totals the principal repaid, the interest paid, the combined outlay, and the balance remaining at year-end. Reading down the rows shows the loan's whole story: interest shrinking, principal repayment accelerating, and the exact balance a sale or refinance would need to clear at any point.

When does the principal portion overtake the interest portion?

It depends on the rate and term — higher rates and longer terms push the crossover later. On the worked example's $18,000 loan at 9% over four years, principal exceeds interest within the first year in annual terms, because the term is short; a 30-year mortgage crosses far later.

Does the schedule change if I miss a payment?

Yes. A missed payment leaves a higher balance accruing interest, and late fees may be added, so every later row of the real schedule shifts. The table here assumes the scheduled payment is made in full every month — treat any real deviation as a reason to request an updated statement balance.

Why does the balance fall slowly at first even though payments are level?

The payment is level, but its split is not. Interest is charged on the current balance, which starts at its maximum, so the first payments are mostly interest and only the remainder reduces the balance. As the balance falls, the same payment automatically directs more toward principal.

Can I use the schedule to plan extra payments?

Yes — it shows exactly which balances generate the most future interest. Extra principal paid early removes balance that would otherwise be charged interest for every remaining month, which is why the same extra amount saves far more in year 1 than in the final year of the term.

Formula-Based Calculator · By QalcTools Editorial Team. Formulas tested against independent reference values · Content reviewed November 2026 by the QalcTools Editorial Team.

Methodology note: Standard continuous discrete compounding formula compliant with Regulation Z.

Related calculators

Category: Loans & Credit Calculators

About this calculator

A loan payment is a single number that hides a moving split: month after month, the share going to interest shrinks while the share retiring your debt grows. An amortization schedule lays that split bare. This calculator builds the schedule for a fixed installment loan and summarises it year by year — principal paid, interest paid, total outlay and the balance still owed at each year-end. It is the page to open when you want to know where you will stand at a future date: what the balance will be if you sell, refinance or simply check, halfway through, whether the debt is falling the way you expected.

How it works

The tool first solves the fixed monthly payment with the standard amortization formula, then walks the loan month by month. Each month it charges interest on the current balance at the monthly rate, applies the remainder of the payment to principal, and reduces the balance accordingly. Because the balance falls every month, the interest charge falls with it, so a growing slice of the same payment reaches principal — with no change in what you pay. The engine groups those monthly steps into annual rows showing principal paid, interest paid, their total, and the closing balance for the year, ending at zero in the final year of the term.

The formula, explained

M = P × q(1 + q)^n ÷ ((1 + q)^n − 1); each month: Interest = Balance × q; Principal = M − Interest; New balance = Balance − Principal

The engine caps the rate at 100 percent and the term at 1,200 months, solves the payment with the annuity formula (principal divided by months when the rate is 0), and reports it to cents. It then simulates every month: interest is the running balance times the monthly rate, scheduled principal is the payment minus that interest and never more than the balance, and the balance falls by that principal. Every twelfth month — or at payoff — the accumulated principal and interest are written as one yearly schedule row, rounded to whole dollars, with interest and lifetime totals taken from the same simulation.

Inputs and variables

VariableMeaningExample
Loan PrincipalThe opening balance at the top of the schedule. Every later balance descends from it by the principal portions of the payments.$18,000
Annual Interest Rate (%)The yearly rate converted to a monthly charge on the outstanding balance. Higher rates tilt the early schedule much more heavily toward interest.9% per year
Loan Term (Months)The number of payments — and therefore the number of monthly rows the engine rolls up into yearly summaries.48 months
Monthly Payment (result)The fixed payment the schedule is built around. It never changes across the rows; only its internal split between interest and principal moves.$447.93 per month

Worked example

A borrower takes an $18,000 loan at 9% over 48 months and wants the full shape of repayment — the payment, the yearly balances and the total interest.

  1. Monthly rate: 9% ÷ 12 = 0.75%. The payment formula over 48 months gives a fixed payment of $447.93.
  2. Month 1 in detail: interest is $18,000 × 0.75% = $135.00, so principal is $447.93 − $135.00 = $312.93 and the balance falls to $17,687.07.
  3. Year 1 rolled up: $3,914 of principal and $1,461 of interest paid, leaving a balance of $14,086.
  4. The tilt accelerates: by year 4 the annual interest has fallen to $253 while annual principal has risen to $5,122, and the balance closes at $0.
  5. Lifetime totals from the simulation: $3,501 of interest and $21,501 paid in all across the 48 payments.

A payment of $447.93 per month for 48 months on $18,000 at 9%, with $3,501 of total interest; the balance falls to $14,086 after year 1 and reaches zero at month 48.

The schedule turns an abstract loan into dated facts: after a quarter of the term, this borrower still owes $14,086 — over three quarters of the original debt — because the early payments were doing interest duty. That is not a flaw in the loan; it is the arithmetic of charging interest on a large opening balance. The practical uses follow directly: a sale or refinance in year 2 must clear roughly $9,805, and any extra payment made in year 1 removes balance that would otherwise keep generating interest for the remaining three years.

Understanding your results

The yearly balance column is the column to plan around. It tells you what a sale must cover, what a refinance would need to replace, and whether you will be above or below the value of whatever the loan financed at each point. Borrowers who only track payments made are routinely surprised by this column, because payments made and debt retired are very different measures in the early years of any amortizing loan.

Compare the first and last yearly interest rows to feel the tilt: $1,461 of interest in year 1 against $253 in year 4 on this loan, from identical payments. That tilt is why the schedule rewards attention early. It also explains quotes you will meet elsewhere — a lender emphasising low early cost is describing the interest-heavy front of this same curve, and a borrower planning extra payments should aim them at the front, where each dollar of principal cancels the most future interest.

Assumptions and limitations

The schedule is built for one fixed-rate loan repaid with the scheduled payment every month; it has no rows for extra principal payments, missed or late payments, rate adjustments or fees, any of which redraw the real schedule a lender would produce. Amounts are grouped by loan year rather than calendar dates, and the interest and principal in each row are rounded to whole dollars, so a lender’s statement can differ by small amounts. Escrowed charges such as property taxes and insurance, where a mortgage is concerned, sit outside these figures entirely. Treat the table as the exact map of the loan you described — and re-run it whenever the real loan’s terms change.

Common mistakes to avoid

Sources

Related guides