{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TVMHomework"],"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":"TVMHomework","index":0,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Question","Variable",null,"Answer",null,"Formulas"]
["Q1, Amy","PMT monthly (PMT)",500]
[null,"APR ( R )",0.06,null,"annual"]
[null,"N",18,null,"years"]
[]
["1)","FV (Microsoft Excel)",null,{"$f":"FV(C3,C4,-C2)","v":15452.826274273524},null,{"$f":"_xlfn.FORMULATEXT(D6)","v":"=FV(C3,C4,-C2)"}]
["2)","FV (VBA)",null,{"$f":"FV(C3,C4,-C2)","v":15452.826274273524},null,{"$f":"_xlfn.FORMULATEXT(D7)","v":"=FV(C3,C4,-C2)"}]
["3)","FV (Math)",null,{"$f":"FV(C3,C4,-C2)","v":15452.826274273524}]
[]
["Q2, John","N",3,null,"years"]
[null,"FV",65000]
[null,"PV",15000]
[null,"APR ( R )",0.08,null,"annual"]
[]
["4)","PMT (Microsoft Excel)",null,{"$f":"PMT(C13/12,C10*12,-C12)","v":470.04548192146274},"monthly",{"$f":"_xlfn.FORMULATEXT(D15)","v":"=PMT(C13/12,C10*12,-C12)"}]
["5)","PMT (VBA)",null,{"$f":"PMT(C13/12,C10*12,-C12)","v":470.04548192146274},"monthly",{"$f":"_xlfn.FORMULATEXT(D16)","v":"=PMT(C13/12,C10*12,-C12)"}]
["6)","PMT (Math)",null,{"$f":"PMT(C13/12,C10*12,-C12)","v":470.04548192146274},"monthly"]
[]
["Q3, Juan","Lottery Prize (millions)",13,null,"millions"]
[null,"Annuity (millions)",1,null,"per year"]
[null,"APR ( R )",7.0000000000000007E-2,null,"annual"]
[null,"N (begin now) in years",25,null,"years"]
[]
["7)","Benefit of lumpsum option (Excel)","Gain/Loss of",{"$f":"FV(C21,C22,C20,-C19)","v":7.3075866055562884},"millions"]
["8)","Benefit of lumpsum option (VBA)","Gain/Loss of",{"$f":"FV(C21,C22,C20,-C19)","v":7.3075866055562884},"millions",{"$f":"_xlfn.FORMULATEXT(D25)","v":"=FV(C21,C22,C20,-C19)"}]
["9)","Benefit of lumpsum (Math)","Gain/Loss of",{"$f":"FV(C21,C22,C20,-C19)","v":7.3075866055562884},"millions"]
[]
["Q4, Cathy","Original loan"]
[null,"Years Ago (N)",6,null,"years"]
[null,"Term (years, N0)",30,null,"years"]
[null,"APR (R0)",6.5000000000000002E-2,null,"annual"]
[null,"Loan Amt (PV0)",500000]
[]
[null,"New Loan"]
[null,"Term (years, N1)",20,null,"years"]
[null,"APR (R1)",4.2500000000000003E-2,null,"annual"]
[]
[]
[]
[]
["10)","Monthly savings (Excel)","increase/decrease by",{"$f":"PMT(C36/12,C35*12,C32)","v":-3096.1723458730894},null,{"$f":"_xlfn.FORMULATEXT(D41)","v":"=PMT(C36/12,C35*12,C32)"}]
["11)","Monthly savings (VBA)","increase/decrease by",{"$f":"PMT(C36/12,C35*12,C32)","v":-3096.1723458730894},null,{"$f":"_xlfn.FORMULATEXT(D42)","v":"=PMT(C36/12,C35*12,C32)"}]
["12)","Monthly savings (Math)","increase/decrease by",{"$f":"PMT(C36/12,C35*12,C32)","v":-3096.1723458730894}]
[]
["Q5, Makayla","PMT1",10000]
[null,"g",0.04]
[null,"N",30,"years"]
[null,"APR ( R )",0.08]
[]
[]
["13)","PV of growing Annuity (Excel)",null,{"$f":"PV(C46,C47,C45)","v":-172920.33300664491},null,{"$f":"_xlfn.FORMULATEXT(D51)","v":"=PV(C46,C47,C45)"}]
["14)","PV of growing Annuity (VBA)",null,{"$f":"PV(C46,C47,C45)","v":-172920.33300664491},null,{"$f":"_xlfn.FORMULATEXT(D52)","v":"=PV(C46,C47,C45)"}]
["15)","PV of growing Annuity (Math)",null,{"$f":"PV(C46,C47,C45)","v":-172920.33300664491},null,{"$f":"_xlfn.FORMULATEXT(D53)","v":"=PV(C46,C47,C45)"}]