Question
1. With detailed explanations introduce a first project proposal for Chipotle that sufficiently has an ESG/sustainability element. This project should have some impact on the
1. With detailed explanations introduce a first project proposal for Chipotle that sufficiently has an ESG/sustainability element. This project should have some impact on the environmental stakeholder, the societal stakeholder, the employee stakeholder, the supplier stakeholder, as well as the traditional stockholder. Please explain how the project will affect each of the stakeholders. Please make this project realistic so I can understand how it can be applied in real-life situations.
2. With detailed explanations introduce a second project for Chipotle which also has an ESG/ sustainability element and this should be a more realistic traditional project that benefits the customer and one other stakeholder or the stockholder.
3. With the two project proposals above, describe in detail the expected cash flows to be caused by the projects. Put another way you will describe in words your assumptions.After the complete description in words, please build an Excel spreadsheet illustrating the cash flows over the life of each of the projects. Starting from the acquisition stage with the initial outlays for the equipment, buildings, land, upfront advertising and promotion, training, and other inputs. Not forgetting working capital and any assumed relationships with drivers.
4. Also describe in words and numbers the cash inflows and outflows expected in the operating stage of this project's life. Including revenues, possible lost revenues, all the costs discussed in the course, whether these costs are fixed or variable and what relationships they have with the driver, assumed income tax rate, depreciation, and any other relevant inputs.
5. Describe for both projects how you expect to exit or not exit each of the projects.For example, forequipment type projects the equipment will wear out and there will be no deposition value, for building type projects (like drive-throughs and menu enhancements)there not be a disposition value but a continuing value.For this value, I would recommend taking the eight-year estimate of cash flow from operations and multiplying by 5 and using this as a continuing value, and label it as such.
6. Put together an Excel spreadsheet with the assumptions at the top of the sheet. Followed by the acquisition stage cash flows (remember to carry out and number years to year 8), the operating stage cash flows, the continuing or disposition stage cash flow, and conclude with a grand total of the cash flows for each year.
Video link 1 https://www.youtube.com/watch?v=leDB_uRB3qE
Video link 2 https://www.youtube.com/watch?v=SJ4o7d6-ONg
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started