How to Calculate NPV for a Real Estate Project
Learn how to calculate NPV for a real estate project: the cash flows, the discount rate, and how to read the result.
How to Calculate NPV for a Real Estate Project
Net present value, or NPV, tells you whether a real estate project is worth more than it costs, after accounting for the fact that money received in the future is worth less than money today. It turns a stream of rents, costs, and a future sale into a single number you can act on. This guide walks through the calculation step by step.
The idea behind NPV
A dollar earned in five years is worth less than a dollar today, because today's dollar can be invested in the meantime. NPV applies this by discounting every future cash flow back to its value today and summing them. If the total is positive, the project creates value above your required return. If it is negative, it destroys value.
Step one: lay out the cash flows
List every cash flow by period, usually by year. For a typical project this includes:
- The initial outflow: land, construction, and fees, recorded as a negative number at year zero. - Operating cash flows: net rental income each year after expenses. - The terminal value: the net proceeds from selling the asset at the end, recorded in the final year.
Be honest and consistent. Use the same unit, the same timing convention, and net figures after operating costs.
Step two: choose a discount rate
The discount rate reflects your required return given the project's risk. It often combines the cost of borrowing, the cost of your own equity, and a premium for the uncertainty of this particular project. A riskier development demands a higher rate. The choice matters: a small change in the rate can flip a project from attractive to unattractive.
Step three: discount each cash flow
Each future cash flow is divided by one plus the discount rate raised to the power of its period number. A cash flow in year three is divided by (1 + r) cubed. This shrinks distant cash flows more than near ones, which is exactly the point.
Step four: sum and interpret
Add all the discounted cash flows, including the negative initial investment. The result is the NPV.
- A **positive NPV** means the project returns more than your required rate. It adds value. - A **negative NPV** means it falls short of that rate. - An **NPV near zero** means it roughly meets your required return with little margin.
A simple example
Suppose you invest one million today, receive one hundred thousand per year for four years, and sell for 1.2 million in year five, with a discount rate of eight percent. You discount each inflow back to today, add them, subtract the one million, and read the sign of the result. A positive figure tells you the project clears your hurdle.
NPV does not replace judgment about location, demand, or execution, but it disciplines those judgments with numbers. Build the cash flows carefully, pick a defensible discount rate, and let the sign of the NPV tell you whether the project is worth pursuing.