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 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