Recalculate the intrinsic value of Toyota shares using the free cash flow model of Spreadsheet(above) under each
Fantastic news! We've Found the answer you've been seeking!
Question:
Recalculate the intrinsic value of Toyota shares using the free cash flow model of Spreadsheet(above) under each of the following assumptions. Treat each scenario independently.
a. Toyota's P/E ratio starting in 2025 (cell G3) will be 11.5.
b. Toyota's unlevered beta (cell B22) is .65.
c. The market risk premium (cell B27) is 7.5%
Transcribed Image Text:
D42 A 1 2 A. Input data 3 P/E 4 Cap spending/shr 5 LT Debt ($M) 6 Shares (million) 7 EPS 8 Working capital 9 10 B. Cash flow calculations 11 Profits ($M, after tax) 12 Interest ($M, after tax) 13 Chg working cap ($M) 14 Depreciation ($M) 15 Cap spending ($M) 16 17 FCFF ($M) 18 FCFE ($M) 19 20 21 Current beta C. Discount rate calculations 22 Unlevered beta 23 Terminal growth 24 tax rate 25 r_debt 26 Risk-free rate 27 Market risk prem 28 MV equity 29 Debt/value 30 Levered beta B PV factor for FCFF PV factor for FCFE D. Present values 0.8 0.603 0.05 0.21 0.025 0.02 0.08 2021 12.50 25.80 109,000 1,375 15.15 7,000 21,100 2,153 16,000 D 2022 E 2023 F G 2024 2025 12.38 12.25 12.13 12.00 20.20 26.05 8.50 14.35 26,000 53,833 81,667 109,500 1,707 1,533 1,360 10.52 13.43 16.35 9,000 1,880 7.60 3,000 5,000 7,000 14,325 17,083 19,842 22,600 514 1,063 1,613 2,163 -4,000 2,000 2,000 2,000 18,000 17,833 17,667 17,500 15,980 22,463 28,945 35,428 20,859 11,517 8,176 4,835 -62,655 38,287 34,396 30,505 263,750 271,200 0.2924 0.2912 0.2900 0.2888 0.2876 0.8000 0.7989 0.7977 0.7966 0.7955 0.0840 0.0839 0.0838 0.0837 0.0836 0.0652 0.0652 0.0652 0.0652 0.0653 1.0000 0.9388 0.8813 0.8273 0.7766 1.0000 0.9226 0.8512 0.7855 0.7248 H 19,581 10,150 6,764 3,755 -57,805 32,592 27,017 22,112 Terminal value 332,621 210,868 0.0836 0.0653 0.7766 0.7248 I 258,318 152,847 J 31 k_equity 32 WACC 33 34 35 36 37 PV(FCFF) 38 PV(FCFE) 39 40 41 42 43 * 2025 P/E ratio is from Yahoo! Finance. Final input is from Value Line, and intermediate values are interpolated. 44 45 K = (1-tax_rate) x r_debt x LT Debt L assumes fixed debt ratio after 2023 YTM on LT debt from Value Line current beta /[1 + (1-tax)*debt/equity)] Row 3 x Row 11 linear trend from initial to final value unlevered beta x [1 + (1-tax)*debt/equity] from CAPM and levered beta (1-t)*r_debt*D/V + k_equity*(1-D/V) M Discount each year at WACC Discount each year at k_equity Intrinsic val Equity val Intrin/share 298,568 189,568 137.87 176,763 176,763 128.56 N O D42 A 1 2 A. Input data 3 P/E 4 Cap spending/shr 5 LT Debt ($M) 6 Shares (million) 7 EPS 8 Working capital 9 10 B. Cash flow calculations 11 Profits ($M, after tax) 12 Interest ($M, after tax) 13 Chg working cap ($M) 14 Depreciation ($M) 15 Cap spending ($M) 16 17 FCFF ($M) 18 FCFE ($M) 19 20 21 Current beta C. Discount rate calculations 22 Unlevered beta 23 Terminal growth 24 tax rate 25 r_debt 26 Risk-free rate 27 Market risk prem 28 MV equity 29 Debt/value 30 Levered beta B PV factor for FCFF PV factor for FCFE D. Present values 0.8 0.603 0.05 0.21 0.025 0.02 0.08 2021 12.50 25.80 109,000 1,375 15.15 7,000 21,100 2,153 16,000 D 2022 E 2023 F G 2024 2025 12.38 12.25 12.13 12.00 20.20 26.05 8.50 14.35 26,000 53,833 81,667 109,500 1,707 1,533 1,360 10.52 13.43 16.35 9,000 1,880 7.60 3,000 5,000 7,000 14,325 17,083 19,842 22,600 514 1,063 1,613 2,163 -4,000 2,000 2,000 2,000 18,000 17,833 17,667 17,500 15,980 22,463 28,945 35,428 20,859 11,517 8,176 4,835 -62,655 38,287 34,396 30,505 263,750 271,200 0.2924 0.2912 0.2900 0.2888 0.2876 0.8000 0.7989 0.7977 0.7966 0.7955 0.0840 0.0839 0.0838 0.0837 0.0836 0.0652 0.0652 0.0652 0.0652 0.0653 1.0000 0.9388 0.8813 0.8273 0.7766 1.0000 0.9226 0.8512 0.7855 0.7248 H 19,581 10,150 6,764 3,755 -57,805 32,592 27,017 22,112 Terminal value 332,621 210,868 0.0836 0.0653 0.7766 0.7248 I 258,318 152,847 J 31 k_equity 32 WACC 33 34 35 36 37 PV(FCFF) 38 PV(FCFE) 39 40 41 42 43 * 2025 P/E ratio is from Yahoo! Finance. Final input is from Value Line, and intermediate values are interpolated. 44 45 K = (1-tax_rate) x r_debt x LT Debt L assumes fixed debt ratio after 2023 YTM on LT debt from Value Line current beta /[1 + (1-tax)*debt/equity)] Row 3 x Row 11 linear trend from initial to final value unlevered beta x [1 + (1-tax)*debt/equity] from CAPM and levered beta (1-t)*r_debt*D/V + k_equity*(1-D/V) M Discount each year at WACC Discount each year at k_equity Intrinsic val Equity val Intrin/share 298,568 189,568 137.87 176,763 176,763 128.56 N O
Expert Answer:
Answer rating: 100% (QA)
To recalculate the intrinsic value of Toyota shares using the free cash flow model under each of ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
1. What are the factors involved in setting price? Provide some examples of pricing strategy from your own or another organization. What are the ethical considerations and biblical perspective...
-
Recalculate the intrinsic value of Honda shares using the free cash flow model of Spreadsheet under each of the following assumptions. Treat each scenario independently. a. Hondas P/E ratio starting...
-
1. You have been provided the information on the after-tax cost of debt and cost of capital that a company will have at a 10% debt ratio, and asked to estimate the after-tax cost of debt and cost of...
-
9. Write a program to solve function given below, with the x and y value proposed by the user. And, based on the result, show "imaginary result" response for the case of the result of the function is...
-
Find a pattern for f-1(x) when f (x) = ax + 1/ax - 1 where a > 0, a 1.
-
The H. Quigley Marble Company has the following balance sheet: The debentures are subordinated only to the notes payable. Suppose the company goes bankrupt and is liquidated, with $1,800 being...
-
In this chapter, we discussed the personal qualifications, educational requirements, and experience requirements of different countries. Develop a matrix that includes countries down one side and the...
-
Jaeco Corporation asks you to review its December 31, 2014 inventory values and prepare the necessary adjustments to the books. The following information is given to you. 1. Jaeco uses the periodic...
-
Find the x- and y-intercepts of the graph of the circle. (If an answer does not exist, enter DNE.) x+10x+y2+2y+ 19-0 STEP 1: Consider the equation for the circle, x+10x + y+ 2y + 190. Let y = 0. Give...
-
a. Calculate (1) the ratio of exchange in market price and (2) the earnings per share (EPS) and price/earnings (PIE) ratio for each company on the basis of the data given in the table that...
-
BJ Enterprise has inspected the work done by its employee yesterday. 8 staff production staff have been chosen as samples. 50 products produced by each sample have been examined and defects found are...
-
Write a program that figures out how many prime numbers exist within an arbitrary, random range of numbers. See next page for more on the "random range" part. See second-to-next page for tips on how...
-
What must be included in the name of all corporations - as required by all states?
-
The Caraway Seed Company grows heirloom tomatoes and sells their seeds. The heirloom tomato plants are preferred by many growers for their superior flavor. At the end of the most recent year the firm...
-
Operations Management To start, view MGT Library Research Slideshow.pdf Please post to the discussion board your chosen company and operations management topic. Using ABI INFORM/ PROQUEST(Links to an...
-
A firm is considering purchasing two assets. Asset A will have a useful life of 15 years and cost RM3 million; it will have installation costs of RM400,000 but no salvage or residual value. Asset B...
-
Delph Company uses a job-order costing system and has twomanufacturing departments??Molding and Fabrication. The companyprovided the following estimates at the beginning of the year: Molding 2 answers
-
What did Lennox gain by integrating their WMS, TMS, and labor management systems?
-
One seeming violation of the Law of One Price is the pervasive discrepancy of closed-end fund prices from their net asset values. Would you expect to observe greater discrepancies on diversified or...
-
Consider the futures contract written on the S&P 500 index and maturing in 6 months. The interest rate is 3% per 6-month period, and the future value of dividends expected to be paid over the next 6...
-
A zero-investment portfolio with a positive alpha could arise if: a. The expected return of the portfolio equals zero. b. The capital market line is tangent to the opportunity set. c. The Law of One...
-
Assume that you believe purchasing power parity (PPP) exists. You expect that inflation in Canada during the next year will be 3 percent and inflation in the United States will be 8 percent. Today...
-
(a) Explain the limitations of HCA when prices are rising. (b) Why has the HCA model survived in spite of its shortcomings in times of inflation?
-
To what extent are CCA statements useful to an investor?
Study smarter with the SolutionInn App