From the course: Investment Evaluation
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
What is IRR? - Microsoft Excel Tutorial
From the course: Investment Evaluation
What is IRR?
- Yes, NPV is awesome, however there are also some other common measures that are used along side NPV to determine whether an investment or project will be worth your time and money. The first one I wanna show you is the internal rate of return, lovingly known as IRR. The IRR is a discount rate that sets the NPV of a project equal to zero. It allows us to see the percentage rate that will be earned for a given set of cash flows. This method incorporates the time value of money, just like the NPV, it's often used when there's a lack of clarity or consensus within the company as to what discount rate should be used in the NPV calculation. So again, IRR is a discount rate that sets NPV equal to zero, when our net present value is zero, we'll know that we'll get as least as high a return as our discount rate. So, if the IRR is set at a desirable percentage and we get a positive or zero NPV, then we know that the project is probably a good investment. It's generally considered a good…
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)
-