Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

8th Edition

1285190904, 978-1305176348, 1305176340, 978-1285190907

More Books

Students also viewed these Accounting questions

Question

Which method of cost estimation is least based on company records?

Answered: 1 week ago