Q9 fx B C D E 2 Fill in the yellow cells with the appropriate functions/formulas. Do not type in the numerical answer. Let Excel calculate the number using your formula in the cell. Balance Sheet ($million) 2020 2019 2020 2019 Cash 24 20 Accounts Payble 216 180 Start each formula with and equal sign: = You can use these symbols in Accounts receivable 360 300 Notes Paybable 134 103 your formulas: Inventory 360 400 Accrued wages&taxes 144 120 Add Total Current Assets 744 720 Total Current Lab. Subtract Gross Plant & Equip. 650 Long-term debt/bonds 300 300 Multiply -Accumulated deprciation 150 Common stock 100 100 Divide Net Plant & Equip. 600 500 Retained earnings 450 417 Total Assets Total Stockhidr Equity Total Liab. and Equity Income Statement (Smillion) Net sales (all credit) 2400.0 2000.0 Additional information: Cost of goods sold 2040.0 1700.0 Depreciation EBIT Sheet2 Accessibility: Investigate 60.0 50.0 Average Tax Rate= Applyaverage tax rate to all Net Income shares outstanding.. 50 million 40% Make use of Parentheses: () Do not type any values in the cell or in the 1 Example of a nonsensical ratio: I want to calculate the 2012 value of: (Total Assets-Accruals)/((Retained Earnings shares outstanding)+dividen i would tvoe the following in the cell: