Question
3.We have two mutually exclusive investments with the following cash flows: Year Investment A Investment B 0 -$100 -$100 1 10 50 2 30 40
3.We have two mutually exclusive investments with the following cash flows:
Year Investment A Investment B
0 -$100 -$100
1 10 50
2 30 40
3 50 30
4 70 20
a.Using a financial calculator, calculate the IRR for each of the investments. State your answers in percentages rounded to two decimal places.
b.Calculate the NPV profile for each investment, using the discount rates of 0%, 5%, 10%, 15%, 20%, and 25%. Perform this task in an Excel spreadsheet. Cautionary note: If you use the =NPV() function in Excel to calculate the NPVs, it will provide incorrect answers. The NPV() function actually calculates the present value of all cash inflows. The NPV should be calculated as =NPV(all cash inflows) - initial cash outflow.
c.Plot the NPV profile for both projects using the X-Y scatter function in Excel.
d.If the required return on this project is 17%, would both NPV and IRR give us the same conclusion? Explain your answer.
e.If the required return on this project is 10%, would both NPV and IRR give us the same conclusion? Explain your answer.
f.Calculate the crossover rate at which we are indifferent between the two investments.
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