{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input","Output"],"not_rendered":{"charts":0,"images":4,"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":"Input","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Financial Functions"]
[]
["Click",null,null,"to calculate the present value of an annuity."]
[]
[]
["Click",null,null,"to calculate the future value of an annuity."]
[]
[]
["Click",null,null,"to calculate the APR of an annuity"]

{"sheet":"Output","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4],[0,6,0,7]]}
["Present Value",null,null,"Future Value",null,null,"Rate"]
["APR:",0.05,null,"APR:",7.4999999999999997E-2]
["Rate:",4.1700000000000001E-3,null,"Rate:",6.2500000000000003E-3,null,"Present Value:",100000]
["Years:",15,null,"Years:",25,null,"Years:",20]
["NPER:",180,null,"NPER:",300,null,"NPER:",240]
["Payment:",125.35,null,"Payment:",125.5,null,"Payment:",965.02]
["Present Value:",15851.16,null,"Present Value:",50000,null,"Rate (APR):",0.1]
["Excel Cross Check:",{"$f":"PV(B2/12,B4*12,-B6)","v":15851.164673203481},null,"Future Value:",434240.26,null,"Excel Cross Check:",{"$f":"RATE(H4*12,-H6,H3)*12","v":9.9999751703837153E-2}]
[null,null,null,"Excel Cross Check:",{"$f":"-FV(E2/12,E4*12,E6,E7)","v":434240.26180188352}]