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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Analysis with Microsoft Excel

ISBN: 978-1111826246

6th edition

Authors: Timothy R. Mayes, Todd M. Shank

Question Posted: