Data Case for Chapter 9: Valuing Stocks
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 methods. 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 are 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!
Go to Yahoo! Finance ([login to view URL]) and enter the symbol for General Electric (GE). From the main page for GE, gather the following information and enter it onto a spreadsheet:
The current stock price (last trade) at the top of the page.
The current dividend amount, which is in the bottom-right cell in the same box as the stock price.
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:
The number of shares of stock outstanding.
The Payout ratio.
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.
Next, click “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.
To determine the stock value based on the dividend-discount model:
Create a timeline in Excel for five years.
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.
Determine the long-term growth rate based on GE’s payout ratio (which is one minus the retention ratio) using Eq. 9.12.
Use the long-term growth rate to determine the stock price for year five using Eq. 9.13.
Determine the current stock price using Eq. 9.14.
To determine the stock value based on the discounted free cash flow method:
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:
EBIT/Sales
Tax Rate (Income Tax Expense/Income Before Tax)
Property Plant and Equipment/Sales
Depreciation/Property Plant and Equipment
Net Working Capital/Sales
Create a timeline for the next seven years.
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.
Use the average ratios computed in part (a) to forecast EBIT, property, plant and
I am an ACCA (UK) professional , APA and Mcom finance.
After carefully reading your project description,
I think that I am the perfect candidate! With over 8 years of working experience.
I can guarantee getting the job right the first
time. Feel free to view my 100% positive reviews before you hire me and rest
assured that you will receive top-quality work at an affordable cost.
Kind regards,
Javed
Hey, I can do this assignment for you and can send back the desired workbook in a couple of days. I have extensive experience in finance and can assure you of accurate data presented in a professional format.
Drop me a message so that we may discuss the details.
Look forward to working with you and thank you for considering my bid.
Regards,
Rishi
Hello! I am a highly qualified business professional, currently doing my doctorate in economics and have tons of writing experience, I am very much excited and deeply interested in bringing laurels to your assignment, please assign me this task without any hassle and you will experience quality work on time. I am 100% Sure, you will award me all your writing tasks once you witness the quality of this task. Thanks!
Hello,
i am chartered accountant & i have done my MBA from finance t would be really easy task for me.
i am interested in working on your project .
Let me know if you are interested.
Thanks
I have done this project before in my finance management class. I have analysed stock of Toyota Motor company. I have participated in CFA Equity Research Challenge where I got chance to analyze the stock of Stepan Company.
Hi
I have more than 8 years of experience in banking. I completed MBA in finance from IIM Bangalore, one of the top 100 business schools in the world. I cleared CFA level 2 and FRM in 2012.
regards
Jagadeesh
Hi there. This sounds like a fun problem. This literally sounds like a question right out of the CFA program. I am a chartered financial analyst and have solved many problems like this. In my professional career I have experience in commercial banking, and institutional investment management. In my current position I trade CMBS and MBS for a large California pension fund. I would love the opportunity to work with. Thank you for the consideration.