need excel formulas for this

Data Formulas Review View Home Insert Draw Page Layout ED Define Na ? fx a e Create fre Text AutoSum Recently Financial Logical Used Date & Time Lookup & Reference Math & Trig sert ction More Functions 0 D E F G B 2019 2018 2019 2018 Assets Cash Accounts Receivable, Net Merchandise Inventory Supplies Prepaid Rent Total Current Assets $65,000 $150,000 $135,000 $9,700 $30,000 $389 200 $80,000 $100,000 $70,000 $500 $10,000 $260.500 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, plant, and Equipment Total Assets $500,000 ($80,000) $420,000 $809.700 $240,000 ($90,000) $150,000 $410.500 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 $240,000 $ 130,000 0 Long Term Liabilities Note Payable Total Long-Term Liabilities Total Liabilities $130,000 $130,000 $370,000 0 $130,000 Stockholders' Equity: Common Stock, $1 Par Paid-In Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total liability and Stockholders' Equity $170,000 $43,700 $226,000 $439,700 SB09.700 $100,000 $0 $180,500 $280,500 $410.500 Comparative Statement of Income For the Years Ended December 31, 2018 and 2017 CashFlowStatement 2012 Horizontal Analysis 2018 2019 2018 Ratio Analysis Vertical Analysis Ready B Common Stock, $1 Par Paid 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,700 $100,000 $0 $180,500 $280.500 $410,500 Comparative Statement of Income For the Years Ended December 31, 2018 and 2017 2019 2018 2019 2018 $700,000 $524,300 $175,700 $600,000 $420,000 $180,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 $88,154 ($5,213) $3,656 ($8,869) $79,285 $23,786 $55,499 $100,000 $20,000 $10,000 $130,000 $50,000 $0 $5,000 ($5,000) $45,000 $13,500 $31.500 points for this analysis, Excel funtion is needed to conduct calculation