2026.6666666666667
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
6.69% Fixed Rate • 30-year term
Equity Milestones
20% Equity Reached
Payment #58
June 2031
PMI Removal: You can request removal of PMI (Private Mortgage Insurance) around payment #58 (June 2031), 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 | $23,012.75 | $4,200.00 | $1,225.00 | $1,487.50 | $29,925.25 | $3,207.15 | $19,805.60 | — | $294,292.85 | 15.9% | $55,707.15 |
| Year 2 | $23,012.75 | $4,200.00 | $1,225.00 | $1,487.50 | $29,925.25 | $3,428.41 | $19,584.33 | — | $290,864.43 | 16.9% | $59,135.57 |
| Year 3 | $23,012.75 | $4,200.00 | $1,225.00 | $1,487.50 | $29,925.25 | $3,664.94 | $19,347.81 | — | $287,199.49 | 17.9% | $62,800.51 |
| Year 4 | $23,012.75 | $4,200.00 | $1,225.00 | $1,487.50 | $29,925.25 | $3,917.78 | $19,094.96 | — | $283,281.71 | 19.1% | $66,718.29 |
| Year 5 | $23,012.75 | $4,200.00 | $1,225.00 | $1,115.63 | $29,553.37 | $4,188.07 | $18,824.68 | — | $279,093.64 | 20.3% | $70,906.36 |
| Year 6 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $4,477.01 | $18,535.74 | — | $274,616.63 | 21.5% | $75,383.37 |
| Year 7 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $4,785.88 | $18,226.87 | — | $269,830.75 | 22.9% | $80,169.25 |
| Year 8 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $5,116.05 | $17,896.70 | — | $264,714.70 | 24.4% | $85,285.30 |
| Year 9 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $5,469.01 | $17,543.74 | — | $259,245.69 | 25.9% | $90,754.31 |
| Year 10 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $5,846.31 | $17,166.43 | — | $253,399.38 | 27.6% | $96,600.62 |
| Year 11 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $6,249.65 | $16,763.10 | — | $247,149.73 | 29.4% | $102,850.27 |
| Year 12 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $6,680.81 | $16,331.93 | — | $240,468.91 | 31.3% | $109,531.09 |
| Year 13 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $7,141.72 | $15,871.02 | — | $233,327.19 | 33.3% | $116,672.81 |
| Year 14 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $7,634.43 | $15,378.32 | — | $225,692.76 | 35.5% | $124,307.24 |
| Year 15 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $8,161.13 | $14,851.62 | — | $217,531.63 | 37.8% | $132,468.37 |
| Year 16 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $8,724.16 | $14,288.58 | — | $208,807.47 | 40.3% | $141,192.53 |
| Year 17 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $9,326.04 | $13,686.70 | — | $199,481.42 | 43.0% | $150,518.58 |
| Year 18 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $9,969.45 | $13,043.30 | — | $189,511.97 | 45.9% | $160,488.03 |
| Year 19 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $10,657.24 | $12,355.51 | — | $178,854.74 | 48.9% | $171,145.26 |
| Year 20 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $11,392.48 | $11,620.27 | — | $167,462.26 | 52.2% | $182,537.74 |
| Year 21 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $12,178.45 | $10,834.30 | — | $155,283.81 | 55.6% | $194,716.19 |
| Year 22 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $13,018.64 | $9,994.11 | — | $142,265.17 | 59.4% | $207,734.83 |
| Year 23 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $13,916.79 | $9,095.96 | — | $128,348.38 | 63.3% | $221,651.62 |
| Year 24 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $14,876.91 | $8,135.84 | — | $113,471.47 | 67.6% | $236,528.53 |
| Year 25 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $15,903.27 | $7,109.48 | — | $97,568.20 | 72.1% | $252,431.80 |
| Year 26 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $17,000.43 | $6,012.32 | — | $80,567.77 | 77.0% | $269,432.23 |
| Year 27 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $18,173.29 | $4,839.46 | — | $62,394.48 | 82.2% | $287,605.52 |
| Year 28 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $19,427.07 | $3,585.68 | — | $42,967.41 | 87.7% | $307,032.59 |
| Year 29 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $20,767.34 | $2,245.41 | — | $22,200.07 | 93.7% | $327,799.93 |
| Year 30 | $23,012.75 | $4,200.00 | $1,225.00 | $0.00 | $28,437.75 | $22,200.07 | $812.67 | — | $0.00 | 100.0% | $350,000.00 |