Excel format. Formulas for better understanding

CHAP analyze the profitability of the companies in the portfolio. Usine need for Electronic Arts, Ine. (NA te 2. In your position as research assistant to a portfolio manager SDAQ: EA) below: 2014 2013 3,575 3,797 016 396 4,515 156 875 4,143 Fiscal Year 2 Total Revenue Net Income 1.190 98 . Calculate the net profit margin for each year. b. Calculate the compound average annual growth rates (CAGR growing more slowly or faster than total revenue? Is this a positi your investment in the company? revenue and net income using the GEOMEAN function. Is net in itive for revenue us Calculate the average annual growth rate of total revenue C. RAGE function. Is this result more or less accurate thanthe result in the previous question? Why? d. Create a Column chart of total revenue and net income. Be sure change the chart so that the x-axis labels contain the year num and format the axis so that 2016 is on the far right side of the axis 3. Repeat Problem 2 using the data below for Kroger Co (NYSE: KR template. Replace the data for Electronic Arts with that of Kroger However, this time you should create a copy of your worksheet to use as a Fiscal Year 2016 2015 2014 2013 2012 Total Revenue 109,830 108,465 98,375 96,619 90,269 Net Income 2,039 1,728 1,519 1,497 602 Which company's sales were growing faster over this period? Which a. one had the faster net income growth? b. Which company was more profitable in 2016? Which was more profitable if you take a longer view? Would the volatility of the net profit margin affect your desire to invest in one company or the other