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.) > Answer is complete but not entirely correct. Intrinsic value 174.05
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.) > Answer is complete but not entirely correct. Intrinsic value 174.05
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
Related questions
Question
This is my last allotted question and the 4th time I am asking, please do not give the same incorrect answer shown. It is not 175.05, 175.20, or 171.33. All information is given
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.)
X Answer is complete but not entirely correct.
$ 174.05 X
Intrinsic value
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
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)
Term value
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
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.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
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…
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