EXCEL HELP PLEASE!! The orange slots i need answers for MUST include the EXCEL formulas/functions and not just the answer or I will receive no credit even if the answeris right.

File Home Insert Draw Page Layout Formulas Data Review Vies Calibri - 12 - AA of Cut By Copy - Paste Format Painter Clipboard 5 ab Wrap Text Merge & Cente BIU. A A Font Alignment 332 > fo AA B D E G H Question 2: Capital Budgeting 2 3 You are considering an investment in two projects, A and B. Both have an initial cost of $65,000, and the projected cash flows listed below. 4 5 6 7 8 9 10 11 12 13 Year 0 1 2 3 4 5 Project A Project B S (65,000.00) S (65,000.00) S4,000.00 S 34,000.00 $ 13,000.00 S 28,000.00 S 30,000.00 $ 18,000.00 $ 35,000.00 S 13,000.00 S40,000.00 $ 11,000.00 Assuming the weighted average cost of capital (WACC) is 12%, calculate the payback period, discounted payback period, NPV, and IRR. If the projects are mutually exclusive, which should be WACC 12% Project A Project B 14 15 16 17 18 19 20 21 22 23 24 25 Payback Period Discounted Payback Period Net Present Value Internal Rate of Return Best Project? Hint: Use an IF statement here Your Info Q1 Q2 Q3 CH Instructions Ready Scroll Lock ! C Clipboard Font . Alignment J32 X fix A B D E G H Suppose you are curious about how your WACC may impact your project decision. Create a NPV profile for Project A and B using the table below What is the exact crossover rate for these projects? 26 27 28 29 30 31 Crossover Rate Project A Project B 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 WACC 0.0% 1.5% 3.0% 4.5% 6.0% 7.5% 9.0% 10.5% 12.0% 13.5% 15.0% 16.5% 18.0% 19.5% 21.0% 22.5%