need help with the empty yellow Spaces and Explain the answers plus how to work it on Excel ,thanks.
B C D G 16 17 18 We Really Love Cash, Co. Comparative Balance Sheet December 31 We Really Love Cash, Co. Income Statement For the Year ended December 31, 2020 19 20 21 22 23 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 gods sold Gross profit Operating expenses Income from operations Inscret 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 $12,000 25 26 27 28 29 30 31 32 33 34 35 36 Liabilities and Stockholders' Equity Accounts payable Income taxes payable Bonds payable Cormon stock Retained earning Total abilities and Stockholders' Equity $24,000 7,000 27,000 18,000 51.000 5127,000 $15,000 8,000 33,000 14,000 38,000 $108,000 37 38 39 40 Additional data: 1. Dividends declared and paid were $19,000 2. Daring 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 42 43 45 46 47 49 50 51 52 54 2. 3 $ 32,000 11 1 We Really Love Cash, Co. Statement of Cash Flows 3 For the year ended December 31, 2020 4 Cash Flows from operating Activities 5 Net Income 6 Adjustments to reoncile net income to Net Cash 7 Used by Operating Activities Depreciation expense Increase in accounts receivable 10 Increase in inventory Increase in accounts payable 12 Decrease in Income tax payable 13 Total Cash used in investing activities 14 15 Cash flows from investing activities 16 Sale of equipment Net used in investing activities 18 19 Cash flows from investing activities 20 Procceds of issue of common stock 21 Procceds to repayment of bonds Dividend paid 23 17 22 24 25 26 Net cash used in financing activities 27 28 29 Free Cash Flow: 30 Net increase in cash and cash equivalents 31 rash and equivalente at beginning of nerind 14 15 Cash flows from investing activities 16 Sale of equipment 17 Net used in investing activities 18 19 Cash flows from investing activities 20 Procceds of issue of common stock 21 Procceds to repayment of bonds 22 Dividend paid 23 24 25 26 Net cash used in financing activities 27 28 29 Free Cash Flow: 30 Net increase in cash and cash equivalents 31 cash and equivalents at beginning of period 32 cash and cash equivalents at end of period 33 34 35 36