2. Part A reports information regarding Scenario #4 in Chapter 8. Refer to Cells A10:B16 and A20:B24 and apply this information to solve for the values in Cells C20:G24 and B27:B29. Assume there are 50 shares of common stock. Lastly, in Cell A32 display the exact equation used to solve for the value in Cell B27. B 1 Value Driver Scenarios, Chapter 8 E F G H nm + 3 Part A Scenario #4 Better Capital Utilization 8 9 Inputs 10 Sales growth in 1st year 11 Sales growth in 2nd year 12 Sales growth in 3rd year 13 Long-term sales growth (8L) 14 Operating profitability (OP) 15 Capital requirement (CR) 16 Cost of capital (WACC) 17 18 Scenario #4 10.00% 8.00% 7.00% 5.00% 6.00% 52.00% 10.97% 19 Year 1 Year 2 Year 3 Year 4 Year 5 Actual 5,000.0 300.0 3,050.0 -260.0 9.84% 20 Net sales 21 NOPAT 22 Total net operating capital 23 FCF = NOPAT - ACapital 24 ROIC = NOPAT / Capital 25 26 Results 27 Value of operations (Vop) 28 Intrinsic stock price 29 Return on capital (ROIC) Scenario #4 30