Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Year 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Sales $ 470,721 $ 627,695
Year | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 |
Sales | $ 470,721 | $ 627,695 | $ 822,930 | $ 1,085,782 | $ 1,331,968 | $ 1,518,417 | $ 1,835,922 | $ 2,269,548 | $ 2,731,224 | $ 3,214,591 | $ 4,108,269 | $ 4,501,223 | $ 3,904,384 | $ 4,476,412 | $ 4,864,985 | $ 5,586,369 | $ 5,984,634 | $ 7,547,061 | $ 8,634,652 |
Food, beverage and packaging | $ 154,148 | $ 202,288 | $ 257,998 | $ 346,393 | $ 431,947 | $ 466,027 | $ 561,107 | $ 738,720 | $ 891,003 | $ 1,073,514 | $ 1,420,994 | $ 1,503,835 | $ 1,365,580 | $ 1,535,428 | $ 1,600,760 | $ 1,847,916 | 1,932,766 | 2,308,631 | 2,602,245 |
Labor | $ 139,494 | $ 178,721 | $ 231,134 | $ 289,417 | $ 351,005 | $ 385,072 | $ 453,573 | $ 543,119 | $ 641,836 | $ 739,800 | $ 904,407 | $ 1,045,726 | $ 1,105,001 | $ 1,205,992 | $ 1,326,079 | $ 1,472,060 | 1,593,013 | 1,917,761 | 2,197,958 |
Occupancy cost | $ 36,190 | $ 47,636 | $ 58,804 | $ 75,891 | $ 98,071 | $ 114,218 | $ 128,933 | $ 147,274 | $ 171,435 | $ 199,107 | $ 230,868 | $ 262,412 | $ 293,636 | $ 327,132 | $ 347,123 | $ 363,072 | 387,762 | 416,606 | 460,425 |
Other operating | $ 64,274 | $ 82,976 | $ 102,745 | $ 131,512 | $ 164,018 | $ 174,581 | $ 202,904 | $ 251,208 | $ 286,610 | $ 347,401 | $ 434,244 | $ 514,963 | $ 641,953 | $ 651,644 | $ 680,031 | $ 760,831 | 1,030,012 | 1,197,054 | 1,311,905 |
Gen and Admin | $ 44,837 | $ 51,964 | $ 65,284 | $ 75,038 | $ 89,155 | $ 99,149 | $ 118,590 | $ 149,426 | $ 183,409 | $ 203,733 | $ 273,897 | $ 250,214 | $ 276,240 | $ 296,388 | $ 375,460 | $ 451,552 | 466,291 | 606,854 | 564,191 |
Depreciation/amort | $ 21,802 | $ 28,026 | $ 34,253 | $ 43,595 | $ 52,770 | $ 61,308 | $ 68,921 | $ 74,938 | $ 84,130 | $ 96,054 | $ 110,474 | $ 130,368 | $ 146,368 | $ 163,348 | $ 201,979 | $ 212,778 | 238,534 | 254,657 | 286,826 |
Preopening cost | $ 2,192 | $ 1,971 | $ 6,778 | $ 9,585 | $ 11,624 | $ 8,401 | $ 7,767 | $ 8,495 | $ 11,909 | $ 15,511 | $ 15,609 | $ 16,922 | $ 17,162 | $ 12,341 | $ 8,546 | $ 11,108 | 15,515 | 21,264 | 29,560 |
Loss on disposal | $ 1,678 | $ 3,119 | $ 3,982 | $ 6,168 | $ 9,339 | $ 5,956 | $ 6,296 | $ 5,806 | $ 5,027 | $ 6,751 | $ 6,976 | $ 13,194 | $ 23,877 | $ 13,345 | $ 66,639 | $ 23,094 | $ 30,577 | $ 19,291 | $ 21,139 |
Total operating costs | $ 464,615 | $ 596,701 | $ 760,978 | $ 977,599 | $ 1,207,929 | $ 1,314,712 | $ 1,548,091 | $ 1,918,986 | $ 2,275,359 | $ 2,681,871 | $ 3,397,469 | $ 3,737,634 | $ 3,869,817 | $ 4,205,618 | $ 4,606,617 | $ 5,142,411 | $ 5,694,470 | $ 6,742,118 | $ 7,474,249 |
Operating income | $ 6,106 | $ 30,994 | $ 61,952 | $ 108,183 | $ 124,039 | $ 203,705 | $ 287,831 | $ 350,562 | $ 455,865 | $ 532,720 | $ 710,800 | $ 763,589 | $ 34,567 | $ 270,794 | $ 258,368 | $ 443,958 | $ 290,164 | $ 804,943 | $ 1,160,403 |
Pretax income | $ 6,126 | $ 3,024 | $ 68,255 | $ 114,002 | $ 127,206 | $ 204,225 | $ 289,061 | $ 349,705 | $ 457,685 | $ 534,471 | $ 714,303 | $ 769,867 | $ 38,739 | $ 275,743 | $ 268,436 | $ 458,285 | $ 293,781 | $ 812,763 | $ 1,181,531 |
Provision for taxes | $ - | $ (7,456) | $ 26,832 | $ 43,439 | $ 49,004 | $ 77,380 | $ 110,080 | $ 134,760 | $ 179,685 | $ 207,033 | $ 268,929 | $ 294,265 | $ 15,801 | $ 99,490 | $ 91,883 | $ 108,127 | $ 69,314 | $ 159,779 | $ 282,430 |
Net income | $ 6,126 | $ 10,480 | $ 41,423 | $ 70,563 | $ 78,202 | $ 126,845 | $ 178,981 | $ 214,945 | $ 278,000 | $ 327,438 | $ 445,374 | $ 475,602 | $ 22,938 | $ 176,253 | $ 176,553 | $ 350,158 | $ 224,467 | $ 652,984 | $ 899,101 |
Effective tax rate | 39.3% | 38.1% | 38.5% | 37.9% | 38.1% | 38.5% | 39.3% | 38.7% | 37.6% | 38.2% | 40.8% | 36.1% | 34.2% | 23.6% | 23.6% | 19.7% | 23.9% |
calculate proforma estimates for Chipotle's expenses in the coming years 2024,2025,2026,2027 and beyond (as a percentage of sales
Year | 2022 | ||
Sales | $ 8,634,652 | ||
Food, beverage and packaging | 2,602,24 | ||
Labor | 2,197,958 | ||
Occupancy cost | 460,425 | ||
Other operating | 1,311,905 | ||
Gen and Admin | 564,191 | ||
Depreciation/amort | 286,826 | ||
Preopening cost | 29,560 | ||
Loss on disposal | $ 21,139 | ||
Total operating costs | $ 7,474,249 | ||
Operating income | $ 1,160,403 | ||
Pretax income | $ 1,181,531 | ||
Provision for taxes | $ 282,430 | ||
Net income | $ 899,101 | ||
Effective tax rate |
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