I searched Google for 45 minutes trying to find a simple explanation on how to use IRR. Your video helped the most. All I need to do is 1. Use the formula =IRR(low cell value:high cell value). This will return a raw percentage like so: 0.2342173 2. Format the output cell as a percentage: 23.42% Easy beans. Thumbed up your video! :)
Dude I got a huge exam and was having a hard time with some basic stuff like this, so I can't figure out more difficult stuff. This explained it better than any other video, thank you
Thanks a lot for your great help. It is so simple and easy to explain NPV as your way. The most benefit for the people to understand how NPV works in real world.
You are one the best in all the videos I watched for this topic. Well done and thank you. It's not only important how well you know, it is equally important how well you can teach to those who are in need of knowledge.
THANK YOU, THANK YOU, THANK YOU! You are a wonderful! I understood everything and it was so easy to understand. You should be my professor. I can't thank you enough.
Thank you. I have been trying to find a simple way to calculate NPV and IRR for days. Great job. Thank you for sharing your knowledge with us. Please continue:)
This helped me out greatly! Thank you so much, did not realize those functions were readily available. Our professor had us going through and doing it manually in excel.
Thank you very much for providing so convincing video to calculate NPV and IRR. Following your guideline I tried to calculate IRR for a life insurance scheme where premium will be paid yearly for 5 years and get one time return after 10 years. I want learn to calculate manually instead of directly using IRR function of Excel. Please make another video which covers this requirement. With best regards.
Thank you for your explanation it was very helpful, I have sales background, in the management discussion people talk about numbers in NPV and IRR but I can't understand. Now it is very clear why the need of calculating NPV and IRR for project investment...
Great presentation. I would like to ask one question though. Why use the original values (B3;B7) and not the present values (C3;C7) when looking at the internal rate of return?
Do I need to multiply the IRR formula by 12 if I am collecting monthly payments rather than annual? For example, $1,000,000 Cash Outflow with an inflow of $19,685 / MO for 60 months. Because if I calculate the way you did, I come up with an IRR of 1%, and yet I assumed a cost of capital of 7%. Thank you.
Sir,In this case does it mean that-if we had invested in the business and we are having the said cash flows,the current value of the initial amount would be (350+117.92 i.e: 467.92 ??Which means the value of 350 invested now is equivalent to today's 467.92 as per the cash flow stated.Kindly clarify.
Thank you very much for the video. I have not find any other explanation that comes close to yours in terms of clarity and quality. Again, thanks so much!
Hi Nadia Rashid, get more help on finance related topics on MS Excel 2016, refer to my channel, ru-vid.com/show-UC7FDW0smEtuasTsaLLG_Aiw?view_as=subscriber