B C D E F G H I J K L M N O  
2  
     
3        
4    
 
5     Show Formula:    
6      
7    
8    
9     Present 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) PV  (2.2)  PV   
33    
34     PV returns the present value of an investment. The present value is the total amount that a series of future payments is worth now.  
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 PV function is Type.  If Type is 0, then ending payment method is used.  If Type is 1, then beginning     
38     payment method is used (discounting starts 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.