Download Excel File: people.highlin... Download PowerPoints: people.highlin... Learn about calculating MIRR - Modified Internal Rate of Return. See the MIRR function and learn about Geometric Mean.
Excellent video - i like it, just like all the rest of them! A very minor point is that at 6:47, since the MIRR function is being used, I think the values argument should be C2:C4, not C19:C21.
Why does Method 2 result in a different IRR than the other Methods? If the CF values are correctly discounted to different periods, then shouldn't the IRR (or in this case MIRR) be the SAME for all periods?
Hi I have a question 🙋♀️…In a question where I have 8 years and cash flows ( negative and positive) how do I solve this for the discounting, Reinvestment and Combination approach? Please I will truly appreciate if you get to explain better
Logically and more correctly, the final solution should be as follows: Year 0 = -6,660 Year 1 = 17,205 + (1+0.15)^1 = 19,785.75 Year 2 = 19,785.75 - 11100 = 8,685.75 The=MIRR(cash flows, WACC,WACC) ... in your case = 14.65% Geometric mean = CAGR = 8,6857/ABS(6,660)^(1/2)-1 = 14.20% This final layout will save you having to do it three times
Excellsfun is a good channel. It demonstrates the example for student to follow. Sir, I have a question and perhaps you can advice me. I want to design excell to use for transferring the products. However, I do not know how to set the data validation. For example, Number 1 has used in the above row then accidentally I again typed Number 1 in the below row but the the same. In excell, how to set to inform user that his number has already input? Thank and perhaps, you can advice me.