In: Accounting
Prepare a balance sheet and cash flow statement using the selected financial statement information and additional data for Stanislaus Co. presented below.
Balance sheet
December 31 2015
Cash.......................................................... $52,000
Accounts receivable (net)........................... 64,000
Inventory.................................................. 178,000
Land.......................................................... 78,800
Equipment................................................. 504,000
TOTAL............................................ $876,800
Accumulated depreciation.......................... $94,000
Accounts payable....................................... 50,400
Notes payable - short-term........................ 67,200
Notes payable - long-term.......................... 178,000
Common stock........................................... 420,000
Retained earnings...................................... 67,200
TOTAL............................................ $876,800
Trial balance
December 31, 2016
................................................................. DR CR
Cash.......................................................... $60,000
Accounts receivable gross........................... 75,000
Allowance for doubtful accounts…………………..4,500
Inventory.................................................. 148,000
Land.......................................................... 58,600
Equipment................................................. 620,000
Accumulated depreciation........................40,000
Accounts payable....................................... 48,700
Notes payable - short-term........................ 24,200
Notes payable - long-term.......................... 154,000
Common stock........................................... 420,000
Retained earnings...................................... 67,200
Sales revenue........................................................... . 630,500
Cost of goods sold……………………………….285,000
Salary expense……………………………………95000
Advertising expense…………………………… 14,600
Depreciation expense…………………………… 10,000
Bad debt expense…………………………………2,500
Other expense……………………………………20,000
Additional data for 2016:
1. Land was sold at its original cost.
2. Equipment was purchased
3. Notes were repaid
| Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | ||
| Balance Sheet as on December 31 2016 | ||
| Cash | $ 60,000 | |
| Accounts Receivable | $ 75,000 | |
| Allowance for doubtful accounts | $ -4,500 | |
| Accounts Receivable,Net | $ 70,500 | |
| Inventory | $ 148,000 | |
| Total Current Assets | $ 278,500 | |
| Land | $ 58,600 | |
| Equipment | $ 620,000 | |
| Accumulated Depreciation | $ -40,000 | |
| Equipment, Net | $ 580,000 | |
| Total Assets | $ 917,100 | |
| Accounts payable | $ 48,700 | |
| Notes payable - short-term | $ 24,200 | |
| Total Current Liabilities | $ 72,900 | |
| Notes payable - long-term | $ 154,000 | |
| Total Liabilities | $ 226,900 | |
| Common stock. | $ 420,000 | |
| Retained Earning (67200+203000 Net Income) | $ 270,200 | |
| Total Liabilities and Equities | $ 917,100 | |
| Cash Flow | ||
| Net Income | $ 203,000 | |
| Adjustment to Net income: | ||
| Depreciation Expenses | $ -54,000 | |
| Increase in Receivable | $ -6,500 | |
| Decerease in inventory | $ 30,000 | |
| Decrease in Accounts Payable | $ -1,700 | |
| Decrease in Note Payable | $ -43,000 | |
| Net Cash flow from Operating Activities | $ 127,800 | |
| Cash flow from Investing activities: | ||
| Sale of Land | $ 20,200 | |
| Purchase of Equipment | $ -116,000 | |
| Net Cash from Investing Activities | $ -95,800 | |
| Cash flow from financing activities: | ||
| Repayent of Note Payment | $ -24,000 | |
| Net Cash from Financing Activities | $ -24,000 | |
| Net Increase in Cash | $ 8,000 | |
| Add: Beginning Balance | $ 52,000 | |
| Ending Balance | $ 60,000 | |