FINA 4370 Final ProjectYour final project will be an valuation of a publicly traded company. Similar to other projects youhave done in the course, the project will be group‐based (i.e., one per group and group members areassigned equal grades). Your goal is similar to a sell side analyst who often comes up with a price target.You can choose which company you would like to evaluate. One useful source ofinformation is the EDGAR company filings database maintained by the SEC. However, you have the choiceto complement this information source using other sources. The information needs to be credible. Properbibliography and acknowledgment are a must. (website: https://www.sec.gov/edgar/searchedgar/companysearch.html and search for your firm)You should apply extensively what we have learned throughout this course and try to integratethese into your model. Your final deliverable will consist of a double‐spaced writeup and the Excel model.Your writeup should describe clearly the thoughts and subjective decisions that go into your Excel model.For instance, you should explain why you select a particular technique to evaluate a specific product line ofApple. Please pay attention to the details of the financial statements and discussions used in the 10K.Even for companies that are not producing tangible products, they have their distinct lines of businessand the revenues from these different product lines are generally reported or discussed separately. Youshould have an estimate of the current stock price.There are a few criteria against which the project is evaluated:1. How far is your estimated stock price from the consensus estimate on the street.2. How well you have integrated the knowledge from the class.3. How much attention to detail you have paid to materials mentioned in the 10‐K.4. How extensively you have utilized information from other sources.5. How logical your reasoning is/how reasonable are your assumptions?6. Professionalism of presentation (you should have seen some sell side analyst reports by now)7. What are the drivers of how far your estimate is away from the street consensus. Can youprovide a more detailed discussion of these factors? What arethe recent events/developments that might influence these factors and their roles indetermining the stock price?Overall I am looking for your best group effort. While there is not an exact right or wrong in these modelingexercises, it is relatively easy to see through good vs. poor effort.Good luck. Your group should inform me about the company you are evaluating by Monday, April 26.Please keep the company name to yourself, as two groups can evaluate the same company bycoincidence.
