excel software

b.pdf 1999 Open with Google Docs Sales 2.928.0 2396.7 Net Income 219.6 171.9 2000 1,878.0 1,3972 97.3 1998 1,066.6 73.1 1312 a. Calculate the net profit margin for each year. b. Calculate the average annual growth rates for sales and net income using the GEOMEAN function. Is net income growing more slowly or faster than sales? Is this a positive for your investment in the company? C. Calculate the average annual growth rate of sales using the AVERAGE function. Is this result more or less accurate than your result in the previous question? Why? d Create a column chart of sales and net income. Be sure to change the chart so that the x-axis labels contain the year numbers, and format the axis so that 2002 is on the far right side of the axis. 3. Repeat Problem 2 using the data below for Lowe's Companies, Inc. However, this time you should create a copy of your worksheet to use as a template. Replace the data for Bed Bath & Beyond with that of Lowe's. Fiscal Year 2002 2000 1999 Sales 22.111.1 18,778.6 15,905.6 12,2449 10,136.9 Net Income 1,023.3 809.9 672.8 482.4 357.5 2001 1998 a. Do you think that Lowe's can maintain the current growth rates of sales and net income over the long run? Why or why not? b. Which company was more profitable in 2002? Which was more profitable if you take a longer view? Would this affect your desire to invest in one company over the other