Home Page Layout Formulas Data Review View Insert Cut 11 A- A+ - Wrap Text Currency Calibri (Body) BIU Copy Format Paste + Merge & Center $ - % ) Insert Conditional Format Formatting as Table Styles Delete Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. M6 X fx A c B D F K G H L M P 2019 2018 Cash flow Statement Corporation 1 2 3 4 5 6 7 Asset Cash Accounts Receivable et Merchandisinventory Supplies Prepaid Rent $65,000 $150.000 $115,000 59,700 $30,000 $189.702 $80,000 $100.000 $70,000 $500 $10.000 SNO500 $5.213 9 10 11 12 12 Property. Plant, and Equipment Equipment Less: Accumulated Depreciation Equipment Total Property Mant, and Equipment $500,000 580,000 $420,000 $109.702 $240,000 1590,000 $150,000 SA Cach tram pertinents Net Income Adjustment to reconcile Net Income to net CF from OA Depreciation Loss on sale of equip Change is current opt and la Change in AR Changistered Change Supplies Changes Prepaid Change Change in ureed revenue Change in sales payable nel cash flow from operating activites $10.000 $10,000 15 16 17 IN 19 20 21 22 23 Liabilities and StockholdersEquity Current Liabilities Accounts Payable Unred Revenue Sales Payable Federal income Taxes Payable $150,000 $40,000 $40.000 $10,000 $40,000 550.000 $10,000 $10,000 Cash flow from investing activities Cash payments on equipments Cash received from sale of equipment Net cash from investing activities S 220.000 $ 54,787 $165.213 Toluntabilities Sa0.000 $120.000 . $113.700 Long Term Liais Nate Payable Total Long Term Liabilities Total liabilities $110.000 $130 000 5370.000 $139,000 Net cash flow from financing activities Cash received from sin common stock Lev: Cash paid for dividends Net cash flow from financing activities Total change in cash Cash at beginning balance Cash atending balance $113,700 25 26 27 28 29 30 31 32 11 + 1546,300] Stockholders' Equity Common Stock, S1 Par Paldin Capital in Excess of Par Retained Earnings The only Totality and Stockholders Equity $170.000 $43,700 $226,000 $100,000 SO $180,500 $280.500 SA 2 points each call Please make sure you use the Excelhunction tell the blank 35 Cash FlowStatement Vertical Analysis Horizontal Analysis Ratio Analysis + Ready 25 W HH ... A) B P N Town w NOVIC Cut Calibri (Body) - 11 A- A Wrap Tent Currency Copy B I U- Merge & Center Format $ . % ) Conditional Formatting Office Update To keep up-to-date with security updates, foxes and improvements, choose Check for Updates. 16 x x c D E F H Long term abilities Netcashow mancing activities Note Payable $130.000 0 Cashewed online common och $113,700 7 Total Long Terme $110.000 0 Leve: Cash paid for dividends * $370.000 $130.000 Net cash flow from nating $111.700 9 Total change in cash Stockhoortuity Cash at beginning balance 31 Cowo Stock $170.000 $100,000 Cash atending balance 45,000 33 Paldin Capital in besof Par $43.700 50 $236.000 $110 SC 5439.200 $280.500 2 points each cell 35 Total liability and Stockhol'vity 580200 Please make sure you use the bacal function to fill the blank Comparative Suitement of income 18 For the Year Ended December 31, 2018 2017 39 2013 2011 41 $700.000 $600.000 Cool Good 5524.190 $420.000 Grown SUM 45 Operating pana 46 Sales and was 547290 $100.000 Sant Expense S10256 $20.000 Operating tape $8.546 $110.000 SIRISE $50.000 51 Lo 50 55.000 53 54 Income before 573 285 federal income 30% 51. 56 Netcom SSA 57 50 Cash FlowStatement Vertical Analysis Horontal Analysis Rationis + Ready 110.000 weste 25 W X ... A esc 20 DOD DOO % 5 2 3 4 6 7 8 QWERTY U