Can you please provide formulas

fx 20 2018 . Account SO HOES 6 10 13 BO 000 14 18 12 05 ONE ONS OS 22 SED 18 33 $70,000 Commons Sa. ODOS for the Year 2018 2017 00005 Bent Expert 52016 SHRI 5.656 58 TS Sa 73 IN ... 2019 1 2 1 4 Assets Carnih Accounts Receivable, Net Merchandise inventory Supplies Prepaid Rent Total Current Arts $65.000 $150,000 $135,000 $9,700 5 $20.000 $500 $10,000 SUR 200 7 8 9 30 $240.000 Property, Plant, and fine Equipment Less: Accumulated Depreciation Equipment Total Property. Plant, and Equipment Total Assets 12 13 14 35 $500,000 $80,000 $420,000 $809,700 $150 000 17 18 19 Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Uneared Revenue Salaries Payable Federal income Taxes Payable $150,000 $40,000 $40,000 $40.000 $50,000 $20,000 $10.000 $10.000 Total Current Liabilities $240,000 $120.000 21 22 23 24 25 26 27 28 Long Term Liabilities Note Payable Total Long Term Liabilities Total Liabilities $130,000 $130.000 $370,000 $120.000 $100.000 Stockholders' Equity Common Stock, $1 Par Paid-in Capital in Excess of Par Retained Earnings Total Stockholders' Equity Total ability and Stockholders' Equity $170,000 $43,700 $2.000 SIS $809.700 S420.500 Comparative Statement of income For the Years Ended December 11, 2018 2017 30 31 32 33 14 35 36 37 38 39 40 41 42 43 44 45 46 47 45 49 2019 $700,000 5524,300 $175,200 $600.000 $420.000 $180.000 $47,290 Cost of Goods Sold Gross Margin Operating Expenses: Salaries and Wapes 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 SO 51 $20,000 $87,546 SBR 154 155,213 $3,656 $10.000 $130.000 550.000 Se $5.000 54 55 56 $29 $23,786 $55 499 $13.500 $31.500 total 10 points for this analysis, Excelfuntion is needed to conduct calculation 58 59 GO 61 2 ent Vertical Analysis Horizontal Analy +