Filling the blank with Excel function

B D E F G II 2019 2013 2018 2 4 5 6 Assets Cash Accounts Receivable, Net Merchandise Inventory Supplies Prepaid Rent Total Current Assets $65.000 $150.0001 $135.000 $9,700 $10.000 5389.700 $80.000 $100,000 $70,000 $500 $10,000 $260.500 8 9 10 11 12 13 14 15 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property. Plant, and Equipment Total Assets $500,000 $80,000) 5.620.000 S802.700 $240,000 (590.000 $150.000 110.500 16 17 18 19 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 Total Current Liabilities $20.000 $120.000 Long Term Liabilities Note Payable Total Long-Term Liabilities Total Liabilities $130,000 $130,000 $370,000 0 0 $130,000 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Stockholders' Equity Common Stock, 51 Par Paid In Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity $170.000 $43,700 $225.000 $439.700 $809.700 $100,000 SO $180.500 $280.500 5.10.500 Comparative Statement of Income For the Years Ended December 31, 2018 and 2017 2012 2011 2010 2018 $700,000 $524,300 $17.700 5600,000 $420,000 $180.000 44 45 46 47 48 49 50 51 52 Sales Cost of Goods Sold Gross Margin Operating Expenses: Salaries and Wages Expense Rent Expense Depreciation Expense Total Operating Expenses Income from Operations Lots on Sale of Equipment Interest Expense Increase (Decrease in Operating Income Income before Taxes Federal Income Taxes Box Net Income $07,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 $79,285 $23.780 555.199 $45,000 $13,500 $11.500 54 55 56 57 58 59 total 10 points for this analysis, Excel funtion is needed to conduct calculation 60