In commercial real estate finance, the Net Present Value (NPV) of a time series of cash flows, both incoming and outgoing, is defined as the sum of the Present Values of the individual cash flows of the same property.
NPV is a central tool in Discounted Cash Flow ("DCF") analysis and is a standard method for using the time value of money to analyze long-term projects. Used for capital budgeting and widely used throughout economics, finance, and accounting, NPV measures the excess or shortfall of cash flows, in present value terms, above the cost of funds.
Each cash inflow/outflow is discounted back to its Present Value, then they are summed.
I = the period's net cash flow
r = the discount rate
n = the period of the net cash flow
By calculating the NPV of a set of cash flows, investors are able to carefully value any property.
Let's look at an example. Let's assume we're underwriting an investment property which is expected to generate $10,000 per year for the next 10 years. At the end of this 10-year period, we project we can sell the property for $100,000.
As an investor, for this type of investment, we target an 8.0% return on our investment. This targeted return is "r" or the "Discount Rate" within the NPV formula. By discounting these cash flows by 8.0%, we are able calculate the price we are willing to pay for the property.
In this instance the sum of the 10 years of cash flow from this property totals $200,000. The sum of the discounted the cash flows at a rate of 8.0% equals $113,420. This figure represents the price we should be willing to pay for this property, so that we are able to realize a return of 8.0%.
Our Net Present Value Calculator uses the steps outlined above to calculate the Net Present Value of investment property.
Is it better to own or lease?
This Excel template allows anyone to quickly compare leasing verses owning any office, retail or industrial building.
powered by LeaseMatrix