{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["CFS wks","25","31.a.1.2009","37","NCI_TSB","TSC_IP_ext","MEDH_IP_ext","CTA_IP_ext","ASTLOG_IP_ext","Sheet4","Acquisition","names","codes","ФО1","ФО2","ФО3","ФО4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"defined_names":6,"comments":1,"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":"CFS wks","index":0,"n_rows":507,"n_cols":11,"rows_kept":507,"cut":false,"hidden":true,"merged":[[442,0,443,0],[442,2,443,2],[472,0,473,0],[472,2,473,2],[204,0,205,0],[223,0,224,0],[242,0,243,0],[291,1,291,3],[340,3,340,4],[52,9,54,9],[169,0,170,0],[340,5,340,6],[36,0,37,0],[52,0,54,0],[52,3,54,3],[52,6,54,6]]}
[]
[]
[]
["Depreciation workings"]
[null,null,"PPE",null,"IA"]
["COS",391997,342656,null,49341]
["Selling",85134,85134,null,0]
["G&A",699147,598586,null,100561]
[null,1176278,8721]
[null,null,1035097,null,149902]
["PPE",-1035097,0,null,0]
["IA",-149902]
[null,-1184999]
[null,-8721]
[null,null,null,"IA"]
[null,null,null,"COS","Selling","Adm"]
[null,"Tsesna Corporation JSC",null,null,null,11738]
[null,"Tsesnabank JSC",null,null,null,87588]
[null,"Tsesna Capital LLC"]
[null,"Medet Holding LLC",null,null,null,31]
[null,"Info-Tses LLC",null,1702,null,66]
[null,"Concern Tsesna Astyk LLC",null,47639]
[null,"Zhaltyr Elevator LLC",null,null,null,68]
[null,"Tsesna Astyk Bread plant LLC",null,null,null,165]
[null,"Akmola Dirmen LLC"]
[null,"Elevator Tsesna Astyk LLC",null,null,null,133]
[null,"Alma-Tses LLC",null,null,null,189]
[null,"Tsesna Mak LLC"]
[null,"Astyk Logistic LLC",null,null,null,559]
[null,"Football Club Tsesna LLC",null,null,null,24]
[null,null,null,49341,0,100561]
[]
[]
["IP"]
[]
[]
[null,2009]
[null,"’000 KZT"]
[]
["At 1 January",20289376]
["Additions",95495]
["Transfer from advances paid",284475]
["Transfer from inventory",12215]
["Transfer (to)/from property, plant and equipment",-65782]
["Change in fair value",835194]
["Disposals",-139546]
["At 31 December",21311427]
[]
[]
["Impairment losses"]
[]
[]
["’000 KZT","Placements with banks and other financial ","Amounts receivable under reverse repur-chase agreements","Held-to-maturity investments (Note 21)","Loans to customers","Trade and other receivables","Investment in associate","Property, plant and equipment","Trade and other payables ","Total"]
[null,"institutions ","(Note 18)",null,"(Note 22)","(Note 23)",null,"(Note 26)","(Note 31)"]
[null,"(Note 17)"]
[]
["2009-01-01",50000,"-","-",6224005,583778,"-","-",159173,7016956]
["Net charge","-","-",288180,3217301,500680,75051,15406,-70000,4026618]
["Write-offs",-1870,"-","-",-658103,-15594,"-","-","-",-675567]
["2009-12-31",48130,"-",288180,8783203,1068864,75051,15406,89173,10383601]
[]
[]
[]
["PPE"]
[]
["’000 KZT ","Land and buildings","Equipment and other","Construction in progress","Total"]
["Cost"]
["Balance at 31 December 2008",7719712,5108350,3143268,15971330]
["Additions",117127,326753,3463159,3907039]
["Disposals",-5672375,-123185,-40,-5795600]
["Acquisition of subsidiary (Note 6)",534488,42313,"-",576801]
["Disposal of subsidiaries (Note 6)","-",-32315,"-",-32315]
["Transfer to inventory","-","-",-179369,-179369]
["Transfer from/(to) investment property",140849,"-",-71936,68913]
["Transfers",975510,108686,-1084196,"-"]
["Balance at 31 December 2009",3815311,5430602,5270886,14516799]
[]
["Depreciation and impairment losses"]
["Balance at 31 December 2008",-708944,-886262,"-",-1595206]
["Depreciation charge",-291732,-743365,"-",-1035097]
["Impairment losses",-15406,"-","-",-15406]
["Disposals",168133,68748,"-",236881]
["Acquisition of subsidiary (Note 6)",-15,-1398,"-",-1413]
["Disposal of subsidiaries (Note 6)","-",7069,"-",7069]
["Transfer from investment property",-3131,"-","-",-3131]
["Balance at 31 December 2009",-851095,-1555208,"-",-2406303]
["Net book value"]
["At 31 December 2008",7010768,4222088,3143268,14376124]
["At 31 December 2009",2964216,3875394,5270886,12110496]
[]
[]
[]
["Proceeds from disposal of PPE"]
[{"$f":"B111","v":5608724}]
[]
[]
["Tsesna Corporation JSC",54032]
["Tsesnabank JSC",{"$f":"4653909+873068","v":5526977}]
["Tsesna Capital LLC",0]
["Medet Holding LLC",410]
["Info-Tses LLC",0]
["Concern Tsesna Astyk LLC",10719]
["Zhaltyr Elevator LLC",3604]
["Tsesna Astyk Bread plant LLC",2129]
["Akmola Dirmen LLC",0]
["Elevator Tsesna Astyk LLC",0]
["Alma-Tses LLC",10100]
["Tsesna Mak LLC",0]
["Astyk Logistic LLC",753]
["Football Club Tsesna LLC",0]
[null,{"$f":"SUM(B97:B110)","v":5608724},"> CFS"]
[]
["Cash receivable for sale of PPE in Tsesnabank (to be eliminated through Trade and other receivables). Receivables for non-current assets sold in the rest companies are not material."]
[null,873068,"> CFS"]
[]
["Cash payable for acquisition of PPE in Tsesnabank (to be adjusted with trade payables). Payables for non-current assets in the rest companies are not material."]
[]
[null,263056,"> CFS"]
[]
[]
["Cash payable for acquisition of Intangibes in Tsesnabank (to be adjusted with trade payables). Payables for non-current assets in the rest companies are not material."]
[null,98698,"> CFS"]
[]
[]
["Intangible assets"]
[]
["’000 KZT ","Patents and Trademarks","Computer software","Other","Total"]
["Cost"]
["Balance at 31 December 2008",319450,452515,49342,821307]
["Additions",465,338667,16324,355456]
["Acquisition of subsidiary (Note 6)","-","-",118,118]
["Disposal of subsidiaries (Note 6)","-","-",-451,-451]
["Disposals","-",-7353,-1514,-8867]
["Balance at 31 December 2009",319915,783829,63819,1167563]
[]
["Amortisation"]
["Balance at 31 December 2008",-102144,-254060,-12223,-368427]
["Amortisation charge ",-47639,-88147,-14116,-149902]
["Acquisition of subsidiary (Note 6)","-","-",-100,-100]
["Disposal of subsidiaries (Note 6)","-","-",73,73]
["Disposals","-",7305,323,7628]
["Balance at 31 December 2009",-149783,-334902,-26043,-510728]
["Net book value"]
["At 31 December 2008",217306,198455,37119,452880]
["At 31 December 2009",170132,448927,37776,656835]
[]
[]
[]
["Proceeds from disposal of IA"]
[]
["Tsesna Corporation JSC",0]
["Tsesnabank JSC",0]
["Tsesna Capital LLC",0]
["Medet Holding LLC",0]
["Info-Tses LLC",0]
["Concern Tsesna Astyk LLC",0]
["Zhaltyr Elevator LLC",0]
["Tsesna Astyk Bread plant LLC",0]
["Akmola Dirmen LLC",0]
["Elevator Tsesna Astyk LLC",0]
["Alma-Tses LLC",0]
["Tsesna Mak LLC",0]
["Astyk Logistic LLC",0]
["Football Club Tsesna LLC",0]
[null,{"$f":"SUM(B151:B164)","v":0}]
[]
[]
["Investment property"]
[]
[null,2009]
[null,"’000 KZT"]
[]
["At 1 January",20289376]
["Additions",95495]
["Transfer from advances paid",284475]
["Transfer from inventory",12215]
["Transfer (to)/from property, plant and equipment",-65782]
["Change in fair value",835194]
["Disposals",-139546]
["At 31 December",21311427]
[]
[]
[]
["Proceeds from disposal of IA"]
[]
["Tsesna Corporation JSC",187629]
["Tsesnabank JSC",0]
["Tsesna Capital LLC",0]
["Medet Holding LLC",42342]
["Info-Tses LLC",0]
["Concern Tsesna Astyk LLC",0]
["Zhaltyr Elevator LLC",0]
["Tsesna Astyk Bread plant LLC",0]
["Akmola Dirmen LLC",0]
["Elevator Tsesna Astyk LLC",0]
["Alma-Tses LLC",0]
["Tsesna Mak LLC",0]
["Astyk Logistic LLC",0]
["Football Club Tsesna LLC",0]
[null,{"$f":"SUM(B186:B199)","v":229971}]
[]
[]
["Trade and other receivables"]
[]
[null,2009]
[null,"’000 KZT"]
["Advances paid for construction works",2948392]
["Loans to related parties",1201479]
["Advances paid for goods and services",3920141]
["Trade receivables",3205322]
["Tax receivables, other than income tax",661199]
["Prepaid expenses","-"]
["Other",255459]
[null,12191992]
["Impairment allowance (Note 12)",-1068864]
[null,11123128]
[]
[]
[]
[]
["Trade and other payables"]
[]
[]
[null,2009]
[null,"’000 KZT"]
["Advances received under share holding agreements on construction",4565251]
["Trade payables",2440217]
["Advance billings under construction contracts",1704169]
["Advances received for investment property to be sold to related parties",950000,"Investing activity"]
["Taxes payable, other than income tax",573864]
["Due to employees",185011]
["Due to the Government of the Republic of Kazakhstan",90689]
["Provision for off-balance sheet credit risk",89173]
["Other",466186]
[null,11064560]
[]
[]
[]
[]
[]
["AFS"]
[]
[null,2009,"2008 "]
[null,"’000 KZT","’000 KZT"]
["Debt and other fixed-income instruments "]
["Treasury bills of the Ministry of Finance of the Republic of Kazakhstan",727196,799812]
["    Astana Finance JSC","-",2173860]
["    HSBK EUROPE B.V.","-",181603]
[null,727196,3155275]
["Equity investments – unquoted"]
["    Corporate shares ",71664,205808]
[null,798860,3361083]
[]
[null,"inflow",{"$f":"C252-B252","v":2562223}]
[]
[null,2009,null,null,null,2008,null,null,null,"Change"]
["TSC",14473,-5781,{"$f":"SUM(B257:C257)","v":8692},null,14473,-5781,{"$f":"SUM(F257:G257)","v":8692},null,{"$f":"H257-D257","v":0}]
["TSB",743941,null,743941,null,3171525,null,3171525,null,2427584]
["TC",10323,null,10323,null,9828,null,9828,null,-495,"acquisition of KASE shares"]
["MH",5524,null,5524,null,4814,null,4814,null,-710,"540 - transfer to subsidiary (9% in FC Tsesna), -1250 - increase in Titan investment"]
["Info Tses",null,null,0,null,135844,null,135844,null,135844,"transfer to associates"]
["CTA",35060,-15000,20060,null,20060,null,20060,null,0]
["JE",10320,null,10320,null,10320,null,10320,null,0]
[null,null,null,{"$f":"SUM(D257:D263)","v":798860},null,null,null,{"$f":"SUM(H257:H263)","v":3361083},null,2562223]
[]
[]
["BB",{"$f":"H264","v":3361083}]
["Acquisition in MH",{"$f":"1250","v":1250}]
["Acquisition in TC",495]
[]
["Transfer to associate",{"$f":"-J261","v":-135844}]
["Transfer to inv in subsidiaries",-540]
[]
["TSB"]
["Purchase of AFS",494,null,"Interest accrued BB",57798]
["Sale of AFS",-2300225,null,"Interest accrued EB",16129]
["FX gain",21700,null,null,{"$f":"E275-E276","v":41669},"cash inflow"]
["Change in AFS reserve",{"$f":"#REF!+SUM(#REF!)","v":{"$error":"#REF!"}}]
["Gain from AFS",31630]
["Interest income",{"$f":"B285","v":131856}]
["Interest received",{"$f":"-(B285+E277)","v":-173525}]
[null,{"$f":"SUM(B267:B281)","v":{"$error":"#REF!"}}]
["check",{"$f":"B282-D264","v":{"$error":"#REF!"}}]
[]
["Interest income",131856]
["Net gain on available-for-sale assets",31630]
[]
[]
[]
["Disposal of subsidiary"]
[]
[null,"Carrying value at date of disposal"]
["‘000 KZT","Parsec Development LLC","Naiza Engineering LLC","Total"]
["Assets"]
["Cash and cash equivalents",2002,13775,15777]
["Trade and other receivables",50564,1225837,1276401]
["Current tax assets",6453,13313,19766]
["Inventories",29632,1987,31619]
["Property, plant and equipment",13029,12217,25246]
["Intangible assets","-",378,378]
["Deferred tax assets","-",2,2]
[null,101680,1267509,1369189]
["Liabilities"]
["Loans and borrowings","-",-1603433,-1603433]
["Trade and other payables",-186735,-24834,-211569]
[null,-186735,-1628267,-1815002]
["Net identifiable assets and liabilities ",-85055,-360758,-445813]
["Consideration received in cash",97,10000,10097]
["Difference recognised in equity",85152,370758,455910]
["Cash disposed of",-2002,-13775,-15777]
["Net cash outflow",-1905,-3775,-5680]
[]
[]
["Acquisition of subsidiary"]
[]
["‘000 KZT","Carrying value on acquisition "]
["Assets"]
["Cash",17780]
["Trade and other receivables",145999]
["Inventories",7329]
["Property, plant and equipment",575388]
["Intangible assets",18]
[null,746514]
["Liabilities"]
["Loans and borrowings",-80000]
["Trade and other payables",-34616]
["Deferred tax liability",-36351]
[null,-150967]
["Net identifiable assets and liabilities ",595547]
["Consideration paid in cash",-19860]
["Consideration paid via offset with trade receivables",-65000]
["Carrying value of previously held investment of 9% in investee",-540]
["Carrying value of minority interest",-9489]
["Difference recognised in equity",500658]
["Cash acquired",17780]
["Net cash inflow",12920]
[]
[]
[]
["Investments in subsidiaries"]
[null,null,null,"2008-12-31",null,"2008-12-31"]
["Company","Country","Main activity","Share","‘000 KZT","Share","‘000 KZT"]
["Medet-Holding LLC","Kazakhstan","Holding of investments",1,12963312,1,12963312,{"$f":"E343-G343","v":0}]
["Tsesnabank JSC","Kazakhstan","\nBanking",0.85209999999999997,12060599,0.91049999999999998,13207845,{"$f":"E344-G344","v":-1147246},"sale of shares of Tsesnabank"]
["Tsesna Capital JSC","Kazakhstan","Broker-dealer activity",0.51,186150,0.51,186150,{"$f":"E345-G345","v":0}]
["Naiza Engineering LLC","Kazakhstan","Engineering services ",0,0,1,97,{"$f":"E346-G346","v":-97},"disposal of subs"]
[null,null,null,null,{"$f":"SUM(E343:E346)","v":25210061},null,{"$f":"SUM(G343:G346)","v":26357404}]
[]
[]
["Loans to customers - Interest receivable - TSB"]
[]
[null,3504291]
[null,8756175.6611800008]
[null,{"$f":"B352-B353","v":-5251884.6611800008},"> CFS"]
[]
["Deposits of customers - TSB - accrued %"]
[null,795608]
[null,919333]
[null,{"$f":"B358-B357","v":123725},"> CFS"]
[]
[]
["Placements with banks - Interest receivable - TSB"]
[]
[null,99755]
[null,2]
[null,{"$f":"B364-B365","v":99753},"> CFS"]
[]
[]
["FVTPL - Interest receivable - TSB"]
[null,47565]
[null,103340]
[null,{"$f":"B370-B371","v":-55775},"> CFS"]
[]
[]
["Interest expense - change in accruals - loans and borrowings - TSB"]
[]
[null,407188,2442]
[null,244569,1661]
[null,{"$f":"B378-B377","v":-162619},{"$f":"C378-C377","v":-781}]
[null,null,{"$f":"SUM(B379:C379)","v":-163400}]
[]
["Dividends on pref.shares"]
[]
[null,530821]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B385-B384","v":{"$error":"#REF!"}}]
[]
[]
["ETA","ok"]
["TM",-13564]
["TSC",98629.221560000035]
["FCT",0]
[null,{"$f":"SUM(B389:B392)","v":85065.221560000035}]
[]
[null,{"$f":"SUM(B393,B386,C380)","v":{"$error":"#REF!"}},"> CFS"]
[]
[]
[]
["FX on loans and borrowings"]
[null,"Loss (gain)"]
["Tsesna Corporation JSC",666879.74384999985,"ATF Bank loans"]
["Tsesnabank JSC",61412,"debt securities issued"]
["Tsesna Capital LLC",0]
["Medet Holding LLC",0]
["Info-Tses LLC",0]
["Concern Tsesna Astyk LLC",1108318,"USD loans"]
["Zhaltyr Elevator LLC",0]
["Tsesna Astyk Bread plant LLC",0]
["Akmola Dirmen LLC",0]
["Elevator Tsesna Astyk LLC",6749]
["Alma-Tses LLC",0]
["Tsesna Mak LLC",71979]
["Astyk Logistic LLC",0]
["Football Club Tsesna LLC",0]
[null,{"$f":"SUM(B401:B414)","v":1915337.7438499997}]
[null,131287,"plug"]
[null,{"$f":"SUM(B415:B416)","v":2046624.7438499997},"> CFS"]
[]
[]
["Repayment and borrowing of loans and borrowings"]
[]
[null,"Issue","Repayment"]
["Tsesna Corporation JSC",2040000,{"$f":"-6108310.20007-D439","v":-8824312.2000700012},{"$f":"SUM(B423:C423)","v":-6784312.2000700012}]
["Tsesnabank JSC",218579,-6819326,-6600747]
["Tsesna Capital LLC",0,0,0]
["Medet Holding LLC",0,{"$f":"-15000-13669","v":-28669},-28669]
["Info-Tses LLC",0,0,0]
["Concern Tsesna Astyk LLC",6429952.1194799989,-6607117.8303399999,-177165.71086000092]
["Zhaltyr Elevator LLC",144714,-196571,-51857]
["Tsesna Astyk Bread plant LLC",0,0,0]
["Akmola Dirmen LLC",0,0,0]
["Elevator Tsesna Astyk LLC",131520,-152566,-21046]
["Alma-Tses LLC",0,0,0]
["Tsesna Mak LLC",435734,-550662,-114928]
["Astyk Logistic LLC",0,0,0]
["Football Club Tsesna LLC",142646,0,142646]
[null,{"$f":"SUM(B423:B436)","v":9543145.1194799989},{"$f":"SUM(C423:C436)","v":-23179224.030409999},{"$f":"SUM(D423:D436)","v":-13636078.910930002}]
[]
["Amounts payable under repurchase agreements",177002,2893004,{"$f":"C439-B439","v":2716002},"repayment of repo (net turnover, as gross is too huge (163 bln KZT)"]
[]
[]
["1                   Banking revenue and expenses"]
[null,"2009 ",null,"2008 "]
[null,"’000 KZT",null,"’000 KZT"]
["Interest income"]
["- Loans to customers",15601142,null,15526442]
["- Financial instruments at fair value through profit or loss",738307,null,567349]
["- Held-to-maturity investments",521163,null,178021]
["- Amounts receivable under reverse repurchase agreements",310279,null,96610]
["- Placements with banks and other financial institutions",226001,null,335354]
["- Available-for-sale assets",131856,null,50786]
["- Due from the NBRK",34100,null,177940]
["Fee and commission income",2501474,null,2301891]
["Gain on foreign currency spot transactions and derivatives",1601942,null,693435]
["Net gain on financial instruments through profit or loss",1359576,null,"-"]
["Net gain on available-for-sale assets",31630,null,"-"]
["Dividend income",39368,null,104289]
["Gain from redemption of debt securities issued","-",null,1016576]
["Loss from foreign currency revaluation of financial assets and liabilities",-478604,null,-148826]
[null,22618234,null,20899867]
["Interest expense"]
["- Current accounts and deposits from customers",-6861247,null,-6532985]
["- Loans and borrowings",-3391738,null,-3842420]
["- Deposits and balances from banks and other financial    institutions",-851950,null,-1240812]
["- Other",-81357,null,-11044]
["Loss on sale of held-to-maturity investments",-819795,null,"-"]
["Fee and commission expense",-197530,null,-162811]
["Net loss on financial instruments through profit or loss","-",null,-2669464]
[null,-12203617,null,-14459536]
[]
[]
["1                   Non-banking finance income and costs"]
[null,"2009 ",null,"2008 "]
[null,"’000 KZT",null,"’000 KZT"]
["Finance income"]
["Net gain on financial instruments at fair value through profit or loss",3403558,null,2547626]
["Net gain on sale of available-for-sale assets","-",null,2279412]
["Interest income",142564,null,102636]
["Dividend income",3690,null,269]
["Other","-",null,695]
[null,3549812,null,4930638]
[]
["Finance costs"]
["Interest expense on financial liabilities measured at amortised cost",-2799816,null,-2915315]
["Net foreign exchange losses",-1960536,null,-92567,{"$f":"SUM(D485,D459)","v":-241393},"FX in 2008 - NS for restatement"]
[null,-4760352,null,-3007882]
[]
[]
[]
[]
["FX effect on cash"]
[]
["Tsesna Corporation JSC",0,"FC operations"]
["Tsesnabank JSC",{"$f":"-39599-91905","v":-131504},91905]
["Tsesna Capital LLC",0]
["Medet Holding LLC",0]
["Info-Tses LLC",0]
["Concern Tsesna Astyk LLC",-90118]
["Zhaltyr Elevator LLC",-1401]
["Tsesna Astyk Bread plant LLC",0]
["Akmola Dirmen LLC",0]
["Elevator Tsesna Astyk LLC",-1257]
["Alma-Tses LLC",0]
["Tsesna Mak LLC",0]
["Astyk Logistic LLC",0]
["Football Club Tsesna LLC",0]
[null,{"$f":"SUM(B493:B506)","v":-224280}]

{"sheet":"25","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[[2,0,3,0]]}
["Deposits and balances from banks and other financial institutions"]
[]
[null,2011,2010,2009]
[null,"’000 KZT","’000 KZT","’000 KZT"]
["Loans and deposits from banks and other financial institutions",null,null,11966197]
["Loro accounts",null,null,18283]
["Derivative financial instruments",null,null,0]
[null,{"$f":"SUM(B5:B7)","v":0},{"$f":"SUM(C5:C7)","v":0},{"$f":"SUM(D5:D7)","v":11984480}]
[null,{"$f":"B8-#REF!","v":{"$error":"#REF!"}},{"$f":"C8-#REF!","v":{"$error":"#REF!"}},{"$f":"D8-#REF!","v":{"$error":"#REF!"}}]

{"sheet":"31.a.1.2009","index":2,"n_rows":61,"n_cols":19,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["Summarised information for interest gap disclosure 2009:"]
[]
[null,"TSC","TSB","TSCAP","MEDH","INFTS","TSAST","ZHALT","BREAD","AKMDIR","ELEV","ALMTS","TSMAK","ASTLOG","FCTSC","CONS","Contractual cash flows","Carrying amount"]
[]
["Financial instruments at fair value through profit or loss",{"$f":"ROUND(SUM(B6:B10),0)","v":0},7093101,17533,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q6:Q10)","v":7110634},7110634,{"$f":"Q5-R5","v":0}]
["Less than 1 month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B6:P6),0)","v":0}]
["1 to 3 months",null,1310610,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B7:P7),0)","v":1310610}]
["3-12 months",null,880057,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B8:P8),0)","v":880057}]
["1-5 years",null,3678825,{"$f":"11593+5940","v":17533},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B9:P9),0)","v":3696358}]
["More than 5 years - 2016 - more",null,1223609,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B10:P10),0)","v":1223609}]
[]
["Available-for-sale financial assets",{"$f":"ROUND(SUM(B13:B17),0)","v":0},727196,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q13:Q17)","v":727196},727196,{"$f":"Q12-R12","v":0}]
["Less than 1 month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B13:P13),0)","v":0}]
["1 to 3 months",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B14:P14),0)","v":0}]
["3-12 months",null,314181,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B15:P15),0)","v":314181}]
["1-5 years",null,413015,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B16:P16),0)","v":413015}]
["More than 5 years - 2016 - more",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B17:P17),0)","v":0}]
[]
["Held-to-maturity investments",{"$f":"ROUND(SUM(B20:B24),0)","v":0},4319954,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q20:Q24)","v":4319954},4319954,{"$f":"Q19-R19","v":0}]
["Less than 1 month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B20:P20),0)","v":0}]
["1 to 3 months",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B21:P21),0)","v":0}]
["3-12 months",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B22:P22),0)","v":0}]
["1-5 years",null,4287458,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B23:P23),0)","v":4287458}]
["More than 5 years - 2016 - more",null,32496,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B24:P24),0)","v":32496}]
[]
["Loans and advances to banks",{"$f":"ROUND(SUM(B27:B31),0)","v":0},27805060,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q27:Q31)","v":27805060},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Q26-R26","v":{"$error":"#REF!"}}]
["Less than 1 month",null,27595060,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B27:P27),0)","v":27595060}]
["1 to 3 months",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B28:P28),0)","v":0}]
["3-12 months",null,210000,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B29:P29),0)","v":210000}]
["1-5 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B30:P30),0)","v":0}]
["More than 5 years - 2016 - more",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B31:P31),0)","v":0}]
[]
["Loans to customers",{"$f":"ROUND(SUM(B34:B38),0)","v":0},103430834,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q34:Q38)","v":103430834},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Q33-R33","v":{"$error":"#REF!"}}]
["Less than 1 month",null,10094286,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B34:P34),0)","v":10094286}]
["1 to 3 months",null,6191098,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B35:P35),0)","v":6191098}]
["3-12 months",null,{"$f":"14933235-1428926","v":13504309},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B36:P36),0)","v":13504309}]
["1-5 years",null,34719745,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B37:P37),0)","v":34719745}]
["More than 5 years - 2016 - more",null,38921396,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B38:P38),0)","v":38921396}]
[]
["Loans and borrowings",{"$f":"SUM(B41:B45)","v":0},21640402,0,0,0,0,0,0,0,0,0,0,0,0,18281207,{"$f":"SUM(Q41:Q45)","v":39921609},39921609,{"$f":"Q40-R40","v":0}]
["Less than 1 month",null,123399,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1334887+177002","v":1511889},{"$f":"ROUND(SUM(B41:P41),0)","v":1635288}]
["1 to 3 months",null,9139753,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B42:P42),0)","v":9139753}]
["3-12 months",null,{"$f":"1390008+13920","v":1403928},null,null,null,null,null,null,null,null,null,null,null,null,5691278,{"$f":"ROUND(SUM(B43:P43),0)","v":7095206}]
["1-5 years",null,{"$f":"2746271+3668698-183487","v":6231482},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"4742170+2852537","v":7594707},{"$f":"ROUND(SUM(B44:P44),0)","v":13826189}]
["More than 5 years - 2016 - more",null,4741840,null,null,null,null,null,null,null,null,null,null,null,null,3483333,{"$f":"ROUND(SUM(B45:P45),0)","v":8225173}]
[]
["Current accounts and deposits from customers",{"$f":"ROUND(SUM(B48:B52),0)","v":0},92459462,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q48:Q52)","v":92459462}]
["Less than 1 month",null,16411574,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B48:P48),0)","v":16411574}]
["1 to 3 months",null,5955965,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B49:P49),0)","v":5955965}]
["3-12 months",null,{"$f":"23860955-237874","v":23623081},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B50:P50),0)","v":23623081}]
["1-5 years",null,40853109,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B51:P51),0)","v":40853109}]
["More than 5 years - 2016 - more",null,5615733,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B52:P52),0)","v":5615733}]
[]
["Deposits and balances from banks and other financial institutions",{"$f":"ROUND(SUM(B55:B59),0)","v":0},14674168,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q55:Q59)","v":14674168},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Q54-R54","v":{"$error":"#REF!"}}]
["Less than 1 month",null,228640,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B55:P55),0)","v":228640}]
["1 to 3 months",null,309379,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B56:P56),0)","v":309379}]
["3-12 months",null,5327216,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B57:P57),0)","v":5327216}]
["1-5 years",null,7702160,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B58:P58),0)","v":7702160}]
["More than 5 years - 2016 - more",null,1106773,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(B59:P59),0)","v":1106773}]
[]
[null,{"$f":"SUM(B4:B60)","v":0},544300354,35066,0,0,0,0,0,0,0,0,0,0,0,36562414]

{"sheet":"37","index":3,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":true,"merged":[[3,0,4,0],[15,0,16,0]]}
["Fair values of financial instruments"]
[]
[]
[null,2008,2008]
[null,"’000 KZT","’000 KZT"]
[null,"Fair Value","Carrying  Value"]
["ASSETS"]
["Loans to customers",{"$f":"B23","v":{"$error":"#REF!"}},{"$f":"C23","v":{"$error":"#REF!"}}]
["Held-to-maturity instruments",{"$f":"B26","v":2217375},{"$f":"C26","v":4953377}]
["LIABILITIES"]
["Current accounts and deposits from customers",{"$f":"B32","v":{"$error":"#REF!"}},{"$f":"C32","v":{"$error":"#REF!"}}]
["Loans and borrowings",{"$f":"B44","v":{"$error":"#REF!"}},{"$f":"C44","v":{"$error":"#REF!"}}]
[]
["Workings:"]
[]
[null,2008,2008]
[null,"’000 KZT","’000 KZT"]
[null,"Fair Value","Carrying  Value"]
["ASSETS"]
["Loans to customers",84875979,86466727]
["Ratio of FV/CV",{"$f":"B20/C20","v":0.98160277305280674}]
["Elim",{"$f":"C22*B21","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["Loans to customers",{"$f":"B20+B22","v":{"$error":"#REF!"}},{"$f":"C20+C22","v":{"$error":"#REF!"}}]
["Check",null,{"$f":"C23-#REF!","v":{"$error":"#REF!"}}]
[]
["Held to maturity investments",2217375,4953377]
[null,null,{"$f":"C26-#REF!","v":{"$error":"#REF!"}}]
["LIABILITIES"]
["Current accounts and deposits from customers",78304566,80313123]
["Ratio of FV/CV",{"$f":"B29/C29","v":0.97499092396145526}]
[null,{"$f":"C31*B30","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["Adjusted values",{"$f":"B29+B31","v":{"$error":"#REF!"}},{"$f":"C29+C31","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C32+#REF!","v":{"$error":"#REF!"}}]
["Loans and borrowings"]
["Unsecured bond issues",{"$f":"22231290+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!-#REF!","v":{"$error":"#REF!"}}]
["Ratio of FV/CV",{"$f":"B35/C35","v":{"$error":"#REF!"}}]
["Elim",{"$f":"C37*B36","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
["Bank loans",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Amounts payable under repurchase agreements",{"$f":"C39","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Loan from other related party",{"$f":"C40","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cumulative non-redeemable preference shares, subordinated bonds, subordinated loans",{"$f":"5533174+1250000","v":6783174},{"$f":"#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]
["Dividends on preference shares",{"$f":"C42","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Interest payable",{"$f":"C43","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"B35+B38+B40+B41+B42+B43+B37+B39","v":{"$error":"#REF!"}},{"$f":"SUM(C35:C43)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C44-#REF!","v":{"$error":"#REF!"}}]

{"sheet":"NCI_TSB","index":4,"n_rows":62,"n_cols":86,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[]
[null,"2005-01-01","2005-04-30","2005-10-25","2005-11-14","2005-11-15","2005-11-16","2005-12-02","2005-12-06","2005-12-08","Acquisition",null,"2006-03-01","2006-03-01",null,"2006-05-01","2006-05-01",null,"2006-07-01","2006-07-01",null,"2006-09-01","2006-09-01",null,"2006-10-01","2006-10-01",null,"2006-11-01","2006-11-01",null,"2007-01-01","2007-01-01",null,"2007-04-01","2007-04-01",null,"2007-05-01","2007-05-01",null,"2007-07-01","2007-07-01",null,"2007-08-01","2007-08-01",null,"2008-01-01","2008-01-01",null,"2009-01-01","2009-01-01",null,"2009-02-01","2009-02-01",null,"2009-07-01","2009-07-01",null,"2009-09-01","2009-09-01",null,"2010-01-01","2010-01-01"]
[]
["Invest, \nKKZT",52000,19100,2355,50780,200677,50693,500025,500025,500025,1875680,null,null,182313,null,null,981988,null,null,0,null,null,400000,null,null,554789,null,null,26,null,null,1512652,null,null,2662710,null,null,156959,null,null,2708371,null,null,300050,null,null,0,null,null,1872307,null,null,127693,null,null,-561294,null,null,-713645,null,null,0]
[]
["Total shares",null,null,null,null,null,null,null,null,null,2246610,null,null,0,null,null,1017414,null,null,35806,null,null,400000,null,null,593168,null,null,12000,null,null,3195002,null,null,2664310,null,null,335690,null,null,2768417,null,null,231583,null,null,0,null,null,{"$f":"AX7","v":1872307},null,null,{"$f":"BA7","v":127693},null,null,0,null,null,0,null,null,0]
["TSC shares",52000,19100,2355,59393,287030,69022,500000,500000,500000,1988900,null,null,182313,null,null,981988,null,null,0,null,null,400000,null,null,554789,null,null,26,null,null,2548759,null,null,2662710,null,null,155550,null,null,2707017,null,null,300000,null,null,0,null,null,1872307,null,null,127693,null,null,-609552,null,null,-775000,null,null,0]
["NCI shares",null,null,null,null,null,null,null,null,null,{"$f":"K6-K7","v":257710},null,null,{"$f":"N6-N7","v":-182313},null,null,{"$f":"Q6-Q7","v":35426},null,null,{"$f":"T6-T7","v":35806},null,null,{"$f":"W6-W7","v":0},null,null,{"$f":"Z6-Z7","v":38379},null,null,{"$f":"AC6-AC7","v":11974},null,null,{"$f":"AF6-AF7","v":646243},null,null,{"$f":"AI6-AI7","v":1600},null,null,{"$f":"AL6-AL7","v":180140},null,null,{"$f":"AO6-AO7","v":61400},null,null,{"$f":"AR6-AR7","v":-68417},null,null,{"$f":"AU6-AU7","v":0},null,null,{"$f":"AX6-AX7","v":0},null,null,{"$f":"BA6-BA7","v":0},null,null,{"$f":"BD6-BD7","v":609552},null,null,{"$f":"BG6-BG7","v":775000},null,null,{"$f":"BJ6-BJ7","v":0}]
["Shareholders",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K7/K6,0%)","v":0.885289391572191},null,null,{"$f":"IFERROR(N7/N6,0%)","v":0},null,null,{"$f":"IFERROR(Q7/Q6,0%)","v":0.96518034939562458},null,null,{"$f":"IFERROR(T7/T6,0%)","v":0},null,null,{"$f":"IFERROR(W7/W6,0%)","v":1},null,null,{"$f":"IFERROR(Z7/Z6,0%)","v":0.93529826288673701},null,null,{"$f":"IFERROR(AC7/AC6,0%)","v":2.1666666666666666E-3},null,null,{"$f":"IFERROR(AF7/AF6,0%)","v":0.7977331469589064},null,null,{"$f":"IFERROR(AI7/AI6,0%)","v":0.99939946928097712},null,null,{"$f":"IFERROR(AL7/AL6,0%)","v":0.46337394620036343},null,null,{"$f":"IFERROR(AO7/AO6,0%)","v":0.9778212603086891},null,null,{"$f":"IFERROR(AR7/AR6,0%)","v":1.295431875396726},null,null,{"$f":"IFERROR(AU7/AU6,0%)","v":0},null,null,{"$f":"IFERROR(AX7/AX6,0%)","v":1},null,null,{"$f":"IFERROR(BA7/BA6,0%)","v":1},null,null,{"$f":"IFERROR(BD7/BD6,0%)","v":0},null,null,{"$f":"IFERROR(BG7/BG6,0%)","v":0},null,null,{"$f":"IFERROR(BJ7/BJ6,0%)","v":0}]
["NCI",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K8/K6,0)","v":0.11471060842780902},null,null,{"$f":"IFERROR(N8/N6,0)","v":0},null,null,{"$f":"IFERROR(Q8/Q6,0)","v":3.4819650604375404E-2},null,null,{"$f":"IFERROR(T8/T6,0)","v":1},null,null,{"$f":"IFERROR(W8/W6,0)","v":0},null,null,{"$f":"IFERROR(Z8/Z6,0)","v":6.4701737113263019E-2},null,null,{"$f":"IFERROR(AC8/AC6,0)","v":0.99783333333333335},null,null,{"$f":"IFERROR(AF8/AF6,0)","v":0.20226685304109357},null,null,{"$f":"IFERROR(AI8/AI6,0)","v":6.0053071902293651E-4},null,null,{"$f":"IFERROR(AL8/AL6,0)","v":0.53662605379963657},null,null,{"$f":"IFERROR(AO8/AO6,0)","v":2.2178739691310956E-2},null,null,{"$f":"IFERROR(AR8/AR6,0)","v":-0.295431875396726},null,null,{"$f":"IFERROR(AU8/AU6,0)","v":0},null,null,{"$f":"IFERROR(AX8/AX6,0)","v":0},null,null,{"$f":"IFERROR(BA8/BA6,0)","v":0},null,null,{"$f":"IFERROR(BD8/BD6,0)","v":0},null,null,{"$f":"IFERROR(BG8/BG6,0)","v":0},null,null,{"$f":"IFERROR(BJ8/BJ6,0)","v":0}]
[]
["Cumulative"]
["Share capital",null,null,null,null,null,null,null,null,null,{"$f":"K6","v":2246610},null,{"$f":"K13","v":2246610},{"$f":"K13+N6","v":2246610},null,{"$f":"N13","v":2246610},{"$f":"N13+Q6","v":3264024},null,{"$f":"Q13","v":3264024},{"$f":"Q13+T6","v":3299830},null,{"$f":"T13","v":3299830},{"$f":"T13+W6","v":3699830},null,{"$f":"W13","v":3699830},{"$f":"W13+Z6","v":4292998},null,{"$f":"Z13","v":4292998},{"$f":"Z13+AC6","v":4304998},null,{"$f":"AC13","v":4304998},{"$f":"AC13+AF6","v":7500000},null,{"$f":"AF13","v":7500000},{"$f":"AF13+AI6","v":10164310},null,{"$f":"AI13","v":10164310},{"$f":"AI13+AL6","v":10500000},null,{"$f":"AL13","v":10500000},{"$f":"AL13+AO6","v":13268417},null,{"$f":"AO13","v":13268417},{"$f":"AO13+AR6","v":13500000},null,{"$f":"AR13","v":13500000},{"$f":"AR13+AU6","v":13500000},null,{"$f":"AU13","v":13500000},{"$f":"AU13+AX6","v":15372307},null,{"$f":"AX13","v":15372307},{"$f":"AX13+BA6","v":15500000},null,{"$f":"BA13","v":15500000},{"$f":"BA13+BD6","v":15500000},null,{"$f":"BD13","v":15500000},{"$f":"BD13+BG6","v":15500000},null,{"$f":"BG13","v":15500000},{"$f":"BG13+BJ6","v":15500000}]
["Reserves",null,null,null,null,null,null,null,null,null,343429,null,{"$f":"N14","v":316993},316993,null,{"$f":"Q14","v":332807},332807,null,{"$f":"T14","v":292459},292459,null,{"$f":"W14","v":291896},291896,null,{"$f":"Z14","v":291565},291565,null,{"$f":"AC14","v":272576},272576,null,{"$f":"AF14","v":299408},299408,null,{"$f":"AI14","v":299408},299408,null,{"$f":"AL14","v":299408},299408,null,{"$f":"AO14","v":299408},299408,null,{"$f":"AR14","v":299408},299408,null,{"$f":"AU14","v":1738465},1738465,null,{"$f":"AX14","v":4156974},4156974,null,{"$f":"BA14","v":4156974},4156974,null,{"$f":"BD14","v":4156974},4156974,null,{"$f":"BG14","v":4156974},4156974,null,{"$f":"BJ14","v":2409455},2409455]
["Net income",null,null,null,null,null,null,null,null,null,0,null,{"$f":"N15","v":54495},54495,null,{"$f":"Q15","v":136032},136032,null,{"$f":"T15","v":202409},202409,null,{"$f":"W15","v":441111},441111,null,{"$f":"Z15","v":543457},543457,null,{"$f":"AC15","v":351197},351197,null,{"$f":"AF15","v":618155},618155,null,{"$f":"AI15","v":265176},{"$f":"(ROUND($AU$15/5,0))","v":265176},null,{"$f":"AL15","v":530352},{"$f":"(ROUND($AU$15/5,0)+AI15)","v":530352},null,{"$f":"AO15","v":795528},{"$f":"(ROUND($AU$15/5,0)+AL15)","v":795528},null,{"$f":"AR15","v":1060704},{"$f":"(ROUND($AU$15/5,0)+AO15)","v":1060704},null,{"$f":"AU15","v":1325881},1325881,null,{"$f":"AX15","v":-4537049},-4537049,null,{"$f":"BA15","v":126539},{"$f":"(ROUND($BJ$15/4,0))","v":126539},null,{"$f":"BD15","v":253078},{"$f":"(ROUND($BJ$15/4,0)+BA15)","v":253078},null,{"$f":"BG15","v":379617},{"$f":"(ROUND($BJ$15/4,0)+BD15)","v":379617},null,{"$f":"BJ15","v":506157},506157]
["Retained earnings",null,null,null,null,null,null,null,null,null,1368133,null,{"$f":"N16","v":1368213},1368213,null,1104423,87009,null,{"$f":"T16","v":87009},87009,null,{"$f":"W16","v":87009},87009,null,{"$f":"Z16","v":87009},87009,null,{"$f":"AC16","v":87009},87009,null,{"$f":"AF16","v":87009},87009,null,{"$f":"AI16","v":705164},{"$f":"SUM(AF15:AF16)","v":705164},null,{"$f":"AL16","v":705164},{"$f":"AI16","v":705164},null,{"$f":"AO16","v":705164},{"$f":"AL16","v":705164},null,{"$f":"AR16","v":705164},{"$f":"AO16","v":705164},null,{"$f":"AU16","v":711303},711303,null,{"$f":"AX16","v":74202},74202,null,{"$f":"BA16","v":-4462847},{"$f":"SUM(AX15:AX16)","v":-4462847},null,{"$f":"BD16","v":-4462847},{"$f":"BA16","v":-4462847},null,{"$f":"BG16","v":-4462847},{"$f":"BD16","v":-4462847},null,{"$f":"BJ16","v":-2762937},-2762937]
["Net assets",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K13:K16)","v":3958172},null,{"$f":"SUM(M13:M16)","v":3986311},{"$f":"SUM(N13:N16)","v":3986311},null,{"$f":"SUM(P13:P16)","v":3819872},{"$f":"SUM(Q13:Q16)","v":3819872},null,{"$f":"SUM(S13:S16)","v":3845901},{"$f":"SUM(T13:T16)","v":3881707},null,{"$f":"SUM(V13:V16)","v":4119846},{"$f":"SUM(W13:W16)","v":4519846},null,{"$f":"SUM(Y13:Y16)","v":4621861},{"$f":"SUM(Z13:Z16)","v":5215029},null,{"$f":"SUM(AB13:AB16)","v":5003780},{"$f":"SUM(AC13:AC16)","v":5015780},null,{"$f":"SUM(AE13:AE16)","v":5309570},{"$f":"SUM(AF13:AF16)","v":8504572},null,{"$f":"SUM(AH13:AH16)","v":8769748},{"$f":"SUM(AI13:AI16)","v":11434058},null,{"$f":"SUM(AK13:AK16)","v":11699234},{"$f":"SUM(AL13:AL16)","v":12034924},null,{"$f":"SUM(AN13:AN16)","v":12300100},{"$f":"SUM(AO13:AO16)","v":15068517},null,{"$f":"SUM(AQ13:AQ16)","v":15333693},{"$f":"SUM(AR13:AR16)","v":15565276},null,{"$f":"SUM(AT13:AT16)","v":17275649},{"$f":"SUM(AU13:AU16)","v":17275649},null,{"$f":"SUM(AW13:AW16)","v":13194127},{"$f":"SUM(AX13:AX16)","v":15066434},null,{"$f":"SUM(AZ13:AZ16)","v":15192973},{"$f":"SUM(BA13:BA16)","v":15320666},null,{"$f":"SUM(BC13:BC16)","v":15447205},{"$f":"SUM(BD13:BD16)","v":15447205},null,{"$f":"SUM(BF13:BF16)","v":15573744},{"$f":"SUM(BG13:BG16)","v":15573744},null,{"$f":"SUM(BI13:BI16)","v":15652675},{"$f":"SUM(BJ13:BJ16)","v":15652675}]
[]
["Net change"]
["Share capital",null,null,null,null,null,null,null,null,null,{"$f":"K13","v":2246610},null,{"$f":"M13-K13","v":0},{"$f":"N13-K13","v":0},null,null,{"$f":"Q13-N13","v":1017414},null,null,{"$f":"T13-Q13","v":35806},null,null,{"$f":"W13-T13","v":400000},null,null,{"$f":"Z13-W13","v":593168},null,null,{"$f":"AC13-Z13","v":12000},null,null,{"$f":"AF13-AC13","v":3195002},null,null,{"$f":"AI13-AF13","v":2664310},null,null,{"$f":"AL13-AI13","v":335690},null,null,{"$f":"AO13-AL13","v":2768417},null,null,{"$f":"AR13-AO13","v":231583},null,null,{"$f":"AU13-AR13","v":0},null,null,{"$f":"AX13-AU13","v":1872307},null,null,{"$f":"BA13-AX13","v":127693},null,null,{"$f":"BD13-BA13","v":0},null,null,{"$f":"BG13-BD13","v":0},null,null,{"$f":"BJ13-BG13","v":0}]
["Reserves",null,null,null,null,null,null,null,null,null,343429,null,{"$f":"M14-K14","v":-26436},{"$f":"N14-K14","v":-26436},null,null,{"$f":"Q14-N14","v":15814},null,null,{"$f":"T14-Q14","v":-40348},null,null,{"$f":"W14-T14","v":-563},null,null,{"$f":"Z14-W14","v":-331},null,null,{"$f":"AC14-Z14","v":-18989},null,null,{"$f":"AF14-AC14","v":26832},null,null,{"$f":"AI14-AF14","v":0},null,null,{"$f":"AL14-AI14","v":0},null,null,{"$f":"AO14-AL14","v":0},null,null,{"$f":"AR14-AO14","v":0},null,null,{"$f":"AU14-AR14","v":1439057},null,null,{"$f":"AX14-AU14","v":2418509},null,null,{"$f":"BA14-AX14","v":0},null,null,{"$f":"BD14-BA14","v":0},null,null,{"$f":"BG14-BD14","v":0},null,null,{"$f":"BJ14-BG14","v":-1747519}]
["Net income",null,null,null,null,null,null,null,null,null,0,null,{"$f":"M15-K15","v":54495},{"$f":"N15-K15","v":54495},null,null,{"$f":"Q15-N15","v":81537},null,null,{"$f":"T15-Q15","v":66377},null,null,{"$f":"W15-T15","v":238702},null,null,{"$f":"Z15-W15","v":102346},null,null,{"$f":"AC15-Z15","v":-192260},null,null,{"$f":"AF15-AC15","v":266958},null,null,{"$f":"AI15","v":265176},null,null,{"$f":"AL15-AI15","v":265176},null,null,{"$f":"AO15-AL15","v":265176},null,null,{"$f":"AR15-AO15","v":265176},null,null,{"$f":"AU15-AR15","v":265177},null,null,{"$f":"AX15","v":-4537049},null,null,{"$f":"BA15","v":126539},null,null,{"$f":"BD15-BA15","v":126539},null,null,{"$f":"BG15-BD15","v":126539},null,null,{"$f":"BJ15-BG15","v":126540}]
["Retained earnings",null,null,null,null,null,null,null,null,null,1368133,null,{"$f":"M16-K16","v":80},{"$f":"N16-K16","v":80},null,null,{"$f":"Q16-N16","v":-1281204},null,null,{"$f":"T16-Q16","v":0},null,null,{"$f":"W16-T16","v":0},null,null,{"$f":"Z16-W16","v":0},null,null,{"$f":"AC16-Z16","v":0},null,null,{"$f":"AF16-AC16","v":0},null,null,{"$f":"AI16-AF16-AF15","v":0},null,null,{"$f":"AL16-AI16","v":0},null,null,{"$f":"AO16-AL16","v":0},null,null,{"$f":"AR16-AO16","v":0},null,null,{"$f":"AU16-AR16","v":6139},null,null,{"$f":"AX16-AU16-AU15","v":-1962982},null,null,{"$f":"BA16-AX16-AX15","v":0},null,null,{"$f":"BD16-BA16","v":0},null,null,{"$f":"BG16-BD16","v":0},null,null,{"$f":"BJ16-BG16","v":1699910}]
["Net assets",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K20:K23)","v":3958172},null,{"$f":"SUM(M20:M23)","v":28139},{"$f":"SUM(N20:N23)","v":28139},null,null,{"$f":"SUM(Q20:Q23)","v":-166439},null,null,{"$f":"SUM(T20:T23)","v":61835},null,null,{"$f":"SUM(W20:W23)","v":638139},null,null,{"$f":"SUM(Z20:Z23)","v":695183},null,null,{"$f":"SUM(AC20:AC23)","v":-199249},null,null,{"$f":"SUM(AF20:AF23)","v":3488792},null,null,{"$f":"SUM(AI20:AI23)","v":2929486},null,null,{"$f":"SUM(AL20:AL23)","v":600866},null,null,{"$f":"SUM(AO20:AO23)","v":3033593},null,null,{"$f":"SUM(AR20:AR23)","v":496759},null,null,{"$f":"SUM(AU20:AU23)","v":1710373},null,null,{"$f":"SUM(AX20:AX23)","v":-2209215},null,null,{"$f":"SUM(BA20:BA23)","v":254232},null,null,{"$f":"SUM(BD20:BD23)","v":126539},null,null,{"$f":"SUM(BG20:BG23)","v":126539},null,null,{"$f":"SUM(BJ20:BJ23)","v":78931}]
[]
["Invest, \nKKZT",null,null,null,null,null,null,null,null,null,{"$f":"K4","v":1875680},null,null,{"$f":"K26+N4","v":2057993},null,null,{"$f":"N26+Q4","v":3039981},null,null,{"$f":"Q26+T4","v":3039981},null,null,{"$f":"T26+W4","v":3439981},null,null,{"$f":"W26+Z4","v":3994770},null,null,{"$f":"Z26+AC4","v":3994796},null,null,{"$f":"AC26+AF4","v":5507448},null,null,{"$f":"AF26+AI4","v":8170158},null,null,{"$f":"AI26+AL4","v":8327117},null,null,{"$f":"AL26+AO4","v":11035488},null,null,{"$f":"AO26+AR4","v":11335538},null,null,{"$f":"AR26+AU4","v":11335538},null,null,{"$f":"AU26+AX4","v":13207845},null,null,{"$f":"AX26+BA4","v":13335538},null,null,{"$f":"BA26+BD4","v":12774244},null,null,{"$f":"BD26+BG4","v":12060599},null,null,{"$f":"BG26+BJ4","v":12060599}]
[]
["TSC shares",null,null,null,null,null,null,null,null,null,{"$f":"K7","v":1988900},null,null,{"$f":"K28+N7","v":2171213},null,null,{"$f":"N28+Q7","v":3153201},null,null,{"$f":"Q28+T7","v":3153201},null,null,{"$f":"T28+W7","v":3553201},null,null,{"$f":"W28+Z7","v":4107990},null,null,{"$f":"Z28+AC7","v":4108016},null,null,{"$f":"AC28+AF7","v":6656775},null,null,{"$f":"AF28+AI7","v":9319485},null,null,{"$f":"AI28+AL7","v":9475035},null,null,{"$f":"AL28+AO7","v":12182052},null,null,{"$f":"AO28+AR7","v":12482052},null,null,{"$f":"AR28+AU7","v":12482052},null,null,{"$f":"AU28+AX7","v":14354359},null,null,{"$f":"AX28+BA7","v":14482052},null,null,{"$f":"BA28+BD7","v":13872500},null,null,{"$f":"BD28+BG7","v":13097500},null,null,{"$f":"BG28+BJ7","v":13097500}]
["NCI shares",null,null,null,null,null,null,null,null,null,{"$f":"K8","v":257710},null,null,{"$f":"K29+N8","v":75397},null,null,{"$f":"N29+Q8","v":110823},null,null,{"$f":"Q29+T8","v":146629},null,null,{"$f":"T29+W8","v":146629},null,null,{"$f":"W29+Z8","v":185008},null,null,{"$f":"Z29+AC8","v":196982},null,null,{"$f":"AC29+AF8","v":843225},null,null,{"$f":"AF29+AI8","v":844825},null,null,{"$f":"AI29+AL8","v":1024965},null,null,{"$f":"AL29+AO8","v":1086365},null,null,{"$f":"AO29+AR8","v":1017948},null,null,{"$f":"AR29+AU8","v":1017948},null,null,{"$f":"AU29+AX8","v":1017948},null,null,{"$f":"AX29+BA8","v":1017948},null,null,{"$f":"BA29+BD8","v":1627500},null,null,{"$f":"BD29+BG8","v":2402500},null,null,{"$f":"BG29+BJ8","v":2402500}]
["Share-holding",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K28/K13,0%)","v":0.885289391572191},null,null,{"$f":"IFERROR(N28/N13,0%)","v":0.96643965797356912},null,null,{"$f":"IFERROR(Q28/Q13,0%)","v":0.96604712465349518},null,null,{"$f":"IFERROR(T28/T13,0%)","v":0.95556468060475841},null,null,{"$f":"IFERROR(W28/W13,0%)","v":0.96036871964387549},null,null,{"$f":"IFERROR(Z28/Z13,0%)","v":0.95690470855099397},null,null,{"$f":"IFERROR(AC28/AC13,0%)","v":0.95424341660553613},null,null,{"$f":"IFERROR(AF28/AF13,0%)","v":0.88756999999999997},null,null,{"$f":"IFERROR(AI28/AI13,0%)","v":0.91688319226784698},null,null,{"$f":"IFERROR(AL28/AL13,0%)","v":0.90238428571428575},null,null,{"$f":"IFERROR(AO28/AO13,0%)","v":0.91812399323898242},null,null,{"$f":"IFERROR(AR28/AR13,0%)","v":0.92459644444444444},null,null,{"$f":"IFERROR(AU28/AU13,0%)","v":0.92459644444444444},null,null,{"$f":"IFERROR(AX28/AX13,0%)","v":0.933780401341191},null,null,{"$f":"IFERROR(BA28/BA13,0%)","v":0.934325935483871},null,null,{"$f":"IFERROR(BD28/BD13,0%)","v":0.89500000000000002},null,null,{"$f":"IFERROR(BG28/BG13,0%)","v":0.84499999999999997},null,null,{"$f":"IFERROR(BJ28/BJ13,0%)","v":0.84499999999999997},null,null,null,null,null,null,null,null,{"$f":"BD30-BA30","v":-3.9325935483870977E-2},{"$f":"BG30-BD30","v":-5.0000000000000044E-2}]
["NCI share",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K29/K13,0)","v":0.11471060842780902},null,null,{"$f":"IFERROR(N29/N13,0)","v":3.3560342026430934E-2},null,null,{"$f":"IFERROR(Q29/Q13,0)","v":3.3952875346504804E-2},null,null,{"$f":"IFERROR(T29/T13,0)","v":4.4435319395241576E-2},null,null,{"$f":"IFERROR(W29/W13,0)","v":3.9631280356124468E-2},null,null,{"$f":"IFERROR(Z29/Z13,0)","v":4.3095291449006035E-2},null,null,{"$f":"IFERROR(AC29/AC13,0)","v":4.5756583394463833E-2},null,null,{"$f":"IFERROR(AF29/AF13,0)","v":0.11243},null,null,{"$f":"IFERROR(AI29/AI13,0)","v":8.3116807732152992E-2},null,null,{"$f":"IFERROR(AL29/AL13,0)","v":9.7615714285714292E-2},null,null,{"$f":"IFERROR(AO29/AO13,0)","v":8.1876006761017542E-2},null,null,{"$f":"IFERROR(AR29/AR13,0)","v":7.5403555555555557E-2},null,null,{"$f":"IFERROR(AU29/AU13,0)","v":7.5403555555555557E-2},null,null,{"$f":"IFERROR(AX29/AX13,0)","v":6.6219598658808984E-2},null,null,{"$f":"IFERROR(BA29/BA13,0)","v":6.5674064516129033E-2},null,null,{"$f":"IFERROR(BD29/BD13,0)","v":0.105},null,null,{"$f":"IFERROR(BG29/BG13,0)","v":0.155},null,null,{"$f":"IFERROR(BJ29/BJ13,0)","v":0.155}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K31-N31","v":8.1150266401378082E-2},null,null,{"$f":"N31-Q31","v":-3.9253332007387065E-4},null,null,{"$f":"Q31-T31","v":-1.0482444048736772E-2},null,null,{"$f":"T31-W31","v":4.8040390391171084E-3},null,null,{"$f":"W31-Z31","v":-3.4640110928815665E-3},null,null,{"$f":"Z31-AC31","v":-2.6612919454577985E-3},null,null,{"$f":"AC31-AF31","v":-6.6673416605536162E-2},null,null,{"$f":"AF31-AI31","v":2.931319226784701E-2},null,null,{"$f":"AI31-AL31","v":-1.44989065535613E-2},null,null,{"$f":"AL31-AO31","v":1.573970752469675E-2},null,null,{"$f":"AO31-AR31","v":6.4724512054619848E-3},null,null,{"$f":"AR31-AU31","v":0},null,null,{"$f":"AU31-AX31","v":9.1839568967465729E-3},null,null,{"$f":"AX31-BA31","v":5.4553414267995148E-4},null,null,{"$f":"BA31-BD31","v":-3.9325935483870963E-2},null,null,{"$f":"BD31-BG31","v":-0.05},null,null,{"$f":"BG31-BJ31","v":0}]
[]
["MI (I)",null,null,null,null,null,null,null,null,null,{"$f":"K17*K31","v":454044.31838191766},null,{"$f":"M17*K31","v":457272.1601924678},{"$f":"N17*N31","v":133781.96058372394},null,{"$f":"P17*N31","v":128196.21081718679},{"$f":"Q17*Q31","v":129695.637855604},null,{"$f":"S17*Q31","v":130579.39724799817},{"$f":"T17*T31","v":172484.89034374501},null,{"$f":"V17*T31","v":183066.67286920841},{"$f":"W17*W31","v":179127.28399250776},null,{"$f":"Y17*W31","v":183170.26905803778},{"$f":"Z17*Z31","v":224743.19467001848},null,{"$f":"AB17*Z31","v":215639.35744670741},{"$f":"AC17*AC31","v":229504.95585828379},null,{"$f":"AE17*AC31","v":242947.78249374335},{"$f":"AF17*AF31","v":956169.02996000007},null,{"$f":"AH17*AF31","v":985982.76763999998},{"$f":"AI17*AI31","v":950362.40038428572},null,{"$f":"AK17*AI31","v":972402.98299146723},{"$f":"AL17*AL31","v":1174797.7026342859},null,{"$f":"AN17*AL31","v":1200683.0472857144},{"$f":"AO17*AO31","v":1233749.9997705077},null,{"$f":"AQ17*AO31","v":1255461.5517393674},{"$f":"AR17*AR31","v":1173677.1536035556},null,{"$f":"AT17*AR31","v":1302645.3591297779},{"$f":"AU17*AU31","v":1302645.3591297779},null,{"$f":"AW17*AU31","v":994884.08825155557},{"$f":"AX17*AX31","v":997693.21269943402},null,{"$f":"AZ17*AX31","v":1006072.5744941211},{"$f":"BA17*BA31","v":1006170.4073140646},null,{"$f":"BC17*BA31","v":1014480.737763871},{"$f":"BD17*BD31","v":1621956.5249999999},null,{"$f":"BF17*BD31","v":1635243.1199999999},{"$f":"BG17*BG31","v":2413930.3199999998},null,{"$f":"BI17*BG31","v":2426164.625},{"$f":"BJ17*BJ31","v":2426164.625}]
["MI (II)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2007-01-01","2008-01-01","2009-01-01","2010-01-01"]
["Dr Net assets",null,null,null,null,null,null,null,null,null,{"$f":"K17","v":3958172},null,{"$f":"M17-K17","v":28139},{"$f":"N17-M17","v":0},null,{"$f":"P17-N17","v":-166439},null,null,{"$f":"S17-Q17","v":26029},{"$f":"T17-S17","v":35806},null,{"$f":"V17-T17","v":238139},{"$f":"W17-V17","v":400000},null,{"$f":"Y17-W17","v":102015},{"$f":"Z17-Y17","v":593168},null,{"$f":"AB17-Z17","v":-211249},{"$f":"AC17-AB17","v":12000},null,{"$f":"AE17-AC17","v":293790},{"$f":"AF17-AE17","v":3195002},null,{"$f":"AH17-AF17","v":265176},{"$f":"AI17-AH17","v":2664310},null,{"$f":"AK17-AI17","v":265176},{"$f":"AL17-AK17","v":335690},null,{"$f":"AN17-AL17","v":265176},{"$f":"AO17-AN17","v":2768417},null,{"$f":"AQ17-AO17","v":265176},{"$f":"AR17-AQ17","v":231583},null,{"$f":"AT17-AR17","v":1710373},{"$f":"AU17-AT17","v":0},null,{"$f":"AW17-AU17","v":-4081522},{"$f":"AX17-AW17","v":1872307},null,{"$f":"AZ17-AX17","v":126539},{"$f":"BA17-AZ17","v":127693},null,{"$f":"BC17-BA17","v":126539},{"$f":"BD17-BC17","v":0},null,{"$f":"BF17-BD17","v":126539},{"$f":"BG17-BF17","v":0},null,{"$f":"BI17-BG17","v":78931},{"$f":"BJ17-BI17","v":0},null,null,null,null,null,null,null,"NA",{"$f":"ROUND(SUM(K37:AF37),0)","v":8504572},{"$f":"ROUND(SUM(K37:AT37),0)","v":17275649},{"$f":"ROUND(SUM(K37:AX37),0)","v":15066434},{"$f":"ROUND(SUM(K37:BJ37),0)","v":15652675}]
["Cr Net income",null,null,null,null,null,null,null,null,null,{"$f":"K15*K30","v":0},null,{"$f":"((M15)*K30) * -1","v":-48243.845393726551},null,null,{"$f":"((P15-N15)*N30) * -1","v":-78800.590392190905},null,null,{"$f":"((S15-Q15)*Q30) * -1","v":-64123.309993125047},null,null,{"$f":"((V15-T15)*T30) * -1","v":-228095.20038971704},null,null,{"$f":"((Y15-W15)*W30) * -1","v":-98289.896980672085},null,null,{"$f":"((AB15-Z15)*Z30) * -1","v":183974.49926601411},null,null,{"$f":"((AE15-AC15)*AC30) * -1","v":-254742.91401018071},null,null,{"$f":"((AH15)*AF30) * -1","v":-235362.26231999998},null,null,{"$f":"((AK15-AI15)*AI30) * -1","v":-243135.41739281858},null,null,{"$f":"((AN15-AL15)*AL30) * -1","v":-239290.65534857142},null,null,{"$f":"((AQ15-AO15)*AO30) * -1","v":-243464.4480311404},null,null,{"$f":"((AT15-AR15)*AR30) * -1","v":-245181.71134844446},null,null,{"$f":"((AW15)*AU30) * -1","v":4194939.3736702222},null,null,{"$f":"((AZ15)*AX30) * -1","v":-118159.63820531296},null,null,{"$f":"((BC15-BA15)*BA30) * -1","v":-118228.66955019355},null,null,{"$f":"((BF15-BD15)*BD30) * -1","v":-113252.405},null,null,{"$f":"((BI15-BG15)*BG30) * -1","v":-106926.3},null,null,null,null,null,null,null,null,"NI",{"$f":"ROUND(SUM(K38:AF38),0)","v":-588321},{"$f":"ROUND(SUM(K38:AT38),0)","v":-1794756},{"$f":"ROUND(SUM(K38:AX38),0)","v":2400184},{"$f":"ROUND(SUM(AZ38:BJ38),0)","v":-456567}]
["Dr Reserves",null,null,null,null,null,null,null,null,null,0,null,{"$f":"((M14-K14)*K30) * -1","v":23403.510355602441},null,null,{"$f":"((P14-N14)*N30) * -1","v":-15283.276751194022},null,null,{"$f":"((S14-Q14)*Q30) * -1","v":38978.069385519222},null,null,{"$f":"((V14-T14)*T30) * -1","v":537.98291518047904},null,null,{"$f":"((Y14-W14)*W30) * -1","v":317.88204620212281},null,null,{"$f":"((AB14-Z14)*Z30) * -1","v":18170.663510674825},null,null,{"$f":"((AE14-AC14)*AC30) * -1","v":-25604.259354359747},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((AT14-AR14)*AR30) * -1","v":-1330546.9855528888},null,null,{"$f":"((AW14-AU14)*AU30) * -1","v":-2236144.8222568887},null,null,{"$f":"((AZ14-AX14)*AX30) * -1","v":0},null,null,{"$f":"((BC14-BA14)*BA30) * -1","v":0},null,null,{"$f":"((BF14-BD14)*BD30) * -1","v":0},null,null,{"$f":"(-(BI14-BG14+1699910)*BG30)","v":40229.604999999996},null,null,null,null,null,null,null,null,"RE",40521,{"$f":"ROUND(SUM(K39:AT39),0)","v":-1290026},-3526171,{"$f":"ROUND(SUM(K39:BJ39),0)+ROUND(SUM(K38:AX38),0)","v":-1085758},null,{"$f":"ROUND(SUM(AY39:BJ39),0)","v":40230}]
["Dividends (Group)",null,null,null,null,null,null,null,null,null,0,null,{"$f":"((M16-K16)*$N$30) * -1","v":-77.315172637885524},null,null,{"$f":"((P16-N16)*$N$30) * -1","v":254937.1173768478},null,null,{"$f":"((S16-Q16)*$N$30) * -1","v":0},null,null,{"$f":"((V16-T16)*$N$30) * -1","v":0},null,null,{"$f":"((Y16-W16)*$N$30) * -1","v":0},null,null,{"$f":"((AB16-Z16)*$N$30) * -1","v":0},null,null,{"$f":"((AE16-AC16)*$N$30) * -1","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"((BI16-BG16-1699910)*$N$30) * -1","v":0},null,null,null,null,null,null,null,null,"RE",254860,254860,254860,{"$f":"ROUND(SUM(K40:BJ40),0)","v":254860}]
["Dividends (NCI)",null,null,null,null,null,null,null,null,null,0,null,{"$f":"((M16-K16)+M40) * -1","v":-2.6848273621144756},null,null,{"$f":"((P16-N16)+P40) * -1","v":8852.8826231521962},null,null,{"$f":"((S16-Q16)+S40) * -1","v":0},null,null,{"$f":"((V16-T16)+V40) * -1","v":0},null,null,{"$f":"((Y16-W16)+Y40) * -1","v":0},null,null,{"$f":"((AB16-Z16)+AB40) * -1","v":0},null,null,{"$f":"((AE16-AC16)+AE40) * -1","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,"RE",8850,8850,8850,8850]
["Dr Deemed disposal",null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"N54","v":-141177.19960874412},null,null,{"$f":"Q54+271","v":983758.4270384172},null,null,{"$f":"T54","v":6099.4930957471952},null,null,{"$f":"W54","v":-3939.3888767007738},null,null,{"$f":"Z54","v":3193.9256119811907},null,null,{"$f":"AC54","v":1891.5984115758911},null,null,{"$f":"AF54","v":-969128.75253374316},null,null,{"$f":"AI54","v":-37220.367255713791},null,null,{"$f":"AL54","v":23663.719642817974},null,null,{"$f":"AO54","v":-26979.047515204176},null,null,{"$f":"AR54","v":-13317.398135812953},null,null,{"$f":"AU54","v":0},null,null,{"$f":"AX54","v":2809.1244478784502},null,null,{"$f":"BA54","v":97.832819942384958},null,null,{"$f":"BD54","v":46181.787236129865},null,null,{"$f":"BG54","v":65042.200000001118},null,null,{"$f":"BJ54","v":0},null,null,null,null,null,null,null,"APIC",-119302,-173155,-170346,-59024]
["NCI",null,null,null,null,null,null,null,null,null,{"$f":"(K17*K31) * -1","v":-454044.31838191766},null,{"$f":"((SUM(M14:M15)-SUM(K14:K15))*K31) * -1","v":-3218.6649618758934},{"$f":"(N54+N8) * -1","v":323490.19960874412},null,{"$f":"((SUM(P14:P15)-SUM(N14:N15))*N31) * -1","v":-3267.1328566150778},{"$f":"(Q42+Q46) * -1","v":-1770.4270384171978},null,{"$f":"((SUM(S14:S15)-SUM(Q14:Q15))*Q31) * -1","v":-883.75939239417357},{"$f":"((T13-S13)-T4+T54) * -1","v":-41905.493095747195},null,{"$f":"((SUM(V14:V15)-SUM(T14:T15))*T31) * -1","v":-10581.782525463434},{"$f":"((W13-V13)-W4+W54) * -1","v":3939.3888767007738},null,{"$f":"((SUM(Y14:Y15)-SUM(W14:W15))*W31) * -1","v":-4042.9850655300374},{"$f":"((Z13-Y13)-Z4+Z54) * -1","v":-41572.925611981191},null,{"$f":"((SUM(AB14:AB15)-SUM(Z14:Z15))*Z31) * -1","v":9103.8372233110749},{"$f":"((AC13-AB13)-AC4+AC54) * -1","v":-13865.598411575891},null,{"$f":"((SUM(AE14:AE15)-SUM(AC14:AC15))*AC31) * -1","v":-13442.826635459529},{"$f":"((AF13-AE13)-AF4+AF54) * -1","v":-713221.24746625684},null,{"$f":"((SUM(AH14:AH15)-SUM(AF14))*AF31) * -1","v":-29813.737680000002},{"$f":"(AI54+AI8) * -1","v":35620.367255713791},null,{"$f":"((SUM(AK14:AK15)-SUM(AI14:AI15))*AI31) * -1","v":-22040.582607181401},{"$f":"((AL13-AK13)-AL4+AL54) * -1","v":-202394.71964281797},null,{"$f":"((SUM(AN14:AN15)-SUM(AL14:AL15))*AL31) * -1","v":-25885.344651428572},{"$f":"((AO13-AN13)-AO4+AO54) * -1","v":-33066.952484795824},null,{"$f":"((SUM(AQ14:AQ15)-SUM(AO14:AO15))*AO31) * -1","v":-21711.551968859589},{"$f":"((AR13-AQ13)-AR4+AR54) * -1","v":81784.398135812953},null,{"$f":"((AT17-AR17)*AR31) * -1","v":-128968.20552622223},{"$f":"(AU54+AU8) * -1","v":0},null,{"$f":"((AW17-AU17)*AU31) * -1","v":307761.27087822225},{"$f":"(AX54+AX8) * -1","v":-2809.1244478784502},null,{"$f":"((SUM(AZ14:AZ15)-SUM(AX14))*AX31) * -1","v":-8379.3617946870309},{"$f":"(BA54+BA8) * -1","v":-97.832819942384958},null,{"$f":"((SUM(BC14:BC15)-SUM(BA14:BA15))*BA31) * -1","v":-8310.3304498064517},{"$f":"((BD13-BC13)-BD4+BD54) * -1","v":-607475.78723612987},null,{"$f":"((SUM(BF14:BF15)-SUM(BD14:BD15))*BD31) * -1","v":-13286.594999999999},{"$f":"((BG13-BF13)-BG4+BG54) * -1","v":-778687.20000000112},null,{"$f":"((SUM(BI14:BI15)-SUM(BG14:BG15)+1699910)*BG31) * -1","v":-12234.305},{"$f":"(BJ54+BJ8) * -1","v":0},null,null,null,null,null,null,null,"NCI",-965284,-1311760,-1006808,-2435279]
["Retained earnings",null,null,null,null,null,null,null,null,null,{"$f":"(K17*K30+K46) * -1","v":-1628447.6816180823},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((AT16-AR16)*AR30) * -1","v":-5676.0975724444443},null,null,{"$f":"((AW16-AU16-AU15)*AU30) * -1","v":1814966.1777084444},null,null,0,null,0,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,"APIC",-1628448,-1634124,180842,180842]
["Cr Other equity",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APIC",0,0,0,0]
["Investments (paid in cash)",null,null,null,null,null,null,null,null,null,{"$f":"(K4) * -1","v":-1875680},null,null,{"$f":"(N4) * -1","v":-182313},null,null,{"$f":"(Q4) * -1","v":-981988},null,null,{"$f":"(T4) * -1","v":0},null,null,{"$f":"(W4) * -1","v":-400000},null,null,{"$f":"(Z4) * -1","v":-554789},null,null,{"$f":"(AC4) * -1","v":-26},null,null,{"$f":"(AF4) * -1","v":-1512652},null,null,{"$f":"(AI4) * -1","v":-2662710},null,null,{"$f":"(AL4) * -1","v":-156959},null,null,{"$f":"(AO4) * -1","v":-2708371},null,null,{"$f":"(AR4) * -1","v":-300050},null,null,{"$f":"(AU4) * -1","v":0},null,null,{"$f":"(AX4) * -1","v":-1872307},null,null,{"$f":"(BA4) * -1","v":-127693},null,null,{"$f":"(BD4) * -1","v":561294},null,null,{"$f":"(BG4) * -1","v":713645},null,null,{"$f":"(BJ7) * -1","v":0},null,null,null,null,null,null,null,"INV",-5507448,-11335538,-13207845,-12060599]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K37:K46)","v":0},null,{"$f":"SUM(M37:M46)","v":-4.0927261579781771E-12},{"$f":"SUM(N37:N46)","v":0},null,{"$f":"SUM(P37:P46)","v":-1.546140993013978E-11},{"$f":"SUM(Q37:Q46)","v":0},null,{"$f":"SUM(S37:S46)","v":1.3642420526593924E-12},{"$f":"SUM(T37:T46)","v":0},null,{"$f":"SUM(V37:V46)","v":0},{"$f":"SUM(W37:W46)","v":0},null,{"$f":"SUM(Y37:Y46)","v":0},{"$f":"SUM(Z37:Z46)","v":0},null,{"$f":"SUM(AB37:AB46)","v":1.4551915228366852E-11},{"$f":"SUM(AC37:AC46)","v":0},null,{"$f":"SUM(AE37:AE46)","v":0},{"$f":"SUM(AF37:AF46)","v":0},null,{"$f":"SUM(AH37:AH46)","v":0},{"$f":"SUM(AI37:AI46)","v":0},null,{"$f":"SUM(AK37:AK46)","v":0},{"$f":"SUM(AL37:AL46)","v":0},null,{"$f":"SUM(AN37:AN46)","v":0},{"$f":"SUM(AO37:AO46)","v":0},null,{"$f":"SUM(AQ37:AQ46)","v":0},{"$f":"SUM(AR37:AR46)","v":0},null,{"$f":"SUM(AT37:AT46)","v":4.2746250983327627E-11},{"$f":"SUM(AU37:AU46)","v":0},null,{"$f":"SUM(AW37:AW46)","v":0},{"$f":"SUM(AX37:AX46)","v":0},null,{"$f":"SUM(AZ37:AZ46)","v":5.4569682106375694E-12},{"$f":"SUM(BA37:BA46)","v":0},null,{"$f":"SUM(BC37:BC46)","v":1.8189894035458565E-12},{"$f":"SUM(BD37:BD46)","v":0},null,{"$f":"SUM(BF37:BF46)","v":1.8189894035458565E-12},{"$f":"SUM(BG37:BG46)","v":0},null,{"$f":"SUM(BI37:BI46)","v":-7.2759576141834259E-12},{"$f":"SUM(BJ37:BJ46)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(BS37:BS46)","v":0},{"$f":"SUM(BT37:BT46)","v":0},{"$f":"SUM(BU37:BU46)","v":0},{"$f":"SUM(BV37:BV46)","v":0},null,null,"Standalone","AJE so far"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"balance",2006,2007,2008,"Total",null,"AJE needed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA",{"$f":"BS37","v":8504572},17275649,15066434,15652675,null,null,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"SUM(BY49:CB49)","v":{"$error":"#REF!"}},null,{"$f":"BV49-CC49","v":{"$error":"#REF!"}},"NA"]
["GNA before",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M17*K30","v":3529038.8398075323},null,null,{"$f":"P17*N30","v":3691675.7891828134},null,null,{"$f":"S17*Q30","v":3715321.602752002},null,null,{"$f":"V17*T30","v":3936779.3271307917},null,null,{"$f":"Y17*W30","v":4438690.7309419625},null,null,{"$f":"AB17*Z30","v":4788140.6425532922},null,null,{"$f":"AE17*AC30","v":5066622.2175062569},null,null,{"$f":"AH17*AF30","v":7783765.2323599998},null,null,{"$f":"AK17*AI30","v":10726831.017008532},null,null,{"$f":"AN17*AL30","v":11099416.952714287},null,null,{"$f":"AQ17*AO30","v":14078231.448260631},null,null,{"$f":"AT17*AR30","v":15973003.640870223},null,null,{"$f":"AW17*AU30","v":12199242.911748445},null,null,{"$f":"AZ17*AX30","v":14186900.425505878},null,null,{"$f":"BC17*BA30","v":14432724.262236129},null,null,{"$f":"BF17*BD30","v":13938500.880000001},null,null,{"$f":"BI17*BG30","v":13226510.375},null,null,null,null,null,null,null,"NI",-588321,-1794756,2400184,-456567,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},null,{"$f":"BV50-CC50","v":{"$error":"#REF!"}},"NI",-506157,{"$f":"CG50-CE50","v":{"$error":"#REF!"}}]
["GNA after",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(N17*N30) * -1","v":-3852529.0394162764},null,null,{"$f":"(Q17*Q30) * -1","v":-3690176.3621443962},null,null,{"$f":"(T17*T30) * -1","v":-3709222.1096562548},null,null,{"$f":"(W17*W30) * -1","v":-4340718.7160074925},null,null,{"$f":"(Z17*Z30) * -1","v":-4990285.8053299813},null,null,{"$f":"(AC17*AC30) * -1","v":-4786275.0441417163},null,null,{"$f":"(AF17*AF30) * -1","v":-7548402.97004},null,null,{"$f":"(AI17*AI30) * -1","v":-10483695.599615714},null,null,{"$f":"(AL17*AL30) * -1","v":-10860126.297365714},null,null,{"$f":"(AO17*AO30) * -1","v":-13834767.000229491},null,null,{"$f":"(AR17*AR30) * -1","v":-14391598.846396444},null,null,{"$f":"(AU17*AU30) * -1","v":-15973003.640870223},null,null,{"$f":"(AX17*AX30) * -1","v":-14068740.787300566},null,null,{"$f":"(BA17*BA30) * -1","v":-14314495.592685936},null,null,{"$f":"(BD17*BD30) * -1","v":-13825248.475},null,null,{"$f":"(BG17*BG30) * -1","v":-13159813.68},null,null,{"$f":"(BJ17*BJ30) * -1","v":-13226510.375},null,null,null,null,null,null,null,"RES",{"$f":"BS39","v":40521},{"$f":"BT39","v":-1290026},{"$f":"BU39","v":-3526171},{"$f":"#REF!+#REF!+#REF!+NCI_TSB!BX39","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},null,{"$error":"#REF!"},"RES",355252,{"$f":"CG51-CE51","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N50:N51)","v":-323490.19960874412},null,null,{"$f":"SUM(Q50:Q51)","v":1499.4270384171978},null,null,{"$f":"SUM(T50:T51)","v":6099.4930957471952},null,null,{"$f":"SUM(W50:W51)","v":-403939.38887670077},null,null,{"$f":"SUM(Z50:Z51)","v":-551595.07438801881},null,null,{"$f":"SUM(AC50:AC51)","v":1865.5984115758911},null,null,{"$f":"SUM(AF50:AF51)","v":-2481780.7525337432},null,null,{"$f":"SUM(AI50:AI51)","v":-2699930.3672557138},null,null,{"$f":"SUM(AL50:AL51)","v":-133295.28035718203},null,null,{"$f":"SUM(AO50:AO51)","v":-2735350.0475152042},null,null,{"$f":"SUM(AR50:AR51)","v":-313367.39813581295},null,null,{"$f":"SUM(AU50:AU51)","v":0},null,null,{"$f":"SUM(AX50:AX51)","v":-1869497.8755521215},null,null,{"$f":"SUM(BA50:BA51)","v":-127595.16718005762},null,null,{"$f":"SUM(BD50:BD51)","v":607475.78723612987},null,null,{"$f":"SUM(BG50:BG51)","v":778687.20000000112},null,null,{"$f":"SUM(BJ50:BJ51)","v":0},null,null,null,null,null,null,null,"RE",{"$f":"SUM(BS40:BS41)","v":263710},{"$f":"SUM(BT40:BT41)","v":263710},{"$f":"SUM(BU40:BU41)","v":263710},{"$f":"SUM(BV40:BV41)+1329306","v":1593016},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},-904795,145438,-347699,{"$error":"#REF!"},null,{"$error":"#REF!"},"RE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(N46) * -1","v":182313},null,null,{"$f":"(Q46) * -1","v":981988},null,null,{"$f":"(T46) * -1","v":0},null,null,{"$f":"(W46) * -1","v":400000},null,null,{"$f":"(Z46) * -1","v":554789},null,null,{"$f":"(AC46) * -1","v":26},null,null,{"$f":"(AF46) * -1","v":1512652},null,null,{"$f":"(AI46) * -1","v":2662710},null,null,{"$f":"(AL46) * -1","v":156959},null,null,{"$f":"(AO46) * -1","v":2708371},null,null,{"$f":"(AR46) * -1","v":300050},null,null,{"$f":"(AU46) * -1","v":0},null,null,{"$f":"(AX46) * -1","v":1872307},null,null,{"$f":"(BA46) * -1","v":127693},null,null,{"$f":"(BD46) * -1","v":-561294},null,null,{"$f":"(BG46) * -1","v":-713645},null,null,{"$f":"(BJ46) * -1","v":0},null,null,null,null,null,null,null,"APIC",{"$f":"BS42+BS44+BS45","v":-1747750},{"$f":"BT42+BT44+BT45","v":-1807279},{"$f":"BU42+BU44+BU45","v":10496},{"$f":"BV42+BV44+BV45","v":121818},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},-88708,-42211,null,{"$error":"#REF!"},null,{"$error":"#REF!"},"APIC",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"CG53-CE53","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N52:N53)","v":-141177.19960874412},null,null,{"$f":"SUM(Q52:Q53)","v":983487.4270384172},null,null,{"$f":"SUM(T52:T53)","v":6099.4930957471952},null,null,{"$f":"SUM(W52:W53)","v":-3939.3888767007738},null,null,{"$f":"SUM(Z52:Z53)","v":3193.9256119811907},null,null,{"$f":"SUM(AC52:AC53)","v":1891.5984115758911},null,null,{"$f":"SUM(AF52:AF53)","v":-969128.75253374316},null,null,{"$f":"SUM(AI52:AI53)","v":-37220.367255713791},null,null,{"$f":"SUM(AL52:AL53)","v":23663.719642817974},null,null,{"$f":"SUM(AO52:AO53)","v":-26979.047515204176},null,null,{"$f":"SUM(AR52:AR53)","v":-13317.398135812953},null,null,{"$f":"SUM(AU52:AU53)","v":0},null,null,{"$f":"SUM(AX52:AX53)","v":2809.1244478784502},null,null,{"$f":"SUM(BA52:BA53)","v":97.832819942384958},null,null,{"$f":"SUM(BD52:BD53)","v":46181.787236129865},null,null,{"$f":"SUM(BG52:BG53)","v":65042.200000001118},null,null,{"$f":"SUM(BJ52:BJ53)","v":0},null,null,null,null,null,null,null,"NCI",{"$f":"BS43","v":-965284},{"$f":"BT43","v":-1311760},{"$f":"BU43","v":-1006808},{"$f":"BV43","v":-2435279},null,null,0,-943806,-275137,347699,-871244,null,-1564035,"NCI",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"CG54-CE54","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INV",{"$f":"BS46","v":-5507448},{"$f":"BT46","v":-11335538},{"$f":"BU46","v":-13207845},{"$f":"BV46","v":-12060599},null,null,-15500000,1937309,171910,0,-13390781,null,1330182,"INV",-12060599,{"$f":"CG55-CE55","v":-13390781}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BY49:BY55)","v":{"$error":"#REF!"}},{"$f":"SUM(BZ49:BZ55)","v":0},{"$f":"SUM(CA49:CA55)","v":0},{"$f":"SUM(CB49:CB55)","v":0},{"$f":"SUM(CC49:CC55)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-14169818]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-12060599]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BV49:BV55)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"CE57-CE58","v":-2109219}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3439401]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CE49:CE55)","v":{"$error":"#REF!"}}]

{"sheet":"TSC_IP_ext","index":5,"n_rows":148,"n_cols":14,"rows_kept":148,"cut":false,"hidden":true,"merged":[]}
["№ п/п","Наименование","Наименование в 2009 г.",null,null,"Сравнительный \nподход, тенге","Затратный \nподход, тенге","Доходный подход, тенге","Fair value 31/12/2010","Fair value 31/12/2009",null,"Area","Per FAS"]
[null,"Бар \"ПАБ\" пр. Республики д. 5, ВП-4"," Бар \"ПАБ\" пр.Республики 5-46    (45 м2) №: 00082",null,null,906.42309999999998,12105.7045,null,9305.884]
[null,"1.Земельный участок площадью 39кв.м.пр. Республики,д. 5,  ВП - 4.",null,null,null,251.94,679.51400000000001,null,679.51400000000001]
[1,"Бар \"ПАБ\" пр. Республики д. 5, ВП-4"," Бар \"ПАБ\" пр.Республики 5-46    (45 м2) №: 00082",{"$f":"C4","v":" Бар \"ПАБ\" пр.Республики 5-46    (45 м2) №: 00082"},null,{"$f":"SUM(F2:F3)","v":1158.3631},{"$f":"SUM(G2:G3)","v":12785.218499999999},{"$f":"SUM(H2:H3)","v":0},{"$f":"SUM(I2:I3)","v":9985.3979999999992},9567.5481]
[]
[null,"Гостиница \"Тенгри\" ул. Вавилова №1"," Гостиница \"Тенгри\"   Астана, ул.Вавилова 1а   (8719,5 м2) №: 05205",null,null,247021.85980000001,1248251.8287,1780322.777,1648999.9990000001]
[null,"2.Земельный участок площадью 2792кв.м. , ул. Вавилова  №1а.",null,null,null,15188.48,54311.004000000001,null,54311.004000000001]
[2,"Гостиница \"Тенгри\" ул. Вавилова №1"," Гостиница \"Тенгри\"   Астана, ул.Вавилова 1а   (8719,5 м2) №: 05205",{"$f":"C8","v":" Гостиница \"Тенгри\"   Астана, ул.Вавилова 1а   (8719,5 м2) №: 05205"},null,{"$f":"SUM(F6:F7)","v":262210.33980000002},{"$f":"SUM(G6:G7)","v":1302562.8326999999},{"$f":"SUM(H6:H7)","v":1780322.777},{"$f":"SUM(I6:I7)","v":1703311.003},1723208.3533000001,"x"]
[]
[null,"Магазин \"Шапагат\" пр. Республики, д. 21, ВП-7"," Магазин \"Шапагат\" пр Республики 21 (415,6 м2) №: 00074",null,null,7090.4835000000003,83489.265599999999,215740.66800000001,114497.501]
[null,"3.Земельный участок площадью 104кв.м. пр. Республики, д 21,ВП 7.",null,null,null,671.84,1811.9882,null,1811.9882]
[3,"Магазин \"Шапагат\" пр. Республики, д. 21, ВП-7"," Магазин \"Шапагат\" пр Республики 21 (415,6 м2) №: 00074",{"$f":"C12","v":" Магазин \"Шапагат\" пр Республики 21 (415,6 м2) №: 00074"},"PPE",{"$f":"SUM(F10:F11)","v":7762.3235000000004},{"$f":"SUM(G10:G11)","v":85301.253800000006},{"$f":"SUM(H10:H11)","v":215740.66800000001},{"$f":"SUM(I10:I11)","v":116309.48920000001},113780.82010000001,"x"]
[]
[null,"Магазин пр. Республики, д. 21, ВП-8"," Магазин \"Глобус\" пр Республики 21 (255,3 м2) №: 00075",null,null,7259.3535000000002,51286.837100000004,79157.471000000005,56324.896999999997]
[null,"4.Земельный участок площадью 93кв.м. пр. Республики, д 21,ВП 8.",null,null,null,600.78,1620.3681999999999,null,1620.3681999999999]
[4,"Магазин пр. Республики, д. 21, ВП-8"," Магазин \"Глобус\" пр Республики 21 (255,3 м2) №: 00075",{"$f":"C16","v":" Магазин \"Глобус\" пр Республики 21 (255,3 м2) №: 00075"},null,{"$f":"SUM(F14:F15)","v":7860.1334999999999},{"$f":"SUM(G14:G15)","v":52907.205300000001},{"$f":"SUM(H14:H15)","v":79157.471000000005},{"$f":"SUM(I14:I15)","v":57945.265199999994},70307.775699999998]
[]
[null,"Офис ул. Бейбитшилик д. 45, кв. 35, 39"," Офис ул.Бейбитшилик, 45    (181,3 м2) №: 00080",null,null,1234.2257999999999,25063.436600000001,90204.441999999995,28753.601999999999]
[null,"5.Земельный участок площадью 52кв.м., ул. Бейбитшилик, д.45,кв.35",null,null,null,309.39999999999998,684.37819999999999,null,684.37819999999999]
[5,"Офис ул. Бейбитшилик д. 45, кв. 35, 39"," Офис ул.Бейбитшилик, 45    (181,3 м2) №: 00080"," Офис ул.Бейбитшилик, 45    (181,3 м2) №: 00080","PPE",{"$f":"SUM(F18:F19)","v":1543.6257999999998},{"$f":"SUM(G18:G19)","v":25747.8148},{"$f":"SUM(H18:H19)","v":90204.441999999995},{"$f":"SUM(I18:I19)","v":29437.980199999998},28760.918999999998]
[]
[null,"Магазин \"Колос\" ул. Бейбитшилик д. 34"," Магазин \"Колос\"  ул Бейбитшилик 34  (2362 м2) №: 00018",null,null,18822.6139,455450.89739999996,53159.851000000002,413507.93]
[null,"6.Земельный участок площадью 1663кв.м., ул. Бейбитшилик, д.34",null,null,null,10460.27,21884.9202,null,21884.9202]
[null,"Магазин \"Колос\" ул. Бейбитшилик д. 34"," Магазин \"Колос\"  ул Бейбитшилик 34  (2362 м2) №: 00018",{"$f":"C24","v":" Магазин \"Колос\"  ул Бейбитшилик 34  (2362 м2) №: 00018"},null,{"$f":"SUM(F22:F23)","v":29282.883900000001},{"$f":"SUM(G22:G23)","v":477335.81759999995},{"$f":"SUM(H22:H23)","v":53159.851000000002},{"$f":"SUM(I22:I23)","v":435392.85019999999},581782.31050000002,"x"]
[]
[null,"Административное здание ул. Бейбитшилик д. 43"," Офис ул.Бейбитшилик, 43   (3302,4 м2) №: 00084",null,null,131425.633,301286.34169999999,1558439.55,581166.701]
[null,"Проходная ул. Бейбитшилик д. 43"," Офис ул.Бейбитшилик, 43   (3302,4 м2) №: 00084",null,null,820.8,1204.6457,null,974.33799999999997]
[null,"Обменный пункт ул. Бейбитшилик д. 43"," Офис ул.Бейбитшилик, 43   (3302,4 м2) №: 00084",null,null,6189.3094000000001,15829.936300000001,null,9081.4979999999996]
[null,"Гаражи ул. Бейбитшилик д. 43"," Офис ул.Бейбитшилик, 43   (3302,4 м2) №: 00084",null,null,3503.1088999999997,13697.267300000001,null,6561.3559999999998]
[null,"7.Земельный участок площадью 2097кв.м. ул. Бейбитшилик, д.43",null,null,null,12477.15,27596.227999999999,null,27596.227999999999]
[7," Офис ул.Бейбитшилик, 43   (3302,4 м2) №: 00084"," Офис ул.Бейбитшилик, 43   (3302,4 м2) №: 00084",{"$f":"C31","v":" Офис ул.Бейбитшилик, 43   (3302,4 м2) №: 00084"},"PPE",{"$f":"SUM(F26:F30)","v":154416.00129999997},{"$f":"SUM(G26:G30)","v":359614.41899999999},{"$f":"SUM(H26:H30)","v":1558439.55},{"$f":"SUM(I26:I30)","v":625380.12100000004},833439.0469999999,"x",3376,500524,{"$f":"M31-I31","v":-124856.12100000004}]
[]
[null,"Торговый центр \"Ажар\" ул. Кошкарбаева д. 97"," Торговый центр \"Ажар\"   Астана, ул.Кошкарбаева 97    (5082,2 №: 01865",null,null,177866.63890000002,888391.97879999992,274177.098,791443.52399999998]
[null,"Склад-магазин, хол. пристройка ул. Кошкарбаева д. 97"," Торговый центр \"Ажар\"   Астана, ул.Кошкарбаева 97    (5082,2 №: 01865",null,null,3275.5312000000004,22374.989799999999,null,7477.4120000000003]
[null,"8.Земельный участок площадью 4940кв.м., ул. Кошкарбаева, д.97",null,null,null,30232.799999999999,59271.898399999998,null,59271.898399999998]
[8,"Торговый центр \"Ажар\" ул. Кошкарбаева д. 97"," Торговый центр \"Ажар\"   Астана, ул.Кошкарбаева 97    (5082,2 №: 01865",{"$f":"C36","v":" Торговый центр \"Ажар\"   Астана, ул.Кошкарбаева 97    (5082,2 №: 01865"},null,{"$f":"SUM(F33:F35)","v":211374.97010000001},{"$f":"SUM(G33:G35)","v":970038.86699999985},{"$f":"SUM(H33:H35)","v":274177.098},{"$f":"SUM(I33:I35)","v":858192.83439999993},857567.64179999998,"x"]
[]
[null,"Магазин пр. Абая д. 219/2"," Магазин \"Ажар\"   ул Абая  219/2    (478,8 м2) №: 00078",null,null,8607.5386999999992,92136.269,27546.857,55020.521000000001]
[null,"9.Земельный участок площадью 184кв.м., пр.Абая д.219/2, ВП1.",null,null,null,813.28,2207.7572,null,2207.7572]
[9,"Магазин пр. Абая д. 219/2"," Магазин \"Ажар\"   ул Абая  219/2    (478,8 м2) №: 00078",{"$f":"C40","v":" Магазин \"Ажар\"   ул Абая  219/2    (478,8 м2) №: 00078"},null,{"$f":"SUM(F38:F39)","v":9420.8186999999998},{"$f":"SUM(G38:G39)","v":94344.026199999993},{"$f":"SUM(H38:H39)","v":27546.857},{"$f":"SUM(I38:I39)","v":57228.278200000001},53618.647100000002]
[]
[null,"Офис ул. Бараева д. 9, ВП-1"," Офис Бараева,9      (277 м2) №: 00077",null,null,6325.9404999999997,57287.4758,124087.68700000001,56942.925000000003]
[null,"10.Земельный участок площадью 610кв.м.,ул. Бараева,д.9, ВП-1",null,null,null,3733.2,10627.834800000001,null,10627.834800000001]
[10,"Офис ул. Бараева д. 9, ВП-1"," Офис Бараева,9      (277 м2) №: 00077",{"$f":"C44","v":" Офис Бараева,9      (277 м2) №: 00077"},"PPE",{"$f":"SUM(F42:F43)","v":10059.1405},{"$f":"SUM(G42:G43)","v":67915.310599999997},{"$f":"SUM(H42:H43)","v":124087.68700000001},{"$f":"SUM(I42:I43)","v":67570.7598},60005.652300000002]
[]
[null,"Магазин пр. Победы д. 37 пр. Республики д. 7/2"," Офис пр.Победы, 37 (83)   (101,2 м2) №: 00076",null,null,1046.4605999999999,19789.0314,356.226,17880.261999999999]
[null,"11.Земельный участок площадью 54кв.м., пр.Победы, д.83, ВП-2",null,null,null,321.3,710.61540000000002,null,710.61540000000002]
[11,"Магазин пр. Победы д. 37 пр. Республики д. 7/2"," Офис пр.Победы, 37 (83)   (101,2 м2) №: 00076",{"$f":"C48","v":" Офис пр.Победы, 37 (83)   (101,2 м2) №: 00076"},"PPE",{"$f":"SUM(F46:F47)","v":1367.7605999999998},{"$f":"SUM(G46:G47)","v":20499.646799999999},{"$f":"SUM(H46:H47)","v":356.226},{"$f":"SUM(I46:I47)","v":18590.877399999998},21184.781800000001]
[]
[null,"Офис ВП-1"," Офис пр.Республики 7/2  ВП-1 (94,2 м2 , этаж -1) с долей зем.уч. пл 0,0027га кад №21-319-028-768 №: 08010",null,null,2284.0128,27603.539000000001,2647.1770000000001,12640.225]
[null,"12.Земельный участок площадью 27кв.м.,пр.Республики д.7/2, ВП-1",null,null,null,174.42,470.35340000000002,null,470.35340000000002]
[12,"Офис ВП-1"," Офис пр.Республики 7/2  ВП-1 (94,2 м2 , этаж -1) с долей зем.уч. пл 0,0027га кад №21-319-028-768 №: 08010",{"$f":"C52","v":" Офис пр.Республики 7/2  ВП-1 (94,2 м2 , этаж -1) с долей зем.уч. пл 0,0027га кад №21-319-028-768 №: 08010"},null,{"$f":"SUM(F50:F51)","v":2458.4328},{"$f":"SUM(G50:G51)","v":28073.892400000001},{"$f":"SUM(H50:H51)","v":2647.1770000000001},{"$f":"SUM(I50:I51)","v":13110.5784},12975.556399999999,"ext",94,{"$f":"ROUND($M$68/$L$68*L52,0)","v":19564},{"$f":"M52-I52","v":6453.4215999999997}]
[null,null,null,null,null,null,null,null,null,null,"ext",null,0,0]
[null,"Офис ВП-2"," Офис пр.Республики 7/2  ВП-2 (102,9 м2) с долей зем.уч. пл 0,0029га кад №21-319-028-768 №: 08011",null,null,3195.7379999999998,30152.910500000002,4026.9630000000002,14227.974,null,"ext",null,0,-14227.974]
[null,"13.Земельный участок площадью 29кв.м., пр.Республики д.7/2, ВП-2",null,null,null,187.34,505.28719999999998,null,505.28719999999998,null,"ext",null,0,-505.28719999999998]
[13,"Офис ВП-2"," Офис пр.Республики 7/2  ВП-2 (102,9 м2) с долей зем.уч. пл 0,0029га кад №21-319-028-768 №: 08011",{"$f":"C56","v":" Офис пр.Республики 7/2  ВП-2 (102,9 м2) с долей зем.уч. пл 0,0029га кад №21-319-028-768 №: 08011"},null,{"$f":"SUM(F54:F55)","v":3383.078},{"$f":"SUM(G54:G55)","v":30658.197700000001},{"$f":"SUM(H54:H55)","v":4026.9630000000002},{"$f":"SUM(I54:I55)","v":14733.261200000001},14166.7549,"ext",102,21229,6495.7387999999992]
[null,null,null,null,null,null,null,null,null,null,"ext",null,0,0]
[null,"Офис ВП-4 пр. Республики д. 9/2"," Офис пр.Республики 9/2  ВП-4 (128,0 м2) с долей зем.уч. пл 0,0035га кад №21-319-028-772 №: 08020",null,null,3919.4784,37009.840600000003,5036.0959999999995,17490.609,null,"ext",null,0,-17490.609]
[null,"14.Земельный участок площадью 36кв.м., пр.Республики д.7/2, ВП-4",null,null,null,232.56,627.18700000000001,null,627.18700000000001,null,"ext",null,0,-627.18700000000001]
[14,"Офис ВП-4 пр. Республики д. 9/2"," Офис пр.Республики 9/2  ВП-4 (128,0 м2) с долей зем.уч. пл 0,0035га кад №21-319-028-772 №: 08020",{"$f":"C60","v":" Офис пр.Республики 9/2  ВП-4 (128,0 м2) с долей зем.уч. пл 0,0035га кад №21-319-028-772 №: 08020"},null,{"$f":"SUM(F58:F59)","v":4152.0384000000004},{"$f":"SUM(G58:G59)","v":37637.027600000001},{"$f":"SUM(H58:H59)","v":5036.0959999999995},{"$f":"SUM(I58:I59)","v":18117.796000000002},17394.464100000001,"ext",128,26640,8522.2039999999979]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Офис ВП-1"," Офис пр.Республики 9/2  ВП-1 (137,3 м2 этаж -1) с долей зем.уч. пл 0,0038га кад №21-319-028-772 №: 08017",null,null,4453.4070000000002,40233.183799999999,null,18765.317999999999,null,null,null,0,-18765.317999999999]
[null,"15.Земельный участок площадью 38кв.м. пр.Республики д.9/2, ВП-1",null,null,null,245.48,662.12080000000003,null,662.12080000000003,null,null,null,0,-662.12080000000003]
[15,"Офис ВП-1"," Офис пр.Республики 9/2  ВП-1 (137,3 м2 этаж -1) с долей зем.уч. пл 0,0038га кад №21-319-028-772 №: 08017",{"$f":"C64","v":" Офис пр.Республики 9/2  ВП-1 (137,3 м2 этаж -1) с долей зем.уч. пл 0,0038га кад №21-319-028-772 №: 08017"},null,{"$f":"SUM(F62:F63)","v":4698.8869999999997},{"$f":"SUM(G62:G63)","v":40895.304599999996},{"$f":"SUM(H62:H63)","v":0},{"$f":"SUM(I62:I63)","v":19427.4388},18893.286700000001,"ext",137,28514,9086.5612000000001]
[]
[null,"Офис ВП-2"," Офис пр.Республики 9/2  ВП-2 (364,9 м2 этаж -1) с долей зем.уч. пл 0,0101га кад №21-319-028-772 №: 08018",null,null,11843.549199999999,106927.0849,null,49876.964]
[null,"16.Земельный участок площадью 101кв.м. пр.Республики д.9/2, ВП-2",null,null,null,652.46,1759.6612,null,1759.6612]
[16,"Офис ВП-2"," Офис пр.Республики 9/2  ВП-2 (364,9 м2 этаж -1) с долей зем.уч. пл 0,0101га кад №21-319-028-772 №: 08018",{"$f":"C68","v":" Офис пр.Республики 9/2  ВП-2 (364,9 м2 этаж -1) с долей зем.уч. пл 0,0101га кад №21-319-028-772 №: 08018"},null,{"$f":"SUM(F66:F67)","v":12496.0092},{"$f":"SUM(G66:G67)","v":108686.7461},{"$f":"SUM(H66:H67)","v":0},{"$f":"SUM(I66:I67)","v":51636.625200000002},51212.427099999994,"x",365,75967,{"$f":"M68-I68","v":24330.374799999998}]
[]
[null,"Офис ВП-3 д.9/1 ул. Вавилова д.13"," Офис ул.Вавилова, 13   ВП-3 (147,5 м2) №: 05265",null,null,4318.1617999999999,38973.149600000004,null,18180.156999999999]
[null,"20.Земельный участок площадью 32кв.м., ул.Вавилова, д.13, ВП 3",null,null,null,174.08,596.23299999999995,null,596.23299999999995]
[17,"Офис ВП-3 д.9/1 ул. Вавилова д.13"," Офис ул.Вавилова, 13   ВП-3 (147,5 м2) №: 05265",{"$f":"C72","v":" Офис ул.Вавилова, 13   ВП-3 (147,5 м2) №: 05265"},null,{"$f":"SUM(F70:F71)","v":4492.2417999999998},{"$f":"SUM(G70:G71)","v":39569.382600000004},{"$f":"SUM(H70:H71)","v":0},{"$f":"SUM(I70:I71)","v":18776.39},20264.011299999998]
[]
[null,"Офис ВП-1"," Офис ул.Вавилова, 13   ВП-1 (67,1 м2) №: 05279",null,null,2252.6248999999998,13707.200500000001,1873.88,9049.6209999999992]
[null,"18.Земельный участок площадью 10кв.м., ул.Вавилова, д.13, ВП 1",null,null,null,54.4,186.31360000000001,null,186.31360000000001]
[18,"Офис ВП-1"," Офис ул.Вавилова, 13   ВП-1 (67,1 м2) №: 05279",{"$f":"C76","v":" Офис ул.Вавилова, 13   ВП-1 (67,1 м2) №: 05279"},null,{"$f":"SUM(F74:F75)","v":2307.0248999999999},{"$f":"SUM(G74:G75)","v":13893.5141},{"$f":"SUM(H74:H75)","v":1873.88},{"$f":"SUM(I74:I75)","v":9235.9345999999987},9140.5704000000005]
[]
[null,"Офис ВП-2"," Офис ул.Вавилова, 13   ВП-2 (467,6 м2) №: 05281",null,null,15700.232199999999,95521.414999999994,null,63592.942000000003]
[null,"19.Земельный участок площадью 100кв.м., ул.Вавилова, д.13, ВП 2",null,null,null,544,1863.136,null,1863.136]
[19,"Офис ВП-2"," Офис ул.Вавилова, 13   ВП-2 (467,6 м2) №: 05281",{"$f":"C80","v":" Офис ул.Вавилова, 13   ВП-2 (467,6 м2) №: 05281"},null,{"$f":"SUM(F78:F79)","v":16244.232199999999},{"$f":"SUM(G78:G79)","v":97384.550999999992},{"$f":"SUM(H78:H79)","v":0},{"$f":"SUM(I78:I79)","v":65456.078000000001},62679.009400000003,"x"]
[]
[null,"Офис ВП-3"," Офис пр.Республики 9/1  ВП-3 (133,0 м2) с долей зем.уч. пл 0,0037га кад №21-319-028-773 №: 08016",null,null,4952.6144999999997,30131.327399999998,null,20059.842000000001]
[null,"17.Земельный участок площадью 37кв.м. пр.Республики д.9/1, ВП-3",null,null,null,239.02,644.58019999999999,null,644.58019999999999]
[20,"Офис ВП-3"," Офис пр.Республики 9/1  ВП-3 (133,0 м2) с долей зем.уч. пл 0,0037га кад №21-319-028-773 №: 08016",{"$f":"C84","v":" Офис пр.Республики 9/1  ВП-3 (133,0 м2) с долей зем.уч. пл 0,0037га кад №21-319-028-773 №: 08016"},null,{"$f":"SUM(F82:F83)","v":5191.6345000000001},{"$f":"SUM(G82:G83)","v":30775.907599999999},{"$f":"SUM(H82:H83)","v":0},{"$f":"SUM(I82:I83)","v":20704.422200000001},18304.216400000001,"ext",133,{"$f":"ROUND($M$68/$L$68*L84,0)","v":27681},{"$f":"M84-I84","v":6976.5777999999991}]
[]
[null,"Офис ВП-5"," Офис ул.Вавилова, 13   ВП-5/1 (42,9 м2) №: 05268",null,null,7131.7645999999995,43389.111499999999,null,28886.172999999999]
[null,"21.Земельный участок площадью 46кв.м., ул.Вавилова, д.13, ВП 5",null,null,null,250.24,857.13099999999997,null,857.13099999999997]
[21,"Офис ВП-5"," Офис ул.Вавилова, 13   ВП-5/1 (42,9 м2) №: 05268",{"$f":"C88","v":" Офис ул.Вавилова, 13   ВП-5/1 (42,9 м2) №: 05268"},null,{"$f":"SUM(F86:F87)","v":7382.0045999999993},{"$f":"SUM(G86:G87)","v":44246.2425},{"$f":"SUM(H86:H87)","v":0},{"$f":"SUM(I86:I87)","v":29743.304},29178.800899999998]
[]
[null,"Офис ВП-8"," Офис ул.Вавилова, 13   ВП-8 (210,5 м2) №: 05257",null,null,7067.9682000000003,43000.979200000002,null,28627.774000000001]
[null,"22.Земельный участок площадью 46кв.м., ул.Вавилова, д.13, ВП 8",null,null,null,250.24,857.13099999999997,null,857.13099999999997]
[22,"Офис ВП-8"," Офис ул.Вавилова, 13   ВП-8 (210,5 м2) №: 05257",{"$f":"C92","v":" Офис ул.Вавилова, 13   ВП-8 (210,5 м2) №: 05257"},null,{"$f":"SUM(F90:F91)","v":7318.2082},{"$f":"SUM(G90:G91)","v":43858.110200000003},{"$f":"SUM(H90:H91)","v":0},{"$f":"SUM(I90:I91)","v":29484.905000000002},28924.8109]
[]
[null,"Офис ВП-7"," Офис ул.Вавилова, 13   ВП-7 (105,6 м2) №: 05273",null,null,3545.3413999999998,21571.9876,null,14361.33]
[null,"23.Земельный участок площадью 24кв.м., ул.Вавилова, д.13, ВП 7",null,null,null,130.56,447.21159999999998,null,447.21159999999998]
[23,"Офис ВП-7"," Офис ул.Вавилова, 13   ВП-7 (210,0 м2) №: 05273"," Офис ул.Вавилова, 13   ВП-7 (210,0 м2) №: 05273",null,{"$f":"SUM(F94:F95)","v":3675.9013999999997},{"$f":"SUM(G94:G95)","v":22019.199199999999},{"$f":"SUM(H94:H95)","v":0},{"$f":"SUM(I94:I95)","v":14808.5416},14526.234]
[]
[null,"Магазин ул. Брусиловского д. 72, ВП-1 г. Алматы, ул. Бокейхана д. 39"," Магазин \"Асем\" ул Брусиловского 72  (736 м2) №: 00089",null,null,10747.1297,132236.34590000001,1209.3510000000001,125971.13]
[null,"24.Земельный участок площадью 255кв.м. ул. Брусиловского д72",null,null,null,1127.0999999999999,3059.5817999999999,null,3059.5817999999999]
[24,"Магазин ул. Брусиловского д. 72, ВП-1 г. Алматы, ул. Бокейхана д. 39"," Магазин \"Асем\" ул Брусиловского 72  (736 м2) №: 00089",{"$f":"C100","v":" Магазин \"Асем\" ул Брусиловского 72  (736 м2) №: 00089"},null,{"$f":"SUM(F98:F99)","v":11874.2297},{"$f":"SUM(G98:G99)","v":135295.9277},{"$f":"SUM(H98:H99)","v":1209.3510000000001},{"$f":"SUM(I98:I99)","v":129030.7118},128109.29210000001,"x"]
[]
[null,"Торговый центр \"Береке\" г. Караганда, пр. Строителей д. 6/4"," Торговый центр \"Береке\" г. Караганда  (5064,4 м2) №: 01131 ***",null,null,245677.4559,646363.82310000004,null,606295.18700000003]
[null,"26.Земельный участок площадью 4500кв.м. г. Караганда, район  Казыбек би, пр. Строителей, д 6/4.",null,null,null,11205,18850.986000000001,null,18850.986000000001]
[25,"Торговый центр \"Береке\" г. Караганда, пр. Строителей д. 6/4"," Торговый центр \"Береке\" г. Караганда  (5064,4 м2) №: 01131 ***",{"$f":"C104","v":" Торговый центр \"Береке\" г. Караганда  (5064,4 м2) №: 01131 ***"},null,{"$f":"SUM(F102:F103)","v":256882.4559},{"$f":"SUM(G102:G103)","v":665214.80910000007},{"$f":"SUM(H102:H103)","v":0},{"$f":"SUM(I102:I103)","v":625146.17300000007},766506.9868999999,"x",null,566266,{"$f":"M104-I104","v":-58880.173000000068}]
[]
[null,"Склад г. Шымкент, Сайрамское шоссе"," Склад  (г.Шымкент)   (2562,7 м2) №: 00085",null,null,25181.583999999999,null,null,25181.583999999999]
[null,"27.Земельный участок площадью 3000кв.м. Южно-Казахстанская  область, г. Шымкент, Сайрамское  шоссе.",null,null,null,3690,5682.27,null,5682.27]
[26,"Склад г. Шымкент, Сайрамское шоссе"," Склад  (г.Шымкент)   (2562,7 м2) №: 00085",{"$f":"C108","v":" Склад  (г.Шымкент)   (2562,7 м2) №: 00085"},null,{"$f":"SUM(F106:F107)","v":28871.583999999999},{"$f":"SUM(G106:G107)","v":5682.27},{"$f":"SUM(H106:H107)","v":0},{"$f":"SUM(I106:I107)","v":30863.853999999999},112998.57610000001]
[27,"25.Земельный участок площадью 3781кв.м. г. Алматы, район  Жетысуский, ул. Бокейханова, д 39."," Земля г.Алматы,Бокейханова39 (0,3781га) №: 00062 Жетысуский р-он, ул.Бокейханова 39"," Земля г.Алматы,Бокейханова39 (0,3781га) №: 00062 Жетысуский р-он, ул.Бокейханова 39","PPE",27223.200000000001,55943.753799999999,null,55943.753799999999,63712.075700000001]
[28,"28.Земельный участок площадью 2063кв.м. Мангыстауская  область, г. Актау, 15  микрорайон, на  территории  бывшего  технопарка."," Земельный участок 0,2063 га (Мангистауская обл., г. Актау, м №: 02295"," Земельный участок 0,2063 га (Мангистауская обл., г. Актау, м №: 02295",null,4443.7020000000002,27388.983600000003,null,27388.983600000003,8249.7310999999991]
[29,"29.Земельный участок площадью 4900 кв.м. Атырауская  область, г. Атырау,  ул. Кулманова,  район  мечети «Имангали»."," Земельный участок Атырау, Кулманова р-н мечети Имангали    (0,49 га) №: 01852"," Земельный участок Атырау, Кулманова р-н мечети Имангали    (0,49 га) №: 01852",null,7791,13643.491400000001,null,13643.491400000001,6910.6464000000005]
[30,"Административное здание "," Административное здание    (Алматы)   (182 м2 ) №: 00065"," Административное здание    (Алматы)   (182 м2 ) №: 00065","PPE",1494.4737,21130.129000000001,null,18184.780999999999,18171.615000000002]
[31,"Нежилое помещение"," Бытовой корпус (Алматы)    (122,8 м20) №: 00064"," Бытовой корпус (Алматы)    (122,8 м20) №: 00064","PPE",3068.6747999999998,14257.0321,null,13138.196,18421.736000000001]
[32,"Склад "," Складские помещения   (Алматы)    ( 9 шт 1051,7 м2 ) №: 00066"," Складские помещения   (Алматы)    ( 9 шт 1051,7 м2 ) №: 00066","PPE",19995.202100000002,122101.9598,37103.783000000003,111233.696,98751.414999999994,"x",null,67929,{"$f":"M114-I114","v":-43304.695999999996}]
[33,"Склад "," Склад    (Алматы)     (208,8 м2) №: 00068"," Склад    (Алматы)     (208,8 м2) №: 00068","PPE",4311.6710000000003,24241.598600000001,null,19657.714,19471.215]
[34,"Торговое помещение"," Торговый павильон    (Алматы)    (70м2) №: 00067"," Торговый павильон    (Алматы)    (70м2) №: 00067","PPE",1968.1876999999999,8080.5329000000002,null,7899.1109999999999,7899.1109999999999]
[null,null,null,null,null,{"$f":"F4+F8+F12+F16+F20+F24+F31+F36+F40+F44+F48+F52+F56+F60+F64+F68+F72+F76+F80+F84+F88+F92+F96+F100+F104+F108+F109+F110+F111+F112+F113+F114+F115+F116","v":1138180.4346999999},{"$f":"G4+G8+G12+G16+G20+G24+G31+G36+G40+G44+G48+G52+G56+G60+G64+G68+G72+G76+G80+G84+G88+G92+G96+G100+G104+G108+G109+G110+G111+G112+G113+G114+G115+G116","v":5099730.9759},{"$f":"H4+H8+H12+H16+H20+H24+H31+H36+H40+H44+H48+H52+H56+H60+H64+H68+H72+H76+H80+H84+H88+H92+H96+H100+H104+H108+H109+H110+H111+H112+H113+H114+H115+H116","v":4255089.8769999994},{"$f":"I4+I8+I12+I16+I20+I24+I31+I36+I40+I44+I48+I52+I56+I60+I64+I68+I72+I76+I80+I84+I88+I92+I96+I100+I104+I108+I109+I110+I111+I112+I113+I114+I115+I116","v":5336710.5972000007},{"$f":"J4+J8+J12+J16+J20+J24+J31+J36+J40+J44+J48+J52+J56+J60+J64+J68+J72+J76+J80+J84+J88+J92+J96+J100+J104+J108+J109+J110+J111+J112+J113+J114+J115+J116","v":5900086.0395000009},null,null,null,{"$f":"SUM(N4:N116)","v":-217454.60780000011}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUMIF(K4:K116,\"x\",I4:I116)","v":4721089.5818000007},null,null,null,null,{"$f":"N117+MEDH_IP_ext!L84+CTA_IP_ext!N46","v":-671980.84864999994}]
[null,null,null,null,null,null,null,null,{"$f":"I119/I117","v":0.88464410722908671}]
[]
[]
[null,null,null,null,null,null,null,null,9235.9345999999987]
[null,null,null,null,null,null,null,null,9985.3979999999992]
[null,null,null,null,null,null,null,null,13110.5784]
[null,null,null,null,null,null,null,null,13138.196]
[null,null,null,null,null,null,null,null,13643.491400000001]
[null,null,null,null,null,null,null,null,14733.261200000001]
[null,null,null,null,null,null,null,null,14808.5416]
[null,null,null,null,null,null,null,null,18117.796000000002]
[null,null,null,null,null,null,null,null,18184.780999999999]
[null,null,null,null,null,null,null,null,18776.39]
[null,null,null,null,null,null,null,null,19427.4388]
[null,null,null,null,null,null,null,null,20704.422200000001]
[null,null,null,null,null,null,null,null,27388.983600000003]
[null,null,null,null,null,null,null,null,29484.905000000002]
[null,null,null,null,null,null,null,null,29743.304]
[null,null,null,null,null,null,null,null,30863.853999999999]
[null,null,null,null,null,null,null,null,51636.625200000002]
[null,null,null,null,null,null,null,null,57228.278200000001]
[null,null,null,null,null,null,null,null,57945.265199999994]
[null,null,null,null,null,null,null,null,65456.078000000001]
[null,null,null,null,null,null,null,null,129030.7118]
[null,null,null,null,null,null,null,null,435392.85019999999]
[null,null,null,null,null,null,null,null,625146.17300000007]
[null,null,null,null,null,null,null,null,858192.83439999993]
[null,null,null,null,null,null,null,null,1703311.003]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,I123:I147)","v":4284687.0948000001}]

{"sheet":"MEDH_IP_ext","index":6,"n_rows":87,"n_cols":12,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
["№ п/п","Наименование","Наименовани 2009","Сравнительный \nподход, тенге","Затратный \nподход, тенге","Доходный подход, тенге","Fair value 31/12/2010","Fair value 31/12/2009"]
[1,"Здания гаража г. Щучинск, ул. Едомского 29","Гараж легковых автомобилей",1223.0160000000001,null,8455.1440000000002,3527.297,3445.71]
[]
[null,"Административное здание г. Щучинск, ул. Едомского 29","Здание ул.Едомского,29",15573.584999999999,92155.821629999991,null,54630.525999999998]
[null,"Земельный участок площадью 2057кв.м. г. Щучинск ул. Едомского, 29 ","Зем.участок ул.Едомского,29",1991.1759999999999,2110.326,null,2110.326]
[2,"Административное здание г. Щучинск, ул. Едомского 29","Здание ул.Едомского,29",{"$f":"SUM(D4:D5)","v":17564.760999999999},{"$f":"SUM(E4:E5)","v":94266.147629999992},{"$f":"SUM(F4:F5)","v":0},{"$f":"SUM(G4:G5)","v":56740.851999999999},53993.955000000002]
[]
[3,"Помещение Бизнес Центра (Секция Ж) г. Астана, ул. Б. Момышулы","Здание Меруерт, секция \"Ж\", Момышулы 12",123470.90186,463390.84425999998,50128.839,362381.66600000003,359496.10100000002,"x"]
[]
[4,"Помещение Бизнес Центра (Секция В) г. Астана, ул. Б. Момышулы","Здание Меруерт, секция \"В\", Момышулы 12",107283.97795999999,402640.72087000002,147804.66899999999,345595.40700000001,327270.70600000001,"x"]
[]
[null,"Административное здание г. Астана, пр. Республики 68","Ул.Серова,5",127115.2454,484101.3187,205765.13200000001,186408.81899999999]
[null,"Земельный участок площадью 2336кв.м. ул. Серова, 5 (пр.Республики , 68)","Зем.участок ул.Серова,5",11516.48,20256.740000000002,null,20256.740000000002]
[5,"Административное здание г. Астана, пр. Республики 68","Ул.Серова,5",{"$f":"SUM(D12:D13)","v":138631.7254},{"$f":"SUM(E12:E13)","v":504358.05869999999},{"$f":"SUM(F12:F13)","v":205765.13200000001},{"$f":"SUM(G12:G13)","v":206665.55899999998},177128.014,"x",2965,279204,{"$f":"K14-G14","v":72538.441000000021}]
[]
[null,"Земельный участок площадью 2354кв.м. г. Кокшетау ул. Коммунистическая угол ул. Момышулы","Земля г. Кокчетав",1518.33,5270.5820000000003,null,5270.5820000000003]
[null,"Забор на территории зем. участка в г. Кокшетау",null,1062.5,null,null,1062.5]
[6,"Земельный участок площадью 2354кв.м. г. Кокшетау ул. Коммунистическая угол ул. Момышулы","Земля г. Кокчетав",{"$f":"SUM(D16:D17)","v":2580.83},{"$f":"SUM(E16:E17)","v":5270.5820000000003},{"$f":"SUM(F16:F17)","v":0},{"$f":"SUM(G16:G17)","v":6333.0820000000003},5368.8182500000003]
[]
[7,"Земельный участок площадью 1960кв.м. г. Петропавловск ","Земля г. Петропавловск",1244.5999999999999,5367.866,null,5367.866,5071.9792500000003]
[]
[8,"Земельный участок площадью 4762кв.м. г. Темиртау","Земля г. Темиртау",2964.3449999999998,4464.1559999999999,null,4464.1559999999999,1553.2615000000001]
[]
[null,"Земельный участок площадью 1493кв.м.",null,2538.1,4874.518,null,2538.1]
[null,"Земельный участок площадью 1100кв.м.",null,1870,3591.4009999999998,null,1870]
[null,"Земельный участок площадью 617кв.м.",null,1048.9000000000001,2014.5160000000001,null,1048.9000000000001]
[null,"Земельный участок площадью 2350кв.м.",null,3995,7672.6120000000001,null,3995]
[null,"Земельный участок площадью 3849кв.м.",null,6543.3,12566.587,null,6543.3]
[null,"Земельный участок площадью 750кв.м.",null,1275,2448.7559999999999,null,1275]
[null,"Земельный участок площадью 700кв.м.",null,1190,2285.4369999999999,null,1190]
[null,"Земельный участок площадью 632кв.м.",null,1074.4000000000001,2063.453,null,1074.4000000000001]
[null,"Земельный участок площадью 700кв.м",null,1190,2285.4369999999999,null,1190]
[null,"Земельный участок площадью 790кв.м.",null,1343,2579.3530000000001,null,1343]
[null,"Земельный участок площадью 680кв.м.",null,1156,2220.1390000000001,null,1156]
[null,"Земельный участок площадью 940кв.м.",null,1598,3069.0149999999999,null,1598]
[null,"Земельный участок площадью 800кв.м.",null,1360,2611.9279999999999,null,1360]
[null,"Земельный участок площадью 602кв.м.",null,1023.4,1965.432,null,1023.4]
[null,"Земельный участок площадью 598кв.м.",null,1016.6,1952.46,null,1016.6]
[null,"Земельный участок площадью 466кв.м.",null,792.2,1521.463,null,792.2]
[null,"Земельный участок площадью 970кв.м.",null,1649,3167.0360000000001,null,1649]
[null,"Земельный участок площадью 595кв.м.",null,1011.5,1942.585,null,1011.5]
[null,"Земельный участок площадью 620кв.м.",null,1054,2024.2439999999999,null,1054]
[null,"Земельный участок площадью 930кв.м.",null,1581,3036.44,null,1581]
[null,"Земельный участок площадью 850кв.м.",null,1445,2775.2469999999998,null,1445]
[null,"Земельный участок площадью 675кв.м.",null,1147.5,2203.777,null,1147.5]
[null,"Земельный участок площадью 759кв.м.",null,1290.3,2478.0889999999999,null,1290.3]
[null,"Земельный участок площадью 661кв.м.",null,1123.7,2158.0830000000001,null,1123.7]
[null,"Земельный участок площадью 650кв.м.",null,1105,2122.2649999999999,null,1105]
[null,"Земельный участок площадью 650кв.м",null,1105,2122.2649999999999,null,1105]
[null,"Земельный участок площадью 490кв.м.",null,833,1599.88,null,833]
[null,"Земельный участок площадью 730кв.м.",null,1241,2383.4580000000001,null,1241]
[null,"Земельный участок площадью 1030кв.м.",null,1751,3362.931,null,1751]
[9,"Земля пос. Коктал","Земля пос. Коктал",{"$f":"SUM(D24:D52)","v":45350.9},{"$f":"SUM(E24:E52)","v":87098.807000000015},{"$f":"SUM(F24:F52)","v":0},{"$f":"SUM(G24:G52)","v":45350.9},45350.9]
[]
[10,"Асфальтное покрытие БЦ \"Маржан\"",null,1124.22145,null,null,1124.22145,0]
[11,"Асфальтное покрытие «Адите»",null,16779.014360000001,null,null,16779.014360000001,0]
[null,null,null,null,null,null,null,0]
[null,"Гараж г. Астана, ул. Кеменгерулы 17",null,4457.1469800000004,17728.055210000002,null,8703.8379999999997,0]
[null,"Пожарное депо г. Астана, ул. Кеменгерулы 17",null,1499.1933600000002,9998.9269100000001,null,2774.1529999999998,0]
[null,"Проходная г. Астана, ул. Кеменгерулы 17",null,3215.0196099999998,10927.09734,null,3986.2280000000001,0]
[null,"Трансформаторная подстанция №1 г. Астана, ул. Кеменгерулы 17",null,3753.0330299999996,6227.1797900000001,null,4124.1549999999997,0]
[null,"Трансформаторная подстанция №2 г. Астана, ул. Кеменгерулы 17",null,1564.4626799999999,2387.92938,null,1687.982,0]
[null,"Цех г. Астана, ул. Кеменгерулы 17",null,2552.59114,19508.454859999998,null,5095.97,0]
[null,"Цех, склад, пр. (Главный корпус) г. Астана, ул. Кеменгерулы 17",null,24658.14934,367656.74524000002,null,41808.078999999998,0]
[null,"Цех г. Астана, ул. Кеменгерулы 17",null,42985.947690000001,91230.715360000002,null,48292.872000000003,0]
[null,"Цех мебельный г. Астана, ул. Кеменгерулы 17",null,6070.1081399999994,25735.63465,null,8036.66,0]
[null,"Гараж г. Астана, ул. Кеменгерулы 17",null,908.38599999999997,7062.5331799999994,null,1823.8009999999999,0]
[null,"Цех  г. Астана, ул. Кеменгерулы 17",null,3143.4813899999999,8623.54709,null,4239.4939999999997,0]
[null,"Ж/д подъездной путь №1",null,2687.4856099999997,null,null,2687.4856099999997,0]
[null,"Ж/д подъездной путь №2",null,1039.2572500000001,null,null,1039.2572500000001,0]
[null,"Ж/д подъездной путь №3",null,1504.1798799999999,null,null,1504.1798799999999,0]
[null,"Ж/д подъездной путь №4",null,1193.43208,null,null,1193.43208,0]
[null,"Ж/д подъездной путь №5",null,4714.2376900000008,null,null,4714.2376900000008,0]
[null,"Подкрановый путь №2",null,5118.6665800000001,null,null,5118.6665800000001,0]
[null,"Подкрановый путь №1",null,1921.0178100000001,null,null,1921.0178100000001,0]
[null,"Подкрановый путь №3",null,842.28337999999997,null,null,842.28337999999997,0]
[null,"Ограда территории",null,463.70835999999997,null,null,463.70835999999997,0]
[null,"Ограда территории",null,1030.38177,null,null,1030.38177,0]
[null,"Ограждение с воротами без уголков",null,2487.70604,null,null,2487.70604,0]
[null,"Ограждение с воротами с уголками",null,1268.8687399999999,null,null,1268.8687399999999,0]
[null,"Бетонированная площадка для хранения груза",null,3237.5202599999998,null,null,3237.57026,0]
[null," Земельный участок площадью 87 803кв.м. ул. Кеменгерулы, 17",null,373162.75,277997.57900000003,null,277997.57900000003,0]
[12,"Производственная база Кеменгерулы 17",null,{"$f":"SUM(D58:D82)","v":495479.01481000002},{"$f":"SUM(E58:E82)","v":845084.39801000012},{"$f":"SUM(F58:F82)","v":0},{"$f":"SUM(G58:G82)","v":436079.60645000008},0,"x",6721,424386,{"$f":"K83-G83","v":-11693.606450000079}]
[null,null,null,{"$f":"SUM(D2:D52)","v":599092.37361999985},{"$f":"SUM(E2:E52)","v":2170751.9707899997},{"$f":"SUM(F2:F52)","v":617918.91599999997},{"$f":"G2+G6+G8+G10+G14+G18+G20+G22+G53+G55+G56+G83","v":1490409.6272600002},{"$f":"H2+H6+H8+H10+H14+H18+H20+H22+H53+H55+H56+H83","v":978679.44500000007},null,null,null,{"$f":"SUM(L2:L83)","v":60844.834549999941}]
[]
[null,null,null,null,null,null,{"$f":"SUMIF(I2:I83,\"x\",G2:G83)","v":1350722.2384500001}]
[null,null,null,null,null,null,{"$f":"G86/G84","v":0.90627584104726677}]

{"sheet":"CTA_IP_ext","index":7,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["№ п/п","Наименование","Наименование 2009",null,"Плошадь, кв.м","Сравнительный \nподход, тенге","Затратный \nподход, тенге","Доходный подход, тенге","Fair value 31/12/2010","Fair value 31/12/2009"]
[null,"Торговый центр «Макси» Лит А  ","Здание ТЦ \"Макси\" S 14029,40 м2 (Ак жол 33)",null,14029.4,2531481.5468099997,585127.79700000002,null,1752940.047]
[null,"Земля под ТЦ \"Макси\", ул. Акжол, 33","Земля под ТЦ Макси - (2,225га)",null,10703,87952.437650000007,45487.75,null,87952.437700000009]
[1,"Торговый центр «Макси» Лит А  ","Здание ТЦ \"Макси\" S 14029,40 м2 (Ак жол 33)",null,14029.4,{"$f":"SUM(F2:F3)","v":2619433.9844599999},{"$f":"SUM(G2:G3)","v":630615.54700000002},{"$f":"SUM(H2:H3)","v":0},{"$f":"SUM(I2:I3)","v":1840892.4846999999},2026150.0859999999,"x",null,{"$f":"E4*O16","v":2377655.3616107064},null,{"$f":"I4/E4","v":131.21676512894351}]
[]
[null,"Центр торговли «Астыкжан» Лит А, а, а1, г. Костанай  ","Зд.ТЦ \"Астыкжан\"-Костанай S 13888.8 м*2",null,13888.8,1986079.4556800001,751742.04070000001,null,1368910.7479999999]
[null,"Земля ТЦ \"Астыкжан\" г. Костанай","Земля под ТЦ \"Астыкжан\" 1,0482 га (Костанай)",null,32732,127516.73642,44417.423999999999,null,127516.73640000001]
[2,"Центр торговли «Астыкжан» Лит А, а, а1, г. Костанай  ","Зд.ТЦ \"Астыкжан\"-Костанай S 13888.8 м*2",null,13888.8,{"$f":"SUM(F6:F7)","v":2113596.1921000001},{"$f":"SUM(G6:G7)","v":796159.46470000001},{"$f":"SUM(H6:H7)","v":0},{"$f":"SUM(I6:I7)","v":1496427.4844},1380686.8900000001,"x",null,null,null,{"$f":"I8/E8","v":107.74346843499799}]
[]
[null,"Центр торговли «Астыкжан»   ","Здание ТЦ \"Астыкжан\" S 8255,1 м2 (Ак жол 31)",null,8255.1,1479910.78024,195741.9278,500930.68599999999,1390419.29]
[null,"Земля под ТЦ \"Астыкжан\" ул. Акжол, 31","Земля под ТЦ \"Астыкжан \" 1,1272 га (Ак жол 31)",null,11272,92628.223599999998,47906,null,92628.223599999998]
[3,"Центр торговли «Астыкжан»   ","Здание ТЦ \"Астыкжан\" S 8255,1 м2 (Ак жол 31)",null,8255.1,{"$f":"SUM(F10:F11)","v":1572539.0038399999},{"$f":"SUM(G10:G11)","v":243647.9278},{"$f":"SUM(H10:H11)","v":500930.68599999999},{"$f":"SUM(I10:I11)","v":1483047.5135999999},1432030.0959999999,"x",null,1399049,{"$f":"M12-I12","v":-83998.513599999947},{"$f":"M12/E12","v":169.47692941333236}]
[]
[null,"Торговый центр «Астыкжан» Лит. А","Здание ТЦ \"Астыкжан-2\" S 13405,3 м2 (Бейсекова 3)",null,13405.3,2414066.66671,1422047.5992000001,407384.72899999999,2372613.4079999998]
[null,"Земля ТЦ \"Астыкжан\" ул. Бейсекова","Земля под ТЦ \"Астыкжан\" 1,8877 га (Бейсекова 3)",null,18877,157849.51175000001,83436.34,null,157849.51180000001]
[4,"Торговый центр «Астыкжан» Лит. А","Здание ТЦ \"Астыкжан-2\" S 13405,3 м2 (Бейсекова 3)",null,13405.3,{"$f":"SUM(F14:F15)","v":2571916.1784600001},{"$f":"SUM(G14:G15)","v":1505483.9392000001},{"$f":"SUM(H14:H15)","v":407384.72899999999},{"$f":"SUM(I14:I15)","v":2530462.9197999998},2535996.1510000001,"x",null,2271885,{"$f":"M16-I16","v":-258577.9197999998},{"$f":"M16/E16","v":169.47662491701044}]
[]
[5,"Однокомнатная квартира   мкр. Молодежный, д. 26/1, кв. 5","Кв. S=45.2 м2 (мкр.Молодежный д26/1 кв5)","PPE",45.2,7459.9122300000008,1155.088,null,7144.67,7114.2]
[]
[6,"Однокомнатная квартира   мкр. Молодежный, д. 26/3, кв. 8:","Кв. S=45.5 м2 (мкр.Молодежный д26/3 кв8)","PPE",45.5,7509.4249199999995,1163.6095,296.37900000000002,7166.1170000000002,7315.15]
[]
[7,"Трехкомнатная квартира   ул. Ирченко, д. 31, кв. 131","Кв. S=81.6 м2 (ул.Ирченко д31 кв 131)","PPE",81.599999999999994,13505.219590000001,2886.6493,null,12974.290999999999,12509.386]
[]
[8,"Трехкомнатная квартира   ул. Габдуллина, д. 19/1, кв. 100","Кв.S=80.90м2(Габдулина 19/1кв100)","PPE",80.900000000000006,13632.39056,1675.1487,null,13034.528,13824.7]
[]
[9,"Двухкомнатная квартира  ул. Габдуллина, д. 19, кв. 39","Кв.S=61.20м2(Габдулина 19кв39)","PPE",61.2,10823.161619999999,2826.64,null,10423.334999999999,10458.228999999999]
[]
[10,"Трехкомнатная квартира  ул. Ташенова (ранее – мкр. Молодежный, д. 39), д. 11/2, кв. 34","Кв. S=57.10 м2(Ташенова 11/2 кв 34)","PPE",57.1,9383.6846100000002,1583.0316,null,8993.6530000000002,9531.4150000000009]
[]
[null,"Склад  Лит. А","Склад S=385м2 (п.Коктал ул.Лесная03) (А)",null,385,null,5566.8167999999996,null,5566.817]
[null,"Земля под Склад, ул. Лесная 03","Земля под складом 0,0673 га (Лесная,03)",null,673,3927.33592,1144.0999999999999,null,3927.3359]
[11,"Склад  Лит. А","Склад S=385м2 (п.Коктал ул.Лесная03) (А)",null,385,null,5566.8167999999996,null,5566.817,7920.0779499999999]
[]
[null,"Конно - спортивный комплекс  Лит. А","Конно-сп/компл(офис,кот,клуб,кон)Садов22",null,507,null,9132.3065000000006,null,9132.3060000000005]
[null,"Здание конно - спортивного комплекса  Лит. В","Конно-сп/компл(офис,кот,клуб,кон)Садов22",null,300.5,null,9021.2294999999995,null,9021.23]
[null,"Здание конно - спортивного комплекса  Лит. А1, а","Конно-сп/компл(офис,кот,клуб,кон)Садов22",null,36.9,null,664.65909999999997,null,664.65899999999999]
[null,"Здание конно - спортивного комплекса  Лит. Б","Конно-сп/компл(офис,кот,клуб,кон)Садов22",null,1866.3,null,56426.966899999999,null,56426.966999999997]
[null,"Земля КСК \"Клуб Тулпар\" ","Земля под КСК \"Клуб Тулпар\" 0,7251га (Садовая 22)",null,7251,14439.452869999999,12326.7,null,14439.451999999999]
[12,"Конно - спортивный комплекс  Лит. А","Конно-сп/компл(офис,кот,клуб,кон)Садов22",null,507,{"$f":"SUM(F34:F38)","v":14439.452869999999},{"$f":"SUM(G34:G38)","v":87571.861999999994},{"$f":"SUM(H34:H38)","v":0},{"$f":"SUM(I34:I38)","v":89684.614000000001},169814.13769999999,"x",null,0,{"$f":"M39-I39","v":-89684.614000000001}]
[]
[13,"Помещение (рамник)  Лит. А","Помещение(Рамник)S=595.5м2Садовая20",null,595.5,null,4523.0889999999999,null,4523.0889999999999,1457.22371]
[]
[null,"Рем. тех. станция: контора, с. Астраханка","Рем.тех.станция S=96 000 кв.м",null,459.8,null,4371.9780000000001,null,4371.9780000000001]
[null,"Земля под Рем. Тех. Станция, с. Астраханка","Земля под рем-тех.станц 9,2633га (Астраханка)",null,92633,0,78738.05,null,78738.05]
[14,"Рем. тех. станция: контора, с. Астраханка","Рем.тех.станция S=96 000 кв.м",null,459.8,{"$f":"SUM(F43:F44)","v":0},{"$f":"SUM(G43:G44)","v":83110.028000000006},{"$f":"SUM(H43:H44)","v":0},{"$f":"SUM(I43:I44)","v":83110.028000000006},181582.84040000002,"x",null,0,{"$f":"M45-I45","v":-83110.028000000006}]
[null,null,null,null,null,{"$f":"F4+F8+F12+F16+F18+F20+F22+F24+F26+F28+F32+F39+F41+F45","v":8954238.6052599996},{"$f":"G4+G8+G12+G16+G18+G20+G22+G24+G26+G28+G32+G39+G41+G45","v":3367968.8416000004},{"$f":"H4+H8+H12+H16+H18+H20+H22+H24+H26+H28+H32+H39+H41+H45","v":908611.79399999999},{"$f":"I4+I8+I12+I16+I18+I20+I22+I24+I26+I28+I32+I39+I41+I45","v":7593451.5444999989},{"$f":"J4+J8+J12+J16+J18+J20+J22+J24+J26+J28+J32+J39+J41+J45","v":7796390.5827599997},null,null,null,{"$f":"SUM(N4:N45)","v":-515371.07539999974}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUMIF(K4:K45,\"x\",I4:I45)","v":7523625.0444999998}]
[null,null,null,null,null,null,null,null,{"$f":"I48/I46","v":0.99080437932726717}]

{"sheet":"ASTLOG_IP_ext","index":8,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["№","Наименование","Наименование 2009","Затратный подход, в тенге","Сравнительный подход, в тенге","Доходный подход, в тенге","Fair value 31/12/2010","Fair value 31/12/2009"]
[null,"Склад лит.К 2792,2 кв.м. шоссе Алаш, 12 ","Автосалон",47750.552520000005,246143.72166000001,112901.91499999999,113636.685,105111.40399999999]
[null,"Склад №1 лит.З,З1 4494,4 кв.м. шоссе Алаш, 12 ","Оптовый склад №1",70510.686969999995,396199.53535000002,0,140914.9,119715.40399999999]
[null,"Склад №2 лит.Ж 4438,2 кв.м. шоссе Алаш, 12 ","Оптовый склад №2",108317.98917,391245.27807999996,1002.573,151252.05499999999,119716.42600000001]
[null,"Офисное здание лит.А 579,8кв.м. шоссе Алаш, №.12 ","Офис (гостиница) /группа-1/",12356.357910000001,85000.16777,10441.612999999999,61680.055,68740.111999999994]
[null,"Гараж, сауна, ПТО лит.В 508,4 кв.м. шоссе Алаш, 12 ","Сауна + Гараж",9569.4034800000009,50106.758609999997,0,15650.007,15222.32]
[null,"Склад №1 лит.Е 5184,0 кв.м. шоссе Алаш, 12 ","Склад №1",136521.43362,457034.64111999999,0,194213.81099999999,138832.704]
[null,"Склад №2 лит.Д 3966,0 кв.м. шоссе Алаш,12 ","Склад №2",105114.73734000001,349618.93849999999,12695.155000000001,138035.144,106213.446]
[null,"Склад №3 лит.Г 5281,2кв.м. шоссе Алаш, 12 ","Склад №3",139437.99616000001,465559.13717,126691.64599999999,196610.24,141435.81700000001]
[null,"Компрессорная лит.И 832,4 кв.м.шоссе Алаш, 12 ","Компрессорная с подстанцией /группа-2/",8527.5730800000001,0,0,8527.5730000000003,8083.1670000000004]
[null,"Служебно-бытовой корпус лит.Б 451,9кв.м.шоссе Алаш, 12 ","Служебно-бытовой корпус (Офис администра) /группа-1/",14418.98718,66249.69958,0,43598.758999999998,54105.61]
[null,"Бутики шоссе Алаш, 12 10штук","Бутики /группа 1/",0,0,3738.7979999999998,3738.7979999999998,3254.8130000000001]
[null,"Земельный  участок 8,8290га","Земля",375232.5,447809.897,0,447809.897,486951.99900000001]
[1,"Складская база",null,null,null,null,{"$f":"SUM(G2:G13)","v":1515667.9240000001},{"$f":"SUM(H2:H13)","v":1367383.2220000001},"x"]
[null,null,null,{"$f":"SUM(D2:D13)","v":1027758.2174300001},{"$f":"SUM(E2:E13)","v":2954967.7748399996},{"$f":"SUM(F2:F13)","v":267471.7},{"$f":"G14","v":1515667.9240000001},{"$f":"H14","v":1367383.2220000001}]
[]
[null,null,null,null,null,null,{"$f":"G14","v":1515667.9240000001}]
[null,null,null,null,null,null,{"$f":"G17/G15","v":1}]

{"sheet":"Sheet4","index":9,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,"TSC\nshares","Invest, \nKKZT","Total shares","Share-holding","NCI shares","NCI share",null,"TSC\nshares","Invest, \nKKZT","Share-holding","NCI shares","NCI share",null,"Total shares"]
["2005-01-01",52000,52000]
["2005-04-30",19100,19100]
["2005-10-25",2355,2355]
["2005-11-14",59393,50780]
["2005-11-15",287030,200677]
["2005-11-16",69022,50693]
["2005-12-02",500000,500025]
["2005-12-06",500000,500025]
["2005-12-08",500000,500025]
["2006-01-01",1988900,1875680,2246610,{"$f":"IFERROR(B11/D11,0%)","v":0.885289391572191},{"$f":"D11-B11","v":257710},{"$f":"IFERROR(F11/D11,0)","v":0.11471060842780902},null,{"$f":"B11","v":1988900},{"$f":"C11","v":1875680},{"$f":"IFERROR(I11/O11,0%)","v":0.885289391572191},{"$f":"F11","v":257710},{"$f":"IFERROR(L11/O11,0)","v":0.11471060842780902},null,{"$f":"D11","v":2246610}]
["2006-03-01",182313,182313,0,0,-182313,{"$f":"IFERROR(F12/D12,0)","v":0},null,{"$f":"I11+B12","v":2171213},2057993,0.96643965797356912,{"$f":"L11+F12","v":75397},3.3560342026430934E-2,null,{"$f":"O11+D12","v":2246610}]
["2006-05-01",981988,981988,1017414,0.96518034939562458,35426,3.4819650604375404E-2,null,3153201,3039981,0.96604712465349518,110823,3.3952875346504804E-2,null,3264024]
["2006-07-01",0,0,35806,0,35806,1,null,3153201,3039981,0.95556468060475841,146629,4.4435319395241576E-2,null,3299830]
["2006-09-01",400000,400000,400000,1,0,0,null,3553201,3439981,0.96036871964387549,146629,3.9631280356124468E-2,null,3699830]
["2006-10-01",554789,554789,593168,0.93529826288673701,38379,6.4701737113263019E-2,null,4107990,3994770,0.95690470855099397,185008,4.3095291449006035E-2,null,4292998]
["2006-11-01",26,26,12000,{"$f":"IFERROR(B17/D17,0%)","v":2.1666666666666666E-3},11974,0.99783333333333335,null,4108016,3994796,0.95424341660553613,196982,4.5756583394463833E-2,null,4304998]
["2007-01-01",2548759,1512652,3195002,0.7977331469589064,646243,0.20226685304109357,null,6656775,5507448,0.88756999999999997,843225,0.11243,null,7500000]
["2007-04-01",2662710,2662710,2664310,0.99939946928097712,1600,6.0053071902293651E-4,null,{"$f":"I18+B19","v":9319485},{"$f":"J18+C19","v":8170158},0.91688319226784698,844825,8.3116807732152992E-2,null,10164310]
["2007-05-01",155550,156959,335690,0.46337394620036343,180140,0.53662605379963657,null,{"$f":"I19+B20","v":9475035},{"$f":"J19+C20","v":8327117},0.90238428571428575,1024965,9.7615714285714292E-2,null,10500000]
["2007-07-01",2707017,2708371,2768417,0.9778212603086891,61400,2.2178739691310956E-2,null,12182052,11035488,0.91812399323898242,1086365,8.1876006761017542E-2,null,13268417]
["2007-08-01",300000,300050,231583,1.295431875396726,-68417,-0.295431875396726,null,12482052,11335538,0.92459644444444444,1017948,7.5403555555555557E-2,null,13500000]
["2008-01-01",0,0,0,0,0,0,null,{"$f":"I22+B23","v":12482052},{"$f":"J22+C23","v":11335538},0.92459644444444444,1017948,7.5403555555555557E-2,null,13500000]
["2009-01-01",1872307,1872307,{"$f":"B24","v":1872307},1,0,0,null,14354359,13207845,0.933780401341191,1017948,6.6219598658808984E-2,null,15372307]
["2009-02-01",127693,127693,{"$f":"B25","v":127693},1,0,0,null,{"$f":"I24+B25","v":14482052},13335538,0.934325935483871,1017948,6.5674064516129033E-2,null,15500000]
["2009-07-01",-609552,-561294,0,0,609552,0,null,13872500,12774244,0.89500000000000002,1627500,0.105,null,15500000]
["2009-09-01",-775000,-713645,0,0,775000,0,null,13097500,12060599,0.84499999999999997,2402500,0.155,null,15500000]
["2010-01-01",0,0,0,0,0,0,null,13097500,12060599,0.84499999999999997,2402500,0.155,null,15500000]

{"sheet":"Acquisition","index":10,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Share capital of FKTSC before contribution",null,{"$f":"C2/$C$2","v":{"$error":"#DIV/0!"}},null,null,"Calculation of goodwill:"]
[null,"Share capital of FKTSC after contribution",null,{"$f":"C3/$C$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"FV of consideration:",null,null,null,{"$f":"SUM(C10:C12)","v":0}]
[null,"Opening balance of investment in FKTSC:",null,null,null,null,"FV of previously held investment:",null,null,null,{"$f":"C6","v":0},"(w1)"]
[null,"Medet Holding",null,{"$f":"C6/$C$2","v":{"$error":"#DIV/0!"}},null,null,"NCI share of net assets:",null,null,null,{"$f":"K18*(1-(D6+D10+D11+D12))","v":{"$error":"#DIV/0!"}},"(w2)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K6)","v":{"$error":"#DIV/0!"}}]
[null,"Share purchased:",null,null,null,null,"FV of net assets aquired:",null,null,null,{"$f":"C40","v":0}]
[null,"Medet Holding",null,null,null,null,"Negative goowill (APIC)",null,null,null,{"$f":"K7-K8","v":{"$error":"#DIV/0!"}}]
[null,"For cash",null,{"$f":"C10/$C$3","v":{"$error":"#DIV/0!"}}]
[null,"As offset with trade receivables",null,{"$f":"C11/$C$3","v":{"$error":"#DIV/0!"}},null,null,"(w1) FV of previously held interest"]
[null,"Concern Tsesna Astyk",null,{"$f":"C12/$C$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Since opening investment held in FKTSC is not significant, we assume"]
[null,"Closing balance of investment in FKTSC:",null,null,null,null,"that FV of previously held investment is equal to its cost."]
[null,"Medet Holding",null,{"$f":"C15/$C$3","v":{"$error":"#DIV/0!"}}]
[null,"Concern Tsesna Astyk",null,{"$f":"C16/$C$3","v":{"$error":"#DIV/0!"}},null,null,"(w2) NCI share of net assets:"]
[null,null,{"$f":"SUM(C15:C16)","v":0},{"$f":"SUM(D15:D16)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"Total","Group","NCI"]
[null,null,null,null,null,null,"Net assets at aquisition:",null,null,null,{"$f":"C40","v":0},{"$f":"K18-M18","v":{"$error":"#DIV/0!"}},{"$f":"K6","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Change in NA",null,null,null,{"$f":"K20-K18","v":0},{"$f":"K19-M19","v":{"$error":"#DIV/0!"}},{"$f":"K19*(1-D17)","v":{"$error":"#DIV/0!"}}]
[null,"Purchase date:","2009-07-20",null,null,null,"Net assets at 31 December 2009:",null,null,null,null,{"$f":"SUM(L18:L19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M18:M19)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Per FS:"]
[null,null,"2009-12-31",null,null,null,"Diff:",null,null,null,{"$f":"K20-K21","v":0}]
[null,"ASSETS"]
[null,"Cash and cash equivalents",null,null,null,null,"Dr Net assets at acquisition",null,null,null,{"$f":"K8","v":0}]
[null,"Trade and other receivables",null,null,null,null,"Cr Cash paid",null,null,null,{"$f":"(K4) * -1","v":0}]
[null,"Current tax assets",null,null,null,null,"Cr NCI",null,null,null,{"$f":"(K6) * -1","v":{"$error":"#DIV/0!"}}]
[null,"Inventories",null,null,null,null,"Cr Gain from previously held investment",null,null,null,{"$f":"(K5) * -1","v":0}]
[null,"Property, plant and equipment",null,null,null,null,"Cr APIC",null,null,null,{"$f":"K9","v":{"$error":"#DIV/0!"}}]
[null,"Intangibles"]
[null,"Deffered income tax assets"]
[null,"Total assets",{"$f":"SUM(C24:C30)","v":0}]
[]
[null,"LIABILITIES",null,null,null,null,null,null,"NA at acquistion",null,null,"NA at reporting date"]
[null,"Loans and borrowings",null,null,null,null,"Share capital",null,null,null,null,{"$f":"M34-J34","v":0},null,null,{"$f":"M34-J34","v":0}]
[null,"Trade and other payables",null,null,null,null,"Retained earnings",null,null,null,null,null,null,null,{"$f":"M35-J35","v":0}]
[null,"Current tax liabilities",null,null,null,null,null,null,null,{"$f":"SUM(J34:J35)","v":0},null,null,{"$f":"SUM(M34:M35)","v":0},null,{"$f":"M36-J36","v":0}]
[null,"Deferred tax liability"]
[null,"Total liabilities",{"$f":"SUM(C34:C37)","v":0}]
[]
[null,"Net identifiable assets and liabilities",{"$f":"C31+C38","v":0}]
[]
[null,"Consideration paid in cash"]
[null,"Consideration paid via offset with trade receivables"]
[null,"Total consideration",{"$f":"SUM(C42:C43)","v":0}]
[null,"Gain recognised in equity",{"$f":"C40-C44","v":0}]
[null,"Cash acquired",{"$f":"C24","v":0}]
[null,"Net cash inflow",{"$f":"C46-C42","v":0}]

{"sheet":"names","index":11,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Subsidiaries","Short name","In-charge","2012-05-16"]
["Tsesna Corporation","TSC","Teleusheva Saule",null,null,"Moderate","all"]
["Tsesna Bank","TSB","Zhakupova Ainur","provided Audit report and WPs, pack to be finalised","sent","High","all"]
["Tsesna Capital","TSCAP","Included to Tsesnabank / Tursunbekova Maira ",null,"N/A",null,"N/A"]
["Medet Holding","MEDH","Murzagaliyev Dauren","provided","sent","Low","all"]
["Info Tsess Newspaper","INFTS","Akhmetova Alma","provided","sent",null,"all"]
["Concern Tsesna Astyk","CTA","Dana Aldamzharova",null,null,null,null,"report","Concern Tsesna Astyk"]
["Zhaltyr Elevator","ZHALT","Murzagaliyev Dauren","provided","sent","Low","all"]
["Tsesna Astyk Bread Plant","BREAD","Bizhumanov Daniyar","provided, audit report","sent","Low","all"]
["Akmola Dirmen","AKMDIR","Duysupzhanova Gulnaz","provided","sent","Low"]
["Elevator Tsesna Astyk","ELEV","Duysupzhanova Gulnaz","provided","sent","Low",null,"report","Elevator Tsesna Astyk"]
["Alma Tsess","ALMTS","Davletov Sanjar","provided","sent",null,"all"]
["Tsesna Mak","TSMAK","Andrey Krom","provided","sent",null,null,"report","Tsesna Mak"]
["Astyk Logistic","ALTLOG","Bizhumanov Daniyar",null,null,"Low",null,"report","Astyk Logistic"]
["Tsesna Garant","TSG","Included to Tsesnabank / Vladislav Afimin ","audit report and WP's","N/A",null,"N/A"]
["Tsesna Footbol Club","FCTSC","Davletov Sanjar","provided","sent",null,null,"report","Tsesna Footbol Club"]

{"sheet":"codes","index":12,"n_rows":273,"n_cols":3,"rows_kept":273,"cut":false,"hidden":true,"merged":[]}
["Company / Description of adjustments"]
["Short name"]
["  Share:"]
["ASSETS",null,"АКТИВЫ"]
["Cash and cash equivalents",null,"Денежные средства и их эквиваленты"]
["Due from the NBRK",null,"Счета и депозиты в Национальном Банке Республики Казахстан"]
["Loans and advances to banks",null,"Кредиты и авансы, выданные банкам"]
["Amounts receivable under reverse repurchase agreements",null,"Финансовые инструменты обремененные залогом по сделкам «РЕПО»"]
["Loans to customers",null,"Кредиты, выданные клиентам"]
["FVTPL instruments",null,"Финансовые инструменты, оцениваемые по справедливой стоимости, изменения которой отражаются в составе прибыли или убытка за период"]
["- Held by the Group",null,"- удерживаемые группой"]
["- Pledged under sale and repurchase agreements",null,"- проданные в рамках соглашений о продаже с обязательством обратного выкупа (сделки «РЕПО»)"]
["AFS assets",null,"Финансовые активы, имеющиеся в наличии для продажи"]
["HTM securities",null,"Инвестиции, удерживаемые до срока погашения"]
["Trade and other receivables",null,"Торговая и прочая дебиторская задолженность"]
["Current tax asset",null,"Дебиторская задолженность по текущему подоходному налогу"]
["Inventories",null,"Запасы"]
["Loans to related parties",null,"Кредиты связанным сторонам"]
["Investments in subsidiaries",null,"Инвестиции в дочерние предприятия"]
["Investments in associate",null,"Инвестиции, учитываемые методом долевого участия"]
["Investment property",null,"Инвестиционная собственность"]
["Property, plant and equipment",null,"Основные средства"]
["Intangible assets",null,"Нематериальные активы"]
["Assets held for sale",null,"Активы, удерживаемые для продажи"]
["Deferred tax asset",null,"Требования по отложенному налогу"]
["Total assets",null,"Всего активов"]
[]
["LIABILITIES"]
["Loans and borrowings",null,"Кредиты и займы "]
["Current accounts and deposits from customers",null,"Текущие счета и депозиты клиентов"]
["Deposits and balances from banks and other financial institutions",null,"Счета и депозиты банков"]
["Trade and other payables",null,"Торговая и прочая кредиторская задолженность"]
["Amounts payable under repurchase agreements",null,"Ценные бумаги, приобретенные в рамках соглашений о покупке с обязательством обратной продажи (сделки «обратного РЕПО»)"]
[null,null,"Финансовые инструменты, оцениваемые по справедливой стоимости, изменения которой отражаются в составе прибыли или убытка за период"]
[null,null,"Обязательства, удерживаемые для продажи"]
["Income tax payable",null,"Кредиторская задолженность по текущему подоходному налогу"]
["Current tax liability",null,"Кредиторская задолженность по текущему подоходному налогу"]
["Deferred tax liability",null,"Обязательства по отложенному налогу"]
["Total liabilities",null,"Всего обязательств"]
[]
["EQUITY",null,"ОБЯЗАТЕЛЬСТВА"]
["Share capital",null,"Акционерный (уставный) капитал"]
["Share premium",null,"Эмиссионный доход"]
["Reserves for general banking risks",null,"Резерв на общие банковские риски"]
["Cumulative translation reserve",null,"Накопленный резерв по переводу в валюту представления данных "]
["Revaluation reserve for available-for-sale assets ",null,"Резерв по переоценке финансовых активов, имеющихся в наличии для продажи"]
["APIC",null,"Дополнительно-оплаченный капитал"]
["Net income",null,"Чистая прибыль / (убыток) текущего года"]
["Retained earnings",null,"Нераспределенная прибыль (накопленные убытки)"]
["Minority interest",null,"Доля неконтролирующих акционеров "]
["Equity",null,"Всего капитала"]
["Total equity and liabilities",null,"Всего обязательств и капитала"]
[]
["Total assets"]
["Total liabilities"]
[]
[]
["Income statement"]
["Banking revenue",null,"Банковские доходы "]
["Banking expenses",null,"Банковские расходы"]
["Non-banking revenue",null,"Небанковские доходы"]
["Non banking cost of sales",null,"Небанковская себестоимость реализации"]
["Other income",null,"Прочие доходы "]
["Change in fair value of investment property",null,"Изменение справедливой стоимости инвестиционной недвижимости"]
["Distribution expenses",null,"Расходы по реализации "]
["Administrative expenses",null,"Административные расходы"]
["Other expenses",null,"Прочие расходы"]
["Impairment losses",null,"Убытки от обесценения "]
["Non-banking financial income",null,"Небанковские финансовые доходы"]
["Non-banking financial expenses",null,"Небанковские финансовые расходы"]
["Gains from equity-accounted investees",null,"Прибыль/(убыток) от инвестиции в ассоциированное предприятие"]
["Income tax (expense)/benefit",null,"(Расход)/экономия по подоходному налогу  "]
["MI net income",null,"Прибыль к распределению между Миноритариями"]
["Net income for the period",null,"Прибыль/(убыток) за год"]
[]
[]
[]
["Statement of changes in equity"]
[]
["Reserves b/f",null,"Остаток на 1 января 2010 года "]
["Currency translation diffs",null,"Курсовые разницы при пересчете показателей зарубежных предприятий из других валют"]
["Transfer b/n reserves"]
["Net change in fair value of available-for-sale assets transferred to profit or loss",null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи, перенесенное в состав прибыли или убытка"]
["Net change in fair value of available-for-sale assets",null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи "]
["MI on reserves"]
["Reserves c/f"]
["Consolidated"]
[]
["Revaluation reserve b/f"]
["Transfer to retained earnings"]
["Revaluation reserve c/f"]
["Consolidated"]
[]
[]
["RE, b/f"]
["Net income",null,"Прибыль/(убыток) за год"]
["Business combinations"]
["Disposal of subsidiaries",null,"Выбытие дочерних предприятий"]
["Depreciation of revaluation reserve for property and equipment "]
["Dividends",null,"Дивиденды акционерам"]
["Discount recognised in equity"]
["Loss recognised directly in equity"]
["Transfer of NCI"]
["Transfer between reserves"]
["RE, c/f"]
["Consolidated"]
[]
[]
[]
["MI, b/f",null,"Переоценка объектов основных средств"]
["Net income",null,"Приобретение дочерних предприятий"]
["Reserves",null,"Приобретение доли меньшинства"]
["Business combination",null,"Распределение доли меньшинства"]
["Disposals",null,"Выкуп собственных акций"]
["Transfer from RE",null,"Продажа выкупленных собственных акций"]
["Acquisitions",null,"Прочие вклады собственников и выплаты собственникам"]
["MI, c/f"]
["Consolidated"]
[]
["Share capital, b/f"]
["Disposal of subsidiaries"]
["Transfer from RE"]
["Aqcuisitions"]
["Shares issued",null,"Выпуск акций"]
["Share capital, c/f"]
["Consolidated"]
[]
["APIC b/f"]
["Disposal of subsidiaries"]
["Business combination"]
["NCI"]
["Contributions"]
["APIC c/f"]
["Consolidated"]
[]
[]
["Share of 2nd level subsidiary"]
["Share of 1st level subsidiary"]
["Share of the Parent"]
[]
[]
[2010]
["Company / Description of adjustments"]
["Short name"]
["  Share:"]
["ASSETS"]
["Cash and cash equivalents"]
["Due from the NBRK"]
["Loans and advances to banks"]
["Amounts receivable under reverse repurchase agreements"]
["Loans to customers"]
["FVTPL instruments"]
["AFS assets"]
["HTM securities"]
["Trade and other receivables"]
["Current tax asset"]
["Inventories"]
["Loans to related parties"]
["Investments in subsidiaries"]
["Investments in associates"]
["Investment property"]
["Property, plant and equipment"]
["Intangible assets"]
["Assets held for sale"]
["Deffered tax assets"]
["Total assets"]
[]
["LIABILITIES"]
["Loans and borrowings"]
["Current accounts and deposits from customers"]
["Deposits and balances from banks and other financial institutions"]
["Trade and other payables"]
["Income tax payable"]
["Deferred tax liability"]
["Total liabilities"]
[]
["EQUITY"]
["Share capital"]
["Reserves"]
["Revaluation reserve"]
["APIC"]
["Net income"]
["Retained earnings"]
["Minority interest"]
["Equity"]
["Total equity and liabilities"]
[]
["Total assets"]
["Total liabilities"]
[]
[]
["Income statement"]
["Banking income"]
["Banking expense"]
["Non-banking income"]
["Non-banking cost of sales"]
["Other income"]
["Change in fair value of investment property"]
["Selling expense"]
["Administrative expense"]
["Other expense"]
["Impairment losses"]
["Non-banking financial income"]
["Non-banking finance expense"]
["Gain from associate"]
["Income tax expense"]
["MI net income"]
["Net income for the period"]
[]
[]
[]
["Statement of changes in equity"]
[]
["Reserves b/f"]
["Currency translation diffs"]
["Transfer b/n reserves"]
["Net change in fair value of available-for-sale assets transferred to profit or loss"]
["Net change in fair value of available-for-sale assets"]
["MI on reserves"]
["Reserves c/f"]
["Consolidated"]
[]
["Revaluation reserve b/f"]
["Transfer to retained earnings"]
["Revaluation reserve c/f"]
["Consolidated"]
[]
[]
["RE, b/f"]
["Net income"]
["Business combinations"]
["Disposal of subsidiaries"]
["Depreciation of revaluation reserve for property and equipment "]
["Dividends"]
["Discount recognised in equity"]
["Loss recognised directly in equity"]
["Transfer of NCI"]
["Transfer between reserves"]
["RE, c/f"]
["Consolidated"]
[]
[]
[]
["MI, b/f"]
["Net income"]
["Reserves"]
["Business combination"]
["Disposals"]
["Transfer from RE"]
["Acquisitions"]
["MI, c/f"]
["Consolidated"]
[]
["Share capital, b/f"]
["Disposal of subsidiaries"]
["Transfer from RE"]
["Aqcuisitions"]
["Shares issued"]
["Share capital, c/f"]
["Consolidated"]
[]
["APIC b/f"]
["Disposal of subsidiaries"]
["Business combination"]
["NCI"]
["Contributions"]
["APIC c/f"]
["Consolidated"]
[]
[]
["Share of 2nd level subsidiary"]
["Share of 1st level subsidiary"]
["Share of the Parent"]

{"sheet":"ФО1","index":13,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[5,1,5,6],[6,1,6,6],[7,1,7,6],[32,3,33,3]]}
[null,null,null,null,null,null,"      Утвержден                      "]
[null,null,null,null,null,null,"приказом Министра финансов              "]
[null,null,null,null,null,null,"Республики Казахстан                 "]
[null,null,null,null,null,null,"от 22 декабря 2005 года N 427              "]
[]
[null,"Консолидированный отчет о финансовом положении"]
[null,"по состоянию на \" 30\" сентября  2013 года"]
[null,"(Форма 1)"]
[]
[null,"Наименование организации   АО \"Корпорация \"Цесна\""]
[null,"Вид деятельности организации 74150,70201,51909,74202,67120, 65121"]
[null,"Организационно-правовая форма  Акционерное общество"]
[null,"Юридический адрес организации  г. Астана, ул.Сарайшык,40"]
[]
[null,"единица измерения",null,null,null,null,"тыс.тенге"]
[null,null,"Код стр.","На конец отчетного периода","корректировка\n аудиторов","На конец отчетного периода ","На начало отчетного периода "]
[null,"АКТИВЫ"]
[null,"Денежные средства и их эквиваленты",1,null,null,34962049,36048431]
[null,"Средства в Национальном Банке Республики Казахстан",2,5504091,14,{"$f":"'[1]раб табл ФО_2'!CJ16","v":0}]
[null,"Кредиты и авансы, выданные банкам",2,3800084,-56172,15942808,15578350]
[null,"Дебиторская задолженность по сделкам \"обратного репо\"",3,47215,10559]
[null,"Финансовые инструменты, оцениваемые по справедливой стоимости, изменения которой отражаются в составе прибыли или убытка за период",3,6991748,-1490117,21328773,31411145]
[null,"Финансовые активы, имеющиеся в наличии для продажи",4,139607,2476,4873174,5642870]
[null,"Инвестиции, удерживаемые до срока погашения",5,null,null,30980670,18073395]
[null,"Кредиты, выданные клиентам",6,216909,null,640340264,478826293]
[null,"Торговая и прочая дебиторская задолженность",7,null,null,31564104,27425240]
[null,"Актив, классифицируемый как удерживаемый для продажи"]
[null,"Текущие налоговые активы",8,18932490,-564051,85252,262949]
[null,"Запасы",9,null,null,2701748,2704758]
[null,"Инвестиции в ассоциированное предприятие",10]
[null,"Инвестиционная недвижимость",11,null,null,11937978,11917227]
[null,"Основные средства",12,null,null,24488888,15898758]
[null,"Нематериальные активы",13,0,null,1138835,1133644]
[null,"Отсроченные налоговые активы",14,null,null,null,30280]
[null,"Итого активов ",null,149412,89205,{"$f":"SUM(F18:F34)","v":820344543},{"$f":"SUM(G18:G34)","v":644953340}]
[null,"ОБЯЗАТЕЛЬСТВА И КАПИТАЛ",null,890346,-47717]
[null,"Кредиты и займы",15,0,null,71627673,48423546]
[null,"Текущие счета и вклады клиентов",16,0,null,634552888,517821058]
[null,"Вклады и остатки на счетах банков и прочих финансовых институтов",17,131547,-874,22836531,7786891]
[null,"Торговая и прочая кредиторская задолженность",18,null,null,15693617,{"$f":"8531699+4017925","v":12549624}]
[null,"Текущие налоговые обязательства",19,496595,55180,327757,12077]
[null,"Отсроченное налоговое обязательство",20,null,null,2162983,2126611]
[null,"Итого обязательств",null,null,null,{"$f":"SUM(F37:F42)","v":747201449},{"$f":"SUM(G37:G42)","v":588719807}]
[null,"Акционерный капитал",21,null,null,18750000,18750000]
[null,"Резервы",22,6690,-196,11041334,{"$f":"5688653-33752+277865","v":5932766}]
[null,"Прочий капитал",23,21267286,70529,-4314688,-4349516]
[null,"Нераспределенный доход отч.года прошлых лет",24,0,null,23435872,18572708]
[null,"Чистая прибыль отчетного года",null,82099,-80458]
[null,"Доля меньшинства",25,{"$f":"SUM(D45:D48)","v":21356075},{"$f":"SUM(E45:E48)","v":-10125},24230576,17327575]
[null,"Итого капитал","  ",null,null,{"$f":"SUM(F44:F49)","v":73143094},{"$f":"SUM(G44:G49)","v":56233533}]
[null,"Итого обязательств и  капитала",null,170380,346991,{"$f":"F43+F50","v":820344543},{"$f":"G43+G50","v":644953340}]
[null,"Балансовая стоимость одной простой акции - 3 840 тенге",null,null,null,null,{"$f":"G35-G43-G50","v":0}]
[null,"Балансовая стоимость одной привилегированной   акции - 1 050 тенге"]
[]
[]
[null,"Председатель Правления ______________________________________Е.С.Еденбаев"]
[null,"                                                                      (подпись)"]
[]
[null,"Главный бухгалтер ______________________________________",null,null,null,"А.С.Сагиндыкова"]
[null,"                                                                      (подпись)"]
[null,"Место печати"]

{"sheet":"ФО2","index":14,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[[11,5,13,5],[11,6,13,6],[1,1,2,6],[3,1,3,2],[11,1,13,1],[11,2,13,2],[11,3,13,3],[11,4,13,4]]}
[]
[null,"                    Консолидированный отчет о совокупном доходе, по состоянию на 30 сентября 2013 года."]
[]
[]
[]
[null,"Наименование организации   АО \"Корпорация \"Цесна\"",null,null,null,null,"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          "]
[null,"Вид деятельности организации 74150,70201,51909,74202,67120, 65121"]
[null,"Организационно-правовая форма  Акционерное общество"]
[null,"Юридический адрес организации  г. Астана, ул.Сарайшык,  40"]
[null,"единица измерения",null,null,null,null,"тыс.тенге"]
[null,null,null,"                                                        тыс. тенге"]
[null,"Наименование показателей","Код стр.","За отчетный период","корректировка\n аудиторов","За отчетный период ","За предыдущий период"]
[]
[]
[null,"Банковские доходы",1,{"$f":"'[2]раб таб 2'!S20","v":5627377},-951975,69827023,51255201]
[null,"Банковские расходы",2,{"$f":"'[2]раб таб 2'!S21","v":773108},1412097,-32259913,-21210180]
[null,"Небанковские доходы",3,{"$f":"SUM(D15-D16)","v":4854269},{"$f":"SUM(E15-E16)","v":-2364072},9289666,8036520]
[null,"Небанковская себестоимость реализации",4,{"$f":"'[2]раб таб 2'!S23","v":56494},-52644,-7455687,-5891985]
[null,"Валовая прибыль (строка 010 – строка 011)",null,{"$f":"'[2]раб таб 2'!S24","v":1702429},324720,{"$f":"SUM(F15:F18)","v":39401089},{"$f":"SUM(G15:G18)","v":32189556}]
[null,"Прочие доходы",5,{"$f":"'[2]раб таб 2'!S25","v":1597474},{"$f":"'[2]форма 2 за 2004г'!AC25","v":126016},467540,1255853]
[null,"Прибыль от инвестиции в ассоциированное предприятие",6,{"$f":"'[2]раб таб 2'!S26","v":2174773},-292645]
[null,"Изменение справедливой стоимости инвестиционной недвижимости",7,{"$f":"'[2]раб таб 2'!S27","v":27219},{"$f":"'[2]форма 2 за 2004г'!AC27","v":173058}]
[null,"Изменение справедливой стоимости инвестиционной недвижимости",6]
[null,"Расходы по реализации ",8,{"$f":"'[2]раб таб 2'!S28","v":466614},{"$f":"'[2]форма 2 за 2004г'!AC28","v":460428},-1143715,-1013342]
[null,"Административные расходы ",9,null,null,-17023492,-13259724]
[null,"Прочие расходы",10,null,0,-555322,-824054]
[null,"Убытки от обесценения",11,{"$f":"SUM(D17+D18+D19-D20-D21-D22-D24+D26)","v":2347112},{"$f":"SUM(E17+E18+E19-E20-E21-E22-E24+E26)","v":-2558853},-7393939,-3485701]
[null,null,null,null,null,{"$f":"SUM(F19:F27)","v":13752161},{"$f":"SUM(G19:G27)","v":14862588}]
[null,"Небанковские финансовые доходы",12,0,0,297110,1471326]
[null,"Небанковские финансовые расходы",13,{"$f":"D27-D29","v":2347112},{"$f":"E27-E29","v":-2558853},-888315,-607798]
[null,"Доходы по финансированию",null,{"$f":"SUM(D27-#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(E27-#REF!)","v":{"$error":"#REF!"}}]
[null,"Расходы по финансированию"]
[null,"Прибыль (убыток) до налогообложения",null,{"$f":"'[2]раб таб 2'!S35","v":56478.134700000002},{"$f":"'[2]форма 2 за 2004г'!AC35","v":11282},{"$f":"SUM(F28:F30)","v":13160956},{"$f":"SUM(G28:G30)","v":15726116}]
[null,"Расходы по подоходному налогу",14,"  ","  ",-2588342,-2254439]
[null,"Прибыль за год ",null,null,null,{"$f":"SUM(F33:F34)","v":10572614},{"$f":"SUM(G33:G34)","v":13471677}]
[null,"Прочий совокупный доход"]
[null,"Чистая прибыль/(убыток) от операций с финансовыми инструментами, оцениваемыми по справедливой стоимости, изменения которой отражаются в составе прибыли или убытка за период "]
[null,"Чистая прибыль от операций с иностранной валютой"]
[null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи",null,null,null,-74533,21984]
[null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи, перенесенное в состав прибыли или убытка",null,null,null,9130]
[null,"Резерв по переоценки активов, имеющихся в наличии для продажи:"]
[null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи"]
[null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи, перенесенное в состав прибыли или убытка",null,null,null,{"$f":"-'[1]раб табл ФО_2'!CJ95","v":0},0]
[null,"Курсовые разницы",null,null,null,{"$f":"[3]TS!DO80","v":0},56033]
[null,"Прочий совокупный доход (убыток) за год",null,null,null,{"$f":"SUM(F37:F44)","v":-65403},{"$f":"SUM(G37:G44)","v":78017}]
[null,"Всего совокупного дохода за год",null,null,null,{"$f":"F35+F45","v":10507211},{"$f":"G35+G45","v":13549694}]
[null,"Прибыль к распределению между:"]
[null,"Акционерами Компании",null,null,null,5650174,{"$f":"G35-G49","v":8530820}]
[null,"Миноритариями",null,null,null,4922440,4940857]
[null,"Прибыль за год ",null,null,null,{"$f":"SUM(F48:F49)","v":10572614},4199477]
[null,"Всего совокупного дохода к распределению между:"]
[null,"Акционерами Компании",null,null,null,5584771,{"$f":"G46-G53","v":8608837}]
[null,"Миноритариями",null,null,null,4922440,4940857]
[null,"Всего совокупного дохода за год",null,null,null,{"$f":"SUM(F52:F53)","v":10507211},{"$f":"SUM(G52:G53)","v":13549694}]
[null,"Прибыль на акцию:"]
[null,"Базовая прибыль на акцию",null,null,null,{"$f":"F48/18750","v":301.34261333333336},{"$f":"G48/18750","v":454.97706666666664}]
[]
[null,"Председатель Правления ______________________________________Е.С.Еденбаев"]
[null,"                                                                      (подпись)"]
[]
[null,"Главный бухгалтер  ______________________________________А.С.Сагиндыкова"]
[null,"                                                                      (подпись)"]
[null,"Место печати"]

{"sheet":"ФО3","index":15,"n_rows":76,"n_cols":4,"rows_kept":76,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[3,0,3,3],[13,0,13,3],[31,0,31,3],[51,0,51,3]]}
[]
["     Консолидированный отчет о движении денег"]
["по состоянию на \" 30 \" сентября  2013 года"]
["(прямой метод)"]
["                                                     (Форма 3)"]
[]
["Наименование организации   АО \"Корпорация \"Цесна\""]
["Вид деятельности организации 74150,70201,51909,74202,67120, 65121"]
["Организационно-правовая форма  Акционерное общество"]
["Юридический адрес организации  г. Астана, ул.Бейбитшилик,  43"]
[]
["единица измерения",null,null,"тыс.тенге"]
["Наименование показателей","Код  стр.","За отчетный период","   За предыдущий период"]
["I. Движение денежных средств от операционной деятельности"]
["1. Поступление денежных средств, всего",10,{"$f":"SUM(C17:C21)","v":6001831084},{"$f":"SUM(D17:D21)","v":4330824528}]
["в том числе:","  ","  ","  "]
["реализация товаров",11,9817851,8510784]
["предоставление услуг",12,14456862,22467594]
["авансы полученные",13,4785092,1664051]
["дивиденды,вознаграждения",14,-9424,17882]
["прочие поступления",15,5972780703,4298164217]
["2. Выбытие денежных средств, всего",20,{"$f":"SUM(C24:C30)","v":6018310212},{"$f":"SUM(D24:D30)","v":4328394816}]
["в том числе:","  "]
["платежи поставщикам за товары и услуги",21,16801667,25588813]
["авансы выданные",22,5020918,3462663]
["выплаты по заработной плате",23,7487886,7429283]
["выплата вознаграждения по займам",24,292606,18215852]
["корпоративный подоходный налог",25,5283942,203]
["подоходный налог и другие платежи в бюджет",26,711786,4561268]
["прочие выплаты",27,5982711407,4269136734]
["3. Чистая сумма денежных средств от операционной деятельности (стр.010-стр.020)",30,{"$f":"C15-C22","v":-16479128},{"$f":"D15-D22","v":2429712}]
["II. Движение денежных средств от инвестиционной деятельности"]
["1. Поступление денежных средств, всего",40,{"$f":"SUM(C35:C41)","v":7283941},{"$f":"SUM(D35:D41)","v":4785440}]
["в том числе:","  ",null,"  "]
["реализация основных средств",41,262959,81534]
["реализация нематериальных активов",42,{"$f":"[4]Сводная!BG32","v":0},0]
["реализация других долгосрочных активов",43,55533,0]
["реализация финансовых активов",44,6965449,3708852]
["погашение займов, предоставленных другим организациям",45,null,0]
["фьючерсные и форвардные контракты, опционы и свопы",46,{"$f":"[4]Сводная!BG36","v":0},0]
["прочие поступления",47,null,995054]
["2. Выбытие денежных средств, всего",50,6965449,{"$f":"SUM(D44:D50)","v":21701496}]
["в том числе:","  ",null,"  "]
["приобретение основных средств",51,11743042,1715522]
["приобретение нематериальных активов",52,201376,118346]
["приобретение других долгосрочных активов",53,70000,561000]
["приобретение финансовых активов",54,19708551,18480442]
["предоставление займов другим организациям",55]
["фьючерсные и форвардные контракты, опционы и свопы",56]
["прочие выплаты",57,192335,826186]
["3. Чистая сумма денежных средств от инвестиционной деятельности (стр.040-стр.050)",60,-24631363,{"$f":"D33-D42","v":-16916056}]
["III. Движение денежных средств от финансовой деятельности"]
["1. Поступление денежных средств, всего",70,{"$f":"SUM(C55:C58)","v":48347695},{"$f":"SUM(D55:D58)","v":23033625}]
["в том числе:","  ",null,"  "]
["эмиссия акций и других ценных бумаг",71,31045000]
["получение займов",72,17270270,7497169]
["получение вознаграждения по финансируемой аренде",73]
["прочие поступления",74,32425,15536456]
["2. Выбытие денежных средств, всего",80,{"$f":"SUM(C61:C64)","v":8331256},{"$f":"D61+D64+D63","v":16428821}]
["в том числе:","  "]
["погашение займов",81,6896891,9871320]
["приобретение собственных акций",82]
["выплата дивидендов",83,null,250390]
["прочие",84,1434365,6307111]
["3. Чистая сумма денежных средств от финансовой деятельности (стр.070-стр.080)",90,{"$f":"C53-C59","v":40016439},{"$f":"D53-D59","v":6604804}]
["4. Курсовая разница",100,7505,-55764]
["Итого: Увеличение +/- уменьшение денежных средств (стр.030+/-стр.060+/-стр.090)","  ",{"$f":"C31+C51+C65","v":-1094052},{"$f":"D31+D51+D65+D66","v":-7937304}]
["Денежные средства и их эквиваленты на начало отчетного периода","  ",36048596,19597050]
["Денежные средства и их эквиваленты на конец отчетного периода","  ",{"$f":"C67+C68+C66","v":34962049},{"$f":"D67+D68","v":11659746}]
[]
["Председатель Правления _____________________________________Е.С. Еденбаев"]
["                                                                      (подпись)"]
[]
["Главный бухгалтер _________________________________________С.В.Денисенко ",null,null,"А.С.Сагиндыкова"]
["                                                                      (подпись)"]
["Место печати"]

{"sheet":"ФО4","index":16,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,2,8],[3,1,3,8],[4,1,4,8],[5,1,5,8]]}
[]
[null,"  ОТЧЕТ ОБ ИЗМЕНЕНИЯХ В КАПИТАЛЕ"]
[null,"(консолидированный)"]
[null,"АО 'Корпорация \"Цесна\"'"]
[null,"по состоянию на 30 сентября 2013 года."]
[]
[null,null,null,null,null,null,null,null,null,null,"в тысячах тенге"]
[null,null,"Акционерный  капитал","Резервы по переоценке активов, имеющихся в наличии для продажи","Резерв накопленных курсовых разниц по пересчету в другую валюту","Резерв на покрытие общих банковских рисков ","Дополнительно оплаченный капитал","Нераспределенная прибыль","Итого","Доля миноритариев","Итого капитала"]
[null,1,2,4,5,6,7,8,9,10,11]
[null,"Остаток на 01 января 2012 г.",18750000,335840,44701,1542478,-4567633,11561111,{"$f":"SUM(C10:H10)","v":27666497},12379431,{"$f":"I10+J10","v":40045928}]
[null,"Итого совокупного дохода",null,null,null,null,null,null,null,null,0]
[null,"Чистый доход за год",null,null,null,null,null,10011034,{"$f":"SUM(C12:H12)","v":10011034},4119831,14130865]
[null,"Прочий совокупный доход",null,null,null,null,null,null,{"$f":"SUM(C13:H13)","v":0},null,0]
[null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи, перенесенное в состав прибыли или убытка за период",null,11200,null,null,null,null,11200,6070,17270]
[null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи ",null,-48335,null,null,null,null,-48335,-26198,-74533]
[null,"Курсовые разницы",null,null,-78453,null,null,null,-78453,null,-78453]
[null,"Накопленный резерв дочерней организации, по переоценке активов, имеющихся в наличии для продажи на начало отчетного периода",null,null,null,null,null,null,0]
[null,"Перевод между резервами",null,null,null,4146175,null,-4146175,0,null,0]
[null,"Влияние изменения налоговых ставок на отсроченный налог, признанный в составе капитала",null,null,null,null,null,null,0,null,0]
[null,"Накопленная сумма прибыли дочерней организации на начало отчетного периода ",null,null,null,null,null,null,0]
[null,"Итого прочего совокупного дохода",{"$f":"C14+C15+C18+C19+C16","v":0},{"$f":"D14+D15+D18+D19+D16+D17","v":-37135},{"$f":"E14+E15+E18+E19+E16+E17","v":-78453},{"$f":"F14+F15+F18+F19+F16+F17","v":4146175},{"$f":"G14+G15+G18+G19+G16+G17","v":0},{"$f":"H14+H15+H18+H19+H16+H20","v":-4146175},-115588,{"$f":"SUM(J13:J19)","v":-20128},-135716]
[null,"Итого совокупного дохода",{"$f":"C12+C21","v":0},-37135,-78453,4146175,{"$f":"G12+G21","v":0},5864859,9895446,{"$f":"J21+J12","v":4099703},13995149]
[null,"Сделки с собственниками, признанные непосредственно в капитале"]
[null,"Приобретение дочернего предприятия",null,null,null,null,null,null,0,null,0]
[null,"Приобретение доли меньшинства",null,null,null,null,null,null,0,null,0]
[null,"Взносы акционеров",null,null,null,null,null,null,0,null,0]
[null,"Распределение доли меньшинства",null,null,null,null,null,null,0,null,0]
[null,"Выбытие дочернего предприятия",null,-20840,null,null,218117,1146738,1344015,{"$f":"1458513-610072","v":848441},2192456]
[null,"Выпуск акций ",null,null,null,null,null,null,0,null,0]
[null,"Формирование резервов ",null,null,null,null,null,null,0,null,0]
[null,"Итого сделок с собственниками",null,null,null,null,null,null,0,{"$f":"SUM(J24:J28)","v":848441},{"$f":"SUM(K24:K28)","v":2192456}]
[null,null,null,null,null,null,null,null,0,null,0]
[null,"Остаток на 31 декабря 2012 г.",{"$f":"C10+C22+C32","v":18750000},{"$f":"D10+D22+D32+D27+D28","v":277865},{"$f":"E10+E22+E32+E27","v":-33752},{"$f":"F10+F22+F32+F30+F27","v":5688653},{"$f":"G10+G24+G27+G28+G16+G18","v":-4349516},{"$f":"H10+H12+H18+H20+H30+H27+H26+H28","v":18572708},{"$f":"SUM(C33:H33)","v":38905958},{"$f":"J10+J22+J31+J29","v":17327575},56233533]
[null,null,null,null,null,null,null,null,null,null,0]
[null,"Остаток на 01 января  2013 г.",18750000,{"$f":"D33","v":277865},{"$f":"E33","v":-33752},5688653,-4349516,18572708,38905958,17327575,56233533]
[null,"Итого совокупного дохода",null,null,null,null,null,null,0,null,0]
[null,"Чистый доход за год",null,null,null,null,null,{"$f":"10572614-J37","v":5650174},5650174,4922440,10572614]
[null,"Прочий совокупный доход",null,null,null,null,null,null,0,null,0]
[null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи, перенесенное в состав прибыли или убытка за период",null,22923,null,null,null,null,22923,null,22923]
[null,"Чистое изменение справедливой стоимости активов, имеющихся в наличии для продажи ",null,-10434,null,null,null,null,-10434,null,-10434]
[null,"Накопленный резерв дочерней организации, по переоценке активов, имеющихся в наличии для продажи на начало отчетного периода",null,null,null,null,null,null,0,null,0]
[null,"стабилизационный резерв по страховой деятельности",null,null,102395,null,null,-102395,0,null,0]
[null,"Перевод резерва по переоценке в состав нераспределенной стоимости по использованию переоцененной собственности",null,null,null,null,null,null,0,null,0]
[null,"Накопленная сумма прибыли дочерней организации на начало отчетного периода ",null,712,null,null,null,654,1366,null,1366]
[null,"Итого прочего совокупного дохода",{"$f":"C39+C40+C41+C43+C42+C44","v":0},13201,102395,0,{"$f":"G37+G39+G40+G41+G43+G42+G44","v":0},{"$f":"H39+H40+H41+H43+H42+H44","v":-101741},{"$f":"I39+I40+I41+I43+I42+I44","v":13855},null,13855]
[null,"Итого совокупного дохода",{"$f":"C37+C45","v":0},13201,102395,{"$f":"F37+F45","v":0},{"$f":"G45","v":0},{"$f":"H45+H37","v":5548433},{"$f":"I45+I37","v":5664029},{"$f":"SUM(J37:J45)","v":4922440},10586469]
[null,"Сделки с собственниками, признанные непосредственно в капитале"]
[null,"Выплата дивидендов",null,null,null,null,null,{"$f":"2000000+1980000","v":3980000},3980000,null,3980000]
[null,"Изменение в учетной политике",null,null,null,null,null,null,0,null,0]
[null,"Распределение долей неконтролирующих акционеров",null,null,null,null,34828,327703,{"$f":"SUM(C50:H50)","v":362531},1980561,2343092]
[null,"Перевод между резервами",null,null,null,4992972,null,-4992972,null,null,0]
[null,"Перевод резерва ",null,null,null,null,null,null,{"$f":"SUM(C52:H52)","v":0},null,0]
[null,"Выпуск акций ",null,null,null,null,null,null,0,null,0]
[null,"Остаток на 30 сентября 2013 г.",{"$f":"C35+C46+C53+C51","v":18750000},{"$f":"D35+D46+D53+D51+D50","v":291066},{"$f":"E35+E46+E53+E51+E50","v":68643},{"$f":"F35+F46+F53+F51+F52+F50","v":10681625},{"$f":"G35+G46+G53+G51+G50+G52","v":-4314688},{"$f":"H35+H46+H53+H51+H48+H49+H50+H52","v":23435872},{"$f":"SUM(C54:H54)","v":48912518},{"$f":"J35+J46+J50+J53+J52","v":24230576},{"$f":"I54+J54","v":73143094}]
[]
[null,null,{"$f":"-C54","v":-18750000},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"I35+I46+I50+I49","v":44932518},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Председатель Правления                              ______________________Е.С.Еденбаев"]
[null,"                                                                      (подпись)"]
[null,null,null,null,null,null,null,{"$f":"H56+H54","v":{"$error":"#REF!"}},{"$f":"I56+I54","v":93845036}]
[null,"Главный бухгалтер ______________________________________________",null,null,"А.С.Сагиндыкова"]
[null,"                                                                      (подпись)"]
[null,"Место печати"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"I63-H63","v":0}]