• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

PropertyMetrics

  • Home
  • Blog
  • Products
    • Proforma Software
    • Publisher Software
    • Courses
  • Sign In
    • Software Login
    • Courses Login
  • Contact Us
  • Build a Proforma

Last Updated on March 13, 2014 By Robert Schmidt 55 Comments

Intuition Behind IRR and NPV

What’s the intuition behind Internal Rate of Return (IRR) and Net Present Value (NPV)? Discounted cash flow analysis is an essential tool in the commercial real estate practitioner’s toolbelt, but unfortunately for many people, there is still a lot of mystery surrounding this concept.

First of all let’s get some definitions out of the way and then we’ll walk through an example.

Internal rate of return (IRR) for an investment is the percentage rate earned on each dollar invested for each period it is invested. IRR is also another term people use for interest. Ultimately, IRR gives an investor the means to compare alternative investments based on their yield.

Net present value (NPV) is an investment measure that tells an investor whether the investment is achieving a target yield at a given initial investment. NPV also quantifies the adjustment to the initial investment needed to achieve the target yield assuming everything else remains the same.

What does all this mean? Consider the following discounted cash flow analysis for a small office building:

NPV IRR Example

The IRR is simply the rate of return an investor would expect to achieve on this property, given its projected cash flows over the holding period. In this case it would be 7.51% without leverage and 10.71% with debt added to the property.

The NPV, on the other hand, depends on the discount rate, which in this case is 12.00%. What is a discount rate? The discount rate is simply the investor’s desired rate of return. Normally the discount rate used is the investor’s opportunity cost of capital or, in the case of an institutional investor, the weighted average cost of capital.

What the NPV tells us is how far off the mark we are from the investor’s desired rate of return. In this case, the NPV is ($50,225) in the levered example and ($402,421) in the unlevered example. This means that in order to achieve our desired 12.00% return we’d have to reduce our initial investment in the property (acquisition price, fees, etc.) by $50,225 or $402,421, depending on whether or not we place debt on the property.

Notice that the IRR calculated above told us the return on our projected cash flows was 10.71% (levered) and 7.51% (unlevered). So, intuitively, we’d expect to reduce our initial cash outlay in order to improve our rate of return. The NPV simply quantifies how much we need to adjust our initial investment in order to achieve our target yield.

Filed Under: Articles

Reader Interactions

Comments

  1. mo says

    May 20, 2013 at 9:20 pm

    I don’t think this is right

    Reply
  2. Shane says

    June 1, 2013 at 2:09 am

    Could you define “Levered” and “Unlevered” better? I am guessing that “Levered” is leveraged using an interest bearing loan of some sort and “Unlevered” is Cash Equity 100% down.

    When I google the terms it comes up with “levered and unlevered betas” and basic methods for evaluating companies to make sure they are solvent minus the capitalization structure.

    I could not find much information on it in regards to Commercial Real-estate specific evaluations.

    Reply
    • Shane says

      June 1, 2013 at 2:13 am

      Excellent article by the way. Other than my ability to fully understand Levered vs. Unlevered. I can see how it would be useful.

      Reply
      • Wm says

        February 9, 2017 at 4:33 pm

        More to the point, whenever we can borrow money at an interest rate lower than the rate of return on an investment we are encouraged to borrow the money. After all, if we can borrow at 5% and invest it for a 10% rate of return we are making money on other peoples’ money. This often referred to as “positive leverage” (the British may call it “positive gearing” evoking the imagery or ratcheting up returns on invested capital).

        Conversely, if we can borrower money at an interest rate higher than the rate of return on an investment we are discouraged from borrowing the money. After all, if we can borrow at 10% and invest it for a 5% return we would be losing money on other peoples’ money. A process often referred to as “Negative Leverage.”

        Conclusion, make money on other peoples’ money when you can but know that returns on an investment can vary over time. What begins as positive leverage can quickly morph into negative leverage in a down market where rents are falling and/or operating expenses and/or vacancies are rising.

        Reply
    • Rob says

      June 1, 2013 at 10:16 am

      Hi Shane,

      Levered means that you are using debt to finance your acquisition. Unlevered means that you are not using any debt. Using debt is leverage in that it can improve the return your receive on the cash you have invested. On the other hand, leverage also increases the downside risk should the project not work out as planned.

      Reply
  3. Steve says

    July 18, 2013 at 2:14 am

    Great article, simple and to the point!

    Reply
  4. Tara Piantanida-Kelly says

    October 13, 2013 at 3:42 pm

    I’m still trying to wrap my head around this. In the example above, is the property purchased for $1,515,000 initially (with $515,000 cash in and a $1,000,000 mortgage for the levered side and all cash for the unlevered side)? And then sold after a 10-year holding period for $1,823,915? And are the EOY increments showing the projected cash flow (NOI – debt service) for each year?

    Reply
    • Rob says

      October 15, 2013 at 11:42 am

      Hi Tara, yes that is correct. The levered example is with debt service and the unlevered example is without any debt on the property. The dollar figures for each year are the cash flow before tax numbers determined on the proforma.

      Reply
      • Kevin says

        December 10, 2015 at 10:08 pm

        graet article. Is the property sold for the same price in lvered and unlevered? this confuses me a bit

        Reply
        • Robby says

          December 21, 2015 at 8:07 pm

          Yes it’s sold for the same price, but the net proceeds are less in the levered example because you have to pay off the loan balance.

          Reply
  5. Arkansas_Red says

    December 11, 2013 at 7:06 pm

    Is there a “rule of thumb” discount rate that people use for quick analysis?

    Reply
    • Rob says

      December 15, 2013 at 4:46 pm

      For an individual investor the discount rate is usually the investor’s required rate of return.

      Reply
  6. Arkansas_Red says

    January 2, 2014 at 2:47 pm

    So, what would you do if you were deciding to purchase a property with “Bridgewater Industrial” numbers? Would you only purchase the property if you could reduce the price by either $50,225 or $402,421 (for levered or unlevered, respectively)?

    Reply
    • Rob says

      January 3, 2014 at 8:52 pm

      As always, it depends. If I had alternative investments I could make with my capital that would yield 12% (my discount rate), then I’d probably look closer at those alternatives. On the other hand, I may be willing to accept a lower return in exchange for some other benefit, such as a solid credit tenant. It really depends on your own investment objectives, time horizon, available alternatives, etc. IRR and NPV are tools that allow you to quantify and compare potential investments, but the decision ultimately comes down to what you want to achieve.

      Reply
      • Arkansas_Red says

        January 4, 2014 at 7:52 pm

        Thanks – this is a good blog 🙂

        Reply
  7. Arkansas_Red says

    January 2, 2014 at 2:50 pm

    And one other question:

    1. The firm that I work for likes to hold on to its properties forever — meaning: they don’t really consider a holding period or disposition. Instead, they simply apply a cap rate to the NOI (along with other mundane things like location, location, and location). What’s wrong with doing that? What do you miss out by not doing a discounted cash flow?

    Reply
    • Rob says

      January 3, 2014 at 8:56 pm

      When properly applied to a stabilized NOI projection, the simple cap rate can produce a valuation approximately equal to what could be generated using a more complex DCF analysis. However, if the property’s net operating income stream is complex and irregular, with substantial variations in cash flow, only a full DCF analysis will yield a credible and reliable valuation. More on the cap rate here:

      http://www.propertymetrics.com/blog/cap-rate/

      Reply
  8. Andrew says

    March 28, 2014 at 6:50 pm

    Nice article, but I’m confused.

    You state:

    “The discount rate is simply the investor’s desired rate of return. Normally the discount rate used is the investor’s opportunity cost of capital or, in the case of an institutional investor, the weighted average cost of capital.”

    However I seem to be missing something. If my cost of capital (loan) is 12%, and my desired rate of return is 12%, I have made zero profit. Shouldn’t my desired rate of return be greater than my cost of capital?

    In other words, if I borrow the full amount of the purchase price at 12% (call it $1 to keep the math simple), then at the end of 1 year I will owe $1.12. Clearly I need to earn greater than $1.12 to make a profit, otherwise I have merely broken even. So what am I not understanding? Thank you

    Reply
    • Rob says

      March 30, 2014 at 1:36 pm

      Assuming you are approaching the discount rate through the lens the the weighted average cost of capital (WACC), then any investment that the company makes must at least achieve your 12% return in order to satisfy debt and equity investors. Any return greater than 12% will create additional value for the shareholders.

      In practice your capital structure will include some equity component (not 100% debt like your example). If your property was financed 100% by debt investors and 0% by equity investors, then that means you don’t require any return to equity investors. This scenario seems unlikely.

      Reply
    • mike says

      December 12, 2014 at 12:48 am

      Wait, you are getting confused Andrew. OPPORTUNITY cost of capital (discount rate) is NOT the cost of borrowed funds (e.g., mortgage interest rate).The opportunity cost of capital (discount rate) is the rate you could expect to earn from similar investments of similar risk. Your understanding of the opportunity cost of capital was confusing you.

      Reply
  9. herkshire says

    March 29, 2014 at 10:16 am

    Hi Rob, in order to calculate the IRR, do I need to discount the cash flows back to today first?

    Reply
    • Rob says

      March 30, 2014 at 1:49 pm

      Yes. IRR is determined through a process of trial and error by trying different discount rates, checking the resulting NPV, and then iterating until NPV is 0.

      Reply
      • herkshire says

        March 30, 2014 at 2:06 pm

        Hi Rob, thanks for helping. Perhaps I should clarify my question. Let’s say my initial cash outflow is -$100, & my cash inflow at the end of years 1-5 is $100. In order to calculate the IRR, would I simply solve the equation:

        0 = -100 + 100/r + 100/r2 + 100/r3 + 100/r4 + 100/r5 ???

        Or would I need to discount the cash flows first by the WACC, and then solve the equation for the IRR??? i.e.

        0 = -100 + 100/r + 98/r + 96/r + 94/r + 92/r

        And from the above follows, do I need a discount rate before I calculate the IRR?

        Hope that makes sense…

        Thanks for your time.

        Reply
        • Rob says

          March 30, 2014 at 3:33 pm

          The IRR is the interest rate that makes the NPV zero.

          You wouldn’t discount the cash flows by the WACC and then try to solve for IRR. This would be assuming what you are trying to solve, which wouldn’t make sense.

          You could discount the cash flows by your WACC, check what the resulting NPV is, then adjust the discount rate rate up or down until you can make the NPV equal zero. Once you do this you will have found your IRR through a process of trial and error.

          Reply
      • mike says

        December 12, 2014 at 6:18 am

        I am not sure I agree. I think the answer is no. if you want to calculate the IRR in excel you simply put in the formula =IRR(-100,100,100,100,100,100,.1) and you will get your IRR which comes out to IRR = 97%. (best investment ever lol). and then you can put in the formula =NPV(.97,100,100,100,100,100)-100 and you will get NPV=0.

        In short, the answer to your question is NO you do not need to discount the cash flows back to today first. All you gotta do is use the IRR formula in excel. And you can check yourself by putting in the IRR you just got as the discount rate when using the NPV formula and it will come out to 0.

        Reply
      • mohdaman says

        April 21, 2015 at 2:35 am

        Based on the IRR rule,an investment is acceptable if the IRR exceeds the required rate return.It should be rejected otherwise.

        Reply
  10. Mike says

    April 3, 2014 at 3:26 am

    IRR must be > Cost of Capital or WACC (if it comes from debt and equity), and NPV must be at least positive or > 0 to make that project feasible.

    Reply
    • mohdaman says

      April 21, 2015 at 2:31 am

      IRR,its the discount rate that makes the NPV of investment zero.Its internal rate that only depends on the cash flows of particular investment,not on rates offered elsewhere.
      NPV,signifies the difference between an investment’s market value and its initial outlay investment cost.Means how much value is created by undertaking an investment by discounted its future cash flow at the appropriate cost of capital(discount rate)

      Reply
      • Kevin says

        December 10, 2015 at 10:42 pm

        sorry but based on what you say is this statement true

        If the IRR is greater than the cost of capital, accept the project. If the IRR is less than the cost of capital, reject the project.

        would appreciate if you could clarify.

        e.g. this silly example in excel =IRR(-100,100,100,100,100,100,.1) and you will get your IRR which comes out to IRR = 97%. Therefore as long as 97% is greater than cost of capital it is acceptable?

        Reply
  11. Mike says

    April 3, 2014 at 3:36 am

    hi Rob, if we assume at the end of year 10 the company will sell the asset (tangible (fixed asset) and intangible ( the business) as also), how to estimate the salvage value (terminal value) from our asset to be added in the last cash flow to be discounted back to today ? thanks.

    Reply
    • Rob says

      April 9, 2014 at 2:33 pm

      For the real estate you can estimate sale price based on a terminal cap rate or by simply applying an annual rate of appreciation to the purchase price. With owner-occupied real estate the building value would likely be based on a third-party appraisal, which would be separate from the value of the business based on free cash flow.

      Reply
  12. Chris Adkins says

    July 30, 2014 at 11:06 am

    Hi Rob,
    Thanks for the article it was to the point and spot on from other articles I have read about IRR and NPV.
    Cheers,
    Chris

    Reply
    • mohdaman says

      April 21, 2015 at 2:16 am

      NPV is the current value of future cash flows discounted at rhe appropriate discount rate.

      Reply
  13. Michael says

    October 20, 2014 at 4:03 pm

    Why would do you use the same discount rate for levered and unlevered cash flow? Shouldn’t we use different rates?

    Reply
    • Rob says

      November 2, 2014 at 4:01 pm

      If you require a higher rate of return to compensate for the additional risk when using leverage, then yes, you would increase your discount rate. Also, keep in mind that as long as it’s a positive leverage situation your IRR will also increase when using debt.

      Reply
      • Yazan says

        February 19, 2017 at 11:44 am

        To my knowledge debt should reduce your overall cost of capital. Equity is generally more expensive than debt and carries more risk than debt.

        Reply
    • Bob says

      August 7, 2016 at 3:11 am

      The additional cost of capital (for leverage) is already included in the cash flow calculations.

      Reply
  14. Yvonne says

    February 23, 2015 at 12:54 pm

    I wish i can understand the importance of using the IRR if we have already the NPV which i found more strong in decision making. Does the IRR really matter? it’s calculation i found it funny. If possible please make me understand the necessity of IRR in project decision making…

    Reply
    • malourdes barangan says

      October 21, 2016 at 3:45 am

      I think it is important. To compare it with the discount rate that you used to get the NPV. If the IRR is lesser than the discount rate it ‘s not ideal.. Thats my opinion, correct me if I’m wrong.

      Reply
  15. Mat Tallon says

    March 24, 2015 at 4:18 pm

    Great article. I have 2 questions which have been nagging me for a few weeks!
    Am I correct in thinking that the following rules apply in validating a project:

    Project gets green light if:
    Unlevered IRR > WACC (becasue neither cost of equity or debt are factored into cash flows)
    Levered IRR > cost of equity (because cost of debt is already factored in cash flows)

    Assuming above rules are correct, should I be able to derive levered IRR if I know unlevered IRR and cost of debt?

    Reply
  16. P says

    September 8, 2015 at 4:53 pm

    Hi there, how can we derive unlevered IRR from a levered IRR? I have the cost of debt, the debt-equity ratio and the levered IRR. Many thanks

    Reply
  17. Frank says

    November 18, 2015 at 8:11 am

    Hi, I’m not sure if I’m being stupid but using the figures above I get an NPV of (39,513) using excel?

    Reply
  18. Kevin says

    December 11, 2015 at 2:09 am

    maybe this is my lack of understanding in terminology but I would appreciate if you could clarify

    With this silly example in excel =IRR(-100,100,100,100,100,100,.1) and you will get your IRR which comes out to IRR = 97%.

    Am I right to say:
    97% is the IRR (and this makes the npv=0)?
    is this 97% the actual return to the investor using discount cash flow?
    In other words is it the same as spending 100 in year 1 and then getting 197 back in year 2, effectively giving you 97% return?

    IRR does not take into account interest rates for borrowing, would this have to be factored in somewhere else? Or does IRR just look at unleveraged examples?

    Reply
    • Robby says

      December 21, 2015 at 9:05 pm

      You are correct in that it’s the discount rate that sets the NPV equal to 0. However, the IRR isn’t always a rate of return on the initial investment amount. It only measures the return on what remains in the investment, which can change if there are interim cash flows (or interim equity injections). Take a look at this article for a more detailed explanation of IRR:

      http://www.propertymetrics.com/blog/what-is-irr/

      Also, in terms of leverage, this would change the cash flows, which would in turn change the inputs into the IRR calculation. But, the IRR math itself wouldn’t change.

      Reply
  19. Bandit says

    December 22, 2015 at 2:49 pm

    I read through the myriad discussions pertaining to IRR and NPV. Happy to stick with mathematics and physics. Business math always confused me. Too many interpretations.

    Reply
  20. Brent Wheeler says

    February 7, 2016 at 11:25 pm

    Useful article thanks… scanning the comments two fundamentals stand out as not being totally understood:
    1. Required return and WACC or cost of capital involve “opportunity cost”… the alternative comparable (including risk) investment. What is being given up by investing in “this”. Crucial.
    2. When using debt there is still no free lunch. A bit of debt may bring down WACC but it drives up equity risk (and thus cost) – its all wonderfully symmetrical.

    Reply
  21. Mauricio says

    February 18, 2016 at 3:29 am

    For the following exercise, complete the calculations below. Evaluate different capital investment appraisal techniques by completing the calculations shown below:

    Bongo Ltd. is considering the selection of one of two mutually exclusive projects. Both would involve purchasing machinery with an estimated useful life of 5 years.

    Project 1 would generate annual cash flows (receipts less payments) of £200,000; the machinery would cost £556,000 with a scrap value of £56,000.

    Project 2 would generate cash flows of £500,000 per annum; the machinery would cost £1,616,000 with a scrap value of £301,000.

    Bongo uses straight-line depreciation. Its cost of capital is 15% per annum.

    Assume that all cash flows arise on the anniversaries of the initial outlay, that there are no price changes over the project lives, and that accepting either project will have no impact on working capital requirements.

    Assess the choice using the following methods by completing the calculations shown below:

    ARR?

    NPV?

    IRR?

    Payback period?

    Reply
  22. Toussaint says

    February 25, 2016 at 1:39 am

    How does weighted average cost of capital work when debt is being used and the debt has partial interest only features? Would you use the interest rate of the debt or a weighted mortgage constant (e.g. 7 year debt with 2 years IO @ 4% but a fully amortizing mortgage of 5.6 for the remaining 5 years)?

    Reply
  23. Stan Lake says

    June 2, 2016 at 11:42 pm

    I was looking for a way to figure out the true cost of a Merchant Cash Advance.

    The NPV formula explanation is helpful – and now I see why I kept getting the wrong answers in previous attempts to use it!

    That being said, the NPV formula doesn’t seem to be the proper tool to figure the actual cost of the loan offer that my friend is considering.

    The face amount of the agreement is $500,500 (minus a $500 handling fee)
    The daily payment (21 per month) is $2,581.94
    The total contract amount is for $650,648.88

    It seems I should be able to plug the data into a formula to solve for APR, but my poor addled brain is too many years from grad school to remember which one!

    Another piece of information – the agreement calls for 4% of sales up to the repayment amount…

    I sure would appreciate any help someone might be interested in offering.

    Reply
  24. Jannatul NAyeem says

    October 26, 2016 at 1:37 pm

    How to Calculate IRR without the help of NPV? Is there any formula or something?

    Reply
    • Andy Chen says

      December 13, 2016 at 2:40 am

      https://uploads.disquscdn.com/images/0ecc32041d93e0bd4c6da034c857b95464f8bc7dab1de203e865eeb8f5cf7d5b.png

      Here’s the formula. r = IRR, but you need the other variables.

      Reply
  25. Andy Chen says

    December 13, 2016 at 2:37 am

    Is the IRR an annualized return similar to effective rents or is it a one-time overall return over a set period?

    Reply
  26. Dan says

    May 19, 2017 at 8:01 am

    Very insightful – thank you

    Reply
    • Robert says

      May 19, 2017 at 11:32 am

      Glad you found it helpful!

      Reply

Trackbacks

  1. Difference Between Cap Rate and Discount Rate says:
    March 1, 2013 at 9:34 am

    […] the investor’s return objectives, given the projected cash flows of the property. The intuition behind IRR and NPV is that it allows us to determine how much an investor should pay for a property, given his […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

What is PropertyMetrics?

PropertyMetrics provides web-based software for commercial real estate analysis and presentation.

Recent Posts

  • Understanding the Co-Tenancy Clause
  • How the Development Spread Works
  • Understanding the Texas Ratio
  • Understanding the Construction Draw Schedule
  • How The Double Net Lease Works

WHAT OTHERS ARE SAYING

"I'm a 30+ year seasoned veteran in shopping center development. PropertyMetrics is an excellent source of information with professional grade software for analysis and presentation. I highly recommend it."
- Frank C. Guess | Barnhart Guess Properties, LLC


"PropertyMetrics is very helpful in my understanding of commercial real estate. The presentation and information provided is astute and always to the point with great clarity. PropertyMetrics is truly appreciated."
-Sheriar Khorsandian, CCIM | Osceola Partners, LLC


"I am very impressed with your product. I have to also compliment your company on clearly explaining valuation concepts to me. To put this into context, I asked my professor in my investment class last week if he knew of a way to value an income property using discounted cash flow analysis. Long story short...you guys are smarter than my professor. THANKS PropertyMetrics! "
-Jonathan Torres | College Student


"I want to compliment PropertyMetrics for providing clear and concise tools for analyzing commercial real estate. As the head of a local Taxpayers Association with a considerable amount of municipal real estate, your data provides me with the information needed to show how much current lease terms cost the town in lost revenue, making my task much easier. Thank you!"
-Jerome Scott | Taxpayers Association of Jamestown


I am a professor at NYU's real estate program and I always tell my students that PropertyMetrics has the best and most easily understood explanations of real estate concepts. Great job!!!"
-J. Weinberg, Adjunct Professor | New York University


"I want you to know how much I appreciate PropertyMetrics. As a 30 year real estate attorney focusing primarily on commercial leasing and purchase and sale of commercial properties, it is extremely helpful to see the principles I have learned and used for so many years explained so clearly."
-Jon K. Ladd | Business and Real Estate Law Group


"I am commercial real estate lender for a large regional bank and I recommend PropertyMetrics to everyone."
-Andrew Levin | Commercial Lender


"Frankly, since I have been getting your emails we have one of the best educated offices in our market!"
-William C. Colucci | Associate Real Estate Broker


"PropertyMetrics is awesome. I actually just went ranting and raving about it to a few other analysts at my company and everyone has been thanking me for referring them!"
-Richard Cadena Jr. | Analyst


"PropertyMetrics is great. Invaluable."
-Peter Knobloch | President/CEO

Footer

My Account

Software Login

Courses Login

Contact Us

Do you have questions, comments, or feedback? Drop us a line and let us know. Get in touch.

Get Our Best Content First

Solutions | Blog | Resources | Contact | Terms | Privacy

Copyright © 2021 PropertyMetrics.com

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OK