{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Percentage","Each Year","FV","Formula","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Percentage","index":0,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,9,1,12],[1,1,1,4]]}
[]
[null,"Using Percentage Formula",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Initial Investment","Interest Rate","In 1 year","In 2 year",null,null,null,null,"Initial Investment","Interest Rate","In 1 year","In 2 year"]
[null,15,7.0000000000000007E-2,{"$f":"B5*(1+$C5)","v":16.05},{"$f":"D5*(1+$C5)","v":17.173500000000001},null,null,null,null,15,7.0000000000000007E-2]
[null,20,0.05,{"$f":"B6*(1+$C6)","v":21},{"$f":"D6*(1+$C6)","v":22.05},null,null,null,null,20,0.05]
[null,25,0.04,26,27.04,null,null,null,null,25,0.04]
[null,30,0.08,32.400000000000006,34.992000000000012,null,null,null,null,30,0.08]
[null,35,0.09,38.150000000000006,41.583500000000008,null,null,null,null,35,0.09]
[null,40,0.06,42.400000000000006,44.94400000000001,null,null,null,null,40,0.06]

{"sheet":"Each Year","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Calculating Earned Interest for Each Year",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Period","Balance",null,"Initial Deposit",null,null,null,null,null,"Period","Balance",null,"Initial Deposit"]
[null,"Year 1",{"$f":"E5 + E5 * $E$7","v":54},null,50,null,null,null,null,null,"Year 1",null,null,50]
[null,"Year 2",{"$f":"C5 + C5 * $E$7","v":58.32},null,"Interest Rate",null,null,null,null,null,"Year 2",null,null,"Interest Rate"]
[null,"Year 3",{"$f":"C6 + C6 * $E$7","v":62.985599999999998},null,0.08,null,null,null,null,null,"Year 3",null,null,0.08]
[null,"Year 4",68.024447999999992,null,null,null,null,null,null,null,"Year 4"]
[null,"Year 5",73.466403839999998,null,null,null,null,null,null,null,"Year 5"]
[null,"Year 6",79.343716147199999,null,null,null,null,null,null,null,"Year 6"]

{"sheet":"FV","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using FV Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Initial Investment",5000,null,null,null,"Initial Investment"]
[null,"Annual Interest Rate",0.09,null,null,null,"Annual Interest Rate"]
[null,"Compounding Periods Per Year",50,null,null,null,"Compounding Periods Per Year"]
[null,"Years",13,null,null,null,"Years"]
[]
[null,"Balance",{"$f":"FV(C5/C6, C7*C6, , -C4)","v":16093.028637428473},null,null,null,"Balance"]

{"sheet":"Formula","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using Compound Interest Formula",null,null,null,null,"Practice Yourself"]
[]
[null,"Initial Investment",5000,null,null,null,"Initial Investment"]
[null,"Annual Interest Rate",0.09,null,null,null,"Annual Interest Rate"]
[null,"Compounding Periods Per Year",50,null,null,null,"Compounding Periods Per Year"]
[null,"Years",13,null,null,null,"Years"]
[]
[null,"Balance",{"$f":"C4 * (1 + C5 /C6) ^ (C7 * C6)","v":16093.028637428473},null,null,null,"Balance"]

{"sheet":"VBA","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using VBA Code",null,null,null,null,"Practice Yourself"]
[]
[null,"Initial Investment",5000,null,null,null,"Initial Investment"]
[null,"Annual Interest Rate",0.09,null,null,null,"Annual Interest Rate"]
[null,"Compounding Periods Per Year",50,null,null,null,"Compounding Periods Per Year"]
[null,"Years",13,null,null,null,"Years"]
[]
[null,"Balance",16093.028637428066,null,null,null,"Balance"]