PFDecrementTable
[this page | pdf | back links]
Function Description
Returns an array that contains a decrement table in a
defined format relevant to (pension fund) projection purposes.
The pension fund members for this purpose are assumed to be
subdivided between various different statuses (e.g. ‘active’, ‘deferred,
‘pensioner’, ‘beneficiary’, ‘left/dead’ etc.) and also subdivided by age. The
aim of the decrement table is to characterise the proportion of scheme members
(or to be more precise the proportion of a given type of benefit attributable
to these scheme members) moving between different categories as a function of
age at outset and time from now to date at which their membership status is to
be projected. See PFDecrementTableHelp
for further details.
NAVIGATION LINKS
Contents | Prev | Next
Output type / Parameter details
Output type: Double()
| Parameter Name | Variable Type | Description |
| NumberStatusEntries | Integer | Number of status types (are coded 0, 1, ...) |
| DecrementGeometric | Boolean | If true then decrements combined geometrically otherwise arithmetically |
| MinAge | Integer | Minimum Age (in years) |
| MaxAge | Integer | Maximum Age (in years) |
| DecrementStatusCode | Integer() | Input Array 1 - status codes at start of year |
| DecrementAge | Integer() | Input Array 2 - age at start of year |
| DecrementRate | Double() | Input Array 3 - rate at which status as in 1 moves to new status over year |
| DecrementFraction | Double() | Input Array 4 - benefit fraction retained on moving status |
| DecrementBecomesCode | Integer() | Input Array 5 - status code at end of year |
Links to:
-
Interactively run function
-
Interactive instructions
-
Example calculation
-
Output type / Parameter details
-
Illustrative spreadsheet
-
Other Cash-Flow Projection functions
-
Computation units used
Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement