2026.25
Mortgage Amortization Modeling Tool
Complete loan analysis with equity tracking, payment schedules, and payoff projections
Purchase Details
Purchase Price
$350,000.00
Down Payment
$52,500.00
Loan Amount
$297,500.00
5.98% Fixed Rate • 30-year term
🏠 Equity Milestones
20% Equity Reached
Payment #52
July 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.
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 | $21,358.07 | $4,200.00 | $1,225.00 | $1,487.50 | $28,270.57 | $3,666.99 | $17,691.08 | — | $293,833.01 | 16.0% | $56,166.99 |
| Year 2 | $21,358.07 | $4,200.00 | $1,225.00 | $1,487.50 | $28,270.57 | $3,892.39 | $17,465.68 | — | $289,940.61 | 17.2% | $60,059.39 |
| Year 3 | $21,358.07 | $4,200.00 | $1,225.00 | $1,487.50 | $28,270.57 | $4,131.64 | $17,226.43 | — | $285,808.97 | 18.3% | $64,191.03 |
| Year 4 | $21,358.07 | $4,200.00 | $1,225.00 | $1,487.50 | $28,270.57 | $4,385.60 | $16,972.47 | — | $281,423.37 | 19.6% | $68,576.63 |
| Year 5 | $21,358.07 | $4,200.00 | $1,225.00 | $371.88 | $27,154.95 | $4,655.17 | $16,702.90 | — | $276,768.20 | 20.9% | $73,231.80 |
| Year 6 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $4,941.31 | $16,416.76 | — | $271,826.89 | 22.3% | $78,173.11 |
| Year 7 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $5,245.03 | $16,113.04 | — | $266,581.86 | 23.8% | $83,418.14 |
| Year 8 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $5,567.43 | $15,790.64 | — | $261,014.43 | 25.4% | $88,985.57 |
| Year 9 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $5,909.64 | $15,448.43 | — | $255,104.79 | 27.1% | $94,895.21 |
| Year 10 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $6,272.88 | $15,085.19 | — | $248,831.91 | 28.9% | $101,168.09 |
| Year 11 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $6,658.45 | $14,699.62 | — | $242,173.46 | 30.8% | $107,826.54 |
| Year 12 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $7,067.73 | $14,290.34 | — | $235,105.73 | 32.8% | $114,894.27 |
| Year 13 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $7,502.16 | $13,855.92 | — | $227,603.58 | 35.0% | $122,396.42 |
| Year 14 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $7,963.29 | $13,394.78 | — | $219,640.29 | 37.2% | $130,359.71 |
| Year 15 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $8,452.76 | $12,905.31 | — | $211,187.53 | 39.7% | $138,812.47 |
| Year 16 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $8,972.32 | $12,385.75 | — | $202,215.20 | 42.2% | $147,784.80 |
| Year 17 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $9,523.82 | $11,834.25 | — | $192,691.38 | 44.9% | $157,308.62 |
| Year 18 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $10,109.22 | $11,248.85 | — | $182,582.16 | 47.8% | $167,417.84 |
| Year 19 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $10,730.60 | $10,627.47 | — | $171,851.56 | 50.9% | $178,148.44 |
| Year 20 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $11,390.17 | $9,967.90 | — | $160,461.39 | 54.2% | $189,538.61 |
| Year 21 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $12,090.29 | $9,267.79 | — | $148,371.11 | 57.6% | $201,628.89 |
| Year 22 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $12,833.43 | $8,524.64 | — | $135,537.67 | 61.3% | $214,462.33 |
| Year 23 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $13,622.26 | $7,735.81 | — | $121,915.41 | 65.2% | $228,084.59 |
| Year 24 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $14,459.57 | $6,898.50 | — | $107,455.84 | 69.3% | $242,544.16 |
| Year 25 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $15,348.35 | $6,009.72 | — | $92,107.48 | 73.7% | $257,892.52 |
| Year 26 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $16,291.76 | $5,066.31 | — | $75,815.72 | 78.3% | $274,184.28 |
| Year 27 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $17,293.16 | $4,064.91 | — | $58,522.56 | 83.3% | $291,477.44 |
| Year 28 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $18,356.11 | $3,001.96 | — | $40,166.44 | 88.5% | $309,833.56 |
| Year 29 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $19,484.40 | $1,873.67 | — | $20,682.04 | 94.1% | $329,317.96 |
| Year 30 | $21,358.07 | $4,200.00 | $1,225.00 | $0.00 | $26,783.07 | $20,682.04 | $676.03 | — | $0.00 | 100.0% | $350,000.00 |