2026.9166666666667
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
7.18% Fixed Rate • 30-year term
Equity Milestones
20% Equity Reached
Payment #62
January 2032
PMI Removal: You can request removal of PMI (Private Mortgage Insurance) around payment #62 (January 2032), typically saving $100–300/month. Lenders measure this against your original loan-to-value, so it can come later than the 20%-equity date above (which counts home appreciation). Extra payments get you there 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 | $24,184.42 | $4,200.00 | $1,225.00 | $1,487.50 | $31,096.92 | $2,918.73 | $21,265.69 | — | $294,581.27 | 15.8% | $55,418.73 |
| Year 2 | $24,184.42 | $4,200.00 | $1,225.00 | $1,487.50 | $31,096.92 | $3,135.33 | $21,049.09 | — | $291,445.93 | 16.7% | $58,554.07 |
| Year 3 | $24,184.42 | $4,200.00 | $1,225.00 | $1,487.50 | $31,096.92 | $3,368.01 | $20,816.41 | — | $288,077.93 | 17.7% | $61,922.07 |
| Year 4 | $24,184.42 | $4,200.00 | $1,225.00 | $1,487.50 | $31,096.92 | $3,617.95 | $20,566.47 | — | $284,459.97 | 18.7% | $65,540.03 |
| Year 5 | $24,184.42 | $4,200.00 | $1,225.00 | $1,487.50 | $31,096.92 | $3,886.44 | $20,297.98 | — | $280,573.53 | 19.8% | $69,426.47 |
| Year 6 | $24,184.42 | $4,200.00 | $1,225.00 | $123.96 | $29,733.38 | $4,174.86 | $20,009.57 | — | $276,398.68 | 21.0% | $73,601.32 |
| Year 7 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $4,484.67 | $19,699.75 | — | $271,914.00 | 22.3% | $78,086.00 |
| Year 8 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $4,817.48 | $19,366.94 | — | $267,096.52 | 23.7% | $82,903.48 |
| Year 9 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $5,174.99 | $19,009.43 | — | $261,921.53 | 25.2% | $88,078.47 |
| Year 10 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $5,559.03 | $18,625.39 | — | $256,362.49 | 26.8% | $93,637.51 |
| Year 11 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $5,971.57 | $18,212.85 | — | $250,390.92 | 28.5% | $99,609.08 |
| Year 12 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $6,414.72 | $17,769.70 | — | $243,976.20 | 30.3% | $106,023.80 |
| Year 13 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $6,890.77 | $17,293.66 | — | $237,085.43 | 32.3% | $112,914.57 |
| Year 14 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $7,402.13 | $16,782.29 | — | $229,683.30 | 34.4% | $120,316.70 |
| Year 15 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $7,951.45 | $16,232.97 | — | $221,731.85 | 36.6% | $128,268.15 |
| Year 16 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $8,541.53 | $15,642.89 | — | $213,190.32 | 39.1% | $136,809.68 |
| Year 17 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $9,175.40 | $15,009.02 | — | $204,014.92 | 41.7% | $145,985.08 |
| Year 18 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $9,856.32 | $14,328.11 | — | $194,158.60 | 44.5% | $155,841.40 |
| Year 19 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $10,587.76 | $13,596.67 | — | $183,570.84 | 47.6% | $166,429.16 |
| Year 20 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $11,373.48 | $12,810.94 | — | $172,197.36 | 50.8% | $177,802.64 |
| Year 21 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $12,217.51 | $11,966.91 | — | $159,979.85 | 54.3% | $190,020.15 |
| Year 22 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $13,124.18 | $11,060.24 | — | $146,855.66 | 58.0% | $203,144.34 |
| Year 23 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $14,098.14 | $10,086.29 | — | $132,757.53 | 62.1% | $217,242.47 |
| Year 24 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $15,144.37 | $9,040.06 | — | $117,613.16 | 66.4% | $232,386.84 |
| Year 25 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $16,268.24 | $7,916.18 | — | $101,344.92 | 71.0% | $248,655.08 |
| Year 26 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $17,475.52 | $6,708.91 | — | $83,869.40 | 76.0% | $266,130.60 |
| Year 27 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $18,772.38 | $5,412.04 | — | $65,097.02 | 81.4% | $284,902.98 |
| Year 28 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $20,165.49 | $4,018.93 | — | $44,931.52 | 87.2% | $305,068.48 |
| Year 29 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $21,661.99 | $2,522.44 | — | $23,269.54 | 93.4% | $326,730.46 |
| Year 30 | $24,184.42 | $4,200.00 | $1,225.00 | $0.00 | $29,609.42 | $23,269.54 | $914.89 | — | $0.00 | 100.0% | $350,000.00 |