In: Accounting
Prepare a:
A) income statement (multiple step)
B) balance sheet
C) cash flow statement
using the selected financial statement information and additional data presented below.
Balance sheet: December 31 2015
Cash $52,000
Accounts receivable (gross) 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 ………………….. 75,000
Allowance for doubtful accounts………………....……………..4,500
Inventory 148,000
Land 58,600
Equipment 620,000
Accumulated depreciation 40,000
Accounts payable 48,300
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……………………………….95,000
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,300 | |||
| Notes payable - short-term | $ 24,200 | |||
| Total Current Liabilities | $ 72,500 | |||
| Notes payable - long-term | $ 154,000 | |||
| Total Liabilities | $ 226,500 | |||
| Common stock. | $ 420,000 | |||
| Retained Earning (67200+203400 Net Income) | $ 270,600 | |||
| Total Liabilities and Equities | $ 917,100 | |||
| Cash Flow | ||||
| Net Income | $ 203,400 | |||
| Adjustment to Net income: | ||||
| Depreciation Expenses | $ -54,000 | |||
| Increase in Receivable | $ -6,500 | |||
| Decerease in inventory | $ 30,000 | |||
| Decrease in Accounts Payable | $ -2,100 | |||
| 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 | |||
| Working Net Income: | ||||
| Sales Revenue | $ 630,500 | |||
| Cost of Goods Sold | $ 285,000 | |||
| Gross Margin | $ 345,500 | |||
| Less: | ||||
| Salary Expense | $ 95,000 | |||
| Advertising Expense | $ 14,600 | |||
| Depreciation Expense | $ 10,000 | |||
| Bad debt expense | $ 2,500 | |||
| Other Expense | $ 20,000 | $ 142,100 | ||
| Net Income | $ 203,400 | |||