AD717 Chipotle Mexican Grill Inc Regression Analysis

Read carefully

Presentation of the company: business model; industry, its peers and the company’s position within that group; history; leadership; etc.
Fundamentals of the company: past performance of the stock; revenue and earnings and their development over the years; appropriate financial ratios.
Price and price expectations: based on the previous section, run a DCF analysis to arrive at your best estimate for the intrinsic value of the company and your best estimate for the share price. Clearly explain your assumptions and provide two alternate scenarios. The report should contain the main table of the DCF for readers to observe your calculations and assumptions. For your DCF you need to find beta which you can do with a regression analysis, as well as the credit rating. Feel free to reach out to me if you need help with the credit rating and its implication for cost of debt.
Risks and headwinds: your DCF is based on assumptions about the future of the company, its industry environment, and the market and business environment. How sensitive is your analysis to this? More specifically, what are the headwinds and risks that the company faces in its operations in the near and medium-term future?
Conclusion and recommendation for three investors (see below).

The stock report must be submitted as a word document. Use the APA style formatting. Font size 12.Additionally, attach the Excel spreadsheet in which you performed your analysis. You have to create your own excel spreadsheet; that means, downloading, using and submitting prepared DCF(discounted cash flow) Excel documents from the Internet will lead to a loss of points.
Note: You MUST submit an excel file that shows how you calculate the DCF (discounted cash flow) to me. You can find CMG stock information on Yahoo finance. For calculate the DCF (discounted cash flow), you need to find the 10-K form which is on Security Exchange Commission official website or on Yahoo finance. Just following the “Reading carefully” steps. Thank you.
The DCF(discounted cash flow) formula is in the PPT
For calculating the WACC, you can find the formula in PPT.

Our Service Charter

1. Professional & Expert Writers: I'm Homework Free only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by I'm Homework Free are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. I'm Homework Free is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At I'm Homework Free, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.