From the course: Investment Evaluation
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Real talk: IRR and payback period - Microsoft Excel Tutorial
From the course: Investment Evaluation
Real talk: IRR and payback period
- Hey everyone and welcome back. I'm here with Kevin, president and CEO of Meet Kevin and Meet Don and this time, Kevin, we're talking about IRR, the internal rate of return. Now Kevin, when do you use internal rate of return metrics in your business? - Any time the discount rate isn't known or there isn't a consensus within the company or a family in that, in this case, we'll use IRR. - So what do you mean by that, there isn't a consensus? Why wouldn't there be a consensus? - You know, different people measure the discount rate in different ways. Some people look at it as what is our cost of debt, what opportunity do we have in the marketplace to get a certain yield, so it can be very variable. - Okay and so what happens? You calculate the IRR and then what do you do with it? - Well the IRR is wonderful because you can use it to sort of compare different investment options and choices. - Okay Kevin, so imagine that you do have a couple of investments and one is a really short-term…
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.
Contents
-
-
-
-
-
-
(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)
-