The Nematrian Function Library
Cash-Flow Projection Functions
[this page | pdf | back links | custom searches]
The Nematrian function library includes a range of tools that
are useful for carrying out cash-flow projection calculations.
The web functions available include ones set out in the
table below. To see a complete list of functions currently available in the
Nematrian online toolkit please go to list of types of available
functions or complete
list of individual functions.
Please note that no web functions currently publicly
available through the Nematrian website are classified by Nematrian as being
explicitly ‘actuarial’ in nature. For example, they do not necessarily adhere
to relevant model standards imposed on actuarial work by the UK’s Board for
Actuarial Standards. If you are seeking access to models that do explicitly
adhere to these standards then please speak to your usual contact at Nematrian.
Usage of the Nematrian website is subject to the terms of the Nematrian License Agreement.
Contents | Prev | Next
|Web function||Short description of function
|MnApplyPriorityWaterfall||Returns an array corresponding to fractions of tranches satisfied in a priority ladder or 'waterfall'
|MnApplyPriorityWaterfall2||Returns an array corresponding to fractions of tranches owned by different investor categories satisfied in a priority ladder or 'waterfall'
|MnPFDecrementTable||Returns a decrement table in a format that can be used for further pension fund projection work
|MnPFProjectBenefitsDepletedOutgoWoundUp||Returns the outgo through time expected from each aggregate membership category conditional on scheme winding up at different points in time (sponsor not necessarily making good any shortfall)
|MnPFProjectBenefitsOutgoWoundUp||Returns the outgo through time expected from each aggregate membership category conditional on scheme winding up at different points in time (assuming sponsor makes good any shortfall)
|MnPFProjectBenefitsProbDefault||Returns probability of sponsor (possibly adjusted to reflect economic or scheme-specific drivers)
|MnPFProjectBenefitsPVSingleRun||Returns the current value of members' future benefits allowing for the possibility that the scheme sponsor may not make good shortfalls on wind-up