In: Accounting
Serial Problem Business Solutions (Indirect) LO P1, P2, P3
Santana Rey, owner of Business Solutions, decides to prepare a
statement of cash flows for her business using the following
financial data.
BUSINESS SOLUTIONS | |||||
Income Statement | |||||
For Three Months Ended March 31, 2018 | |||||
Computer services revenue | $ | 24,307 | |||
Net sales | 18,293 | ||||
Total revenue | 42,600 | ||||
Cost of goods sold | $ | 14,852 | |||
Depreciation expense—Office equipment | 390 | ||||
Depreciation expense—Computer equipment | 1,200 | ||||
Wages expense | 2,750 | ||||
Insurance expense | 535 | ||||
Rent expense | 2,475 | ||||
Computer supplies expense | 1,305 | ||||
Advertising expense | 510 | ||||
Mileage expense | 280 | ||||
Repairs expense—Computer | 920 | ||||
Total expenses | 25,217 | ||||
Net income | $ | 17,383 | |||
BUSINESS SOLUTIONS | |||||||
Comparative Balance Sheets | |||||||
December 31, 2017, and March 31, 2018 | |||||||
Mar. 31, 2018 | Dec. 31, 2017 | ||||||
Assets | |||||||
Cash | $ | 75,727 | $ | 51,652 | |||
Accounts receivable | 23,867 | 5,468 | |||||
Inventory | 614 | 0 | |||||
Computer supplies | 2,095 | 550 | |||||
Prepaid insurance | 1,060 | 1,615 | |||||
Prepaid rent | 785 | 785 | |||||
Total current assets | 104,148 | 60,070 | |||||
Office equipment | 7,200 | 7,200 | |||||
Accumulated depreciation—Office equipment | (780 | ) | (390 | ) | |||
Computer equipment | 19,200 | 19,200 | |||||
Accumulated depreciation—Computer equipment | (2,400 | ) | (1,200 | ) | |||
Total assets | $ | 127,368 | $ | 84,880 | |||
Liabilities and Equity | |||||||
Accounts payable | $ | 0 | $ | 1,110 | |||
Wages payable | 925 | 510 | |||||
Unearned computer service revenue | 0 | 1,900 | |||||
Total current liabilities | 925 | 3,520 | |||||
Equity | |||||||
Common stock | 105,000 | 73,000 | |||||
Retained earnings | 21,443 | 8,360 | |||||
Total liabilities and equity | $ | 127,368 | $ | 84,880 | |||
Required:
Prepare a statement of cash flows for Business Solutions using the
indirect method for the three months ended March 31, 2018.
Owner Santana Rey contributed $32,000 to the business in exchange
for additional stock in the first quarter of 2018 and has received
$4,300 in cash dividends. (Amounts to be deducted should be
indicated with a minus sign.)
|
Business solutions |
||
Statement of cash flows (indirect) |
||
For the quarter ended Mar 31 2018 |
||
Particulars |
$ |
$ |
Net income |
17383 |
|
Adjustments to reconcile net income to net cash provided by operating activities |
||
Depreciation [390+1200] |
1590 |
|
Less: |
||
Increase in accounts receivable [5468-23867] |
-18399 |
|
Increase in inventory |
-614 |
|
Increase in computer supplies[550-2095] |
-1545 |
|
Decrease in accounts payable |
-1110 |
|
Decrease in unearned service revenue |
-1900 |
-23568 |
Add: |
||
Decrease in prepaid insurance [1615-1060] |
555 |
|
Increase in wages payable [925-510] |
415 |
970 |
Cash used in operating activities |
-3625 |
|
Cash flows from investing activities: |
0 |
|
Cash flows from financing activities: |
||
Proceeds from issuance of common stock |
32000 |
|
Payment of cash dividend |
-4300 |
|
cash flows from financing activities |
27700 |
|
Net cash from the activities |
24075 |
|
cash flows in the beginning |
51652 |
|
cash flows at the end |
75727 |
|