please help fill in shaded area *Excel*

U . B C D E F G H 1 2. 3 1 2 3 4 5 Sales History of Allied Food Products (in millions of U.S. dollar): Percent Change Year Sales in Sales 2015 2,058 2016 2,534 2017 2,472 2018 2,850 2019 3,000 1) 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Average Growth Rate Average 2) Coumpound Growth Rate 3) Trend Line (Trend Function 2020 4) Regression Line 22 24 25 27 Sales Forecast Income statement Balance Sheet A B B C D F G H 4 E F Ratios of Sales Calculation 2019 Ratios 2020 (Forecast) 5 Net Sales 3,000.00 1096 6 Operating costs (Cost of goods so 2,616,20 87.296 7 EBITDA 383 80 8 Depreciation 100.00 1.100 from fixed assets forecasted in Balince Sheet 1096 9 EBIT 283.80 10 Less Interest Assume 996 for short-term debt Assume 11% for long-term debt 88.00 11 EBT 196.80 12 Taxes (40%) 78.30 13 Net Income 117.50 14 15 Common dividends Assumed to grow by 8% 57.50 16 Addition to retained eamings 60.00 H Wande B G UAE TEE VERHUUR VULLUTIS VI.3. UUIION). quo ......... Ratios of Sales 2020 (Forecast) Assets 2019 Ratios Calculation Cash and equivalents $10 0.3395 6 Accounts receivable 375 1250% Inventones 615 20.509 8 Total current assets $1,000 9 Net plant and equipment 1,000 33.33% 10 Total asstes $2.000 11 12 Liabilities and Equity 13 Accounts payable $60 200% 14 Are ascom suy initially constant Notes payable 110 15 Accruals 140 4.679 10 Total current liabilities $310 17 Are assumed to stay initially constant Long-term bonds 750