Please in the missing cells use a formula (specify the cells you used in order to get the value missing).

here is a picture of the formulas professor gave to solve some of the missing pieces in the case.

Format Data Tools Add-ons Help Last edit was seconds ago 100% * $ % .0 .00 123- Arial 11 B C D E F G H K M N P Q R S T U V Instructions: Attached are partial financial statements for Garners' Platoon Mental Health Care, Inc. Fill in the blanks (highlighted cells with yellow) on the two financial statements; the balance sheet and the income statemetn. 13 15 The statement of cash flows is just for your information to review/analyze since we did not discuss much in class. 16 The highlighted cells have formulas so you can understand from where (balance sheet or income statement) the numbers are derived. 17 18 8 & S 8 8 8 8 8 9 8 8 8 8 8 8 8 8 8 + Instructions Balance Sheet Income Statement Statement of Cash Flows CHAPTER 2 H....XIsx SELF WEALTH....pdf EXTRA CREDIT....pdf ~100% $ % .0 .00 123- Times New... - 12 B I S A D. H E - E F H . . C + Y . E. fx A B C D E G H J K L M N 0 P Q R S Garners' Platoon Mental Health Care, Inc. 2 Balance Sheet as of December 31, 2018 and 2017 3 (in millions of dollars) 4 5 2018 2017 2018 2017 Assets Liabilities and Equity 7 Current assets: Current liabilities: 10 00 Cash and marketable Accrued wages and taxes $316 $242 securities $421 Accounts payable 867 791 10 Accounts receivable 1,020 Notes payable 714 11 Inventory 1,760 1,581 Total $2,055 $1,747 12 Total $3,290 13 Long-term debt: $3,090 14 Fixed assets: 15 Gross plant and Stockholders' equity: 16 equipment $4,743 Preferred 30 million st $60 $60 17 Less: Depreciation 840 640 Common stock and paid-in 18 Net plant and surphi 200 million st 637 19 equipment $4,972 Retained earnings 3,312 2440 20 Other long-term assets 790 Total $4,009 $3,137 21 Total $5,864 $4,893 22 Total liabilities and equity $9,154 $7,889 23 Total assets $7,889 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 + E Instructions Balance Sheet Income Statement Statement of Cash FlowsB C D E F G H K M 1 Garners' Platoon Mental Health Care, Inc. D W N Income Statement for Years Ending December 31, 2018 and 2017 (in millions of dollars) 2018 2017 Net sales $4,980 2,035 10 00 Less: Cost of goods sold Gross profits $2,734 $2,313 Less: Other operating expenses 125 100 10 Earnings before interest, taxes, depreciation, and 11 amortization (EBITDA) 2,609 2,213 12 Less: Depreciation 200 191 13 Earnings before interest and taxes (EBIT) $2,409 14 Less: Interest 285 15 Earnings before taxes (EBT) $2,094 $1,737 16 Less: Taxes 17 Net income $1,327 $1,105 18 19 20 Less: Preferred stock dividends $60 21 Net income available to common stockholders $1,267 $1,045 22 Less: Common stock dividends 395 395 23 Addition to retained earnings $872 24 Per (common) share data: 25 Earnings per share (EPS) 26 Dividends per share (DPS) 27 Book value per share (BVPS) 28 Market value (price) per share (MVPS) $26.85 $22.50 29 30 31 32 33 34 35 36 37 38 39 + E Instructions Balance Sheet Income Statement Statement of Cash FlowsJX A B C D E F G H J K L M N 0 P Q R Garners' Platoon Mental Health Care, Inc. 2 Statement of Cash Flows for Year Ending December 31, 2018 (in millions of dollars) A. Cash flows from operating activities 6 Net income $1,327 7 Additions (sources of cash): 8 Depreciation 200 9 Increase in accrued wages and taxes 74 10 Increase in accounts payable 76 11 Subtractions (uses of cash): 12 Increase in accounts receivable 1,020 13 Increase in inventory -179 14 Net cash flow from operating activities: $2,518 15 16 B. Cash flows from investing activities 17 Subtractions: 18 Increase in fixed assets 4,743 19 Increase in other long-term a 790 20 21 Net cash flow from investing $5,533 22 23 C. Cash flows from financing activities 24 Additions: 25 Increase in notes payable -714 26 Increase in long-term debt 3,090 27 Increase in common and pref 637 28 Subtractions: 29 Dividends -455 30 31 Net cash flow from financing $2,558 32 33 D. Net change in cash and marketable securities $26 34 35 36 37 38 39 40 + Instructions Balance Sheet Income Statement Staterent of Cash Flows