Question: You will need to complete the 2017 Cash Flow Statement. In addition, you will also prepare the Common Sized Financial Statements for the 2 years
You will need to complete the 2017 Cash Flow Statement. In addition, you will also prepare the Common Sized Financial Statements for the 2 years shown.
| Bob Smith, Inc. Common Sized Financial Statement | ||||||
| Assets | ||||||
| 2016 | 2017 | Change from 2016 to 2017 | ||||
| Net Sales | $3,155,848 | |||||
| Amount | Percent | Amount | Percent | Amount | Percent | |
| Cash | $16,566 | 0.65% | $33,411 | 1.2% | $16,845 | 0.01% |
| Accounts Receivable | $318,768 | 12.5% | $260,205 | 9.8% | $58,563 | 0.11% |
| Inventory | $352,740 | 13.9% | $423,819 | 15.9% | $71,079 | 0.13% |
| Other Current Assets | $29,912 | 1.1% | $41,251 | 1.5% | ($11,339) | 0.01% |
| Plant, Property & Equipment | $1,403,220 | 55.3% | $1,512,675 | 57% | $109,455 | |
| Goodwill & Other Assets | $412,565 | 16.2% | $382,145 | 14.4% | $30,420 | 0.13% |
| Total Assets | $2,533,771 | $2,653,506 | ($119,735) | |||
| Liabilities & Equity | ||||||
| Accounts Payable | $332,004 | 13% | $378,236 | 14.2% | $46,232 | 1.2% |
| Wages Payable | $7,862 | 0.31% | $14,487 | 0.54% | $6,625 | 0.53% |
| Accrued Income Taxes | $16,815 | 0.66% | $21,125 | 0.79% | $4,310 | 0.78% |
| Total Current Liabilities | $356,681 | 14% | $413,848 | 15.5% | $57,167 | 13.3% |
| Long-term Debt Bank Notes | $793,515 | 31.3% | $679,981 | 25.6% | $113,534 | 17.5% |
| Total Liabilities | $1,150,196 | 45.3% | $1,093,829 | 41.2% | $56,367 | 22.5% |
| Total Common Equity | $1,383,575 | 54.6% | $1,559,677 | 58.7% | $176,102 | 26.6% |
| Total Liabilities & Equity | $2,533,771 | $2,653,506 | $119,735 | |||
| Bob Smith, Inc. Statement of Cash Flows for the Year End December 31, 2017 | |
| Period Ending: | Dec-17 |
| Cash flows from operating activities | |
| Net Income | $3,155,848 |
| Depreciation | $212,366 |
| Accounts Receivable | $58,563 |
| Inventory | ($71,079) |
| Other Current Assets | ($11,339) |
| Accounts Payable | $46,232 |
| Wages Payable | $6,625 |
| Taxes | ($225,700) |
| Accrued Income Taxes | $4,310 |
| Net cash provided by operation activities | |
| Cash flow from investing activities: | |
| Goodwill and other assets | $30,420 |
| PP&E | ($109,445) |
| Depreciation | ($212,366) |
| Net cash from Investments | |
| Cash flows from financing activities | |
| Long-term debt bank notes | (113,534) |
| Dividends paid | $2,966,412 |
| Tax | |
| Net cash used in financing activities | |
| Net increase (decrease) in cash & cash | $16,845 |
| Cash start of period | $33,411 |
| Cash end of period | $16,566 |
| Quick Ratio | 0.44 |
| Current Ratio | 1.83 |
Please review my calculations and help me figure out what I did wrong
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
