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%.
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
Step by Step Answer:
a The solution is shown in the Excel ...View the full answer
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
-
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...
-
Recalculate the intrinsic value of GE using the three-stage growth model of Spreadsheet 13.1 (available in Connect; link to Chapter 13 material). Treat each of the following scenarios independently....
-
Recalculate the intrinsic value of Honda shares using the free cash flow model of Spreadsheet 18.2 under each of the following assumptions. Treat each scenario independently. a. Honda's P/E ratio...
-
In Problems 65-72, summarize all pertinent information obtained by applying the graphing strategy, and sketch the graph of y=f(x). 66. 68. 70. 72. x2x6 f(x) 2x 1x +14 f(x)-_-x2-4 x3-5x2-6x 3x +2...
-
Rewrite each equation in standard form, and identify the type of curve. a. 25x2 - 4y2 + 100 = 0 b. 4y2 - 10x + 16y +36 = 0 c. 4x2 + 4y2 + 24x - 8y + 39 = 0 d. 3x2 + 5y2 - 12x + 20 y + 8 = 0
-
Consider the incompressible, two-dimensional flow of a nonviscous fluid between the boundaries shown in Fig. P6.22. The velocity potential for this flow field is \[ \phi=x^{2}-y^{2} \] (a) Determine...
-
Data Analysis tools to compute the correlations between hand-washing efficiency scored on a scale of 1 to 5 with 1 being best (Wash), number of times hands are washed each day (Number), and number of...
-
Wildcat Sporting Goods (WSG) sells athletic shoes and trendy sports apparel to a variety of sporting goods stores in the Northeast and, in 2011, WSG also began direct Internet sales to consumers....
-
The Kwintz Corporation has preferred shares, $1.75 cumulative, 150,000 issued and outstanding. 500,000 shares are authorized. Cash Year dividends paid ($) 2021 225,000 2022 350,000 2023 0 2024...
-
You have recently been promoted to be director of advertising for the Timkin Tool Company. In your first meeting with Mr. Timkin, he says, Advertising is a waste! Weve been advertising for six months...
-
The Digital Electronic Quotation System (DEQS) Corporation pays no cash dividends currently and is not expected to for the next 5 years. Its latest EPS was $10, all of which was reinvested in the...
-
The Duo Growth Company just paid a dividend of $1 per share. The dividend is expected to grow at a rate of 25% per year for the next 3 years and then to level off to 5% per year forever. You think...
-
Reconsider Prob. 12??71. In order to drain the tank faster, a pump is installed near the tank exit. Determine the pump head input necessary to establish an average water velocity of 6.5 m/s when the...
-
Ayayai Co.'s projected sales are as follows: August $320,000 September $450,000 October $550,000 Ayayai estimates that it will collect 30% in the month of sale, 50% in the month after the sale, and...
-
Beginning inventory, purchases, and sales for Item CSW15 are as follows: August 1 Inventory 102 15 9 Sale 90 16 Purchase 126 27 25 Sale 78 Assuming a perpetual inventory system and using the...
-
Beginning inventory, purchases, and sales for Item MMM8 are as follows: November 1 Inventory 108 15 9 Sale 92 16 Purchase 133 19 25 Sale 84 Assuming a perpetual inventory system and using the...
-
What PEST (Political, Economic, Social or Technological) trend or issue has had the most impact on the role of the Sales Professional?
-
(1) Tesla had stated that its annual production target for 2030 is 30 million electric vehicles. (a) What are the key constraints that Tesla faces in trying to achieve this target? (b) Is this...
-
What are the most significant statutes related to healthcare fraud, and how have they been affected by the ACA?
-
Revol Industries manufactures plastic bottles for the food industry. On average, Revol pays $76 per ton for its plastics. Revol's waste-disposal company has increased its waste-disposal charge to $57...
-
Does activity-based costing allocate more or less total costs to products than unit-based costing?
-
Given the following information concerning a convertible bond: Principal ............$1,000 Coupon ............5% Maturity ............15 years Call price ............$1,050 Conversion price...
-
The following information concerns a convertible bond: Coupon ..........6% ($60 per $1,000 bond) Exercise price .........$25 Maturity ..........20 years Call price ..........$1,040 Price of the...
-
Given the following information concerning a $2.00 convertible preferred stock: One share of preferred is convertible into 0.50 shares of common stock Price of common stock : .........$34 Price of...
-
Use the table for the question(s) below. Suppose the term structure of interest rates is shown below: Term Rate 1 year 2 years 3 years 5 years 10 years 20 years (EAR%) 5.00% 4.80% 4.60% 4.50% 4.25%...
-
Alpha and Beta Companies can borrow for a five-year term at the following rates: Alpha Beta Moody's credit rating Aa Baa Fixed-rate borrowing cost 10.5% 12.0% Floating-rate borrowing cost LIBOR...
-
4) Transactions for the month of July for Shelly's Bookstore were as follows: Purchases Salca July 1 (balance) 600 8 $7.30 1,200 @ $7.40 July 3 350 @$9.50 12 900 @9.75 22 700 $7.60 25 800 10.00 250...
Study smarter with the SolutionInn App