Quick Scenario: RollForward

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.

Roll-Forward Date

Specify the Roll-Forward Date (up to 4.5 years from valuation date)

Asset Value at Roll Forward Date

Specify the Net Asset Value at the Roll Forward Date.

Roll Valuation Date Assets Forward

Indicate whether Valuation Date Assets are to be input at the roll forward date (unticked) or are to be rolled forward from the Valuation Date up to the Roll Forward Date (ticked).

Asset Rollup Rate

If rolling forward the Assets from the Valuation date up to the Roll Forward date, then specify / select the Rollup Rate(s) (% p.a.) over the Roll Forward period.

Benefit Cash Flows to Roll Forward Date

This displays the Benefit Net Cash Flows during the period to the Roll Forward Date.

Contribution Cash Flows to Roll Forward Date

This displays the Contribution Net Cash Flows during the period to the Roll Forward Date.

Other Liabilities at Roll Forward Date

Specify the Value of Other liabilities at the Roll Forward Date.

Roll Valuation Date Other Liabilities Forward

Indicate whether Other Liabilities are to be input at the roll forward date (unticked) or are to be rolled forward from the Valuation Date up to the Roll Forward Date (ticked).

Other Liabilities Rollup Rate

If rolling forward the Other Liabilities from the Valuation date up to the Roll Forward date, then specify / select the Rollup Rate(s) (% p.a.) over the Roll Forward Period. The rolled forward amount will show as Additional Liability in the liability bar chart.

Net Cash Flow over Roll Forward Period

If rolling forward the Other Liabilities from the Valuation date up to the Roll Forward date, then the Net Cash Flow in respect of Other Liabilities over the Roll Forward Period can be specified here.

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.

Configure Roll-Forward

Configure Financial Assumptions for Roll-Forward Valuations i.e. whether discount rates / escalation rates and adjustments to these apply from Valuation Date or Roll-Forward Date.

Create Financials

A new set of Financial assumptions can be created for the changes that have been input in the Financial tab.

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.

Configure Graphs

Choose type of bar chart for cash flows.

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.