Answered step by step
Verified Expert Solution
Question
1 Approved Answer
90 Excel for Accounting Chapter 3: Statement of Cash Flows Extend Your Skills EA3-E1 Create the Statement of Cash Flows for Survive & Thrive
90 Excel for Accounting Chapter 3: Statement of Cash Flows Extend Your Skills EA3-E1 Create the Statement of Cash Flows for Survive & Thrive Co. In this exercise, you will use the indirect method to create a statement of cash flows in Excel for Survive & Thrive Co. These amounts relate to July of 2016. Net Income $4,500 Sale of Machinery $21,000 Depreciation Expense $900 Purchase of Equipment $18,000 Accounts Receivable (beginning) $6,200 Notes Payable (beginning) $5,600 Accounts Receivable (ending) $5,100 Notes Payable (ending) $6,600 Accounts Payable (beginning) $3,000 Travis Jackman, Drawing $3,000 Accounts Payable (ending) $4,800 Cash (beginning balance): $37,400 Use the techniques from this chapter to present the statement in good form. EA3-E2 Create the Statement of Cash Flows for Big League Bullseye Corp. In this exercise, you will use the indirect method to create a statement of cash flows in Excel for Big League Bullseye Corp. These amounts relate to September of 2016. Net Income $300 Purchase of Equipment $3,100 Depreciation Expense: $2,500 Purchase of Furniture $2,400 Accounts Receivable (beginning) $9,400 Investment by Owner $1,800 Accounts Receivable (ending) $12,500 Nicholas Winfield, Drawing $1,500 Accounts Payable (beginning) $7,300 Cash (beginning balance) $11,300 Accounts Payable (ending) $6,900 Use the techniques from this chapter to present the statement in good form.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started