{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["PVsingleCF","ShortPV","ShortFV","Stock","Bond","LongPV","LongFV","CALC","FVIF"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":1,"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":"PVsingleCF","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["To Calculate Future Value",null,null,null,null,null,"Finmath.xls"]
[]
[]
["PV =",100]
[0,1,2,3,4,"…N =",30]
[]
[]
["i =",0.15,null,null,null,"FV =",{"$f":"B4*(1+B8/C9)^(G5*C9)","v":6621.1771956785751}]
[null,"M =",1," <--Compounding Periods per Year"]
[]
[]
["To Calculate Present Value"]
[]
[]
["PV =",{"$f":"G19*(1/((1+B19/C20)^(G16*C20)))","v":6209.2132305915493}]
[0,1,2,3,4,"…N =",5]
[]
[]
["i =",0.1,null,null,null,"FV =",10000]
[null,"M =",1," <--Compounding Periods per Year"]

{"sheet":"ShortPV","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Uneven Cash Flows"]
[null,"Interest Rate =",0.1]
[null,"End of Period","Cash Flow","Discount Factor","PV Cash Flow"]
[null,0,-2500,{"$f":"(1+$C$2)^-B4","v":1},{"$f":"C4*D4","v":-2500}]
[null,{"$f":"1+B4","v":1},600,0.90909090909090906,545.45454545454538]
[null,2,600,0.82644628099173545,495.8677685950413,null,"Note: Be sure that the cash flow"]
[null,3,600,0.75131480090157754,450.78888054094654,null,"column countains no \"blank\" cells -"]
[null,4,600,0.68301345536507052,409.80807321904229,null,"use \"0\" where appropriate!"]
[null,5,600,0.62092132305915493,372.55279383549293]
[null,6,600,0.56447393005377722,338.68435803226635]
[null,7,600,0.51315811823070645,307.89487093842388]
[null,8,600,0.46650738020973315,279.9044281258399]
[null,9,600,0.42409761837248466,254.4585710234908]
[null,10,600,0.38554328942953148,231.32597365771889]
[null,null,null,null,{"$f":"SUM(E4:E14)","v":1186.7402634228083}]
[null,null,"IRR(PVo…FVn) =",{"$f":"IRR(C4:C14,#REF!)","v":{"$error":"#REF!"}}]
[null,null,"NPV(i,FV1…FVn) =",{"$f":"NPV(C2,C5:C14)","v":3686.7402634228079}," <-- Sum of discounted cash flows excluding period zero"]

{"sheet":"ShortFV","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Future Value: Uneven Cash Flows"]
[null,"Interest Rate =",0.1]
[null,"End of Period","Cash Flow (Investment)","Future Value of Investment","Sum of Investment","Sum of Interest"]
[null,0,0,{"$f":"C4","v":0},{"$f":"SUM(C4:C$4)","v":0},{"$f":"D4-E4","v":0}]
[null,{"$f":"1+B4","v":1},2000,{"$f":"D4*(1+$C$2)+C5","v":2000},{"$f":"SUM(C$4:C5)","v":2000},{"$f":"D5-E5","v":0}]
[null,2,{"$f":"C5","v":2000},{"$f":"D5*(1+$C$2)+C6","v":4200},{"$f":"SUM(C$4:C6)","v":4000},200]
[null,3,{"$f":"C6","v":2000},6620,{"$f":"SUM(C$4:C7)","v":6000},620]
[null,4,2000,9282,{"$f":"SUM(C$4:C8)","v":8000},1282]
[null,5,2000,12210.2,{"$f":"SUM(C$4:C9)","v":10000},2210.2000000000007]
[null,6,2000,15431.220000000001,{"$f":"SUM(C$4:C10)","v":12000},3431.2200000000012]
[null,7,2000,18974.342000000004,{"$f":"SUM(C$4:C11)","v":14000},4974.3420000000042]
[null,8,2000,22871.776200000008,{"$f":"SUM(C$4:C12)","v":16000},6871.7762000000075]
[null,9,2000,27158.95382000001,{"$f":"SUM(C$4:C13)","v":18000},9158.9538200000097]
[null,10,2000,31874.849202000012,{"$f":"SUM(C$4:C14)","v":20000},11874.849202000012]
[null,"Sum of CFs",{"$f":"SUM(C4:C14)","v":20000},{"$f":"D14","v":31874.849202000012},"Future Value"]
[null,null,null,{"$f":"C15","v":20000},"Total Investment"]
[null,null,null,{"$f":"D15-D16","v":11874.849202000012},"Total Interest"]

{"sheet":"Stock","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Stock Valuation",null,null,null,"Note: Enter dividends and growth rates until constant"]
[null,"Discount Rate =",0.15,null,"growth is reached."]
[null,"End of Period","Cash Dividend","Next Dividend Growth Rate","Terminal Price = Perpetuity Value of Dividends","Total Cash Flow","Discount Factor","PV of CFs"]
[null,0,1,0.1,{"$f":"IF(C5<=0,C4*(1+D4)/($C$2-D4),0)","v":0},{"$f":"E4","v":0},{"$f":"(1+$C$2)^-B4","v":1},{"$f":"F4*G4","v":0}]
[null,{"$f":"1+B4","v":1},{"$f":"C4*(1+D4)","v":1.1000000000000001},{"$f":"D4","v":0.1},0,{"$f":"C5+E5","v":1.1000000000000001},0.86956521739130443,0.95652173913043492]
[null,2,1.2100000000000002,{"$f":"D5","v":0.1},0,1.2100000000000002,0.7561436672967865,0.91493383742911183]
[null,3,1.3310000000000004,0.08,0,1.3310000000000004,0.65751623243198831,0.87515410536697669]
[null,4,1.4374800000000005,{"$f":"D7","v":0.08},0,1.4374800000000005,0.57175324559303342,0.82188385547507403]
[null,5,1.5524784000000007,0.05,0,1.5524784000000007,0.49717673529828987,0.77185614253311297]
[null,6,1.6301023200000009,{"$f":"D9","v":0.05},0,1.6301023200000009,0.43232759591155645,0.70473821709545104]
[null,7,1.7116074360000011,{"$f":"D10","v":0.05},17.971878078000014,19.683485514000015,0.37593703992309269,7.3997512795022402]
[null,8,null,null,0,0,0.32690177384616753,0]
[null,9,null,null,0,0,0.28426241204014574,0]
[null,10,null,null,0,0,0.24718470612186585,0]
[]
[null,null,null,null,null,null,"Stock Value (t=0) =",{"$f":"SUM(H4:H14)","v":12.444839176532401}]

{"sheet":"Bond","index":4,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["BOND VALUE & Yield to Maturity",null,null,null,null,null,"Data Table: PV of Bonds vs Required Rate"]
[null,null,"Bond 1","Bond 2",null,null,"Required Rate","Value Bond 1","Value Bond 2"]
[null,"Coupon Rate",5.6250000000000001E-2,6.1249999999999999E-2,null,null,null,{"$f":"C40","v":66723.402159900856},{"$f":"D40","v":70526.441913055038}]
[null,"Par Value",100000,100000,null,null,{"$f":"0","v":0},184375,70526.441913055038]
[null,"Maturity (Years)",15,15,null,null,{"$f":"G4+0.01","v":0.01},164125.86789187469,70526.441913055038]
[null,"Required Rate",0.1,0.1,null,null,0.02,146578.58018958091,70526.441913055038]
[null,null,"Cash Flow","Cash Flow",null,null,0.03,131337.07960278718,70526.441913055038]
[null,"t","Bond 1","Bond 2",null,null,0.04,118067.37957727315,70526.441913055038]
[null,0,{"$f":"-C41","v":-96125},{"$f":"-D41","v":-97725},null,null,0.05,106487.28627386282,70526.441913055038]
[null,{"$f":"1+B9","v":1},{"$f":"IF($B10<=C$5,IF($B10=C$5,C$3*C$4+C$4,C$3*C$4),0)","v":5625},{"$f":"IF($B10<=D$5,IF($B10=D$5,D$3*D$4+D$4,D$3*D$4),0)","v":6125},null,null,6.0000000000000005E-2,96357.90662959707,70526.441913055038]
[null,{"$f":"1+B10","v":2},{"$f":"IF($B11<=C$5,IF($B11=C$5,C$3*C$4+C$4,C$3*C$4),0)","v":5625},6125,null,null,7.0000000000000007E-2,87476.618242974888,70526.441913055038]
[null,3,5625,6125,null,null,0.08,79671.23811617482,70526.441913055038]
[null,4,5625,6125,null,null,0.09,72795.176549241878,70526.441913055038]
[null,5,5625,6125,null,null,9.9999999999999992E-2,66723.402159900856,70526.441913055038]
[null,6,5625,6125,null,null,0.10999999999999999,61349.076029504286,70526.441913055038]
[null,7,5625,6125,null,null,0.11999999999999998,56580.738879660654,70526.441913055038]
[null,8,5625,6125,null,null,0.12999999999999998,52339.956178396213,70526.441913055038]
[null,9,5625,6125,null,null,0.13999999999999999,48559.343123780076,70526.441913055038]
[null,10,5625,6125,null,null,0.15,45180.905325333544,70526.441913055038]
[null,11,5625,6125,null,null,0.16,42154.642312896329,70526.441913055038]
[null,12,5625,6125,null,null,0.17,39437.37023996342,70526.441913055038]
[null,13,5625,6125,null,null,0.18000000000000002,36991.727707519152,70526.441913055038]
[null,14,5625,6125,null,null,0.19000000000000003,34785.334831360939,70526.441913055038]
[null,15,105625,106125,null,null,0.20000000000000004,32790.080765419101,70526.441913055038]
[null,16,0,0]
[null,17,{"$f":"IF($B26<=C$5,IF($B26=C$5,C$3*C$4+C$4,C$3*C$4),0)","v":0},0]
[null,18,0,0]
[null,19,0,0]
[null,20,0,0]
[null,21,0,0]
[null,22,0,0]
[null,23,0,0]
[null,24,0,0]
[null,25,0,0]
[null,26,0,0]
[null,27,0,0]
[null,28,0,0]
[null,{"$f":"1+B37","v":29},0,0]
[null,30,0,0]
[null,"Present Value of Bond",{"$f":"NPV(C6,C10:C39)","v":66723.402159900856},{"$f":"NPV(D6,D10:D39)","v":70526.441913055038}]
[null,"Market Price of Bond",{"$f":"100000-1800-125-350-1600","v":96125},{"$f":"100000-1800-125-350","v":97725}]
[null,"Yield to Maturity (YTM)",{"$f":"IRR(C9:C39,C6)","v":6.0246228557024439E-2},{"$f":"IRR(D9:D39,D6)","v":6.3648563205204178E-2}]

{"sheet":"LongPV","index":5,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,"Interest Rate =",0.1]
[null,"End of Period","Cash Flow","Discount Factor","PV Cash Flow"]
[null,0,0,{"$f":"(1+$C$1)^-B3","v":1},{"$f":"C3*D3","v":0},"Note: Be sure that the cash flow"]
[null,{"$f":"1+B3","v":1},0,{"$f":"(1+$C$1)^-B4","v":0.90909090909090906},{"$f":"C4*D4","v":0},"column countains no \"blank\""]
[null,{"$f":"1+B4","v":2},0,0.82644628099173545,0,"cells - use \"0\" where"]
[null,3,0,0.75131480090157754,0,"appropriate!"]
[null,4,0,0.68301345536507052,0]
[null,5,0,0.62092132305915493,0]
[null,6,0,0.56447393005377722,0]
[null,7,0,0.51315811823070645,0]
[null,8,0,0.46650738020973315,0]
[null,9,0,0.42409761837248466,0]
[null,10,0,0.38554328942953148,0]
[null,11,0,0.3504938994813922,0]
[null,12,0,0.31863081771035656,0]
[null,13,0,0.28966437973668779,0]
[null,14,0,0.26333125430607973,0]
[null,15,0,0.23939204936916339,0]
[null,16,0,0.21762913579014853,0]
[null,17,0,0.19784466890013502,0]
[null,18,0,0.17985878990921364,0]
[null,19,0,0.16350799082655781,0]
[null,20,0,0.14864362802414349,0]
[null,21,0,0.13513057093103953,0]
[null,22,0,0.12284597357367227,0]
[null,23,0,0.11167815779424752,0]
[null,24,0,0.10152559799477048,0]
[null,25,0,9.2295998177064048E-2,0]
[null,26,0,8.3905452888240042E-2,0]
[null,27,0,7.6277684443854576E-2,0]
[null,28,0,6.9343349494413245E-2,0]
[null,29,0,6.3039408631284766E-2,0]
[null,30,0,5.7308553301167964E-2,0]
[null,31,0,5.2098684819243603E-2,0]
[null,32,0,4.7362440744766907E-2,0]
[null,33,0,4.3056764313424457E-2,0]
[null,34,0,3.9142513012204054E-2,0]
[null,35,0,3.5584102738367311E-2,0]
[null,36,0,3.2349184307606652E-2,0]
[null,37,0,2.94083493705515E-2,0]
[null,38,0,2.6734863064137721E-2,0]
[null,39,0,2.4304420967397926E-2,0]
[null,40,0,2.2094928152179935E-2,0]
[null,41,0,2.0086298320163575E-2,0]
[null,42,0,1.8260271200148705E-2,0]
[null,43,0,1.6600246545589729E-2,0]
[null,44,0,1.5091133223263388E-2,0]
[null,45,0,1.3719212021148534E-2,0]
[null,46,0,1.2472010928316847E-2,0]
[null,47,0,1.1338191753015316E-2,0]
[null,48,0,1.0307447048195742E-2,0]
[null,49,0,9.3704064074506734E-3,0]
[null,50,0,8.5185512795006111E-3,0]
[null,51,0,7.744137526818737E-3,0]
[null,52,0,7.0401250243806697E-3,0]
[null,53,0,6.4001136585278805E-3,0]
[null,54,0,5.8182851441162548E-3,0]
[null,55,0,5.2893501310147762E-3,0]
[null,56,0,4.808500119104343E-3,0]
[null,57,0,4.3713637446403109E-3,0]
[null,58,0,3.9739670405821012E-3,0]
[null,59,0,3.6126973096200906E-3,0]
[null,{"$f":"1+B62","v":60},0,3.2842702814728101E-3,{"$f":"C63*D63","v":0}]
[null,null,null,null,{"$f":"SUM(E3:E63)","v":0}]
[null,null,"IRR(PVo…FVn) =",{"$f":"IRR(C3:C63,E70)","v":{"$error":"#NUM!"}}]
[null,null,"NPV(i,FV1…FVn) =",{"$f":"NPV(C1,C4:C63)","v":0},{"$f":"D66+E3","v":0}," <-- Actual NPV"]

{"sheet":"LongFV","index":6,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,7,0,10]]}
["Future Value: Uneven Cash Flows",null,null,null,null,null,null,"Competing Investment"]
[null,null,null,"Interest Rate =",0.12,null,null,null,"Interest Rate =",0.11]
[null,"End of Period","Cash Flow (Investment)","Future Value of Investment","Sum of Investment","Sum of      Interest",null,"Cash Flow (Investment)","Future Value of Investment","Sum of Investment","Sum of      Interest"]
[null,0,0,{"$f":"C4","v":0},{"$f":"SUM(C4:C$4)","v":0},{"$f":"D4-E4","v":0},null,0,{"$f":"H4","v":0},{"$f":"SUM(H4:H$4)","v":0},{"$f":"I4-J4","v":0}]
[null,{"$f":"1+B4","v":1},2000,{"$f":"D4*(1+$E$2)+C5","v":2000},{"$f":"SUM(C$4:C5)","v":2000},{"$f":"D5-E5","v":0},null,2000,{"$f":"I4*(1+$J$2)+H5","v":2000},{"$f":"SUM(H$4:H5)","v":2000},{"$f":"I5-J5","v":0}]
[null,2,{"$f":"C5","v":2000},4240,{"$f":"SUM(C$4:C6)","v":4000},240,null,{"$f":"H5","v":2000},{"$f":"I5*(1+$J$2)+H6","v":4220},{"$f":"SUM(H$4:H6)","v":4000},220]
[null,3,{"$f":"C6","v":2000},6748.8,{"$f":"SUM(C$4:C7)","v":6000},748.80000000000018,null,{"$f":"H6","v":2000},6684.2000000000007,{"$f":"SUM(H$4:H7)","v":6000},684.20000000000073]
[null,4,2000,9558.6560000000009,{"$f":"SUM(C$4:C8)","v":8000},1558.6560000000009,null,2000,9419.4620000000014,{"$f":"SUM(H$4:H8)","v":8000},1419.4620000000014]
[null,5,2000,12705.694720000001,{"$f":"SUM(C$4:C9)","v":10000},2705.6947200000013,null,2000,12455.602820000002,{"$f":"SUM(H$4:H9)","v":10000},2455.6028200000019]
[null,6,2000,16230.378086400004,{"$f":"SUM(C$4:C10)","v":12000},4230.3780864000037,null,2000,15825.719130200003,{"$f":"SUM(H$4:H10)","v":12000},3825.7191302000028]
[null,7,2000,20178.023456768005,{"$f":"SUM(C$4:C11)","v":14000},6178.0234567680054,null,2000,19566.548234522004,{"$f":"SUM(H$4:H11)","v":14000},5566.5482345220043]
[null,8,0,22599.38627158017,{"$f":"SUM(C$4:C12)","v":14000},8599.3862715801697,null,0,21718.868540319425,{"$f":"SUM(H$4:H12)","v":14000},7718.8685403194249]
[null,9,0,25311.312624169794,{"$f":"SUM(C$4:C13)","v":14000},11311.312624169794,null,0,24107.944079754565,{"$f":"SUM(H$4:H13)","v":14000},10107.944079754565]
[null,{"$f":"1+B13","v":10},{"$f":"C13","v":0},28348.670139070171,{"$f":"SUM(C$4:C14)","v":14000},{"$f":"D14-E14","v":14348.670139070171},null,0,26759.817928527569,{"$f":"SUM(H$4:H14)","v":14000},12759.817928527569]
[null,11,0,31750.510555758596,{"$f":"SUM(C$4:C15)","v":14000},17750.510555758596,null,0,29703.397900665605,{"$f":"SUM(H$4:H15)","v":14000},15703.397900665605]
[null,12,0,35560.57182244963,{"$f":"SUM(C$4:C16)","v":14000},21560.57182244963,null,0,32970.771669738824,{"$f":"SUM(H$4:H16)","v":14000},18970.771669738824]
[null,13,0,39827.840441143591,{"$f":"SUM(C$4:C17)","v":14000},25827.840441143591,null,0,36597.556553410097,{"$f":"SUM(H$4:H17)","v":14000},22597.556553410097]
[null,14,0,44607.181294080823,{"$f":"SUM(C$4:C18)","v":14000},30607.181294080823,null,0,40623.287774285214,{"$f":"SUM(H$4:H18)","v":14000},26623.287774285214]
[null,15,0,49960.043049370528,{"$f":"SUM(C$4:C19)","v":14000},35960.043049370528,null,0,45091.84942945659,{"$f":"SUM(H$4:H19)","v":14000},31091.84942945659]
[null,16,0,55955.248215294996,{"$f":"SUM(C$4:C20)","v":14000},41955.248215294996,null,0,50051.952866696818,{"$f":"SUM(H$4:H20)","v":14000},36051.952866696818]
[null,17,0,62669.878001130404,{"$f":"SUM(C$4:C21)","v":14000},48669.878001130404,null,0,55557.667682033476,{"$f":"SUM(H$4:H21)","v":14000},41557.667682033476]
[null,18,0,70190.263361266057,{"$f":"SUM(C$4:C22)","v":14000},56190.263361266057,null,0,61669.011127057165,{"$f":"SUM(H$4:H22)","v":14000},47669.011127057165]
[null,19,0,78613.094964617994,{"$f":"SUM(C$4:C23)","v":14000},64613.094964617994,null,0,68452.602351033463,{"$f":"SUM(H$4:H23)","v":14000},54452.602351033463]
[null,20,0,88046.666360372168,{"$f":"SUM(C$4:C24)","v":14000},74046.666360372168,null,0,75982.388609647154,{"$f":"SUM(H$4:H24)","v":14000},61982.388609647154]
[null,21,0,98612.266323616845,{"$f":"SUM(C$4:C25)","v":14000},84612.266323616845,null,0,84340.451356708349,{"$f":"SUM(H$4:H25)","v":14000},70340.451356708349]
[null,22,0,110445.73828245088,{"$f":"SUM(C$4:C26)","v":14000},96445.738282450882,null,0,93617.901005946274,{"$f":"SUM(H$4:H26)","v":14000},79617.901005946274]
[null,23,0,123699.226876345,{"$f":"SUM(C$4:C27)","v":14000},109699.226876345,null,0,103915.87011660037,{"$f":"SUM(H$4:H27)","v":14000},89915.870116600374]
[null,24,0,138543.13410150641,{"$f":"SUM(C$4:C28)","v":14000},124543.13410150641,null,0,115346.61582942643,{"$f":"SUM(H$4:H28)","v":14000},101346.61582942643]
[null,25,0,155168.31019368718,{"$f":"SUM(C$4:C29)","v":14000},141168.31019368718,null,0,128034.74357066336,{"$f":"SUM(H$4:H29)","v":14000},114034.74357066336]
[null,26,0,173788.50741692967,{"$f":"SUM(C$4:C30)","v":14000},159788.50741692967,null,0,142118.56536343633,{"$f":"SUM(H$4:H30)","v":14000},128118.56536343633]
[null,27,0,194643.12830696124,{"$f":"SUM(C$4:C31)","v":14000},180643.12830696124,null,0,157751.60755341433,{"$f":"SUM(H$4:H31)","v":14000},143751.60755341433]
[null,28,0,218000.30370379661,{"$f":"SUM(C$4:C32)","v":14000},204000.30370379661,null,0,175104.28438428993,{"$f":"SUM(H$4:H32)","v":14000},161104.28438428993]
[null,29,0,244160.34014825223,{"$f":"SUM(C$4:C33)","v":14000},230160.34014825223,null,0,194365.75566656183,{"$f":"SUM(H$4:H33)","v":14000},180365.75566656183]
[null,30,0,273459.58096604253,{"$f":"SUM(C$4:C34)","v":14000},259459.58096604253,null,0,215745.98878988365,{"$f":"SUM(H$4:H34)","v":14000},201745.98878988365]
[null,31,0,306274.73068196769,{"$f":"SUM(C$4:C35)","v":14000},292274.73068196769,null,0,239478.04755677088,{"$f":"SUM(H$4:H35)","v":14000},225478.04755677088]
[null,32,0,343027.69836380385,{"$f":"SUM(C$4:C36)","v":14000},329027.69836380385,null,0,265820.6327880157,{"$f":"SUM(H$4:H36)","v":14000},251820.6327880157]
[null,33,0,{"$f":"D36*(1+$E$2)+C37","v":384191.02216746035},{"$f":"SUM(C$4:C37)","v":14000},370191.02216746035,null,0,295060.90239469748,{"$f":"SUM(H$4:H37)","v":14000},281060.90239469748]
[null,34,0,430293.94482755562,{"$f":"SUM(C$4:C38)","v":14000},416293.94482755562,null,0,327517.60165811423,{"$f":"SUM(H$4:H38)","v":14000},313517.60165811423]
[null,35,0,481929.21820686234,{"$f":"SUM(C$4:C39)","v":14000},467929.21820686234,null,0,363544.53784050682,{"$f":"SUM(H$4:H39)","v":14000},349544.53784050682]
[null,36,0,539760.72439168592,{"$f":"SUM(C$4:C40)","v":14000},525760.72439168592,null,0,403534.43700296263,{"$f":"SUM(H$4:H40)","v":14000},389534.43700296263]
[null,37,0,604532.01131868828,{"$f":"SUM(C$4:C41)","v":14000},590532.01131868828,null,0,447923.22507328854,{"$f":"SUM(H$4:H41)","v":14000},433923.22507328854]
[null,38,0,677075.85267693095,{"$f":"SUM(C$4:C42)","v":14000},663075.85267693095,null,0,497194.77983135032,{"$f":"SUM(H$4:H42)","v":14000},483194.77983135032]
[null,39,0,758324.95499816269,{"$f":"SUM(C$4:C43)","v":14000},744324.95499816269,null,0,551886.20561279892,{"$f":"SUM(H$4:H43)","v":14000},537886.20561279892]
[null,40,0,849323.94959794229,{"$f":"SUM(C$4:C44)","v":14000},835323.94959794229,null,0,612593.68823020684,{"$f":"SUM(H$4:H44)","v":14000},598593.68823020684]
[null,41,0,951242.82354969543,{"$f":"SUM(C$4:C45)","v":14000},937242.82354969543,null,0,679978.99393552961,{"$f":"SUM(H$4:H45)","v":14000},665978.99393552961]
[null,42,0,1065391.962375659,{"$f":"SUM(C$4:C46)","v":14000},1051391.962375659,null,0,754776.68326843798,{"$f":"SUM(H$4:H46)","v":14000},740776.68326843798]
[null,43,0,1193238.9978607383,{"$f":"SUM(C$4:C47)","v":14000},1179238.9978607383,null,0,837802.11842796626,{"$f":"SUM(H$4:H47)","v":14000},823802.11842796626]
[null,44,0,1336427.6776040271,{"$f":"SUM(C$4:C48)","v":14000},1322427.6776040271,null,0,929960.3514550426,{"$f":"SUM(H$4:H48)","v":14000},915960.3514550426]
[null,45,0,1496798.9989165105,{"$f":"SUM(C$4:C49)","v":14000},1482798.9989165105,null,0,1032255.9901150974,{"$f":"SUM(H$4:H49)","v":14000},1018255.9901150974]
[null,46,0,1676414.8787864919,{"$f":"SUM(C$4:C50)","v":14000},1662414.8787864919,null,0,1145804.1490277583,{"$f":"SUM(H$4:H50)","v":14000},1131804.1490277583]
[null,47,0,1877584.6642408711,{"$f":"SUM(C$4:C51)","v":14000},1863584.6642408711,null,0,1271842.6054208118,{"$f":"SUM(H$4:H51)","v":14000},1257842.6054208118]
[null,48,0,2102894.8239497757,{"$f":"SUM(C$4:C52)","v":14000},2088894.8239497757,null,0,1411745.2920171013,{"$f":"SUM(H$4:H52)","v":14000},1397745.2920171013]
[null,49,0,2355242.2028237488,{"$f":"SUM(C$4:C53)","v":14000},2341242.2028237488,null,0,1567037.2741389826,{"$f":"SUM(H$4:H53)","v":14000},1553037.2741389826]
[null,50,0,2637871.2671625991,{"$f":"SUM(C$4:C54)","v":14000},2623871.2671625991,null,0,1739411.374294271,{"$f":"SUM(H$4:H54)","v":14000},1725411.374294271]
[null,51,0,2954415.8192221113,{"$f":"SUM(C$4:C55)","v":14000},2940415.8192221113,null,0,1930746.625466641,{"$f":"SUM(H$4:H55)","v":14000},1916746.625466641]
[null,52,0,3308945.7175287651,{"$f":"SUM(C$4:C56)","v":14000},3294945.7175287651,null,0,2143128.754267972,{"$f":"SUM(H$4:H56)","v":14000},2129128.754267972]
[null,53,0,3706019.2036322174,{"$f":"SUM(C$4:C57)","v":14000},3692019.2036322174,null,0,2378872.917237449,{"$f":"SUM(H$4:H57)","v":14000},2364872.917237449]
[null,54,0,4150741.5080680838,{"$f":"SUM(C$4:C58)","v":14000},4136741.5080680838,null,0,2640548.9381335685,{"$f":"SUM(H$4:H58)","v":14000},2626548.9381335685]
[null,55,0,4648830.4890362546,{"$f":"SUM(C$4:C59)","v":14000},4634830.4890362546,null,0,2931009.3213282614,{"$f":"SUM(H$4:H59)","v":14000},2917009.3213282614]
[null,56,0,5206690.1477206061,{"$f":"SUM(C$4:C60)","v":14000},5192690.1477206061,null,0,3253420.3466743706,{"$f":"SUM(H$4:H60)","v":14000},3239420.3466743706]
[null,57,0,5831492.9654470794,{"$f":"SUM(C$4:C61)","v":14000},5817492.9654470794,null,0,3611296.5848085517,{"$f":"SUM(H$4:H61)","v":14000},3597296.5848085517]
[null,58,0,6531272.1213007299,{"$f":"SUM(C$4:C62)","v":14000},6517272.1213007299,null,0,4008539.2091374928,{"$f":"SUM(H$4:H62)","v":14000},3994539.2091374928]
[null,59,0,7315024.7758568181,{"$f":"SUM(C$4:C63)","v":14000},7301024.7758568181,null,0,4449478.522142617,{"$f":"SUM(H$4:H63)","v":14000},4435478.522142617]
[null,{"$f":"1+B63","v":60},{"$f":"C63","v":0},8192827.7489596372,{"$f":"SUM(C$4:C64)","v":14000},{"$f":"D64-E64","v":8178827.7489596372},null,0,4938921.1595783057,{"$f":"SUM(H$4:H64)","v":14000},4924921.1595783057]
[null,"Sum of CFs",{"$f":"SUM(C4:C64)","v":14000},{"$f":"D64","v":8192827.7489596372},"Future Value",null,null,{"$f":"SUM(H4:H64)","v":14000},{"$f":"I64","v":4938921.1595783057},"Future Value"]
[null,null,null,{"$f":"C65","v":14000},"Total Investment",null,null,null,{"$f":"H65","v":14000},"Total Investment"]
[null,null,null,{"$f":"D65-D66","v":8178827.7489596372},"Total Interest",null,null,null,{"$f":"I65-I66","v":4924921.1595783057},"Total Interest"]

{"sheet":"CALC","index":7,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Financial Math Calculator",null,null,null,null,{"$f":"IF(F3,\"PMT @ Beginning\", \"PMT @ End\")","v":"PMT @ Beginning"},"of Period"]
["N","IY","PV","PMT","FV","Type"]
[10,0.1,-40000,5625,5000,1,"<-- Inputs"]
[null,null,null,"Result","Excel function"]
[null,{"$f":"getformula(D5)","v":" =FV(IY,N,PMT,PV,Type) -->"},null,{"$f":"FV(IY,N,PMT,PV,Type)","v":5136.8836853124521},"FV"]
[null,{"$f":"getformula(D6)","v":" =NPER(IY,PMT,PV,FV,Type) -->"},null,{"$f":"NPER(IY,PMT,PV,FV,Type)","v":10.025282157573658},"NPER"]
[null,{"$f":"getformula(D7)","v":" =PMT(IY,N,PV,FV,Type) -->"},null,{"$f":"PMT(IY,N,PV,FV,Type)","v":5632.8080189890061},"PMT"]
[null,{"$f":"getformula(D8)","v":" =PV(IY,N,PMT,FV,Type) -->"},null,{"$f":"PV(IY,N,PMT,FV,Type)","v":-39947.2254136954},"PV"]
[null,{"$f":"getformula(D9)","v":" =RATE(N,PMT,PV,FV,Type) -->"},null,{"$f":"RATE(N,PMT,PV,FV,Type)","v":9.9639676691242976E-2},"RATE"]

{"sheet":"FVIF","index":8,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["FVIF TABLE"]
[null,0.02,0.04,0.06,0.08,0.1]
[1,{"$f":"(1+B$2)^$A3","v":1.02},1.04,1.06,1.08,1.1000000000000001]
[2,1.0404,1.0816000000000001,1.1236000000000002,1.1664000000000001,1.2100000000000002]
[3,1.0612079999999999,1.1248640000000001,1.1910160000000003,1.2597120000000002,1.3310000000000004]
[4,1.08243216,1.1698585600000002,1.2624769600000003,1.3604889600000003,1.4641000000000004]
[5,1.1040808032,1.2166529024000003,1.3382255776000005,1.4693280768000003,1.6105100000000006]
[]
[]
[null,null,"Rate =",0.1]
[null,null,"N =",5]
[null,null,"FVIF =",{"$f":"(1+D10)^D11","v":1.6105100000000006}]
["data table: FVIF"]
[{"$f":"D12","v":1.6105100000000006},0.02,0.04,0.06,0.08,0.1]
[1,1.02,1.04,1.06,1.08,1.1000000000000001]
[2,1.0404,1.0816000000000001,1.1236000000000002,1.1664000000000001,1.2100000000000002]
[3,1.0612079999999999,1.1248640000000001,1.1910160000000003,1.2597120000000002,1.3310000000000004]
[4,1.08243216,1.1698585600000002,1.2624769600000003,1.3604889600000003,1.4641000000000004]
[5,1.1040808032,1.2166529024000003,1.3382255776000005,1.4693280768000003,1.6105100000000006]