O Problem Joe Fox is the manager of the Gear division and plans to submit a proposal for an expanded production area. Joe has projected various conditions for revenues and expense for the expansion, including different sizes and quality components. Knowing that the effect will likely differ under each, Joe plans to submit a conservative estimate for his proposed capital budgeting project this year to avoid a repeat of an unfavorable post-audit evaluation as occurred two years ago. Joe has provided the following data to be used in the analysis of selecting the proposal to be submitted to the capital budget committee. Required rate of return 6.0% Student Work Area Table of useful lives and cash flows for different capital budgeting scenarios (Dollar amounts in thousands) a. Calculation of IRRs Years of Operating Operating Operating Operating Operating Operating Project Useful Net Initial Cash Flows Cash Flows Cash Flows Cash Flows Cash Flows Cash Flows Project Scenario Life Investment Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Scenario IRR A 6 $ (43,869) $ 9,006 $ 9,564 8,831 9,557 $ 9,143 $ 8,906 (51,967) 11,372 12,042 11,259 11,517 11,880 10,758 (46,516) 12,414 12,970 12,586 11,730 (51,118) 14,982 12,853 13,817 14,031 canmono - IanmonP (71,715) 15,237 17,496 17,826 15,962 17,682 (49,709) 13,054 12,078 13,866 13,686 (55,519) 15,361 13,898 15,514 15,491 (46,336) 10,422 10,050 9,228 10,221 10,725 9,079 H (53,417) 12,843 13,283 12,562 11,670 12,677 (60,032) 12,845 12,328 10,734 10,113 10,960 - XL (51,321) 10,630 8,576 9,787 8,273 9,265 10,909 - X 67,073) 713,627 12,263 13,931 13,080 12,984 23 1 (43,994) *9,537 8,490 8,690 9,395 (39,793) 9,526 9,079 9,779 10,746 8,277 Instructions: There are three parts to this problem. Use Excel to perform the following: b. Chart for part b a. Use Excel's IRR function to calculate IRR for each project scenario. b. Create a column chart that illustrates the IRR for each project. Include a descriptive chart title and axes labels in the chart. C. Examine the chart. Which project scenarios are acceptable? Which project scenario would you recommend that Joe submit to the capital budget committee? Justify your response. c. Response to part c