Filling the blank with Excel functions

B D E F H - J 2019 2010 ON Please calculate following ratios for the year of 20 Assets Cash Accounts Receivable, Net Merchandise Inventory Supplies Prepaid Rent Total Current Assets $65,000 $150.000 $135,000 $9,700 $30,000 $289.700 $80,000 $100,000 $70,000 $500 $10.000 $260.500 8 Working Capital Current Ratio Quick Ratio 10 11 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation Equipment Total Property. Plant, and Equipment $500,000 $80.000 Accounts Receivable Turnover $240,000 (590.000) $150.000 $410.500 Inventory Turnover 5409.709 13 14 15 16 17 18 Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Uneamed Revenue Salaries Payable Federal Income Taxes Payable Ratio of Net Sales to Assets Rate Earned on Total Assets Rate Earned on Stockhoders' Equity Earning per share(EPS) P/E ratio 20 21 $150,000 $40,000 $40.000 $10,000 $40,000 $50,000 $10.000 $10.000 Note: This company has 300.000 shares outstanding 22 23 24 Total Current Liabilities $200.000 $120.000 25 Long Term Liabities Note Payable Total Long Term Liabilities Total Liabilities $130.000 $110.000 5370.000 0 ol $130,000 Stockholders' Equity Corron Stock, 51 Par Paid-In Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity 5170.000 549,700 $226,000 $139,700 $809.700 $100.000 SO $180.500 $280.500 $410.500 Comparative Statement of Income For the Years Ended December 31, 2018 and 2017 2012 2011 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 $700,000 $524,300 $175.700 $600,000 $420,000 S180.000 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.2011 52.656 S8.8691 $79,285 $23,780 SSS.499 $100,000 $20.000 $10.000 $120,000 $50,000 SO 55.000 $6,000 $13,500 $11.500