{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Zero Growth Model","Gordon Growth Model","Multi-Stage Model"],"read":"whole","date_system":"1900"}

{"sheet":"Zero Growth Model","index":0,"n_rows":3,"n_cols":2,"rows_kept":3}
["Dividend",{"v":2,"d":"$2.00"}]
["Required Return",{"v":0.1,"d":"10%"}]
["Stock Price",{"$f":"B1/B2","v":{"v":20,"d":"$20.00"}}]

{"sheet":"Gordon Growth Model","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
["Dividend",{"v":2,"d":"$2.00"}]
["Discount Rate",{"v":0.1,"d":"10%"}]
["Growth Rate",{"v":0.05,"d":"5%"}]
["Stock Price",{"$f":"B1/(B2-B3)","v":{"v":40,"d":"$40.00"}}]

{"sheet":"Multi-Stage Model","index":2,"n_rows":8,"n_cols":8,"rows_kept":8}
["D0",{"v":3,"d":"$3.00"},null,"Year","Growth Rate","Dividend","PV Factor","Present Value of Dividend"]
["Growth for Year 1-3",{"v":0.25,"d":"25%"},null,1,{"v":0.25,"d":"25%"},{"$f":"B1+(B1*E2)","v":{"v":3.75,"d":"$3.75"}},{"$f":"(1+$B$5)^-D2","v":{"v":0.8695652173913044,"d":"0.9"}},{"$f":"F2*G2","v":{"v":3.2608695652173916,"d":"$3.26"}}]
["Growth for Year 4-5",{"v":0.1,"d":"10%"},null,2,{"v":0.25,"d":"25%"},{"$f":"F2+(F2*E3)","v":{"v":4.6875,"d":"$4.69"}},{"$f":"(1+$B$5)^-D3","v":{"v":0.7561436672967865,"d":"0.8"}},{"$f":"F3*G3","v":{"v":3.544423440453687,"d":"$3.54"}}]
["Growth for Year 6+",{"v":0.05,"d":"5%"},null,3,{"v":0.25,"d":"25%"},{"$f":"F3+(F3*E4)","v":{"v":5.859375,"d":"$5.86"}},{"$f":"(1+$B$5)^-D4","v":{"v":0.6575162324319883,"d":"0.7"}},{"v":3.8526341744061816,"d":"$3.85"}]
["Rate of Return",{"v":0.15,"d":"15%"},null,4,{"v":0.1,"d":"10%"},{"v":6.4453125,"d":"$6.45"},{"$f":"(1+$B$5)^-D5","v":{"v":0.5717532455930334,"d":"0.6"}},{"v":3.685128340736348,"d":"$3.69"}]
[{"$nulls":3},5,{"v":0.1,"d":"10%"},{"v":7.08984375,"d":"$7.09"},{"v":0.4971767352982899,"d":"0.5"},{"v":3.524905369399985,"d":"$3.52"}]
[{"$nulls":3},"Terminal Value",{"v":0.05,"d":"5%"},{"$f":"(F6+(F6*B4))/(B5-B4)","v":{"v":74.443359375,"d":"$74.44"}},{"v":0.4971767352982899,"d":"0.5"},{"v":37.01150637869984,"d":"$37.01"}]
[{"$nulls":6},"Stock Value",{"$f":"SUM(H2:H7)","v":{"v":54.87946726891344,"d":"$54.88"}}]