With just one click you can paste an entire table into a worksheet at the active cell. If the target range is not empty, the paste will not occur to prevent wiping out any cells that already exist in the active worksheet.
Actuarial Equivalence
|
Actuarial equivalence (ERF) |
|
Actuarial equivalence (LRF) |
|
Actuarial equivalent factor to convert SL to CL |
|
Actuarial equivalent factor to convert SL to JL |
Interest Rates
|
Spot rates from FTSE Pension Discount Curve |
|
Spot rates from FTSE Above Median Double-A Curve |
|
Spot rates from IRS Yield Curve |
|
Rate Table -- IRS 417(e) Segment Rates |
|
Rate Table -- Treasury Rates and 417(e) |
Lump Sum PV Factors
|
Lump sum factor table -- monthly ages |
|
Lump sum factor table -- whole ages |
Other
|
Age at death for a given probability of survival |
|
IRS mortality table q's |
|
Life expectancy |
|
Mortality table q's |
|
Mortality table commutation functions |
|
Projection scale (1D) |
|
Turnover table |
Regulatory Amounts
|
401(k) Elective Deferral Limit Table |
|
403(b) Elective Deferral Limit Table |
|
457(b) Deferral Limit Table |
|
Catch Up Contribution Limit Table |
|
Compensation Limit Table |
|
Covered Compensation Table |
|
DC 415 Annual Additions Limit Table |
|
DB 415 Annual Benefits Limit Table |
|
HCE Threshold Definition Table |
|
SIMPLE Catch Up Contrib Limit Table |
|
SIMPLE Elective Deferral Limit Table |
|
Top Heavy Key Employee Comp Table |
|
NAE Table |
|
Social Security COLA Table |
|
Social Security Early or Delayed Factor Table |
|
Social Security Detail Table |
|
Social Security Max Table |
|
Wage Base Table |
|
Wage Base Table -- Old Law |
|
PBGC Premium Single Employer Table |
|
PBGC Premium Multi Employer Table |
|
PBGC Premium Table |
|
CPI-U Table (used to annually adjust IRS limits) |
|
CPI-W Table (used to annually adjust Soc Sec items) |
|
Inflation Table |