Home > Tools > Administration Factors

Administration Factors

The Administration Factors tool generates annuity, lump sum and insurance present value factors, factors for converting from one payment form to another (conversion factors) and commutation functions. Factors are developed for the ages that you request and the payment forms that you specify. Payment forms are defined in a manner similar to that of defining pension mode payment forms for inactive plan members (under the Inactive Data topic of the Census Specifications) and defining a Payment Form Definition for active plan members, with some differences, discussed below in the Payment Forms section of this article. Present values, for annuity factors, and the ratio of present values, for conversion factors, are as of a “current age” that typically would be the member’s age on his or her termination date (and is presumed to be so in the rest of this article). This date is analogous to the valuation date for an inactive payment form or to the decrement date for ProVal’s active Payment Form Definition.

Name may be any descriptive phrase, including spaces, under which to save this entry in the Administration Factors library.

Select the calculations to perform by checking one or more of the boxes for:

Select a topic to edit contains entries for each category of information (topic) found under the Administration Factors command. The available topics differ according to which of the three factor types you have selected. Click the name of a topic to access its parameters, which are described in separate sections (below) of this article. The topics are:

Current Ages

Interest Rates

Mortality and Timing Parameters

Payment Forms – not applicable if the Commutation Functions box has been checked

Commutation Functions – if the Commutation Functions box has been checked

In the following discussion of these topics, a reference to factors also applies to commutation functions, unless noted otherwise.

After entering all relevant parameter values, click the Run button to execute the selected calculations. ProVal will check for completion of all specified parameters and then, if no errors are found, calculate the factors and or functions. When the calculation is complete, ProVal displays, in the output, the parameter settings and the results for the factors or functions requested.

 

Current Ages

Under the Current Ages topic, you set the ages for which to generate annuity (present value) factors and/or conversion factors. Either you indicate the Age ranges, or combination of age ranges for the plan member and the member’s spouse or beneficiary if any factors involve joint life annuities, or you provide Specific ages / age combinations for the plan member, and for the spouse or beneficiary if joint life annuities are involved.

If you select Age ranges, ProVal will generate factors for a range of ages entered for the Primary Annuitant (the plan member), and reflecting, for each Primary Annuitant age, a range of ages entered for the Contingent Annuitant (the member’s spouse or beneficiary, presumed to be of opposite sex) if joint life factors are to be generated. For each annuitant, in the box to the right of From, enter the first age for which you wish to generate a factor and, in the box to the right of To, enter the last age for which you wish to generate a factor. You may enter only whole numbers (for example, 55, not 55.5).

Alternatively, if factors are to be generated for joint life annuities, you may define the Contingent Annuitant age range by selecting the Age differences up to option and entering, in the text field, the largest age difference between the primary and contingent annuitants (member and spouse / beneficiary), n, to consider. ProVal will generate factors for 2n+1 sets of age differences (-n…, -1, 0, 1…, n). Note that you specify the fixed range as a positive number; ProVal will generate factors for a contingent annuitant up to n years older and up to n years younger than the primary annuitant.

Check the Include monthly ages box to indicate that you want ProVal to calculate factors for (besides integral ages) all "fractional ages" of the primary and contingent annuitants, that is, ages in years and months in-between the integral ages. For example, if the Primary Annuitant (member) age range is 55 to 70 and the Contingent Annuitant (spouse, or beneficiary of opposite sex) age range is 50 to 75, ProVal will generate factors at age 55, at age 55 and 1 month, at age 55 and 2 months, etc., for the primary annuitant, up to and including age 70. For each of these primary annuitant ages, ProVal will also generate factors at contingent annuitant ages 50, 50 and 1 month, etc., up to and including age 75.  The factors generated at months in-between the integral ages are linearly interpolated between the factors at integer ages.  For a joint and survivor annuity, interpolation is performed first on the member age and then on the spouse age. 

If you select Specific ages / age combinations, ProVal will generate factors for (only) the ages you enter in the grid, in years and months, for the Primary Annuitant, and reflecting the ages you enter (also in years and months) for the Contingent Annuitant if joint life factors are to be generated. For example, to generate life annuity factors for a Primary Annuitant who is age 55.5, enter 55 in the years column and 6 in the months column. To also generate joint life annuity factors for a married primary annuitant of the same age with a spouse age 52.25, enter in the Contingent Annuitant columns 52 for the years and 3 for the months.  The factors generated at months in-between the integral ages are linearly interpolated between the factors at integer ages.  For a joint and survivor annuity, interpolation is performed first on the member age and then on the spouse age. 

You may use the Populate button to generate ages from a database file.  This option can be used to add ages or replace any existing ages already in the grid.  You must select a Database file.  Enter a Selection Expression to view specific records.  As an alternative, click the backdoor button to load a saved selection expression.  ProVal has a default Limit to 5 records for the view, but you may select up to 20 records at a time.  You will need to select a Date of birth (or attained age) field for the Primary annuitant and if applicable, the Contingent annuitant.  You may select a numeric field or a date field for either.  If you select a date field, you will need to enter a Calculation date so ProVal can determine the age of the annuitant.  Lastly, select the Age rounding rule.  You may select nearest year, completed months, nearest months, or started months.  The results and data preview displays the selected database records and the calculated annuitant ages that will be saved in the grid when you click the OK button.  Clicking OK will save the current selections made on the populate screen.

Interest Rates

The Interest Rates topic provides the following options for defining the interest assumption to be used in your calculations:

Enter all interest rates as numbers between 0 and 0.40 (not as percentages).

 

Mortality and Timing Parameters

Under the Mortality and Timing Parameters topic, you define the mortality assumption to be used in your calculations, as well as the timing of annuity payments within each payment year. Thus the dialog box is divided into two sections, Mortality and Timing Parameters.

In the Mortality section, unless all payment forms defined under the Payment Forms topic are payable only for a certain period (that is, life contingencies do not apply), you must select the mortality rate reference table (from among those unhidden in the current Project) that you wish to use for the Primary Annuitant (the plan member), and if joint life factors are to be generated you must select a mortality table for the Contingent Annuitant (the member’s spouse or beneficiary, presumed to be of opposite sex). For either the primary or the contingent table selection, the button provides access to the Mortality Rate Table Library, in which you may create new tables or modify existing ones. If an “Age by Duration from Decrement” table is selected, duration is measured from the member age (entered under the Current Ages topic) at which the factor is being calculated. You may not use a service-based mortality table, because a service dimension does not apply to inactive plan members and the factors being developed are presumed to be for inactive members (computed “as of” the termination date).

The Valuation year text field is accessible only for dynamic, fully generational and age by year of birth mortality tables. Enter the calendar year, for example, 2013, you wish ProVal to assume is the year that corresponds to the attained ages specified under the Current Ages topic.

For fully generational mortality tables, choose whether to Generate factors for an individual age x in valuation year, and if selected, specify the desired age. If this option is selected, all factors generated will be for the same individual. If this option is not selected, the factor for each age entered under the Current Ages topic will be for different individuals attaining each age in the applicable valuation year. For example, if the valuation year is 2015 and factors are generated for an individual age 60 in valuation year, then an age 60 factor will be for someone who is attained age 60 in 2015 and an age 61 factor will be for someone whose attained age is 61 in 2016. If this option is unchecked, then an age 60 factor will still be for someone who turns 60 in 2015, but an age 61 factor will be for someone who turns 61 in 2015. 

For an age by year of birth mortality table, choose whether to Generate factors for year of birth. Similar to the example above for projected mortality improvements, if this option is selected, all factors generated will be for the same individual.  If the option is not selected, the factor for each attained age specified under the Current Ages topic will be for an individual attaining that age in the valuation year. For example, if the valuation year is 2015, an age 65 factor would be for someone born in 1950, an age 64 factor would be for someone born in 1951, and so forth.

See Decrement Tables, in particular, the Mortality Projection and Dynamic Mortality sections, for more information about these tables.

Check the Use zero mortality in the deferral period (if any) box to assume zero mortality rates, for all payment forms, during the payment form’s entire deferral period (if any) for both the primary and contingent annuitants.

In the Timing Parameters section, your selection for the Payment Frequency parameter indicates, for all payment forms, how often payments are made within each payment year. ProVal assumes that benefit payments will be made in equal installments throughout the year and will adjust the present value of each payment form to account for multiple payments during the year. The available frequencies are “Annual”, “Semi-annual”, “Quarterly”, “Monthly” and “Continuous”. For details about the adjustment methodology, see the Technical Reference article entitled “Present Values: Benefits payable (m)thly”.

Your selection for the Annuity Payment Timing parameter indicates, for all annuity payment forms and all payment years, whether each payment is made at the beginning of each period or at the end of each period – for example, for 12 (monthly) payments each year, whether payments are made at the beginning or end of each month. Select “Beginning of Period” for an annuity-due or “End of Period” for an annuity-immediate. ProVal will adjust the present value of each annuity payment form to account for the indicated timing. The length of each period (a year, half year, quarter, month, or a fraction of an instant for the continuous frequency) is determined by the setting of the Payment Frequency parameter. Note: the Annuity Payment Timing parameter does not affect a life insurance benefit, which is always assumed to be payable at the end of the period. Again, for details about the adjustment methodology, see the Technical Reference article entitled “Present Values: Benefits payable (m)thly”.

 

Payment Forms

Under the Payment Forms topic, you define the annuity, lump sum and insurance payment forms whose present values you wish to calculate and you indicate, for conversion factors, which payment form to convert from. There are also parameters to blend male and female factor values and/or to blend life with joint life factor values.

Select a payment form to modify contains entries for each payment form you have already defined, if any. To add a new payment form, click the Add button and complete the parameters in the Payment Form Definition dialog box. To change the order of payment forms in the list, click the Reorder button.

For details about completing the parameters to define an Administration Factors payment form, see the discussions of payment forms for inactive members and Payment Form Definitions (for active members). However, there are some differences – in available parameters, their options and their treatment – between payment forms defined within this tool and either active Payment Form Definitions or payment forms defined for Inactive Benefits:

Check the Only paid if box to indicate that a spouse or beneficiary exists and payment of the face amount depends on who dies first, or last, the member or the spouse/beneficiary.  From the first drop-down list, select "Member" if the insurance is on the member's life (i.e., the member is the insured) and select "Beneficiary" if the insurance is on the beneficiary's, or spouse's, life.  The selection from the second drop-down list indicates whether the insured life dies "first" or "last". 

A constant, level, face amount of insurance is assumed.  To indicate, instead, a face amount that decreases each year, check the Decreases annually box and complete the parameters that become accessible.  Enter the Initial face amount in effect when coverage commences, the amount of Annual decrease in the face amount for each year of coverage, and the Minimum face amount of coverage.  Once the face amount reaches the minimum, it stays at this value for all future coverage years. 

For decreasing life insurance, the Factor applies to selection indicates what the annuity factor (per $1 of insurance coverage) produced by this tool should be multiplied by to obtain the present value of the payment form:  either the Initial face amount of insurance or, for a modified cash refund annuity, the Annual decrease in the "insurance" amount that will be paid when the annuitant dies:  

For a joint and survivor annuity with a pop-up feature, see also the FAQ article entitled "Pop-up conversion factors". 

If the Conversion Factors box has been checked, the Normal Form of Payment parameter is accessible, for you to select the payment form you wish to convert from. Once you have defined at least one payment form, you may select from the drop down list of payment forms unhidden in the current Project. As previously alluded to in this article, only payment forms that are an annuity or insurance Type will appear in the list. Neither will a joint life payment form Type appear in the list, because ProVal does not support conversion from a joint life annuity to another payment form, although you can generate factors to convert to a joint life payment form. ProVal will produce factors to convert from the selected normal form to each other payment form listed in this (Payment Forms) dialog box.

The Blending weights parameters allow you to blend male factor values with female factor values and/or to blend life factor values with joint life factor values. If conversion factors are to be produced (in addition to annuity factors), ProVal first blends the annuity factors for the normal form of payment and the payment form you are converting to, and then produces the (blended) conversion factor by taking the ratio of the blended annuity factors.

Check the Blend male and female annuity factors box to have ProVal weight the male and female annuity factors and blend them into a single factor. (Note that this parameter has no effect on results unless at least one of the mortality tables, or an underlying mortality improvement scale, selected under the Mortality and Timing Parameters topic is sex-distinct.) Enter the desired weight (a number between 0 and 1, inclusive) for a Male annuitant; ProVal will then enter the complement of this number for a Female annuitant. For example, if your payment form is a life annuity and you enter 0.5, for ProVal to weight male and female factor values equally, ProVal will compute separate male and female (primary) annuitant life annuity present values and then compute a blended value that is halfway between the male and female annuity present values. If your payment form is a joint life annuity and you enter 0.5, ProVal will compute separate factor values for 1) a male primary annuitant with a female contingent annuitant, and 2) a female primary annuitant with a male contingent annuitant, and then 3) compute a blended value that is halfway between the male and female primary annuitant joint life annuity values. Note that this parameter cannot be used to blend male and female mortality rates and then use the blended mortality rates to compute a single, blended, annuity present value factor; to achieve this result, you should first produce a unisex mortality table, select it under the Mortality and Timing Parameters topic and, consequently, not check the Blend male and female annuity factors box. (You can create a unisex mortality table from a sex-distinct table by use of the Table Type command behind the Options button available when you edit a Mortality Rate Table library entry; see Table Interface for details about constructing mortality rate tables.)

The Fraction of population receiving J&S (blends J&S factor with life annuity factor; applies only to the J&S forms) box applies only to joint life factors. Check it to have ProVal return joint life factor values computed by weighting each joint life annuity value towards the single life annuity value for the same primary annuitant current age. Presumably, you might not wish to use the “pure” joint life value if you are developing factors to compare to valuation results for a population that is not all married or that does not all elect a joint and survivor payment form. Enter the desired fraction (a number between 0 and 1, inclusive) that you wish ProVal to use to develop factors for a primary annuitant (plan member) who is Male; likewise, enter the desired fraction for ProVal to use for a Female primary annuitant / plan member. (Note: If a fraction of 1 is entered, that would denote a plan member population all of whom are married and/or electing the joint and survivor payment form, with thus no weighting towards the single life annuity value. However, in this situation, you need not check the Fraction of population receiving J&S box for ProVal to produce a “pure” joint life annuity value.) For example, if you enter 0.8 for a Male primary annuitant and 0.6 for a Female primary annuitant, for ProVal to weight joint life factor values by 0.8 for male plan members and by 0.6 for female members (and thus weight life annuity values by 0.2 for male members and by 0.4 for female members), ProVal will compute separate life annuity and joint and survivor annuity present values and then compute the weighted value. For male members, that value will be two tenths of the way from the male primary annuitant joint life value to the male annuitant life annuity value; for female members, that value will be four tenths of the way from the female primary annuitant joint life value to the female annuitant life annuity value.

If you check both the Blend male and female annuity factors box and the Fraction of population receiving J&S box, to blend male and female annuity factors and also to compute each joint life factor value as partly weighted towards a life annuity, ProVal will first weight each joint and survivor annuity factor value towards the life annuity factor value and then blend the male and female joint life factor values into a single (unisex) value.

 

Commutation Functions

Under the Commutation Functions topic, you may define commutation functions for ProVal to generate. You can select functions for (one or more of) the Primary Annuitant (the member, aged x), the Contingent Annuitant (the spouse or beneficiary, aged y) and, during the joint lifetime of the member and spouse / beneficiary, Joint Life (ages are x and y, respectively, denoted in the Joint Life column as xy).

The following commutation functions are available:

D, where D is the common denominator of commutation functions;

N, where N is an annuity factor numerator under which one payment is made per payment year;

N(m), where N(m) is the annuity factor numerator and m is the Payment Frequency entered under the Mortality and Timing Parameters topic, for example, if m=12, then N(m) represents a monthly annuity factor numerator;

S, where S is an increasing annuity numerator;

C, where C is an insurance utility numerator;

M, where M is the sum of Cx's;

R, where R is the increasing insurance numerator, the sum of Mx's;

e, where e is the curtate life expectancy.