You are considering an investment in two projects, A and B. Both projects will cost $75,000, and
Question:
You are considering an investment in two projects, A and B. Both projects will cost $75,000, and the projected cash flows are as follows:
Year Project A Project B
1 .....................................$ 5,000........................ $ 36,000
2...................................... 15,000........................... 27,000
3...................................... 28,000........................... 20,000
4...................................... 35,000........................... 15,000
5...................................... 40,000...........................10,000
a. Assuming that the WACC is 10%, calculate the payback period, discounted payback period, NPV, PI, IRR, and MIRR. If the projects are mutually exclusive, which project should be selected?
b. Create an NPV profile chart for projects A and B. What is the exact crossover rate for these two projects?
Step by Step Answer:
Financial Analysis with Microsoft Excel
ISBN: 978-1111826246
6th edition
Authors: Timothy R. Mayes, Todd M. Shank