{"text_format":"3","workbook":"xls","n_sheets":16,"sheets":["Stock Expected Return","Stock Price - Zero Growth","Stock Price - Constant Growth","Stock Price - Variable Growth","Sheet5","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10","Sheet11","Sheet12","Sheet13","Sheet14","Sheet15","Sheet16"],"not_rendered":{"charts":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Stock Expected Return","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"flags":["formulas_cached_only"]}
[]
[]
["EXPECTED RETURN COMMON STOCK"]
[]
[null,"INPUTS"]
[]
[null,"LAST DIVIDEND",null,null,{"v":1.25,"d":"$1.25"},"Dollar Amount"]
[null,"PRICE OF STOCK",null,null,{"v":45,"d":"$45.00"},"Dollar Amount"]
[null,"EXPECTED GROWTH RATE",null,null,{"v":0.09,"d":"9.00%"},"Decimal"]
[]
[null,"OUTPUT"]
[]
[null,"EXPECTED RETURN",null,null,{"v":0.11777777777777777,"d":"11.8%"}]
[]
[]
[]
[]
[{"v":0,"d":"0%"},{"v":0.11777777777777777,"d":"11.8%"}]
[{"v":0.01,"d":"1%"},{"v":0.03777777777777778,"d":"3.8%"}]
[{"v":0.02,"d":"2%"},{"v":0.04777777777777778,"d":"4.8%"}]
[{"v":0.03,"d":"3%"},{"v":0.057777777777777775,"d":"5.8%"}]
[{"v":0.04,"d":"4%"},{"v":0.06777777777777777,"d":"6.8%"}]
[{"v":0.05,"d":"5%"},{"v":0.07777777777777778,"d":"7.8%"}]
[{"v":0.06,"d":"6%"},{"v":0.08777777777777777,"d":"8.8%"}]
[{"v":0.07,"d":"7%"},{"v":0.09777777777777778,"d":"9.8%"}]
[{"v":0.08,"d":"8%"},{"v":0.10777777777777778,"d":"10.8%"}]
[{"v":0.09,"d":"9%"},{"v":0.11777777777777777,"d":"11.8%"}]
[{"v":0.1,"d":"10%"},{"v":0.12777777777777777,"d":"12.8%"}]
[{"v":0.11,"d":"11%"},{"v":0.13777777777777778,"d":"13.8%"}]
[{"v":0.12,"d":"12%"},{"v":0.14777777777777779,"d":"14.8%"}]
[{"v":0.13,"d":"13%"},{"v":0.1577777777777778,"d":"15.8%"}]
[{"v":0.14,"d":"14%"},{"v":0.1677777777777778,"d":"16.8%"}]
[{"v":0.15,"d":"15%"},{"v":0.17777777777777776,"d":"17.8%"}]
[{"v":0.16,"d":"16%"},{"v":0.18777777777777777,"d":"18.8%"}]
[{"v":0.17,"d":"17%"},{"v":0.19777777777777777,"d":"19.8%"}]
[{"v":0.18,"d":"18%"},{"v":0.20777777777777778,"d":"20.8%"}]
[{"v":0.19,"d":"19%"},{"v":0.2177777777777778,"d":"21.8%"}]
[{"v":0.2,"d":"20%"},{"v":0.2277777777777778,"d":"22.8%"}]

{"sheet":"Stock Price - Zero Growth","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"PRICE OF COMMON STOCK - ZERO GROWTH MODEL"]
[]
[]
[null,"INPUTS"]
[]
[null,"LAST DIVIDEND",null,null,{"v":3,"d":"$3.00"},"Dollar Amount"]
[null,"EXPECTED RETURN (ROR)",null,null,{"v":0.06,"d":"6.00%"},"Decimal"]
[]
[null,"OUTPUT"]
[]
[null,"PRICE OF STOCK",null,null,{"v":50,"d":"$50.00"}]

{"sheet":"Stock Price - Constant Growth","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"PRICE OF COMMON STOCK - CONSTANT GROWTH MODEL"]
[]
[]
[null,"INPUTS"]
[]
[null,"LAST DIVIDEND",null,null,{"v":1.17,"d":"$1.17"},"Dollar Amount"]
[null,"EXPECTED RETURN (ROR (k)",null,null,{"v":0.136,"d":"13.60%"},"Decimal"]
[null,"GROWTH RATE (g)",null,null,{"v":0.081,"d":"8.10%"},"Decimal"]
[{"$nulls":4},"k must > g"]
[null,"OUTPUT"]
[]
[null,"PRICE OF STOCK",null,null,{"v":22.995818181818176,"d":"$23.00"}]
[]
[]
[{"v":0.09,"d":"9%"},{"v":21.27272727272727,"d":"$21.27"}]
[{"v":0.1,"d":"10%"},{"v":61.57894736842104,"d":"$61.58"}]
[{"v":0.11,"d":"11%"},{"v":40.3448275862069,"d":"$40.34"}]
[{"v":0.12,"d":"12%"},{"v":30.000000000000004,"d":"$30.00"}]
[{"v":0.13,"d":"13%"},{"v":23.87755102040816,"d":"$23.88"}]
[{"v":0.14,"d":"14%"},{"v":19.830508474576266,"d":"$19.83"}]
[{"v":0.15,"d":"15%"},{"v":16.956521739130437,"d":"$16.96"}]
[{"v":0.16,"d":"16%"},{"v":14.81012658227848,"d":"$14.81"}]
[{"v":0.17,"d":"17%"},{"v":13.146067415730334,"d":"$13.15"}]
[{"v":0.18,"d":"18%"},{"v":11.818181818181818,"d":"$11.82"}]
[{"v":0.19,"d":"19%"},{"v":10.73394495412844,"d":"$10.73"}]
[{"v":0.2,"d":"20%"},{"v":9.831932773109243,"d":"$9.83"}]
[{"v":0.21,"d":"21%"},{"v":9.069767441860463,"d":"$9.07"}]

{"sheet":"Stock Price - Variable Growth","index":3,"n_rows":36,"n_cols":10,"rows_kept":36,"flags":["formulas_cached_only"]}
[]
[null,"PRICE OF STOCK - VARIABLE GROWTH MODEL"]
[]
[]
["INPUTS"]
[]
["LAST YEAR (e.g., 1996)",null,null,1996,1997,1998,1999,2000,2001]
["LAST DIVIDEND",null,null,{"v":1.17,"d":"$1.17"}]
["GROWTH RATE (g)",{"$nulls":3},{"v":0.3,"d":"30.00%"},{"v":0.3,"d":"30.00%"},{"v":0.3,"d":"30.00%"},{"v":0.081,"d":"8.10%"},{"v":0.081,"d":"8.10%"},"Decimal"]
["EXPECTED RETURN (ROR) (k)",null,null,{"v":0.136,"d":"13.60%"},"Decimal"]
[]
["OUTPUT"]
[]
["DIVIDENDS",{"$nulls":3},{"v":1.521,"d":"$1.52"},{"v":1.9773,"d":"$1.98"},{"v":2.57049,"d":"$2.57"},{"v":2.77869969,"d":"$2.78"},{"v":3.0037743648899995,"d":"$3.00"}]
["PRICE",{"$nulls":6},{"v":54.61407936163635,"d":"$54.61"}]
[]
["CASH FLOWS",{"$nulls":3},{"v":1.521,"d":"$1.52"},{"v":1.9773,"d":"$1.98"},{"v":2.57049,"d":"$2.57"},{"v":57.39277905163635,"d":"$57.39"}]
[]
["PRESENT VALUE",null,null,{"v":39.08678354538238,"d":"$39.09"}]
[]
[]
[]
[]
[null,{"v":0.09,"d":"9%"},{"v":39.08678354538238,"d":"$39.09"}]
[null,{"v":0.1,"d":"10%"},{"v":114.82590691605039,"d":"$114.83"}]
[null,{"v":0.11,"d":"11%"},{"v":74.91534470164476,"d":"$74.92"}]
[null,{"v":0.12,"d":"12%"},{"v":55.47737563775509,"d":"$55.48"}]
[null,{"v":0.13,"d":"13%"},{"v":43.977609516670654,"d":"$43.98"}]
[null,{"v":0.14,"d":"14%"},{"v":36.379553030658684,"d":"$36.38"}]
[null,{"v":0.15,"d":"15%"},{"v":30.98671324073314,"d":"$30.99"}]
[null,{"v":0.16,"d":"16%"},{"v":26.961584498562587,"d":"$26.96"}]
[null,{"v":0.17,"d":"17%"},{"v":23.84307116104869,"d":"$23.84"}]
[null,{"v":0.18,"d":"18%"},{"v":21.356381395105902,"d":"$21.36"}]
[null,{"v":0.19,"d":"19%"},{"v":19.32756660138421,"d":"$19.33"}]
[null,{"v":0.2,"d":"20%"},{"v":17.64115021008403,"d":"$17.64"}]
[null,{"v":0.21,"d":"21%"},{"v":16.21746401869233,"d":"$16.22"}]

{"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"]}