{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["PL","BS","CF","Revenue Driver","Market Share ","Cost Matrix","Asset schedule","Debt Schedule","WACC","Valuation","Ref."],"not_rendered":{"defined_names":1,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"PL","index":0,"n_rows":45,"n_cols":17,"rows_kept":45,"merged":[[76087,0,76087,4],[76088,0,76088,4],[76089,0,76089,4],[76090,0,76090,4],[76091,0,76091,4],[76092,0,76092,4],[76093,0,76093,4],[76094,0,76094,4],[76095,0,76095,4],[76096,0,76096,4],[76097,0,76097,4],[76098,0,76098,4],[76099,0,76099,4],[76100,0,76100,4],[76101,0,76101,4],[76102,0,76102,4],[76103,0,76103,4],[76104,0,76104,4],[76105,0,76105,4],[76128,0,76128,4],[76129,0,76129,4],[76130,0,76130,4],[76131,0,76131,4],[76132,0,76132,4],[76133,0,76133,4],[76134,0,76134,4],[76135,0,76135,4],[76136,0,76136,4],[76137,0,76137,4],[76138,0,76138,4],[76139,0,76139,4],[76140,0,76140,4],[76141,0,76141,4],[76142,0,76142,4],[76143,0,76143,4],[76144,0,76144,4],[76145,0,76145,4],[76146,0,76146,4],[76147,0,76147,4],[76148,0,76148,4],[76149,0,76149,4],[76150,0,76150,4],[76151,0,76151,4],[76152,0,76152,4],[76167,0,76167,4],[76168,0,76168,4],[76169,0,76169,4],[76170,0,76170,4],[76171,0,76171,4],[76172,0,76172,4],[76173,0,76173,4],[76174,0,76174,4],[76175,0,76175,4],[76176,0,76176,4],[76177,0,76177,4],[76178,0,76178,4],[76179,0,76179,4],[76180,0,76180,4],[76181,0,76181,4],[76182,0,76182,4],[76183,0,76183,4],[76184,0,76184,4],[76185,0,76185,4],[76186,0,76186,4],[76187,0,76187,4],[76188,0,76188,4],[76189,0,76189,4],[76190,0,76190,4],[76191,0,76191,4],[76192,0,76192,4],[76193,0,76193,4],[76194,0,76194,4],[76195,0,76195,4],[76196,0,76196,4],[76197,0,76197,4],[76217,0,76217,4],[76218,0,76218,4],[76301,0,76301,4],[76302,0,76302,4],[76303,0,76303,4],[76304,0,76304,4],[76305,0,76305,4],[76306,0,76306,4],[76307,0,76307,4],[76308,0,76308,4],[76309,0,76309,4],[76310,0,76310,4],[76311,0,76311,4],[76312,0,76312,4],[76313,0,76313,4],[76314,0,76314,4],[76315,0,76315,4],[76316,0,76316,4],[76317,0,76317,4],[76318,0,76318,4],[76319,0,76319,4],[76320,0,76320,4],[76321,0,76321,4],[76322,0,76322,4],[76323,0,76323,4],[76324,0,76324,4],[76325,0,76325,4],[76326,0,76326,4],[76327,0,76327,4],[76328,0,76328,4],[76329,0,76329,4],[76330,0,76330,4],[76331,0,76331,4],[76332,0,76332,4],[76333,0,76333,4],[76334,0,76334,4],[76335,0,76335,4],[76336,0,76336,4],[76337,0,76337,4],[76338,0,76338,4],[76339,0,76339,4],[76340,0,76340,4],[76341,0,76341,4],[76344,0,76344,4],[76345,0,76345,4],[76346,0,76346,4],[76347,0,76347,4],[76348,0,76348,4],[76349,0,76349,4],[76350,0,76350,4],[76351,0,76351,4],[76352,0,76352,4],[76353,0,76353,4],[76354,0,76354,4],[76355,0,76355,4],[76356,0,76356,4],[76357,0,76357,4],[76358,0,76358,4],[76414,0,76414,4],[76415,0,76415,4],[76416,0,76416,4],[76417,0,76417,4],[76418,0,76418,4],[76419,0,76419,4],[76420,0,76420,4],[76421,0,76421,4],[76422,0,76422,4],[76423,0,76423,4],[76424,0,76424,4],[76425,0,76425,4],[76426,0,76426,4],[76427,0,76427,4],[76428,0,76428,4],[76429,0,76429,4],[76430,0,76430,4],[76431,0,76431,4],[76432,0,76432,4],[76433,0,76433,4],[76434,0,76434,4],[76435,0,76435,4],[76436,0,76436,4],[76437,0,76437,4],[76438,0,76438,4],[76439,0,76439,4],[76440,0,76440,4],[76441,0,76441,4],[76442,0,76442,4],[76443,0,76443,4],[76444,0,76444,4],[76445,0,76445,4],[76446,0,76446,4],[76447,0,76447,4],[76448,0,76448,4],[76449,0,76449,4],[76450,0,76450,4],[76451,0,76451,4],[76452,0,76452,4],[76453,0,76453,4],[76454,0,76454,4],[76455,0,76455,4],[76456,0,76456,4],[76457,0,76457,4],[76458,0,76458,4],[76459,0,76459,4],[76460,0,76460,4],[76461,0,76461,4],[76462,0,76462,4],[76463,0,76463,4],[76464,0,76464,4],[76465,0,76465,4],[76466,0,76466,4],[76467,0,76467,4],[76468,0,76468,4],[76469,0,76469,4],[76470,0,76470,4],[76471,0,76471,4],[76472,0,76472,4],[76473,0,76473,4],[76474,0,76474,4],[76475,0,76475,4],[76476,0,76476,4],[76477,0,76477,4],[76478,0,76478,4],[76479,0,76479,4],[76480,0,76480,4],[76481,0,76481,4],[76482,0,76482,4],[76483,0,76483,4],[76484,0,76484,4],[76485,0,76485,4],[76486,0,76486,4],[76487,0,76487,4],[76488,0,76488,4],[76489,0,76489,4],[76490,0,76490,4],[76527,0,76527,4],[76528,0,76528,4],[76529,0,76529,4],[76530,0,76530,4],[76531,0,76531,4],[76532,0,76532,4],[76533,0,76533,4],[76534,0,76534,4],[76535,0,76535,4],[76536,0,76536,4],[76537,0,76537,4],[76538,0,76538,4],[76539,0,76539,4],[76540,0,76540,4],[76541,0,76541,4],[76542,0,76542,4],[76543,0,76543,4],[76544,0,76544,4],[76545,0,76545,4],[76546,0,76546,4],[76547,0,76547,4],[76548,0,76548,4],[76549,0,76549,4],[76550,0,76550,4],[76551,0,76551,4],[76552,0,76552,4],[76553,0,76553,4],[76554,0,76554,4],[76555,0,76555,4],[76556,0,76556,4],[76557,0,76557,4],[76558,0,76558,4],[76559,0,76559,4],[76586,0,76586,4],[76587,0,76587,4],[76588,0,76588,4],[76589,0,76589,4],[76590,0,76590,4],[76591,0,76591,4],[76592,0,76592,4],[76593,0,76593,4],[76594,0,76594,4],[76595,0,76595,4],[76596,0,76596,4],[76597,0,76597,4],[76598,0,76598,4],[76599,0,76599,4],[76600,0,76600,4],[76601,0,76601,4],[76602,0,76602,4],[76603,0,76603,4],[76604,0,76604,4],[76605,0,76605,4],[76606,0,76606,4],[76607,0,76607,4],[76608,0,76608,4],[76609,0,76609,4],[76610,0,76610,4],[76611,0,76611,4],[76612,0,76612,4],[76613,0,76613,4],[76614,0,76614,4],[76615,0,76615,4],[76616,0,76616,4],[76617,0,76617,4],[76618,0,76618,4],[76619,0,76619,4],[76620,0,76620,4],[76621,0,76621,4],[76622,0,76622,4],[76623,0,76623,4],[76624,0,76624,4],[76625,0,76625,4],[76626,0,76626,4],[76627,0,76627,4],[76628,0,76628,4],[76629,0,76629,4],[76632,0,76632,4],[76633,0,76633,4],[76634,0,76634,4],[76635,0,76635,4],[76636,0,76636,4],[76637,0,76637,4],[76638,0,76638,4],[76639,0,76639,4],[76640,0,76640,4],[76641,0,76641,4],[76642,0,76642,4],[76643,0,76643,4],[76644,0,76644,4],[76645,0,76645,4],[76646,0,76646,4],[76647,0,76647,4],[76648,0,76648,4],[76649,0,76649,4],[76650,0,76650,4],[76651,0,76651,4],[76702,0,76702,4],[76703,0,76703,4],[76704,0,76704,4],[76705,0,76705,4],[76706,0,76706,4],[76707,0,76707,4],[76708,0,76708,4],[76709,0,76709,4],[76710,0,76710,4],[76711,0,76711,4],[76712,0,76712,4],[76713,0,76713,4],[76714,0,76714,4],[76715,0,76715,4],[76716,0,76716,4],[76717,0,76717,4],[76718,0,76718,4],[76719,0,76719,4],[76720,0,76720,4],[76721,0,76721,4],[76722,0,76722,4],[76723,0,76723,4],[76724,0,76724,4],[76725,0,76725,4],[76726,0,76726,4],[76727,0,76727,4],[76728,0,76728,4],[76729,0,76729,4],[76730,0,76730,4],[76731,0,76731,4],[76732,0,76732,4],[76733,0,76733,4],[76734,0,76734,4],[76735,0,76735,4],[76736,0,76736,4],[76737,0,76737,4],[76738,0,76738,4],[76739,0,76739,4],[76740,0,76740,4],[76741,0,76741,4],[76742,0,76742,4],[76743,0,76743,4],[76744,0,76744,4],[76745,0,76745,4],[76746,0,76746,4],[76747,0,76747,4],[76748,0,76748,4],[76749,0,76749,4],[76750,0,76750,4],[76751,0,76751,4],[76752,0,76752,4],[76753,0,76753,4],[76754,0,76754,4],[76755,0,76755,4],[76756,0,76756,4],[76757,0,76757,4],[76758,0,76758,4],[76759,0,76759,4],[76760,0,76760,4],[76761,0,76761,4],[76762,0,76762,4],[76763,0,76763,4],[76764,0,76764,4],[76765,0,76765,4],[76766,0,76766,4],[76767,0,76767,4],[76768,0,76768,4],[76769,0,76769,4],[76770,0,76770,4],[76771,0,76771,4],[76772,0,76772,4],[76773,0,76773,4],[76774,0,76774,4],[76775,0,76775,4],[76776,0,76776,4],[76777,0,76777,4],[76778,0,76778,4],[76779,0,76779,4],[76780,0,76780,4],[76781,0,76781,4],[76782,0,76782,4],[76783,0,76783,4],[76784,0,76784,4],[76785,0,76785,4],[76786,0,76786,4],[76787,0,76787,4],[76846,0,76846,4],[76847,0,76847,4],[76848,0,76848,4],[76849,0,76849,4],[76850,0,76850,4],[76851,0,76851,4],[76852,0,76852,4],[76853,0,76853,4],[76854,0,76854,4],[76855,0,76855,4],[76856,0,76856,4],[76857,0,76857,4],[76858,0,76858,4],[76859,0,76859,4],[76860,0,76860,4],[76861,0,76861,4],[76862,0,76862,4],[76863,0,76863,4],[76864,0,76864,4],[76865,0,76865,4],[76866,0,76866,4],[76867,0,76867,4],[76868,0,76868,4],[76869,0,76869,4],[76870,0,76870,4],[76871,0,76871,4],[76872,0,76872,4],[76873,0,76873,4],[76874,0,76874,4],[76875,0,76875,4],[76876,0,76876,4],[76877,0,76877,4],[76878,0,76878,4],[76879,0,76879,4],[76880,0,76880,4],[76881,0,76881,4],[76882,0,76882,4],[76883,0,76883,4],[76884,0,76884,4],[76885,0,76885,4],[76886,0,76886,4],[76887,0,76887,4],[76888,0,76888,4],[76889,0,76889,4],[76890,0,76890,4],[76891,0,76891,4],[76892,0,76892,4],[76893,0,76893,4],[76894,0,76894,4],[76895,0,76895,4],[76896,0,76896,4],[76897,0,76897,4],[76898,0,76898,4],[76899,0,76899,4],[76900,0,76900,4],[76901,0,76901,4],[76902,0,76902,4],[76903,0,76903,4],[76904,0,76904,4],[76905,0,76905,4],[76906,0,76906,4],[76907,0,76907,4],[76908,0,76908,4],[76909,0,76909,4],[76910,0,76910,4],[76911,0,76911,4],[76912,0,76912,4],[76913,0,76913,4],[76914,0,76914,4],[76915,0,76915,4],[76916,0,76916,4],[76917,0,76917,4],[76920,0,76920,4],[76921,0,76921,4],[76922,0,76922,4],[76923,0,76923,4],[76924,0,76924,4],[76925,0,76925,4],[76926,0,76926,4],[76927,0,76927,4],[76928,0,76928,4],[76929,0,76929,4],[76930,0,76930,4],[76931,0,76931,4],[76932,0,76932,4],[76933,0,76933,4],[76934,0,76934,4],[76935,0,76935,4],[76936,0,76936,4],[76937,0,76937,4],[76938,0,76938,4],[76939,0,76939,4],[76940,0,76940,4],[76941,0,76941,4],[76942,0,76942,4],[76943,0,76943,4],[76944,0,76944,4],[76959,0,76959,4],[76960,0,76960,4],[76961,0,76961,4],[76962,0,76962,4],[76963,0,76963,4],[76964,0,76964,4],[76965,0,76965,4],[76966,0,76966,4],[76967,0,76967,4],[76968,0,76968,4],[76969,0,76969,4],[76970,0,76970,4],[76971,0,76971,4],[76972,0,76972,4],[76973,0,76973,4],[76974,0,76974,4],[76975,0,76975,4],[76976,0,76976,4],[76977,0,76977,4],[76978,0,76978,4],[76979,0,76979,4],[76980,0,76980,4],[76981,0,76981,4],[76982,0,76982,4],[76983,0,76983,4],[76984,0,76984,4],[76985,0,76985,4],[76986,0,76986,4],[76987,0,76987,4],[76988,0,76988,4],[76989,0,76989,4],[77009,0,77009,4],[77010,0,77010,4],[77093,0,77093,4],[77094,0,77094,4],[77095,0,77095,4],[77096,0,77096,4],[77097,0,77097,4],[77098,0,77098,4],[77099,0,77099,4],[77100,0,77100,4],[77101,0,77101,4],[77102,0,77102,4],[77103,0,77103,4],[77104,0,77104,4],[77105,0,77105,4],[77106,0,77106,4],[77107,0,77107,4],[77108,0,77108,4],[77109,0,77109,4],[77110,0,77110,4],[77111,0,77111,4],[77112,0,77112,4],[77113,0,77113,4],[77114,0,77114,4],[77115,0,77115,4],[77116,0,77116,4],[77117,0,77117,4],[77118,0,77118,4],[77119,0,77119,4],[77120,0,77120,4],[77121,0,77121,4],[77122,0,77122,4],[77123,0,77123,4],[77124,0,77124,4],[77125,0,77125,4],[77126,0,77126,4],[77127,0,77127,4],[77128,0,77128,4],[77129,0,77129,4],[77130,0,77130,4],[77131,0,77131,4],[77132,0,77132,4],[77133,0,77133,4],[77136,0,77136,4],[77137,0,77137,4],[77138,0,77138,4],[77139,0,77139,4],[77140,0,77140,4],[77141,0,77141,4],[77142,0,77142,4],[77143,0,77143,4],[77144,0,77144,4],[77145,0,77145,4],[77146,0,77146,4],[77147,0,77147,4],[77148,0,77148,4],[77149,0,77149,4],[77150,0,77150,4],[77206,0,77206,4],[77207,0,77207,4],[77208,0,77208,4],[77209,0,77209,4],[77210,0,77210,4],[77211,0,77211,4],[77212,0,77212,4],[77213,0,77213,4],[77214,0,77214,4],[77215,0,77215,4],[77216,0,77216,4],[77217,0,77217,4],[77218,0,77218,4],[77219,0,77219,4],[77220,0,77220,4],[77221,0,77221,4],[77222,0,77222,4],[77223,0,77223,4],[77224,0,77224,4],[77225,0,77225,4],[77226,0,77226,4],[77227,0,77227,4],[77228,0,77228,4],[77229,0,77229,4],[77230,0,77230,4],[77231,0,77231,4],[77232,0,77232,4],[77233,0,77233,4],[77234,0,77234,4],[77235,0,77235,4],[77236,0,77236,4],[77237,0,77237,4],[77238,0,77238,4],[77239,0,77239,4],[77240,0,77240,4],[77241,0,77241,4],[77242,0,77242,4],[77243,0,77243,4],[77244,0,77244,4],[77245,0,77245,4],[77246,0,77246,4],[77247,0,77247,4],[77248,0,77248,4],[77249,0,77249,4],[77250,0,77250,4],[77251,0,77251,4],[77252,0,77252,4],[77253,0,77253,4],[77254,0,77254,4],[77255,0,77255,4],[77256,0,77256,4],[77257,0,77257,4],[77258,0,77258,4],[77259,0,77259,4],[77260,0,77260,4],[77261,0,77261,4],[77262,0,77262,4],[77263,0,77263,4],[77264,0,77264,4],[77265,0,77265,4],[77266,0,77266,4],[77267,0,77267,4],[77268,0,77268,4],[77269,0,77269,4],[77270,0,77270,4],[77271,0,77271,4],[77272,0,77272,4],[77273,0,77273,4],[77274,0,77274,4],[77275,0,77275,4],[77276,0,77276,4],[77277,0,77277,4],[77278,0,77278,4],[77279,0,77279,4],[77280,0,77280,4],[77281,0,77281,4],[77282,0,77282,4],[77319,0,77319,4],[77320,0,77320,4],[77321,0,77321,4],[77322,0,77322,4],[77323,0,77323,4],[77324,0,77324,4],[77325,0,77325,4],[77326,0,77326,4],[77327,0,77327,4],[77328,0,77328,4],[77329,0,77329,4],[77330,0,77330,4],[77331,0,77331,4],[77332,0,77332,4],[77333,0,77333,4],[77334,0,77334,4],[77335,0,77335,4],[77336,0,77336,4],[77337,0,77337,4],[77338,0,77338,4],[77339,0,77339,4],[77340,0,77340,4],[77341,0,77341,4],[77342,0,77342,4],[77343,0,77343,4],[77344,0,77344,4],[77345,0,77345,4],[77346,0,77346,4],[77347,0,77347,4],[77348,0,77348,4],[77349,0,77349,4],[77350,0,77350,4],[77351,0,77351,4],[77378,0,77378,4],[77379,0,77379,4],[77380,0,77380,4],[77381,0,77381,4],[77382,0,77382,4],[77383,0,77383,4],[77384,0,77384,4],[77385,0,77385,4],[77386,0,77386,4],[77387,0,77387,4],[77388,0,77388,4],[77389,0,77389,4],[77390,0,77390,4],[77391,0,77391,4],[77392,0,77392,4],[77393,0,77393,4],[77394,0,77394,4],[77395,0,77395,4],[77396,0,77396,4],[77397,0,77397,4],[77398,0,77398,4],[77399,0,77399,4],[77400,0,77400,4],[77401,0,77401,4],[77402,0,77402,4],[77403,0,77403,4],[77404,0,77404,4],[77405,0,77405,4],[77406,0,77406,4],[77407,0,77407,4],[77408,0,77408,4],[77409,0,77409,4],[77410,0,77410,4],[77411,0,77411,4],[77412,0,77412,4],[77413,0,77413,4],[77414,0,77414,4],[77415,0,77415,4],[77416,0,77416,4],[77417,0,77417,4],[77418,0,77418,4],[77419,0,77419,4],[77420,0,77420,4],[77421,0,77421,4],[77424,0,77424,4],[77425,0,77425,4],[77426,0,77426,4],[77427,0,77427,4],[77428,0,77428,4],[77429,0,77429,4],[77430,0,77430,4],[77431,0,77431,4],[77432,0,77432,4],[77433,0,77433,4],[77434,0,77434,4],[77435,0,77435,4],[77436,0,77436,4],[77437,0,77437,4],[77438,0,77438,4],[77439,0,77439,4],[77440,0,77440,4],[77441,0,77441,4],[77442,0,77442,4],[77443,0,77443,4],[77494,0,77494,4],[77495,0,77495,4],[77496,0,77496,4],[77497,0,77497,4],[77498,0,77498,4],[77499,0,77499,4],[77500,0,77500,4],[77501,0,77501,4],[77502,0,77502,4],[77503,0,77503,4],[77504,0,77504,4],[77505,0,77505,4],[77506,0,77506,4],[77507,0,77507,4],[77508,0,77508,4],[77509,0,77509,4],[77510,0,77510,4],[77511,0,77511,4],[77512,0,77512,4],[77513,0,77513,4],[77514,0,77514,4],[77515,0,77515,4],[77516,0,77516,4],[77517,0,77517,4],[77518,0,77518,4],[77519,0,77519,4],[77520,0,77520,4],[77521,0,77521,4],[77522,0,77522,4],[77523,0,77523,4],[77524,0,77524,4],[77525,0,77525,4],[77526,0,77526,4],[77527,0,77527,4],[77528,0,77528,4],[77529,0,77529,4],[77530,0,77530,4],[77531,0,77531,4],[77532,0,77532,4],[77533,0,77533,4],[77534,0,77534,4],[77535,0,77535,4],[77536,0,77536,4],[77537,0,77537,4],[77538,0,77538,4],[77539,0,77539,4],[77540,0,77540,4],[77541,0,77541,4],[77542,0,77542,4],[77543,0,77543,4],[77544,0,77544,4],[77545,0,77545,4],[77546,0,77546,4],[77547,0,77547,4],[77548,0,77548,4],[77549,0,77549,4],[77550,0,77550,4],[77551,0,77551,4],[77552,0,77552,4],[77553,0,77553,4],[77554,0,77554,4],[77555,0,77555,4],[77556,0,77556,4],[77557,0,77557,4],[77558,0,77558,4],[77559,0,77559,4],[77560,0,77560,4],[77561,0,77561,4],[77562,0,77562,4],[77563,0,77563,4],[77564,0,77564,4],[77565,0,77565,4],[77566,0,77566,4],[77567,0,77567,4],[77568,0,77568,4],[77569,0,77569,4],[77570,0,77570,4],[77571,0,77571,4],[77572,0,77572,4],[77573,0,77573,4],[77574,0,77574,4],[77575,0,77575,4],[77576,0,77576,4],[77577,0,77577,4],[77578,0,77578,4],[77579,0,77579,4],[77638,0,77638,4],[77639,0,77639,4],[77640,0,77640,4],[77641,0,77641,4],[77642,0,77642,4],[77643,0,77643,4],[77644,0,77644,4],[77645,0,77645,4],[77646,0,77646,4],[77647,0,77647,4],[77648,0,77648,4],[77649,0,77649,4],[77650,0,77650,4],[77651,0,77651,4],[77652,0,77652,4],[77653,0,77653,4],[77654,0,77654,4],[77655,0,77655,4],[77656,0,77656,4],[77657,0,77657,4],[77658,0,77658,4],[77659,0,77659,4],[77660,0,77660,4],[77661,0,77661,4],[77662,0,77662,4],[77663,0,77663,4],[77664,0,77664,4],[77665,0,77665,4],[77666,0,77666,4],[77667,0,77667,4],[77668,0,77668,4],[77669,0,77669,4],[77670,0,77670,4],[77671,0,77671,4],[77672,0,77672,4],[77673,0,77673,4],[77674,0,77674,4],[77675,0,77675,4],[77676,0,77676,4],[77677,0,77677,4],[77678,0,77678,4],[77679,0,77679,4],[77680,0,77680,4],[77681,0,77681,4],[77682,0,77682,4],[77683,0,77683,4],[77684,0,77684,4],[77685,0,77685,4],[77686,0,77686,4],[77687,0,77687,4],[77688,0,77688,4],[77689,0,77689,4],[77690,0,77690,4],[77691,0,77691,4],[77692,0,77692,4],[77693,0,77693,4],[77694,0,77694,4],[77695,0,77695,4],[77696,0,77696,4],[77697,0,77697,4],[77698,0,77698,4],[77699,0,77699,4],[77700,0,77700,4],[77701,0,77701,4],[77702,0,77702,4],[77703,0,77703,4],[77704,0,77704,4],[77705,0,77705,4],[77706,0,77706,4],[77707,0,77707,4],[77708,0,77708,4],[77709,0,77709,4],[77710,0,77710,4],[77711,0,77711,4],[77712,0,77712,4],[77713,0,77713,4],[77714,0,77714,4],[77715,0,77715,4],[77716,0,77716,4],[77717,0,77717,4],[77718,0,77718,4],[77719,0,77719,4],[77720,0,77720,4],[77721,0,77721,4],[77722,0,77722,4],[77723,0,77723,4],[77724,0,77724,4],[77725,0,77725,4],[77726,0,77726,4],[77727,0,77727,4],[77728,0,77728,4],[77729,0,77729,4],[77730,0,77730,4],[77731,0,77731,4],[77732,0,77732,4],[77733,0,77733,4],[77734,0,77734,4],[77735,0,77735,4],[77736,0,77736,4],[77757,0,77757,4],[77758,0,77758,4],[77759,0,77759,4],[77760,0,77760,4],[77761,0,77761,4],[77762,0,77762,4],[77763,0,77763,4],[77764,0,77764,4],[77765,0,77765,4],[77766,0,77766,4],[77769,0,77769,4],[77770,0,77770,4],[77771,0,77771,4],[77772,0,77772,4],[77773,0,77773,4],[77774,0,77774,4],[77801,0,77801,4],[77802,0,77802,4],[77803,0,77803,4],[77804,0,77804,4],[77805,0,77805,4],[77806,0,77806,4],[77808,0,77808,4],[77810,0,77810,4],[77811,0,77811,4],[77812,0,77812,4],[77813,0,77813,4],[77814,0,77814,4],[77815,0,77815,4],[77816,0,77816,4],[77817,0,77817,4],[77818,0,77818,4],[77819,0,77819,4],[77820,0,77820,4],[77821,0,77821,4],[77822,0,77822,4],[77837,0,77837,4],[77838,0,77838,4],[77839,0,77839,4],[77840,0,77840,4],[77841,0,77841,4],[77842,0,77842,4],[77843,0,77843,4],[77844,0,77844,4],[77845,0,77845,4],[77846,0,77846,4],[77847,0,77847,4],[77848,0,77848,4],[77849,0,77849,4],[77850,0,77850,4],[77851,0,77851,4],[77852,0,77852,4],[77853,0,77853,4],[77854,0,77854,4],[77855,0,77855,4],[77885,0,77885,4],[77886,0,77886,4],[77887,0,77887,4],[77888,0,77888,4],[77889,0,77889,4],[77890,0,77890,4],[77891,0,77891,4]],"merged_total":77982,"flags":["merged_cut"]}
[]
["TESLA INC"]
[]
["Profit & Loss Statement"]
[]
["(All figures in $ Millions unless stated otherwise)",{"$nulls":5},"2020-12-31",{"$f":"EOMONTH(G6,12)","v":"2021-12-31"},{"$f":"EOMONTH(H6,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31",{"$f":"EOMONTH(O6,12)","v":"2029-12-31"},{"$f":"EOMONTH(P6,12)","v":"2030-12-31"}]
["Revenue",{"$nulls":4},"I",{"v":31536,"d":"31,536"},{"v":53823,"d":"53,823"},{"v":81462,"d":"81,462"},{"v":96773,"d":"96,773"},{"v":97690,"d":"97,690"},{"v":94827,"d":"94,827"}]
["Other Income",{"$nulls":4},"II",{"$nulls":5},0]
["Total Revenue (I+II)",{"$nulls":4},"III",{"$f":"G8+G7","v":{"v":31536,"d":"31,536"}},{"$f":"H8+H7","v":{"v":53823,"d":"53,823"}},{"v":81462,"d":"81,462"},{"v":96773,"d":"96,773"},{"v":97690,"d":"97,690"},{"v":94827,"d":"94,827"}]
["Cost of Revenue",{"$nulls":5},{"v":24906,"d":"24,906"},{"v":40217,"d":"40,217"},{"v":60609,"d":"60,609"},{"v":79113,"d":"79,113"},{"v":80240,"d":"80,240"},{"v":77733,"d":"77,733"}]
["Gross Profit (III-IV)",{"$nulls":4},"V",{"$f":"G7-G10","v":{"v":6630,"d":"6,630"}},{"v":13606,"d":"13,606"},{"v":20853,"d":"20,853"},{"v":17660,"d":"17,660"},{"$f":"K7-K10","v":{"v":17450,"d":"17,450"}},{"$f":"L7-L10","v":{"v":17094,"d":"17,094"}}]
["Gross Profit Margin",{"$nulls":5},{"$f":"G11/G9","v":{"v":0.2102359208523592,"d":"21%"}},{"v":0.25279155751258753,"d":"25%"},{"v":0.25598438535759005,"d":"26%"},{"v":0.18248891736331416,"d":"18%"},{"v":0.17862626676220697,"d":"18%"},{"v":0.18,"d":"18%"}]
["Operating Expenses"]
["Research & Development",{"$nulls":5},{"v":1491,"d":"1,491"},{"v":2593,"d":"2,593"},{"v":3075,"d":"3,075"},{"v":3969,"d":"3,969"},{"v":4540,"d":"4,540"},{"v":6411,"d":"6,411"}]
["SGA",{"$nulls":5},{"v":3145,"d":"3,145"},{"v":4517,"d":"4,517"},{"v":3946,"d":"3,946"},{"v":4800,"d":"4,800"},{"v":5150,"d":"5,150"},{"v":5834,"d":"5,834"}]
["Restructuring and other",{"$nulls":5},0,-27,176,0,684,494]
["Total Operating Expenses",{"$nulls":4},"VI",{"$f":"G14+G15+G16","v":{"v":4636,"d":"4,636"}},{"$f":"H14+H15+H16","v":{"v":7083,"d":"7,083"}},{"v":7197,"d":"7,197"},{"v":8769,"d":"8,769"},{"v":10374,"d":"10,374"},{"v":12739,"d":"12,739"}]
["Depreciation & Amortisation [+]",{"$nulls":5},{"$f":"CF!G7","v":{"v":2322,"d":"2,322"}},{"$f":"CF!H7","v":{"v":2911,"d":"2,911"}},{"$f":"CF!I7","v":{"v":3747,"d":"3,747"}},{"$f":"CF!J7","v":{"v":4667,"d":"4,667"}},{"$f":"CF!K7","v":{"v":5368,"d":"5,368"}},0]
["Wages and Salary",{"$nulls":10},0]
["Shares Based Payments",{"$nulls":5},{"$f":"CF!G8","v":{"v":1734,"d":"1,734"}},{"$f":"CF!H8","v":{"v":2121,"d":"2,121"}},{"$f":"CF!I8","v":{"v":1560,"d":"1,560"}},{"$f":"CF!J8","v":{"v":1812,"d":"1,812"}},{"$f":"CF!K8","v":{"v":1999,"d":"1,999"}},0]
["Depreciation on leased assets",{"$nulls":10},0]
["Amortisation/Adjustment aquired Goodwill",{"$nulls":10},0]
["Exceptional Costs",{"$nulls":10},0]
["Total Adjustments",{"$nulls":5},{"$f":"G20+G22+G23","v":{"v":1734,"d":"1,734"}},{"$f":"H20+H22+H23","v":{"v":2121,"d":"2,121"}},{"v":1560,"d":"1,560"},{"v":1812,"d":"1,812"},{"v":1999,"d":"1,999"}]
[{"$nulls":11},0]
["Reported EBIT",{"$nulls":5},{"$f":"G11-G17","v":{"v":1994,"d":"1,994"}},{"$f":"H11-H17","v":{"v":6523,"d":"6,523"}},{"v":13656,"d":"13,656"},{"v":8891,"d":"8,891"},{"v":7076,"d":"7,076"},{"v":4355,"d":"4,355"}]
[]
["Interest Income",{"$nulls":5},30,56,297,{"v":1066,"d":"1,066"},{"v":1569,"d":"1,569"},{"v":1680,"d":"1,680"}]
["Interest Expense",{"$nulls":5},-748,-371,-191,-156,-350,-338]
["Notional Interest",{"$nulls":5},-122,135,-43,172,695,-419]
[{"$nulls":11},0]
["Reported PBT",{"$nulls":5},{"$f":"G26+G30+G29+G28","v":{"v":1154,"d":"1,154"}},{"$f":"H26+H30+H29+H28","v":{"v":6343,"d":"6,343"}},{"$f":"I26+I30+I29+I28","v":{"v":13719,"d":"13,719"}},{"$f":"J26+J30+J29+J28","v":{"v":9973,"d":"9,973"}},{"$f":"K26+K30+K29+K28","v":{"v":8990,"d":"8,990"}},{"$f":"SUM(L27:L30)","v":923}]
["Tax Rate",{"$nulls":5},{"$f":"G34/G32","v":{"v":-0.2530329289428076,"d":"-25%"}},{"$f":"H34/H32","v":{"v":-0.11020022071574964,"d":"-11%"}},{"$f":"I34/I32","v":{"v":-0.08251330271885705,"d":"-8%"}},{"$f":"J34/J32","v":{"v":0.5014539255991176,"d":"50%"}},{"$f":"K34/K32","v":{"v":-0.20433815350389323,"d":"-20%"}},{"v":0.27,"d":"0"}]
["Reported Tax",{"$nulls":5},-292,-699,{"v":-1132,"d":"-1,132"},{"v":5001,"d":"5,001"},{"v":-1837,"d":"-1,837"},{"v":1423,"d":"1,423"}]
[]
["Reported PAT",{"$nulls":5},{"$f":"G32+G34+G35","v":862},{"$f":"H32+H34+H35","v":{"v":5644,"d":"5,644"}},{"$f":"I32+I34+I35","v":{"v":12587,"d":"12,587"}},{"$f":"J32+J34+J35","v":{"v":14974,"d":"14,974"}},{"$f":"K32+K34+K35","v":{"v":7153,"d":"7,153"}},{"$f":"L32-L34","v":-500}]
["PAT attributable to Common Stock holders",{"$nulls":5},{"$f":"G40*G44","v":{"v":699.5,"d":"700"}},{"v":5533.33,"d":"5,533"},{"v":12582.599999999999,"d":"12,583"},{"v":15013.020000000002,"d":"15,013"},{"$f":"K40*K44","v":{"v":7129.3099999999995,"d":"7,129"}},{"v":3794,"d":"3,794"}]
[]
["EPS"]
["Basic",{"$nulls":5},0.25,1.87,4.02,4.73,2.23,{"$f":"L37/L44","v":{"v":1.1764341085271317,"d":"1.176"}}]
["Diluted",{"$nulls":5},0.21,1.63,3.62,{"v":4.3,"d":"4.30"},2.04,{"$f":"L37/L45","v":{"v":1.0753968253968254,"d":"1.075"}}]
[]
["No.of Common Stock"]
["Basic",{"$nulls":5},{"v":2798,"d":"2,798"},{"v":2959,"d":"2,959"},{"v":3130,"d":"3,130"},{"v":3174,"d":"3,174"},{"v":3197,"d":"3,197"},{"v":3225,"d":"3,225"}]
["Diluted",{"$nulls":5},{"v":3249,"d":"3,249"},{"v":3386,"d":"3,386"},{"v":3475,"d":"3,475"},{"v":3485,"d":"3,485"},{"v":3498,"d":"3,498"},{"v":3528,"d":"3,528"}]

{"sheet":"BS","index":1,"n_rows":35,"n_cols":15,"rows_kept":35,"merged":[[2,0,2,5],[76979,0,76979,4],[76980,0,76980,4],[76985,0,76985,4],[76986,0,76986,4],[76987,0,76987,4],[76988,0,76988,4],[76989,0,76989,4],[76990,0,76990,4],[76991,0,76991,4],[76992,0,76992,4],[76993,0,76993,4],[76994,0,76994,4],[76995,0,76995,4],[76996,0,76996,4],[76997,0,76997,4],[76998,0,76998,4],[76999,0,76999,4],[77000,0,77000,4],[77001,0,77001,4],[77002,0,77002,4],[77003,0,77003,4],[77004,0,77004,4],[77005,0,77005,4],[77006,0,77006,4],[77007,0,77007,4],[77008,0,77008,4],[77009,0,77009,4],[77010,0,77010,4],[77011,0,77011,4],[77012,0,77012,4],[77013,0,77013,4],[77014,0,77014,4],[77015,0,77015,4],[77016,0,77016,4],[77017,0,77017,4],[77018,0,77018,4],[77019,0,77019,4],[77020,0,77020,4],[77021,0,77021,4],[77022,0,77022,4],[77023,0,77023,4],[77024,0,77024,4],[77025,0,77025,4],[77026,0,77026,4],[77027,0,77027,4],[77028,0,77028,4],[77029,0,77029,4],[77030,0,77030,4],[77031,0,77031,4],[77032,0,77032,4],[77033,0,77033,4],[77034,0,77034,4],[77035,0,77035,4],[77036,0,77036,4],[77037,0,77037,4],[77038,0,77038,4],[77039,0,77039,4],[77040,0,77040,4],[77041,0,77041,4],[77042,0,77042,4],[77043,0,77043,4],[77044,0,77044,4],[77045,0,77045,4],[77046,0,77046,4],[77047,0,77047,4],[77048,0,77048,4],[77049,0,77049,4],[77050,0,77050,4],[77051,0,77051,4],[77052,0,77052,4],[77053,0,77053,4],[77054,0,77054,4],[77055,0,77055,4],[77056,0,77056,4],[77057,0,77057,4],[77058,0,77058,4],[77059,0,77059,4],[77060,0,77060,4],[77061,0,77061,4],[77062,0,77062,4],[77063,0,77063,4],[77064,0,77064,4],[77065,0,77065,4],[77066,0,77066,4],[77067,0,77067,4],[77068,0,77068,4],[77069,0,77069,4],[77070,0,77070,4],[77071,0,77071,4],[77072,0,77072,4],[77073,0,77073,4],[77074,0,77074,4],[77075,0,77075,4],[77076,0,77076,4],[77077,0,77077,4],[77078,0,77078,4],[77079,0,77079,4],[77080,0,77080,4],[77081,0,77081,4],[77082,0,77082,4],[77083,0,77083,4],[77084,0,77084,4],[77085,0,77085,4],[77086,0,77086,4],[77087,0,77087,4],[77088,0,77088,4],[77089,0,77089,4],[77090,0,77090,4],[77091,0,77091,4],[77092,0,77092,4],[77093,0,77093,4],[77094,0,77094,4],[77095,0,77095,4],[77096,0,77096,4],[77097,0,77097,4],[77098,0,77098,4],[77099,0,77099,4],[77100,0,77100,4],[77101,0,77101,4],[77102,0,77102,4],[77103,0,77103,4],[77104,0,77104,4],[77105,0,77105,4],[77106,0,77106,4],[77107,0,77107,4],[77108,0,77108,4],[77109,0,77109,4],[77110,0,77110,4],[77111,0,77111,4],[77112,0,77112,4],[77113,0,77113,4],[77114,0,77114,4],[77115,0,77115,4],[77116,0,77116,4],[77117,0,77117,4],[77118,0,77118,4],[77119,0,77119,4],[77120,0,77120,4],[77121,0,77121,4],[77122,0,77122,4],[77123,0,77123,4],[77124,0,77124,4],[77125,0,77125,4],[77126,0,77126,4],[77127,0,77127,4],[77128,0,77128,4],[77129,0,77129,4],[77130,0,77130,4],[77131,0,77131,4],[77132,0,77132,4],[77133,0,77133,4],[77134,0,77134,4],[77135,0,77135,4],[77136,0,77136,4],[77137,0,77137,4],[77138,0,77138,4],[77139,0,77139,4],[77140,0,77140,4],[77141,0,77141,4],[77142,0,77142,4],[77143,0,77143,4],[77144,0,77144,4],[77145,0,77145,4],[77146,0,77146,4],[77147,0,77147,4],[77148,0,77148,4],[77149,0,77149,4],[77150,0,77150,4],[77151,0,77151,4],[77152,0,77152,4],[77153,0,77153,4],[77154,0,77154,4],[77155,0,77155,4],[77156,0,77156,4],[77157,0,77157,4],[77158,0,77158,4],[77159,0,77159,4],[77160,0,77160,4],[77161,0,77161,4],[77162,0,77162,4],[77163,0,77163,4],[77164,0,77164,4],[77165,0,77165,4],[77166,0,77166,4],[77167,0,77167,4],[77168,0,77168,4],[77169,0,77169,4],[77170,0,77170,4],[77171,0,77171,4],[77172,0,77172,4],[77173,0,77173,4],[77174,0,77174,4],[77175,0,77175,4],[77176,0,77176,4],[77177,0,77177,4],[77178,0,77178,4],[77179,0,77179,4],[77180,0,77180,4],[77181,0,77181,4],[77182,0,77182,4],[77183,0,77183,4],[77184,0,77184,4],[77185,0,77185,4],[77186,0,77186,4],[77187,0,77187,4],[77188,0,77188,4],[77189,0,77189,4],[77190,0,77190,4],[77191,0,77191,4],[77192,0,77192,4],[77193,0,77193,4],[77194,0,77194,4],[77195,0,77195,4],[77196,0,77196,4],[77197,0,77197,4],[77198,0,77198,4],[77199,0,77199,4],[77200,0,77200,4],[77201,0,77201,4],[77202,0,77202,4],[77203,0,77203,4],[77204,0,77204,4],[77205,0,77205,4],[77206,0,77206,4],[77207,0,77207,4],[77208,0,77208,4],[77209,0,77209,4],[77210,0,77210,4],[77211,0,77211,4],[77212,0,77212,4],[77213,0,77213,4],[77214,0,77214,4],[77215,0,77215,4],[77216,0,77216,4],[77217,0,77217,4],[77218,0,77218,4],[77219,0,77219,4],[77220,0,77220,4],[77221,0,77221,4],[77222,0,77222,4],[77223,0,77223,4],[77224,0,77224,4],[77225,0,77225,4],[77226,0,77226,4],[77227,0,77227,4],[77228,0,77228,4],[77229,0,77229,4],[77230,0,77230,4],[77231,0,77231,4],[77232,0,77232,4],[77233,0,77233,4],[77234,0,77234,4],[77235,0,77235,4],[77236,0,77236,4],[77237,0,77237,4],[77238,0,77238,4],[77239,0,77239,4],[77240,0,77240,4],[77241,0,77241,4],[77242,0,77242,4],[77243,0,77243,4],[77244,0,77244,4],[77245,0,77245,4],[77246,0,77246,4],[77247,0,77247,4],[77248,0,77248,4],[77249,0,77249,4],[77250,0,77250,4],[77251,0,77251,4],[77252,0,77252,4],[77253,0,77253,4],[77254,0,77254,4],[77255,0,77255,4],[77256,0,77256,4],[77257,0,77257,4],[77258,0,77258,4],[77259,0,77259,4],[77260,0,77260,4],[77261,0,77261,4],[77262,0,77262,4],[77263,0,77263,4],[77264,0,77264,4],[77265,0,77265,4],[77266,0,77266,4],[77267,0,77267,4],[77268,0,77268,4],[77269,0,77269,4],[77270,0,77270,4],[77271,0,77271,4],[77272,0,77272,4],[77273,0,77273,4],[77274,0,77274,4],[77275,0,77275,4],[77276,0,77276,4],[77277,0,77277,4],[77278,0,77278,4],[77279,0,77279,4],[77280,0,77280,4],[77281,0,77281,4],[77282,0,77282,4],[77283,0,77283,4],[77284,0,77284,4],[77285,0,77285,4],[77286,0,77286,4],[77287,0,77287,4],[77288,0,77288,4],[77289,0,77289,4],[77290,0,77290,4],[77291,0,77291,4],[77292,0,77292,4],[77293,0,77293,4],[77294,0,77294,4],[77295,0,77295,4],[77296,0,77296,4],[77297,0,77297,4],[77298,0,77298,4],[77299,0,77299,4],[77300,0,77300,4],[77301,0,77301,4],[77302,0,77302,4],[77303,0,77303,4],[77304,0,77304,4],[77305,0,77305,4],[77306,0,77306,4],[77307,0,77307,4],[77308,0,77308,4],[77309,0,77309,4],[77310,0,77310,4],[77311,0,77311,4],[77312,0,77312,4],[77313,0,77313,4],[77314,0,77314,4],[77315,0,77315,4],[77316,0,77316,4],[77317,0,77317,4],[77318,0,77318,4],[77319,0,77319,4],[77320,0,77320,4],[77321,0,77321,4],[77322,0,77322,4],[77323,0,77323,4],[77324,0,77324,4],[77325,0,77325,4],[77326,0,77326,4],[77327,0,77327,4],[77328,0,77328,4],[77329,0,77329,4],[77330,0,77330,4],[77331,0,77331,4],[77332,0,77332,4],[77333,0,77333,4],[77334,0,77334,4],[77335,0,77335,4],[77336,0,77336,4],[77337,0,77337,4],[77338,0,77338,4],[77339,0,77339,4],[77340,0,77340,4],[77341,0,77341,4],[77342,0,77342,4],[77343,0,77343,4],[77344,0,77344,4],[77345,0,77345,4],[77346,0,77346,4],[77347,0,77347,4],[77348,0,77348,4],[77349,0,77349,4],[77350,0,77350,4],[77351,0,77351,4],[77352,0,77352,4],[77353,0,77353,4],[77354,0,77354,4],[77355,0,77355,4],[77356,0,77356,4],[77357,0,77357,4],[77358,0,77358,4],[77359,0,77359,4],[77360,0,77360,4],[77361,0,77361,4],[77362,0,77362,4],[77363,0,77363,4],[77364,0,77364,4],[77365,0,77365,4],[77366,0,77366,4],[77367,0,77367,4],[77368,0,77368,4],[77369,0,77369,4],[77370,0,77370,4],[77371,0,77371,4],[77372,0,77372,4],[77373,0,77373,4],[77374,0,77374,4],[77375,0,77375,4],[77376,0,77376,4],[77377,0,77377,4],[77378,0,77378,4],[77379,0,77379,4],[77380,0,77380,4],[77381,0,77381,4],[77382,0,77382,4],[77383,0,77383,4],[77384,0,77384,4],[77385,0,77385,4],[77386,0,77386,4],[77387,0,77387,4],[77388,0,77388,4],[77389,0,77389,4],[77390,0,77390,4],[77391,0,77391,4],[77392,0,77392,4],[77393,0,77393,4],[77394,0,77394,4],[77395,0,77395,4],[77396,0,77396,4],[77397,0,77397,4],[77398,0,77398,4],[77399,0,77399,4],[77400,0,77400,4],[77401,0,77401,4],[77402,0,77402,4],[77403,0,77403,4],[77404,0,77404,4],[77405,0,77405,4],[77406,0,77406,4],[77407,0,77407,4],[77408,0,77408,4],[77409,0,77409,4],[77410,0,77410,4],[77411,0,77411,4],[77412,0,77412,4],[77413,0,77413,4],[77414,0,77414,4],[77415,0,77415,4],[77416,0,77416,4],[77417,0,77417,4],[77418,0,77418,4],[77419,0,77419,4],[77420,0,77420,4],[77421,0,77421,4],[77422,0,77422,4],[77423,0,77423,4],[77424,0,77424,4],[77425,0,77425,4],[77426,0,77426,4],[77427,0,77427,4],[77428,0,77428,4],[77429,0,77429,4],[77430,0,77430,4],[77431,0,77431,4],[77432,0,77432,4],[77433,0,77433,4],[77434,0,77434,4],[77435,0,77435,4],[77436,0,77436,4],[77437,0,77437,4],[77438,0,77438,4],[77439,0,77439,4],[77440,0,77440,4],[77441,0,77441,4],[77442,0,77442,4],[77443,0,77443,4],[77444,0,77444,4],[77445,0,77445,4],[77446,0,77446,4],[77447,0,77447,4],[77448,0,77448,4],[77449,0,77449,4],[77450,0,77450,4],[77451,0,77451,4],[77452,0,77452,4],[77453,0,77453,4],[77454,0,77454,4],[77455,0,77455,4],[77456,0,77456,4],[77457,0,77457,4],[77458,0,77458,4],[77459,0,77459,4],[77460,0,77460,4],[77461,0,77461,4],[77462,0,77462,4],[77463,0,77463,4],[77464,0,77464,4],[77465,0,77465,4],[77466,0,77466,4],[77467,0,77467,4],[77468,0,77468,4],[77469,0,77469,4],[77470,0,77470,4],[77471,0,77471,4],[77472,0,77472,4],[77473,0,77473,4],[77474,0,77474,4],[77475,0,77475,4],[77476,0,77476,4],[77477,0,77477,4],[77478,0,77478,4],[77479,0,77479,4],[77480,0,77480,4],[77481,0,77481,4],[77482,0,77482,4],[77483,0,77483,4],[77484,0,77484,4],[77485,0,77485,4],[77486,0,77486,4],[77487,0,77487,4],[77488,0,77488,4],[77489,0,77489,4],[77490,0,77490,4],[77491,0,77491,4],[77492,0,77492,4],[77493,0,77493,4],[77494,0,77494,4],[77495,0,77495,4],[77496,0,77496,4],[77497,0,77497,4],[77498,0,77498,4],[77499,0,77499,4],[77500,0,77500,4],[77501,0,77501,4],[77502,0,77502,4],[77503,0,77503,4],[77504,0,77504,4],[77505,0,77505,4],[77506,0,77506,4],[77507,0,77507,4],[77508,0,77508,4],[77509,0,77509,4],[77510,0,77510,4],[77511,0,77511,4],[77512,0,77512,4],[77513,0,77513,4],[77514,0,77514,4],[77515,0,77515,4],[77516,0,77516,4],[77517,0,77517,4],[77518,0,77518,4],[77519,0,77519,4],[77520,0,77520,4],[77521,0,77521,4],[77522,0,77522,4],[77523,0,77523,4],[77524,0,77524,4],[77525,0,77525,4],[77526,0,77526,4],[77527,0,77527,4],[77528,0,77528,4],[77529,0,77529,4],[77530,0,77530,4],[77531,0,77531,4],[77532,0,77532,4],[77533,0,77533,4],[77534,0,77534,4],[77535,0,77535,4],[77536,0,77536,4],[77537,0,77537,4],[77538,0,77538,4],[77539,0,77539,4],[77540,0,77540,4],[77541,0,77541,4],[77542,0,77542,4],[77543,0,77543,4],[77544,0,77544,4],[77545,0,77545,4],[77546,0,77546,4],[77547,0,77547,4],[77548,0,77548,4],[77549,0,77549,4],[77550,0,77550,4],[77551,0,77551,4],[77552,0,77552,4],[77553,0,77553,4],[77554,0,77554,4],[77555,0,77555,4],[77556,0,77556,4],[77557,0,77557,4],[77558,0,77558,4],[77559,0,77559,4],[77560,0,77560,4],[77561,0,77561,4],[77562,0,77562,4],[77563,0,77563,4],[77564,0,77564,4],[77565,0,77565,4],[77566,0,77566,4],[77567,0,77567,4],[77568,0,77568,4],[77569,0,77569,4],[77570,0,77570,4],[77571,0,77571,4],[77572,0,77572,4],[77573,0,77573,4],[77574,0,77574,4],[77575,0,77575,4],[77576,0,77576,4],[77577,0,77577,4],[77578,0,77578,4],[77579,0,77579,4],[77580,0,77580,4],[77581,0,77581,4],[77582,0,77582,4],[77583,0,77583,4],[77584,0,77584,4],[77585,0,77585,4],[77586,0,77586,4],[77587,0,77587,4],[77588,0,77588,4],[77589,0,77589,4],[77590,0,77590,4],[77591,0,77591,4],[77592,0,77592,4],[77593,0,77593,4],[77594,0,77594,4],[77595,0,77595,4],[77596,0,77596,4],[77597,0,77597,4],[77598,0,77598,4],[77599,0,77599,4],[77600,0,77600,4],[77601,0,77601,4],[77602,0,77602,4],[77603,0,77603,4],[77604,0,77604,4],[77605,0,77605,4],[77606,0,77606,4],[77607,0,77607,4],[77608,0,77608,4],[77609,0,77609,4],[77610,0,77610,4],[77611,0,77611,4],[77612,0,77612,4],[77613,0,77613,4],[77614,0,77614,4],[77615,0,77615,4],[77616,0,77616,4],[77617,0,77617,4],[77618,0,77618,4],[77619,0,77619,4],[77620,0,77620,4],[77621,0,77621,4],[77622,0,77622,4],[77623,0,77623,4],[77624,0,77624,4],[77625,0,77625,4],[77626,0,77626,4],[77627,0,77627,4],[77628,0,77628,4],[77629,0,77629,4],[77630,0,77630,4],[77631,0,77631,4],[77632,0,77632,4],[77633,0,77633,4],[77634,0,77634,4],[77635,0,77635,4],[77636,0,77636,4],[77637,0,77637,4],[77638,0,77638,4],[77639,0,77639,4],[77640,0,77640,4],[77641,0,77641,4],[77642,0,77642,4],[77643,0,77643,4],[77644,0,77644,4],[77645,0,77645,4],[77646,0,77646,4],[77647,0,77647,4],[77648,0,77648,4],[77649,0,77649,4],[77650,0,77650,4],[77651,0,77651,4],[77652,0,77652,4],[77653,0,77653,4],[77654,0,77654,4],[77655,0,77655,4],[77656,0,77656,4],[77657,0,77657,4],[77658,0,77658,4],[77659,0,77659,4],[77660,0,77660,4],[77661,0,77661,4],[77662,0,77662,4],[77663,0,77663,4],[77664,0,77664,4],[77665,0,77665,4],[77666,0,77666,4],[77667,0,77667,4],[77668,0,77668,4],[77669,0,77669,4],[77670,0,77670,4],[77671,0,77671,4],[77672,0,77672,4],[77673,0,77673,4],[77674,0,77674,4],[77675,0,77675,4],[77676,0,77676,4],[77677,0,77677,4],[77678,0,77678,4],[77679,0,77679,4],[77680,0,77680,4],[77681,0,77681,4],[77682,0,77682,4],[77683,0,77683,4],[77684,0,77684,4],[77685,0,77685,4],[77686,0,77686,4],[77687,0,77687,4],[77688,0,77688,4],[77689,0,77689,4],[77690,0,77690,4],[77691,0,77691,4],[77692,0,77692,4],[77693,0,77693,4],[77694,0,77694,4],[77695,0,77695,4],[77696,0,77696,4],[77697,0,77697,4],[77698,0,77698,4],[77699,0,77699,4],[77700,0,77700,4],[77701,0,77701,4],[77702,0,77702,4],[77703,0,77703,4],[77704,0,77704,4],[77705,0,77705,4],[77706,0,77706,4],[77707,0,77707,4],[77708,0,77708,4],[77709,0,77709,4],[77710,0,77710,4],[77711,0,77711,4],[77712,0,77712,4],[77713,0,77713,4],[77714,0,77714,4],[77715,0,77715,4],[77716,0,77716,4],[77717,0,77717,4],[77718,0,77718,4],[77719,0,77719,4],[77720,0,77720,4],[77721,0,77721,4],[77722,0,77722,4],[77723,0,77723,4],[77724,0,77724,4],[77725,0,77725,4],[77726,0,77726,4],[77727,0,77727,4],[77728,0,77728,4],[77729,0,77729,4],[77730,0,77730,4],[77731,0,77731,4],[77732,0,77732,4],[77733,0,77733,4],[77734,0,77734,4],[77735,0,77735,4],[77736,0,77736,4],[77737,0,77737,4],[77738,0,77738,4],[77739,0,77739,4],[77740,0,77740,4],[77741,0,77741,4],[77742,0,77742,4],[77743,0,77743,4],[77744,0,77744,4],[77745,0,77745,4],[77746,0,77746,4],[77747,0,77747,4],[77748,0,77748,4],[77749,0,77749,4],[77750,0,77750,4],[77751,0,77751,4],[77752,0,77752,4],[77753,0,77753,4],[77754,0,77754,4],[77755,0,77755,4],[77756,0,77756,4],[77757,0,77757,4],[77758,0,77758,4],[77759,0,77759,4],[77760,0,77760,4],[77761,0,77761,4],[77762,0,77762,4],[77763,0,77763,4],[77764,0,77764,4],[77765,0,77765,4],[77766,0,77766,4],[77767,0,77767,4],[77768,0,77768,4],[77769,0,77769,4],[77770,0,77770,4],[77771,0,77771,4],[77772,0,77772,4],[77773,0,77773,4],[77774,0,77774,4],[77775,0,77775,4],[77776,0,77776,4],[77777,0,77777,4],[77778,0,77778,4],[77779,0,77779,4],[77780,0,77780,4],[77781,0,77781,4],[77782,0,77782,4],[77783,0,77783,4],[77784,0,77784,4],[77785,0,77785,4],[77786,0,77786,4],[77787,0,77787,4],[77788,0,77788,4],[77789,0,77789,4],[77790,0,77790,4],[77791,0,77791,4],[77792,0,77792,4],[77793,0,77793,4],[77794,0,77794,4],[77795,0,77795,4],[77796,0,77796,4],[77797,0,77797,4],[77798,0,77798,4],[77799,0,77799,4],[77800,0,77800,4],[77801,0,77801,4],[77802,0,77802,4],[77803,0,77803,4],[77804,0,77804,4],[77805,0,77805,4],[77806,0,77806,4],[77807,0,77807,4],[77808,0,77808,4],[77809,0,77809,4],[77810,0,77810,4],[77811,0,77811,4],[77812,0,77812,4],[77813,0,77813,4],[77814,0,77814,4],[77815,0,77815,4],[77816,0,77816,4],[77817,0,77817,4],[77818,0,77818,4],[77819,0,77819,4],[77820,0,77820,4],[77821,0,77821,4],[77822,0,77822,4],[77823,0,77823,4],[77824,0,77824,4],[77825,0,77825,4],[77826,0,77826,4],[77827,0,77827,4],[77828,0,77828,4],[77829,0,77829,4],[77830,0,77830,4],[77831,0,77831,4],[77832,0,77832,4],[77833,0,77833,4],[77834,0,77834,4],[77835,0,77835,4],[77836,0,77836,4],[77837,0,77837,4],[77838,0,77838,4],[77839,0,77839,4],[77840,0,77840,4],[77841,0,77841,4],[77842,0,77842,4],[77843,0,77843,4],[77844,0,77844,4],[77845,0,77845,4],[77846,0,77846,4],[77847,0,77847,4],[77848,0,77848,4],[77849,0,77849,4],[77850,0,77850,4],[77851,0,77851,4],[77852,0,77852,4],[77853,0,77853,4],[77854,0,77854,4],[77855,0,77855,4],[77856,0,77856,4],[77857,0,77857,4],[77858,0,77858,4],[77859,0,77859,4],[77860,0,77860,4],[77861,0,77861,4],[77862,0,77862,4],[77863,0,77863,4],[77864,0,77864,4],[77865,0,77865,4],[77866,0,77866,4],[77867,0,77867,4],[77868,0,77868,4],[77869,0,77869,4],[77870,0,77870,4],[77871,0,77871,4],[77872,0,77872,4],[77873,0,77873,4],[77874,0,77874,4],[77875,0,77875,4],[77876,0,77876,4],[77877,0,77877,4],[77878,0,77878,4],[77879,0,77879,4],[77880,0,77880,4],[77881,0,77881,4],[77882,0,77882,4],[77883,0,77883,4],[77884,0,77884,4],[77885,0,77885,4],[77886,0,77886,4],[77887,0,77887,4],[77888,0,77888,4],[77889,0,77889,4],[77890,0,77890,4],[77891,0,77891,4],[77892,0,77892,4],[77893,0,77893,4],[77894,0,77894,4],[77895,0,77895,4],[77896,0,77896,4],[77897,0,77897,4],[77898,0,77898,4],[77899,0,77899,4],[77900,0,77900,4],[77901,0,77901,4],[77902,0,77902,4],[77903,0,77903,4],[77904,0,77904,4],[77905,0,77905,4],[77906,0,77906,4],[77907,0,77907,4],[77908,0,77908,4],[77909,0,77909,4],[77910,0,77910,4],[77911,0,77911,4],[77912,0,77912,4],[77913,0,77913,4],[77914,0,77914,4],[77915,0,77915,4],[77916,0,77916,4],[77917,0,77917,4],[77918,0,77918,4],[77919,0,77919,4],[77920,0,77920,4],[77921,0,77921,4],[77922,0,77922,4],[77923,0,77923,4],[77924,0,77924,4],[77925,0,77925,4],[77926,0,77926,4],[77927,0,77927,4],[77928,0,77928,4],[77929,0,77929,4],[77930,0,77930,4],[77931,0,77931,4],[77932,0,77932,4],[77933,0,77933,4],[77934,0,77934,4],[77935,0,77935,4],[77936,0,77936,4],[77937,0,77937,4],[77938,0,77938,4],[77939,0,77939,4],[77940,0,77940,4],[77941,0,77941,4],[77942,0,77942,4],[77943,0,77943,4],[77944,0,77944,4],[77945,0,77945,4],[77946,0,77946,4],[77947,0,77947,4],[77948,0,77948,4],[77949,0,77949,4],[77950,0,77950,4],[77951,0,77951,4],[77952,0,77952,4],[77953,0,77953,4],[77954,0,77954,4],[77955,0,77955,4],[77956,0,77956,4],[77957,0,77957,4],[77958,0,77958,4],[77959,0,77959,4],[77960,0,77960,4],[77961,0,77961,4],[77962,0,77962,4],[77963,0,77963,4],[77964,0,77964,4],[77965,0,77965,4],[77966,0,77966,4],[77967,0,77967,4],[77968,0,77968,4],[77969,0,77969,4],[77970,0,77970,4],[77971,0,77971,4],[77972,0,77972,4],[77973,0,77973,4],[77974,0,77974,4],[77975,0,77975,4],[77976,0,77976,4],[77977,0,77977,4],[77978,0,77978,4],[77979,0,77979,4],[77980,0,77980,4],[77981,0,77981,4]],"merged_total":77980,"flags":["merged_cut"]}
["Balance Sheet"]
["Year Tracker",{"$nulls":5},{"$f":"F2+1","v":1},{"$f":"G2+1","v":2},3,4,5,6,7,8,9]
["(All figures in $ Millions unless stated otherwise)",{"$nulls":5},"2020-12-31",{"$f":"EOMONTH(G3,12)","v":"2021-12-31"},{"$f":"EOMONTH(H3,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
["Check"]
["Non-Current Assets",{"$nulls":5},{"v":25431,"d":"25,431"},{"v":35031,"d":"35,031"},{"v":41421,"d":"41,421"},{"v":57002,"d":"57,002"},{"v":63710,"d":"63,710"},{"v":69164,"d":"69,164"}]
["Current Assets",{"$nulls":10},0]
["Cash and Cash Equivalents",{"$nulls":5},{"v":19384,"d":"19,384"},{"v":17576,"d":"17,576"},{"v":16253,"d":"16,253"},{"v":16398,"d":"16,398"},{"v":16139,"d":"16,139"},{"v":16513,"d":"16,513"}]
["Short-Term marketable securities",{"$nulls":5},0,131,{"v":5932,"d":"5,932"},{"v":12696,"d":"12,696"},{"v":20424,"d":"20,424"},{"v":27546,"d":"27,546"}]
["Accounts Receivables",{"$nulls":5},{"v":1886,"d":"1,886"},{"v":1913,"d":"1,913"},{"v":2952,"d":"2,952"},{"v":3508,"d":"3,508"},{"v":4418,"d":"4,418"},{"v":4576,"d":"4,576"}]
["Inventory",{"$nulls":5},{"v":4101,"d":"4,101"},{"v":5757,"d":"5,757"},{"v":12839,"d":"12,839"},{"v":13626,"d":"13,626"},{"v":12017,"d":"12,017"},{"v":12392,"d":"12,392"}]
["Prepaid Exp. & other CA",{"$nulls":5},{"v":1346,"d":"1,346"},{"v":1723,"d":"1,723"},{"v":2941,"d":"2,941"},{"v":3388,"d":"3,388"},{"v":5362,"d":"5,362"},{"v":7615,"d":"7,615"}]
["Total",{"$nulls":5},{"$f":"SUM(G7:G11)","v":{"v":26717,"d":"26,717"}},{"v":27100,"d":"27,100"},{"v":40917,"d":"40,917"},{"v":49616,"d":"49,616"},{"v":58360,"d":"58,360"},{"v":68642,"d":"68,642"}]
[]
["Total Assets",{"$nulls":5},{"$f":"G5+G12","v":{"v":52148,"d":"52,148"}},{"v":62131,"d":"62,131"},{"v":82338,"d":"82,338"},{"v":106618,"d":"106,618"},{"v":122070,"d":"122,070"},{"$f":"L12+L5","v":{"v":137806,"d":"137,806"}}]
[]
["Current Liablities",{"$nulls":10},0]
["Accounts Payable",{"$nulls":5},{"v":6051,"d":"6,051"},{"v":10025,"d":"10,025"},{"v":15255,"d":"15,255"},{"v":14431,"d":"14,431"},{"v":12474,"d":"12,474"},{"v":13371,"d":"13,371"}]
["Accrued liablites and other",{"$nulls":5},{"v":3855,"d":"3,855"},{"v":5719,"d":"5,719"},{"v":8205,"d":"8,205"},{"v":9080,"d":"9,080"},{"v":10723,"d":"10,723"},{"v":13279,"d":"13,279"}]
["Deferred revenue",{"$nulls":5},{"v":1458,"d":"1,458"},{"v":1447,"d":"1,447"},{"v":1747,"d":"1,747"},{"v":2864,"d":"2,864"},{"v":3168,"d":"3,168"},{"v":3424,"d":"3,424"}]
["Current portion of LT Debt",{"$nulls":10},{"v":1640,"d":"1,640"}]
["Customer deposits",{"$nulls":5},752,925,{"$nulls":3},0]
["Total",{"$nulls":5},{"$f":"SUM(G17:G21)","v":{"v":12116,"d":"12,116"}},{"v":18116,"d":"18,116"},{"v":25207,"d":"25,207"},{"v":26375,"d":"26,375"},{"v":26365,"d":"26,365"},{"v":31714,"d":"31,714"}]
["Debt and finance leases",{"$nulls":5},{"$f":"2132+9556","v":{"v":11688,"d":"11,688"}},{"$f":"1589+5245","v":{"v":6834,"d":"6,834"}},{"$f":"1502+1597","v":{"v":3099,"d":"3,099"}},{"$f":"2373+2857","v":{"v":5230,"d":"5,230"}},{"$f":"5757+2456","v":{"v":8213,"d":"8,213"}},{"v":6736,"d":"6,736"}]
["Other long-term liabilities",{"$nulls":5},{"v":3330,"d":"3,330"},{"v":3546,"d":"3,546"},{"v":5330,"d":"5,330"},{"v":8153,"d":"8,153"},{"v":10495,"d":"10,495"},{"v":12860,"d":"12,860"}]
["Deferred Revenue",{"$nulls":5},{"v":1284,"d":"1,284"},{"v":2052,"d":"2,052"},{"v":2804,"d":"2,804"},{"v":3251,"d":"3,251"},{"v":3317,"d":"3,317"},{"v":3631,"d":"3,631"}]
["Total",{"$nulls":5},{"$f":"SUM(G23:G25)","v":{"v":16302,"d":"16,302"}},{"$f":"SUM(H23:H25)","v":{"v":12432,"d":"12,432"}},{"v":11233,"d":"11,233"},{"v":16634,"d":"16,634"},{"v":22025,"d":"22,025"},{"$f":"SUM(L23:L25)","v":{"v":23227,"d":"23,227"}}]
["Total Liabilities",{"$nulls":5},{"$f":"G22+G26","v":{"v":28418,"d":"28,418"}},{"v":30548,"d":"30,548"},{"v":36440,"d":"36,440"},{"v":43009,"d":"43,009"},{"v":48390,"d":"48,390"},{"$f":"L26+L22","v":{"v":54941,"d":"54,941"}}]
[]
["Provisions",{"$nulls":5},655,568,409,242,63,0]
["Redeemable NCI",{"$nulls":10},58]
["Equity",{"$nulls":5},{"$f":"1+27260+363","v":{"v":27624,"d":"27,624"}},{"$f":"3+29803+54","v":{"v":29860,"d":"29,860"}},{"$f":"3+32177-361","v":{"v":31819,"d":"31,819"}},{"$f":"3+34892-143","v":{"v":34752,"d":"34,752"}},{"$f":"3+38371-670","v":{"v":37704,"d":"37,704"}},{"v":82137,"d":"82,137"}]
["Retained Earnings",{"$nulls":5},{"v":-5399,"d":"-5,399"},329,{"v":12885,"d":"12,885"},{"v":27882,"d":"27,882"},{"v":35209,"d":"35,209"},{"v":39003,"d":"39,003"}]
["NCI in Subsidiaries",{"$nulls":5},850,826,785,733,704,670]
["Total liabilities & equity",{"$nulls":5},{"$f":"G27+G29+G31+G32+G33","v":{"v":52148,"d":"52,148"}},{"$f":"H27+H29+H31+H32+H33","v":{"v":62131,"d":"62,131"}},{"$f":"I27+I29+I31+I32+I33","v":{"v":82338,"d":"82,338"}},{"v":106618,"d":"106,618"},{"v":122070,"d":"122,070"},{"$f":"L31+L27+L30+L33","v":{"v":137806,"d":"137,806"}}]
["Check"]

{"sheet":"CF","index":2,"n_rows":53,"n_cols":15,"rows_kept":53,"merged":[[2,0,2,5],[10,0,10,4],[30,0,30,4],[31,0,31,4],[76992,0,76992,4],[76993,0,76993,4],[76994,0,76994,4],[76995,0,76995,4],[76996,0,76996,4],[76998,0,76998,4],[76999,0,76999,4],[77000,0,77000,4],[77001,0,77001,4],[77002,0,77002,4],[77003,0,77003,4],[77004,0,77004,4],[77005,0,77005,4],[77006,0,77006,4],[77007,0,77007,4],[77008,0,77008,4],[77009,0,77009,4],[77010,0,77010,4],[77011,0,77011,4],[77012,0,77012,4],[77013,0,77013,4],[77014,0,77014,4],[77015,0,77015,4],[77016,0,77016,4],[77017,0,77017,4],[77018,0,77018,4],[77019,0,77019,4],[77020,0,77020,4],[77021,0,77021,4],[77022,0,77022,4],[77023,0,77023,4],[77024,0,77024,4],[77025,0,77025,4],[77026,0,77026,4],[77027,0,77027,4],[77028,0,77028,4],[77029,0,77029,4],[77030,0,77030,4],[77031,0,77031,4],[77032,0,77032,4],[77033,0,77033,4],[77034,0,77034,4],[77035,0,77035,4],[77036,0,77036,4],[77037,0,77037,4],[77038,0,77038,4],[77039,0,77039,4],[77040,0,77040,4],[77041,0,77041,4],[77042,0,77042,4],[77043,0,77043,4],[77044,0,77044,4],[77045,0,77045,4],[77046,0,77046,4],[77047,0,77047,4],[77048,0,77048,4],[77049,0,77049,4],[77050,0,77050,4],[77051,0,77051,4],[77052,0,77052,4],[77053,0,77053,4],[77054,0,77054,4],[77055,0,77055,4],[77056,0,77056,4],[77057,0,77057,4],[77058,0,77058,4],[77059,0,77059,4],[77060,0,77060,4],[77061,0,77061,4],[77062,0,77062,4],[77063,0,77063,4],[77064,0,77064,4],[77065,0,77065,4],[77066,0,77066,4],[77067,0,77067,4],[77068,0,77068,4],[77069,0,77069,4],[77070,0,77070,4],[77071,0,77071,4],[77072,0,77072,4],[77073,0,77073,4],[77074,0,77074,4],[77075,0,77075,4],[77076,0,77076,4],[77077,0,77077,4],[77078,0,77078,4],[77079,0,77079,4],[77080,0,77080,4],[77081,0,77081,4],[77082,0,77082,4],[77083,0,77083,4],[77084,0,77084,4],[77085,0,77085,4],[77086,0,77086,4],[77087,0,77087,4],[77088,0,77088,4],[77089,0,77089,4],[77090,0,77090,4],[77091,0,77091,4],[77092,0,77092,4],[77093,0,77093,4],[77094,0,77094,4],[77095,0,77095,4],[77096,0,77096,4],[77097,0,77097,4],[77098,0,77098,4],[77099,0,77099,4],[77100,0,77100,4],[77101,0,77101,4],[77102,0,77102,4],[77103,0,77103,4],[77104,0,77104,4],[77105,0,77105,4],[77106,0,77106,4],[77107,0,77107,4],[77108,0,77108,4],[77109,0,77109,4],[77110,0,77110,4],[77111,0,77111,4],[77112,0,77112,4],[77113,0,77113,4],[77114,0,77114,4],[77115,0,77115,4],[77116,0,77116,4],[77117,0,77117,4],[77118,0,77118,4],[77119,0,77119,4],[77120,0,77120,4],[77121,0,77121,4],[77122,0,77122,4],[77123,0,77123,4],[77124,0,77124,4],[77125,0,77125,4],[77126,0,77126,4],[77127,0,77127,4],[77128,0,77128,4],[77129,0,77129,4],[77130,0,77130,4],[77131,0,77131,4],[77132,0,77132,4],[77133,0,77133,4],[77134,0,77134,4],[77135,0,77135,4],[77136,0,77136,4],[77137,0,77137,4],[77138,0,77138,4],[77139,0,77139,4],[77140,0,77140,4],[77141,0,77141,4],[77142,0,77142,4],[77143,0,77143,4],[77144,0,77144,4],[77145,0,77145,4],[77146,0,77146,4],[77147,0,77147,4],[77148,0,77148,4],[77149,0,77149,4],[77150,0,77150,4],[77151,0,77151,4],[77152,0,77152,4],[77153,0,77153,4],[77154,0,77154,4],[77155,0,77155,4],[77156,0,77156,4],[77157,0,77157,4],[77158,0,77158,4],[77159,0,77159,4],[77160,0,77160,4],[77161,0,77161,4],[77162,0,77162,4],[77163,0,77163,4],[77164,0,77164,4],[77165,0,77165,4],[77166,0,77166,4],[77167,0,77167,4],[77168,0,77168,4],[77169,0,77169,4],[77170,0,77170,4],[77171,0,77171,4],[77172,0,77172,4],[77173,0,77173,4],[77174,0,77174,4],[77175,0,77175,4],[77176,0,77176,4],[77177,0,77177,4],[77178,0,77178,4],[77179,0,77179,4],[77180,0,77180,4],[77181,0,77181,4],[77182,0,77182,4],[77183,0,77183,4],[77184,0,77184,4],[77185,0,77185,4],[77186,0,77186,4],[77187,0,77187,4],[77188,0,77188,4],[77189,0,77189,4],[77190,0,77190,4],[77191,0,77191,4],[77192,0,77192,4],[77193,0,77193,4],[77194,0,77194,4],[77195,0,77195,4],[77196,0,77196,4],[77197,0,77197,4],[77198,0,77198,4],[77199,0,77199,4],[77200,0,77200,4],[77201,0,77201,4],[77202,0,77202,4],[77203,0,77203,4],[77204,0,77204,4],[77205,0,77205,4],[77206,0,77206,4],[77207,0,77207,4],[77208,0,77208,4],[77209,0,77209,4],[77210,0,77210,4],[77211,0,77211,4],[77212,0,77212,4],[77213,0,77213,4],[77214,0,77214,4],[77215,0,77215,4],[77216,0,77216,4],[77217,0,77217,4],[77218,0,77218,4],[77219,0,77219,4],[77220,0,77220,4],[77221,0,77221,4],[77222,0,77222,4],[77223,0,77223,4],[77224,0,77224,4],[77225,0,77225,4],[77226,0,77226,4],[77227,0,77227,4],[77228,0,77228,4],[77229,0,77229,4],[77230,0,77230,4],[77231,0,77231,4],[77232,0,77232,4],[77233,0,77233,4],[77234,0,77234,4],[77235,0,77235,4],[77236,0,77236,4],[77237,0,77237,4],[77238,0,77238,4],[77239,0,77239,4],[77240,0,77240,4],[77241,0,77241,4],[77242,0,77242,4],[77243,0,77243,4],[77244,0,77244,4],[77245,0,77245,4],[77246,0,77246,4],[77247,0,77247,4],[77248,0,77248,4],[77249,0,77249,4],[77250,0,77250,4],[77251,0,77251,4],[77252,0,77252,4],[77253,0,77253,4],[77254,0,77254,4],[77255,0,77255,4],[77256,0,77256,4],[77257,0,77257,4],[77258,0,77258,4],[77259,0,77259,4],[77260,0,77260,4],[77261,0,77261,4],[77262,0,77262,4],[77263,0,77263,4],[77264,0,77264,4],[77265,0,77265,4],[77266,0,77266,4],[77267,0,77267,4],[77268,0,77268,4],[77269,0,77269,4],[77270,0,77270,4],[77271,0,77271,4],[77272,0,77272,4],[77273,0,77273,4],[77274,0,77274,4],[77275,0,77275,4],[77276,0,77276,4],[77277,0,77277,4],[77278,0,77278,4],[77279,0,77279,4],[77280,0,77280,4],[77281,0,77281,4],[77282,0,77282,4],[77283,0,77283,4],[77284,0,77284,4],[77285,0,77285,4],[77286,0,77286,4],[77287,0,77287,4],[77288,0,77288,4],[77289,0,77289,4],[77290,0,77290,4],[77291,0,77291,4],[77292,0,77292,4],[77293,0,77293,4],[77294,0,77294,4],[77295,0,77295,4],[77296,0,77296,4],[77297,0,77297,4],[77298,0,77298,4],[77299,0,77299,4],[77300,0,77300,4],[77301,0,77301,4],[77302,0,77302,4],[77303,0,77303,4],[77304,0,77304,4],[77305,0,77305,4],[77306,0,77306,4],[77307,0,77307,4],[77308,0,77308,4],[77309,0,77309,4],[77310,0,77310,4],[77311,0,77311,4],[77312,0,77312,4],[77313,0,77313,4],[77314,0,77314,4],[77315,0,77315,4],[77316,0,77316,4],[77317,0,77317,4],[77318,0,77318,4],[77319,0,77319,4],[77320,0,77320,4],[77321,0,77321,4],[77322,0,77322,4],[77323,0,77323,4],[77324,0,77324,4],[77325,0,77325,4],[77326,0,77326,4],[77327,0,77327,4],[77328,0,77328,4],[77329,0,77329,4],[77330,0,77330,4],[77331,0,77331,4],[77332,0,77332,4],[77333,0,77333,4],[77334,0,77334,4],[77335,0,77335,4],[77336,0,77336,4],[77337,0,77337,4],[77338,0,77338,4],[77339,0,77339,4],[77340,0,77340,4],[77341,0,77341,4],[77342,0,77342,4],[77343,0,77343,4],[77344,0,77344,4],[77345,0,77345,4],[77346,0,77346,4],[77347,0,77347,4],[77348,0,77348,4],[77349,0,77349,4],[77350,0,77350,4],[77351,0,77351,4],[77352,0,77352,4],[77353,0,77353,4],[77354,0,77354,4],[77355,0,77355,4],[77356,0,77356,4],[77357,0,77357,4],[77358,0,77358,4],[77359,0,77359,4],[77360,0,77360,4],[77361,0,77361,4],[77362,0,77362,4],[77363,0,77363,4],[77364,0,77364,4],[77365,0,77365,4],[77366,0,77366,4],[77367,0,77367,4],[77368,0,77368,4],[77369,0,77369,4],[77370,0,77370,4],[77371,0,77371,4],[77372,0,77372,4],[77373,0,77373,4],[77374,0,77374,4],[77375,0,77375,4],[77376,0,77376,4],[77377,0,77377,4],[77378,0,77378,4],[77379,0,77379,4],[77380,0,77380,4],[77381,0,77381,4],[77382,0,77382,4],[77383,0,77383,4],[77384,0,77384,4],[77385,0,77385,4],[77386,0,77386,4],[77387,0,77387,4],[77388,0,77388,4],[77389,0,77389,4],[77390,0,77390,4],[77391,0,77391,4],[77392,0,77392,4],[77393,0,77393,4],[77394,0,77394,4],[77395,0,77395,4],[77396,0,77396,4],[77397,0,77397,4],[77398,0,77398,4],[77399,0,77399,4],[77400,0,77400,4],[77401,0,77401,4],[77402,0,77402,4],[77403,0,77403,4],[77404,0,77404,4],[77405,0,77405,4],[77406,0,77406,4],[77407,0,77407,4],[77408,0,77408,4],[77409,0,77409,4],[77410,0,77410,4],[77411,0,77411,4],[77412,0,77412,4],[77413,0,77413,4],[77414,0,77414,4],[77415,0,77415,4],[77416,0,77416,4],[77417,0,77417,4],[77418,0,77418,4],[77419,0,77419,4],[77420,0,77420,4],[77421,0,77421,4],[77422,0,77422,4],[77423,0,77423,4],[77424,0,77424,4],[77425,0,77425,4],[77426,0,77426,4],[77427,0,77427,4],[77428,0,77428,4],[77429,0,77429,4],[77430,0,77430,4],[77431,0,77431,4],[77432,0,77432,4],[77433,0,77433,4],[77434,0,77434,4],[77435,0,77435,4],[77436,0,77436,4],[77437,0,77437,4],[77438,0,77438,4],[77439,0,77439,4],[77440,0,77440,4],[77441,0,77441,4],[77442,0,77442,4],[77443,0,77443,4],[77444,0,77444,4],[77445,0,77445,4],[77446,0,77446,4],[77447,0,77447,4],[77448,0,77448,4],[77449,0,77449,4],[77450,0,77450,4],[77451,0,77451,4],[77452,0,77452,4],[77453,0,77453,4],[77454,0,77454,4],[77455,0,77455,4],[77456,0,77456,4],[77457,0,77457,4],[77458,0,77458,4],[77459,0,77459,4],[77460,0,77460,4],[77461,0,77461,4],[77462,0,77462,4],[77463,0,77463,4],[77464,0,77464,4],[77465,0,77465,4],[77466,0,77466,4],[77467,0,77467,4],[77468,0,77468,4],[77469,0,77469,4],[77470,0,77470,4],[77471,0,77471,4],[77472,0,77472,4],[77473,0,77473,4],[77474,0,77474,4],[77475,0,77475,4],[77476,0,77476,4],[77477,0,77477,4],[77478,0,77478,4],[77479,0,77479,4],[77480,0,77480,4],[77481,0,77481,4],[77482,0,77482,4],[77483,0,77483,4],[77484,0,77484,4],[77485,0,77485,4],[77486,0,77486,4],[77487,0,77487,4],[77488,0,77488,4],[77489,0,77489,4],[77490,0,77490,4],[77491,0,77491,4],[77492,0,77492,4],[77493,0,77493,4],[77494,0,77494,4],[77495,0,77495,4],[77496,0,77496,4],[77497,0,77497,4],[77498,0,77498,4],[77499,0,77499,4],[77500,0,77500,4],[77501,0,77501,4],[77502,0,77502,4],[77503,0,77503,4],[77504,0,77504,4],[77505,0,77505,4],[77506,0,77506,4],[77507,0,77507,4],[77508,0,77508,4],[77509,0,77509,4],[77510,0,77510,4],[77511,0,77511,4],[77512,0,77512,4],[77513,0,77513,4],[77514,0,77514,4],[77515,0,77515,4],[77516,0,77516,4],[77517,0,77517,4],[77518,0,77518,4],[77519,0,77519,4],[77520,0,77520,4],[77521,0,77521,4],[77522,0,77522,4],[77523,0,77523,4],[77524,0,77524,4],[77525,0,77525,4],[77526,0,77526,4],[77527,0,77527,4],[77528,0,77528,4],[77529,0,77529,4],[77530,0,77530,4],[77531,0,77531,4],[77532,0,77532,4],[77533,0,77533,4],[77534,0,77534,4],[77535,0,77535,4],[77536,0,77536,4],[77537,0,77537,4],[77538,0,77538,4],[77539,0,77539,4],[77540,0,77540,4],[77541,0,77541,4],[77542,0,77542,4],[77543,0,77543,4],[77544,0,77544,4],[77545,0,77545,4],[77546,0,77546,4],[77547,0,77547,4],[77548,0,77548,4],[77549,0,77549,4],[77550,0,77550,4],[77551,0,77551,4],[77552,0,77552,4],[77553,0,77553,4],[77554,0,77554,4],[77555,0,77555,4],[77556,0,77556,4],[77557,0,77557,4],[77558,0,77558,4],[77559,0,77559,4],[77560,0,77560,4],[77561,0,77561,4],[77562,0,77562,4],[77563,0,77563,4],[77564,0,77564,4],[77565,0,77565,4],[77566,0,77566,4],[77567,0,77567,4],[77568,0,77568,4],[77569,0,77569,4],[77570,0,77570,4],[77571,0,77571,4],[77572,0,77572,4],[77573,0,77573,4],[77574,0,77574,4],[77575,0,77575,4],[77576,0,77576,4],[77577,0,77577,4],[77578,0,77578,4],[77579,0,77579,4],[77580,0,77580,4],[77581,0,77581,4],[77582,0,77582,4],[77583,0,77583,4],[77584,0,77584,4],[77585,0,77585,4],[77586,0,77586,4],[77587,0,77587,4],[77588,0,77588,4],[77589,0,77589,4],[77590,0,77590,4],[77591,0,77591,4],[77592,0,77592,4],[77593,0,77593,4],[77594,0,77594,4],[77595,0,77595,4],[77596,0,77596,4],[77597,0,77597,4],[77598,0,77598,4],[77599,0,77599,4],[77600,0,77600,4],[77601,0,77601,4],[77602,0,77602,4],[77603,0,77603,4],[77604,0,77604,4],[77605,0,77605,4],[77606,0,77606,4],[77607,0,77607,4],[77608,0,77608,4],[77609,0,77609,4],[77610,0,77610,4],[77611,0,77611,4],[77612,0,77612,4],[77613,0,77613,4],[77614,0,77614,4],[77615,0,77615,4],[77616,0,77616,4],[77617,0,77617,4],[77618,0,77618,4],[77619,0,77619,4],[77620,0,77620,4],[77621,0,77621,4],[77622,0,77622,4],[77623,0,77623,4],[77624,0,77624,4],[77625,0,77625,4],[77626,0,77626,4],[77627,0,77627,4],[77628,0,77628,4],[77629,0,77629,4],[77630,0,77630,4],[77631,0,77631,4],[77632,0,77632,4],[77633,0,77633,4],[77634,0,77634,4],[77635,0,77635,4],[77636,0,77636,4],[77637,0,77637,4],[77638,0,77638,4],[77639,0,77639,4],[77640,0,77640,4],[77641,0,77641,4],[77642,0,77642,4],[77643,0,77643,4],[77644,0,77644,4],[77645,0,77645,4],[77646,0,77646,4],[77647,0,77647,4],[77648,0,77648,4],[77649,0,77649,4],[77650,0,77650,4],[77651,0,77651,4],[77652,0,77652,4],[77653,0,77653,4],[77654,0,77654,4],[77655,0,77655,4],[77656,0,77656,4],[77657,0,77657,4],[77658,0,77658,4],[77659,0,77659,4],[77660,0,77660,4],[77661,0,77661,4],[77662,0,77662,4],[77663,0,77663,4],[77664,0,77664,4],[77665,0,77665,4],[77666,0,77666,4],[77667,0,77667,4],[77668,0,77668,4],[77669,0,77669,4],[77670,0,77670,4],[77671,0,77671,4],[77672,0,77672,4],[77673,0,77673,4],[77674,0,77674,4],[77675,0,77675,4],[77676,0,77676,4],[77677,0,77677,4],[77678,0,77678,4],[77679,0,77679,4],[77680,0,77680,4],[77681,0,77681,4],[77682,0,77682,4],[77683,0,77683,4],[77684,0,77684,4],[77685,0,77685,4],[77686,0,77686,4],[77687,0,77687,4],[77688,0,77688,4],[77689,0,77689,4],[77690,0,77690,4],[77691,0,77691,4],[77692,0,77692,4],[77693,0,77693,4],[77694,0,77694,4],[77695,0,77695,4],[77696,0,77696,4],[77697,0,77697,4],[77698,0,77698,4],[77699,0,77699,4],[77700,0,77700,4],[77701,0,77701,4],[77702,0,77702,4],[77703,0,77703,4],[77704,0,77704,4],[77705,0,77705,4],[77706,0,77706,4],[77707,0,77707,4],[77708,0,77708,4],[77709,0,77709,4],[77710,0,77710,4],[77711,0,77711,4],[77712,0,77712,4],[77713,0,77713,4],[77714,0,77714,4],[77715,0,77715,4],[77716,0,77716,4],[77717,0,77717,4],[77718,0,77718,4],[77719,0,77719,4],[77720,0,77720,4],[77721,0,77721,4],[77722,0,77722,4],[77723,0,77723,4],[77724,0,77724,4],[77725,0,77725,4],[77726,0,77726,4],[77727,0,77727,4],[77728,0,77728,4],[77729,0,77729,4],[77730,0,77730,4],[77731,0,77731,4],[77732,0,77732,4],[77733,0,77733,4],[77734,0,77734,4],[77735,0,77735,4],[77736,0,77736,4],[77737,0,77737,4],[77738,0,77738,4],[77739,0,77739,4],[77740,0,77740,4],[77741,0,77741,4],[77742,0,77742,4],[77743,0,77743,4],[77744,0,77744,4],[77745,0,77745,4],[77746,0,77746,4],[77747,0,77747,4],[77748,0,77748,4],[77749,0,77749,4],[77750,0,77750,4],[77751,0,77751,4],[77752,0,77752,4],[77753,0,77753,4],[77754,0,77754,4],[77755,0,77755,4],[77756,0,77756,4],[77757,0,77757,4],[77758,0,77758,4],[77759,0,77759,4],[77760,0,77760,4],[77761,0,77761,4],[77762,0,77762,4],[77763,0,77763,4],[77764,0,77764,4],[77765,0,77765,4],[77766,0,77766,4],[77767,0,77767,4],[77768,0,77768,4],[77769,0,77769,4],[77770,0,77770,4],[77771,0,77771,4],[77772,0,77772,4],[77773,0,77773,4],[77774,0,77774,4],[77775,0,77775,4],[77776,0,77776,4],[77777,0,77777,4],[77778,0,77778,4],[77779,0,77779,4],[77780,0,77780,4],[77781,0,77781,4],[77782,0,77782,4],[77783,0,77783,4],[77784,0,77784,4],[77785,0,77785,4],[77786,0,77786,4],[77787,0,77787,4],[77788,0,77788,4],[77789,0,77789,4],[77790,0,77790,4],[77791,0,77791,4],[77792,0,77792,4],[77793,0,77793,4],[77794,0,77794,4],[77795,0,77795,4],[77796,0,77796,4],[77797,0,77797,4],[77798,0,77798,4],[77799,0,77799,4],[77800,0,77800,4],[77801,0,77801,4],[77802,0,77802,4],[77803,0,77803,4],[77804,0,77804,4],[77805,0,77805,4],[77806,0,77806,4],[77807,0,77807,4],[77808,0,77808,4],[77809,0,77809,4],[77810,0,77810,4],[77811,0,77811,4],[77812,0,77812,4],[77813,0,77813,4],[77814,0,77814,4],[77815,0,77815,4],[77816,0,77816,4],[77817,0,77817,4],[77818,0,77818,4],[77819,0,77819,4],[77820,0,77820,4],[77821,0,77821,4],[77822,0,77822,4],[77823,0,77823,4],[77824,0,77824,4],[77825,0,77825,4],[77826,0,77826,4],[77827,0,77827,4],[77828,0,77828,4],[77829,0,77829,4],[77830,0,77830,4],[77831,0,77831,4],[77832,0,77832,4],[77833,0,77833,4],[77834,0,77834,4],[77835,0,77835,4],[77836,0,77836,4],[77837,0,77837,4],[77838,0,77838,4],[77839,0,77839,4],[77840,0,77840,4],[77841,0,77841,4],[77842,0,77842,4],[77843,0,77843,4],[77844,0,77844,4],[77845,0,77845,4],[77846,0,77846,4],[77847,0,77847,4],[77848,0,77848,4],[77849,0,77849,4],[77850,0,77850,4],[77851,0,77851,4],[77852,0,77852,4],[77853,0,77853,4],[77854,0,77854,4],[77855,0,77855,4],[77856,0,77856,4],[77857,0,77857,4],[77858,0,77858,4],[77859,0,77859,4],[77860,0,77860,4],[77861,0,77861,4],[77862,0,77862,4],[77863,0,77863,4],[77864,0,77864,4],[77865,0,77865,4],[77866,0,77866,4],[77867,0,77867,4],[77868,0,77868,4],[77869,0,77869,4],[77870,0,77870,4],[77871,0,77871,4],[77872,0,77872,4],[77873,0,77873,4],[77874,0,77874,4],[77875,0,77875,4],[77876,0,77876,4],[77877,0,77877,4],[77878,0,77878,4],[77879,0,77879,4],[77880,0,77880,4],[77881,0,77881,4],[77882,0,77882,4],[77883,0,77883,4],[77884,0,77884,4],[77885,0,77885,4],[77886,0,77886,4],[77887,0,77887,4],[77888,0,77888,4],[77889,0,77889,4],[77890,0,77890,4],[77891,0,77891,4],[77892,0,77892,4],[77893,0,77893,4],[77894,0,77894,4],[77895,0,77895,4],[77896,0,77896,4],[77897,0,77897,4],[77898,0,77898,4],[77899,0,77899,4],[77900,0,77900,4],[77901,0,77901,4],[77902,0,77902,4],[77903,0,77903,4],[77904,0,77904,4],[77905,0,77905,4],[77906,0,77906,4],[77907,0,77907,4],[77908,0,77908,4],[77909,0,77909,4],[77910,0,77910,4],[77911,0,77911,4],[77912,0,77912,4],[77913,0,77913,4],[77914,0,77914,4],[77915,0,77915,4],[77916,0,77916,4],[77917,0,77917,4],[77918,0,77918,4],[77919,0,77919,4],[77920,0,77920,4],[77921,0,77921,4],[77922,0,77922,4],[77923,0,77923,4],[77924,0,77924,4],[77925,0,77925,4],[77926,0,77926,4],[77927,0,77927,4],[77928,0,77928,4],[77929,0,77929,4],[77930,0,77930,4],[77931,0,77931,4],[77932,0,77932,4],[77933,0,77933,4],[77934,0,77934,4],[77935,0,77935,4],[77936,0,77936,4],[77937,0,77937,4],[77938,0,77938,4],[77939,0,77939,4],[77940,0,77940,4],[77941,0,77941,4],[77942,0,77942,4],[77943,0,77943,4],[77944,0,77944,4],[77945,0,77945,4],[77946,0,77946,4],[77947,0,77947,4],[77948,0,77948,4],[77949,0,77949,4],[77950,0,77950,4],[77951,0,77951,4],[77952,0,77952,4],[77953,0,77953,4],[77954,0,77954,4],[77955,0,77955,4],[77956,0,77956,4],[77957,0,77957,4],[77958,0,77958,4],[77959,0,77959,4],[77960,0,77960,4],[77961,0,77961,4],[77962,0,77962,4],[77963,0,77963,4],[77964,0,77964,4],[77965,0,77965,4],[77966,0,77966,4],[77967,0,77967,4],[77968,0,77968,4],[77969,0,77969,4],[77970,0,77970,4],[77971,0,77971,4],[77972,0,77972,4],[77973,0,77973,4],[77974,0,77974,4],[77975,0,77975,4],[77976,0,77976,4],[77977,0,77977,4],[77978,0,77978,4],[77979,0,77979,4],[77980,0,77980,4],[77981,0,77981,4],[77982,0,77982,4],[77983,0,77983,4],[77984,0,77984,4],[77985,0,77985,4],[77986,0,77986,4],[77987,0,77987,4],[77988,0,77988,4]],"merged_total":77989,"flags":["merged_cut"]}
["Cahs Flow Statement"]
["Year Tracker",{"$nulls":5},{"$f":"F2+1","v":1},{"$f":"G2+1","v":2},3,4,5,6,7,8,9]
["(All figures in $ Millions unless stated otherwise)",{"$nulls":5},"2020-12-31",{"$f":"EOMONTH(G3,12)","v":"2021-12-31"},{"$f":"EOMONTH(H3,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
["Cash Flows from Operating Activities"]
["Net Income",{"$nulls":5},862,{"v":5644,"d":"5,644"},{"v":12587,"d":"12,587"},{"v":14974,"d":"14,974"},{"v":7153,"d":"7,153"},{"v":3855,"d":"3,855"}]
["Adjustments:"]
["Depreciation, amortization and impairment",{"$nulls":5},{"v":2322,"d":"2,322"},{"v":2911,"d":"2,911"},{"v":3747,"d":"3,747"},{"v":4667,"d":"4,667"},{"v":5368,"d":"5,368"},{"v":6148,"d":"6,148"}]
["Stock-based compensation",{"$nulls":5},{"v":1734,"d":"1,734"},{"v":2121,"d":"2,121"},{"v":1560,"d":"1,560"},{"v":1812,"d":"1,812"},{"v":1999,"d":"1,999"},{"v":2825,"d":"2,825"}]
["Inventory and purchase commitments write-downs",{"$nulls":5},202,140,177,463,335,362]
["Foreign Exchange Gain/Loss",{"$nulls":5},114,-55,81,-144,-73,452]
["Deferred income taxes",{"$nulls":7},-196,{"v":-6349,"d":"-6,349"},477,123]
["Non-cash interest and other operating activities",{"$nulls":5},525,245,340,81,172,272]
["Digital assets gain",{"$nulls":6},-27,140,null,-589,68]
["Changes in Working Capital:"]
["Accounts receivable",{"$nulls":5},-652,-130,{"v":-1124,"d":"-1,124"},-586,{"v":-1083,"d":"-1,083"},-261]
["Inventory",{"$nulls":5},-422,{"v":-1709,"d":"-1,709"},{"v":-6465,"d":"-6,465"},{"v":-1195,"d":"-1,195"},937,-630]
["Operating lease vehicles",{"$nulls":5},{"v":-1072,"d":"-1,072"},{"v":-2114,"d":"-2,114"},{"v":-1570,"d":"-1,570"},{"v":-1952,"d":"-1,952"},-590,-25]
["Prepaid expenses and other current assets",{"$nulls":5},-251,-271,{"v":-3713,"d":"-3,713"},{"v":-2652,"d":"-2,652"},{"v":-3273,"d":"-3,273"},{"v":-3181,"d":"-3,181"}]
["Other non-current assets",{"$nulls":5},-344,{"v":-1291,"d":"-1,291"},{"$nulls":3},0]
["Accounts payable and accrued liabilities",{"$nulls":5},{"v":2102,"d":"2,102"},{"v":4578,"d":"4,578"},{"v":8029,"d":"8,029"},{"v":2605,"d":"2,605"},{"v":3588,"d":"3,588"},{"v":4376,"d":"4,376"}]
["Deferred revenue",{"$nulls":5},321,793,{"v":1131,"d":"1,131"},{"v":1532,"d":"1,532"},502,363]
["Customer deposits",{"$nulls":5},7,186,{"$nulls":3},0]
["Other long-term liabilities",{"$nulls":5},495,476,{"$nulls":3},0]
["Net cash provided by operating activities",{"$nulls":5},{"$f":"SUM(G5:G23)","v":{"v":5943,"d":"5,943"}},{"v":11497,"d":"11,497"},{"v":14724,"d":"14,724"},{"v":13256,"d":"13,256"},{"v":14923,"d":"14,923"},{"v":14747,"d":"14,747"}]
["Cash Flows from Investing Activities"]
["Purchases of PP&E",{"$nulls":5},{"v":-3157,"d":"-3,157"},{"v":-6482,"d":"-6,482"},{"v":-7158,"d":"-7,158"},{"v":-8898,"d":"-8,898"},{"v":-11339,"d":"-11,339"},{"v":-8527,"d":"-8,527"}]
["Purchases of solar energy systems",{"$nulls":5},-75,-32,-5,-1,-3,0]
["Purchases of digital assets",{"$nulls":6},{"v":-1500,"d":"-1,500"},936,null,null,0]
["Proceeds from sales of digital assets",{"$nulls":6},272,-9,null,null,0]
["Purchases of marketable securities/investments",{"$nulls":6},-132,{"v":-5835,"d":"-5,835"},{"v":-19112,"d":"-19,112"},{"v":-35955,"d":"-35,955"},{"v":-37109,"d":"-37,109"}]
["Proceeds from maturities of investments",{"$nulls":7},22,{"v":12353,"d":"12,353"},{"v":28310,"d":"28,310"},{"v":30158,"d":"30,158"}]
["Proceeds from sale of investments",{"$nulls":8},138,200,0]
["Receipt of government grants",{"$nulls":5},123,6,76,null,null,0]
["Purchase of intangible assets",{"$nulls":5},-10,{"$nulls":4},0]
["Business combinations, net of cash acquired",{"$nulls":5},-13,null,null,-64,null,0]
["Net cash used in investing activities",{"$nulls":5},{"$f":"SUM(G26:G35)","v":{"v":-3132,"d":"-3,132"}},{"$f":"SUM(H26:H35)","v":{"v":-7868,"d":"-7,868"}},{"v":-11973,"d":"-11,973"},{"v":-15584,"d":"-15,584"},{"v":-18787,"d":"-18,787"},{"v":-15478,"d":"-15,478"}]
["Cash Flows from Financing Activities"]
["Proceeds from issuances of common stock",{"$nulls":5},{"v":12269,"d":"12,269"},{"$nulls":4},101]
["Proceeds from issuances of convertible and other debt",{"$nulls":5},{"v":9713,"d":"9,713"},{"v":8883,"d":"8,883"},null,{"v":3931,"d":"3,931"},{"v":5744,"d":"5,744"},{"v":5586,"d":"5,586"}]
["Repayments of convertible and other debt",{"$nulls":5},{"v":-11623,"d":"-11,623"},{"v":-14167,"d":"-14,167"},{"v":-3364,"d":"-3,364"},{"v":-1351,"d":"-1,351"},{"v":-2500,"d":"-2,500"},{"v":-5546,"d":"-5,546"}]
["Collateralized lease repayments",{"$nulls":5},-240,-9,{"$nulls":3},0]
["Proceeds from exercises of stock options and other stock issuances",{"$nulls":5},417,707,541,700,{"v":1241,"d":"1,241"},{"v":1186,"d":"1,186"}]
["Principal payments on finance leases",{"$nulls":5},-338,-439,-502,-464,-381,-104]
["Debt issuance costs",{"$nulls":5},-6,-9,null,-29,-14,-6]
["Proceeds from investments by NCI in subsidiaries",{"$nulls":5},24,2,{"$nulls":3},0]
["Distributions paid to NCI in subsidiaries",{"$nulls":5},-208,-161,-157,-144,-104,-78]
["Payments for buy-outs of noncontrolling interests in subsidiaries",{"$nulls":5},-35,-10,-45,-54,-133,0]
["Net cash (used in) provided by financing activities",{"$nulls":5},{"$f":"SUM(G38:G47)","v":{"v":9973,"d":"9,973"}},{"v":-5203,"d":"-5,203"},{"v":-3527,"d":"-3,527"},{"v":2589,"d":"2,589"},{"v":3853,"d":"3,853"},{"v":1139,"d":"1,139"}]
["Effect of exchange rate changes on cash and cash equivalents and restricted cash",{"$nulls":5},334,-183,-444,4,-141,171]
["Net (decrease) increase in cash and cash equivalents and restricted cash",{"$nulls":5},{"$f":"G24+G36+G48+G49","v":{"v":13118,"d":"13,118"}},{"v":-1757,"d":"-1,757"},{"v":-1220,"d":"-1,220"},265,-152,579]
["Cash and cash equivalents and restricted cash, beginning of period",{"$nulls":5},{"v":6783,"d":"6,783"},{"v":19901,"d":"19,901"},{"v":18144,"d":"18,144"},{"v":16924,"d":"16,924"},{"v":17189,"d":"17,189"},{"v":17037,"d":"17,037"}]
["Cash and cash equivalents and restricted cash, end of period",{"$nulls":5},{"$f":"G50+G51","v":{"v":19901,"d":"19,901"}},{"$f":"H50+H51","v":{"v":18144,"d":"18,144"}},{"v":16924,"d":"16,924"},{"v":17189,"d":"17,189"},{"v":17037,"d":"17,037"},{"v":17616,"d":"17,616"}]
[{"$nulls":6},{"$f":"G52-BS!G7","v":517},{"$f":"H52-BS!H7","v":568},{"$f":"I52-BS!I7","v":671},{"$f":"J52-BS!J7","v":791},{"$f":"K52-BS!K7","v":898}]

{"sheet":"Revenue Driver","index":3,"n_rows":69,"n_cols":17,"rows_kept":69,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,5],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[27,0,27,2],[28,0,28,2],[30,0,30,2],[31,0,31,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[43,0,43,2],[44,0,44,2],[46,0,46,2],[48,0,48,2],[50,0,50,2],[56,0,56,2],[57,0,57,2],[60,0,60,2]]}
[]
["TESLA INC"]
["Year ",{"$nulls":5},"2020-12-31",{"$f":"EOMONTH(G3,12)","v":"2021-12-31"},{"$f":"EOMONTH(H3,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31",{"$f":"EOMONTH(O3,12)","v":"2029-12-31"},{"$f":"EOMONTH(P3,12)","v":"2030-12-31"}]
["Total Revenue",{"$nulls":5},{"$f":"PL!G9","v":{"v":31536,"d":"31,536"}},{"$f":"PL!H9","v":{"v":53823,"d":"53,823"}},{"$f":"PL!I9","v":{"v":81462,"d":"81,462"}},{"$f":"PL!J9","v":{"v":96773,"d":"96,773"}},{"$f":"PL!K9","v":{"v":97690,"d":"97,690"}},{"$f":"PL!L9","v":{"v":94827,"d":"94,827"}},{"$f":"SUM(M5:M7)","v":{"v":118071.26401780565,"d":"118,071"}},{"$f":"SUM(N5:N7)","v":{"v":153523.07790543407,"d":"153,523"}},{"v":208842.62032633653,"d":"208,843"},{"v":299456.6955329021,"d":"299,457"},{"v":454812.95544438803,"d":"454,813"}]
["Automotive Revenue",{"$nulls":5},{"v":27236,"d":"27,236"},{"v":47232,"d":"47,232"},{"v":71462,"d":"71,462"},{"v":82419,"d":"82,419"},{"v":77070,"d":"77,070"},{"v":69526,"d":"69,526"},{"$f":"M37*M38","v":{"v":80906.68599676315,"d":"80,907"}},{"$f":"N37*N38","v":{"v":93954.04915100406,"d":"93,954"}},{"v":109105.48668650755,"d":"109,105"},{"v":126700.31076539781,"d":"126,700"},{"v":147132.55250098763,"d":"147,133"}]
["Energy generation and storage revenue",{"$nulls":5},{"v":1994,"d":"1,994"},{"v":2789,"d":"2,789"},{"v":3909,"d":"3,909"},{"v":6035,"d":"6,035"},{"v":10086,"d":"10,086"},{"v":12771,"d":"12,771"},{"$f":"M63*M64","v":{"v":22260.37259100642,"d":"22,260"}},{"$f":"N63*N64","v":{"v":41840.749464668086,"d":"41,841"}},{"v":78649.67023554603,"d":"78,650"},{"v":147673.2334047109,"d":"147,673"},{"v":277844.4539614561,"d":"277,844"}]
["Services and other revenue",{"$nulls":5},{"v":2306,"d":"2,306"},{"v":3802,"d":"3,802"},{"v":6091,"d":"6,091"},{"v":8319,"d":"8,319"},{"v":10534,"d":"10,534"},{"v":12530,"d":"12,530"},{"$f":"L7*(1+M67)","v":{"v":14904.205430036072,"d":"14,904"}},{"$f":"M7*(1+N67)","v":{"v":17728.27928976191,"d":"17,728"}},{"v":21087.463404282964,"d":"21,087"},{"v":25083.151362793385,"d":"25,083"},{"v":29835.948981944286,"d":"29,836"}]
[{"$nulls":7},{"$f":"H7/G7-1","v":{"v":0.6487424111014743,"d":"65%"}},{"v":0.6020515518148344,"d":"60%"},{"v":0.3657855852897718,"d":"37%"},{"v":0.2662579636975597,"d":"27%"},{"$f":"L7/K7-1","v":{"v":0.18948167837478636,"d":"19%"}}]
["Proportion %"]
["Automotive Revenue",{"$nulls":5},{"$f":"G5/G$4","v":{"v":0.8636478944698123,"d":"86%"}},{"$f":"H5/H$4","v":{"v":0.8775430578005685,"d":"88%"}},{"v":0.8772433772802043,"d":"88%"},{"v":0.8516735039732156,"d":"85%"},{"v":0.7889241478145153,"d":"79%"},{"v":0.7331878051609774,"d":"73%"}]
["Energy generation and storage revenue",{"$nulls":5},{"$f":"G6/G$4","v":{"v":0.06322932521562659,"d":"6%"}},{"v":0.05181799602400461,"d":"5%"},{"v":0.04798556382116815,"d":"5%"},{"v":0.06236243580337491,"d":"6%"},{"v":0.10324495854232778,"d":"10%"},{"v":0.1346768325476921,"d":"13%"}]
["Services and other revenue",{"$nulls":5},{"$f":"G7/G$4","v":{"v":0.07312278031456114,"d":"7%"}},{"v":0.07063894617542686,"d":"7%"},{"v":0.07477105889862758,"d":"7%"},{"v":0.08596406022340942,"d":"9%"},{"v":0.10783089364315693,"d":"11%"},{"v":0.13213536229133052,"d":"13%"}]
[]
["Growth %"]
["Automotive Revenue",{"$nulls":6},{"$f":"H5/G5-1","v":{"v":0.7341753561462769,"d":"73%"}},{"$f":"I5/H5-1","v":{"v":0.5129996612466126,"d":"51%"}},{"v":0.15332624331812705,"d":"15%"},{"v":-0.06490008371856004,"d":"-6%"},{"v":-0.09788503957441286,"d":"-10%"}]
["Energy generation and storage revenue",{"$nulls":6},{"$f":"H6/G6-1","v":{"v":0.3986960882647943,"d":"40%"}},{"v":0.4015776263893869,"d":"40%"},{"v":0.5438731133282169,"d":"54%"},{"v":0.6712510356255179,"d":"67%"},{"v":0.2662105889351576,"d":"27%"}]
["Services and other revenue",{"$nulls":6},{"v":0.6487424111014743,"d":"65%"},{"v":0.6020515518148344,"d":"60%"},{"v":0.3657855852897718,"d":"37%"},{"v":0.2662579636975597,"d":"27%"},{"v":0.18948167837478636,"d":"19%"}]
["Total",{"$nulls":6},{"$f":"H4/G4-1","v":{"v":0.7067161339421613,"d":"71%"}},{"$f":"I4/H4-1","v":{"v":0.5135165263920629,"d":"51%"}},{"v":0.18795266504627928,"d":"19%"},{"v":0.009475783534663496,"d":"1%"},{"v":-0.02930699150373628,"d":"-3%"}]
[]
[]
["Automotive"]
[]
["Model S/X / Other Models",{"$nulls":5},{"v":54805,"d":"54,805"},{"v":24390,"d":"24,390"},{"v":71177,"d":"71,177"},{"v":70826,"d":"70,826"},{"v":94105,"d":"94,105"},{"v":53900,"d":"53,900"}]
["Model 3/Y",{"$nulls":5},{"v":454932,"d":"454,932"},{"v":906032,"d":"906,032"},{"v":1298434,"d":"1,298,434"},{"v":1775159,"d":"1,775,159"},{"v":1679338,"d":"1,679,338"},{"v":1600767,"d":"1,600,767"}]
["Total Production",{"$nulls":5},{"$f":"SUM(G22:G24)/10^6","v":{"v":0.509737,"d":"0.51"}},{"v":0.930422,"d":"0.93"},{"v":1.369611,"d":"1.37"},{"v":1.845985,"d":"1.85"},{"v":1.773443,"d":"1.77"},{"$f":"SUM(L22:L24)/10^6","v":{"v":1.654667,"d":"1.65"}}]
[]
["Production "]
["Model S/X / Other Models",{"$nulls":6},{"$f":"H23/(H$25*10^6)","v":{"v":0.026213911536915508,"d":"3%"}},{"$f":"I23/(I$25*10^6)","v":{"v":0.05196877069474471,"d":"5%"}},{"v":0.03836759236938545,"d":"4%"},{"v":0.05306344776798578,"d":"5%"},{"v":0.032574530101827134,"d":"3%"}]
["Model 3/Y",{"$nulls":6},{"$f":"H24/(H$25*10^6)","v":{"v":0.9737860884630845,"d":"97%"}},{"v":0.9480312293052553,"d":"95%"},{"v":0.9616324076306145,"d":"96%"},{"v":0.9469365522320142,"d":"95%"},{"v":0.9674254698981729,"d":"97%"}]
["Growth"]
["Model S/X / Other Models",{"$nulls":6},{"$f":"H23/G23-1","v":{"v":-0.5549676124441201,"d":"-55%"}},{"$f":"I23/H23-1","v":{"v":1.9182861828618285,"d":"192%"}},{"v":-0.004931368279078918,"d":"-0%"},{"v":0.3286787337983226,"d":"33%"},{"v":-0.42723553477498544,"d":"-43%"}]
["Model 3/Y",{"$nulls":6},{"$f":"H24/G24-1","v":{"v":0.9915767631206422,"d":"99%"}},{"$f":"I24/H24-1","v":{"v":0.4330994931746339,"d":"43%"}},{"v":0.3671538175987381,"d":"37%"},{"v":-0.05397882668538423,"d":"-5%"},{"v":-0.046786888643024827,"d":"-5%"}]
[]
["Deliveries"]
["Model S/X / Other Models",{"$nulls":5},{"v":57085,"d":"57,085"},{"v":24390,"d":"24,390"},{"v":66705,"d":"66,705"},{"v":68874,"d":"68,874"},{"v":85133,"d":"85,133"},{"v":50850,"d":"50,850"}]
["Model 3/Y",{"$nulls":5},{"v":442562,"d":"442,562"},{"v":911242,"d":"911,242"},{"v":1247146,"d":"1,247,146"},{"v":1739707,"d":"1,739,707"},{"v":1704093,"d":"1,704,093"},{"v":1585279,"d":"1,585,279"}]
["Total Deliveries( In Mn)",{"$nulls":5},{"$f":"SUM(G35:G36)/10^6","v":{"v":0.499647,"d":"0.50"}},{"v":0.935632,"d":"0.94"},{"v":1.313851,"d":"1.31"},{"v":1.808581,"d":"1.81"},{"v":1.789226,"d":"1.79"},{"$f":"SUM(L35:L36)/10^6","v":{"v":1.636129,"d":"1.64"}},{"$f":"'Market Share '!D32","v":{"v":1.9039463690302634,"d":"1.90"}},{"$f":"'Market Share '!D33","v":{"v":2.2109850197535184,"d":"2"}},{"$f":"'Market Share '!D34","v":{"v":2.567538055215443,"d":"2.57"}},{"$f":"'Market Share '!D35","v":{"v":2.9815903798906818,"d":"2.98"}},{"$f":"'Market Share '!D36","v":{"v":3.4624145785876994,"d":"3.46"}}]
["ARPU( $)",{"$nulls":5},{"$f":"G5*10^6/(G37*10^6)","v":{"v":54510.4844019878,"d":"54,510"}},{"$f":"H5*10^6/(H37*10^6)","v":{"v":50481.38584400705,"d":"50,481"}},{"v":54391.251367164165,"d":"54,391"},{"v":45571.085840225016,"d":"45,571"},{"v":43074.49142813708,"d":"43,074"},{"v":42494.20430785103,"d":"42,494"},{"$f":"L38","v":{"v":42494.20430785103,"d":"42494.2"}},{"$f":"M38","v":{"v":42494.20430785103,"d":"42494.2"}},{"v":42494.20430785103,"d":"42494.2"},{"v":42494.20430785103,"d":"42494.2"},{"v":42494.20430785103,"d":"42494.2"}]
[]
["Tesla Locations",{"$nulls":6},644,963,1208,1359,1553]
[{"$nulls":8},{"$f":"I40/H40-1","v":{"v":0.4953416149068324,"d":"0.50"}},{"v":0.25441329179646943,"d":"0.25"},{"v":0.125,"d":"0.13"},{"$f":"L40/K40-1","v":{"v":0.14275202354672545,"d":"0.14"}}]
["Installed Capacity"]
["California"]
["Model S/X / Other Models",{"$nulls":10},550000]
["Model 3/Y",{"$nulls":10},100000]
["Shanghai"]
["Model 3/Y",{"$nulls":10},950000]
["Berlin"]
["Model 3/Y",{"$nulls":10},375000]
["Texas"]
["Model 3/Y",{"$nulls":10},250000]
["Cyber truck",{"$nulls":10},125000]
["Total Capacity ( In Mn)",{"$nulls":10},{"$f":"SUM(L44:L52)/10^6","v":2.35}]
[]
[]
["Sales Growth"]
["Model S/X / Other Models",{"$nulls":6},{"$f":"H35/G35-1","v":{"v":-0.5727424016817027,"d":"-57%"}},{"$f":"I35/H35-1","v":{"v":1.7349323493234934,"d":"173%"}},{"v":0.03251630312570275,"d":"3%"},{"v":0.2360687632488312,"d":"24%"},{"v":-0.40269930579211355,"d":"-40%"}]
["Model 3/Y",{"$nulls":6},{"$f":"H36/G36-1","v":{"v":1.0590154599807486,"d":"106%"}},{"$f":"I36/H36-1","v":{"v":0.368622166230266,"d":"37%"}},{"v":0.3949505510982676,"d":"39%"},{"v":-0.02047126326444626,"d":"-2%"},{"v":-0.06972272053227146,"d":"-7%"}]
[]
[]
["Energy generation and storage revenue"]
["Capacity"]
["Storage deployed (GWH)",{"$nulls":6},4,6.5,14.7,31.4,46.7,81.4,153,287.6,540,1016]
["Revenue per GWH",{"$nulls":6},{"$f":"H6/H63","v":697.25},{"$f":"I6/I63","v":{"v":601.3846153846154,"d":"601.38"}},{"$f":"J6/J63","v":{"v":410.5442176870749,"d":"410.54"}},{"$f":"K6/K63","v":{"v":321.21019108280257,"d":"321.21"}},{"$f":"L6/L63","v":{"v":273.4689507494646,"d":"273.47"}},{"$f":"L64","v":{"v":273.4689507494646,"d":"273.47"}},{"$f":"M64","v":{"v":273.4689507494646,"d":"273.47"}},{"v":273.4689507494646,"d":"273.47"},{"v":273.4689507494646,"d":"273.47"},{"v":273.4689507494646,"d":"273.47"}]
[]
["Others"]
["Service Growth",{"$nulls":6},{"$f":"H7/G7-1","v":{"v":0.6487424111014743,"d":"65%"}},{"$f":"I7/H7-1","v":{"v":0.6020515518148344,"d":"60%"}},{"v":0.3657855852897718,"d":"37%"},{"v":0.2662579636975597,"d":"27%"},{"v":0.18948167837478636,"d":"19%"},{"$f":"L67","v":{"v":0.18948167837478636,"d":"19%"}},{"$f":"M67","v":{"v":0.18948167837478636,"d":"19%"}},{"v":0.18948167837478636,"d":"19%"},{"v":0.18948167837478636,"d":"19%"},{"v":0.18948167837478636,"d":"19%"}]
["Super Charger Stations",{"$nulls":6},3476,4678,5952,6975,8182]
["Super Charger Connectors",{"$nulls":6},31498,42419,54892,65495,77682]

{"sheet":"Market Share ","index":4,"n_rows":61,"n_cols":11,"rows_kept":61,"merged":[[37,6,37,9]]}
[]
["EV Sales By Region  Vs Tesla Sales"]
["Year","Region","Total EV Sales (All OEMs)","Tesla Sales","% Share"]
[2021,"China",{"v":2989000,"d":"2,989,000"},{"v":484000,"d":"484,000"},{"$f":"D4/C4","v":{"v":0.16192706590833056,"d":"16%"}}]
[{"$f":"A4+1","v":2022},"China",{"v":5670000,"d":"5,670,000"},{"v":439000,"d":"439,000"},{"$f":"D5/C5","v":{"v":0.07742504409171076,"d":"8%"}}]
[{"$f":"A5+1","v":2023},"China",{"v":7750000,"d":"7,750,000"},{"v":603000,"d":"603,000"},{"v":0.07780645161290323,"d":"8%"}]
[2024,"China",{"v":10900000,"d":"10,900,000"},{"v":657000,"d":"657,000"},{"v":0.060275229357798166,"d":"6%"}]
[2025,"China",{"v":12860000,"d":"12,860,000"},{"v":625698,"d":"625,698"},{"v":0.048654587869362366,"d":"5%"}]
[2021,"US",{"v":491330,"d":"491,330"},{"v":352000,"d":"352,000"},{"$f":"D9/C9","v":{"v":0.7164227708464779,"d":"72%"}}]
[{"$f":"A9+1","v":2022},"US",{"v":812453,"d":"812,453"},{"v":491000,"d":"491,000"},{"$f":"D10/C10","v":{"v":0.6043426512056698,"d":"60%"}}]
[{"$f":"A10+1","v":2023},"US",{"v":1189051,"d":"1,189,051"},{"v":625000,"d":"625,000"},{"v":0.5256292623276883,"d":"53%"}]
[2024,"US",{"v":1302034,"d":"1,302,034"},{"v":579000,"d":"579,000"},{"v":0.4446888483710871,"d":"44%"}]
[2025,"US",{"v":1275930,"d":"1,275,930"},{"v":568454,"d":"568,454"},{"v":0.44552130602776013,"d":"45%"}]
[2021,"Europe",{"v":1745524,"d":"1,745,524"},{"v":167000,"d":"167,000"},{"$f":"D14/C14","v":{"v":0.09567327633421253,"d":"10%"}}]
[{"$f":"A14+1","v":2022},"Europe",{"v":2588906,"d":"2,588,906"},{"v":222000,"d":"222,000"},{"$f":"D15/C15","v":{"v":0.08575050619837105,"d":"9%"}}]
[{"$f":"A15+1","v":2023},"Europe",{"v":3009338,"d":"3,009,338"},{"v":238000,"d":"238,000"},{"v":0.07908716136239931,"d":"8%"}]
[2024,"Europe",{"v":2945160,"d":"2,945,160"},{"v":326000,"d":"326,000"},{"v":0.11069008135381439,"d":"11%"}]
[2025,"Europe",{"v":3858088,"d":"3,858,088"},{"v":236357,"d":"236,357"},{"v":0.06126272910312051,"d":"6%"}]
[{"v":2021,"d":"2,021"},"ROW",{"v":1050000,"d":"1050000.00"},{"v":85000,"d":"85000.00"},{"v":0.08095238095238096,"d":"8%"}]
[{"v":2022,"d":"2,022"},"ROW",{"v":1650000,"d":"1650000.00"},{"v":150000,"d":"150000.00"},{"v":0.09090909090909091,"d":"9%"}]
[2023,"ROW",{"v":2200000,"d":"2200000.00"},{"v":200000,"d":"200000.00"},{"v":0.09090909090909091,"d":"9%"}]
[2024,"ROW",{"v":2500000,"d":"2500000.00"},{"v":230000,"d":"230000.00"},{"v":0.092,"d":"9%"}]
[2025,"ROW",{"v":3200000,"d":"3200000.00"},{"v":359491,"d":"359491.00"},{"v":0.1123409375,"d":"11%"}]
[]
["Tesla Share World Wide in Mns"]
["Year","Total EV Sales Worldwide","Aggressive","Tesla Sales","Aggressive","% Share"]
[2021,5.23,null,1,null,{"$f":"D27/B27","v":{"v":0.19120458891013384,"d":"19.12%"}}]
[{"$f":"A27+1","v":2022},9.07,null,1.3,null,{"$f":"D28/B28","v":{"v":0.14332965821389196,"d":"14.33%"}}]
[{"$f":"A28+1","v":2023},11.95,null,1.81,null,{"$f":"D29/B29","v":{"v":0.15146443514644353,"d":"15.15%"}}]
[2024,15.15,null,1.79,null,{"$f":"D30/B30","v":{"v":0.11815181518151815,"d":"11.82%"}}]
[2025,17.999,null,1.64,null,{"$f":"D31/B31","v":{"v":0.09111617312072894,"d":"9.11%"}}]
[{"$f":"A31+1","v":{"v":2026,"d":"2026E"}},{"$f":"B45/10^6","v":{"v":20.89581140010714,"d":"20.896"}},{"$f":"C45/10^6","v":{"v":26.091326099999996,"d":"26.091"}},{"$f":"B32*F32","v":{"v":1.9039463690302634,"d":"1.90"}},{"$f":"C32*F32","v":{"v":2.377341785876993,"d":"2.38"}},{"$f":"F31","v":{"v":0.09111617312072894,"d":"9.11%"}}]
[{"$f":"A32+1","v":{"v":2027,"d":"2027E"}},{"$f":"B46/10^6","v":{"v":24.265560591794863,"d":"24.266"}},{"v":37.832422844999996,"d":"37.832"},{"$f":"B33*F33","v":{"v":2.2109850197535184,"d":"2.21"}},{"$f":"C33*F33","v":{"v":3.44714558952164,"d":"3.45"}},{"$f":"F32","v":{"v":0.09111617312072894,"d":"9.11%"}}]
[{"v":2028,"d":"2028E"},{"v":28.178730155989488,"d":"28.179"},{"v":54.85701312525,"d":"54.857"},{"$f":"B34*F34","v":{"v":2.567538055215443,"d":"2.57"}},{"v":4.998361104806379,"d":"5.00"},{"v":0.09111617312072894,"d":"9.11%"}]
[{"v":2029,"d":"2029E"},{"v":32.72295441930023,"d":"32.723"},{"v":79.54266903161249,"d":"79.543"},{"$f":"B35*F35","v":{"v":2.9815903798906818,"d":"2.98"}},{"v":7.247623601969248,"d":"7.25"},{"v":0.09111617312072894,"d":"9.11%"}]
[{"v":2030,"d":"2030E"},{"v":38,"d":"38.000"},{"v":115.3368700958381,"d":"115.337"},{"$f":"B36*F36","v":{"v":3.4624145785876994,"d":"3.46"}},{"v":10.509054222855408,"d":"10.51"},{"v":0.09111617312072894,"d":"9.11%"}]
[]
["Region wise Share EV",{"$nulls":5},"Share of Global EV Sales"]
["Year","Total EV Sales","Aggressive","China","US","Europe","ROW","China","US","Europe","Row"]
[2021,{"$f":"SUM(D40:F40)","v":5225854},null,{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,D$39,$A$4:$A$23,$A40)","v":2989000},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,E$39,$A$4:$A$23,$A40)","v":491330},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,F$39,$A$4:$A$23,$A40)","v":1745524},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,G$39,$A$4:$A$23,$A40)","v":1050000},{"$f":"D40/SUM($D40:$G40)","v":{"v":0.47626984311617193,"d":"48%"}},{"$f":"E40/SUM($D40:$G40)","v":{"v":0.07828894681106348,"d":"8%"}},{"$f":"F40/SUM($D40:$G40)","v":{"v":0.2781333026549056,"d":"28%"}},{"$f":"G40/SUM($D40:$G40)","v":{"v":0.16730790741785898,"d":"17%"}}]
[{"$f":"A40+1","v":2022},{"$f":"SUM(D41:F41)","v":9071359},null,{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,D$39,$A$4:$A$23,$A41)","v":5670000},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,E$39,$A$4:$A$23,$A41)","v":812453},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,F$39,$A$4:$A$23,$A41)","v":2588906},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,G$39,$A$4:$A$23,$A41)","v":1650000},{"$f":"D41/SUM($D41:$G41)","v":{"v":0.5288508667604546,"d":"53%"}},{"$f":"E41/SUM($D41:$G41)","v":{"v":0.07577891944482038,"d":"8%"}},{"$f":"F41/SUM($D41:$G41)","v":{"v":0.24147181341469864,"d":"24%"}},{"$f":"G41/SUM($D41:$G41)","v":{"v":0.15389840038002645,"d":"15%"}}]
[{"$f":"A41+1","v":2023},{"$f":"SUM(D42:F42)","v":11948389},null,{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,D$39,$A$4:$A$23,$A42)","v":7750000},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,E$39,$A$4:$A$23,$A42)","v":1189051},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,F$39,$A$4:$A$23,$A42)","v":3009338},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,G$39,$A$4:$A$23,$A42)","v":2200000},{"$f":"D42/SUM($D42:$G42)","v":{"v":0.5477655441902255,"d":"55%"}},{"$f":"E42/SUM($D42:$G42)","v":{"v":0.08404144104321701,"d":"8%"}},{"$f":"F42/SUM($D42:$G42)","v":{"v":0.2126982796415903,"d":"21%"}},{"$f":"G42/SUM($D42:$G42)","v":{"v":0.15549473512496723,"d":"16%"}}]
[2024,{"$f":"SUM(D43:F43)","v":15147194},null,{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,D$39,$A$4:$A$23,$A43)","v":10900000},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,E$39,$A$4:$A$23,$A43)","v":1302034},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,F$39,$A$4:$A$23,$A43)","v":2945160},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,G$39,$A$4:$A$23,$A43)","v":2500000},{"$f":"D43/SUM($D43:$G43)","v":{"v":0.6176619353762417,"d":"62%"}},{"$f":"E43/SUM($D43:$G43)","v":{"v":0.07378136150143756,"d":"7%"}},{"$f":"F43/SUM($D43:$G43)","v":{"v":0.16689112161400843,"d":"17%"}},{"$f":"G43/SUM($D43:$G43)","v":{"v":0.14166558150831232,"d":"14%"}}]
[2025,{"$f":"SUM(D44:F44)","v":17994018},null,{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,D$39,$A$4:$A$23,$A44)","v":12860000},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,E$39,$A$4:$A$23,$A44)","v":1275930},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,F$39,$A$4:$A$23,$A44)","v":3858088},{"$f":"SUMIFS($C$4:$C$23,$B$4:$B$23,G$39,$A$4:$A$23,$A44)","v":3200000},{"$f":"D44/SUM($D44:$G44)","v":{"v":0.6067749871685492,"d":"61%"}},{"$f":"E44/SUM($D44:$G44)","v":{"v":0.06020236464836446,"d":"6%"}},{"$f":"F44/SUM($D44:$G44)","v":{"v":0.18203664826556248,"d":"18%"}},{"$f":"G44/SUM($D44:$G44)","v":{"v":0.1509859999175239,"d":"15%"}}]
[{"$f":"A44+1","v":{"v":2026,"d":"2026E"}},{"$f":"B44*(1+B57)","v":{"v":20895811.400107138,"d":"20895811"}},{"$f":"B44*(1+C57)","v":{"v":26091326.099999998,"d":"26091326"}},{"$f":"$B45*H45","v":{"v":12679055.694176432,"d":"12679056"}},{"$f":"$B45*I45","v":{"v":1257977.2575327011,"d":"1257977"}},{"v":3803803.4700648338,"d":"3803803"},{"v":3154974.9783331715,"d":"3154975"},{"$f":"H44","v":{"v":0.6067749871685492,"d":"61%"}},{"$f":"I44","v":{"v":0.06020236464836446,"d":"6%"}},{"v":0.18203664826556248,"d":"18%"},{"v":0.1509859999175239,"d":"15%"}]
[{"$f":"A45+1","v":{"v":2027,"d":"2027E"}},{"$f":"B45*(1+B58)","v":{"v":24265560.591794863,"d":"24265561"}},{"$f":"C45*(1+C58)","v":{"v":37832422.845,"d":"37832423"}},{"$f":"$B46*H46","v":{"v":14723735.21672398,"d":"14723735"}},{"$f":"$B46*I46","v":{"v":1460844.1271442168,"d":"1460844"}},{"$f":"$B46*J46","v":{"v":4417221.318415256,"d":"4417221"}},{"$f":"$B46*K46","v":{"v":3663759.9295114106,"d":"3663760"}},{"$f":"H45","v":{"v":0.6067749871685492,"d":"61%"}},{"$f":"I45","v":{"v":0.06020236464836446,"d":"6%"}},{"$f":"J45","v":{"v":0.18203664826556248,"d":"18%"}},{"$f":"K45","v":{"v":0.1509859999175239,"d":"15%"}}]
[{"v":2028,"d":"2028E"},{"v":28178730.155989487,"d":"28178730"},{"$f":"C46*(1+C59)","v":{"v":54857013.12525,"d":"54857013"}},{"v":17098148.62882653,"d":"17098149"},{"v":1696426.188178743,"d":"1696426"},{"v":5129561.5899760565,"d":"5129562"},{"v":4254593.749008157,"d":"4254594"},{"v":0.6067749871685492,"d":"61%"},{"v":0.06020236464836446,"d":"6%"},{"v":0.18203664826556248,"d":"18%"},{"v":0.1509859999175239,"d":"15%"}]
[{"v":2029,"d":"2029E"},{"v":32722954.419300232,"d":"32722954"},{"v":79542669.03161249,"d":"79542669"},{"v":19855470.247887917,"d":"19855470"},{"v":1969999.2343225218,"d":"1969999"},{"v":5956776.94383619,"d":"5956777"},{"v":4940707.993253604,"d":"4940708"},{"v":0.6067749871685492,"d":"61%"},{"v":0.06020236464836446,"d":"6%"},{"v":0.18203664826556248,"d":"18%"},{"v":0.1509859999175239,"d":"15%"}]
[{"v":2030,"d":"2030E"},{"$f":"38*10^6","v":38000000},{"v":115336870.0958381,"d":"115336870"},{"v":23057449.512404867,"d":"23057450"},{"v":2287689.8566378495,"d":"2287690"},{"v":6917392.634091374,"d":"6917393"},{"v":5737467.996865909,"d":"5737468"},{"v":0.6067749871685492,"d":"61%"},{"v":0.06020236464836446,"d":"6%"},{"v":0.18203664826556248,"d":"18%"},{"v":0.1509859999175239,"d":"15%"}]
["YOY Growth EV Region Wise"]
["Year","Consesus","Aggressive","China","US","Europe","ROW"]
[2021]
[{"$f":"A52+1","v":2022},{"$f":"B41/B40-1","v":{"v":0.7358615453091495,"d":"74%"}},null,{"$f":"D41/D40-1","v":{"v":0.8969555035128807,"d":"90%"}},{"$f":"E41/E40-1","v":{"v":0.6535790609162884,"d":"65%"}},{"$f":"F41/F40-1","v":{"v":0.48316837809162183,"d":"48%"}},{"$f":"G41/G40-1","v":{"v":0.5714285714285714,"d":"57%"}}]
[{"$f":"A53+1","v":2023},{"$f":"B42/B41-1","v":{"v":0.31715534574257287,"d":"32%"}},null,{"$f":"D42/D41-1","v":{"v":0.36684303350970016,"d":"37%"}},{"$f":"E42/E41-1","v":{"v":0.4635320443151789,"d":"46%"}},{"$f":"F42/F41-1","v":{"v":0.16239755325222305,"d":"16%"}},{"$f":"G42/G41-1","v":{"v":0.33333333333333326,"d":"33%"}}]
[2024,{"$f":"B43/B42-1","v":{"v":0.26771851837097027,"d":"27%"}},null,{"$f":"D43/D42-1","v":{"v":0.40645161290322585,"d":"41%"}},{"$f":"E43/E42-1","v":{"v":0.09501947351291062,"d":"10%"}},{"$f":"F43/F42-1","v":{"v":-0.021326285050067506,"d":"-2%"}},{"$f":"G43/G42-1","v":{"v":0.13636363636363646,"d":"14%"}}]
[2025,{"$f":"B44/B43-1","v":{"v":0.1879439848727098,"d":"19%"}},null,{"$f":"D44/D43-1","v":{"v":0.1798165137614678,"d":"18%"}},{"$f":"E44/E43-1","v":{"v":-0.020048631602554212,"d":"-2%"}},{"$f":"F44/F43-1","v":{"v":0.3099756889269174,"d":"31%"}},{"$f":"G44/G43-1","v":{"v":0.28,"d":"28%"}}]
[{"$f":"A56+1","v":{"v":2026,"d":"2026E"}},{"$f":"(B49/B44)^(1/5)-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"45%","v":{"v":0.45,"d":"45%"}},{"$f":"D45/D44-1","v":{"v":-0.01407031927088398,"d":"-1%"}},{"$f":"E45/E44-1","v":{"v":-0.014070319270883869,"d":"-1%"}},{"$f":"F45/F44-1","v":{"v":-0.01407031927088398,"d":"-1%"}},{"$f":"G45/G44-1","v":{"v":-0.014070319270883869,"d":"-1%"}}]
[{"$f":"A57+1","v":{"v":2027,"d":"2027E"}},{"$f":"B57","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"45%","v":{"v":0.45,"d":"45%"}},{"$f":"D46/D45-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"E46/E45-1","v":{"v":0.1612643379653802,"d":"16%"}},{"$f":"F46/F45-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"G46/G45-1","v":{"v":0.16126433796538042,"d":"16%"}}]
[{"v":2028,"d":"2028E"},{"$f":"B58","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"45%","v":{"v":0.45,"d":"45%"}},{"$f":"D47/D46-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"E47/E46-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"F47/F46-1","v":{"v":0.1612643379653802,"d":"16%"}},{"$f":"G47/G46-1","v":{"v":0.16126433796538042,"d":"16%"}}]
[{"v":2029,"d":"2029E"},{"v":0.16126433796538042,"d":"16%"},{"$f":"45%","v":{"v":0.45,"d":"45%"}},{"$f":"D48/D47-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"E48/E47-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"F48/F47-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"G48/G47-1","v":{"v":0.16126433796538042,"d":"16%"}}]
[{"v":2030,"d":"2030E"},{"v":0.16126433796538042,"d":"16%"},{"$f":"45%","v":{"v":0.45,"d":"45%"}},{"$f":"D49/D48-1","v":{"v":0.1612643379653802,"d":"16%"}},{"$f":"E49/E48-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"F49/F48-1","v":{"v":0.16126433796538042,"d":"16%"}},{"$f":"G49/G48-1","v":{"v":0.1612643379653802,"d":"16%"}}]

{"sheet":"Cost Matrix","index":5,"n_rows":17,"n_cols":15,"rows_kept":17,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,5],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4]]}
["Cost Matrix"]
["Year Tracker",{"$nulls":5},"2020-12-31",{"$f":"EOMONTH(G2,12)","v":"2021-12-31"},{"$f":"EOMONTH(H2,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
[{"$nulls":6},"2020-12-31",{"$f":"EOMONTH(G3,12)","v":"2021-12-31"},{"$f":"EOMONTH(H3,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
[]
["Revenue",{"$nulls":5},{"$f":"PL!G9","v":{"v":31536,"d":"31,536"}},{"$f":"PL!H9","v":{"v":53823,"d":"53,823"}},{"$f":"PL!I9","v":{"v":81462,"d":"81,462"}},{"$f":"PL!J9","v":{"v":96773,"d":"96,773"}},{"$f":"PL!K9","v":{"v":97690,"d":"97,690"}},{"$f":"PL!L7","v":{"v":94827,"d":"94,827"}},{"$f":"PL!M9","v":0},{"$f":"PL!N9","v":0},{"$f":"PL!O9","v":0}]
["Cost of Revenue",{"$nulls":5},{"$f":"PL!G10","v":{"v":24906,"d":"24,906"}},{"$f":"PL!H10","v":{"v":40217,"d":"40,217"}},{"$f":"PL!I10","v":{"v":60609,"d":"60,609"}},{"$f":"PL!J10","v":{"v":79113,"d":"79,113"}},{"$f":"PL!K10","v":{"v":80240,"d":"80,240"}},{"$f":"PL!L10","v":{"v":77733,"d":"77,733"}}]
["R&D",{"$nulls":5},{"$f":"PL!G14","v":{"v":1491,"d":"1,491"}},{"$f":"PL!H14","v":{"v":2593,"d":"2,593"}},{"$f":"PL!I14","v":{"v":3075,"d":"3,075"}},{"$f":"PL!J14","v":{"v":3969,"d":"3,969"}},{"$f":"PL!K14","v":{"v":4540,"d":"4,540"}},{"$f":"PL!L14","v":{"v":6411,"d":"6,411"}}]
["SG&A",{"$nulls":5},{"$f":"PL!G15","v":{"v":3145,"d":"3,145"}},{"$f":"PL!H15","v":{"v":4517,"d":"4,517"}},{"$f":"PL!I15","v":{"v":3946,"d":"3,946"}},{"$f":"PL!J15","v":{"v":4800,"d":"4,800"}},{"$f":"PL!K15","v":{"v":5150,"d":"5,150"}},{"$f":"PL!L15","v":{"v":5834,"d":"5,834"}}]
["Other",{"$nulls":5},{"$f":"PL!G16","v":0},{"$f":"PL!H16","v":-27},{"$f":"PL!I16","v":176},{"$f":"PL!J16","v":0},{"$f":"PL!K16","v":684},{"$f":"PL!L16","v":494}]
["Reported Tax",{"$nulls":5},{"$f":"-PL!G34","v":292},{"$f":"-PL!H34","v":699},{"$f":"-PL!I34","v":1132},{"$f":"-PL!J34","v":-5001},{"$f":"-PL!K34","v":1837},{"$f":"-PL!L34","v":-1423}]
[]
["% of Sales"]
["Cost of Revenue",{"$nulls":5},{"$f":"G6/G$5","v":{"v":0.7897640791476408,"d":"79%"}},{"$f":"H6/H$5","v":{"v":0.7472084424874125,"d":"75%"}},{"v":0.74401561464241,"d":"74%"},{"v":0.8175110826366858,"d":"82%"},{"v":0.8213737332377931,"d":"82%"},{"v":0.8197348856338385,"d":"82%"}]
["R&D",{"$nulls":5},{"$f":"G7/G$5","v":{"v":0.047279299847793,"d":"5%"}},{"$f":"H7/H$5","v":{"v":0.04817643015067908,"d":"5%"}},{"$f":"I7/I$5","v":{"v":0.03774766148633719,"d":"4%"}},{"$f":"J7/J$5","v":{"v":0.04101350583323861,"d":"4%"}},{"$f":"K7/K$5","v":{"v":0.04647353874500972,"d":"5%"}},{"$f":"L7/L$5","v":{"v":0.06760732702711253,"d":"7%"}}]
["SG&A",{"$nulls":5},{"$f":"G8/G$5","v":{"v":0.09972729578893963,"d":"10%"}},{"$f":"H8/H$5","v":{"v":0.08392322984597662,"d":"8%"}},{"$f":"I8/I$5","v":{"v":0.048439763325231394,"d":"5%"}},{"$f":"J8/J$5","v":{"v":0.04960061174087814,"d":"5%"}},{"$f":"K8/K$5","v":{"v":0.052717780734977994,"d":"5%"}},{"$f":"L8/L$5","v":{"v":0.061522562139475045,"d":"6%"}}]
["Other",{"$nulls":5},{"$f":"G9/G$5","v":{"v":0,"d":"0%"}},{"$f":"H9/H$5","v":{"v":-5.0164427846831284E-4,"d":"-0%"}},{"$f":"I9/I$5","v":{"v":2.160516559868405E-3,"d":"0%"}},{"$f":"J9/J$5","v":{"v":0,"d":"0%"}},{"$f":"K9/K$5","v":{"v":0.007001740198587368,"d":"1%"}},{"$f":"L9/L$5","v":{"v":0.005209486749554452,"d":"1%"}}]
["Tax Rate",{"$nulls":5},{"$f":"G10/PL!G32","v":{"v":0.2530329289428076,"d":"25%"}},{"$f":"H10/PL!H32","v":{"v":0.11020022071574964,"d":"11%"}},{"$f":"I10/PL!I32","v":{"v":0.08251330271885705,"d":"8%"}},{"$f":"J10/PL!J32","v":{"v":-0.5014539255991176,"d":"-50%"}},{"$f":"K10/PL!K32","v":{"v":0.20433815350389323,"d":"20%"}},{"$f":"L10/PL!L32","v":{"v":-1.5417118093174431,"d":"-154%"}}]

{"sheet":"Asset schedule","index":6,"n_rows":13,"n_cols":15,"rows_kept":13,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,5],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[12,0,12,4],[13,0,13,4]]}
["Asset Schedule"]
["Year Tracker"]
[{"$nulls":6},"2020-12-31",{"$f":"EOMONTH(G3,12)","v":"2021-12-31"},{"$f":"EOMONTH(H3,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
["Revenue",{"$nulls":5},{"$f":"PL!G7","v":{"v":31536,"d":"31,536"}},{"$f":"PL!H7","v":{"v":53823,"d":"53,823"}},{"$f":"PL!I7","v":{"v":81462,"d":"81,462"}},{"$f":"PL!J7","v":{"v":96773,"d":"96,773"}},{"$f":"PL!K7","v":{"v":97690,"d":"97,690"}},{"$f":"PL!L7","v":{"v":94827,"d":"94,827"}}]
["CAPEX (% of sales)",{"$nulls":6},{"$f":"H8/G4","v":{"v":0.20554287163876206,"d":"21%"}},{"v":0.13299147204726605,"d":"13%"},{"v":0.10922884289607425,"d":"11%"},{"$f":"K8/J4","v":{"v":0.11717111177704526,"d":"12%"}},{"$f":"L8/K4","v":{"v":0.08728631384993346,"d":"9%"}}]
[]
["Gross Block",{"$nulls":5},{"$f":"G10-G9-G8","v":{"v":27391,"d":"27,391"}},{"v":35280,"d":"35,280"},{"v":43304,"d":"43,304"},{"v":60161,"d":"60,161"},{"$f":"K10-K9-K8","v":{"v":67959,"d":"67,959"}},{"$f":"K7+L8","v":{"v":76486,"d":"76,486"}}]
["CAPEX",{"$nulls":5},{"$f":"-CF!G26","v":{"v":3157,"d":"3,157"}},{"$f":"-CF!H26","v":{"v":6482,"d":"6,482"}},{"$f":"-CF!I26","v":{"v":7158,"d":"7,158"}},{"$f":"-CF!J26","v":{"v":8898,"d":"8,898"}},{"$f":"-CF!K26","v":{"v":11339,"d":"11,339"}},{"$f":"-CF!L26","v":{"v":8527,"d":"8,527"}}]
["Accumulated Dep",{"$nulls":5},{"v":-5117,"d":"-5,117"},{"v":-6731,"d":"-6,731"},{"v":-9041,"d":"-9,041"},{"v":-12057,"d":"-12,057"},{"v":-15588,"d":"-15,588"},{"$f":"L7-L10","v":{"v":7322,"d":"7,322"}}]
["Net Block",{"$nulls":5},{"$f":"BS!G5","v":{"v":25431,"d":"25,431"}},{"$f":"BS!H5","v":{"v":35031,"d":"35,031"}},{"$f":"BS!I5","v":{"v":41421,"d":"41,421"}},{"$f":"BS!J5","v":{"v":57002,"d":"57,002"}},{"$f":"BS!K5","v":{"v":63710,"d":"63,710"}},{"$f":"BS!L5","v":{"v":69164,"d":"69,164"}}]
[]
["Dep",{"$nulls":5},{"$f":"CF!G7","v":{"v":2322,"d":"2,322"}},{"$f":"CF!H7","v":{"v":2911,"d":"2,911"}},{"$f":"CF!I7","v":{"v":3747,"d":"3,747"}},{"$f":"CF!J7","v":{"v":4667,"d":"4,667"}},{"$f":"CF!K7","v":{"v":5368,"d":"5,368"}}]
["Dep (% of Op. Bl.)",{"$nulls":6},{"$f":"H12/G10","v":{"v":0.11446659588690968,"d":"11%"}},{"$f":"I12/H10","v":{"v":0.10696240472724158,"d":"11%"}},{"v":0.11267231597498853,"d":"11%"},{"v":0.09417213431107681,"d":"9%"}]

{"sheet":"Debt Schedule","index":7,"n_rows":29,"n_cols":17,"rows_kept":29,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,5],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[11,0,11,4],[12,0,12,4],[14,0,14,4],[15,0,15,4]]}
["Debt Schedule"]
[]
[{"$nulls":6},"2020-12-31",{"$f":"EOMONTH(G3,12)","v":"2021-12-31"},{"$f":"EOMONTH(H3,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31",{"$f":"EOMONTH(O3,12)","v":"2029-12-31"},{"$f":"EOMONTH(P3,12)","v":"2030-12-31"}]
["Revenue",{"$nulls":5},{"$f":"PL!G7","v":{"v":31536,"d":"31,536"}},{"$f":"PL!H7","v":{"v":53823,"d":"53,823"}},{"$f":"PL!I7","v":{"v":81462,"d":"81,462"}},{"$f":"PL!J7","v":{"v":96773,"d":"96,773"}},{"$f":"PL!K7","v":{"v":97690,"d":"97,690"}}]
["Beginning Balance",{"$nulls":6},{"v":10570,"d":"10,570"},{"v":5380,"d":"5,380"},{"v":2060,"d":"2,060"},{"v":4680,"d":"4,680"}]
["Interest",{"$nulls":5},{"$f":"-PL!G29","v":748},{"$f":"-PL!H29","v":371},{"$f":"-PL!I29","v":191},{"$f":"-PL!J29","v":156},{"$f":"-PL!K29","v":350}]
["Interest %",{"$nulls":6},{"$f":"H6/H5","v":{"v":0.035099337748344374,"d":"4%"}},{"$f":"I6/I5","v":{"v":0.03550185873605948,"d":"4%"}},{"v":0.07572815533980583,"d":"8%"},{"v":0.07478632478632478,"d":"7%"}]
["Repayment"]
["Closing Debt Balance",{"$nulls":5},{"v":9556,"d":"9,556"},{"v":5245,"d":"5,245"},{"v":1597,"d":"1,597"},{"v":2857,"d":"2,857"},{"v":5757,"d":"5,757"}]
[]
[]
["Accrued liablites and other",{"$nulls":5},{"$f":"BS!G18","v":{"v":3855,"d":"3,855"}},{"$f":"BS!H18","v":{"v":5719,"d":"5,719"}},{"$f":"BS!I18","v":{"v":8205,"d":"8,205"}},{"$f":"BS!J18","v":{"v":9080,"d":"9,080"}},{"$f":"BS!K18","v":{"v":10723,"d":"10,723"}}]
["as a % of Revenue",{"$nulls":5},{"$f":"G12/G4","v":{"v":0.12224124809741248,"d":"12%"}},{"$f":"H12/H4","v":{"v":0.10625568994667707,"d":"11%"}},{"v":0.1007218089415924,"d":"10%"},{"v":0.09382782387649448,"d":"9%"},{"v":0.10976558501381922,"d":"11%"}]
[]
["Other long-term liabilities",{"$nulls":5},{"$f":"BS!G24","v":{"v":3330,"d":"3,330"}},{"$f":"BS!H24","v":{"v":3546,"d":"3,546"}},{"$f":"BS!I24","v":{"v":5330,"d":"5,330"}},{"$f":"BS!J24","v":{"v":8153,"d":"8,153"}},{"$f":"BS!K24","v":{"v":10495,"d":"10,495"}}]
["as a % of Revenue",{"$nulls":5},{"$f":"G15/G4","v":{"v":0.10559360730593607,"d":"11%"}},{"$f":"H15/H4","v":{"v":0.06588261523883841,"d":"7%"}},{"v":0.06542927990965113,"d":"7%"},{"v":0.08424870573403738,"d":"8%"},{"v":0.1074316716142901,"d":"11%"}]
[]
[]
[]
["BOP Debt"]
["Repayment"]
["Raising of Debt"]
["EOP Debt"]
[]
[]
["Repayment as % of Opening debt"]
[]
[]
["Intrest income"]

{"sheet":"WACC","index":8,"n_rows":9,"n_cols":15,"rows_kept":9,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,5],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4]]}
["FCFF"]
["Year Tracker",{"$nulls":5},{"$f":"F2+1","v":1},{"$f":"G2+1","v":2},3,4,5,6,7,8,9]
[{"$nulls":6},"2020-12-31",{"$f":"EOMONTH(G3,12)","v":"2021-12-31"},{"$f":"EOMONTH(H3,12)","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
[]
["FCFF",{"$nulls":5},{"$f":"SUM(G6:G9)","v":{"$error":"#REF!"}},{"$f":"SUM(H6:H9)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(K6:K9)","v":{"$error":"#REF!"}},{"$f":"SUM(L6:L9)","v":{"v":-7883.823565891473,"d":"-7,884"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["NOPAT",{"$nulls":5},{"$f":"PL!#REF!","v":{"$error":"#REF!"}},{"$f":"PL!#REF!","v":{"$error":"#REF!"}},{"$f":"PL!#REF!","v":{"$error":"#REF!"}},{"$f":"PL!#REF!","v":{"$error":"#REF!"}},{"$f":"PL!#REF!","v":{"$error":"#REF!"}},{"$f":"PL!L40","v":{"v":1.1764341085271317,"d":"1"}},{"$f":"PL!#REF!","v":{"$error":"#REF!"}},{"$f":"PL!#REF!","v":{"$error":"#REF!"}},{"$f":"PL!#REF!","v":{"$error":"#REF!"}}]
["Dep",{"$nulls":5},{"$f":"'Asset schedule'!G12","v":{"v":2322,"d":"2,322"}},{"$f":"'Asset schedule'!H12","v":{"v":2911,"d":"2,911"}},{"$f":"'Asset schedule'!I12","v":{"v":3747,"d":"3,747"}},{"$f":"'Asset schedule'!J12","v":{"v":4667,"d":"4,667"}},{"$f":"'Asset schedule'!K12","v":{"v":5368,"d":"5,368"}},{"$f":"'Asset schedule'!L12","v":0},{"$f":"'Asset schedule'!M12","v":0},{"$f":"'Asset schedule'!N12","v":0},{"$f":"'Asset schedule'!O12","v":0}]
["Δ WC",{"$nulls":5},{"$f":"SUM(CF!G15:G23)","v":184},{"$f":"SUM(CF!H15:H23)","v":518},{"$f":"SUM(CF!I15:I23)","v":{"v":-3712,"d":"-3,712"}},{"$f":"SUM(CF!J15:J23)","v":{"v":-2248,"d":"-2,248"}},{"$f":"SUM(CF!K15:K23)","v":81},{"$f":"SUM(CF!L15:L23)","v":642},{"$f":"SUM(CF!M15:M23)","v":0},{"$f":"SUM(CF!N15:N23)","v":0},{"$f":"SUM(CF!O15:O23)","v":0}]
["CAPEX",{"$nulls":5},{"$f":"CF!G26","v":{"v":-3157,"d":"-3,157"}},{"$f":"CF!H26","v":{"v":-6482,"d":"-6,482"}},{"$f":"CF!I26","v":{"v":-7158,"d":"-7,158"}},{"$f":"CF!J26","v":{"v":-8898,"d":"-8,898"}},{"$f":"CF!K26","v":{"v":-11339,"d":"-11,339"}},{"$f":"CF!L26","v":{"v":-8527,"d":"-8,527"}},{"$f":"CF!M26","v":0},{"$f":"CF!N26","v":0},{"$f":"CF!O26","v":0}]

{"sheet":"Valuation","index":9,"n_rows":31,"n_cols":14,"rows_kept":31,"merged":[[1,0,1,5],[17,2,17,5],[17,6,17,9],[17,10,17,13]]}
[]
["(All figures in $ Millions unless stated otherwise)"]
[]
[]
["Capital Structure","Values","%","Cost"]
["Total Equity",{"$f":"BS!L34","v":137806}]
["Total Debt",{"$f":"BS!L25","v":3631}]
["Total",{"$f":"SUM(B6:B7)","v":141437}]
[]
[]
["CAPM"]
["Rf",{"v":0.0416,"d":"4.16%"}]
["Beta",1.88]
["Rm",{"v":0.1056,"d":"10.56%"}]
["Ke",{"$f":"(B14-B12)*B13+(B12)","v":{"v":0.16192,"d":"16%"}}]
["Kd",{"$f":"'Debt Schedule'!L7*(1-0.11)","v":{"v":0,"d":"0%"}}]
["Terminal Growth rate",{"v":0.09,"d":"9%"}]
[null,null,"Explict Forecast",{"$nulls":3},"Linear Growth",{"$nulls":3},"Linear Decline"]
["Year",0,1,2,3,4,5,{"$f":"G19+1","v":6},{"$f":"H19+1","v":7},8,9,10,11,{"$f":"M19+1","v":12}]
["FCFF",null,{"$f":"WACC!L5","v":{"v":-7883.823565891473,"d":"-7,884"}},{"$f":"WACC!M5","v":{"$error":"#REF!"}},{"$f":"WACC!N5","v":{"$error":"#REF!"}},{"$f":"WACC!O5","v":{"$error":"#REF!"}},{"$f":"F20*(1+G22)","v":{"$error":"#REF!"}},{"$f":"G20*(1+H22)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"J20*(1+K22)","v":{"$error":"#REF!"}},{"$f":"K20*(1+L22)","v":{"$error":"#REF!"}},{"$f":"L20*(1+M22)","v":{"$error":"#REF!"}},{"$f":"M20*(1+N22)","v":{"$error":"#REF!"}}]
[{"$nulls":13},{"$f":"N20*(1+$N$22)/(B15-B17)","v":{"$error":"#REF!"}}]
["Growth Rate",null,null,{"$f":"D20/C20-1","v":{"$error":"#REF!"}},{"$f":"E20/D20-1","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F22","v":{"$error":"#REF!"}},{"$f":"G22","v":{"$error":"#REF!"}},{"$f":"H22","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"J22-(J22-N22)/4","v":{"$error":"#REF!"}},{"$f":"K22-(K22-O22)/3","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"v":0.09,"d":"9%"}]
[]
["PV",null,{"$f":"SUM(C20:C21)/(1+B15)^C19","v":{"v":-6785.169001214776,"d":"-6,785"}},{"$f":"SUM(D20:D21)/(1+C15)^D19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Equity Value",{"$f":"SUM(C24:N24)","v":{"$error":"#REF!"}}]
["No. of shares",{"$f":"PL!L49","v":0}]
["Intrinsic Value",{"$f":"B25/B26","v":{"$error":"#REF!"}}]
["CMP",481.2]
["Upside",{"$f":"B27/B28-1","v":{"$error":"#REF!"}}]
[]
["EV","MARKET CAP+ DEBT- CASH"]

{"sheet":"Ref.","index":10,"n_rows":28,"n_cols":1,"rows_kept":28}
["🇮🇳 "]
["India EV Adoption Targets & Trends"]
["India’s official EV adoption target — 30% share of total vehicles sold by 2030 (EV30@30) (NITI Aayog / government report)"]
["https://www.niti.gov.in/sites/default/files/2025-08/Electric-Vehicles-WEB-LOW-Report.pdf  "]
["S&P Global on India’s EV trends and the 30% passenger EV target by 2030"]
["https://www.spglobal.com/automotive-insights/en/blogs/2025/03/india-ev-market-trends-future  "]
["India EV growth and adoption data (7.8% uptake in FY25 vs 30% target)"]
["https://auto.economictimes.indiatimes.com/news/industry/indias-ev-uptake-hits-7-8-in-fy25-are-we-on-track-to-achieve-2030-target/120092840  "]
["India EV industry overview with adoption and targets"]
["https://www.ibef.org/industry/electric-vehicle  "]
[]
[]
["🇪🇺 "]
["European Union EV Targets"]
["EU plan to end sale of new CO₂-emitting cars by 2035 (Fit for 55 deal)"]
["https://ec.europa.eu/commission/presscorner/detail/en/ip_22_6462  "]
[]
["🇬🇧 "]
["United Kingdom EV Sales Mandates"]
["UK Zero Emission Vehicle mandate (80% new cars by 2030 → 100% by 2035)"]
["https://www.gov.uk/government/news/government-sets-out-path-to-zero-emission-vehicles-by-2035  "]
[]
[]
["🌍 "]
[]
["Global EV Adoption & Growth Outlook"]
["IEA Global EV Outlook 2025 — global EV fleet expected to grow ~4× by 2030"]
["https://www.iea.org/reports/global-ev-outlook-2025/outlook-for-electric-mobility  "]