USE EXCEL SPREADSHEET- Prepare a complete statement of cash flows for calendar-year 20X2 using the indirect method.

The following information is available for the XYZCompany, Balance Sheets At December 31 20X2 20X1 Assets: Cash Accounts receivable Merchandise inventory $ 29,568 S 27,648 38,616 35,280 87,750 74,052 Long-term investments Machinery Accumulated depreciation 67,080 210,600 (40,260 67,680 174,600 (37.440 Total assets $393.354 $341.820 $ 78,000||$ 48,456 12,870 12,240 58,500 79.200 $149,370 $139,896 Liabilities: Accounts payable Income taxes payable Bonds payable Total liabilities Equity: Common stock Paid-in capital in excess of par Retained earnings Total equity Total liabilities and equity 140,400 15,600 87,984 $243.984 $393.354 115,200 10,800 75.924 $201.924 $341,820 XYZ Company Income Statement For Year Ended December 31, 20X2 Sales Cost of goods sold Depreciation expense Other operating expenses Interest expense Other gains (losses): Loss on sale of equipment Income before taxes Income taxes expense Net income $288,000 $97,080 35,280 57,600 2.400 (192,360 (10,080) 85,560 33.180 $ 52.380 Additional information: (1) There was no gain or loss on the sales of the long-term investments, nor on the bonds retired. (2) Old machinery with an original cost of $45,060 was sold for $2,520 cash. (3) New machinery was purchased for $81,060 cash. (4) Cash dividends of $40,320 were paid. (5) Additional shares of stock were issued for cash. Prepare a complete statement of cash flows for calendar-year 20X2 using the indirect method