Analyzing CMG(Chipotle Mexican Grill, Inc. Must be good at using excel to conduct regression analysis.
Read carefully
Presentation of the company:; 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.
Answer preview to analyzing CMG(Chipotle Mexican Grill, Inc. Must be good at using excel to conduct regression analysis.
APA
2030 words
Get instant access to the full solution from by clicking the purchase button below
We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.