B C D E F G H I J K L M N O  
2  
     
3        
4    
 
5     Show Formula:    
6      
7    
8    
9     Future Value On Annuity Calculation (Type Usage)  
10            
11    
12     Annual Deposit:  
13     Interest Rate:  
14     No. Of Years:  
15    
16     Ending Payment   Beginning Payment  
17 (1.1) Year*   (1.2) Year*    
18        
19            
20            
21            
22            
23            
24            
25            
26            
27        
28     Sum     Sum    
29      
30      
31      
32 (2.1) FV  (2.2) FV   
33    
34     FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate.  
35    
36     In this example, two methods (1 and 2) are used for payment at the end of the period (.1) and payment at the beginning of the period (.2).  
37     The last parameter in the FV function is Type.  If Type is 0, then ending payment method is used.  If Type is 1, then beginning     
38     payment method is used (interest starts to accur in the beginning of the period).    
39        
40     * Notice that in this example, number of years in Method One is fixed at 10 years.    
41        
42    
43        
44     Copyright.  Anthony's VBA Page.