I have to complete a cash flow statement from the attached worksheet and I don't know how.

Thanks!

RC 5-15 MT 480 Case Study Bob Smith Loan Review Data for Teams Comparative Balance Sheets and Cash Flow Statement Worksheet The bank told Bob to increase cash to $70,000 from 2013 to 2014. But cash increased from $16,566 in 2013 to just $33,411 in 2014, well short of $70,000,... why... ASSETS Cash and marketable securities Accounts receivable Inventory Other current assets Total current assets Gross Plant and equipment Less: Accumulated depreciation $ $ $ $ $ $ $ 2014 33,411 260,205 423,819 41,251 758,686 1,931,719 (419,044) $ $ $ $ $ $ $ 2013 Cash Up or Down 16,566 $ 16,845 318,768 $ 58,563 EXPLAIN 352,740 $ (71,079) EXPLAIN 29,912 $ (11,339) 717,986 $ (40,700) 1,609,898 (321,821) (206,678) 212,366 Net plant and equipment $ 1,512,675 $ 1,403,220 $ (109,455) EXPLAIN Goodwill and other assets Total Assets $ $ 382,145 2,653,506 $ $ 412,565 $ 2,533,771 30,420 (119,735) LIABILITIES AND EQUITY Accounts payable and accruals $ 378,236 $ 332,004 $ 46,232 EXPLAIN Notes payable Accrued income taxes $ $ 14,487 21,125 $ $ 7,862 $ 16,815 $ 6,625 EXPLAIN 4,310 Total current liabilities $ $ Long-term debt Total liabilities Preferred stock Common stock (10,000 shares) Additional paid in capital Retained earnings Less: Treasury stock Total common equity Total Liabilities and Equity $ $ $ $ $ $ $ $ $ 413,848 679,981 1,093,829 10,000 975,465 587,546 (13,334) 1,559,677 2,653,506 $ $ $ $ $ $ $ $ $ $ $ 356,681 $ 793,515 $ 1,150,196 10,000 975,465 398,110 1,383,575 2,533,771 57,167 (113,534) EXPLAIN (56,367) 0 0 189,436 (13,334) 176,102 119,735 In addition, it was reported that the company had a net income of $3,155,848 and depreciation expenses were equal to $212,366 during 2014. Net Income $3,155,848 Depreciation $212,366 Dividends Paid -$2,966,412 Explain how the six highlighted accounts impacted cash flow from one year to the next. The accounts either added or reduced the cash balance from one year to the next. I.e., the accounts were either a Source or Use of cash. This one worksheet provides all the data you need to complete the project. You may want to assign each team member a respective 'Explain