Quick Scenario

Membership Groups

Select from:

All
Active
Deferred
Pensioner
Active / Deferred
Deferred / Pensioner
Active / Pensioner

Contributions

Contributions checkbox appears as an option if employee contributions have been included
within the Actives basis. These will then be included within the cashflow graphs / output.

Expenses

Expenses checkbox appears as an option if expenses have been included when running the consolidation. These will then be included within the cashflow graphs / output.

Additional Liabilities

Additional Liabilities checkbox appears if additional liabilities have been included when running the consolidation. These will then be included within the cashflow graphs / output.

Cease Future Accrual after

User can input the future ceasing accrual period in this field. The default accrual period is 99 years i.e. gives the same results as the Attained Age Funding method.

Cashflows and liability amounts will decrease depending upon the number of years input here.

Capitalise Pensions

If Capitalise Pensions is ticked, benefits are capitalised at point of exit i.e. the cashflow becomes the present value of future cashflows as at the date of exit. Liabilities remain unchanged.

Expense/Profit Loading

If Capitalise Pensions box is ticked a loading can be input here to adjust the capitalised cashflow value, and hence the liabilities, allowing for a loading for expenses / profit .

Relative Change

New Values

% Change

% of Current Values

Variations can be:

Relative Change

An absolute addition or subtractive relative to the current financial assumptions

New Values

These overwrite the current financial assumptions

% Change

New financial assumption is: (1+% input) × current financial assumptions

% of Current Values

New final assumption is: % input × current financial assumptions

Rate 1 Description

Rate 2 Description

Rate 3 Description

Rate 4 Description

Rate 5 Description

Rate 6 Description

Rate 7 Description

Rate 8 Description

Rate 9 Description

Rate 10 Description

Adjustments:

Here adjustments can be made to the groups set up within the Scheme Financial Assumptions, subject to a minimum of -10 and a maximum of +10. Note the percentage is input here e.g. 1 rather than 0.01.

Adjustments can be:

A single number, which can be negative or positive
A vector of numbers, separated by a space or a comma (limit of 25 digits)
A yield curve (CSV file)

Post-Retirement Mortality Adjustment

If, under File > Properties > Valn Options the box Output Separate Cashflows for Spouse is ticked, then it is possible to adjust the post-retirement mortality.

If the per Annum box is unchecked then mortality will be adjusted overall by the percentage specified. A number or a vector can be input here.

per Annum

If the per Annum box is checked then the mortality adjustment will be applied to the mortality improvement i.e. by $(1 - mortality adjustment)^{t}$ at time $t$ .

Adjust Future Service Funding Rate

If Adjust Future Service Funding Rate boxed is ticked then the employer future service funding rate is adjusted to allow for the changes in assumptions. The impact of this can be seen in the graphs Employer Contributions and Employer Funding Rate.

Control Period

If Adjust Future Service Funding Rate boxed is ticked then the control period can be changed; the impact on the employer future service funding rate can then be seen in the graphs Employer Contributions and Employer Funding Rate.

Amortisation Constant

If amortisation is included within the consolidation file, the rate, term or amount can be kept constant.

The field chosen i.e. First Year Contribution, Term or Deficit / (Surplus) Amortised is greyed out and then changing one of the remaining two alters the other appropriately. For example: if the term is kept constant, the rate can then be adjusted and the deficit / surplus amortised calculated.

Contribution Rate

If amortisation is included within the consolidation file, the rate, term or amount can be kept constant.
The field chosen i.e. First Year Contribution, Term or Deficit / (Surplus) Amortised is greyed out and then changing one of the remaining two alters the other appropriately. For example: if the term is kept constant, the rate can then be adjusted and the deficit / surplus amortised calculated.

First Year Contribution £

If amortisation is included within the consolidation file, the rate, term or amount can be kept constant.

The field chosen i.e. First Year Contribution, Term or Deficit / (Surplus) Amortised is greyed out and then changing one of the remaining two alters the other appropriately. For example: if the term is kept constant, the rate can then be adjusted and the deficit / surplus amortised calculated.

Term

If amortisation is included within the consolidation file, the rate, term or amount can be kept constant.
The field chosen i.e. First Year Contribution, Term or Deficit / (Surplus) Amortised is greyed out and then changing one of the remaining two alters the other appropriately. For example: if the term is kept constant, the rate can then be adjusted and the deficit / surplus amortised calculated.

Deficit/(Surplus) Amortised £

If amortisation is included within the consolidation file, the rate, term or amount can be kept constant.
The field chosen i.e. First Year Contribution, Term or Deficit / (Surplus) Amortised is greyed out and then changing one of the remaining two alters the other appropriately. For example: if the term is kept constant, the rate can then be adjusted and the deficit / surplus amortised calculated.

Amortisation Method 1

Amortisation Method 2

If amortisation has been included within the consolidation there is a choice of four amortisation methods:

Percentage of All Members’ Salaries
Percentage of Current Members’ Salaries
Level Amounts
Fixed Amounts plus Accrued Interest

Consolidation Database File

Select the database file containing the results to run the Quick Scenario Modeller on i.e. the original results in the graphs / output.

Consolidation SQL Server Database

Select the consolidation SQL server database file to be used for QSM

Type of Graph

The default is liabilities. Choose to view one of the following 7 options:

Liabilities – these are split into membership groups (actives / deferreds / pensioners) and past and future service
Waterfall Liabilities
Financial Position
Waterfall Financial Position
Cash Flows
Employer Contributions
Employer Funding Rate

Term

The term displayed for the cashflows i.e.in the graphs Cash Flows, Employer Contributions and Employer Funding Rate can be adjusted here to display the results for the term required.

Dump Results

Selecting Dump Results in the bottom right of the screen will produce a TXT file.

This contains the:

adjustments to the financials/mortality
original / change in / revised liabilities, split by benefit type
revised cashflows, split into components (e.g. Ret Pen / Ret Cash / Death Pen / Death Cash)

Amortise Deficit

If amortisation is included when consolidating, then selecting Amortise Deficit will adjust the amortisation assumptions to amortise any surplus / deficit.

A new box will appear asking which amortisations are to be included:

Both Amortisations
Amortisation 1
Amortisation 2

and which of the two currently variable fields out of rate / term / amount (one has previously been chosen to be constant) is to change to amortise the surplus / deficit.

If Both Amortisations is chosen then a further box Shared will be displayed with a choice between sharing between the two amortisation methods equally or proportionally.

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.