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.
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
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
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?
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.
Interesting class, thanks sir for your great work
You are welcome for the work, Alex!!!
You are welcome!
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.
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
For someone who is struggling in a finance class, it would have been super helpful to use more than 2 periods.
This is the only video title I have on Solver:
RUclipsrsLoveExcel#21: Solver for Linear Algebra
Yes, circledchicken is correct. Both come out with the same answer but some viewers may get confused.
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
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?
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.
I have a question: Which of the three modified IRR approaches is commonly used by companies? They have slightly results though.
Thanks a lot
I am currently overwhelemed at work (80+ hours per week). Try this site for Excel questions:
mrexcel[dot]com/forum