Question: Can you check my figures using the provided data? The cash flow statement is set how the instructor has asked for it to be formatted.
Can you check my figures using the provided data? The cash flow statement is set how the instructor has asked for it to be formatted. I think my Cash and cash equivalents, end of period 50,266, are incorrect. That it should be 16,566 (end of period 2016)
Bob Smith, Inc. Common-Size Balance Sheet (Both % columns need to be completed) Assets 2017 2016 Current Assets Cash 33,411.00 1% $ 16,566.00 1% 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 Accounts Receivable 260,205.00 10% $ 318,768.00 13% $70,000. In this assignment, you will review six select changes in the Balance Sheet accounts, highlighted in yellow, to better understand how these Inventory 423,819.00 6% s 352,740.00 individual account changes impact overall cash flows. 14% Other Current Assets 41,251.00 2% S 29,912.00 1% Total Current Assets $ 758,686.00 $ 717,986.00 2017 and Needed to foot the Cash Flow Statement all the way 2016 Comparative back to 2017 cash position. ASSETS 2017 Net Income $3,155,848 Fixed Assets 2016 Items 1 to 6. Note the $ value Depreciation 212,366 PP&E $ 1,512,675.00 57% $ 1,403,220.00 55% effect on Cash. Did the change in Dividends Paid 2,966,412 Goodwill other assets 382,145.00 14% $ 412,565.00 16% balances from one year to the Tax 225,700 Total Fixed Assets $ 1,894,820.00 $ 1,815,785.00 next create (+) or 'use' (-) cash? Note the accounting or finance Total Assets $2,653,506.00 $2,533,771.00 issue related to each of the six Cash $ $ 33,411 $ $ 16,566 accounts reviewed Liabilities & Equity 2017 2016 Accounts Receivable S 260,205 318,768 Current Liabilities Accounts Payable 378,236.00 35% $ 332,004.00 29% Inventory 423,819 S 352,740 71,079 Wages Payable 14,487.00 $ 7,862.00 Accrued Income Taxes 21,125.00 2% S Other current assets 16,815.00 1% 41.251 29.912 (1 1,339) Total Current Assets 758.686 $ 413,848.00 717,986 Total Current Liabilities $ (40.700 356,681.00 Long Term Liabilities Plant Property and Equipment 1.512.675 S 1.403,220 109,455 Long-Term Debt: Bank Notes $ 679,981.00 62% $ 793,515.00 69% Goodwill and other assets 382.145 412.565 30.420 Total Long Term Liabilities Total Assets 2.653.506 2.533.771 [119.735) Total Liabilities $1,093,829.00 $1,150,196.00 LIABILITIES AND EQUITY Equity Accounts Payable S 378.236 8 332.014 46,232 Total Common Equity $1,559,677.00 $1,383,575.00 Total Liabilities & Equity $2,653,506.00 $2,533,771.00 Waves Payable 14.487 Z.862 6,625 Accrued income taxes 21.125 S 16815 4310 Total Current Liabilities s S 413,848 S S 356.681 57,167 Bob Smith, Inc. Statement of Cash Flows Long-Term Debt: Bank Notes 679.981 8 793.515 (113,534) For the Year Ended December 31, 2017 provided in the data worksheet. ) Total Liabilities 1,093,829 1,150,196 (56,367) Period Ending: Dec-17 Total Common Equity 1.559.677 1,383.575 176,102 Total Liabilities and Equity 2.653.506 $ 2.533.771 119.735Bob 5mith, Inc. Statement of Cash Flows For the Year Ended December 31, 2017 provided in the data worksheet.) . . Period Ending: Dec-17 Cash flows from operating activities: Net income (loss) Depreciaiton Accounts Payable Accounts Receivable Wages Payable Accrued Income Taxes Other Current Assets (subtract) Inventories subtract Net cash from Operations 3,401,526 Cash flows from investing activities: Sale of Goodwill 30420 (109,445) PP&E subtract Net cash from Investments (79.025) Cash flows from financing activities: Bank Notes (subtract) (113,534] Dividends paid [subtract) (2,966,412) Tax subtract Net cash used in financing activities 3.305,646
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Students Have Also Explored These Related Accounting Questions!