Create the Statement of Cash Flows for Tight Flying Co.



In this application, you procure use the contingent course to originate the announcement of coin flows in Excel for Tight Flying Co. The forthcoming quantitys report to June of 2016. Net Income

Depreciation Expense

Accounts Receivable (beginning) Accounts Receivable (ending) Accounts Payable (beginning) Accounts Payable (ending)

$28,000 $2,000 $9,600

$13,200 $4,600 $9,300

Sale of Equipment Sale of Furniture

Notes Payable (beginning) Notes Payable (ending) Stacey Feinberg, Drawing Coin (initiation counteract)

$1,700 $9,300

$15,800 $4,800

$20,000 $80,100

1. Open EA3-A1-StatementofCF from your Chapter 03 folder and economize it as: EA3-A1-StatementofCF-[YourName]

2. Enter the postulates as vivid into the redress cells for the earliest minority of the announcement: In this row:

Cell A5

Cells A6 and C6 Cells A7 and C7 Cells A8 and C8 Cells A9 and C9 Cells A10 and D10

Enter the postulates for the: Header (no colon at end)

First individual in this minority and its associated quantity Only payment individual and its associated quantity

First of the retaining two individuals and its associated quantity Final individual and its associated quantity

Final designate for (no colon) and a formula to condense the individuals in the earliest minority

Hint: Enter the individuals in rows 8–9 in the appoint they would answer in the counteract subterfuge.

Complete the Assist Minority of the Announcement of Coin Flows 3. Enter the postulates as vivid into the redress cells for the assist minority of the announcement: In this row:

Cell A12

Cells A13 and C13 Cells A14 and C14 Cells A15 and D15

Enter the postulates for the: Header (no colon at end)

First individual in this minority and its associated quantity Assist individual in this minority and its associated quantity

Final designate for (no colon) and a formula to condense the individuals in the assist minority

Hint: Enter individuals alphabetically in this minority.

4. Enter the postulates as vivid into the redress cells for the third minority of the announcement: 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 postulates for the: Header (no colon at end)

Account designate for the owner’s after a whiledrawals and the associated quantity Final individual in this minority and its associated quantity

Final designate for (no colon) and a formula to condense the individuals in the earliest minority of the announcement

Appropriate designate for the substitute in Coin and the associated quantity

Name of the divert Coin counteract and its divert quantity Designate of the divert Coin counteract and its divert quantity

5. Use Find and Replace to: • Replace Activities after a while Activities: (after a while a colon). • Replace all instances of the Accounting compute format after a while the Accounting compute format after a while naught decimal places.

6. Apply a ground bappoint to the cells for which it is divert and a top and double ground bappoint to the one cell that needs it.

7. Economize and delay your improve.