Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help. Any calculations pls include! EA3-R2 Create the Statement of Cash Flows for Hailstorm Co In this exercise, you will use the indirect method

Please help. Any calculations pls include!
image text in transcribed
image text in transcribed
image text in transcribed
EA3-R2 Create the Statement of Cash Flows for Hailstorm Co In this exercise, you will use the indirect method to create a statement of cash flows in Excel for Hailstorm Co. The following amounts relate to January of 2016. Net Income Depreciation Expense Accounts Receivable (beginning) $3,100Sale of Machinery $400 Purchase of Equipment $1,900 $1,900 $2,100 Investment by Owner$1,000 Accounts Recelivable (ending) $1.100 Lucas Cash (beginning balance) $7,800 Accounts Payable (beginning) Accounts Payable (ending) $2,900 $1.700 1. Open EA3-R2-StatementofCF from your Chapter 03 folder and save it as: -R2-Statemen to fCP_ [YourName] 2. In cell A5, enter a header for the first section of the statement (without a colon at 3. Enter the first item for this section in cell A6 and its associated amount in cell C6. 4. Enter the name of the only expense item for this section in cell A7 and its associated 5. Enter the remaining two items for this section on rows 8-9 in the order they appear irn the end). amount in cell C7 the balance sheet. Hint: Any amounts that result in cash fowing out of the business should be entered as negative figures within this section. 6. In cell A10, type the appropriate cash flows description based on the information in this section of the statement (do not include a colon). 7. Enter -cC6+C7+C8+C9 in cell D10. Complete the Second Section of the Statement of Cash Flows 8. In cell A12, enter a header for the second section of the statement (without a colon at the end). 9. Enter the first item for this section (enter items from largest to smallest in this section 10. Enter the second item for this section in cell A14 and its associated amount in cell C14. 11. In cell A15, type the appropriate cash flows entry based on the information in this 12. Click cell D10 and press Ctr C, click cell D15, and choose Home->Clipboard-+Paste. in cell A13 and its associated amount in cell C13. section of the statement (do not include a colon). The formula in cell D15 needs to be corrected. 13. Click in the Formula Bar to the left of C13 and tap Backspace enough times to delete the first two cell references

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

Information Audit For The Management Process Empresa Nacional De Productos Agropecuarios ENPA Of Villa Clara

Authors: Alejandra María Osorio Capote, Manuel Osvaldo Machado Rivero, Dianelys Martínez Paz

1st Edition

ISBN: 6203767883, 978-6203767889

More Books

Students also viewed these Accounting questions

Question

What is gravity?

Answered: 1 week ago

Question

What is the Big Bang Theory?

Answered: 1 week ago

Question

explain what is meant by the terms unitarism and pluralism

Answered: 1 week ago