NPV and IRR in Excel 2010
Вставка
- Опубліковано 4 лип 2024
- Get the Kindle eBook of this video: www.amazon.com/dp/B08B3BG8VD/
Description: How to calculate net present value (NPV) and internal rate of return (IRR) in excel with a simple example.
Download the excel file here:
www.codible.com/pages/38
Some good books on Excel and Finance:
Financial Modeling - by Benninga:
amzn.to/2tByGQ2
Principles of Finance with Excel - by Benninga:
amzn.to/2uaCyo6
Thanks everyone for your kind comments! Please consider getting a Kindle eBook of this video for future reference here: www.amazon.com/dp/B08B3BG8VD/
Not only you show how to use excel formula. You explain the concept. Thank you!
most useful, and elegantly explained, thanks for taking time out! Grateful!
Thank you. I don't normally post a comment, but wanted to applaud you for this very informative, very helpful and crystal clear explanation. Thanks!
Well explained. Very easy to comprehend. The pace of audio and the supporting excel sheet on video complemented each other. Thanks to all members who were involved in making this UA-cam post. Good day.
I must say that this is one of the best-explained resources on youtube
THANK YOU! Best explanation and demonstration of NPV / IRR on YT!
One of the best explanations of two fuzzy concepts! Thank you so much!
Very well explained, both the concept and excel formulas. Better than some College Professors & Finance Gurus out there.
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.
Thankyou so much! This is the most simplest and effective video on NPV and IRR !
Simple and straightforward, best explanation so far, thank you.
This is definitely one of the better explanations of Excel functions!
I love the way this instructor explains this subject. Awesome!
Amazing! Tutor never said there is a formula to calculate IRR interest rate to get present value to 0. This just saved my nerves. Thank you!
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
You are able to express your understanding clearly. Further, you verbalize issues with excel vs. traditional Financial Community.
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! :)
Awesome job. You are a very good teacher. Thank you so much for making this so easy to understand!
EXCELLENT explanation. Brief, to the point, simple to follow. Thanks!
Great information! NPV is to measure the (net) future gain/ loss with given interest rate, while IRR is to measure the breakeven interest rate.
Such an amazing explanation that really helped me grasp the concept as I was studying for managerial finance principles! Thank you!
Very helpful. You made this confusing topic easy to understand. Thank you.
It is 1.30 am and you are the man I needed to listen to, to finish my work to go to bed !
Thank you, great job
The best example I have found so far. Great explanation and easy to listen to. Thank you!
Such a great explanation, certainly you know this very well because you explained it in the easiest way. Thanks a lot, and big thumbs up!! cheers!!
Wow this is fantastic. A great help to me. I am curently doing an assignment where I need to show NPV and IRR in Excel. This is perfect. Many thanks
your explanation was better than any of the professors I've evver had. thanks for sharing!
Great way of teaching, everything becomes very clear and easily understood. Thanks a lot
Very simple and straight to the point, thanks, man.
You saved me with this explanation! Thank you!
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.
Perfection at its best. Very well explained
Genuinely better teacher than my college. Thanks you sir.
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.
Best video on the subject I have seen to date.
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.
Perfect - just what I was looking for. Really clear explanation.
This is so helpful.....so brief yet with heavy content.
This was the most usefull video and explained very well. Thank you.
Great tutorials for NPV & IRR. THANKS!!!
Super helpful excel video with great explanation of finance concepts along the way!!
This was incredibly helpful! Thank you!
You’re better than all my finance professors
Well explained. Clear, simple, easy to understand
You sir are a very helpful person . thank you for the excellent video and simple yet effective expalanation !!
Thanks for that! it's a great explanation if you need to remember something you studied long time ago
Finally, i figured it out!! Thank you so much for explaining it.
your explanation is just incredible thank you very much.
Fantastic video. Very well explained and easy to understand.
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:)
so nice to revise with such simple explanations. thank you
thanks for saving me. your videos for excel are fantabulous.
Thank you ,thank you ,thank you. I helped me out with my assignment for financial management!
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.
Very helpful!! Great job in explaining the concept.
thank you! from colombia. it was very educative
Thanks for such a beautiful explanation.
Such a clear and good explanation. Thank you very much 👍❤
THANK YOU! :) You just saved me on a question I was working on for 5 hours.
Thank you for this video. You explained it quicker and better than my professor could.
Fantastic presentation! Would also be interesting to expand on this to show how to calculate NPV based on semi-annual rates.
Super clear and helpful. Excellent. Thank you!
Thank you this has been a huge help understanding these concepts!
You are a talented explainer.
Excellent explanation and demonstration. Much thanks
Thank you so much! My headache is disappear after watching your video!
Well done man
thats like a professional guy
Thank you for making this so easy to understand!!!!!!
Thanks so much for clearing this up, I finally am able to get a grasp of these metrics!
Really appreciate your efforts, Keep it up sir. Thank you
Wonderfully explained!!! very helpful..thanks a lot!!
Thank you for helping. I just recovered from all the headaches...
Thanks so much for posting this video. It was very helpful!
Great video and much simpler way to explain. THANKS Alot
By far the simplest on the webbert!
Thanks Buddy... You explained it beautifully
Thank you so much for your very well-explained one.
Thanks! Great video and clear explanation
Very clear and well explained.
You explain things so well, thank you!!
Outstanding explanation! Thank you VERY much for the assistance!
You saved my life! Thank you!
Brilliantly explained!
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...
This was extremely helpful, thanks!
Thank you very much, explained clearly and concisely which was extremely helpful.
precise and simple .. Superb work ! please keep it up and enlighten us
Great video, most useful. Thanks.
Thank you very much for simplifying the concepts
YOU ARE ONE OF A KIND!
Incredibly helpful! Thank you!
Excellent explain in very simple style...
many thanks, very clear and well explained
Great job on explaining NPV and IRR!!
very informative and presented in simple language
Excellent video, thank you for your help!
Thank you for this video... MBA in 9 minutes! Well explained.
Thanks, mate! Awesome explanation!
Thank you so much! This was clearly explained and nicely done!