Filling the blank with Excel function
A B C D E F H - J K L M N 2019) 2018 Assets Cash flow Statement Corporation Accounts Receivable, Net Merchandise Inventory Supplies Prepaid Rent $65.000 $150.000 $135,000 59,700 530.0001 S182.700 580.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 $500,000 ($80,000) $.420.000 SR02.700 $240,000 $90.000) $150.000 $0.500 Cash from Operting activities Net Income Adjustment to reconcile Net Income to me CF from OA Depreciation Low on sale of equip Change in current opt and liab Change in AR Change in Inventories Change in Supplies Change in Prepaid Revit Change in AP Change in unearned revenue Change in salaries payable net cash flow from operating activites ($10.000) $10,000 55.212 Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Uneamed Revenue Salarles Payable Federal Income Taxes Payable $150,000 $40,000 540,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 $1165 213) Total Current Liabilities $240.000 $120.000 $113,700 Long Term Liabilities Note Payable Total Long-Term Liabilities Total Liabilities $130,000 $1.30,000 $370,000 0 0 $130,000 3 4 5 6 7 8 9 10 11 12 113 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 BO 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 03462001 ($46,300) Stockholders' Equity Common Stock, 51 Par Pald-in Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity $170,000 $43,700 $226,000 $19.700 SA09.700 $100,000 so $180,500 $280.500 $410.500 2 points each cell, Please make sure you use the Excel function to fill the blank Comparative Statement of Income For the Yusted December 21, 2018 and 2017 2019 2014 $700,000 $524,300 $175.700 $600.000 $420.000 $180.000 Sales Cost of Goods Sold Gross Margin Operating Expenses: Salaries and Wages Expende 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 JON Net Income $47,290 $20,256 $20.000 $87,546 588,154 $5,213) $3.656 SB.1691 $79,285 $23.786 $55.499 $100,000 $20,000 $10.000 $130,000 $50,000 $0 $5.000 $6,000 $13.500 $31.500
