Question

In: Accounting

Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...

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, 2020 Computer services revenue $ 25,207 Net sales 17,993 Total revenue 43,200 Cost of goods sold $ 14,852 Depreciation expense—Office equipment 310 Depreciation expense—Computer equipment 1,250 Wages expense 2,850 Insurance expense 525 Rent expense 1,975 Computer supplies expense 1,285 Advertising expense 540 Mileage expense 310 Repairs expense—Computer 860 Total expenses 24,757 Net income $ 18,443 BUSINESS SOLUTIONS Comparative Balance Sheets December 31, 2019, and March 31, 2020 Mar. 31, 2020 Dec. 31, 2019 Assets Cash $ 74,567 $ 54,312 Accounts receivable 24,167 5,168 Inventory 614 0 Computer supplies 2,085 510 Prepaid insurance 1,060 1,655 Prepaid rent 825 825 Total current assets 103,318 62,470 Office equipment 7,500 7,500 Accumulated depreciation—Office equipment (620 ) (310 ) Computer equipment 19,700 19,700 Accumulated depreciation—Computer equipment (2,500 ) (1,250 ) Total assets $ 127,398 $ 88,110 Liabilities and Equity Accounts payable $ 0 $ 1,120 Wages payable 895 530 Unearned computer service revenue 0 1,500 Total current liabilities 895 3,150 Equity Common stock 104,000 77,000 Retained earnings 22,503 7,960 Total liabilities and equity $ 127,398 $ 88,110 Required: Prepare a statement of cash flows for Business Solutions using the indirect method for the three months ended March 31, 2020. Owner Santana Rey contributed $27,000 to the business in exchange for additional stock in the first quarter of 2020 and has received $3,900 in cash dividends. (Amounts to be deducted should be indicated with a minus sign.)

Solutions

Expert Solution

Solution:

Business Solutions
Statement of Cash Flows
For year ended 2020
Particulars Details Amount
Cash Flow from Operating Activities:
Net Income $18,443.00
Adjustments to reconcile net income to net cash provided by operations:
Depreciation Expense $1,560.00
Increase in accounts receivables ($24,167 - $5,168) -$18,999.00
Increase in inventory ($614 -0) -$614.00
Increase in computer supplies ($2,085 - $510) -$1,575.00
Decrease in prepaid insurance ($1,655 - $1,060) $595.00
Decrease in accounts payable ($1,120 - 0) -$1,120.00
Increase in wages payable ($895 - $530) $365.00
Decrease in unearned computer service revenue ($1,500 - 0) -$1,500.00
Net Cash provided (Used In) by operating activities -$2,845.00
Cash Flow from Investing Activities: $0.00
Cash Flow from Financing Activities:
Dividend Paid -$3,900.00
Proceed from issue of common stock $27,000.00
Net Cash Provided by financing activities $23,100.00
Net Increase / (Decrease) in Cash $20,255.00
Cash balance at beginning of year $54,312.00
Cash balance at end of year $74,567.00

Related Solutions

Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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, 2020 Computer services revenue $ 25,107 Net sales 17,793 Total revenue 42,900 Cost of goods sold $ 14,152 Depreciation expense—Office equipment 330 Depreciation expense—Computer equipment 1,240 Wages expense 2,450 Insurance expense 525 Rent expense 2,275 Computer supplies expense 1,235 Advertising expense 520 Mileage expense 270 Repairs expense—Computer...
Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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, 2020 Computer services revenue $ 25,207 Net sales 18,593 Total revenue 43,800 Cost of goods sold $ 14,552 Depreciation expense—Office equipment 360 Depreciation expense—Computer equipment 1,220 Wages expense 2,650 Insurance expense 545 Rent expense 2,375 Computer supplies expense 1,275 Advertising expense 510 Mileage expense 310 Repairs expense—Computer...
Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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,507 Net sales 18,193 Total revenue 42,700 Cost of goods sold $ 14,252 Depreciation expense—Office equipment 380 Depreciation expense—Computer equipment 1,180 Wages expense 2,950 Insurance expense 495 Rent expense 2,075 Computer supplies expense 1,285 Advertising expense 600 Mileage expense 250 Repairs expense—Computer 910...
Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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, 2019 Computer services revenue $ 25,307 Net sales 18,693 Total revenue 44,000 Cost of goods sold $ 14,052 Depreciation expense—Office equip. 400 Depreciation expense—Computer equip. 1,250 Wages expense 3,250 Insurance expense 555 Rent expense 2,475 Computer supplies expense 1,305 Advertising expense 600 Mileage expense 320 Repairs expense—Computer 960...
Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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, 2020 Computer services revenue $ 25,007 Net sales 17,893 Total revenue 42,900 Cost of goods sold $ 14,652 Depreciation expense—Office equipment 370 Depreciation expense—Computer equipment 1,250 Wages expense 2,950 Insurance expense 475 Rent expense 1,575 Computer supplies expense 1,285 Advertising expense 580 Mileage expense 260 Repairs expense—Computer 860...
Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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, 2020 Computer services revenue $ 24,307 Net sales 18,393 Total revenue 42,700 Cost of goods sold $ 14,652 Depreciation expense—Office equipment 400 Depreciation expense—Computer equipment 1,210 Wages expense 3,050 Insurance expense 525 Rent expense 2,375 Computer supplies expense 1,275 Advertising expense 510 Mileage expense 280 Repairs expense—Computer...
Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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,407 Net sales 18,193 Total revenue 42,600 Cost of goods sold $ 14,452 Depreciation expense—Office equipment 400 Depreciation expense—Computer equipment 1,240 Wages expense 2,550 Insurance expense 465 Rent expense 1,775 Computer supplies expense 1,265 Advertising expense 540 Mileage expense 230 Repairs expense—Computer...
Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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,607 Net sales 18,493 Total revenue 43,100 Cost of goods sold $ 14,552 Depreciation expense—Office equipment 390 Depreciation expense—Computer equipment 1,190 Wages expense 2,650 Insurance expense 525 Rent expense 1,575 Computer supplies expense 1,255 Advertising expense 560 Mileage expense 260 Repairs expense—Computer...
Santana Rey, owner of Business Solutions, decides to prepare a statement of cash flows for her...
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, 2020 Computer services revenue $ 25,107 Net sales 18,293 Total revenue 43,400 Cost of goods sold $ 14,752 Depreciation expense—Office equipment 340 Depreciation expense—Computer equipment 1,220 Wages expense 2,250 Insurance expense 545 Rent expense 1,675 Computer supplies expense 1,285 Advertising expense 600 Mileage expense 230 Repairs expense—Computer...
Santana Rey, owner of Business Solutions, decides to diversify her business by also manufacturing computer workstation...
Santana Rey, owner of Business Solutions, decides to diversify her business by also manufacturing computer workstation furniture. Required: 1. Classify the following manufacturing costs of Business Solutions by behavior and traceability. Product Costs Cost by Behavior Cost by Traceability   1. Monthly flat fee to clean workshop   (Click to select)VariableFixed   (Click to select)IndirectDirect   2. Laminate coverings for desktops   (Click to select)VariableFixed   (Click to select)IndirectDirect   3. Taxes on assembly workshop   (Click to select)FixedVariable   (Click to select)IndirectDirect   4. Glue to assemble workstation component...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT