4 Dant Part C reports information regarding Scenario #8 in Chapter 8. Refer to Cells A74:B80 and A84:B88 and apply this information to solve for the values in Cells C84:G88 and B91:B93. Assume there are 50 shares of common stock. Lastly, in Cell A96 display the exact equation used to solve for the value in Cell B91. 67 Part c Scenario #8 Lower Average Cost of Capital 73 Inputs 74 Sales growth in 1st year 10.00% 75 Sales growth in 2nd year 8.00% 76 Sales growth in 3rd year 7.00% 77 Long-term sales growth (gl) 5.00% 78 Operating profitability (OP) 6.00% 79 Capital requirement (CR) 61.00% 80 Cost of capital (WACC) 9.50% 81 82 Scenario #8 Actual 84 Net sales 5,000.0 85 NOPAT 300.0 86 Total net operating capital 3,050.0 87 FCF = NOPAT - ACapital -260.0 88 ROIC = NOPAT / Capital 9.84% 83 Year 1 Year 2 Year 3 Year 4 Year 5 89 Scenario #8 90 Results 91 Value of operations (Vop) 92 Intrinsic stock price 93 Return on capital (ROIC) 94 95 Calculation of V., Scenario 8: Sheet1 Sheet2 Sheet3