{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dashboard","Detailed Statements"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":11,"defined_names":373,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":19,"n_cols":19,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["USE SCROLL BARS TO PUT A CONDENSE TABLE IN YOUR DASHBOARD"]
[]
[null,"INCOME STATEMENT",2015,2014,"Budget","PY","Bdgt",null,null,"RATIOS",2015,2014,"Budget","PY","Budget",null,null,"www.excelnaccess.com"]
[null,{"$f":"INDEX('Detailed Statements'!B3:B26,Scrollbar1)","v":"Other income"},{"$f":"IFERROR(INDEX('Detailed Statements'!C3:C26,Scrollbar1),\"\")","v":46086421.439999998},{"$f":"IFERROR(INDEX('Detailed Statements'!D3:D26,Scrollbar1),\"\")","v":37330001.366399996},{"$f":"IFERROR(INDEX('Detailed Statements'!E3:E26,Scrollbar1),\"\")","v":34716901.270751998},{"$f":"IFERROR(ABS(C4)/ABS(D4)-1,\"NA\")","v":0.23456790123456805},{"$f":"IFERROR(ABS(C4)/ABS(E4)-1,\"NA\")","v":0.32749236691889028},null,null,{"$f":"INDEX('Detailed Statements'!L3:L22,scrollbar3)","v":"Return on equity (ROE)"},{"$f":"INDEX('Detailed Statements'!M3:M22,scrollbar3)","v":0.10260692721},{"$f":"INDEX('Detailed Statements'!N3:N22,scrollbar3)","v":0.13514083095951221},{"$f":"INDEX('Detailed Statements'!O3:O22,scrollbar3)","v":0.16684053204878049},{"$f":"IFERROR(K4-L4,\"NA\")","v":-3.2533903749512205E-2},{"$f":"IFERROR(K4-M4,\"NA\")","v":-6.4233604838780489E-2},null,null,"Scroll Bars For","Cell Link"]
[null,{"$f":"INDEX('Detailed Statements'!B4:B27,Scrollbar1)","v":"Miscellaneous expenses"},{"$f":"IFERROR(INDEX('Detailed Statements'!C4:C27,Scrollbar1),\"\")","v":0},{"$f":"IFERROR(INDEX('Detailed Statements'!D4:D27,Scrollbar1),\"\")","v":0},{"$f":"IFERROR(INDEX('Detailed Statements'!E4:E27,Scrollbar1),\"\")","v":0},"NA",{"$f":"IFERROR(ABS(C5)/ABS(E5)-1,\"NA\")","v":"NA"},null,null,{"$f":"INDEX('Detailed Statements'!L4:L22,scrollbar3)","v":"Return on invested capital"},{"$f":"INDEX('Detailed Statements'!M4:M23,scrollbar3)","v":1.5417240381435347E-2},{"$f":"INDEX('Detailed Statements'!N4:N23,scrollbar3)","v":1.4294889673922258E-2},{"$f":"INDEX('Detailed Statements'!O4:O23,scrollbar3)","v":1.4746307242572436E-2},{"$f":"IFERROR(K5-L5,\"NA\")","v":1.1223507075130892E-3},{"$f":"IFERROR(K5-M5,\"NA\")","v":6.7093313886291105E-4},null,null,"Income Statement",15]
[null,{"$f":"INDEX('Detailed Statements'!B5:B28,Scrollbar1)","v":"Net other income"},{"$f":"IFERROR(INDEX('Detailed Statements'!C5:C28,Scrollbar1),\"\")","v":18670171.27},{"$f":"IFERROR(INDEX('Detailed Statements'!D5:D28,Scrollbar1),\"\")","v":18296767.844599999},{"$f":"IFERROR(INDEX('Detailed Statements'!E5:E28,Scrollbar1),\"\")","v":19943476.950613998},{"$f":"IFERROR(ABS(C6)/ABS(D6)-1,\"NA\")","v":2.0408163265306145E-2},-6.3845721774948405E-2,null,null,{"$f":"INDEX('Detailed Statements'!L5:L22,scrollbar3)","v":"Gross Profit margin"},{"$f":"INDEX('Detailed Statements'!M5:M24,scrollbar3)","v":0.62457287051523935},{"$f":"INDEX('Detailed Statements'!N5:N24,scrollbar3)","v":0.66621106188292201},{"$f":"INDEX('Detailed Statements'!O5:O24,scrollbar3)","v":0.65375851867015711},-4.1638191367682653E-2,-2.9185648154917754E-2,null,null,"Balance Sheet",20]
[null,{"$f":"INDEX('Detailed Statements'!B6:B29,Scrollbar1)","v":"Net income before Tax"},{"$f":"IFERROR(INDEX('Detailed Statements'!C6:C29,Scrollbar1),\"\")","v":1087569272.0999999},{"$f":"IFERROR(INDEX('Detailed Statements'!D6:D29,Scrollbar1),\"\")","v":957060959.44799984},{"$f":"IFERROR(INDEX('Detailed Statements'!E6:E29,Scrollbar1),\"\")","v":937919740.25903976},0.13636363636363646,0.15955473098330253,null,null,{"$f":"INDEX('Detailed Statements'!L6:L24,scrollbar3)","v":"EBITDA margin"},{"$f":"INDEX('Detailed Statements'!M6:M25,scrollbar3)","v":0.44306208446027179},{"$f":"INDEX('Detailed Statements'!N6:N25,scrollbar3)","v":0.53167450135232608},{"$f":"INDEX('Detailed Statements'!O6:O25,scrollbar3)","v":0.47204745447169133},-8.8612416892054291E-2,-2.8985370011419542E-2,null,null,"Ratios",1]
[null,{"$f":"INDEX('Detailed Statements'!B7:B30,Scrollbar1)","v":"Tax"},{"$f":"IFERROR(INDEX('Detailed Statements'!C7:C30,Scrollbar1),\"\")","v":61500000},{"$f":"IFERROR(INDEX('Detailed Statements'!D7:D30,Scrollbar1),\"\")","v":54120000},{"$f":"IFERROR(INDEX('Detailed Statements'!E7:E30,Scrollbar1),\"\")","v":53037600},0.13636363636363646,0.15955473098330231,null,null,{"$f":"INDEX('Detailed Statements'!L7:L25,scrollbar3)","v":"EBIT margin"},{"$f":"INDEX('Detailed Statements'!M7:M26,scrollbar3)","v":0.30235631904846033},{"$f":"INDEX('Detailed Statements'!N7:N26,scrollbar3)","v":0.35274903888987036},{"$f":"INDEX('Detailed Statements'!O7:O26,scrollbar3)","v":0.32307855898324578},-5.0392719841410027E-2,-2.0722239934785447E-2,null,null,"Cash Flow",12]
[null,{"$f":"INDEX('Detailed Statements'!B8:B31,Scrollbar1)","v":"Current Tax"},{"$f":"IFERROR(INDEX('Detailed Statements'!C8:C31,Scrollbar1),\"\")","v":31500006},{"$f":"IFERROR(INDEX('Detailed Statements'!D8:D31,Scrollbar1),\"\")","v":64120000},{"$f":"IFERROR(INDEX('Detailed Statements'!E8:E31,Scrollbar1),\"\")","v":43039600},-0.50873353087960083,-0.26811573527635013,null,null,{"$f":"INDEX('Detailed Statements'!L8:L26,scrollbar3)","v":"Net profitt Margin"},{"$f":"INDEX('Detailed Statements'!M8:M27,scrollbar3)","v":0.29024117239876884},{"$f":"INDEX('Detailed Statements'!N8:N27,scrollbar3)","v":0.34828940687852261},{"$f":"INDEX('Detailed Statements'!O8:O27,scrollbar3)","v":0.3255041185780585},-5.8048234479753769E-2,-3.5262946179289656E-2]
[null,{"$f":"INDEX('Detailed Statements'!B9:B32,Scrollbar1)","v":"Deferred Tax"},{"$f":"IFERROR(INDEX('Detailed Statements'!C9:C32,Scrollbar1),\"\")","v":61500000},{"$f":"IFERROR(INDEX('Detailed Statements'!D9:D32,Scrollbar1),\"\")","v":54735000},{"$f":"IFERROR(INDEX('Detailed Statements'!E9:E32,Scrollbar1),\"\")","v":50356200},{"$f":"IFERROR(ABS(C10)/ABS(D10)-1,\"NA\")","v":0.12359550561797761},0.22129946262823652,null,null,{"$f":"INDEX('Detailed Statements'!L9:L27,scrollbar3)","v":"Fixed assets turnover"},{"$f":"INDEX('Detailed Statements'!M9:M28,scrollbar3)","v":9.3624327476186847E-2},{"$f":"INDEX('Detailed Statements'!N9:N28,scrollbar3)","v":9.5052933746338567E-2},{"$f":"INDEX('Detailed Statements'!O9:O28,scrollbar3)","v":0.11240584201913943},-1.4286062701517194E-3,-1.8781514542952585E-2,null,null,"Maximum Value For Each Scroll Bar is determined as Follows"]
[]
[null,"BALANCE SHEET",2015,2014,"Budget","PY","Bdgt",null,null,"CASH FLOW",2015,2014,"Budget","PY","Bdgt",null,null,"Example Scroll Bar for \"Ratios\""]
[null,{"$f":"INDEX('Detailed Statements'!G3:G46,scrollbar2)","v":"Accrued expenses"},{"$f":"INDEX('Detailed Statements'!H3:H46,scrollbar2)","v":5502076232},{"$f":"INDEX('Detailed Statements'!I3:I46,scrollbar2)","v":4456681747.9200001},{"$f":"INDEX('Detailed Statements'!J3:J46,scrollbar2)","v":3699045850.7735996},{"$f":"IFERROR(ABS(C13)/ABS(D13)-1,\"NA\")","v":0.23456790123456783},{"$f":"IFERROR(ABS(C13)/ABS(E13)-1,\"NA\")","v":0.48743120630670855},null,null,{"$f":"INDEX('Detailed Statements'!Q3:Q29,scrollbar4)","v":"Interest Received"},{"$f":"INDEX('Detailed Statements'!R3:R29,scrollbar4)","v":7148496.5481511736},{"$f":"INDEX('Detailed Statements'!S3:S29,scrollbar4)","v":4142902.1651883665},{"$f":"INDEX('Detailed Statements'!T3:T29,scrollbar4)","v":3728611.9486695295},{"$f":"IFERROR(ABS(K13)/ABS(L13)-1,\"NA\")","v":0.72548041520699313},{"$f":"IFERROR(ABS(K13)/ABS(M13)-1,\"NA\")","v":0.91720046134110378},null,null,"No of rows in Original Table",{"$f":"ROWS('Detailed Statements'!L3:L22)","v":20}]
[null,{"$f":"INDEX('Detailed Statements'!G4:G47,scrollbar2)","v":"Unearned revenue - current"},{"$f":"INDEX('Detailed Statements'!H4:H47,scrollbar2)","v":1249306740},{"$f":"INDEX('Detailed Statements'!I4:I47,scrollbar2)","v":1099389931.2},{"$f":"INDEX('Detailed Statements'!J4:J47,scrollbar2)","v":1165353327.072},0.13636363636363624,{"$f":"IFERROR(ABS(C14)/ABS(E14)-1,\"NA\")","v":7.2041166380788946E-2},null,null,{"$f":"INDEX('Detailed Statements'!Q4:Q30,scrollbar4)","v":"investment held to maturity "},{"$f":"INDEX('Detailed Statements'!R4:R30,scrollbar4)","v":238417471.48276839},{"$f":"INDEX('Detailed Statements'!S4:S30,scrollbar4)","v":81980109.246551603},{"$f":"INDEX('Detailed Statements'!T4:T30,scrollbar4)","v":73782098.321896449},1.9082355912180873,{"$f":"IFERROR(ABS(K14)/ABS(M14)-1,\"NA\")","v":2.2313728791312077},null,null,"No of rows in condensed Report",{"$f":"ROWS(J4:J10)","v":7}]
[null,{"$f":"INDEX('Detailed Statements'!G5:G48,scrollbar2)","v":"Derivatives - current liability"},{"$f":"INDEX('Detailed Statements'!H5:H48,scrollbar2)","v":0},{"$f":"INDEX('Detailed Statements'!I5:I48,scrollbar2)","v":0},{"$f":"INDEX('Detailed Statements'!J5:J48,scrollbar2)","v":0},"NA","NA",null,null,{"$f":"INDEX('Detailed Statements'!Q5:Q31,scrollbar4)","v":"Investments in equity and other "},{"$f":"INDEX('Detailed Statements'!R5:R31,scrollbar4)","v":0},{"$f":"INDEX('Detailed Statements'!S5:S31,scrollbar4)","v":0},{"$f":"INDEX('Detailed Statements'!T5:T31,scrollbar4)","v":0},"NA","NA",null,null,"Maximum Value",{"$f":"S13-S14+1","v":14}]
[null,{"$f":"INDEX('Detailed Statements'!G6:G49,scrollbar2)","v":"Borrowings ST"},{"$f":"INDEX('Detailed Statements'!H6:H49,scrollbar2)","v":1054444445},{"$f":"INDEX('Detailed Statements'!I6:I49,scrollbar2)","v":1001722222.75},{"$f":"INDEX('Detailed Statements'!J6:J49,scrollbar2)","v":861481111.56500006},5.2631578947368363E-2,0.22399020807833536,null,null,{"$f":"INDEX('Detailed Statements'!Q6:Q32,scrollbar4)","v":"Investments in Joint Ventures"},{"$f":"INDEX('Detailed Statements'!R6:R32,scrollbar4)","v":0},{"$f":"INDEX('Detailed Statements'!S6:S32,scrollbar4)","v":0},{"$f":"INDEX('Detailed Statements'!T6:T32,scrollbar4)","v":0},"NA","NA"]
[null,{"$f":"INDEX('Detailed Statements'!G7:G50,scrollbar2)","v":"Total current liabilities"},{"$f":"INDEX('Detailed Statements'!H7:H50,scrollbar2)","v":25969482113},{"$f":"INDEX('Detailed Statements'!I7:I50,scrollbar2)","v":24411313186.220001},{"$f":"INDEX('Detailed Statements'!J7:J50,scrollbar2)","v":23190747526.909},6.3829787234042534E-2,0.11982082866741317,null,null,{"$f":"INDEX('Detailed Statements'!Q7:Q33,scrollbar4)","v":"Investments in Subsidiaries"},{"$f":"INDEX('Detailed Statements'!R7:R33,scrollbar4)","v":0},{"$f":"INDEX('Detailed Statements'!S7:S33,scrollbar4)","v":0},{"$f":"INDEX('Detailed Statements'!T7:T33,scrollbar4)","v":0},"NA","NA"]
[null,{"$f":"INDEX('Detailed Statements'!G8:G51,scrollbar2)","v":"Other Payables - non current"},{"$f":"INDEX('Detailed Statements'!H8:H51,scrollbar2)","v":0},{"$f":"INDEX('Detailed Statements'!I8:I51,scrollbar2)","v":0},{"$f":"INDEX('Detailed Statements'!J8:J51,scrollbar2)","v":0},"NA","NA",null,null,{"$f":"INDEX('Detailed Statements'!Q8:Q34,scrollbar4)","v":"Other Investments"},{"$f":"INDEX('Detailed Statements'!R8:R34,scrollbar4)","v":0},{"$f":"INDEX('Detailed Statements'!S8:S34,scrollbar4)","v":0},{"$f":"INDEX('Detailed Statements'!T8:T34,scrollbar4)","v":0},"NA","NA"]
[null,{"$f":"INDEX('Detailed Statements'!G9:G52,scrollbar2)","v":"Unearned revenue-Non current"},{"$f":"INDEX('Detailed Statements'!H9:H52,scrollbar2)","v":25969482113},{"$f":"INDEX('Detailed Statements'!I9:I52,scrollbar2)","v":27527651039.779999},{"$f":"INDEX('Detailed Statements'!J9:J52,scrollbar2)","v":22572673852.619598},{"$f":"IFERROR(ABS(C19)/ABS(D19)-1,\"NA\")","v":-5.6603773584905648E-2},0.15048320294523698,null,null,{"$f":"INDEX('Detailed Statements'!Q9:Q35,scrollbar4)","v":"Proceeds from sale of PPE "},{"$f":"INDEX('Detailed Statements'!R9:R35,scrollbar4)","v":-203268417.34930295},{"$f":"INDEX('Detailed Statements'!S9:S35,scrollbar4)","v":-96026256.721468866},{"$f":"INDEX('Detailed Statements'!T9:T35,scrollbar4)","v":-76821005.377175093},{"$f":"IFERROR(ABS(K19)/ABS(L19)-1,\"NA\")","v":1.1168003865744529},1.6460004832180659]

{"sheet":"Detailed Statements","index":1,"n_rows":46,"n_cols":20,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INCOME STATEMENT",2015,2014,"Budget",null,"BALANCE SHEET",2015,2014,"Budget",null,"RATIOS",2015,2014,"Budget",null,"CASHFLOWS",2015,2014,"Budget"]
[null,"Sales",3535229904.2199998,3181706913.7979999,3404426397.7638597,null,"Cash and bank",1101719633,1156805614.6500001,1145237558.5035,null,"Return on equity (ROE)",{"$f":"'Detailed Statements'!C26/'Detailed Statements'!H43","v":0.10260692721},0.13514083095951221,0.16684053204878049,null,"Cash Flow from Operations",12497751981.484484,11585434483.367735,10426891035.030962]
[null,"Cost of Goods Sold",1327221215.01,1433398912.2107999,1447732901.3329079,null,"Short term investments",8249000000,8166510000,8248175100,null,"Return on invested capital",{"$f":"'Detailed Statements'!C12/('Detailed Statements'!H18-'Detailed Statements'!H26)","v":1.5417240381435347E-2},1.4294889673922258E-2,1.4746307242572436E-2,null,"Net income",6641422444.2302122,5975147235.0023203,4780117788.0018559]
[null,"Gross Profit",2208008689.21,2119688341.6416001,2225672758.72368,null,"Debtors",19033810459,20937191504.900002,22402794910.243004,null,"Gross Profit margin",{"$f":"'Detailed Statements'!C5/'Detailed Statements'!C3","v":0.62457287051523935},0.66621106188292201,0.65375851867015711,null,"Non Cash and Other Items",5917049256.6278095,6487380748.2496738,6487380748.2496738]
[null,"Admin & General   Expenses",156917549.65000001,171040129.11849999,147094511.04190999,null,"Inventories",0,0,0,null,"EBITDA margin",{"$f":"'Detailed Statements'!C11/'Detailed Statements'!C3","v":0.44306208446027179},0.53167450135232608,0.47204745447169133,null,"Working Capital and other changes",54682099.550934076,-647546418.49016571,-582791776.64114916]
[null,"Selling And Marketing Expenses",484764809.14999998,475069512.96699995,494072293.48567992,null,"Other current assets",2434295015,2069150762.75,2131225285.6324999,null,"EBIT margin",{"$f":"'Detailed Statements'!C12/'Detailed Statements'!C3","v":0.30235631904846033},0.35274903888987036,0.32307855898324578,null,"End of service benefits ",-115401818.92447136,-229547081.39409375,-206592373.25468439]
[null,"Distribution Expenses",497427229.57999998,477530140.39679998,391574715.12537599,null,"Total current assets",39033810459,40595162877.360001,44248727536.322403,null,"Net profitt Margin",{"$f":"'Detailed Statements'!C26/'Detailed Statements'!C3","v":0.29024117239876884},0.34828940687852261,0.3255041185780585,null,"Paid Gratuity",0,0,0]
[null,"Provisions",0,0,0,null,"Fixed Assets",34485893044,30002726948.279999,27302481522.934799,null,"Fixed assets turnover",{"$f":"'Detailed Statements'!C3/('Detailed Statements'!H9+'Detailed Statements'!H10)","v":9.3624327476186847E-2},9.5052933746338567E-2,0.11240584201913943,null,"Tax paid",-32442342,-45435345,-34654234]
[null,"Total Operating expenses",1139109588.3800001,1173282876.0314002,1149817218.5107722,null,"Intangible assets",3273843122,3470273709.3200002,2984435390.0152001,null,"Revenue growth (YOY)",{"$f":"'Detailed Statements'!C3/'Detailed Statements'!D3-1","v":0.11111111111111116},-6.5420560747663559E-2,-7.1308411214953279E-2,null,"Cash Flow from Investing Activities",-4504454067.5131245,-1141225466.2084389,-1141225466.2084389]
[null,"EBITDA",1566326330.4100001,1691632436.8427999,1607050815.0006597,null,"Investments in Associates",1425324075,1439577315.75,1554743501.01,null,"Gross Profit growth (YOY)",{"$f":"'Detailed Statements'!C5/'Detailed Statements'!D5-1","v":4.1666666666666519E-2},-4.7619047619047561E-2,-4.6666666666666606E-2,null,"Capital expenditures ",-327214368.04540014,-416650114.56904405,-333320091.65523523]
[null,"Operating income",1068899100.83,1122344055.8715,1099897174.75407,null,"Investment in Subsidiaries",4554894985,3780562837.5500002,3364700925.4195004,null,"EBITDA growth (YOY)",{"$f":"'Detailed Statements'!C11/'Detailed Statements'!D11-1","v":-7.4074074074073959E-2},5.2631578947368585E-2,4.7894736842105413E-2,null,"Dividends recieved ",0,0,0]
[null,"Cost of early retirement",0,0,0,null,"Investment in Joint Ventures",17135798765,17649872727.950001,16767379091.5525,null,"EBIT growth (YOY)",{"$f":"'Detailed Statements'!C12/'Detailed Statements'!D12-1","v":-4.7619047619047561E-2},2.0408163265306145E-2,1.6530612244897977E-2,null,"Intangible assets net ",-518498996.60236019,-504063511.78296989,-504063511.78296983]
[null,"Finance Income",20533150.280000001,18479835.252,19403827.014600001,null,"Other Investment",33483954,32814274.920000002,30517275.6756,null,"Net profit growth (YOY)",{"$f":"'Detailed Statements'!C26/'Detailed Statements'!D26-1","v":-7.407407407407407E-2},0,0,null,"Interest Received",7148496.5481511736,4142902.1651883665,3728611.9486695295]
[null,"Investment Income",50264750.68,46746218.132399999,48148604.676371992,null,"Derivatives",33483954,36832349.399999999,34254084.942000002,null,"Shareholders' Equity growth (YOY)",{"$f":"'Detailed Statements'!H43/'Detailed Statements'!I43-1","v":0.21951219512195119},0.23456790123456783,0.24864197530864188,null,"investment held to maturity ",238417471.48276839,81980109.246551603,73782098.321896449]
[null,"Finance Cost",6041308.25,5074698.93,4567229.0369999995,null,"Other non current assets",3572834696,2893996103.7600002,3038695908.9480004,null,"Total Debt %age",0.4,0.33200000000000002,0.34860000000000002,null,"Investments in equity and other ",0,0,0]
[null,"Other income",46086421.439999998,37330001.366399996,34716901.270751998,null,"Total non current assets",64482072641,61257969008.949997,62483128389.128998,null,"Total Equity %age",{"$f":"100%-M16","v":0.6},0.66799999999999993,0.65139999999999998,null,"Investments in Joint Ventures",0,0,0]
[null,"Miscellaneous expenses",0,0,0,null,"Total assets",95300897748,102924969567.84,97778721089.447983,null,"Current ratio",{"$f":"'Detailed Statements'!H8/'Detailed Statements'!H26","v":1.5030646467709172},1.5932485255771724,1.497653614042542,null,"Investments in Subsidiaries",0,0,0]
[null,"Net other income",18670171.27,18296767.844599999,19943476.950613998,null,"Trade Payables",14750883082,14160847758.719999,15152107101.8304,null,"Debt to Equity ratio",0.6,0.65399999999999991,0.71285999999999983,null,"Other Investments",0,0,0]
[null,"Net income before Tax",1087569272.0999999,957060959.44799984,937919740.25903976,null,"Dividend Payable",1055492612,1013272907.52,841016513.24160004,null,"Total Capital to Equity ratio",0.8,0.76800000000000013,0.67584000000000022,null,"Proceeds from sale of PPE ",-203268417.34930295,-96026256.721468866,-76821005.377175093]
[null,"Tax",61500000,54120000,53037600,null,"Other payables - current",2357279002,2262987841.9200001,2127208571.4048002,null,"Interest coverage",{"$f":"'Detailed Statements'!C12/'Detailed Statements'!C16","v":176.93172680437223},221.1646585054653,240.82373926150666,null,"Short term investments",-3701038253.5469809,-210608594.54669601,-210608594.54669601]
[null,"Current Tax",31500006,64120000,43039600,null,"Accrued expenses",5502076232,4456681747.9200001,3699045850.7735996,null,"Average Finance Cost (Finance expense / total debt)",0.05,0.06,7.0000000000000007E-2,null,"Cash Flow from Financing Activities",-10792240096.667095,-11628550236.031597,-9302840188.8252773]
[null,"Deferred Tax",61500000,54735000,50356200,null,"Unearned revenue - current",1249306740,1099389931.2,1165353327.072,null,null,null,null,null,null,"Acquisition of additional shareholding in a subsidiary",0,0,0]
[null,"Net income before minority interest",1026069272.1,1056851350.263,1014577296.25248,null,"Derivatives - current liability",0,0,0,null,null,null,null,null,null,"Capital increase ",0,0,0]
[null,"Minority Interest",0,0,0,null,"Borrowings ST",1054444445,1001722222.75,861481111.56500006,null,null,null,null,null,null,"Cash flows from financing activities ",-5396120048.3335457,-5814275118.0158005,-5814275118.0158005]
[null,"Net income for the year",1026069272.1,1108154813.868,1108154813.868,null,"Total current liabilities",25969482113,24411313186.220001,23190747526.909,null,null,null,null,null,null,"Dividends paid ",-4210210179.4093738,-4735696021.4458981,-4262126419.3013086]
[null,null,null,null,null,null,"Other Payables - non current",0,0,0,null,null,null,null,null,null,"Murabahas and Loans net",-1166052068.6138394,-1066071685.7914544,-959464517.21230912]
[null,null,null,null,null,null,"Unearned revenue-Non current",25969482113,27527651039.779999,22572673852.619598,null,null,null,null,null,null,"Paid Finance costs",-19857800.310335129,-12507410.778444352,-11256669.700599916]
[null,null,null,null,null,null,"Borrowings LT",null,0,0,null,null,null,null,null,null,"Shareholders Loan",0,0,0]
[null,null,null,null,null,null,"Derivative Liability - non current",null,0,0]
[null,null,null,null,null,null,"Long Term Provisions",47125000,49010000,47539700]
[null,null,null,null,null,null,"Defined Benfit Liability",30570313,30876016.129999999,32419816.936500002]
[null,null,null,null,null,null,"Total non current liabilities",4481388887,4481388887,3809180553.9499998]
[null,null,null,null,null,null,"Total liabilities",0,0,0]
[null,null,null,null,null,null,"Paid Up Capital",2837653067,2951159189.6799998,2656043270.7119999]
[null,null,null,null,null,null,"Share Premiun",7396737267,6213259304.2799997,5219137815.5951996]
[null,null,null,null,null,null,"Shareholder Loans",4396737267,4220867776.3200002,4600745876.1887999]
[null,null,null,null,null,null,"Hedging reserves-net of tax",33366219380,35701854736.599998,30703595073.476002]
[null,null,null,null,null,null,"Other Reserves",2766757267,2683754548.9899998,2952130003.8889995]
[null,null,null,null,null,null,"Retained earnings",null,0,0]
[null,null,null,null,null,null,"Unrealized loss on investments",20000000000,16600000000,14940000000]
[null,null,null,null,null,null,"Exchange fluctuation reserve",0,0,0]
[null,null,null,null,null,null,"Total shareholders' equity",10000000000,8200000000,6642000000]
[null,null,null,null,null,null,"Minority Interest",0,0,0]
[null,null,null,null,null,null,"Total Equity",0,0,0]
[null,null,null,null,null,null,"Total liabilities and equity",31948050535,34184414072.450001,35209946494.623505]