/

PFDecrementTable

[this page | pdf | back links]

Interactively run this function

Answer  

Decrement Table
From statusTo statusfraction with this from / to status x benefit carried over
000.8730.8550.8280.7650.630
010.01465384615384620.02416666666666670.03822222222222220.07050.138750
02000000
10000000
110.990.970.950.90.850
12000000
20000000
21000000
22111111

Parameter NameInputAn input expression?Delimiter
NumberStatusEntries
DecrementGeometric
MinAge
MaxAge
DecrementStatusCode
DecrementAge
DecrementRate
DecrementFraction
DecrementBecomesCode

Calculation description
Time-stamp calculation?  
  


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


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


Desktop view | Switch to Mobile