You are to pick a stock and create an analysis regarding potential investment. You should incorporate...

Transcribed Image Text:

You are to pick a stock and create an analysis regarding potential investment. You should incorporate aspects of the fundamental analysis (DGM, RIM, FCF, multiples). You may use any data sources you wish and any specific methods. Much of your work, including virtually all of the calculations, need to be done in Excel. More specifically, they need to be done in a manner that facilitates flexibility. You should set up your model so that the inputs can be changed and the calculations automatically adjust. In addition, you are required to complete a written report. In this report, you are to do the following: 1. Write a brief introduction detailing the company you chose and, more importantly, why you chose it. This section should not be more than 1 page in length. 2. Describe the quantitative methods used to arrive at your valuation. 3. Provide a summary of your numerical conclusions. 4. Provide a short (less than 1 page) conclusion, detailing your recommendation for investment and an exit plan. You are to pick a stock and create an analysis regarding potential investment. You should incorporate aspects of the fundamental analysis (DGM, RIM, FCF, multiples). You may use any data sources you wish and any specific methods. Much of your work, including virtually all of the calculations, need to be done in Excel. More specifically, they need to be done in a manner that facilitates flexibility. You should set up your model so that the inputs can be changed and the calculations automatically adjust. In addition, you are required to complete a written report. In this report, you are to do the following: 1. Write a brief introduction detailing the company you chose and, more importantly, why you chose it. This section should not be more than 1 page in length. 2. Describe the quantitative methods used to arrive at your valuation. 3. Provide a summary of your numerical conclusions. 4. Provide a short (less than 1 page) conclusion, detailing your recommendation for investment and an exit plan.