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  
10            
11    
12    
13     Annual Deposit:  
14     Interest Rate:    
15     No. Of Years:  
16    
17   (1) Year*    
18        
19        
20        
21        
22        
23        
24        
25        
26        
27        
28     Sum    
29      
30      
31      
32   (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 to show how to derive present value on annuity.  
37     Change Annual Deposit, Interest Rate, and No. of Year to see how the numbers in the table and the chart change.    
38        
39     * Notice that in this example, number of years in Method One is fixed at 10 years.    
40        
41     More Example on PV  
42    
43        
44     Copyright.  Anthony's VBA Page.