Since this is in microsoft excel, would you please explain what formulas you used to solve it?

G H Vertical analysis of income statement Completed by: Percent Percent Current Year 800,000 15,000 Previous Year 600,000 22,000 520,000 408,000 Sales Sales returns and allowances Net sales Cost of goods sold Gross Profit Selling expenses Administrative expenses Total operating expenses 2 Other income Other expense 34 Income before income taxes 15 Income tax expense 16 Net Income 120,000 60,000 72,000 48,000 4,000 5,000 1,500 2,000 30,000 24,000 10 Vertical analysis of balance sheet 19 20 Percent Percent Current Year 90,000 21 Cash Accounts Receivable 23 Investments 2: Prepaid Insurance Expense Inventory Property, plant and equipment 22 Intangible assets Total assets 520,000 454,000 160,000 130,000 100,000 22,775 Previous Year 70,000 454,000 520,000 130,000 160,000 100,000 22,775 25 12,000 10,500 52,500 229,000 11,250 10,500 52,500 229,000 Accounts Payable Credit Cards Vehicle Notes Payable Mortgage Payable Total liabilities 35 ** Common stock 22 Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 495,000 677,775 500,000 653,525