A B C D E F G H I J K L M N
2
3 FVM
4
5 Category: Time Value Of Money Analysis
6 Family: Annuity
7 Arguments: AnnPmt, PresentValue, InterestAER, TermYrs, PmtsPerYear
8 Meaning: Future Value of an annuity  allowing for different periodicity of payments per year
9 Description: Calculates the Future Value of a simple annuity, taking into account that the annual payments specified may take place during the course of the year.
10
11
12 Check:
13 Interest Annual Pmts Per FVM PVM
14 AER Payment Year PV Term Function Function
15   10% -10 -1 25.49 5     20.00       25.49  
16              
17
18              
19   10% -10 -1 20 5     28.84       20.00  
20   10% -10 1 20 5     34.95       20.00  
21   10% -10 -4 20 5     31.08       20.00  
22   10% -10 4 20 5     32.61       20.00  
23   10% -10 -12 20 5     31.59       20.00  
24   10% -10 12 20 5     32.10       20.00  
25              
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80