Group Project
Form a group:
Groups must be formed by 2/14. A group may contain a maximum of four members. Choose a name for your group. (If you have trouble getting into a group, email me starting 2/2. I will run a lonely hearts list on the web page, with the names of people looking to join a group.)
Pick a company:
Pick a company from the list to be posted on the web page. Each group needs to choose a different company.
Register your group and company with me:
Send me an email by 2/14, giving me the name of your group, the names of all group members, and the company you want to choose. If your company has already been picked, I will let you know, and you'll need to choose again. (Late emails will lead to a point deduction.)
The project:
Over the semester, you will turn in two reports consisting of various financial analyses of your company, as described below. The company you pick will need to have been in existence for at least 4 years. Ideally, it should be a parent company, not a subsidiary; and it should be in one industry rather than a conglomerate. Avoid financial companies. Most firms on the list should conform to this description, but all firms may not. The first thing you should do once you pick a company is make sure it conforms.
The first report (due 3/14) will consist of a brief description of the company, and an analysis of its latest financial statements. Details below.
The second report (due 4/27) will consist of an analysis of your company's stock price changes over the past year, a decomposition of its stock price into the PV of existing assets and PVGO, and an estimate of its WACC. Details below.
Please note that each report must contain the following information on the cover page: name of your group, names of all group members, and the name of the company you are analyzing. (If any of this information is omitted, that will lead to a point deduction.)
Report # 1
|
Start by providing a brief description of the company: the products or services it sells, characteristics of its markets, any recent changes in the company's operations or management or ownership, any other significant news (over the last three years only). This should be about a page or two. (Please put together your own write-up; do NOT lift it from some web page or other published source. Do not quote without attribution. Acknowledge all sources.) | |
|
Analyze the company's financial statements. Your objective is to identify the company's strengths and weaknesses, and to analyze how or why it came to have the performance it has (and the financial condition it has). | |
|
In analyzing its financial statements, look at how various ratios have changed over the last three years (i.e. consider the last full year, and the previous two years). Pick a competitor, and compare your company to it over the same three year span (not allowed to pick Kmart as a competitor). Also compare your company's ratios to the industry average. (You will not get industry average data for all the ratios; work with those you find.) | |
Please note that you should compute your own ratios from scratch using the information contained in the financial statements. Except for the industry comparison described below, do NOT use pre-computed ratios from Reuters or any other web page. | |
Remember that a financial statement analysis involves a lot more than just computing ratios, and stating which ratios went up, or which ratios are lower than the competitor/industry average. Ultimately, the financial statements tell a story about the company's performance. You are trying to reconstruct this story. | |
Industry ratios can be obtained from www.investor.reuters.com. Following the same instructions as you did to obtain the financial statements, if you click on "Ratios" in the left column menu, this will pull up a comparison (for selected key ratios) of your company's ratios with the average ratio for the industry. (Reuters may compute a given ratio differently from how you did it. Don't worry about this. Use your computed ratios for the basic analysis, and for comparisons between your company and its competitor. Use Reuter's ratios only for the industry comparison.) (Please note that TTM means trailing twelve months and MRQ means most recent quarter.) | |
|
Attach to your report the Reuters printouts of all three financial statements for your company as well as for the competitor firm. Also attach a table containing the ratios you computed. |
Report # 2 (to be discussed in detail in class on 4/20)
Part I: Analysis of stock price changes
Track the change in your company's stock price over the last 12 months. Focusing only on significant ups and downs, discuss why you think the stock price changed. There are two aspects to this. One, what type of news was responsible -- economy-wide, industry-wide or firm-specific? Two, can you identify the specific news item causing the price change? In each case, try and identify whether the news would tend to affect future cashflows or risk. | |
Provide a graph of stock price movements in your report. Yahoo Finance will allow you to put both stocks on the same graph, along with the S&P500 index or the Nasdaq index or the DJIA. ( Check out "compare" under "Chart".) Use whichever index seems most appropriate for your stock. |
Part II: Decomposing stock price into the PV of existing assets and PVGO
|
Estimate what proportion of the company's current stock price is based on future growth opportunities. | |||||||
|
Compare the company to the competitor firm, and see which has greater growth opportunities. (Would you have guessed this from the financial statement analysis done earlier? Include a brief discussion explaining why or why not.) | |||||||
|
You need to compute the PV of the existing assets. The difference between the current stock price and this number is PVGO. To compute the PV of the existing assets, you will need required return and expected future earnings. | |||||||
For required return:
| |||||||
|
For expected future earnings, you can go to Reuters or www.morningstar.com
|
Part III: Estimating WACC (weighted average cost of capital) and asset beta
Make sure you fully explain your work. This includes stating clearly any assumptions you made, and defending those assumptions (i.e. explain why you assumed what you did) | |||||||
Estimate WACC and asset beta both for your firm and the competitor firm you have chosen. | |||||||
Discuss the meaning of the WACC number. Under what conditions should it be used to evaluate a new investment project? | |||||||
Please remember the following:
|