FREE Trial

Recalculate the intrinsic value of Honda in each of the following scenarios by using the three stage

Question:

Recalculate the intrinsic value of Honda in each of the following scenarios by using the three stage growth model of Spreadsheet. Treat each scenario independently.

a. ROE in the constant-growth period will be 10%.

b. Honda’s actual beta is 1.0.

c. The market risk premium is8.5%.

Recalculate the intrinsic value of Honda in each of the
Transcribed Image Text:

Inputs Dividend Div Term value Investor CF 2 beta 3 mkt prem 0.035 0.83 1.00 1.26 1.56 1.91 2.31 6 plowback 3.20 3.68 12 Value line 13 forecasts of 14 annual dividends 5.08 17 Transitional period 18 with slowing dividend 186.57 49.44 | = PV of CF Beginning of constant E17(1 F17VBS-F17) NPV B5,H2:H

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 71% (14 reviews)

a The solution is shown in the Excel ...View the full answer


answer-question-section
Answered By
tutor-profile-image
OTIENO OBADO
I have a vast experience in teaching, mentoring and tutoring. I handle student concerns diligently and my academic background is undeniably aesthetic
4.30+ 3+ Reviews 10+ Question Solved
Related Book For  book-img-for-question
Investments

Investments

ISBN: 9780073530703

9th Edition

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

See More Books
Question Posted:
See More Questions

Related Video

NPV stands for \"Net Present Value,\" which is a financial concept used to determine the value of an investment or project. It measures the difference between the present value of cash inflows and the present value of cash outflows over a given period of time, using a specific discount rate. To calculate the NPV of an investment, you need to first estimate the cash inflows and outflows associated with the investment, and then discount them back to their present values using a discount rate. The discount rate represents the cost of capital or the expected rate of return required by investors. The formula for calculating NPV is: NPV = sum of (cash inflows / (1 + discount rate)^t) - sum of (cash outflows / (1 + discount rate)^t) Where: Cash inflows: the expected cash received from the investment Cash outflows: the expected cash paid out for the investment Discount rate: the required rate of return or the cost of capital t: the time period in which the cash flow occurs If the NPV is positive, it means that the investment is expected to generate a return higher than the required rate of return or the cost of capital, and it may be considered a good investment. If the NPV is negative, it means that the investment is not expected to generate a return higher than the required rate of return or the cost of capital, and it may be considered a bad investment.

Students also viewed these Accounting questions

Mcgraw Hill My Math Grade K Volume 1 1st Edition - ISBN: 0079057675 - Free Book