Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach Chapters 1-25

Authors: Jeffrey Slater

12th Edition

013277206X, 978-0132772068

More Books

Students also viewed these Accounting questions