Part Using Excel, prepare two trend (horizontal) analyses and a common-size (vertical) analysis for the income statements provided. The company's income statements for six years (2012 through 2017) are presented on the sheet labeled "Par1 Combined Analysis". Trend Analvsis Prepare the first trend analysis (Trend Analysis 1) using 2012 as the base year and expressing the line items for each subsequent year relative to the base year amount. For example, 2013 revenues are indexed at 109.7 of 2012 revenues calculated as follows: ($20,862+$19,014) 100- 109.7 Use the number format and carry out the decimal to the tenths place (one place to the right of the decimal) rend Analvsis Prepare the second trend analysis (Trend Analysis 2) showing the year-over-year percentage change in each line item. For example, 2013 revenues increased over 2012 revenues by 9.7% calculated as follows ($20,862-$19,014) $ 19,014 9.7% Use the percentage format and carry out decimals to the tenths place (one place to the right of the decimal) 1 9 1 Trerd Analysis 1 30,601 Revenues Cost of sales Gross profit Demand creation expenge Operating overhead expense 27,799 25,313 24,128 20,862 9,014 14,067 3,213 11,034 2,745 10,4 9,508 3,031 2,711 2,356 4245 6,693 2 Total seling and administrative expense 8,766 6,326 7,796 3 Interest expense lincome),ne Other expense (income) 28 3544 Income before income taxes 6 Income tax expense 3,256 2,983 Net inceme Trend Analsis 2 30,601 24,128 0,862 $19,014 Revenues 27,799 25,313 Cost of sales 7 Gross profit 10,47 3,213 3,031 Demand creation expense Operating overhead expense 2,745 2,711 2.448 2,356 9,892 28 0 Total seling and administrative expense 8,766 6,326 6,693 Interest expense lincome), net Other expense (income) 3 Income before income taxes 3,256 2,517 Income tax experse