Question 19 Directions: Table 1: Revenue and oeprating expense forecasts 2014A Revenue 1,000.0 Operating Expenses 800.0 Operating Profit 200.0 2015A 1,100.0 800.0 2016A 1,200.0 800.0 2017P 1,320.0 990.0 2018P 1,452.0 1,089.0 363.0 2019P 1,597.2 1,197.9 399.3 300.0 400.0 330.0 10.0% Revenue growth Operating expenses as a % of revenue 10.0% 72.7% 9.1% 66.7% 10.0% 75.0% 10.0% 75.0% 80.0% 75.0% Table 2: 2019 Assumptions for data table Revenue growth Operating expenses as a % of revenue 5.0% 65.0% 10.0% 70.0% 15.0% 75.0% 20.0% 80.0% Table 1 shows a company's revenue and operating expense forecasts. However, there is little certainty around them, particularly for the 2019 forecasts. Build a data table that shows various 2019 operating profit results based on 2019 revenue growth and 2019 operating expense as % of revenue assumptions listed in B11:F13. Start your data table in cell C16. Hint: Should you encounter any problems building the data table, modify table 1 in order to resolve the problem. When you're done, click the done button below. Done! Go to next