A large company is considering acquiring venture capital company D. Company D is in the semi-conductor industry, and is expected to have a growth rate of 30% in the next five years. After that, its long-term growth is expected to be comparable with large companies in the same industry, like Intel Corporation.

4) Using past 10 years of Intel Corporation dividend data (Jan 2011- Dec 2020), calculate the average annual dividend growth.

5) Using past 10 years of Monthly returns for Intel Corporation, and S&P500 index, calculate market beta for the company. Assume that risk free rate is close to zero.

Use Excel Please to Calculate!