Question
For the following two mutually-exclusive projects, use Excel to find the net present value (NPV), internal rate of return (IRR), and the profitability index (PI).
For the following two mutually-exclusive projects, use Excel to find the net present value (NPV), internal rate of return (IRR), and the profitability index (PI). Assume the cost of capital (discount rate) is 8%. Which project should be accepted? Is there a conflict between NPV and IRR? If the discount rate is 12%, is there a conflict between NPV and IRR? Which project should be accepted if the discount rate is 12%?
Graph the NPV profile for both projects. What is the crossover point (i.e., at what rate do the two projects have the same NPV)?
Year: Project A Cash Flows: Project B Cash Flows:
0 ($14,000) ($14,000)
1 $6000 $3000
2 $5000 $3000
3 $5000 $5000
4 $2000 $5000
5 $2000 $6000
Please use Excel to solve
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started