$1$ Base Model:

Input section:

Dividend at time $0$

$\backslash$table$[[$$$,3,],[20\%,,],[,4,$years$],[,5\%,],[,,]]$

Year

Stage $1$ Dividend growth rate $($g$1)$

Stage $1$ lasts for

Stage $2$ Dividend growth rate $($g$2)$

Stage $1$ lasts for

$12\%$

Stock discount rate

Output section:

Dividend at year $3$

$$,5\mathrm{.}2$

Stock price at time $0$

$\backslash$table$[[$$$,5\mathrm{.}2],[$$$,51\mathrm{.}4]]$

Create a scenario summary report on Dividend at year $3$ and stock price at year $0$

Case $1$: $g1=10\%,g2=3\%$

Case $2$: g$1=30\%$ g$2=7\%$