Modified IRR - Example 1

In this video, you will learn how to use the MIRR concept.

[@mdmuktadinemon4705]

My gratitude can't be explained in words. It was superb!

[@maxusknowledge]

Thankyou!

[@deniztuncbilek8802]

1,649 is calculated by taking 1,581 root 3 by the way

[@subhasreemajumdar4611]

Excellent explanation.I was going crazy around other explanation for hours but could not understand anything properly.You just guided me step by step so easily. Its so clear now.Thanks.

[@maxusknowledge]

Thankyou Subhasree!

[@kumarip1937]

Can you please explain sir how to came the 1+r = 1.581 become

[@kumarip1937]

@@maxusknowledge 1.165

[@josemanuelvega9690]

Thank you so much! Since Covid, we have all of our school exams open note/ open everything, and I literally watch your entire video on 2x speed and you helped me get the right answer! I owe my success to you! Great video!

[@maxusknowledge]

Thank you for your kind words!

[@ayandazinhle9807]

All the way from South Africa.....Thank u!

[@hawktrain1324]

You're a lifesaver, sir!

[@umairrehman3369]

Wow so smoothly taught. Made sense too. Loved it.

[@manansbat3244]

Ur teaching method is awesome

[@lespxnach3247]

I can't follow how did you get the 1.165??

[@Dutch0gaming]

You, my good sir, are a financial mastermind

[@Nishu_mishra89]

Thnku so much for dis informative video 👍

[@shreyapoudel4332]

Thankyou so much

[@harshaladia3641]

Well explained! Thank you!

[@niteshmatta]

Superb sir... you made it so easy for me

[@MohalafNaeem]

V nice sir

[@arsurya]

Very clear explanation of IRR. But calling it MIRR is confusing. MIRR or Modified Internal Rate of Return is normally applied to non-conventional cash flows, i.e. where there is cash outflows in addition to year zero. Your example is based on a conventional cash flow, so please refer to it as IRR and not MIRR.

[@niteshmatta]

No ways IRR is different and differently calculated

[@DuyNguyen-td7vj]

very much appreciated!

[@Roshan__43]

Well explained 👌💥

[@MetciEtci]

Thanks a Loto. Useful.🙏🍀👍

[@hassanali9813]

Thanks. Its very helpful.

[@dariknour6051]

hassan ali 😂😂

[@TechTaken]

Really thanks man.

[@purvipatel7658]

how did you get the 1.165?

[@soni1142]

I know how this come

[@abhishekshilwant7332]

@@soni1142 how?

[@TheExtremeRover]

But just like NPV, in MNPV also value should be zero i.e. in MNPV present value of Terminal value of cash Inflow minus Present Value of Cash Outflow should equal to zero, which is not clarified in the end, so it is not a comprehensive example

[@tanmaysinghal5166]

Thanks sir

[@mamtasankhla6147]

Thank you sir 🙏🙏

[@Sandeepjakhar17]

Thanks a lot sir.

[@soni1142]

Thank u

[@kevonreynolds1243]

I'm not getting the 1.165

[@guidanceforsuccesschannel6315]

Confusing calculation techniques used at 1 stage used cost of capital K and.second stage used R thanks for your efforts but can improve further if use simpler explanation techniques

[@sushmagjsushmashalini714]

Thanks

[@dreamvy760]

does anyone made the resume for this subject?

[@zahidulislam9397]

in fin calculator the result 16.50% plz

[@kumbinyakudyapeters1701]

THANK YOU!!!!!!!!!!!!

[@KannapiranArjunan-vm2rq]

Modified IRR (MIRR) Is a Spurious Criterion and Should Not Be Used in Cost-Benefit Analysis (CBA) and Investment Analysis Forthcoming in the Journal of Economic and Finance Education 29 PagesPosted: 3 Apr 2017Last revised: 15 Dec 2018 Kannapiran Arjunan Independent Date Written: March 28, 2017 Abstract This paper evaluates whether MIRR is an appropriate criterion for investment decision and the true annual rate of return on capital. Unlike other published papers, the present analysis introduces three important improvements viz. the investment returns are consistent with NCF (NCF-consistent); the two components of returns on capital investment, i.e. return of capital invested (ROC) and return on invested capital (ROIC), are clearly defined and accounted for; and finally, capital amortization schedule (CAS) is used to verify whether the returns are achievable from the NCF generated and therefore NCF-consistent. The appropriateness of MIRR is evaluated using numerical analysis and the main findings are: a. The estimation of MIRR, manually or in excel, is based on the modified net cash flow (MNCF). The MNCF, derived by mathematically adjusting the actual net cash flow (NCF), distorts the intrinsic value of the cash inflow and its timing. With MNCF, the MIRR is lower than the IRR because MIRR failed to fully utilize the NCF generated as shown by the CAS. MNCF is neither NCF-consistent nor accounting concept-consistent (cash vs accrual concept). b. The problem of reinvestment of intermediate income is a fallacy and therefore the MNCF is a meaningless exercise. For the same NCF, the net benefit stream, MIRR is increasing without any limit with increasing investment rates (IR). The NCF is not adequate to support such an increase in MIRR, as revealed by the CAS. Similarly, when the actual IRR is lower than the IR used, the estimated MIRR is higher than the IRR. Again, the NCF is not sufficient to achieve that higher MIRR than the IRR as confirmed by the CAS. This is one of the serious problems with MIRR that is based on the MNCF, a mere data mining exercise. MIRR is not an accurate estimate but a spurious one. c. Again, the problem of multiple IRR is a data problem associated with non-normal NCF. MIRR does not solve this problem either. With non-normal NCF, the cumulative sum of undiscounted NCF is zero or negative or negligible. In those cases, the NCF data leads to multiple IRR. The non-normal MNCF leads to spurious MIRR estimate (also GIRR and AIRR) that is not supported by the actual NCF as revealed by the CAS. Any rate of return must be NCF-consistent. d. With normal NCF also, the MIRR is spurious because of the false reinvestment assumption and the use of MNCF data. The estimated MIRR, based on assumed reinvestment rate, leads to serious problems as explained above. MIRR (when MIRR < IRR) estimate does not fully utilize the benefit stream and leave a closing balance, as revealed by the CAS. Contrarily, IRR fully utilizes the NCF and therefore IRR is higher than the MIRR (paid-off the ROC and ROIC = IRR). When MIRR is higher than the IRR, the NCF does not support that level of MIRR. e. The results of CAS reveal that MIRR is neither the true return nor the annual rate of return. IRR is also not the annual rate of return but it is the true rate of return on the capital remains invested. Both the MNCF and MIRR are not NCF-consistent but may be mathematically-consistent. When there is no intermediate income, the question of reinvestment does not arise. With that type of NCF, the MNCF and the MIRR are NCF-consistent. f. Generalized IRR (GIRR) and Average IRR (AIRR) criteria are also reviewed. They are not NCF-consistent but mathematically generated returns and are based on wrong assumptions (reinvestment). Based on these results, it is evident that the MIRR is a spurious criterion. Investment analysts and decisions makers may wish to move away from using or reporting MIRR as a criterion so also the authors of all published works and finance and economic texts. Keywords: MIRR a Spurious Criterion, MIRR Misleads Investment Decision