a. The terminal growth rate will be 10.30%. (Round your answer to 2 decimal places.) Intrinsic value b. Rio Tinto's actual beta is 1.05. (Round your answer to 2 decimal places.) Intrinsic value c. The market risk premium is 9.50%. (Round your answer to 2 decimal places.)

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter11: Capital Budgeting And Risk
Section: Chapter Questions
Problem 6P
icon
Related questions
icon
Concept explainers
Topic Video
Question
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 10.30%. (Round your answer to 2 decimal places.)
Intrinsic value
b. Rio Tinto's actual beta is 1.05. (Round your answer to 2 decimal places.)
Intrinsic value
c. The market risk premium is 9.50%. (Round your answer to 2 decimal places.)
Intrinsic value
Transcribed Image Text: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 10.30%. (Round your answer to 2 decimal places.) Intrinsic value b. Rio Tinto's actual beta is 1.05. (Round your answer to 2 decimal places.) Intrinsic value c. The market risk premium is 9.50%. (Round your answer to 2 decimal places.) Intrinsic value
Inputs for GE
beta
mkt_prem
rf
k_equity
term_gwth
Value line
forecasts of
annual dividends
1.1
0.08
0.029
0.1170
0.094
Transitional period
with slowing dividend
growth
Beginning of constant
growth period
Year
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
Dividend
3.12
3.38
3.64
3.90
4.19
4.51
4.86
5.25
5.68
6.15
6.68
7.27
7.93
8.66
9.47
10.36
Div growth Term value
0.0740
0.0760
0.0780
0.0800
0.0820
0.0840
0.0860
0.0880
0.0900
0.0920
0.0940
0.0940
E17*(1+ F17)/(B5 - F17)
492.73
Investor CF
3.12
3.38
3.64
3.90
4.19
4.51
4.86
5.25
5.68
6.15
6.68
7.27
7.93
8.66
9.47
503.09
118.98
= PV of CF
NPV(B5,H2:H17)
Transcribed Image Text:Inputs for GE beta mkt_prem rf k_equity term_gwth Value line forecasts of annual dividends 1.1 0.08 0.029 0.1170 0.094 Transitional period with slowing dividend growth Beginning of constant growth period Year 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Dividend 3.12 3.38 3.64 3.90 4.19 4.51 4.86 5.25 5.68 6.15 6.68 7.27 7.93 8.66 9.47 10.36 Div growth Term value 0.0740 0.0760 0.0780 0.0800 0.0820 0.0840 0.0860 0.0880 0.0900 0.0920 0.0940 0.0940 E17*(1+ F17)/(B5 - F17) 492.73 Investor CF 3.12 3.38 3.64 3.90 4.19 4.51 4.86 5.25 5.68 6.15 6.68 7.27 7.93 8.66 9.47 503.09 118.98 = PV of CF NPV(B5,H2:H17)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 6 images

Blurred answer
Knowledge Booster
Stock Valuation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning