please provide formulas
TE Format as Table 1 & fx De Cell Styles B Forr D E F 2019 G 2018 H Assets Cash Accounts Receivable, Net Merchandise Inventory Supplies Prepaid Rent Total Current Assets Please calculate following ratios for the year of 2019 $65,000 $150,000 $135,000 $9,700 $30,000 $389.709 $80,000 $100,000 $70,000 $500 $10,000 $260.500 Working Capital Current Ratio Quick Ratio Property. Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property. Plant, and Equipment Total Assets Accounts Receivable Turnover $500,000 $80,000) $420,000 S109.700 $240,000 1590,000) $150,000 $410.500 5 Inventory Turnover 6 7 LR Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Unearned Revenue Salaries Payable Federal Income Taxes Payable Ratio of Net Saleste Assets Rate Earned on Total Assets Rate Earned an Stockhoders' Equity Earnings per share(EPS P/E ratio 5150,000 $40.000 $40.000 $10,000 20 21 22 23 $40,000 $50.000 SJ0,000 $10,000 Note: This company has 100,000 shares outstanding Total Current liabilities $240.000 $110.000 25 26 Long Term Liabilities Note Payable Total Long-Term Liabilities Total abilities $130,000 $130,000 $370,000 28 0 0 $130,000 30 31 Stockholders' Equity Common Stock 51 Par Paldin Capital in Excess of Par Retained Earnings Total Stockholders Louity Total liability and Stockholders' Equity $170.000 543,700 $220,000 5439.7209 $100,000 50 5180.500 35 $110.509 11 Comparative Matement of income For the Year Ended December 31, 2018 and 2017 5700,000 5524.300 Cost of Goods Sold 5600.000 5420.000 Vertical Analy Pald-in Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity $43,700 $226,000 $439, 700 $809,700 $0 $180,500 $280,500 $410.500 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 UA Sales Cost of Goods Sold Gross Margin Operating Expenses -6 Salaries and Wages Expense 47 Rent Expense 48 Depreciation Expense 49 Total Operating Expenses 50 Income from Operations 51 Loss on Sale of Equipment 52 Interest Expense 53 Increase (Decrease) in Operating Income 54 Income before Taxes 55 Federal Income Taxes 30% 56 Net Income 57 SB 59 60 61 62 $47,290 $20.256 $20.000 $87,546 $88,154 1$5,213) $3,656 15.8.869) $79,285 $23,786 $55.499 $100,000 $20,000 $10,000 $130,000 $50,000 $0 $5,000 195.000 $45,000 $13,500 $31.500 64 65 67 + Ratio Analysis Horizontal Analysis Cash FlowStatement Vertical Analysis
