|Perfect Number of Pages to Order||5-10 Pages|
Stock Valuation project Essay Assignment
FIN 430 — Finance Theory and Practice
Stock Valuation project
You have been assigned a company to research (please check the excel list for the firm you are assigned to). statements are available on the internet through at the http://finance.yahoo.com website. At this website you will put the ticker symbol for your company in the symbol box and press “go”. At this point you will see a page that has financial information about your company. On the left-hand side of the screen there will be a series of options that you can choose to get more information about your company. Under the heading “financial statements” you will see an option for “income statement” and “balance sheet.” You want annual statements. The financial statements for the past 3 years should be available. (Depending on the fiscal year for your company, these might be 2015, 2016, and 2017 or 2016, 2017 and 2018.).
The purpose of the project is to estimate and justify: (1) an intrinsic (fundamental) value for the company of your choice and (2) the fundamental price/share of equity in the firm. You should attempt to justify that you have calculated your best estimate of the firm’s stock price. You may compare your values (ratios/prices/calculations, etc.) to those you find on the internet, but your work should be your own and your job is to calculate these figures. All calculations/ratios/values are assumed to have been calculated by you own. You should not substitute those figures for yours and using such figures from other sources is plagiarism. All of your reports (including table, graph, figures, reference, etc) should not be longer than 25 pages.
You may use up to three different methods to calculate firm stock value (the FCF method is most important and you have to include this analysis in your project). The three methods that we study for valuing corporations include:
|Value of Operations (Enterprise Value )|
|+ Value of non-operating assets (one example would be marketable securities)|
|= Total Firm value|
|– Value of Debt [we use the book value of ST and LT debt; though theory suggests that the market value|
|– Value of Preferred Shares [if any]|
|= Value of Equity|
|÷ Number of Shares of Common Stock outstanding|
|Price per share|
This price per share is your estimate of the fundamental value of the firm stock, which you would then use to argue that the firm is either currently over/under/fairly valued according to the market, i.e., by comparing your price/share to the current market price/share. Warren Buffet calls this estimate the “intrinsic value” of the firm. Remember that you may consider the efficient market hypothesis in relation to your price estimate.
General Guidelines (Mandatory)
The major focus of the project is to calculate and justify your estimate of the price/share of equity using the FCF Method. Many other elements of the project are necessary in order to complete a satisfactory project. Minimally, these include:
Data Needed to Construct the Pro Formas
* Dividend data: You can attain the historical data from https://www.dividata.com/
* An Excel spreadsheet that you use to construct your pro formas. An excel file is provided on BB and here under the name: CH12 (Figure 1-3) . This file “automatically” completes the 5 years of pro formas for you; given that you have input the data and assumptions correctly.
* 2 years of the firm’s historical financial statements, including annual balance sheets, income and cash flow statements (these form the basis of your pro formas). You may also want to download 5-10 year historical data to do a better estimate. This data may be downloaded at Mergent-Online (available through the university library) or through the SEC official site: http://www.sec.gov/edgar/searchedgar/companysearch.html
NOTE: While you may want to read or skim the 10Ks for your company, you need not construct the 10 years of financial data from the 10Ks. Rather, using either SEC site or MergentOnline, you are able to download the 5-10 years of financial statements directly as a file which can be read by Excel. Should you have difficulty, please contact me.
* Estimates of the company’s current and future (long-term normal – gn ) sales growth (this should be completed in the same manner that you calculate dividend growth for a company) – you may use the Growth estimate sheet available on Blackboard as a guide. Use the 10 years of financial statements for the historical sales figures.
* A justification of your choice of constant or non-constant ratios when completing the pro-formas (the base case should usually be the constant ratio approach as discussed in the text).
* An estimate of the firm’s target capital structure (see the guideline below about Calculating a Firm’s WACC) – note that you need these weights both for the WACC.
* An estimate of the firm’s dividend payout policy.
* The firm’s tax rate.
Steps to Take after Completing the Pro Formas
* As mentioned above, the goal is to calculate the firm’s value (in the end, your estimate of the stock price/share). This requires that you calculate the firm’s FCFs (free cash flows) as discussed in the relevant chapters in your text (CH2 and CH12). This should be a relatively easy procedure, and should be done on the same Excel spreadsheet as your pro-formas (see CH12 (Figure 1-3)).
* You also need to calculate the Continuing Value (or terminal or horizon values) as discussed in CH6 – see the related equation (it is analogous to the constant growth part of the supernormal growth model)! This is a crucial part of the project, because the continuing value of the firm will typically be the largest proportion of any firm’s current value.
* To discount the FCFs back to the “present” (to the date of your last historical financial statements) you need to have an estimate of the firm’s WACC(note that this includes the weights of debt and equity, the costs of debt and equity, the latter of which is calculated by using the CAPM, with your estimate of the firm’s beta). Again, see the guidelines of WACC Calculation about Calculating a Firm’s WACC, and also review the “Four Mistakes to Avoid” (see the index to your text).
* Once you have completed these steps, you are then ready to follow the general steps described above to calculate your estimate of the stock price/share.
Improving the Quality of your Project (Optional)
Other elements are left up to you, in terms of how complete and/or creative you want your project to be. Some of these elements must be completed in order to earn a higher than average or satisfactory evaluation for the project. You may/should include these other elements if you believe that they will improve your “case” for your estimate of the price/share for your firm. For example, a SWOT analysis is often used in business. For this project, it may be useful, but only if you can connect the main conclusions of the SWOT analysis to your evaluation of the firm.
The most important extensions include:
* Using ratios that are not a constant percentage of sales when constructing the pro formas (the basic percent of sales method is described in the Financial Planning and Forecasting Financial Statements chapter of the text). The relevant procedures are either discussed in the text or are available on spreadsheets that come with the text and/or are on the text’s homepage (listed in the syllabus). The firm’s profit margin has a very important impact on firm value. If you use the most recent profit margin in the pro formas, you may not be providing an accurate longer-term picture of the firm’s operations. As a result, it may be useful or even crucial to analyze this ratio and/or others when constructing the pro formas.
* Sensitivity analysis. How does your estimate of the price/share change with changes in the firm’s WACC, the firm’s short or long-term growth rates, changes in the firm’s profit margin(s) and so on. The amount of work that could be done here is almost limitless, so good projects would demonstrate good judgment in which sensitivity analyses they conduct.
* Scenario analysis. This is similar to sensitivity analysis, but discrete scenarios (e.g., a recession or a boom) are analyzed instead.
* Ratio analysis. Ratios can be used as diagnostic tools in evaluating the “health” of a firm. Note that such analysis would typically include comparisons of your firm’s financial ratios to the industry standards (or averages). These averages are available on the Yahoo.finance site under: Profile/Competitors (Sector or Industry). Ratio analysis by itself is not very useful in terms of valuation. It provides a diagnostic view of the company which may be helpful in terms of analyzing the better and poorer practices of a company. In order to make ratio analysis relevant for this project, it must be tied directly to the firm’s valuation. For example, if a company’s current Inventory Turnover is very poor, the group can suggest that it should get better into the future, and then make the necessary adjustments (which may require changes in the formulas) in the pro forma sheets, to see how improving the inventory turnover would increase the firm’s value.
* Managerial/Strategy Analysis. You may view your job of this project as the managers of the firm. In completing the project, you may recognize that the company is either performing some function very well or very poorly. It is perfectly appropriate to make suggestions for improving or maintaining the operation of the firm.
* Marketing Analysis. Future sales typically depend upon marketing. Projects which focus on companies for which this may be particularly important may consider analyzing the marketing policies of the company in order to determine how those policies affect firm value
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER