Using excel format

\fAdditional data for 2020 are as follows: 0 Said equipment with a bunk vaiue of $30,000 (2 $40,000 cast $10,000 accumulaned depreciation} for $28,000 cash 0 Purchased equipment for $96,000 cash 0 There were no sales of long-term inveshneitts (Hint: Solve for the purchase of long-term investments.) 0 Issued bonds for $16,000 cash 0 Repurchased common stock (treasuryr shares) for $45,000 cash 0 Declared and paid $12,000 in cash dividends Required: 1. Use the four steps described in the chapter to prepare a statement of cash ows for the year ended December 31, 2020, using the rimmed mediod. Refer to the format presented in Figure 6.? \"Statement of Cash Fiows (Home Store, Inc.)". 2. Briey describe the major changes in cash identified in the statement of cash ows.