{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Inputs","Investment"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Inputs","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Personal Investment Program"]
[]
["Step 1: Enter the input values below."]
["Annual Percentage Rate (APR)",0.06]
["No. of Years to Invest",4]
["Amount Invested Each Period",100]
["Start of 1st Period","2012-08-01"]
[]
["Step 2: Click button to display results."]

{"sheet":"Investment","index":1,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,3,2,4]]}
["Summary Area",null,null,"*Due to rounding, these\n  values may be different\n  from the list ending value\n  by a few cents."]
["APR",{"$f":"Inputs!B4","v":0.06}]
["No. of Years",{"$f":"Inputs!B5","v":4}]
["No. of Pmts per Year",12]
["Deposit per Period",{"$f":"Inputs!B6","v":100}]
["Start of 1st Period",{"$f":"DATE(YEAR(Inputs!B7),MONTH(Inputs!B7),DAY(Inputs!B7))","v":"2012-08-01"}]
["Start of Last Period",{"$f":"DATE(YEAR(B6)+B3,MONTH(B6)-1,DAY(B6))","v":"2016-07-01"}]
["Maturity Date",{"$f":"EDATE(B6,B3*B4)","v":"2016-08-01"}]
["Maturity Value*",{"$f":"FV(B2/B4,B3*B4,-B5,,1)","v":5436.8321380171265},null,"Cross-Check*",5436.83]
[]
["Period\nStart Date","Beginning Value","Beg-of-Period Invest","Interest Earned","Ending Value"]
["2012-08-01",null,100,0.5,100.5]
["2012-09-01",100.5,100,1,201.5]
["2012-10-01",201.5,100,1.51,303.01]
["2012-11-01",303.01,100,2.02,405.03]
["2012-12-01",405.03,100,2.5299999999999998,507.56]
["2013-01-01",507.56,100,3.04,610.6]
["2013-02-01",610.6,100,3.55,714.15]
["2013-03-01",714.15,100,4.07,818.22]
["2013-04-01",818.22,100,4.59,922.81]
["2013-05-01",922.81,100,5.1100000000000003,1027.92]
["2013-06-01",1027.92,100,5.64,1133.56]
["2013-07-01",1133.56,100,6.17,1239.73]
["2013-08-01",1239.73,100,6.7,1346.43]
["2013-09-01",1346.43,100,7.23,1453.66]
["2013-10-01",1453.66,100,7.77,1561.43]
["2013-11-01",1561.43,100,8.31,1669.74]
["2013-12-01",1669.74,100,8.85,1778.59]
["2014-01-01",1778.59,100,9.39,1887.98]
["2014-02-01",1887.98,100,9.94,1997.92]
["2014-03-01",1997.92,100,10.49,2108.41]
["2014-04-01",2108.41,100,11.04,2219.4499999999998]
["2014-05-01",2219.4499999999998,100,11.6,2331.0500000000002]
["2014-06-01",2331.0500000000002,100,12.16,2443.21]
["2014-07-01",2443.21,100,12.72,2555.9299999999998]
["2014-08-01",2555.9299999999998,100,13.28,2669.21]
["2014-09-01",2669.21,100,13.85,2783.06]
["2014-10-01",2783.06,100,14.42,2897.48]
["2014-11-01",2897.48,100,14.99,3012.47]
["2014-12-01",3012.47,100,15.56,3128.03]
["2015-01-01",3128.03,100,16.14,3244.17]
["2015-02-01",3244.17,100,16.72,3360.89]
["2015-03-01",3360.89,100,17.3,3478.19]
["2015-04-01",3478.19,100,17.89,3596.08]
["2015-05-01",3596.08,100,18.48,3714.56]
["2015-06-01",3714.56,100,19.07,3833.63]
["2015-07-01",3833.63,100,19.670000000000002,3953.3]
["2015-08-01",3953.3,100,20.27,4073.57]
["2015-09-01",4073.57,100,20.87,4194.4399999999996]
["2015-10-01",4194.4399999999996,100,21.47,4315.91]
["2015-11-01",4315.91,100,22.08,4437.99]
["2015-12-01",4437.99,100,22.69,4560.68]
["2016-01-01",4560.68,100,23.3,4683.9799999999996]
["2016-02-01",4683.9799999999996,100,23.92,4807.8999999999996]
["2016-03-01",4807.8999999999996,100,24.54,4932.4399999999996]
["2016-04-01",4932.4399999999996,100,25.16,5057.6000000000004]
["2016-05-01",5057.6000000000004,100,25.79,5183.3900000000003]
["2016-06-01",5183.3900000000003,100,26.42,5309.81]
["2016-07-01",5309.81,100,27.05,5436.86]