Future Home Equity Calculator
Test cases replayed : 3 of 3 match · Methodology · No outside source listed
Enter today's home value, the yearly appreciation you want to assume, your mortgage balance, rate and remaining term, and how many years ahead to look. Equity grows from both sides: the home's value and the principal you repay.
Result
Projected home equity
Projected home value
- Projected mortgage balance
- Equity as a share of the home value
- Equity gained over the period
- Monthly principal and interest payment
Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Home value today, in dollars: enter 0 or more.
- Assumed home value change, in % / year: enter a number from -20 to 20.
- Mortgage balance today, in dollars: enter 0 or more.
- Mortgage interest rate, in % / year: enter a number from 0 to 25.
- Years left on the mortgage: enter a number from 1 to 40.
- Years from now: enter a number from 0 to 40.
- Read the result: Projected home equity; the panel also shows Projected home value, Projected mortgage balance, Equity as a share of the home value, Equity gained over the period and Monthly principal and interest payment.
How this calculator works
Future value = today's value × (1 + appreciation ÷ 100)^years. The appreciation rate is your assumption: no one can know future home prices, so try a low, a middle and a high rate.
Monthly payment = B × r × (1 + r)^n ÷ ((1 + r)^n − 1), with B the balance, r the yearly rate ÷ 12 and n the months left (standard amortization). Balance after k payments = B × (1 + r)^k − payment × ((1 + r)^k − 1) ÷ r; it reaches 0 when the loan is paid off.
Equity = future value − future balance. Equity gained = future equity − today's equity (value − balance). Extra principal payments, a second mortgage or a HELOC, and selling costs are not included.
The formula
| Symbol | Meaning | Unit |
|---|---|---|
| Home value today | $ | |
| Assumed home value change | % / year | |
| Mortgage balance today | $ | |
| Mortgage interest rate | % / year | |
| Years left on the mortgage | ||
| Years from now | ||
| Result of step 1 | ||
| Result of step 2 | ||
| Monthly principal and interest payment | $ | |
| Result of step 4 | ||
| Projected mortgage balance | $ | |
| Projected home value | $ | |
| Projected home equity | $ | |
pmt(P, r, n) | the payment per period that repays P over n periods at rate r per period, or P ÷ n when r is zero. | |
min(a, b, …) | the smallest of the values. | |
max(a, b, …) | the largest of the values. |
Worked example
| Home value today | $400,000 |
|---|---|
| Assumed home value change | 3 % / year |
| Mortgage balance today | $280,000 |
| Mortgage interest rate | 6.5 % / year |
| Years left on the mortgage | 25 |
| Years from now | 5 |
| Monthly principal and interest payment | $1,890.58 |
|---|---|
| Projected home value | $463,710 |
| Projected mortgage balance | $253,574 |
| Equity as a share of the home value | 45.32% |
| Equity gained over the period | $90,136 |
Projected home equity $210,136
Each step uses the unrounded value of the step before it; figures on this page are rounded for display.
Frequently asked questions
What appreciation rate should I use?
There is no official forecast for one house. Look at past price changes in your area, then test several rates, including 0% and a negative one, to see the range of outcomes.
Why does my equity grow even with 0% appreciation?
Each monthly payment repays some principal, so the balance falls and your equity rises by the same amount.
Can I borrow against the projected equity?
Lenders lend against the value appraised at the time you apply, not a projection, and usually keep part of the equity unborrowed.