(Appendx 7re) Using a Spreadiheet to Prepare a Statement of Cash Hons Comparative balance sheets for cindinati Mealth Club are vresented below. Additional tnformation: 1. Cinchnat Health Club regorted net income-of $2,700 for the yean 2. No builisgs or equipment were sold during the yoar. Equipment was purchased for $10,000 cash. 3. Depteciation expense was $28,000. 4. Bonds payable of $50,000 were issued for cash during the year. 5. Comimon stock of $30,000 was issoed during the yeat. 6. Cash dividends of $10,000 were declared and paid during the year. Required: 1. Using the data above and Exhibit 10 as a guide, creatn a spreadsheer to prepare a statement of cash flows. 2. Using vourspreadaheet, construct the Staterhent of Cash Flows below. ASsume Cincinnatl Health Club uses the indirect methodi. Use a minus sign to enter cash outflows. 2. Using Your spreatfbeet, construct the Statement of Cash. Fow below. Assume Clncinat Health Club uses the indirect method. Use an minus tign to enter rash outflows Cincinnati Heath Club Statement of Cosh Flows Spreadsheet to Prepare Statement of Cash Flows