Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help!!! Any calculations please include. EA3-A1 Create the Statement of Cash Flows for Tight Flying Co. In this exercise, you will use the indtrect

Please help!!! Any calculations please include. image text in transcribed
image text in transcribed
image text in transcribed
EA3-A1 Create the Statement of Cash Flows for Tight Flying Co. In this exercise, you will use the indtrect method to create the statement of cash flows in Excel for Tight Flying Co. The following amounts relate to June of 2016. $28,000 $2,000 Sale of Equipment Sale of Furniture $1,700 $9,300 Net Income Depreciation Expense 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) 1. Open EA3-A1-StatementofCF from your Chapter 03 folder and save it as: $9,300 Cash (beginning balance) $80,100 EA3-A1-StatementofCF-[YourName] Enter the data as described into the correct cells for the first section of the statement: 2. In this row Cell AS Cells A6 and C6 Cel Enter the data for the Header (no colon at end) First item in this section and its associated amount Is A7 and C7Only expense item and its associated amount Cells A8 and C8 First of the remaining two items and its associated amount Cells A9 and C9 Final item and its associated amount Cells A10 and D10 Final description for ino colon) and a formula to summarize the itemsin the first section Hint: Enter the items in rows 8-9 in the order they would appear in the balance sheet 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 (no colon at end First item in this section and its associated amount Second item in this section and its associated amount Final description for (no colon) and a formula to summarize the items in the second section Hint: Enter items alphabetically in this

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

NHS Audit Committee Handbook Practical Guides

Authors: Governance And Audit Committee

3rd Edition

1904624839, 978-1904624837

More Books

Students also viewed these Accounting questions

Question

Prepare a physical DFD based on the output from Short Problem.

Answered: 1 week ago