Vertical Analysis

Can you show the work in excel please

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,700 $80,000 $100,000 $70,000 $500 $10,000 $260,500 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipmen 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 $809,700 $100,000 $0 $180,500 $280,500 $410,500