Hello, I need the complete the 2017 Cash Flow Statement. In addition, your team will also prepare Common Sized Financial Statements for the 2 years shown for my assignment.

Read the scenario, and then access the data worksheet below. Review the grading rubric, which provides some tips on how to organize your team process.

Scenario: The team assignment requires an analysis of specific financial data of Bob Smith, Inc. Bob is an existing bank customer. When the loan to Bob was originally made in 2016, the bank required Bob to increase the YE 2016 cash balance to at least $70,000 to qualify for the interest rate that the bank used for the original loan. This cash balance was required for the bank to make its target yield on the loan created. The Cash Flow Statement and Balance Sheet show an actual YE 2017 cash balance of less than $34,000.

The team assignment requires participation in a team effort to complete the 2017 Cash Flow Statement. In addition, your team will also prepare Common Sized Financial Statements for the 2 years shown. In the Unit 1 Seminar, you discussed how to complete and use the 2017 Cash Flow Statement outcomes to explain how specific accounts influenced Bobs low cash balances; in other words, some reasons why Bob has no cash!

XYZ Bank told Bob to increase cash to $70,000 from 2016 to 2017. But cash increased from $16,566 in 2016 to just $33,411 in 2017, well short of $70,000. In this assignment, you will review six select changes in the Balance Sheet accounts, highlighted in yellow, to better understand how these individual account changes impact overall cash flows. 2017 and 2016 Comparative ASSETS 2017 2016 Needed to foot the Cash Flow Statement all the way back to 2017 cash position. Net Income $3,155,848 Depreciation 212,366 Dividends Paid 2,966,412 Tax 225,700 Items 1 to 6. Note the $ value effect on Cash. Did the change in balances from one year to the next create (+) or 'use' (-) cash? Note the accounting or finance issue related to each of the six accounts reviewed. . Cash $ $ 33,411 $ $ 16,566 Accounts Receivable $ 260,205 $ 318,768 Inventory $ 423,879 $ 352,740 71,079 Other current assets Total Current Assets $ S 41.251 758.686 $ $ 29,912 $ 717,986 S (11,339) (40,700) Plant Property and Equipment 1.512.675 1.403,220 109,455 Goodwill and other assets Total Assets $ S 382.145 2.653.506 $ 412.565 S $ 2.533.771 30,420 (119.735 LIABILITIES AND EQUITY Accounts Payable $ 378,236 5 332,004 46,232 Wages Payable Accrued income taxes Total Current Liabilities s 14,487 $ 21.125 SS 413.848 $ 7.862 $ $ 16,815 $ $ $ 356,681 $ 6,625 4,310 57,167 Long-Term Debt: Bank Notes 679.987 $ 793,515 (113,534) Total Liabilities Total Common Equity Total Liabilities and Equity S s $ s 1,093,829 1,559,677 2.653.506 S 1,150,196 $ 1,383,575 S2.533.771 (56,367) 176,102 119.735