EA3-A2 Create the Statement of Cash Flows for Fitness Pros Co. In this exercise, you will use the indirect method to create a statement of cash flows in Excel for Fitness Pros Co. The following amounts relate to October of 2016. Net Income $9,000 Depreciation Expense $1,250 Purchase of Furniture Purchase of Machinery $4,900 $8,800 Accounts Receivable (beginning) $3,950 Notes Payable (beginning) $0 2 Accounts Receivable (ending) $10,750 Notes Payable (ending) $4,500 Accounts Payable (beginning) Accounts Payable (ending) $8,300 Eva Bryant, Drawing $6,000 $200 Cash (beginning balance) $35,600 1. Open EA3-A2-StatementofCF from your Chapter 03 folder and save it as: EA3-A2-Statement of CF-[YourName] Apply Your Skills 89 2. Enter the data as described into the correct cells for the first section of the statement: In this row: Cell AS Cells A6 and C6 Cells A7 and C7 Cells A8 and C8 Cells A9 and C9 Cells A10 and D10 Enter the data for the: Header (include a colon) First item in this section and its associated amount Only expense item and its associated amount First of the remaining two items and its associated amount Final item and its associated amount Final description for (with colon) and a formula to summarize the items in the first section Hint: Enter the items in rows 8-9 in the order they would appear in the balance sheet. Use an abbreviation when typing the description of the asset account. Complete the Second Section of the Statement of Cash Flows 3. Enter the data as described into the correct cells for the second section of the statement: In this row: Cell A12 Cells A13 and C13 Cells A14 and C14 Cells A15 and D15 Enter the data for the: Header (include a colon) First item in this section and its associated amount Second item in this section and its associated amount Final description for (with colon) and a formula to summarize the items in the second section Hint: Enter items alphabetically in this section. Complete the Third Section of the Statement of Cash Flows 4. Enter the data as described into the correct cells for the third section of the statement: In this row: Cell A17 Cells A18 and C18 Cells A19 and C19 Cells A20 and D20 Cells A22 and D22 Cells A23 and D23 Cells A24 and D24 Enter the data for the: Header (include a colon) Description for the liability account that should be entered and the associated amount Final item in this section and its associated amount Final description for (with colon) and a formula to summarize the items in the first section of the statement Appropriate description for the change in Cash and the associated amount Name of the appropriate Cash balance and its appropriate amount Name of the appropriate Cash balance and its appropriate amount 5. Use Find and Replace to: . . Replace A/R with Accounts Receivable. Replace all instances of the Accounting number format with the Accounting number format with zero decimal places. 6. Apply a bottom border to the cells for which it is appropriate and a top and double bottom border to the one cell that needs it. 7. Save and close your file. of Macre AutoSave (Off AS-On File Home Insert Draw Page Layout PROTECTED VIEW I In Ac A1 EA3-A2-StatementofCF Protecte... Jeremy Desumala Formulas Data Review View Help Tell me Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. fx Fitness Pros Co. A C D E G 1 4 231569 Student 7 8 9 -Statement 10 IT Statement 12 -Statement 13 -Statement 14 P-Statement 15 10 17 18 Fitness Pros Co. Statement of Cash Flows For the Month Ended October 31, 2016 19 20 21 22 23 24 25 26 27 28 29 30 31 Sheet1 Ready