For the attached balance sheets and income statements prepare the following:

Horizontal analysis of each balance sheet and each income statement

Vertical analysis of the 2020 balance sheet

Vertical analysis of the 2020 income statement

In excel format preferably

Comparative Balance Sheets 31-Dec 2,019 Assets Cash 2,020 $ 38,000 Accounts receivable Inventory Equipment Accumulated depreciation-equipment Total 30,000 27,000 60,000 (29,000) $ 20,000 14,000 20,000 78,000 (24,000) $126,000 $108,000 Liabilities and Stockholders' Equity Accounts payable $ 24,000 Income taxes payable Bonds payable Common stock Retained earnings 7,000 27,000 18,000 50,000 $ 15,000 8,000 33,000 14,000 38,000 Total $126,000 $108,000 Nosker Company Income Statement For the Year Ended December 31, 2020 Net sales Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income taxes Income tax expense Net income 2,020 242,000 175,000 67,000 24,000 43,000 3,000 40,000 8,000 32,000 2,019 200,000 25,000 175,000 20,000 155,000 5,000 150,000 4,000 146,000