Get historical dividends of Johnson and Johnson (JNJ) to calculate the annual growth rate of dividends over the last 10 years from Yahoo Finance (finance.yahoo.com). Use Mar 2019- Feb 2020 dividend year as the last year for dividends. (Steps to get data: i) Go to Yahoo finance and type in JNJ in the Quote Lookup box (you can also put Johnson and Johnson instead of JNJ), ii) Click on the Historical Data tab, iii) Change period from 1/1/ 2010 to Present, change Historical Prices to Dividends only and change Frequency to Monthly, iv) Click on download data, v) Sort data by date once data is in Excel.)

1. Data download. (5)
2. What is the total amount of dividend in the Mar 2019- Feb 2020 dividend year and in the Mar 2009- Feb 2010 dividend year? (Hint: Need to add the 4 values of dividend within the specific period to calculate the annual dividend. Make sure that the 4 values are the same.) (4)
3. Use the values found in part b to calculate dividend growth rate over the 10 year period. (Hint: Can use either the compound growth formula or use the RATE function) (5)
4. Plot the total annual dividends (have to sum up 4 values for each dividend year) for the last 10 years (last dividend year should be Mar 2019- Feb 2020). (8)
5. What can you comment from the graph of total dividends? (2)