Worked example
Start with Price today of $400,000, Price growth per year of 3%, Loan today of $340,000, Rate of 6.5%, 7 years from now, and 30 original term, years. Equity if price growth holds is $184,534. The breakdown is Future price of $491,950 and Loan balance then of $307,415. Selling costs are not deducted. Growth is an input.
How this number is made
Future equity is a future price minus a future loan balance. Both depend on assumptions: the price growth you type, and on-time payments with no extras.
- Original term is the term the payment was built on, so the balance formula knows the payment.
- Years from now cannot exceed the term.
Formula
Future price = price × (1 + growth) ^ years. Equity = future price − scheduled balance.
Questions
What if I sell?
Commission and repairs come out of this equity. They are not subtracted here.
What if prices fall?
Type a negative growth rate. Equity can be smaller than the down payment you remember.