D M N 2019 2018 Cash Bow Statement Corporation Assets Cash Accounts Receivable, Net Merchandise Inventory Supplies Prepaid Rent Total Current Assets $65,000 $150,000 $135,000 $9,700 $30,000 $389.700 $80,000 $100,000 $70,000 $500 $10,000 $260.500 $5,213 Property. Plant, and Equipment: Equipment Less: Accumulated Depreciation Equipment Total Property. Plant, and Equipment Total Aunts $500,000 1580,0001 $420,000 $240,000 1590,000 $150,000 $410.50 Cash from Otting activities Net Income Adjustment to reconcile Net Income to net Of from OA Depreciation Loss on sale of equip Change in current opt and liab Change in AR Change in Inventories Change in Supplies Change in Prepaid Rent Change in AP Change in unearned revenue Change in salaries payable net cash flow from operating activites $10,000 $10,000 Uabilities and Stockholders' Equity Current abilities: Accounts Payable Unearned Revenue Salaries Puyable Federal Income Taxes Payable $150,000 $40,000 S40.000 $10,000 $40,000 $50,000 $30,000 $10,000 Cash flow from investing activities Cash payments on equipments Cash received from sale of equipment Net cash from investing activities $ 220,000) $ 54,787 $ 155,213) Total Current Lates $240.000 $130.000 Long Term Liabilities Note Payable Total Long-Term abilities Tstal abilities 0 $113,700 $130,000 $130,000 $370,000 $130,000 Net cash flow from finanding activities Cash received from issuing common stock Les Cash paid for dividends Net cash flow from financing activities Total change in cash Cash at beginning balance Cash at ending balance $113,700 Stade holders' Equity Common Stock, 51 Par Paldin Capital in Excess of Par Retained Earnings 1946.300) $170,000 543,700 $226,000 $100,000 $0 $180,500 $280.500 $41500 2 points each call Please make sure you use the Excel function to fill the bank Total liability and Stoholders' Equity son Comparative Statement of income For the Years Ended December 31, 2015 and 2017 2019 2011 $700,000 $524,300 S175.700 $600,000 $420,000 S180.000 Cost of Goods Sot Gross Margin Operating Expenses Salaries and Wages Expense Rent Expen Deprecation Expense Total Operating Expenses Income from Cerations Loss on Sale of Equipment Interest Expense Increase Decrease in Operating income Income before Taxes Federal income Taxes on Net Income $47,290 $20,256 $20,000 $87,546 $88,154 155,213) $3.656 $100.000 $20,000 $10,000 $130,000 $50.000 SO $5.000 55.000 $45,000 $13.500 $11.00 579,285 521786 Cash FlowStatement Vertical Analysis Horizontal Analysis Ratio Analysis + Paste Merge & Centa Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left SUM XV fx =C48 A D E O H L M 3 Corporation 4 5 6 7 Cash Accounts Receivable Net Merchandise inventory Supplies fraid on TAALLA SE DO $150.000 $135.000 $ $80,000 $100,000 $70,000 $500 $10.000 $55 am 13.00 55211 Property Part, and went que Law: Acumulated Depreciation for Total Property, Pant, and it 12 $500,000 80,000 $410,000 Cash from Gerting with Net income Adjustment to reconde Net Income to net From OA Depreciation Low on sale of Change in current opt and a Change in AR Change in inventories Change is supplies Change in Prent Change in AP Change in unearned revenue Change in salaries payable net cash flow from operating activites $240,000 150,000 $110,000 Sauna 30 1550,000 1565.000 199 200 5. DOC $110,000 1530,000 $10,000 17 11 abies and Stockholders' Equity Current abilities Accounts Payable Unearned Revenge Salaries Payable Federal Income Taxes Payable $40,000 20 $150,000 540 000 $40.000 $10.000 $10,000 $10,000 Cash flow from investing activities Cash payments on Cash received from sale of equipment Net cash from investing activities $220.000 $ 54,787 $1652111 21 $200.000 SLEDO 25 26 Long Term Lab Note Pay Total Long Term Lines $130,000 $130,000 $111.200 0 0 $1.30.000 Net cash flow from financing activities Cash received from incommon stock Law: Cath paid for dividende Net show from financing activities Total change in cash Cash at beginning balance Cash atending balance $111.00 19 31 Stockholm Equity Common Stock, Si Par 33 34 15 $170.000 54100 $220.000 SA 200 $100.000 50 $10.00 SOS SAIGO 2 poscholl Mease make wre you the function to fill the bank Totality and Stoholder 32 Comparative statement of Income For the Year Ended December 31, 2018 and 2017 $700.000 S500 S600.000 $400,000 Operating perses Deprecatione Totaling pent $100,000 $20,000 $10,000 $10.00 550.000 50 $5,000 S14 SH. 51 52 33 44 55 Federal income $ $21, SA 545.000 5130 50 CashFlowStatement Vertical Analysis Horizontal Analysis Ratio Analysis Point 2Excel Project-SUM20 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Callbel (Body 11 A A Wrap Text General Paste Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you loft off? SUM x fx .048 D E F G H 1 2019 2018 2 Assets ca 3 Cash $65,000 $80,000 4 Accounts Receivable, Net $150,000 $100,000 5 Merchandise Inventory $135,000 $70,000 Cash from Operting activities 60 Supplies $9,700 $500 Net Income 7 Prepaid Rent $30,000 $10,000 Adjustment to reconcile Net Incom Total Current Assets $389.700 $260.500 Depreciation 9 Loss on sale of equip 10 Property, Plant, and Equipment Change in current opt and liab 11 Equipment $500,000 $240,000 Change in AR 12 Less: Accumulated Depreciation - Equipment ($80,000) 1$90,000) Change in investories 13 Total Property, plant, and Equipment $420,000 $150,000 Change in Supplies 14 Total Assets $809.700 $410.500 Change in Prepaid Ren 15 Change in AP 16 Uabilities and Stockholders' Equity Change in unearnedre 17 Current Liabilities: Change in salaries paya 18 Accounts Payable $150,000 $40,000 net cash flow from operating activit 19 Unearned Revenue $40,000 $50,000 20 Salaries Payable $40,000 $30.000 Cash flow from investing activities 21 Federal Income Taxes Payable $10,000 $10,000 Cash payments on equip 22 Cash received from sale 23 Total Current abilities 5240,000 $130,000 Net cash from investing activities 24 25 Long Term Liabilities Net cash flow from financing activitie 26 Note Payable $130,000 0 Cash received from issir 27 Total Long-Term Liabilities $130,000 0 Less: Cash paid for divide Total Labs 28 $370,000 $130,000 Net cash flow from financing activities Total change in cash 29 30 Stockholders' Equity Cash at beginning balance 31 Common Stock $1 Par $170,000 $100,000 Cash atending balance $0 32 $43,700 Paid-in Capital in Excess of Par 33 Retained Earnings $226,000 $180.500 2 point 34 Total Stockholders will $439,700 $280.500 Cash Flow Statement Vertical My Ratio Analysis Point 000 80 F3 57 esc F4 F1 F2 SUM JxC48 A B E F Total abilities $370,000 $130,000 G Net cash flow from Total change in cas Cash at beginning Cash at ending bal 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Stockholders' Equity Common Stock, $ 1 Par Paid-In Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity $170,000 $43,700 $226,000 $439.700 $809.700 $100,000 $0 $180,500 $280,500 $410.500 Please mal Comparative Statement of income For the Years Ended December 31, 2018 and 2017 2019 2018 $700,000 $524,300 $175,700 $600,000 $420,000 $180.000 45 46 48 49 50 51 52 53 54 S5 56 57 58 59 Sales Cost Goods Sold Gross Margin Operating Expenses: Salaries and Wages Expense Rent Expense Depreciation Expense Total Operating Expenses Income from Operations Loss on Sale of Equipment Interest Expense Increase (Decrease in Operating Income Income before Taxes Federal income Taxes 30% Net Income $47,290 $20,256 $20,000 $87,546 $88,154 $5,213) $3,656 158.869) $79,285 $21,786 $55.499 $100,000 $20,000 $10,000 $130,000 $50,000 SO $5,000 155.000 $45,000 $13,500 $31.500 61 Cash FlowStatement Horrontal Analys Point MacBook Air esc BRA F1 F2 53 F5 A 1 2 3 4 N 5 6 7 Delete Merge & Center Conditional Format Formatting as Table Styles Cell Format Sort & Filter it to continue working where you left off? D E F G H . N 0 2018 Cash flow Statement Corporation $80,000 $100,000 $70,000 $500 $10,000 $260.500 2 $5,213 3 0) 0 9 $240,000 1$90,000) $150,000 $410,500 Cash from Operting activities Net Income Adjustment to reconcile Net Income to net CF from OA Depreciation Loss on sale of equip Change in current opt and liab Change in AR Change in Inventories Change in Supplies Change in Prepaid Rent Change in AP Change in unearned revenue Change in salaries payable net cash flow from operating activites ($10,000) $10,000 $5.213 20 10 0 $40,000 $50,000 $30,000 $10,000 00 Cash flow from investing activities Cash payments on equipments Cash received from sale of equipment Net cash from investing activities $ 220,000) $ 54,787 $ (165,213) 50 $130,000 $113,700 00 00 00 0 0 $130,000 Net cash flow from financing activities Cash received from issuing common stock Less: Cash paid for dividends Net cash flow from financing activities Total change in cash Cash at beginning balance Cash at ending balance $113,700 1946.300) ($46,300) 000 700 300 200 $100,000 $0 $180,500 $280.500 Fat Analyse 2 points each cell Please make sure you use the Excel function to fill the blank - MacBook Air 999 F4 F5 57 F8 F9 F10
