Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the intrinsic value of Toyota in each of the following scenarios by using the three-stage growth model of the speadsheet above. Treat each scenario

image text in transcribed

Calculate the intrinsic value of Toyota in each of the following scenarios by using the three-stage growth model of the speadsheet above. Treat each scenario independently.

a) The terminal growth rate will be 4.9%.

Note: Round your answer to 2 decimal places.

b) Toyotas actual beta is 0.70.

Note: Round your answer to 2 decimal places.

c) The market risk premium is 7.9%.

Note: Round your answer to 2 decimal places.

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Inputs for Toyota & & Year & Dividend & Div growth & Term value & Investor CF & \\ \hline beta & 0.8 & 2022 & 4.45 & & & 4.45 & \\ \hline mkt_prem & 0.08 & 2023 & 4.82 & & & 4.82 & \\ \hline rf & 0.02 & 2024 & 5.18 & & & 5.18 & \\ \hline k_equity & 0.0840 & 2025 & 5.55 & & & 5.55 & \\ \hline \multirow[t]{6}{*}{ term_gwth } & 0.050 & 2026 & 5.97 & 0.0764 & & 5.97 & \\ \hline & & 2027 & 6.41 & 0.0738 & & 6.41 & \\ \hline & & 2028 & 6.87 & 0.0711 & & 6.87 & \\ \hline & & 2029 & 7.34 & 0.0685 & & 7.34 & \\ \hline & & 2030 & 7.82 & 0.0658 & & 7.82 & \\ \hline & & 2031 & 8.32 & 0.0632 & & 8.32 & \\ \hline Value line & & 2032 & 8.82 & 0.0606 & & 8.82 & \\ \hline forecasts of & & 2033 & 9.33 & 0.0579 & & 9.33 & \\ \hline \multirow[t]{3}{*}{ annual dividends } & & 2034 & 9.85 & 0.0553 & & 9.85 & \\ \hline & & 2035 & 10.37 & 0.0526 & & 10.37 & \\ \hline & Z & 2036 & 10.89 & 0.0500 & & 10.89 & \\ \hline \multicolumn{2}{|l|}{ Transitional period } & 2037 & 11.43 & 0.0500 & 353.03 & 364.46 & \\ \hline \multicolumn{8}{|c|}{ with slowing dividend } \\ \hline \multirow[t]{3}{*}{ growth } & & & & 4 & & 157.00 & =PV of CF \\ \hline & Beginning of constant & & \multicolumn{2}{|c|}{E17(1+F17)/(B5F17)} & & & \\ \hline & growth period & & & & & \multicolumn{2}{|c|}{NPV(B5,H2:H17)} \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Financial Management

Authors: R. Charles Moyer, William J. Kretlow, James R. Mcguigan

8th Edition

0324065914, 9780324065916

More Books

Students also viewed these Finance questions

Question

What is the difference between specificity and sensitivity?

Answered: 1 week ago