ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Understanding Net Present Value: Knowing Whether The Real Estate Investment Achieves Your Desired Yield!

Updated on December 24, 2017

Net present value (or NPV) is a return commonly used in real estate analysis by real estate investors because net present value reveals to the investor whether the rate of return he or she desires will be achieved and thus, whether or not the property is profitable enough for the investor to consider making the capital investment.

Specifically, net present value measures the present value of a property’s future benefits discounted by the investor’s target rate of return against the capital required to make the real estate investment.

This way the investor can make a determination about the property based upon the outcome.

When the discounted future benefits are equal to or are greater than what must be paid for those benefits, the rate of return is achieved and the investment opportunity might be worth pursuing.

When the present value of the future benefits is less than the cost for those benefits, the rate of return will not be achieved and the property might not be worth further evaluation.

NPV Benefit

The dilemma real estate investor’s face when doing a real estate analysis on rental income property is addressed by net present value.

For at the same time that projections can be made for both the capital investment amount and a property’s future cash flow benefit, that data alone says nothing about what rate of return is achieved from that property.

In other words, because the real estate investor has no knowledge of the yield, he or she has no adequate way to compare a real estate investment project to other potential investment opportunities.

In this case, net present value lets the investor plug in his or her target yield for a property and then reveals whether or not the future cash flow benefits generated by that income property will be enough to achieve that yield based on the capital required to make that investment.

NPV Formulation

The NPV result is a dollar amount that will either be a negative dollar amount, a zero dollar amount, or a positive dollar amount.

Here’s the formulation.

First, NPV arrives at the present value of all the rental property’s future benefits (i.e., cash flows) by discounting them at the real estate investor’s desired rate of return. Then it deducts that amount from the capital required to make that investment.

Formula

NPV Conceptually

Okay, let’s look at the following three examples and then make a determination about the result for each so you understand the concept.

1) Let’s assume that a rental property under evaluation requires a $100,000 investment and the present value of all future benefits discounted at 6% (your desired rate of return) is $106,362. The result would be $6,362 (106,362 – 100,000 = 6,362).

Determination: Since the discounted value of future benefits is more than the amount you must invest, your specified rate of return is met and therefore the rental property might prove to be a profitable real estate investment opportunity.

2) Say that a commercial office building you’re doing a real estate analysis on is going to take an investment of $500,000 and produces a discounted value of $500,000 for all the future benefits. The result will be $0 (500,000 – 500,000 = 0).

Determination: Because the present value of future benefits exactly equals the amount of the investment, the office building meets your desired investment yield perfectly but with no room to spare.

3) Let’s say that an apartment complex you’re analyzing is selling for $750,000 and generates a present value of all future cash flows in the amount of $745,000. The result would be -$5,000 ( 745,000 - 750,000 = -5,000).

Determination: You have a negative dollar amount revealing that your desired rate of return is not met with this specific apartment complex and perhaps you should consider moving on to another real estate investment opportunity.

Sample (example 1, above)

Source: iCalculator by ProAPOD Real Estate Investment Software
Source: iCalculator by ProAPOD Real Estate Investment Software

Sample (using Excel)

Source: MS Excel 2003
Source: MS Excel 2003

NPV Bottom-line

Of course, NPV is not without its shortcomings because it doesn’t really provide real estate investors with any useful information from a risk perspective.

In other words, NPV alone (though it helps compare properties with the same yield requirements) is not going to enable you to compare one investment opportunity to another based upon risk.

Nonetheless, net present value is certainly worth knowing and when properly used as part of a real estate analysis can help you evaluate your next real estate investment opportunity. Just bear in mind that it is just one aspect of real estate investing analysis and should not dictate your investment decision.

One final thought.

NPV is impractical to calculate simply by knowing the formula (at least for most). So it does require MS Excel, a financial calculator, or other quality real estate solution. If you are serious about real estate investing and want to include net present value in your real estate analysis presentations, however, you probably want to consider real estate investment software with net present value and printable reports.

About the Author

James Kobzeff is a real estate professional and the owner/developer of ProAPOD - leading real estate investment software solutions since 2000. Create cash flow, rates of return, and profitability analysis on rental property at your fingertips in minutes! Includes the NPV calculation.

ProAPOD also provides iCalculator - an online real estate calculator that enables you to learn dozens of real estate definitions and formulas as you calculate, including net present value. You save 64%. Learn more at real estate calculator

Comments

    0 of 8192 characters used
    Post Comment

    • jamesrk profile imageAUTHOR

      James Kobzeff 

      5 years ago from Salem, Oregon

      Please explain.

    • profile image

      andy 

      5 years ago

      your math seeems wrong

    • Mike_RealEstate profile image

      Mike_RealEstate 

      8 years ago from CA

      Very useful information, thanks. Visit me back please and let's keep in touch.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)