Mortgage Amortization Modeling Tool
Complete loan analysis with equity tracking, payment schedules, and payoff projections
Loan Details
Property Details
$52,500.00 down (15.0%) • $297,500.00 loan
Current market value (Zillow, etc.)
Loan Terms
Purchase Details
Purchase Price
$350,000.00
Down Payment
$52,500.00
Loan Amount
$297,500.00
6.5% Fixed Rate • 30-year term
Total Monthly Payment
$2,456.44
P&I: $1,880.40
Tax: $350.00
Insurance: $102.08
PMI: $123.96
Total Interest
$379,444.85
Over life of loan
Total Paid
$846,512.56
P&I: $676,944.85
Tax: $126,000.00
Ins: $36,750.00
PMI: $6,817.71
Payoff Time
30y 0m
🏠 Equity Milestones
20% Equity Reached
Payment #56
September 2030
Why 20% Matters: Once you reach 20% equity, you can request removal of PMI (Private Mortgage Insurance), typically saving $100-300/month. Extra payments help you reach this milestone faster.
Key Year Snapshots
AFTER YEAR 5
Balance Remaining
$278,492.66
Equity Built
20.4%
$71,507.34
Interest Paid So Far
$93,816.80
Time Remaining
25y 0m
AFTER YEAR 10
Balance Remaining
$252,208.98
Equity Built
27.9%
$97,791.02
Interest Paid So Far
$180,357.26
Time Remaining
20y 0m
AFTER YEAR 15
Balance Remaining
$215,863.45
Equity Built
38.3%
$134,136.55
Interest Paid So Far
$256,835.87
Time Remaining
15y 0m
Snapshots show your loan position at the end of each year
Total Cost Breakdown
LIFETIME TOTAL
$846,512.56
Principal & Interest
$676,944.85
80.0%
Property Tax
$126,000.00
14.9%
Insurance
$36,750.00
4.3%
PMI
$6,817.71
0.8%
Complete cost over year loan term
Payment Breakdown Over Time
How to Read the Schedule
- Green rows: Payments you've already made (based on start date)
- Emerald border: When PMI drops off at 20% equity
- 20% Equity: When you own 20% of your home's value. PMI automatically drops off at this point.
- Net If Sold: What you'd walk away with after paying off the loan (excludes closing costs and agent fees)
Complete Payment Schedule
💡 Tip: Yearly view shows annual totals and averages
| Year | P&I | Tax | Ins | PMI | Total | Total Principal | Total Interest | One-Time Extra | Ending Balance | Equity % | Net If Sold |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Year 1 | $22,564.83 | $4,200.00 | $1,225.00 | $1,487.50 | $29,477.33 | $3,325.23 | $19,239.60 | — | $294,174.77 | 16.0% | $55,825.23 |
| Year 2 | $22,564.83 | $4,200.00 | $1,225.00 | $1,487.50 | $29,477.33 | $3,547.93 | $19,016.90 | — | $290,626.84 | 17.0% | $59,373.16 |
| Year 3 | $22,564.83 | $4,200.00 | $1,225.00 | $1,487.50 | $29,477.33 | $3,785.54 | $18,779.29 | — | $286,841.29 | 18.0% | $63,158.71 |
| Year 4 | $22,564.83 | $4,200.00 | $1,225.00 | $1,487.50 | $29,477.33 | $4,039.07 | $18,525.76 | — | $282,802.23 | 19.2% | $67,197.77 |
| Year 5 | $22,564.83 | $4,200.00 | $1,225.00 | $867.71 | $28,857.54 | $4,309.57 | $18,255.26 | — | $278,492.66 | 20.4% | $71,507.34 |
| Year 6 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $4,598.19 | $17,966.64 | — | $273,894.47 | 21.7% | $76,105.53 |
| Year 7 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $4,906.14 | $17,658.69 | — | $268,988.33 | 23.1% | $81,011.67 |
| Year 8 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $5,234.71 | $17,330.12 | — | $263,753.62 | 24.6% | $86,246.38 |
| Year 9 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $5,585.29 | $16,979.54 | — | $258,168.32 | 26.2% | $91,831.68 |
| Year 10 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $5,959.35 | $16,605.48 | — | $252,208.98 | 27.9% | $97,791.02 |
| Year 11 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $6,358.46 | $16,206.37 | — | $245,850.52 | 29.8% | $104,149.48 |
| Year 12 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $6,784.29 | $15,780.53 | — | $239,066.22 | 31.7% | $110,933.78 |
| Year 13 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $7,238.65 | $15,326.18 | — | $231,827.57 | 33.8% | $118,172.43 |
| Year 14 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $7,723.44 | $14,841.39 | — | $224,104.14 | 36.0% | $125,895.86 |
| Year 15 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $8,240.69 | $14,324.14 | — | $215,863.45 | 38.3% | $134,136.55 |
| Year 16 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $8,792.58 | $13,772.24 | — | $207,070.86 | 40.8% | $142,929.14 |
| Year 17 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $9,381.44 | $13,183.39 | — | $197,689.42 | 43.5% | $152,310.58 |
| Year 18 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $10,009.73 | $12,555.10 | — | $187,679.69 | 46.4% | $162,320.31 |
| Year 19 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $10,680.10 | $11,884.73 | — | $176,999.58 | 49.4% | $173,000.42 |
| Year 20 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $11,395.37 | $11,169.46 | — | $165,604.22 | 52.7% | $184,395.78 |
| Year 21 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $12,158.54 | $10,406.29 | — | $153,445.68 | 56.2% | $196,554.32 |
| Year 22 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $12,972.82 | $9,592.01 | — | $140,472.86 | 59.9% | $209,527.14 |
| Year 23 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $13,841.63 | $8,723.20 | — | $126,631.23 | 63.8% | $223,368.77 |
| Year 24 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $14,768.63 | $7,796.20 | — | $111,862.60 | 68.0% | $238,137.40 |
| Year 25 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $15,757.71 | $6,807.11 | — | $96,104.88 | 72.5% | $253,895.12 |
| Year 26 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $16,813.04 | $5,751.79 | — | $79,291.84 | 77.3% | $270,708.16 |
| Year 27 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $17,939.04 | $4,625.79 | — | $61,352.81 | 82.5% | $288,647.19 |
| Year 28 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $19,140.45 | $3,424.38 | — | $42,212.36 | 87.9% | $307,787.64 |
| Year 29 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $20,422.32 | $2,142.51 | — | $21,790.04 | 93.8% | $328,209.96 |
| Year 30 | $22,564.83 | $4,200.00 | $1,225.00 | $0.00 | $27,989.83 | $21,790.04 | $774.79 | — | $0.00 | 100.0% | $350,000.00 |