Practice Set for Chapters 16,17,18:
Please use the financial valuation model located in this assignment tab for the remaining problems. What would happen to Chipotle’s valuation (intrinsic value per share) if the number of new stores per year increased by 15 stores per year after 2024 (2024 is projected by Chipotle management to be 285 to 315 for an average of 300). So, the 2025 estimated new stores would be 315 and this would grow by 15 stores to 585 in 2043. By adding 15 additional stores per year – so in 2025 Chipotle would add 315 new stores, in 2026 Chipotle would add 330 new stores, and so on until it levels off at 585 stores in perpetuity in 2043. What is the new intrinsic value per share?Please return to the original financial valuation model located in this assignment tab. What would happen to Chipotle’s intrinsic value per share if the investment in leasehold improvements (per new store opened) went from the assumed historically based $700,000 per new store to $900,000 per new store due to increases in the costs of equipment and inflationary impacts on metal and furniture? Model this increase starting in 2024 and continuing to 2043 starting a $900,000 and increasing at 2.5% per year. What is the new intrinsic value per share?For this problem, go back to the original valuation model then please type in a sensitivity that you believe plausible for Chipotle’s future (remember sensitivity analysis changes just one variable at a time to view the impact on the value of the firm) and then run this using the model (after first going back to the original model and then making the change). Please do not repeat the two sensitivities you completed in questions 4 and 5 above. My sensitivity analysis involves changing ________________________________________ and the new intrinsic value resulting from this change is $______per share.Go back to the original model. Changing only the average number of new stores per year (originally set at 300 per year) how many new stores will Chipotle need annually from 2024 to 2043 to force the model intrinsic value to Chipotle’s market price today of $2,233 per share?Going back to the original model, what annual increase in sales per store as a percentage would Chipotle need to force the model’s intrinsic value to Chipotle’s market price today of $2,233 per share?