Consider the following two mutually exclusive projects:
|Year||Cash Flow (X)||Cash Flow (Y)|
A. Calculate the IRR for each project.
B. What is the crossover rate for these two projects?
C. What is the NPV of Projects X and Y at discount rates of 0%, 15%, and 25%?
In the capital budgeting process, both the internal rate of return (IRR) and the net present value (NPV) methods can be utilized to make an investment decision. The IRR enables us to figure out the discount rate at which the present value of future cash flows is equal to the initial cost. NPV on the other hand enables us to determine the current worth of a project after netting off the present value of future cash flows against the initial cost. Sometimes projects can have the same NPV amount and the discount rate at which this happens is referred to as the cross-over rate.
Answer and Explanation: 1
One approach to calculating the IRR is to use excel.
Below are the steps applied:
Input the cash flows and corresponding years into...
See full answer below.
Become a member and unlock all Study Answers
Start today. Try it nowCreate an account
Ask a question
Our experts can answer your tough homework and study questions.Ask a question Ask a question
Learn more about this topic:
fromChapter 9 / Lesson 7
Learn about incremental analysis. Understand what incremental analysis is, learn the applications of incremental analysis, and see examples of incremental analysis.