{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["DCF","Sheet1","Additional Data","Data","BBG_DATA","Help"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":183,"comments":3,"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":"DCF","index":0,"n_rows":281,"n_cols":55,"rows_kept":281,"cut":false,"hidden":false,"merged":[[223,13,223,20],[246,13,246,20],[246,4,246,11],[26,13,26,16],[26,17,26,19],[44,10,45,10],[44,11,45,11],[44,12,45,12],[44,13,45,13],[44,14,45,14],[44,15,45,15],[46,6,46,9],[47,6,47,9],[221,4,221,20],[48,6,48,9],[249,13,249,14],[231,18,231,19],[248,13,248,14],[42,4,42,20],[25,13,25,16],[25,17,25,19],[25,5,25,8],[26,5,26,8],[25,9,25,11],[26,9,26,11],[231,9,231,10],[241,9,241,10],[243,9,243,10],[243,18,243,19],[241,18,241,19],[223,4,223,11],[5,10,5,11],[5,5,5,7],[7,5,7,7],[7,10,7,11],[11,4,11,20],[9,4,9,7],[7,13,7,14],[7,16,7,17],[7,19,7,20],[14,4,14,7],[22,5,22,11],[22,13,22,19],[23,5,23,8],[24,5,24,8],[23,13,23,16],[23,17,23,19],[24,13,24,16],[24,17,24,19],[23,9,23,11],[24,9,24,11]]}
[]
[]
[]
[]
[]
[null,null,null,null,"Ticker","BB CN",null,null,null,"Currency","Trading",null,null,{"$f":"IFERROR(IF(OR(_xll.BDP(TKR,\"EQY_FUND_IND\",\"Fill=B\")=\"Bank\",_xll.BDP(TKR,\"EQY_FUND_IND\",\"Fill=B\")=\"Financial\"),\"WARNING: This model is not suitable for financial institutions. See DDM<GO> or EQRV<GO>.\",VLOOKUP(_xll.BDP(TKR,\"MARKET_STATUS\",\"Fill=B\"),Data!$L$4:$N$58,3,FALSE)),\"\")","v":""}]
[]
[null,null,null,null,"Name",{"$f":"_xll.BDP(TKR,\"SECURITY_NAME\",\"Fill=B\")","v":"BlackBerry Ltd"},null,null,null,"Data","Adjusted (If available)",null,null,"Summary Analysis",null,null,"Input Calculation",null,null,"Output Analysis",null,null,{"$f":"_xll.BDP(\"EUR CURNCY\",\"TIME\")","v":"09:42:25"}]
[]
[null,null,null,null,{"$f":"\"In Millions of \"&CCY","v":"In Millions of CAD"},null,null,null,{"$f":"IF(ISBLANK(I52),\"\",I52)","v":"Févr 10 A"},{"$f":"IF(ISBLANK(J52),\"\",J52)","v":"Févr 11 A"},"Févr 12 A","Févr 13 A","Févr 14 A","Févr 15 A","Févr 16 E","Févr 17 E","Févr 18 E","Févr 19 E","Févr 20 E","Févr 21 E","Year 5"]
[]
[null,null,null,null,"Summary Analysis"]
[]
[]
[null,null,null,null,{"$f":"\"In Millions of \"&CCY","v":"In Millions of CAD"},null,null,null,{"$f":"IF(ISBLANK(I52),\"\",I52)","v":"Févr 10 A"},"Févr 11 A","Févr 12 A","Févr 13 A","Févr 14 A","Févr 15 A","Févr 16 E","Févr 17 E","Févr 18 E","Févr 19 E","Févr 20 E","Févr 21 E","Trend"]
[null,null,null,null,{"$f":"IF(ISBLANK(E55),\"\",E55)","v":"Revenue (Estimate Comparable)"},null,null,null,{"$f":"I55","v":16617.006847678778},20323.487484188721,18356.397527269932,11061.339286188208,7128.9817041387923,3754.077391876624,2855.1240000000003,2643.5450000000001,2216.8760000000002,1270.2047763770693,850.77257308939613,640.21121259181245]
[null,null,null,null,{"$f":"IF(ISBLANK(E57),\"\",E57)","v":"% YoY Growth"},null,null,null,{"$f":"IF(ISBLANK(I57),\"\",I57)","v":" "},{"$f":"J57","v":0.22305344581522513},{"$f":"K57","v":-9.6788996398829097E-2},-0.39741230436115349,-0.35550465276474896,-0.47340622438445001,-0.23946053797981148,-7.4105012601904607E-2,-0.16140031662029575,-0.42702939795592115,-0.33020833419001555,-0.24749429772162934]
[null,null,null,null,{"$f":"IF(ISBLANK(E211),\"\",E211)","v":"EBITDA"},null,null,null,{"$f":"I211","v":4461.9445506693537},5682.4499591598133,3471.3308485760081,1236.6962915470965,-2755.1165165121738,757.56944069954056,472.99699999999996,412.28999999999996,267.7510000000002,153.41345166790427,102.75505135030514,77.323762079011431]
[null,null,null,null,{"$f":"IF(ISBLANK(E212),\"\",E212)","v":"% Margin"},null,null,null,{"$f":"I212","v":0.26851674261015551},0.27960014065404126,0.18910741301059,0.11180348595683193,-0.38646704829003375,0.20179910044977509,0.16566600960238501,0.15596102960229538,0.12077851896091625,0.12077851896091626,0.12077851896091625,0.12077851896091629]
[null,null,null,null,{"$f":"RIGHT(E197,LEN(E197)-4)","v":"Free Cash Flow"},null,null,null,{"$f":"IF(ISBLANK(I197),\"\",I197)","v":1995.6442575622916},{"$f":"J197","v":3223.1448307989313},1988.6328930625273,1439.015077438303,-2088.8412390237368,1118.3856869984113,586.43261134081183,490.23184878071243,283.91353712534465,123.34150716450588,51.903083583984007,-3.6722382959892648]
[null,null,null,null,"% Margin",null,null,null,{"$f":"IF(ISBLANK(I198),\"\",I198)","v":0.12009649366191735},{"$f":"J198","v":0.15859211335192719},{"$f":"K198","v":0.10833459507009752},0.130094108878401,-0.29300695747487215,0.29791226185652553,0.20539654716951411,0.18544486618563799,0.12806920058918253,9.7103639868451483E-2,6.1007001431074834E-2,-5.735979351443537E-3]
[]
[null,null,null,null,null,"Perpetuity Growth Method",null,null,null,null,null,null,null,"EBITDA Multiple Method"]
[null,null,null,null,null,{"$f":"F243","v":"Current Price (CAD)"},null,null,null,{"$f":"K243","v":10.15},null,null,null,{"$f":"O243","v":"Current Price (CAD)"},null,null,null,{"$f":"T243","v":10.15}]
[null,null,null,null,null,"Consensus Price Target",null,null,null,{"$f":"_xll.BDP(TKR,\"BEST_TARGET_PRICE\",\"Fill=NA\")","v":9.3031463623046875},null,null,null,"Consensus Price Target",null,null,null,{"$f":"_xll.BDP(TKR,\"BEST_TARGET_PRICE\",\"Fill=NA\")","v":9.3031463623046875}]
[null,null,null,null,null,{"$f":"\"DCF \"&F242","v":"DCF Estimated Value per Share (CAD)"},null,null,null,{"$f":"J242","v":4.7833407339459058},null,null,null,{"$f":"\"DCF \"&O242","v":"DCF Estimated Value per Share (CAD)"},null,null,null,{"$f":"S242","v":5.0206028710319979}]
[null,null,null,null,null,{"$f":"\"DCF \"&F244","v":"DCF Estimated Upside "},null,null,null,{"$f":"J244","v":-0.52873490305951676},null,null,null,{"$f":"\"DCF \"&O244","v":"DCF Estimated Upside "},null,null,null,{"$f":"S244","v":-0.5053593230510347}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J250","v":"Perpetuity Growth"},null,null,null,null,null,null,null,{"$f":"S250","v":"Terminal EBITDA Multiple"}]
[null,null,null,null,null,null,null,{"$f":"H260","v":9.9999999999999985E-3},1.4999999999999999E-2,0.02,2.5000000000000001E-2,3.0000000000000002E-2,null,null,null,{"$f":"Q260","v":1.02886204256653},2.52886204256653,4.02886204256653,5.52886204256653,7.02886204256653]
[null,null,null,null,null,null,{"$f":"G261","v":0.11040749313643004},4.8078192512412734,4.8155416752511488,4.8241182789027723,4.8336990805862863,4.8444714132216786,null,null,{"$f":"P261","v":0.11040749313643004},4.7717232429423149,4.9145046993729791,5.0572861558036433,5.2000676122343066,5.3428490686649708]
[null,null,null,null,null,{"$f":"E254","v":"Discount"},{"$f":"G262","v":0.11540749313643005},4.7886256574643751,4.7954909642300176,4.8030758483097635,4.8114996986982321,4.8209098618889046,null,{"$f":"N254","v":"Discount"},{"$f":"P262","v":0.11540749313643005},4.7595479863697623,4.8991577970277991,5.0387676076858359,5.1783774183438727,5.3179872290019086]
[null,null,null,null,null,{"$f":"E255","v":"Rate"},{"$f":"G263","v":0.12040749313643005},4.7704643745099267,4.7765971594439955,4.7833407339459058,4.7907911265687222,4.7990656093597694,null,{"$f":"N255","v":"Rate"},{"$f":"P263","v":0.12040749313643005},4.7475582037865838,4.8840805374092904,5.0206028710319979,5.1571252046547045,5.293647538277412]
[null,null,null,null,null,{"$f":"E256","v":"(WACC)"},{"$f":"G264","v":0.12540749313643004},4.7532133359265671,4.7587158355476626,4.7647403568445785,4.7713648852832646,4.7786837541999274,null,{"$f":"N256","v":"(WACC)"},{"$f":"P264","v":0.12540749313643004},4.7357497387266063,4.8692661696073474,5.0027826004880884,5.1362990313688295,5.2698154622495723]
[null,null,null,null,null,null,{"$f":"G265","v":0.13040749313643005},4.7367704840935687,4.7417273155817252,4.7471331049573706,4.7530517411159909,4.7595598388749094,null,null,{"$f":"P265","v":0.13040749313643005},4.7241185539930948,4.854708152976551,4.9852977519600081,5.1158873509434644,5.2464769499269215]
[null,null,null,null,null,null,null,{"$f":"H268","v":9.9999999999999985E-3},1.4999999999999999E-2,0.02,2.5000000000000001E-2,3.0000000000000002E-2,null,null,null,{"$f":"Q268","v":1.02886204256653},2.52886204256653,4.02886204256653,5.52886204256653,7.02886204256653]
[null,null,null,null,null,null,{"$f":"G269","v":0.11040749313643004},-0.52632322647869234,-0.52556239652698045,-0.5247174109455397,-0.52377348959741021,-0.52271217603727305,null,null,{"$f":"P269","v":0.11040749313643004},-0.52987948345395908,-0.51581234488936167,-0.50174520632476427,-0.48767806776016687,-0.47361092919556935]
[null,null,null,null,null,null,{"$f":"G270","v":0.11540749313643005},-0.52821422093947046,-0.52753783603645155,-0.52679055681677212,-0.52596062081790818,-0.52503351114395036,null,null,{"$f":"P270","v":0.11540749313643005},-0.53107901612120578,-0.51732435497263063,-0.50356969382405559,-0.48981503267548054,-0.47606037152690561]
[null,null,null,null,null,null,{"$f":"G271","v":0.12040749313643005},-0.53000350990049983,-0.5293992946360595,-0.52873490305951676,-0.52800087422968256,-0.52718565425026909,null,null,{"$f":"P271","v":0.12040749313643005},-0.53226027548900656,-0.51880979927002069,-0.5053593230510347,-0.49190884683204883,-0.47845837061306284]
[null,null,null,null,null,null,{"$f":"G272","v":0.12540749313643004},-0.53170311961314609,-0.53116100142387568,-0.53056745252762783,-0.52991478962726457,-0.52919371879803667,null,null,{"$f":"P272","v":0.12540749313643004},-0.53342367106141819,-0.52026934289582782,-0.50711501473023768,-0.49396068656464731,-0.48080635839905694]
[null,null,null,null,null,null,{"$f":"G273","v":0.13040749313643005},-0.53332310501541191,-0.53283474723332758,-0.53230215714705709,-0.53171904028413886,-0.53107784838670846,null,null,{"$f":"P273","v":0.13040749313643005},-0.53456960059181335,-0.52170363024861566,-0.50883765990541796,-0.49597168956222026,-0.48310571921902257]
[]
[null,null,null,null,"Input Calculation"]
[]
[null,null,null,null,null,null,null,null,null,null,"Input","Peers","Px Implied","Tgt Implied","Default","Current Choice"]
[]
[null,null,null,null,null,null,"Weighted Average Cost of Capital",null,null,null,null,{"$f":"IFERROR('Additional Data'!L43,\"\")","v":8.0856747998210882E-2},null,null,{"$f":"IFERROR(_xll.BDP(TKR,\"WACC\")/100,\"\")","v":0.12040749313643005},{"$f":"IF(ISBLANK(K47),O47,K47)","v":0.12040749313643005}]
[null,null,null,null,null,null,"Perpetuity Growth Rate",null,null,null,null,null,{"$f":"($P47*((J24*K241+SUM(K237:K238)-O197*O207*O209-P197*P207*P209-Q197*Q207*Q209-R197*R207*R209-S197*S207*S209-T197*T207*T209)*(1+$P47)^5)-$K$225)/($K$225+((((J24*K241)+SUM(K237:K238))-O197*O207*O209-P197*P207*P209-Q197*Q207*Q209-R197*R207*R209-S197*S207*S209-T197*T207*T209)*(1+$P47)^5))","v":0.11781630543780051},{"$f":"($P47*((J25*K241+SUM(K237:K238)-O197*O207*O209-P197*P207*P209-Q197*Q207*Q209-R197*R207*R209-S197*S207*S209-T197*T207*T209)*(1+$P47)^5)-$K$225)/($K$225+((((J25*K241)+SUM(K237:K238))-O197*O207*O209-P197*P207*P209-Q197*Q207*Q209-R197*R207*R209-S197*S207*S209-T197*T207*T209)*(1+$P47)^5))","v":0.11734561244869819},{"$f":"'Additional Data'!D9","v":0.02},{"$f":"IF(ISBLANK(K48),O48,K48)","v":0.02}," (Perpetuity Growth Method only)"]
[null,null,null,null,null,null,"Exit Enterprise Value / EBITDA",null,null,null,null,{"$f":"'Additional Data'!K43","v":6.4502558930279825},{"$f":"((R24*T241+SUM(T237:T238)-O197*O207*O209-P197*P207*P209-Q197*Q207*Q209-R197*R207*R209-S197*S207*S209-T197*T207*T209)*(1+P47)^5)/T225","v":60.386642409223548},{"$f":"((R25*T241+SUM(T237:T238)-O197*O207*O209-P197*P207*P209-Q197*Q207*Q209-R197*R207*R209-S197*S207*S209-T197*T207*T209)*(1+P47)^5)/T225","v":51.082080856287348},{"$f":"IF(IFERROR(_xll.BDP(TKR,\"EV_TO_T12M_EBITDA\",\"EQY_FUND_RELATIVE_PERIOD\",PER)/1,IFERROR(_xll.BDP(TKR,\"EV_TO_T12M_EBITDA\",\"EQY_FUND_RELATIVE_PERIOD\",\"-0FY\")/1,'Additional Data'!K43))>'Additional Data'!K45,'Additional Data'!K45,IFERROR(_xll.BDP(TKR,\"EV_TO_T12M_EBITDA\",\"EQY_FUND_RELATIVE_PERIOD\",PER)/1,IFERROR(_xll.BDP(TKR,\"EV_TO_T12M_EBITDA\",\"EQY_FUND_RELATIVE_PERIOD\",\"-0FY\")/1,'Additional Data'!K43)))","v":4.02886204256653},{"$f":"IF(ISBLANK(K49),O49,K49)","v":4.02886204256653}," (EBITDA Multiple Method only)"]
[]
[]
[null,null,null,null,{"$f":"\"In Millions of \"&CCY","v":"In Millions of CAD"},null,null,null,{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",I$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" A\"","v":"Févr 10 A"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",J$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" A\"","v":"Févr 11 A"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",K$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" A\"","v":"Févr 12 A"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",L$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" A\"","v":"Févr 13 A"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",M$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" A\"","v":"Févr 14 A"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",N$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" A\"","v":"Févr 15 A"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",O$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" E\"","v":"Févr 16 E"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",P$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" E\"","v":"Févr 17 E"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",Q$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" E\"","v":"Févr 18 E"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",R$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" E\"","v":"Févr 19 E"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",S$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" E\"","v":"Févr 20 E"},{"$f":"PROPER(TEXT(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",T$53),REPT(Dates_M,3)&\" \"&REPT(Dates_Y,2)))&\" E\"","v":"Févr 21 E"},"Year 5"]
[null,null,null,null,null,null,null,null,"-5FY","-4FY","-3FY","-2FY","-1FY","-0FY","1FY","2FY","3FY","4FY","5FY","6FY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[null,null,null,null,"Revenue (Estimate Comparable)",null,null,null,{"$f":"IFERROR(_xll.BDP(TKR,\"IS_COMP_SALES\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY)/1,_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=Y\",\"Fill=0\"))","v":16617.006847678778},{"$f":"IFERROR(_xll.BDP(TKR,\"IS_COMP_SALES\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY)/1,_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=Y\",\"Fill=0\"))","v":20323.487484188721},{"$f":"IFERROR(_xll.BDP(TKR,\"IS_COMP_SALES\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY)/1,_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=Y\",\"Fill=0\"))","v":18356.397527269932},{"$f":"IFERROR(_xll.BDP(TKR,\"IS_COMP_SALES\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY)/1,_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=Y\",\"Fill=0\"))","v":11061.339286188208},{"$f":"IFERROR(_xll.BDP(TKR,\"IS_COMP_SALES\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY)/1,_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=Y\",\"Fill=0\"))","v":7128.9817041387923},{"$f":"IFERROR(_xll.BDP(TKR,\"IS_COMP_SALES\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY)/1,_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=Y\",\"Fill=0\"))","v":3754.077391876624},{"$f":"N55*(1+O$57)","v":2855.1240000000003},2643.5450000000001,2216.8760000000002,1270.2047763770693,850.77257308939613,640.21121259181245]
[null,null,null,null,{"$f":"IF(AND(ADJ=\"Y\",ADJ_AVA=\"Y\"),\"Revenue (Adjusted)\",\"Revenue (GAAP)\")","v":"Revenue (Adjusted)"},null,null,null,{"$f":"_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":16617.006847678778},{"$f":"_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":20323.487484188721},{"$f":"_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":18272.093778090228},{"$f":"_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":11061.339286188208},{"$f":"_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":7128.9817041387923},{"$f":"_xll.BDP(TKR,\"SALES_REV_TURN\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":3754.077391876624}]
[16,null,null,null,"% YoY Growth",null,null,"Edit Row"," ",{"$f":"IFERROR(J55/I55-1,\"\")","v":0.22305344581522513},-9.6788996398829097E-2,-0.39741230436115349,-0.35550465276474896,-0.47340622438445001,{"$f":"IF(ISNUMBER(O$61),O$61,IF(ISNUMBER(O$62),O$62,IF(ISNUMBER(O$63),O$63,\"\")))","v":-0.23946053797981148},-7.4105012601904607E-2,-0.16140031662029575,-0.42702939795592115,-0.33020833419001555,-0.24749429772162934,null,null,10,5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Row # of choice",{"$f":" IF($O$61<>\"\",1, IF($O$62<>\"\",2,3 ))","v":1},{"$f":" IF($P$61<>\"\",1, IF($P$62<>\"\",2,3 ))","v":1},{"$f":" IF($Q$61<>\"\",1, IF($Q$62<>\"\",2,3 ))","v":1},{"$f":" IF($R$61<>\"\",1, IF($R$62<>\"\",2,3 ))","v":2},{"$f":" IF($S$61<>\"\",1, IF($S$62<>\"\",2,3 ))","v":2},{"$f":" IF($T$61<>\"\",1, IF($T$62<>\"\",2,3 ))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on a cell below to select assumption (selected cells are highlighted in blue)"]
[null,1,null,null,null,null,null,"BEst Consensus Revenue ",null,null,null,null,null,null,{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY)/N55)-1,\"\")","v":-0.23946053797981148},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY)/O55)-1,\"\")","v":-7.4105012601904607E-2},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY)/P55)-1,\"\")","v":-0.16140031662029575},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY)/Q55)-1,\"\")","v":""},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY)/R55)-1,\"\")","v":""},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY)/S55)-1,\"\")","v":""}]
[null,1,null,null,null,null,null,"5 Year Moving Trend",null,null,null,null,null,null,{"$f":"IFERROR(SLOPE(DCF!I55:N55,DCF!$O$54:$T$54)/AVERAGE(DCF!I55:N55),\"\")","v":-0.21935054474245577},{"$f":"IFERROR(SLOPE(DCF!J55:O55,DCF!$O$54:$T$54)/AVERAGE(DCF!J55:O55),\"\")","v":-0.41934451970499786},{"$f":"IFERROR(SLOPE(DCF!K55:P55,DCF!$O$54:$T$54)/AVERAGE(DCF!K55:P55),\"\")","v":-0.50188108998095027},{"$f":"IFERROR(SLOPE(DCF!L55:Q55,DCF!$O$54:$T$54)/AVERAGE(DCF!L55:Q55),\"\")","v":-0.42702939795592115},{"$f":"IFERROR(SLOPE(DCF!M55:R55,DCF!$O$54:$T$54)/AVERAGE(DCF!M55:R55),\"\")","v":-0.33020833419001555},{"$f":"IFERROR(SLOPE(DCF!N55:S55,DCF!$O$54:$T$54)/AVERAGE(DCF!N55:S55),\"\")","v":-0.24749429772162934}]
[null,1,null,null,null,null,null,"BEst Consensus EPS Long Term Growth",null,null,null,null,null,null,{"$f":"IFERROR(_xll.BDP(TKR,\"BEST_EST_LONG_TERM_GROWTH\")/100,\"\")","v":-0.20402000000000001},{"$f":"$O$63","v":-0.20402000000000001},{"$f":"$O$63","v":-0.20402000000000001},{"$f":"$O$63","v":-0.20402000000000001},{"$f":"$O$63","v":-0.20402000000000001},{"$f":"$O$63","v":-0.20402000000000001}]
[]
[null,2,null,null,null,null,null,"Input (%) ",null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input"]
[null,2,null,null,">>",null,null,{"$f":"\"Input (\"&CCY&\")\"","v":"Input (CAD)"},null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input",null,null,null,5]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Revenue YoY growth",null,null,null,null,0,0.15,{"$f":"O57","v":-0.23946053797981148},-7.4105012601904607E-2,-0.16140031662029575,-0.42702939795592115,-0.33020833419001555,-0.24749429772162934]
[null,null,61,null,null,null,null,"Number of analysts estimating Revenue",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":26},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":25},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":7},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[null,null,63,null,null,null,null,"Number of analysts estimating EPS LTG Rate",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_LTG_EPS\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":4},{"$f":"O71","v":4},{"$f":"O71","v":4},{"$f":"O71","v":4},{"$f":"O71","v":4},{"$f":"O71","v":4}]
[]
[]
[null,null,null,null,"(-) Cost of Revenue",null,null,null,{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":9300.1370402754674},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":11313.853835323223},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":11737.065503442422},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":7535.0566455086837},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":7066.1989502494152},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":1922.6279416267685},{"$f":"IF(O77=0,0,O55-O77)","v":1562.2953015600001},{"$f":"IF(P77=0,0,P55-P77)","v":1448.5569182000002},882.13929792000022,505.43988461596348,338.53942228373251,254.75284571453403]
[null,null,null,null,"(-) Cost of Revenue (GAAP)",null,null,null,{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=N\",\"Fill=0\")","v":9300.1370402754674},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=N\",\"Fill=0\")","v":11313.853835323223},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=N\",\"Fill=0\")","v":11750.950826836726},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=N\",\"Fill=0\")","v":7630.9555501843879},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=N\",\"Fill=0\")","v":7173.9760110928464},{"$f":"_xll.BDP(TKR,\"IS_COGS_TO_FE_AND_PP_AND_G\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED=N\",\"Fill=0\")","v":1948.5181305362623}]
[null,3,null,null,"% of Revenue",null,null,null,{"$f":"IFERROR(I74/I$55,\"\")","v":0.55967582643047409},{"$f":"IFERROR(J74/J$55,\"\")","v":0.55668860199929671},0.63939917873352059,0.68120653842680401,0.99119330691325414,0.51214392803598197,0.54718999999999995,0.54796,0.39792000000000005,0.39792000000000005,0.39792,0.39792000000000005]
[null,null,null,null,"(=) Gross Profit",null,null,null,{"$f":"_xll.BDP(TKR,\"GROSS_PROFIT\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":7316.8698074033091},{"$f":"_xll.BDP(TKR,\"GROSS_PROFIT\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":9009.6336488654979},{"$f":"_xll.BDP(TKR,\"GROSS_PROFIT\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":6535.028274647806},{"$f":"_xll.BDP(TKR,\"GROSS_PROFIT\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":3526.2826406795243},{"$f":"_xll.BDP(TKR,\"GROSS_PROFIT\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":62.782753889377297},{"$f":"_xll.BDP(TKR,\"GROSS_PROFIT\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":1831.4494502498551},{"$f":"O$55*O78","v":1292.8286984400002},1194.9880817999999,1334.73670208,764.76489176110579,512.23315080566363,385.45836687727842]
[13,null,null,null,"% Margin",null,null,"Edit Row",{"$f":"IF(ISERROR(I77/I$55),\"\",I77/I$55)","v":0.4403241735695258},0.44331139800070329,0.35600821266479366,0.31879346157319605,8.8066930867459273E-3,0.48785607196401792,{"$f":"IF(ISNUMBER(O$82),O$82,IF(ISNUMBER(O$83),O$83,\"\"))","v":0.45280999999999999},0.45204,0.60207999999999995,0.60207999999999995,0.60207999999999995,0.60207999999999995,null,null,8,4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF($O$82<>\"\", 1,2)","v":1},{"$f":" IF($P$82<>\"\", 1,2)","v":1},{"$f":" IF($Q$82<>\"\", 1,2)","v":1},{"$f":" IF($R$82<>\"\", 1,2)","v":2},{"$f":" IF($S$82<>\"\", 1,2)","v":2},{"$f":" IF($T$82<>\"\", 1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on a cell below to select assumption (selected cells are highlighted in blue)"]
[null,1,null,null,null,null,null,"BEst Consensus Gross Margin",null,null,null,null,null,null,{"$f":"IFERROR(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY)/100,\"\")","v":0.45280999999999999},{"$f":"IFERROR(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY)/100,\"\")","v":0.45204},{"$f":"IFERROR(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY)/100,\"\")","v":0.60207999999999995},{"$f":"IFERROR(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY)/100,\"\")","v":""},{"$f":"IFERROR(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY)/100,\"\")","v":""},{"$f":"IFERROR(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY)/100,\"\")","v":""}]
[null,1,null,null,null,null,null,"Last Year's Gross Margin",null,null,null,null,null,null,{"$f":"IF(ISBLANK(N78),\"\",N78)","v":0.48785607196401792},0.45280999999999999,0.45204,0.60207999999999995,0.60207999999999995,0.60207999999999995]
[]
[null,2,null,null,">>",null,null,"Input (%)",null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input",null,null,null,4]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Gross Margin YoY Change",null,null,null,null,-0.05,0.05,{"$f":"IFERROR(O78-N78,\"NA\")","v":-3.5046071964017933E-2},-7.6999999999999291E-4,0.15003999999999995,0,0,0]
[null,null,82,null,null,null,null,"Number of analysts estimating Gross Margin",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":14},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":13},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":3},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[]
[]
[null,null,null,null,"(-) Operating Expenses/Income",null,null,null,{"$f":"IF(AND(I74=0,I77=0),I55-I110,I77-I110)","v":3539.0438369528338},4273.5780684590345,4574.2222496093009,{"$f":"IF(AND(L74=0,L77=0),L55-L110,L77-L110)","v":4205.5665487990927},{"$f":"IF(AND(M74=0,M77=0),M55-M110,M77-M110)","v":4146.800894393371},1855.0883183846104,{"$f":"O$55*O93","v":1542.4466984400001},1505.9690817999999,1703.5437020799998,976.08046058917625,653.77055766260139,491.96607262281782]
[15,null,null,null,"% of Revenue",null,null,"Edit Row",{"$f":"IF(ISERROR(I92/I$55),\"\",I92/I$55)","v":0.21297721481334053},0.21027779173155176,0.24918953965852608,0.38020410006321681,0.58168207837956853,0.49415292353823081,{"$f":"IF(ISNUMBER(O$97),O$97,IF(ISNUMBER(O$98),O$98,\"\"))","v":0.54023807667898138},0.56967786884656768,0.76844338703653237,0.76844338703653237,0.76844338703653237,0.76844338703653237,null,null,8,6]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF($O$97<>\"\", 1,2)","v":1},{"$f":" IF($P$97<>\"\", 1,2)","v":1},{"$f":" IF($Q$97<>\"\", 1,2)","v":1},{"$f":" IF($R$97<>\"\", 1,2)","v":2},{"$f":" IF($S$97<>\"\", 1,2)","v":2},{"$f":" IF($T$97<>\"\", 1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on a cell below to select assumption (selected cells are highlighted in blue)"]
[null,1,null,null,null,null,null,"BEst Consensus Implied Operating Expense as a % of Revenue",null,null,null,null,null,null,{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY)*(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY)/100)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":0.54023807667898138},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY)*(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY)/100)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":0.56967786884656768},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY)*(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY)/100)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":0.76844338703653237},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY)*(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY)/100)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY)*(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY)/100)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY)*(_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY)/100)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""}]
[null,1,null,null,null,null,null,"Last Year's Operating Expense as a % of Revenue",null,null,null,null,null,null,{"$f":"IF(ISBLANK(N93),\"\",N93)","v":0.49415292353823081},0.54023807667898138,0.56967786884656768,0.76844338703653237,0.76844338703653237,0.76844338703653237]
[]
[null,2,null,null,">>",null,null,"Input (%)",null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input",null,null,null,6]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Operating Expenses/Income as a % of Revenue change",null,null,null,null,-0.05,0.05,{"$f":"IFERROR(O93-N93,\"NA\")","v":4.6085153140750568E-2},2.9439792167586298E-2,0.19876551818996469,0,0,0]
[null,null,97,null,null,null,null,"Number of analysts estimating Revenue",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":26},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":25},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":7},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[null,null,97,null,null,null,null,"Number of analysts estimating Gross Margin",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":14},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":13},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":3},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[null,null,97,null,null,null,null,"Number of analysts estimating Operating Profit",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":16},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":15},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":5},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[]
[]
[null,3,null,null,"% YoY Growth",null,null,null,null,{"$f":"IF(ISERROR(J92/I92-1),\"\",J92/I92-1)","v":0.20755160584239762},7.0349523592223129E-2,-8.0594182069246068E-2,-1.3973302698658374E-2,-0.55264591533855434,-0.16853193287145218,-2.3649191039724737E-2,0.13119434035382049,-0.42702939795592121,-0.33020833419001538,-0.24749429772162945]
[null,null,null,null,"(=) Operating Income",null,null,null,{"$f":"_xll.BDP(TKR,\"IS_OPER_INC\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":3777.8259704504753},{"$f":"_xll.BDP(TKR,\"IS_OPER_INC\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":4736.0555804064634},{"$f":"_xll.BDP(TKR,\"IS_OPER_INC\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":1960.8060250385051},{"$f":"_xll.BDP(TKR,\"IS_OPER_INC\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":-679.28390811956842},{"$f":"_xll.BDP(TKR,\"IS_OPER_INC\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":-4084.0181405039934},{"$f":"_xll.BDP(TKR,\"IS_OPER_INC\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")","v":-23.638868134755349},{"$f":"O55-O74-O92","v":-249.61799999999994},{"$f":"P55-P74-P92","v":-310.98099999999999},-368.80699999999979,-211.31556882807047,-141.53740685693776,-106.5077057455394]
[null,3,null,null,"% Margin",null,null,null,{"$f":"IFERROR(I110/I$55,\"\")","v":0.22734695875618527},0.23303360626915154,0.10681867300626756,-6.1410638490020771E-2,-0.57287538529282256,-6.2968515742128925E-3,{"$f":"IFERROR(O110/O$55,\"\")","v":-8.7428076678981337E-2},-0.11763786884656777,-0.16636338703653239,-0.16636338703653242,-0.16636338703653242,-0.16636338703653236]
[null,null,null,null,"(-) Tax on Operating Income",null,null,null,{"$f":"I110*I113","v":1107.1758750022952},1257.7061884955851,377.7669053947493,0,0,0,{"$f":"O110*O113","v":-22.875933783207621},-17.682551028644895,-10.953886391897337,-7.5315058568254321,-6.0534478246809131,-5.4663048078203804]
[12,null,null,null,"% Tax Rate",null,null,"Edit Row",{"$f":"IF(ISERROR(_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100),0,_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100)","v":0.29307222822396806},{"$f":"IF(ISERROR(_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100),0,_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100)","v":0.26555984555984558},{"$f":"IF(ISERROR(_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100),0,_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100)","v":0.19265898848272406},{"$f":"IF(ISERROR(_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100),0,_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100)","v":0},{"$f":"IF(ISERROR(_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100),0,_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100)","v":0},{"$f":"IF(ISERROR(_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100),0,_xll.BDP(TKR,\"EFF_TAX_RATE\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"FA_ADJUSTED\",ADJ,\"Fill=0\")/100)","v":0},{"$f":"IF(ISNUMBER(O$117),O$117,IF(ISNUMBER(O$118),O$118,\"\"))","v":9.1643766808513924E-2},5.6860551058247596E-2,2.9700863573352304E-2,3.5641036288022766E-2,4.276924354562732E-2,5.1323092254752775E-2,null,null,8,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF($O$117<>\"\", 1,2)","v":1},{"$f":" IF($P$117<>\"\", 1,2)","v":1},{"$f":" IF($Q$117<>\"\", 1,2)","v":1},{"$f":" IF($R$117<>\"\", 1,2)","v":1},{"$f":" IF($S$117<>\"\", 1,2)","v":1},{"$f":" IF($T$117<>\"\", 1,2)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on a cell below to select assumption (selected cells are highlighted in blue)"]
[null,1,null,null,null,null,null,"5 Year Rolling Average Effective Tax Rate",null,null,null,null,null,null,{"$f":"AVERAGE(J113:N113)","v":9.1643766808513924E-2},5.6860551058247596E-2,2.9700863573352304E-2,3.5641036288022766E-2,4.276924354562732E-2,5.1323092254752775E-2]
[null,1,null,null,null,null,null,"Last Year's Effective Tax Rate",null,null,null,null,null,null,{"$f":"IF(ISBLANK(N113),\"\",N113)","v":0},9.1643766808513924E-2,5.6860551058247596E-2,2.9700863573352304E-2,3.5641036288022766E-2,4.276924354562732E-2]
[]
[null,2,null,null,">>",null,null,"Input (%)",null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input",null,null,null,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Estimated Tax on Operating Income",null,null,null,null,0,0.5,{"$f":"O113","v":9.1643766808513924E-2},5.6860551058247596E-2,2.9700863573352304E-2,3.5641036288022766E-2,4.276924354562732E-2,5.1323092254752775E-2]
[]
[]
[null,null,null,null,"(=) NOPAT",null,null,null,{"$f":"I110-I112","v":2670.6500954481799},3478.3493919108782,1583.0391196437558,-679.28390811956842,-4084.0181405039934,-23.638868134755349,-226.74206621679232,-293.29844897135513,-357.85311360810243,-203.78406297124505,-135.48395903225685,-101.04140093771902]
[null,3,null,null,"% Margin",null,null,null,{"$f":"IF(ISERROR(I126/I$55),\"\",I126/I$55)","v":0.16071787897356749},{"$f":"IFERROR(J126/J$55,\"\")","v":0.17114923777806179},{"$f":"IFERROR(K126/K$55,\"\")","v":8.6239095513813188E-2},{"$f":"IFERROR(L126/L$55,\"\")","v":-6.1410638490020771E-2},{"$f":"IFERROR(M126/M$55,\"\")","v":-0.57287538529282256},{"$f":"IFERROR(N126/N$55,\"\")","v":-6.2968515742128925E-3},{"$f":"IFERROR(O126/O55,\"\")","v":-7.9415838407295908E-2},-0.11094891479863407,-0.16142225077455952,-0.16043402352216499,-0.1592481508192915,-0.15782510357584328]
[null,null,null,null,"(+) Depreciation & Amortization",null,null,null,{"$f":"_xll.BDP(TKR,\"CF_DEPR_AMORT\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":684.11858021887826},{"$f":"_xll.BDP(TKR,\"CF_DEPR_AMORT\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":946.39437875335022},{"$f":"_xll.BDP(TKR,\"CF_DEPR_AMORT\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":1510.5248235375032},{"$f":"_xll.BDP(TKR,\"CF_DEPR_AMORT\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":1915.9801996666649},{"$f":"_xll.BDP(TKR,\"CF_DEPR_AMORT\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":1328.9016239918194},{"$f":"_xll.BDP(TKR,\"CF_DEPR_AMORT\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":781.20830883429596},{"$f":"O$55*O129","v":722.6149999999999},723.27099999999996,636.55799999999999,364.72902049597474,244.2924582072429,183.83146782455083]
[15,null,null,null,"% of Revenue",null,null,"Edit Row",{"$f":"IF(ISERROR(I128/I$55),\"\",I128/I$55)","v":4.1169783853970215E-2},4.6566534384889731E-2,8.2288740004322458E-2,0.17321412444685269,0.18640833700278878,0.20809595202398801,{"$f":"IF(ISNUMBER(O$133),O$133,IF(ISNUMBER(O$134),O$134,\"\"))","v":0.25309408628136637},0.27359889844886315,0.28714190599744865,0.28714190599744865,0.28714190599744865,0.28714190599744865,null,null,8,6]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF($O$133<>\"\", 1,2)","v":1},{"$f":" IF($P$133<>\"\", 1,2)","v":1},{"$f":" IF($Q$133<>\"\", 1,2)","v":1},{"$f":" IF($R$133<>\"\", 1,2)","v":2},{"$f":" IF($S$133<>\"\", 1,2)","v":2},{"$f":" IF($T$133<>\"\", 1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on a cell below to select assumption (selected cells are highlighted in blue)"]
[null,1,null,null,null,null,null,"BEst Consensus Implied Depreciation & Amortization as a % of Revenue",null,null,null,null,null,null,{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":0.25309408628136637},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":0.27359889844886315},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":0.28714190599744865},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""},{"$f":"IFERROR((_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY)-_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY))/_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""}]
[null,1,null,null,null,null,null,"Last Year's Depreciation & Amortization as a % of Revenue",null,null,null,null,null,null,{"$f":"IF(ISBLANK(N129),\"\",N129)","v":0.20809595202398801},0.25309408628136637,0.27359889844886315,0.28714190599744865,0.28714190599744865,0.28714190599744865]
[]
[null,2,null,null,">>",null,null,"Input (%)",null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input",null,null,null,6]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Depr & Amort as a % of Revenue change",null,null,null,null,-0.05,0.05,{"$f":"O129-N129","v":4.4998134257378364E-2},2.0504812167496778E-2,1.3543007548585506E-2,0,0,0]
[null,null,133,null,null,null,null,"Number of analysts estimating Revenue",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":26},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":25},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":7},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[null,null,133,null,null,null,null,"Number of analysts estimating Operating Profit",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":16},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":15},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":5},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[null,null,133,null,null,null,null,"Number of analysts estimating EBITDA",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":13},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":12},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":4},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[]
[]
[null,3,null,null,"% YoY Growth",null,null,null,null,{"$f":"IFERROR(J128/I128-1,\"\")","v":0.38337768643932879},0.59608389213729351,0.26842020058937166,-0.30641160893885189,-0.41213984938353498,-7.5003437843266019E-2,9.0781398116579481E-4,-0.11989005504160954,-0.42702939795592121,-0.3302083341900155,-0.24749429772162934]
[null,null,null,null,"(-) Capital Expenditure",null,null,null,{"$f":"-_xll.BDP(TKR,\"CF_CAP_EXPEND_PRPTY_ADD\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":1121.7295069047666},{"$f":"-_xll.BDP(TKR,\"CF_CAP_EXPEND_PRPTY_ADD\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":1060.7376046652976},{"$f":"-_xll.BDP(TKR,\"CF_CAP_EXPEND_PRPTY_ADD\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":894.6115501187312},{"$f":"-_xll.BDP(TKR,\"CF_CAP_EXPEND_PRPTY_ADD\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":417.55981410879355},{"$f":"-_xll.BDP(TKR,\"CF_CAP_EXPEND_PRPTY_ADD\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":296.12532251156284},{"$f":"-_xll.BDP(TKR,\"CF_CAP_EXPEND_PRPTY_ADD\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":97.932453701129319},{"$f":"IF(ISNUMBER(O$151),O$151,IF(ISNUMBER(O$152),O$152,\"\"))","v":77.807000000000002},130.47300000000001,191.809,158.82935524253844,131.37016178873355,138.0577034062544]
[15,null,null,null,"% of Revenue",null,null,"Edit Row",{"$f":"IFERROR(I146/I$55,\"\")","v":6.7504907302933473E-2},5.2192696036570042E-2,4.8735681867300623E-2,3.7749480718865712E-2,4.1538235725818273E-2,2.6086956521739129E-2,{"$f":"IFERROR(O146/O$55,\"\")","v":2.7251706055498814E-2},4.935531644061289E-2,8.6522205121080289E-2,0.1250423224635937,0.15441278426700017,0.21564399481125238,null,null,9,5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF($O$151<>\"\",1, IF($O$152<>\"\",2,3 ))","v":1},{"$f":" IF($P$151<>\"\",1, IF($P$152<>\"\",2,3 ))","v":1},{"$f":" IF($Q$151<>\"\",1, IF($Q$152<>\"\",2,3 ))","v":1},{"$f":" IF($R$151<>\"\",1, IF($R$152<>\"\",2,3 ))","v":2},{"$f":" IF($S$151<>\"\",1, IF($S$152<>\"\",2,3 ))","v":2},{"$f":" IF($T$151<>\"\",1, IF($T$152<>\"\",2,3 ))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on a cell below to select assumption (selected cells are highlighted in blue)"]
[null,1,null,null,null,null,null,"BEst Consensus Capital Expenditure",null,null,null,null,null,null,{"$f":"IFERROR(-_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":77.807000000000002},{"$f":"IFERROR(-_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":130.47300000000001},{"$f":"IFERROR(-_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":191.809},{"$f":"IFERROR(-_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""},{"$f":"IFERROR(-_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""},{"$f":"IFERROR(-_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"EQY_FUND_CRNCY\",CCY),\"\")","v":""}]
[null,1,null,null,null,null,null,"5 Year Rolling Average",null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(J146:N146),\"\")","v":553.39334902110295},356.80722808804342,203.97951806429714,158.82935524253844,131.37016178873355,138.0577034062544]
[null,1,null,null,null,null,null,"Last Year's Capital Expenditure",null,null,null,null,null,null,{"$f":"IF(ISBLANK(N146),\"\",N146)","v":97.932453701129319},77.807000000000002,130.47300000000001,191.809,158.82935524253844,131.37016178873355]
[]
[null,2,null,null,">>",null,null,{"$f":"\"Input (\"&CCY&\")\"","v":"Input (CAD)"},null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input",null,null,null,5]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Capex as a % of Revenue YoY change",null,null,null,null,-0.05,0.05,{"$f":"IFERROR(O147-N147,\"NA\")","v":1.1647495337596854E-3},2.2103610385114075E-2,3.71668886804674E-2,3.8520117342513413E-2,2.9370461803406467E-2,6.1231210544252207E-2]
[null,null,151,null,null,null,null,"The ratio Capex / Depr & Amort",null,null,null,null,{"$f":"1/N159","v":0.8},1.25,{"$f":"IFERROR(O146/O128,\"NA\")","v":0.10767421102523475},0.18039296473935776,0.30132211047540053,0.43547221722734109,0.53775774640282625,0.75100147455721233,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AC$82),AC$82,IF(ISNUMBER(AC$83),AC$83,\"NA\"))","v":"NA"},"NA","NA","NA","NA","NA"]
[null,null,151,null,null,null,null,"Number of analysts estimating Capex",null,null,null,null,3,null,{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",O$53,\"Fill=0\")","v":6},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",P$53,\"Fill=0\")","v":6},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",Q$53,\"Fill=0\")","v":2},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",R$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",S$53,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_CONSENSUS_STAT_OVERRIDE=NUMEST\",\"BEST_FPERIOD_OVERRIDE\",T$53,\"Fill=0\")","v":0}]
[]
[]
[null,3,null,null,"% YoY Growth",null,null,null,null,{"$f":"IFERROR(J146/I146-1,\"\")","v":-5.4373092500496378E-2},-0.15661371277488112,-0.53325014185947439,-0.29081939280103097,-0.66928713535700635,-0.20550341526771365,0.67687997223900176,0.47010492592337094,-0.1719400276184202,-0.17288487642522798,5.0906092574321438E-2]
[null,null,null,null,"(-) Changes in Net Working Capital",null,null,null,{"$f":"_xll.BDP(TKR,\"NET_WORKING_CAPITAL_INVESTMENT\",\"EQY_FUND_RELATIVE_PERIOD\",I$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":275.65240259999985},{"$f":"_xll.BDP(TKR,\"NET_WORKING_CAPITAL_INVESTMENT\",\"EQY_FUND_RELATIVE_PERIOD\",J$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":262.37787800000001},{"$f":"_xll.BDP(TKR,\"NET_WORKING_CAPITAL_INVESTMENT\",\"EQY_FUND_RELATIVE_PERIOD\",K$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":169.0335},{"$f":"_xll.BDP(TKR,\"NET_WORKING_CAPITAL_INVESTMENT\",\"EQY_FUND_RELATIVE_PERIOD\",L$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":-597.3261},{"$f":"_xll.BDP(TKR,\"NET_WORKING_CAPITAL_INVESTMENT\",\"EQY_FUND_RELATIVE_PERIOD\",M$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":-1178.9283},{"$f":"_xll.BDP(TKR,\"NET_WORKING_CAPITAL_INVESTMENT\",\"EQY_FUND_RELATIVE_PERIOD\",N$53,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":-434.06229999999999},{"$f":"O$55*O165","v":-178.66119640364724},-205.33148366456484,-210.71188766372381,-131.15953252830832,-77.280816892999439,-54.980321033703369]
[11,null,null,null,"% of Revenue",null,null,"Edit Row",{"$f":"IFERROR(I164/I$55,\"\")","v":1.6588571282830374E-2},1.2910081412165353E-2,9.2084244606757334E-3,-5.4001245648965308E-2,-0.16537120572431305,-0.11562422792328658,{"$f":"IF(ISNUMBER(O$169),O$169,IF(ISNUMBER(O$170),O$170,\"\"))","v":-6.2575634684744766E-2},-7.7672777904126786E-2,-9.5049018377087305E-2,-0.10325857292271171,-9.0836046362391426E-2,-8.5878410050212392E-2,null,null,7,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on a cell below to select assumption (selected cells are highlighted in blue)"]
[null,1,null,null,null,null,null,"5 Year Rolling Average ",null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(J165:N165),0)","v":-6.2575634684744766E-2},{"$f":"AVERAGE(K165:O165)","v":-7.7672777904126786E-2},{"$f":"AVERAGE(L165:P165)","v":-9.5049018377087305E-2},{"$f":"AVERAGE(M165:Q165)","v":-0.10325857292271171},{"$f":"AVERAGE(N165:R165)","v":-9.0836046362391426E-2},{"$f":"AVERAGE(O165:S165)","v":-8.5878410050212392E-2}]
[]
[null,2,null,null,"<<",null,null,"Input (%)",null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input",null,null,null,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Change in NWC as a % of Revenue YoY change",null,null,null,null,-0.05,0.05,{"$f":"O165-N165","v":5.3048593238541816E-2},-1.509714321938202E-2,-1.7376240472960519E-2,-8.2095545456244007E-3,1.2422526560320279E-2,4.957636312179034E-3,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(AC$82),AC$82,IF(ISNUMBER(AC$83),AC$83,\"NA\"))","v":"NA"},"NA","NA","NA","NA","NA"]
[]
[]
[null,null,null,null,"(+) Changes in Net Long Term Deferred Tax Liabilities",null,null,null,{"$f":"IF(ISBLANK('Additional Data'!F55),\"\",'Additional Data'!F55)","v":38.257491399999992},{"$f":"IF(ISBLANK('Additional Data'!G55),\"\",'Additional Data'!G55)","v":121.5165428},{"$f":"IF(ISBLANK('Additional Data'!H55),\"\",'Additional Data'!H55)","v":-41.285999999999973},{"$f":"IF(ISBLANK('Additional Data'!I55),\"\",'Additional Data'!I55)","v":22.552499999999981},{"$f":"IF(ISBLANK('Additional Data'!J55),\"\",'Additional Data'!J55)","v":-216.52770000000001},{"$f":"IF(ISBLANK('Additional Data'!K55),\"\",'Additional Data'!K55)","v":24.686399999999999},{"$f":"O$55*O178","v":-10.2945188460429},-14.599185912497189,-13.694236930276691,-9.9336276459936848,-2.816070695267932,-3.3849228102700386]
[11,null,null,null,"% of Revenue",null,null,"Edit Row",{"$f":"IFERROR(I177/I$55,\"\")","v":2.3023094201435057E-3},5.9791186377110474E-3,-2.2491341200617516E-3,2.0388579914694654E-3,-3.0372879183333149E-2,6.57589000520299E-3,{"$f":"IF(ISNUMBER(O$182),O$182,IF(ISNUMBER(O$183),O$183,\"\"))","v":-3.6056293338022792E-3},-5.5225789281049455E-3,-6.1772678897135834E-3,-7.8204930659501928E-3,-3.3100158424736021E-3,-5.2871970120089203E-3,null,null,7,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click on a cell below to select assumption (selected cells are highlighted in blue)"]
[null,1,null,null,null,null,null,"5 Year Rolling Average ",null,null,null,null,null,null,{"$f":"AVERAGE(J178:N178)","v":-3.6056293338022792E-3},-5.5225789281049455E-3,-6.1772678897135834E-3,-7.8204930659501928E-3,-3.3100158424736021E-3,-5.2871970120089203E-3]
[]
[null,2,null,null,">>",null,null,"Input (%)",null,null,null,null,null,null,"Input","Input","Input","Input","Input","Input",null,null,null,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Change in Net LT Def Tax Liab as a % of Revenue YoY chg",null,null,null,null,-0.05,0.05,{"$f":"O178-N178","v":-1.0181519339005268E-2},-1.9169495943026664E-3,-6.5468896160863783E-4,-1.6432251762366094E-3,4.5104772234765902E-3,-1.9771811695353182E-3]
[]
[]
[null,null,null,null,"(+) Other User Estimated Non-Cash Adjustments",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(O194),O194,0)","v":0},0,0,0,0,0]
[5,null,null,null,"% of Revenue",null,null,"Edit Row",null,null,null,null,null,null,{"$f":"IFERROR(O190/O$55,\"\")","v":0},0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,{"$f":"\"Input (\"&CCY&\")\"","v":"Input (CAD)"},null,null,null,null,null,null,0,0,0,0,0,0]
[]
[]
[null,null,null,null,"(=) Free Cash Flow",null,null,null,{"$f":"I126+I128-I146-I164+I177+I190","v":1995.6442575622916},{"$f":"J126+J128-J146-J164+J177+J190","v":3223.1448307989313},1988.6328930625273,1439.015077438303,-2088.8412390237368,1118.3856869984113,586.43261134081183,490.23184878071243,283.91353712534465,123.34150716450588,51.903083583984007,-3.6722382959892648,{"$f":"T197*T207+S197*(1-T207)","v":11.81596616236394}]
[6,null,null,null,"% Margin",null,null,"Edit Row",{"$f":"IF(ISERROR(I197/I$55),\"\",I197/I$55)","v":0.12009649366191735},{"$f":"IF(ISERROR(J197/J$55),\"\",J197/J$55)","v":0.15859211335192719},0.10833459507009752,0.130094108878401,-0.29300695747487215,0.29791226185652553,{"$f":"IF(ISERROR(O197/O$55),\"\",O197/O$55)","v":0.20539654716951411},0.18544486618563799,0.12806920058918253,9.7103639868451483E-2,6.1007001431074834E-2,-5.735979351443537E-3]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"Free Cash Flow Margin YoY Change",null,null,null,null,-0.05,0.05,{"$f":"O198-N198","v":-9.2515714687011419E-2},{"$f":"P198-O198","v":-1.9951680983876119E-2},-5.7375665596455461E-2,-3.0965560720731047E-2,-3.6096638437376649E-2,-6.6742980782518377E-2]
[]
[]
[null,3,null,null,"% YoY Growth",null,null,null,null,{"$f":"IF(ISERROR(J197/I197-1),\"\",J197/I197-1)","v":0.61508987315006203},{"$f":"IFERROR(K197/J197-1,\"\")","v":-0.38301472708888529},-0.2763797267668664,-2.4515770347189392,-1.5354096166356386,-0.47564367269871466,-0.1640440192098922,-0.42085864508500515,-0.56556665661894101,-0.57919207591035327,-1.0707518328857522]
[]
[null,null,null,null,"% of the Free Cash Flow to be discounted",null,null,null,null,null,null,null,null,null,{"$f":"(IF(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",O$53)-_xll.BToday()<0,0,_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",O$53)-_xll.BToday())/(_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",O$53)-_xll.BDP(TKR,\"BEST_PERIOD_END_DATE\",\"BEST_FPERIOD_OVERRIDE\",N$53)))","v":0.27868852459016391},1,1,1,1,{"$f":"1-O207","v":0.72131147540983609}]
[null,null,null,null,"Period for Discount Factor (Mid-Year Convention)",null,null,null,null,null,null,null,null,null,{"$f":"1*O207/2","v":0.13934426229508196},{"$f":"2-$T$207-0.5","v":0.77868852459016402},{"$f":"3-$T$207-0.5","v":1.778688524590164},{"$f":"4-$T$207-0.5","v":2.778688524590164},{"$f":"5-$T$207-0.5","v":3.778688524590164},{"$f":"IF(T207=0,0,T207/2+4+O207)","v":4.639344262295082}]
[null,null,null,null,{"$f":"\"Discount Factor @ \"&TEXT(P47,\"0.0%\")&\" WACC\"","v":"Discount Factor @ 12.0% WACC"},null,null,null,null,null,null,null,null,null,{"$f":"IF(O208<>0,1/(1+$P$47)^O208,0)","v":0.98428243970686413},{"$f":"1/(1+$P$47)^P208","v":0.91527472951821021},{"$f":"1/(1+$P$47)^Q208","v":0.81691236012356683},{"$f":"1/(1+$P$47)^R208","v":0.7291207575171873},{"$f":"1/(1+$P$47)^S208","v":0.65076390686759145},{"$f":"1/(1+$P$47)^T208","v":0.59010285532723117}]
[null,null,null,null,"Present Value of Free Cash Flow (5 Years)",null,null,null,null,null,null,null,null,null,{"$f":"O197*O209*O207","v":160.86328629576107},448.6968227939787,231.9324776840952,89.930853137096122,33.776653451588579,-1.5630807438005234]
[null,null,null,null,"EBITDA",null,null,null,{"$f":"IF(OR(ISBLANK(I110)+ISBLANK(I128)),\"\",I110+I128)","v":4461.9445506693537},5682.4499591598133,3471.3308485760081,1236.6962915470965,-2755.1165165121738,757.56944069954056,472.99699999999996,412.28999999999996,267.7510000000002,153.41345166790427,102.75505135030514,77.323762079011431,{"$f":"T211*T207+S211*(1-T207)","v":84.41117056445394}]
[7,null,null,null,"% Margin",null,null,"Edit Row",{"$f":"IFERROR(I211/I$55,\"\")","v":0.26851674261015551},0.27960014065404126,0.18910741301059,0.11180348595683193,-0.38646704829003375,0.20179910044977509,0.16566600960238501,0.15596102960229538,0.12077851896091625,0.12077851896091626,0.12077851896091625,0.12077851896091629]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Highlight estimates if…","Less than","Greater than"]
[null,null,null,null,null,null,null,"EBITDA Margin YoY Change",null,null,null,null,-0.05,0.05,{"$f":"O212-N212","v":-3.6133090847390081E-2},-9.7049800000896247E-3,-3.5182510641379131E-2,0,{"$f":"S212-R212","v":0},0]
[]
[]
[null,3,null,null,"% YoY Growth",null,null,null,null,{"$f":"IFERROR(J211/I211-1,\"\")","v":0.27353665977479857},{"$f":"IFERROR(K211/J211-1,\"\")","v":-0.38911369681656349},-0.64374001053388274,-3.2278036534463497,-1.2749682041246597,-0.37563875390322776,-0.128345422909659,-0.35057605083800181,-0.42702939795592121,-0.3302083341900155,-0.24749429772162912]
[]
[null,null,null,null,"Output Analysis"]
[]
[null,null,null,null,"Perpetuity Growth Method - Value per Share",null,null,null,null,null,null,null,null,"EBITDA Multiple Method - Value per Share"]
[null,null,null,null,null,"Free Cash Flow at Year 5",null,null,null,null,{"$f":"U197","v":11.81596616236394},null,null,null,"Terminal EBITDA at Year 5",null,null,null,null,{"$f":"U211","v":84.41117056445394},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BF"]
[null,null,null,null,null,"WACC",null,null,null,null,{"$f":"P47","v":0.12040749313643005},null,null,null,"WACC",null,null,null,null,{"$f":"P47","v":0.12040749313643005}]
[null,null,null,null,null,"Perpetuity Growth Rate",null,null,null,null,{"$f":"P48","v":0.02},null,null,null,"Exit Enterprise Value / EBITDA",null,null,null,null,{"$f":"P49","v":4.02886204256653}]
[null,null,null,null,null,"Perpetuity Value at End of Year 5",null,null,null,null,{"$f":"(K225*(1+K227))/(K226-K227)","v":120.03372566263569},null,null,null,"Terminal Value at End of Year 5",null,null,null,null,{"$f":"T225*T227","v":340.08096105573765}]
[]
[null,null,null,null,null,{"$f":"\"Present Value of Perpetuity  (@ \"&TEXT(P47,\"0.0%\")&\" WACC)\"","v":"Present Value of Perpetuity  (@ 12.0% WACC)"},null,null,null,null,{"$f":"K228/(1+K226)^5","v":67.98659062355361},null,null,null,{"$f":"\"Present Value of Terminal Value  (@ \"&TEXT(P47,\"0.0%\")&\" WACC)\"","v":"Present Value of Terminal Value  (@ 12.0% WACC)"},null,null,null,null,{"$f":"T228/(1+T226)^5","v":192.62040689417879}]
[null,null,null,null,null,{"$f":"\"(+) Present Value of Free Cash Flows  (@ \"&TEXT(P47,\"0.0%\")&\" WACC)\"","v":"(+) Present Value of Free Cash Flows  (@ 12.0% WACC)"},null,null,null,null,{"$f":"SUM($O$210:$T$210)","v":963.63701261871927},null,null,null,{"$f":"\"(+) Present Value of Free Cash Flows  (@ \"&TEXT(P47,\"0.0%\")&\" WACC)\"","v":"(+) Present Value of Free Cash Flows  (@ 12.0% WACC)"},null,null,null,null,{"$f":"SUM($O$210:$T$210)","v":963.63701261871927}]
[null,null,null,null,null,"(=) Current Enterprise Value",null,null,null,{"$f":"K231+K230","v":1031.6236032422728},null,null,null,null,"(=) Current Enterprise Value",null,null,null,{"$f":"SUM(T230:T231)","v":1156.257419512898}]
[]
[null,null,null,null,null,"Short Term Debt",null,null,null,null,{"$f":"_xll.BDP(TKR,\"BS_ST_BORROW\", \"FUND_PER\",PER,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},null,null,null,"Short Term Debt",null,null,null,null,{"$f":"_xll.BDP(TKR,\"BS_ST_BORROW\", \"FUND_PER\",PER,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0}]
[null,null,null,null,null,"(+) Long Term Debt",null,null,null,null,{"$f":"_xll.BDP(TKR,\"BS_LT_BORROW\", \"FUND_PER\",PER,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":2135.2862999999998},null,null,null,"(+) Long Term Debt",null,null,null,null,{"$f":"_xll.BDP(TKR,\"BS_LT_BORROW\", \"FUND_PER\",PER,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":2135.2862999999998}]
[null,null,null,null,null,"(-) Cash and Marketable Securities",null,null,null,null,{"$f":"IF(J236<>\"\",J236,_xll.BDP(TKR,\"CASH_AND_MARKETABLE_SECURITIES\",\"FUND_PER\",PER,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\"))","v":3616.3518999999997},null,null,null,"(-) Cash and Marketable Securities",null,null,null,null,{"$f":"IF(S236<>\"\",S236,_xll.BDP(TKR,\"CASH_AND_MARKETABLE_SECURITIES\", \"FUND_PER\",PER,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\"))","v":3616.3518999999997}]
[null,null,null,null,null,"(-) Current Net Debt",null,null,null,null,{"$f":"SUM(K234:K235)-SUM(K236)","v":-1481.0655999999999},null,null,null,"(-) Current Net Debt",null,null,null,null,{"$f":"SUM(T234:T235)-SUM(T236)","v":-1481.0655999999999}]
[null,null,null,null,null,"(-) Current Preferred and Minority Interest",null,null,null,null,{"$f":"_xll.BDP(TKR,\"PREFERRED_EQUITY_&_MINORITY_INT\", \"FUND_PER\",PER,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},null,null,null,"(-) Current Preferred and Minority Interest",null,null,null,null,{"$f":"_xll.BDP(TKR,\"PREFERRED_EQUITY_&_MINORITY_INT\", \"FUND_PER\",PER,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0}]
[null,null,null,null,null,"(=) Equity Value",null,null,null,null,{"$f":"SUM(J232,-K237,-K238)","v":2512.6892032422729},null,null,null,{"$f":"F239","v":"(=) Equity Value"},null,null,null,null,{"$f":"SUM(S232,-T237,-T238)","v":2637.3230195128981}]
[]
[null,null,null,null,null,"Shares outstanding",null,null,null,null,{"$f":"IFERROR(_xll.BDP(TKR,\"CRNCY_ADJ_MKT_CAP\", \"SCALING_FORMAT=MLN\", \"EQY_FUND_CRNCY\",CCY,\"Fill=0\")/_xll.BDP(TKR,\"PX_LAST\", \"SCALING_FORMAT=MLN\", \"EQY_FUND_CRNCY\",CCY,\"Fill=0\"),_xll.BDP(TKR,\"EQY_SH_OUT_TOT_MULT_SH\", \"EQY_FUND_CRNCY\",CCY,\"Fill=0\"))","v":525.30006600000002},null,null,null,"Shares outstanding",null,null,null,null,{"$f":"IFERROR(_xll.BDP(TKR,\"CRNCY_ADJ_MKT_CAP\", \"SCALING_FORMAT=MLN\", \"EQY_FUND_CRNCY\",CCY,\"Fill=0\")/_xll.BDP(TKR,\"PX_LAST\", \"SCALING_FORMAT=MLN\", \"EQY_FUND_CRNCY\",CCY,\"Fill=0\"),_xll.BDP(TKR,\"EQY_SH_OUT_TOT_MULT_SH\", \"EQY_FUND_CRNCY\",CCY,\"Fill=0\"))","v":525.30006600000002}]
[null,null,null,null,null,{"$f":"\"Estimated Value per Share (\"&CCY&\")\"","v":"Estimated Value per Share (CAD)"},null,null,null,{"$f":"K239/K241","v":4.7833407339459058},null,null,null,null,{"$f":"\"Estimated Value per Share (\"&CCY&\")\"","v":"Estimated Value per Share (CAD)"},null,null,null,{"$f":"T239/T241","v":5.0206028710319979}]
[null,null,null,null,null,{"$f":"\"Current Price (\"&CCY&\")\"","v":"Current Price (CAD)"},null,null,null,null,{"$f":"_xll.BDP(TKR,\"CRNCY_ADJ_PX_LAST\",\"EQY_FUND_CRNCY\",CCY,\"Fill=B\")","v":10.15},null,null,null,{"$f":"\"Current Price (\"&_xll.BDP(TKR,\"CRNCY\",\"Fill=b\")&\")\"","v":"Current Price (CAD)"},null,null,null,null,{"$f":"_xll.BDP(TKR,\"PX_LAST\",\"Fill=B\")","v":10.15}]
[null,null,null,null,null,"Estimated Upside ",null,null,null,{"$f":"IFERROR(J242/K243-1,\"\")","v":-0.52873490305951676},null,null,null,null,"Estimated Upside ",null,null,null,{"$f":"IFERROR(S242/T243-1,\"\")","v":-0.5053593230510347}]
[]
[]
[null,null,null,null,"Perpetuity Growth Method - Sensitivity Analysis",null,null,null,null,null,null,null,null,"EBITDA Multiple Method - Sensitivity Analysis"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Enterprise Value in Millions of \"&CCY","v":"Enterprise Value in Millions of CAD"},null,null,null,null,null,null,null,null,{"$f":"\"Enterprise Value in Millions of \"&CCY","v":"Enterprise Value in Millions of CAD"}]
[null,null,null,null,null,"Incremental change",null,null,null,"Perpetuity Growth",null,null,null,"Incremental change",null,null,null,null,"Terminal EBITDA Multiple"]
[null,null,null,null,null,5.0000000000000001E-3,null,null,null,null,null,null,null,1.5,5.0000000000000001E-3]
[null,null,null,null,null,null,null,{"$f":"H276","v":9.9999999999999985E-3},{"$f":"I276","v":1.4999999999999999E-2},{"$f":"J276","v":0.02},{"$f":"K276","v":2.5000000000000001E-2},{"$f":"L276","v":3.0000000000000002E-2},null,null,null,null,{"$f":"Q276","v":1.02886204256653},{"$f":"R276","v":2.52886204256653},{"$f":"S276","v":4.02886204256653},{"$f":"T276","v":5.52886204256653},{"$f":"U276","v":7.02886204256653}]
[null,null,null,null,null,null,{"$f":"G277","v":0.11040749313643004},{"$f":"IFERROR((($K$225*(1+H$252))/($G253-H$252))/(1+$G253)^5+\n($O$197*$O$207)/(1+$G253)^$O$208 + ($P$197*$P$207)/(1+$G253)^$P$208 + ($Q$197*$Q$207)/(1+$G253)^$Q$208 + ($R$197*$R$207)/(1+$G253)^$R$208 + ($S$197*$S$207)/(1+$G253)^$S$208 + ($T$197*$T$207)/(1+$G253)^$T$208,\"-\")","v":1044.4821699931119},1048.538759835179,1053.0440502994329,1058.0768460561155,1063.7355531004616,null,null,null,{"$f":"P277","v":0.11040749313643004},{"$f":"IFERROR(($T$225*Q$252)/(1+$P253)^5+\n($O$197*$O$207)/(1+$P253)^$O$208 + ($P$197*$P$207)/(1+$P253)^$P$208 + ($Q$197*$Q$207)/(1+$P253)^$Q$208 + ($R$197*$R$207)/(1+$P253)^$R$208 + ($S$197*$S$207)/(1+$P253)^$S$208 + ($T$197*$T$207)/(1+$P253)^$T$208,\"-\")","v":1025.5209344513321},1100.5240429379362,1175.5271514245401,1250.530259911144,1325.5333683977481]
[null,null,null,null,"Discount",null,{"$f":"G278","v":0.11540749313643005},1034.3997739153297,1038.0061200124321,1041.9904601201251,1046.4155092851615,1051.3586686302926,null,"Discount",null,{"$f":"P278","v":0.11540749313643005},1019.1252713702032,1092.4623141231175,1165.7993568760317,1239.136399628946,1312.4734423818602]
[null,null,null,null,"Rate",null,{"$f":"G279","v":0.12040749313643005},{"$f":"IFERROR((($K$225*(1+H$252))/($G255-H$252))/(1+$G255)^5+\n($O$197*$O$207)/(1+$G255)^$O$208 + ($P$197*$P$207)/(1+$G255)^$P$208 + ($Q$197*$Q$207)/(1+$G255)^$Q$208 + ($R$197*$R$207)/(1+$G255)^$R$208 + ($S$197*$S$207)/(1+$G255)^$S$208 + ($T$197*$T$207)/(1+$G255)^$T$208,\"-\")","v":1024.8596507807131},1028.0812031113437,1031.6236032422728,1035.5372949787641,1039.8838813350171,null,"Rate",null,{"$f":"P279","v":0.12040749313643005},1012.8270377879338,1084.5422286504158,1156.257419512898,1227.9726103753799,1299.687801237862]
[null,null,null,null,"(WACC)",null,{"$f":"G280","v":0.12540749313643004},{"$f":"IFERROR((($K$225*(1+H$252))/($G256-H$252))/(1+$G256)^5+\n($O$197*$O$207)/(1+$G256)^$O$208 + ($P$197*$P$207)/(1+$G256)^$P$208 + ($Q$197*$Q$207)/(1+$G256)^$Q$208 + ($R$197*$R$207)/(1+$G256)^$R$208 + ($S$197*$S$207)/(1+$G256)^$S$208 + ($T$197*$T$207)/(1+$G256)^$T$208,\"-\")","v":1015.7976790743057},1018.6881424884327,1021.8528239233208,1025.3326891493816,1029.1772914743499,null,"(WACC)",null,{"$f":"P280","v":0.12540749313643004},1006.6240503125689,1076.7602402663069,1146.896430220045,1217.0326201737828,1287.1688101275208]
[null,null,null,null,null,null,{"$f":"G281","v":0.13040749313643005},{"$f":"IFERROR((($K$225*(1+H$252))/($G257-H$252))/(1+$G257)^5+\n($O$197*$O$207)/(1+$G257)^$O$208 + ($P$197*$P$207)/(1+$G257)^$P$208 + ($Q$197*$Q$207)/(1+$G257)^$Q$208 + ($R$197*$R$207)/(1+$G257)^$R$208 + ($S$197*$S$207)/(1+$G257)^$S$208 + ($T$197*$T$207)/(1+$G257)^$T$208,\"-\")","v":1007.1602479212037},1009.7640718290829,1012.6037333448917,1015.712793309645,1019.1314974919397,null,null,null,{"$f":"P281","v":0.13040749313643005},1000.5141882043972,1069.1129131693206,1137.7116381342439,1206.3103630991673,1274.9090880640906]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Value in \"&CCY","v":"Value in CAD"},null,null,null,null,null,null,null,null,{"$f":"\"Value in \"&CCY","v":"Value in CAD"}]
[null,null,null,null,null,null,null,{"$f":"H276","v":9.9999999999999985E-3},{"$f":"I276","v":1.4999999999999999E-2},{"$f":"J276","v":0.02},{"$f":"K276","v":2.5000000000000001E-2},{"$f":"L276","v":3.0000000000000002E-2},null,null,null,null,{"$f":"Q276","v":1.02886204256653},{"$f":"R276","v":2.52886204256653},{"$f":"S276","v":4.02886204256653},{"$f":"T276","v":5.52886204256653},{"$f":"U276","v":7.02886204256653}]
[null,null,null,null,null,null,{"$f":"G277","v":0.11040749313643004},{"$f":"IFERROR((H253-SUM($K$237:$K$238))/$K$241,\"-\")","v":4.8078192512412734},4.8155416752511488,4.8241182789027723,4.8336990805862863,4.8444714132216786,null,null,null,{"$f":"P277","v":0.11040749313643004},{"$f":"IFERROR((Q253-SUM($T$237:$T$238))/$T$241,\"-\")","v":4.7717232429423149},4.9145046993729791,5.0572861558036433,5.2000676122343066,5.3428490686649708]
[null,null,null,null,null,null,{"$f":"G278","v":0.11540749313643005},4.7886256574643751,4.7954909642300176,4.8030758483097635,4.8114996986982321,4.8209098618889046,null,null,null,{"$f":"P278","v":0.11540749313643005},4.7595479863697623,4.8991577970277991,5.0387676076858359,5.1783774183438727,5.3179872290019086]
[null,null,null,null,null,null,{"$f":"G279","v":0.12040749313643005},4.7704643745099267,4.7765971594439955,4.7833407339459058,4.7907911265687222,4.7990656093597694,null,null,null,{"$f":"P279","v":0.12040749313643005},4.7475582037865838,4.8840805374092904,5.0206028710319979,5.1571252046547045,5.293647538277412]
[null,null,null,null,null,null,{"$f":"G280","v":0.12540749313643004},4.7532133359265671,4.7587158355476626,4.7647403568445785,4.7713648852832646,4.7786837541999274,null,null,null,{"$f":"P280","v":0.12540749313643004},4.7357497387266063,4.8692661696073474,5.0027826004880884,5.1362990313688295,5.2698154622495723]
[null,null,null,null,null,null,{"$f":"G281","v":0.13040749313643005},4.7367704840935687,4.7417273155817252,4.7471331049573706,4.7530517411159909,4.7595598388749094,null,null,null,{"$f":"P281","v":0.13040749313643005},4.7241185539930948,4.854708152976551,4.9852977519600081,5.1158873509434644,5.2464769499269215]
[]
[null,null,null,null,null,null,null,null,null,"Upside Potential",null,null,null,null,null,null,null,null,"Upside Potential"]
[null,null,null,null,null,null,null,{"$f":"H276","v":9.9999999999999985E-3},{"$f":"I276","v":1.4999999999999999E-2},{"$f":"J276","v":0.02},{"$f":"K276","v":2.5000000000000001E-2},{"$f":"L276","v":3.0000000000000002E-2},null,null,null,null,{"$f":"Q276","v":1.02886204256653},{"$f":"R276","v":2.52886204256653},{"$f":"S276","v":4.02886204256653},{"$f":"T276","v":5.52886204256653},{"$f":"U276","v":7.02886204256653}]
[null,null,null,null,null,null,{"$f":"G277","v":0.11040749313643004},{"$f":"IFERROR(H261/$K$243-1,\"-\")","v":-0.52632322647869234},-0.52556239652698045,-0.5247174109455397,-0.52377348959741021,-0.52271217603727305,null,null,null,{"$f":"P277","v":0.11040749313643004},{"$f":"IFERROR(Q261/$T$243-1,\"-\")","v":-0.52987948345395908},-0.51581234488936167,-0.50174520632476427,-0.48767806776016687,-0.47361092919556935]
[null,null,null,null,null,null,{"$f":"G278","v":0.11540749313643005},-0.52821422093947046,-0.52753783603645155,-0.52679055681677212,-0.52596062081790818,-0.52503351114395036,null,null,null,{"$f":"P278","v":0.11540749313643005},-0.53107901612120578,-0.51732435497263063,-0.50356969382405559,-0.48981503267548054,-0.47606037152690561]
[null,null,null,null,null,null,{"$f":"G279","v":0.12040749313643005},-0.53000350990049983,-0.5293992946360595,-0.52873490305951676,-0.52800087422968256,-0.52718565425026909,null,null,null,{"$f":"P279","v":0.12040749313643005},-0.53226027548900656,-0.51880979927002069,-0.5053593230510347,-0.49190884683204883,-0.47845837061306284]
[null,null,null,null,null,null,{"$f":"G280","v":0.12540749313643004},-0.53170311961314609,-0.53116100142387568,-0.53056745252762783,-0.52991478962726457,-0.52919371879803667,null,null,null,{"$f":"P280","v":0.12540749313643004},-0.53342367106141819,-0.52026934289582782,-0.50711501473023768,-0.49396068656464731,-0.48080635839905694]
[null,null,null,null,null,null,{"$f":"G281","v":0.13040749313643005},-0.53332310501541191,-0.53283474723332758,-0.53230215714705709,-0.53171904028413886,-0.53107784838670846,null,null,null,{"$f":"P281","v":0.13040749313643005},-0.53456960059181335,-0.52170363024861566,-0.50883765990541796,-0.49597168956222026,-0.48310571921902257]
[]
[null,null,null,null,null,null,null,null,null,"Implied Exit EV / EBITDA Multiple",null,null,null,null,null,null,null,null,"Implied Perpetuity Growth"]
[null,null,null,null,null,null,null,{"$f":"IF(H251<>\"\",H$251,I276-F251)","v":9.9999999999999985E-3},{"$f":"IF(I251<>\"\",I$251,J276-F251)","v":1.4999999999999999E-2},{"$f":"IF(J251<>\"\",J251,K227)","v":0.02},{"$f":"IF(K251<>\"\",K$251,J276+F251)","v":2.5000000000000001E-2},{"$f":"IF(L251<>\"\",L$251,K276+F251)","v":3.0000000000000002E-2},null,null,null,null,{"$f":"IF(Q251<>\"\",Q251,R276-N251)","v":1.02886204256653},{"$f":"IF(R251<>\"\",R251,S276-N251)","v":2.52886204256653},{"$f":"IF(S251<>\"\",S251,T227)","v":4.02886204256653},{"$f":"IF(T251<>\"\",T251,S276+N251)","v":5.52886204256653},{"$f":"IF(U251<>\"\",U251,T276+N251)","v":7.02886204256653}]
[null,null,null,null,null,null,{"$f":"IF(F253<>\"\",F253,G278-F251)","v":0.11040749313643004},{"$f":"IFERROR((($K$225*(1+H$276))/($G277-H$276))/$T$225,\"-\")","v":1.4080710365210884},1.4891994708737439,1.5793015457442519,1.6799532892166213,1.793122739627272,null,null,null,{"$f":"IF(O253<>\"\",O253,P278-O251)","v":0.11040749313643004},{"$f":"IFERROR((Q$276*$T$225*$P277-$K$225)/(Q$276*$T$225+$K$225),\"-\")","v":-2.2575307991567203E-2},5.216651575496524E-2,7.3122321398617532E-2,8.2988136429008291E-2,8.8725329223245886E-2]
[null,null,null,null,null,null,{"$f":"IF(F254<>\"\",F254,G279-F251)","v":0.11540749313643005},1.3412792461737644,1.4150416852167373,1.4965354288583437,1.5870432199880962,1.6881481833103609,null,null,null,{"$f":"IF(O254<>\"\",O254,P279-O251)","v":0.11540749313643005},-1.8174109791581978E-2,5.6904265285018581E-2,7.7954431808677449E-2,8.7864671138667111E-2,9.3627697659845938E-2]
[null,null,null,null,null,null,{"$f":"IF(F255<>\"\",F255,K226)","v":0.12040749313643005},1.280537026236013,1.347919242441951,1.4220123339123865,1.5038713868429434,1.5947848942319407,null,null,null,{"$f":"IF(O255<>\"\",O255,T226)","v":0.12040749313643005},-1.3772911591596753E-2,6.1642014815071922E-2,8.278654221873738E-2,9.2741205848325944E-2,9.8530066096446003E-2]
[null,null,null,null,null,null,{"$f":"IF(F256<>\"\",F256,G279+F251)","v":0.12540749313643004},1.225058088454988,1.286876318445102,1.3545592387101384,1.4289829826080354,1.5112073448275432,null,null,null,{"$f":"IF(O256<>\"\",O256,P279+O251)","v":0.12540749313643004},-9.3717133916115282E-3,6.6379764345125256E-2,8.7618652628797283E-2,9.761774055798475E-2,0.10343243453304604]
[null,null,null,null,null,null,{"$f":"IF(F257<>\"\",F257,G280+F251)","v":0.13040749313643005},1.1741867491162097,1.2311227324572402,1.2932156106541914,1.3611992349783251,1.4359536313036845,null,null,null,{"$f":"IF(O257<>\"\",O257,P280+O251)","v":0.13040749313643005},-4.9705151916263051E-3,7.111751387517859E-2,9.2450763038857228E-2,0.10249427526764358,0.10833480296964611]

{"sheet":"Sheet1","index":1,"n_rows":64,"n_cols":103,"rows_kept":64,"cut":false,"hidden":true,"merged":[[32,16,32,23],[34,14,47,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,1,{"$f":"C25+1","v":2},{"$f":"D25+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,{"$f":"BP25+1","v":67},68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,{"$f":"CX25+1","v":101}]
[null,null,1,{"$f":"C26*(1+C27)","v":1.05},{"$f":"D26*(1+D27)","v":1.0996363636363637},1.1486201652892563,1.1966533722013524,1.2434316403874053,1.2886473364014928,1.3319927468077248,1.3731634317090546,1.4118616738754006,1.4477999710285925,1.4807045158246968,1.5103186061411906,1.5405249782640145,1.5713354778292947,1.6027621873858806,1.6348174311335983,1.6675137797562702,1.7008640553513956,1.7348813364584235,1.769578963187592,1.8049705424513438,1.8410699533003707,1.8778913523663781,1.9154491794137056,1.9537581630019798,1.9928333262620195,2.0326899927872599,2.0733437926430049,2.1148106684958652,2.1571068818657824,2.2002490195030981,2.2442539998931603,2.2891390798910236,2.3349218614888443,2.3816202987186212,2.4292527046929937,2.4778377587868534,2.5273945139625904,2.5779424042418424,2.6295012523266794,2.6820912773732131,2.7357331029206775,2.7904477649790911,2.846256720278673,2.9031818546842465,2.9612454917779316,3.0204704016134905,3.0808798096457601,3.1424974058386752,3.2053473539554487,3.2694543010345578,3.334843387055249,3.401540254796354,3.4695710598922811,3.5389624810901266,3.6097417307119293,3.681936565326168,3.7555752966326912,3.8306868025653449,3.9073005386166519,3.985446549388985,4.0651554803767649,4.1464585899843005,4.229387761783987,4.3139755170196672,{"$f":"BP26*(1+BP27)","v":4.4002550273600605},4.488260127907262,4.5780253304654073,4.6695858370747159,4.76297755381621,4.8582371048925346,4.9554018469903856,5.0545098839301934,5.1556000816087977,5.2587120832409742,5.3638863249057938,5.4711640514039095,5.5805873324319881,5.6921990790806278,5.8060430606622404,5.9221639218754856,6.0406072003129951,6.1614193443192553,6.2846477312056406,6.4103406858297536,6.5385474995463486,6.6693184495372755,6.8027048185280208,6.9387589148985809,7.0775340931965527,7.2190847750604838,7.3634664705616935,7.5107357999729274,7.6609505159723863,7.8141695262918338,7.9704529168176705,8.1298619751540233,8.2924592146571037,8.4583083989502459,{"$f":"CX26*(1+CX27)","v":8.6274745669292514}]
[null,null,0.05,{"$f":"C27-($C$27-$N$27)/11","v":4.7272727272727272E-2},{"$f":"D27-($C$27-$N$27)/11","v":4.4545454545454541E-2},4.181818181818181E-2,3.9090909090909079E-2,3.6363636363636348E-2,3.3636363636363617E-2,3.090909090909089E-2,2.8181818181818162E-2,2.5454545454545435E-2,2.2727272727272707E-2,0.02,{"$f":"N27","v":0.02},{"$f":"O27","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,{"$f":"CA27","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,{"$f":"NPV(B29,C26:CL26)","v":35.842082194929368}]
["Discount rate",0.05,1,{"$f":"C29*(1+C30)","v":1.026},{"$f":"D29*(1+D30)","v":1.0526759999999999},1.0800455760000001,1.1081267609760002,1.1369380567613763,1.1664984462371721,1.1968274058393387,1.2279449183911615,1.2598714862693317,1.2926281449123342,1.326236476680055,1.3607186250737364,1.3960973093256537,1.4323958393681206,1.4696381311916917,1.5078487226026758,1.5470527893903454,1.5872761619144944,1.6285453421242713,1.6708875210195024,1.7143305965660096,1.758903192076726,1.804634675070721,1.8515551766225598,1.8996956112147463,1.9490876971063298,1.9997639772310944,2.051757840639103,2.1051035444957198,2.1598362366526085,2.2159919788055764,2.2736077702545217,2.3327215722811392,2.3933723331604488,2.4556000138226204,2.5194456141820085,2.5849512001507406,2.6521599313546598,2.7211160895698812,2.791865107898698,2.8644536007040644,2.9389293943223702,3.0153415585747521,3.0937404390976955,3.1741776905142358,3.2567063104676062,3.3413806745397641,3.4282565720777982,3.5173912429518213,3.6088434152685687,3.7026733440655515,3.798942851011256,3.8977153651375489,3.9990559646311254,4.1030314197115345,4.2097102366240344,4.3191627027762598,4.4314609330484425,4.5466789173077018,4.6648925691577023,4.7861797759558025,4.9106204501306534,5.0382965818340502,5.1692922929617353,5.3036938925787407,{"$f":"BP29*(1+BP30)","v":5.4415899337857878},5.5830712720642186,5.7282311251378886,5.8771651343914737,6.029971427885652,6.1867506850106793,6.3476062028209572,6.5126439640943019,6.681972707160754,6.855703997546934,7.0339523014831542,7.2168350613217163,7.4044727729160806,7.5969890650118987,7.7945107807022085,7.9971680610004663,8.2050944305864792,8.4184268857817273,8.6373059848120519,8.8618759404171659,9.092284714868013,9.328684117454582,9.5712299045084013,9.8200818820256206,10.075404010958287,10.337364515243204,10.606135992639528,10.881895528448156,11.164824812187808,11.455110257304691,11.752943123994614,12.058519645218475,12.372041155994156,12.693714226050004,13.023750795927304]
[null,null,2.5999999999999999E-2,{"$f":"C30","v":2.5999999999999999E-2},{"$f":"D30","v":2.5999999999999999E-2},2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,{"$f":"BP30","v":2.5999999999999999E-2},2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,{"$f":"CX30","v":2.5999999999999999E-2}]
[null,{"$f":"NPV(B29,C29:CL29)","v":36.220408948510673}]
[]
[null,null,{"$f":"1/(B29-C30)","v":41.666666666666657},null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,0.11,0.1,0.09,0.08,7.0000000000000007E-2,0.06,0.05]
[null,"dr","start growth","perp",null,"start growth","perp",null,"start growth","perp",null,"start growth","perp",null,"Start growth",0.15,6.2E-2,{"$f":"Q35-($Q35-$T35)/3","v":5.8999999999999997E-2},{"$f":"R35-($Q35-$T35)/3","v":5.5999999999999994E-2},5.2999999999999999E-2,{"$f":"T35-($T35-$X35)/4","v":0.05},{"$f":"U35-($T35-$X35)/4","v":4.7E-2},{"$f":"V35-($T35-$X35)/4","v":4.3999999999999997E-2},4.1000000000000002E-2]
[null,0.12,0.15,6.2E-2,null,0.1,4.8000000000000001E-2,null,0.05,3.2000000000000001E-2,null,0.02,0.02,null,null,0.14000000000000001,{"$f":"Q35-(Q$35-Q$40)/5","v":5.9200000000000003E-2},{"$f":"R35-(R$35-R$40)/5","v":5.6399999999999999E-2},5.3599999999999995E-2,5.0799999999999998E-2,4.8000000000000001E-2,4.5199999999999997E-2,4.24E-2,3.9600000000000003E-2]
[null,0.11,0.15,{"$f":"D36-(D$36-D$39)/3","v":5.8999999999999997E-2},null,{"$f":"F36","v":0.1},{"$f":"G36-(G$36-G$39)/3","v":4.5999999999999999E-2},null,{"$f":"I36","v":0.05},{"$f":"J36-(J$36-J$39)/3","v":3.1E-2},null,{"$f":"L36","v":0.02},0.02,null,null,0.13,{"$f":"Q36-(Q$35-Q$40)/5","v":5.6400000000000006E-2},5.3800000000000001E-2,5.1199999999999996E-2,4.8599999999999997E-2,4.5999999999999999E-2,4.3399999999999994E-2,4.0800000000000003E-2,3.8200000000000005E-2]
[null,0.1,0.15,{"$f":"D37-(D$36-D$39)/3","v":5.5999999999999994E-2},null,{"$f":"F37","v":0.1},{"$f":"G37-(G$36-G$39)/3","v":4.3999999999999997E-2},null,{"$f":"I37","v":0.05},{"$f":"J37-(J$36-J$39)/3","v":0.03},null,{"$f":"L37","v":0.02},0.02,null,null,0.12,{"$f":"Q37-(Q$35-Q$40)/5","v":5.3600000000000009E-2},5.1200000000000002E-2,4.8799999999999996E-2,4.6399999999999997E-2,4.3999999999999997E-2,4.1599999999999991E-2,3.9200000000000006E-2,3.6800000000000006E-2]
[null,0.09,0.15,5.2999999999999999E-2,null,0.1,4.2000000000000003E-2,null,0.05,2.9000000000000001E-2,null,0.02,0.02,null,null,0.11,{"$f":"Q38-(Q$35-Q$40)/5","v":5.0800000000000012E-2},4.8600000000000004E-2,4.6399999999999997E-2,4.4199999999999996E-2,4.1999999999999996E-2,3.9799999999999988E-2,3.7600000000000008E-2,3.5400000000000008E-2]
[null,0.08,0.15,{"$f":"D39-(D$39-D$43)/4","v":0.05},null,0.1,{"$f":"G39-(G$39-G$43)/4","v":0.04},null,0.05,2.8000000000000001E-2,null,0.02,0.02,null,null,0.1,4.8000000000000001E-2,{"$f":"Q40-($Q40-$T40)/3","v":4.5999999999999999E-2},{"$f":"R40-($Q40-$T40)/3","v":4.3999999999999997E-2},4.2000000000000003E-2,{"$f":"T40-($T40-$X40)/4","v":0.04},{"$f":"U40-($T40-$X40)/4","v":3.7999999999999999E-2},{"$f":"V40-($T40-$X40)/4","v":3.5999999999999997E-2},3.4000000000000002E-2]
[null,7.0000000000000007E-2,0.15,{"$f":"D40-(D$39-D$43)/4","v":4.7E-2},null,0.1,{"$f":"G40-(G$39-G$43)/4","v":3.7999999999999999E-2},null,0.05,{"$f":"J40-(J$39-J$43)/4","v":2.725E-2},null,0.02,0.02,null,null,9.0000000000000094E-2,{"$f":"Q40-(Q$40-Q$45)/5","v":4.48E-2},{"$f":"R40-(R$40-R$45)/5","v":4.2999999999999997E-2},4.1200000000000001E-2,3.9400000000000004E-2,3.7600000000000001E-2,3.585E-2,3.4099999999999998E-2,3.2399999999999998E-2]
[null,0.06,0.15,{"$f":"D41-(D$39-D$43)/4","v":4.3999999999999997E-2},null,0.1,{"$f":"G41-(G$39-G$43)/4","v":3.5999999999999997E-2},null,0.05,{"$f":"J41-(J$39-J$43)/4","v":2.6499999999999999E-2},null,0.02,0.02,null,null,8.0000000000000099E-2,{"$f":"Q41-(Q$40-Q$45)/5","v":4.1599999999999998E-2},3.9999999999999994E-2,3.8400000000000004E-2,3.6800000000000006E-2,3.5200000000000002E-2,3.3700000000000001E-2,3.2199999999999999E-2,3.0799999999999998E-2]
[null,0.05,0.15,4.1000000000000002E-2,null,0.1,3.4000000000000002E-2,null,0.05,2.5999999999999999E-2,null,0.02,0.02,null,null,7.0000000000000201E-2,{"$f":"Q42-(Q$40-Q$45)/5","v":3.8399999999999997E-2},3.6999999999999991E-2,3.5600000000000007E-2,3.4200000000000008E-2,3.2800000000000003E-2,3.1550000000000002E-2,3.0300000000000001E-2,2.9199999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.0000000000000199E-2,{"$f":"Q43-(Q$40-Q$45)/5","v":3.5199999999999995E-2},3.3999999999999989E-2,3.280000000000001E-2,3.160000000000001E-2,3.0400000000000003E-2,2.9400000000000003E-2,2.8400000000000002E-2,2.7599999999999996E-2]
["Median",{"$f":"MEDIAN(B36:B43)","v":8.4999999999999992E-2},{"$f":"MEDIAN(C36:C43)","v":0.15},{"$f":"ROUND(MEDIAN(D36:D43),2)","v":0.05},null,{"$f":"MEDIAN(F36:F43)","v":0.1},{"$f":"ROUND(MEDIAN(G36:G43),2)","v":0.04},null,{"$f":"MEDIAN(I36:I43)","v":0.05},{"$f":"ROUND(MEDIAN(J36:J43),2)","v":0.03},null,{"$f":"MEDIAN(L36:L43)","v":0.02},{"$f":"ROUND(MEDIAN(M36:M43),2)","v":0.02},null,null,5.0000000000000197E-2,3.2000000000000001E-2,{"$f":"Q45-($Q45-$T45)/3","v":3.1E-2},{"$f":"R45-($Q45-$T45)/3","v":0.03},2.9000000000000001E-2,2.8000000000000001E-2,{"$f":"U45-($T45-$X45)/4","v":2.725E-2},{"$f":"V45-($T45-$X45)/4","v":2.6499999999999999E-2},2.5999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04,{"$f":"Q45-(Q$45-Q$48)/3","v":2.8000000000000001E-2},{"$f":"R45-(R$45-R$48)/3","v":2.7333333333333334E-2},2.6666666666666665E-2,2.6000000000000002E-2,2.5333333333333333E-2,2.4833333333333332E-2,2.4333333333333332E-2,2.4E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,{"$f":"Q46-(Q$45-Q$48)/3","v":2.4E-2},2.3666666666666669E-2,2.3333333333333331E-2,2.3000000000000003E-2,2.2666666666666665E-2,2.2416666666666665E-2,2.2166666666666664E-2,2.2000000000000002E-2]
[null,null,"Perpetuity growth rate consistent with DDM (17 years), linearly stepping down from a high growth rate to ",null,null,null,null,null,null,null,null,null,null,null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[]
[null,null,null,"LY Growth","Perpetuity"]
[null,null,null,0.15,0.05]
[null,null,null,0.14000000000000001,{"$f":"E51-($E$51-$E$56)/5","v":4.8000000000000001E-2},"=E51-($E$51-$E$56)/5"]
[null,null,null,0.13,{"$f":"E52-($E$51-$E$56)/5","v":4.5999999999999999E-2}]
[null,null,null,0.12,{"$f":"E53-($E$51-$E$56)/5","v":4.3999999999999997E-2}]
[null,null,null,0.11,{"$f":"E54-($E$51-$E$56)/5","v":4.1999999999999996E-2}]
[null,null,null,0.1,0.04]
[null,null,null,9.0000000000000094E-2,{"$f":"E56-($E$56-$E$61)/COUNT($D$57:$D$61)","v":3.7999999999999999E-2}]
[null,null,null,8.0000000000000099E-2,{"$f":"E57-($E$56-$E$61)/COUNT($D$57:$D$61)","v":3.5999999999999997E-2}]
[null,null,null,7.0000000000000201E-2,{"$f":"E58-($E$56-$E$61)/COUNT($D$57:$D$61)","v":3.3999999999999996E-2}]
[null,null,null,6.0000000000000199E-2,{"$f":"E59-($E$56-$E$61)/COUNT($D$57:$D$61)","v":3.1999999999999994E-2}]
[null,null,null,5.0000000000000197E-2,0.03]
[null,null,null,0.04,{"$f":"E61-($E$61-$E$64)/COUNT($D$62:$D$64)","v":2.6666666666666665E-2}]
[null,null,null,0.03,{"$f":"E62-($E$61-$E$64)/COUNT($D$62:$D$64)","v":2.3333333333333331E-2}]
[null,null,null,0.02,0.02]

{"sheet":"Additional Data","index":2,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[6,1,6,12],[47,1,47,12],[8,5,8,6],[8,9,8,10],[40,4,40,5],[28,1,28,12],[41,4,41,5],[30,9,31,9],[30,10,31,10],[30,11,31,11],[30,2,31,2],[30,3,31,3],[30,4,31,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[10,4,10,11],[12,2,25,2],[32,4,32,5],[33,4,33,5],[34,4,34,5]]}
[]
[]
[]
[]
[]
[]
[null,"Perpetuity Growth Estimation"]
[]
[null,null,"Value",{"$f":"INDEX(E13:L26,MATCH($L$9,$D$13:$D$26,0),MATCH($H$9,$E$12:$L$12,0))","v":0.02},null,{"$f":"$E$11","v":"Discount rate"},null,{"$f":"IF(DCF!P47>E12,E12,IF(DCF!P47<L12,L12,ROUND(DCF!P47,2)))","v":0.12},null,{"$f":"$C$13","v":"Year 5 FCF Growth"},null,{"$f":"IF(DCF!T205>D13,D13,IF(DCF!T205<D26,D26,ROUND(DCF!T205,2)))","v":0.02}]
[]
[null,null,null,null,"Discount rate"]
[null,null,null,null,0.12,0.11,0.1,0.09,0.08,7.0000000000000007E-2,0.06,0.05]
[null,null,"Year 5 FCF Growth",0.15,6.2E-2,{"$f":"E13-($E13-$H13)/3","v":5.8999999999999997E-2},{"$f":"F13-($E13-$H13)/3","v":5.5999999999999994E-2},5.2999999999999999E-2,{"$f":"H13-($H13-$L13)/4","v":0.05},{"$f":"I13-($H13-$L13)/4","v":4.7E-2},{"$f":"J13-($H13-$L13)/4","v":4.3999999999999997E-2},4.1000000000000002E-2]
[null,null,null,0.14000000000000001,{"$f":"E13-(E$13-E$18)/5","v":5.9200000000000003E-2},5.6399999999999999E-2,5.3599999999999995E-2,5.0799999999999998E-2,4.8000000000000001E-2,4.5199999999999997E-2,4.24E-2,3.9600000000000003E-2]
[null,null,null,0.13,5.6400000000000006E-2,5.3800000000000001E-2,5.1199999999999996E-2,4.8599999999999997E-2,4.5999999999999999E-2,4.3399999999999994E-2,4.0800000000000003E-2,3.8200000000000005E-2]
[null,null,null,0.12,5.3600000000000009E-2,5.1200000000000002E-2,4.8799999999999996E-2,4.6399999999999997E-2,4.3999999999999997E-2,4.1599999999999991E-2,3.9200000000000006E-2,3.6800000000000006E-2]
[null,null,null,0.11,5.0800000000000012E-2,4.8600000000000004E-2,4.6399999999999997E-2,4.4199999999999996E-2,4.1999999999999996E-2,3.9799999999999988E-2,3.7600000000000008E-2,3.5400000000000008E-2]
[null,null,null,0.1,4.8000000000000001E-2,{"$f":"E18-($E18-$H18)/3","v":4.5999999999999999E-2},{"$f":"F18-($E18-$H18)/3","v":4.3999999999999997E-2},4.2000000000000003E-2,{"$f":"H18-($H18-$L18)/4","v":0.04},{"$f":"I18-($H18-$L18)/4","v":3.7999999999999999E-2},{"$f":"J18-($H18-$L18)/4","v":3.5999999999999997E-2},3.4000000000000002E-2]
[null,null,null,0.09,{"$f":"E18-(E$18-E$23)/5","v":4.48E-2},4.2999999999999997E-2,4.1200000000000001E-2,3.9400000000000004E-2,3.7650000000000003E-2,3.5900000000000001E-2,3.415E-2,3.2399999999999998E-2]
[null,null,null,0.08,4.1599999999999998E-2,3.9999999999999994E-2,3.8400000000000004E-2,3.6800000000000006E-2,3.5300000000000005E-2,3.3800000000000004E-2,3.2300000000000002E-2,3.0799999999999998E-2]
[null,null,null,7.0000000000000007E-2,3.8399999999999997E-2,3.6999999999999991E-2,3.5600000000000007E-2,3.4200000000000008E-2,3.2950000000000007E-2,3.1700000000000006E-2,3.0450000000000001E-2,2.9199999999999997E-2]
[null,null,null,0.06,3.5199999999999995E-2,3.3999999999999989E-2,3.280000000000001E-2,3.160000000000001E-2,3.0600000000000006E-2,2.9600000000000005E-2,2.86E-2,2.7599999999999996E-2]
[null,null,null,0.05,3.2000000000000001E-2,{"$f":"E23-($E23-$H23)/3","v":3.1E-2},{"$f":"F23-($E23-$H23)/3","v":0.03},2.9000000000000001E-2,{"$f":"H23-($H23-$L23)/4","v":2.8250000000000001E-2},{"$f":"I23-($H23-$L23)/4","v":2.75E-2},{"$f":"J23-($H23-$L23)/4","v":2.6749999999999999E-2},2.5999999999999999E-2]
[null,null,null,0.04,{"$f":"E23-(E$23-E$26)/3","v":2.8000000000000001E-2},2.7333333333333334E-2,2.6666666666666665E-2,2.6000000000000002E-2,2.5500000000000002E-2,2.5000000000000001E-2,2.4500000000000001E-2,2.4E-2]
[null,null,null,0.03,2.4E-2,2.3666666666666669E-2,2.3333333333333331E-2,2.3000000000000003E-2,2.2750000000000003E-2,2.2500000000000003E-2,2.2250000000000002E-2,2.2000000000000002E-2]
[null,null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[]
[]
[null,"Peers Data"]
[]
[null,null,"Custom","Peers","Rel. Indx.",null,null,null,null,"Ticker","EV/EBITDA","WACC"]
[]
[null,null,null,{"$f":"IF(LEFT(_xll.BDS(TKR,\"BLOOMBERG_PEERS\",\"EndRow=10\",\"Fill=B\"),1)=\"#\",\"\",_xll.BDS(TKR,\"BLOOMBERG_PEERS\",\"EndRow=10\",\"Fill=B\",\"cols=1;rows=10\"))","v":"005930 KS"},{"$f":"_xll.BDS(TKR,\"RELATIVE_INDICES_LIST\",\"EndRow=10\",\"Fill=B\",\"cols=1;rows=2\")","v":"SPTSX Index"},null,null,null,null,{"$f":"IF(C33=\"\",IF(D33=\"\",IF(E33=\"\",\"\",E33),D33),C33)","v":"005930 KS"},{"$f":"IF(J33=\"\",\"\",IF(LEFT(_xll.BDP(J33&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J33,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J33&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":2.1024110262830429},{"$f":"IFERROR(_xll.BDP(J33&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":0.11579590630917107}]
[null,null,null,"AAPL US","STINFT Index",null,null,null,null,"AAPL US",{"$f":"IF(J34=\"\",\"\",IF(LEFT(_xll.BDP(J34&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J34,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J34&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":6.0462225154266731},{"$f":"IFERROR(_xll.BDP(J34&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":9.1785663640807494E-2}]
[null,null,null,"SHOR US",null,null,null,null,null,"SHOR US",{"$f":"IF(J35=\"\",\"\",IF(LEFT(_xll.BDP(J35&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J35,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J35&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":""},{"$f":"IFERROR(_xll.BDP(J35&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":0.11184718675295711}]
[null,null,null,"2498 TT",null,null,null,null,null,"2498 TT",{"$f":"IF(J36=\"\",\"\",IF(LEFT(_xll.BDP(J36&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J36,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J36&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":""},{"$f":"IFERROR(_xll.BDP(J36&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":0.14565025975828}]
[null,null,null,"066570 KS",null,null,null,null,null,"066570 KS",{"$f":"IF(J37=\"\",\"\",IF(LEFT(_xll.BDP(J37&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J37,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J37&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":5.1308912320827726},{"$f":"IFERROR(_xll.BDP(J37&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":5.5320100435845988E-2}]
[null,null,null,"SPT LN",null,null,null,null,null,"SPT LN",{"$f":"IF(J38=\"\",\"\",IF(LEFT(_xll.BDP(J38&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J38,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J38&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":17.247173662222224},{"$f":"IFERROR(_xll.BDP(J38&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":7.21753570421E-2}]
[null,null,null,"6703 JP",null,null,null,null,null,"6703 JP",{"$f":"IF(J39=\"\",\"\",IF(LEFT(_xll.BDP(J39&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J39,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J39&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":5.9663664718249096},{"$f":"IFERROR(_xll.BDP(J39&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":5.2457345383512835E-2}]
[null,null,null,"MITL US",null,null,null,null,null,"MITL US",{"$f":"IF(J40=\"\",\"\",IF(LEFT(_xll.BDP(J40&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J40,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J40&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":13.092228739002934},{"$f":"IFERROR(_xll.BDP(J40&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":7.9085051321358193E-2}]
[null,null,null,"SHEN US",null,null,null,null,null,"SHEN US",{"$f":"IF(J41=\"\",\"\",IF(LEFT(_xll.BDP(J41&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J41,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J41&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":8.3214870562502696},{"$f":"IFERROR(_xll.BDP(J41&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":8.262844467506357E-2}]
[null,null,null,"3105 JP",null,null,null,null,null,"3105 JP",{"$f":"IF(J42=\"\",\"\",IF(LEFT(_xll.BDP(J42&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"),1)=\"#\",_xll.BDP(J42,\"EV_TO_T12M_EBITDA\",\"Fill=B\"),_xll.BDP(J42&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\")))","v":6.8542892706292928},{"$f":"IFERROR(_xll.BDP(J42&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":7.7481045884212771E-2}]
[null,null,null,null,null,null,null,null,null,"Median",{"$f":"IFERROR(MEDIAN(K33:K42),\"NA\")","v":6.4502558930279825},{"$f":"MEDIAN(L33:L42)","v":8.0856747998210882E-2}]
[null,null,null,null,null,null,null,null,null,"IQR",{"$f":"_xlfn.QUARTILE.EXC(K33:K42,3)-_xlfn.QUARTILE.EXC(K33:K42,1)","v":6.5597832762964607},{"$f":"_xlfn.QUARTILE.EXC(L33:L42,3)-_xlfn.QUARTILE.EXC(L33:L42,1)","v":4.4872823751474111E-2}]
[null,null,null,null,null,null,null,null,null,"Up Limit",{"$f":"IFERROR(_xlfn.QUARTILE.EXC(K33:K42,3)+(1.5*K44),K43)","v":21.739218232759459},{"$f":"_xlfn.QUARTILE.EXC(L33:L42,3)+(1.5*L44)","v":0.18014360226922177}]
[]
[]
[null,"Net Long Term Deferred Tax Liabilities"]
[]
[null,null,null,null,"-6FY",{"$f":"DCF!I53","v":"-5FY"},{"$f":"DCF!J53","v":"-4FY"},{"$f":"DCF!K53","v":"-3FY"},{"$f":"DCF!L53","v":"-2FY"},{"$f":"DCF!M53","v":"-1FY"},{"$f":"DCF!N53","v":"-0FY"}]
[null,null,null,"Field",null,{"$f":"DCF!I52","v":"Févr 10 A"},{"$f":"DCF!J52","v":"Févr 11 A"},{"$f":"DCF!K52","v":"Févr 12 A"},{"$f":"DCF!L52","v":"Févr 13 A"},{"$f":"DCF!M52","v":"Févr 14 A"},{"$f":"DCF!N52","v":"Févr 15 A"}]
[null,null,null,"Liabilities",{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_LIABILITIES_LT\",\"EQY_FUND_RELATIVE_PERIOD\",E$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":111.3556722},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_LIABILITIES_LT\",\"EQY_FUND_RELATIVE_PERIOD\",F$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":149.1014572},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_LIABILITIES_LT\",\"EQY_FUND_RELATIVE_PERIOD\",G$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":270.61799999999999},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_LIABILITIES_LT\",\"EQY_FUND_RELATIVE_PERIOD\",H$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":229.33200000000002},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_LIABILITIES_LT\",\"EQY_FUND_RELATIVE_PERIOD\",I$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":251.8845},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_LIABILITIES_LT\",\"EQY_FUND_RELATIVE_PERIOD\",J$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":35.3568},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_LIABILITIES_LT\",\"EQY_FUND_RELATIVE_PERIOD\",K$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":60.043199999999999}]
[null,null,null,"Assets",{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_ASSETS_LT\",\"EQY_FUND_RELATIVE_PERIOD\",E$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0.51170640000000001},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_ASSETS_LT\",\"EQY_FUND_RELATIVE_PERIOD\",F$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_ASSETS_LT\",\"EQY_FUND_RELATIVE_PERIOD\",G$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_ASSETS_LT\",\"EQY_FUND_RELATIVE_PERIOD\",H$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_ASSETS_LT\",\"EQY_FUND_RELATIVE_PERIOD\",I$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_ASSETS_LT\",\"EQY_FUND_RELATIVE_PERIOD\",J$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,\"BS_DEFERRED_TAX_ASSETS_LT\",\"EQY_FUND_RELATIVE_PERIOD\",K$50,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0}]
[null,null,null,"Net",{"$f":"E52-E53","v":110.84396580000001},149.1014572,270.61799999999999,229.33200000000002,251.8845,35.3568,60.043199999999999]
[null,null,null,"Change",null,{"$f":"F54-E54","v":38.257491399999992},121.5165428,-41.285999999999973,22.552499999999981,-216.52770000000001,24.686399999999999]

{"sheet":"Data","index":3,"n_rows":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":true,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Currency Options",null,null,"Data Options",null,null,null,null,null,null,"Market Status"]
[null,"Choice",{"$f":"VLOOKUP(DCF!$K$6,Data!$B$4:$C$17,2,FALSE)","v":"CAD"},null,"Choice",{"$f":"VLOOKUP(DCF!K8,Data!E4:F5,2,FALSE)","v":"Y"},null,null,null,null,null,"PR286","Status","Message"]
[null,"Fundamental",{"$f":"_xll.BDP(TKR,\"EQY_FUND_CRNCY\",\"Fill=B\")","v":"USD"},null,"Adjusted (If available)","Y",null,null,null,null,null,"ACTV"," Active",{"$f":"\"\"","v":""}]
[null,"Trading",{"$f":"_xll.BDP(TKR,\"CRNCY\",\"Fill=B\")","v":"CAD"},null,"GAAP","N",null,null,null,null,null,"DLST"," Delisted",{"$f":"\"WARNING: This ticker is\"&M5","v":"WARNING: This ticker is Delisted"}]
[null,"AUD",{"$f":"B6","v":"AUD"},null,null,null,null,null,null,null,null,"ACQU"," Acquired",{"$f":"\"WARNING: This company's market status is\"&M6","v":"WARNING: This company's market status is Acquired"}]
[null,"BRL","BRL",null,"Adj Financials Available",{"$f":"_xll.BDP(TKR,\"ADJUSTED_FINANCIALS_INDICATOR\")","v":"Y"},null,null,null,null,null,"UNLS"," Unlisted",{"$f":"\"WARNING: This ticker is\"&M7","v":"WARNING: This ticker is Unlisted"}]
[null,"CAD",{"$f":"B8","v":"CAD"},null,null,null,null,null,null,null,null,"SUSP"," Suspended",{"$f":"\"WARNING: This ticker is\"&M8","v":"WARNING: This ticker is Suspended"}]
[null,"CHF","CHF",null,null,null,null,null,null,null,null,"HALT"," Halted",{"$f":"\"WARNING: This ticker is\"&M9","v":"WARNING: This ticker is Halted"}]
[null,"DKK","DKK",null,null,null,null,null,null,null,null,"PRIV"," Private Company",{"$f":"\"WARNING: This company's market status is\"&M10","v":"WARNING: This company's market status is Private Company"}]
[null,"EUR","EUR",null,null,null,null,null,null,null,null,"EXPD"," Expired",{"$f":"\"WARNING: This ticker is\"&M11","v":"WARNING: This ticker is Expired"}]
[null,"GBP","GBP",null,null,null,null,null,null,null,null,"POST"," Postponed",{"$f":"\"WARNING: This ticker is\"&M12","v":"WARNING: This ticker is Postponed"}]
[null,"JPY","JPY",null,null,null,null,null,null,null,null,"PEND"," Pending Listing",{"$f":"\"WARNING: This ticker is\"&M13","v":"WARNING: This ticker is Pending Listing"}]
[null,"NOK","NOK",null,null,null,null,null,null,null,null,"TKCH"," Ticker Change",{"$f":"\"WARNING: This ticker has changed. See DES<GO> or CACS<GO> for details.\"","v":"WARNING: This ticker has changed. See DES<GO> or CACS<GO> for details."}]
[null,"NZD","NZD",null,null,null,null,null,null,null,null,"LIQU"," Liquidated",{"$f":"\"WARNING: This company's market status is\"&M15","v":"WARNING: This company's market status is Liquidated"}]
[null,"SEK","SEK",null,null,null,null,null,null,null,null,"INAC"," Inactive",{"$f":"\"WARNING: This ticker is\"&M16","v":"WARNING: This ticker is Inactive"}]
[null,"USD","USD",null,null,null,null,null,null,null,null,"WHIS"," When Issued",{"$f":"\"WARNING: This ticker's market status is\"&M17","v":"WARNING: This ticker's market status is When Issued"}]
[null,null,null,null,null,null,null,null,null,null,null,"PSYM"," Pending Symbol","WARNING: This ticker's market status is Pending Symbol"]
[null,null,null,null,null,null,null,null,null,null,null,"OInd"," Opening Auction","WARNING: This ticker's market status is Opening Auction"]
[null,null,null,null,null,null,null,null,null,null,null,"CInd"," Closing Auction","WARNING: This ticker's market status is Closing Auction"]
[null,null,null,null,null,null,null,null,null,null,null,"Auct"," Auction","WARNING: This ticker's market status is Auction"]
[null,null,null,null,null,null,null,null,null,null,null,"IMRK"," Indicated Market","WARNING: This ticker's market status is Indicated Market"]
[null,null,null,null,null,null,null,null,null,null,null,"OPDL"," Opening Delay","WARNING: This ticker's market status is Opening Delay"]
[null,null,null,null,null,null,null,null,null,null,null,"NOOP"," No Open, No Resume","WARNING: This ticker's market status is No Open, No Resume"]
[null,null,null,null,null,null,null,null,null,null,null,"PIND"," Price Indication","WARNING: This ticker's market status is Price Indication"]
[null,null,null,null,null,null,null,null,null,null,null,"TRIN"," Trading Range Indication","WARNING: This ticker's market status is Trading Range Indication"]
[null,"Primary periodicity",null,null,null,null,null,null,null,null,null,"IMBB"," Market Imbalance Buy","WARNING: This ticker's market status is Market Imbalance Buy"]
[null,{"$f":"LEFT(_xll.BDP(TKR,\"PRIMARY_PERIODICITY\",\"Fill=B\"),1)","v":"Q"},{"$f":"\"-0F\"&B28","v":"-0FQ"},null,null,null,null,null,null,null,null,"IMBS"," Market Imbalance Sell","WARNING: This ticker's market status is Market Imbalance Sell"]
[null,null,null,null,null,null,null,null,null,null,null,"NIMB"," No Market Imbalance","WARNING: This ticker's market status is No Market Imbalance"]
[null,"Palette",null,null,null,null,null,null,null,null,null,"NOMM"," No Market Makers","WARNING: This ticker's market status is No Market Makers"]
[null,null,"FMT_INP",null,null,null,null,null,null,null,null,"RSRV"," Halted Exceeds Limit","WARNING: This ticker's market status is Halted Exceeds Limit"]
[null,null,"FMT_SEL",null,null,null,null,null,null,null,null,"DELT"," Security Deleted","WARNING: This ticker's market status is Security Deleted"]
[null,null,"FMT_ERR",null,null,null,null,null,null,null,null,"WI"," When Issued","WARNING: This ticker's market status is When Issued"]
[null,null,null,null,null,null,null,null,null,null,null,"DL"," Delisted","WARNING: This ticker's market status is Delisted"]
[null,"Description",null,null,null,null,null,null,null,null,null,"SC"," Script Conversion","WARNING: This ticker's market status is Script Conversion"]
[null,{"$f":"_xll.BDS(TKR,\"CIE_DES_BULK\",\"Fill=B\",\"cols=1;rows=4\")","v":"BlackBerry Limited designs, manufactures, and markets wireless solutions for the"},null,null,null,null,null,null,null,null,null,"CA"," Any Combination of Cum Remarks",{"$f":"\"WARNING: This ticker's market status is\"&M36","v":"WARNING: This ticker's market status is Any Combination of Cum Remarks"}]
[null,"worldwide mobile communications market. The Company provides platforms and",null,null,null,null,null,null,null,null,null,"CD"," Cum Dividend","WARNING: This ticker's market status is Cum Dividend"]
[null,"solutions for access to email, phone, SMS messaging, Internet, and",null,null,null,null,null,null,null,null,null,"CB"," Cum Bonus","WARNING: This ticker's market status is Cum Bonus"]
[null,"Intranet-based applications.",null,null,null,null,null,null,null,null,null,"CR"," Cum Rights","WARNING: This ticker's market status is Cum Rights"]
[null,null,null,null,null,null,null,null,null,null,null,"CO"," Cum Offer","WARNING: This ticker's market status is Cum Offer"]
[null,null,null,null,null,null,null,null,null,null,null,"CI"," Cum Interest","WARNING: This ticker's market status is Cum Interest"]
[null,null,null,null,null,null,null,null,null,null,null,"CE"," Cum Entitlement","WARNING: This ticker's market status is Cum Entitlement"]
[null,null,null,null,null,null,null,null,null,null,null,"XA"," Any Combination of Ex Remarks","WARNING: This ticker's market status is Any Combination of Ex Remarks"]
[null,null,null,null,null,null,null,null,null,null,null,"XD"," Ex Dividend","WARNING: This ticker's market status is Ex Dividend"]
[null,null,null,null,null,null,null,null,null,null,null,"XB"," Ex Bonus",{"$f":"\"WARNING: This ticker's market status is\"&M45","v":"WARNING: This ticker's market status is Ex Bonus"}]
[null,null,null,null,null,null,null,null,null,null,null,"XR"," Ex Rights",{"$f":"\"WARNING: This ticker's market status is\"&M46","v":"WARNING: This ticker's market status is Ex Rights"}]
[null,null,null,null,null,null,null,null,null,null,null,"XL"," Ex Liquidation",{"$f":"\"WARNING: This ticker's market status is\"&M47","v":"WARNING: This ticker's market status is Ex Liquidation"}]
[null,null,null,null,null,null,null,null,null,null,null,"XS"," Ex Stock Distribution","WARNING: This ticker's market status is Ex Stock Distribution"]
[null,null,null,null,null,null,null,null,null,null,null,"XP"," Ex Repayment of Capital","WARNING: This ticker's market status is Ex Repayment of Capital"]
[null,null,null,null,null,null,null,null,null,null,null,"ST"," Stabilization Indicator","WARNING: This ticker's market status is Stabilization Indicator"]
[null,null,null,null,null,null,null,null,null,null,null,"SP"," Stock Split","WARNING: This ticker's market status is Stock Split"]
[null,null,null,null,null,null,null,null,null,null,null,"XDXR"," Ex Dividend/Ex Rights","WARNING: This ticker's market status is Ex Dividend/Ex Rights"]
[null,null,null,null,null,null,null,null,null,null,null,"PRNA"," Price Not Available","WARNING: This ticker's market status is Price Not Available"]
[null,null,null,null,null,null,null,null,null,null,null,"INFO"," Additional Information on DES","WARNING: This ticker's market status is Additional Information on DES"]
[null,null,null,null,null,null,null,null,null,null,null,"PREN"," PreNotice","WARNING: This ticker's market status is PreNotice"]
[null,null,null,null,null,null,null,null,null,null,null,"RSUS"," Suspended by the Regulator","WARNING: This ticker's market status is Suspended by the Regulator"]
[null,null,null,null,null,null,null,null,null,null,null,"SUSH"," Short Term Suspension","WARNING: This ticker's market status is Short Term Suspension"]
[null,null,null,null,null,null,null,null,null,null,null,"AHLT"," Authorized Halt","WARNING: This ticker's market status is Authorized Halt"]

{"sheet":"BBG_DATA","index":4,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[{"$f":"COUNTIF(3:100,\"#N/A Requesting Data...\")","v":0}]
[null,1,2,3,4,5,6]
["Best Sales",{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",B$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":2855.1240000000003},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",C$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":2643.5450000000001},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",D$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":2216.8760000000002},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",E$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",F$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_SALES\",\"BEST_FPERIOD_OVERRIDE\",G$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"}]
["Best EPS LTG",{"$f":"_xll.BDP(TKR,\"BEST_EST_LONG_TERM_GROWTH\")","v":-20.402000000000001}]
["Best Gross Margin",{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",B$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":45.280999999999999},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",C$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":45.204000000000001},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",D$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":60.207999999999998},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",E$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",F$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_GROSS_MARGIN\",\"BEST_FPERIOD_OVERRIDE\",G$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"}]
["Best OPP",{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",B$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-249.61799999999999},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",C$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-310.98099999999999},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",D$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-368.80700000000002},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",E$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",F$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_OPP\",\"BEST_FPERIOD_OVERRIDE\",G$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"}]
["Best EBITDA",{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",B$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":472.99700000000001},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",C$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":412.29},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",D$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":267.75100000000003},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",E$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",F$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_EBITDA\",\"BEST_FPERIOD_OVERRIDE\",G$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"}]
["Best CAPEX",{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",B$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-77.807000000000002},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",C$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-130.47300000000001},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",D$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-191.809},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",E$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",F$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,\"BEST_CAPEX\",\"BEST_FPERIOD_OVERRIDE\",G$2&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"}]
[]
[null,{"$f":"C10-1","v":-5},{"$f":"D10-1","v":-4},{"$f":"E10-1","v":-3},{"$f":"F10-1","v":-2},{"$f":"G10-1","v":-1},"-0"]
["IS_COMP_SALES",{"$f":"_xll.BDP(TKR,$A11,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":16617.006847678778},{"$f":"_xll.BDP(TKR,$A11,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":20323.487484188721},{"$f":"_xll.BDP(TKR,$A11,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":18356.397527269932},{"$f":"_xll.BDP(TKR,$A11,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":11061.339286188208},{"$f":"_xll.BDP(TKR,$A11,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":7128.9817041387923},{"$f":"_xll.BDP(TKR,$A11,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":3754.077391876624}]
["SALES_REV_TURN",{"$f":"_xll.BDP(TKR,$A12,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":16617.006847678778},{"$f":"_xll.BDP(TKR,$A12,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":20323.487484188721},{"$f":"_xll.BDP(TKR,$A12,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":18272.093778090228},{"$f":"_xll.BDP(TKR,$A12,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":11061.339286188208},{"$f":"_xll.BDP(TKR,$A12,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":7128.9817041387923},{"$f":"_xll.BDP(TKR,$A12,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":3754.077391876624}]
["GROSS_PROFIT",{"$f":"_xll.BDP(TKR,$A13,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":7316.8698074033091},{"$f":"_xll.BDP(TKR,$A13,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":9009.6336488654979},{"$f":"_xll.BDP(TKR,$A13,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":6521.1429512535015},{"$f":"_xll.BDP(TKR,$A13,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":3430.3837360038206},{"$f":"_xll.BDP(TKR,$A13,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-44.994306954053734},{"$f":"_xll.BDP(TKR,$A13,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":1805.5592613403612}]
["IS_OPER_INC",{"$f":"_xll.BDP(TKR,$A14,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":3598.1342860839695},{"$f":"_xll.BDP(TKR,$A14,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":4732.9928154266781},{"$f":"_xll.BDP(TKR,$A14,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":1484.7377943766526},{"$f":"_xll.BDP(TKR,$A14,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-1233.6994507759809},{"$f":"_xll.BDP(TKR,$A14,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-7495.2144351601601},{"$f":"_xll.BDP(TKR,$A14,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-476.15434385721488}]
["EFF_TAX_RATE",{"$f":"_xll.BDP(TKR,$A15,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":24.777698522276069},{"$f":"_xll.BDP(TKR,$A15,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":26.550387596899228},{"$f":"_xll.BDP(TKR,$A15,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":22.859025032938078},{"$f":"_xll.BDP(TKR,$A15,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,$A15,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"},{"$f":"_xll.BDP(TKR,$A15,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":"#N/A N/A"}]
["CF_DEPR_AMORT",{"$f":"_xll.BDP(TKR,$A16,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":684.11858021887826},{"$f":"_xll.BDP(TKR,$A16,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":946.39437875335022},{"$f":"_xll.BDP(TKR,$A16,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":1510.5248235375032},{"$f":"_xll.BDP(TKR,$A16,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":1915.9801996666649},{"$f":"_xll.BDP(TKR,$A16,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":1328.9016239918194},{"$f":"_xll.BDP(TKR,$A16,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":781.20830883429596}]
["CF_CAP_EXPEND_PRPTY_ADD",{"$f":"_xll.BDP(TKR,$A17,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-1121.7295069047666},{"$f":"_xll.BDP(TKR,$A17,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-1060.7376046652976},{"$f":"_xll.BDP(TKR,$A17,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-894.6115501187312},{"$f":"_xll.BDP(TKR,$A17,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-417.55981410879355},{"$f":"_xll.BDP(TKR,$A17,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-296.12532251156284},{"$f":"_xll.BDP(TKR,$A17,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-97.932453701129319}]
["NET_WORKING_CAPITAL_INVESTMENT",{"$f":"_xll.BDP(TKR,$A18,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":275.65240259999985},{"$f":"_xll.BDP(TKR,$A18,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":262.37787800000001},{"$f":"_xll.BDP(TKR,$A18,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":169.0335},{"$f":"_xll.BDP(TKR,$A18,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-597.3261},{"$f":"_xll.BDP(TKR,$A18,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-1178.9283},{"$f":"_xll.BDP(TKR,$A18,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":-434.06229999999999}]
["IS_COGS_TO_FE_AND_PP_AND_G",{"$f":"_xll.BDP(TKR,$A19,\"EQY_FUND_RELATIVE_PERIOD\",B$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":9300.1370402754674},{"$f":"_xll.BDP(TKR,$A19,\"EQY_FUND_RELATIVE_PERIOD\",C$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":11313.853835323223},{"$f":"_xll.BDP(TKR,$A19,\"EQY_FUND_RELATIVE_PERIOD\",D$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":11750.950826836726},{"$f":"_xll.BDP(TKR,$A19,\"EQY_FUND_RELATIVE_PERIOD\",E$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":7630.9555501843879},{"$f":"_xll.BDP(TKR,$A19,\"EQY_FUND_RELATIVE_PERIOD\",F$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":7173.9760110928464},{"$f":"_xll.BDP(TKR,$A19,\"EQY_FUND_RELATIVE_PERIOD\",G$10&\"FY\",\"EQY_FUND_CRNCY\",CCY)","v":1948.5181305362623}]
[]
["ARD_DEFERRED_UNEARNED_REV_LT",{"$f":"_xll.BDP(TKR,$A21,\"EQY_FUND_RELATIVE_PERIOD\",B$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A21,\"EQY_FUND_RELATIVE_PERIOD\",C$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A21,\"EQY_FUND_RELATIVE_PERIOD\",D$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A21,\"EQY_FUND_RELATIVE_PERIOD\",E$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A21,\"EQY_FUND_RELATIVE_PERIOD\",F$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A21,\"EQY_FUND_RELATIVE_PERIOD\",G$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0}]
["ARD_DEFERRED_INC_TAX_ASSET_LT",{"$f":"_xll.BDP(TKR,$A22,\"EQY_FUND_RELATIVE_PERIOD\",B$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A22,\"EQY_FUND_RELATIVE_PERIOD\",C$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A22,\"EQY_FUND_RELATIVE_PERIOD\",D$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A22,\"EQY_FUND_RELATIVE_PERIOD\",E$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A22,\"EQY_FUND_RELATIVE_PERIOD\",F$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0},{"$f":"_xll.BDP(TKR,$A22,\"EQY_FUND_RELATIVE_PERIOD\",G$10,\"EQY_FUND_CRNCY\",CCY,\"Fill=0\")","v":0}]
[]
["CRNCY",{"$f":"_xll.BDP(TKR,$A$24)","v":"CAD"}]
[]
[{"$f":"_xll.BDS(TKR,\"BLOOMBERG_PEERS\",\"EndRow=10\",\"Fill=B\",\"cols=1;rows=10\")","v":"005930 KS"},{"$f":"IF(ISBLANK(A26),\"\",_xll.BDP(A26&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":2.1024110262830429},{"$f":"IFERROR(_xll.BDP(A26&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":0.11579590630917107}]
["AAPL US",{"$f":"IF(ISBLANK(A27),\"\",_xll.BDP(A27&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":6.0462225154266731},{"$f":"IFERROR(_xll.BDP(A27&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":9.1785663640807494E-2}]
["SHOR US",{"$f":"IF(ISBLANK(A28),\"\",_xll.BDP(A28&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":""},{"$f":"IFERROR(_xll.BDP(A28&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":0.11184718675295711}]
["2498 TT",{"$f":"IF(ISBLANK(A29),\"\",_xll.BDP(A29&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":""},{"$f":"IFERROR(_xll.BDP(A29&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":0.14565025975828}]
["066570 KS",{"$f":"IF(ISBLANK(A30),\"\",_xll.BDP(A30&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":5.1308912320827726},{"$f":"IFERROR(_xll.BDP(A30&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":5.5320100435845988E-2}]
["SPT LN",{"$f":"IF(ISBLANK(A31),\"\",_xll.BDP(A31&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":17.247173662222224},{"$f":"IFERROR(_xll.BDP(A31&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":7.21753570421E-2}]
["6703 JP",{"$f":"IF(ISBLANK(A32),\"\",_xll.BDP(A32&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":5.9663664718249096},{"$f":"IFERROR(_xll.BDP(A32&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":5.2457345383512835E-2}]
["MITL US",{"$f":"IF(ISBLANK(A33),\"\",_xll.BDP(A33&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":13.092228739002934},{"$f":"IFERROR(_xll.BDP(A33&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":7.9085051321358193E-2}]
["SHEN US",{"$f":"IF(ISBLANK(A34),\"\",_xll.BDP(A34&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":8.3214870562502696},{"$f":"IFERROR(_xll.BDP(A34&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":8.262844467506357E-2}]
["3105 JP",{"$f":"IF(ISBLANK(A35),\"\",_xll.BDP(A35&\" Equity\",\"EV_TO_T12M_EBITDA\",\"Fill=B\"))","v":6.8542892706292928},{"$f":"IFERROR(_xll.BDP(A35&\" Equity\",\"WACC\",\"Fill=B\")/100,\"\")","v":7.7481045884212771E-2}]

{"sheet":"Help","index":5,"n_rows":178,"n_cols":8,"rows_kept":178,"cut":false,"hidden":false,"merged":[[220,20,228,23],[5,20,219,23],[220,1,228,19],[9,1,215,2],[9,18,215,19],[9,3,10,17],[5,3,8,17],[5,1,8,2],[5,18,8,19],[216,3,219,17],[216,1,219,2],[216,18,219,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Application Objective: The Bloomberg Excel Discounted Cash Flow (XDCF) allows you to estimate the value of a stock based on the present value of projected free cash flows. "]
[]
[]
[null,null,null,"A. Step-by-step User Guide"]
[]
[null,null,null,"General color scheme:",null,null,null,"<-- User Input"]
[null,null,null,null,null,null,null,"<-- Forecast outlier"]
[null,null,null,null,null,null,null,"<-- Current selection (while forecasting future cash flows)"]
[]
[null,null,null,"Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Inputs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Outputs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"B. Features"]
[]
[null,null,null,"Overview"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Forecasting Free Cash Flows"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Discounting"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Sensitivity"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"C. FAQ"]