JA K M P N H G D E Dec 31 2020 Dec 31 2019 B Balance Sheet - Debit balance accounts Cash A/R Inventory P.P.&E. $ Total Assets Balance Sheet - Credit balance accounts A/P N/P Common Stock Retained Earnings $ $ Total Liabilities & Equity Ratios Statement of Cash Flows Operating Activities Net Income 95000 Current Quick ROA What do these ratios tell you about the positie Total Investing Activities Total Financing Activities Total Net Cash Flow CH16-17 CH 18 eady 0 e 1 Home Insert Draw Design Layout References Mailings Review View Help ACCT 206 - Assignment 1 Handout CH 16-17 Information: Use the following to complete the CH 16-17 tab of the excel workbook provided on Blackboard. Lilly Company Balance Sheets from year-end 2017 & 2018 contained the following information: 2020 2019 Cash 2 100,000 AR 180,000 120,000 250,000 Inventory 220,000 PP&E (net of depreciation) 500,000 A/P 160,000 500,000 140,000 N/P 410,000 370,000 Common Stock 200,000 200,000 Retained Earnings 280,000 260,000 Other information for 2020 is as follows: Depreciation was 50,000 Dividends were paid out to shareholders totaling 75,000 Net income was 95,000 PPE was purchased for 50,000 The company received 40,000 from issuing long-term notes payable Prepare the statement of cash flows for 2020 using the excel template on blackboard using only formulas. 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. 2 285 words DX Type here to search O e