In: Accounting
The Sage Corporation prepared, for 2017 and 2016, the following balance sheet data:
|
December 31 |
||
|
2017 |
2016 |
|
|
Cash .................................... |
$ 87,375 |
$ 63,750 |
|
Available-for-sale securities (not cash equivalents) ......................... |
17,250 |
105,000 |
|
Accounts receivable ..................... |
90,000 |
86,250 |
|
Merchandise inventory ................... |
187,500 |
163,500 |
|
Prepaid insurance ....................... |
1,125 |
1,500 |
|
Land, buildings, and equipment ......... |
1,378,875 |
1,087,500 |
|
Accumulated depreciation ................ |
(558,750) |
(498,750) |
|
Total ................................. |
$1,203,375 |
$1,008,750 |
|
Accounts payable ........................ |
$ 153,375 |
$ 236,250 |
|
Salaries payable ........................ |
18,750 |
26,250 |
|
Notes payable--bank (current) ........... |
37,500 |
150,000 |
|
Bonds payable ........................... |
375,000 |
0 |
|
Common stock ............................ |
600,000 |
600,000 |
|
Retained earnings (deficit) ............. |
18,750 |
(3,750) |
|
Total ................................. |
$1,203,375 |
$1,008,750 |
Additional information:
|
(a) |
Sold available-for-sale securities (not cash equivalents) costing $87,750 for $90,000. |
|
(b) |
Equipment costing $18,750 with a book value of $3,750 was sold for $4,500. |
|
(c) |
Issued 8% bonds payable at par, $375,000. |
|
(d) |
Purchased new equipment for cash, $310,125. |
|
(e) |
Paid cash dividends of $22,500 during the year. |
|
(f) |
Net income for 2017 was $45,000. |
|
(g) |
Proceeds from the notes payable were used for operating purposes. |
Prepare a cash flow statement for Sage Corporation for 2017, using the indirect method.
| Sage Corporation | ||||
| Statement of cash flows for the year ended 2017 | ||||
| Cash flows from operating activities | ||||
| Net income | 45,000 | |||
| Adjustments for: | ||||
| Depreciation | 75,000 | |||
| Less:Profit on sale of Available-for-sale securities | (2,250) | |||
| (90000-87750) | ||||
| Less:Profit on sale of Equipment | (750) | |||
| Less:Increase in trade receivable | (3,750) | |||
| Less:Increase in inventory | (24,000) | |||
| Add: Decrease in Pre Paid Insurance | 375 | |||
| Less: Decrease in Note Payable | (112,500) | |||
| Less: Decrease in Salary Payable | (7,500) | |||
| Less: Decrease in Accounts Payable | (82,875) | |||
| (158,250) | ||||
| Cash generated from operations-----A | (113,250) | |||
| Cash flows from investing activities | ||||
| Purchase of equipment | (310,125) | |||
| Sale of Equipment | 4,500 | |||
| Sale of Available-for-sale securities | 90,000 | |||
| Net cash used in investing activities----B | (215,625) | |||
| Cash flows from financing activities | ||||
| Issue of Bonds | 375,000 | |||
| Payment of Dividend | (22,500) | |||
| Net cash used in financing activities-----C | 352,500 | |||
| Net increase in cash and cash equivalents(A+B+C) | 23,625 | |||
| Cash and cash equivalents at beginning of period | 63,750 | |||
| Cash and cash equivalents at end of period | 87,375 | |||
| Cost of Equipment | 18,750 | |||
| Accumulated Depreciaiton | 15,000 | |||
| Book Value | 3,750 | |||
| Sale | 4,500 | |||
| Profit on sale of machine | 750 | |||
| Accumulated Depreciation -2016 | 498,750 | |||
| Less: Accumulated Deprecation for sale of equipment | (15,000) | |||
| 483,750 | ||||
| Accumulated Depreciation -2017 | 558,750 | |||
| Depreciation for the year 2017 | 75,000 | (558750-483750) | ||