Indirect method

foSave Excel Project 2 - Instructions & Template - Excel Jessica Teyler Gruszecki Home Insert Page Layout Formulas Data Review View Help Search X 15 - Garamond - 12 - AA 25 Wrap Text General 49 0 E- Merge Center $ - % 98 a Delete- Format Conditional Formatas Cell Formatting Table Styles Styles Ide board Font Sort & Find & Filter Select Editing Alignment 5 Number Cells Ide A B D E F December 31 G H For the Year ended December 31, 2020 2020 2019 Assets Cash Accounts Receivable Inventory Equipment Accumulated depreciation--equipment Total Assets $39,000 30,000 27,000 60,000 (29,000) $127,000 $20,000 14,000 20.000 78,000 (24,000 $108,000 Sales revenue Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income taxes Income tax expense Net income $242,000 175,000 67,000 24,000 43,000 3,000 40,000 8.000 $32,000 Liabilities and Stockholders' Equity Accounts payable Income taxes payable Bonds payable Common stock Retained earnings Total Liabilities and Stockholders' Equity $24,000 7,000 27.000 18,000 51,000 $127,000 $15,000 8,000 33,000 14,000 38,000 $108,000 Excel Project 2 TEMPLATE Type here to search a General Paste ce Wrap Text - A.A. Merge & Center Alignment $ %68-58 Conditional Formatting Clipboard Font Number A52 X f 34 35 36 B Common stock Retained earnings Total Liabilities and Stockholders' Equity C D 18,000 51,000 $127,000 E 14,000 38,000 $108,000 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 Additional data: 1. Dividends declared and paid were $19,000 2. During the year equipment was sold for $6,500 cash. This equipment cost $18,000 originally and had a book value of $6,500 at the time of sale. 3. All depreciation expense, $16,500, is in the operating expenses. 4. All sales and purchases are on account. Excel Project 2 TEMPLATE Read HE Type here to search O Clipboard Font Alignment Number P25 B D E F 2 Available Statement of Cash Flows For the year ended Dember 31, 2020 Cash flow from opening tities Net we Adjustments to role net income to net esh provided by operating activities 1 Cells in one on the template should be . VALUE Cells is een on the template should be a FORMULA Cells in yellow on the template should be TEXT 32,000 net cash provided by operating activites Cash flows from investing activites 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cash flows from financing activites 9 27 Excel Project 2 TEMPLATE Ready Type here to search Clipboard 5 Font Alignment Number P48 X A B D E F G H 9 B) Free Cash Flow operating cash flow Capital Expendituce ON Free cash flo 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 30 Total points available Excel Project 2 TEMPLATE Read