From the course: Investment Evaluation
Schalten Sie den kompletten Kurs noch heute frei
Join today to access over 23,300 courses taught by industry experts.
Challenge 5: Calculate NPV and IRR - Microsoft Excel Tutorial
From the course: Investment Evaluation
Challenge 5: Calculate NPV and IRR
- [Instructor] Welcome to your fifth challenge in this course. In this challenge your job is to determine the IRR, and NPV, and whether Kevin should accept the project that has been presented. It should take you less than 10 minutes to complete this challenge. There are two parts to this challenge. Simple, and multiple. In the exercise file labeled 04_06_Challenge5, in the Simple tab, imagine that Kevin has a potential project in which he has to initially invest a million dollars. The project takes 10 years, and it's estimated to produce a net cash flow of $125,000 a year. The discount rate is assumed to be five percent. Calculate the IRR, and NPV of this project. Is it worth Kevin's time to take it on? Okay, now for the second part of the challenge. Let's take a look at the Multiple tab. This time I provided the net cash flows. See if you can determine the two different IRR values. It should take you less than five minutes to complete this challenge. 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)
-