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

Подписаться 109 тыс.

Просмотров 18 тыс.

50% 1

Modified Internal Rate of Return (MIRR) Tutorial - Chapters
00:00 - Introduction
01:10 - What is MIRR?
01:57 - Multiple IRR Problem
04:23 - Overestimate of Rate of Return
09:10 - Calculating MIRR
10:03 - MIRR Formula
11:55 - MIRR Excel Function
In this video, we will talk about MIRR, its calculations, how it tells the limitations of IRR, and its uses.
What is Modified Internal Rate of Return (MIRR)?
MIRR or Modified Internal Rate of Return accurately assesses the potential profits of an investment. Unlike IRR, which exaggerates and entices investors for investment, MIRR offers a better estimate of the expected ROI of an investment.
It can be calculated through:
- Discounted Approach
- Reinvestment Method
- Combination Approach
Uses of MIRR:
- Eradicates the issues of multiple IRRs and overestimation of the rate of return
- Allows adjustments for growth
- Adds reinvestment rates
#wallstreetmojo, #MIRR, modifiedinternalrateofreturn
For more details, you can refer to our article at - www.wallstreetmojo.com/mirr/
Subscribe to Our Channel -
RU-vid ► / @wallstreetmojo
LinkedIn ► / mycompany
Facebook ► / wallstreetmojo
Instagram ► / wallstreetmojoofficial
Twitter ► / wallstreetmojo

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@yashfitness959 Год назад

Thank you!

@mohitsingha210 10 месяцев назад

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

@wallstreetmojo 10 месяцев назад

Glad it was helpful!

@prasetio7 Год назад

Thank you

@syedyasir9240 2 года назад

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

@mufassirsaleem7043 10 месяцев назад

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.

@qwertyuiopasdfghjkl-ew1qi Год назад

love your video sir!

@wallstreetmojo 11 месяцев назад

Appreciate your feedback, more content coming soon!

@user-rn3ho3vk2b 5 месяцев назад

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.

@AmandaHunter-ym5dy 7 месяцев назад

nice

@digvijaychoudhari4128 2 года назад

Keep going sir

@sachi04denise 3 месяца назад

thank you so much.

@wallstreetmojo Месяц назад

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

@dharminsanghavi7365 11 месяцев назад

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 ?

@kanchandatta4668 5 месяцев назад

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?

@slvrcross 2 месяца назад

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

@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?