Create 4 spread sheets with the following information on Tesla stock

Valuation Project: Due 11/4/18 by 11:59 p.m. You have been hired as a financial analyst, and your first assignment on the job is the value the stock of any publicly traded company You will need to use the following valuation models: 1. Dividend Discount Model 2. Residual Income Model 3. FCFF 4. FCFE You will need to use a constant growth assumption, as well as a multi-stage assumption for all models. You will need to create a spreadsheet that shows your work and estimation of all inputs for the models. Although you will need to turn in a written report that describes your estimate of value, in order to justify your valuation, you will need to discuss the estimation of the inputs to your model (k, g, cash flow) and discuss why they are good estimates. This will likely require an analysis of the global macro economy, domestic economy, and industry in which the firm operates. It will likely involve a discussion of the company and how they generate revenue and make money. In addition, if you find a model that you think would work better for the company than you can include that in your analysis. This report will be graded on professionalism and is an independent project and it is not likely you will have the same valuation as someone else. Page 1 of 1 Valuation Project: Due 11/4/18 by 11:59 p.m. You have been hired as a financial analyst, and your first assignment on the job is the value the stock of any publicly traded company You will need to use the following valuation models: 1. Dividend Discount Model 2. Residual Income Model 3. FCFF 4. FCFE You will need to use a constant growth assumption, as well as a multi-stage assumption for all models. You will need to create a spreadsheet that shows your work and estimation of all inputs for the models. Although you will need to turn in a written report that describes your estimate of value, in order to justify your valuation, you will need to discuss the estimation of the inputs to your model (k, g, cash flow) and discuss why they are good estimates. This will likely require an analysis of the global macro economy, domestic economy, and industry in which the firm operates. It will likely involve a discussion of the company and how they generate revenue and make money. In addition, if you find a model that you think would work better for the company than you can include that in your analysis. This report will be graded on professionalism and is an independent project and it is not likely you will have the same valuation as someone else. Page 1 of 1