all of 17.15 please

E17.15 (LO 5), Excel Comparative balance sheets for International Company are presented as follows. Prepare a worksheet. International Company Comparative Balance Sheets December 31 2020 2019 Assets $ 73,000 $ 22,000 Cash Accounts receivable 85,000 76,000 Inventory 180,000 189,000 Land 75,000 100,000 Equipment 250,000 200,000 (66,000) Accumulated depreciation-equipment (42,000) Total $597,000 $545,000 Liabilitio s and Stockholders' Eguity 2020 2019 Land 100,000 75,000 Equipment 250,000 200,000 Accumulated depreciation-equipment (66,000) (42,000) $545,000 Total $597,000 Liabilities and Stockholders' Equity 2020 2019 $ 34,000 $ 47,000 Accounts payable Bonds payable Common stock ($1 par) 200,000 150,000 214,000 164,000 Retained earnings 199,000 134,000 $597,000 $545,000 Total Additional information: 1. Net income for 2020 was $135,000. 2. Cash dividends of $70,000 were declared and paid. 3. Bonds payable amounting to $50,000 were redeemed for cash $50,000. 4. Common stock was issued for $50,000 cash. Additional information: 1. Net income for 2020 was $135,000. 2. Cash dividends of $70,000 were declared and paid. 3. Bonds payable amounting to $50,000 were redeemed for cash $50,000. 4. Common stock was issued for $50,000 cash. 5. Depreciation expense was $24,000. 6. Sales revenue for the year was $978,000. 7. Land was sold at cost, and equipment was purchased for cash. Instructions Prepare a worksheet for a statement of cash flows for 2020 using the indirect method. Enter the reconciling items directly on the worksheet, using letters to cross-reference each entry. Problems: Set A