{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Exe Sum","MEMO","Industry","MCD","YOY MCD","CAVA","YOY CAVA","CMG","YOY CMG","SHAK","YOY SHAK","YUM","YOY Yum","Ratio Formulas","TrendLineChart"],"not_rendered":{"charts":12,"images":2,"macros":0,"external_links":1,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Exe Sum","index":0,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"STOCK NAME","TICKER","MARKET PRICE (12/31/2024)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"McDonald's Corporation","(MCD)",305.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CAVA Group, Inc.","(CAVA)",58.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Chipotle Mexican Grill, Inc.","(CMG)",37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Shake Shack Inc.","(SHAK)",81.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yum! Brands, Inc.","(YUM)",151.28]

{"sheet":"MEMO","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Industry","index":2,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Company Name",null,"MCD","CAVA","CMG","SHAK","YUM","Industry"]
["*Numbers in Thousands",null,1,2,3,4,5,"Average"]
["Stock Price, Market Price of Common Stock ",null,289.89,170.25,68.55,144.65,137.77000000000001,{"$f":"AVERAGE(C3:G3)","v":162.22199999999998}]
["Revenue",null,{"$f":"_xlfn.XLOOKUP(A4,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":25920},963.71,11313.85,1252.6099999999999,7549,{"$f":"AVERAGE(C4:G4)","v":9399.8339999999989}]
["Cost of Revenue",null,{"$f":"_xlfn.XLOOKUP(A5,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":11210},532.23,8296.16,950.14,2120,4621.7060000000001]
["Gross Profit",null,{"$f":"_xlfn.XLOOKUP(A6,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":14710},431.48,3017.69,302.47000000000003,5429,4778.1279999999997]
["SG&A Expenses",null,{"$f":"_xlfn.XLOOKUP(A7,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":2412},120.5,697.48,149.05000000000001,2892,1254.2060000000001]
["Operating Income",null,{"$f":"_xlfn.XLOOKUP(A8,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":11712},43.12,1916.33,3.04,2403,3215.4980000000005]
["Net Income Common",null,{"$f":"_xlfn.XLOOKUP(A9,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":8223},130.32,1534.11,10.210000000000001,1486,2276.7280000000001]
["Cash and Short Term Investments",null,{"$f":"_xlfn.XLOOKUP(A10,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":1085},385.78,1422.91,320.70999999999998,616,766.08]
["Receivables",null,{"$f":"_xlfn.XLOOKUP(A11,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":2383},16.54,211.19,19.690000000000001,775,681.08400000000006]
["Inventory",null,{"$f":"_xlfn.XLOOKUP(A12,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":56},7.99,48.94,6.01,100,43.787999999999997]
["Total current assets",null,{"$f":"_xlfn.XLOOKUP(A13,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":4599},418.54,1780.59,368.22,1871,1807.47]
["Total Assets",null,{"$f":"_xlfn.XLOOKUP(A14,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":55182},1291.6300000000001,9204.3700000000008,1696.97,6727,14820.394]
["Total current liabilities",null,{"$f":"_xlfn.XLOOKUP(A15,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":3861},153.71,1168.77,187.31,1269,1327.9580000000001]
["Long Term Debt (Total)",null,{"$f":"_xlfn.XLOOKUP(A16,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":38424},100,100,246.68,11306,10035.335999999999]
["Total liabilities",null,{"$f":"_xlfn.XLOOKUP(A17,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":58979},540.91999999999996,5548.83,1203.3499999999999,14375,16129.420000000002]
["Common Equity (Total) or Shareholders Equity",null,{"$f":"_xlfn.XLOOKUP(A18,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":"Find it"},750.71,3655.55,493.63,-7648,-687.02749999999992]
["Shares (Common)",null,{"$f":"MCD!B32","v":721.9},114.52,1358.75,42.52,279,503.33800000000002]
["Financial Ratio's"]
["Liquidity "]
["Current Ratio",null,1.1911421911421911,{"$f":"D13/D15","v":2.7229197840088477},1.5234733951076773,1.9658320431370457,1.4743892828999212,1.7755513392591369]
["Quick Ratio",null,0.93467166279523217,{"$f":"(D14-D12)/D17","v":2.3730681061894554},1.6499748595649895,1.4052104541488346,0.46100869565217389,1.3647867556701372]
["Net Working Capital",null,738,{"$f":"D13-D15","v":264.83000000000004},611.81999999999994,180.91000000000003,602,479.51200000000006]
["Asset Management"]
["Accounts Rec. Turnover",null,10.87704574066303,{"$f":"D4/'YOY MCD'!D11","v":0.38734324758842448},4.7477339488040284,0.52564414603441034,3.1678556441460346,3.9411245454471855]
["Inventory Turnover",null,462.85714285714283,{"$f":"D4/D12","v":120.61451814768461},231.17797302819781,208.42096505823628,75.489999999999995,219.71211981825232]
["Total Asset Turnover",null,0.46971838643035774,{"$f":"D4/D14","v":0.74611924467533264},1.2291824426875495,0.73814504675981296,1.1221941430057976,0.86107185271177011]
["Debt Management"]
["Debt to Equity Ratio ",null,-10.122233930453108,{"$f":"D16/D18","v":0.13320723048847091},2.7355664674262422E-2,0.49972651581143773,-1.4782949790794979,-2.188047899711687]
["Equity multiplier",null,-14.536880927291886,{"$f":"D14/D18","v":1.7205445511582369},2.5179165925784082,3.4377367664039871,-0.87957635983263593,-1.5480518753967778]
["Profitability"]
["Net Profit Margin",null,0.31719999999999998,0.31719999999999998,0.31719999999999998,0.31719999999999998,0.31719999999999998,0.31719999999999998]
["Gross Profit Margin",null,0.56751543209876543,0.44772805096969004,0.26672529687064966,0.24147180686726119,0.71916810173532919,0.44852173770833909]
["Return On Assets ROA",null,0.14899467217570947,0.23666902441101551,0.38989667082049068,0.23413960883221266,0.35595998216143898,0.27313199168017344]
["Return On Equity ROE",null,-2.1659178082191781,0.40719960037830849,0.98172729684999516,0.80491034175394516,-0.31309398535564853,-5.703491091851557E-2]
["Market Value"]
["EPS (Net Income / Shares Common)",null,11.390774345477213,{"$f":"D9/D19","v":1.1379671673070206},1.1290597976080956,0.24012229539040453,5.3261648745519716,3.8448176960669413]
["P/E",null,25.449542867566578,{"$f":"D3/D38","v":149.60888581952116},60.714233333985177,602.40137120470126,25.866641991924631,172.80813504353975]
["Book Value Per Share",null,-5.2583460313062753,{"$f":"D18/D19","v":6.5552741879147751},2.6903771849126037,11.609360301034807,-27.412186379928315,-2.3631041474744809]
["Market Capitalization (Stock Price * Shares Common)",null,209271.59099999999,{"$f":"D3*D19","v":19497.03},93142.3125,6150.5180000000009,38437.83,73299.856299999999]
["Cash Per Share",null,1.5029782518354342,{"$f":"D10/D19","v":3.3686692280824309},1.0472198712051519,7.5425682031984937,2.2078853046594982,3.1338641717962021]
["Revenue Per Share",null,35.905250034630839,{"$f":"D4/D19","v":8.4152113168005602},8.3266605335786572,29.459313264346186,27.057347670250895,21.832756563921425]
["Price to Book Value",null,-39797.9877615648,{"$f":"D41/D40","v":2974.2508766367837},34620.540577854219,529.78956983975866,-1402.2168632322177,-615.12472009325143]

{"sheet":"MCD","index":3,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Statements","2024","2023","2022","2021"]
["Revenue",25920,25494,23183,23222.9]
["Revenue Growth",1.67E-2,9.9699999999999997E-2,-1.6999999999999999E-3,0.20899999999999999]
["Cost of Revenue",11210,10931,9975,10642.7]
["Gross Profit",14710,14563,13208,12580.2]
["SG&A Expenses",2412,2435,2492,2707.5]
["Operating Income",11712,11647,9372,10356]
["Interest Expense (Operating)",100,100,1299,1194]
["Non-operating Income/Expense",-1367,-1125,-1546,-1228.0999999999999]
["Non-operating Interest Expenses",1506,1361,1207,1185.8]
["EBT",10345,10522,7825,9127.9]
["Income Tax Provision",2121,2053,1648,1582.7]
["Income after Tax",8224,8469,6177,7545.2]
["Dividends (Preferred)",1,0,100,100]
["Net Income Common",8223,8469,6177,7545.2]
["EPS (Basic)",11.39,11.56,8.33,10.039999999999999]
["EPS (Diluted)",11.39,11.56,8.33,10.039999999999999]
["Shares (Basic, Weighted)",718.3,727.9,736.5,746.3]
["Shares (Diluted, Weighted)",721.9,732.3,741.3,751.8]
["Gross Margin",0.5675,0.57120000000000004,0.56969999999999998,0.54169999999999996]
["EBIT Margin",0.45190000000000002,0.45689999999999997,0.40429999999999999,0.44590000000000002]
["EBT margin",0.39910000000000001,0.41270000000000001,0.33750000000000002,0.3931]
["Net Profit Margin",0.31719999999999998,0.3322,0.26640000000000003,0.32490000000000002]
["Free Cash Flow Margin",0.2621,0.2883,0.2384,0.31040000000000001]
["EBITDA",13809,13625,11243,12224.1]
["EBIT",11712,11647,9372,10356]
["Income from Continuous Operations",8224,8469,6177,7545.2]
["Consolidated Net Income/Loss",8224,8469,6177,7545.2]
["EPS (Basic, from Continuous Ops)",11.45,11.63,8.39,10.11]
["EPS (Basic, Consolidated)",11.45,11.63,8.39,10.11]
["EPS (Diluted, from Cont. Ops)",11.39,11.56,8.33,10.039999999999999]
["Shares (Diluted, Average)",721.9,732.3,741.3,751.8]
["EPS (Diluted, Consolidated)",11.39,11.56,8.33,10.039999999999999]
["EBITDA Margin",0.53280000000000005,0.53439999999999999,0.48499999999999999,0.52639999999999998]
["Operating Cash Flow Margin",0.36449999999999999,0.377,0.31859999999999999,0.39360000000000001]
["Cash and Short Term Investments",1085,4579,2583.8000000000002,4709.2]
["Receivables",2383,2488,2115,1872.4]
["Inventory",56,53,52,55.6]
["Other current assets",1130,919.1,673,511]
["Total current assets",4599,7986,5424.2,7148.5]
["Property, Plant, Equpment (Net)",25295,24908,23773.599999999999,24720.6]
["Long-Term Investments",2710,1080,1064.5,1201.2]
["Goodwill and Intangible Assets (Total)",3145,3040,2900.4,2782.5]
["Long-term assets (Other)",6095,5618,4707.2,4449.5]
["Total non-current assets",50584,48160,45011.4,46705.8]
["Total Assets",55182,56147,50435.6,53854.3]
["Accounts Payable",1029,1103,980.2,1006.8]
["Accrued Expenses",1611,1903,1630.8,1710.3]
["Current Part of Debt",100,2192,661,706]
["Current Part of Taxes to Pay",361,705,274.89999999999998,360.7]
["Other current liabilities",100,100,1886,1947]
["Total current liabilities",3861,6859,3802.1,4020]
["Long Term Debt (Total)",38424,37153,35903.5,35622.699999999997]
["Non-current Revenue (Deferred)",778,790,757.8,738.3]
["Long Term Tax Liability (Deferred)",1914,1681,1997.5,2075.6]
["Non-current Liabilities (Other)",1115,1313,1843.7,2977.8]
["Total non-current liabilities",55119,53995,52636.9,54435.3]
["Total liabilities",58979,60854,56439,58455.3]
["Additional Paid In Capital",9281,8893,8547.1,8231.6]
["Common Stock (Net)",17,17,16.600000000000001,16.600000000000001]
["Retained Earnings",66834,63480,59543.9,57534.7]
["Treasury Stock",77375,74640,71624.399999999994,67810.2]
["Common Equity (Total)",-3796,-4706,-6003.4,-4601.01]
["Shareholders Equity (Total)",-3797,-4707,-6003.4,-4601]
["Shareholders Equity and Liabilities (Total)",55182,56147,50435.6,53854.3]
["Shares (Common)",715.2,722.7,731.3,744.8]
["Shareholders Equity (Tangible)",-6942,-7747,-8903.7999999999993,-7383.5]
["Net Debt",37339,34766,33980.699999999997,31619.5]
["Total Debt",38424,39345,36564.5,36328.699999999997]

{"sheet":"YOY MCD","index":4,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,4,1,4],[0,6,1,6],[0,8,1,8],[19,4,20,4],[19,6,20,6],[19,8,20,8]]}
[{"$f":"+H48+A1:J44+A1:A1:J45","v":0},null,"MCD","MCD","% Change YOY","MCD","% Change YOY","MCD","% Change YOY","MCD"]
["Year ending:",null,2024,2023,null,2023,null,2022,null,2021]
["Stock Price ",null,289.89,296.51,{"$f":"IFERROR((C3-D3)/D3,\"Missing Info\")","v":-2.2326397086101665E-2},296.51,{"$f":"IFERROR((F3-H3)/H3,\"Missing Info\")","v":0.12514704208249544},263.52999999999997,{"$f":"IFERROR((H3-J3)/J3,\"Missing Info\")","v":-1.6935874958033427E-2},268.07]
["Revenue",null,{"$f":"_xlfn.XLOOKUP(A4,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":25920},{"$f":"_xlfn.XLOOKUP(A4,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":25494},{"$f":"IFERROR((C4-D4)/D4,\"Missing Info\")","v":1.670981407389974E-2},{"$f":"D4","v":25494},{"$f":"IFERROR((F4-H4)/H4,\"Missing Info\")","v":9.9685114092222749E-2},{"$f":"_xlfn.XLOOKUP(A4,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":23183},{"$f":"IFERROR((H4-J4)/J4,\"Missing Info\")","v":-1.7181316717550974E-3},{"$f":"_xlfn.XLOOKUP(A4,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":23222.9}]
["Cost of Revenue",null,{"$f":"_xlfn.XLOOKUP(A5,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":11210},{"$f":"_xlfn.XLOOKUP(A5,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":10931},{"$f":"IFERROR((C5-D5)/D5,\"Missing Info\")","v":2.5523739822523098E-2},{"$f":"D5","v":10931},{"$f":"IFERROR((F5-H5)/H5,\"Missing Info\")","v":9.5839598997493738E-2},{"$f":"_xlfn.XLOOKUP(A5,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":9975},{"$f":"IFERROR((H5-J5)/J5,\"Missing Info\")","v":-6.2737839082187857E-2},{"$f":"_xlfn.XLOOKUP(A5,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":10642.7}]
["Gross Profit",null,{"$f":"_xlfn.XLOOKUP(A6,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":14710},{"$f":"_xlfn.XLOOKUP(A6,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":14563},1.0094074023209504E-2,14563,0.1025893397940642,{"$f":"_xlfn.XLOOKUP(A6,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":13208},4.990381710942586E-2,{"$f":"_xlfn.XLOOKUP(A6,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":12580.2}]
["SG&A Expenses",null,{"$f":"_xlfn.XLOOKUP(A7,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":2412},{"$f":"_xlfn.XLOOKUP(A7,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":2435},-9.4455852156057497E-3,2435,-2.2873194221508828E-2,{"$f":"_xlfn.XLOOKUP(A7,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":2492},-7.9593721144967683E-2,{"$f":"_xlfn.XLOOKUP(A7,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":2707.5}]
["Operating Income",null,{"$f":"_xlfn.XLOOKUP(A8,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":11712},{"$f":"_xlfn.XLOOKUP(A8,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":11647},5.5808362668498326E-3,11647,0.2427443448570209,{"$f":"_xlfn.XLOOKUP(A8,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":9372},-9.5017381228273468E-2,{"$f":"_xlfn.XLOOKUP(A8,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":10356}]
["Net Income Common",null,{"$f":"_xlfn.XLOOKUP(A9,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":8223},{"$f":"_xlfn.XLOOKUP(A9,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":8469},-2.9047113000354233E-2,8469,0.37105390966488588,{"$f":"_xlfn.XLOOKUP(A9,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":6177},-0.1813338281291417,{"$f":"_xlfn.XLOOKUP(A9,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":7545.2}]
["Cash and Short Term Investments",null,{"$f":"_xlfn.XLOOKUP(A10,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":1085},{"$f":"_xlfn.XLOOKUP(A10,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":4579},-0.76304870058964835,4579,0.7721959904017337,{"$f":"_xlfn.XLOOKUP(A10,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":2583.8000000000002},-0.45132931283445166,{"$f":"_xlfn.XLOOKUP(A10,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":4709.2}]
["Receivables",null,{"$f":"_xlfn.XLOOKUP(A11,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":2383},{"$f":"_xlfn.XLOOKUP(A11,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":2488},-4.2202572347266883E-2,2488,0.17635933806146573,{"$f":"_xlfn.XLOOKUP(A11,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":2115},0.12956633198034603,{"$f":"_xlfn.XLOOKUP(A11,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":1872.4}]
["Inventory",null,{"$f":"_xlfn.XLOOKUP(A12,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":56},{"$f":"_xlfn.XLOOKUP(A12,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":53},5.6603773584905662E-2,53,1.9230769230769232E-2,{"$f":"_xlfn.XLOOKUP(A12,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":52},-6.4748201438848949E-2,{"$f":"_xlfn.XLOOKUP(A12,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":55.6}]
["Total current assets",null,{"$f":"_xlfn.XLOOKUP(A13,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":4599},{"$f":"_xlfn.XLOOKUP(A13,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":7986},-0.42411720510894063,7986,0.47229084473286387,{"$f":"_xlfn.XLOOKUP(A13,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":5424.2},-0.24121144296006158,{"$f":"_xlfn.XLOOKUP(A13,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":7148.5}]
["Total Assets",null,{"$f":"_xlfn.XLOOKUP(A14,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":55182},{"$f":"_xlfn.XLOOKUP(A14,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":56147},-1.7187026911500168E-2,56147,0.11324144056975631,{"$f":"_xlfn.XLOOKUP(A14,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":50435.6},-6.3480539158433102E-2,{"$f":"_xlfn.XLOOKUP(A14,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":53854.3}]
["Total current liabilities",null,{"$f":"_xlfn.XLOOKUP(A15,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":3861},{"$f":"_xlfn.XLOOKUP(A15,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":6859},-0.43708995480390728,6859,0.80400305094553015,{"$f":"_xlfn.XLOOKUP(A15,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":3802.1},-5.4203980099502509E-2,{"$f":"_xlfn.XLOOKUP(A15,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":4020}]
["Long Term Debt (Total)",null,{"$f":"_xlfn.XLOOKUP(A16,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":38424},{"$f":"_xlfn.XLOOKUP(A16,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":37153},3.4209888838048069E-2,37153,3.4801621011879065E-2,{"$f":"_xlfn.XLOOKUP(A16,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":35903.5},7.8826141757924843E-3,{"$f":"_xlfn.XLOOKUP(A16,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":35622.699999999997}]
["Total liabilities",null,{"$f":"_xlfn.XLOOKUP(A17,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":58979},{"$f":"_xlfn.XLOOKUP(A17,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":60854},-3.0811450356591184E-2,60854,7.8226049363029113E-2,{"$f":"_xlfn.XLOOKUP(A17,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":56439},-3.44930228738883E-2,{"$f":"_xlfn.XLOOKUP(A17,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":58455.3}]
["Common Equity (Total)",null,{"$f":"_xlfn.XLOOKUP(A18,MCD!$A$2:$A$69,MCD!$B$2:$B$69,\"Find it\")","v":-3796},{"$f":"_xlfn.XLOOKUP(A18,MCD!$A$2:$A$69,MCD!$C$2:$C$69,\"Find it\")","v":-4706},-0.19337016574585636,-4706,-0.21611087050671282,{"$f":"_xlfn.XLOOKUP(A18,MCD!$A$2:$A$69,MCD!$D$2:$D$69,\"Find it\")","v":-6003.4},0.30480046772339103,{"$f":"_xlfn.XLOOKUP(A18,MCD!$A$2:$A$69,MCD!$E$2:$E$69,\"Find it\")","v":-4601.01}]
["Shares (Common)",null,{"$f":"MCD!B32","v":721.9},{"$f":"MCD!C32","v":732.3},-1.4201829851153869E-2,{"$f":"MCD!C32","v":732.3},-1.2140833670578714E-2,{"$f":"MCD!D32","v":741.3},-1.3966480446927375E-2,{"$f":"MCD!E32","v":751.8}]
["Financial Ratio's",null,"MCD","MCD","% Change YOY","MCD","% Change YOY","MCD","% Change YOY","MCD"]
["Liquidity ",null,2024,2023,null,2023,null,2022,null,2021]
["Current Ratio",null,{"$f":"C13/C15","v":1.1911421911421911},{"$f":"D13/D15","v":1.1643096661320893},{"$f":"IFERROR((C22-D22)/D22,\"Missing Info\")","v":2.304586639673031E-2},{"$f":"F13/F15","v":1.1643096661320893},{"$f":"IFERROR((F22-H22)/H22,\"Missing Info\")","v":-0.18387563482157424},{"$f":"H13/H15","v":1.4266326503774229},{"$f":"IFERROR((H22-J22)/J22,\"Missing Info\")","v":-0.19772494166367213},{"$f":"J13/J15","v":1.7782338308457712}]
["Quick Ratio",null,{"$f":"(C14-C12)/C17","v":0.93467166279523217},{"$f":"(D14-D12)/D17","v":0.9217799980280672},{"$f":"IFERROR((C23-D23)/D23,\"Missing Info\")","v":1.3985619990392145E-2},{"$f":"(F14-F12)/F17","v":0.9217799980280672},{"$f":"IFERROR((F23-H23)/H23,\"Missing Info\")","v":3.2564987589336382E-2},{"$f":"(H14-H12)/H17","v":0.89270894239798715},{"$f":"IFERROR((H23-J23)/J23,\"Missing Info\")","v":-3.0021746983532067E-2},{"$f":"(J14-J12)/J17","v":0.92033913092568176}]
["Net Working Capital",null,{"$f":"C13-C15","v":738},{"$f":"D13-D15","v":1127},{"$f":"IFERROR((C24-D24)/D24,\"Missing Info\")","v":-0.34516415261756878},{"$f":"F13-F15","v":1127},{"$f":"IFERROR((F24-H24)/H24,\"Missing Info\")","v":-0.30522162628691196},{"$f":"H13-H15","v":1622.1},{"$f":"IFERROR((H24-J24)/J24,\"Missing Info\")","v":-0.48150871024452618},{"$f":"J13-J15","v":3128.5}]
["Asset Management"]
["Accounts Rec. Turnover",null,{"$f":"C4/'YOY MCD'!C11","v":10.87704574066303},{"$f":"D4/'YOY MCD'!D11","v":10.246784565916398},{"$f":"IFERROR((C26-D26)/D26,\"Missing Info\")","v":6.1508190271029307E-2},{"$f":"F4/'YOY MCD'!F11","v":10.246784565916398},{"$f":"IFERROR((F26-H26)/H26,\"Missing Info\")","v":-6.5179253896683664E-2},{"$f":"H4/'YOY MCD'!H11","v":10.961229314420804},{"$f":"IFERROR((H26-J26)/J26,\"Missing Info\")","v":-0.11622554597739684},{"$f":"J4/'YOY MCD'!J11","v":12.402745139927367}]
["Inventory Turnover",null,{"$f":"C4/C12","v":462.85714285714283},{"$f":"D4/D12","v":481.01886792452831},{"$f":"IFERROR((C27-D27)/D27,\"Missing Info\")","v":-3.7756783108630669E-2},{"$f":"F4/F12","v":481.01886792452831},{"$f":"IFERROR((F27-H27)/H27,\"Missing Info\")","v":7.8936338354633609E-2},{"$f":"H4/H12","v":445.82692307692309},{"$f":"IFERROR((H27-J27)/J27,\"Missing Info\")","v":6.739368998173878E-2},{"$f":"J4/J12","v":417.67805755395688}]
["Total Asset Turnover",null,{"$f":"C4/C14","v":0.46971838643035774},{"$f":"D4/D14","v":0.45405809749407805},{"$f":"IFERROR((C28-D28)/D28,\"Missing Info\")","v":3.4489614925288133E-2},{"$f":"F4/F14","v":0.45405809749407805},{"$f":"IFERROR((F28-H28)/H28,\"Missing Info\")","v":-1.2177346246287277E-2},{"$f":"H4/H14","v":0.45965548144564555},{"$f":"IFERROR((H28-J28)/J28,\"Missing Info\")","v":6.5948877806743786E-2},{"$f":"J4/J14","v":0.43121719157058952}]
["Debt Management"]
["Total Debt to Equity",null,{"$f":"C16/C18","v":-10.122233930453108},{"$f":"D16/D18","v":-7.894815129621759},{"$f":"IFERROR((C30-D30)/D30,\"Missing Info\")","v":0.28213691698415549},{"$f":"F16/F18","v":-7.894815129621759},{"$f":"IFERROR((F30-H30)/H30,\"Missing Info\")","v":0.32008670879360696},{"$f":"H16/H18","v":-5.9805277009694509},{"$f":"IFERROR((H30-J30)/J30,\"Missing Info\")","v":-0.22755805266199761},{"$f":"J16/J18","v":-7.7423652632791482}]
["Equity multiplier",null,{"$f":"C14/C18","v":-14.536880927291886},{"$f":"D14/D18","v":-11.930939226519337},{"$f":"IFERROR((C31-D31)/D31,\"Missing Info\")","v":0.21841882280149635},{"$f":"F14/F18","v":-11.930939226519337},{"$f":"IFERROR((F31-H31)/H31,\"Missing Info\")","v":0.42015164987600406},{"$f":"H14/H18","v":-8.4011726688210011},{"$f":"IFERROR((H31-J31)/J31,\"Missing Info\")","v":-0.28225082377874905},{"$f":"J14/J18","v":-11.704886535782361}]
["Profitability"]
["Net Profit Margin",null,{"$f":"_xlfn.XLOOKUP(A33,MCD!$A$2:$A$69,MCD!B$2:B$69)","v":0.31719999999999998},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!C$2:C$69)","v":0.3322},{"$f":"IFERROR((C33-D33)/D33,\"Missing Info\")","v":-4.5153521974714068E-2},{"$f":"D33","v":0.3322},{"$f":"IFERROR((F33-H33)/H33,\"Missing Info\")","v":0.24699699699699687},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!D$2:D$69)","v":0.26640000000000003},{"$f":"IFERROR((H33-J33)/J33,\"Missing Info\")","v":-0.18005540166204984},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!E$2:E$69)","v":0.32490000000000002}]
["Gross Profit Margin",null,{"$f":"C6/C4","v":0.56751543209876543},{"$f":"D6/D4","v":0.57123244685023922},{"$f":"IFERROR((C34-D34)/D34,\"Missing Info\")","v":-6.5070091378200117E-3},{"$f":"D34","v":0.57123244685023922},2.640961184819541E-3,{"$f":"H6/H4","v":0.56972781779752402},5.171079473538745E-2,{"$f":"J6/J4","v":0.54171528964944082}]
["Return On Assets ROA",null,{"$f":"C33*C28","v":0.14899467217570947},{"$f":"D33*D28","v":0.15083809998753273},{"$f":"IFERROR((C35-D35)/D35,\"Missing Info\")","v":-1.2221234634854335E-2},{"$f":"D35","v":0.15083809998753273},0.2318118827964839,{"$f":"H33*H28","v":0.12245222025711999},-0.12598097553796078,{"$f":"J33*J28","v":0.14010246554128455}]
["Return On Equity ROE",null,{"$f":"C35*C31","v":-2.1659178082191781},{"$f":"D35*D31","v":-1.7996402039949002},{"$f":"IFERROR((C36-D36)/D36,\"Missing Info\")","v":0.20352824048451623},{"$f":"D36","v":-1.7996402039949002},0.74935967769029377,{"$f":"H35*H31","v":-1.0287422460605657},-0.37267356519067002,{"$f":"J35*J31","v":-1.6398834625440937}]
["Market Value"]
["EPS (Net Income / Shares Common)",null,{"$f":"C9/C19","v":11.390774345477213},{"$f":"D9/D19","v":11.564932404752151},{"$f":"IFERROR((C38-D38)/D38,\"Missing Info\")","v":-1.5059150644354294E-2},{"$f":"D38","v":11.564932404752151},{"$f":"IFERROR((F38-H38)/H38,\"Missing Info\")","v":0.38790422399915325},{"$f":"H9/H19","v":8.3326588425738564},{"$f":"IFERROR((H38-J38)/J38,\"Missing Info\")","v":-0.16973799000065939},{"$f":"J9/J19","v":10.036179835062518}]
["P/E",null,{"$f":"C3/C38","v":25.449542867566578},{"$f":"D3/D38","v":25.638714488133193},-7.3783582501444258E-3,25.638714488133193,-0.18931939061294914,{"$f":"H3/H38","v":31.626159786304029},0.18404083675073532,{"$f":"J3/J38","v":26.710362349573234}]
["Book Value Per Share",null,{"$f":"C18/C19","v":-5.2583460313062753},{"$f":"D18/D19","v":-6.4263280076471396},-0.18174951153302482,-6.4263280076471396,-0.20647683778045359,{"$f":"H18/H19","v":-8.0984756508835822},0.32328206075063437,{"$f":"J18/J19","v":-6.1199920191540311}]
["Market Capitalization (Stock Price * Shares Common)",null,{"$f":"C3*C19","v":209271.59099999999},{"$f":"D3*D19","v":217134.27299999999},-3.6211151244649437E-2,217134.27299999999,0.1114868189896283,{"$f":"H3*H19","v":195354.78899999996},-3.066582083850786E-2,{"$f":"J3*J19","v":201535.02599999998}]
["Cash Per Share",null,{"$f":"C10/C19","v":1.5029782518354342},{"$f":"D10/D19","v":6.252901816195549},-0.75963507887768333,6.252901816195549,0.79397635898512264,{"$f":"H10/H19","v":3.4854984486712537},-0.44355777335618607,{"$f":"J10/J19","v":6.2638999733971801}]
["Revenue Per Share",null,{"$f":"C4/C19","v":35.905250034630839},{"$f":"D4/D19","v":34.813600983203607},3.1356970281641264E-2,34.813600983203607,0.11320029370007467,{"$f":"H4/H19","v":31.273438553891815},1.2421838134594009E-2,{"$f":"J4/J19","v":30.889731311519025}]
["Price to Book Value",null,{"$f":"C41/C40","v":-39797.9877615648},{"$f":"D41/D40","v":-33788.233769209517},0.17786528983447017,-33788.233769209517,0.40069864612484984,{"$f":"H41/H40","v":-24122.414812556217},-0.26747727645333952,{"$f":"J41/J40","v":-32930.602747396762}]

{"sheet":"CAVA","index":5,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Statements","2024","2023","2022","2021"]
["Revenue",963.71,728.7,564.12,500.07]
["Revenue Growth",0.32250000000000001,0.29170000000000001,0.12809999999999999,100]
["Cost of Revenue",532.23,400.78,337.88,298.17]
["Gross Profit",431.48,327.92,226.24,201.91]
["SG&A Expenses",120.5,101.49,70.040000000000006,64.790000000000006]
["Operating Income",43.12,4.72,-59.77,-52.75]
["Interest Expense (Operating)",100,100,0.05,4.8099999999999996]
["Non-operating Income/Expense",16.79,9.32,0.87,15.48]
["Non-operating Interest Expenses",-16.47,-8.85,0.05,4.8099999999999996]
["EBT",59.91,14.05,-58.89,-37.270000000000003]
["Income Tax Provision",-70.41,0.77,0.09,0.12]
["Income after Tax",130.32,13.28,-58.99,-37.39]
["Net Income Common",130.32,13.28,-58.99,-37.39]
["EPS (Basic)",1.1399999999999999,0.22,-0.53,-0.34]
["EPS (Diluted)",1.1000000000000001,0.21,-0.53,-0.34]
["Shares (Basic, Weighted)",114.29,60.51,1.33,0.73]
["Shares (Diluted, Weighted)",118.27,63.45,1.33,0.73]
["Gross Margin",0.44769999999999999,0.45,0.40110000000000001,0.40379999999999999]
["EBIT Margin",4.4699999999999997E-2,6.4999999999999997E-3,-0.10589999999999999,-0.1055]
["EBT margin",6.2199999999999998E-2,1.9300000000000001E-2,-0.10440000000000001,-7.4499999999999997E-2]
["Net Profit Margin",0.13519999999999999,1.8200000000000001E-2,-0.1046,-7.4800000000000005E-2]
["Free Cash Flow Margin",5.4899999999999997E-2,-5.7200000000000001E-2,-0.1739,-0.10580000000000001]
["EBITDA",103.47,52.16,-17.04,-8.31]
["EBIT",43.12,4.72,-59.77,-52.75]
["Income from Continuous Operations",130.32,13.28,-58.99,-37.39]
["Consolidated Net Income/Loss",130.32,13.28,-58.99,-37.39]
["EPS (Basic, from Continuous Ops)",1.1399999999999999,0.22,-44.42,-51.08]
["EPS (Basic, Consolidated)",1.1399999999999999,0.22,-44.42,-51.08]
["EPS (Diluted, from Cont. Ops)",1.1000000000000001,0.21,-44.42,-51.08]
["Shares (Diluted, Average)",118.27,63.45,100,100]
["EPS (Diluted, Consolidated)",1.1000000000000001,0.21,-44.42,-51.08]
["EBITDA Margin",0.1074,7.1599999999999997E-2,-3.0200000000000001E-2,-1.66E-2]
["Operating Cash Flow Margin",0.1671,0.1333,1.0699999999999999E-2,6.7999999999999996E-3]
["Cash and Short Term Investments",385.78,369.27,366.12,367.16]
["Receivables",16.54,15.92,13,13.2]
["Inventory",7.99,7.28,7.6,7.33]
["Other current assets",100,100,100,100]
["Total current assets",418.54,403.02,394.15,393.26]
["Property, Plant, Equpment (Net)",418.03,390.58,372.9,363.22]
["Long-Term Investments",95.61,79.92,100,100]
["Goodwill and Intangible Assets (Total)",3.54,3.52,3.3,3.3]
["Long Term Assets (Tax, Deferred)",71.56,76.92,71.540000000000006,100]
["Long-term assets (Other)",12.22,6.31,5.95,5.69]
["Total non-current assets",873.1,825.34,775.52,686.28]
["Total Assets",1291.6300000000001,1228.3599999999999,1169.67,1079.54]
["Accounts Payable",33.619999999999997,25.98,25.57,25.34]
["Accrued Expenses",73.47,63.72,69.819999999999993,67.89]
["Current Part of Debt",100,100,100,100]
["Current Part of Capital Lease",100,100,100,100]
["Current Part of Taxes to Pay",100,100,100,100]
["Other current liabilities",100,100,100,100]
["Total current liabilities",153.71,134.28,132.63999999999999,134.44]
["Long Term Debt (Total)",100,100,100,100]
["Non-current Revenue (Deferred)",100,100,100,100]
["Long Term Tax Liability (Deferred)",100,100,100,0.08]
["Liabilities (Preferred Stock)",100,100,100,100]
["Minority Interests",100,100,100,100]
["Non-current Liabilities (Other)",100,100,100,100]
["Total non-current liabilities",387.22,367.91,341.47,328.66]
["Total liabilities",540.91999999999996,502.19,474.1,463.1]
["Additional Paid In Capital",1058.3599999999999,1052.25,1047.28,1039.95]
["Preferred Stock (Total)",100,100,100,100]
["Common Stock (Net)",0.01,0.01,0.01,0.01]
["Retained Earnings",-273.27,-291.64,-317.33999999999997,-395.96]
["Treasury Stock",34.380000000000003,34.380000000000003,34.380000000000003,27.56]
["Shareholders Equity (Other)",100,100,100,100]
["Common Equity (Total)",750.71,726.17,695.57,616.44000000000005]
["Shareholders Equity (Total)",750.71,726.17,695.57,616.44000000000005]
["Shareholders Equity and Liabilities (Total)",1291.6300000000001,1228.3599999999999,1169.67,1079.54]
["Shares (Common)",114.52,114.22,113.66,113.18]
["Shareholders Equity (Tangible)",747.17,722.65,692.27,613.14]
["Net Debt",-385.78,-369.27,-366.12,-367.16]
["Total Debt",100,100,100,100]

{"sheet":"YOY CAVA","index":6,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,4,1,4],[0,6,1,6],[0,8,1,8],[19,4,20,4],[19,6,20,6],[19,8,20,8]]}
[{"$f":"+H48+A1:J44+A1:A1:J45","v":0},null,"CAVA","CAVA","% Change YOY","CAVA","% Change YOY","CAVA","% Change YOY","CAVA"]
["Year ending:",null,2024,2023,null,2023,null,2022,null,2021]
["Stock Price ",null,170.25,101.5,{"$f":"IFERROR((C3-D3)/D3,\"Missing Info\")","v":0.67733990147783252},101.5,{"$f":"IFERROR((F3-H3)/H3,\"Missing Info\")","v":0},101.5,{"$f":"IFERROR((H3-J3)/J3,\"Missing Info\")","v":0},101.5]
["Revenue",null,{"$f":"_xlfn.XLOOKUP(A4,Table2[Statements],Table2[2024])","v":963.71},{"$f":"_xlfn.XLOOKUP(A4,Table2[Statements],Table2[2023])","v":728.7},{"$f":"IFERROR((C4-D4)/D4,\"Missing Info\")","v":0.32250583230410318},{"$f":"D4","v":728.7},{"$f":"IFERROR((F4-H4)/H4,\"Missing Info\")","v":0.2917464369283132},{"$f":"_xlfn.XLOOKUP(A4,Table2[Statements],Table2[2022])","v":564.12},{"$f":"IFERROR((H4-J4)/J4,\"Missing Info\")","v":0.12808206851040857},{"$f":"_xlfn.XLOOKUP(A4,Table2[Statements],Table2[2021])","v":500.07}]
["Cost of Revenue",null,{"$f":"_xlfn.XLOOKUP(A5,Table2[Statements],Table2[2024])","v":532.23},{"$f":"_xlfn.XLOOKUP(A5,Table2[Statements],Table2[2023])","v":400.78},{"$f":"IFERROR((C5-D5)/D5,\"Missing Info\")","v":0.32798542841459166},{"$f":"D5","v":400.78},{"$f":"IFERROR((F5-H5)/H5,\"Missing Info\")","v":0.18616076713626134},{"$f":"_xlfn.XLOOKUP(A5,Table2[Statements],Table2[2022])","v":337.88},{"$f":"IFERROR((H5-J5)/J5,\"Missing Info\")","v":0.1331790589261159},{"$f":"_xlfn.XLOOKUP(A5,Table2[Statements],Table2[2021])","v":298.17}]
["Gross Profit",null,{"$f":"_xlfn.XLOOKUP(A6,Table2[Statements],Table2[2024])","v":431.48},{"$f":"_xlfn.XLOOKUP(A6,Table2[Statements],Table2[2023])","v":327.92},0.31580873383752134,327.92,0.44943422913719944,{"$f":"_xlfn.XLOOKUP(A6,Table2[Statements],Table2[2022])","v":226.24},0.12049923233123676,{"$f":"_xlfn.XLOOKUP(A6,Table2[Statements],Table2[2021])","v":201.91}]
["SG&A Expenses",null,{"$f":"_xlfn.XLOOKUP(A7,Table2[Statements],Table2[2024])","v":120.5},{"$f":"_xlfn.XLOOKUP(A7,Table2[Statements],Table2[2023])","v":101.49},0.18730909449206826,101.49,0.44902912621359203,{"$f":"_xlfn.XLOOKUP(A7,Table2[Statements],Table2[2022])","v":70.040000000000006},8.103102330606575E-2,{"$f":"_xlfn.XLOOKUP(A7,Table2[Statements],Table2[2021])","v":64.790000000000006}]
["Operating Income",null,{"$f":"_xlfn.XLOOKUP(A8,Table2[Statements],Table2[2024])","v":43.12},{"$f":"_xlfn.XLOOKUP(A8,Table2[Statements],Table2[2023])","v":4.72},8.1355932203389827,4.72,-1.0789693826334283,{"$f":"_xlfn.XLOOKUP(A8,Table2[Statements],Table2[2022])","v":-59.77},0.13308056872037921,{"$f":"_xlfn.XLOOKUP(A8,Table2[Statements],Table2[2021])","v":-52.75}]
["Net Income Common",null,{"$f":"_xlfn.XLOOKUP(A9,Table2[Statements],Table2[2024])","v":130.32},{"$f":"_xlfn.XLOOKUP(A9,Table2[Statements],Table2[2023])","v":13.28},8.8132530120481931,13.28,-1.2251229021868113,{"$f":"_xlfn.XLOOKUP(A9,Table2[Statements],Table2[2022])","v":-58.99},0.57769457074083985,{"$f":"_xlfn.XLOOKUP(A9,Table2[Statements],Table2[2021])","v":-37.39}]
["Cash and Short Term Investments",null,{"$f":"_xlfn.XLOOKUP(A10,Table2[Statements],Table2[2024])","v":385.78},{"$f":"_xlfn.XLOOKUP(A10,Table2[Statements],Table2[2023])","v":369.27},4.4709832913586239E-2,369.27,8.6037364798426125E-3,{"$f":"_xlfn.XLOOKUP(A10,Table2[Statements],Table2[2022])","v":366.12},-2.8325525656390138E-3,{"$f":"_xlfn.XLOOKUP(A10,Table2[Statements],Table2[2021])","v":367.16}]
["Receivables",null,{"$f":"_xlfn.XLOOKUP(A11,Table2[Statements],Table2[2024])","v":16.54},{"$f":"_xlfn.XLOOKUP(A11,Table2[Statements],Table2[2023])","v":15.92},3.8944723618090406E-2,15.92,0.22461538461538461,{"$f":"_xlfn.XLOOKUP(A11,Table2[Statements],Table2[2022])","v":13},-1.5151515151515098E-2,{"$f":"_xlfn.XLOOKUP(A11,Table2[Statements],Table2[2021])","v":13.2}]
["Inventory",null,{"$f":"_xlfn.XLOOKUP(A12,Table2[Statements],Table2[2024])","v":7.99},{"$f":"_xlfn.XLOOKUP(A12,Table2[Statements],Table2[2023])","v":7.28},9.7527472527472514E-2,7.28,-4.210526315789466E-2,{"$f":"_xlfn.XLOOKUP(A12,Table2[Statements],Table2[2022])","v":7.6},3.683492496589353E-2,{"$f":"_xlfn.XLOOKUP(A12,Table2[Statements],Table2[2021])","v":7.33}]
["Total current assets",null,{"$f":"_xlfn.XLOOKUP(A13,Table2[Statements],Table2[2024])","v":418.54},{"$f":"_xlfn.XLOOKUP(A13,Table2[Statements],Table2[2023])","v":403.02},3.8509255123815291E-2,403.02,2.2504122795889904E-2,{"$f":"_xlfn.XLOOKUP(A13,Table2[Statements],Table2[2022])","v":394.15},2.2631338046076041E-3,{"$f":"_xlfn.XLOOKUP(A13,Table2[Statements],Table2[2021])","v":393.26}]
["Total Assets",null,{"$f":"_xlfn.XLOOKUP(A14,Table2[Statements],Table2[2024])","v":1291.6300000000001},{"$f":"_xlfn.XLOOKUP(A14,Table2[Statements],Table2[2023])","v":1228.3599999999999},5.1507701325344539E-2,1228.3599999999999,5.0176545521386222E-2,{"$f":"_xlfn.XLOOKUP(A14,Table2[Statements],Table2[2022])","v":1169.67},8.3489263945754774E-2,{"$f":"_xlfn.XLOOKUP(A14,Table2[Statements],Table2[2021])","v":1079.54}]
["Total current liabilities",null,{"$f":"_xlfn.XLOOKUP(A15,Table2[Statements],Table2[2024])","v":153.71},{"$f":"_xlfn.XLOOKUP(A15,Table2[Statements],Table2[2023])","v":134.28},0.14469764670837063,134.28,1.236429433051881E-2,{"$f":"_xlfn.XLOOKUP(A15,Table2[Statements],Table2[2022])","v":132.63999999999999},-1.3388872359416925E-2,{"$f":"_xlfn.XLOOKUP(A15,Table2[Statements],Table2[2021])","v":134.44}]
["Long Term Debt (Total)",null,{"$f":"_xlfn.XLOOKUP(A16,Table2[Statements],Table2[2024])","v":100},{"$f":"_xlfn.XLOOKUP(A16,Table2[Statements],Table2[2023])","v":100},0,100,0,{"$f":"_xlfn.XLOOKUP(A16,Table2[Statements],Table2[2022])","v":100},0,{"$f":"_xlfn.XLOOKUP(A16,Table2[Statements],Table2[2021])","v":100}]
["Total liabilities",null,{"$f":"_xlfn.XLOOKUP(A17,Table2[Statements],Table2[2024])","v":540.91999999999996},{"$f":"_xlfn.XLOOKUP(A17,Table2[Statements],Table2[2023])","v":502.19},7.7122204743224593E-2,502.19,5.9249103564648756E-2,{"$f":"_xlfn.XLOOKUP(A17,Table2[Statements],Table2[2022])","v":474.1},2.3752969121140142E-2,{"$f":"_xlfn.XLOOKUP(A17,Table2[Statements],Table2[2021])","v":463.1}]
["Common Equity (Total)",null,{"$f":"_xlfn.XLOOKUP(A18,Table2[Statements],Table2[2024])","v":750.71},{"$f":"_xlfn.XLOOKUP(A18,Table2[Statements],Table2[2023])","v":726.17},3.3793739757908038E-2,726.17,4.3992696637290149E-2,{"$f":"_xlfn.XLOOKUP(A18,Table2[Statements],Table2[2022])","v":695.57},0.12836610213483873,{"$f":"_xlfn.XLOOKUP(A18,Table2[Statements],Table2[2021])","v":616.44000000000005}]
["Shares (Common)",null,{"$f":"_xlfn.XLOOKUP(A19,Table2[Statements],Table2[2024])","v":114.52},{"$f":"_xlfn.XLOOKUP(A19,Table2[Statements],Table2[2023])","v":114.22},2.6265102433899244E-3,{"$f":"D19","v":114.22},4.9269751891606751E-3,{"$f":"_xlfn.XLOOKUP(A19,Table2[Statements],Table2[2022])","v":113.66},4.2410319844494587E-3,{"$f":"_xlfn.XLOOKUP(A19,Table2[Statements],Table2[2021])","v":113.18}]
["Financial Ratio's",null,"CAVA","CAVA","% Change YOY","CAVA","% Change YOY","CAVA","% Change YOY","CAVA"]
["Liquidity ",null,2024,2023,null,2023,null,2022,null,2021]
["Current Ratio",null,{"$f":"C13/C15","v":2.7229197840088477},{"$f":"D13/D15","v":3.0013404825737262},{"$f":"IFERROR((C22-D22)/D22,\"Missing Info\")","v":-9.2765449365520045E-2},{"$f":"F13/F15","v":3.0013404825737262},{"$f":"IFERROR((F22-H22)/H22,\"Missing Info\")","v":1.0015987843661046E-2},{"$f":"H13/H15","v":2.9715772014475275},{"$f":"IFERROR((H22-J22)/J22,\"Missing Info\")","v":1.5864412761546057E-2},{"$f":"J13/J15","v":2.9251710800357036}]
["Quick Ratio",null,{"$f":"(C14-C12)/C17","v":2.3730681061894554},{"$f":"(D14-D12)/D17","v":2.4315099862601803},{"$f":"IFERROR((C23-D23)/D23,\"Missing Info\")","v":-2.4035221077011622E-2},{"$f":"(F14-F12)/F17","v":2.4315099862601803},{"$f":"IFERROR((F23-H23)/H23,\"Missing Info\")","v":-7.9953148382185275E-3},{"$f":"(H14-H12)/H17","v":2.4511073613161782},{"$f":"IFERROR((H23-J23)/J23,\"Missing Info\")","v":5.866184705003881E-2},{"$f":"(J14-J12)/J17","v":2.3152882746706975}]
["Net Working Capital",null,{"$f":"C13-C15","v":264.83000000000004},{"$f":"D13-D15","v":268.74},{"$f":"IFERROR((C24-D24)/D24,\"Missing Info\")","v":-1.4549378581528495E-2},{"$f":"F13-F15","v":268.74},{"$f":"IFERROR((F24-H24)/H24,\"Missing Info\")","v":2.7647126304921488E-2},{"$f":"H13-H15","v":261.51},{"$f":"IFERROR((H24-J24)/J24,\"Missing Info\")","v":1.0393323545321064E-2},{"$f":"J13-J15","v":258.82}]
["Asset Management"]
["Accounts Rec. Turnover",null,{"$f":"C4/'YOY MCD'!C11","v":0.40441040704993708},{"$f":"D4/'YOY MCD'!D11","v":0.29288585209003215},{"$f":"IFERROR((C26-D26)/D26,\"Missing Info\")","v":0.38077822525078014},{"$f":"F4/'YOY MCD'!F11","v":0.29288585209003215},{"$f":"IFERROR((F26-H26)/H26,\"Missing Info\")","v":9.8088309527082876E-2},{"$f":"H4/'YOY MCD'!H11","v":0.26672340425531915},{"$f":"IFERROR((H26-J26)/J26,\"Missing Info\")","v":-1.3140117830311444E-3},{"$f":"J4/'YOY MCD'!J11","v":0.26707434308908351}]
["Inventory Turnover",null,{"$f":"C4/C12","v":120.61451814768461},{"$f":"D4/D12","v":100.09615384615385},{"$f":"IFERROR((C27-D27)/D27,\"Missing Info\")","v":0.20498654057244939},{"$f":"F4/F12","v":100.09615384615385},{"$f":"IFERROR((F27-H27)/H27,\"Missing Info\")","v":0.34852650008999725},{"$f":"H4/H12","v":74.226315789473688},{"$f":"IFERROR((H27-J27)/J27,\"Missing Info\")","v":8.8005468708065068E-2},{"$f":"J4/J12","v":68.222373806275584}]
["Total Asset Turnover",null,{"$f":"C4/C14","v":0.74611924467533264},{"$f":"D4/D14","v":0.59322999772053808},{"$f":"IFERROR((C28-D28)/D28,\"Missing Info\")","v":0.2577233915045854},{"$f":"F4/F14","v":0.59322999772053808},{"$f":"IFERROR((F28-H28)/H28,\"Missing Info\")","v":0.23002788667975219},{"$f":"H4/H14","v":0.48228987663187051},{"$f":"IFERROR((H28-J28)/J28,\"Missing Info\")","v":4.1156664905252195E-2},{"$f":"J4/J14","v":0.46322507734775925}]
["Debt Management"]
["Total Debt to Equity",null,{"$f":"C16/C18","v":0.13320723048847091},{"$f":"D16/D18","v":0.13770880096946997},{"$f":"IFERROR((C30-D30)/D30,\"Missing Info\")","v":-3.2689054361870848E-2},{"$f":"F16/F18","v":0.13770880096946997},{"$f":"IFERROR((F30-H30)/H30,\"Missing Info\")","v":-4.2138893096657644E-2},{"$f":"H16/H18","v":0.14376698247480482},{"$f":"IFERROR((H30-J30)/J30,\"Missing Info\")","v":-0.11376281323231302},{"$f":"J16/J18","v":0.16222178963078318}]
["Equity multiplier",null,{"$f":"C14/C18","v":1.7205445511582369},{"$f":"D14/D18","v":1.691559827588581},{"$f":"IFERROR((C31-D31)/D31,\"Missing Info\")","v":1.7134908914794526E-2},{"$f":"F14/F18","v":1.691559827588581},{"$f":"IFERROR((F31-H31)/H31,\"Missing Info\")","v":5.9232683370432073E-3},{"$f":"H14/H18","v":1.6815992639130497},{"$f":"IFERROR((H31-J31)/J31,\"Missing Info\")","v":-3.9771522827722491E-2},{"$f":"J14/J18","v":1.7512491077801569}]
["Profitability"]
["Net Profit Margin",null,{"$f":"_xlfn.XLOOKUP(A33,MCD!$A$2:$A$69,MCD!B$2:B$69)","v":0.31719999999999998},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!C$2:C$69)","v":0.3322},{"$f":"IFERROR((C33-D33)/D33,\"Missing Info\")","v":-4.5153521974714068E-2},{"$f":"D33","v":0.3322},{"$f":"IFERROR((F33-H33)/H33,\"Missing Info\")","v":0.24699699699699687},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!D$2:D$69)","v":0.26640000000000003},{"$f":"IFERROR((H33-J33)/J33,\"Missing Info\")","v":-0.18005540166204984},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!E$2:E$69)","v":0.32490000000000002}]
["Gross Profit Margin",null,{"$f":"C6/C4","v":0.44772805096969004},{"$f":"D6/D4","v":0.45000686153423902},{"$f":"IFERROR((C34-D34)/D34,\"Missing Info\")","v":-5.0639462624629305E-3},{"$f":"D34","v":0.45000686153423902},0.12207333242881412,{"$f":"H6/H4","v":0.4010494221087712},-6.7218834434490341E-3,{"$f":"J6/J4","v":0.40376347311376409}]
["Return On Assets ROA",null,{"$f":"C33*C28","v":0.23666902441101551},{"$f":"D33*D28","v":0.19707100524276275},{"$f":"IFERROR((C35-D35)/D35,\"Missing Info\")","v":0.20093275070817126},{"$f":"D35","v":0.19707100524276275},0.53384108091221338,{"$f":"H33*H28","v":0.12848202313473031},-0.14630921658738327,{"$f":"J33*J28","v":0.15050182763028699}]
["Return On Equity ROE",null,{"$f":"C35*C31","v":0.40719960037830849},{"$f":"D35*D31","v":0.33335739565115613},{"$f":"IFERROR((C36-D36)/D36,\"Missing Info\")","v":0.22151062400434932},{"$f":"D36","v":0.33335739565115613},0.542926433220837,{"$f":"H35*H31","v":0.21605527552942191},-0.18026179906769452,{"$f":"J35*J31","v":0.26356619135682308}]
["Market Value"]
["EPS (Net Income / Shares Common)",null,{"$f":"C9/C19","v":1.1379671673070206},{"$f":"D9/D19","v":0.11626685344072842},{"$f":"IFERROR((C38-D38)/D38,\"Missing Info\")","v":8.7875459224252932},{"$f":"D38","v":0.11626685344072842},{"$f":"IFERROR((F38-H38)/H38,\"Missing Info\")","v":-1.224019165317396},{"$f":"H9/H19","v":-0.51900404715819115},{"$f":"IFERROR((H38-J38)/J38,\"Missing Info\")","v":0.57103177473559996},{"$f":"J9/J19","v":-0.33035872062201799}]
["P/E",null,{"$f":"C3/C38","v":149.60888581952116},{"$f":"D3/D38","v":872.9917168674699},-0.82862507979301536,872.9917168674699,-5.4639037851211292,{"$f":"H3/H38","v":-195.5668757416511},-0.36347563678761557,{"$f":"J3/J38","v":-307.2417758759027}]
["Book Value Per Share",null,{"$f":"C18/C19","v":6.5552741879147751},{"$f":"D18/D19","v":6.3576431448082644},3.1085582912576466E-2,6.3576431448082644,3.8874189282038139E-2,{"$f":"H18/H19","v":6.1197430934365658},0.12360087488668893,{"$f":"J18/J19","v":5.4465453260293337}]
["Market Capitalization (Stock Price * Shares Common)",null,{"$f":"C3*C19","v":19497.03},{"$f":"D3*D19","v":11593.33},0.68174545191071068,11593.33,4.9269751891606673E-3,{"$f":"H3*H19","v":11536.49},4.2410319844494926E-3,{"$f":"J3*J19","v":11487.77}]
["Cash Per Share",null,{"$f":"C10/C19","v":3.3686692280824309},{"$f":"D10/D19","v":3.2329714585886884},4.1973079945772103E-2,3.2329714585886884,3.6587347951226932E-3,{"$f":"H10/H19","v":3.2211859933133908},-7.0437119424513082E-3,{"$f":"J10/J19","v":3.2440360487718678}]
["Revenue Per Share",null,{"$f":"C4/C19","v":8.4152113168005602},{"$f":"D4/D19","v":6.3797933811941867},0.31904135666935635,6.3797933811941867,0.28541323779786432,{"$f":"H4/H19","v":4.9632236494809083},0.12331804077079062,{"$f":"J4/J19","v":4.4183601342993457}]
["Price to Book Value",null,{"$f":"C41/C40","v":2974.2508766367837},{"$f":"D41/D40","v":1823.5263817012546},0.63104351353664723,1823.5263817012546,-3.2676925120584857E-2,{"$f":"H41/H40","v":1885.126519832655},-0.10622975254827612,{"$f":"J41/J40","v":2109.1846872363899}]

{"sheet":"CMG","index":7,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Statements","2024","2023","2022","2021"]
["Revenue",11313.85,9871.65,8634.65,7547.06]
["Revenue Growth",0.14610000000000001,0.14330000000000001,0.14410000000000001,0.2611]
["Cost of Revenue",8296.16,7285.56,6572.53,5840.05]
["Gross Profit",3017.69,2586.09,2062.12,1707.01]
["SG&A Expenses",697.48,633.58000000000004,564.19000000000005,606.85]
["Operating Income",1916.33,1557.81,1160.4000000000001,804.94]
["Non-operating Income/Expense",93.9,62.69,21.13,7.82]
["Non-operating Interest Expenses",100,100,100,100]
["EBT",2010.23,1620.51,1181.53,812.76]
["Income Tax Provision",476.12,391.77,282.43,159.78]
["Income after Tax",1534.11,1228.74,899.1,652.98]
["Net Income Common",1534.11,1228.74,899.1,652.98]
["EPS (Basic)",1.1200000000000001,0.89,0.65,0.46]
["EPS (Diluted)",1.1100000000000001,0.89,0.64,0.46]
["Shares (Basic, Weighted)",1368.34,1377.77,1392.54,1406.6]
["Shares (Diluted, Weighted)",1376.56,1385.5,1403.08,1425.55]
["Gross Margin",0.26669999999999999,0.26200000000000001,0.23880000000000001,0.22620000000000001]
["EBIT Margin",0.1694,0.1578,0.13439999999999999,0.1067]
["EBT margin",0.1777,0.16420000000000001,0.1368,0.1077]
["Net Profit Margin",0.1356,0.1245,0.1041,8.6499999999999994E-2]
["Free Cash Flow Margin",0.13539999999999999,0.1239,9.7699999999999995E-2,0.1118]
["EBITDA",2251.36,1877.21,1447.23,1059.5999999999999]
["EBIT",1916.33,1557.81,1160.4000000000001,804.94]
["Income from Continuous Operations",1534.11,1228.74,899.1,652.98]
["Consolidated Net Income/Loss",1534.11,1228.74,899.1,652.98]
["EPS (Basic, from Continuous Ops)",1.1200000000000001,0.89,0.65,0.46]
["EPS (Basic, Consolidated)",1.1200000000000001,0.89,0.65,0.46]
["EPS (Diluted, from Cont. Ops)",1.1100000000000001,0.89,0.64,0.46]
["Shares (Diluted, Average)",1376.56,1385.5,1403.1,1425.55]
["EPS (Diluted, Consolidated)",1.1100000000000001,0.89,0.64,0.46]
["EBITDA Margin",0.19900000000000001,0.19020000000000001,0.1676,0.1404]
["Operating Cash Flow Margin",0.18609999999999999,0.1807,0.1532,0.1699]
["Cash and Short Term Investments",1422.91,1295.45,899.14,1076.32]
["Receivables",211.19,168.5,154.62,193.66]
["Inventory",48.94,39.31,35.67,32.83]
["Other current assets",100,100,86,79]
["Total current assets",1780.59,1620.71,1175.8399999999999,1381.56]
["Property, Plant, Equpment (Net)",2390.13,2170.04,1951.15,1769.28]
["Long-Term Investments",868.02,564.49,388.06,274.31]
["Goodwill and Intangible Assets (Total)",21.94,21.94,21.94,21.94]
["Long-term assets (Other)",143.57,88.64,88.12,87.57]
["Total non-current assets",7423.79,6423.65,5751.67,5271.39]
["Total Assets",9204.3700000000008,8044.36,6927.5,6652.96]
["Accounts Payable",210.69,197.65,184.57,163.16]
["Accrued Expenses",179.75,147.69,147.54,173.05]
["Current Part of Debt",100,100,236,219]
["Current Part of Taxes to Pay",100,100,100,100]
["Current Revenue (Deferred)",238.58,209.68,183.07,156.35]
["Other current liabilities",100,100,465,460]
["Total current liabilities",1168.77,1030.6300000000001,921.88,873.68]
["Long Term Debt (Total)",100,100,3495,3302]
["Non-current Revenue (Deferred)",100,100,100,100]
["Long Term Tax Liability (Deferred)",46.21,89.11,98.62,141.76]
["Non-current Liabilities (Other)",71.069999999999993,58.87,43.82,38.54]
["Total non-current liabilities",4380.0600000000004,3951.53,3637.6,3481.9]
["Total liabilities",5548.83,4982.1499999999996,4559.4799999999996,4355.58]
["Additional Paid In Capital",2078.0100000000002,1937.79,1829.3,1729.31]
["Common Stock (Net)",13.59,18.739999999999998,0.37,0.37]
["Retained Earnings",1574.23,6056.98,4828.25,3929.15]
["Treasury Stock",100,4944.66,4282.01,3356.1]
["Common Equity (Total)",3655.55,3062.21,2368.02,2297.37]
["Shareholders Equity (Total)",3655.55,3062.21,2368.02,2297.37]
["Shareholders Equity and Liabilities (Total)",9204.3700000000008,8044.36,6927.5,6652.96]
["Shares (Common)",1358.75,1371.3,1381.35,1404]
["Shareholders Equity (Tangible)",3633.61,3040.27,2346.08,2275.4299999999998]
["Net Debt",-1422.91,-1295.45,2831.86,2444.6799999999998]
["Total Debt",100,100,3731,3521]

{"sheet":"YOY CMG","index":8,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,4,1,4],[0,6,1,6],[0,8,1,8],[19,4,20,4],[19,6,20,6],[19,8,20,8]]}
[{"$f":"+H48+A1:J44+A1:A1:J45","v":0},null,"CMG","CMG","% Change YOY","CMG","% Change YOY","CMG","% Change YOY","CMG"]
["Year ending:",null,2024,2023,null,2023,null,2022,null,2021]
["Stock Price ",null,68.55,46.8,{"$f":"IFERROR((C3-D3)/D3,\"Missing Info\")","v":0.46474358974358976},46.8,{"$f":"IFERROR((F3-H3)/H3,\"Missing Info\")","v":0.33371330863493853},35.090000000000003,{"$f":"IFERROR((H3-J3)/J3,\"Missing Info\")","v":-0.10416134797038545},39.17]
["Revenue",null,{"$f":"_xlfn.XLOOKUP(A4,Table3[Statements],Table3[2024])","v":11313.85},{"$f":"_xlfn.XLOOKUP(A4,Table3[Statements],Table3[2023])","v":9871.65},{"$f":"IFERROR((C4-D4)/D4,\"Missing Info\")","v":0.14609513100646809},{"$f":"D4","v":9871.65},{"$f":"IFERROR((F4-H4)/H4,\"Missing Info\")","v":0.1432600047483106},{"$f":"_xlfn.XLOOKUP(A4,Table3[Statements],Table3[2022])","v":8634.65},{"$f":"IFERROR((H4-J4)/J4,\"Missing Info\")","v":0.14410777176807912},{"$f":"_xlfn.XLOOKUP(A4,Table3[Statements],Table3[2021])","v":7547.06}]
["Cost of Revenue",null,{"$f":"_xlfn.XLOOKUP(A5,Table3[Statements],Table3[2024])","v":8296.16},{"$f":"_xlfn.XLOOKUP(A5,Table3[Statements],Table3[2023])","v":7285.56},{"$f":"IFERROR((C5-D5)/D5,\"Missing Info\")","v":0.13871274136785633},{"$f":"D5","v":7285.56},{"$f":"IFERROR((F5-H5)/H5,\"Missing Info\")","v":0.10848638195641568},{"$f":"_xlfn.XLOOKUP(A5,Table3[Statements],Table3[2022])","v":6572.53},{"$f":"IFERROR((H5-J5)/J5,\"Missing Info\")","v":0.12542358370219425},{"$f":"_xlfn.XLOOKUP(A5,Table3[Statements],Table3[2021])","v":5840.05}]
["Gross Profit",null,{"$f":"_xlfn.XLOOKUP(A6,Table3[Statements],Table3[2024])","v":3017.69},{"$f":"_xlfn.XLOOKUP(A6,Table3[Statements],Table3[2023])","v":2586.09},0.16689287689136878,2586.09,0.25409287529338753,{"$f":"_xlfn.XLOOKUP(A6,Table3[Statements],Table3[2022])","v":2062.12},0.20803041575620523,{"$f":"_xlfn.XLOOKUP(A6,Table3[Statements],Table3[2021])","v":1707.01}]
["SG&A Expenses",null,{"$f":"_xlfn.XLOOKUP(A7,Table3[Statements],Table3[2024])","v":697.48},{"$f":"_xlfn.XLOOKUP(A7,Table3[Statements],Table3[2023])","v":633.58000000000004},0.1008554562959689,633.58000000000004,0.1229904819298463,{"$f":"_xlfn.XLOOKUP(A7,Table3[Statements],Table3[2022])","v":564.19000000000005},-7.0297437587542172E-2,{"$f":"_xlfn.XLOOKUP(A7,Table3[Statements],Table3[2021])","v":606.85}]
["Operating Income",null,{"$f":"_xlfn.XLOOKUP(A8,Table3[Statements],Table3[2024])","v":1916.33},{"$f":"_xlfn.XLOOKUP(A8,Table3[Statements],Table3[2023])","v":1557.81},0.23014359902683895,1557.81,0.34247673216132352,{"$f":"_xlfn.XLOOKUP(A8,Table3[Statements],Table3[2022])","v":1160.4000000000001},0.4415981315377544,{"$f":"_xlfn.XLOOKUP(A8,Table3[Statements],Table3[2021])","v":804.94}]
["Net Income Common",null,{"$f":"_xlfn.XLOOKUP(A9,Table3[Statements],Table3[2024])","v":1534.11},{"$f":"_xlfn.XLOOKUP(A9,Table3[Statements],Table3[2023])","v":1228.74},0.24852287709360799,1228.74,0.3666332999666333,{"$f":"_xlfn.XLOOKUP(A9,Table3[Statements],Table3[2022])","v":899.1},0.37691812919231832,{"$f":"_xlfn.XLOOKUP(A9,Table3[Statements],Table3[2021])","v":652.98}]
["Cash and Short Term Investments",null,{"$f":"_xlfn.XLOOKUP(A10,Table3[Statements],Table3[2024])","v":1422.91},{"$f":"_xlfn.XLOOKUP(A10,Table3[Statements],Table3[2023])","v":1295.45},9.8390520668493603E-2,1295.45,0.4407656204817938,{"$f":"_xlfn.XLOOKUP(A10,Table3[Statements],Table3[2022])","v":899.14},-0.16461647093801096,{"$f":"_xlfn.XLOOKUP(A10,Table3[Statements],Table3[2021])","v":1076.32}]
["Receivables",null,{"$f":"_xlfn.XLOOKUP(A11,Table3[Statements],Table3[2024])","v":211.19},{"$f":"_xlfn.XLOOKUP(A11,Table3[Statements],Table3[2023])","v":168.5},0.25335311572700298,168.5,8.9768464622946548E-2,{"$f":"_xlfn.XLOOKUP(A11,Table3[Statements],Table3[2022])","v":154.62},-0.20159041619332849,{"$f":"_xlfn.XLOOKUP(A11,Table3[Statements],Table3[2021])","v":193.66}]
["Inventory",null,{"$f":"_xlfn.XLOOKUP(A12,Table3[Statements],Table3[2024])","v":48.94},{"$f":"_xlfn.XLOOKUP(A12,Table3[Statements],Table3[2023])","v":39.31},0.24497583312134305,39.31,0.10204653770675638,{"$f":"_xlfn.XLOOKUP(A12,Table3[Statements],Table3[2022])","v":35.67},8.6506244288760387E-2,{"$f":"_xlfn.XLOOKUP(A12,Table3[Statements],Table3[2021])","v":32.83}]
["Total current assets",null,{"$f":"_xlfn.XLOOKUP(A13,Table3[Statements],Table3[2024])","v":1780.59},{"$f":"_xlfn.XLOOKUP(A13,Table3[Statements],Table3[2023])","v":1620.71},9.8648123353345066E-2,1620.71,0.37834229146822712,{"$f":"_xlfn.XLOOKUP(A13,Table3[Statements],Table3[2022])","v":1175.8399999999999},-0.14890413735197894,{"$f":"_xlfn.XLOOKUP(A13,Table3[Statements],Table3[2021])","v":1381.56}]
["Total Assets",null,{"$f":"_xlfn.XLOOKUP(A14,Table3[Statements],Table3[2024])","v":9204.3700000000008},{"$f":"_xlfn.XLOOKUP(A14,Table3[Statements],Table3[2023])","v":8044.36},0.14420165184054431,8044.36,0.161221219776254,{"$f":"_xlfn.XLOOKUP(A14,Table3[Statements],Table3[2022])","v":6927.5},4.1265842572328702E-2,{"$f":"_xlfn.XLOOKUP(A14,Table3[Statements],Table3[2021])","v":6652.96}]
["Total current liabilities",null,{"$f":"_xlfn.XLOOKUP(A15,Table3[Statements],Table3[2024])","v":1168.77},{"$f":"_xlfn.XLOOKUP(A15,Table3[Statements],Table3[2023])","v":1030.6300000000001},0.13403452257357137,1030.6300000000001,0.11796546188224076,{"$f":"_xlfn.XLOOKUP(A15,Table3[Statements],Table3[2022])","v":921.88},5.5168940573207634E-2,{"$f":"_xlfn.XLOOKUP(A15,Table3[Statements],Table3[2021])","v":873.68}]
["Long Term Debt (Total)",null,{"$f":"_xlfn.XLOOKUP(A16,Table3[Statements],Table3[2024])","v":100},{"$f":"_xlfn.XLOOKUP(A16,Table3[Statements],Table3[2023])","v":100},0,100,-0.97138769670958514,{"$f":"_xlfn.XLOOKUP(A16,Table3[Statements],Table3[2022])","v":3495},5.8449424591156873E-2,{"$f":"_xlfn.XLOOKUP(A16,Table3[Statements],Table3[2021])","v":3302}]
["Total liabilities",null,{"$f":"_xlfn.XLOOKUP(A17,Table3[Statements],Table3[2024])","v":5548.83},{"$f":"_xlfn.XLOOKUP(A17,Table3[Statements],Table3[2023])","v":4982.1499999999996},0.11374205915116974,4982.1499999999996,9.2701360681481243E-2,{"$f":"_xlfn.XLOOKUP(A17,Table3[Statements],Table3[2022])","v":4559.4799999999996},4.6813512781305737E-2,{"$f":"_xlfn.XLOOKUP(A17,Table3[Statements],Table3[2021])","v":4355.58}]
["Common Equity (Total)",null,{"$f":"_xlfn.XLOOKUP(A18,Table3[Statements],Table3[2024])","v":3655.55},{"$f":"_xlfn.XLOOKUP(A18,Table3[Statements],Table3[2023])","v":3062.21},0.19376202154653016,3062.21,0.29315208486414812,{"$f":"_xlfn.XLOOKUP(A18,Table3[Statements],Table3[2022])","v":2368.02},3.0752556183810224E-2,{"$f":"_xlfn.XLOOKUP(A18,Table3[Statements],Table3[2021])","v":2297.37}]
["Shares (Common)",null,{"$f":"_xlfn.XLOOKUP(A19,Table3[Statements],Table3[2024])","v":1358.75},{"$f":"_xlfn.XLOOKUP(A19,Table3[Statements],Table3[2023])","v":1371.3},-9.1518996572595018E-3,{"$f":"_xlfn.XLOOKUP(A19,Table3[Statements],Table3[2023])","v":1371.3},-7.2754913671408085E-3,{"$f":"_xlfn.XLOOKUP(A19,Table3[Statements],Table3[2022])","v":1381.35},-1.6132478632478697E-2,{"$f":"_xlfn.XLOOKUP(A19,Table3[Statements],Table3[2021])","v":1404}]
["Financial Ratio's",null,"CMG","CMG","% Change YOY","CMG","% Change YOY","CMG","% Change YOY","CMG"]
["Liquidity ",null,2024,2023,null,2023,null,2022,null,2021]
["Current Ratio",null,{"$f":"C13/C15","v":1.5234733951076773},{"$f":"D13/D15","v":1.5725430076749172},{"$f":"IFERROR((C22-D22)/D22,\"Missing Info\")","v":-3.1203987635156451E-2},{"$f":"F13/F15","v":1.5725430076749172},{"$f":"IFERROR((F22-H22)/H22,\"Missing Info\")","v":0.23290239140984556},{"$f":"H13/H15","v":1.2754805397665638},{"$f":"IFERROR((H22-J22)/J22,\"Missing Info\")","v":-0.19340322679923311},{"$f":"J13/J15","v":1.5813112352348686}]
["Quick Ratio",null,{"$f":"(C14-C12)/C17","v":1.6499748595649895},{"$f":"(D14-D12)/D17","v":1.6067460835181597},{"$f":"IFERROR((C23-D23)/D23,\"Missing Info\")","v":2.6904547327213792E-2},{"$f":"(F14-F12)/F17","v":1.6067460835181597},{"$f":"IFERROR((F23-H23)/H23,\"Missing Info\")","v":6.2987135910110736E-2},{"$f":"(H14-H12)/H17","v":1.5115385965066193},{"$f":"IFERROR((H23-J23)/J23,\"Missing Info\")","v":-5.5138977373101984E-3},{"$f":"(J14-J12)/J17","v":1.5199192759632472}]
["Net Working Capital",null,{"$f":"C13-C15","v":611.81999999999994},{"$f":"D13-D15","v":590.07999999999993},{"$f":"IFERROR((C24-D24)/D24,\"Missing Info\")","v":3.6842462039045572E-2},{"$f":"F13-F15","v":590.07999999999993},{"$f":"IFERROR((F24-H24)/H24,\"Missing Info\")","v":1.3235155142542137},{"$f":"H13-H15","v":253.95999999999992},{"$f":"IFERROR((H24-J24)/J24,\"Missing Info\")","v":-0.499960620619044},{"$f":"J13-J15","v":507.88}]
["Asset Management"]
["Accounts Rec. Turnover",null,{"$f":"C4/'YOY MCD'!C11","v":4.7477339488040284},{"$f":"D4/'YOY MCD'!D11","v":3.9677049839228293},{"$f":"IFERROR((C26-D26)/D26,\"Missing Info\")","v":0.19659449682924571},{"$f":"F4/'YOY MCD'!F11","v":3.9677049839228293},{"$f":"IFERROR((F26-H26)/H26,\"Missing Info\")","v":-2.813709403429393E-2},{"$f":"H4/'YOY MCD'!H11","v":4.0825768321513003},{"$f":"IFERROR((H26-J26)/J26,\"Missing Info\")","v":1.2873471327920317E-2},{"$f":"J4/'YOY MCD'!J11","v":4.0306878872035892}]
["Inventory Turnover",null,{"$f":"C4/C12","v":231.17797302819781},{"$f":"D4/D12","v":251.12312388705161},{"$f":"IFERROR((C27-D27)/D27,\"Missing Info\")","v":-7.9423792401629181E-2},{"$f":"F4/F12","v":251.12312388705161},{"$f":"IFERROR((F27-H27)/H27,\"Missing Info\")","v":3.7397211126233475E-2},{"$f":"H4/H12","v":242.07036725539666},{"$f":"IFERROR((H27-J27)/J27,\"Missing Info\")","v":5.3015367175386408E-2},{"$f":"J4/J12","v":229.88303381053916}]
["Total Asset Turnover",null,{"$f":"C4/C14","v":1.2291824426875495},{"$f":"D4/D14","v":1.2271516938575597},{"$f":"IFERROR((C28-D28)/D28,\"Missing Info\")","v":1.65484743259906E-3},{"$f":"F4/F14","v":1.2271516938575597},{"$f":"IFERROR((F28-H28)/H28,\"Missing Info\")","v":-1.5467522227508343E-2},{"$f":"H4/H14","v":1.2464308913749549},{"$f":"IFERROR((H28-J28)/J28,\"Missing Info\")","v":9.8766256407384956E-2},{"$f":"J4/J14","v":1.1343913085303385}]
["Debt Management"]
["Total Debt to Equity",null,{"$f":"C16/C18","v":2.7355664674262422E-2},{"$f":"D16/D18","v":3.2656153562296508E-2},{"$f":"IFERROR((C30-D30)/D30,\"Missing Info\")","v":-0.1623121007782686},{"$f":"F16/F18","v":3.2656153562296508E-2},{"$f":"IFERROR((F30-H30)/H30,\"Missing Info\")","v":-0.97787398433230632},{"$f":"H16/H18","v":1.4759165885423264},{"$f":"IFERROR((H30-J30)/J30,\"Missing Info\")","v":2.6870530896270159E-2},{"$f":"J16/J18","v":1.437295690289331}]
["Equity multiplier",null,{"$f":"C14/C18","v":2.5179165925784082},{"$f":"D14/D18","v":2.6269785547039555},{"$f":"IFERROR((C31-D31)/D31,\"Missing Info\")","v":-4.1516121983659636E-2},{"$f":"F14/F18","v":2.6269785547039555},{"$f":"IFERROR((F31-H31)/H31,\"Missing Info\")","v":-0.10202269836015002},{"$f":"H14/H18","v":2.9254398189204482},{"$f":"IFERROR((H31-J31)/J31,\"Missing Info\")","v":1.0199621941702656E-2},{"$f":"J14/J18","v":2.8959027061378881}]
["Profitability"]
["Net Profit Margin",null,{"$f":"_xlfn.XLOOKUP(A33,MCD!$A$2:$A$69,MCD!B$2:B$69)","v":0.31719999999999998},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!C$2:C$69)","v":0.3322},{"$f":"IFERROR((C33-D33)/D33,\"Missing Info\")","v":-4.5153521974714068E-2},{"$f":"D33","v":0.3322},{"$f":"IFERROR((F33-H33)/H33,\"Missing Info\")","v":0.24699699699699687},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!D$2:D$69)","v":0.26640000000000003},{"$f":"IFERROR((H33-J33)/J33,\"Missing Info\")","v":-0.18005540166204984},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!E$2:E$69)","v":0.32490000000000002}]
["Gross Profit Margin",null,{"$f":"C6/C4","v":0.26672529687064966},{"$f":"D6/D4","v":0.26197140295695254},{"$f":"IFERROR((C34-D34)/D34,\"Missing Info\")","v":1.8146613943500898E-2},{"$f":"D34","v":0.26197140295695254},9.6944588356764005E-2,{"$f":"H6/H4","v":0.23881917622601959},5.5871173647690162E-2,{"$f":"J6/J4","v":0.22618211594978704}]
["Return On Assets ROA",null,{"$f":"C33*C28","v":0.38989667082049068},{"$f":"D33*D28","v":0.40765979269948133},{"$f":"IFERROR((C35-D35)/D35,\"Missing Info\")","v":-4.3573396732027654E-2},{"$f":"D35","v":0.40765979269948133},0.22770904322830965,{"$f":"H33*H28","v":0.33204918946228801},-9.9072543222753578E-2,{"$f":"J33*J28","v":0.368563736141507}]
["Return On Equity ROE",null,{"$f":"C35*C31","v":0.98172729684999516},{"$f":"D35*D31","v":1.0709135330365975},{"$f":"IFERROR((C36-D36)/D36,\"Missing Info\")","v":-8.3280520261718005E-2},{"$f":"D36","v":1.0709135330365975},0.10245485383699936,{"$f":"H35*H31","v":0.97138992069323749},-8.9883423766725937E-2,{"$f":"J35*J31","v":1.0673247208764807}]
["Market Value"]
["EPS (Net Income / Shares Common)",null,{"$f":"C9/C19","v":1.1290597976080956},{"$f":"D9/D19","v":0.89604025377379137},{"$f":"IFERROR((C38-D38)/D38,\"Missing Info\")","v":0.26005477192895271},{"$f":"D38","v":0.89604025377379137},{"$f":"IFERROR((F38-H38)/H38,\"Missing Info\")","v":0.37664909859907314},{"$f":"H9/H19","v":0.65088500380062986},{"$f":"IFERROR((H38-J38)/J38,\"Missing Info\")","v":0.399495459793691},{"$f":"J9/J19","v":0.46508547008547008}]
["P/E",null,{"$f":"C3/C38","v":60.714233333985177},{"$f":"D3/D38","v":52.2297963767762},0.16244438128771937,52.2297963767762,-3.1188623163177585E-2,{"$f":"H3/H38","v":53.911212879546213},-0.35988455999587443,{"$f":"J3/J38","v":84.221078746669122}]
["Book Value Per Share",null,{"$f":"C18/C19","v":2.6903771849126037},{"$f":"D18/D19","v":2.2330708087216511},0.20478812154315129,2.2330708087216511,0.30262935347997599,{"$f":"H18/H19","v":1.7142795091758063},4.7653808869634509E-2,{"$f":"J18/J19","v":1.6363034188034187}]
["Market Capitalization (Stock Price * Shares Common)",null,{"$f":"C3*C19","v":93142.3125},{"$f":"D3*D19","v":64176.84},0.45133840338664238,64176.84,0.32400988897172434,{"$f":"H3*H19","v":48471.571499999998},-0.11861344588240175,{"$f":"J3*J19","v":54994.68}]
["Cash Per Share",null,{"$f":"C10/C19","v":1.0472198712051519},{"$f":"D10/D19","v":0.9446875227885948},0.10853572842149428,0.9446875227885948,0.4513247209600566,{"$f":"H10/H19","v":0.6509139609802006},-0.15091868476270837,{"$f":"J10/J19","v":0.76660968660968654}]
["Revenue Per Share",null,{"$f":"C4/C19","v":8.3266605335786572},{"$f":"D4/D19","v":7.198753008094509},0.15668095907942567,7.198753008094509,0.15163874247726894,{"$f":"H4/H19","v":6.250877764505737},0.16286771025618649,{"$f":"J4/J19","v":5.3753988603988603}]
["Price to Book Value",null,{"$f":"C41/C40","v":34620.540577854219},{"$f":"D41/D40","v":28739.27676155456},0.20464202579263274,28739.27676155456,1.6413368418752562E-2,{"$f":"H41/H40","v":28275.18572120379},-0.15870438626231906,{"$f":"J41/J40","v":33609.096801995329}]

{"sheet":"SHAK","index":9,"n_rows":70,"n_cols":5,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Statements","2024","2023","2022","2021"]
["Revenue",1252.6099999999999,1087.53,900.49,739.89]
["Revenue Growth",0.15179999999999999,0.2077,0.217,0.41510000000000002]
["Cost of Revenue",950.14,838.59,717.1,594.64]
["Gross Profit",302.47000000000003,248.94,183.39,145.26]
["SG&A Expenses",149.05000000000001,129.54,120.01,87.2]
["Operating Income",3.04,5.92,-26.89,-15.85]
["Interest Expense (Operating)",100,100,1.52,1.58]
["Non-operating Income/Expense",11.21,11.06,2.61,-1.48]
["Non-operating Interest Expenses",2.04,1.72,1.52,1.58]
["EBT",14.24,16.98,-24.29,-17.34]
["Income Tax Provision",3.42,-4.01,-1.18,-11.32]
["Income after Tax",10.82,20.99,-23.11,-6.02]
["Dividends (Preferred)",100,0,100,0]
["Non-Controlling Interest",0.61,0.73,-1.88,-1.46]
["Net Income Common",10.210000000000001,20.260000000000002,-21.23,-4.5599999999999996]
["EPS (Basic)",0.26,0.5,-0.61,-0.22]
["EPS (Diluted)",0.24,0.47,-0.61,-0.22]
["Shares (Basic, Weighted)",39.83,39.42,39.24,39.090000000000003]
["Shares (Diluted, Weighted)",44.2,43.9,39.24,39.090000000000003]
["Gross Margin",0.24149999999999999,0.22889999999999999,0.20369999999999999,0.1963]
["EBIT Margin",2.3999999999999998E-3,5.4000000000000003E-3,-2.9899999999999999E-2,-2.1399999999999999E-2]
["EBT margin",1.14E-2,1.5599999999999999E-2,-2.7E-2,-2.3400000000000001E-2]
["Net Profit Margin",8.0999999999999996E-3,1.8599999999999998E-2,-2.3599999999999999E-2,-6.1999999999999998E-3]
["Free Cash Flow Margin",2.8500000000000001E-2,-1.29E-2,-7.3099999999999998E-2,-5.8200000000000002E-2]
["EBITDA",108.25,98.39,48.45,45.25]
["EBIT",3.04,5.92,-26.89,-15.85]
["Income from Continuous Operations",10.82,20.99,-23.11,-6.02]
["Consolidated Net Income/Loss",10.82,20.99,-23.11,-6.02]
["EPS (Basic, from Continuous Ops)",0.27,0.53,-0.59,-0.15]
["EPS (Basic, Consolidated)",0.27,0.53,-0.59,-0.15]
["EPS (Diluted, from Cont. Ops)",0.24,0.48,-0.59,-0.15]
["Shares (Diluted, Average)",44.2,43.9,39.24,39.090000000000003]
["EPS (Diluted, Consolidated)",0.24,0.48,-0.59,-0.15]
["EBITDA Margin",8.6400000000000005E-2,9.0499999999999997E-2,5.3800000000000001E-2,6.1199999999999997E-2]
["Operating Cash Flow Margin",0.1366,0.1215,8.5199999999999998E-2,7.8899999999999998E-2]
["Operating Cash Flow Margin",8.5199999999999998E-2,7.8899999999999998E-2,7.1400000000000005E-2,0.15110000000000001]
["Cash and Short Term Investments",320.70999999999998,293.20999999999998,311.23,382.41]
["Receivables",19.690000000000001,16.850000000000001,13.88,13.66]
["Inventory",6.01,5.4,4.18,3.85]
["Other current assets",100,100,15,10]
["Total current assets",368.22,334.43,343.99,409.68]
["Property, Plant, Equpment (Net)",551.6,531,467.03,389.39]
["Long-Term Investments",100,100,100,100]
["Goodwill and Intangible Assets (Total)",100,100,2,1]
["Long Term Assets (Tax, Deferred)",341.59,326.20999999999998,317.63,298.67]
["Long-term assets (Other)",10.96,15.93,15.82,12.56]
["Total non-current assets",1328.76,1271.42,1167.96,1047.8900000000001]
["Total Assets",1696.97,1605.86,1511.95,1457.57]
["Accounts Payable",23.61,22.27,20.41,19.95]
["Accrued Expenses",63.01,54.74,47.95,36.89]
["Current Part of Debt",100,100,45,38]
["Other current liabilities",19.54,17.100000000000001,19.55,14.5]
["Total current liabilities",187.31,164.07,147.72,121.5]
["Long Term Debt (Total)",246.68,245.64,244.59,243.54]
["Non-current Revenue (Deferred)",100,100,14,13]
["Long Term Tax Liability (Deferred)",100,100,-301,-299]
["Non-current Liabilities (Other)",274.85000000000002,262.25,255.58,256.82]
["Total non-current liabilities",1016.03,972.42,927.4,900.47]
["Total liabilities",1203.3499999999999,1136.49,1075.1099999999999,1021.97]
["Additional Paid In Capital",442.99,426.6,415.65,405.94]
["Common Stock (Net)",0.04,0.04,0.04,0.04]
["Retained Earnings",26.98,16.78,-3.49,3.55]
["Common Equity (Total)",493.63,469.37,436.84,435.6]
["Shareholders Equity (Total)",493.63,469.37,436.84,435.6]
["Shareholders Equity and Liabilities (Total)",1696.97,1605.86,1511.95,1457.57]
["Shares (Common)",42.52,42.31,42.16,42.06]
["Shareholders Equity (Tangible)",493.63,469.37,436.84,435.6]
["Net Debt",-74.03,-47.58,-21.64,-100.86]
["Total Debt",246.68,245.64,289.58999999999997,281.54000000000002]

{"sheet":"YOY SHAK","index":10,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,4,1,4],[0,6,1,6],[0,8,1,8],[19,4,20,4],[19,6,20,6],[19,8,20,8]]}
[{"$f":"+H48+A1:J44+A1:A1:J45","v":0},null,"MCD","MCD","% Change YOY","MCD","% Change YOY","MCD","% Change YOY","MCD"]
["Year ending:",null,2024,2023,null,2023,null,2022,null,2021]
["Stock Price ",null,144.65,102,{"$f":"IFERROR((C3-D3)/D3,\"Missing Info\")","v":0.41813725490196085},102,{"$f":"IFERROR((F3-H3)/H3,\"Missing Info\")","v":0.02},100,{"$f":"IFERROR((H3-J3)/J3,\"Missing Info\")","v":-0.16826083340264497},120.23]
["Revenue",null,{"$f":"_xlfn.XLOOKUP(A4,Table4[Statements],Table4[2024])","v":1252.6099999999999},{"$f":"_xlfn.XLOOKUP(A4,Table4[Statements],Table4[2023])","v":1087.53},{"$f":"IFERROR((C4-D4)/D4,\"Missing Info\")","v":0.15179351374214958},{"$f":"D4","v":1087.53},{"$f":"IFERROR((F4-H4)/H4,\"Missing Info\")","v":0.20770913613699205},{"$f":"_xlfn.XLOOKUP(A4,Table4[Statements],Table4[2022])","v":900.49},{"$f":"IFERROR((H4-J4)/J4,\"Missing Info\")","v":0.21705929259754833},{"$f":"_xlfn.XLOOKUP(A4,Table4[Statements],Table4[2021])","v":739.89}]
["Cost of Revenue",null,{"$f":"_xlfn.XLOOKUP(A5,Table4[Statements],Table4[2024])","v":950.14},{"$f":"_xlfn.XLOOKUP(A5,Table4[Statements],Table4[2023])","v":838.59},{"$f":"IFERROR((C5-D5)/D5,\"Missing Info\")","v":0.13302090413670561},{"$f":"D5","v":838.59},{"$f":"IFERROR((F5-H5)/H5,\"Missing Info\")","v":0.16941849114488913},{"$f":"_xlfn.XLOOKUP(A5,Table4[Statements],Table4[2022])","v":717.1},{"$f":"IFERROR((H5-J5)/J5,\"Missing Info\")","v":0.20593972823893456},{"$f":"_xlfn.XLOOKUP(A5,Table4[Statements],Table4[2021])","v":594.64}]
["Gross Profit",null,{"$f":"_xlfn.XLOOKUP(A6,Table4[Statements],Table4[2024])","v":302.47000000000003},{"$f":"_xlfn.XLOOKUP(A6,Table4[Statements],Table4[2023])","v":248.94},0.21503173455451124,248.94,0.35743497464420099,{"$f":"_xlfn.XLOOKUP(A6,Table4[Statements],Table4[2022])","v":183.39},0.26249483684427921,{"$f":"_xlfn.XLOOKUP(A6,Table4[Statements],Table4[2021])","v":145.26}]
["SG&A Expenses",null,{"$f":"_xlfn.XLOOKUP(A7,Table4[Statements],Table4[2024])","v":149.05000000000001},{"$f":"_xlfn.XLOOKUP(A7,Table4[Statements],Table4[2023])","v":129.54},0.15060985023930848,129.54,7.9410049162569676E-2,{"$f":"_xlfn.XLOOKUP(A7,Table4[Statements],Table4[2022])","v":120.01},0.37626146788990827,{"$f":"_xlfn.XLOOKUP(A7,Table4[Statements],Table4[2021])","v":87.2}]
["Operating Income",null,{"$f":"_xlfn.XLOOKUP(A8,Table4[Statements],Table4[2024])","v":3.04},{"$f":"_xlfn.XLOOKUP(A8,Table4[Statements],Table4[2023])","v":5.92},-0.48648648648648646,5.92,-1.2201561918928971,{"$f":"_xlfn.XLOOKUP(A8,Table4[Statements],Table4[2022])","v":-26.89},0.69652996845425874,{"$f":"_xlfn.XLOOKUP(A8,Table4[Statements],Table4[2021])","v":-15.85}]
["Net Income Common",null,{"$f":"_xlfn.XLOOKUP(A9,Table4[Statements],Table4[2024])","v":10.210000000000001},{"$f":"_xlfn.XLOOKUP(A9,Table4[Statements],Table4[2023])","v":20.260000000000002},-0.49605133267522211,20.260000000000002,-1.9543099387658973,{"$f":"_xlfn.XLOOKUP(A9,Table4[Statements],Table4[2022])","v":-21.23},3.6557017543859658,{"$f":"_xlfn.XLOOKUP(A9,Table4[Statements],Table4[2021])","v":-4.5599999999999996}]
["Cash and Short Term Investments",null,{"$f":"_xlfn.XLOOKUP(A10,Table4[Statements],Table4[2024])","v":320.70999999999998},{"$f":"_xlfn.XLOOKUP(A10,Table4[Statements],Table4[2023])","v":293.20999999999998},9.3789434193922452E-2,293.20999999999998,-5.7899302766442944E-2,{"$f":"_xlfn.XLOOKUP(A10,Table4[Statements],Table4[2022])","v":311.23},-0.18613529980910543,{"$f":"_xlfn.XLOOKUP(A10,Table4[Statements],Table4[2021])","v":382.41}]
["Receivables",null,{"$f":"_xlfn.XLOOKUP(A11,Table4[Statements],Table4[2024])","v":19.690000000000001},{"$f":"_xlfn.XLOOKUP(A11,Table4[Statements],Table4[2023])","v":16.850000000000001},0.16854599406528187,16.850000000000001,0.21397694524495681,{"$f":"_xlfn.XLOOKUP(A11,Table4[Statements],Table4[2022])","v":13.88},1.6105417276720397E-2,{"$f":"_xlfn.XLOOKUP(A11,Table4[Statements],Table4[2021])","v":13.66}]
["Inventory",null,{"$f":"_xlfn.XLOOKUP(A12,Table4[Statements],Table4[2024])","v":6.01},{"$f":"_xlfn.XLOOKUP(A12,Table4[Statements],Table4[2023])","v":5.4},0.11296296296296285,5.4,0.29186602870813416,{"$f":"_xlfn.XLOOKUP(A12,Table4[Statements],Table4[2022])","v":4.18},8.5714285714285618E-2,{"$f":"_xlfn.XLOOKUP(A12,Table4[Statements],Table4[2021])","v":3.85}]
["Total current assets",null,{"$f":"_xlfn.XLOOKUP(A13,Table4[Statements],Table4[2024])","v":368.22},{"$f":"_xlfn.XLOOKUP(A13,Table4[Statements],Table4[2023])","v":334.43},0.10103758634093837,334.43,-2.7791505567022302E-2,{"$f":"_xlfn.XLOOKUP(A13,Table4[Statements],Table4[2022])","v":343.99},-0.16034465924624097,{"$f":"_xlfn.XLOOKUP(A13,Table4[Statements],Table4[2021])","v":409.68}]
["Total Assets",null,{"$f":"_xlfn.XLOOKUP(A14,Table4[Statements],Table4[2024])","v":1696.97},{"$f":"_xlfn.XLOOKUP(A14,Table4[Statements],Table4[2023])","v":1605.86},5.673595456640064E-2,1605.86,6.2111842322828036E-2,{"$f":"_xlfn.XLOOKUP(A14,Table4[Statements],Table4[2022])","v":1511.95},3.7308671281653785E-2,{"$f":"_xlfn.XLOOKUP(A14,Table4[Statements],Table4[2021])","v":1457.57}]
["Total current liabilities",null,{"$f":"_xlfn.XLOOKUP(A15,Table4[Statements],Table4[2024])","v":187.31},{"$f":"_xlfn.XLOOKUP(A15,Table4[Statements],Table4[2023])","v":164.07},0.14164685804839405,164.07,0.11068237205523961,{"$f":"_xlfn.XLOOKUP(A15,Table4[Statements],Table4[2022])","v":147.72},0.21580246913580245,{"$f":"_xlfn.XLOOKUP(A15,Table4[Statements],Table4[2021])","v":121.5}]
["Long Term Debt (Total)",null,{"$f":"_xlfn.XLOOKUP(A16,Table4[Statements],Table4[2024])","v":246.68},{"$f":"_xlfn.XLOOKUP(A16,Table4[Statements],Table4[2023])","v":245.64},4.2338381371113034E-3,245.64,4.2928983196368732E-3,{"$f":"_xlfn.XLOOKUP(A16,Table4[Statements],Table4[2022])","v":244.59},4.3114067504311871E-3,{"$f":"_xlfn.XLOOKUP(A16,Table4[Statements],Table4[2021])","v":243.54}]
["Total liabilities",null,{"$f":"_xlfn.XLOOKUP(A17,Table4[Statements],Table4[2024])","v":1203.3499999999999},{"$f":"_xlfn.XLOOKUP(A17,Table4[Statements],Table4[2023])","v":1136.49},5.8830258075301935E-2,1136.49,5.7091832463654991E-2,{"$f":"_xlfn.XLOOKUP(A17,Table4[Statements],Table4[2022])","v":1075.1099999999999},5.1997612454377201E-2,{"$f":"_xlfn.XLOOKUP(A17,Table4[Statements],Table4[2021])","v":1021.97}]
["Common Equity (Total)",null,{"$f":"_xlfn.XLOOKUP(A18,Table4[Statements],Table4[2024])","v":493.63},{"$f":"_xlfn.XLOOKUP(A18,Table4[Statements],Table4[2023])","v":469.37},5.1686302916675524E-2,469.37,7.4466623935537116E-2,{"$f":"_xlfn.XLOOKUP(A18,Table4[Statements],Table4[2022])","v":436.84},2.8466483011936458E-3,{"$f":"_xlfn.XLOOKUP(A18,Table4[Statements],Table4[2021])","v":435.6}]
["Shares (Common)",null,{"$f":"_xlfn.XLOOKUP(A19,Table4[Statements],Table4[2024])","v":42.52},{"$f":"_xlfn.XLOOKUP(A19,Table4[Statements],Table4[2023])","v":42.31},4.9633656346017687E-3,{"$f":"D19","v":42.31},3.5578747628084843E-3,{"$f":"_xlfn.XLOOKUP(A19,Table4[Statements],Table4[2022])","v":42.16},2.37755587256287E-3,{"$f":"_xlfn.XLOOKUP(A19,Table4[Statements],Table4[2021])","v":42.06}]
["Financial Ratio's",null,"MCD","MCD","% Change YOY","MCD","% Change YOY","MCD","% Change YOY","MCD"]
["Liquidity ",null,2024,2023,null,2023,null,2022,null,2021]
["Current Ratio",null,{"$f":"C13/C15","v":1.9658320431370457},{"$f":"D13/D15","v":2.038337295056988},{"$f":"IFERROR((C22-D22)/D22,\"Missing Info\")","v":-3.5570782174161798E-2},{"$f":"F13/F15","v":2.038337295056988},{"$f":"IFERROR((F22-H22)/H22,\"Missing Info\")","v":-0.12467459744231436},{"$f":"H13/H15","v":2.3286623341456809},{"$f":"IFERROR((H22-J22)/J22,\"Missing Info\")","v":-0.30938177699985303},{"$f":"J13/J15","v":3.3718518518518521}]
["Quick Ratio",null,{"$f":"(C14-C12)/C17","v":1.4052104541488346},{"$f":"(D14-D12)/D17","v":1.4082482027998484},{"$f":"IFERROR((C23-D23)/D23,\"Missing Info\")","v":-2.1571116831352738E-3},{"$f":"(F14-F12)/F17","v":1.4082482027998484},{"$f":"IFERROR((F23-H23)/H23,\"Missing Info\")","v":4.1463388395743357E-3},{"$f":"(H14-H12)/H17","v":1.4024332393894579},{"$f":"IFERROR((H23-J23)/J23,\"Missing Info\")","v":-1.4084763462809751E-2},{"$f":"(J14-J12)/J17","v":1.4224683699130112}]
["Net Working Capital",null,{"$f":"C13-C15","v":180.91000000000003},{"$f":"D13-D15","v":170.36},{"$f":"IFERROR((C24-D24)/D24,\"Missing Info\")","v":6.1927682554590344E-2},{"$f":"F13-F15","v":170.36},{"$f":"IFERROR((F24-H24)/H24,\"Missing Info\")","v":-0.13201202425230546},{"$f":"H13-H15","v":196.27},{"$f":"IFERROR((H24-J24)/J24,\"Missing Info\")","v":-0.31893261156221803},{"$f":"J13-J15","v":288.18}]
["Asset Management"]
["Accounts Rec. Turnover",null,{"$f":"C4/'YOY MCD'!C11","v":0.52564414603441034},{"$f":"D4/'YOY MCD'!D11","v":0.43711012861736331},{"$f":"IFERROR((C26-D26)/D26,\"Missing Info\")","v":0.20254396231240795},{"$f":"F4/'YOY MCD'!F11","v":0.43711012861736331},{"$f":"IFERROR((F26-H26)/H26,\"Missing Info\")","v":2.6649848444428512E-2},{"$f":"H4/'YOY MCD'!H11","v":0.42576359338061465},{"$f":"IFERROR((H26-J26)/J26,\"Missing Info\")","v":7.7457125040023417E-2},{"$f":"J4/'YOY MCD'!J11","v":0.39515594958342232}]
["Inventory Turnover",null,{"$f":"C4/C12","v":208.42096505823628},{"$f":"D4/D12","v":201.39444444444442},{"$f":"IFERROR((C27-D27)/D27,\"Missing Info\")","v":3.4889346789951585E-2},{"$f":"F4/F12","v":201.39444444444442},{"$f":"IFERROR((F27-H27)/H27,\"Missing Info\")","v":-6.5143668693958226E-2},{"$f":"H4/H12","v":215.4282296650718},{"$f":"IFERROR((H27-J27)/J27,\"Missing Info\")","v":0.12097566423458414},{"$f":"J4/J12","v":192.17922077922077}]
["Total Asset Turnover",null,{"$f":"C4/C14","v":0.73814504675981296},{"$f":"D4/D14","v":0.67722591010424327},{"$f":"IFERROR((C28-D28)/D28,\"Missing Info\")","v":8.9953936709528143E-2},{"$f":"F4/F14","v":0.67722591010424327},{"$f":"IFERROR((F28-H28)/H28,\"Missing Info\")","v":0.13708282688548531},{"$f":"H4/H14","v":0.59558186447964545},{"$f":"IFERROR((H28-J28)/J28,\"Missing Info\")","v":0.1732855670567203},{"$f":"J4/J14","v":0.50761884506404498}]
["Debt Management"]
["Total Debt to Equity",null,{"$f":"C16/C18","v":0.49972651581143773},{"$f":"D16/D18","v":0.52333979589662738},{"$f":"IFERROR((C30-D30)/D30,\"Missing Info\")","v":-4.512036017580795E-2},{"$f":"F16/F18","v":0.52333979589662738},{"$f":"IFERROR((F30-H30)/H30,\"Missing Info\")","v":-6.5310288893729473E-2},{"$f":"H16/H18","v":0.55990751762659097},{"$f":"IFERROR((H30-J30)/J30,\"Missing Info\")","v":1.4606006329269474E-3},{"$f":"J16/J18","v":0.55909090909090908}]
["Equity multiplier",null,{"$f":"C14/C18","v":3.4377367664039871},{"$f":"D14/D18","v":3.421309414747427},{"$f":"IFERROR((C31-D31)/D31,\"Missing Info\")","v":4.8014808557655074E-3},{"$f":"F14/F18","v":3.421309414747427},{"$f":"IFERROR((F31-H31)/H31,\"Missing Info\")","v":-1.1498525256611799E-2},{"$f":"H14/H18","v":3.4611070414797185},{"$f":"IFERROR((H31-J31)/J31,\"Missing Info\")","v":3.4364200188372093E-2},{"$f":"J14/J18","v":3.3461202938475663}]
["Profitability"]
["Net Profit Margin",null,{"$f":"_xlfn.XLOOKUP(A33,MCD!$A$2:$A$69,MCD!B$2:B$69)","v":0.31719999999999998},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!C$2:C$69)","v":0.3322},{"$f":"IFERROR((C33-D33)/D33,\"Missing Info\")","v":-4.5153521974714068E-2},{"$f":"D33","v":0.3322},{"$f":"IFERROR((F33-H33)/H33,\"Missing Info\")","v":0.24699699699699687},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!D$2:D$69)","v":0.26640000000000003},{"$f":"IFERROR((H33-J33)/J33,\"Missing Info\")","v":-0.18005540166204984},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!E$2:E$69)","v":0.32490000000000002}]
["Gross Profit Margin",null,{"$f":"C6/C4","v":0.24147180686726119},{"$f":"D6/D4","v":0.22890403023364872},{"$f":"IFERROR((C34-D34)/D34,\"Missing Info\")","v":5.490413000061288E-2},{"$f":"D34","v":0.22890403023364872},0.12397508143900073,{"$f":"H6/H4","v":0.20365578740463525},3.7332235596967994E-2,{"$f":"J6/J4","v":0.19632648096338645}]
["Return On Assets ROA",null,{"$f":"C33*C28","v":0.23413960883221266},{"$f":"D33*D28","v":0.22497444733662961},{"$f":"IFERROR((C35-D35)/D35,\"Missing Info\")","v":4.0738677676888373E-2},{"$f":"D35","v":0.22497444733662961},0.41793887046305617,{"$f":"H33*H28","v":0.15866300869737757},-3.7970836983963412E-2,{"$f":"J33*J28","v":0.16492536276130823}]
["Return On Equity ROE",null,{"$f":"C35*C31","v":0.80491034175394516},{"$f":"D35*D31","v":0.76970719475041005},{"$f":"IFERROR((C36-D36)/D36,\"Missing Info\")","v":4.5735764513608702E-2},{"$f":"D36","v":0.76970719475041005},0.40163466454870522,{"$f":"H35*H31","v":0.54914965662485127},-4.9114742390283682E-3,{"$f":"J35*J31","v":0.55186010330578517}]
["Market Value"]
["EPS (Net Income / Shares Common)",null,{"$f":"C9/C19","v":0.24012229539040453},{"$f":"D9/D19","v":0.47884660836681636},{"$f":"IFERROR((C38-D38)/D38,\"Missing Info\")","v":-0.49854026071233881},{"$f":"D38","v":0.47884660836681636},{"$f":"IFERROR((F38-H38)/H38,\"Missing Info\")","v":-1.9509266607981617},{"$f":"H9/H19","v":-0.50355787476280844},{"$f":"IFERROR((H38-J38)/J38,\"Missing Info\")","v":3.644658818535905},{"$f":"J9/J19","v":-0.10841654778887302}]
["P/E",null,{"$f":"C3/C38","v":602.40137120470126},{"$f":"D3/D38","v":213.01184600197433},1.8280181713420662,213.01184600197433,-2.0726379247205684,{"$f":"H3/H38","v":-198.58690532265658},-0.82092566987309157,{"$f":"J3/J38","v":-1108.9635526315792}]
["Book Value Per Share",null,{"$f":"C18/C19","v":11.609360301034807},{"$f":"D18/D19","v":11.093594894823918},4.6492179595591356E-2,11.093594894823918,7.0657359137845377E-2,{"$f":"H18/H19","v":10.361480075901328},4.6797978055516704E-4,{"$f":"J18/J19","v":10.356633380884452}]
["Market Capitalization (Stock Price * Shares Common)",null,{"$f":"C3*C19","v":6150.5180000000009},{"$f":"D3*D19","v":4315.62},0.42517598861808992,4315.62,2.3629032258064491E-2,{"$f":"H3*H19","v":4216},-0.16628332706266077,{"$f":"J3*J19","v":5056.8738000000003}]
["Cash Per Share",null,{"$f":"C10/C19","v":7.5425682031984937},{"$f":"D10/D19","v":6.9300401796265652},8.8387369725890327E-2,6.9300401796265652,-6.1239295784288272E-2,{"$f":"H10/H19","v":7.3821157495256173},-0.18806571892720522,{"$f":"J10/J19","v":9.0920114122681888}]
["Revenue Per Share",null,{"$f":"C4/C19","v":29.459313264346186},{"$f":"D4/D19","v":25.703852517135427},0.14610497569215306,25.703852517135427,0.20342749183492276,{"$f":"H4/H19","v":21.358870967741936},0.21417252956956562,{"$f":"J4/J19","v":17.591298145506418}]
["Price to Book Value",null,{"$f":"C41/C40","v":529.78956983975866},{"$f":"D41/D40","v":389.01907279971027},0.36186014229828073,389.01907279971027,-4.3924722020918835E-2,{"$f":"H41/H40","v":406.8916765863932},-0.1666733071055323,{"$f":"J41/J40","v":488.27390272727274}]

{"sheet":"YUM","index":11,"n_rows":70,"n_cols":5,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Statements","2024","2023","2022","2021"]
["Revenue",7549,7076,6842,6584]
["Revenue Growth",6.6799999999999998E-2,3.4200000000000001E-2,3.9199999999999999E-2,0.16489999999999999]
["Cost of Revenue",2120,1774,1745,1725]
["Gross Profit",5429,5302,5097,4859]
["R&D Expenses",100,100,100,100]
["SG&A Expenses",2892,2876,2807,2636]
["Operating Income",2403,2318,2187,2139]
["Interest Expense (Operating)",100,100,537,522]
["Non-operating Income/Expense",-503,-500,-525,-465]
["Non-operating Interest Expenses",489,513,527,544]
["EBT",1900,1818,1662,1674]
["Income Tax Provision",414,221,337,99]
["Income after Tax",1486,1597,1325,1575]
["Net Income Common",1486,1597,1325,1575]
["EPS (Basic)",5.28,5.68,4.63,5.3]
["EPS (Diluted)",5.22,5.59,4.57,5.21]
["Shares (Basic, Weighted)",282,281,286,297]
["Shares (Diluted, Weighted)",285,285,290,302]
["Gross Margin",0.71919999999999995,0.74929999999999997,0.745,0.73799999999999999]
["EBIT Margin",0.31830000000000003,0.3276,0.3196,0.32490000000000002]
["EBT margin",0.25169999999999998,0.25690000000000002,0.2429,0.25430000000000003]
["Net Profit Margin",0.1968,0.22570000000000001,0.19370000000000001,0.2392]
["Free Cash Flow Margin",0.18970000000000001,0.18629999999999999,0.1678,0.22420000000000001]
["EBITDA",2578,2471,2333,2303]
["EBIT",2403,2318,2187,2139]
["Income from Continuous Operations",1486,1597,1325,1575]
["Income from Discontinued Operations",100,100,100,100]
["Consolidated Net Income/Loss",1486,1597,1325,1575]
["EPS (Basic, from Continuous Ops)",5.27,5.68,4.63,5.3]
["EPS (Basic, from Discontinued Ops)",100,100,100,100]
["EPS (Basic, Consolidated)",5.27,5.68,4.63,5.3]
["EPS (Diluted, from Cont. Ops)",5.21,5.6,4.57,5.22]
["EPS (Diluted, from Disc. Ops)",100,100,100,100]
["Shares (Diluted, Average)",285,285,290,302]
["EPS (Diluted, Consolidated)",5.21,5.6,4.57,5.22]
["EBITDA Margin",0.34150000000000003,0.34920000000000001,0.34100000000000003,0.3498]
["Operating Cash Flow Margin",0.22370000000000001,0.22650000000000001,0.20860000000000001,0.2591]
["Cash and Short Term Investments",616,512,367,486]
["Receivables",775,737,648,596]
["Inventory",100,100,100,100]
["Other current assets",100,100,342,150]
["Total current assets",1871,1609,1609,1532]
["Property, Plant, Equpment (Net)",1304,1197,1171,1207]
["Long-Term Investments",100,100,274,277]
["Goodwill and Intangible Assets (Total)",1152,1019,992,1016]
["Long Term Assets (Tax, Deferred)",1071,1045,750,724]
["Long-term assets (Other)",1329,1361,1324,1487]
["Total non-current assets",4856,4622,4237,4434]
["Total Assets",6727,6231,5846,5966]
["Accounts Payable",1211,1169,1251,1334]
["Current Part of Debt",27,53,398,68]
["Current Part of Taxes to Pay",31,55,16,13]
["Other current liabilities",100,100,929,1019]
["Total current liabilities",1269,1277,1665,1415]
["Long Term Debt (Total)",11306,11142,11453,11178]
["Long Term Tax Liability (Deferred)",100,100,-750,-724]
["Minority Interests",100,100,100,100]
["Non-current Liabilities (Other)",1800,1670,1604,1746]
["Total non-current liabilities",13106,12812,13057,12924]
["Total liabilities",14375,14089,14722,14339]
["Common Stock (Net)",0,60,0,100]
["Retained Earnings",-7256,-7616,-8507,-8048]
["Common Equity (Total)",-7648,-7858,-8876,-8373]
["Shareholders Equity (Total)",-7648,-7858,-8876,-8373]
["Shareholders Equity and Liabilities (Total)",6727,6231,5846,5966]
["Shares (Common)",279,281,280,289]
["Shareholders Equity (Tangible)",-8800,-8877,-9868,-9389]
["Net Debt",10717,10683,11484,10760]
["Total Debt",11333,11195,11851,11246]

{"sheet":"YOY Yum","index":12,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,4,1,4],[0,6,1,6],[0,8,1,8],[19,4,20,4],[19,6,20,6],[19,8,20,8]]}
[{"$f":"+H48+A1:J44+A1:A1:J45","v":0},null,"MCD","MCD","% Change YOY","MCD","% Change YOY","MCD","% Change YOY","MCD"]
["Year ending:",null,2024,2023,null,2023,null,2022,null,2021]
["Stock Price ",null,137.77000000000001,134.9,{"$f":"IFERROR((C3-D3)/D3,\"Missing Info\")","v":2.1275018532246143E-2},134.9,{"$f":"IFERROR((F3-H3)/H3,\"Missing Info\")","v":4.8499922275765654E-2},128.66,{"$f":"IFERROR((H3-J3)/J3,\"Missing Info\")","v":-7.4388489208633113E-2},139]
["Revenue",null,{"$f":"_xlfn.XLOOKUP(A4,Table5[Statements],Table5[2024])","v":7549},{"$f":"_xlfn.XLOOKUP(A4,Table5[Statements],Table5[2023])","v":7076},{"$f":"IFERROR((C4-D4)/D4,\"Missing Info\")","v":6.6845675522894291E-2},{"$f":"D4","v":7076},{"$f":"IFERROR((F4-H4)/H4,\"Missing Info\")","v":3.4200526161940956E-2},{"$f":"_xlfn.XLOOKUP(A4,Table5[Statements],Table5[2022])","v":6842},{"$f":"IFERROR((H4-J4)/J4,\"Missing Info\")","v":3.9185905224787362E-2},{"$f":"_xlfn.XLOOKUP(A4,Table5[Statements],Table5[2021])","v":6584}]
["Cost of Revenue",null,{"$f":"_xlfn.XLOOKUP(A5,Table5[Statements],Table5[2024])","v":2120},{"$f":"_xlfn.XLOOKUP(A5,Table5[Statements],Table5[2023])","v":1774},{"$f":"IFERROR((C5-D5)/D5,\"Missing Info\")","v":0.19503945885005636},{"$f":"D5","v":1774},{"$f":"IFERROR((F5-H5)/H5,\"Missing Info\")","v":1.66189111747851E-2},{"$f":"_xlfn.XLOOKUP(A5,Table5[Statements],Table5[2022])","v":1745},{"$f":"IFERROR((H5-J5)/J5,\"Missing Info\")","v":1.1594202898550725E-2},{"$f":"_xlfn.XLOOKUP(A5,Table5[Statements],Table5[2021])","v":1725}]
["Gross Profit",null,{"$f":"_xlfn.XLOOKUP(A6,Table5[Statements],Table5[2024])","v":5429},{"$f":"_xlfn.XLOOKUP(A6,Table5[Statements],Table5[2023])","v":5302},2.3953225198038476E-2,5302,4.0219737100255053E-2,{"$f":"_xlfn.XLOOKUP(A6,Table5[Statements],Table5[2022])","v":5097},4.8981271866639225E-2,{"$f":"_xlfn.XLOOKUP(A6,Table5[Statements],Table5[2021])","v":4859}]
["SG&A Expenses",null,{"$f":"_xlfn.XLOOKUP(A7,Table5[Statements],Table5[2024])","v":2892},{"$f":"_xlfn.XLOOKUP(A7,Table5[Statements],Table5[2023])","v":2876},5.5632823365785811E-3,2876,2.458140363377271E-2,{"$f":"_xlfn.XLOOKUP(A7,Table5[Statements],Table5[2022])","v":2807},6.4871016691957509E-2,{"$f":"_xlfn.XLOOKUP(A7,Table5[Statements],Table5[2021])","v":2636}]
["Operating Income",null,{"$f":"_xlfn.XLOOKUP(A8,Table5[Statements],Table5[2024])","v":2403},{"$f":"_xlfn.XLOOKUP(A8,Table5[Statements],Table5[2023])","v":2318},3.6669542709232096E-2,2318,5.9899405578417927E-2,{"$f":"_xlfn.XLOOKUP(A8,Table5[Statements],Table5[2022])","v":2187},2.244039270687237E-2,{"$f":"_xlfn.XLOOKUP(A8,Table5[Statements],Table5[2021])","v":2139}]
["Net Income Common",null,{"$f":"_xlfn.XLOOKUP(A9,Table5[Statements],Table5[2024])","v":1486},{"$f":"_xlfn.XLOOKUP(A9,Table5[Statements],Table5[2023])","v":1597},-6.9505322479649342E-2,1597,0.20528301886792452,{"$f":"_xlfn.XLOOKUP(A9,Table5[Statements],Table5[2022])","v":1325},-0.15873015873015872,{"$f":"_xlfn.XLOOKUP(A9,Table5[Statements],Table5[2021])","v":1575}]
["Cash and Short Term Investments",null,{"$f":"_xlfn.XLOOKUP(A10,Table5[Statements],Table5[2024])","v":616},{"$f":"_xlfn.XLOOKUP(A10,Table5[Statements],Table5[2023])","v":512},0.203125,512,0.39509536784741145,{"$f":"_xlfn.XLOOKUP(A10,Table5[Statements],Table5[2022])","v":367},-0.2448559670781893,{"$f":"_xlfn.XLOOKUP(A10,Table5[Statements],Table5[2021])","v":486}]
["Receivables",null,{"$f":"_xlfn.XLOOKUP(A11,Table5[Statements],Table5[2024])","v":775},{"$f":"_xlfn.XLOOKUP(A11,Table5[Statements],Table5[2023])","v":737},5.1560379918588875E-2,737,0.13734567901234568,{"$f":"_xlfn.XLOOKUP(A11,Table5[Statements],Table5[2022])","v":648},8.7248322147651006E-2,{"$f":"_xlfn.XLOOKUP(A11,Table5[Statements],Table5[2021])","v":596}]
["Inventory",null,{"$f":"_xlfn.XLOOKUP(A12,Table5[Statements],Table5[2024])","v":100},{"$f":"_xlfn.XLOOKUP(A12,Table5[Statements],Table5[2023])","v":100},0,100,0,{"$f":"_xlfn.XLOOKUP(A12,Table5[Statements],Table5[2022])","v":100},0,{"$f":"_xlfn.XLOOKUP(A12,Table5[Statements],Table5[2021])","v":100}]
["Total current assets",null,{"$f":"_xlfn.XLOOKUP(A13,Table5[Statements],Table5[2024])","v":1871},{"$f":"_xlfn.XLOOKUP(A13,Table5[Statements],Table5[2023])","v":1609},0.16283405842137974,1609,0,{"$f":"_xlfn.XLOOKUP(A13,Table5[Statements],Table5[2022])","v":1609},5.0261096605744127E-2,{"$f":"_xlfn.XLOOKUP(A13,Table5[Statements],Table5[2021])","v":1532}]
["Total Assets",null,{"$f":"_xlfn.XLOOKUP(A14,Table5[Statements],Table5[2024])","v":6727},{"$f":"_xlfn.XLOOKUP(A14,Table5[Statements],Table5[2023])","v":6231},7.9601990049751242E-2,6231,6.5856996236743071E-2,{"$f":"_xlfn.XLOOKUP(A14,Table5[Statements],Table5[2022])","v":5846},-2.0113979215554811E-2,{"$f":"_xlfn.XLOOKUP(A14,Table5[Statements],Table5[2021])","v":5966}]
["Total current liabilities",null,{"$f":"_xlfn.XLOOKUP(A15,Table5[Statements],Table5[2024])","v":1269},{"$f":"_xlfn.XLOOKUP(A15,Table5[Statements],Table5[2023])","v":1277},-6.2646828504306969E-3,1277,-0.23303303303303302,{"$f":"_xlfn.XLOOKUP(A15,Table5[Statements],Table5[2022])","v":1665},0.17667844522968199,{"$f":"_xlfn.XLOOKUP(A15,Table5[Statements],Table5[2021])","v":1415}]
["Long Term Debt (Total)",null,{"$f":"_xlfn.XLOOKUP(A16,Table5[Statements],Table5[2024])","v":11306},{"$f":"_xlfn.XLOOKUP(A16,Table5[Statements],Table5[2023])","v":11142},1.4719080954945252E-2,11142,-2.7154457347419891E-2,{"$f":"_xlfn.XLOOKUP(A16,Table5[Statements],Table5[2022])","v":11453},2.4601896582572912E-2,{"$f":"_xlfn.XLOOKUP(A16,Table5[Statements],Table5[2021])","v":11178}]
["Total liabilities",null,{"$f":"_xlfn.XLOOKUP(A17,Table5[Statements],Table5[2024])","v":14375},{"$f":"_xlfn.XLOOKUP(A17,Table5[Statements],Table5[2023])","v":14089},2.0299524451699909E-2,14089,-4.299687542453471E-2,{"$f":"_xlfn.XLOOKUP(A17,Table5[Statements],Table5[2022])","v":14722},2.6710370318711207E-2,{"$f":"_xlfn.XLOOKUP(A17,Table5[Statements],Table5[2021])","v":14339}]
["Common Equity (Total)",null,{"$f":"_xlfn.XLOOKUP(A18,Table5[Statements],Table5[2024])","v":-7648},{"$f":"_xlfn.XLOOKUP(A18,Table5[Statements],Table5[2023])","v":-7858},-2.6724357342835327E-2,-7858,-0.11469130238846327,{"$f":"_xlfn.XLOOKUP(A18,Table5[Statements],Table5[2022])","v":-8876},6.0074047533739398E-2,{"$f":"_xlfn.XLOOKUP(A18,Table5[Statements],Table5[2021])","v":-8373}]
["Shares (Common)",null,{"$f":"_xlfn.XLOOKUP(A19,Table5[Statements],Table5[2024])","v":279},{"$f":"_xlfn.XLOOKUP(A19,Table5[Statements],Table5[2023])","v":281},-7.1174377224199285E-3,{"$f":"D19","v":281},3.5714285714285713E-3,{"$f":"_xlfn.XLOOKUP(A19,Table5[Statements],Table5[2022])","v":280},-3.1141868512110725E-2,{"$f":"_xlfn.XLOOKUP(A19,Table5[Statements],Table5[2021])","v":289}]
["Financial Ratio's",null,"MCD","MCD","% Change YOY","MCD","% Change YOY","MCD","% Change YOY","MCD"]
["Liquidity ",null,2024,2023,null,2023,null,2022,null,2021]
["Current Ratio",null,{"$f":"C13/C15","v":1.4743892828999212},{"$f":"D13/D15","v":1.2599843382928739},{"$f":"IFERROR((C22-D22)/D22,\"Missing Info\")","v":0.17016476958558072},{"$f":"F13/F15","v":1.2599843382928739},{"$f":"IFERROR((F22-H22)/H22,\"Missing Info\")","v":0.30383711824588877},{"$f":"H13/H15","v":0.96636636636636641},{"$f":"IFERROR((H22-J22)/J22,\"Missing Info\")","v":-0.10743576474646971},{"$f":"J13/J15","v":1.0826855123674912}]
["Quick Ratio",null,{"$f":"(C14-C12)/C17","v":0.46100869565217389},{"$f":"(D14-D12)/D17","v":0.43516218326353895},{"$f":"IFERROR((C23-D23)/D23,\"Missing Info\")","v":5.9395125272137944E-2},{"$f":"(F14-F12)/F17","v":0.43516218326353895},{"$f":"IFERROR((F23-H23)/H23,\"Missing Info\")","v":0.11494216185273591},{"$f":"(H14-H12)/H17","v":0.39030023094688221},{"$f":"IFERROR((H23-J23)/J23,\"Missing Info\")","v":-4.594016168643978E-2},{"$f":"(J14-J12)/J17","v":0.40909407908501288}]
["Net Working Capital",null,{"$f":"C13-C15","v":602},{"$f":"D13-D15","v":332},{"$f":"IFERROR((C24-D24)/D24,\"Missing Info\")","v":0.81325301204819278},{"$f":"F13-F15","v":332},{"$f":"IFERROR((F24-H24)/H24,\"Missing Info\")","v":-6.9285714285714288},{"$f":"H13-H15","v":-56},{"$f":"IFERROR((H24-J24)/J24,\"Missing Info\")","v":-1.4786324786324787},{"$f":"J13-J15","v":117}]
["Asset Management"]
["Accounts Rec. Turnover",null,{"$f":"C4/'YOY MCD'!C11","v":3.1678556441460346},{"$f":"D4/'YOY MCD'!D11","v":2.8440514469453375},{"$f":"IFERROR((C26-D26)/D26,\"Missing Info\")","v":0.11385314339108739},{"$f":"F4/'YOY MCD'!F11","v":2.8440514469453375},{"$f":"IFERROR((F26-H26)/H26,\"Missing Info\")","v":-0.12084641767182273},{"$f":"H4/'YOY MCD'!H11","v":3.2349881796690307},{"$f":"IFERROR((H26-J26)/J26,\"Missing Info\")","v":-8.0013385842604312E-2},{"$f":"J4/'YOY MCD'!J11","v":3.5163426618243965}]
["Inventory Turnover",null,{"$f":"C4/C12","v":75.489999999999995},{"$f":"D4/D12","v":70.760000000000005},{"$f":"IFERROR((C27-D27)/D27,\"Missing Info\")","v":6.6845675522894138E-2},{"$f":"F4/F12","v":70.760000000000005},{"$f":"IFERROR((F27-H27)/H27,\"Missing Info\")","v":3.4200526161941004E-2},{"$f":"H4/H12","v":68.42},{"$f":"IFERROR((H27-J27)/J27,\"Missing Info\")","v":3.9185905224787335E-2},{"$f":"J4/J12","v":65.84}]
["Total Asset Turnover",null,{"$f":"C4/C14","v":1.1221941430057976},{"$f":"D4/D14","v":1.1356122612742738},{"$f":"IFERROR((C28-D28)/D28,\"Missing Info\")","v":-1.1815756773724657E-2},{"$f":"F4/F14","v":1.1356122612742738},{"$f":"IFERROR((F28-H28)/H28,\"Missing Info\")","v":-2.9700485324553452E-2},{"$f":"H4/H14","v":1.1703729045501197},{"$f":"IFERROR((H28-J28)/J28,\"Missing Info\")","v":6.0517124627280428E-2},{"$f":"J4/J14","v":1.1035869929601072}]
["Debt Management"]
["Total Debt to Equity",null,{"$f":"C16/C18","v":-1.4782949790794979},{"$f":"D16/D18","v":-1.4179180453041487},{"$f":"IFERROR((C30-D30)/D30,\"Missing Info\")","v":4.258139881589431E-2},{"$f":"F16/F18","v":-1.4179180453041487},{"$f":"IFERROR((F30-H30)/H30,\"Missing Info\")","v":9.8877199870743421E-2},{"$f":"H16/H18","v":-1.2903334835511491},{"$f":"IFERROR((H30-J30)/J30,\"Missing Info\")","v":-3.3461955826286381E-2},{"$f":"J16/J18","v":-1.3350053744177715}]
["Equity multiplier",null,{"$f":"C14/C18","v":-0.87957635983263593},{"$f":"D14/D18","v":-0.79294986001527101},{"$f":"IFERROR((C31-D31)/D31,\"Missing Info\")","v":0.10924587314473658},{"$f":"F14/F18","v":-0.79294986001527101},{"$f":"IFERROR((F31-H31)/H31,\"Missing Info\")","v":0.2039382411042672},{"$f":"H14/H18","v":-0.65863001351960337},{"$f":"IFERROR((H31-J31)/J31,\"Missing Info\")","v":-7.5643797653429629E-2},{"$f":"J14/J18","v":-0.71252836498268246}]
["Profitability"]
["Net Profit Margin",null,{"$f":"_xlfn.XLOOKUP(A33,MCD!$A$2:$A$69,MCD!B$2:B$69)","v":0.31719999999999998},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!C$2:C$69)","v":0.3322},{"$f":"IFERROR((C33-D33)/D33,\"Missing Info\")","v":-4.5153521974714068E-2},{"$f":"D33","v":0.3322},{"$f":"IFERROR((F33-H33)/H33,\"Missing Info\")","v":0.24699699699699687},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!D$2:D$69)","v":0.26640000000000003},{"$f":"IFERROR((H33-J33)/J33,\"Missing Info\")","v":-0.18005540166204984},{"$f":"_xlfn.XLOOKUP($A$33,MCD!$A$2:$A$69,MCD!E$2:E$69)","v":0.32490000000000002}]
["Gross Profit Margin",null,{"$f":"C6/C4","v":0.71916810173532919},{"$f":"D6/D4","v":0.74929338609383833},{"$f":"IFERROR((C34-D34)/D34,\"Missing Info\")","v":-4.0204924956773046E-2},{"$f":"D34","v":0.74929338609383833},5.8201584567475336E-3,{"$f":"H6/H4","v":0.7449576147325343},9.4260002879204968E-3,{"$f":"J6/J4","v":0.7380012150668287}]
["Return On Assets ROA",null,{"$f":"C33*C28","v":0.35595998216143898},{"$f":"D33*D28","v":0.37725039319531378},{"$f":"IFERROR((C35-D35)/D35,\"Missing Info\")","v":-5.6435755715308476E-2},{"$f":"D35","v":0.37725039319531378},0.20996058098792544,{"$f":"H33*H28","v":0.31178734177215189},-0.13043471221696681,{"$f":"J33*J28","v":0.35855541401273888}]
["Return On Equity ROE",null,{"$f":"C35*C31","v":-0.31309398535564853},{"$f":"D35*D31","v":-0.29914064647492999},{"$f":"IFERROR((C36-D36)/D36,\"Missing Info\")","v":4.664474401972625E-2},{"$f":"D36","v":-0.29914064647492999},0.4567178136801,{"$f":"H35*H31","v":-0.20535250112663361},-0.1962119328924728,{"$f":"J35*J31","v":-0.25548090290218561}]
["Market Value"]
["EPS (Net Income / Shares Common)",null,{"$f":"C9/C19","v":5.3261648745519716},{"$f":"D9/D19","v":5.6832740213523127},{"$f":"IFERROR((C38-D38)/D38,\"Missing Info\")","v":-6.2835109737567854E-2},{"$f":"D38","v":5.6832740213523127},{"$f":"IFERROR((F38-H38)/H38,\"Missing Info\")","v":0.20099375545558318},{"$f":"H9/H19","v":4.7321428571428568},{"$f":"IFERROR((H38-J38)/J38,\"Missing Info\")","v":-0.13168934240362823},{"$f":"J9/J19","v":5.4498269896193774}]
["P/E",null,{"$f":"C3/C38","v":25.866641991924631},{"$f":"D3/D38","v":23.736318096430811},8.9749551166242308E-2,23.736318096430811,-0.12697304418703723,{"$f":"H3/H38","v":27.188528301886794},6.5991189551460022E-2,{"$f":"J3/J38","v":25.505396825396826}]
["Book Value Per Share",null,{"$f":"C18/C19","v":-27.412186379928315},{"$f":"D18/D19","v":-27.964412811387902},-1.9747471015543906E-2,-27.964412811387902,-0.1178418671486466,{"$f":"H18/H19","v":-31.7},9.4147856204466668E-2,{"$f":"J18/J19","v":-28.972318339100347}]
["Market Capitalization (Stock Price * Shares Common)",null,{"$f":"C3*C19","v":38437.83},{"$f":"D3*D19","v":37906.9},1.4006157190379596E-2,37906.9,5.2244564855322057E-2,{"$f":"H3*H19","v":36024.799999999996},-0.10321376117099411,{"$f":"J3*J19","v":40171}]
["Cash Per Share",null,{"$f":"C10/C19","v":2.2078853046594982},{"$f":"D10/D19","v":1.8220640569395017},0.21174955197132619,1.8220640569395017,0.39013061564866613,{"$f":"H10/H19","v":1.3107142857142857},-0.22058348030570252,{"$f":"J10/J19","v":1.6816608996539792}]
["Revenue Per Share",null,{"$f":"C4/C19","v":27.057347670250895},{"$f":"D4/D19","v":25.181494661921707},7.4493314773954447E-2,25.181494661921707,3.0520097243215107E-2,{"$f":"H4/H19","v":24.435714285714287},7.2588309321298478E-2,{"$f":"J4/J19","v":22.782006920415224}]
["Price to Book Value",null,{"$f":"C41/C40","v":-1402.2168632322177},{"$f":"D41/D40","v":-1355.5407101043522},3.4433604819048405E-2,-1355.5407101043522,0.1928071914433383,{"$f":"H41/H40","v":-1136.4290220820187},-0.18037929358112212,{"$f":"J41/J40","v":-1386.5303953182849}]

{"sheet":"Ratio Formulas","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TrendLineChart","index":14,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Revenue (SALES) YOY Trend Chart"]
[null,"Year","MCD","CAVA","CMG","SHAK","YUM"]
[null,2021,{"$f":"'YOY MCD'!$J4","v":23222.9},{"$f":"CAVA!E2","v":500.07},{"$f":"CMG!E2","v":7547.06},{"$f":"SHAK!E2","v":739.89},{"$f":"YUM!E2","v":6584}]
[null,2022,{"$f":"'YOY MCD'!$H4","v":23183},{"$f":"CAVA!D2","v":564.12},{"$f":"CMG!D2","v":8634.65},{"$f":"SHAK!D2","v":900.49},{"$f":"YUM!D2","v":6842}]
[null,2023,{"$f":"'YOY MCD'!D4","v":25494},{"$f":"CAVA!C2","v":728.7},{"$f":"CMG!C2","v":9871.65},{"$f":"SHAK!C2","v":1087.53},{"$f":"YUM!C2","v":7076}]
[null,2024,{"$f":"'YOY MCD'!C4","v":25920},{"$f":"CAVA!B2","v":963.71},{"$f":"CMG!B2","v":11313.85},{"$f":"SHAK!B2","v":1252.6099999999999},{"$f":"YUM!B2","v":7549}]
[]
[]
[null,"Profits YOY Trend Chart"]
[null,"Year","MCD","CAVA","CMG","SHAK","YUM"]
[null,2021,{"$f":"'YOY MCD'!$J6","v":12580.2},{"$f":"'YOY CAVA'!J6","v":201.91},{"$f":"'YOY CMG'!J6","v":1707.01},{"$f":"'YOY SHAK'!J6","v":145.26},{"$f":"'YOY Yum'!J6","v":4859}]
[null,2022,{"$f":"'YOY MCD'!$H6","v":13208},{"$f":"'YOY CAVA'!H6","v":226.24},{"$f":"'YOY CMG'!H6","v":2062.12},{"$f":"'YOY SHAK'!H6","v":183.39},{"$f":"'YOY Yum'!H6","v":5097}]
[null,2023,{"$f":"'YOY MCD'!$D6","v":14563},{"$f":"'YOY CAVA'!D6","v":327.92},{"$f":"'YOY CMG'!D6","v":2586.09},{"$f":"'YOY SHAK'!D6","v":248.94},{"$f":"'YOY Yum'!D6","v":5302}]
[null,2024,{"$f":"'YOY MCD'!$C6","v":14710},{"$f":"'YOY CAVA'!C6","v":431.48},{"$f":"'YOY CMG'!C6","v":3017.69},{"$f":"'YOY SHAK'!C6","v":302.47000000000003},{"$f":"'YOY Yum'!C6","v":5429}]
[]
[]
[null,"EPS YOY Trend Chart"]
[null,"Year","MCD","CAVA","CMG","SHAK","YUM"]
[null,2021,{"$f":"'YOY MCD'!J38","v":10.036179835062518},{"$f":"'YOY CAVA'!J38","v":-0.33035872062201799},{"$f":"'YOY CMG'!J38","v":0.46508547008547008},{"$f":"'YOY SHAK'!J38","v":-0.10841654778887302},{"$f":"'YOY Yum'!J38","v":5.4498269896193774}]
[null,2022,{"$f":"'YOY MCD'!H38","v":8.3326588425738564},{"$f":"'YOY CAVA'!H38","v":-0.51900404715819115},{"$f":"'YOY CMG'!H38","v":0.65088500380062986},{"$f":"'YOY SHAK'!H38","v":-0.50355787476280844},{"$f":"'YOY Yum'!H38","v":4.7321428571428568}]
[null,2023,{"$f":"'YOY MCD'!D38","v":11.564932404752151},{"$f":"'YOY CAVA'!D38","v":0.11626685344072842},{"$f":"'YOY CMG'!D38","v":0.89604025377379137},{"$f":"'YOY SHAK'!D38","v":0.47884660836681636},{"$f":"'YOY Yum'!D38","v":5.6832740213523127}]
[null,2024,{"$f":"'YOY MCD'!C38","v":11.390774345477213},{"$f":"'YOY CAVA'!C38","v":1.1379671673070206},{"$f":"'YOY CMG'!C38","v":1.1290597976080956},{"$f":"'YOY SHAK'!C38","v":0.24012229539040453},{"$f":"'YOY Yum'!C38","v":5.3261648745519716}]
[]
[null,"P/E YOY Trend Chart"]
[null,"Year","MCD","CAVA","CMG","SHAK","YUM"]
[null,2021,{"$f":"'YOY MCD'!J39","v":26.710362349573234},{"$f":"'YOY CAVA'!J39","v":-307.2417758759027},{"$f":"'YOY CMG'!J39","v":84.221078746669122},{"$f":"'YOY SHAK'!J39","v":-1108.9635526315792},{"$f":"'YOY Yum'!J39","v":25.505396825396826}]
[null,2022,{"$f":"'YOY MCD'!H39","v":31.626159786304029},{"$f":"'YOY CAVA'!H39","v":-195.5668757416511},{"$f":"'YOY CMG'!H39","v":53.911212879546213},{"$f":"'YOY SHAK'!H39","v":-198.58690532265658},{"$f":"'YOY Yum'!H39","v":27.188528301886794}]
[null,2023,{"$f":"'YOY MCD'!D39","v":25.638714488133193},{"$f":"'YOY CAVA'!D39","v":872.9917168674699},{"$f":"'YOY CMG'!D39","v":52.2297963767762},{"$f":"'YOY SHAK'!D39","v":213.01184600197433},{"$f":"'YOY Yum'!D39","v":23.736318096430811}]
[null,2024,{"$f":"'YOY MCD'!C39","v":25.449542867566578},{"$f":"'YOY CAVA'!C39","v":149.60888581952116},{"$f":"'YOY CMG'!C39","v":60.714233333985177},{"$f":"'YOY SHAK'!C39","v":602.40137120470126},{"$f":"'YOY Yum'!C39","v":25.866641991924631}]