Do Everythig In Excel. Everything filled in is already confirmed correct. Please fill in the missing data and have an extra row to show how you did it so I can learn please:

In your position as research assistant to a portfolio manager, you need to analyze the profitability of the

companies in the portfolio. Using the data for Electronic Arts, Inc. $($NASDAQ: EA$)$ below:

a$.$ In Row $10,$ calculate the net profit margin for each year.

Calculate the compound average annual growth rates $($CAGR$)$ for revenue and net income

b$.$ using the GEOMEAN$()$ function.

i$.$ Is net income growing more slowly or faster than total revenue?

Faster Choose your answer from the dropdown

ii$.$ Is this a positive for your investment in the company?

Yes Choose your answer from the dropdown

c$.$ Calculate the average annual growth rate of total revenue using the AVERAGE$()$ function.

i$.$ Is this result more or less accurate than your result in the previoius question?

Less Choose your answer from the dropdown

d$.$ Create a Column Chart of total revenue 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 $2016$ is on the far right

side of the axis.EE