Home
Investing Blog
LIST Your Property FREE
Intelligent Investing
RE Investment Math
Real Estate Books
RE Encyclopedia
Book Reviews
Real Estate Articles
Advertise with Us
Useful Links
Investment Analysis
Investment Strategies
Real Estate Cycle
Capitalization Rates
Market Data
Mortgage Financing
Megatrends
Market Watch
RE Investment Math
International Investing
Shopping Centers
Investment Process
Contact Us
Best Housing Markets

Subscribe To This Site
XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

Net Present Value

We introduced the Net Present Value (NPV) concept in the discussion of the internal rate of return (IRR), as it was defined as the discount rate that renders the NPV of the investment’s cash flows equal to zero.

As a measure of investment performance, the NPV is the present value of all cash flows associated with a commercial real estate investment over its holding period discounted at the investor’s required rate of return. These cash flows include and the initial cash outlay for acquiring the property, which includes not only the purchase price but also any other acquisition and pre-acquisition costs, such as, transfer fees, legal fees, consulting fees for evaluating the property, etc. If the NPV is greater than zero then it mean’s that the investment return exceeds the investor’s required rate of return; if it is negative then it means that the investment will provide a return lower than the required return by the investor. The formula for estimating the Net Present Value of a cash-flow stream discounted at a discount rate or required rate of return d is:

NPV = CF0 + CF1/(1+d) + CF2/(1+d)2 +...+ CFn/(1+d)n

where
CF0 = Initial cash paid for acquiring the property, including all acquisition and pre-acquisition costs
CF1 = Cash flow in period 1
CF2 = Cash flow in period 2
CFn = Cash flow in the last period of the holding period n

Notice that usually the NPV is calculated using the expected after tax cash flows of the property. Also, if there is borrowing, the debt service payments, as well as the payment of the remaining balance at the end of the holding period, need to be taken into account when calculating the cash flows for each period.

In Excel, the NPV can be calculated by typing "=NPV(Range)"where the Range includes all the cells that contain the cash flows of the property in each period of the holding period.


Example

CF0 = - 200,000
CF1 = 120,000
CF2 = 720,000
CF3 = - 150,000
Discount Rate (d) = 12%

NPV = -200,000 + 120,000/1.12 + 720,000/(1.12)2 - 150,000/(1.12)3 = -200,000 + 107,142.86 + 573,979.59 – 106,767.04 = 374,355.41

In our example, the cash flow stream has a Net Present Value significantly higher than 0 indicating that the investment’s return is considerably higher than the discount rate of 12% used, which also represents and the investor's acceptable rate of return. If the Net Present Value came out negative it would mean that the project has an expected return below the 12%.

This is an excerpt from the 51-page e-book "Real Estate Investment Mathematics".



Search Our Over 500-Page Website!
Custom Search

SMART PROPERTY INVESTING PACK
EBOOKS AND SPREADSHEETS
Download all these formulas Now!
Internal Rate of Return(IRR)
The 3 Formulas for Modified IRR (MIRR)/Financial Management Rate of Return (FMRR)
Potential Gross Income Multiplier (PGIM)
Potential Gross Income
Effective Gross Income Multiplier
Effective Gross Income
Net Income Multiplier
Net Operating Income
Overall Capitalization Rate/Income Return
Capitalization Factor
Band-of-Investment Formula for Estimating a Market/Required Capitalization Rate
Theoretical-Approach Formula for Estimating a Market/Required Capitalization Rate
Appreciation Return
Total Return
Return on Total Capital (ROR)
Return on Equity (ROE)/Cash-on-Cash Return/Equity Dividend Rate
Before Tax Equity Cash Flow (BTECF)
Equity Investment
Loan Amount
Debt Service
Mortgage Constant
Payback Period
Breakeven Occupancy
After Tax Cash Flow (ATCF)
Taxable Income
One-Period IRR
Income Tax Payment in Association with Income Producing Property
Capital Gains
Formula for Cash Flow for Last Period of Analysis
Future Resale Price
Annual Rental Income of Occupied Multi-Tenant Property
Multi-Period Lease Rate Growth Formula with Intertemporally Variable CPI Forecast
Multi-period Lease Rate Growth Formula with Constant CPI Forecast
Present Value (PV)
Net Present Value (NPV)
Profitability Index
And more …….



Related Posts
Leveraged IRR Calculation
Investment Value
Net Operating Income
Cap Rate Data Sources
Historical Cap Rate Measurement Issues
Capitalization Rate Estimation Techniques
Cap Rates and Interest Rates
Exit Cap Rate
Cap Rate Cycle
Apartment Cap Rates
Capitalization Rate Influences
Capitalization Rate Readings

Search Our Over 500-Page Website!
Custom Search




Return from Net Present Value to Investment Analysis