PMI Removal Calculator & Home Equity Tracker: When Can I Drop PMI? (Excel + Google Sheets)

Paying PMI on a conventional loan? You don't have to pay it forever. This tracker shows when your balance reaches 80% of your home's original value (when you can usually ask your servicer to cancel PMI) and 78% (when it usually ends on its own), plus how extra principal moves those dates closer.

What it shows you

• Your 80% and 78% loan balance targets and the dates you hit them

• How much PMI you could skip by asking at 80% instead of waiting

• Your loan-to-value on the original value and on today's estimated value

• Extra principal needed today to reach 80%

• Home equity today and year by year, with a chart

• An Equity Log to record your balance and home value estimates over time

Instant download, one .xlsx file. Works in Excel, Google Sheets and LibreOffice. The example rate is example only, not a quote. Rules depend on your loan type and servicer; use this to plan, then confirm with your servicer.

Educational tool only. Not a loan offer, rate quote, or financial advice.

Aaron Clark, Licensed Mortgage Loan Officer, NMLS #1770738 · www.nmlsconsumeraccess.org · Equal Housing Opportunity