Question

In: Accounting

Serial Problem Business Solutions (Indirect) LO P1, P2, P3 Santana Rey, owner of Business Solutions, decides...

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 Quarter Ended March 31, 2018
Cash flows from operating activities
Adjustments to reconcile net income to net cash provided by operating activities
$0
Cash flows from investing activities
Net cash used in investing activities
Cash flows from financing activities
0
$0
Cash balance at December 31, 2017
Cash balance at March 31, 2018 $0

Solutions

Expert Solution

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


Related Solutions

Serial Problem Business Solutions LO P1, P2 Santana Rey, owner of Business Solutions, realizes that she...
Serial Problem Business Solutions LO P1, P2 Santana Rey, owner of Business Solutions, realizes that she needs to begin accounting for bad debts expense. Assume that Business Solutions has total revenues of $46,000 during the first three months of 2020, and that the Accounts Receivable balance on March 31, 2020, is $22,617. Required: 1a. Prepare the adjusting entry to record bad debts expense, which are estimated to be 1% of total revenues on March 31, 2020. There is a zero...
Serial Problem Business Solutions LO P2, A3 Part A Santana Rey of Business Solutions is evaluating...
Serial Problem Business Solutions LO P2, A3 Part A Santana Rey of Business Solutions is evaluating her inventory to determine whether it must be adjusted based on lower of cost or market rules. Business Solutions has three different types of software in its inventory, and the following information is available for each. Per Unit Inventory Items Units Cost Market Office productivity 6 $ 86 $ 84 Desktop publishing 5 114 110 Accounting 6 100 106 Required: 1. & 2. Compute...
Serial Problem Business Solutions LO P3 Santana Rey receives the March bank statement for Business Solutions...
Serial Problem Business Solutions LO P3 Santana Rey receives the March bank statement for Business Solutions on April 11, 2020. The March 31 bank statement shows an ending cash balance of $68,266. The general ledger Cash account, No. 101, shows an ending cash balance per books of $68,825 as of March 31 (prior to any reconciliation). A comparison of the bank statement with the general ledger Cash account, No. 101, reveals the following. The bank erroneously cleared a $580 check...
Serial Problem Business Solutions P2, P3 Santana Rey expects sales of Business Solutions’s line of computer...
Serial Problem Business Solutions P2, P3 Santana Rey expects sales of Business Solutions’s line of computer workstation furniture to equal 300 workstations (at a sales price of $3,100 each) for 2018. The workstations’ manufacturing costs include the following. Direct materials $740 per unit Direct labor $360 per unit Variable overhead $90 per unit Fixed overhead $24,000 per year The selling expenses related to these workstations follow Variable selling expenses $ 35 per unit Fixed selling expenses $ 3,900 per year...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5, P6 After the success of the...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5, P6 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2019, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2019) follows. No. Account Title Debit Credit 101 Cash $ 38,264 106 Accounts receivable 12,618 126 Computer supplies 2,545 128 Prepaid insurance 2,220 131 Prepaid rent 3,300 163 Office equipment 8,000 164 Accumulated depreciation—Office equipment...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5, P6 After the success of the...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5, P6 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2019, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2019) follows. No. Account Title Debit Credit 101 Cash $ 38,264 106 Accounts receivable 12,618 126 Computer supplies 2,545 128 Prepaid insurance 2,220 131 Prepaid rent 3,300 163 Office equipment 8,000 164 Accumulated depreciation—Office equipment...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5, P6 After the success of the...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5, P6 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2019, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2019) follows. No. Account Title Debit Credit 101 Cash $ 38,564 106 Accounts receivable 12,818 126 Computer supplies 2,645 128 Prepaid insurance 1,860 131 Prepaid rent 3,200 163 Office equipment 8,700 164 Accumulated depreciation—Office equipment...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2016, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2016) follows. No. Account Title Debit Credit 101 Cash $ 38,664 106 Accounts receivable 12,718 126 Computer supplies 2,545 128 Prepaid insurance 2,160 131 Prepaid rent 3,020 163 Office equipment 8,400 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2017, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2017) follows. No. Account Title Debit Credit 101 Cash $ 38,764 106 Accounts receivable 13,418 126 Computer supplies 2,545 128 Prepaid insurance 2,040 131 Prepaid rent 3,140 163 Office equipment 8,000 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3 After the success of the company’s first two...
Serial Problem Business Solutions LO P1, P2, P3 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2017, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2017) follows. No. Account Title Debit Credit 101 Cash $ 38,364 106 Accounts receivable 13,218 126 Computer supplies 2,645 128 Prepaid insurance 2,040 131 Prepaid rent 3,140 163 Office equipment 8,000 164 Accumulated depreciation—Office equipment $ 0 167...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT