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