Question: (Appendix 11B) Using a Spreadsheet to Prepare a Statement of Cash Flows Comparative balance sheets for Cincinnati Health Club are presented below. Additional Informtion: 1.


(Appendix 11B) Using a Spreadsheet to Prepare a Statement of Cash Flows Comparative balance sheets for Cincinnati Health Club are presented below. Additional Informtion: 1. Cincinnati Health Club reported net income of $2,800 for the year. 2. No buildings or equipment were sald during the year. Equipment was purchased for $11,000 eash. 3. Depreciation expense was $28,000. 4. Bonds payable of $50,000 were issued for cash during the year. 5. Common stock of $30,000 was issued during the year. 6. Cash dividends of $9,000 were declared and paid during the year. Required: 1. Using the data above and Exhibit 10 as a guide, ereate a spreadsheet to prepare a statement of cash flows. 2. Using your spreadsheet, construct the Statement of Cash Flows below. Assume Cincinnati Health Club uses the indirect method. Use a minus sign to enter cash o Cincinnati Health Club Statement of Cash Flows
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
