{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["guide","FS","dca","cra","ratios<","metrics<","accounts<","config","model","manual","calc","names","validate","cra grid","test","<JE","count"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":19,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"guide","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,32,8]]}
[]
[null,"Package: AC.finance.fs\n\nAvailable functions:\n\n1.     \n"]

{"sheet":"FS","index":1,"n_rows":57,"n_cols":24,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: FINANCIAL STATEMENTS IN STANDARDIZED OUTPUT FORMAT"]
[]
[null,"Parameter key",null,"Parameter object","size",null,null,"Metric output object",null,null,null,"size",null,null,null,"size",null,null,null,null,null,"size"]
[null,{"$f":"config!B13","v":"metric-levels"},null,{"$f":"_xll.AC.data.map(names!G9:G83, names!I9:I83, 0)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:37:817..2071232410842837232"},{"$f":"_xll.AC.data.size(D5, 1)","v":64}," ",null,"metrics output",null,{"$f":"_xll.AC.finance.fs.get(calc!K8, config!B7, _xll.AC.data.map(B5:B6, D5:D6))","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:37:898..9000302027142440671"},null,{"$f":"_xll.AC.data.size(J5, 1)","v":32},null,{"$f":"D5","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:37:817..2071232410842837232"},null,{"$f":"_xll.AC.data.size(N5, 1)","v":64},null,{"$f":"H5","v":"metrics output"},null,{"$f":"_xll.AC.finance.fs.get(calc!K8, config!B7, _xll.AC.data.map(B5:B6, N5:N6))","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:37:905..7501639911809676148"},null,{"$f":"_xll.AC.data.size(T5, 1)","v":20},null," "]
[null,{"$f":"config!B15","v":"metric-names"},null,{"$f":"_xll.AC.data.list_x(B12:B13, 0, 1)","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:438..6674366794769735504"},{"$f":"_xll.AC.data.size(D6, 1)","v":2}," ",null,null,null,null,null,{"$f":"_xll.AC.data.size(J5, 2)","v":14},null,{"$f":"_xll.AC.data.list_x(B15:B24, 0, 1)","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:441..733514025384559712"},null,{"$f":"_xll.AC.data.size(N6, 1)","v":10},null,null,null,null,null,{"$f":"_xll.AC.data.size(T5, 2)","v":14}]
[]
[]
[null,null,"Balance Sheet",null,null,null,null,null,null,null,null,null,null,"Income Statement"]
[]
[null,"Metric","#",{"$f":"_xll.AC.data._get(J5, \"\", 0)","v":"Account Name"},"level","is metric","31-Mar-13","31-Mar-14","31-Mar-15","31-Mar-16","31-Mar-17",null,null,"#",{"$f":"_xll.AC.data._get(T5, \"\", 0)","v":"Account Name"},"level","is metric","31-Mar-13","31-Mar-14","31-Mar-15","31-Mar-16","31-Mar-17"]
[null,{"$f":"names!G9","v":"TOT_ASSETS"},1,"total assets",0,1,1058500,1330300,1327500,1554800,1737700,null,null,1,"gross profits",0,1,530300,535700,527600,480100,523500]
[null,{"$f":"names!G24","v":"TOT_LIAB_EQTY"},{"$f":"IF(D13=\"\", \"\", C12+1)","v":2},"     total current assets",1,1,614500,675700,684200,746100,677800,null,null,{"$f":"IF(O13=\"\", \"\", N12+1)","v":2},"     total revenue",1,1,2862700,3131600,3425400,3357000,3007700]
[null,null,{"$f":"IF(D14=\"\", \"\", C13+1)","v":3},"          cash and marketable securities",2,0,65600,104100,79700,122900,83400,null,null,{"$f":"IF(O14=\"\", \"\", N13+1)","v":3},"     total COGS",1,1,-2332400,-2595900,-2897800,-2876900,-2484200]
[null,{"$f":"names!G29","v":"GROSS_PROFITS"},4,"          accounts receivable",2,0,444600,472300,581600,593100,480600,null,null,4,"total operating expense",0,1,-352700,-386700,-400800,-352100,-412100]
[null,{"$f":"names!G30","v":"OPEX"},5,"          inventory",2,0,11700,7200,4900,10500,22000,null,null,5,"     selling general and administrative costs",1,0,-310000,-334400,-346200,-294200,-381300]
[null,{"$f":"names!G36","v":"EBITDA"},6,"          other current assets (part of WC)",2,0,92600,92100,18000,19600,91800,null,null,6,"     other expense (income)",1,0,-42700,-52300,-54600,-57900,-30800]
[null,{"$f":"names!G37","v":"D&A"},7,"     total long-term assets",1,1,444000,654600,643300,808700,1059900,null,null,7,"earnings before interest, tax and D&A (EBITDA)",0,1,177600,149000,126800,128000,111400]
[null,{"$f":"names!G34","v":"EBIT"},8,"          net fixed assets",2,0,16300,19300,18800,159800,253800,null,null,8,"amortization and depreciation",0,1,-17100,-15800,-39900,-35300,-90600]
[null,{"$f":"names!G31","v":"TOT_INT"},9,"          goodwill",2,0,217600,216000,218900,238700,252200,null,null,9,"     amortization",1,0,-12100,-13000,-36800,-31400,-86200]
[null,{"$f":"names!G33","v":"EBT"},10,"          intangible assets (other than goodwill)",2,0,51800,50300,55700,127400,187900,null,null,10,"     depreciation",1,0,-5000,-2800,-3100,-3900,-4400]
[null,{"$f":"names!G32","v":"TOT_NON_OPEX"},11,"          investments - long term",2,0,14000,8000,8400,37000,39700,null,null,11,"earnings before interest and tax (EBIT)",0,1,160500,133200,86900,92700,20800]
[null,{"$f":"names!G39","v":"INC_TAX"},12,"          deferred tax asset - long-term",2,0,17300,31500,21000,1500,24500,null,null,12,"total interest expense",0,1,-59500,-55300,-64800,-66000,-73900]
[null,{"$f":"names!G38","v":"NI"},13,"          other long-term assets (part of CFO)",2,0,0,0,16100.000000000002,174600,68400,null,null,13,"     interest expense",1,0,-59500,-55300,-64800,-66000,-73900]
[null,null,14,"          other long-term assets (part of OCI)",2,0,127000,329500,304400,69700,233400,null,null,14,"earnings before tax (EBT)",0,1,101000,77900,22100,26700,-53100]
[null,null,15,"total liabilities and equity",0,1,795500,652700,463500,1365200,1192800,null,null,15,"total non-operating expense",0,1,286200,-19300,-560600,179600,722700]
[null,null,16,"     total liabilities",1,1,918100,1174100,987300,1471400,1355000,null,null,16,"     non-operating expenses",1,0,286200,-19300,-560600,179600,722700]
[null,null,17,"          total current liabilities",2,1,405400,437800,448300,525800,505600,null,null,17,"total income tax",0,1,-32900,200,25400,-45800,-86300]
[null,null,18,"               accounts payable",3,0,386000,409600,435400,475900,330000,null,null,18,"     current income tax",1,0,-32900,200,25400,-45800,-86300]
[null,null,19,"               current portion of long-term debt",3,0,0,0,0,47000,159800,null,null,19,"net income",0,1,354300,58800,-513100,160500,583300]
[null,null,20,"               other current liabilities (part of WC)",3,0,19400,28200,12900,2900,15800,null,null,""]
[null,null,21,"          total long-term liabilities",2,1,512700,736300,539000,945600,849400,null,null,""]
[null,null,22,"               third-party debt - long-term",3,0,374800,508700,533100,840800,782400,null,null,""]
[null,null,23,"               deferred tax liability - long-term",3,0,1300,1100,1000,29800,30800,null,null,""]
[null,null,24,"               other long-term liabilities (part of CFO)",3,0,2100,5500,4900,33900,35500,null,null,""]
[null,null,25,"               other long-term liabilities (part of OCI)",3,0,134500,221000,0,41100,700,null,null,""]
[null,null,26,"     total other comprehensive income",1,1,52900,53700,44400,65099.999999999993,46400,null,null,""]
[null,null,27,"          other comprehensive income",2,0,52900,53700,44400,65099.999999999993,46400,null,null,""]
[null,null,28,"     total equity",1,1,-175500,-575100,-568200,-171300,-208600,null,null,""]
[null,null,29,"          retained earnings",2,0,-1121000,-1432100,-1440900,-1170800,-1279300,null,null,""]
[null,null,30,"          other owners equity",2,0,945500,857000,872700,993700,1071400,null,null,""]
[null,null,31,"          minority interest",2,0,0,0,0,5800,-700,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",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":"IF(D54=\"\", \"\", C53+1)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O54=\"\", \"\", N53+1)","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"dca","index":2,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: DCA METRICS AND RATIOS"]
[]
[null,"DCA Metrics"]
[]
[null,{"$f":"config!B15","v":"metric-names"},{"$f":"_xll.AC.data.list_x(B10:B14, 0, 1)","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:401..6327396496261576006"},{"$f":"_xll.AC.data.size(C6, 1)","v":5}]
[null,"metrics list",{"$f":"_xll.AC.finance.fs.get(calc!K8, config!B7, _xll.AC.data.map(B6:B6, C6:C6))","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:526..7600518256901461593"},{"$f":"_xll.AC.data.size(C7, 1)","v":6},{"$f":"_xll.AC.data.size(C7, 2)","v":14}]
[]
[null,"Metric",{"$f":"_xll.AC.data._get(C7, \"\", 0)","v":"Account Name"},"level","is metric","31-Mar-13","31-Mar-14","31-Mar-15","31-Mar-16","31-Mar-17"]
[null,{"$f":"names!G19","v":"TOT_DEBT"},"total debt",0,1,374800,508700,533100,887800,942200]
[null,{"$f":"names!G22","v":"TOT_EQTY"},"total equity",0,1,-175500,-575100,-568200,-171300,-208600]
[null,{"$f":"names!G34","v":"EBIT"},"earnings before interest and tax (EBIT)",0,1,160500,133200,86900,92700,20800]
[null,{"$f":"names!G36","v":"EBITDA"},"earnings before interest, tax and D&A (EBITDA)",0,1,177600,149000,126800,128000,111400]
[null,{"$f":"names!G31","v":"TOT_INT"},"total interest expense",0,1,-59500,-55300,-64800,-66000,-73900]
[]
[]
[null,"DCA Ratios"]
[]
[null,{"$f":"config!B16","v":"ratio-names"},{"$f":"_xll.AC.data.list_x(B23:B26, 0, 1)","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:442..8832695662314558461"},{"$f":"_xll.AC.data.size(C19, 1)","v":4}]
[null,null,{"$f":"_xll.AC.finance.fs.get(calc!K8, config!B8, _xll.AC.data.map(B19:B19, C19:C19))","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:520..736281471537571623"},{"$f":"_xll.AC.data.size(C20, 1)","v":5},{"$f":"_xll.AC.data.size(C20, 2)","v":14}]
[]
[null,"Ratio",{"$f":"_xll.AC.data._get(C20, \"\", 0)","v":"Account Name"},"level","format","31-Mar-13","31-Mar-14","31-Mar-15","31-Mar-16","31-Mar-17"]
[null,{"$f":"names!M9","v":"DEBT/EBITDA"},"Debt to EBITDA",0,"x.x",2.1103603603603602,3.4140939597315438,4.2042586750788642,6.9359374999999996,8.4578096947935375]
[null,{"$f":"names!M10","v":"DEBT/EQTY"},"Debt to Equity",0,"x.x",-2.1356125356125357,-0.88454181881411931,-0.93822597676874342,-5.1827203736135434,-4.5167785234899327]
[null,{"$f":"names!M11","v":"EBIT/INT_EXP"},"EBIT to Interest Expense",0,"x.x",2.6974789915966388,2.4086799276672695,1.3410493827160495,1.4045454545454545,0.28146143437077131]
[null,{"$f":"names!M13","v":"EBITDA/INT_EXP"},"EBITDA to Interest Expense",0,"x.x",2.984873949579832,2.694394213381555,1.9567901234567902,1.9393939393939394,1.5074424898511503]

{"sheet":"cra","index":3,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":false,"merged":[[15,3,15,4]]}
[]
[null,"TAB: CREDIT RATING ANALYSIS"]
[]
[null,"Based on Moody's Methodology:",null,null,{"$f":"_xll.AC.finance.cra.get(calc!K6, config!B25)","v":"Distribution and Supply Chain Service Industry, 11 Dec 2015"}]
[]
[null,"Qualitative overlay",null,null,null,null,null,null,"Consensus credit rating"]
[]
[null,"`#","Factor","Weight","Adjusted weight","Rating",null,null,"Parameter",null,null,null,null,"Weight","Adjusted weight","Credit \nscore","Credit \nrating"]
[null,1,{"$f":"_xll.AC.finance.cra.get(calc!K6, config!B26)","v":"Business Profile"},0.15,0.15,"Ba",null,null,"Credit rating based on quantitative metric grid",null,null,null,null,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B28)","v":0.70000000000000007},0.70000000000000007,14.404761904761903,"B1"]
[null,{"$f":"IF(C10=\"\", \"\", B9+1)","v":2},"Financial Policy",0.15,0.15,"Ba",null,null,"Credit rating based on qualitative factors",null,null,null,null,0.3,0.3,12,"Ba2"]
[null,{"$f":"IF(C11=\"\", \"\", B10+1)","v":""},null,null,null,null,null,null,"Consensus credit rating",null,null,null,null,1,1,13.683333333333334,"B1"]
[]
[]
[null,"Quantitative metric grid"]
[]
[null,null,null,"Period-averaging scenarios",null,{"$f":"\"FY\" & YEAR(OFFSET($M$16, 0, F17)) & \" - \" & CHAR(10) &YEAR(OFFSET($M$16, 0, F18))","v":"FY2013 - \n2015"},{"$f":"\"FY\" & YEAR(OFFSET($M$16, 0, G17)) & \" - \" & CHAR(10) &YEAR(OFFSET($M$16, 0, G18))","v":"FY2013 - \n2016"},"FY2013 - \n2017","FY2014 - \n2015","FY2014 - \n2016","FY2014 - \n2017",null,"Dates",{"$f":"model!E9","v":"2013-03-31"},{"$f":"model!F9","v":"2014-03-31"},{"$f":"model!G9","v":"2015-03-31"},{"$f":"model!H9","v":"2016-03-31"},{"$f":"model!I9","v":"2017-03-31"}]
[null,null,null,"First period",null,1,1,1,2,2,2,null,null,1,{"$f":"N17+1","v":2},{"$f":"O17+1","v":3},4,5]
[null,"Factor-specific ratings",null,"Last period",null,3,4,5,3,4,5,null,"Factor-specific scores"]
[]
[null,"#","Factor","Weight","Adjusted weight",{"$f":"F16","v":"FY2013 - \n2015"},{"$f":"G16","v":"FY2013 - \n2016"},"FY2013 - \n2017","FY2014 - \n2015","FY2014 - \n2016","FY2014 - \n2017",null,{"$f":"F20","v":"FY2013 - \n2015"},{"$f":"G20","v":"FY2013 - \n2016"},"FY2013 - \n2017","FY2014 - \n2015","FY2014 - \n2016","FY2014 - \n2017"]
[null,1,{"$f":"_xll.AC.finance.cra.get(calc!K6, config!B27)","v":"REV_BLN"},0.1,0.1,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B29)","v":"B"},"B","B","B","B","B",null,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B30)","v":15},15,15,15,15,15]
[null,{"$f":"IF(C22=\"\", \"\", B21+1)","v":2},"EBITA_BLN",0.1,0.1,"B","B","B","B","B","B",null,15,15,15,15,15,15]
[null,{"$f":"IF(C23=\"\", \"\", B22+1)","v":3},"OM",0.1,0.1,"B","B","B","B","B","B",null,15,15,15,15,15,15]
[null,4,"ROC",0.05,0.05,"Ca","B","Aa","Aaa","Ca","Baa",null,20,15,3,1,20,9]
[null,5,"DEBT/EBITDA",0.1,0.1,"Ba","Ba","B","Ba","B","B",null,12,12,15,12,15,15]
[null,6,"EBITA/INT_EXP",0.15,0.15,"B","B","B","B","B","B",null,15,15,15,15,15,15]
[null,7,"RCF/DEBT",0.1,0.1,"B","Ba","Baa","Ca","Ca","Baa",null,15,12,9,20,20,9]
[null,"Consensus rating / score before qualitative overlay",null,null,null,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B31)","v":"B2"},"B1","Ba3","B1","B3","B1",null,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B32)","v":14.928571428571429},14.142857142857142,13.285714285714285,14.285714285714285,16.071428571428569,13.714285714285712]
[null,"Consensus rating / score after qualitative overlay",null,null,null,"B1","Ba3","Ba3","B1","B2","Ba3",null,14.05,13.5,12.9,13.6,14.85,13.2]
[]
[null,"Matching ratios to grid values",null,null,null,null,null,null,null,null,null,null,"Quantitatve metric grid"]
[null,""]
[null,{"$f":"B20","v":"#"},"Factor","Weight","Adjusted weight","FY2013 - \n2015","FY2013 - \n2016","FY2013 - \n2017","FY2014 - \n2015","FY2014 - \n2016","FY2014 - \n2017",null,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B33)","v":"compare"},"format","Aaa","Aa","A","Baa","Ba","B","Caa","Ca"]
[null,1,{"$f":"_xll.AC.finance.cra.get(calc!K6, config!B27)","v":"REV_BLN"},0.1,0.1,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B34)","v":"[5, 2]"},"[5, 2]","[5, 2]","[5, 2]","[5, 2]","[5, 2]",null,">=","x.x",160,85,35,15,5,2,0.5,""]
[null,{"$f":"IF(C35=\"\", \"\", B34+1)","v":2},"EBITA_BLN",0.1,0.1,"[0.4, 0.1]","[0.4, 0.1]","[0.4, 0.1]","[0.4, 0.1]","[0.4, 0.1]","[0.4, 0.1]",null,">=","x.x",8,4,2,0.75,0.4,0.05,0,""]
[null,3,"OM",0.1,0.1,"[5%, 2%]","[5%, 2%]","[5%, 2%]","[5%, 2%]","[5%, 2%]","[5%, 2%]",null,">=","%",0.4,0.3,0.2,0.1,0.05,0.02,5.0000000000000001E-3,""]
[null,4,"ROC",0.05,0.05,"[1%, ---]","[7.5%, 2.5%]","[50%, 35%]","[---, 50%]","[1%, ---]","[25%, 15%]",null,">=","%",0.5,0.35,0.25,0.15,7.4999999999999997E-2,2.5000000000000001E-2,0.01,""]
[null,5,"DEBT/EBITDA",0.1,0.1,"[3, 4.5]","[3, 4.5]","[4.5, 6.5]","[3, 4.5]","[4.5, 6.5]","[4.5, 6.5]",null,"<=","x.x",0.5,1,2,3,4.5,6.5,9,""]
[null,6,"EBITA/INT_EXP",0.15,0.15,"[2.5, 1.5]","[2.5, 1.5]","[2.5, 1.5]","[2.5, 1.5]","[2.5, 1.5]","[2.5, 1.5]",null,">=","x.x",25,15,10,5,2.5,1.5,0.75,""]
[null,7,"RCF/DEBT",0.1,0.1,"[12.5%, 5%]","[22.5%, 12.5%]","[35%, 22.5%]","[0%, ---]","[0%, ---]","[35%, 22.5%]",null,">=","%",0.7,0.5,0.35,0.22500000000000001,0.125,0.05,0,""]
[]
[null,"Period-specific average ratios",null,null,null,null,null,null,null,null,null,null,"Year-specific average ratios"]
[null,""]
[null,{"$f":"B20","v":"#"},"Factor","Weight","Adjusted weight","FY2013 - \n2015","FY2013 - \n2016","FY2013 - \n2017","FY2014 - \n2015","FY2014 - \n2016","FY2014 - \n2017",null,{"$f":"IF(N16=\"\", \"\", N16)","v":"2013-03-31"},"2014-03-31","2015-03-31","2016-03-31","2017-03-31","","","","",""]
[null,1,{"$f":"_xll.AC.finance.cra.get(calc!K6, config!B27)","v":"REV_BLN"},0.1,0.1,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B36)","v":3.1398999999999999},3.194175,3.1568800000000001,3.2785000000000002,3.3046666666666664,3.2304249999999999,null,{"$f":"_xll.AC.finance.cra.get(calc!K11, config!B35)","v":2.8626999999999998},3.1316000000000002,3.4253999999999998,3.3570000000000002,3.0076999999999998]
[null,{"$f":"IF(C46=\"\", \"\", B45+1)","v":2},"EBITA_BLN",0.1,0.1,0.14749999999999999,0.14165,0.13472000000000001,0.13494999999999999,0.13133333333333333,0.12525,null,0.1726,0.1462,0.1237,0.1241,0.107]
[null,{"$f":"IF(C47=\"\", \"\", B46+1)","v":3},"OM",0.1,0.1,4.0404683800970308E-2,3.7043994145593152E-2,3.1303058716200809E-2,3.356718011285649E-2,3.1551341537220098E-2,2.5817036458051185E-2,null,5.6065951723897021E-2,4.2534167837527143E-2,2.5369299935773925E-2,2.7613941018766755E-2,6.915583336104E-3]
[null,4,"ROC",0.05,0.05,-1.0224948875255624,7.4296942158909487E-2,0.41591834097809938,4.4758620689655171,-0.47772357723577236,0.21466706213851403,null,1.777722027094832,-0.88554216867469882,14.618233618233619,0.22400558269364967,0.79511995637949839]
[null,5,"DEBT/EBITDA",0.1,0.1,3.1243934715483017,3.9635362917096661,4.6862009237875286,3.777374909354605,4.7786032689450222,5.5741459627329188,null,2.1103603603603602,3.4140939597315438,4.2042586750788642,6.9359374999999996,8.4578096947935375]
[null,6,"EBITA/INT_EXP",0.15,0.15,2.4638084632516706,2.30700325732899,2.1082942097026605,2.2472939217318899,2.1171413218699624,1.926923076923077,null,2.9008403361344537,2.6437613019891502,1.9089506172839505,1.8803030303030304,1.4479025710419486]
[null,7,"RCF/DEBT",0.1,0.1,8.0957221516306646E-2,0.15736156917201874,0.33724665804225962,-0.2915348435400269,-2.890806384742952E-2,0.23556654363117208,null,1.1163420490928495,0.23252801258108904,-0.79161132995685612,0.27927461139896376,0.77720335385268524]
[null,""]
[null,""]

{"sheet":"ratios<","index":4,"n_rows":105,"n_cols":17,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: FINANCIAL STATEMENT RATIOS"]
[]
[null,"Parameter key",null,"Parameter object",null,null,"size","Metric output object"]
[null,{"$f":"config!B13","v":"metric-levels"},null,{"$f":"_xll.AC.data.map(names!G9:G80, names!J9:J80)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:478..5876697257220149224"},null,null,{"$f":"_xll.AC.data.size(D5, 1)","v":61},"ratios output",null,{"$f":"_xll.AC.finance.fs.get(calc!K8, config!B8, _xll.AC.data.map(B5:B7, D5:D7))","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:524..8206217447685413074"},null,{"$f":"_xll.AC.data.size(J5, 1)","v":70}]
[null,{"$f":"config!B14","v":"ratio-levels"},null,{"$f":"_xll.AC.data.map(names!M9:M55, names!N9:N55)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:466..8809742407094261855"},null,null,{"$f":"_xll.AC.data.size(D6, 1)","v":39},null,null,null,null,{"$f":"_xll.AC.data.size(J5, 2)","v":14}]
[null,{"$f":"config!B16","v":"ratio-names"},null,{"$f":"_xll.AC.data.list_x(B12:B18, 0, 1)","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:477..8046283278341980256"},null,null,{"$f":"_xll.AC.data.size(D7, 1)","v":7}]
[]
[null,null,null,null,null,null,"Year-specific ratios",null,null,null,null,"Period-specific average ratios"]
[]
[null,"Ratios list","#",{"$f":"_xll.AC.data._get(J5, \"\", 0)","v":"Account Name"},"level","format","31-Mar-13","31-Mar-14","31-Mar-15","31-Mar-16","31-Mar-17","FY2013 - \n2015","FY2013 - \n2016","FY2013 - \n2017","FY2014 - \n2015","FY2014 - \n2016","FY2014 - \n2017"]
[null,{"$f":"cra!C34","v":"REV_BLN"},1,"Revenue (in billions)",0,"x.x",2.8626999999999998,3.1316000000000002,3.4253999999999998,3.3570000000000002,3.0076999999999998,3.1398999999999999,3.194175,3.1568800000000001,3.2785000000000002,3.3046666666666664,3.2304249999999999]
[null,{"$f":"cra!C35","v":"EBITA_BLN"},{"$f":"IF(D13=\"\", \"\", C12+1)","v":2},"     total revenue",1,1,2862700,3131600,3425400,3357000,3007700,3139900,3194175,3156880,3278500,3304666.6666666665,3230425]
[null,{"$f":"cra!C36","v":"OM"},{"$f":"IF(D14=\"\", \"\", C13+1)","v":3},"          revenues",2,0,2862700,3131600,3425400,3357000,3007700,3139900,3194175,3156880,3278500,3304666.6666666665,3230425]
[null,{"$f":"cra!C37","v":"ROC"},4,"     constant",1,1,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000]
[null,{"$f":"cra!C38","v":"DEBT/EBITDA"},5,"EBITA (in billions)",0,"x.x",0.1726,0.1462,0.1237,0.1241,0.107,0.14749999999999999,0.14165,0.13472000000000001,0.13494999999999999,0.13133333333333333,0.12525]
[null,{"$f":"cra!C39","v":"EBITA/INT_EXP"},6,"     earnings before interest, tax and amortization (EBITA)",1,1,172600,146200,123700,124100,107000,147500,141650,134720,134950,131333.33333333334,125250]
[null,{"$f":"cra!C40","v":"RCF/DEBT"},7,"          earnings before interest and tax (EBIT)",2,1,160500,133200,86900,92700,20800,126866.66666666667,118325,98820,110050,104266.66666666667,83400]
[null,null,8,"               earnings before interest, tax and D&A (EBITDA)",3,1,177600,149000,126800,128000,111400,151133.33333333334,145350,138560,137900,134600,128800]
[null,null,9,"               amortization and depreciation",3,1,-17100,-15800,-39900,-35300,-90600,-24266.666666666668,-27025,-39740,-27850,-30333.333333333332,-45400]
[null,null,10,"          amortization",2,0,-12100,-13000,-36800,-31400,-86200,-20633.333333333332,-23325,-35900,-24900,-27066.666666666668,-41850]
[null,null,11,"     constant",1,1,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000]
[null,null,12,"Operating Margin",0,"%",5.6065951723897021E-2,4.2534167837527143E-2,2.5369299935773925E-2,2.7613941018766755E-2,6.915583336104E-3,4.0404683800970308E-2,3.7043994145593152E-2,3.1303058716200809E-2,3.356718011285649E-2,3.1551341537220098E-2,2.5817036458051185E-2]
[null,null,13,"     earnings before interest and tax (EBIT)",1,1,160500,133200,86900,92700,20800,126866.66666666667,118325,98820,110050,104266.66666666667,83400]
[null,null,14,"          earnings before interest, tax and D&A (EBITDA)",2,1,177600,149000,126800,128000,111400,151133.33333333334,145350,138560,137900,134600,128800]
[null,null,15,"               gross profits",3,1,530300,535700,527600,480100,523500,531200,518425,519440,531650,514466.66666666669,516725]
[null,null,16,"               total operating expense",3,1,-352700,-386700,-400800,-352100,-412100,-380066.66666666669,-373075,-380880,-393750,-379866.66666666669,-387925]
[null,null,17,"          amortization and depreciation",2,1,-17100,-15800,-39900,-35300,-90600,-24266.666666666668,-27025,-39740,-27850,-30333.333333333332,-45400]
[null,null,18,"               amortization",3,0,-12100,-13000,-36800,-31400,-86200,-20633.333333333332,-23325,-35900,-24900,-27066.666666666668,-41850]
[null,null,19,"               depreciation",3,0,-5000,-2800,-3100,-3900,-4400,-3633.3333333333335,-3700,-3840,-2950,-3266.6666666666665,-3550]
[null,null,20,"     total revenue",1,1,2862700,3131600,3425400,3357000,3007700,3139900,3194175,3156880,3278500,3304666.6666666665,3230425]
[null,null,21,"          revenues",2,0,2862700,3131600,3425400,3357000,3007700,3139900,3194175,3156880,3278500,3304666.6666666665,3230425]
[null,null,22,"Return on Capital",0,"%",1.777722027094832,-0.88554216867469882,14.618233618233619,0.22400558269364967,0.79511995637949839,-1.0224948875255624,7.4296942158909487E-2,0.41591834097809938,4.4758620689655171,-0.47772357723577236,0.21466706213851403]
[null,null,23,"     net income",1,1,354300,58800,-513100,160500,583300,-33333.333333333336,15125,128760,-227150,-97933.333333333328,72375]
[null,null,24,"          earnings before tax (EBT)",2,1,101000,77900,22100,26700,-53100,67000,56925,34920,50000,42233.333333333336,18400]
[null,null,25,"               earnings before interest and tax (EBIT)",3,1,160500,133200,86900,92700,20800,126866.66666666667,118325,98820,110050,104266.66666666667,83400]
[null,null,26,"               total interest expense",3,1,-59500,-55300,-64800,-66000,-73900,-59866.666666666664,-61400,-63900,-60050,-62033.333333333336,-65000]
[null,null,27,"          total income tax",2,1,-32900,200,25400,-45800,-86300,-2433.3333333333335,-13275,-27880,12800,-6733.333333333333,-26625]
[null,null,28,"               current income tax",3,0,-32900,200,25400,-45800,-86300,-2433.3333333333335,-13275,-27880,12800,-6733.333333333333,-26625]
[null,null,29,"          non-operating expenses",2,0,286200,-19300,-560600,179600,722700,-97900,-28525,121720,-289950,-133433.33333333334,80600]
[null,null,30,"     total book capitalization",1,1,199300,-66400,-35100,716500,733600,32600,203575,309580,-50750,205000,337150]
[null,null,31,"          total debt",2,1,374800,508700,533100,887800,942200,472200,576100,649320,520900,643200,717950]
[null,null,32,"               total short-tem debt",3,1,0,0,0,47000,159800,0,11750,41360,0,15666.666666666666,51700]
[null,null,33,"               total long-tem debt",3,1,374800,508700,533100,840800,782400,472200,564350,607960,520900,627533.33333333337,666250]
[null,null,34,"          total equity",2,1,-175500,-575100,-568200,-171300,-208600,-439600,-372525,-339740,-571650,-438200,-380800]
[null,null,35,"               retained earnings",3,0,-1121000,-1432100,-1440900,-1170800,-1279300,-1331333.3333333333,-1291200,-1288820,-1436500,-1347933.3333333333,-1330775]
[null,null,36,"               other owners equity",3,0,945500,857000,872700,993700,1071400,891733.33333333337,917225,948060,864850,907800,948700]
[null,null,37,"               minority interest",3,0,0,0,0,5800,-700,0,1450,1020,0,1933.3333333333333,1275]
[null,null,38,"Debt to EBITDA",0,"x.x",2.1103603603603602,3.4140939597315438,4.2042586750788642,6.9359374999999996,8.4578096947935375,3.1243934715483017,3.9635362917096661,4.6862009237875286,3.777374909354605,4.7786032689450222,5.5741459627329188]
[null,null,39,"     total debt",1,1,374800,508700,533100,887800,942200,472200,576100,649320,520900,643200,717950]
[null,null,40,"          total short-tem debt",2,1,0,0,0,47000,159800,0,11750,41360,0,15666.666666666666,51700]
[null,null,41,"               current portion of long-term debt",3,0,0,0,0,47000,159800,0,11750,41360,0,15666.666666666666,51700]
[null,null,42,"          total long-tem debt",2,1,374800,508700,533100,840800,782400,472200,564350,607960,520900,627533.33333333337,666250]
[null,null,43,"               third-party debt - long-term",3,0,374800,508700,533100,840800,782400,472200,564350,607960,520900,627533.33333333337,666250]
[null,null,44,"     earnings before interest, tax and D&A (EBITDA)",1,1,177600,149000,126800,128000,111400,151133.33333333334,145350,138560,137900,134600,128800]
[null,null,45,"          gross profits",2,1,530300,535700,527600,480100,523500,531200,518425,519440,531650,514466.66666666669,516725]
[null,null,46,"               total revenue",3,1,2862700,3131600,3425400,3357000,3007700,3139900,3194175,3156880,3278500,3304666.6666666665,3230425]
[null,null,47,"               total COGS",3,1,-2332400,-2595900,-2897800,-2876900,-2484200,-2608700,-2675750,-2637440,-2746850,-2790200,-2713700]
[null,null,48,"          total operating expense",2,1,-352700,-386700,-400800,-352100,-412100,-380066.66666666669,-373075,-380880,-393750,-379866.66666666669,-387925]
[null,null,49,"               selling general and administrative costs",3,0,-310000,-334400,-346200,-294200,-381300,-330200,-321200,-333220,-340300,-324933.33333333331,-339025]
[null,null,50,"               other expense (income)",3,0,-42700,-52300,-54600,-57900,-30800,-49866.666666666664,-51875,-47660,-53450,-54933.333333333336,-48900]
[null,null,51,"EBITA to Interest Expense",0,"x.x",2.9008403361344537,2.6437613019891502,1.9089506172839505,1.8803030303030304,1.4479025710419486,2.4638084632516706,2.30700325732899,2.1082942097026605,2.2472939217318899,2.1171413218699624,1.926923076923077]
[null,null,52,"     earnings before interest, tax and amortization (EBITA)",1,1,172600,146200,123700,124100,107000,147500,141650,134720,134950,131333.33333333334,125250]
[null,null,53,"          earnings before interest and tax (EBIT)",2,1,160500,133200,86900,92700,20800,126866.66666666667,118325,98820,110050,104266.66666666667,83400]
[null,null,54,"               earnings before interest, tax and D&A (EBITDA)",3,1,177600,149000,126800,128000,111400,151133.33333333334,145350,138560,137900,134600,128800]
[null,null,55,"               amortization and depreciation",3,1,-17100,-15800,-39900,-35300,-90600,-24266.666666666668,-27025,-39740,-27850,-30333.333333333332,-45400]
[null,null,56,"          amortization",2,0,-12100,-13000,-36800,-31400,-86200,-20633.333333333332,-23325,-35900,-24900,-27066.666666666668,-41850]
[null,null,57,"     total interest expense",1,1,-59500,-55300,-64800,-66000,-73900,-59866.666666666664,-61400,-63900,-60050,-62033.333333333336,-65000]
[null,null,58,"          interest expense",2,0,-59500,-55300,-64800,-66000,-73900,-59866.666666666664,-61400,-63900,-60050,-62033.333333333336,-65000]
[null,null,59,"RCF to Debt",0,"%",1.1163420490928495,0.23252801258108904,-0.79161132995685612,0.27927461139896376,0.77720335385268524,8.0957221516306646E-2,0.15736156917201874,0.33724665804225962,-0.2915348435400269,-2.890806384742952E-2,0.23556654363117208]
[null,null,60,"     retained cash flows",1,1,418405,118287,-422008,247940,732281,38228,90656,218981,-151860.5,-18593.666666666668,169125]
[null,null,61,"          funds from operations",2,1,418405,118287,-422008,247940,732281,38228,90656,218981,-151860.5,-18593.666666666668,169125]
[null,null,62,"               net income",3,1,354300,58800,-513100,160500,583300,-33333.333333333336,15125,128760,-227150,-97933.333333333328,72375]
[null,null,63,"               amortization and depreciation",3,1,-17100,-15800,-39900,-35300,-90600,-24266.666666666668,-27025,-39740,-27850,-30333.333333333332,-45400]
[null,null,64,"               tax-adjusted interest expense",3,1,-47005,-43687,-51192,-52140,-58381,-47294.666666666664,-48506,-50481,-47439.5,-49006.333333333336,-51350]
[null,null,65,"     total debt",1,1,374800,508700,533100,887800,942200,472200,576100,649320,520900,643200,717950]
[null,null,66,"          total short-tem debt",2,1,0,0,0,47000,159800,0,11750,41360,0,15666.666666666666,51700]
[null,null,{"$f":"IF(D78=\"\", \"\", C77+1)","v":67},"               current portion of long-term debt",3,0,0,0,0,47000,159800,0,11750,41360,0,15666.666666666666,51700]
[null,null,68,"          total long-tem debt",2,1,374800,508700,533100,840800,782400,472200,564350,607960,520900,627533.33333333337,666250]
[null,null,69,"               third-party debt - long-term",3,0,374800,508700,533100,840800,782400,472200,564350,607960,520900,627533.33333333337,666250]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"metrics<","index":5,"n_rows":104,"n_cols":17,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: FINANCIAL STATEMENT METRICS"]
[]
[null,"Parameter key",null,"Parameter object",null,null,"size","Metric output object",null,null,null,"size"]
[null,{"$f":"config!B13","v":"metric-levels"},null,{"$f":"_xll.AC.data.map(names!G9:G80, names!H9:H80)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:486..1698388395872754580"},null,null,{"$f":"_xll.AC.data.size(D5, 1)","v":61},"metrics output",null,{"$f":"_xll.AC.finance.fs.get(calc!K8, config!B7, _xll.AC.data.map(B5:B6, D5:D6))","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:522..8432161268763603467"},null,{"$f":"_xll.AC.data.size(J5, 1)","v":22}]
[null,{"$f":"config!B15","v":"metric-names"},null,{"$f":"_xll.AC.data.list_x(B11:B15, 0, 1)","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:487..3734492626137006885"},null,null,{"$f":"_xll.AC.data.size(D6, 1)","v":5},null,null,null,null,{"$f":"_xll.AC.data.size(J5, 2)","v":14}]
[]
[null,null,null,null,null,"Year-specific metrics",null,null,null,null,null,"Period-specific average metrics"]
[]
[null,"Metrics list","#",{"$f":"_xll.AC.data._get(J5, \"\", 0)","v":"Account Name"},"level","is metric","31-Mar-13","31-Mar-14","31-Mar-15","31-Mar-16","31-Mar-17","FY2013 - \n2015","FY2013 - \n2016","FY2013 - \n2017","FY2014 - \n2015","FY2014 - \n2016","FY2014 - \n2017"]
[null,{"$f":"names!G36","v":"EBITDA"},1,"earnings before interest, tax and D&A (EBITDA)",0,1,177600,149000,126800,128000,111400,151133.33333333334,145350,138560,137900,134600,128800]
[null,{"$f":"names!G13","v":"TOT_LIAB"},{"$f":"IF(D12=\"\", \"\", C11+1)","v":2},"     gross profits",1,1,530300,535700,527600,480100,523500,531200,518425,519440,531650,514466.66666666669,516725]
[null,{"$f":"names!G19","v":"TOT_DEBT"},{"$f":"IF(D13=\"\", \"\", C12+1)","v":3},"     total operating expense",1,1,-352700,-386700,-400800,-352100,-412100,-380066.66666666669,-373075,-380880,-393750,-379866.66666666669,-387925]
[null,{"$f":"names!G30","v":"OPEX"},4,"total liabilities",0,1,918100,1174100,987300,1471400,1355000,1026500,1137725,1181180,1080700,1210933.3333333333,1246950]
[null,{"$f":"names!G34","v":"EBIT"},5,"     total current liabilities",1,1,405400,437800,448300,525800,505600,430500,454325,464580,443050,470633.33333333331,479375]
[null,null,6,"     total long-term liabilities",1,1,512700,736300,539000,945600,849400,596000,683400,716600,637650,740300,767575]
[null,null,7,"total debt",0,1,374800,508700,533100,887800,942200,472200,576100,649320,520900,643200,717950]
[null,null,8,"     total short-tem debt",1,1,0,0,0,47000,159800,0,11750,41360,0,15666.666666666666,51700]
[null,null,9,"          current portion of long-term debt",2,0,0,0,0,47000,159800,0,11750,41360,0,15666.666666666666,51700]
[null,null,10,"     total long-tem debt",1,1,374800,508700,533100,840800,782400,472200,564350,607960,520900,627533.33333333337,666250]
[null,null,11,"          third-party debt - long-term",2,0,374800,508700,533100,840800,782400,472200,564350,607960,520900,627533.33333333337,666250]
[null,null,12,"total operating expense",0,1,-352700,-386700,-400800,-352100,-412100,-380066.66666666669,-373075,-380880,-393750,-379866.66666666669,-387925]
[null,null,13,"     selling general and administrative costs",1,0,-310000,-334400,-346200,-294200,-381300,-330200,-321200,-333220,-340300,-324933.33333333331,-339025]
[null,null,14,"     other expense (income)",1,0,-42700,-52300,-54600,-57900,-30800,-49866.666666666664,-51875,-47660,-53450,-54933.333333333336,-48900]
[null,null,15,"earnings before interest and tax (EBIT)",0,1,160500,133200,86900,92700,20800,126866.66666666667,118325,98820,110050,104266.66666666667,83400]
[null,null,16,"     earnings before interest, tax and D&A (EBITDA)",1,1,177600,149000,126800,128000,111400,151133.33333333334,145350,138560,137900,134600,128800]
[null,null,17,"          gross profits",2,1,530300,535700,527600,480100,523500,531200,518425,519440,531650,514466.66666666669,516725]
[null,null,18,"          total operating expense",2,1,-352700,-386700,-400800,-352100,-412100,-380066.66666666669,-373075,-380880,-393750,-379866.66666666669,-387925]
[null,null,19,"     amortization and depreciation",1,1,-17100,-15800,-39900,-35300,-90600,-24266.666666666668,-27025,-39740,-27850,-30333.333333333332,-45400]
[null,null,20,"          amortization",2,0,-12100,-13000,-36800,-31400,-86200,-20633.333333333332,-23325,-35900,-24900,-27066.666666666668,-41850]
[null,null,21,"          depreciation",2,0,-5000,-2800,-3100,-3900,-4400,-3633.3333333333335,-3700,-3840,-2950,-3266.6666666666665,-3550]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[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":"IF(D77=\"\", \"\", C76+1)","v":""}]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"accounts<","index":6,"n_rows":118,"n_cols":21,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: FINANCIAL STATEMENTS"]
[]
[null,null,"account-levels",{"$f":"_xll.AC.data.map(names!C9:C76, names!D9:D76)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:487..8718910813228316133"},null,null,null,{"$f":"_xll.AC.data.size(D4, 1)","v":54},null,null,null,null,null,{"$f":"C4","v":"account-levels"},{"$f":"D4","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:487..8718910813228316133"},null,null,null,{"$f":"_xll.AC.data.size(O4, 1)","v":54}]
[null,null,"P&L output",{"$f":"_xll.AC.finance.fs.get(calc!G7, config!$B$6, _xll.AC.data.map(C4, D4))","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:530..7733017757578725247"},null,null,null,{"$f":"_xll.AC.data.size(D5, 1)","v":24},{"$f":"_xll.AC.data.size(D5, 2)","v":8},null,null,null,null,"Balance sheet output",{"$f":"_xll.AC.finance.fs.get(calc!G6, config!$B$6, _xll.AC.data.map(N4, O4))","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:488..6730781668202339257"},null,null,null,{"$f":"_xll.AC.data.size(O5, 1)","v":54},{"$f":"_xll.AC.data.size(O5, 2)","v":8}]
[]
[null,"#",{"$f":"_xll.AC.data._get(D5, \"\", 0)","v":"JE: Income statement (C$'000)"},"not balanced","level","31-Mar-13","31-Mar-14","31-Mar-15","31-Mar-16","31-Mar-17",null,null,"#",{"$f":"_xll.AC.data._get(O5, \"\", 0)","v":"JE: Balance Sheet (C$'000)"},"not balanced","level","31-Mar-13","31-Mar-14","31-Mar-15","31-Mar-16","31-Mar-17"]
[null,1,"revenues","",0,2862700,3131600,3425400,3357000,3007700,null,null,1,"cash and marketable securities","",0,65600,104100,79700,122900,83400]
[null,{"$f":"IF(C9=\"\", \"\", B8+1)","v":2},"     Total Revenue","",1,2862700,3131600,3425400,3357000,3007700,null,null,{"$f":"IF(N9=\"\", \"\", M8+1)","v":2},"     Cash, Cash Equivalents and Short-Term Investments",1,1,62900,98300,65900,112000,70300]
[null,{"$f":"IF(C10=\"\", \"\", B9+1)","v":3},"cost of goods sold","",0,-2332400,-2595900,-2897800,-2876900,-2484200,null,null,{"$f":"IF(N10=\"\", \"\", M9+1)","v":3},"     Restricted Cash","",1,2700,5800,13800,10900,13100]
[null,4,"     Cost of Revenue","",1,-2332400,-2595900,-2897800,-2876900,-2484200,null,null,4,"accounts receivable","",0,444600,472300,581600,593100,480600]
[null,5,"selling general and administrative costs","",0,-310000,-334400,-346200,-294200,-381300,null,null,5,"     Total Receivables",1,1,444600,472300,581600,593100,480600]
[null,6,"     Wages and Salaries","",1,-4600,-4100,-6300,-1500,-11900,null,null,6,"inventory","",0,11700,7200,4900,10500,22000]
[null,7,"     Selling, General and Administrative Expenses",1,1,-305400,-330300,-339900,-292700,-369400,null,null,7,"     Total Inventory","",1,11700,7200,4900,10500,22000]
[null,8,"other expense (income)","",0,-42700,-52300,-54600,-57900,-30800,null,null,8,"other current assets (part of WC)","",0,92600,92100,18000,19600,91800]
[null,9,"     Amortization of Securities","",1,0,0,0,-14200,0,null,null,9,"     Prepaid Assets","",1,83800,88300,18000,19600,15600]
[null,10,"     Provision for Doubtful Accounts","",1,-42700,-52300,-54600,-43700,-30800,null,null,10,"     Other Current Assets","",1,8800,3800,0,0,76200]
[null,11,"     Other Taxes","",1,0,0,0,0,0,null,null,11,"net fixed assets","",0,16300,19300,18800,159800,253800]
[null,12,"     Other Operating Expense","",1,0,0,0,0,0,null,null,12,"     Property/Plant/Equipment - Net","",1,16300,19300,18800,159800,253800]
[null,13,"interest expense","",0,-59500,-55300,-64800,-66000,-73900,null,null,13,"goodwill","",0,217600,216000,218900,238700,252200]
[null,14,"     Interest Expense - Non-Operating","",1,-59500,-55300,-64800,-66000,-73900,null,null,14,"     Goodwill","",1,217600,216000,218900,238700,252200]
[null,15,"I/C interest expense","",0,0,0,0,0,0,null,null,15,"intangible assets (other than goodwill)","",0,51800,50300,55700,127400,187900]
[null,16,"amortization","",0,-12100,-13000,-36800,-31400,-86200,null,null,16,"     Other Intangible Assets","",1,51800,50300,55700,127400,187900]
[null,17,"     Amortization","",1,-12100,-13000,-36800,-31400,-86200,null,null,17,"investments - long term","",0,14000,8000,8400,37000,39700]
[null,18,"depreciation","",0,-5000,-2800,-3100,-3900,-4400,null,null,18,"     Long-Term Investments","",1,11700,5400,8400,37000,39700]
[null,19,"     Depreciation","",1,-5000,-2800,-3100,-3900,-4400,null,null,19,"     Financial Assets","",1,2300,2600,0,0,0]
[null,20,"non-operating expenses","",0,286200,-19300,-560600,179600,722700,null,null,20,"due from related companies - long term","",0,0,0,0,0,0]
[null,21,"     Other Income (Expense)","",1,286200,-19300,-560600,179600,722700,null,null,21,"deferred tax asset - long-term","",0,17300,31500,21000,1500,24500]
[null,22,"current income tax","",0,-32900,200,25400,-45800,-86300,null,null,22,"     Non-Current Deferred Assets","",1,17300,31500,21000,1500,24500]
[null,23,"     Total Income Tax","",1,-32900,200,25400,-45800,-86300,null,null,23,"other long-term assets (part of CFO)","",0,0,0,16100.000000000002,174600,68400]
[null,"",null,null,null,null,null,null,null,null,null,null,24,"     Deferred Charges","",1,0,0,0,0,57500]
[null,"",null,null,null,null,null,null,null,null,null,null,25,"     Other Long-Term Assets","",1,0,0,16100.000000000002,174600,10900]
[null,"",null,null,null,null,null,null,null,null,null,null,26,"other long-term assets (part of OCI)","",0,127000,329500,304400,69700,233400]
[null,"",null,null,null,null,null,null,null,null,null,null,27,"     Other Current liabilities","",1,127000,329500,304400,69700,233400]
[null,"",null,null,null,null,null,null,null,null,null,null,28,"accounts payable","",0,386000,409600,435400,475900,330000]
[null,"",null,null,null,null,null,null,null,null,null,null,29,"     Payables",1,1,386000,409600,435400,475900,330000]
[null,"",null,null,null,null,null,null,null,null,null,null,30,"current portion of long-term debt","",0,0,0,0,47000,159800]
[null,"",null,null,null,null,null,null,null,null,null,null,31,"     Current Debt and Capital Lease Obligation","",1,0,0,0,47000,159800]
[null,"",null,null,null,null,null,null,null,null,null,null,32,"other current liabilities (part of WC)","",0,19400,28200,12900,2900,15800]
[null,"",null,null,null,null,null,null,null,null,null,null,33,"     Current Provisions","",1,6200,10500,11700,2800,3000]
[null,"",null,null,null,null,null,null,null,null,null,null,34,"     Current Deferred Liabilities","",1,13200,17700,1200,100,12800]
[null,"",null,null,null,null,null,null,null,null,null,null,35,"third-party debt - long-term","",0,374800,508700,533100,840800,782400]
[null,"",null,null,null,null,null,null,null,null,null,null,36,"     Long-Term Debt and Capital Lease Obligation","",1,374800,508700,533100,840800,782400]
[null,"",null,null,null,null,null,null,null,null,null,null,37,"I/C debt - long-term","",0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,null,38,"deferred tax liability - long-term","",0,1300,1100,1000,29800,30800]
[null,"",null,null,null,null,null,null,null,null,null,null,39,"     Deferred Taxes - Non-Current Liabilities","",1,1300,1100,1000,29800,30800]
[null,"",null,null,null,null,null,null,null,null,null,null,40,"other long-term liabilities (part of CFO)","",0,2100,5500,4900,33900,35500]
[null,"",null,null,null,null,null,null,null,null,null,null,41,"     Long-Term Provisions","",1,0,3400,3400,3400,3700]
[null,"",null,null,null,null,null,null,null,null,null,null,42,"     Non-Current Deferred Liabilities","",1,2100,2100,1500,30500,31800]
[null,"",null,null,null,null,null,null,null,null,null,null,43,"other long-term liabilities (part of OCI)","",0,134500,221000,0,41100,700]
[null,"",null,null,null,null,null,null,null,null,null,null,44,"     Derivative Product Liabilities","",1,134500,221000,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,null,45,"     Other Long-Term Liabilities","",1,0,0,0,41100,700]
[null,"",null,null,null,null,null,null,null,null,null,null,46,"other comprehensive income","",0,52900,53700,44400,65099.999999999993,46400]
[null,"",null,null,null,null,null,null,null,null,null,null,47,"     Gains (Losses) Not Affecting Retained Earnings","",1,52900,53700,44400,65099.999999999993,46400]
[null,"",null,null,null,null,null,null,null,null,null,null,48,"retained earnings","",0,-1121000,-1432100,-1440900,-1170800,-1279300]
[null,"",null,null,null,null,null,null,null,null,null,null,49,"     Retained Earnings (Accumulated Deficit)","",1,-1121000,-1432100,-1440900,-1170800,-1279300]
[null,"",null,null,null,null,null,null,null,null,null,null,50,"other owners equity","",0,945500,857000,872700,993700,1071400]
[null,"",null,null,null,null,null,null,null,null,null,null,51,"     Additional Paid-In Capital","",1,945500,857000,872700,993700,1071400]
[null,"",null,null,null,null,null,null,null,null,null,null,52,"minority interest","",0,0,0,0,5800,-700]
[null,"",null,null,null,null,null,null,null,null,null,null,53,"     Minority Interest","",1,0,0,0,5800,-700]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,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":"IF(C74=\"\", \"\", B73+1)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N74=\"\", \"\", M73+1)","v":""}]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"config","index":7,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[17,7,19,7]]}
[]
[null,"TAB: CONFIGURATION FILE",null,null,"Calculations enabled:",null,true]
[null,null,null,null,"Test connection",null,{"$f":"_xll.AC.test.connection()","v":"host: home-pc; user: Konstantin Rybakov; key: null"}]
[null,"Financial statement output keys"]
[null,"Output key","Description",null,"Adjustment type","Description"]
[null,"accounts","Financial statement accounts",null,"GR","Set the account growth rate"]
[null,"metrics","Financial statement metrics",null,"REPLACE","Replace the account"]
[null,"ratios","Financial statement ratios",null,"ADD","Add to current account value. Blank vaues are assumed by default to be ADD operations"]
[null,"balance-sheet","Balance sheet statement"]
[null,"profit-and-loss","Profit and loss statement",null,"Configuration parameters for output arrays"]
[null,null,null,null,"Cell address","Row count","Col count","Comment"]
[null,"account-levels","Returned levels of financial statement accounts",null,{"$f":"addressFla('accounts<'!C7)","v":"'accounts<'!$C$7"},{"$f":"'accounts<'!H5","v":24},{"$f":"'accounts<'!I5","v":8},"Standardized financial statement (Income statement)"]
[null,"metric-levels","Returned levels of financial statement metrics",null,{"$f":"addressFla('accounts<'!N7)","v":"'accounts<'!$N$7"},{"$f":"'accounts<'!S5","v":54},{"$f":"'accounts<'!T5","v":8},"Standardized financial statement (Balance sheet)"]
[null,"ratio-levels","Returned levels of financial statement ratios",null,{"$f":"addressFla('metrics<'!D10)","v":"'metrics<'!$D$10"},{"$f":"'metrics<'!L5","v":22},{"$f":"'metrics<'!L6","v":14},"Metrics estimated based on standard financial statements"]
[null,"metric-names","Range of returned metrics names",null,{"$f":"addressFla('ratios<'!D11)","v":"'ratios<'!$D$11"},{"$f":"'ratios<'!L5","v":70},{"$f":"'ratios<'!L6","v":14},"Ratios estimated based on standard financial statements"]
[null,"ratio-names","Range of returned metrics names",null,{"$f":"addressFla(validate!E6)","v":"'validate'!$E$6"},{"$f":"validate!H4","v":-1},{"$f":"validate!H5","v":-1},"Valiadation of the original financial statement metrics"]
[null,null,null,null,{"$f":"addressFla(cra!C9)","v":"'cra'!$C$9"},{"$f":"MIN(calc!L7, MATCH(cra!B14, cra!B9:B14, 0)-3)","v":2},3,"Set qualitative factors"]
[null,"Keys of ajustments based on Moody's financial statement adjustment methodology",null,null,{"$f":"addressFla(cra!C21)","v":"'cra'!$C$21"},{"$f":"MIN(calc!L6, MATCH(cra!B28, cra!B21:B28, 0)-1)","v":7},3,"Set quantitative factors"]
[null,"Output key","Description",null,{"$f":"addressFla(cra!C34)","v":"'cra'!$C$34"},{"$f":"F18","v":7},{"$f":"G18","v":3}]
[null,"moody's-adjustment","Indicator which specifies whether to perform Moody's adjustments",null,{"$f":"addressFla(cra!C45)","v":"'cra'!$C$45"},{"$f":"F19","v":7},{"$f":"G19","v":3}]
[null,"operating-lease factor","Multiplier in Moody's adjsutment methodology that specifies additional level of debt related to operating leases",null,{"$f":"addressFla(cra!N9)","v":"'cra'!$N$9"},3,4,"Table with final aggregated consensus ratings"]
[null,null,null,null,{"$f":"addressFla(cra!F21)","v":"'cra'!$F$21"},{"$f":"F20","v":7},6,"Grid of quantitative factors ratings"]
[null,"CRA modelling output keys",null,null,{"$f":"addressFla(cra!M21)","v":"'cra'!$M$21"},{"$f":"F22","v":7},{"$f":"G22","v":6},"Grid of quantitative factors scores"]
[null,"Output key","Description",null,{"$f":"addressFla(cra!F28)","v":"'cra'!$F$28"},2,{"$f":"G23","v":6}]
[null,"model-name","Name of the Moody's CRA model",null,{"$f":"addressFla(cra!M28)","v":"'cra'!$M$28"},2,{"$f":"G24","v":6}]
[null,"factors-qualitative","List of qualitative factors with weights and adjusted weights",null,{"$f":"addressFla(cra!F34)","v":"'cra'!$F$34"},{"$f":"F23","v":7},{"$f":"G23","v":6},"Ratios and respective grid ranges, which the ratios matched to"]
[null,"factors-quantitative","List of quantitative factors with weights and adjusted weights",null,{"$f":"addressFla(cra!M33)","v":"'cra'!$M$33"},{"$f":"F20+1","v":8},10,"Moody's model quantitative grid"]
[null,"table-final","Table with consensus  aggregate credit rating results",null,{"$f":"addressFla(cra!F45)","v":"'cra'!$F$45"},{"$f":"F23","v":7},{"$f":"G22","v":6},"Period-specific ratios estimated for quantitative factors"]
[null,"grid-ratings","Estimated factor-specific ratings",null,{"$f":"addressFla(cra!M45)","v":"'cra'!$M$45"},{"$f":"F28","v":7},{"$f":"COUNT(cra!N16:V16)","v":5},"Year-specific ratios estimated for quantitative factors"]
[null,"grid-scores","Estimated factor-specific scores",null,{"$f":"addressFla(dca!C9)","v":"'dca'!$C$9"},{"$f":"dca!D7","v":6},{"$f":"dca!E7-G28","v":8},"Standard debt capacity metrics"]
[null,"grid-ratings-final","Estimated aggregate quantitative and final ratings",null,{"$f":"addressFla(dca!C22)","v":"'dca'!$C$22"},{"$f":"dca!D20","v":5},{"$f":"dca!E20-G28","v":8},"Standard debt capacity ratios"]
[null,"grid-scores-final","Estimated aggregate quantitative and final scores",null,{"$f":"addressFla(FS!D11)","v":"'FS'!$D$11"},{"$f":"FS!L5","v":32},{"$f":"FS!L6-G28","v":8}]
[null,"grid-thresholds","Moody's methodology grid threshold values",null,{"$f":"addressFla(FS!O11)","v":"'FS'!$O$11"},{"$f":"FS!V5","v":20},{"$f":"G32","v":8}]
[null,"ratio-matched-ranges","Ratios and respective grid ranges, which the ratios matched to",null,{"$f":"addressFla(test!M7)","v":"'test'!$M$7"},{"$f":"test!R5","v":-1},{"$f":"test!S5","v":-1}]
[null,"ratios-year-specific","Year-specific ratios",null,{"$f":"addressFla(test!C7)","v":"'test'!$C$7"},{"$f":"test!H5","v":-1},{"$f":"test!I5","v":-1},"Test output"]
[null,"ratios-period-specific","Period-specific ratios",null,{"$f":"addressFla(count!C8)","v":"'count'!$C$8"},{"$f":"count!B6","v":0},2,"Calculation of accounts in original statements  with duplicate names"]
[null,"calculator-metrics","Metrics calculator"]

{"sheet":"model","index":8,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[9,10,9,12],[19,10,19,12]]}
[]
[null,"TAB: PROJECTION  AND ADJUSTMENTS OF CONSOLIDATED FINANCIAL STATEMENTS "]
[]
[null,"#","Parameters",null,"Value",null,"Parameter",null,null,null,"Moody's adjustment parameters","Value"]
[null,1,"Effective fixed interest rate",null,0.05,null,"Covered Transaction issue date",null,"2018-03-01",null,{"$f":"config!B20","v":"moody's-adjustment"},1]
[null,2,"Covered Transaction size",null,50000,null,"Fiscal year end",null,"2018-12-31",null,{"$f":"config!B21","v":"operating-lease factor"},7]
[null,3,"Target acquisition price",null,140000,null,"Corporate income tax",null,0.21,null,"Parameters's object",{"$f":"_xll.AC.data.map(K5:K6, L5:L6)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:475..164265036044193492"},null," "]
[]
[null,"#","Account name","Adjustment type","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","Name","Comment"]
[null,"Adjustment of exisiting financial statements",null,null,null,null,null,null,null,null,"Note: Set adjustments to existing statements (ADD, REPLACE, or blank types); set non-numeric values in blank cells (for REPLACE adjustment)"]
[null,1,{"$f":"names!C58","v":"DEPRECIATION"},{"$f":"config!E8","v":"ADD"},"-","-","-","-","-",null,"Remove deperciation from the COGS account"]
[null,{"$f":"IF(C12=\"\", \"\", B11+1)","v":2},{"$f":"names!C57","v":"AMORTIZATION"},{"$f":"D11","v":"ADD"},"-","-","-","-","-",null,"Offset COGS by adjusted depreciation"]
[null,{"$f":"IF(C13=\"\", \"\", B12+1)","v":3},{"$f":"names!C68","v":"TAX_INC_CURR"},{"$f":"config!E7","v":"REPLACE"},"-","-","-","-","-",null,"I/C accounts receivable"]
[null,4,{"$f":"names!C66","v":"NON_OPEX"}]
[null,5,{"$f":"names!C45","v":"RE"}]
[null,6,{"$f":"names!C60","v":"INT_EXP"}]
[null,7,{"$f":"names!C61","v":"INT_EXP_IC"},{"$f":"D13","v":"REPLACE"},"-","-","-","-","-",null,"I/C accounts payable"]
[null,8,{"$f":"names!C38","v":"DEBT_IC_LT"},{"$f":"D17","v":"REPLACE"},"-","-","-","-","-",null,"I/C investments (adjusted to balance the balance sheet)"]
[null,9,{"$f":"names!C23","v":"DEBT_RECEIV_IC_LT"},{"$f":"D18","v":"REPLACE"},"-","-","-","-","-",null,"I/C debt"]
[null,"Projections of financial statements",null,null,null,null,null,null,null,null,"Note: Set projection parameters for the financial statements (ADD, GR, or blank types)"]
[null,1,{"$f":"names!C50","v":"REV"},{"$f":"config!E6","v":"GR"},"-","-","-","-","-",null,"Projected Revenues growth rates"]
[null,{"$f":"B21+1","v":2},{"$f":"names!C54","v":"COGS"},{"$f":"D21","v":"GR"},"-","-","-","-","-",null,"Projected COGS growth rates"]
[null,{"$f":"B22+1","v":3},{"$f":"names!C59","v":"SGA"},{"$f":"D22","v":"GR"},"-","-","-","-","-",null,"Projected SGA growth rates"]
[null,4,{"$f":"names!C10","v":"AR"},"GR","-","-","-","-","-",null,"Assume the same growth rates as for Revenues"]
[null,5,{"$f":"names!C12","v":"INV"},{"$f":"D24","v":"GR"},"-","-","-","-","-",null,"Assume the same growth rates as for COGS"]
[null,6,{"$f":"names!C15","v":"ASSETS_OTHER_WC_ST"},{"$f":"D21","v":"GR"},"-","-","-","-","-",null,"Assume the same growth rates as for Revenues"]
[null,{"$f":"IF(C27=\"\", \"\", B26+1)","v":7},{"$f":"names!C28","v":"AP"},{"$f":"D26","v":"GR"},"-","-","-","-","-",null,"Assume the same growth rates as for COGS"]
[null,8,{"$f":"names!C34","v":"LIAB_OTHER_WC_ST"},"GR","-","-","-","-","-",null,"Assume the same growth rates as for COGS"]
[null,9,{"$f":"names!C19","v":"GOODWILL"},{"$f":"D17","v":"REPLACE"},"-","-","-","-","-",null,"Goodwill adjustment after the target acquisition"]
[null,10,{"$f":"names!C38","v":"DEBT_IC_LT"},{"$f":"D12","v":"ADD"},"-","-","-","-","-",null,"Size of the Covered Transaction"]
[null,11,{"$f":"names!C61","v":"INT_EXP_IC"},{"$f":"D30","v":"ADD"},"-","-","-","-","-",null,"Adjustment for Covered Transaction interest expense"]
[null,12,{"$f":"names!C72","v":"DIV"},{"$f":"D31","v":"ADD"},"-","-","-","-","-",null,"Set projected dividend payments in the model"]
[null,13,{"$f":"names!C73","v":"CAPEX"},{"$f":"D32","v":"ADD"},"-","-","-","-","-",null,"Set projected capital expenditures in the model"]
[null,{"$f":"IF(C34=\"\", \"\", B31+1)","v":""}]
[null,""]
[null,null,"Summary of facts"]
[]
[null,null,"Acquisition of AIS"]
[null,1,"Celestica US acquired AIS on XXX"]
[null,{"$f":"B39+1","v":2},"Historical FY2017 consolidated balance sheet of Celestica US and the target were provided by the client"]
[null,{"$f":"B40+1","v":3},"Both historical FY2017 and projected FY2018-2020 consolidated income statements of Celestica US and the target were provided by the client"]
[]
[null,null,"Description of the Covered Transaction"]
[null,{"$f":"B41+1","v":4},"The acquistion price was US$140 mln"]
[null,5,"The acquisition was financed through the issue of debt and equity (determined in this CRA and DCA analysis)"]
[null,6,"The planned date of the AIS acquisition financing is XXX"]

{"sheet":"manual","index":9,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: OVERRIDE MODEL-DERIVED METRICS AND RATIOS WITH MANUAL METRICS AND RATIOS"]
[]
[]
[null,"Manual metrics that override model-derived ratios"]
[]
[null,"#","Ratio",{"$f":"cra!N16","v":"2013-03-31"},{"$f":"cra!O16","v":"2014-03-31"},{"$f":"cra!P16","v":"2015-03-31"},{"$f":"cra!Q16","v":"2016-03-31"},{"$f":"cra!R16","v":"2017-03-31"}]
[null,1,{"$f":"names!G45","v":"CFF"},50000,50000,50000,50000,50000]
[null,{"$f":"IF(C9=\"\", \"\", B8+1)","v":""}]
[null,{"$f":"IF(C10=\"\", \"\", B9+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"calc","index":10,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: FINANCIAL STATEMENT CALCULATOR"]
[]
[null,"1. Financial statements adjsutment / projection model",null,null,null,"2. Financial statements metrics  / ratios calculator",null,null,null,"3. CRA calculator",null,"# factors"]
[]
[null,"Adjustment types (exisiting FS):",{"$f":"_xll.AC.data.map(model!C11:C19, model!D11:D19)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:477..7400884301922308573"},{"$f":"_xll.AC.data.size(C6, 1)","v":9},null,"Model output: balance sheet",{"$f":"_xll.AC.finance.fs.get(C11, config!B9, )","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:854..2703290214678850336"},null," ",{"$f":"'cra grid'!G31","v":"Moody's CRA model"},{"$f":"'cra grid'!K31","v":"jeconkr.finance.FSTP.cra.ModelCRA@Thu, 15 Feb 2018 05:04:37:856..332424736160870626"},{"$f":"_xll.AC.finance.cra.size(K6, config!B27)","v":7}]
[null,"Adjustment types projected FS):",{"$f":"_xll.AC.data.map(model!C21:C33, model!D21:D33)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:479..9049991651446498208"},{"$f":"_xll.AC.data.size(C7, 1)","v":13}," ","Model output: P&L",{"$f":"_xll.AC.finance.fs.get(C11, config!B10,)","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:853..351460337489923185"},null," ","Qualitative factors overlay",{"$f":"_xll.AC.data.map(cra!C9:C10, cra!F9:F10)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:488..1573340309836553055"},{"$f":"_xll.AC.finance.cra.size(K6, config!B26)","v":2},null," "]
[null,"FS: balance sheet",{"$f":"K20","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:854..2703290214678850336"},null," ","Cash flows:",null,null,null,"Updated metrics calculator",{"$f":"_xll.AC.finance.cra.get(K11, config!B37)","v":"jeconkr.finance.IFRS9.geq.lib.calculator.account.CalculatorMetrics@Thu, 15 Feb 2018 05:04:36:488..1509452961823193125"},null,null," "]
[null,"FS: P&L",{"$f":"K21","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:853..351460337489923185"},null," ",null,null,null," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Model calculator",{"$f":"_xll.AC.finance.fs.model(C8, C9, model!E9:I9, model!C11:C19, model!K11:K19, model!E11:I19, C6, model!C21:C33, model!K21:K33, model!E21:I33, C7, model!I7)","v":"jeconkr.finance.IFRS9.geq.lib.calculator.account.CalculatorAccountingModel@Thu, 15 Feb 2018 05:04:36:486..76139110436068824"},null," ","Metrics calculator",{"$f":"_xll.AC.finance.fs.metrics(G6, G7,,,,model!I7)","v":"jeconkr.finance.IFRS9.geq.lib.calculator.account.CalculatorMetrics@Thu, 15 Feb 2018 05:04:36:488..1509452961823193125"},null," ","CRA calculator output",{"$f":"_xll.AC.finance.cra.runmodel(K6, G11, K7, cra!F16:K18)","v":"jeconkr.finance.FSTP.cra.OutputCRA@Thu, 15 Feb 2018 05:07:27:340..9010838609995714661"},null,null," "]
[null,null,null,null," "]
[]
[null,"Financial statements calculator"]
[]
[null,"Hostorical and merged projected JEUS income statements",null,null,null,"Hostorical and merged projected JEUS balance sheet",null,null,null,"Group historical financial statements"]
[]
[null,null,null,null,null,null,null,null," ","Balance Sheet, 2013-2017",{"$f":"K49","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:844..245975045255545048"},null,null," "]
[null,null,null,null,null,null,null,null," ","P&L, 2013-2017",{"$f":"K39","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:847..5774946984170704883"},null,null," "]
[null,null,null,null,null,null,null,null," ","Copy of Balance Sheet, 2013-2017",{"$f":"_xll.AC.finance.fs.copy(K18)","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:854..2703290214678850336"},null,null," "]
[null,null,null,null,null,null,null,null,null,"Copy of P&L, 2013-2017",{"$f":"_xll.AC.finance.fs.copy(K19)","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:853..351460337489923185"},null,null," "]
[]
[]
[null,"Parameter","JEUS","JE",null,null,null,null,null,null,null,null,"JE"]
[null,"Account multipier",1E-3,1000,null,null,null,null,null,null,null,null,"2017-03-31"]
[null,"Account units",1000,1000,null,null,null,null,null,null,null,null,"2016-03-31"]
[null,"Accounts currency","US$","C$",null,null,null,null,null,null,null,null,"2015-03-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-31"]
[]
[null,"Income statement","JEUS","2017-03-31",null,{"$f":"B31","v":"Income statement"},{"$f":"C31","v":"JEUS"},"2018-03-31",null,"Income statement","JE","FY2013-2017"]
[]
[null,"Parameter","Object","size",null,{"$f":"B33","v":"Parameter"},{"$f":"C33","v":"Object"},"size",null,"Parameter","Object","size"]
[null,"Levels mapping",null,null,null,{"$f":"B44","v":"Levels mapping"},null,null,null,"Levels mapping",{"$f":"_xll.AC.data.map('<JE'!T14:T52, '<JE'!U14:U52, 0)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:403..4768138763638624491"},{"$f":"_xll.AC.data.size(K34, 1)","v":33}]
[null,"Multiplier mapping",null,null," ",{"$f":"B45","v":"Multiplier mapping"},null,null,null,"Multiplier mapping",{"$f":"_xll.AC.data.map('<JE'!T14:T52, '<JE'!V14:V52, 0)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:441..7111137418728933959"},{"$f":"_xll.AC.data.size(K35, 1)","v":33}]
[null,"Standard accounts",null,null," ",{"$f":"B46","v":"Standard accounts"},null,null,null,"Standard accounts",{"$f":"_xll.AC.data.map('<JE'!T14:T52, '<JE'!W14:W52, 0)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:440..5775278568690871220"},{"$f":"_xll.AC.data.size(K36, 1)","v":33}]
[null,null,null,null," "]
[null,"P&L original",null,null," ",{"$f":"B48","v":"P&L original"},null,null," ","P&L original",{"$f":"_xll.AC.finance.fs.statement(K31, J31, $M$25:$M$29, '<JE'!$T$14:$T$52, '<JE'!$X$14:$AB$52, K34, K35, $D$25, $D$26, $D$27)","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:847..5774946984170704883"},null,null," "]
[null,"P&L standard",null,null," ",{"$f":"B49","v":"P&L standard"},null,null," ","P&L standard",{"$f":"_xll.AC.finance.fs.standard(K38,K36)","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:847..5774946984170704883"},null,null," "]
[]
[null,"Balance Sheet","JEUS",{"$f":"D31","v":"2017-03-31"}," ",{"$f":"B41","v":"Balance Sheet"},{"$f":"C41","v":"JEUS"},{"$f":"H31","v":"2018-03-31"},null,"Balance Sheet","JE",{"$f":"L31","v":"FY2013-2017"}]
[null,null,null,null," "]
[null,{"$f":"B33","v":"Parameter"},{"$f":"C33","v":"Object"},{"$f":"D33","v":"size"}," ",{"$f":"B43","v":"Parameter"},{"$f":"C43","v":"Object"},"size",null,"Parameter","Object","size"]
[null,{"$f":"B34","v":"Levels mapping"},null,null," ",{"$f":"B34","v":"Levels mapping"},null,null,null,"Historical P&L:",{"$f":"_xll.AC.data.map('<JE'!B13:B87, '<JE'!C13:C87, 0)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:438..3082856348681009686"},{"$f":"_xll.AC.data.size(K44, 1)","v":70},null," "]
[null,{"$f":"B35","v":"Multiplier mapping"},null,null," ",{"$f":"B35","v":"Multiplier mapping"},null,null,null,"Adjustment types (exisiting FS):",{"$f":"_xll.AC.data.map('<JE'!B13:B87, '<JE'!D13:D87, 0)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:437..8774906353584091997"},{"$f":"_xll.AC.data.size(K45, 1)","v":70},null," "]
[null,{"$f":"B36","v":"Standard accounts"},null,null," ",{"$f":"B36","v":"Standard accounts"},null,null,null,"Adjustment types projected FS):",{"$f":"_xll.AC.data.map('<JE'!B13:B87, '<JE'!E13:E87, 0)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:463..1444578359241545198"},{"$f":"_xll.AC.data.size(K46, 1)","v":70},null," "]
[null,null,null,null," ",null,null,null,null,null,null,null,null," "]
[null,{"$f":"B38","v":"P&L original"},null,null," ",{"$f":"B38","v":"P&L original"},null,null," ","Historical and projected P&L:",{"$f":"_xll.AC.finance.fs.statement(K41, J41, $M$25:$M$29, '<JE'!$B$13:$B$87, '<JE'!$I$13:$M$87, K44, K45, $D$25, $D$26, $D$27)","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:844..245975045255545048"},null,null," "]
[null,"P&L standard",null,null," ",{"$f":"B39","v":"P&L standard"},null,null," ","Model calculator",{"$f":"_xll.AC.finance.fs.standard(K48,K46)","v":"jeconkr.finance.IFRS9.geq.lib.account.statement.FinancialStatement@Thu, 15 Feb 2018 05:04:37:844..245975045255545048"},null,null," "]

{"sheet":"names","index":11,"n_rows":83,"n_cols":14,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: NAMES OF ACCOUNTS, METRICS, AND RATIOS USED IN STANDARDIZED FINANCIAL STATEMENTS"]
[]
[null,"Financial statements standard accounts",null,null,null,"Financial statement metrics",null,null,null,null,null,"Financial statement ratios"]
[]
[null,"Name","ID","level",null,"Name","ID","level (metric)","level (metric, output)","level (ratio)",null,"Name","ID","level"]
[]
[null,"Balance Sheet Accounts",null,null,null,"Aggregate Balance Sheet Accounts",null,null,null,null,null,"Solvency Ratios"]
[null,"cash and marketable securities","CASH",1,null,"total assets","TOT_ASSETS",1,2,1,null,"Debt to EBITDA","DEBT/EBITDA",1]
[null,"accounts receivable","AR",1,null,"total current assets","TOT_CURR_ASSETS",1,2,1,null,"Debt to Equity","DEBT/EQTY",1]
[null,"I/C accounts receivable","AR_IC",1,null,"total accounts receivable","TOT_AR",1,2,1,null,"EBIT to Interest Expense","EBIT/INT_EXP",1]
[null,"inventory","INV",1,null,"total long-term assets","TOT_LT_ASSETS",1,2,1,null,"EBITA to Interest Expense","EBITA/INT_EXP",1]
[null,"due from related companies - short term","DEBT_RECEIV_IC_ST",1,null,"total liabilities","TOT_LIAB",1,2,1,null,"EBITDA to Interest Expense","EBITDA/INT_EXP",1]
[null,"deferred tax asset - short-term","TAX_RECEIV_ST",1,null,"total current liabilities","TOT_CURR_LIAB",2,2,1,null,"Debt to Total Book Capitalization","DEBT/TOT_CAPITAL",1]
[null,"other current assets (part of WC)","ASSETS_OTHER_WC_ST",1,null,"total account payables","TOT_AP",1,2,1,null,"Debt to Total Assets","DEBT/ASSETS",1]
[null,"other current assets (part of OCI)","ASSETS_OTHER_OCI_ST",1,null,"total long-term liabilities","TOT_LT_LIAB",1,2,1,null,"Equity Multiplier","ASSETS/EQTY",1]
[null,null,null,null,null,"total short-tem debt","TOT_ST_DEBT",3,2,1,null,"RCF to Debt","RCF/DEBT",1]
[null,"net fixed assets","ASSETS_FIXED",1,null,"total long-tem debt","TOT_LT_DEBT",3,2,1,null,"FFO (before Interest) to Interest","(FFO+INT_EXP)/INT_EXP",1]
[null,"goodwill","GOODWILL",1,null,"total debt","TOT_DEBT",4,2,1,null,"FFO to Net Debt","FFO/NET_DEBT",1]
[null,"intangible assets (other than goodwill)","INTANGIBLES",1,null,"net debt","NET_DEBT",1,2,1]
[null,"investments - long-term","INVEST",1,null,"total other comprehensive income","TOT_OCI",1,2,1,null,"Profitability Ratios"]
[null,"I/C investments - long-term","INVEST_IC",1,null,"total equity","TOT_EQTY",2,2,1,null,"Gross Margin","GM",1]
[null,"due from related companies - long term","DEBT_RECEIV_IC_LT",1,null,"total book capitalization","TOT_BOOK_CAPITAL",1,2,1,null,"Operating Margin","OM",1]
[null,"deferred tax asset - long-term","TAX_RECEIV_LT",1,null,"total liabilities and equity","TOT_LIAB_EQTY",2,3,1,null,"Pre-tax Margin","EBT/REV",1]
[null,"other long-term assets (part of CFO)","ASSETS_OTHER_CFO_LT",1,null,null,null,null,null,null,null,"Net-income Margin","NI/REV",1]
[null,"other long-term assets (part of OCI)","ASSETS_OTHER_OCI_LT",1,null,"Income Statement Aggregate and Derived Accounts",null,null,null,null,null,"Operating Return on Assets","ROA_OP",1]
[null,null,null,null,null,"total revenue","TOT_REV",1,1,1,null,"Return on Assets","ROA",1]
[null,"accounts payable","AP",1,null,"total COGS","TOT_COGS",1,1,1,null,"Return on Capital","ROC",1]
[null,"I/C accounts payable","AP_IC",1,null,"gross profits","GROSS_PROFITS",1,1,1,null,"Return on Equity","ROE",1]
[null,"third-party debt - short-term","DEBT_ST",1,null,"total operating expense","OPEX",1,1,1,null,"Return on Common Equity","RCE",1]
[null,"current portion of long-term debt","DEBT_LT_CURR",1,null,"total interest expense","TOT_INT",3,1,1]
[null,"I/C debt - short-term","DEBT_IC_ST",1,null,"total non-operating expense","TOT_NON_OPEX",1,1,1,null,"Valuation Ratios"]
[null,"income taxes payable - short-term","TAX_PAYABLE_ST",1,null,"earnings before tax (EBT)","EBT",1,0,1,null,"Price to Earnings","P/NI",1]
[null,"other current liabilities (part of WC)","LIAB_OTHER_WC_ST",1,null,"earnings before interest and tax (EBIT)","EBIT",2,0,1,null,"Price to Cash Flow","P/CFO",1]
[null,"other current liabilities (part of OCI)","LIAB_OTHER_OCI_ST",1,null,"earnings before interest, tax and amortization (EBITA)","EBITA",1,0,1,null,"Price to Sales","P/REV",1]
[null,null,null,null,null,"earnings before interest, tax and D&A (EBITDA)","EBITDA",1,0,1,null,"Price to Book Value","P/BOOK_EQTY",1]
[null,"third-party debt - long-term","DEBT_LT",1,null,"amortization and depreciation","D&A",1,2,1,null,"Basic Earnings per Share","EPS",1]
[null,"I/C debt - long-term","DEBT_IC_LT",1,null,"net income","NI",2,0,1,null,"Diluted Earnings per Share","EPS_DILUTE",1]
[null,"capital leases","LEASES_CAPITAL",1,null,"total income tax","INC_TAX",1,2,1,null,"Cash Flow per Share","CFO/SHARES",1]
[null,"deferred tax liability - long-term","TAX_PAYABLE_LT",1,null,"tax-adjusted interest expense","TAX_ADJ_INT",1,2,1,null,"EBITDA per Share","EBITDA/SHARES",1]
[null,"other long-term liabilities (part of CFO)","LIAB_OTHER_CFO_LT",1,null,null,null,null,null,null,null,"Dividends per Share","DIV/SHARES",1]
[null,"other long-term liabilities (part of OCI)","LIAB_OTHER_OCI_LT",1,null,"Cash Flows Aggregate and Derived Accounts",null,null,null,null,null,"Dividend Payout","DIV_PAYOUT",1]
[null,null,null,null,null,"cash flows from operations","CFO",2,2,1,null,"Retention Rate","RETENTION",1]
[null,"other comprehensive income","OCI",1,null,"cash flows from investing activities","CFI",2,2,1,null,"Sustainable Growth Rate","GR",1]
[null,"retained earnings","RE",1,null,"cash flows from financing activities","CFF",2,2,1]
[null,"other owners equity","EQTY_CONTRIB",1,null,"funds from operations","FFO",2,2,1,null,"Liquidity Ratios"]
[null,"minority interest","MINORITY",1,null,"retained cash flows","RCF",2,2,1,null,"Current Ratio","CURR_ASSETS/CURR_LIAB",1]
[null,null,null,null,null,"free cash flows","FCF",2,2,1,null,"Quick Ratio","(CASH+AR)/CURR_LIAB",1]
[null,"Income Statement Accounts",null,null,null,"FFO before interest expense","FFO+INT_EXP",2,2,1,null,"Cash Ratio","CASH/CURR_LIAB",1]
[null,"revenues","REV",1,null,"working capital","WC",2,2,1]
[null,"I/C revenues","REV_IC",1,null,"change in working capital","D_WC",2,2,1,null,"Other Ratios"]
[null,"discounts and disbursments","DISBURSEMENT",1,null,"\t",null,null,null,null,null,"Effective Interest Rate","EFF_INT_RATE",1]
[null,null,null,null,null,"Increase (decrease) in cash","D_CASH",2,2,1,null,"CFO to Net Debt","CFO/NET_DEBT",1]
[null,"cost of goods sold","COGS",1,null,"Decrease (increase) in A/R","D_AR",2,2,1,null,"Revenue (in billions)","REV_BLN",1]
[null,"I/C cost of goods sold","COGS_IC",1,null,"Decrease (increase) in inventory","D_INV",2,2,1,null,"EBITA (in billions)","EBITA_BLN",1]
[null,null,null,null,null,"Decrease (increase) in other current assets (part of WC)","D_OTHER_ASSETS_WC_ST",2,2,1,null,"Total Assets (in billions)","ASSETS_BLN",1]
[null,"amortization","AMORTIZATION",1,null,"Decrease (increase) in other current assets (part of OCI)","D_OTHER_ASSETS_OCI_ST",2,2,1]
[null,"depreciation","DEPRECIATION",1,null,"Decrease (increase) in other long-term assets (part of CFO)","D_OTHER_ASSETS_CFO_LT",2,2,1]
[null,"selling general and administrative costs","SGA",1,null,"Decrease (increase) in other long-term assets (part of OCI)","D_OTHER_ASSETS_OCI_LT",2,2,1]
[null,"interest expense","INT_EXP",1,null,"Increase (decrease) in A/P","D_AP",2,2,1]
[null,"I/C interest expense","INT_EXP_IC",1,null,"Increase (decrease) in other short-term liabilities (part of WC)","D_OTHER_LIAB_WC_ST",2,2,1]
[null,"interest income","INT_INC",1,null,"Increase (decrease) in other short-term liabilities (part of OCI)","D_OTHER_LIAB_OCI_ST",2,2,1]
[null,"operating leases","LEASES_OPER",1,null,"Increase (decrease) in other long-term liabilities (part of CFO)","D_OTHER_LIAB_CFO_LT",2,2,1]
[null,"other expense (income)","EXP_OTHER",1,null,"Increase (decrease) in other long-term liabilities (part of OCI)","D_OTHER_LIAB_OCI_LT",2,2,1]
[null,"other income (expense)","INC_OTHER",1]
[null,"non-operating expense","NON_OPEX",1,null,"Increase in asset value due to acquisitions","D_ACQUSITION",2,2,1]
[null,null,null,null,null,"increase in investments","D_INVEST",2,2,1]
[null,"current income tax","TAX_INC_CURR",1,null,"increase in I/C investments","D_INVEST_IC",2,2,1]
[null,"future income tax","TAX_INC_FUT",1]
[null,null,null,null,null,"Increase in debt - short term","D_DEBT_ST",2,2,1]
[null,"Cash Flow Statement Accounts",null,null,null,"Increase in debt - long term","D_DEBT_LT",2,2,1]
[null,"dividends","DIV",1,null,"Increase in other comprehensive income","D_OCI",2,2,1]
[null,"capital expenditures","CAPEX",1,null,"Issuance of common stock and adjustment to equity","D_EQTY",2,2,1]
[]
[null,null,null,null,null,"Market Valuation Metrics"]
[null,null,null,null,null,"Total number of market shares","SHARES",2,2,1]
[null,null,null,null,null,"Market price per share","P",2,2,1]
[]
[null,null,null,null,null,"Validation Test Metrics"]
[null,null,null,null,null,"balance sheet balancing test","TEST_BS",1,2,1]
[null,null,null,null,null,"income statement balancing test","TEST_IS",1,2,1]
[null,null,null,null,null,"cash flow statement balancing test","TEST_CF",1,2,1]
[null,null,null,null,null,"capex account test","TEST_CAPEX",1,2,1]

{"sheet":"validate","index":12,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: VALIDATION OF FINANCIAL STATEMENTS"]
[]
[null,"List of financial statements",null,null,"P&L metrics",{"$f":"_xll.AC.finance.fs.get(calc!C39, config!B7, 'accounts<'!D4)","v":0},null,{"$f":"_xll.AC.data.size($F$4, 1)","v":-1}]
[null,null,null,null,null,null,null,{"$f":"_xll.AC.data.size($F$4, 2)","v":-1}]
[null,{"$f":"calc!C39","v":0}," ","#",{"$f":"_xll.AC.data._get(F4, \"\", 0)","v":0},0,0]
[null,{"$f":"_xll.AC.data.list_x(B6:B6, 0, 1)","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:488..597782670240864507"}," ",1,0,0,0]
[null,null,null,{"$f":"IF(E8=\"\", \"\", D7+1)","v":2},0,0,0]
[null,"Validation",null,3,0,0,0]
[null,null,null,4,0,0,0]
[null,{"$f":"_xll.AC.finance.fs.validate(B7, 1)","v":"java.lang.ClassCastException: java.lang.Double cannot be cast to jeconkr.finance.IFRS9.geq.iLib.account.statement.IFinancialStatement"},{"$f":"_xll.AC.data.size(B11, 1)","v":-1},5,0,0,0]
[null,null,null,""]
[null,null,null,""]

{"sheet":"cra grid","index":13,"n_rows":35,"n_cols":33,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: CRA QUANTITATIVE METRICS GRIDS AND QUALITATIVE FACTORS"]
[]
[null,"Mappings"]
[]
[null,"Rating-to-score mapping",null,null,null,null,"Aaa",null,"Aa","A","Baa","Ba","B","Caa","Ca"]
[null,{"$f":"_xll.AC.data.map(G6:O6, G7:O7)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:466..5030072378946356434"},null,null,null,{"$f":"_xll.AC.data.size(B7, 1)","v":8},1,null,3,6,9,12,15,18,20]
[]
[null,"Aggregate score-to-rating mapping",null,null,null,null,1.5,{"$f":"G9+1","v":2.5},{"$f":"H9+1","v":3.5},4.5,5.5,6.5,7.5,8.5,9.5,{"$f":"O9+1","v":10.5},null,null,{"$f":"P9+1","v":11.5},{"$f":"S9+1","v":12.5},13.5,null,{"$f":"U9+1","v":14.5},15.5,16.5,17.5,18.5,19.5,1000]
[null,{"$f":"_xll.AC.data.map(G9:AC9, G10:AC10)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:466..3142166712048917003"},null,null,null,{"$f":"_xll.AC.data.size(B10, 1)","v":20},"Aaa","Aa1","Aa2","Aa3","A1","A2","A3","Baa1","Baa2","Baa3",null,null,"Ba1","Ba2","Ba3",null,"B1","B2","B3","Caa1","Caa2","Caa3","Ca"]
[]
[]
[null,"Distribution and Supply Chain Service Industry, 11 Dec 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"Unregulated Utilities and Unregulated Power Companies, 17 May 2017"]
[]
[null,"Quantitative metrics grid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quantitative metrics grid"]
[]
[null,"#","Metric","weight","weight adjusted","id","match ≥","format","Aaa","Aa","A","Baa","Ba","B","Caa","Ca",null,null,"#",{"$f":"C17","v":"Metric"},{"$f":"D17","v":"weight"},"weight adjusted",{"$f":"F17","v":"id"},{"$f":"G17","v":"match ≥"},"format",{"$f":"I17","v":"Aaa"},"Aa","A","Baa","Ba","B","Caa"]
[null,1,"Revenue (in USD bln)",0.1,{"$f":"D18","v":0.1},{"$f":"names!M54","v":"REV_BLN"},1,"x.x",160,85,35,15,5,2,0.5,null,null,null,1,"Scale (USD bln)",0.1,{"$f":"U18","v":0.1},{"$f":"names!M56","v":"ASSETS_BLN"},1,"x.x",100,50,25,10,5,2.5]
[null,{"$f":"B18+1","v":2},"EBITA (in USD bln)",0.1,{"$f":"D19","v":0.1},{"$f":"names!M55","v":"EBITA_BLN"},1,"x.x",8,4,2,0.75,0.4,0.05,0,null,null,null,{"$f":"S18+1","v":2},"(CFO Pre-WC + Interest) / Interest",0.1,{"$f":"U19","v":0.1},{"$f":"names!M18","v":"(FFO+INT_EXP)/INT_EXP"},1,"x.x",18,13,8,4.2,2.8,1]
[null,{"$f":"B19+1","v":3},"Operating Margin",0.1,0.1,{"$f":"names!M23","v":"OM"},1,"%",0.4,0.3,0.2,0.1,0.05,0.02,5.0000000000000001E-3,null,null,null,{"$f":"S19+1","v":3},"(CFO Pre-WC) / Debt",0.15,0.15,{"$f":"names!M19","v":"FFO/NET_DEBT"},1,"%",0.9,0.6,0.35,0.2,0.12,0.05]
[null,4,"Return on invested capital",0.05,0.05,{"$f":"names!M28","v":"ROC"},1,"%",0.5,0.35,0.25,0.15,7.4999999999999997E-2,2.5000000000000001E-2,0.01,null,null,null,4,"RCF / Debt",0.15,0.15,{"$f":"names!M17","v":"RCF/DEBT"},1,"%",0.6,0.45,0.25,0.15,0.08,0.03]
[null,5,"Debt / EBITDA",0.1,0.1,{"$f":"names!M9","v":"DEBT/EBITDA"},0,"x.x",0.5,1,2,3,4.5,6.5,9,null,null,null,null,null,{"$f":"SUM(U18:U21)","v":0.5},{"$f":"SUM(V18:V21)","v":0.5}]
[null,6,"EBITA / Interest",0.15,0.15,{"$f":"names!M12","v":"EBITA/INT_EXP"},1,"x.x",25,15,10,5,2.5,1.5,0.75]
[null,7,"RCF / Debt",0.1,0.1,{"$f":"names!M17","v":"RCF/DEBT"},1,"%",0.7,0.5,0.35,0.22500000000000001,0.125,0.05,0]
[null,null,null,{"$f":"SUM(D18:D24)","v":0.70000000000000007},{"$f":"SUM(E18:E24)","v":0.70000000000000007}]
[null,"Qualitative overlay",null,null,null,null,"Methodology objects",null,null,null,null,null,null,null,null,null,null,null,"Qualitative overlay"]
[]
[null,"#","Factor","weight",{"$f":"E17","v":"weight adjusted"},null,"Name",null,null,null,"Object",null,null,null,null,null,null,null,"#","Factor","weight",{"$f":"V17","v":"weight adjusted"}]
[null,1,"Business Profile",0.15,{"$f":"D29","v":0.15},null,null,null,null,null,null,null,null,null,null,null," ",null,1,"Market Diversification",0.1,{"$f":"U29","v":0.1}]
[null,{"$f":"B29+1","v":2},"Financial Policy",0.15,{"$f":"D30","v":0.15},null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"S29+1","v":2},"Hedging and Intergration Impact on Cash Flow Predictability",0.05,{"$f":"U30","v":0.05}]
[null,null,null,{"$f":"SUM(D29:D30)","v":0.3},{"$f":"SUM(E29:E30)","v":0.3},null,"Moody's CRA model",null,null,null,{"$f":"_xll.AC.finance.cra.model(B13, C18:P24, C29:E30, $B$7, $B$10)","v":"jeconkr.finance.FSTP.cra.ModelCRA@Thu, 15 Feb 2018 05:04:37:856..332424736160870626"},null,null,null,null,null," ",null,{"$f":"S30+1","v":3},"Market Framework & Positioning",0.1,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Capital Requirements and Operational Performance",0.05,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Business Mix Impact on Cash Flow Predictability",0.1,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Financial Policy",0.1,{"$f":"U34","v":0.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U29:U34)","v":0.5},{"$f":"SUM(V29:V34)","v":0.5},null,"Moody's CRA model",null,null,null,{"$f":"_xll.AC.finance.cra.model(S13, T18:AF21, T29:V34, $B$7, $B$10)","v":"jeconkr.finance.FSTP.cra.ModelCRA@Thu, 15 Feb 2018 05:04:37:857..3770334199112215231"},null,null,null,null," "]

{"sheet":"test","index":14,"n_rows":90,"n_cols":20,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: TESTING"]
[]
[null,{"$f":"'accounts<'!N4","v":"account-levels"},null,null,{"$f":"'accounts<'!D4","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:487..8718910813228316133"},null,null," ",null,null,null,"account-levels",null,null,{"$f":"E4","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:487..8718910813228316133"},null,null," "]
[null,"Financial statement",null,null,{"$f":"_xll.AC.finance.fs.get(calc!C20, config!B6, _xll.AC.data.map(B4, E4))","v":0},null,null,{"$f":"_xll.AC.data.size(E5, 1)","v":-1},{"$f":"_xll.AC.data.size(E5, 2)","v":-1},null,null,"Financial statement",null,null,{"$f":"_xll.AC.finance.fs.get(calc!C21, config!B6, _xll.AC.data.map(B4, E4))","v":0},null,null,{"$f":"_xll.AC.data.size(O5, 1)","v":-1},{"$f":"_xll.AC.data.size(O5, 2)","v":-1}]
[]
[null,"#",{"$f":"_xll.AC.data._get(E5, \"\", 0)","v":0},0,0,0,0,0,0,null,null,"#",{"$f":"_xll.AC.data._get(O5, \"\", 0)","v":0},0,0,0,0,0,0,0]
[null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(C9=\"\", \"\", B8+1)","v":2},0,0,0,0,0,0,0,null,null,{"$f":"IF(M9=\"\", \"\", L8+1)","v":2},0,0,0,0,0,0,0,0]
[null,{"$f":"IF(C10=\"\", \"\", B9+1)","v":3},0,0,0,0,0,0,0,null,null,{"$f":"IF(M10=\"\", \"\", L9+1)","v":3},0,0,0,0,0,0,0,0]
[null,4,0,0,0,0,0,0,0,null,null,4,0,0,0,0,0,0,0,0]
[null,5,0,0,0,0,0,0,0,null,null,5,0,0,0,0,0,0,0,0]
[null,6,0,0,0,0,0,0,0,null,null,6,0,0,0,0,0,0,0,0]
[null,7,0,0,0,0,0,0,0,null,null,7,0,0,0,0,0,0,0,0]
[null,8,0,0,0,0,0,0,0,null,null,8,0,0,0,0,0,0,0,0]
[null,9,0,0,0,0,0,0,0,null,null,9,0,0,0,0,0,0,0,0]
[null,10,0,0,0,0,0,0,0,null,null,10,0,0,0,0,0,0,0,0]
[null,11,0,0,0,0,0,0,0,null,null,11,0,0,0,0,0,0,0,0]
[null,12,0,0,0,0,0,0,0,null,null,12,0,0,0,0,0,0,0,0]
[null,13,0,0,0,0,0,0,0,null,null,13,0,0,0,0,0,0,0,0]
[null,14,0,0,0,0,0,0,0,null,null,14,0,0,0,0,0,0,0,0]
[null,15,0,0,0,0,0,0,0,null,null,15,0,0,0,0,0,0,0,0]
[null,16,0,0,0,0,0,0,0,null,null,16,0,0,0,0,0,0,0,0]
[null,17,0,0,0,0,0,0,0,null,null,17,0,0,0,0,0,0,0,0]
[null,18,0,0,0,0,0,0,0,null,null,18,0,0,0,0,0,0,0,0]
[null,19,0,0,0,0,0,0,0,null,null,19,0,0,0,0,0,0,0,0]
[null,20,0,0,0,0,0,0,0,null,null,20,0,0,0,0,0,0,0,0]
[null,21,0,0,0,0,0,0,0,null,null,21,0,0,0,0,0,0,0,0]
[null,22,0,0,0,0,0,0,0,null,null,22,0,0,0,0,0,0,0,0]
[null,23,0,0,0,0,0,0,0,null,null,23,0,0,0,0,0,0,0,0]
[null,24,0,0,0,0,0,0,0,null,null,24,0,0,0,0,0,0,0,0]
[null,25,0,0,0,0,0,0,0,null,null,25,0,0,0,0,0,0,0,0]
[null,26,0,0,0,0,0,0,0,null,null,26,0,0,0,0,0,0,0,0]
[null,27,0,0,0,0,0,0,0,null,null,27,0,0,0,0,0,0,0,0]
[null,28,0,0,0,0,0,0,0,null,null,28,0,0,0,0,0,0,0,0]
[null,29,0,0,0,0,0,0,0,null,null,29,0,0,0,0,0,0,0,0]
[null,30,0,0,0,0,0,0,0,null,null,30,0,0,0,0,0,0,0,0]
[null,31,0,0,0,0,0,0,0,null,null,31,0,0,0,0,0,0,0,0]
[null,32,0,0,0,0,0,0,0,null,null,32,0,0,0,0,0,0,0,0]
[null,33,0,0,0,0,0,0,0,null,null,33,0,0,0,0,0,0,0,0]
[null,34,0,0,0,0,0,0,0,null,null,34,0,0,0,0,0,0,0,0]
[null,35,0,0,0,0,0,0,0,null,null,35,0,0,0,0,0,0,0,0]
[null,36,0,0,0,0,0,0,0,null,null,36,0,0,0,0,0,0,0,0]
[null,37,0,0,0,0,0,0,0,null,null,37,0,0,0,0,0,0,0,0]
[null,38,0,0,0,0,0,0,0,null,null,38,0,0,0,0,0,0,0,0]
[null,39,0,0,0,0,0,0,0,null,null,39,0,0,0,0,0,0,0,0]
[null,40,0,0,0,0,0,0,0,null,null,40,0,0,0,0,0,0,0,0]
[null,41,0,0,0,0,0,0,0,null,null,41,0,0,0,0,0,0,0,0]
[null,42,0,0,0,0,0,0,0,null,null,42,0,0,0,0,0,0,0,0]
[null,43,0,0,0,0,0,0,0,null,null,43,0,0,0,0,0,0,0,0]
[null,44,0,0,0,0,0,0,0,null,null,44,0,0,0,0,0,0,0,0]
[null,45,0,0,0,0,0,0,0,null,null,45,0,0,0,0,0,0,0,0]
[null,46,0,0,0,0,0,0,0,null,null,46,0,0,0,0,0,0,0,0]
[null,47,0,0,0,0,0,0,0,null,null,47,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,48,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,49,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,50,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,51,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,52,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,53,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,54,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,55,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,56,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,57,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,58,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,59,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,60,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,61,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,62,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,63,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,64,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,65,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,66,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(C74=\"\", \"\", B73+1)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(M74=\"\", \"\", L73+1)","v":67},0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,68,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,69,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,70,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,71,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,72,0,0,0,0,0,0,0,0]
[null,"",null,null,null,null,null,null,null,null,null,73,0,0,0,0,0,0,0,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,null,null,""]
[null,"",null,null,null,null,null,null,null,null,null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"<JE","index":15,"n_rows":102,"n_cols":45,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Just Energy Group Inc",null,null,null,"epsilon",0.4,null,null,null,null,null,null,null,null,null,null,null,null,"Just Energy Group Inc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Just Energy Group Inc"]
[null,"Annual Balance Sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Income Statement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Cash Flows"]
[null,"[Standardized in USD Millions]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Standardized in USD Millions]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Standardized in USD Millions]"]
[]
[null,"",null,null,null,null,null,null,"31-Mar-2017","31-Mar-2016","31-Mar-2015","31-Mar-2014","31-Mar-2013","31-Mar-2012","31-Mar-2011","31-Mar-2010","31-Mar-2009","31-Mar-2008",null,"",null,null,null,"31-Mar-2017","31-Mar-2016","31-Mar-2015","31-Mar-2014","31-Mar-2013","31-Mar-2012","31-Mar-2011","31-Mar-2010","31-Mar-2009","31-Mar-2008",null,"","31-Mar-2017","31-Mar-2016","31-Mar-2015","31-Mar-2014","31-Mar-2013","31-Mar-2012","31-Mar-2011","31-Mar-2010","31-Mar-2009","31-Mar-2008"]
[null,"UpdateDate",null,null,null,null,null,null," Filed  31-May-2017 "," Filed  31-May-2017 "," Filed  02-Jun-2016 "," Filed  02-Jun-2015 "," Filed  04-Jun-2014 "," Filed  31-May-2013 "," Filed  26-Jun-2012 "," Filed  03-Jun-2011 "," Filed  02-Jun-2010 "," Filed  31-Mar-2009 ",null,"Period Length",null,null,null,"12 Months","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months",null,"Period Length","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months","12 Months"]
[null,"Filed Currency",null,null,null,null,null,null,"CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD",null,"UpdateDate",null,null,null," Filed  31-May-2017 "," Filed  31-May-2017 "," Filed  02-Jun-2016 "," Filed  02-Jun-2015 "," Filed  04-Jun-2014 "," Filed  31-May-2013 "," Filed  26-Jun-2012 "," Filed  03-Jun-2011 "," Filed  02-Jun-2010 "," Filed  31-Mar-2009 ",null,"UpdateDate"," Filed  31-May-2017 "," Filed  31-May-2017 "," Filed  02-Jun-2016 "," Filed  02-Jun-2015 "," Filed  04-Jun-2014 "," Filed  31-May-2013 "," Filed  26-Jun-2012 "," Filed  03-Jun-2011 "," Filed  02-Jun-2010 "," Filed  31-Mar-2009 "]
[null,"Exchange Rate ",null,null,null,null,null,null,1.329094,1.29853,1.2690250000000001,1.1060719999999999,1.016418,0.99822200000000005,0.97275,1.0145500000000001,1.2581500000000001,1.0260499999999999,null,"Filed Currency",null,null,null,"CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD",null,"Filed Currency","CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD","CAD"]
[null,"Auditor",null,null,null,null,null,null,"Ernst & Young LLP","Ernst & Young LLP","Ernst & Young LLP","","Ernst & Young LLP","Ernst & Young LLP","Ernst & Young LLP","KPMG LLP","Chartered Accountants, Licensed Public Accountants","",null,"Exchange Rate (Period Average)",null,null,null,1.3124009999999999,1.3111139999999999,1.1373629999999999,1.0529109999999999,1.0011540000000001,0.99304400000000004,1.0168699999999999,1.090827,1.126447,1.032316,null,"Exchange Rate (Period Average)",1.3124009999999999,1.3111139999999999,1.1373629999999999,1.0529109999999999,1.0011540000000001,0.99304400000000004,1.0168699999999999,1.090827,1.126447,1.032316]
["#","Auditor Opinion","level","multiplier","Mapped account",null,null,null,"Unqualified","Unqualified","Unqualified","","Unqualified","Unqualified","Unqualified","Unqualified","Unqualified","",null,"Auditor","level","multiplier","Mapped account","Ernst & Young LLP","Ernst & Young LLP","Ernst & Young LLP","","Ernst & Young LLP","Ernst & Young LLP","Ernst & Young LLP","KPMG LLP","Chartered Accountants, Licensed Public Accountants","",null,"Auditor","Ernst & Young LLP","Ernst & Young LLP","Ernst & Young LLP","","Ernst & Young LLP","Ernst & Young LLP","Ernst & Young LLP","KPMG LLP","Chartered Accountants, Licensed Public Accountants",""]
[null,"",null,null,null,null,null,null,"","","","","","","","","","",null,"Auditor Opinion",null,null,null,"Unqualified","Unqualified","Unqualified","","Unqualified","Unqualified","Unqualified","Unqualified","Unqualified","",null,"Auditor Opinion","Unqualified","Unqualified","Unqualified","","Unqualified","Unqualified","Unqualified","Unqualified","Unqualified",""]
[0,"Cash",-1,1,null,{"$f":"_xll.AC.finance.fs.match(B13:B91, I13:R91,,,G2)","v":"d"},"","","-","-","-","-","-","-","-",59.3,47,"-",null,"",null,null,null,"","","","","","","","","","",null,"","","","","","","","","","",""]
[{"$f":"A13+1","v":1},"Cash and Cash Equivalents",-1,1,null,-1,"","",43.2,98.3,62.1,18.399999999999999,37.9,53.3,100.4,59.3,47,26.6,null,"Other Operating Revenue",null,null,null,2862.7,3131.6,3425.4,"-",3007.7,"-",2904.2,2107.8000000000002,1686,1684.3,null,"Net Income","-","-","-","-","-","-","-",212.2,-983.2,148]
[{"$f":"A14+1","v":2},"Short-Term Investments",-1,1,null,-1,"","",19.8,"-",3.8,93.6,32.5,"-","-","-","-","-",null,"Operating Revenue",null,null,null,2862.7,3131.6,3425.4,3357,3007.7,2673.4,2904.2,2107.8000000000002,1686,1684.3,null,"Discontinued Operations","-","-",116.6,-31.9,-71.2,1.8,"-","-","-","-"]
[3,"Cash, Cash Equivalents and Short-Term Investments",0,1,{"$f":"names!C9","v":"CASH"},0,"","",62.9,98.3,65.900000000000006,112,70.3,53.3,100.4,59.3,47,26.6,null,"Total Revenue",0,1,{"$f":"names!C50","v":"REV"},2862.7,3131.6,3425.4,3357,3007.7,2673.4,2904.2,2107.8000000000002,1686,1684.3,null,"Net Income from Continuing Operations","-","-","-","-","-","-","-",212.2,-983.2,148]
[4,"Accounts Receivable, Net",-1,1,null,-1,"","",216.9,231.5,296.10000000000002,"-","-","-",289.60000000000002,229.2,198.3,202.5,null,"",null,null,null,"","","","","","","","","","",null,"Depreciation",5,2.8,3.1,3.9,4.4000000000000004,4.5999999999999996,5.6,5,4.5,5]
[5,"Unbilled Receivables",-1,1,null,-1,"","",164.3,175.1,173.1,154.30000000000001,127.1,131,115.3,73,45.9,46.1,null,"Cost of Revenue",0,-1,{"$f":"names!C54","v":"COGS"},2332.4,2595.9,2897.8,2876.9,2484.1999999999998,2170.1999999999998,2430.6,1727,1399.4,1418.1,null,"Amortization of Intangibles",12.1,27.8,36.799999999999997,45.6,86.2,123.1,131.1,55.9,3.2,7.3]
[6,"Taxes Receivable",-1,1,null,-1,"","",2.2000000000000002,7.8,10.3,8.8000000000000007,9.6,8.1999999999999993,9.4,"-","-",2.6,null,"Gross Profit",null,null,null,530.29999999999995,535.6,527.6,480.1,523.5,503.2,473.6,380.8,286.60000000000002,266.2,null,"Amortization",12.1,27.8,36.799999999999997,45.6,95.4,123.1,131.1,55.9,3.2,7.3]
[7,"Other Receivables",-1,1,null,-1,"","",61.1,57.9,102.2,430,343.9,297.7,27.3,20.5,"-","-",null,"",null,null,null,"","","","","","","","","","",null,"Depreciation and Amortization",17.2,30.6,39.9,49.5,99.8,127.7,136.69999999999999,60.9,7.7,12.3]
[8,"Total Receivables",0,1,{"$f":"names!C10","v":"AR"},0,"","",444.6,472.3,581.6,593.1,480.6,437,441.5,322.7,244.2,251.2,null,"Wages and Salaries",0,-1,{"$f":"names!C59","v":"SGA"},4.5999999999999996,4.0999999999999996,6.3,1.5,11.9,10.7,9.6999999999999993,4.4000000000000004,3.6,3,null,"Depreciation, Amortization and Depletion",17.2,30.6,39.9,49.5,99.8,127.7,136.69999999999999,60.9,7.7,12.3]
[9,"Fuel and Natural Gas",-1,1,null,-1,"","",11.7,7.2,4.9000000000000004,2.2000000000000002,16,24.3,9.9,11.3,5.3,4.2,null,"General and Administrative Expense",-1,1,null,133,134,141.9,112.4,149.1,126.8,117.3,85.4,56.5,53,null,"Deferred Income Tax","-","-","-","-","-","-","-",-111.9,-56.9,-18.100000000000001]
[10,"Materials and Supplies",-1,1,null,-1,"","","-","-","-","-","-",1.2,2.2999999999999998,2.2999999999999998,"-","-",null,"Marketing Expense",-1,1,null,"-","-","-","-","-","-","-",87.8,60.4,54.4,null,"Deferred Taxes","-","-","-","-","-","-","-",-111.9,-56.9,-18.100000000000001]
[11,"Inventories - Other",-1,1,null,-1,"","","-","-","-",8.3000000000000007,6,8.8000000000000007,"-",4,0.2,"-",null,"Selling and Marketing",-1,1,null,172.4,196.3,198,180.3,220.2,178.5,131.4,87.8,60.4,54.4,null,"Amortization of Securities",2.2999999999999998,1.9,26.9,16.5,17.399999999999999,6.8,9.6999999999999993,"-","-","-"]
[12,"Total Inventory",0,1,{"$f":"names!C12","v":"INV"},0,"","",11.7,7.2,4.9000000000000004,10.5,22,34.299999999999997,12.2,17.5,5.5,4.2,null,"Selling, General and Administrative Expenses",0,-1,{"$f":"names!C59","v":"SGA"},305.39999999999998,330.3,339.9,292.7,369.4,305.39999999999998,248.7,173.2,117,107.4,null,"Unrealized Gain (Loss) on Investment Securities",-285.60000000000002,17.399999999999999,558.5,-176.8,-718.7,"-","-",1.2,1186.9000000000001,0.8]
[13,"Prepaid Assets",0,1,{"$f":"names!C15","v":"ASSETS_OTHER_WC_ST"},0,"","",83.8,88.3,18,19.600000000000001,15.6,9.5,6.2,19.8,1.6,2.2999999999999998,null,"Depreciation",0,-1,{"$f":"names!C58","v":"DEPRECIATION"},5,2.8,3.1,3.9,4.4000000000000004,4.5999999999999996,"-",5,4.5,5,null,"Stock-Based Compensation",4.5999999999999996,4.0999999999999996,6.3,1.5,11.9,10.7,9.6999999999999993,4.4000000000000004,3.6,3]
[14,"Restricted Cash",0,1,{"$f":"names!C9","v":"CASH"},0,"","",2.7,5.8,13.8,10.9,13.1,12.2,0.9,18.399999999999999,6,4.5999999999999996,null,"Amortization of Intangibles",null,null,null,12.1,13,30.4,31.4,86.2,28.4,"-",55.9,3.2,7.3,null,"Other Non-Cash Items",-278.7,23.4,591.70000000000005,-158.80000000000001,-689.4,17.600000000000001,19.399999999999999,5.5,1190.5,3.8]
[15,"Deferred Taxes - Current Assets",null,null,null,"d","","","-","-","-","-","-","-","-",28.7,"-","-",null,"Amortization",0,-1,{"$f":"names!C57","v":"AMORTIZATION"},12.1,13,36.799999999999997,31.4,86.2,28.4,124.4,55.9,3.2,7.3,null,"Accounts Receivable","-","-","-","-","-",13.5,"-","-",-15.3,-14.4]
[16,"Current Deferred Assets",0,1,{"$f":"names!C14","v":"TAX_RECEIV_ST"},0,"","","-","-","-","-","-","-","-",28.7,"-","-",null,"Depreciation and Amortization",null,null,null,17.2,15.8,39.9,35.299999999999997,90.6,33,124.4,60.9,7.7,12.3,null,"Receivables",11.7,107.3,-81.7,-152.19999999999999,-15,13.5,"-",-55,-15.3,-14.4]
[17,"Other Current Assets",0,1,{"$f":"E26","v":"ASSETS_OTHER_WC_ST"},0,"","",8.8000000000000007,3.8,"-","-",76.2,12.8,8.8000000000000007,2.7,4.4000000000000004,188.5,null,"Depreciation, Amortization and Depletion",null,null,null,17.2,15.8,39.9,35.299999999999997,90.6,33,124.4,60.9,7.7,12.3,null,"Inventories",-4.7,-2.2000000000000002,-2.9,14.3,-4.7,-4.9000000000000004,"-",2.2000000000000002,-1.3,1.6]
[18,"Total Current Assets","m",1,{"$f":"names!G10","v":"TOT_CURR_ASSETS"},"","","",614.5,675.8,684.3,746.1,677.8,559.20000000000005,569.9,469,308.8,477.4,null,"Amortization of Securities",0,-1,{"$f":"names!C64","v":"EXP_OTHER"},"-","-","-",14.2,"-",80.599999999999994,"-","-","-","-",null,"Prepaid Expenses",2.6,-30.4,-23.8,-4.9000000000000004,-2.7,0.4,"-",23.7,0.3,-0.1]
[19,"",null,null,null,"","","","","","","","","","","","","",null,"Provision for Doubtful Accounts",0,-1,{"$f":"W31","v":"EXP_OTHER"},42.7,52.3,54.6,43.7,30.8,28.7,"-",16.399999999999999,12.3,6.7,null,"Taxes Payable","-","-","-","-","-","-","-",-7.6,"-",1.6]
[20,"Water Production",null,null,null,"d","","","-","-","-","-","-","-","-",50.3,1.8,"-",null,"Other Taxes",0,-1,{"$f":"W32","v":"EXP_OTHER"},"-","-","-","-","-","-","-",0.5,0.2,0.8,null,"Payables",-19.100000000000001,-39.299999999999997,70.900000000000006,178.9,12.7,-24.2,"-",-7.6,"-",2.6]
[21,"Leases",null,null,null,"d","","",3.4,6.9,6.8,8.1999999999999993,8.8000000000000007,8.6999999999999993,8.8000000000000007,8.3000000000000007,6,7.3,null,"Other Operating Expense",0,-1,{"$f":"W33","v":"EXP_OTHER"},"-","-","-","-","-","-",28.6,"-","-","-",null,"Accrued Expenses",1,-13.2,-5.0999999999999996,6.5,"-","-","-","-","-","-"]
[22,"Other Property/Plant/Equipment",null,null,null,"d","","",12.9,12.4,11.9,151.6,245,282.89999999999998,231.8,155.19999999999999,8,9,null,"Total Operating Expense",null,null,null,365.3,398.3,434.4,386,490.8,447.6,401.8,251,137.19999999999999,127.2,null,"Payables/Accrued",-18.2,-52.5,65.8,185.4,12.7,-24.2,"-",-2.2000000000000002,16.899999999999999,1.9]
[23,"Property/Plant/Equipment - Gross",-1,1,null,-1,"","",43.9,55.2,50.8,224.1,307.7,357.9,289.60000000000002,243.1,31.6,30,null,"",null,null,null,"","","","","","","","","","",null,"Other Working Capital",-9.1999999999999993,3.4,1.2,-5,"-","-","-",-1.3,5,-0.4]
[24,"Accumulated Depreciation",-1,1,null,-1,"","",-27.6,-35.9,-32,-64.3,-53.9,-66.3,-49,-28.9,-15.7,-13.8,null,"Total Expenses",null,null,null,2697.7,2994.2,3332.2,3262.8,2975,2617.8000000000002,2832.4,1978.1,1536.7,1545.2,null,"Changes in Working Capital",-17.899999999999999,25.6,-41.5,37.6,-9.8000000000000007,-15.2,-38.4,-32.6,5.5,-11.5]
[25,"Property/Plant/Equipment - Net",0,1,{"$f":"names!C18","v":"ASSETS_FIXED"},0,"","",16.3,19.3,18.8,159.80000000000001,253.8,291.60000000000002,240.6,214.1,15.9,16.2,null,"",null,null,null,"","","","","","","","","","",null,"Cash from Discontinued Operating Activities","-","-",18.399999999999999,6.3,"-","-","-","-","-","-"]
[26,"Goodwill",0,1,{"$f":"names!C19","v":"GOODWILL"},-1,"","",217.6,216,218.9,238.7,252.2,255.3,"-",175.3,93,113.2,null,"Operating Income",null,null,null,165,137.30000000000001,93.2,94.2,32.700000000000003,55.6,71.8,129.69999999999999,149.4,139,null,"Cash from Operating Activities",114.6,142.69999999999999,84.6,157.1,93,145.4,143.1,145.1,153.4,131.69999999999999]
[27,"Other Intangible Assets",0,1,{"$f":"names!C20","v":"INTANGIBLES"},-1,"","",51.8,50.3,55.7,127.4,187.9,295.10000000000002,688.6,337.1,4.0999999999999996,1.5,null,"",null,null,null,"","","","","","","","","","",null,"","","","","","","","","","",""]
[28,"Goodwill and Other Intangible Assets",null,null,null,0,"","",269.3,266.39999999999998,274.60000000000002,366.1,440.1,550.4,688.6,512.5,97.1,114.7,null,"Interest Expense - Non-Operating",0,-1,{"$f":"names!C60","v":"INT_EXP"},59.5,55.3,64.8,66,73.900000000000006,54.8,58.9,14.8,3.4,5.2,null,"Purchase of Property/Plant/Equipment",-6.3,-5.3,-5.0999999999999996,-6.9,-38.299999999999997,-75.099999999999994,-32.9,-37.799999999999997,-5.6,-7.6]
[29,"Long-Term Investments",0,1,{"$f":"names!C21","v":"INVEST"},0,"","",11.7,5.4,8.4,37,39.700000000000003,"-",5.5,"-","-","-",null,"Net Non-Operating Interest Income (Expense)",null,null,null,-59.5,-55.3,-64.8,-66,-73.900000000000006,-54.8,-58.9,-14.8,-3.4,-5.2,null,"Net Purchase (Sale) of Property/Plant/Equipment",-6.3,-5.3,-5.0999999999999996,-6.9,-38.299999999999997,-75.099999999999994,-32.9,-37.799999999999997,-5.6,-7.6]
[30,"Financial Assets",0,1,{"$f":"E42","v":"INVEST"},0,"","",2.2999999999999998,2.6,"-","-","-","-","-","-","-","-",null,"Other Income (Expense)",0,1,{"$f":"names!C66","v":"NON_OPEX"},286.2,-19.3,-560.6,179.6,722.7,-92.3,504.8,2,-1180.0999999999999,0.1,null,"Purchase/Acquisition of Intangibles",-13.8,-7.7,-6.7,-7.1,-14.5,-5.9,-5.7,-5.8,"-","-"]
[31,"Deferred Taxes - Non-Current Assets",null,null,null,"d","","",17.3,31.5,21,1.5,24.5,78.5,125.2,84,"-",9.1999999999999993,null,"Income Before Tax",null,null,null,391.7,62.7,-532.20000000000005,207.8,681.5,-91.6,517.6,117,-1034.2,133.9,null,"Intangible, Net",-13.8,-7.7,-6.7,-7.1,-14.5,-5.9,-5.7,-5.8,"-","-"]
[32,"Non-Current Deferred Assets",0,1,{"$f":"names!C24","v":"TAX_RECEIV_LT"},0,"","",17.3,31.5,21,1.5,24.5,78.5,125.2,84,"-",9.1999999999999993,null,"",null,null,null,"","","","","","","","","","",null,"Purchase of Short-Term Investments",-20,"-","-","-","-","-","-","-","-","-"]
[33,"Deferred Charges",0,1,{"$f":"names!C25","v":"ASSETS_OTHER_CFO_LT"},0,"","","-","-","-","-",57.5,44.3,"-",5.5,"-","-",null,"Total Income Tax",0,-1,{"$f":"names!C68","v":"TAX_INC_CURR"},32.9,-0.2,-25.4,45.8,86.3,37.799999999999997,170.6,-91.9,-51,-14,null,"Purchase of Investments",-20,"-","-",-6.8,-10.5,"-","-","-","-","-"]
[34,"Other Long-Term Assets",0,1,{"$f":"E46","v":"ASSETS_OTHER_CFO_LT"},0,"","","-","-",16.100000000000001,174.6,10.9,21.8,4.7,6.9,4.0999999999999996,73.599999999999994,null,"Income After Tax",null,null,null,358.8,62.9,-506.8,162,595.20000000000005,-129.4,347.1,208.9,-983.2,148,null,"Investment, Net",-20,"-","-",-6.8,-10.5,"-","-","-","-","-"]
[35,"Total Non-Current Assets",null,null,null,"","","",316.89999999999998,325.2,338.9,739,826.4,986.6,1064.5999999999999,823,117.1,213.7,null,"",null,null,null,"","","","","","","","","","",null,"Acquisition of Business",-7.2,"-","-","-","-",-1.1000000000000001,-1.3,9,"-",-32.4]
[36,"",null,null,null,"","","","","","","","","","","","","",null,"Net Income from Continuing Operations",null,null,null,358.8,62.9,-506.8,162,595.20000000000005,-129.4,347.1,208.9,-983.2,148,null,"Sale of Business","-","-",171.9,"-","-","-","-","-","-","-"]
[37,"Total Assets",null,null,null,"","","",931.4,1001,1023.2,1485.1,1504.2,1545.8,1634.6,1292,425.8,691.1,null,"Discontinued Operations",null,null,null,"-","-",116.6,-31.9,-71.2,1.8,"-","-","-","-",null,"Net Acquisition (Sale) of Business",-7.2,"-",171.9,"-","-",-95.1,-258.3,9,-1.6,-32.4]
[38,"",null,null,null,"","","","","","","","","","","","","",null,"Minority Interest",null,null,null,-18.600000000000001,-13.6,-2.7,-1,5.7,0.1,2.1,3.3,0.1,"-",null,"Other Investing Cash Flow",3,8,-26.2,-22,-35.6,-30.3,-16.7,0.3,"-","-"]
[39,"Accounts Payable",-1,1,null,-1,"","","-","-","-","-","-",287.7,283.2,"-","-",4.5,null,"Net Income",null,null,null,340.1,49.3,-392.8,129.1,529.70000000000005,-127.4,349.2,212.2,-983.2,148,null,"Cash from Discontinued Investing Activities","-","-",-16.5,-64.7,-63.7,-0.3,"-","-","-","-"]
[40,"Income Taxes Payable",-2,1,null,"d","","",10.5,7.2,10.4,5.7,5.0999999999999996,4.8,10.1,"-","-","-",null,"",null,null,null,"","","","","","","","","","",null,"Cash from Investing Activities",-44.3,-4.9000000000000004,117.4,-107.6,-162.69999999999999,-206.7,-313.60000000000002,-34.299999999999997,-7.3,-40]
[41,"Total Tax Payable",-1,1,null,-1,"","",10.5,7.2,10.4,5.7,5.0999999999999996,4.8,10.1,6.3,1.5,"-",null,"Net Income Available to Common Stockholders",null,null,null,340.1,49.3,-392.8,129.1,529.70000000000005,-127.4,349.2,212.2,-983.2,148,null,"","","","","","","","","","",""]
[42,"Other Payables",-1,1,null,-1,"","",375.6,402.4,425.1,470.2,325,3,19.899999999999999,13,8.6999999999999993,32.1,null,"",null,null,null,"","","","","","","","","","",null,"Short-Term Debt Reduction","-","-","-","-","-","-",-5.8,"-","-","-"]
[43,"Payables",0,1,{"$f":"names!C28","v":"AP"},0,"","",386,409.6,435.4,475.9,330,295.39999999999998,313.2,19.3,10.199999999999999,36.6,null,"Basic EPS",null,null,null,2.2999999999999998,0.34,-2.7,0.9,3.79,-0.93,2.72,1.66,-8.9,1.38,null,"Short-Term Debt, Net","-","-","-","-","-","-",-5.8,7.6,"-","-"]
[44,"Accrued Expenses",0,1,{"$f":"names!C34","v":"LIAB_OTHER_WC_ST"},0,"","","-","-","-","-","-","-","-",14.9,32.9,37.5,null,"Basic EPS from Continuing Operations",null,null,null,2.2999999999999998,0.34,-3.53,1.0900000000000001,4.26,-0.94,2.72,1.66,-8.9,1.38,null,"Long-Term Debt Issued",121.9,"-",272.8,571.29999999999995,471.2,467.8,476.8,223.5,77.900000000000006,94.2]
[45,"Other Payables and Accrued Expenses",0,1,{"$f":"E57","v":"LIAB_OTHER_WC_ST"},0,"","","-","-","-","-","-","-","-",182,138.19999999999999,125.4,null,"Basic EPS from Discontinued Operations",null,null,null,"-","-",0.83,-0.19,-0.5,0.01,"-","-","-","-",null,"Long-Term Debt Reduction",-305.7,-24.5,-335.3,-545.1,-277.3,-284.2,-148,-190.2,-76.099999999999994,-66.2]
[46,"Current Provisions",0,1,{"$f":"E58","v":"LIAB_OTHER_WC_ST"},0,"","",6.2,10.5,11.7,2.8,3,3.2,4.0999999999999996,"-","-","-",null,"Diluted EPS",null,null,null,1.84,0.33,-2.7,0.89,3.27,-0.93,2.36,1.64,-8.9,1.37,null,"Long-Term Debt, Net",-183.8,-24.5,-62.5,26.3,193.9,183.6,328.8,33.299999999999997,1.8,28.1]
[47,"Current Debt",null,null,null,"d","","","-","-",0,47,159.80000000000001,98.8,99.1,70,"-","-",null,"Diluted EPS from Continuing Operations",null,null,null,1.84,0.33,-3.53,1.05,3.65,-0.94,2.36,1.64,-8.9,1.37,null,"Issuance (Retirement) of Debt, Net",-183.8,-24.5,-62.5,26.3,193.9,183.6,323,40.799999999999997,1.8,28.1]
[48,"Current Debt and Capital Lease Obligation",0,1,{"$f":"names!C31","v":"DEBT_LT_CURR"},0,"","","-","-",0,47,159.80000000000001,98.8,99.1,70,"-","-",null,"Diluted EPS from Discontinued Operations",null,null,null,"-","-",0.8,-0.19,-0.5,0.01,"-","-","-","-",null,"Sale/Issuance of Common","-","-","-","-",0,"-","-","-","-",17.5]
[49,"Deferred Taxes - Current Liabilities",-1,1,null,"d","","","-","-","-","-","-","-","-",6.7,"-","-",null,"Basic Average Shares",null,null,null,147.6,146.9,145.30000000000001,143,140,138.19999999999999,128.19999999999999,128,110.5,107.5,null,"Repurchase/Retirement of Common",-5,"-","-","-","-","-","-","-","-","-"]
[50,"Customer Advances",-1,1,null,0,"","",13.2,17.7,1.2,0.1,12.8,12,"-",7.1,"-","-",null,"Diluted Average Shares",null,null,null,189.4,190.1,188.5,173.6,171.3,138.19999999999999,147.9,129.4,110.5,108.4,null,"Common Stock, Net",-5,"-","-","-",0,-1,"-","-",-5.9,17.5]
[51,"Current Deferred Liabilities",0,1,{"$f":"E59","v":"LIAB_OTHER_WC_ST"},0,"","",13.2,17.7,1.2,0.1,12.8,12,"-",13.8,"-","-",null,"Dilution Adjustment",null,null,null,9.6999999999999993,37.6,28.8,"-","-","-","-","-","-","-",null,"Sale/Issuance of Preferred",101.3,"-","-","-","-","-","-","-","-","-"]
[52,"Other Current liabilities",0,1,{"$f":"names!C26","v":"ASSETS_OTHER_OCI_LT"},0,"","",127,329.5,304.39999999999998,69.7,233.4,637.20000000000005,499,675.4,412.8,57.6,null,"Interest Expense",null,null,null,59.5,55.3,64.8,66,73.900000000000006,54.8,58.9,14.8,3.4,5.2,null,"Preferred Stock, Net",101.3,"-","-","-","-","-","-","-","-","-"]
[53,"Total Current Liabilities",null,null,null,"","","",532.4,767.2,752.8,595.4,739.1,1046.7,915.4,975.4,594.1,257.2,null,"Net Interest Income",null,null,null,-59.5,-55.3,-64.8,-66,-73.900000000000006,-54.8,-58.9,-14.8,-3.4,-5.2,null,"Cash Dividends Paid - Common","-","-","-","-","-","-","-","-",-114.8,-127]
[54,"",null,null,null,"","","","","","","","","","","","","",null,"Net Income Including Non-Controlling Interests",null,null,null,358.8,62.9,-390.1,130.1,524,-127.5,347.1,208.9,-983.2,148,null,"Cash Dividends Paid - Preferred","-","-","-","-","-","-","-",-6.9,-7.5,-11.5]
[55,"Long-Term Provisions",0,1,{"$f":"names!C41","v":"LIAB_OTHER_CFO_LT"},0,"","","-",3.4,3.4,3.4,3.7,3.1,3.3,"-","-","-",null,"Net Income from Continuing and Discontinued Operations",null,null,null,340.1,49.3,-392.8,129.1,529.70000000000005,-127.4,349.2,212.2,-983.2,148,null,"Total Cash Dividends Paid",-58.5,-57,-73,-109.3,-156.5,-147.9,-132.4,-151.30000000000001,-122.3,-138.5]
[56,"Deferred Taxes - Non-Current Liabilities",0,1,{"$f":"names!C40","v":"TAX_PAYABLE_LT"},0,"","",1.3,1.1000000000000001,1,29.8,30.8,6.1,23.6,"-","-",19,null,"Normalized Income",null,null,null,340.1,49.3,-509.5,161,600.9,-129.19999999999999,349.2,212.2,-983.2,148,null,"Options Exercised","-","-","-","-","-","-","-","-",3.8,3.9]
[57,"Non-Current Deferred Liabilities",0,1,{"$f":"E68","v":"LIAB_OTHER_CFO_LT"},0,"","",2.1,2.1,1.5,30.5,31.8,7.9,25.2,2,1.9,21.7,null,"Basic EPS from Continuing &amp; Discontinued Operations",null,null,null,2.2999999999999998,0.34,-2.7,0.9,3.76,-0.93,2.72,1.66,-8.9,1.38,null,"Other Financing Cash Flow",23.4,-16.3,-0.3,-16.5,-1.9,-11.4,17.5,4.2,2.2999999999999998,6.7]
[58,"Derivative Product Liabilities",0,1,{"$f":"names!C42","v":"LIAB_OTHER_OCI_LT"},0,"","",134.5,221,"-","-","-","-","-","-","-","-",null,"Diluted EPS from Continuing &amp; Discontinued Operations",null,null,null,1.84,0.33,-2.73,0.86,3.15,-0.93,2.36,1.64,-8.9,1.37,null,"Cash from Discontinued Financing Activities","-","-",-13.7,36.5,22.2,-7.1,"-","-","-","-"]
[59,"Minority Interest",0,1,{"$f":"names!C47","v":"MINORITY"},0,"","","-","-","-",5.8,-0.7,-0.6,"-",20.3,0.2,"-",null,"Dividends per Share",null,null,null,0.38,0.38,0.45,0.8,1.21,1.25,0.95,0.73,1.26,1.1499999999999999,null,"Cash from Financing Activities",-122.5,-97.8,-155.19999999999999,-63,57.8,16.2,208.2,-106.3,-120.3,-82.3]
[60,"Other Long-Term Liabilities",0,1,{"$f":"E71","v":"LIAB_OTHER_OCI_LT"},0,"","","-","-","-",41.1,0.7,310.8,365.4,561.79999999999995,319.10000000000002,152.4,null,"Net Income Before Extraord Items",null,null,null,340.1,49.3,-509.5,161,600.9,-129.19999999999999,349.2,212.2,-983.2,148,null,"","","","","","","","","","",""]
[61,"Deferred Credits and Other Non-Current Liabilities",null,null,null,"","","",136.6,226.5,4.9000000000000004,80.8,35.6,321.10000000000002,393.9,584.1,321.2,174.1,null,"Tax Rate",null,null,null,"8.41%","-","4.77%","23.99%","12.55%","25.00%","5.89%","28.00%","4.93%","10.49%",null,"Cash from Discontinued Operating Activities","-","-",18.399999999999999,6.3,"-","-","-","-","-","-"]
[62,"",null,null,null,"","","","","","","","","","","","","",null,"Basic Normalized EPS",null,null,null,2.2999999999999998,0.34,-3.53,1.0900000000000001,4.26,-0.94,2.72,1.66,-8.9,1.38,null,"Cash from Discontinued Investing Activities","-","-",-16.5,-64.7,-63.7,-0.3,"-","-","-","-"]
[63,"Long-Term Debt",null,null,null,"d","","",374.8,508.7,533.1,840.8,782.4,680.3,521.70000000000005,228.5,60.8,65.900000000000006,null,"Diluted Normalized EPS",null,null,null,1.84,0.33,-3.53,1.05,3.65,-0.94,2.36,1.64,-8.9,1.37,null,"Cash from Discontinued Financing Activities","-","-",-13.7,36.5,22.2,-7.1,"-","-","-","-"]
[64,"Long-Term Debt and Capital Lease Obligation",0,1,{"$f":"names!C37","v":"DEBT_LT"},0,"","",374.8,508.7,533.1,840.8,782.4,680.3,521.70000000000005,228.5,60.8,65.900000000000006,null,"EBITDA",null,null,null,468.4,148.6,-427.5,323.2,855.3,90.9,713.2,192.7,-1023.1,151.4,null,"Net Cash - Beginning Balance",97.2,60.1,17.899999999999999,36.6,53,98.3,59.1,54.2,24.2,16.3]
[65,"Total Liabilities",null,null,null,"","","",1043.8,1502.4,1526.6,1573.8,1640.4,2047.5,1831,1808.3,976.3,497.2,null,"Normalized EBITDA",null,null,null,468.4,148.6,-427.5,323.2,855.3,90.9,713.2,192.7,-1023.1,151.4,null,"Net Change in Cash",-53.5,37.200000000000003,53.1,-12.3,-14.5,-44.7,36.9,1,28.2,10.199999999999999]
[{"$f":"A78+1","v":66},"",null,null,null,"","","","","","","","","","","","","",null,"Reconciled Cost of Revenue",null,null,null,2332.4,2581.1,2897.8,2862.7,2475,2075.5,2418.4,1727,1399.4,1418.1,null,"Foreign Exchange Effects",-1.3,-2.8,6.2,1.2,-2.7,0.3,-0.9,-3.5,2.4,0.7]
[67,"Capital Stock",0,1,{"$f":"E82","v":"EQTY_CONTRIB"},0,"","","-","-","-","-","-","-","-",649.70000000000005,"-",349,null,"Reconciled Depreciation",null,null,null,17.2,30.6,39.9,49.5,99.8,127.7,136.69999999999999,60.9,7.7,12.3,null,"Net Cash - Ending Balance",43.7,97.3,69.3,19.399999999999999,38.5,53.6,96,55.1,52.5,26.5]
[68,"Retained Earnings (Accumulated Deficit)",0,1,{"$f":"names!C45","v":"RE"},0,"","",-1121,-1432.1,-1440.9,-1170.8,-1279.3,-1655.1,-1387.7,-1403.3,-1156.9000000000001,-206.6,null,"EBIT",null,null,null,451.2,118,-467.4,273.7,755.4,-36.700000000000003,576.5,131.80000000000001,-1030.8,139.1,null,"","","","","","","","","","",""]
[69,"Additional Paid-In Capital",0,1,{"$f":"names!C46","v":"EQTY_CONTRIB"},0,"","",945.5,857,872.7,993.7,1071.4000000000001,1057.2,1045.2,18.600000000000001,"-",11.7,null,"Non-Operating Expenses",null,null,null,-59.5,-55.3,-64.8,-66,-73.900000000000006,-54.8,-58.9,-14.3,-3.2,-4.4000000000000004,null,"Capital Expenditures",-20.100000000000001,-12.9,-11.8,-14,-52.9,-81,-38.5,-43.6,-5.6,-7.6]
[70,"Gains (Losses) Not Affecting Retained Earnings",0,1,{"$f":"names!C44","v":"OCI"},0,"","",52.9,53.7,44.4,65.099999999999994,46.4,70.400000000000006,127.4,218.8,289.8,39.799999999999997,null,"Non-Operating Income",null,null,null,286.2,-19.3,-560.6,179.6,722.7,-92.3,504.8,2,-1180.0999999999999,0.1,null,"Issuance of Capital Stock",101.3,"-","-","-",0,"-","-","-","-",17.5]
[71,"Stockholders' Equity",null,null,null,"","","",-112.4,-501.4,-503.4,-88.7,-136.1,-501.7,-196.5,-516.29999999999995,"-",193.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Debt Issued",121.9,"-",272.8,571.29999999999995,471.2,467.8,476.8,223.5,77.900000000000006,94.2]
[72,"Limited Partner",0,1,{"$f":"E82","v":"EQTY_CONTRIB"},0,"","","-","-","-","-","-","-","-","-",316.7,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Debt Reduction",-305.7,-24.5,-335.3,-545.1,-277.3,-284.2,-153.80000000000001,-190.2,-76.099999999999994,-66.2]
[73,"Total Partnership Capital",null,null,null,"","","","-","-","-","-","-","-","-","-",-550.5,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repurchase of Capital Stock",-5,"-","-","-","-","-","-","-","-","-"]
[74,"Total Equity",null,null,null,"","","",-112.4,-501.4,-503.4,-88.7,-136.1,-501.7,-196.5,-516.29999999999995,-550.5,193.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Taxes Paid","-","-","-","-","-","-","-",25.6,1,1.2]
[75,"",null,null,null,null,null,null,"","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Interest Paid",40.6,44.6,49.7,54.2,66.400000000000006,53.2,38.5,13.4,3.6,5.4]
[76,"Total Liabilities and Shareholders&#8217; Equity",null,null,null,null,null,null,931.4,1001,1023.2,1485.1,1504.2,1545.8,1634.6,1292,425.8,691.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Cash Flow",94.5,129.80000000000001,72.8,143.1,40.1,64.400000000000006,104.6,101.5,147.69999999999999,124.2]
[77,"",null,null,null,null,null,null,"","","","","","","","","",""]
[null,"Net Tangible Assets",null,null,null,null,null,null,-381.7,-767.8,-778,-454.8,-576.20000000000005,-1052.0999999999999,-885.1,-1028.7,-647.6,79.2]
[null,"Working Capital",null,null,null,null,null,null,82.1,-91.4,-68.5,150.69999999999999,-61.3,-487.6,-345.5,-506.4,-285.3,220.2]
[null,"Invested Capital",null,null,null,null,null,null,262.39999999999998,7.3,29.7,799.2,806.1,277.5,424.3,-217.7,-489.7,259.8]
[null,"Total Debt",null,null,null,null,null,null,374.8,508.7,533.1,887.8,942.2,779.1,620.79999999999995,298.60000000000002,60.8,65.900000000000006]
[null,"Net Debt",null,null,null,null,null,null,331.6,410.4,471,869.4,904.4,725.8,520.4,239.3,13.8,39.299999999999997]
[null,"Total Capitalization",null,null,null,null,null,null,262.39999999999998,7.3,29.7,752.2,646.29999999999995,178.6,325.2,-287.8,-489.7,259.8]
[null,"Common Stock Equity",null,null,null,null,null,null,-112.4,-501.4,-503.4,-88.7,-136.1,-501.7,-196.5,-516.29999999999995,-550.5,193.9]
[null,"Total Common Shares Outstanding",null,null,null,null,null,null,147,147.19999999999999,146.6,143.80000000000001,142,139.30000000000001,137,124.3,111.4,108.9]
[null,"Total Preferred Shares Outstanding",null,null,null,null,null,null,"-","-","-","-","-","-","-",5.3,5.3,"-"]
[null,"Shares Issued",null,null,null,null,null,null,147,147.19999999999999,146.6,143.80000000000001,142,139.30000000000001,137,124.3,111.4,108.9]
[null,"Tangible Book Value",null,null,null,null,null,null,-381.7,-767.8,-778,-454.8,-576.20000000000005,-1052.0999999999999,-885.1,-1028.7,-647.6,79.2]
[null,"Employees",null,null,null,null,null,null,2146,1450,1220,1500,1500,1200,1055,898,702,435]

{"sheet":"count","index":16,"n_rows":219,"n_cols":4,"rows_kept":219,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: DATA COUNT"]
[]
[null,{"$f":"_xll.AC.data.list_x(#REF!, 0, 1)","v":"java.util.ArrayList@Thu, 15 Feb 2018 05:04:36:487..7425052831053461416"},null," "]
[null,{"$f":"_xll.AC.data.count(B4)","v":"java.util.LinkedHashMap@Thu, 15 Feb 2018 05:04:36:488..4789770072572806373"},null," "]
[null,{"$f":"_xll.AC.data.size(B5, 1)","v":0}]
[null,"#","Account","Count"]
[null,1,{"$f":"_xll.AC.data._get(B5, \"parse\", 0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,{"$f":"B8+1","v":2},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B9+1","v":3},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,4,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,5,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,6,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,7,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,8,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,9,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,10,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,11,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,12,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,13,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,14,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,15,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,16,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,17,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,18,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,19,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,20,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,21,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,22,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,23,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,24,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,25,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,26,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,27,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,28,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,29,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,30,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,31,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,32,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,33,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,34,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,35,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,36,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,37,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,38,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,39,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,40,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,41,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,42,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,43,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,44,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,45,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,46,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,47,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,48,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,49,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,50,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,51,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,52,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,53,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,54,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,55,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,56,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,57,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,58,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,59,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,60,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,61,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,62,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,63,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,64,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,65,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,66,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B73+1","v":67},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,68,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,69,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,70,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,71,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,72,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,73,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,74,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,75,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,76,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,77,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,78,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,79,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,80,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,81,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,82,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,83,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,84,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,85,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,86,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,87,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,88,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,89,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,90,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,91,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,92,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,93,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,94,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,95,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,96,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,97,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,98,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,99,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,100,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,101,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,102,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,103,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,104,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,105,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,106,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,107,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,108,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,109,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,110,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,111,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,112,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,113,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,114,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,115,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,116,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,117,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,118,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,119,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,120,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,121,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,122,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,123,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,124,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,125,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,126,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,127,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,128,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,129,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,130,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B137+1","v":131},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,132,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,133,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,134,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,135,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,136,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,137,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,138,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,139,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,140,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,141,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,142,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,143,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,144,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,145,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,146,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,147,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,148,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,149,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,150,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,151,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,152,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,153,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,154,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,155,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,156,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,157,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,158,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,159,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,160,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,161,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,162,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,163,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,164,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,165,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,166,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,167,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,168,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,169,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,170,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,171,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,172,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,173,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,174,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,175,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,176,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,177,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,178,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,179,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,180,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,181,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,182,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,183,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,184,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,185,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,186,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,187,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,188,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,189,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,190,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,191,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,192,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,193,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,194,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"B201+1","v":195},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,196,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,197,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,198,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,199,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,200,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,201,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,202,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,203,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,204,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,205,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,206,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,207,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,208,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,209,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,210,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,211,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,212,{"$error":"#N/A"},{"$error":"#N/A"}]