Home > Valuations > Valuation Assumptions > Reference Tables

Reference Tables

ProVal contains reference tables for the following categories of rates or probabilities:

The Reference Tables command also provides access to custom regulatory text files that are created and stored outside ProVal and contain “historical” data that can be used in place of the standard compensation limit historical data (RegMaxComp.txt) or the standard U.S. social security wage base history (RegWageBase.txt). These custom regulatory files are available in all ProVal modes of operation.

Decrement tables must be specified for Valuation Assumptions and, if you are running a Core Projection, for Projection Assumptions. The other table categories are optional.

Decrement tables, salary merit scales, election probability tables, fraction married tables and age difference tables are entered into ProVal spreadsheets whose interface permits values to vary by age, service, age and service (i.e., the table is select and ultimate), and sex. In pension modes other than German and U.K., retirement rate tables may also vary by replacement ratio. COLA rates are entered in the same manner, except the “service” dimension is labeled “duration”. Fraction married tables and age difference tables permit values to vary by age and sex. 

Increase rates are entered into a three column spreadsheet that varies by calendar year.

Yield curves are entered into a three column spreadsheet that varies by forecast valuation date.

Except for increase rate tables, yield curves and custom regulatory tables, see Table Interface for details about constructing and entering values. For such details about increase rate tables, see the discussion under the Increase Rate Tables command. Likewise, for details about constructing a yield curve library entry, see the discussion under the Forecast Yield Curves command.