Bor Chapter 3.pdf X Por Chapter 4 (1).pdf X PDE Chapter 6.pdf X por Chapter 9.pdf X DDE Chapter 10.pdf X + X File | C:/Users/walte/Downloads/Chapter%203.pdf Cp . . . | | V Draw ~ | Read aloud Ask Copilot + 2 of 2 Q | ED Q 16 89 503 88 Excel for Accounting Chapter 3: Statement of Cash Flows 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) O 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 28 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-3) 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)Bor Chapter 3.pdf X Por Chapter 4 (1).pdf X ODE Chapter 6.pdf X PDE Chapter 9.pdf X QDE Chapter 10.pdf X + X File | C:/Users/walte/Downloads/Chapter%203.pdf Cp . . . | | V Draw ~ | Read aloud Ask Copilot + 1 of 2| 2 | ED 503 Apply Your Skills If your classroom is using eLab with Project Grader ("PG"), download and use the eStart file on the Assignments page and submit as directed. If you don't use the eStart file, your work cannot be automatically graded. If you are not using Project Grader, open the indicated file from your chapter folder. EA3-A1 Create the Statement of Cash Flows for Tight Flying Co. PG O In this exercise, you will use the indirect method to create the statement of cash flows for Tight Flying Co. Access the proper file. . Using Project Grader: Download EA3-A1-StatementofCF-eStart. + . Not using Project Grader: Open EA3-A1-StatementofCF. These amounts relate to June 2026: Net Income: $28,000 Sale of Equipment: $1,700 Depreciation Expense: $2,000 Sale of Furniture: $9,300 Accounts Receivable (beginning): $9,600 Notes Payable (beginning): $15,800 Accounts Receivable (ending): $13,200 Notes Payable (ending): $4,800 Accounts Payable (beginning): $4,600 Stacey Feinberg, Drawing: $20,000 Accounts Payable (ending): $9,300 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 co 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