Browning Company Balance Sheets from year-end 2020 & 2021 contained the following information: 2021 2020 Cash ? 80,000 A/R 110,000 30,000 120,000 Inventory 80,000 PP&E (net of depreciation) 500,000 500,000 A/P 75,000 N/P 250,000 100,000 220,000 200,000 210,000 Common Stock 200,000 Retained Earnings 225,000 Other information for 2021 is as follows: Depreciation was 30,000 Dividends paid out to shareholders totaling 25,000 Net income was 40,000 PPE purchased for 30,000 The company received 30,000 from issuing long-term notes payable Prepare the statement of cash flows for 2021 using the excel template on blackboard using only formulas (type in the balance sheet, then use formulas to fill in cash flow information). Then, calculate the ratios listed and give a brief commentary on the ratios. Numbers may be typed into the balance sheet, but only formulas should be in the cash flow and ratio sections. Di Dec 31 2020 Balance Sheet - Debl balance Cash AR Inventory P.P.&E Total Assets $ Balance Sheet.Credit balance accounts NP Common Stock Retained tamings Total liabilities & Equity 5 $ Ratis Statement of Cash Flows Operating Activities Current Quick ROA 1 What does the cash flow and ratio data tel Total Investing Activities 1 Total 3 4 Financing Activities 5 06 Total CH16-17 CH 18 + De $ 3 Balance Sheet - Debit balance accounts 1 Cash 5 AVR 6 Inventory 1 P.P.&E. 8 9 Total Assets 10 11 Balance Sheet - Credit balance accounts 12 A/P 13 N/P 14 Common Stock 15 Retained Earnings 16 17 Total Liabilities & Equity 19 20 21 Statement of Cash Flows 22 Operating Activities 23 24 25 26 27 28 Total 29 Total 30 Investing Activities 31 32 33 34 Financing Activities 35 36 37 Total