Question: please do it in excel p E17.9 (LO 2), Financial Statement Here are comparative balance sheets for Velo Company. Prepare a statement of cash flows-indirect
please do it in excel
p
E17.9 (LO 2), Financial Statement Here are comparative balance sheets for Velo Company. Prepare a statement of cash flows-indirect method. 2019 Velo Company Comparative Balance Sheets December 31 Assets 2020 Cash $ 63,000 Accounts receivable 85,000 Inventory 170,000 Land 75,000 Equipment 270,000 Accumulated depreciation equipment (66,000) Total $597,000 Liabilities and Stockholders' Equity Accounts payable $ 39,000 Bonds payable 150,000 Common stock ($1 par) 216,000 Retained earnings 192,000 Total $597,000 $ 22,000 76,000 189,000 100,000 200,000 (32,000) $555,000 $ 47,000 200,000 174,000 134,000 $555,000 Additional information: 1. Net income for 2020 was $93,000. 2. Cash dividends of $35,000 were declared and paid. 3. Bonds payable amounting to $50,000 were redeemed for cash $50,000. 4. Common stock was issued for $42,000 cash. 5. No equipment was sold during 2020, but land was sold at cost. Instructions Prepare a statement of cash flows for 2020 using the indirect method
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
