LOANSLoansFinance Calculator
๐Ÿ“‹

Amortization Tables: See Exactly Where Every Payment Goes

An amortization table reveals the hidden truth of every loan payment. On a $350K mortgage at 6.5%, payment #1 splits $1,108 to interest and $1,104 to principalโ€”nearly 50/50. Payment #360: only $12 to interest and $2,200 to principal. Adding $200/mo moves the crossover point to year 11 and saves $68K.

Concept Fundamentals
$1,108 int + $1,104 prin
Payment #1
$12 int + $2,200 prin
Payment #360
#202 (Year 17)
Crossover Point
$68K
Saved by $200/mo Extra

Did our AI summary help? Let us know.

Early payments are mostly interest; later payments go more to principal. Extra payments applied to principal reduce total interest and shorten the loan. Even $50โ€“200 extra per month can save thousands over a 30-year mortgage. Lump-sum payments (tax refund, bonus) have the same effect when applied to principal.

Key figures
$1,108 int + $1,104 prin
Payment #1
Key figure
$12 int + $2,200 prin
Payment #360
Key figure
#202 (Year 17)
Crossover Point
Key figure
$68K
Saved by $200/mo Extra
Key figure

Ready to run the numbers?

Why: Amortization tables matter because they show how interest is front-loaded. Early payments are mostly interest; later payments go to principal. Seeing the crossover pointโ€”when principal exceeds interestโ€”motivates extra payments. Even $50โ€“200 extra per month can save thousands over 30 years.

How: Enter principal, rate, term, and optional extra payments (monthly, annual, or lump sum). The calculator generates a full amortization schedule with principal, interest, balance, and cumulative interest per payment. Download as CSV for your records.

Early payments are mostly interest; later payments go more to principal.Extra payments applied to principal reduce total interest and shorten the loan.
Sources:CFPBFreddie Mac

Run the calculator when you are ready.

Generate Your Amortization TableEnter loan details and extra payments to see month-by-month breakdown.

๐ŸŽฏ Examples โ€” Click to Load

Inputs

Loan amount
APR
Loan term
Loan length
Additional principal
Yearly bonus
One-time extra
When to apply
Fixed payment (for neg amort)
Loan start
amortization.sh
CALCULATED
Monthly Payment
$2,212.24
Total Interest
$446,405.71
Payoff Date
April 20, 2056
Payoff Months
360
Interest Saved
$0.00
Share:
Loan Summary
$2,212.24/mo
Payoff in 360 months โ€ข Save $0.00 in interest
numbervibe.com/calculators/finance/loan-payment-table-calculator

Principal vs Interest per Payment (Crossing Point)

Cumulative Interest Paid

Balance Reduction (Acceleration)

Annual Summary (Principal vs Interest by Year)

Amortization Table

MonthPaymentPrincipalInterestExtraBalance
1$2,212.24$316.40$1,895.83$0.00$349,683.60
2$2,212.24$318.12$1,894.12$0.00$349,365.48
3$2,212.24$319.84$1,892.40$0.00$349,045.63
4$2,212.24$321.57$1,890.66$0.00$348,724.06
5$2,212.24$323.32$1,888.92$0.00$348,400.74
6$2,212.24$325.07$1,887.17$0.00$348,075.68
7$2,212.24$326.83$1,885.41$0.00$347,748.85
8$2,212.24$328.60$1,883.64$0.00$347,420.25
9$2,212.24$330.38$1,881.86$0.00$347,089.87
10$2,212.24$332.17$1,880.07$0.00$346,757.70
11$2,212.24$333.97$1,878.27$0.00$346,423.74
12$2,212.24$335.78$1,876.46$0.00$346,087.96
Page 1 of 30

๐Ÿ“ Steps

Monthly payment (PMT formula)$2,212.24
Interest each month = Balance ร— (Rate/12)Decreases over time
Principal = Payment โˆ’ Interest + ExtraIncreases over time
New balance = Previous โˆ’ PrincipalUntil $0

Loan Summary

Monthlypayment:$2,212.24โˆฃPayoff:360monthsMonthly payment: \text{\$}2,212.24 | Payoff: 360 months

Step-by-step:

1
Total Interest: $446,405.71
2
Payoff Date: April 20, 2056
3
Interest Savings (from extra payments): $0.00

Your amortization table shows how each payment is split between principal and interest. Extra payments reduce total interest and shorten the loan term.

For educational purposes only โ€” not financial advice. Consult a qualified advisor before making decisions.

๐Ÿ’ก Money Facts

๐Ÿ“Š

On a $350K 30-year loan at 6.5%, you pay ~$444K in interestโ€”more than the principal.

โ€” Amortization

๐Ÿ’ฐ

Adding $200/month to a $350K mortgage can save ~$68K and cut 7+ years off the term.

โ€” Extra Payment Impact

๐Ÿ“…

Biweekly payments (half every 2 weeks) = 13 full payments/year, accelerating payoff.

โ€” Payment Strategies

๐Ÿ 

Refinancing to a lower rate can reduce monthly payment and total interest significantly.

โ€” Refinancing

๐Ÿ“‰

Interest is front-loaded: first 5 years of a 30-year loan pay mostly interest.

โ€” Loan Structure

๐ŸŽฏ

Some lenders apply extra payments to next month's payment; specify "principal only".

โ€” Lender Policies

๐Ÿ“‹ The Hidden Truth of Every Loan Payment

An amortization table reveals the hidden truth of every loan payment. On a $350K mortgage at 6.5%, payment #1 splits $1,108 to interest and only $1,104 to principal โ€” nearly 50/50. But payment #360 (the last): only $12 to interest and $2,200 to principal. The 'crossover point' where principal exceeds interest occurs at payment #202 (month 17 of year 17). Seeing this table motivates extra payments โ€” adding $200/mo moves the crossover to year 11 and saves $68K. Every borrower should see their amortization table.

#1
$1,108 Interest + $1,104 Principal
#360
$12 Interest + $2,200 Principal
#202
Crossover (Principal > Interest)
$68K
Saved by $200/mo Extra
Sources: CFPB, Freddie Mac, Amortization.com, Bankrate

๐Ÿ’ก Key Takeaways

  • โ€ข Early payments are mostly interest; later payments go more to principal
  • โ€ข Extra payments applied to principal reduce total interest and shorten the loan
  • โ€ข Even $50โ€“200 extra per month can save thousands over a 30-year mortgage
  • โ€ข Lump-sum payments (tax refund, bonus) have the same effect when applied to principal

๐Ÿ“Š Did You Know?

๐Ÿ“ŠOn a $350K 30-year loan at 6.5%, you pay ~$444K in interestโ€”more than the principalSource: Amortization
๐Ÿ’ฐAdding $200/month to a $350K mortgage can save ~$68K and cut 7+ years off the termSource: Extra Payment Impact
๐Ÿ“…Biweekly payments (half every 2 weeks) = 13 full payments/year, accelerating payoffSource: Payment Strategies
๐Ÿ Refinancing to a lower rate can reduce monthly payment and total interest significantlySource: Refinancing
๐Ÿ“‰Interest is front-loaded: first 5 years of a 30-year loan pay mostly interestSource: Loan Structure
๐ŸŽฏSome lenders apply extra payments to next month's payment; specify "principal only"Source: Lender Policies

๐Ÿ“– How Amortization Works

An amortization table shows how each payment is split between principal and interest. The monthly payment stays fixed, but the interest portion decreases over time while the principal portion increases.

Standard Payment

M = P ร— r(1+r)^n / ((1+r)^n โˆ’ 1). Same amount each month until payoff.

Extra Payments

Any amount above the required payment goes to principal, reducing future interest.

๐ŸŽฏ Expert Tips

Start Small

Even $50โ€“100 extra per month compounds into significant savings over 30 years.

Windfall Strategy

Apply tax refunds, bonuses, or inheritances directly to principal for maximum impact.

Biweekly Option

Pay half the monthly amount every 2 weeks = 13 full payments/year, shortening the loan.

Verify With Lender

Confirm extra payments go to principal, not future payments. Some loans have prepayment penalties.

โš–๏ธ Extra Payment Impact ($350K, 6.5%)

Extra PaymentInterest SavedYears Saved
$0$00
$100/mo~$45,000~5
$200/mo~$68,000~7
$500/mo~$130,000~13

โ“ Frequently Asked Questions

What is an amortization table?

An amortization table is a schedule showing how each loan payment is split between principal and interest. Early payments are mostly interest; later payments go more to principal. The table reveals the true cost of borrowing and motivates extra payments.

How to read an amortization schedule?

Each row shows: payment number, total payment, principal portion, interest portion, extra payments, and remaining balance. Principal increases over time while interest decreases. The crossover point is when principal exceeds interestโ€”typically around year 17 on a 30-year mortgage.

What is an amortization schedule for a mortgage?

A mortgage amortization schedule shows month-by-month how your fixed payment splits between principal and interest. On a $350K loan at 6.5%, payment #1: $1,108 interest + $1,104 principal. Payment #360: $12 interest + $2,200 principal. The dramatic shift motivates extra payments.

Yearly vs monthly amortization table?

Monthly tables show every payment; yearly tables aggregate by year (total principal paid, total interest paid, ending balance). Monthly is best for seeing the crossover point and extra-payment impact. Yearly is useful for tax planning and annual summaries.

How do extra payments affect amortization?

Extra payments reduce principal immediately, so less interest accrues. Adding $200/mo to a $350K mortgage at 6.5% moves the crossover point from year 17 to year 11 and saves ~$68K. The table shows exactly when payoff accelerates.

What is negative amortization?

Negative amortization occurs when payments are below the interest dueโ€”the unpaid interest gets added to the balance. On a $200K ARM with payments below interest, the balance can INCREASE from $200K to $220K. The table shows this danger clearly.

๐Ÿ“Š Infographic Stats

~70%
Interest in First 10 Years
~$68K
Saved with $200/mo Extra
7 yrs
Years Cut with $200/mo
13
Payments/Year Biweekly

โš ๏ธ Disclaimer: This calculator is for educational purposes. Actual loan terms, interest rates, and lender policies vary. Consult your lender for specific payoff strategies.

๐Ÿ‘ˆ START HERE
โฌ…๏ธJump in and explore the concept!
AI

Related Calculators