{"text_format":"3","workbook":"xls","n_sheets":18,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10","Sheet11","Sheet12","Sheet13","Sheet14","Sheet15","Sheet16","Module1","Module2"],"not_rendered":{"images":1,"macros":1,"defined_names":17},"unopened":[{"sheet":"Module1","index":16,"reason":"not_a_worksheet"},{"sheet":"Module2","index":17,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1904","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"flags":["formulas_cached_only"]}
["Implied Risk Premium Calculator"]
["Enter level of the index =",null,970.43]
["Enter current dividend yield =",null,{"v":0.01599291035932525,"d":"1.60%"},"(if you want, you can add stock buybacks to this number)"]
["Enter expected growth rate in earnings for next 5 years for market =",null,{"v":0.08,"d":"8.00%"}]
["Enter current long term bond rate =",null,{"v":0.0592,"d":"5.92%"}]
["Enter risk premium =",null,{"v":0.055,"d":"5.50%"}]
["Enter expected growth rate in the long term =",null,{"v":0.0592,"d":"5.92%"},"(As a default, it is set equal to long term bond rate)"]
[]
[null,1,2,3,4,5]
["Expected Dividends =",{"v":16.7616,"d":"$16.76"},{"v":18.102528000000003,"d":"$18.10"},{"v":19.550730240000004,"d":"$19.55"},{"v":21.114788659200006,"d":"$21.11"},{"v":22.803971751936007,"d":"$22.80"}]
["Expected Terminal Value =",{"$nulls":4},{"v":439.16303417546584,"d":"$439.16"}]
["Present Value =",{"v":15.043618739903073,"d":"$15.04"},{"v":14.581859844817197,"d":"$14.58"},{"v":14.134274486090986,"d":"$14.13"},{"v":13.70042761171986,"d":"$13.70"},{"v":269.02657855740824,"d":"$269.03"}]
["Intrinsic Value of Index =",{"v":326.4867592399394,"d":"$326.49"}]
[]
[]
["Implied Risk Premium in current level of Index =",null,{"v":0.018609727102128562,"d":"1.86%"},"(Go under Tools and choose Solver: See below)"]
[]
[null,1,2,3,4,5]
["Expected Dividends =",{"v":16.7616,"d":"$16.76"},{"v":18.102528000000003,"d":"$18.10"},{"v":19.550730240000004,"d":"$19.55"},{"v":21.114788659200006,"d":"$21.11"},{"v":22.803971751936007,"d":"$22.80"}]
["Expected Terminal Value =",{"$nulls":4},{"v":1297.9216055719544,"d":"$1,297.92"}]
["Present Value =",{"v":15.551538994796756,"d":"$15.55"},{"v":15.583142081616243,"d":"$15.58"},{"v":15.614809390703176,"d":"$15.61"},{"v":15.646541052566945,"d":"$15.65"},{"v":908.0339676146832,"d":"$908.03"}]
["Intrinsic Value of Index =",{"v":970.4299991343663,"d":"$970.43"}]
[]
[]
[null,"This is a picture of the solver option, with the inputs that I used (Do not try to enter numbers in it). "]
[null,"Enter current level of index where you see 759.64."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet5","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet6","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet7","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet8","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet9","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet10","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet11","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet12","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet13","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet14","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet15","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet16","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}