fill in blanks and state how you got each one
Open recovered workbooks? Your recent changes were saved. Do you want to continue working SUM XV fx =C48 A B C D E F 1 2019 2018 2 4 un Assets Cash Accounts Receivable, Net Merchandise Inventory Supplies Prepaid Rent Total Current Assets Cas $65,000 $150,000 $135,000 $9,700 $30,000 $389.700 $80,000 $100,000 $70,000 $500 $10,000 $260.500 Net Adid 6 7 8 9 10 11 12 13 Ch Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, Plant, and Equipment Totalsts $500,000 ($80,000) $420,000 $809,700 $240,000 ($90,000) $150,000 $410,500 net ca Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Unearned Revenue Salaries Payable Federal Income Taxes Payable $150,000 $40,000 $40,000 $10,000 $40,000 $50,000 $30,000 $10,000 Cash Total Current Liabilities $240,000 $130.000 Net cas Net cast 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 Long Term Liabilities Note Payable Total Long-Term Liabilities Total Liabilities $130,000 $130,000 $370,000 0 0 $130,000 Net cash Total che Cash at b Cash at er Stockholders' Equity Common Stock, $1 Par Pald-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.200 $100,000 $0 $180,500 $280.500 S110.500 Comparative Statement of income For the Years Ended December 31, 2018 and 2017 2019 2018 CashFlowStatement Vertical Analysis Horizontal Analysis Ratio Analysis Point Delete Merge & Center % 3 og Conditional Format Cell Formatting as Table Styles HO Format nue working where you left off? E F G H L M N 2018 Cash flow Statement Corporation $80,000 $100,000 $70,000 $500 $10,000 $260.500 $5,213 $240,000 ($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 $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 $ (165,213) $130.000 $113,700 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) $100,000 $0 $180,500 $280,500 Ratio Analysis 2 points each cell Please make sure you use the Excel function to fill the blank MacBook AS AutoSave OFF Excel Project-SUM20 (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body Wrap Text Paste Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you tof? SUM Xfx =C48 A D H B Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity C $226,000 $439.700 $809.200 E SLO $280.500 $410.500 2 points Please make sure you use the 33 34 35 36 37 38 39 40 Comparative Statement of Income For the Years Ended December 31, 2018 and 2017 2019 2013 $700,000 $524,300 $175.700 $500,000 $420,000 $180.000 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 Sales Cost of 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 588,154 155.213 $3,656 158.859) $79,285 $23.786 $55.499 $100,000 $20.000 $10,000 $130.000 550.000 $0 55.000 155.000 $45.000 $13.500 $31.500 65 66 67 CashFlowStatement Horror Point MacBook Air
