Calculate the intrinsic value of Rio Tinto in the following scenario by using the threestage growth model of Spreadsheet $18\mathrm{.}1.$The market risk premium is $7\mathrm{.}5\%.$

What is the intrinsic value now? SHOW THE CHART AND CALCULATIONS.

Follow this format for excel chart headings:

Year

Dividend Growth

Dividend

Terminal Dividend

Total Dividend $+$Terminal value

PV Factor @$13\mathrm{.}3\%=1/1\mathrm{.}133^$n

PV of Dividends $+$Terminal Value