A trend analysis compares amounts of a more recent year to a base year. The base year is the earliest year being studied. The analysis measures the percentage of change from the base vear. Q1 Use the amounts listed below to complete the trend indexes for Total expenses and Net income. Divide each amount by the amount of the base year and multiply by 100. Record the resulting trend index in the shaded area. Use 2005 as the base year. 2008 2007 2006 PEPSICO ($ in millions Sales revenue Total expenses $43,251 133 $39,474 121 108 Base Year 2005 $32,562 100 $28,484 $38,109 $35,137 $29.495 $ 5,642 $33,816 $ 5,658 Net income $ 5,142 $ 4,078 Q2 From 2005 to 2008 sales growth for PepsiCo was 33%. During the same period, total expenses increased %. When net sales increase, expenses would be expected to increase / stay the same / decrease). It is favorable when sales increase by 33% and expenses increase at a 'greater / lesser) rate than 33%. From 2005 to 2008 (revenues / expenses) of PepsiCo increased at a greater rate, which is favorable / unfavorable) Assume PepsiCo had a goal of increasing profits by 5% each year. This goal was (met / not met) The best year financially for PepsiCo was (2008 / 2007 / 2006). Why? Q3 04 The worst year financially for PepsiCo was (2008/2007 / 2006). Why? Q5 Use the amounts listed below to complete the trend indexes for Liabilities and Stockholders' Equity