Calculate the intrinsic value of Rio Tinto in each of the following scenarios by using the three-stage growth model of Spreadsheet 18.1 . Treat each scenario independently. a. The terminal growth rate will be 6.00%. (Round your answer to 2 decimal places.) \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Inputs for GE & & & Year & Dividend & Div growth & Term value & Investor CF & \\ \hline beta & 1.9 & & 2019 & 3.12 & & & 3.12 & \\ \hline mkt_prem & 0.08 & & 2020 & 3.38 & & & 3.38 & \\ \hline rf & 0.029 & & 2021 & 3.64 & & & 3.64 & \\ \hline k_equity & 0.1810 & & 2022 & 3.90 & & & 3.90 & \\ \hline \multirow[t]{6}{*}{ term_gwth } & 0.070 & & 2023 & 4.19 & 0.0740 & & 4.19 & \\ \hline & & & 2024 & 4.50 & 0.0736 & & 4.50 & \\ \hline & & & 2025 & 4.83 & 0.0732 & & 4.83 & \\ \hline & & & 2026 & 5.18 & 0.0728 & & 5.18 & \\ \hline & & & 2027 & 5.55 & 0.0724 & & 5.55 & \\ \hline & Z & & 2028 & 5.95 & 0.0720 & & 5.95 & \\ \hline Value line & & & 2029 & 6.38 & 0.0716 & & 6.38 & \\ \hline forecasts of & & & 2030 & 6.83 & 0.0712 & & 6.83 & \\ \hline \multirow[t]{3}{*}{ annual dividends } & & & 2031 & 7.32 & 0.0708 & & 7.32 & \\ \hline & & & 2032 & 7.83 & 0.0704 & & 7.83 & \\ \hline & & & 2033 & 8.38 & 0.0700 & & 8.38 & \\ \hline \multicolumn{2}{|c|}{ Transitional period } & & 2034 & 8.97 & 0.0700 & 86.43 & 95.39 & \\ \hline \multicolumn{9}{|c|}{ with slowing dividend } \\ \hline \multirow[t]{3}{*}{ growth } & & , & & & & & 28.91 & =PV of CF \\ \hline & \multicolumn{2}{|c|}{ Beginning of constant } & & \multicolumn{2}{|c|}{E17(1+F17)/(B5F17)} & & & \\ \hline & \multicolumn{2}{|c|}{ growth period } & & & & & \multicolumn{2}{|c|}{NPV(B5,H2:H17)} \\ \hline \end{tabular}