1.

spreadsheet

2.

spreadsheet

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%. (Round your answer to 2 decimal places.) Answer is complete but not entirely correct. Intrinsic. value b. Rio Tinto's actual beta is 1.2. (Round your answer to 2 decimal places.) Sprd 18.1 Calculate the intrinsic value of Rio Tinto shares using the free cash flow model of Spreadsheet 18:2. Treat each scenario independently. a. Rio Tinto's P/E ratio starting in 2022 (cell G3) will be 11. (Round your intrinsic value to the nearest whole number and per share value to 2 decimal places.) b. Rio Tinto's unlevered beta (cell B22) is 1.2. (Round your intrinsic value to the nearest whole number and per share value to 2 decimal places.) b. Rio Tinto's unlevered beta (cell B22) is 1:2. (Round your intrinsic value to the nearest whole number and per share value to 2 decimal places.) c. The market risk premlum (cell B27) is 7.5\%, (Round your intrinsic value to the nearest whole number and per share value to 2 decimal places.) A1