Question: I put the link in the comment EA3-A1 Create the Statement of Cash Flows for Tight Flying Co. You will use the indirect method to

I put the link in the comment

EA3-A1 Create the Statement of Cash Flows for Tight Flying Co. You will use the indirect method to create the statement of cash flows for Tight Flying Co. These amounts relate to June 2026: Net Income $28,000 Depreciation Expense $2,000 Accounts Receivable (beginning) $9,600 Accounts Receivable (ending) $13,200 Accounts Payable (beginning) $4,600 Accounts Payable (ending) $9,300 Sale of Equipment $1,700 Sale of Furniture $9,300 Notes Payable (beginning) $15,800 Notes Payable (ending) $4,800 Stacey Feinberg, Drawing $20,000 Cash (beginning balance) $80,100 First Section

Location What to Enter Cell A5 Header (no colon at end) (PG-1a) Cells A6 and C6 Name and amount of the first item in this section (PG-1b) Cells A7 and C7 Name and amount of the only expense item (PG-1c) Cells A8 and C8 Name and amount of next item (per the order presented in the chapter; no abbreviations) (PG-1d) Cells A9 and C9 Name and amount of the final item (no abbreviations) (PG-1e) Cells A10 and D10 Description of the final amount (no colon) and a formula to calculate that amount (PG-1f) Hint: For rows 8-9, enter the items in the order they would appear in the balance sheet. Also, for the description in cell A10, recall that the phrasing changes depending on whether the amount in cell D10 is positive or negative. Second Section

Location What to Enter Cell A12 Header (no colon) (PG-2a) Cells A13 and C13 Name and amount of the largest item (PG-2b) Cells A14 and C14 Name and amount of the smallest item (PG-2c) Cells A15 and D15 Description of the final amount (no colon) and a formula to calculate that amount (PG-2d) Hint: To determine the appropriate description for cell A15, check whether the associated amount in cell D15 is positive or negative. Third Section Location What to Enter Cell A17 Header (no colon at end) (PG-3a) Cells A18 and C18 Account name for the owner's withdrawal account and its amount (PG-3b) Cells A19 and C19 Account name for the long-term liability account and its amount (no abbreviations) (PG-3c) Cells A20 and D20 Description of the final amount (no colon) and a formula to calculate that amount (PG-3d) Cells A22 and D22 Appropriate description for the change in Cash and a formula to calculate that amount (PG-3e) Cells A23 and D23 Name of the appropriate Cash balance and its amount (PG-3f) Cells A24 and D24 Name of the appropriate Cash balance and a formula to calculate that amount (PG-3g) Hint: For the cell A20 description, again, check whether the associated amount is positive or negative.

Use Find and Replace:

Replace Activities with Activities: (with a colon) (PG-4a) Replace all instances of the Accounting number format alone to the Accounting number format with zero decimal places. (PG-4b) To finalize the worksheet, apply a Bottom Border to the cells for which it is appropriate and apply the "Top and Double Bottom Border" to the one cell that needs it. (PG-4c) Save and close the file.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!