From the course: Investment Evaluation
Schalten Sie den kompletten Kurs noch heute frei
Join today to access over 23,400 courses taught by industry experts.
Challenge 6: Choose a project based on NPV, IRR, and payback period - Microsoft Excel Tutorial
From the course: Investment Evaluation
Challenge 6: Choose a project based on NPV, IRR, and payback period
- [Instructor] Welcome to your sixth and final challenge in this course. In this challenge, I'll present to you a set of data for two different projects, which you can find in exercise file 04_11_Challenge6. From the set of data, you'll need to determine the NPV, IRR, and Payback Period for each project. After that, determine whether you'd accept each project on its own. Then, determine which of the projects you would choose between the two. The challenge should take approximately five minutes. Good luck.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Inhalt
-
-
-
-
-
-
(Locked)
What is IRR?1m 47s
-
(Locked)
IRR calculation the long way3m 10s
-
(Locked)
The case of no IRR1m 47s
-
(Locked)
The case of multiple IRRs5m 10s
-
(Locked)
IRR using the Microsoft Excel formula6m 24s
-
(Locked)
Challenge 5: Calculate NPV and IRR1m 3s
-
(Locked)
Solution 5: Calculate NPV and IRR3m 37s
-
(Locked)
Pros and cons of IRR1m 26s
-
(Locked)
Payback period2m 15s
-
(Locked)
Payback period in Microsoft Excel2m 31s
-
(Locked)
Challenge 6: Choose a project based on NPV, IRR, and payback period33s
-
(Locked)
Solution 6: Choose a project based on NPV, IRR, and payback period4m 53s
-
(Locked)
Real talk: IRR and payback period4m 49s
-
(Locked)
-