(10 points) Work this problem in Excel. The Light Blue Bedding Company is considering two new products for addition to its existing offerings. The products are considered mutually exclusive, since they appeal to the same target market. The projected cash flow streams are below.

Year Product A Product B

0 -$17,000 -$17,000

1 8,000 2,000

2 7,000 5,000

3 5,000 9,000

4 3,000 9,500

1. Calculate the internal rate of return for each project and explain your answer in words.

2. Calculate the NPV for each project at 0, 5, 10, 15, 20, 25, and 30%. Use your results to plot the NPV profile graphs. Be sure to identify the IRR for each project on the graph.

3. If the firms WACC is 8%, which product is preferable?

4. If the firms WACC is 14%, which product is preferable?

5. Calculate the crossover rate, and explain in words what it represents.