Ryan O'Connell, CFA, FRM shows how to calculate NPV and IRR in Excel.
💾 Download Free Excel File:
► Grab the file from this video here: ryanoconnellfi...
🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/
👨💼 Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: ryanoconnellfinance.com/freelance-finance-services/
📚 CFA Exam Prep Discount - AnalystPrep:
► Get 20% off CFA Level 1, 2, and 3 complete courses with promo code "RYAN20". Explore here: analystprep.com/shop/all-3-levels-of-the-cfa-exam-complete-course-by-analystprep/?ref=mgmymmr
Chapters:
0:00 - Define the Expected Cash Flows
0:51 - Calculate the Present Value (PV) of Each cash Flow
1:46 - Calculate the Net Present Value (NPV) of the Project
2:14 - Calculate Net Present Value (NPV) using NPV() Excel Function
2:38 - Calculate Internal Rate of Return (IRR) Using IRR() Excel Function
2:54 - NPV and IRR Accept or Reject Rule
3:27 - Experimenting With Different Assumptions
*Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC
Негізгі бет How to Calculate NPV and IRR in Excel
No video
Пікірлер: 31