please do excel formula. I cannot figure out the answer that habe brn provided.

a. perform a horizontal analysis showing the percentage change in each income statement, Capone in between your three and four

b, perform a vertical analysis, showing each income component as percentage of sales of each year

Income statements for Burch Company for Year 3 and Year 4 follow. Prequired a. Perform a hortontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4. b. Perform a vertical analyis, showing each income statement component as a percentage of sales for each year. Note: Use cell references cell A to C 1S from the given information to complete this question. For both requirements, round your answers to 1 decimal place. (1.6.,0.234 should be entered as 23.4). Note: Use cell references cell A4 to C15 from the given information to complete this question. For both requirements, round your answers to 1 decimal place. (i.e., 0.234 should be entered as 23.4 )