2026.75
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.71% Fixed Rate • 30-year term
Equity Milestones
20% Equity Reached
Payment #58
July 2031
PMI Removal: You can request removal of PMI (Private Mortgage Insurance) around payment #58 (July 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,060.11 | $4,200.00 | $1,225.00 | $1,487.50 | $29,972.61 | $3,194.93 | $19,865.18 | — | $294,305.07 | 15.9% | $55,694.93 |
| Year 2 | $23,060.11 | $4,200.00 | $1,225.00 | $1,487.50 | $29,972.61 | $3,416.03 | $19,644.08 | — | $290,889.04 | 16.9% | $59,110.96 |
| Year 3 | $23,060.11 | $4,200.00 | $1,225.00 | $1,487.50 | $29,972.61 | $3,652.43 | $19,407.68 | — | $287,236.62 | 17.9% | $62,763.38 |
| Year 4 | $23,060.11 | $4,200.00 | $1,225.00 | $1,487.50 | $29,972.61 | $3,905.18 | $19,154.93 | — | $283,331.44 | 19.0% | $66,668.56 |
| Year 5 | $23,060.11 | $4,200.00 | $1,225.00 | $1,115.63 | $29,600.73 | $4,175.43 | $18,884.68 | — | $279,156.01 | 20.2% | $70,843.99 |
| Year 6 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $4,464.38 | $18,595.73 | — | $274,691.62 | 21.5% | $75,308.38 |
| Year 7 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $4,773.33 | $18,286.78 | — | $269,918.30 | 22.9% | $80,081.70 |
| Year 8 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $5,103.65 | $17,956.46 | — | $264,814.64 | 24.3% | $85,185.36 |
| Year 9 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $5,456.84 | $17,603.27 | — | $259,357.80 | 25.9% | $90,642.20 |
| Year 10 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $5,834.47 | $17,225.64 | — | $253,523.33 | 27.6% | $96,476.67 |
| Year 11 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $6,238.23 | $16,821.88 | — | $247,285.11 | 29.3% | $102,714.89 |
| Year 12 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $6,669.93 | $16,390.18 | — | $240,615.18 | 31.3% | $109,384.82 |
| Year 13 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $7,131.50 | $15,928.60 | — | $233,483.67 | 33.3% | $116,516.33 |
| Year 14 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $7,625.02 | $15,435.09 | — | $225,858.65 | 35.5% | $124,141.35 |
| Year 15 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $8,152.69 | $14,907.42 | — | $217,705.95 | 37.8% | $132,294.05 |
| Year 16 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $8,716.88 | $14,343.23 | — | $208,989.07 | 40.3% | $141,010.93 |
| Year 17 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $9,320.11 | $13,740.00 | — | $199,668.96 | 43.0% | $150,331.04 |
| Year 18 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $9,965.09 | $13,095.02 | — | $189,703.87 | 45.8% | $160,296.13 |
| Year 19 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $10,654.70 | $12,405.41 | — | $179,049.18 | 48.8% | $170,950.82 |
| Year 20 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $11,392.03 | $11,668.08 | — | $167,657.15 | 52.1% | $182,342.85 |
| Year 21 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $12,180.39 | $10,879.72 | — | $155,476.76 | 55.6% | $194,523.24 |
| Year 22 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $13,023.30 | $10,036.81 | — | $142,453.46 | 59.3% | $207,546.54 |
| Year 23 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $13,924.55 | $9,135.56 | — | $128,528.91 | 63.3% | $221,471.09 |
| Year 24 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $14,888.16 | $8,171.95 | — | $113,640.75 | 67.5% | $236,359.25 |
| Year 25 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $15,918.46 | $7,141.65 | — | $97,722.29 | 72.1% | $252,277.71 |
| Year 26 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $17,020.06 | $6,040.05 | — | $80,702.23 | 76.9% | $269,297.77 |
| Year 27 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $18,197.89 | $4,862.22 | — | $62,504.34 | 82.1% | $287,495.66 |
| Year 28 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $19,457.23 | $3,602.88 | — | $43,047.11 | 87.7% | $306,952.89 |
| Year 29 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $20,803.72 | $2,256.39 | — | $22,243.39 | 93.6% | $327,756.61 |
| Year 30 | $23,060.11 | $4,200.00 | $1,225.00 | $0.00 | $28,485.11 | $22,243.39 | $816.72 | — | $0.00 | 100.0% | $350,000.00 |