PLEASE MAKE SURE TO USE A FORMAT OF EXCEL IF YOU SCREEN SHOT IT OR WRITE IN PAPER OR ANY OTHER WAY YOU CAN SHOW THE WORK!!!!!!!!

EA3-R1 Create the Statement of Cash Flows for Waterfall Management Inc. In this exercise, you will use the indirect method to create a statement of cash flows in Excel for Waterfall Management Inc. The following amounts relate to April of 2016 $57,000 $1,500 Purchase of Equipment Purchase of Machinery $31,000 Net Income Amortization Expense Accounts Receivable (beginning) $17,500 Notes Payable (beginning) $20,000 Accounts Receivable (ending) Accounts Payable (beginning) Accounts Payable (ending) 1. Open EA3-R1-StatementofCF from your Chapter 03 folder and save it as: $18,500 S4,500 Notes Payable (ending) $1,200 9,200 Cash (beginning balance) $147,000 $9,000 $4,000 Michael Elba, Drawing EA3-R1-StatementofCF-[YourNamel 2. In cell A5, type a header for the first section of the statement and do not include a colon at the end. Enter the first item for this section in cell A6 and its associated amount in cell C6 Enter the name of the only expense item for this section in cell A7 and its associated 3. 4. amount in cell C7 5. Enter the remaining two items for this section on rows 8-9 in the order they appear in the balance sheet. 6. In cell A10, begin typing Cash Flows and complete the entry based on the informa tion in this section of the statement (do not include a colon)