Mortgage Amortization Schedule Calculator

A mortgage is a 360-act play, and the amortization schedule is its script: every payment, every interest charge, every dollar of principal, month by month until the balance hits zero. The Mortgage Amortization Schedule Calculator distills that script into its three most revealing numbers — your monthly payment, the total interest you will pay in the first year, and your remaining balance after twelve payments — the figures that tell you how the loan really behaves.

Most borrowers know their payment and little else. But the first year of a mortgage is where the most expensive lessons hide: how little principal a payment buys when the balance is largest, how much interest the bank collects before you have built any real equity, and how dramatically extra payments in year one outperform extra payments in year twenty. Twelve months of amortization teach more than a decade of statements.

This guide explains what amortization is, the closed-form mathematics that produces schedule figures without simulating 360 rows, how to use the calculator, two complete worked examples, how to read your first year like a professional, how extra payments rewrite the schedule, and when the schedule matters most. Fifteen FAQs and a conclusion follow.

What an Amortization Schedule Is

An amortization schedule is the month-by-month ledger of a loan: for each payment number, it lists the payment amount, the interest portion, the principal portion, and the remaining balance. On a fixed-rate mortgage the payment never changes, but its composition glides continuously from interest-heavy to principal-heavy as the balance falls.

The schedule exists because lenders must prove the loan actually amortizes — that the fixed payment, repeated for the full term, drives the balance exactly to zero. Regulators, auditors, and borrowers all read the same ledger. For you, it is the document that translates a 30-year commitment into 360 concrete, inspectable facts.

You rarely need all 360 rows. The figures that drive decisions are concentrated at the boundaries: the first year (where interest dominates), the crossover point (where principal first exceeds interest in a payment), and the final years (where payments are nearly pure principal). This calculator reports the first boundary precisely.

The Closed-Form Math: No 360 Rows Needed

Simulating 360 monthly rows works, but closed-form formulas are faster and exact. The monthly payment is PMT = P x r x (1+r)^k / ((1+r)^k – 1). The balance after m payments is B(m) = P x (1+r)^m – PMT x ((1+r)^m – 1) / r — the grown principal minus the grown value of payments made. Total paid over m months is m x PMT, so interest paid in that span is simply m x PMT – (P – B(m)).

For the calculator’s first-year figures, m = 12. The balance after twelve payments, B(12), comes straight from the formula; first-year interest is 12 payments minus the principal retired (P – B(12)). No iteration, no rounding drift across rows — the same numbers a full 360-row simulation would produce, in a single evaluation.

The 0% edge case is instructive: with no interest, the balance after twelve payments is exactly P – 12 x PMT, and first-year “interest” is zero. The calculator handles this branch explicitly, which doubles as a correctness anchor — at 0% APR the schedule must be pure division, and it is.

How to Use the Mortgage Amortization Schedule Calculator

Three inputs reconstruct your loan’s opening chapter:

1. Enter the loan amount in dollars — the principal borrowed, such as 300000.
2. Enter the annual interest rate as a percentage, like 6.5.
3. Enter the loan term in years — 30 for the classic fixed mortgage, 15 for the accelerated version.
4. Press Calculate to see the monthly payment, first-year interest, and balance after twelve payments.

Use the balance-after-12-payments figure to calibrate expectations: it is almost always higher than new borrowers guess, and that surprise is the lesson.

Worked Example 1: $300,000 at 6.50% for 30 Years

Borrow $300,000 at 6.50% APR for 30 years (360 payments). Monthly rate r = 0.065/12 = 0.0054167; (1+r)^360 = 6.99215. Payment = 300,000 x 0.0054167 x 6.99215 / 5.99215 = $1,896.20 per month.

After twelve payments: (1+r)^12 = 1.06697, so B(12) = 300,000 x 1.06697 – 1,896.20 x (0.06697/0.0054167) = 320,091 – 23,445 = $296,646.82. You paid $22,754.40 across the year and retired only $3,353.18 of principal — first-year interest is $19,401.27. Eighty-five percent of year one’s payments went to the bank’s interest, fifteen percent to your equity. That ratio is the single most important thing a new homeowner can understand.

Worked Example 2: $450,000 at 5.75% for 30 Years

Borrow $450,000 at 5.75% APR for 30 years. Monthly rate 0.0047917; (1+r)^360 = 5.58651. Payment = 450,000 x 0.0047917 x 5.58651 / 4.58651 = $2,626.08 per month.

After twelve payments: (1+r)^12 = 1.05904, B(12) = 450,000 x 1.05904 – 2,626.08 x (0.05904/0.0047917) = 476,568 – 32,357 = $444,211.08. Twelve payments totaled $31,512.96; principal retired was $5,788.92; first-year interest was $25,724.02. The lower rate softened the interest share versus example one, but the balance still barely moved — the mathematics of large balances and long terms is unforgiving in year one.

Reading Your First Year Like a Professional

Professionals read the first-year interest figure as the price of admission. In example one, year one costs $19,402 in interest to “rent” $300,000 of the bank’s money while building $3,352 of equity. Compare that with renting a comparable home: if annual rent is below $19,402 plus maintenance and taxes, renting can be the cheaper housing — the schedule makes the buy-vs-rent math brutally concrete.

The balance-after-twelve-payments figure also sets your equity reality. After a full year of $1,896 payments, you own $3,352 more of the house than at closing (plus any appreciation and your down payment). Anyone planning to sell within a few years should stare at this number: with 6% selling costs, year-one sellers routinely lose money even as prices rise.

Finally, the first-year figures calibrate prepayment strategy. An extra $5,000 applied in month one of example one saves about $35,000 in lifetime interest; the same $5,000 in year twenty saves a fraction of that. The schedule’s opening rows are where extra dollars have maximum leverage — a fact invisible on the monthly statement but obvious in the amortization math.

How Extra Payments Rewrite the Schedule

Every extra principal dollar deletes all future interest on itself and pulls every subsequent payment’s principal share forward. A single extra $10,000 payment in month 13 of example one shortens the loan by about 14 months and saves roughly $26,000 in interest — because it retires principal that would otherwise have accrued interest for decades.

Recurring extra payments compound the effect. Adding $200 monthly to example one’s payment retires the loan roughly six years early and saves about $75,000 in interest. The schedule does not just shrink; it reshapes — the crossover point where principal exceeds interest arrives years sooner, and the interest-heavy early phase compresses.

The strategic question is always opportunity cost. Extra payments earn a guaranteed return equal to the mortgage rate — 6.50% risk-free in example one, an excellent deal. Against a 3% mortgage, the same dollars might earn more invested. The schedule quantifies the guaranteed side of that tradeoff precisely; your risk tolerance prices the other side.

When the Schedule Matters Most

Refinancing decisions live and die by the schedule. Refinancing restarts amortization — a new loan’s early years are interest-heavy again. Refinancing in year three of a 6.50% loan into a 5.75% loan usually wins; refinancing in year twenty rarely does, because you have already survived the interest-heavy phase and would be volunteering to repeat it.

ARM adjustments are schedule shocks: when a 5/1 ARM resets, the payment recalculates against the remaining balance and term at the new rate. Knowing your balance trajectory — the B(m) curve — lets you forecast the reset payment years in advance instead of being ambushed by it.

Divorce, inheritance, and sale timing all require knowing the balance at a specific future date. The closed-form balance formula answers “what will we owe in month 40?” instantly — the number that determines equity splits, payoff quotes, and whether selling even makes sense.

The Crossover Point: When Principal Takes Over

Every amortizing loan has a crossover month: the first payment in which the principal portion exceeds the interest portion. On a 30-year loan at 6.50%, it arrives around month 200 — more than sixteen years in. On a 15-year loan at the same rate, it arrives around month 30. The crossover is the loan’s psychological turning point: before it, you are mostly renting money; after it, you are mostly buying the house.

Extra payments drag the crossover dramatically closer. Adding $300 monthly to our $300,000 example pulls the crossover from month ~200 to roughly month ~110 — nearly eight years sooner. The mechanism is straightforward: extra principal shrinks the balance, which shrinks every subsequent interest charge, which enlarges every subsequent principal share. It is a virtuous cycle running in reverse of the original amortization.

Track your own crossover by watching two numbers on each statement: interest paid and principal paid. The month they swap leadership, celebrate — from there, every payment builds equity faster than it feeds the bank. Borrowers who know their crossover date tend to protect it fiercely, because they understand what it represents.

15-Year vs. 30-Year: A Schedule Showdown

Run $300,000 at 6.50% through both terms and the schedules tell opposite stories. The 30-year loan: $1,896 monthly, $382,632 in total interest. The 15-year loan: about $2,601 monthly, roughly $168,000 in total interest. The 15-year costs $705 more per month but saves over $214,000 in interest — and builds equity at nearly triple the early pace.

The first-year contrast is starkest. The 30-year borrower retires $3,352 of principal in year one; the 15-year borrower retires about $11,500. After five years, the 30-year balance is still ~$283,000 while the 15-year balance is ~$238,000. Same house, same rate, radically different wealth trajectories — the term is doing enormous hidden work.

The 15-year is not universally superior: its higher payment reduces flexibility and the opportunity cost of the extra $705 monthly is real. But the schedule comparison reframes the choice honestly — it is not “$705 more per month” but “$705 monthly to buy $214,000 and fifteen years of freedom.” Few financial tradeoffs are stated that clearly; the schedule states this one.

Reading the Schedule at a Glance

You do not need all 360 rows memorized — you need three landmarks. The first-year interest tells you the price of admission. The crossover month tells you when the loan turns in your favor. The balance at any future date tells you your equity position for sales and refinances. Everything else is detail.

Bookmark this calculator alongside your loan documents. Once a year, re-run your numbers with the current balance as the loan amount and the remaining term — a rolling schedule that keeps the landmarks current as extra payments reshape the loan beneath you.

Tips for Mastering Your Amortization Schedule

1. 1. Study year one before closing. — The first-year interest and post-year-one balance reveal the loan’s true opening cost; know them before you sign.
2. 2. Prepay early, not late. — Extra principal in the first years saves multiples of what the same dollars save later.
3. 3. Find your crossover point. — The month principal first exceeds interest marks the loan’s turning point; extra payments pull it dramatically closer.
4. 4. Model refinancing against the schedule. — Compare remaining interest on the current loan versus total interest on the new one, including closing costs.
5. 5. Track balance, not just payments. — The B(m) trajectory tells you your equity position at any future date for sales and refinancing decisions.
6. 6. Beware the refinance reset trap. — A lower rate that restarts a 30-year clock can cost more lifetime interest than keeping a higher rate with fewer years left.
7. 7. Automate a small extra payment. — Even $100 monthly reshapes a 30-year schedule; automation makes it permanent.

Frequently Asked Questions

1. What does the Mortgage Amortization Schedule Calculator show?

Your fixed monthly payment, the total interest paid during the first twelve months, and the remaining loan balance after twelve payments — computed with exact closed-form formulas.

2. What is an amortization schedule?

A month-by-month ledger of a loan showing each payment’s interest portion, principal portion, and the remaining balance, from origination to a zero balance.

3. Why is the first-year interest so high?

Interest accrues on the outstanding balance, which is largest at the start. Early payments are therefore interest-heavy; the principal share grows as the balance shrinks.

4. How is the balance after 12 payments calculated?

With B(12) = P x (1+r)^12 – PMT x ((1+r)^12 – 1) / r: the grown principal minus the grown value of the twelve payments made.

5. Why did my balance barely drop after a year?

On a large long-term loan, year-one payments are mostly interest. In the $300,000 example, only about 15% of year-one payments reduced principal — normal amortization, not an error.

6. Do extra payments really save that much interest?

Yes, especially early. Each extra principal dollar eliminates all future interest on itself, and early in a 30-year loan that means decades of interest erased per dollar.

7. What is the crossover point?

The month when a payment’s principal portion first exceeds its interest portion. On 30-year loans it typically arrives years in; extra payments pull it much closer.

8. Should I refinance based on the schedule?

Compare the remaining interest on your current loan against the new loan’s total interest plus closing costs — and remember refinancing restarts the interest-heavy early phase.

9. How does a 15-year term change the schedule?

Payments rise about 40-50%, but first-year interest roughly halves and the crossover point arrives in the first couple of years. Total interest falls enormously.

10. What happens with an adjustable-rate mortgage?

The schedule holds until the reset date; then the payment recalculates on the remaining balance and term at the new rate. The balance formula still forecasts the reset point.

11. Can I get my full 360-row schedule?

Yes — lenders and free spreadsheet templates generate it. This calculator gives you the three boundary figures that drive most decisions without the 360 rows.

12. Does the schedule include taxes and insurance?

No. It models principal and interest only. Escrow for taxes and insurance is separate and does not amortize the loan.

13. Why does refinancing late rarely help?

Because you have already paid most of the interest. A new loan restarts amortization’s interest-heavy phase, which can outweigh the lower rate.

14. What if my rate is 0%?

Then every payment is pure principal: the balance after twelve payments is exactly P minus twelve payments, and first-year interest is zero.

15. How do I use the schedule when selling?

Read the balance at your planned sale month, subtract it and selling costs from the expected price — that is your walk-away equity. Year-one sellers often find it uncomfortably small.

CONCLUSION

The Mortgage Amortization Schedule Calculator turns a 30-year abstraction into three concrete facts: your payment, your first year’s interest cost, and where you stand after twelve months. Those facts are the foundation of every smart mortgage decision — prepayment, refinancing, and timing a sale.

Study the schedule before you borrow, respect the interest-heavy early years, and attack principal while each dollar has maximum leverage. Amortization is just arithmetic, but it is arithmetic that rewards whoever reads it first.