# Current Value Of Cash Flow Minus Cost Of Investment Alternatives to IRR and NPV

You are searching about Current Value Of Cash Flow Minus Cost Of Investment, today we will share with you article about Current Value Of Cash Flow Minus Cost Of Investment was compiled and edited by our team from many sources on the internet. Hope this article on the topic Current Value Of Cash Flow Minus Cost Of Investment is useful to you.

Muc lục nội dung

## Alternatives to IRR and NPV

In a previous article, I discussed the shortcomings associated with using either the Internal Rate of Return (IRR) or Net Present Value (NPV) as a return measure for income producing real estate assets.

In that article, I also indicated that there are several other return measures that I prefer and those will be the topic of discussion here. Please note that these measures are not perfect, but in my experience, I have found them to be stronger and more reliable indicators than either IRR or NPV.

As detailed in my prior article, the primary shortcoming of the IRR is that it assumes that any positive cash outflows will be reinvested at the same rate as the IRR. As this is rarely the case, IRR figures are often distorted, sometimes significantly.

The Modified Internal Rate of Return (MIRR) alleviates this problem by assuming that the present values of cash outflows are calculated using the financing rate, while the future value of cash inflows are calculated using the actual reinvestment rate.

Without getting overly technical, the formula used to calculate the MIRR can be described as “The nth root of the future value of positive cash flows divided by the present value of negative cash flows minus 1.0, where “n” is the number of time periods.

Calculations like the above can be sidestepped by simply using the MIRR formula found in Excel. For a case in which cash flows are detailed in cells A2 through A8, using a reinvestment rate of 7.0% and a financing rate of 5.0%, the formula would be as follows: =MIRR (A2:A8, 0.05, 0.07)

However, for this formula to work, there must be at least one negative cash outflow. For instances with no negative cashflows, the “long hand” formula above must be used.

In essence, the MIRR formula is simply a geometric mean, identical to the formula used to calculate the cumulative average growth rate for figures that increase exponentially, such as compound interest earnings.

As many real estate investments (hopefully) do not experience periods of negative cash outflows, the above calculation can be cumbersome, especially in situations that include an investment horizon covering many time periods. Regardless, since the final calculation will likely be more accurate than a similar IRR figure, it is worth the added time to construct it.

There are two other investment measures that I rely upon, perhaps more so than any others. These include Net Yield on Equity and that old standby, the Capitalization Rate. If you are reading this article, chances are that you are quite familiar with both metrics, but in the event that you are not, the formula used to calculate Net Yield assumes After Tax Cash Flow + Amortization (Principal Reduction) divided by Initial Equity, while the Capitalization Rate is simply Net Operating Income divided by Total Investment Cost.

While neither of the above factor in the “time value of money” (like IRR, NPV and MIRR), the underlying assumptions that go into the calculation of both are very reliable, and as such, return figures generated by either can be used with the confidence that these are not distorted by problematic variables.

Investment real estate analysis is not rocket science, and I see no reason to overcomplicate an analysis, when simpler, time proven metrics are readily attainable. This is especially true when using more complex return measures (i.e. the IRR and NPV) that may distort real returns.

## Video about Current Value Of Cash Flow Minus Cost Of Investment

You can see more content about Current Value Of Cash Flow Minus Cost Of Investment on our youtube channel: Click Here

## Question about Current Value Of Cash Flow Minus Cost Of Investment

If you have any questions about Current Value Of Cash Flow Minus Cost Of Investment, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Current Value Of Cash Flow Minus Cost Of Investment was compiled by me and my team from many sources. If you find the article Current Value Of Cash Flow Minus Cost Of Investment helpful to you, please support the team Like or Share!

Rate: 4-5 stars
Ratings: 6678
Views: 60838854

## Search keywords Current Value Of Cash Flow Minus Cost Of Investment

Current Value Of Cash Flow Minus Cost Of Investment
way Current Value Of Cash Flow Minus Cost Of Investment
tutorial Current Value Of Cash Flow Minus Cost Of Investment
Current Value Of Cash Flow Minus Cost Of Investment free
#Alternatives #IRR #NPV

Source: https://ezinearticles.com/?Alternatives-to-IRR-and-NPV&id=9679740