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.
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.