PVCOPPA calculates the present value of a certain-only annuity based on the so-called PPA assumption for interest
(3 segment rates).
Syntax
PVCOPPA(InterestRate1, InterestRate2, InterestRate3,
[YearsCertain], [Frequency], [COLA])
Parameter Name |
Description |
||||||||||||||
InterestRate1 |
Segment
rate 1 -- to discount payments made during the first 5 years (years 1 to 5). Must be a single number. ·
Note:
A value that is greater than 25% (i.e. 0.25) will be divided by 100; e.g.
if you enter 2.75 it will be treated as .0275 or 2.75%. |
||||||||||||||
InterestRate2 |
Segment
rate 2 -- to discount payments made during the next 15 years (years 6 to 20). |
||||||||||||||
InterestRate3 |
Segment
rate 3 -- to discount payments made after the first 20 years (years 21 and
later). |
||||||||||||||
YearsCertain |
Number of years guaranteed payments. May
be an integer, or a factional amount (e.g. years & months). |
||||||||||||||
Frequency |
Number of payments per year:
|
||||||||||||||
COLA |
Periodic cost-of-living
adjustment applied to the benefit amount. |
Related Topics