Please show in excel with formulas

1. Suppose that at the end of December 2008 you purchased Inc. (Nasdaq: AAPL). It is now five years later and you decide tApple, your holdings to see if you have done well with this inv below shows the end-of-year market prices of AAP table AAPL Stock Prices Date 2008 2009 203.76 2010 311.89 2011 391.60 2012 519.13 2013 561.02 Price 82.53 Enter the data, as shown, into a worksheet and format the table as shown. Create a formula to calculate your rate of return for each year. Format the results as percentages with two decimal places. Calculate the total return for the entire five-year holding period. What is the compound average annual rate of return? a. b. c. Create a Line chart showing the stock price from December 2008 to December 2013. Make sure to title the chart and label the axes. Now create an XY Scatter chart of the same data. What are the differences between these types of charts? Which type of chart is more appropriate for this data? d. e. Experiment with the formatting possibilities of the chart. For example, you might try changing it to a 3-D Line chart and fill the plot area with a marble background. Is there any reason to use this type of chart to display this data? Do the "enhancements" help you to understand the data