fill the green column please

H A 8 D 1.25 82.50% 1.20 1 Froe Cash Flows 2 (All dollar values are provided in millions) 3 2018 4 Sales, ST Invest, Notes Pay. LT Debt factor increase 5 Operating costs as % of sales 6 Cash factor increase 7 Accts Rec factor increase 8 Inventory factor increase Net Plant & Equip factor increase 10 Accts Pay factor increase 11 Accruals factor increase 12 13 Depreciation as % of Net Plant & Equip 14 Interest rate Tax rate 16 Payout rale 17 2017 Sales Cash as % of sales Accts Rec as % of sales Inventory as % of sales Net Plant & Equip as % of sales Accts Pay as % of sales Accruals as % of Sales 1.10 $5,000 1.00% 14.00% 18.00% 23.00% 8.00% 3.00% 9 1.20 1.15 1.20 1 20 10.00% 10 00% 40.00% 90 00% 15 Operating cost as % of sales Depreciation as % of Net Plant & Equip Interest rate Tax rate Payout rate Short-term investments as % of sales Notes payable as % of sales Long-term debt as % of sales 85.00% 10.00% 10.00% 40.00% 80.00% 0 50% 200% 20.00% 18 19 Sheet1 Calculaton Mode Automatic Workbook Statistics Type here to search O 99 23 2018 $6,250.0 5,156.3 132.3 $961.5 134.4 $827.1 330.9 $496.3 2017 $5,000.0 4,250.0 115.0 $635.0 107.5 $527.5 211.0 $316.5 22 Income Statements: Sales 24 Operating costs excluding depreciation 25 Depreciation and amortization 26 Earnings before interest and taxes 27 Less interest 28 Pre-tax income 29 Taxes 30 Net income available to common stockholders 31 Common dividends 32 33 Balance Sheets: 34 Assets 35 Cash 36 Short-term investments 37 Accounts receivable 38 Inventories Total current assets $446.6 $253.2 2018 2017 $60.0 31.3 770.0 $50.0 25.0 700.0 900.0 $1.675.0 1.080.0 $1.941.3 A B D 3 Total current assets Net plant and equipment Total assets $1,941.3 1,322.5 $3,263.8 $1,675.0 1,150.0 $2,825.0 1 $400.0 150.0 2 3 Liabilities and Equity 2 Accounts payable 5 Accruals 5 Notes payable 7 Total current liabilities 8 Long-term debt Total liabilities Common stock 1 Retained earnings 2 Total common equity 3 Total liabilities and equity 2 $480.0 180.0 125.0 $785.0 1,250.0 $2,035.0 1,084.2 144.6 $1,228.8 $3,263.8 100.0 $650.0 1,000.0 $1,650.0 1,080.1 95.0 $1,175.0 $2,825.0 5 FORMU NOPATA NOPAT 2018 NOWC 2018 NOWC 2017 Total net operating capital2018 Total net operating capital2017 Free cash flow 2018 5 ROIC 2018 7 3 Uses of free cash flow! After-tax interest payment 0 Reduction (increase) in debt 1 Payment of dividends 2 Repurchase (issue) stock D