please show how you get the answers
E13-3 Preparing and Interpreting a Schedule for Horizontal and Vertical Analyses [LO 13-2, LO 13-3, LO 13-5] According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016 Required 1. Conduct a horizontal analysis by calculating the year-over year changes in each line item, expressed in dollars and in percentages for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. 2-a. Conduct a vertical analysis by expressing each lin e as a percentage of total revenues 2-b. Excluding income tax, interest, and operating expenses, did Computer Tycoon earn more proft per dollar of sales in 2016 compared to 2015? Complete this question by entering your answers in the tabs below Rea 1 Req 2A Req 2B Conduct a horizontal analysis by calculating the year-over year changes indicated by a minus sign. Round percentage values to I decimal place in each line item, expressed in dollars and in for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. (Decreases should be COMPUTER TYCOON, IN Income Statements For the Year Ended December 31 Change in DollarsPercenta 2016 2015 Req 2A Req 1 Req 2B Conduct a horizontal analysis by calculating the year-over-year changes in each line item, expressed in dollars and in percentages for the income statement of Computer Tycoon Inc. for the year ended December 31, 2016. (Decreases sho indicated by a minus sign. Round percentage values to 1 decimal place.) COMPUTER TYCOON, INC. Income Statements For the Year Ended December 31 Book Hint Print Change in 2016 2015 Dollars Percent erences Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income 05,000 127,500 (22,500) 73,500 62,500 (11,000) (11,500) 42.500| 54,00oF 36,500 550 5,450 1,500 38,000 500 50 15,500 5,500 3.950|$ 10,000 s (650) (10,050 (4,000 Req 2A> Prey 1 of 8 Next> e here to search Saved Complete this question by entering your answers in the tabs below. Req 2A Req 2B Req 1 Conduct a vertical analysis by expressing each line as a percentage of total revenues. (Round percentage values to place.) COMPUTER TYCOON, INC. Income Statements For the Year Ended December 31 2016 2015 Sales Revenue Cost of Goods Sold Gross Profit Selling, General, and Administrative Expenses Interest Expense Income before Income Tax Expense Income Tax Expense Net Income S 105,000 62,500 42,500 36,500 550 5,450 1,500 S 3.950 % | $ 127,500 73,500 54,000 38,000 500 15,500 5,500 %|$ 10,000 K Req 1