AutoSave OF APvc ... ACC 210 Chapter 12 Serial Problem - Fall 2021 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 ~ A 5 Wrap Text General Insert v X G AY Delete V Paste B I U ar Ar Y = = = Merge & Center $ %? Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Sensitivity Analyze Data V Y20 fy A B C K M NO P Q V W X X Y 2 AA AH ACAD AE AF A S25 397 18 623 44,000 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 BUSINESS SOLUTIONS Income Statement For Three Months Ended Mareh 31, 2021 Computer services revenue Nel gelee Total revenue Cost of goods sold $14,052 Depreciation expense-Om aquipment 400 Depreciation experenonputer equipment 1,250 Wages expense 3,250 Insurance expense 655 Rent expen 2.475 Computer supplies axen 1,305 Advertising experce 600 Micago cxpense 320 Repair expense-Computer Total expenses Not income 25 187 $18.833 BUSINESS SOLUTIONS Comparative Balance Sheets Mar. 31, 2021 Dec. 31. 2020 28 29 30 31 32 33 34 35 16 37 38 39 40 41 42 43 44 45 46 47 48 49 Assets Cash Manaunable Inventory Computer supplus Prepaid Insurance Prepaid rent Total current sets Office buupment Computer Acciation Office equipment Accumulated depreciation Computer equipment Total assets Liabilities and Equity Accounts payable Wages payable Uneamed computer service revenue Tatalcument Abits Equity Common stock Retained earrings Tatal abilities and equity 558,057 22,847 704 2,005 1,110 825 95,588 0,000 (800) 20,000 12,500) $ 120,288 $43,372 5,668 3 583 1,665 825 57, 110 3,000 1400) 20,000 11,253) $83.09 SO 875 0 875 $1,100 309 1,503 3,103 51 52 53 90,000 21,393 $120 28R 73,003 7,263 $83,463 55 56 57 Penuired: Serial Problem + Ready + 100% AutoSave OF APvc ... ACC 210 Chapter 12 Serial Problem - Fall 2021 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 ~ A ab Wrap Text General X G Insert v AY O v Delete v Paste B I U U Av = = = Merge & Center Y $ % Conditional Format Cell Formatting as Table Styles Sensitivity Sort & Filter # Format Find & Select Analyze Data V Y20 fx . M N 0 P R T V X 2 AA AS AC AD AE AF DL SRS41 AG C TEITHETINHMEmy 120217 A 94 55 56 58 59 50 61 2 53 54 Required: Prepare a statement of cash flows for Business Sulutions using the indirect method for the three months anced March 31, 2021. Owner Santara Rey contributed $20,000 to the business in exchange for additional stock in the first quarter of 2021 and has received $4,800 in cash didends. (Amounts to be deducted should be indicated with a minus sign.) BUSINESS SOLUTIONS Statement of Cash Flows (indirect For Quarter Ended March 31, 2021 Cash ratom operating activities Nul income Adjustments to recorcie net income to rot cash provided by operatng activities 57 58 19 70 71 72 74 75 76 78 Cash Man from vasting Act Cash Hoastram financing activitas 83 84 AS SG 87 38 9 so Can balance at December 31, 2020 Cash balance at March 31, 2021 98 109 101 102 103 Serial Problem + Ready + 100%
