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.)

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education