NPV and IRR in Excel 2010

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

[@Codible]

Thanks everyone for your kind comments! Please consider getting a Kindle eBook of this video for future reference here: www.amazon.com/dp/B08B3BG8VD/

[@nikorgbroga]

Not only you show how to use excel formula. You explain the concept. Thank you!

[@mlcalderaro]

One of the best explanations of two fuzzy concepts! Thank you so much!

[@BrenHere]

I’m here the night before my assignment is due 😂

[@aadyasharma2060]

Got semester exam today its 3:00 AM right now

[@b72k_78]

I'm here bc I have final exam after a week 😂😂😂😂🥲🥲🥲

[@kugykung1691]

need to submit my asiignment by tomorrow lol

[@MoussaToure316]

I feel u bro 🤣🤣🤣🤣

[@omalkhairismaelabdirahman5925]

You’re not alone 😭

[@TanksKreativeKlouds]

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.

[@sosheelgodfrey7846]

I must say that this is one of the best-explained resources on youtube

[@Dylan-wr3xs]

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

[@TedWoodYourMentor]

You are able to express your understanding clearly. Further, you verbalize issues with excel vs. traditional Financial Community.

[@rogerk123]

Very well explained, both the concept and excel formulas. Better than some College Professors & Finance Gurus out there.

[@nelliku9263]

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!

[@jaikishansmspl39]

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 CZcams post. Good day.

[@ryanrhoades7401]

Awesome job. You are a very good teacher. Thank you so much for making this so easy to understand!

[@mountaingoat6393]

THANK YOU! Best explanation and demonstration of NPV / IRR on YT!

[@pwatah]

You saved me with this explanation! Thank you!

[@chigoziehumphrey3356]

Very simple and straight to the point, thanks, man.

[@sabina23990]

Thankyou so much! This is the most simplest and effective video on NPV and IRR !

[@RS-ld3qt]

This is definitely one of the better explanations of Excel functions!

[@dualityofnature]

most useful, and elegantly explained, thanks for taking time out! Grateful!

[@tzhenyao]

Great information! NPV is to measure the (net) future gain/ loss with given interest rate, while IRR is to measure the breakeven interest rate.

[@swatace23]

Super helpful excel video with great explanation of finance concepts along the way!!

[@TheMunkinutz007]

Great tutorials for NPV & IRR. THANKS!!!

[@nenebinene2194]

so nice to revise with such simple explanations. thank you

[@henodu5219]

Very helpful. You made this confusing topic easy to understand. Thank you.

[@mariamachuca7207]

This was incredibly helpful! Thank you!

[@jh1896]

Such an amazing explanation that really helped me grasp the concept as I was studying for managerial finance principles! Thank you!

[@houmadasara1568]

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!!

[@alokeganguli974]

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.

[@Cohsyn]

Simple and straightforward, best explanation so far, thank you.

[@Shooter_gringo]

Thank you thank you thank you!
Who determines the initial discount rate?

[@MrEverth007]

Fantastic video. Very well explained and easy to understand.

[@ahsanali50]

Perfection at its best. Very well explained

[@kiranshrestha2775]

the value which you have put in cash flow is profit value ? pls
give the answer. thank you

[@luayaltaher9069]

You sir are a very helpful person . thank you for the excellent video and simple yet effective expalanation !!

[@zanemckinnon5115]

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

[@trevorspear5970]

Thank you for making this so easy to understand!!!!!!

[@salimavirani109]

Very helpful!! Great job in explaining the concept.

[@CGP9856]

Where do you get those numbers for Cash Flow to calculate net present value

[@devangc7260]

Thanks for such a beautiful explanation.

[@cliffgadd3035]

Great video, most useful. Thanks.

[@sosheelgodfrey7846]

Do you have one that includes salvage value as well and how to deal with it?

[@KhalidKhan-gw2yd]

Really appreciate your efforts, Keep it up sir. Thank you

[@izabelasantos9425]

Thanks for that! it's a great explanation if you need to remember something you studied long time ago

[@sharpthorn381]

Thank you so much for your very well-explained one.

[@kxmode]

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! :)

[@aakashbhatt4727]

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.

[@msylviaeghs]

Excellent video, thank you for your help!

[@arafatislam9159]

what i want to get irr from year 1 in excel

[@JuanVichannel]

thank you! from colombia. it was very educative

[@kmlckd]

Thanks so much for posting this video. It was very helpful!

[@anilrungta4664]

You are a talented explainer.

[@Cap_Fifeberry]

This was extremely helpful, thanks!

[@barackobama3719]

You’re better than all my finance professors

[@Nina-yj6cu]

I love the way this instructor explains this subject. Awesome!

[@masterofyourbreath]

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

[@idrisahmedi4686]

This was the most usefull video and explained very well. Thank you.

[@denismulongoysalumu3942]

your explanation is just incredible thank you very much.

[@taylorkoki5259]

Very clear and well explained.

[@nomansyed89]

Well done man
thats like a professional guy

[@camiwritesru]

Thank you ,thank you ,thank you. I helped me out with my assignment for financial management!

[@mehmoodnadeem5594]

very informative and presented in simple language

[@napi1650]

Thanks, mate! Awesome explanation!

[@akaphoenix1980]

This was more helpful than the professor I'm paying to teach me this material.

[@alisahudson5996]

What if the 2 net present values (in this case $117.92) aren't the same? Mine are coming out as different values and i am making sure that the formula is correct.

[@kristinearshakyan7757]

Such a clear and good explanation. Thank you very much 👍❤

[@lareynadlsr3190]

Finally, i figured it out!! Thank you so much for explaining it.

[@pauloneto4196]

Thank you so much.. great explanation

[@SnehalThomas]

Very well explained. Thanks !

[@stephenheckman5528]

Fantastic presentation! Would also be interesting to expand on this to show how to calculate NPV based on semi-annual rates.

[@MikahFierce]

The best example I have found so far. Great explanation and easy to listen to. Thank you!

[@muhammadadnanahmed6143]

thanks a lot, nice way of explanation

[@andrascaron]

By far the simplest on the webbert!

[@jaknicholls7824]

Thanks mate, that was really helpful!

[@lampikhung6088]

Thank you so much! My headache is disappear after watching your video!

[@ashbeelqadir7858]

Love.. Thnku so much.. U explained well

[@SanjaySharma-xz8wj]

Very well explained thanks

[@YvesAustin]

very well explained - thank you

[@Raja-up6yv]

Sir, In an Excel Sheet, for how many 'Number of entries' in Rows one can calculate IRR ?

[@pravinsingh1851]

Thanks Buddy... You explained it beautifully

[@vengoba861]

Well explained. Clear, simple, easy to understand

[@nissynissy2141]

Thank you for helping. I just recovered from all the headaches...

[@ellenj7065]

Thank you so much! It helped with my assignment!!

[@darsh0212]

Will it work the same way if we keep on adding money for say 5 or 10 years without any net return?? What will be the formula for NPV in this case? Do we need to add all negative values + npv (interest rate, Select remaining cells)

[@imranahmedmirza7045]

Excellent explain in very simple style...

[@kimhao98]

Please help I have two IRR values but it only limits to one and I cant find the other. URGENTTTT!!!

[@tapabratamajumdar3371]

Really good video..thanks for the concepts

[@kevinmcaleer28]

Perfect - just what I was looking for. Really clear explanation.

[@SoulRaag]

You explain things so well, thank you!!

[@sarahsitu5538]

Thank you for showing this! It is easy to understand and please have more Excel videos!!!

[@hrithikraj4927]

Hi Sarah Situ, wanna more videos on excel refer to my channel, Excel Study, czcams.com/channels/7FDW0smEtuasTsaLLG_Aiw.html?view_as=subscriber

[@deepakpatel-kk9cv]

czcams.com/video/aIQSpkOtXfI/video.html

[@joannajane889]

Thanks! This was very helpful

[@ke8814]

Thank you for this very helpful video

[@nadiarashid5856]

Thank you so much. Your video was easy to follow and I have managed to find the NPV for my project....Awesome 😊

[@hrithikraj4927]

Hi Nadia Rashid, get more help on finance related topics on MS Excel 2016, refer to my channel, czcams.com/channels/7FDW0smEtuasTsaLLG_Aiw.html?view_as=subscriber

[@deepakpatel-kk9cv]

czcams.com/video/3Pw-W3Q9JsU/video.html

[@MM-lb2zk]

Thank you this has been a huge help understanding these concepts!

[@oceanadex]

YOU ARE ONE OF A KIND!

[@balonzydodor2921]

Please which key did you used to change the f4 to$f$1

[@andrewcolinferguson]

very clearly explained. thank you very much!

[@scolson18]

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.

[@shokhrukhmukhitdinov8970]

good explanation, thank you very much!

[@zabisadiqi6983]

IRR is used for comparison with the company WACC. If the company WACC is lower than the IRR yield by the project, then go for it.

[@dzikripratama3776]

Thank you for the explanation...

[@hasanaskari7850]

brilliantly explained!