please use excel and and show the formulas used

pter y (Related) 12. Apple paid an annual dividend of $1.72 in 2010. You expect Apple to increase its dividends by 8% per year for the next five years (through 2015), and after that by 3% per year. If the appropriate equity cost of capital for Apple is 8% per year, use the dividend-discount model to estimate its value per share at the end of 2010