{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ERP","Beta","Valuation"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ERP","index":0,"n_rows":320,"n_cols":10,"rows_kept":320,"cut":false,"hidden":false,"merged":[]}
["Serial","Month","Bse200","Risk Free Rate","Mean Reversion Period (Y)","Required Rtn Equity","Equity Risk Premium",null,"Effective Date","RBI Reverse Repo Rate %"]
[1,"1991-01",133,null,null,null,null,null,"2001-04-27",6.7500000000000004E-2]
[{"$f":"A2+1","v":2},"1991-02",142.5,null,null,null,null,null,"2001-05-28",6.5000000000000002E-2]
[3,"1991-03",160.4,null,null,null,null,null,"2002-03-05",0.06]
[4,"1991-04",169,null,null,null,null,null,"2002-06-27",5.7500000000000002E-2]
[5,"1991-05",168.75,null,null,null,null,null,"2002-10-29",5.5E-2]
[6,"1991-06",168,null,null,null,null,null,"2003-03-03",0.05]
[7,"1991-07",191.25,null,null,null,null,null,"2003-08-25",4.4999999999999998E-2]
[8,"1991-08",218.4,null,null,null,null,null,"2004-10-27",4.7500000000000001E-2]
[9,"1991-09",228.75,null,null,null,null,null,"2005-04-29",0.05]
[10,"1991-10",221.75,null,null,null,null,null,"2005-10-26",5.2499999999999998E-2]
[11,"1991-11",231.8,null,null,null,null,null,"2006-01-24",5.5E-2]
[12,"1991-12",226.75,null,null,null,null,null,"2006-06-08",5.7500000000000002E-2]
[13,"1992-01",248.5,null,null,null,null,null,"2006-07-25",0.06]
[14,"1992-02",300.60000000000002,null,null,null,null,null,"2008-12-08",0.05]
[15,"1992-03",454.5,null,null,null,null,null,"2009-01-05",0.04]
[16,"1992-04",561.25,null,null,null,null,null,"2009-03-05",3.5000000000000003E-2]
[17,"1992-05",429.4,null,null,null,null,null,"2009-04-21",3.2500000000000001E-2]
[18,"1992-06",370,null,null,null,null,null,"2010-03-19",3.5000000000000003E-2]
[19,"1992-07",337.5,null,null,null,null,null,"2010-04-20",3.7499999999999999E-2]
[20,"1992-08",336.8,null,null,null,null,null,"2010-07-02",0.04]
[21,"1992-09",390,null,null,null,null,null,"2010-07-27",4.4999999999999998E-2]
[22,"1992-10",378,null,null,null,null,null,"2010-09-16",0.05]
[23,"1992-11",322.5,null,null,null,null,null,"2010-11-02",5.2499999999999998E-2]
[24,"1992-12",313.75,null,null,null,null,null,"2011-01-25",5.5E-2]
[25,"1993-01",302.75,null,null,null,null,null,"2011-03-17",5.7500000000000002E-2]
[26,"1993-02",307.5,null,null,null,null,null,"2011-05-03",6.25E-2]
[27,"1993-03",260.25,null,null,null,null,null,"2011-06-16",6.5000000000000002E-2]
[28,"1993-04",236.5,null,null,null,null,null,"2011-07-26",7.0000000000000007E-2]
[29,"1993-05",242.8,null,null,null,null,null,"2011-09-16",7.2499999999999995E-2]
[30,"1993-06",254.5,null,null,null,null,null,"2011-10-25",7.4999999999999997E-2]
[31,"1993-07",247.4,null,null,null,null,null,"2012-04-17",7.0000000000000007E-2]
[32,"1993-08",292,null,null,null,null,null,"2013-01-29",6.7500000000000004E-2]
[33,"1993-09",321.75,null,null,null,null,null,"2013-03-19",6.5000000000000002E-2]
[34,"1993-10",316.8,null,null,null,null,null,"2013-05-03",6.25E-2]
[35,"1993-11",336.25,null,null,null,null,null,"2013-09-20",6.5000000000000002E-2]
[36,"1993-12",398.75,null,null,null,null,null,"2013-10-29",6.7500000000000004E-2]
[37,"1994-01",481.75,null,null,null,null,null,"2014-01-28",7.0000000000000007E-2]
[38,"1994-02",483,null,null,null,null,null,"2015-01-15",6.7500000000000004E-2]
[39,"1994-03",456,null,null,null,null,null,"2015-03-04",6.5000000000000002E-2]
[40,"1994-04",462,null,null,null,null,null,"2015-06-02",6.25E-2]
[41,"1994-05",450.5,null,null,null,null,null,"2015-09-29",5.7500000000000002E-2]
[42,"1994-06",486.5,null,null,null,null,null,"2016-04-05",0.06]
[43,"1994-07",489.2,null,null,null,null,null,"2016-10-04",5.7500000000000002E-2]
[44,"1994-08",513,null,null,null,null,null,"2017-04-06",0.06]
[45,"1994-09",519.5]
[46,"1994-10",488.4]
[47,"1994-11",470.25]
[48,"1994-12",446.4]
[49,"1995-01",410]
[50,"1995-02",387.5]
[51,"1995-03",383]
[52,"1995-04",371]
[53,"1995-05",353]
[54,"1995-06",360.5]
[55,"1995-07",352.6]
[56,"1995-08",355]
[57,"1995-09",348]
[58,"1995-10",355.75]
[59,"1995-11",323]
[60,"1995-12",309.8]
[61,"1996-01",299.25]
[62,"1996-02",344.75]
[63,"1996-03",342.8]
[64,"1996-04",373.25]
[65,"1996-05",386.75]
[{"$f":"A66+1","v":66},"1996-06",394.8]
[67,"1996-07",377.25]
[68,"1996-08",351]
[69,"1996-09",336.75]
[70,"1996-10",312.25]
[71,"1996-11",300.60000000000002]
[72,"1996-12",295]
[73,"1997-01",332.75]
[74,"1997-02",333]
[75,"1997-03",359.8]
[76,"1997-04",352.75]
[77,"1997-05",363]
[78,"1997-06",383]
[79,"1997-07",407.25]
[80,"1997-08",409]
[81,"1997-09",383.75]
[82,"1997-10",385]
[83,"1997-11",354.8]
[84,"1997-12",339]
[85,"1998-01",336.4]
[86,"1998-02",329.5]
[87,"1998-03",363.75]
[88,"1998-04",404.5]
[89,"1998-05",390]
[90,"1998-06",327.5]
[91,"1998-07",327.75]
[92,"1998-08",311]
[93,"1998-09",316.75]
[94,"1998-10",300.8]
[95,"1998-11",299]
[96,"1998-12",300]
[97,"1999-01",333.2]
[98,"1999-02",335]
[99,"1999-03",368.75]
[100,"1999-04",349]
[101,"1999-05",372.2]
[102,"1999-06",399.25]
[103,"1999-07",443.2]
[104,"1999-08",474]
[105,"1999-09",495]
[106,"1999-10",517.79999999999995]
[107,"1999-11",507]
[108,"1999-12",552.75]
[109,"2000-01",623.6]
[110,"2000-02",737.5]
[111,"2000-03",660.25]
[112,"2000-04",577.4]
[113,"2000-05",455]
[114,"2000-06",500]
[115,"2000-07",504.2]
[116,"2000-08",460.75]
[117,"2000-09",473.6]
[118,"2000-10",412.75]
[119,"2000-11",429.75]
[120,"2000-12",448.2]
[121,"2001-01",463.5]
[122,"2001-02",475]
[123,"2001-03",394.2]
[124,"2001-04",350.75]
[125,"2001-05",378.5]
[126,"2001-06",366]
[127,"2001-07",345.75]
[128,"2001-08",342.75]
[129,"2001-09",303.2]
[{"$f":"A130+1","v":130},"2001-10",300.25]
[131,"2001-11",324]
[132,"2001-12",345.4]
[133,"2002-01",351.5]
[134,"2002-02",380]
[135,"2002-03",397.6]
[136,"2002-04",403.5]
[137,"2002-05",400.25]
[138,"2002-06",391]
[139,"2002-07",389.75]
[140,"2002-08",370]
[141,"2002-09",364.25]
[142,"2002-10",355]
[143,"2002-11",363.6]
[144,"2002-12",391.5]
[145,"2003-01",393]
[146,"2003-02",385]
[147,"2003-03",375.2]
[148,"2003-04",359.25]
[149,"2003-05",378.4]
[150,"2003-06",433.25]
[151,"2003-07",459.75]
[152,"2003-08",512.6]
[153,"2003-09",555.25]
[154,"2003-10",604.75]
[155,"2003-11",627.6]
[156,"2003-12",704.25]
[157,"2004-01",776.4]
[158,"2004-02",747]
[159,"2004-03",734]
[160,"2004-04",778]
[161,"2004-05",690]
[162,"2004-06",622.75]
[163,"2004-07",651.20000000000005]
[164,"2004-08",669.25]
[165,"2004-09",709.5]
[166,"2004-10",749.2]
[167,"2004-11",784.5]
[168,"2004-12",845.75]
[169,"2005-01",848.2]
[170,"2005-02",885]
[171,"2005-03",899.25]
[172,"2005-04",852.6]
[173,"2005-05",861.75]
[174,"2005-06",901.75]
[175,"2005-07",948.6]
[176,"2005-08",1004.25]
[177,"2005-09",1049]
[178,"2005-10",1045.8]
[179,"2005-11",1078.25]
[180,"2005-12",1162]
[181,"2006-01",1221]
[182,"2006-02",1262.25]
[183,"2006-03",1353]
[184,"2006-04",1451.8]
[185,"2006-05",1438.5]
[186,"2006-06",1227.25]
[187,"2006-07",1252.2]
[188,"2006-08",1348.75]
[189,"2006-09",1450.2]
[190,"2006-10",1529.5]
[191,"2006-11",1611]
[192,"2006-12",1643.6]
[193,"2007-01",1690.25]
[{"$f":"A194+1","v":194},"2007-02",1695.25]
[195,"2007-03",1534.6]
[196,"2007-04",1612.5]
[197,"2007-05",1706.5,{"$f":"VLOOKUP(DATE(VALUE(MID(B198,1,4)),VALUE(MID(B198,6,2)),1),I:J,2,TRUE)","v":0.06},{"$f":"VALUE(MID(B198,1,4))-VALUE(MID(B$2,1,4))","v":16},{"$f":"RATE(E198,0,-C198,EXP(FORECAST(A198+E198*12,LN(C$2:C198),A$2:A198))) + 1.25%","v":6.1684368030430758E-2},{"$f":"F198-D198","v":1.6843680304307607E-3}]
[198,"2007-06",1759.4,0.06,16,{"$f":"RATE(E199,0,-C199,EXP(FORECAST(A199+E199*12,LN(C$2:C199),A$2:A199))) + 1.25%","v":6.2227086286345504E-2},{"$f":"F199-D199","v":2.227086286345506E-3}]
[199,"2007-07",1871.25,0.06,16,{"$f":"RATE(E200,0,-C200,EXP(FORECAST(A200+E200*12,LN(C$2:C200),A$2:A200))) + 1.25%","v":6.0853015462402779E-2},8.5301546240278137E-4]
[200,"2007-08",1781,0.06,16,{"$f":"RATE(E201,0,-C201,EXP(FORECAST(A201+E201*12,LN(C$2:C201),A$2:A201))) + 1.25%","v":6.6537930555176289E-2},6.5379305551762912E-3]
[201,"2007-09",1964,0.06,16,{"$f":"RATE(E202,0,-C202,EXP(FORECAST(A202+E202*12,LN(C$2:C202),A$2:A202))) + 1.25%","v":6.2783564501190534E-2},2.7835645011905358E-3]
[202,"2007-10",2223.25,0.06,16,{"$f":"RATE(E203,0,-C203,EXP(FORECAST(A203+E203*12,LN(C$2:C203),A$2:A203))) + 1.25%","v":5.76417623172331E-2},-2.3582376827668977E-3]
[203,"2007-11",2411.25,0.06,16,{"$f":"RATE(E204,0,-C204,EXP(FORECAST(A204+E204*12,LN(C$2:C204),A$2:A204))) + 1.25%","v":5.547874476724067E-2},-4.5212552327593275E-3]
[204,"2007-12",2546.6,0.06,16,{"$f":"RATE(E205,0,-C205,EXP(FORECAST(A205+E205*12,LN(C$2:C205),A$2:A205))) + 1.25%","v":5.5129485065898765E-2},-4.8705149341012333E-3]
[205,"2008-01",2552.75,0.06,17,{"$f":"RATE(E206,0,-C206,EXP(FORECAST(A206+E206*12,LN(C$2:C206),A$2:A206))) + 1.25%","v":6.1344188570784483E-2},1.3441885707844853E-3]
[206,"2008-02",2231.5,0.06,17,{"$f":"RATE(E207,0,-C207,EXP(FORECAST(A207+E207*12,LN(C$2:C207),A$2:A207))) + 1.25%","v":7.226706204130183E-2},1.2267062041301832E-2]
[207,"2008-03",2005,0.06,17,{"$f":"RATE(E208,0,-C208,EXP(FORECAST(A208+E208*12,LN(C$2:C208),A$2:A208))) + 1.25%","v":8.1179683565643437E-2},2.117968356564344E-2]
[208,"2008-04",2011.25,0.06,17,{"$f":"RATE(E209,0,-C209,EXP(FORECAST(A209+E209*12,LN(C$2:C209),A$2:A209))) + 1.25%","v":8.3151701013169058E-2},2.315170101316906E-2]
[209,"2008-05",2110.8000000000002,0.06,17,{"$f":"RATE(E210,0,-C210,EXP(FORECAST(A210+E210*12,LN(C$2:C210),A$2:A210))) + 1.25%","v":8.2358324271474534E-2},2.2358324271474536E-2]
[210,"2008-06",1826.5,0.06,17,{"$f":"RATE(E211,0,-C211,EXP(FORECAST(A211+E211*12,LN(C$2:C211),A$2:A211))) + 1.25%","v":9.3276288197979965E-2},3.3276288197979967E-2]
[211,"2008-07",1667.5,0.06,17,{"$f":"RATE(E212,0,-C212,EXP(FORECAST(A212+E212*12,LN(C$2:C212),A$2:A212))) + 1.25%","v":0.10054582121186838},4.054582121186838E-2]
[212,"2008-08",1797.6,0.06,17,{"$f":"RATE(E213,0,-C213,EXP(FORECAST(A213+E213*12,LN(C$2:C213),A$2:A213))) + 1.25%","v":9.7380883608968932E-2},3.7380883608968934E-2]
[213,"2008-09",1695,0.06,17,{"$f":"RATE(E214,0,-C214,EXP(FORECAST(A214+E214*12,LN(C$2:C214),A$2:A214))) + 1.25%","v":0.10255691574386834},4.2556915743868343E-2]
[214,"2008-10",1252.25,0.06,17,{"$f":"RATE(E215,0,-C215,EXP(FORECAST(A215+E215*12,LN(C$2:C215),A$2:A215))) + 1.25%","v":0.12265019033106643},6.2650190331066433E-2]
[215,"2008-11",1112.4000000000001,0.06,17,{"$f":"RATE(E216,0,-C216,EXP(FORECAST(A216+E216*12,LN(C$2:C216),A$2:A216))) + 1.25%","v":0.13054827521356149},7.0548275213561495E-2]
[216,"2008-12",1125.75,0.06,17,{"$f":"RATE(E217,0,-C217,EXP(FORECAST(A217+E217*12,LN(C$2:C217),A$2:A217))) + 1.25%","v":0.12992116936818454},6.9921169368184544E-2]
[217,"2009-01",1113.4000000000001,0.05,18,{"$f":"RATE(E218,0,-C218,EXP(FORECAST(A218+E218*12,LN(C$2:C218),A$2:A218))) + 1.25%","v":0.13019469965236172},8.0194699652361714E-2]
[218,"2009-02",1078.5,0.04,18,{"$f":"RATE(E219,0,-C219,EXP(FORECAST(A219+E219*12,LN(C$2:C219),A$2:A219))) + 1.25%","v":0.1321588468016002},9.2158846801600192E-2]
[219,"2009-03",1057.5,0.04,18,{"$f":"RATE(E220,0,-C220,EXP(FORECAST(A220+E220*12,LN(C$2:C220),A$2:A220))) + 1.25%","v":0.13330079871944142},9.3300798719441413E-2]
[220,"2009-04",1282.25,3.5000000000000003E-2,18,{"$f":"RATE(E221,0,-C221,EXP(FORECAST(A221+E221*12,LN(C$2:C221),A$2:A221))) + 1.25%","v":0.12180559434960712},8.6805594349607121E-2]
[221,"2009-05",1527.4,3.2500000000000001E-2,18,{"$f":"RATE(E222,0,-C222,EXP(FORECAST(A222+E222*12,LN(C$2:C222),A$2:A222))) + 1.25%","v":0.11196509674813472},7.946509674813472E-2]
[222,"2009-06",1813.5,3.2500000000000001E-2,18,{"$f":"RATE(E223,0,-C223,EXP(FORECAST(A223+E223*12,LN(C$2:C223),A$2:A223))) + 1.25%","v":0.10283659215103233},7.0336592151032329E-2]
[223,"2009-07",1785.25,3.2500000000000001E-2,18,{"$f":"RATE(E224,0,-C224,EXP(FORECAST(A224+E224*12,LN(C$2:C224),A$2:A224))) + 1.25%","v":0.10501753064407175},7.2517530644071751E-2]
[224,"2009-08",1892.4,3.2500000000000001E-2,18,{"$f":"RATE(E225,0,-C225,EXP(FORECAST(A225+E225*12,LN(C$2:C225),A$2:A225))) + 1.25%","v":0.1028275542968167},7.0327554296816697E-2]
[225,"2009-09",2004.75,3.2500000000000001E-2,18,{"$f":"RATE(E226,0,-C226,EXP(FORECAST(A226+E226*12,LN(C$2:C226),A$2:A226))) + 1.25%","v":0.10078902803922005},6.8289028039220045E-2]
[226,"2009-10",2071.8000000000002,3.2500000000000001E-2,18,{"$f":"RATE(E227,0,-C227,EXP(FORECAST(A227+E227*12,LN(C$2:C227),A$2:A227))) + 1.25%","v":0.10029294630242248},6.7792946302422483E-2]
[227,"2009-11",2071,3.2500000000000001E-2,18,{"$f":"RATE(E228,0,-C228,EXP(FORECAST(A228+E228*12,LN(C$2:C228),A$2:A228))) + 1.25%","v":0.10176505608548148},6.9265056085481475E-2]
[228,"2009-12",2139,3.2500000000000001E-2,18,{"$f":"RATE(E229,0,-C229,EXP(FORECAST(A229+E229*12,LN(C$2:C229),A$2:A229))) + 1.25%","v":0.10130014923465604},6.8800149234656036E-2]
[229,"2010-01",2162.8000000000002,3.2500000000000001E-2,19,{"$f":"RATE(E230,0,-C230,EXP(FORECAST(A230+E230*12,LN(C$2:C230),A$2:A230))) + 1.25%","v":0.1032686408047246},7.07686408047246E-2]
[230,"2010-02",2047,3.2500000000000001E-2,19,{"$f":"RATE(E231,0,-C231,EXP(FORECAST(A231+E231*12,LN(C$2:C231),A$2:A231))) + 1.25%","v":0.10768762945742139},7.5187629457421384E-2]
[231,"2010-03",2178.5,3.2500000000000001E-2,19,{"$f":"RATE(E232,0,-C232,EXP(FORECAST(A232+E232*12,LN(C$2:C232),A$2:A232))) + 1.25%","v":0.10547255986633666},7.2972559866336661E-2]
[232,"2010-04",2229.25,3.5000000000000003E-2,19,{"$f":"RATE(E233,0,-C233,EXP(FORECAST(A233+E233*12,LN(C$2:C233),A$2:A233))) + 1.25%","v":0.10553274691644232},7.0532746916442318E-2]
[233,"2010-05",2148.4,3.7499999999999999E-2,19,{"$f":"RATE(E234,0,-C234,EXP(FORECAST(A234+E234*12,LN(C$2:C234),A$2:A234))) + 1.25%","v":0.10891836513391626},7.1418365133916251E-2]
[234,"2010-06",2196,3.7499999999999999E-2,19,{"$f":"RATE(E235,0,-C235,EXP(FORECAST(A235+E235*12,LN(C$2:C235),A$2:A235))) + 1.25%","v":0.10892841728070225},7.1428417280702261E-2]
[235,"2010-07",2273.6,3.7499999999999999E-2,19,{"$f":"RATE(E236,0,-C236,EXP(FORECAST(A236+E236*12,LN(C$2:C236),A$2:A236))) + 1.25%","v":0.10824508763973753},7.0745087639737525E-2]
[236,"2010-08",2325.5,4.4999999999999998E-2,19,{"$f":"RATE(E237,0,-C237,EXP(FORECAST(A237+E237*12,LN(C$2:C237),A$2:A237))) + 1.25%","v":0.10827850560505048},6.3278505605050481E-2]
[237,"2010-09",2445.25,4.4999999999999998E-2,19,{"$f":"RATE(E238,0,-C238,EXP(FORECAST(A238+E238*12,LN(C$2:C238),A$2:A238))) + 1.25%","v":0.10679912044862888},6.1799120448628883E-2]
[238,"2010-10",2565.4,0.05,19,{"$f":"RATE(E239,0,-C239,EXP(FORECAST(A239+E239*12,LN(C$2:C239),A$2:A239))) + 1.25%","v":0.10552349873603492},5.5523498736034918E-2]
[239,"2010-11",2525.5,0.05,19,{"$f":"RATE(E240,0,-C240,EXP(FORECAST(A240+E240*12,LN(C$2:C240),A$2:A240))) + 1.25%","v":0.10783459559858168},5.7834595598581673E-2]
[240,"2010-12",2467.75,5.2499999999999998E-2,19,{"$f":"RATE(E241,0,-C241,EXP(FORECAST(A241+E241*12,LN(C$2:C241),A$2:A241))) + 1.25%","v":0.11048815122029682},5.7988151220296817E-2]
[241,"2011-01",2387.4,5.2499999999999998E-2,20,{"$f":"RATE(E242,0,-C242,EXP(FORECAST(A242+E242*12,LN(C$2:C242),A$2:A242))) + 1.25%","v":0.11444081018899115},6.1940810188991148E-2]
[242,"2011-02",2205.5,5.5E-2,20,{"$f":"RATE(E243,0,-C243,EXP(FORECAST(A243+E243*12,LN(C$2:C243),A$2:A243))) + 1.25%","v":0.11977679677038397},6.4776796770383976E-2]
[243,"2011-03",2255.5,5.5E-2,20,{"$f":"RATE(E244,0,-C244,EXP(FORECAST(A244+E244*12,LN(C$2:C244),A$2:A244))) + 1.25%","v":0.11951737563835389},6.4517375638353885E-2]
[244,"2011-04",2393,5.7500000000000002E-2,20,{"$f":"RATE(E245,0,-C245,EXP(FORECAST(A245+E245*12,LN(C$2:C245),A$2:A245))) + 1.25%","v":0.11732749566620453},5.9827495666204523E-2]
[245,"2011-05",2274.75,5.7500000000000002E-2,20,{"$f":"RATE(E246,0,-C246,EXP(FORECAST(A246+E246*12,LN(C$2:C246),A$2:A246))) + 1.25%","v":0.12107011785685846},6.3570117856858455E-2]
[246,"2011-06",2257.5,6.25E-2,20,{"$f":"RATE(E247,0,-C247,EXP(FORECAST(A247+E247*12,LN(C$2:C247),A$2:A247))) + 1.25%","v":0.12238680597624024},5.9886805976240243E-2]
[247,"2011-07",2305.8000000000002,6.5000000000000002E-2,20,{"$f":"RATE(E248,0,-C248,EXP(FORECAST(A248+E248*12,LN(C$2:C248),A$2:A248))) + 1.25%","v":0.12212547431434352},5.7125474314343519E-2]
[248,"2011-08",2056,7.0000000000000007E-2,20,{"$f":"RATE(E249,0,-C249,EXP(FORECAST(A249+E249*12,LN(C$2:C249),A$2:A249))) + 1.25%","v":0.12914388980767288},5.9143889807672878E-2]
[249,"2011-09",2069.25,7.0000000000000007E-2,20,{"$f":"RATE(E250,0,-C250,EXP(FORECAST(A250+E250*12,LN(C$2:C250),A$2:A250))) + 1.25%","v":0.12941504672191934},5.9415046721919329E-2]
[250,"2011-10",2066.4,7.2499999999999995E-2,20,{"$f":"RATE(E251,0,-C251,EXP(FORECAST(A251+E251*12,LN(C$2:C251),A$2:A251))) + 1.25%","v":0.13009668555116935},5.7596685551169355E-2]
[251,"2011-11",2036,7.4999999999999997E-2,20,{"$f":"RATE(E252,0,-C252,EXP(FORECAST(A252+E252*12,LN(C$2:C252),A$2:A252))) + 1.25%","v":0.13147671825671642},5.6476718256716421E-2]
[252,"2011-12",1922,7.4999999999999997E-2,20,{"$f":"RATE(E253,0,-C253,EXP(FORECAST(A253+E253*12,LN(C$2:C253),A$2:A253))) + 1.25%","v":0.13511372667537369},6.0113726675373694E-2]
[253,"2012-01",1999.75,7.4999999999999997E-2,21,{"$f":"RATE(E254,0,-C254,EXP(FORECAST(A254+E254*12,LN(C$2:C254),A$2:A254))) + 1.25%","v":0.13330040256132208},5.8300402561322087E-2]
[254,"2012-02",2198.25,7.4999999999999997E-2,21,{"$f":"RATE(E255,0,-C255,EXP(FORECAST(A255+E255*12,LN(C$2:C255),A$2:A255))) + 1.25%","v":0.12888730864318185},5.388730864318185E-2]
[255,"2012-03",2164.6,7.4999999999999997E-2,21,{"$f":"RATE(E256,0,-C256,EXP(FORECAST(A256+E256*12,LN(C$2:C256),A$2:A256))) + 1.25%","v":0.13028136784558597},5.5281367845585974E-2]
[256,"2012-04",2148.25,7.4999999999999997E-2,21,{"$f":"RATE(E257,0,-C257,EXP(FORECAST(A257+E257*12,LN(C$2:C257),A$2:A257))) + 1.25%","v":0.13122292062937102},5.6222920629371023E-2]
[257,"2012-05",2018,7.0000000000000007E-2,21,{"$f":"RATE(E258,0,-C258,EXP(FORECAST(A258+E258*12,LN(C$2:C258),A$2:A258))) + 1.25%","v":0.13495172790668875},6.4951727906688739E-2]
[{"$f":"A258+1","v":258},"2012-06",2064,7.0000000000000007E-2,21,{"$f":"RATE(E259,0,-C259,EXP(FORECAST(A259+E259*12,LN(C$2:C259),A$2:A259))) + 1.25%","v":0.1341680124956503},6.4168012495650295E-2]
[259,"2012-07",2117,7.0000000000000007E-2,21,{"$f":"RATE(E260,0,-C260,EXP(FORECAST(A260+E260*12,LN(C$2:C260),A$2:A260))) + 1.25%","v":0.13326833436236854},6.3268334362368533E-2]
[260,"2012-08",2149.5,7.0000000000000007E-2,21,{"$f":"RATE(E261,0,-C261,EXP(FORECAST(A261+E261*12,LN(C$2:C261),A$2:A261))) + 1.25%","v":0.13292172133190752},6.2921721331907515E-2]
[261,"2012-09",2222.6,{"$f":"VLOOKUP(DATE(VALUE(MID(B262,1,4)),VALUE(MID(B262,6,2)),1),I:J,2,TRUE)","v":7.0000000000000007E-2},{"$f":"VALUE(MID(B262,1,4))-VALUE(MID(B$2,1,4))","v":21},{"$f":"RATE(E262,0,-C262,EXP(FORECAST(A262+E262*12,LN(C$2:C262),A$2:A262))) + 1.25%","v":0.13165303830960803},{"$f":"F262-D262","v":6.1653038309608027E-2}]
[262,"2012-10",2309.75,7.0000000000000007E-2,21,{"$f":"RATE(E263,0,-C263,EXP(FORECAST(A263+E263*12,LN(C$2:C263),A$2:A263))) + 1.25%","v":0.13017579938230409},6.0175799382304079E-2]
[263,"2012-11",2294.75,7.0000000000000007E-2,21,{"$f":"RATE(E264,0,-C264,EXP(FORECAST(A264+E264*12,LN(C$2:C264),A$2:A264))) + 1.25%","v":0.13106109077950359},6.1061090779503585E-2]
[264,"2012-12",2404.6,7.0000000000000007E-2,21,{"$f":"RATE(E265,0,-C265,EXP(FORECAST(A265+E265*12,LN(C$2:C265),A$2:A265))) + 1.25%","v":0.12918289239977532},5.9182892399775311E-2]
[265,"2013-01",2468,7.0000000000000007E-2,22,{"$f":"RATE(E266,0,-C266,EXP(FORECAST(A266+E266*12,LN(C$2:C266),A$2:A266))) + 1.25%","v":0.12861024389318199},5.8610243893181979E-2]
[266,"2013-02",2404.5,6.7500000000000004E-2,22,{"$f":"RATE(E267,0,-C267,EXP(FORECAST(A267+E267*12,LN(C$2:C267),A$2:A267))) + 1.25%","v":0.1304789027273856},6.2978902727385599E-2]
[267,"2013-03",2330.1999999999998,6.7500000000000004E-2,22,{"$f":"RATE(E268,0,-C268,EXP(FORECAST(A268+E268*12,LN(C$2:C268),A$2:A268))) + 1.25%","v":0.13254341734106895},6.5043417341068943E-2]
[268,"2013-04",2294.25,6.5000000000000002E-2,22,{"$f":"RATE(E269,0,-C269,EXP(FORECAST(A269+E269*12,LN(C$2:C269),A$2:A269))) + 1.25%","v":0.13375748072557914},6.8757480725579134E-2]
[269,"2013-05",2440,6.5000000000000002E-2,22,{"$f":"RATE(E270,0,-C270,EXP(FORECAST(A270+E270*12,LN(C$2:C270),A$2:A270))) + 1.25%","v":0.13114208743888783},6.6142087438887831E-2]
[270,"2013-06",2343,6.25E-2,22,{"$f":"RATE(E271,0,-C271,EXP(FORECAST(A271+E271*12,LN(C$2:C271),A$2:A271))) + 1.25%","v":0.13363376440657077},7.1133764406570765E-2]
[271,"2013-07",2365.25,6.25E-2,22,{"$f":"RATE(E272,0,-C272,EXP(FORECAST(A272+E272*12,LN(C$2:C272),A$2:A272))) + 1.25%","v":0.13358031917175248},7.1080319171752476E-2]
[272,"2013-08",2193.6,6.25E-2,22,{"$f":"RATE(E273,0,-C273,EXP(FORECAST(A273+E273*12,LN(C$2:C273),A$2:A273))) + 1.25%","v":0.13770087992012423},7.5200879920124225E-2]
[273,"2013-09",2311.75,6.25E-2,22,{"$f":"RATE(E274,0,-C274,EXP(FORECAST(A274+E274*12,LN(C$2:C274),A$2:A274))) + 1.25%","v":0.13537744458193324},7.2877444581933237E-2]
[274,"2013-10",2409.25,6.5000000000000002E-2,22,{"$f":"RATE(E275,0,-C275,EXP(FORECAST(A275+E275*12,LN(C$2:C275),A$2:A275))) + 1.25%","v":0.13368689199212708},6.8686891992127075E-2]
[275,"2013-11",2444.1999999999998,6.7500000000000004E-2,22,{"$f":"RATE(E276,0,-C276,EXP(FORECAST(A276+E276*12,LN(C$2:C276),A$2:A276))) + 1.25%","v":0.13337912489558248},6.587912489558248E-2]
[276,"2013-12",2497.25,6.7500000000000004E-2,22,{"$f":"RATE(E277,0,-C277,EXP(FORECAST(A277+E277*12,LN(C$2:C277),A$2:A277))) + 1.25%","v":0.13273393932695593},6.5233939326955925E-2]
[277,"2014-01",2490.75,6.7500000000000004E-2,23,{"$f":"RATE(E278,0,-C278,EXP(FORECAST(A278+E278*12,LN(C$2:C278),A$2:A278))) + 1.25%","v":0.13323172822684451},6.5731728226844505E-2]
[278,"2014-02",2426.5,7.0000000000000007E-2,23,{"$f":"RATE(E279,0,-C279,EXP(FORECAST(A279+E279*12,LN(C$2:C279),A$2:A279))) + 1.25%","v":0.13485332979973971},6.4853329799739706E-2]
[279,"2014-03",2583.8000000000002,7.0000000000000007E-2,23,{"$f":"RATE(E280,0,-C280,EXP(FORECAST(A280+E280*12,LN(C$2:C280),A$2:A280))) + 1.25%","v":0.13223322312760197},6.2233223127601961E-2]
[280,"2014-04",2712.5,7.0000000000000007E-2,23,{"$f":"RATE(E281,0,-C281,EXP(FORECAST(A281+E281*12,LN(C$2:C281),A$2:A281))) + 1.25%","v":0.13037672341901382},6.0376723419013817E-2]
[281,"2014-05",2861,7.0000000000000007E-2,23,{"$f":"RATE(E282,0,-C282,EXP(FORECAST(A282+E282*12,LN(C$2:C282),A$2:A282))) + 1.25%","v":0.1283694829941861},5.8369482994186095E-2]
[282,"2014-06",3081.25,7.0000000000000007E-2,23,{"$f":"RATE(E283,0,-C283,EXP(FORECAST(A283+E283*12,LN(C$2:C283),A$2:A283))) + 1.25%","v":0.12546295960204348},5.5462959602043477E-2]
[283,"2014-07",3129.75,7.0000000000000007E-2,23,{"$f":"RATE(E284,0,-C284,EXP(FORECAST(A284+E284*12,LN(C$2:C284),A$2:A284))) + 1.25%","v":0.12539963857285144},5.5399638572851434E-2]
[284,"2014-08",3161.8,7.0000000000000007E-2,23,{"$f":"RATE(E285,0,-C285,EXP(FORECAST(A285+E285*12,LN(C$2:C285),A$2:A285))) + 1.25%","v":0.12559620190575319},5.5596201905753179E-2]
[285,"2014-09",3299.5,7.0000000000000007E-2,23,{"$f":"RATE(E286,0,-C286,EXP(FORECAST(A286+E286*12,LN(C$2:C286),A$2:A286))) + 1.25%","v":0.12427458358562384},5.4274583585623828E-2]
[286,"2014-10",3225.5,7.0000000000000007E-2,23,{"$f":"RATE(E287,0,-C287,EXP(FORECAST(A287+E287*12,LN(C$2:C287),A$2:A287))) + 1.25%","v":0.12605440468755086},5.6054404687550852E-2]
[287,"2014-11",3444.2,7.0000000000000007E-2,23,{"$f":"RATE(E288,0,-C288,EXP(FORECAST(A288+E288*12,LN(C$2:C288),A$2:A288))) + 1.25%","v":0.12365208090171693},5.3652080901716928E-2]
[288,"2014-12",3415.5,7.0000000000000007E-2,23,{"$f":"RATE(E289,0,-C289,EXP(FORECAST(A289+E289*12,LN(C$2:C289),A$2:A289))) + 1.25%","v":0.12479215219499841},5.4792152194998403E-2]
[289,"2015-01",3542.4,7.0000000000000007E-2,24,{"$f":"RATE(E290,0,-C290,EXP(FORECAST(A290+E290*12,LN(C$2:C290),A$2:A290))) + 1.25%","v":0.12419119433649922},5.4191194336499215E-2]
[290,"2015-02",3635.25,6.7500000000000004E-2,24,{"$f":"RATE(E291,0,-C291,EXP(FORECAST(A291+E291*12,LN(C$2:C291),A$2:A291))) + 1.25%","v":0.12376352964397254},5.6263529643972535E-2]
[291,"2015-03",3587,6.7500000000000004E-2,24,{"$f":"RATE(E292,0,-C292,EXP(FORECAST(A292+E292*12,LN(C$2:C292),A$2:A292))) + 1.25%","v":0.12511180085561016},5.7611800855610157E-2]
[292,"2015-04",3576.5,6.5000000000000002E-2,24,{"$f":"RATE(E293,0,-C293,EXP(FORECAST(A293+E293*12,LN(C$2:C293),A$2:A293))) + 1.25%","v":0.12595324766948512},6.0953247669485122E-2]
[293,"2015-05",3475,6.5000000000000002E-2,24,{"$f":"RATE(E294,0,-C294,EXP(FORECAST(A294+E294*12,LN(C$2:C294),A$2:A294))) + 1.25%","v":0.12793217408398067},6.2932174083980663E-2]
[294,"2015-06",3421.75,6.5000000000000002E-2,24,{"$f":"RATE(E295,0,-C295,EXP(FORECAST(A295+E295*12,LN(C$2:C295),A$2:A295))) + 1.25%","v":0.1292510646552392},6.4251064655239193E-2]
[295,"2015-07",3563.25,6.25E-2,24,{"$f":"RATE(E296,0,-C296,EXP(FORECAST(A296+E296*12,LN(C$2:C296),A$2:A296))) + 1.25%","v":0.12801270295725251},6.5512702957252505E-2]
[296,"2015-08",3540,6.25E-2,24,{"$f":"RATE(E297,0,-C297,EXP(FORECAST(A297+E297*12,LN(C$2:C297),A$2:A297))) + 1.25%","v":0.12893492909442766},6.6434929094427664E-2]
[297,"2015-09",3300.25,6.25E-2,24,{"$f":"RATE(E298,0,-C298,EXP(FORECAST(A298+E298*12,LN(C$2:C298),A$2:A298))) + 1.25%","v":0.13269663677820226},7.0196636778202259E-2]
[298,"2015-10",3432.6,5.7500000000000002E-2,24,{"$f":"RATE(E299,0,-C299,EXP(FORECAST(A299+E299*12,LN(C$2:C299),A$2:A299))) + 1.25%","v":0.13140161755994162},7.3901617559941624E-2]
[299,"2015-11",3334.5,5.7500000000000002E-2,24,{"$f":"RATE(E300,0,-C300,EXP(FORECAST(A300+E300*12,LN(C$2:C300),A$2:A300))) + 1.25%","v":0.133233648320391},7.5733648320391006E-2]
[300,"2015-12",3297.25,5.7500000000000002E-2,24,{"$f":"RATE(E301,0,-C301,EXP(FORECAST(A301+E301*12,LN(C$2:C301),A$2:A301))) + 1.25%","v":0.13420617705868276},7.6706177058682767E-2]
[301,"2016-01",3224,5.7500000000000002E-2,{"$f":"VALUE(MID(B302,1,4))-VALUE(MID(B$2,1,4))","v":25},{"$f":"RATE(E302,0,-C302,EXP(FORECAST(A302+E302*12,LN(C$2:C302),A$2:A302))) + 1.25%","v":0.13559820227837169},7.8098202278371692E-2]
[302,"2016-02",3024.5,5.7500000000000002E-2,{"$f":"E302","v":25},{"$f":"RATE(E303,0,-C303,EXP(FORECAST(A303+E303*12,LN(C3:C303),$A3:$A303))) + 1.25%","v":0.1383298041134744},8.0829804113474402E-2]
[303,"2016-03",3187.75,5.7500000000000002E-2,25,0.13595616930589435,7.8456169305894358E-2]
[304,"2016-04",3286.2,5.7500000000000002E-2,25,0.13474002911610669,7.7240029116106695E-2]
[305,"2016-05",3328.5,0.06,25,0.13437029263255848,7.4370292632558482E-2]
[306,"2016-06",3443.5,0.06,25,0.13307315240238898,7.3073152402388986E-2]
[307,"2016-07",3607.8,0.06,25,0.13124846821676209,7.124846821676209E-2]
[308,"2016-08",3704.25,0.06,25,0.13049666212332475,7.0496662123324755E-2]
[309,"2016-09",3788.25,0.06,25,0.13008689299968024,7.0086892999680239E-2]
[310,"2016-10",3753.8,0.06,25,0.13110472124077857,7.1104721240778573E-2]
[311,"2016-11",3550,5.7500000000000002E-2,25,0.13407161376722182,7.6571613767221824E-2]
[312,"2016-12",3501.8,5.7500000000000002E-2,25,0.13515993115015296,7.7659931150152961E-2]
[313,"2017-01",3633.25,5.7500000000000002E-2,25,0.13398489559750187,7.6484895597501878E-2]
[314,"2017-02",3828,5.7500000000000002E-2,25,0.13228444430414385,7.4784444304143854E-2]
[315,"2017-03",3909.25,5.7500000000000002E-2,25,0.13221671064098975,7.4716710640989753E-2]
[316,"2017-04",4018.4,5.7500000000000002E-2,25,0.13236639761836769,7.4866397618367692E-2]
[317,"2017-05",4114,0.06,25,0.13296323002178195,7.2963230021781955E-2]
[318,"2017-06",4182.25,0.06,25,0.13356443011736696,7.3564430117366963E-2]
[{"$f":"A319+1","v":319},"2017-07",4269,{"$f":"VLOOKUP(DATE(VALUE(MID(B320,1,4)),VALUE(MID(B320,6,2)),1),I:J,2,TRUE)","v":0.06},{"$f":"E319","v":25},0.13381575767262621,{"$f":"F320-D320","v":7.3815757672626214E-2}]

{"sheet":"Beta","index":1,"n_rows":212,"n_cols":9,"rows_kept":212,"cut":false,"hidden":false,"merged":[]}
["Week","Date","Stock Price","Stock Returns","BSE200 Index","BSE200 Returns","Beta","Moving Avg","Beta Forecast"]
[1,"2013-07-20",644.09997599999997]
[{"$f":"A2+1","v":2},"2013-07-27",631.25,-0.13538968683776784]
[3,"2013-08-03",610.5,-0.15999455337690632,2238,-4.1131105398457581E-2]
[4,"2013-08-10",587.90002400000003,-8.3644026584535625E-2,2204,-1.519213583556747E-2]
[5,"2013-08-17",607.54998799999998,-8.7210330797806407E-2,2188,-7.2595281306715061E-3]
[6,"2013-08-24",594,4.8449612403100775E-3,2170,-8.2266910420475316E-3]
[7,"2013-08-31",616.20001200000002,-6.1716489874638382E-2,2168,-9.2165898617511521E-4]
[8,"2013-09-07",629.20001200000002,0.20349434737923947,2246,3.5977859778597784E-2]
[9,"2013-09-14",659.04998799999998,-3.9624252775405711E-2,2312,2.9385574354407838E-2]
[10,"2013-09-21",608.90002400000003,0.26711719722568034,2373,2.6384083044982697E-2]
[11,"2013-09-28",640.45001200000002,-0.14484210526315797,2316,-2.402022756005057E-2]
[12,"2013-10-05",661.29998799999998,3.4629903167569379E-2,2346,1.2953367875647668E-2]
[13,"2013-10-12",676.59997599999997,0.10152284263959391,2413,2.8559249786871271E-2]
[14,"2013-10-19",672.54998799999998,-2.304147465437821E-3,2444,1.28470783257356E-2]
[15,"2013-10-26",683.79998799999998,2.5981524249422634E-2,2434,-4.0916530278232409E-3]
[16,"2013-11-02",652.5,6.3731007315700722E-2,2501,2.7526705012325389E-2]
[17,"2013-11-09",642.20001200000002,-6.4012696733236313E-2,2446,-2.1991203518592562E-2]
[18,"2013-11-16",642.15002400000003,-1.0173802458668991E-2,2416,-1.2264922322158627E-2]
[19,"2013-11-23",661.29998799999998,-1.6274089935760138E-2,2394,-9.1059602649006619E-3]
[20,"2013-11-30",682.70001200000002,7.0091423595994712E-2,2464,2.9239766081871343E-2]
[21,"2013-12-07",689.95001200000002,6.3466232709520023E-2,2495,1.2581168831168832E-2]
[22,"2013-12-14",664.59997599999997,-6.6309614894159652E-2,2455,-1.6032064128256512E-2]
[23,"2013-12-21",669.65002400000003,1.1881999453701081E-2,2508,2.1588594704684317E-2]
[24,"2013-12-28",663.09997599999997,8.9080847617762499E-3,2531,9.1706539074960132E-3]
[25,"2014-01-04",662.04998799999998,-8.6956521739130436E-3,2498,-1.3038324772817068E-2]
[26,"2014-01-11",665,-7.4358974358974386E-2,2478,-8.0064051240992789E-3]
[27,"2014-01-18",673.40002400000003,2.5076541769937375E-2,2495,6.8603712671509278E-3]
[28,"2014-01-25",628.5,-1.0951500497795542E-2,2492,-1.2024048096192384E-3]
[29,"2014-02-01",647.75,-0.11432269197584125,2426,-2.6484751203852328E-2]
[30,"2014-02-08",641.79998799999998,3.4096444227959453E-3,2420,-2.4732069249793899E-3]
[31,"2014-02-15",664.40002400000003,-2.7669902912621395E-2,2410,-4.1322314049586778E-3]
[32,"2014-02-22",669.59997599999997,1.8139457480445962E-2,2450,1.6597510373443983E-2]
[33,"2014-03-01",711.45001200000002,-3.7593984962405276E-3,2495,1.8367346938775512E-2]
[34,"2014-03-08",732.15002400000003,0.23281378178835108,2589,3.7675350701402807E-2]
[35,"2014-03-15",733.84997599999997,-5.2568538727708281E-2,2578,-4.248744689069139E-3]
[36,"2014-03-22",744.95001200000002,1.236128669756998E-2,2587,3.4910783553141972E-3,{"$f":"COVAR(D8:D37,F8:F37)/VARP(F8:F37)","v":3.8759644669839028}]
[37,"2014-03-29",725.45001200000002,0.12362980435687512,2670,3.2083494395052183E-2,3.8564839798317356]
[38,"2014-04-05",738.15002400000003,4.2726599160286524E-2,2684,5.2434456928838954E-3,3.632192132801602]
[39,"2014-04-12",718.70001200000002,4.914732354334439E-2,2722,1.4157973174366617E-2,4.000813102556581]
[40,"2014-04-19",726.40002400000003,-5.8810249463822128E-2,2719,-1.1021307861866275E-3,3.6223609947220647]
[41,"2014-04-26",717.09997599999997,0.12269129287598954,2725,2.206693637366679E-3,3.386628535091234]
[42,"2014-05-03",756.79998799999998,-5.2344834953530602E-2,2691,-1.2477064220183486E-2,3.4105467604592876]
[43,"2014-05-10",804.70001200000002,9.1083305151617583E-2,2751,2.2296544035674472E-2,3.4301411840398623]
[44,"2014-05-17",789.65002400000003,0.12428969934910639,2898,5.3435114503816793E-2,3.1930590952150348]
[45,"2014-05-24",792.75,3.6849843778717063E-2,3014,4.0027605244996552E-2,2.970127883394611]
[46,"2014-05-31",815.25,9.3946645395729302E-3,2951,-2.0902455209024551E-2,2.8221238883250415]
[47,"2014-06-07",835.40002400000003,2.0370532970409885E-2,3109,5.3541172483903762E-2,2.3532480191197354]
[48,"2014-06-14",821.95001200000002,-9.2332845710351913E-2,3074,-1.1257639112254744E-2,2.48447193170596]
[49,"2014-06-21",816.20001200000002,2.645051194539258E-2,3062,-3.9037085230969422E-3,2.4596019507753843]
[50,"2014-06-28",856.65002400000003,-1.4962593516209518E-2,3080,5.8785107772697581E-3,2.4612544208039226]
[51,"2014-07-05",811.79998799999998,4.5007032348804502E-2,3186,3.4415584415584413E-2,2.3767667705695912]
[52,"2014-07-12",832.45001200000002,-8.4881112606550041E-2,3039,-4.6139359698681735E-2,2.2342514740370092]
[53,"2014-07-19",835.5,8.5694675948622387E-2,3133,3.0931227377426786E-2,2.2934293246967781]
[54,"2014-07-26",815.45001200000002,-2.6641379933170777E-2,3161,8.9371209703159905E-3,2.2907765218503875]
[55,"2014-08-02",796.15002400000003,-5.0102059751344066E-3,3103,-1.834862385321101E-2,2.2566802659222298]
[56,"2014-08-09",826.70001200000002,-2.7694889966430478E-2,3084,-6.1231066709635839E-3,2.2131197729788354]
[57,"2014-08-16",846.75,3.6252037978325456E-2,3161,2.4967574578469522E-2,2.1942029063233939]
[58,"2014-08-23",843.54998799999998,8.0610828320222039E-2,3227,2.0879468522619425E-2,2.2162959425413251]
[59,"2014-08-30",848.45001200000002,-2.0811921891058544E-2,3234,2.1691973969631237E-3,2.0925604393005819]
[60,"2014-09-06",855.70001200000002,6.9885419399982593E-2,3303,2.1335807050092765E-2,2.1144827501792696]
[61,"2014-09-13",860.25,3.4744931327665138E-2,3329,7.8716318498334853E-3,2.0884360187965267]
[62,"2014-09-20",871.65002400000003,-7.9876748044560422E-2,3319,-3.0039050765995794E-3,2.1682896506158826]
[63,"2014-09-27",868,-1.4940752189592878E-2,3247,-2.1693281108767701E-2,2.1349823322645678]
[64,"2014-10-04",867.29998799999998,-2.7022315202231518E-2,3243,-1.2319063751154912E-3,1.8546159973509064]
[65,"2014-10-11",885.25,2.5443468912381171E-2,3208,-1.0792476102374344E-2,1.7644104522291322]
[{"$f":"A66+1","v":66},"2014-10-18",893.65002400000003,4.4906517560719984E-2,3173,-1.0910224438902744E-2,1.694846466832149]
[67,"2014-10-25",911.84997599999997,3.8545150501672162E-2,3278,3.3091711314213679E-2,1.5527454280522208]
[68,"2014-11-01",899.45001200000002,0.10160212543273493,3392,3.4777303233679072E-2,1.6284951740126192]
[69,"2014-11-08",930.09997599999997,-1.1474091938902321E-2,3408,4.7169811320754715E-3,1.6246009467860059]
[70,"2014-11-15",932.84997599999997,2.5580363743900738E-2,3439,9.0962441314553985E-3,1.590393216089705]
[71,"2014-11-22",957.15002400000003,1.412918108419832E-2,3472,9.5958127362605408E-3,1.6335333429635446]
[72,"2014-11-29",942.75,9.9516633494455501E-3,3510,1.0944700460829493E-2,1.5860673180498459]
[73,"2014-12-06",931.5,5.9895833333333433E-2,3514,1.1396011396011395E-3,1.5122364251757276]
[74,"2014-12-13",941.45001200000002,-7.0522611063151636E-2,3387,-3.6141149686966419E-2,1.4379079212893655]
[75,"2014-12-20",948.65002400000003,3.8079588483246378E-2,3381,-1.7714791851195749E-3,1.479655257251355]
[76,"2014-12-27",965.29998799999998,2.0853406744666177E-2,3380,-2.9577048210588581E-4,1.5436019112297117]
[77,"2015-01-03",975.65002400000003,6.8900424728645618E-2,3474,2.7810650887573965E-2,1.8740139031957375]
[78,"2015-01-10",1001.349976,-3.5446231472721565E-2,3431,-1.2377662636729994E-2,1.7979765710861775]
[79,"2015-01-17",1042.8000489999999,5.0088275681684523E-2,3526,2.7688720489653162E-2,1.8057123853493664]
[80,"2015-01-24",1077.349976,9.0105236938788094E-2,3640,3.2331253545093593E-2,1.8607953171353044]
[81,"2015-01-31",1053.5,-1.4623557637381417E-2,3641,2.7472527472527473E-4,1.9345431594694245]
[82,"2015-02-07",1065.8000489999999,-6.1101449275362374E-2,3571,-1.9225487503433124E-2,1.9990775237155125]
[83,"2015-02-14",1073.0500489999999,3.1304025685354439E-2,3642,1.9882385886306357E-2,1.9269219363496792]
[84,"2015-02-21",1054,-1.2812069688079904E-2,3654,3.2948929159802307E-3,1.9517739930467566]
[85,"2015-02-28",1085.099976,-4.3665473952332135E-3,3674,5.4734537493158182E-3,2.0217204399865492]
[86,"2015-03-07",1042.650024,4.3735152585734273E-2,3705,8.4376701143168212E-3,2.0003485168372519]
[87,"2015-03-14",1055.900024,-6.2503647505106452E-2,3598,-2.8879892037786774E-2,2.0761307561656599,{"$f":"AVERAGE(G37:G88)","v":2.2843349399144626}]
[88,"2015-03-21",1014.650024,3.6167828685258904E-2,3569,-8.0600333518621465E-3,1.9568234018126809,2.2474283809688615]
[89,"2015-03-28",1033.25,-1.988585160708916E-2,3476,-2.6057719249089381E-2,1.8849960890905202,2.2095151523007615]
[90,"2015-04-04",1042.650024,3.8371950471987194E-2,3579,2.9631760644418872E-2,1.7821449399190707,2.1739373216684053]
[91,"2015-04-11",1018.25,-6.0212514757969574E-3,3669,2.5146689019279127E-2,1.6626696140392374,2.1289730238123021]
[92,"2015-04-18",1006.450012,-3.7593538424991066E-2,3595,-2.0168983374216409E-2,1.6399044060227468,2.0908488586450078]
[93,"2015-04-25",988.79998799999998,1.7155199012650387E-2,3463,-3.6717663421418634E-2,1.4459206131557469,2.0535275524539411]
[94,"2015-05-02",982,1.8989261663532098E-2,3425,-1.0973144672249495E-2,1.4109227363046135,2.01507324429712]
[95,"2015-05-09",990.09997599999997,-1.6134793998571036E-2,3415,-2.9197080291970801E-3,1.4511981618529999,1.9770166477166033]
[96,"2015-05-16",1024.3000489999999,2.8925869894099822E-2,3466,1.493411420204978E-2,1.5062296124856742,1.9445776192025772]
[97,"2015-05-23",1050.5500489999999,1.9584779156619395E-2,3536,2.0196191575302943E-2,1.5278464741455651,1.9168414382554801]
[98,"2015-05-30",1011.75,1.8227964928472621E-2,3533,-8.484162895927602E-4,1.4000290951350627,1.8894934614633654]
[99,"2015-06-06",1009.150024,-6.8320870156356295E-2,3399,-3.7928106425134445E-2,1.478713634134021,1.8726754925213323]
[100,"2015-06-13",1030.5,-2.0004864404718391E-2,3339,-1.7652250661959398E-2,{"$f":"COVAR(D72:D101,F72:F101)/VARP(F72:F101)","v":1.4762697688384485},1.8532869893892647]
[101,"2015-06-20",1062.849976,2.9968356393869799E-2,3445,3.1746031746031744E-2,1.4247102130059333,1.8333852252013909]
[102,"2015-06-27",1074.25,3.4096385542168622E-2,3504,1.7126269956458634E-2,1.4383717338453188,1.8137144042983406]
[103,"2015-07-04",1090.75,1.5787020855178923E-2,3551,1.3413242009132419E-2,1.4265416719690696,1.7954408447098693]
[104,"2015-07-11",1110.5500489999999,-7.1858691288639073E-2,3510,-1.1546043368065334E-2,1.4173734622877907,1.7797316521762303]
[105,"2015-07-18",1107.849976,1.8907563025210027E-2,3615,2.9914529914529916E-2,1.3730131316500085,1.7620313407714849]
[106,"2015-07-25",1111.650024,-1.9223771983020041E-2,3577,-1.0511756569847857E-2,1.3825667089250622,1.744565767445998]
[107,"2015-08-01",1092.650024,2.4794410437148418E-2,3589,3.3547665641599105E-3,1.3240745272451464,1.7266310417022079]
[108,"2015-08-08",1101.8000489999999,-8.0849523349825567E-3,3625,1.0030649205906938E-2,1.2879882578586734,1.7088400510268207]
[109,"2015-08-15",1061.3000489999999,-3.0778588807785834E-2,3594,-8.5517241379310348E-3,1.2727227201950315,1.6911192782166595]
[110,"2015-08-22",1027.9499510000001,-0.13204468432283173,3512,-2.2815804117974403E-2,1.3230504507628731,1.6739414802978436]
[111,"2015-08-29",996.04998799999998,-2.2198120028922665E-2,3380,-3.7585421412300681E-2,1.2334312440929966,1.6574197650053899]
[112,"2015-09-05",1010.5,-4.4073060711380542E-2,3241,-4.1124260355029585E-2,1.1651244446591649,1.639162874514619]
[113,"2015-09-12",1049.75,0.10071942446043168,3286,1.3884603517432891E-2,1.2548645978628929,1.6231326548812797]
[114,"2015-09-19",1051.400024,8.2577834000983896E-2,3356,2.130249543517955E-2,1.3553803964648898,1.607499784609145]
[115,"2015-09-26",1067.650024,-6.4009348221241325E-2,3318,-1.132300357568534E-2,1.3929658743946443,1.5932302373424156]
[116,"2015-10-03",1086.150024,1.0264946594534578E-2,3357,1.1754068716094032E-2,1.360954661465027,1.5837367501138411]
[117,"2015-10-10",1100.0500489999999,-4.2564877111079353E-3,3446,2.6511766458147155E-2,1.2402817671530393,1.5736573523239163]
[118,"2015-10-17",1108.5,6.6050744622173155E-2,3468,6.3842135809634359E-3,1.2928808311883646,1.5659272439461513]
[119,"2015-10-24",1099.599976,-3.6217824343552814E-3,3488,5.7670126874279125E-3,1.3157454267496302,1.561369551613409]
[120,"2015-10-31",1080.900024,-1.4539789692327576E-2,3404,-2.4082568807339451E-2,1.2835127196978364,1.5547352736458171]
[121,"2015-11-07",1052.0500489999999,-8.5627717033325945E-4,3355,-1.4394829612220916E-2,1.3480950980321471,1.5494178534774734]
[122,"2015-11-14",1070.849976,-2.7688047992616521E-2,3287,-2.0268256333830104E-2,1.3346117560433777,1.5444989792458133]
[123,"2015-11-21",1079.400024,-7.7971387890704447E-3,3331,1.3386066321874049E-2,1.4936095735378185,1.5418081375260877]
[124,"2015-11-28",1058.900024,4.1273746070793947E-2,3365,1.020714500150105E-2,1.5500743195880411,1.5411159644787453]
[125,"2015-12-05",1046.349976,-2.9531434571466071E-2,3312,-1.575037147102526E-2,1.5527121208494814,1.5418943432417018]
[126,"2015-12-12",1073,-7.9321071138761134E-2,3230,-2.4758454106280192E-2,1.6147292276256151,1.5452947529789374]
[127,"2015-12-19",1074,5.6261476312890128E-2,3304,2.2910216718266253E-2,1.6764289228286422,1.549078861932347]
[128,"2015-12-26",1088.75,8.7615603921842276E-3,3343,1.1803874092009685E-2,1.665185726018604,1.5514170122167488]
[129,"2016-01-02",1062.349976,9.5815813055765246E-3,3391,1.4358360753813939E-2,1.64238728711364,1.54696265421517]
[{"$f":"A130+1","v":130},"2016-01-09",1042.150024,-5.2642359688652135E-2,3254,-4.0401061633736364E-2,1.6070289361829735,1.5432905843131848]
[131,"2016-01-16",1030.3000489999999,-4.4684684684684686E-2,3151,-3.165334972341733E-2,1.6363367730482274,1.5400333609997017]
[132,"2016-01-23",1049.849976,3.1384383251603101E-2,3133,-5.7124722310377659E-3,1.6156460552498859,1.5353189521172899]
[133,"2016-01-30",1055.25,9.2677931387608853E-2,3191,1.8512607724225982E-2,1.7333487701214383,1.531449829245213]
[134,"2016-02-06",971.40002400000003,4.0768509840674851E-2,3162,-9.0880601692259477E-3,1.6722252124894315,1.5251642078754808]
[135,"2016-02-13",989.29998799999998,-8.2009390879269312E-2,2946,-6.8311195445920306E-2,1.6510289775488274,1.5198585740523878]
[136,"2016-02-20",961,5.6053811659189637E-4,3032,2.9192124915139173E-2,1.5333641151749702,{"$f":"AVERAGE(G86:G137)","v":1.5118122302471613}]
[137,"2016-02-27",1020.549988,-3.9285714285714222E-2,2958,-2.4406332453825858E-2,1.5329540113559765,1.5024128758504196]
[138,"2016-03-05",1028.6999510000001,0.10700488373788172,3153,6.5922920892494935E-2,1.5561044018188668,1.493869719792374]
[139,"2016-03-12",1028.400024,5.2874168696911798E-2,3160,2.2201078338090706E-3,1.5635969345596872,1.4840133001461049]
[140,"2016-03-19",1049.349976,1.8386491557223321E-2,3193,1.0443037974683544E-2,1.462721708034197,1.474511344496519]
[141,"2016-03-26",1064.4499510000001,4.1513141734217579E-2,3245,1.6285624804259317E-2,1.5075894993419368,1.467253525462892,{"$f":"FORECAST(A142+52,H91:H142,A91:A142)","v":0.77654511405543136}]
[142,"2016-04-02",1059.349976,9.0801886792453365E-3,3254,2.7734976887519259E-3,1.5235035009227702,1.4622796516360401,0.81216262844038578]
[143,"2016-04-09",1081.75,-6.8949398153559547E-3,3199,-1.6902274124154886E-2,1.4626476764895104,1.4584330759139297,0.84474659158700716]
[144,"2016-04-16",1092.150024,2.3181925158860962E-2,3315,3.6261331666145667E-2,1.3463263671215457,1.4527873443965988,0.87475459059278626]
[145,"2016-04-23",1132.349976,7.2455434157561293E-3,3341,7.8431372549019607E-3,1.3106730885422757,1.450186430461724,0.90266934678769362]
[146,"2016-04-30",1119.650024,7.74720255766157E-2,3322,-5.6869200838072431E-3,1.2952132993355889,1.4479612489815505,0.92815487882662495]
[147,"2016-05-07",1140.900024,-3.5606421872516315E-2,3279,-1.2944009632751354E-2,1.3833293118031948,1.4466560787882849,0.9512064793884798]
[148,"2016-05-14",1140.900024,4.2909730234602574E-2,3316,1.1283928026837451E-2,1.3758138274943867,1.444148082923068,0.97223185503415377]
[149,"2016-05-21",1186.8000489999999,2.9923085027921164E-2,3283,-9.9517490952955364E-3,1.3693129475622889,1.4410993612580052,0.99166548829566081]
[150,"2016-05-28",1171.75,5.033248081841437E-2,3436,4.6603716113310996E-2,1.3230226685959474,1.4396184684399456,1.0096993136398089]
[151,"2016-06-04",1161.349976,2.1963572611278809E-2,3461,7.2759022118742724E-3,1.3296505207550573,1.4367518701057342,1.0275455559152331]
[152,"2016-06-11",1170,1.2389802239695021E-2,3448,-3.7561398439757295E-3,1.315677819438841,1.4336635633865114,1.0446689513980216]
[153,"2016-06-18",1161.900024,7.5782537067544875E-3,3447,-2.9002320185614848E-4,1.3373943120301437,1.4319844114446691,1.061146379724464]
[154,"2016-06-25",1174.5,9.0161636924227708E-3,3418,-8.4131128517551494E-3,1.3260956211705741,1.4298252554316933,1.0768031032854624]
[155,"2016-07-02",1174.849976,4.6252141302838133E-2,3539,3.5400819192510237E-2,1.2890957785856991,1.427182065174321,1.0916504032980989]
[156,"2016-07-09",1223.6999510000001,-9.5583679971680512E-3,3542,8.4769708957332577E-4,1.2088719323166595,1.4231724203671836,1.1057283499275992]
[157,"2016-07-16",1230.8000489999999,5.3480475382003519E-2,3625,2.3433088650479956E-2,1.2058743939560563,1.4199582138730693,1.1187982068674249]
[158,"2016-07-23",1246.1999510000001,-1.7473175283091003E-2,3641,4.413793103448276E-3,1.2117350183098774,1.4166729890535463,1.1307874221329397]
[159,"2016-07-30",1249.25,5.0805024388138421E-2,3692,1.4007140895358419E-2,1.2345947179347383,1.4149522234898848,1.1418229772699218]
[160,"2016-08-06",1228.6999510000001,3.368386460729543E-2,3706,3.791982665222102E-3,1.19205264434966,1.4131073078454806,1.1517966951466239]
[161,"2016-08-13",1247.099976,2.6068987442377962E-2,3700,-1.6189962223421479E-3,1.1371058158039775,1.4104992904533447,1.1604706012094774]
[162,"2016-08-20",1257.099976,3.5360185902401309E-2,3721,5.6756756756756758E-3,1.1517361365525522,1.4072047844108388,{"$f":"FORECAST(A163+52,H112:H163,A112:A163)","v":1.1677004357709675}]
[163,"2016-08-27",1285.099976,-7.7806456439607156E-3,3690,-8.3310937919914008E-3,1.1193853074210138,1.4050115933209928,1.1737037551215543]
[164,"2016-09-03",1290.400024,4.6182846371347785E-2,3774,2.2764227642276424E-2,{"$f":"COVAR(D136:D165,F136:F165)/VARP(F136:F165)","v":1.159283275525516},1.4048992631453459,1.1785059828783124]
[165,"2016-09-10",1297.849976,-7.9459459459459453E-2,3811,9.8039215686274508E-3,1.0391830310652068,1.4007515407069289,1.1815762002477557]
[166,"2016-09-17",1312.6999510000001,-8.5261303581914347E-2,3768,-1.1283127787982157E-2,1.2653119211084611,1.399019454642382,1.1833518428357439]
[167,"2016-09-24",1272.849976,5.4820901271023396E-2,3800,8.4925690021231421E-3,1.2106215667236158,1.3955128333410163,1.1836202312275605]
[168,"2016-10-01",1280.599976,1.7729633235962276E-2,3720,-2.1052631578947368E-2,0.94638506922646237,1.3875403411825824,1.1822163593893653]
[169,"2016-10-08",1261.8000489999999,1.6623480167430663E-2,3779,1.5860215053763442E-2,0.95273688261002742,1.3820106318644474,1.1794978275810024]
[170,"2016-10-15",1270.6999510000001,-1.1881421065014403E-2,3734,-1.190791214607039E-2,0.979251339234535,1.3759792954807197,1.1757069941093672]
[171,"2016-10-22",1259.0500489999999,4.5319258700742021E-2,3782,1.2854847348687734E-2,0.97943998658823606,1.369511883169924,1.1712458983115499]
[172,"2016-10-29",1243.6999510000001,-3.4281158650013188E-2,3754,-7.4034902168164992E-3,1.0381479846390589,1.3647933305726396,1.1661317075336002]
[173,"2016-11-05",1275.8000489999999,-5.9360012579605312E-2,3649,-2.7970165157165688E-2,1.1965623141688932,1.3618792385752694,1.1608964738356593]
[174,"2016-11-12",1211.400024,1.5964560347709718E-2,3578,-1.9457385585091806E-2,1.2211542307253169,1.3596973630883833,1.1557241345488811]
[175,"2016-11-19",1189.3000489999999,-2.9329494035376463E-2,3473,-2.9346003353828955E-2,1.2372340070157339,1.3547670637321896,1.1504278190933181]
[176,"2016-11-26",1189.099976,-1.0467432300716116E-2,3500,7.7742585660811976E-3,1.2833032274392211,1.3496368504216354,1.1452967798435754]
[177,"2016-12-03",1198.3000489999999,-1.4989293361884369E-2,3492,-2.2857142857142859E-3,1.2488846656886226,1.343794014745465,1.1404560073202399]
[178,"2016-12-10",1182.3000489999999,5.9695652173913122E-2,3570,2.2336769759450172E-2,1.2845417206480481,1.3374442549958967,1.1362633547127516]
[179,"2016-12-17",1186.25,-3.0648668608706464E-2,3507,-1.7647058823529412E-2,1.3651414770825014,1.3314579579623174,1.1329115476525673]
[180,"2016-12-24",1206.1999510000001,-4.7955642089223621E-2,3429,-2.2241231822070145E-2,1.5346773182246707,1.3289481808893568,1.1308929305203759]
[181,"2016-12-31",1193.650024,2.8142088649802038E-2,3511,2.3913677456984545E-2,1.4932436008811598,1.3260800330771936,1.1291118540194072]
[182,"2017-01-07",1232.5,7.8612816743059838E-2,3556,1.2816861293078895E-2,1.5826372800421618,1.3256109627667934,1.1281308599084374]
[183,"2017-01-14",1236.349976,5.6646889031430295E-2,3626,1.968503937007874E-2,1.6279120358889727,1.3254489485906538,1.1280512286961604]
[184,"2017-01-21",1291.900024,3.0959517395758383E-2,3612,-3.8610038610038611E-3,1.6274642610726551,1.3256762217795537,1.1286981694334743]
[185,"2017-01-28",1311.0500489999999,2.9956206528539222E-2,3739,3.5160575858250276E-2,1.5651446935335036,1.3224415279990163,1.1295202524974113]
[186,"2017-02-04",1303.599976,-1.500696752063393E-3,3790,1.3640010698047607E-2,1.5256333307708754,1.3196224533505825,1.130214161040175]
[187,"2017-02-11",1377.0500489999999,9.518697441402723E-3,3819,7.6517150395778366E-3,1.4860411806681766,1.3164496111028776,1.130843450981541]
[188,"2017-02-18",1394.3000489999999,2.130374676544607E-2,3828,2.3566378633150041E-3,1.4960160987970712,1.3157313800186874,1.1314275150413131]
[189,"2017-02-25",1377,2.7766208524226017E-3,3875,1.2277951933124347E-2,1.4314624310537181,1.3137796188590285,1.1314748032268667]
[190,"2017-03-04",1400.099976,-6.403156583137201E-3,3853,-5.67741935483871E-3,1.4264573790582162,1.311286406882862,1.1309679302580753]
[191,"2017-03-11",1425.849976,3.110739540878538E-2,3860,1.8167661562418895E-3,1.4371496729450786,1.3088547287748891,1.1296734199694325]
[192,"2017-03-18",1424.349976,1.8986486486486424E-2,3970,2.8497409326424871E-2,1.3531362332644616,1.3067473157985476,1.1276584276273955]
[193,"2017-03-25",1442.5500489999999,1.3792188846893564E-2,3954,-4.0302267002518891E-3,1.3423085237679346,1.3035688354990478,1.1250230447570355]
[{"$f":"A194+1","v":194},"2017-04-01",1438.849976,1.3212113284060316E-2,3992,9.6105209914011131E-3,1.3073453068770122,1.2994119471520138,1.1219129282986791]
[195,"2017-04-08",1440.3000489999999,2.5821444709831515E-3,4011,4.7595190380761527E-3,1.3956479013268654,1.2981234899373475,1.1190377853596223]
[196,"2017-04-15",1496.599976,4.1014744704140141E-2,4004,-1.7452006980802793E-3,1.2545371779739847,1.2963583132229712,1.11601022513183]
[197,"2017-04-22",1546.5,-4.5398317664522431E-2,4002,-4.995004995004995E-4,1.241092860958549,1.295020231923284,1.113360167918191]
[198,"2017-04-29",1532.1999510000001,5.6563431385253306E-2,4083,2.0239880059970013E-2,1.4144886623881763,1.2973139889050647,1.1118205300715474]
[199,"2017-05-06",1551.650024,-1.3491138774759305E-2,4071,-2.9390154298310064E-3,1.4427656176618546,1.2984569947869622,1.1112887455849776]
[200,"2017-05-13",1561.25,-7.7640330701808966E-2,4123,1.2773274379759274E-2,1.3205268416778404,{"$f":"AVERAGE(G150:G201)","v":1.2973937835212594},1.1111461781195899]
[201,"2017-05-20",1626,-3.6325650357190903E-2,4109,-3.3955857385398981E-3,1.3131394467346162,1.2963135238899579,1.1112956518956234]
[202,"2017-05-27",1634.25,4.3849220225190444E-2,4153,1.070820150888294E-2,1.3069569529937171,1.2960045678206842,1.1121138632360461]
[203,"2017-06-03",1666.8000489999999,-7.1017017285273411E-3,4190,8.9092222489766427E-3,1.1715429833490609,1.2929640382551839,1.1128633284316249]
[204,"2017-06-10",1669.25,2.9014844804318182E-3,4204,3.3412887828162289E-3,1.3275119841013963,1.2931916183448484,1.1141248405579396]
[205,"2017-06-17",1678.650024,-2.9940119760479042E-2,4177,-6.4224548049476686E-3,1.4552654029340697,1.2954583700930007,1.1164797105249979]
[206,"2017-06-24",1652.0500489999999,-3.6066028575392189E-3,4158,-4.5487191764424229E-3,1.4530226853879862,1.2978992751741054,1.1198596299218417]
[207,"2017-07-01",1667.1999510000001,1.7541417235138555E-2,4149,-2.1645021645021645E-3,1.3999101838722965,1.3000303214296167,1.1241003611018217]
[208,"2017-07-08",1679.9499510000001,2.8389656587768507E-2,4218,1.6630513376717282E-2,1.3123594149808067,1.302020465327004,1.1289305165454793]
[209,"2017-07-15",1703.0500489999999,4.1242599614182134E-2,4304,2.0388809862494073E-2,1.3133692534884231,1.3040876741641645,1.1344490575603938]
[210,"2017-07-22",1778.5,8.624544815690284E-3,4316,2.7881040892193307E-3,1.1401255201456686,1.3027105684302376,1.1399625814978482]
[{"$f":"A211+1","v":211},"2017-07-29",1784.4,0.16803901697491763,4358,9.7312326227988882E-3,{"$f":"COVAR(D183:D212,F183:F212)/VARP(F183:F212)","v":1.2669238813239527},{"$f":"AVERAGE(G161:G212)","v":1.3033322831107994},{"$f":"FORECAST(A212+52,H161:H212,A161:A212)","v":1.1460783740799199}]

{"sheet":"Valuation","index":2,"n_rows":46,"n_cols":28,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"Company","HDFC BANK Ltd",null,null,null,"Inputs to the model.",null,null,null,"Key ratios",null,null,null,null,null,null,null,null,null,"Checklist"]
["Ph","Financial Year Ended","Book Value","Ret on Equity","Div + Buyback","Earnings","Shares Out","Price / Book","EPS Growth","Sust Growth Rate","Payout Ratio","Disc Rate","PV Factor","PV of Div","Eco Value Added","PV of EVA","P/E","Avg Price","Ann Rtn",null,"High Growth Phase"]
[null,"2012-03-31",null,null,null,null,null,null,null,{"$f":"(1-E3/F3)*D3","v":{"$error":"#DIV/0!"}},{"$f":"E3/F3","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"H3/D3","v":{"$error":"#DIV/0!"}},{"$f":"C3*H3","v":0},null,null,null,"Years",null,null,">=",8,null,0]
[null,"2013-03-31",null,null,null,null,null,null,{"$f":"F4/F3-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"(D4-discount_rate)*AVERAGE(C3:C4)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},0,{"$f":"R4/R3-1","v":{"$error":"#DIV/0!"}},null,null,"Growth Rate",null,null,">=",0.25,"<=",0]
[null,"2014-03-31",null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"(D5-discount_rate)*AVERAGE(C4:C5)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},0,{"$f":"R5/R4-1","v":{"$error":"#DIV/0!"}},null,null,"Discount Rate",null,null,"<=",{"$f":"CAPM_Disc_Rate-3%","v":0.1145986435349208},">=",{"$f":"CAPM_Disc_Rate+5%","v":0.19459864353492079}]
[null,"2015-03-31",null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"(D6-discount_rate)*AVERAGE(C5:C6)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},0,{"$f":"R6/R5-1","v":{"$error":"#DIV/0!"}},null,null,"Payout Ratio",null,null,"<=",0.1,">=",0.5]
[null,"2016-03-31",null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"(D7-discount_rate)*AVERAGE(C6:C7)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},0,{"$f":"R7/R6-1","v":{"$error":"#DIV/0!"}},null,"Slowdown Phase"]
[null,"2017-03-31",362,0.18,13.198443579766536,56.5,257.51,4.91,{"$error":"#DIV/0!"},0.13795186116180572,0.23360077132330154,null,null,null,{"$f":"(D8-discount_rate)*AVERAGE(C7:C8)","v":12.815291040358668},null,27.277777777777779,1777.42,{"$f":"R8/R7-1","v":{"$error":"#DIV/0!"}},null,null,"Years",null,null,">=",{"$f":"20-growth_phase_years","v":16},"<=",0]
[{"$f":"IF(YEAR(B9)-YEAR(B$8)<=C$36,1,IF(YEAR(B9)-YEAR(B$8)<=C$36+D$36,2,3))","v":1},{"$f":"DATE(YEAR(B8)+1,MONTH(B8),DAY(B8))","v":"2018-03-31"},{"$f":"(C8*G8+(G9-G8)*I$44*C8)/G9+F8-E8","v":433.17478385551641},{"$f":"IF(A9=1,D8+(C$37-D$8)/C$36,IF(A9=2,D8+(E$37-C$37)/D$36,E$37))","v":0.185},{"$f":"E8*(1+J8)*IF(A9=1,C$38,IF(A9=2,D$38,1))","v":15.019193436034417},{"$f":"((C9+C8)/2)*D9","v":73.553667506635264},{"$f":"G8*IF(A9=1,1+C$39,1)","v":262.66019988488404},{"$f":"R9/C9","v":3.1079869771851558},0.30183482312628795,0.14722417073335309,0.20419367171160482,{"$f":"IF(A9=1,discount_rate,IF(A9=3,term_disc_rate,disc_rate-((discount_rate-term_disc_rate)/slowdown_phase_years)))","v":0.1445986435349208},{"$f":"(1+L9)^((B9-TODAY())/365)","v":1.0940787594211869},{"$f":"(1-C$46)*E9/M9","v":12.354936951323481},{"$f":"(D9-L9)*AVERAGE(C8:C9)","v":16.063069947294508},{"$f":"O9/M9","v":14.681822317611338},{"$f":"fair_pe","v":18.303663606529071},{"$f":"F9*Q9","v":1346.3015870679396},{"$f":"(R9+E9)/R8-1","v":-0.23410292418000589},null,"Perpetual Phase"]
[1,"2019-03-31",{"$f":"(C9*G9+(G10-G9)*I$44*C9)/G10+F9-E9","v":525.06279182013498},0.19,17.230381734738405,{"$f":"((C10+C9)/2)*D10","v":91.032569689186886},267.91340376516348,3.102225466272599,0.23763467920854997,0.15403734904136002,0.18927711030863142,{"$f":"IF(A10=1,discount_rate,IF(A10=3,term_disc_rate,L9-((discount_rate-term_disc_rate)/slowdown_phase_years)))","v":0.1445986435349208},1.2522810639538593,{"$f":"(1-C$46)*E10/M10","v":12.383277211189977},21.752642875741778,{"$f":"O10/M10","v":17.37041587697701},{"$f":"Q9+((I$36-J$43)/20)","v":17.893191082466959},1628.8631641766108,0.22267815898242782,null,null,"ROE",null,null,">=",{"$f":"term_disc_rate+5%","v":0.16600000000000001},"<=",{"$f":"term_disc_rate-2%","v":9.6000000000000002E-2}]
[1,"2020-03-31",639.2936941784709,0.19500000000000001,19.88450406012818,113.52475738486407,273.27167172070011,3.104553354497344,0.24707846622887186,0.16084464586363462,0.17515566223777126,0.1445986435349208,1.4338896640523771,12.48077456918028,29.342573151621369,20.46361996131213,17.482718558404848,1984.721382770771,0.23067789297342611,null,null,"Growth Rate",null,null,">=",{"$f":"term_disc_rate-3%","v":8.6000000000000007E-2},"<=",{"$f":"term_disc_rate-10%","v":1.6E-2}]
[1,"2021-03-31",782.1581976020434,0.2,23.082820073853501,142.14518917805145,278.73710503295217,3.1026174112677318,0.25210740328790404,0.16752219303751478,0.16238903481242617,0.1445986435349208,1.6412281644530939,12.657921985753179,39.375181477246741,23.99129038244827,17.072246034342736,2426.7376422458869,0.23433973331796709,null,null,"Discount Rate",null,null,"<=",{"$f":"discount_rate-5%","v":9.4598643534920798E-2},">=",{"$f":"discount_rate+2%","v":0.16459864353492079}]
[2,"2022-03-31",901.22056670624124,0.19500000000000001,28.83618404410392,164.12942952005776,278.73710503295217,3.034426290369113,0.15466045997848576,0.160740111904105,0.17569173382510259,0.14221542324034406,1.8603567584544343,13.950316530284578,44.428217800102715,23.881557985154004,16.661773510280625,2734.6873810347693,0.13878134865922265,null,null,"Terminal Value / Present Value",null,null,">=",0.75,"<=",0.3]
[2,"2023-03-31",1036.5138121821951,0.19,35.814307578837393,184.08476599440147,278.73710503295217,2.8862296903254041,0.12158292716118302,0.15303486383992224,0.19455334821093564,0.13983220294576731,2.099918215185796,15.34958675431165,48.605932532542354,23.146583605515232,16.251300986218514,2991.6169391526209,0.10704838429682551,null,null,"Payout Ratio",null,null,"<=",0.3,">=",0.7]
[2,"2024-03-31",1184.7842705977594,0.185,44.185805431073874,205.47007265714581,278.73710503295217,2.7471804410658716,0.11617097453569158,0.14521623052429294,0.21504740257138943,0.13744898265119057,2.3612115972331362,16.841872593953735,52.812491835573375,22.366691700760306,15.840828462156404,3254.8161750686595,0.10274879692123262,null,null,"Exit PE",null,null,">=",{"$f":"exit_pe + 3","v":13.094213125286863},"<=",{"$f":"exit_pe-3","v":7.0942131252868634}]
[2,"2025-03-31",1346.0685378238311,0.18,54.14446264614606,227.77675275794314,278.73710503295217,2.6110679142389648,0.10856413205254967,0.13721247599546163,0.23770846669187976,0.13506576235661383,2.6428900030768006,18.438155324209834,56.86097076702351,21.514694406814922,15.430355938094294,3514.676369478364,9.6473852950920369E-2,null,"Overall Valuation"]
[2,"2026-03-31",1519.700827935628,0.17499999999999999,65.883921517176276,250.75481950395266,278.73710503295217,2.4783221047344113,0.10087977138926085,0.12902008109629134,0.26274239373547809,0.13268254206203708,2.9456752236296286,20.129690092716789,60.636037297714267,20.584766715387996,15.019883414032185,3766.3081544560528,9.0339955408750505E-2,null,null,"DDM / RIM Ratio",null,null,">=",1.5,"<",1]
[2,"2027-03-31",1704.5717259224043,0.16999999999999998,79.591169343262536,274.06316707793275,278.73710503295217,2.3489192955382299,9.2952740131132972E-2,0.12062999916180968,0.29041176963641357,0.13029932176746034,3.269237010973129,21.910938903635536,64.0029035973633,19.577321369646441,14.609410889970075,4003.9014176480387,8.4216272149684857E-2]
[2,"2028-03-31",1899.0437236570747,0.16499999999999998,95.435709676837689,297.29827459030696,278.73710503295217,2.2228660797074031,8.4780117518553855E-2,0.11203335524439793,0.32100996821576999,0.1279161014728836,3.6141077214015782,23.76579375333182,66.818054831477141,18.488119331862251,14.198938365907965,4221.3198771985508,7.8137330716580466E-2]
[2,"2029-03-31",2100.9062885705439,0.15999999999999998,113.55663091300856,319.99600097820945,278.73710503295217,2.1001669389154003,7.6346646879068336E-2,0.10322097497925102,0.3548689063796811,0.12553288117830685,3.9769860474822805,25.698095643661688,68.933376176141095,17.333069654539248,13.788465841845856,4412.2539290153136,7.2131629819023324E-2]
[2,"2030-03-31",2307.3456586357447,0.15499999999999997,134.04752106619284,341.63952590848731,278.73710503295217,1.9808264434020273,6.7636860661117071E-2,9.4183366707910166E-2,0.39236537607799882,0.12314966088373012,4.3575777505319913,27.68574099334085,70.20215971423859,16.110363080880891,13.377993317783746,4570.4512946945506,6.623482951051507E-2]
[2,"2031-03-31",2514.9376634780392,0.14999999999999997,156.93964765199036,361.67124915853373,278.73710503295217,1.8648491817759596,5.8634091581698744E-2,8.4910648268091374E-2,0.43392901154605734,0.1207664405891534,4.7541006358101718,29.710284595757379,70.486252996473951,14.826411638310221,12.967520793721636,4689.9794439545649,6.0490262139524908E-2]
[2,"2032-03-31",2719.6692649845822,0.14499999999999996,182.18407951420278,379.50900231353995,278.73710503295217,1.7522398484907191,4.9320351552708752E-2,7.539245085486887E-2,0.48005206306986964,0.11838322029457667,5.1659581286962304,31.739643930130672,69.664189729686029,13.485240877720331,12.557048269659527,4765.51286082145,5.495066651374958E-2]
[2,"2033-03-31",2916.9941877839192,0.13999999999999996,209.63374063980305,394.56644169379501,278.73710503295217,1.6430033322574276,3.9676105938101003E-2,6.561779059672633E-2,0.53130149573766894,0.11599999999999994,5.5875042586883996,33.766482823247259,67.639961433222084,12.105576712186661,12.146575745597417,4792.6311707045279,4.9680287817347679E-2]
[3,"2034-03-31",3101.9268888379115,0.14000000000000001,223.38944353511408,421.32447536352822,278.73710503295217,1.5940761048942822,6.7816293638319314E-2,6.5770934461066841E-2,0.53020761099237979,0.11600000000000001,6.2356547526962727,32.242083174131672,72.227052919461997,11.582914029714571,11.736103221535307,4944.7075326255772,7.8342311787153118E-2]
[3,"2035-03-31",3299.8619206663257,0.14000000000000001,238.08197598515628,448.12521666529665,278.73710503295217,1.5380342669463818,6.3610691685177079E-2,6.5620171777083791E-2,0.53128448730654443,0.11600000000000001,6.9589907040090422,30.790927521026653,76.821465714050873,11.039167744511339,11.325630697473198,5075.3007101763114,7.4559546970845547E-2]
[3,"2036-03-31",3509.9051613464662,0.14000000000000001,253.70495614632975,476.68369574089547,278.73710503295217,1.4823984405612944,6.3728792787238087E-2,6.5487919604045819E-2,0.53222914568538704,0.11600000000000001,7.7685691846015112,29.392086896038784,81.717204984153526,10.51895182270237,10.915158173411088,5203.0779376980399,7.5164449448908766E-2]
[3,"2037-03-31",3732.8839009410322,0.14000000000000001,270.31956591758859,506.99523436012493,278.73710503295217,1.4267321738371037,6.3588368744429413E-2,6.53548422871746E-2,0.53317969794875286,0.11600000000000001,8.6697232100152846,28.061750465664616,86.913468747450011,10.024941586029803,10.504685649348978,5325.8255626711261,7.5545128402319639E-2]
[null,"Growth Rates"]
[null,"Last 3 Years",{"$f":"RATE(3,0,-C5,C8)","v":{"$error":"#NUM!"}},{"$f":"AVERAGE(D6:D8)","v":0.18},{"$f":"RATE(3,0,-E5,E8)","v":{"$error":"#NUM!"}},{"$f":"RATE(3,0,-F5,F8)","v":{"$error":"#NUM!"}},{"$f":"RATE(3,0,-G5,G8)","v":{"$error":"#NUM!"}},null,null,{"$f":"AVERAGE(J6:J8)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(K6:K8)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"RATE(3,0,-O5,O8)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(Q6:Q8)","v":{"$error":"#DIV/0!"}}]
[null,"High Growth Phase ",{"$f":"RATE(growth_phase_years,0,-C8,OFFSET(C8,growth_phase_years,0))","v":0.21240161921514486},{"$f":"AVERAGE(OFFSET(D9,0,0,growth_phase_years,1))","v":0.1925},{"$f":"RATE(growth_phase_years,0,-E8,OFFSET(E8,growth_phase_years,0))","v":0.14998330774671709},{"$f":"RATE(growth_phase_years,0,-F8,OFFSET(F8,growth_phase_years,0))","v":0.25942099683012187},null,null,null,{"$f":"AVERAGE(OFFSET(J9,0,0,growth_phase_years,1))","v":0.15740708966896563},{"$f":"AVERAGE(OFFSET(K9,0,0,growth_phase_years,1))","v":0.18275386976760841},null,null,null,{"$f":"RATE(growth_phase_years,0,-O8,OFFSET(O8,growth_phase_years,0))","v":0.3239559133658319},null,{"$f":"AVERAGE(OFFSET(Q9,0,0,growth_phase_years,1))","v":17.687954820435902}]
[null,"Slowdown Phase",{"$f":"RATE(slowdown_phase_years,0,-OFFSET(C8,growth_phase_years,0),OFFSET(C8,growth_phase_years+slowdown_phase_years,0))","v":0.11592947019315672},{"$f":"AVERAGE(OFFSET(D9,growth_phase_years,0,slowdown_phase_years,1))","v":0.16749999999999998},{"$f":"RATE(slowdown_phase_years,0,-OFFSET(E8,growth_phase_years,0),OFFSET(E8,growth_phase_years+slowdown_phase_years,0))","v":0.20184287495271783},{"$f":"RATE(slowdown_phase_years,0,-OFFSET(F8,growth_phase_years,0),OFFSET(F8,growth_phase_years+slowdown_phase_years,0))","v":8.8802221481506197E-2},null,null,null,{"$f":"AVERAGE(OFFSET(J9,growth_phase_years,0,slowdown_phase_years,1))","v":0.11510102909776072},{"$f":"AVERAGE(OFFSET(K9,growth_phase_years,0,slowdown_phase_years,1))","v":0.32414016130818707},null,null,null,{"$f":"RATE(slowdown_phase_years,0,-OFFSET(O8,growth_phase_years,0),OFFSET(O8,growth_phase_years+slowdown_phase_years,0))","v":4.6120546247534318E-2},null,{"$f":"AVERAGE(OFFSET(Q9,growth_phase_years,0,slowdown_phase_years,1))","v":14.404174627939019}]
[null,"Perpetual",{"$f":"C28/C27-1","v":6.3528422947196406E-2},{"$f":"terminal_roe","v":0.14000000000000001},{"$f":"J28","v":6.53548422871746E-2},{"$f":"terminal_growth_rate","v":6.53548422871746E-2},null,null,null,{"$f":"terminal_growth_rate","v":6.53548422871746E-2},{"$f":"K28","v":0.53317969794875286},null,null,null,{"$f":"terminal_roe-term_disc_rate","v":2.4000000000000007E-2},null,{"$f":"Q28","v":10.504685649348978}]
[]
[null,null,"High Growth","Slowdown","Perpetual",null,"Intrinsic Value",null,"DDM","RIM","CAPM",null,null,null,"Curr / TTM",{"$f":"\"In \" & growth_phase_years & \" Years\"","v":"In 4 Years"},{"$f":"growth_phase_years & \" Year CAGR\"","v":"4 Year CAGR"},"In 20 Years","20 Yr CAGR"]
[null,"Years",4,12,null,null,"Exit PE",null,{"$f":"I37/F28","v":10.094213125286863},null,null,null,"Sales (Rs Cr)",null,71458,{"$f":"O36*P38/O38","v":167455.16576136253},{"$f":"RATE((OFFSET(B8,growth_phase_years,0)-TODAY())/365,0,-O36,P36)","v":0.26129691126108595},{"$f":"O36*R38/O38","v":799187.03699126083},{"$f":"RATE(20,0,-O36,R36)","v":0.1283137450037686}]
[null,"ROE",0.2,null,0.14000000000000001,null,"Terminal Value",null,{"$f":"(1-C46)*E28*(1+J28)/(E40-J28)","v":5117.717949135862},{"$f":"O28*(1+O33)/(term_disc_rate-O33)","v":967.38469562379146},null,null,"Profits (Rs Cr)",null,15204,{"$f":"P40*P39","v":39621.138525851384},{"$f":"RATE((OFFSET(B8,growth_phase_years,0)-TODAY())/365,0,-O37,P37)","v":0.29834357300199438},{"$f":"R40*R39","v":141318.38389104433},0.11792338277773867]
[null,"Div Growth Factor",1,1.07,null,null,"PV of Term Val",null,{"$f":"I37/M28","v":590.29773213796057},{"$f":"J37/M28","v":111.5819585227665},null,null,"Book Value (Rs Cr)",null,93034,{"$f":"P41*P39","v":218016.51167738534},{"$f":"RATE((OFFSET(B8,growth_phase_years,0)-TODAY())/365,0,-O38,P38)","v":0.26129691126108584},{"$f":"R41*R39","v":1040493.2519724168},0.1283137450037686]
[null,"Dilution Rate",1.9999999552965164E-2,null,null,null,"Intrinsic Value",null,{"$f":"SUM(N9:N28,I38)","v":1039.6480928508511},{"$f":"SUM(C8,P9:P28,J38)","v":816.67547932285197},{"$f":"PV(discount_rate,(OFFSET(B8,growth_phase_years,0)-TODAY())/365,-AVERAGE(OFFSET(E8,0,0,growth_phase_years,1)),-P44)","v":1522.7422874128813},null,"Shares (Cr)",null,257.8,{"$f":"OFFSET(G8,growth_phase_years,0)","v":278.73710503295217},{"$f":"RATE((OFFSET(B8,growth_phase_years,0)-TODAY())/365,0,-O39,P39)","v":2.1513446174814908E-2},{"$f":"G28","v":278.73710503295217},3.91188006916775E-3]
[null,"Discount Rate",{"$f":"CAPM_Disc_Rate","v":0.1445986435349208},null,{"$f":"E45","v":0.11600000000000001},null,"Term Val / IV",null,{"$f":"I38/I39","v":0.56778609627348708},{"$f":"J38/J39","v":0.13662949524979603},null,null,"EPS",null,56.8,{"$f":"OFFSET(F8,growth_phase_years,0)","v":142.14518917805145},{"$f":"RATE((OFFSET(B8,growth_phase_years,0)-TODAY())/365,0,-O40,P40)","v":0.28409170442200837},{"$f":"F28","v":506.99523436012493},0.11566234942917265]
[null,null,null,null,null,null,null,null,null,null,null,null,"BVPS",null,{"$f":"O38/O39","v":360.87664856477886},{"$f":"OFFSET(C8,growth_phase_years,0)","v":782.1581976020434},{"$f":"RATE((OFFSET(B8,growth_phase_years,0)-TODAY())/365,0,-O41,P41)","v":0.23473353775639191},{"$f":"C28","v":3732.8839009410322},0.12391711603907095]
[null,"Equity Risk Premium",{"$f":"erp","v":7.3815757672626214E-2},null,0.06,null,null,null,"Current","Fair","Terminal",null,"SPS",null,277.2,{"$f":"O42*P41/O41","v":600.79878606046009},{"$f":"RATE((OFFSET(B8,growth_phase_years,0)-TODAY())/365,0,-O42,P42)","v":0.23473353775639189},{"$f":"O42*R41/O41","v":2867.3382482798997},0.12391711603907093]
[null,"Risk Free Rate",{"$f":"rfr","v":0.06},null,0.05,null,"P/E",null,{"$f":"O44/O40","v":31.302816901408452},{"$f":"I39/O40","v":18.303663606529071},{"$f":"I36","v":10.094213125286863},null,"Mcap Rs. Cr",null,{"$f":"O44*O39","v":458368.4},{"$f":"P44*P39","v":676421.82507411053},{"$f":"RATE((OFFSET(B8,growth_phase_years,0)-TODAY())/365,0,-O43,P43)","v":0.11190776514172249},{"$f":"R38*K44","v":1426497.8855173076},5.8407291575367767E-2]
[null,"Beta",{"$f":"beta","v":1.1460783740799199},null,1.1000000000000001,null,"P/B",null,{"$f":"O44/O41","v":4.9268912440613111},{"$f":"I39/O41","v":2.8808959986343643},{"$f":"I37/C28","v":1.3709823517001758},null,"Price",null,1778,{"$f":"OFFSET(R8,growth_phase_years,0)","v":2426.7376422458869},{"$f":"xirr2((Q$45,OFFSET(E8,1,0,growth_phase_years,1),OFFSET(R8,growth_phase_years,0)),(Q$46,OFFSET(B8,1,0,growth_phase_years,1),OFFSET(B8,growth_phase_years,0)))","v":9.8834055662155168E-2},{"$f":"I37","v":5117.717949135862},{"$f":"IRR((Q45,E9:E27,R45))","v":8.3213074291438621E-2}]
[null,"CAPM Disc Rate",{"$f":"C$43+C$44*C$42","v":0.1445986435349208},null,{"$f":"E$43+E$44*E$42","v":0.11600000000000001},null,"P/S",null,{"$f":"O44/O42","v":6.4141414141414144},{"$f":"I39/O42","v":3.7505342454936907},null,null,null,null,null,null,{"$f":"-O44","v":-1778},{"$f":"I37+E28","v":5388.037515053451}]
[null,"Div Dist Tax",0.1,null,null,null,"Div Yield",null,{"$f":"E8/O44","v":7.4231966140419214E-3},{"$f":"E8/I39","v":1.2695106806356637E-2},{"$f":"E28/I37","v":5.2820332930468089E-2},null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-31"}]