Determine stock value based on the dividend-discount model

Assignment Help Finance Basics
Reference no: EM13842266

Data Case As a new analyst for a large brokerage firm, you are anxious to demonstrate the skills you learned in your MBA program and prove that you are worth your attractive salary. Your first assignment is to analyze the stock of the General Electric Corporation. Your boss recommends determining prices based on both the dividend-discount model and discounted free cash flow valuation meth¬ods. GE uses a cost of equity of 10.5% and an after-tax weighted average cost of capital of 7.5%. The expected return on new investments is 12%. However, you arc a little concerned because your finance professor has told you that these two methods can result in widely differing estimates when applied to real data. You are really hoping that the two methods will reach similar prices. Good luck with that!

1. Go to Yahoo! Finance (https://fi nance.yahoo.com) and enter the symbol for General Electric (GE). From the main page for GE, gather the following information and enter it onto a spreadsheet:

a. The current stock price (last trade) at the cop of the page.

b. The current dividend amount, which is in the bottom-right cell in the same box as the stock price.

2. Next, click "Key Statistics" from the left side of the page. From the Key Statistics page, gather the following information and enter it on the same spreadsheet:

a. The number of shares of stock outstanding.

b. The Payout ratio.

3. Next, click "Analyst Estimates" from the left side of the page. From the Analyst Estimates page, find the expected growth rate for the next five years and enter it onto your spreadsheet. It will be near the very bottom of the page.

4. Next, dick "Income Statement" near the bottom of the menu on the left. Copy and paste the entire three years of income statements into a new worksheet in your existing Excel file. (Note: if you are using IE as your browser, you can place the cursor in the middle of the statement, right-click, and select "Export to Microsoft Excel" to download an Excel version.) Repeat this process for both the balance sheet and cash flow statement for General Electric. Keep all the different statements in the same Excel worksheet.

5. To determine the stock value based on the dividend-discount model:

a. Create a timeline in Excel for five years.

b. Use the dividend obtained from Yahoo! Finance as the current dividend to forecast the next five annual dividends based on the five-year growth rate.

c. Determine the long-term growth rate based on GE's payout ratio (which is one minus the retention ratio).

d. Use the long-term growth rate to determine the stock price for year five.

e. Determine the current stock price.

6. To determine the stock value based on the discounted free cash flow method:

a. Forecast the free cash flows using the historic data from the financial statements downloaded from Yahoo! to compute the three-year average of the following ratios:

i. EBIT/Sales

ii. Tax Rate (Income Tax Expense/Income Before Tax)

iii. Property Plant and Equipment/Sales

iv. Depreciation/Property Plant and Equipment

v. Net Working Capital/Sales

b. Create a timeline for the next seven years.

c. Forecast future sales based on the most recent year's total revenue growing at the five-year growth rate from Yahoo! for the first five years and the long-term growth rate for years 6 and 7.

d. Use the average ratios computed in part (a) to forecast EBIT, property, plant and equipment, depreciation, and net working capital for the next seven years.

e. Forecast the free cash flow for the next seven years.

f. Determine the horizon enterprise value for year.

g. Determine the enterprise value of the firm as the present value of the free cash flows.

h. Determine the stock price.

7. Compare the stock prices from the two methods to the actual stock price. What recommen-dations can you make as to whether clients should buy or sell GE stock based on your price estimates?

8. Explain to your boss why the estimates from the two valuation methods differ. Specifically, address the assumptions implicit in the models themselves as well as those you made in preparing your analysis. Why do these estimates differ from the actual stock price of GE?

Book:
Berk, Jonathan, Peter DeMarzo (2014). Corporate Finance (with Access) 3rd Ed. Pearson. ISBN 9780133424157.

Attachment:- Investment_Rules_Template.xlsx

Reference no: EM13842266

Questions Cloud

Calculate the following parameters : Calculate the following parameters
What is the potential for injury to employees : What is the potential for injury to employees. Are the employees repairing or adjusting equipment while it is in motion. What is the past record of failure. How quickly can the item or part become hazardous
Application: disorders of the veins and arteries : Application: Disorders of the Veins and Arteries
Create a structured reference in cell h4 : Create a structured reference in cell h4 that will multiply the streaming_Revenues amount by the value in cell b2 if the rating is pg-13. Other it will display 0. How do I find the formula for this
Determine stock value based on the dividend-discount model : Create a timeline in Excel for five years - determine the stock value based on the dividend-discount model and Determine the long-term growth rate based on GE's payout ratio
Why is it so difficult for couples to talk about sex : Why is it so difficult for couples to talk about sex? What about parents and their children? What would make it easier for people to have meaningful conversations about sex (e.g., times, places, resources, etc.)?
What feature of the dna helix provides access : What feature of the DNA helix provides access to "reading" by a protein molecule? Why?
Skin and what risks to life may result from injury : A person has been diagnosed with third degree burns over the anterior surfaces of their arms and trunk. What specific structural damage has occurred to their skin and what risks to life may result from this injury?
Increased folic acid levels : A patient with a diagnosis of atrophic gastritis and subsequent pernicious anemia is receiving high doses of vitamin B12. Which change would you expect at the end of his treatment? a. increased folic acid levels b. a decrease in RBC MCV

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Operating breakeven point in boxes

What will the impact be on its operating breakeven point in boxes

  Calculate levered beta

Swannee Resorts is considering a new project whose data are shown below. The equipment that would be used has a 3-year tax life, would be depreciated by the straight line method over the project's 3 year life, with zero salvage value.

  Break-even point and degree of leverage

Healthy Foods, Coirporation, sells 50 pound bags of grapes to the military for $10 a bag. The fixed expenses of this operation are $80,000, while the variable costs of grapes are $.10 per pound.

  What is the current value of chambers common stock

Chambers corp's ROE is 18%. their dividend payout ration is 80%. the last dividend just paid was $2.20. if dividends are expected to grow by the companys internal growth rate indefinitely, what is the current value of chambers common stock if its ..

  Your employer barnaby well company is considering the

your employer barnaby well company is considering the acquisition of a new drill truck and your boss has asked you to

  The gross profit rate is 30 percent and the rate of return

sales campaign. jones corporation is considering a sales campaign in which it will offer credit terms of 315 net80.

  Why you think this system is best for consumers

Explain which economic system (market, planned, mixed, or traditional) you think is best for consumers. Describe at least one reason why you think this system is best for consumers.

  The replacement of an existing machine

Holliday Manufacturing is considering the replacement of an existing machine

  Based on the ratios calculated discuss briefly the

condensed balance sheet and income statement data for sievert corporation are presented here and on the next page.

  Collection and disbursement floats which would a firm

collection and disbursement floats which would a firm prefer a net collection float or a net disbursement float?

  Determine the break-even point in units

You are a hard-working analyst in the office of financial operations for a manufacturing company that produces a single product. You have developed the following cost structure information for this corporation.

  Calculate required external financing

Cambridge Prep Shops, a national clothing chain, had sales of $200 million last year. The business has a steady net profit margin of 12% and a dividend payout ratio of 40%.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd