PPF Overrides: Mortality
Male First Life Mortality Rates
Female First Life Mortality Rates
Female Contingent Life Mortality Rates
Male Contingent Life Mortality Rates
Double click to select one of the previously defined Rate Tables
containing the mortality assumption. The Rate Table will be a D Type
table (for non select rates) or a DS Type table (select rates).
Related
Decr Help
Rate tables can be selected by any of the following methods:
- Right-click on the field for a list of appropriate Rate Tables. For a field that will accept more than one type of Rate Table (e.g. Miscellaneous Tables), the list will be restricted to the current Table Type specified in the field – if you wish to see all allowable Rate Tables, delete the Table Type from the field before clicking; or
- Double Clicking on the field will produce the Rate Tables form where Rate Tables can be viewed (numerically and graphically) and Rate Tables can be added or edited. A Rate Table can be selected by pressing the Select button or double clicking on the Rate Table description in the tree; or
- the list of allowable Rate Tables can be scrolled through by
pressing the
<or>keys. The description of the Rate Table to the right of the field will change as each new Table is selected.
Age Rating
Any Rate Table can be rated up or down by a number of years as required
to make the rate at every age lighter or heavier than in the
original table.
A value of +10 will result, for example, in the value selected for a
30 year old actually being the rate for a 40 year old and for a value of
-5 would mean that the value at age 25 is selected.
If an age rating of a fraction of a year is required, a new table will have to be created through the Edit rate table option on the Rate Table form.
% Rating
A percentage adjustment can be made to either a Rate Table or a Salary.
The Rate Tables can be adjusted by a percentage loading to make the decrement rate lighter or heavier than the original table. The salary for new entrants can be loaded to reflect changes in the salary profile.
Enter the number as percentage above 100% i.e. if a loading of 110% is
required then enter 10 or if a loading of 90% then enter -10. If no
adjustment is required then leave blank.
Base Year of Male First Life Mortality Table
Base Year of Female First Life Mortality Table
Base Year of Female Contingent Life Mortality Table
Base Year of Male Contingent Life Mortality Table
Specify the Origin Year of the Mortality Table. If left blank the year of the Mortality Improvement Table will be used. If completed the Mortality Improvement Table will be rebased. i.e. improvement will start from 1 at the specified base year. Improvement for age x in year y becomes: original improvement for age x in year y /original improvement for age x in base year.
Male First Life Two-Dimensional Improvement Table (CSV File)
Female First Life Two-Dimensional Improvement Table (CSV File)
Female Contingent Life Two-Dimensional Improvement Table (CSV File)
Male Contingent Life Two-Dimensional Improvement Table (CSV File)
If 2D Tables has been selected or you are entering the PPF Overrides,
the select from the drop-down list which of the available tables to use.
The user will be able to select from the CSV files stored in the Library
Folder containing the mortality improvement rates.
Version 9 is supplied with a sample 2D file called MortImpNew.csv.
The CSV file should contain 120 rows and 120 columns. Ages are held in the rows and Years in the Columns. The table should start at age 0 and the Year that your Table starts. If no year is entered SuperVal will assume this starts at Year 2000.
Base Year of Male First Life Mortality Improvement Table
Base Year of Female First Life Mortality Improvement Table
Base Year of Female Contingent Life Mortality Improvement Table
Base Year of Male Contingent Life Mortality Improvement Table
When using the Specified Year of Birth, Accurate Member Specific or
2D Tables projection methods, enter the Base Year of the Mortality
Improvement Table.
For more information please see the Infocus Document relating to Mortality Set Up.
Male First Life Two-Dimensional Improvement Table (Rate Table)
Users can upload mortality improvement tables into the SVDECR.SF file.
The table should contain 120 rows and 120 columns. Ages are held in the rows and Years in the Columns. The table should start at age 0 and the Year that your Table starts.
Related
Female First Life Two-Dimensional Improvement Table (Rate Table)
Users can upload mortality improvement tables into the SVDECR.SF file.
The table should contain 120 rows and 120 columns. Ages are held in the rows and Years in the Columns. The table should start at age 0 and the Year that your Table starts.
Related
Same as Post-Retirement First Life Mortality
Tick checkbox if Member Pre-Retirement Mortality is the same as Post Retirement Member mortality
Male First Life Two-Dimensional Improvement Table (Rate Table)
Users can upload mortality improvement tables into the SVDECR.SF file.
The table should contain 120 rows and 120 columns. Ages are held in the rows and Years in the Columns. The table should start at age 0 and the Year that your Table starts.
Related
Female First Life Two-Dimensional Improvement Table (Rate Table)
Users can upload mortality improvement tables into the SVDECR.SF file.
The table should contain 120 rows and 120 columns. Ages are held in the rows and Years in the Columns. The table should start at age 0 and the Year that your Table starts.
Related
Female Contingent Life Two-Dimensional Improvement Table (Rate Table)
Users can upload spouse’s mortality improvement tables into the SVDECR.SF file.
The table should contain 120 rows and 120 columns. Ages are held in the rows and Years in the columns. The table should start at age 0 and the Year that your Table starts.
Related
Male Contingent Life Two-Dimensional Improvement Table (Rate Table)
Users can upload spouse's mortality improvement tables into the SVDECR.SF file.
The table should contain 120 rows and 120 columns. Ages are held in the rows and Years in the columns. The table should start at age 0 and the Year that your Table starts.
Related
SaveAs
Click the Save As button to save with a new file name.
Save
Clicking on the Save button allows you to save the entries.
Quit
Clicking on the Quit button allows you to exit without saving any of your changes.
In some of the screens you will be asked to confirm if you want to exit Ignoring all changes. If you click Yes, the file will be closed without saving any changes. If you click No you will be returned to your original screen.
From the Browser, the Quit button will take you to a graphical display of the results.