Modified Internal Rate of Return (MIRR) - Basics, Formula, Calculations in Excel (Step by Step)

[@mohitsingha210]

Thanks a lot, I had asked about an alternative to IRR from your video on IRR, this clarifies my doubt. Thanks again!!

[@wallstreetmojo]

Glad it was helpful!

[@qwertyuiopasdfghjkl-ew1qi]

love your video sir!

[@wallstreetmojo]

Appreciate your feedback, more content coming soon!

[@manishpandey8378]

😊❤

[@user-rn3ho3vk2b]

Excellent video. Good explanation of the concept. I would have used the phrase, "Cost of equity" rather than "cost of capital." You're trying to find out the rate of return you can expect on your investment, which is equity, not the cost of capital which sounds like the WACC, which includes debt capital.

[@yizhang6117]

good explanation!

[@wallstreetmojo]

Thank You

[@slvrcross]

If I wanted to find my MIRR on a MONTHLY BASIS, would I need to add any numbers to the equation?

[@sachi04denise]

thank you so much.

[@wallstreetmojo]

🎁Check out our Free and Paid courses at www.wallstreetmojo.com/all-courses/

[@mufassirsaleem7043]

Thank you, this was very useful. In real life situation, can we use the interest rate as the finance rate and the COC as the re investment rate.

[@yashfitness959]

Thank you!

[@digvijaychoudhari4128]

Keep going sir

[@syedyasir9240]

Very useful ... request you to update your course as well on financial modeling or add some recent cases FY20 FY21

[@kanchandatta4668]

Excellent

[@wallstreetmojo]

🎁 Check out our Free and Paid courses at www.wallstreetmojo.com/all-courses/

[@kanchandatta4668]

If one project has successive outflow ( say successive 6 years) how to calculate initial capital ? Should we calculate the present value of outflow in year 2 , similarly upto year 6 then add these p.v with current years amount to make initial investment?

[@prasetio7]

Thank you

[@AmandaHunter-ym5dy]

nice

[@KJUnni]

Well explained and thanks for the information. I do have a question to ask, while working out some trial formula's using MIRR, I just noticed that when the cash in (-ve value) is happening at the beginning of the year, the finance rate (whatever value it maybe), is not having any impact on the MIRR calculation. Could you please clarify?

[@nikitachomal8435]

Ya same question

[@dharminsanghavi7365]

Sir, MIRR formula in excel do not ask to consider dates or years into consideration in comparision to XIRR formula. Is there any solution to calculate MIRR which considers dates too ? I mean if you have multiple outflows and inflows then How to get dates effect included in MIRR ?