Calculate the intrinsic value of Rio Tinto in each of the following scenarios by using the three$-$stage growth model of Spreadsheet $18\mathrm{.}1$

Treat each scenario independently.

a$.$ The terminal growth rate will be $10\mathrm{.}30\%.($Round your answer to $2$ decimal places.$)$

Answer is complete but not entirely correct.

b$.$ Rio Tinto's actual beta is $1\mathrm{.}05.($Round your answer to $2$ decimal places.$)$

Answer is complete but not entirely correct.

c$.$ The market risk premium is $9\mathrm{.}50\%.($Round your answer to $2$ decimal places.$)\backslash$table$[[\backslash$table$[[$Inputs for GE$]],,,$Year,Dividend,$\backslash$table$[[$Div growth$]],$Term value,Investor CF$,],[$beta$,1\mathrm{.}1,,2019,3\mathrm{.}12,,,3\mathrm{.}12,],[$mkt$\_$prem,$0\mathrm{.}08,,2020,3\mathrm{.}38,,,3\mathrm{.}38,],[$rf$,0\mathrm{.}029,,2021,3\mathrm{.}64,,,3\mathrm{.}64,],[$k$\_$equity,$0\mathrm{.}1170,,2022,3\mathrm{.}90,,,3\mathrm{.}90,],[$term$\_$gwth$,0\mathrm{.}094,,2023,4\mathrm{.}19,0\mathrm{.}0740,,4\mathrm{.}19,],[,,2024,4\mathrm{.}51,0\mathrm{.}0760,,4\mathrm{.}51,],[,,2025,4\mathrm{.}86,0\mathrm{.}0780,,4\mathrm{.}86,],[,,2026,5\mathrm{.}25,0\mathrm{.}0800,,5\mathrm{.}25,],[,,2027,5\mathrm{.}68,0\mathrm{.}0820,,5\mathrm{.}68,],[\backslash$sigma $,,2028,6\mathrm{.}15,0\mathrm{.}0840,,6\mathrm{.}15,],[$Value line,,,$2029,6\mathrm{.}68,0\mathrm{.}0860,,6\mathrm{.}68,],[$forecasts of$,,,2030,7\mathrm{.}27,0\mathrm{.}0880,,7\mathrm{.}27,],[$annual dividend,,,$2031,7\mathrm{.}93,0\mathrm{.}0900,,7\mathrm{.}93,],[,,2032,8\mathrm{.}66,0\mathrm{.}0920,,8\mathrm{.}66,],[/\_\backslash ,,2033,9\mathrm{.}47,0\mathrm{.}0940,,9\mathrm{.}47,],[$Transitional period,,$2034,10\mathrm{.}36,0\mathrm{.}0940,492\mathrm{.}73,503\mathrm{.}09,],[$with slowing dividend$],[$growth$,,,,,$T$,,118\mathrm{.}98,=$PV of CF$],[$Beginning of constant,,E$17^(**)(1+$F$17)/($B$5-$F$17),,\backslash$bar $($N$),],[$growth period,,,,,NPV$($B$5,$H$2$:H$17)]]$