Home Appreciation Calculator: Future Value and Rate
How much will my house be worth in 5 or 10 years? Pick the future value, the yearly appreciation rate between two prices, or the doubling time, and enter the values you know. Appreciation is compounded yearly.
Updated
Report a problem
Formula
- Future value:
V = P × (1 + r)^t, withrthe yearly rate as a decimal andtthe years. - Annual rate from two prices:
r = (V ÷ P)^(1 ÷ t) - 1. - Doubling time:
t = ln 2 ÷ ln(1 + r), shown as 0 if the value is not growing. - Total gain:
V - P, and as a percent(V - P) ÷ P × 100.
Worked example
- A home worth 300,000 at 4% a year for 10 years:
300,000 × 1.04^10 =444,073.29. - A home that went from 300,000 to 450,000 in 10 years:
(1.5)^(1/10) - 1 =4.14% a year. - At 7% a year the value doubles in
ln 2 ÷ ln 1.07 =10.2 years.
When to use it
Use this page for what-if projections of a home's price, or to measure how fast a past price grew. For the equity you hold after a rise, use the home equity calculator. For a general growth rate between any two values, the CAGR calculator does the same maths.
Second example
A home worth 275,000 that sold at 340,000 six years later grew (340,000 ÷ 275,000)^(1/6) - 1 = 3.60% a year, a total gain of 65,000 (23.6%).
Common mistakes
- Treating an assumed rate as a forecast. Prices rise and fall.
- Using nominal prices to judge real growth; inflation matters.
- Ignoring improvements, which raise the value but also the cost.
- Dividing total growth by the years instead of compounding.
Frequently asked questions
How do I calculate future home value?
Multiply today's value by (1 + rate) once for each year. A 300,000 home at 4% a year for 10 years is 300,000 × 1.04^10 = 444,073.29, a gain of 144,073.29 or 48%.
How do I find the annual appreciation rate from two prices?
Use rate = (later price ÷ earlier price)^(1 ÷ years) - 1. A home bought for 300,000 and worth 450,000 ten years later grew (1.5)^(0.1) - 1 = 4.14% a year.
How long until my home value doubles?
Doubling time is ln 2 ÷ ln(1 + rate). At 7% a year it is 10.2 years, and at 4% it is 17.7 years. The rule of 72 gives a quick estimate: 72 ÷ 7 is about 10.3.
Can I rely on a future value as a forecast?
No. Home prices rise and fall, and the rate you enter is an assumption, not a prediction. The result is a what-if figure and does not include costs, improvements or taxes.
How much will a 400,000 home be worth in 5 years at 3% appreciation?
It will be worth 400,000 × 1.03^5 = 463,709.63, a gain of 63,709.63 or 15.9%. At 2% it would be 441,632.32 and at 4% it would be 486,661.16, which shows how sensitive long projections are to the rate you assume.
How do I calculate appreciation in Excel?
For a future value use =start*(1+rate)^years, such as =400000*(1+3%)^5. To find the annual rate between two prices use =(end/start)^(1/years)-1. A home bought at 275,000 and worth 340,000 six years later has grown 3.60% a year.
What is the difference between appreciation and total return?
Appreciation is only the change in price. Total return on a home also includes rent saved or earned, and costs such as taxes, repairs and interest, so a 3.6% appreciation rate does not mean a 3.6% return on your money.