PVJLPPA calculates the present value of a joint life annuity based on so-called PPA assumptions
for interest (3 segment rates) and mortality (annuitant, non-annuitant,
combined, applicable).
Syntax
PVJLPPA (AnnuityCode, Percentage,
CurrentAgeX, CurrentAgeY, CommencementAge, InterestRate1, InterestRate2, InterestRate3, CalcYear, MortTableType, SexX,
SexY, [YearsCertain], [Frequency], [COLA],
[CalculationMethod], [NoPreRetMort], [StopAge], [AnnTiming], [YrsCertOption])
Parameter Name |
Description |
|||||||||||||||||||||||||||||||||||||||||||||
AnnuityCode |
Type of joint life annuity to evaluate:
For a pop-up annuity, 𝐵 is calculated as follows: |
|||||||||||||||||||||||||||||||||||||||||||||
Percentage |
The joint
percentage payable to the survivor according to the AnnuityCode. May be
either a percent or a number, e.g. 50% or .5. Note: A value
that is 10 or greater (i.e. 1000%) will be divided by 100, e.g. if you enter
10 it will be treated as 10%; if you enter 50 it will be treated as 50%. |
|||||||||||||||||||||||||||||||||||||||||||||
CurrentAgeX |
Current age of the primary annuitant 𝑥 (i.e. the age at the valuation date).
May be provided as an integer, or as a fractional amount (e.g. years &
months). |
|||||||||||||||||||||||||||||||||||||||||||||
CurrentAgeY |
Current age of the secondary annuitant 𝑦
(i.e. the age at the valuation date). May be provided as an integer, or as a
fractional amount (e.g. years & months). |
|||||||||||||||||||||||||||||||||||||||||||||
CommencementAge |
Age of primary annuitant 𝑥 at benefit commencement. ·
If CommencementAge >
CurrentAgeX then it will be valued as a deferred annuity. ·
If CommencementAge
is missing or zero, then CommencementAge is assumed to be = CurrentAgeX
and it will be valued as an immediate annuity |
|||||||||||||||||||||||||||||||||||||||||||||
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). |
|||||||||||||||||||||||||||||||||||||||||||||
MortTableType |
The type of static mortality table to use:
|
|||||||||||||||||||||||||||||||||||||||||||||
SexX |
Primary
annuitant sex: “m”
or “f”; not used if type of table is “Applicable Table” because this is a
unisex table. |
|||||||||||||||||||||||||||||||||||||||||||||
SexY |
Joint
annuitant sex: “m”
or “f”; not used if type of table is “Applicable Table” because this is a
unisex table. |
|||||||||||||||||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||||||||||||||||
CalculationMethod |
Method of calculation
|
|||||||||||||||||||||||||||||||||||||||||||||
NoPreRetMort |
The defines the application of
pre-retirement mortality for a deferred annuity.
|
|||||||||||||||||||||||||||||||||||||||||||||
StopAge |
Age when the annuity benefit
stops -- no payment at this age. |
|||||||||||||||||||||||||||||||||||||||||||||
AnnTiming |
Defines when the payments are
made in the period.
|
|||||||||||||||||||||||||||||||||||||||||||||
YrsCertOption |
This is to select the method of
calculation for the certain portion of the annuity when using CalculationMethod
=0. It does not apply for other methods. This is used only if YearsCertain
not a whole number.
|
Related Topics