Requirements

$1$ In cell D$12,$ by using cell references, calculate the dividend that the company will pay next year $(1$ pt$.).$

$2$ In cell D$13,$ by using cell references, calculate the dividend that the company will pay in six years $(1$ pt$.).$

$3$ In cell D$14,$ by using cell references, write an expression to calculate the present value of the first five dividends $($years $1-5)(1$ pt$.).$ Note: Use the Present Value of a Growing Annuity equation. The output of the expression or function you typed in this cell is expected as a positive number.

$4$ In cell D$15,$ by using cell references, write an expression to calculate the present value of all remaining dividends $(1$ pt$.).$ Note: Combine the Present Value and Present Value of a Growing Perpetuity equations. The output of the expression or function you typed in this cell is expected as a positive number.

$5$ In cell D$16,$ by using cell references, calculate the price of the stock today $(1$ pt$.).$