Year, Present worth Future worth
nDeposit in year 0 in year n
0
110,000 9,346 10,000
211,000
18,954
21,700
312,100 28,831
35,319
413,310 38,985 51,101
514,641 49,424 69,319
616,105
60,155 90,277
717,716 71,188
114,312
819,487 82,529 141,801
921,436 94,189 173,163
10 23,579
106,176 208,864
11 25,937 118,498 249,422
12 28,531 131,167
295,412
13 31,384 144,190 347,475
14 34,523 157,578
406,321
25 98,497 332,095 1,802,424
26 108,347 350,752 2,036,941
27 119,182 369,932 2,298,709
28 131,100 389,650 2,590,718
29 144,210 409,920 2,916,279
30 158,631 430,759 3,279,049
Year, Present worth Future worth
nDeposit in year 0 in year n
0
= $A3+1 10000 =NPV(7%,$B$4:$B4) = -FV(7%,$A4,,$C4)
= $A4+1 = $B4*1.1 =NPV(7%,$B$4:$B5) = -FV(7%,$A5,,$C5)
= $A5+1 = $B5*1.1 =NPV(7%,$B$4:$B6) = -FV(7%,$A6,,$C6)
= $A6+1 = $B6*1.1 =NPV(7%,$B$4:$B7) = -FV(7%,$A7,,$C7)
= $A7+1 = $B7*1.1 =NPV(7%,$B$4:$B8) = -FV(7%,$A8,,$C8)
= $A8+1 = $B8*1.1 =NPV(7%,$B$4:$B9) = -FV(7%,$A9,,$C9)
= $A9+1 = $B9*1.1 =NPV(7%,$B$4:$B10) = -FV(7%,$A10,,$C10)
= $A10+1 = $B10*1.1 =NPV(7%,$B$4:$B11) = -FV(7%,$A11,,$C11)
= $A11+1 = $B11*1.1 =NPV(7%,$B$4:$B12) = -FV(7%,$A12,,$C12)
= $A12+1 = $B12*1.1 =NPV(7%,$B$4:$B13) = -FV(7%,$A13,,$C13)
= $A13+1 = $B13*1.1 =NPV(7%,$B$4:$B14) = -FV(7%,$A14,,$C14)
= $A14+1 = $B14*1.1 =NPV(7%,$B$4:$B15) = -FV(7%,$A15,,$C15)
= $A15+1 = $B15*1.1 =NPV(7%,$B$4:$B16) = -FV(7%,$A16,,$C16)
= $A16+1 = $B16*1.1 =NPV(7%,$B$4:$B17) = -FV(7%,$A17,,$C17)
= $A27+1 = $B27*1.1 =NPV(7%,$B$4:$B28) = -FV(7%,$A28,,$C28)
= $A28+1 = $B28*1.1 =NPV(7%,$B$4:$B29) = -FV(7%,$A29,,$C29)
= $A29+1 = $B29*1.1 =NPV(7%,$B$4:$B30) = -FV(7%,$A30,,$C30)
= $A30+1 = $B30*1.1 =NPV(7%,$B$4:$B31) = -FV(7%,$A31,,$C31)
= $A31+1 = $B31*1.1 =NPV(7%,$B$4:$B32) = -FV(7%,$A32,,$C32)