Could someone help me please? I'm taking up Finance.
Practice Set Chapters 8 and 9 Name________________
Please open and complete the yellow cells in the Excel spreadsheet. If you are not familiar with common sized statements, you may what to watch the video on the lecture note page in week four.
We are now in the part of the course where we will need to do educated predictions of the inputs for the valuation model. As with all predictions, there is no one correct answer, but there are better answers than others. Many people believe that this is where financial statement analysis becomes more of an art than a science. But let us begin with science, and science tells us that the best predictor of the future is the past, modified for internal or external conditions that are expected to change in some way. For this reason, the common sized history is a good starting point for your future estimates.
For each of the income statement items listed below, please explain the logic behind your estimates for that individual item:
Explain the logic behind your estimates of future Food, Beverage, and Packaging expenses—
Explain the logic behind your estimates of future Labor expenses—
Explain the logic behind your estimates of future Operating costs —
Explain the logic behind your estimates of future Other Operating costs —
Explain the logic behind your estimates of future General and Administrative expenses—
The most important determinant of value and changes in future value is the firm’s ability to grow projects/ideas that possess an ROIC greater than its cost of capital (or in other words positive net present value projects). In the textbook, in Chapter 8 the authors discuss three ways to grow. The following questions relate to these areas.
“Create new markets through new products” – how is Chipotle doing this now and in the future?
“Convince existing customers to buy more of a product” – how is Chipotle doing this now and in the future?
“Attract new customers to the market” -- how is Chipotle doing this now and in the future?
Please attach this document and the completed Excel spreadsheet to the assignment tab (both can be attached) – thanks.
