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.
Pros and cons of IRR - Microsoft Excel Tutorial
From the course: Investment Evaluation
Pros and cons of IRR
- I really like IRR for its simplicity, at least when the project investment structure's simple. There are no difficult formulas, and it gives a really good metric that you can compare against other projects that you're considering. I also like it, because it ignores a lot of the guessing. For example, you don't have to worry about what the whack discount rate is. So the risk of calculating it is immediately mitigated. Of course, I also love that IRR takes into account the time value of money, which results in each cash flow being given an equal weight. However, its simplicity also limits its scope. For example, there's no parameter for the size of the project. A project with 100000 dollar overhead cost and projected cash flows of 25000 dollars in the next five years has an IRR of 7.94 percent, whereas a project with a 10000 dollar overhead and projected cash flows of 3000 in the next five years has an IRR of 15.2 percent. Using the IRR method alone makes the second, smaller project…
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)
-