About the AXIS Help System
AXIS 12 Users Guide
An Introduction to AXIS 12
About AXIS 12
Getting Started
Installing AXIS
Windows Basics
Basic AXIS Concepts
Modules in AXIS
What Are Datasets?
Objects and the View Menu
What is a Cell?
How AXIS uses Tables
What are Policy Year Results
What are Calendar Year Projections?
Modeling vs. Seriatim
How AXIS handles Reinsurance
Subfunds, Funds, and Offices
Global Scenarios
Reinvestment Strategies
Batch Objects and Batch Operations
Cell Override Sets
System and Dataset Parameters
Online Help
The AXIS 12 Interface
The Main Application Window
Using the Menu Bar
The File Menu
Setting System Parameters
Setting Dataset Parameters
Using the Standard Toolbar
The Object Explorer
Working With Cells
Working Interactively With Objects
How to Select Objects
Using the Actions Button
Using the Cell Assumption Screen
Organization of the Cell Assumption Screen
Navigating Around the Cell Assumption Screen
How to Customize the Cell Assumption Screen
Entering Data in the Cell Asssumption Screen
Ages in AXIS
Running a Cell
Viewing Standard Reports
Creating Custom Reports
Opening the CRE from the View Menu
Opening the CRE from Within a Report
The Report Editor Window
Using the Report Editor Action Buttons
Using the Formula Definition Window
Printing Reports
Running an Illustration
Working With Tables
How Tables are Organized in AXIS
Selecting and Viewing Tables
The Table Icons in the Assumption Screen
Basics of Table Editing
Table Editing Action Buttons
Tables with Expandable Columns
Table Buffer Options
Generating Tables
Editing Table Header
Other Objects in AXIS
What are Investment Accounts?
Assumption Screen Filters
What Are Custom Reports?
What are Object Sets?
What is a Remote Table?
Batch Operations
What are Batch Processes?
What are System Batch Processes?
Using the Batch Wizards
Import Export Options
Overview of Import and Export Options
What is the Import/Export Database?
Exporting Assumptions to the Import/Export Database
Exporting Projections to the Import/Export Database
Viewing and Comparing Projections
Export and Import of AXIS Table values
AXIS Script
About AXIS Script Language
Introduction to the Basic Elements of AXIS Script
Using the AXIS Script Editor
Using the AXIS Script Debugger
Reference Guide to AXIS Script Statements & Events
Reference Guide to AXIS Script Functions
Recommendations for Programming with AXIS Script
Seriatim Processing with DataLink
Introduction to AXIS DataLink
What is AXIS DataLink?
DataLink Flow Diagram
Data Requirements
Using DataLink for Asset Projects
Using DataLink for Insurance Projects
Basic Concepts and Terms in DataLink
Objects Used by DataLink
Working with DataLink Object Lists
Working with Formulas in DataLink
Sample Database Applications
Getting Started
Project Development Overview
Setting DataLink Dataset Parameters
Copying an Existing Database
Preparing Logical Source Files
Defining a Table
Basics of Table Definition
Table Definition Overview
The Table Object View
Editing the Table Definition
The Status Date
Adding New Fields
Adjusting Field Attributes
Defining Input Fields
Creating an Input Field
Scanning a Source File
Validating Source Data
Converting Source Data
Using a Formula Procedure During Loading
Testing the Field Definitions
Defining Calculated Fields
Creating Calculated Fields
Defining a Mapping Rules Table
Using a Formula Procedure During Mapping
Using the Formula Expression Edit Window
Testing the Field Definitions
Defining a Formula Procedure
What is a Formula Procedure?
Defining Formula Procedures
Syntax Rules for Formula Procedures
Internal System Variables
User Defined Variables
Using Comment Statements
Using Conditional Branching
DO CASE ... ENDCASE
IF ... ELSE ... ENDIF
FOR...ENDFOR / NEXT
Predefined DataLink Functions
Predefined DataLink File Functions
Using Global User Defined Formula Procedures
Batch Processing in DataLink
Formula Procedure Batches
Cross Table Formulas
Record Collection Batches
DataLink Batch Macros
Using the Cells Reference Table
Using the Cells Table in Liability Modules
Asset Cell Assumption Tables
Using Subfunds Reference Tables
Using the AXIS Table Values Table
Communicating with AXIS
Exporting Seriatim Files to AXIS
Using AXIS Seriatim Reports
Documentation
Viewing DataLink Objects
Archiving Your Data
Creating Queries
What is a Query?
Specifying Query Sources
Conditional Record Selection
Defining Query Output Fields
Working with Query Results
Advanced Topics
About User Defined Tables
About User Defined Tables
Using a User Defined Table to Hold Supplementary Policy Data
Using a User Defined Table to Hold Mapping Rule Source Data
Using a User Defined Table to Perform a Table Lookup
How to Export Selected Records to Cells
How to Generate Multiple Policy Info Records
How to Generate Unique Policy ID's
How to Load Selected Records from the Source File
Glossary of Terms
Earnings by Source
Overview of Earnings by Source in AXIS
Preparing to Use EBS
Choosing an EBS Reporting Period
Setting EBS Parameters
Capturing Actual Policy Movement Data
Capturing Actual Fund Movement Data
Creating Calendar Year EBS Reports
Experience Analysis
Advanced Applications in AXIS
How to Approach CALM in AXIS
How to Perform Cash Flow Testing in AXIS
Generating New York Regulation 126 Required Scenarios
Using AXIS in a Production Environment
Distributed Processing
Distributed Processing - Overview
Distributed Processing on a Multi-Processor Computer
Distributed Processing over Multiple Machines
Distributed Processing from the Command Line
Stochastic Processing in AXIS
What is Stochastic Processing?
Overview to Stochastic Processing in AXIS
Defining Scenarios for Stochastic Processing
The Block Object
Viewing Results from Block Processing
Embedded Scenario Processing
User Guide for EIA Hedging Functionality
Abstract
Product Design and General Settings
Fixed Guarantee Portion
Indexed Crediting Portion
Scenario Generator for HWLN model
Scenario Generator Parameter Specification
Example - Data Description
Correspondence between the Cell and the Scenarios
Consistency Test with Blank Summary Report
Appendix
Appendix A Model Consistency Proof
Appendix B Questions and Answers
Appendix C The EIA Formula Table Scripts
AXIS ScenarioTools Introduction
About ScenarioTools
Scenarios
Scenario Sets
Where Scenario Sets are Used
Scenario Generators
Scenario Generator (Old) in Batch
Valuation Scenario Formula Tables
Market Models
Scenario Analyzer (in Batch)
Results Analyzer (in Batch)
User Guide for VA Hedging Functionality
Abstract
1. Dataset Parameters
1.1 Feature codes
1.2 Period and dates
1.3 Scenario settings
2. Scenario Generation
2.1 Risk neutral scenario set
2.2 Real world scenario set
3. Asset Pricing Model
3.1 Risk neutral scenarios
3.2 Greeks
3.3 Managed fund
3.4 Liability projection
4. Cell Setup
4.1 Investment account
4.2 Hedged liabilities
4.3 Pricing at the Block Level
4.4 Scenario reserve
4.5 Results
5. Strategy Sets
5.1 Hedge strategy
5.2 Reinvestment strategy
6. Higher Level Processing
6.1 Fund assumptions
6.2 Embedded block
6.3 Results
7. Scenario Based Analysis
AXIS Reference Manual
AXIS Assumption Screens
Asset Pricing Model Assumption Screen
Risk neutral scenarios
Asset Pricing Model
Greeks
Asset Pricing Model
Managed fund
Managed fund mapping table
Asset Pricing Model
Liability projections
Block Assumption Screen
Processing
Block Type
Block Reporting Category Usage
Cells
Projection assumptions
Initial Reserves and Capital
Benefit reserves
N =
Minimum reserves
Required capital
M =
Minimum required capital
Target ratio for required capital
Inforce asset subfunds
Historical DAC Tax Balances
Projection Assumptions for Embedded Value Calculations
Projected benefit reserves
Projected required surplus
Interest Rate
Tax rate
Time zero strain adjustment
DAC calculation
K =
Unamortized DAC
Embedded Value
Hurdle rate
FAS 97 / SOP 03-1 Inforce Balances
Cohort information
Block Projection Assumptions Assumption Screen
Processing
Years of projections
N =
Values after Projection Period
Scenarios
Scenarios
Optional block calculated line set
Initial Reserves and Capital
Liability projection assumptions
Initial total asset requirement
Inforce asset adjustment
Working reserve
C3 Phase II standard scenario run
C3 Phase II standard scenario interest rate
AG43 (VA-CARVM) standard scenario run
AG43 (VA-CARVM) standard scenario interest rate
AG43 (VA-CARVM) aggregate calculation valuation interest rate
Fund shock
Discount rate
Reinvest strategy for general account
Reinvest strategy for liability categories
Match minimum for liability categories
Tax rate
DAC tax basis
DAC capitalization rate
Investment Earnings
Asset base for earned rate calculation
Earned rate calculation method
Earned rate validation
Lower rate bound
X =
Upper rate bound
Y =
Alternate rate
Earned rate capture
Convergence criteria
Maximum iterations
Tolerance
Capture rate type
Capture column
FAS 97 / SOP 03-1 Assumptions
Reserve calculation
Projection assumptions
Amortization rate
FAS 97 base scenario
Cell Assumption Screens
Regular Module Cell Assumption Screen
Processing
CALENDAR YEAR RESULTS
Cell Code
SCENARIO DEPENDENCY
PROJECTION METHOD
ISSUE MONTH METHOD
TIMING OF ISSUE
INFORCE ADJUSTMENT
VOLUMES Table
SERIATIM INFORCE
AGE DISTRIBUTION
POLICY YEAR RESULTS
Pricing Issue Year and Month
Risk class
Risk class life 1 and life 2
Product Features
Premiums
PREMIUM ADJUSTMENT Table
Guaranteed Premiums
Commission Table
Bonus & Chargeback Table
FACE AMOUNT Table
Cash Value Table
ROP Table
DIVIDEND Table
RPU VALUE Table
ETI term
PROPORTION OF POLICY FEE COMMISSIONABLE TABLE
Other Benefit
Valuation Size
Age Distribution Table
SALES
Age mix duration
AGE MIX BASIS
LIFE STATUS
N
1ST LIFE IS
2ND LIFE IS
Maturity Age
ROP on lapse formula
CSV Formula
X%
Mid Year CSV
CSV limitation
MATURITY VAL
MV
DISTRIBUTION OF SALES BY MODE
Modal premium factors
Policy fee with each premium
PROPORTION OF LAPSES AT YR END
Premium Rates
SINGLE PREMIUM PLAN
UNEARNED PREMIUMS
Y
UNEARNED COMMISSION
Z
EXPENSE BASIS
EXPENSE BASIS FOR PAIDUP
First Year Premium
Number of premium waived months
First year commission
Prop of 1st year commission advance
First year bonus per premium
Prop of 1st year bonus per premium advance
DIVIDEND PAID ON LAPSE
X
DIVIDEND PAID ON DEATH
X
Direct recapture charge
Initial term for reserves
Issue fee per policy
COMMISSION RATE ON ISSUE FEE
Purchase assumptions
Purchase date - month
Purchase date - year
Multiple Reinsurance
Multiple reinsurance
Reinsurance Terms
Net amount at risk
Input factors
Single Reinsurance
Single reinsurance
Premiums
PREMIUM ADJUSTMENT Table
Commission Table
Bonus & Chargeback Table
Locked in Commission Table
Locked in Bonus & Chargeback Table
Face amount table
Cash Value Table
DIVIDEND Table
Other Benefit Set Table
CEDED POLICY FEE TABLE
Interest on Premium
Recapture charge
Ceded Premium Tax Assumptions
Premium Tax Rate
PREMIUM TAX BASIS CEDED
PREMIUM TAX BASIS CEDED ADJ
PREMIUM TAX REFUND CEDED
UNEARNED CEDED PREMIUMS
Y
UNEARNED CEDED COMM
Z
REINSURANCE METHOD
Adj for unregistered
Proportion for unregistered
ROP benefit
W
ROP Basis
OTHER BEN REINS BASIS
Ceded premium for Jt life
N
Premium Payable
PROP. COMMISSIONABLE
General Assumptions
SPARE FIELD
KEYCODE
PREM VOLUME
RESRV DETAILS
Y =
RES FACTORS
CALCULATION OF MORTALITY PAD
MINIMUM Q REFERENCE TABLE
F factor (VTP 8)
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP FINANCIALS
US GAAP required fund
US GAAP Policy Year Results
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
Pricing Assumptions
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates
LAPSE RATE Table
Skew lapse table
RPU proportion Table
ETI assumptions
EXPENSE table
FIXED (OVERHEAD) EXPENSE table
Letter of Credit Expenses Table
Capital Charge Table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
START ACCUMULATING PROFIT MEASURES AT POLICY YEAR
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
HURDLE RATE
DISCOUNT RATE
DISCOUNT RATE BASIS
DISCOUNT INTEREST RATE TABLE
YIELD SPREAD table
YIELD PROPORTIONATE ADJUSTMENT table
EMBEDDED VALUE
EMBEDDED VAL ADJUSTMENT
PROFIT MARGIN
PROFIT EMERGENCE (PV)
PROFIT EMERGENCE (ROI)
ROI Definition
Time Zero Strain
Taxes
TAX METHOD
X
CORPORATE TAX RATES
DIFFERENTIAL EARNINGS
Tax exempt investment income proportion table
PREMIUM TAX RATE
PREMIUM TAX BASIS
Y
PREMIUM TAX BASIS ADJ
PREMIUM TAX REFUND
TAX LOSS TREATMENT
Y =
Z =
DAC tax method
T
DAC TAX CAPITALIZATION RATE
DAC TAX BASIS
DAC tax amortization period
CANADIAN IIT RATE
IIT Rate
Proportion of T5 Credit Disallowed
PROPORTION OF IIT DEDUCTIBLE
IIT Payment Frequency
Policyholder Tax
Mortality - Exempt Test Policy
Mortality for Joint Lives - Exempt Test Policy
Interest - Exempt Test Policy
X =
Exempt Test Duration - Exempt Test Policy
Accumulating Fund - Exempt Test Policy
ETP Line Treatment - Exempt Test Policy
Exempt Test and ACB Mortality Tables
CONTAGION FACTOR
T5 Calculation
Accumulating Fund - T5 Calculation
ACB Mortality - T5 Calculation
Tax Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates
LAPSE RATE Table
Skew lapse table
RPU proportion Table
ETI assumptions
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
Premiums for valuation
Guaranteed Premiums for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
Mortality PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS extra q tables
LAPSE AT
Adjustment table 1 option
Adjustment table 2 option
Tax reserve ceiling
Lapse rate PAD
Lapse margin (X =)
Maximum lapse rate
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
LOC Expense
Reserve revaluation
M =
N =
Revaluation method
Lapse PAD Treatment
Valuation scenarios
Valuation mortality adjustment
Direct premium adjustment
Guaranteed premium adjustment
Ceded premium adjustment
Valuation interest rate
N
I
Additional mortality PAD
Years
Statutory Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates
LAPSE RATE Table
Skew lapse table
RPU proportion Table
ETI assumptions
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
Premiums for valuation
Guaranteed Premiums for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
IIT Rate
Mortality PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS extra q tables
LAPSE AT
Adjustment table 1 option
Adjustment table 2 option
Statutory reserve floor
Lapse rate PAD
Lapse margin (X =)
Maximum lapse rate
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
LOC Expense
Cost of Capital Rate
Reserve revaluation
M =
N =
Revaluation method
Lapse PAD Treatment
Valuation scenarios
Valuation mortality adjustment
Direct premium adjustment
Guaranteed premium adjustment
Ceded premium adjustment
Valuation interest rate
N
I
Additional mortality PAD
Years
Second Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates
LAPSE RATE Table
Skew lapse table
RPU proportion Table
ETI assumptions
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
Premiums for valuation
Guaranteed Premiums for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
IIT Rate
Mortality PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS extra q tables
Lapse at
Adjustment table 1 option
Adjustment table 2 option
Lapse rate PAD
Lapse margin (X =)
Maximum lapse rate
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
LOC Expense
Cost of Capital Rate
Reserve revaluation
M =
N =
Revaluation method
Lapse PAD Treatment
Valuation scenarios
Valuation mortality adjustment
Direct premium adjustment
Guaranteed premium adjustment
Ceded premium adjustment
Valuation interest rate
N
I
Additional mortality PAD
Years
Third Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates
LAPSE RATE Table
Skew lapse table
RPU proportion Table
ETI assumptions
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
Premiums for valuation
Guaranteed Premiums for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
IIT Rate
Mortality PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS extra q tables
LAPSE AT
Adjustment table 1 option
Adjustment table 2 option
Lapse rate PAD
Lapse margin (X =)
Maximum lapse rate
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
LOC Expense
Cost of Capital Rate
Reserve revaluation
M =
N =
Revaluation method
Lapse PAD Treatment
Valuation scenarios
Valuation mortality adjustment
Direct premium adjustment
Guaranteed premium adjustment
Ceded premium adjustment
Valuation interest rate
N
I
Additional mortality PAD
Years
Fourth Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates
LAPSE RATE Table
Skew lapse table
RPU proportion Table
ETI assumptions
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
Premiums for valuation
Guaranteed Premiums for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
IIT Rate
Mortality PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS extra q tables
LAPSE AT
Adjustment table 1 option
Adjustment table 2 option
Lapse rate PAD
Lapse margin (X =)
Maximum lapse rate
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
LOC Expense
Cost of Capital Rate
Reserve revaluation
M =
N =
Revaluation method
Lapse PAD Treatment
Valuation scenarios
Valuation mortality adjustment
Direct premium adjustment
Guaranteed premium adjustment
Ceded premium adjustment
Valuation interest rate
N
I
Additional mortality PAD
Years
Fifth Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates
LAPSE RATE Table
Skew lapse table
RPU proportion Table
ETI assumptions
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
Premiums for valuation
Guaranteed Premiums for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
IIT Rate
Mortality PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS extra q tables
LAPSE AT
Adjustment table 1 option
Adjustment table 2 option
Lapse rate PAD
Lapse margin (X =)
Maximum lapse rate
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
LOC Expense
Cost of Capital Rate
Reserve revaluation
M =
N =
Revaluation method
Lapse PAD Treatment
Valuation scenarios
Valuation mortality adjustment
Direct premium adjustment
Guaranteed premium adjustment
Ceded premium adjustment
Valuation interest rate
N
I
Additional mortality PAD
Years
Required Surplus
PREMIUM DEFINITION
Claims Definition
GAAP reserve definition
Reduction of negative res and CSV def
Tax rate for Negative Reserves (for MCCSR available capital calculations)
Negative Reserve Reduction Table
MCCSR Mortality Components Table
Calculate mortality components for
Lapse Risk Component - Pre 2003 Method
A =
B =
N =
Lapse Risk Component - 2003 method
C =
Lapse Component Floor
Calculate lapse components for
REQUIRED SURPLUS METHOD
Target ratio
REQUIRED CAPITAL
Reserve used for required capital
Available Capital Deduction - Percentage of Deferred Tax Asset
Lapse risk component
Mortality component
Required Capital Factors (%) Table
C1 To C4 Required Capital Factors (%) Tables
Solvency Capital Requirements Table
Stat PFAD Analysis
STAT PFAD ANALYSIS
Reserve Recalculation Order
Other benefit MAD recalculation
Mortality MAD
X
Other benefit MAD
X
Interest MAD
X
Lapse MAD
X
Expense MAD
X
User Defined Scalars
USER DEFINED SCALARS - USAGE SWITCH
USER DEFINED SCALARS - VALUES
User Defined Tables
USER DEFINED TABLES
UL Module Cell Assumption Screen
Processing
CALENDAR YEAR RESULTS
Cell Code
SCENARIO DEPENDENCY
PROJECTION METHOD
ISSUE MONTH METHOD
TIMING OF ISSUE
INFORCE ADJUSTMENT
VOLUMES Table
SERIATIM INFORCE
AGE DISTRIBUTION
POLICY YEAR RESULTS
Pricing Issue Year and Month
Risk class
Risk class life 1 and life 2
General Account Liability Category
Block Reporting Category Formula Table
Product Features
Target Regular Premium Table
Target Regular Premium Adjustment Table
Minimum prem
Target Dumpin Premium Table
MAXIMUM PREMIUM Table
INFLATION Table
Premium Load Table
GUARANTEE PREM LOAD Table
EXP CHARGE Table
GUARANTEE EXPENSE CHARGE Table
CREDITED i Table
FUND BONUS Table
SURR CHARGE Table
SC PER PART WITHDRAWAL TABLE
MINIMUM SURR VALUE TABLE
SECOND FUND Table
FACE AMOUNT Table
FA Maximum Proportional Decrease
COMMISSION Table
BONUS & CHARGEBACK Table
RISK CHARGE Table
Guaranteed Risk Charge Table
NAAR Adjustment
EXTRA COMM Table
CRVM Guaranteed Minimum Credited Interest
Other Benefit
Age Distribution Table
SALES
Premium Distribution by
Premium Distribution (All yr)
ADDITIONAL POLICY FEE
PROP. OF POLICY FEE COMMISSIONABLE
Lapse Distribution During the Year (INIT/YR N+)
Age mix duration
AGE MIX BASIS
LIFE STATUS
1st LIFE IS
2ND LIFE IS
Maturity Age
MIN/MAX PREMIUM APPROACH
MINIMUM PREM TABLE switch
N
POLICY FEE TREATMENT
CREDITED INTEREST
Sum of Premiums in Face Amount
EXPENSE BASIS
FIRST YR COMMISSIONS
POLICY TERMINATES
NAAR METHOD
Minimum NAAR
X =
Y =
Risk Charge Adjustment
EXTRA COMM TABLE
UNEARNED COMMISSION
Z
Partial Withdrawal
FREQUENCY OF CHARGES
MATURITY VALUE
INFLATION SOURCE
SEG FUND OPTIONS
Accumulating fund for illustration
FACE AMOUNT ADJUSTMENT OPTION
FA Attained Age =
FA Duration =
FA Min =
TARGET VANISHING PREMIUM DURATION
VANISH DURATION
VANISH ATTAINED AGE
VANISH ULTIMATE TARGET FUND
SURRENDER BONUS AS % of T5 AMOUNT ON LAPSE (IIT CREDIT)
ACB NAAR for Surrender Bonus
MVA sign limitation
Direct recapture charge
Risk Charge Formula Table
Surrender Charge Formula [Composite] Table
Face Amount Formula Table
Monthly Risk Charge Table
Optional Issue Age For Table Lookup Formula Table
SC Based on Initial Premium Table
Standard Surrender Charge [Composite] Table
SC Based on Initial Premium [Composite]
Product Features - Continuation guarantee (NLG)
CONTINUATION GUARANTEE
X =
Y =
Z =
Continuation Guarantee Criteria
WAIVER OF FUND CHARGES
Notional Account Deferral Period Table
Notional Account Charge Table
Notional Account Minimum Premium Table
Notional Account Premium Load Table
Notional Account Minimally Funded Premium Load Table
Notional Account Expense Charge Table
Notional Account Credited Interest Table
Notional Account Face Amount Table
Notional Account Risk Charge Table
Notional Account Minimally Funded Risk Charge Table
Notional Account COI Discount
X =
Y =
Notional Account NAAR Method
Notional Account Deferral Period Method
Notional Account Charge Option
Product Features - Fund 1 Investments
FUND 1 INVESTMENTS Option
ALLOCATION RULES Table
Pending Account
Pending Account Option
Negative Balance Interest Spread
Holding Account Option for Pending Account
X
Product Features - Side Fund
SIDE FUND Option
THRESHOLD FUND Table
COMMISSION Table
INVESTMENT ACCOUNTS
Product Features - Policy Loans
POLICY LOANS Option
LOAN ACCOUNT ADJUSTMENT
Liability Category
POLICY LOAN INTEREST RATE CHARGED Table
LOAN ACCOUNT CREDITED RATE Table
POLICY LOAN REPAYMENT
OVERLOAN PROTECTION OPTION
X =
Y =
PROTECTION CHARGE
PROTECTION INTEREST RATE
Multiple Reinsurance
Multiple Reinsurance
Reinsurance Terms
Net Amount At Risk
Input factors
Retention
Single Reinsurance
Single Reinsurance
Proportion Ceded Table
Face Amount Table
Ceded Commission Table
BONUS & CHARGEBACK Table
Risk Charge Table
Other Benefit Set Table
Ceded deferrable commission (%)
Ceded deferrable bonus & chargeback (%)
Ceded Premium Tax Assumptions
Premium Tax Rate From Reinsurer
Premium Tax Basis Ceded
Premium Tax Basis Ceded Adj
Reinsurance Mode
Reinsurance Method
Treatment of Maturity Value
W
Unearned Ceded Premiums
Y
Unearned Ceded Comm
Z
Adj for unregistered
Proportion for unregistered
Earned risk charge for YRT
General Assumptions
SPARE FIELD
KEYCODE
RESRV DETAILS
VAL YEAR
CALCULATION OF MORTALITY PAD
MINIMUM Q REFERENCE TABLE
F factor (VTP 8)
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP FINANCIALS
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
Pricing Assumptions
Total Premium Table
Partial Withdrawal Table
Dynamic Premium Adjustment
Dynamic Premium Adjustment Applies
M =
N =
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
EXTRA LAPSE Table
EXPENSE table
FIXED (OVERHEAD) EXPENSE table
Capital Charge Table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
START ACCUMULATING PROFIT MEASURES AT POLICY YEAR
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
HURDLE RATE
DISCOUNT RATE
Discount Rate Basis
DISCOUNT INTEREST RATE TABLE
YIELD SPREAD table
YIELD PROPORTIONATE ADJUSTMENT table
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
PROFIT MARGIN
PROFIT EMERGENCE (PV)
PROFIT EMERGENCE (ROI)
ROI Definition
Time Zero Strain
Taxes
TAX METHOD
X
CORPORATE TAX RATES
DIFFERENTIAL EARNINGS
Tax exempt investment income proportion table
PREMIUM TAX RATE
PREMIUM TAX BASIS
PREMIUM TAX BASIS ADJ
DAC tax method
T
DAC TAX CAPITALIZATION RATE
DAC TAX BASIS
DAC tax amortization period
CANADIAN IIT RATE
IIT Rate
Proportion of T5 Credit Disallowed
PROPORTION OF IIT DEDUCTIBLE
IIT Payment Frequency
Policyholder Tax
Option
Mortality - Exempt Test Policy
Mortality for Joint Lives - Exempt Test Policy
Interest - Exempt Test Policy
X =
Exempt Test Duration - Exempt Test Policy
Accumulating Fund - Exempt Test Policy
ETP Line Treatment - Exempt Test Policy
Additional Exempt Test Policy Lines
Reserve Assumption Tables
Exempt Test and ACB Mortality tables
CONTAGION FACTOR
T5
Accumulating Fund - T5 Calculation
POLICY LOAN INTEREST IMPACT ON ACB
ACB Mortality - T5 Calculation
7-Pay Test
Guideline Single Premium
Guideline Level Premium
Tax Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
EXTRA LAPSE Table
EXPENSE table
DEFERRABLE EXPENSE table
DEFERRABLE COMMISSION table
DEFERRABLE BONUS / CHARGEBACK table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
INPUT TERMINAL RESERVE FACTORS Table
Fund based reserve adj
MORTALITY PAD
Mortality: Minimum 1st life
SECOND LIFE
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
TAX RESERVE CEILING
Deferrable comp for FAS 97 DAC
Deferrable expense for FAS 97 DAC
Lapse Rate PAD
maximum percentage margin (X =)
Extra lapse rate PAD
Reinsurance Expense Method
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
Reinsurance Expense Mode
Reserve revaluation
M =
N =
Total Premium Table
Partial Withdrawal Table
Benchmark rate MAD
Interpolation
Valuation Scenarios
Dynamic Premium Adjustment
Dynamic Premium Adjustment Applies
M =
N =
Statutory Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
EXTRA LAPSE Table
EXPENSE table
DEFERRABLE EXPENSE table
DEFERRABLE COMMISSION table
DEFERRABLE BONUS / CHARGEBACK table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
INPUT TERMINAL RESERVE FACTORS Table
Fund based reserve adj
IIT Rate
MORTALITY PAD
Mortality: Minimum 1st life
SECOND LIFE
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Statutory Reserve Floor
Deferrable comp for FAS 97 DAC
Deferrable expense for FAS 97 DAC
Lapse Rate PAD
maximum percentage margin (X =)
Extra lapse rate PAD
Reinsurance Expense Method
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
Reinsurance Expense Mode
Reserve revaluation
M =
N =
Total Premium Table
Partial Withdrawal Table
Benchmark rate MAD
Interpolation
Valuation Scenarios
Dynamic Premium Adjustment
Dynamic Premium Adjustment Applies
M =
N =
Second Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
EXTRA LAPSE Table
EXPENSE table
DEFERRABLE EXPENSE table
DEFERRABLE COMMISSION table
DEFERRABLE BONUS / CHARGEBACK table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
INPUT TERMINAL RESERVE FACTORS Table
Fund based reserve adj
IIT Rate
MORTALITY PAD
Mortality: Minimum 1st life
SECOND LIFE
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Deferrable comp for FAS 97 DAC
Deferrable expense for FAS 97 DAC
Lapse Rate PAD
maximum percentage margin (X =)
Extra lapse rate PAD
Reinsurance Expense Method
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
Reinsurance Expense Mode
Reserve revaluation
M =
N =
Total Premium Table
Partial Withdrawal Table
Benchmark rate MAD
Interpolation
Valuation Scenarios
Dynamic Premium Adjustment
Dynamic Premium Adjustment Applies
M =
N =
Third Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
EXTRA LAPSE Table
EXPENSE table
DEFERRABLE EXPENSE table
DEFERRABLE COMMISSION table
DEFERRABLE BONUS / CHARGEBACK table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
INPUT TERMINAL RESERVE FACTORS Table
Fund based reserve adj
IIT Rate
MORTALITY PAD
Mortality: Minimum 1st life
SECOND LIFE
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Deferrable comp for FAS 97 DAC
Deferrable expense for FAS 97 DAC
Lapse Rate PAD
maximum percentage margin (X =)
Extra lapse rate PAD
Reinsurance Expense Method
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
Reinsurance Expense Mode
Reserve revaluation
M =
N =
Total Premium Table
Partial Withdrawal Table
Benchmark rate MAD
Interpolation
Valuation Scenarios
Dynamic Premium Adjustment
Dynamic Premium Adjustment Applies
M =
N =
Fourth Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
EXTRA LAPSE Table
EXPENSE table
DEFERRABLE EXPENSE table
DEFERRABLE COMMISSION table
DEFERRABLE BONUS / CHARGEBACK table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
INPUT TERMINAL RESERVE FACTORS Table
Fund based reserve adj
IIT Rate
MORTALITY PAD
Mortality: Minimum 1st life
SECOND LIFE
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Deferrable comp for FAS 97 DAC
Deferrable expense for FAS 97 DAC
Lapse Rate PAD
maximum percentage margin (X =)
Extra lapse rate PAD
Reinsurance Expense Method
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
Reinsurance Expense Mode
Reserve revaluation
M =
N =
Total Premium Table
Partial Withdrawal Table
Benchmark rate MAD
Interpolation
Valuation Scenarios
Dynamic Premium Adjustment
Dynamic Premium Adjustment Applies
M =
N =
Fifth Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
EXTRA LAPSE Table
EXPENSE table
DEFERRABLE EXPENSE table
DEFERRABLE COMMISSION table
DEFERRABLE BONUS / CHARGEBACK table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
INPUT TERMINAL RESERVE FACTORS Table
Fund based reserve adj
IIT Rate
MORTALITY PAD
Mortality: Minimum 1st life
SECOND LIFE
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Deferrable comp for FAS 97 DAC
Deferrable expense for FAS 97 DAC
Lapse Rate PAD
maximum percentage margin (X =)
Extra lapse rate PAD
Reinsurance Expense Method
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
Reinsurance Expense Mode
Reserve revaluation
M =
N =
Total Premium Table
Partial Withdrawal Table
Benchmark rate MAD
Interpolation
Valuation Scenarios
Dynamic Premium Adjustment
Dynamic Premium Adjustment Applies
M =
N =
Required Surplus
PREMIUM DEFINITION
Claims Definition
GAAP reserve definition
Reduction of negative res and CSV def
Tax rate for Negative Reserves (for MCCSR available capital calculations)
Negative Reserve Reduction Table
Negative Reserve Reduction Table
MCCSR Mortality Components Table
Calculate mortality components for
Lapse Risk Component - Pre 2003 Method
A =
B =
N =
Lapse Risk Component - 2003 method
C =
Lapse Component Floor
Calculate lapse components for
REQUIRED SURPLUS METHOD
Target ratio
REQUIRED CAPITAL
Reserve used for required capital
Available Capital Deduction - Percentage of Deferred Tax Asset
Lapse risk component
Mortality component
Required Capital Factors (%) Table
Required Capital Factors (%) Table
C1 To C4 Required Capital Factors (%) Tables
Solvency Capital Requirements Table
C1 To C4 Required Capital Factors (%) Tables
Stat PFAD Analysis
STAT PFAD ANALYSIS
Reserve Recalculation Order
Other benefit MAD recalculation
Mortality MAD
X
Other benefit MAD
X
Interest MAD
X
Lapse MAD
X
Expense MAD
X
Partial withdrawal MAD
Benchmark rate MAD
Premium MAD
User Defined Scalars
USER DEFINED SCALARS - USAGE SWITCH
USER DEFINED SCALARS - VALUES
User Defined Tables
USER DEFINED TABLES
Par Module Cell Assumption Screen
Processing
CALENDAR YEAR RESULTS
Cell Code
SCENARIO DEPENDENCY
PROJECTION METHOD
ISSUE MONTH METHOD
TIMING OF ISSUE
INFORCE ADJUSTMENT
VOLUMES Table
SERIATIM INFORCE
AGE DISTRIBUTION
POLICY YEAR RESULTS
Pricing Issue Year and Month
Risk class
Risk class life 1 and life 2
Segmentation Method
Liability Category
Benchmark Rate Table
Benchmark Spread Table
Dividend
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
DIVIDEND ADJUSTMENT Table
PUA Dividend Assumptions Table
Premiums
FACE AMOUNT Table
Cash Value Table
PUA CSV Table
DIVIDEND FORMULA
DIVIDEND FORMULA ADJUSTMENT
Dividend Policy Fee
Inflation of expenses
Treatment of gen div
Treatment of PUA div
Timing of PUA CSV
CSV (Dividend expected) Formula
X
DIVIDEND EXPENSE BASE
Treatment of ROUP
Dividend floors
PUA dividend floor
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Product Features
Premiums
PREMIUM ADJUSTMENT Table
FACE AMOUNT Table
Cash Value Table
ROP
COMMISSION Table
Bonus & Chargeback Table
DIVIDEND Table
Proportion to secondary dividend option
TERMINAL DIV Table
SURR DIV Table
PUA Div/Bonus
ENHANCE FACE Table
YRT TERM COST Table
PUA NSP Table
PUA CSV Table
VANISH DURATION Table
PROPORTION OF POLICY FEE COMMISSIONABLE TABLE
Dividends on deposit account
Other Benefit
SHAREHOLDER DIVIDEND RATE
DIVIDEND OPTION
Cash out PUA/Accum dividends for enhancement
Secondary dividend option
Dividend to secondary dividend option
Residual dividend option
Enhance Face option
N =
VANISH PREMIUM
LAPSE AFTER VANISH PREM
VANISH DURATION
VANISH ATTAINED AGE
Guaranteed vanish prem
OYT shortfalls
No. of shortfalls free (N =)
Valuation Size
Age Distribution Table
SALES
Age mix duration
AGE MIX BASIS
LIFE STATUS
1ST LIFE IS
2ND LIFE IS
Maturity Age
POLICY SIZE IS
CSV Formula
X
Mid Year CSV
CSV limitation
MATURITY VAL
MV
DISTRIBUTION OF SALES BY MODE
MODAL PREMIUM FACTORS
POLICY FEE WITH EACH PREMIUM
PROPORTION OF LAPSES AT YR END
PREMIUM RATES
UNEARNED PREMIUMS
Y
UNEARNED COMMISSION
Z
EXPENSE BASIS
First year commission
First year bonus per premium
Prop of 1st year bonus per premium advance
DIVIDEND TABLE HOLDS
Current PUA cash out basis
REGULAR DIV ON DEATH
X
PUA Div/Bonus on death
Y
REGULAR DIV ON LAPSE
X
PUA Div/Bonus on lapse
Y
PUA Bonus per CSV basis
SURR/TERM DIV TABLE
TERM DIV ADJUST
Surrender dividend timing
Enhance face adjustment
Direct recapture charge
Product Features - Additional Premiums
Method
First year premium
Cash out of PUA
Allocation of bonus
Additional premium rate table
Commission on additional premium table
Bonus & Chargeback Table
Premium load on additional premium table
PUA Div/Bonus from additional premium
PUA NSP table
PUA CSV table
Designation of coverage
Additional premium limit
Product Features - Policy Loans
Policy Loan Option
Direct recognition
Use dividends to repay policy loan
Policy Loan Interest Rate Charged table
Maximum Policy Loan Allowed table
Policy Loan Utilization table
Policy Loan Expense Charged (%)
Multiple Reinsurance
Multiple Reinsurance
Reinsurance Terms
Net amount at risk
Input factors
Single Reinsurance
Single Reinsurance
Premiums
PREMIUM ADJUSTMENT Table
FACE AMOUNT Table
Cash Value Table
Other Benefits Table
COMMISSION Table
Bonus & Chargeback Table
Locked in Commission Table
Locked in Bonus & Chargeback Table
DIVIDEND Table
TERMINAL DIV Table
SURR DIV Table
CEDED POLICY FEE TABLE
Recapture charge
Ceded Premium Tax Assumptions
PREMIUM TAX RATE FROM REINSURER
PREMIUM TAX BASIS CEDED
PREMIUM TAX BASIS CEDED ADJ
PREMIUM TAX REFUND CEDED
UNEARNED CEDED PREMIUMS
Y
UNEARNED CEDED COMM
Z
REINSURANCE METHOD
ROP Benefit
OTHER BEN REINS BASIS
PROP COMMISSIONABLE
General Assumptions
SPARE FIELD
KEYCODE
PREM VOLUME
RESRV DETAILS
Y =
CALCULATION OF MORTALITY PAD
MINIMUM Q REFERENCE TABLE
F factor (VTP 8)
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP FINANCIALS
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
Pricing Assumptions
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
Skew lapse table
EXPENSE table
FIXED (OVERHEAD) EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Recapture rate
START ACCUMULATING PROFIT MEASURES AT POLICY YEAR
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
Reduction of lapse rate
X
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
HURDLE RATE
DISCOUNT RATE
DISCOUNT RATE BASIS
DISCOUNT INTEREST RATE TABLE
YIELD SPREAD table
YIELD PROPORTIONATE ADJUSTMENT table
EMBEDDED VALUE: SHAREHOLDER DIVIDEND
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
PROFIT MARGIN
PROFIT EMERGENCE (PV)
PROFIT EMERGENCE (ROI)
ROI Definition
Time Zero Strain
Taxes
TAX METHOD
X
CORPORATE TAX RATES
Tax exempt investment income proportion table
PREMIUM TAX RATE
PREMIUM TAX BASIS
Y
PREMIUM TAX BASIS ADJ
PREMIUM TAX REFUND
DAC tax method
T
DAC Tax Capitalization Rate
DAC Tax Basis
DAC tax amortization period
CANADIAN IIT RATE
IIT Rate
Proportion of T5 Credit Disallowed
PROPORTION OF IIT DEDUCTIBLE
IIT Payment Frequency
Policyholder Tax
Mortality - Exempt Test Policy
Mortality for Joint Lives - Exempt Test Policy
Interest - Exempt Test Policy
X =
Exempt Test Duration - Exempt Test Policy
Accumulating Fund - Exempt Test Policy
ETP Line Treatment
Exempt Test and ACB Mortality Table
MORT LIFE 2 Table
CONTAGION FACTOR
T5 Calculation
Accumulating Fund - T5 Calculation
ACB Mortality - T5 Calculation
Tax Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
Skew lapse table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
OYT reserve rates
Recapture rate
Premiums Table for Valuation
Commission table for valuation
Bonus & Chargeback Table
Dividend Table for Valuation
Terminal Dividend Table for Valuation
Surrender Dividend Table for Valuation
PUA Div/Bonus Table for Valuation
INPUT TERMINAL RESERVE FACTORS table
PUA reserve factors table
MORTALITY PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
Reduction of lapse rate
X
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Tax reserve ceiling
Lapse rate PAD
Lapse margin (X =)
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
RESERVE REVALUATION
M =
N =
REVALUATION METHOD
Lapse PAD Treatment
Valuation mortality adjustment
VALUATION INTEREST RATE
N
I
ADDITIONAL PAD
YEARS
Statutory Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
Skew lapse table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
OYT reserve rates
Recapture rate
Premiums Table for Valuation
Commission table for valuation
Bonus & Chargeback Table
Dividend Table for Valuation
Terminal Dividend Table for Valuation
Surrender Dividend Table for Valuation
PUA Div/Bonus Table for Valuation
INPUT TERMINAL RESERVE FACTORS table
PUA reserve factors table
IIT Rate
MORTALITY PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
Reduction of lapse rate
X
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Statutory Reserve Floor
Lapse rate PAD
Lapse margin (X =)
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
RESERVE REVALUATION
M =
N =
REVALUATION METHOD
Lapse PAD Treatment
Valuation mortality adjustment
VALUATION INTEREST RATE
N
I
ADDITIONAL PAD
YEARS
Second Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
Skew lapse table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
OYT reserve rates
Recapture rate
Premiums Table for Valuation
Commission table for valuation
Bonus & Chargeback Table
Dividend Table for Valuation
Terminal Dividend Table for Valuation
Surrender Dividend Table for Valuation
PUA Div/Bonus Table for Valuation
INPUT TERMINAL RESERVE FACTORS table
PUA reserve factors table
IIT Rate
MORTALITY PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
Reduction of lapse rate
X
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Lapse rate PAD
Lapse margin (X =)
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
RESERVE REVALUATION
M =
N =
REVALUATION METHOD
Lapse PAD Treatment
Valuation mortality adjustment
VALUATION INTEREST RATE
N
I
ADDITIONAL PAD
YEARS
Third Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
Skew lapse table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
OYT reserve rates
Recapture rate
Premiums Table for Valuation
Commission table for valuation
Bonus & Chargeback Table
Dividend Table for Valuation
Terminal Dividend Table for Valuation
Surrender Dividend Table for Valuation
PUA Div/Bonus Table for Valuation
INPUT TERMINAL RESERVE FACTORS table
PUA reserve factors table
IIT Rate
MORTALITY PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
Reduction of lapse rate
X
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Lapse rate PAD
Lapse margin (X =)
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
RESERVE REVALUATION
M =
N =
REVALUATION METHOD
Lapse PAD Treatment
Valuation mortality adjustment
VALUATION INTEREST RATE
N
I
ADDITIONAL PAD
YEARS
Fourth Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
Skew lapse table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
OYT reserve rates
Recapture rate
Premiums Table for Valuation
Commission table for valuation
Bonus & Chargeback Table
Dividend Table for Valuation
Terminal Dividend Table for Valuation
Surrender Dividend Table for Valuation
PUA Div/Bonus Table for Valuation
INPUT TERMINAL RESERVE FACTORS table
PUA reserve factors table
IIT Rate
MORTALITY PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
Reduction of lapse rate
X
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Lapse rate PAD
Lapse margin (X =)
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
RESERVE REVALUATION
M =
N =
REVALUATION METHOD
Lapse PAD Treatment
Valuation mortality adjustment
VALUATION INTEREST RATE
N
I
ADDITIONAL PAD
YEARS
Fifth Reserves
Reserve Method
MORTALITY Table
MORT LIFE 2 Table
CONTAGION FACTOR
AIDS EXTRA Q Table
AIDS LIFE 2 Table
INTEREST Table
Other Benefit Rates Table
LAPSE RATE Table
Skew lapse table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
OYT reserve rates
Recapture rate
Premiums Table for Valuation
Commission table for valuation
Bonus & Chargeback Table
Dividend Table for Valuation
Floor for LOC expense - Apply the zero floor for LOC expense
Terminal Dividend Table for Valuation
Surrender Dividend Table for Valuation
PUA Div/Bonus Table for Valuation
INPUT TERMINAL RESERVE FACTORS table
PUA reserve factors table
IIT Rate
MORTALITY PAD
Mortality minimum: First life
Mortality minimum: Second life
Decrement method
AIDS EXTRA Q TABLE
LAPSE AT
Reduction of lapse rate
X
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Lapse rate PAD
Lapse margin (X =)
Reinsurance Expense
Reinsurance Expense (X =)
Reinsurance Expense (Y =)
RESERVE REVALUATION
M =
N =
REVALUATION METHOD
Lapse PAD Treatment
Valuation mortality adjustment
VALUATION INTEREST RATE
N
I
ADDITIONAL PAD
YEARS
Required Surplus
PREMIUM DEFINITION
Claims Definition
GAAP reserve definition
Reduction of negative res and CSV def
Tax rate for Negative Reserves (for MCCSR available capital calculations)
Negative Reserve Reduction Table
Negative Reserve Reduction Table
MCCSR Mortality Components Table
Calculate mortality components for
Lapse Risk Component - Pre 2003 method
A =
B =
N =
Lapse Risk Component - 2003 method
C =
Lapse Component Floor
Calculate lapse components for
REQUIRED SURPLUS METHOD
Target ratio
REQUIRED CAPITAL
Reserve used for required capital
Available Capital Deduction - Percentage of Deferred Tax Asset
Lapse risk component
Mortality component
Required Capital Factors (%) Table
Target ratio
Required Capital Factors (%) Table
C1 To C4 Required Capital Factors (%) Tables
Solvency Capital Requirements Table
C1 To C4 Required Capital Factors (%) Tables
Stat PFAD Analysis
STAT PFAD ANALYSIS
Reserve Recalculation Order
Other benefit MAD recalculation
Mortality MAD
X
Other benefit MAD
X
Interest MAD
X
Lapse MAD
X
Expense MAD
X
User Defined Scalars
USER DEFINED SCALARS - USAGE SWITCH
USER DEFINED SCALARS - VALUES
User Defined Tables
USER DEFINED TABLES
Disability Module Cell Assumption Screen
Processing
CALENDAR YEAR RESULTS
Cell Code
SCENARIO DEPENDENCY
PROJECTION METHOD
ISSUE MONTH METHOD
TIMING OF ISSUE
INFORCE ADJUSTMENT
VOLUMES Table
SERIATIM INFORCE
Inforce claims volume
AGE DISTRIBUTION
POLICY YEAR RESULTS
PRICING ISSUE YEAR AND MONTH
Risk class
Product Features
Premiums
PREMIUM ADJUSTMENT Table
COMMISSION Table
Bonus & Chargeback Table
PRE DIS BEN Table
POST DIS BEN Table
Benefit paid cap
DI Offset Amount Table
LUMP SUM BEN Table
DI Death Ben Table
Cash Value Table
Return Of Premium Table
PROPORTION OF POLICY FEE COMMISSIONABLE TABLE
Other Benefit
BENEFIT PERIOD
TO AGE
MAX BEN PERIOD
MAX BEN PERIOD MONTHS
MIN BEN PERIOD MONTHS
ELIMINATION PERIOD DAYS
Qualification Period (Lump Sum)
Claim Deferral Period
Premium waiver applies
Valuation Size
Age Distribution Table
SALES
Age mix duration
AGE MIX BASIS
DI death max
Cash Value Reduction
T =
Lump Sum Defn
Mid Year CSV
CSV limitation
MATURITY VAL
MV
EXTRA LUMP SUM
LS
Claim Deferral
Y =
DI Death Benefit Reduction
X =
DISTRIBUTION OF SALES BY MODE
MODAL PREMIUM FACTORS
POLICY FEE WITH EACH PREMIUM
PROPORTION OF LAPSES AT YR END
PREMIUM RATES
SINGLE PREMIUM PLAN
UNEARNED PREMIUMS
Y
UNEARNED COMMISSION
Z
EXPENSE BASIS
First year commission
Prop of 1st year commission advance
First year bonus per premium
Prop of 1st year bonus per premium advance
PREMIUM WAIVER
W =
Treatment of Waived Premium
IBNR CLAIM CALCULATION
IBNR Factor (X)
ISSUE FEE PER POL
COMMISSION RATE ON ISSUE FEE
Purchase assumptions
Purchase date - month
Purchase date - year
Multiple Reinsurance
Multiple Reinsurance
Reinsurance Terms
Single Reinsurance
Single Reinsurance
Premiums
PREMIUM ADJUSTMENT Table
COMMISSION Table
Bonus & Chargeback Table
Locked in Commission Table
Locked in Bonus & Chargeback Table
PRE DIS BEN Table
POST DIS BEN Table
LUMP SUM BEN Table
DI DEATH BEN Table
Cash Value Table
Other Benefits Table
CEDED POLICY FEE TABLE
Ceded Premium Tax Assumptions
PREMIUM TAX RATE FROM REINSURER
PREMIUM TAX BASIS CEDED
PREMIUM TAX BASIS CEDED ADJ
PREMIUM TAX REFUND CEDED
REINSURANCE METHOD
UNEARNED CEDED PREMIUMS
Y
UNEARNED CEDED COMM
Z
ROP Benefit
W =
OTHER BEN REINS BASIS
Ceded Offset Adjustment
PROP COMMISSIONABLE
General Assumptions
SPARE FIELD
KEYCODE
PREM VOLUME
RESRV DETAILS
Y =
DI RECOVERIES
INCIDENCE RATE
EP terminations
Annual Termination Durations
Incidence timing
Benefit Timing
DETERIORATION
Reserve revaluation interval
M =
N =
DISABLED LIVES RETURNING TO ACTIVE STATUS AT END OF BP
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP FINANCIALS
US GAAP required fund
US GAAP Policy Year Results
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
Pricing Assumptions
Termination/Recovery Table
TERMINATION CLIFFS Table
DI Deaths
Cause 1 Qi Table
Cause 2 Qi Table
Cause 3 Qi Table
Incidence distribution
Other Benefit Rates Table
Dis Ben Utilization Table
DI Offset Probability
Lapse Rate Table
Skew lapse table
Interest Table
EXPENSE table
FIXED (OVERHEAD) EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
ADJUSTMENT TABLE 2
START ACCUMULATING PROFIT MEASURES AT POLICY YEAR
HURDLE RATE
DISCOUNT RATE
DISCOUNT RATE BASIS
DISCOUNT INTEREST RATE TABLE
YIELD SPREAD table
YIELD PROPORTIONATE ADJUSTMENT table
EMBEDDED VALUE
EMBEDDED VAL ADJUSTMENT
RATE FOR PV OF LOSS RATIO
DECREMENT METHOD
DI DECREMENT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
PROFIT MARGIN
PROFIT EMERGENCE (PV)
PROFIT EMERGENCE (ROI)
ROI Definition
Time Zero Strain
LOSS RATIO DEFINITION
Taxes
TAX METHOD
X
Y
CORPORATE TAX RATES
Tax exempt investment income proportion table
PREMIUM TAX RATE
PREMIUM TAX BASIS
PREMIUM TAX BASIS ADJ
PREMIUM TAX REFUND
DAC tax method
T
DAC TAX CAPITALIZATION RATE
DAC TAX BASIS
DAC tax amortization period
Tax Reserves
Reserve processing option
X =
Y =
Reserve Method
Termination/Recovery Table
TERMINATION CLIFFS Table
DI Deaths
Cause 1 Qi Table
Cause 2 Qi Table
Cause 3 Qi Table
Incidence distribution
Other Benefit Rates Table
POST DIS BEN Table
Dis Ben Utilization Table
DI Offset Probability
DI Offset Amount MAD
Lapse Rate Table
Skew lapse table
Interest Table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Premiums table for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
DLR INTEREST Table
DLR EXPENSES Table
DLR Modification Table
DECREMENT METHOD
DI DECREMENT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Tax Reserve Ceiling
LAPSE RATE PAD
maximum percentage margin (X =)
Reserve revaluation
Revaluation method
Valuation scenarios
Statutory Reserves
Reserve Method
Termination/Recovery Table
TERMINATION CLIFFS Table
DI Deaths
Cause 1 Qi Table
Cause 2 Qi Table
Cause 3 Qi Table
Incidence distribution
Other Benefit Rates Table
POST DIS BEN Table
Dis Ben Utilization Table
DI Offset Probability
DI Offset Amount MAD
Lapse Rate Table
Skew lapse table
Interest Table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Premiums table for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
DLR INTEREST Table
DLR EXPENSES Table
DLR Modification Table
DECREMENT METHOD
DI DECREMENT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
Statutory Reserve Floor
LAPSE RATE PAD
maximum percentage margin (X =)
Cost of Capital Rate
Reserve revaluation
Revaluation method
Valuation scenarios
Second Reserves
Reserve Method
Termination/Recovery Table
TERMINATION CLIFFS Table
DI Deaths
Cause 1 Qi Table
Cause 2 Qi Table
Cause 3 Qi Table
Incidence distribution
Other Benefit Rates Table
POST DIS BEN Table
Dis Ben Utilization Table
DI Offset Probability
DI Offset Amount MAD
Lapse Rate Table
Skew lapse table
Interest Table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Premiums table for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
DLR INTEREST Table
DLR EXPENSES Table
DLR Modification Table
DECREMENT METHOD
DI DECREMENT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
LAPSE RATE PAD
maximum percentage margin (X =)
Cost of Capital Rate
Reserve revaluation
Revaluation method
Valuation scenarios
Third Reserves
Reserve Method
Termination/Recovery Table
TERMINATION CLIFFS Table
DI Deaths
Cause 1 Qi Table
Cause 2 Qi Table
Cause 3 Qi Table
Incidence distribution
Other Benefit Rates Table
POST DIS BEN Table
Dis Ben Utilization Table
DI Offset Probability
DI Offset Amount MAD
Lapse Rate Table
Skew lapse table
Interest Table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Premiums table for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
DLR INTEREST Table
DLR EXPENSES Table
DLR Modification Table
DECREMENT METHOD
DI DECREMENT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
LAPSE RATE PAD
maximum percentage margin (X =)
Cost of Capital Rate
Reserve revaluation
Revaluation method
Valuation scenarios
Fourth Reserves
Reserve Method
Termination/Recovery Table
TERMINATION CLIFFS Table
DI Deaths
Cause 1 Qi Table
Cause 2 Qi Table
Cause 3 Qi Table
Incidence distribution
Other Benefit Rates Table
POST DIS BEN Table
Dis Ben Utilization Table
DI Offset Probability
DI Offset Amount MAD
Lapse Rate Table
Skew lapse table
Interest Table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Premiums table for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
DLR INTEREST Table
DLR EXPENSES Table
DLR Modification Table
DECREMENT METHOD
DI DECREMENT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
LAPSE RATE PAD
maximum percentage margin (X =)
Cost of Capital Rate
Reserve revaluation
Revaluation method
Valuation scenarios
Fifth Reserves
Reserve Method
Termination/Recovery Table
TERMINATION CLIFFS Table
DI Deaths
Cause 1 Qi Table
Cause 2 Qi Table
Cause 3 Qi Table
Incidence distribution
Other Benefit Rates Table
POST DIS BEN Table
Dis Ben Utilization Table
DI Offset Probability
DI Offset Amount MAD
Lapse Rate Table
Skew lapse table
Interest Table
EXPENSE table
MODIFICATION Table
ADJUSTMENT TABLE 1
ADJUSTMENT TABLE 2
Premiums table for valuation
Commission table for valuation
Bonus & Chargeback Table
INPUT TERMINAL RESERVE FACTORS Table
DLR INTEREST Table
DLR EXPENSES Table
DLR Modification Table
DECREMENT METHOD
DI DECREMENT
ADJUSTMENT TABLE 1 option
ADJUSTMENT TABLE 2 option
LAPSE RATE PAD
maximum percentage margin (X =)
Cost of Capital Rate
Reserve revaluation
Revaluation method
Valuation scenarios
Required Surplus
PREMIUM DEFINITION
INCURRED CLAIMS DEFINITION
GAAP reserve definition
Reduction of negative res and CSV def
Tax rate for Negative Reserves (for MCCSR available capital calculations)
Negative Reserve Reduction Table
Lapse Risk Component - 2003 method
C =
Lapse risk grading
Lapse Component Floor
Calculate lapse components for
REQUIRED SURPLUS METHOD
Target ratio
REQUIRED CAPITAL
Reserve used for required capital
Lapse risk component
Available Capital Deduction - Percentage of Deferred Tax Asset
Required Capital Factors (%) Table
C1 To C4 Required Capital Factors (%) Tables
Solvency Capital Requirements Table
Negative Reserve Reduction Table
Stat PFAD Analysis
STAT PFAD ANALYSIS
Reserve Recalculation
Other benefit MAD recalculation
Incidence MAD recalculation
Termination/Recovery MAD
DI death MAD
X
DI Offset Amount MAD
Incidence MAD
X
Other benefit MAD
X
Lapse MAD
X
Interest MAD
X
Expense MAD
X
Disability Reserve
Interest MAD
X
Expense MAD
X
Termination/Recovery MAD
DI death MAD
X
DI Offset Amount MAD
User Defined Scalars
USER DEFINED SCALARS - USAGE SWITCH
USER DEFINED SCALARS - VALUES
User Defined Tables
USER DEFINED TABLES
Asset/Reinv Module Cell Assumption Screen
Processing
CALENDAR YEAR RESULTS
Cell Code
SCENARIO DEPENDENCY
Duration Calculation
Greeks Calculation
POLICY YEAR RESULTS
Scenario supplement table timing
Historic Asset Table
Reporting Category
Reinvestment Category
Reinvestment category table
Asset Bundle Category
Liquidity Index
Asset Features
Calculation type
REPORTING TYPE
Equity Index
INCOME RATE Table
Additional Spread on Principal
MORTGAGE PAYMENTS table
Historic Cashflow Table
DATE OF ISSUE
PAR VALUE
DATE OF PURCHASE
PURCHASE PRICE
DATE OF MATURITY
MATURITY VALUE
PAYMENT MODE
INCOME RATE TYPE
INCOME RATE BASIS
Initial Income Rate Option
Initial Income Rate
Initial Period
MORTGAGE INTEREST
MORTGAGE PAYMENTS switch
NO OF QUARTERS (N =)
FUTURE ACQUISITIONS
YIELD CURVE
Stock/Real Estate
OPTION TEST RATE Table
OPTION PREMIUM Table
MORTGAGE PREPAYMENT LIMITS Table
SINKING FUND Table
OPTION TEST METHOD
MORT PREPAYMENTS
Prepayment penalty
MVA Spread
M= (Number of months)
Option type
Months between exercise
Embedded option timing
Embedded option start date
Embedded option end date
Option Strike Price
Base asset start price
INCOME RATE (PAY) table
PAYMENT MODE (pay side of swap)
INCOME RATE TYPE (pay side of swap)
Initial Income Rate Option (pay)
Initial Income Rate (pay)
Initial Period (pay)
Principal Exchange
Principal Exchange - Receive par value and pay X
Inforce Volumes
INFORCE DATE (MONTH/YEAR)
INFORCE UNITS
PAR VALUE INFORCE
MARKET VALUE INFORCE
CURRENT O/S PRINCIPAL
MARKET VALUE INFORCE (pay side of swap)
Write-downs on impaired assets
AI INFORCE
AI INFORCE (pay)
AMORTIZED COST BASIS INFORCE
Tax Amortized Unrealized Gains
Book Amortized Unrealized Gains
Accumulated OCI
Notional amount/multiplier
Accumulated average switch
Accumulated average value
General Assumptions
DEFAULT MODE
SALES MODE
Opt/prepay rate type - Use rate as point in time
DEFAULTS
Pricing/Projections
DEFAULT RATE Table
SALVAGE VALUE Table
PROPERTY SALVAGE Table
OPTION/PREPAYMENT Table
MORTGAGE LAPSE Table
EXPENSE table
OTHER CHARGES table
SALES RATE Table
PROJECTION PERIOD
EARNED INCOME
Designated Investment CF
X= for Designated Investment CF
DISCOUNT RATE FOR PY RESULTS
Margins
Method
Income rate
Default Rate
Salvage value
Expenses
Other Charges
Growth rate
Market value correction
Tax Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
IRR METHOD
IRR
IRR Recalculation
M =
N =
IRR VALIDATION
DEFAULT
TOLERANCE
DEPRECIATION RATE Table (book)
PREPAYMENT TABLE
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
TAX EXEMPT PORTION OF DISPOSITION GAINS
TAX EXEMPT PORTION OF EARNED INCOME
TAX EXEMPT PORTION OF COUPON INCOME
First Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
IRR METHOD
IRR
IRR Recalculation
M =
N =
IRR VALIDATION
DEFAULT
TOLERANCE
DEPRECIATION RATE Table (book)
PREPAYMENT TABLE
Accounting Treatment
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
Second Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
IRR METHOD
IRR
IRR Recalculation
M =
N =
IRR VALIDATION
DEFAULT
TOLERANCE
DEPRECIATION RATE Table (book)
PREPAYMENT TABLE
Accounting Treatment
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
Third Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
IRR METHOD
IRR
IRR Recalculation
M =
N =
IRR VALIDATION
DEFAULT
TOLERANCE
DEPRECIATION RATE Table (book)
PREPAYMENT TABLE
Accounting Treatment
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
Fourth Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
IRR METHOD
IRR
IRR Recalculation
M =
N =
IRR VALIDATION
DEFAULT
TOLERANCE
DEPRECIATION RATE Table (book)
PREPAYMENT TABLE
Accounting Treatment
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
Market Value
MARKET VALUE METHOD
YIELD SPREAD BOUND
DEPRECIATION METHOD
DEFAULT RATE Table
SALVAGE VALUE Table
OPTION/PREPAYMENT Table
MORTGAGE LAPSE Table
EXPENSE table
OTHER CHARGES table
GROWTH RATE Table
DEPRECIATION RATE Table (market)
YIELD SPREAD Table
YIELD PROPORTIONATE ADJUSTMENT Table
SPREAD METHOD
Historical spread
Grading span
SCENARIO REFERENCING - YIELD CURVE
SCENARIO REFERENCING - NON YIELD CURVE
Tree size lower bound
Months between exercise
X =
BDT REPORT DATE
TREE SIZE
Short Rate Volatility for BDT and Black Scholes
YIELD SPREAD Table (pay side of swap)
YIELD PROPORTIONATE ADJUSTMENT Table (pay side of swap)
SPREAD METHOD (PAY SIDE OF SWAP)
Historical spread (pay side of swap)
Grading span (pay side of swap)
Required Surplus
Required Surplus Method
REQUIRED SURPLUS FACTORS
AVR/IMR
AVR Sub-component
AVR Factors
IMR TAX RATE
Scenario Links
Scenario links
User Defined Scalars
USER DEFINED SCALARS - USAGE SWITCH
USER DEFINED SCALARS - VALUES
Reinv Module Cell Assumption Screen
Processing
CALENDAR YEAR RESULTS
Cell Code
SCENARIO DEPENDENCY
Duration Calculation
PROFIT TEST YR
Reporting Category
Reinvestment Category
Reinvestment category table
Liquidity Index
Historic Asset Table
Asset Features
CALCULATION TYPE
REPORTING TYPE
INCOME RATE Table
Additional Spread on Principal
MORTGAGE PAYMENTS table
CMO Tranches Information Table
PAR VALUE
TOTAL TERM OF ASSET
PURCHASE PRICE
TIME SINCE ISSUE AT PURCHASE DATE
MATURITY VALUE
LIMIT MATURITY
ADJUST INCOME RATE
PAYMENT MODE
INCOME RATE TYPE
INCOME RATE BASIS
Initial Income Rate Option
Initial Income Rate
Initial Period
MORTGAGE PAYMENTS switch
NO OF QUARTERS (N =)
YIELD CURVE
Stock/Real Estate
OPTION PREMIUM Table
MORTGAGE PREPAYMENT LIMITS Table
SINKING FUND Table
Option type
Months between exercise
Option timing
Months since issue at option start date
Months since issue at option end date
MORT PREPAYMENTS
Prepayment penalty
MVA Spread
M= (Number of months)
INCOME RATE (PAY) table
PAYMENT MODE (pay side of swap)
INCOME RATE TYPE (pay side of swap)
Initial Income Rate Option (pay)
Initial Income Rate (pay)
Initial Period (pay)
Principal Exchange
Principal Exchange - Receive par value and pay X
Historic Cashflow Table
General Assumptions
DEFAULT MODE
SALES MODE
Opt/prepay rate type - Use rate as point in time
DEFAULTS
Pricing/Projections
DEFAULT RATE Table
SALVAGE VALUE Table
OPTION/PREPAYMENT Table
MORTGAGE LAPSE Table
EXPENSE table
OTHER CHARGES table
SALES RATE Table
PROJECTION PERIOD
EARNED INCOME
Designated Investment CF
X= for Designated Investment CF
DISCOUNT RATE FOR PY RESULTS
Margins
Method
Income rate
Default Rate
Salvage value
Expenses
Other Charges
Growth rate
Market value correction
Tax Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
DEPRECIATION RATE Table (book)
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
TAX EXEMPT PORTION OF DISPOSITION GAINS
TAX EXEMPT PORTION OF EARNED INCOME
TAX EXEMPT PORTION OF COUPON INCOME
First Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
DEPRECIATION RATE Table (book)
Accounting Treatment
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
Second Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
DEPRECIATION RATE Table (book)
Accounting Treatment
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
Third Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
DEPRECIATION RATE Table (book)
Accounting Treatment
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
Fourth Accounting Basis
AMORTIZED COST BASIS METHOD
DEPRECIATION METHOD
DEPRECIATION RATE Table (book)
Accounting Treatment
Unrealized Gains
Realized Gains
AMORTIZATION METHOD
Market Value
MARKET VALUE METHOD
DEPRECIATION METHOD
DEFAULT RATE Table
SALVAGE VALUE Table
OPTION/PREPAYMENT Table
MORTGAGE LAPSE Table
EXPENSE table
OTHER CHARGES table
GROWTH RATE Table
YIELD SPREAD Table
YIELD PROPORTIONATE ADJUSTMENT Table
DEPRECIATION RATE Table (market)
SCENARIO REFERENCING - YIELD CURVE
SCENARIO REFERENCING - NON YIELD CURVE
YIELD SPREAD Table (pay side of swap)
YIELD PROPORTIONATE ADJUSTMENT Table (pay side of swap)
Required Surplus
Required Surplus Method
REQUIRED SURPLUS FACTORS
AVR/IMR
AVR Sub-component
AVR Factors
IMR TAX RATE
Scenario Links
Scenario links
User Defined Scalars
USER DEFINED SCALARS - USAGE SWITCH
USER DEFINED SCALARS - VALUES
Annuity Module Cell Assumption Screen
Processing
CALENDAR YEAR RESULTS
Cell Code
SCENARIO DEPENDENCY
PRICING ISSUE YR
SALES DISTRIBUTION
PRICING ISSUE MONTH
TIMING OF ISSUE
INFORCE OPTION
VOLUMES Table
SERIATIM INFORCE
POLICY YEAR RESULTS
Risk class
Risk class life 1 and life 2
General Account Liability Category
Block Reporting Category
Block Reporting Category Formula Table
Product Features
Plan type
Age Distribution Table
Age mix duration
AGE MIX BY
Product Features - Accumulation Phase
Investment Account
Allocation rules
Pending Account
Pending Account Option
Negative Balance Interest Spread
Holding Account Option for Pending Account
X
SCHED PREM Table
DUMPIN PREM Table
FIRST YEAR SINGLE PREMIUM
PREMIUM LOAD / BONUS Table
EXP CHARGE Table
GUARANTEED MINIMUM WITHDRAWAL Table
Fund bonus table
COMMISSION Accumulation Table
CHARGEBACK
Bonus Payout Table
Death Benefit Enhancement
SCHEDULED PREMIUM DISTRIBUTION BY
ALL YR
SCHEDULED WITHDRAWAL DISTRIBUTION BY
SCHEDULED WITHDRAWAL DISTRIBUTION - ALL YR
REGULAR LAPSE DISTRIBUTION BY
Lapse Distribution During the Year (INIT/YR N+)
Fund Accumulation
MATURITY VALUE
Z=
MATURITY OPTION
Per Policy Charges
U%
Per Minimum Ann Base Charges
Per Death Benefit Charges
RRIF MINIMUM PAYOUT
Bonus payout method
Q =
RESET GUARANTEE
V =
ANNUITIZATION VALUE
X=
Minimum Annuitization Income
Minimum Annuitization Income Ages
Minimum Annuitization Benefit No Lapse Guarantee
P=
DEATH BENEFIT accumulation
D = (Percentage of fund for death benefit)
Minimum Death Benefit < Age N
N =
Y=
Minimum Death Benefit Treatment
T =
Death Benefit Top Up
SNFL Deposit Percentage
SNFL Growth Rate
Cash Value Table
CASH VALUE Definition
W =
S =
SURR CHARGE FACTORS
SURR CHARGE Table
Bailout provision table
MVA method
MVA sign limitation
Bond yield linked MVA applies
MVA period
MVA bond term
MVA spread
Bond yield linked MVA reduction (positive MVA)
Bond yield linked MVA reduction (negative MVA)
Limit to positive MVA (%)
Limit to negative MVA (%)
MVA rate basis
MVA formula method
Partial Withdrawal Formula Table
Product Features - Accumulation Phase - Guarantee Fund 1
Guarantee Fund Usage
Guarantee Fund Method
M =
Guarantee Fund Age K
Formula Table for H for Ratchet
Guarantee Fund Accumulated Rate Table
Premium multiplier
PREMIUM LOAD/BONUS
Withdrawals
X=
J% for Withdrawals From Guarantee Fund - Use Regular Table
J% for Withdrawals From Guarantee Fund
Maximum Guarantee Fund
N =
Y =
Reset Rule
Z
Product Features - Accumulation Phase - Guarantee Fund 2
Guarantee Fund Usage
Guarantee Fund Method
M =
Guarantee Fund Age K
V
Formula Table for H for Ratchet
Guarantee Fund Accumulated Rate Table
Premium multiplier
PREMIUM LOAD/BONUS
Withdrawals
X=
J% for Withdrawals From Guarantee Fund - Use Regular Table
J% for Withdrawals From Guarantee Fund
Maximum Guarantee Fund
N =
Y =
Product Features - Accumulation Phase - Guarantee Fund 3
Guarantee Fund Usage
Guarantee Fund Method
Guarantee Fund Age K
Formula Table for H for Ratchet
Guarantee Fund Accumulated Rate Table
Premium multiplier
PREMIUM LOAD/BONUS
Withdrawals
X=
J% for Withdrawals From Guarantee Fund - Use Regular Table
J% for Withdrawals From Guarantee Fund
Maximum Guarantee Fund
N =
Y =
Product Features - Accumulation Phase - Guarantee Fund 4
Guarantee Fund Usage
Guarantee Fund Method
Guarantee Fund Age K
Formula Table for H for Ratchet
Guarantee Fund Accumulated Rate Table
Premium multiplier
PREMIUM LOAD/BONUS
Withdrawals
X=
J% for Withdrawals From Guarantee Fund - Use Regular Table
J% for Withdrawals From Guarantee Fund
Maximum Guarantee Fund
N =
Y =
Product Features - Accumulation Phase - Guarantee Fund 5
Guarantee Fund Usage
Guarantee Fund Method
Guarantee Fund Age K
Formula Table for H for Ratchet
Guarantee Fund Accumulated Rate Table
Premium multiplier
PREMIUM LOAD/BONUS
Withdrawals
X=
J% for Withdrawals From Guarantee Fund - Use Regular Table
J% for Withdrawals From Guarantee Fund
Maximum Guarantee Fund
N =
Y =
Product Features - Annuitization Phase
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
EXPENSE Annuity Table
CURR PREMIUM Table
GUAR PREMIUM Table
PAYOUT Table
Guar Period Years
COMMISSION Annuity Table
ANNUITY DEFERRAL PERIOD (N =)
ANNUITY DEFERRED TO LIFE 1 AGE A (A=)
PREMIUM OPTIONS
X=
AGE ADJUSTMENT (mths) : LIFE 1
AGE ADJUSTMENT (mths) : LIFE 2
LIFE STATUS
ANNUITY TYPE
PAYOUT MODE
PAYOUT INDEXATION
PAYOUT INDEXATION (M =)
ADDITIONAL PAYOUT
DEATH BENEFIT annuity
S =
GDA annuitization bonus
Reinsurance
Reinsurance Terms X
General Assumptions
SPARE FIELD
KEYCODE
RESRV DETAILS
VAL YEAR
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP FINANCIALS
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
Pricing Assumptions
Partial Withdrawal Table
MORTALITY Accumulation Table
INTEREST Accumulation Table
LAPSE RATE Table
EXTRA LAPSE Table
ANNUITIZE Rate Table
EXPENSE Table
Fixed Expense
MODIFICATION Accumulation Table
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
EXPENSE Annuity Table
Fixed Expense
MODIFICATION Annuity Table
START ACCUMULATING PROFIT MEASURES AT POLICY YEAR
Decrement method
HURDLE RATE
DISCOUNT RATE
DISCOUNT RATE BASIS
DISCOUNT INTEREST RATE TABLE
YIELD SPREAD table
YIELD PROPORTIONATE ADJUSTMENT table
EMBEDDED VALUE
EMBEDDED VAL ADJUSTMENT
PROFIT MARGIN
PROFIT EMERGENCE (PV)
PROFIT EMERGENCE (ROI)
ROI Definition
Time Zero Strain
Extra Lapse Formula Table
Taxes
TAX METHOD
X
CORPORATE TAX RATES
PREMIUM TAX RATE
Stamp duty
PREMIUM TAX BASIS ADJ
Premium tax on annuitization
Taxable Income Adjustment
DAC tax method
T
DAC TAX CAPITALIZATION RATE
DAC tax amortization period
Tax Reserves
Reserve Method
MORTALITY Accumulation Table
INTEREST Accumulation Table
LAPSE RATE Table
EXTRA LAPSE Table
ANNUITIZE Rate Table
EXPENSE Table
MODIFICATION Accumulation Table
Fund based reserve adjustment table
COMMISSION Accumulation Table
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
EXPENSE Annuity Table
MODIFICATION Annuity Table
Decrement method
TAX RESERVE CEILING
Risk Mitigation Factor
Seg Fund Factor Method Tables
Reserve revaluation
M =
N =
Partial withdrawal
Benchmark rate MAD
Seg fund management fee MAD
Annuitization Current Prem
Valuation scenarios
Future premium
Charges for guarantees
Y =
X =
Z =
Extra fund shock for base reserve
S =
Statutory Reserves
Reserve Method
MORTALITY Accumulation Table
INTEREST Accumulation Table
LAPSE RATE Table
EXTRA LAPSE Table
ANNUITIZE Rate Table
EXPENSE Table
MODIFICATION Accumulation Table
Fund based reserve adjustment table
COMMISSION Accumulation Table
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
EXPENSE Annuity Table
MODIFICATION Annuity Table
Decrement method
Risk Mitigation Factor
Seg Fund Factor Method Tables
Reserve revaluation
M =
N =
Partial withdrawal
Benchmark rate MAD
Seg fund management fee MAD
Annuitization Current Prem
Valuation scenarios
Future premium
Charges for guarantees
X =
Y =
Z =
Extra fund shock for base reserve
S =
Second Reserves
Reserve Method
MORTALITY Accumulation Table
INTEREST Accumulation Table
LAPSE RATE Table
EXTRA LAPSE Table
ANNUITIZE Rate Table
EXPENSE Table
MODIFICATION Accumulation Table
Fund based reserve adjustment table
COMMISSION Accumulation Table
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
EXPENSE Annuity Table
MODIFICATION Annuity Table
Decrement method
Risk Mitigation Factor
Seg Fund Factor Method Tables
Reserve revaluation
M =
N =
Partial withdrawal
Benchmark rate MAD
Seg fund management fee MAD
Annuitization Current Prem
Valuation scenarios
Future premium
Charges for guarantees
X =
Y =
Z =
Extra fund shock for base reserve
S =
Third Reserves
Reserve Method
MORTALITY Accumulation Table
INTEREST Accumulation Table
LAPSE RATE Table
EXTRA LAPSE Table
ANNUITIZE Rate Table
EXPENSE Table
MODIFICATION Accumulation Table
Fund based reserve adjustment table
COMMISSION Accumulation Table
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
EXPENSE Annuity Table
MODIFICATION Annuity Table
Decrement method
Risk Mitigation Factor
Seg Fund Factor Method Tables
Reserve revaluation
M =
N =
Partial withdrawal
Benchmark rate MAD
Seg fund management fee MAD
Annuitization Current Prem
Valuation scenarios
Future premium
Charges for guarantees
X =
Y =
Z =
Extra fund shock for base reserve
S =
Fourth Reserves
Reserve Method
MORTALITY Accumulation Table
INTEREST Accumulation Table
LAPSE RATE Table
EXTRA LAPSE Table
ANNUITIZE Rate Table
EXPENSE Table
MODIFICATION Accumulation Table
Fund based reserve adjustment table
COMMISSION Accumulation Table
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
EXPENSE Annuity Table
MODIFICATION Annuity Table
Decrement method
Risk Mitigation Factor
Seg Fund Factor Method Tables
Reserve revaluation
M =
N =
Partial withdrawal
Benchmark rate MAD
Seg fund management fee MAD
Annuitization Current Prem
Valuation scenarios
Future premium
Charges for guarantees
X =
Y =
Z =
Extra fund shock for base reserve
S =
Fifth Reserves
Reserve Method
MORTALITY Accumulation Table
INTEREST Accumulation Table
LAPSE RATE Table
EXTRA LAPSE Table
ANNUITIZE Rate Table
EXPENSE Table
MODIFICATION Accumulation Table
Fund based reserve adjustment table
COMMISSION Accumulation Table
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
EXPENSE Annuity Table
MODIFICATION Annuity Table
Decrement method
Risk Mitigation Factor
Seg Fund Factor Method Tables
Reserve revaluation
M =
N =
Partial withdrawal
Benchmark rate MAD
Seg fund management fee MAD
Annuitization Current Prem
Valuation scenarios
Future premium
Charges for guarantees
X =
Y =
Z =
Extra fund shock for base reserve
Required Surplus
PREMIUM DEFINITION
Risk Mitigation Factor
Seg Fund Factor Method Tables
REQUIRED SURPLUS
Target ratio
REQUIRED CAPITAL
Reserve used for required capital
Available Capital Deduction - Percentage of Deferred Tax Asset
Seg fund component
Required Capital Factors (%) Table
C1 To C4 Required Capital Factors (%) Tables
Solvency Capital Requirements Table
Negative Reserve Reduction Table
Stat PFAD Analysis
STAT PFAD ANALYSIS
Reserve Recalculation
Mortality MAD
X
Interest MAD
X
Lapse MAD
X
Annuitization MAD
X
Expense MAD
X
Net basic reserve
Modal loading for DPA/UEP - Include (use annualized premium)
Seg fund management fee MAD
Hedged Liabilities
Hedged Liabilities
User Defined Scalars
USER DEFINED SCALARS - USAGE SWITCH
USER DEFINED SCALARS - VALUES
User Defined Tables
User Defined Tables
Group Annuity Module Cell Assumption Screen
Processing
Calendar Year Results
Cell Code
Scenario Dependency
Modeling Technique
Seriatim Deposits
Group Issue Year
Group Issue Month
Risk class
General Account Liability Category
Product Features - When Modeling Individual Certs Only
Age Distribution Table
NEW ENTRANT FREQUENCY
Product Features - Group Level
NUMBER OF INITIAL CERTS
CERT GROWTH RATE IS
CERT GROWTH
CERT TERMINATION
Deduct X% of the average fund balance for lapses
GROUP TERMINATES IN YEAR
Prop of MVA/BEC on term
GROUP LAPSE OCCURS
GROUP LAPSE
Chargeback
SALES BONUS
COMMISSION
Additional commission per group assets (%)
Additional commission per initial trans (%)
Additional commission per new ent trans (%)
Additional commission per first year recurring prem (%)
Additional commission per renewal recurring prem (%)
Product Features - Certificate Level
Allocation rules
TRANSFER PER INITIAL CERT
TRANSFER PER NEW ENTRANT
ADDITIONAL TRANSFERS
RECURRING PREM PER CERT
PREMIUM GROWTH
SCHEDULED WITHDRAWAL
BANDED BONUS INT (GRP)
BANDED MNGT FEE RDCTN (GRP)
TIERED SPREAD REDCTN (GRP)
BANDED BONUS INT (CERT)
BANDED MGT FEE RDCTN (CERT)
SCHEDULED PREM DISTRIBUTION BY
SCHEDULED PREM DISTRIBUTION - ALL YR
SCHEDULED WITHDRAWAL DISTRIBUTION BY
SCHEDULED WITHDRAWAL DISTRIBUTION- ALL YR
CERT LAPSE DISTRIBUTION BY
CERT LAPSE DISTRIBUTION DURING THE YR (INIT/YR N+)
EXTRA MVA SPREAD ON GROUP LAPSE
EXTRA MVA SPREAD ON CERT LAPSE
MVA sign limitation
SURR CHARGE FACTORS
Minimum cash value
Product Features - Charges
PREMIUM LOAD
PARTICIPANT FEE IS
PARTICIPANT FEE (FLAT $)
PARTCPNT FEE (% OF ASSETS)
ASSET CHARGE / SERC IS
BASE ASSET CHARGE
BASE ASSET CHARGE REDUCTION
SUPPLEMENTAL ASSET CHARGE
ADDITIONAL FIRST YEAR SUPPLEMENTAL ASSET CHARGE
SERC (SALES EXPENSE RECOVERY CHARGE)
Minimum Charge Per Asset Basis
MINIMUM CHARGE PER ASSET ($)
Policy month to start minimum charge
GROUP EXP CHARGE
Additional group exp charge per cert ($)
Additional group exp charge per group ($)
SURR CHARGE (CERT LAPSE)
BACK END CHARGE (GROUP LAPSE)
General Assumptions
SPARE FIELD
KEYCODE
Reserve details
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP FINANCIALS
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
Pricing Assumptions
INTEREST
EXPENSES
FIXED EXPENSES
Additional Expense Per Group at Group Issue
HURDLE RATE
EMBEDDED VALUE
EMBEDDED VAL ADJUSTMENT
Taxes
TAX METHOD
CORPORATE TAX RATES
Tax Rate Table
PREMIUM TAX RATE
Tax Reserves
Reserve Method
INTEREST
EXPENSES
DEF EXPENSES
DAC Amortization
Additional Expense Per Group at Group Issue
Additional Deferrable Expense Per Group at Group Issue
TAX RESERVE CEILING
Future premium
Reserve revaluation
M =
N =
Statutory Reserves
Reserve Method
INTEREST
EXPENSES
DEF EXPENSES
DAC Amortization
Additional Expense Per Group at Group Issue
Additional Deferrable Expense Per Group at Group Issue
Future premium
Reserve revaluation
M =
N =
Second Reserves
Reserve Method
INTEREST
EXPENSES
DEF EXPENSES
DAC Amortization
Additional Expense Per Group at Group Issue
Additional Deferrable Expense Per Group at Group Issue
Future premium
Reserve revaluation
M =
N =
Third Reserves
Reserve Method
INTEREST
EXPENSES
DEF EXPENSES
DAC Amortization
Additional Expense Per Group at Group Issue
Additional Deferrable Expense Per Group at Group Issue
Future premium
Reserve revaluation
M =
N =
Fourth Reserves
Reserve Method
INTEREST
EXPENSES
DEF EXPENSES
DAC Amortization
Additional Expense Per Group at Group Issue
Additional Deferrable Expense Per Group at Group Issue
Future premium
Reserve revaluation
M =
N =
Fifth Reserves
Reserve Method
INTEREST
EXPENSES
DEF EXPENSES
DAC Amortization
Additional Expense Per Group at Group Issue
Additional Deferrable Expense Per Group at Group Issue
Future premium
Reserve revaluation
M =
N =
Required Surplus
REQUIRED SURPLUS
Target ratio
REQUIRED CAPITAL
Reserve used for required capital
REQUIRED CAPITAL FACTOR TABLE
Solvency Capital Requirements Table
Negative Reserve Reduction Table
C1 To C4 Required Capital Factors (%) Tables
Fund Assumption Screen
Initial Asset Position
METHOD OF INPUT
Initial Free Surplus
Initial Total Asset
X% of book profit reserve used
Proportion of general account invested assets from the asset subfunds
Retained earnings
Transfers Of Free Surplus
AMOUNT OF TRANSFER
X =
Timing of transfer
Investment Earnings
GENERAL ACCOUNT INVESTMENT EARNINGS
USE REINVESTMENT STRATEGY
General Account Liability Category
INTEREST RATE FOR CASHFLOW Table
INTEREST RATE FOR REINVESTMENT Table
INTEREST RATE FOR BORROWING Table
LIABILITY CATEGORY INVESTMENT EARNINGS
Asset Segment Definition
Liability Matching Reinvestment Strategy
Match Minimum (Units)
NET INVESTMENT INCOME RATE
MONTHLY PERIOD EARNED RATE
Earned rate validation
Lower rate bound
X =
Upper rate bound
Y =
Alternate rate
Capture earned rate
Capture earned rate asset base
Capture column
INTEREST ALLOCATION METHOD
REINVESTMENT STRATEGY OVERRIDE
N =
Expenses
EXPENSES
WHICH YR
EXPENSE
Floor for LOC expense
Capital Charge
CAPITAL CHARGE ADJUSTMENT TABLE
Reserves
Reserve Revaluation Table
DTL ADJUSTMENT
First Required Fund
REQUIRED SURPLUS
Z=
FUND TARGET RATIO
Prop of assets to include in RS
REQUIRED CAPITAL
Reserve used for required capital
RC Components Table
MCCSR Mortality Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve - Negative reserves shown in calendar year results
Extra required surplus table
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCIES
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $million)
C% of CV Def and Neg Res
Final extra required surplus adjustment formula table
Extra required surplus formula table
C1 To C4 RC Components Table
Second Required Fund
REQUIRED SURPLUS
Z=
FUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve - Negative reserves shown in calendar year results
Extra required surplus table
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCIES
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $million)
C% of CV Def and Neg Res
Final extra required surplus adjustment formula table
Extra required surplus formula table
C1 To C4 RC Components Table
Third Required Fund
REQUIRED SURPLUS
Z=
FUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve - Negative reserves shown in calendar year results
Extra required surplus table
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCIES
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $million)
C% of CV Def and Neg Res
Final extra required surplus adjustment formula table
Extra required surplus formula table
C1 To C4 RC Components Table
AVR / IMR
IMR Floor
AVR Starting Reserves
Amortization Amounts ($Millions)
INITIAL DEFERRED ASSET AMOUNTS METHOD
AMORTIZATION OF G/L ON PAST BOND DISPOSALS FOR YEARS 1 to 20
AMORTIZATION OF G/L ON PAST MORTGAGE DISPOSALS FOR YEARS 1 to 20
SHARES - DEFERRED REALIZED GAIN
SHARES - TAX EXEMPT % OF AMORTIZATION OF DEFERRED REALIZED GAIN
REAL ESTATE - DEFERRED REALIZED GAIN
REAL ESTATE - TAX EXEMPT % OF AMORTIZATION OF DEFERRED REALIZED GAIN
Asset accounting basis
Reporting Category
Reinvestment Category
Taxation
TAXATION METHOD
Corporate Tax Rate Table
TAX RATE ON CASHFLOW & RESERVES
ACCRUED TAX ($000's)
TAX RATE ON REQUIRED SURPLUS
ACCRUED TAX ($000's)
TAX RATE ON FREE SURPLUS
ACCRUED TAX ($000's)
PROPORTION OF IIT DEDUCTIBLE
DIFFERENTIAL EARNINGS RATE
Future Tax Liability
X = ($000's)
TAX LOSS TREATMENT
X = (AMOUNT OF TAX LOSS)
Y =
Z =
Historical tax loss carryforwards
DAC tax method
T
DAC CAPITALIZATION RATE
Historical DAC Tax Balances
Taxable amount calculation
DAC tax basis
DAC tax amortization period
Fund Information
FUND INFORMATION
Annuity reinsurance treaties
INITIAL SHAREHOLDER SURPLUS
SHAREHOLDER DIVIDEND
X =
Experience Refund
Experience refund method
N =
Random seed specification
H = / L =
ER discount rate
Stochastic generate formula
Experience refund formula
Additional Reserve Adjustment
Claim fluctuation reserve ($000's)
Loss carry forward ($000's)
Reserve adjustment ($000's)
Book Profit Financials
Book profit reserve table
Book Profit required fund
DTL ADJUSTMENT
DTL ADJUSTMENT APPLIES
Statement DTL/DTA
HURDLE RATE
EMBEDDED VALUE: SHAREHOLDER DIVIDEND
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
COLUMN 5 PROFIT MARGIN
Reserve formula table
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP financials
US GAAP required fund
US GAAP Asset Accounting Basis
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative Financials Asset Accounting Basis
Alternative financials required surplus interest rate
Hedge Strategy Assumption Screen
Processing
Hedge asset sales
Fee income
Optimization criteria
INTEREST RATE FOR MARGIN ACCOUNT Table
Equity Risk
Match with Optimization
Hedge Asset Series tables
Hedge asset ladder for Simple Match
Equity option series
Equity forward series
Interest rate swap series
Interest rate swaption series
Interest Rate Risk
Match with Optimization
Hedge Asset Series tables
Hedge asset ladder for Simple Match
Equity option series
Equity forward series
Interest rate swap series
Interest rate swaption series
Integrated Hull White LN Model Assumption Screen
Hull White Model Parameters
Hull and White and LogNormal market model screen
Yield Curve input table
Average and Standard Deviation table
Lognormal Vector Process (composite) table
Dividends table
Scenario Column Link table
Index total return volatility table
Index total return drift table
Intermodel Correlations
Intermodel correlations table
LogNormal Model Parameters
Output to Equity Markets Table
Index total return drift table
Index total return volatility table
Correlation Coefficient Matrix Table
Dividends table
Hull and White and LogNormal market model screen
Average and Standard Deviation table
Lognormal Vector Process (composite) table
Scenario Column Link table
Correlation Matrix Table
Investment Account Assumption Screens
UL Module Investment Account Assumption Screen
Investment Account Assumptions
Liability Category
BENCHMARK INTEREST Table
Competitors' i
Minimum cr i
Credited i
EXPENSE CHARGE Table
Expense benchmark
Benchmark interest spread table
COMMISSION Table
Transfers out
Required Capital Factors
Fund Type Option
Benchmark i method
Credited i options
M
Credited i interp
Per fund surrender charge
Fund shock percentage
Fund shock time
MVA spread
MVA adjustments
MVA Applies
MVA Method
X =
MVA rate basis
Investment Account Interest Bonus Formula Table
Portfolio Credited Interest Rate Formula Table
Par Module Investment Account Assumption Screen
Investment Account Assumptions
Liability Category
CREDITED INTEREST Table
Benchmark Rate Table
Benchmark Spread Table
Annuity Module Investment Account Assumption Screen
Investment Account Assumptions
Liability Category
Benchmark i
Competitors' i
Minimum cr i
Credited i
Exp charge
SF mgmt fees
Expense benchmark
Benchmark interest spread
Commission table
Transfers out
Required Capital Factors
Fund type
Benchmark i method
Credited i options
M
Credited i interp
Fee benchmark
Fund shock timing
X =
Fund shock percentage
MVA spread
MVA adjustments
MVA Applies
MVA method
X =
MVA rate basis
Investment Account Interest Bonus Formula Table
Portfolio Credited Interest Rate Formula Table
SFAS 97 Assumptions
SFAS 97 bonus interest treatment
CARVM Assumptions
AG33 SF mgmt fees
AG34 immediate drop
AG34 gross assumed return
Expense charge per fund for guaranteed living benefits for AG39
CARVM IA interest bonus treatment
Investment Account Interest Bonus Formula Table
Portfolio Credited Interest Rate Formula Table
C3 Phase II Standard Scenario Assumptions
C3 Phase II Fund Drop/Growth
C3 Phase II expense charge per fund for guaranteed benefits
C3 Phase II expense charge per fund for contract charges
AG43 (VA-CARVM) Standard Scenario Assumptions
AG43 (VA-CARVM) Fund Drop/Growth
Expense charge per fund for guaranteed living benefits
Expense charge per fund for guaranteed death benefits
Expense charge per fund for contract charges
Seg Fund Factor Method Assumptions
Distribution of Funds
Volatility
Available Offset
Group Annuity Module Investment Account Assumption Screen
Investment Account Assumptions
Liability Category
Benchmark i
Competitors' i
Minimum cr i
Credited i
Exp charge
SF mgmt fees
Expense benchmark
Benchmark interest spread
Commission table
Transfers out
Required Capital Factors
Fund skim X
Fund type
Benchmark i method
Credited i options
M
Credited i interp
Fund shock percentage
Fund shock time
Cert MVA sprd
MVA adjustments (certificate lapse)
Grp MVA sprd
MVA adjustments (group lapse)
MVA Applies - Cert Level
MVA method - cert level
X =
MVA method - group level lapses
Y =
MVA rate basis
CARVM Assumptions
AG33 SF mgmt fees
Log Normal Model Assumption Screen
LN Parameters
Number of Indices
Equity Total Return composite table
Dividends table
Average and Standard Deviation table
Lognormal Vector Process (composite) table
Scenario Column Link table
Index total return volatility table
Index total return drift table
Output
Scenario Column Link table
Average and Standard Deviation table
Lognormal Vector Process (composite) table
Dividends table
Index total return volatility table
Index total return drift table
Data for Fitting LN Process
Max number of observations
Data for fitting table
Matching Strategy Assumption Screen
Matching Method
Matching Method
Match Minimum (Units)
Target Cash Flows
Tax in Target Cash Flows
Accumulate target cash flows
Match Target Cash Flows Monthly for Y years
Match Target Cash Flows Using
Term Preference
Matching Assets
Matching Asset Type
Reinvestment subfunds
Allocation Table
Swap Parameters
Matching Asset Maximum Term
Maximum Term
General Assumptions
Asset Reporting Type (Matching)
Reporting Category
Reinvestment Category
Reinvestment category table
Liquidity Index
Accounting Information
Accounting Treatment
Reporting of AVR & IMR
AVR Factors
Tax Basis
Unrealized gains
Realized gains
Market Value and Duration
Market Value Method
Duration Calculation
Yield Spread
Yield Proportional Adjustment
Required Surplus
Required Surplus Factors
Office Assumption Screen
Results Calculated
RESULTS CALCULATED
Initial Asset Position
Capital Movements
SHAREHOLDER DIVIDEND
X =
INJECTION METHOD
Y =
YEAR
INJECTION ($K)
SH DIVIDEND ($K)
Investment Earnings
INVESTMENT EARNINGS
INTEREST RATE FOR CASHFLOW Table
INTEREST RATE FOR REINVESTMENT Table
INTEREST RATE FOR BORROWING Table
USE REINVESTMENT STRATEGY
General Account Liability Category
NET INVESTMENT INCOME RATE
MONTHLY PERIOD EARNED RATE
Earned rate validation
Lower rate bound
X =
Upper rate bound
Y =
Alternate rate
Capture earned rate
Capture earned rate asset base
Capture column
INTEREST ALLOCATION METHOD
REINVESTMENT STRATEGY OVERRIDE
N =
First Required Fund
REQUIRED SURPLUS
Z=
OFFICE TARGET RATIO
Prop of assets to include in RS
REQUIRED CAPITAL
Reserve used for required capital
RC Components Table
MCCSR Mortality Components Table
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
Proportion of Deferred Tax Adjustment Adjustment
MIN REQUIRED SURPLUS
B (in $million)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Second Required Fund
REQUIRED SURPLUS
Z=
OFFICE TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
Proportion of Deferred Tax Adjustment Adjustment
MIN REQUIRED SURPLUS
B (in $million)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Third Required Fund
REQUIRED SURPLUS
Z=
OFFICE TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
Proportion of Deferred Tax Adjustment Adjustment
MIN REQUIRED SURPLUS
B (in $million)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Interest Maintenance Reserve (IMR)
IMR Floor
Taxation
TAXATION METHOD
Corporate Tax Rate Table
BASIC TAX
TAX RATE ON CASHFLOW & RESERVES
ACCRUED TAX ($000's)
TAX RATE ON REQUIRED SURPLUS
ACCRUED TAX ($000's)
TAX RATE ON FREE SURPLUS
ACCRUED TAX ($000's)
CAPITAL TAX CALCULATION FORMULA
ADDITIONAL TAX
SURTAX ON CORPORATE TAX
LARGE CORPORATIONS TAX
PROPORTION OF IIT DEDUCTIBLE
DIFFERENTIAL EARNINGS RATE
Adjustment for future tax asset
X = ($k)
Statement DTL
TAX LOSS TREATMENT
X = (Amount of Tax Loss)
Y =
Z =
Historical tax loss carryforwards
DAC tax method
T
DAC CAPITALIZATION RATE
Historical DAC Tax Balances
Taxable amount calculation
DAC tax basis
DAC tax amortization period
Book Profit Financials
Book profit reserve
Book Profit required fund
HURDLE RATE
EMBEDDED VALUE
EMBEDDED VALUE
EMBEDDED VAL ADJUSTMENT
COLUMN 5 PROFIT MARGIN
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP financials
US GAAP required fund
US GAAP Asset Accounting Basis
Other Benefit Assumption Screens
Regular Module Other Benefit Assumption Screen
Other Benefit Assumptions
Processing Option
Benefit Amount Table
Premium Table
Commission Table
Benefit Definition
Other benefit coverage period
Other benefit maximum age
Other benefit maximum duration
Reporting Type
Decrement
Premium Rates
Reserve method
Proportion of earned benefit included in interpolated mean reserves
Proportion of earned benefit included in interpolated mid year CSV
UL Module Other Benefit Assumption Screen
Other Benefit Assumptions
Processing Option
Benefit Amount Table
Benefit Charge Table
Minimum Premium Table
NLG Test Premium Table
Benefit Size Table
Benefit Definition
Reporting Type
Decrement
Benefit NAAR method
Par Module Other Benefit Assumption Screen
Other Benefit Assumptions
Processing Option
Benefit Amount Table
Premium Table
Commission Table
Benefit Definition
Reporting Type
Decrement
Dividend
Extra Benefit
Proportion of Extra Benefit
Premium Rates
Proportion of earned benefit included in interpolated mean reserves
Proportion of earned benefit included in interpolated mid year CSV
Disability Module Other Benefit Assumption Screen
Other Benefit Assumptions
Processing Option
Benefit Amount Table
Premium Table
Commission Table
Benefit Definition
Reporting Type
Decrement
Premium Rates
Other Benefit Reduction
U =
Property set Assumption Screen
Range
Property set
Timing
Property set
Adjustments
Property set
Interest Rate
Property set
Regime Switching LN Model Assumption Screen
RSLN Parameters
Number of Indices
Equity Total Return composite table
Dividends table
Average and Standard Deviation table
Lognormal Vector Process (composite) table
Scenario Column Link table
Index total return volatility table
Index total return drift table
Output
Scenario Column Link table
Average and Standard Deviation table
Lognormal Vector Process (composite) table
Dividends table
Index total return volatility table
Index total return drift table
Data for Fitting RSLN Process
Max number of observations
Data for fitting table
Reinsurance Terms Assumption Screens
Regular Module Reinsurance Terms Assumption Screen
General
Reinsurance Treaty
Reinsurance method
Reinsurance period
N =
Transfer at reins period end
X =
Modco transfer frequency
Modco reserve
Modco interest rate table
Premiums
Premiums
Premium adjustment table
Policy fee table
Interest on premium table
Recapture charge
Recapture charge
Premium mode
Premium payable
Premium for joint
Premium for joint N
Premium Adjustment for Death
X=
Premium Adjustment for Lapse
Y=
Premium Adjustment for Other Benefit
Z=
Ceded premium tax assumptions
Premium tax rate X
Premium tax basis for reinsurance
Premium tax adj for ceded
Premium tax refund on reinsured business
Allowances
Commission table
Bonus & Chargeback Table
Locked in Commission Table
Locked in Bonus & Chargeback Table
Prop of Unearned Commission Chargeback on Death
Prop of Unearned Commission Chargeback on Lapse
Prop of Unearned Commission Chargeback on Other Benefit
Prop of Unearned Bonus Chargeback on Death
Prop of Unearned Bonus Chargeback on Lapse
Prop of Unearned Bonus Chargeback on Other Benefit
Policy fee prop commissionable
Benefits Reinsured
Face amount table
Cash Value Table
Dividend table
Other benefits table
Input factors
ROP benefit
ROP proportion
ROP basis
UL Module Reinsurance Terms Assumption Screen
General
Reinsurance Treaty
Reinsurance Method
Modco transfer frequency
Modco reserve
Modco interest rate table
Modco interest rate table
Premiums
Premiums
Recapture charge
Premium Mode
Prop of Unearned Prems Returned on Death
Prop of Unearned Prems Returned on Lapse
Premium Tax
Premium Tax Rate
Premium Tax Basis
Prem Tax Basis Adj
Earned Risk Charge for YRT
Allowances
Commission
BONUS & CHARGEBACK Table
Deferrable commission
Deferrable bonus & chargeback
Prop of Unearned Comm Chargeback on Death
Prop of Unearned Comm Chargeback on Lapse
Prop of Unearned Bonus Chargeback on Death
Prop of Unearned Bonus Chargeback on Lapse
Benefits Reinsured
Benefits reinsured
Face Amount Table
Other Benefits
Input factors
Maturity Value
W
Maximum face amount
Par Module Reinsurance Terms Assumption Screen
General
Reinsurance Treaty
Reinsurance method
Premiums
Premiums
Premium adjustment table
Policy fee table
Recapture charge
Recapture charge
Premium mode
Premium Adjustment for Death
X=
Prop of Unearned Prems Returned on Lapse
Premium Adjustment for Other Benefit
Ceded Premium Tax Assumptions
Premium tax rate
Premium tax basis for reinsurance
Premium tax adj for ceded
Premium tax refund on reinsured business
Allowances
Commission table
Bonus & Chargeback Table
Locked in Commission Table
Locked in Bonus & Chargeback Table
Prop of Unearned Commission Chargeback on Death
Prop of Unearned Commission Chargeback on Lapse
Prop of Unearned Commission Chargeback on Other Benefit
Prop of Unearned Bonus Chargeback on Death
Prop of Unearned Bonus Chargeback on Lapse
Prop of Unearned Bonus Chargeback On Other Benefits
Prop of policy fee commisionable
Benefits Reinsured
FACE AMOUNT Table
Cash Value Table
Other benefits table
ROP benefit
Disability Module Reinsurance Terms Assumption Screen
General
Reinsurance Treaty
Reinsurance method
Premiums
Premiums
Premiums
PREMIUM ADJUSTMENT Table
PREMIUM ADJUSTMENT Table
Policy fee table
Premium mode
Prop of Unearned Prems Returned on Lapse
Prop of Unearned Prems Returned on Other Benefit
Ceded Premium Tax Assumptions
PREMIUM TAX RATE FROM REINSURER
PREMIUM TAX BASIS CEDED
Premium tax adj for ceded
Premium tax refund on reinsured business
Allowances
COMMISSION Table
Commission table
Bonus & Chargeback Table
Bonus & Chargeback Table
Locked in Commission Table
Locked in Bonus & Chargeback Table
Prop of Unearned Commission Chargeback on Lapse
Prop of Unearned Commission Chargeback on Other Benefit
Prop of Unearned Bonus Chargeback on Lapse
Prop of Unearned Bonus Chargeback on Other Benefit
PROP COMMISSIONABLE
Benefits Reinsured
Disability Benefits
Cash Value Table
Cash Value Table
Other Benefits Table
ROP benefit
W =
Annuity Module Reinsurance Terms Assumption Screen
Processing
Treaty
Premium components
Aggregate premium minimums
Aggregate premium maximums
Claim coverage
Aggregate annual claim deductible
Aggregate annual claim limit
Gross claim
Gross claim offset
Reinsurance term annuitization premium
MORTALITY Annuity Table
2nd life Q Table
PROJECTION TABLE
2nd Life Projection Table
INTEREST Table
Reinsurance term annuitization premium - Use premium table below
Annuitization Premium Table
Claim coverage on death
Claim coverage on annuitization
Claim coverage on survivorship
Reinsurance Treaty Assumption Screen
Treaty Processing
Reinsurer status
Aggregate Reinsurance of Annuity Benefits
Aggregate annuity reinsurance coverage
Coverage Start
Coverage end
Standard scenario run
Premium frequency
Premium method
X =
Aggregate premium minimums
Aggregate premium maximums
Claim payment frequency
Aggregate claim deductible
Aggregate claim limit
Deductible/limit timing
Deductible/limit method
Final claims adjustment Formula Table
Final claim adjustment input X
Historical adjustments - Premium
Historical adjustments - Claim deductible/limit
Reinsurance Treaty - Aggregate Reins of Annuity Benefits
Claims since last deductible/limit
Reinvestment Strategy Assumption Screen
Reinvestment Method
N =
Reference Date
Designated Cashflow Reinvestment Method
FIXED AMOUNT REINVESTMENT
Initial Matching Strategy
M =
Initial Negative Method
K =
Allocation Method
Blended allocation table
Final Matching Strategy
Y =
Allocation Maximums
Negative Asset Sales
Min purchase or sale ($'s)
INTEREST RATE FOR CASHFLOW Table
INTEREST RATE FOR REINVESTMENT Table
INTEREST RATE FOR BORROWING Table
Liability Duration Method
D =
Asset Duration Method
Liability categories
Liability Duration Adjustment Table
Matching Duration Table
Allocation Maximums
Allocation Maximums Table
Allocation Maximums Frequency
N =
Designated Cashflow Allocation
Cash Allocation for Designated Cashflow Table
Designated Cashflow Allocation Table
Designated Cashflow Shortfall Method
Fixed Allocation
Fixed Amount Allocation Table
Units
Shortfall Method fixed amounts
Initial Negative Allocation
Initial Negative Allocation Switch
X =
Y =
Initial Negative Cashflow Allocation Table
Cashflow Allocation
Cashflow Allocation Table
Method For Negatives (Cashflow Allocation)
Target Allocation
Target Allocation Table
Target based on
First Level Targeting - Positive Cashflow
First Level Targeting - Negative Cashflow
Second Level Targeting
Additional Rebalancing
Special Case Allocations
SPECIAL CASE ALLOCATIONS
First and last year and month for Special Case tests
Special Cases 1 and 2
Threshold1
Threshold2
Test Rate Table
Reserve Method Assumption Screens
Regular Module Reserve Method Assumption Screen
General
Reserve Method
Limitation
Terminal reserve adjustment
Reserve for deferred tax
Statement DTL/DTA
Reserve for RPU/ETI
Additional limit for premium
Additional limit for premium (X =)
Residual margin method
Residual margin amortization basis
Term for reserves
Recognition of claims
Y =
Reserve lapses
Valuation mode
Valuation joint life status
Face Amount Adjustments
GAAP Valuation Premium
X =
Interest to DAC balance
DAC amortization pattern
DAC amortization period
DAC capitalization/asset floor
Maintenance expense reserve floor
GAAP valuation start date
Reinsurance treatment
Ceded DAC
Ceded GAAP maintenance compensation
Ceded compensation for DAC
CRVM/XXX premium deficiency
N =
CRVM/XXX nondeduction reserve
CRVM/XXX expense allowance
CRVM/XXX expense allowance premium
CRVM/XXX Expense allowance limit
CRVM/XXX Valuation Premium Cap
CRVM/XXX first year valuation premium
CRVM/XXX return of unearned premium
CRVM/XXX renewal amount of insurance
CRVM / SNFL Expense Amortization Period
M =
N =
CRVM/SNFL expense allowance basis
XXX deficiency reserves
XXX select factors
XXX time horizon
N =
XXX level policy fee
XXX Segment Mortality Ratio Adjustment Factor
Z =
XXX unitary/segmented
XXX fund CSV increase
XXX component terminal reserve limitation
XXX CSV floor
XXX tabular cost floor
XXX guaranteed premium adjustment
NAIC Details
Substandard method
Reserve for IIT
Reserve for dividend
Reserve for other benefit
Reserve for compensation
Reserve for capital charge
Policy fee treatment
Valuation premium tax
X =
LOC Amount Deduction
Generic reserve reference limit
Z
Generic reserve preliminary term period
Expense adjustment
Mean Reserves
Mean Reserve Method
Interpolation Timing
Time zero reserve
Premium basis for DPA/UEP
L
Modal loading for DPA/UEP
Proportional coinsurance DPA/UEP
PPM valuation premium
YRT reinsurance credit
Dividend adjustment
Earned dividend liabilities (X =)
Adjustment by unearned premiums
X =
Half cx mean reserve floor
UL Module Reserve Method Assumption Screen
General
Reserve Method
LIMITATION
Y =
Terminal reserve adjustment
Reserve for deferred tax
Statement DTL/DTA
Residual margin method
Residual margin amortization basis
Recognition of claims
SFAS 97 Unearned Revenue
SFAS97 URL amortization period
DAC amortization period
DAC capitalization/asset floor
Reinsurance Treatment
Negative Unearned Revenue
SFAS97 accum YTD values rate
Deficiency Reserve
SECONDARY GUARANTEE
CRVM GMF end point
K =
CRVM GMF amount at end point
CRVM FOR VARIABLE PLANS - EXPENSE CHARGE
CRVM FOR VARIABLE PLANS - SECONDARY GUARANTEE
CRVM / XXX /AG 37/AG 38 SELECT FACTORS
CRVM / XXX BASIC RESERVE
CRVM/XXX EXPENSE ALLOWANCE
CRVM/XXX EXPENSE ALLOWANCE PREMIUM
CRVM/XXX RENEWAL AMOUNT OF INSURANCE
CRVM/XXX FIRST YEAR VALUATION PREMIUM
CRVM/XXX Substandard Method
CRVM VALUATION PREMIUM MODE
CRVM tabular cost floor
XXX Segment Mortality Ratio Adjustment Factor
Z =
XXX Unitary Reserves
XXX Notional Account Frequency Of Charges
XXX Notional Account Minimally Funded Risk Charge
XXX NA Premium Load
AG 38 adjustment
L =
AG 38 Single Payment Solver
AG 37 Payment Term
AG 37 Limitation Application
Reserve for IIT
Reserve for Other Benefit
Reserve for compensation
Valuation premium tax
X =
Mean Reserves
Mean Reserve Method
TIME ZERO RESERVE
Reinsurance credit for mean reserve
FUND/CSV BASED RESERVES
Par Module Reserve Method Assumption Screen
General
Reserve Method
RESERVE APPROACH
LIMITATION
Reserve for deferred tax
Statement DTL/DTA
Additional limit for premium
Additional limit for premium (X =)
Residual margin method
Residual margin amortization basis
RECOGNITION OF CLAIMS
Percentage of yearly interest credited
RESERVE LAPSES
Valuation mode
Face Amount Adjustments - Use optional adjustments
DAC treatment
Interest to DAC balance
DAC amortization pattern
DAC amortization period
DAC capitalization/asset floor
Maintenance expense reserve floor
FAS 120 Terminal Dividend Liability
Reinsurance treatment
Ceded DAC
Ceded GAAP maintenance compensation
Ceded compensation for DAC
CRVM Premium Deficiency
N =
CRVM expense allowance
CRVM expense allowance premium
CRVM first year valuation premium
CRVM renewal amount of insurance
CRVM / SNFL Expense Amortization Period
M =
N =
CRVM/SNFL expense allowance basis
NAIC Details
Substandard method
Reserve for IIT
RESERVE FOR OTHER BENEFIT
N =
Reserve for compensation
Policy fee treatment
Valuation premium tax
X =
Generic reserve reference limit
Z
Generic reserve preliminary term period
Expense adjustment
OYT reserve method
Y =
Additional dividend liability
X =
Mean Reserves
Mean Reserve Method
Interpolation Timing
PUA/Accumulated Mean Method
TIME ZERO RESERVE
Premium basis for DPA/UEP
L
Modal loading for DPA/UEP
Proportional coinsurance DPA/UEP
YRT REINSURANCE CREDIT
Reserve for unearned OYT
Dividend adjustment
Provision for regular dividend (X =)
PUA Dividend adjustment
PUA Dividend adjustment (Y =)
Disability Module Reserve Method Assumption Screen
General (ALR)
DLR METHOD
LIMITATION
Reserve for deferred tax
Statement DTL/DTA
Additional limit for premium
Additional limit for premium (X =)
GAAP valuation mode
INTEREST TO DAC BALANCE
DAC AMORTIZATION PATTERN
DAC amortization period
DAC capitalization/asset floor
Maintenance expense reserve floor
GAAP valuation start date
Reinsurance treatment
Ceded DAC
Ceded GAAP maintenance compensation
Ceded compensation for DAC
Premium deficiency
N =
NAIC details
Substandard method
SPP Issue Fee For Unearned Premium
Reserve for compensation
Valuation premium tax
X =
Generic reserve expense limit
Generic reserve expense limit (X =)
Generic reserve preliminary term period
Mean Reserves (ALR)
Mean Reserve Method
Interpolation Timing
TIME ZERO RESERVE
Premium basis for DPA/UEP
L
Modal loading for DPA/UEP
Proportional coinsurance DPA/UEP
PPM VALUATION PREMIUM
YRT REINSURANCE CREDIT
Disabled Life Reserves
DLR METHOD - no reserves
X =
DLR deferred tax liability
Annuity Module Reserve Method Assumption Screen
General
Reserve Method
LIMITATION
Reserve for deferred tax
Statement DTL/DTA
SFAS 97 premium bonus treatment
DAC/SIA amortization period
DAC/SIA floor
CARVM CSV testing
CARVM 93% floor
CARVM annuitization treatment - Ignore Annuitization Benefit
CARVM AG39 Treatment
CARVM fund bonus treatment
CARVM expense charges
AG43 standard scenario GLB margin
AG43 standard scenario GMDB margin
Fund base reserve
Valuation premium tax
X =
Scenario reserve
N =
Initial total asset requirement
Scenarios
Fund shock
Base for interpolation
Method for interpolation
Group Annuity Module Reserve Method Assumption Screen
General
METHOD
Reserve for deferred tax
% seg fund value in reserve
DAC amortization period
DAC COMMISSIONS
N =
CARVM CSV testing
CARVM seg fund treatment
CARVM 93% fund floor
Scenario Processing Screen Assumption Screen
Yield Curve
Stock And Real Estate Index
Default
Inflation
Portfolio Rate
Total Rates Of Return
User Defined Rates
Forward Rate Extrapolation
Subfund Assumption Screens
Regular Module Subfund Assumption Screen
Subfund Type
Subfund type
Duration Cashflow Adjustments
Yield Spread table
Yield Proportionate Adjustment table
Initial Asset Position
METHOD OF INPUT
INITIAL FREE SURPLUS
INITIAL LIFE FUND
RETAINED EARNINGS
Investment Earnings
INVESTMENT EARNINGS
CALENDAR YEAR INTEREST RATE TABLE
Additional Cashflow
ADDITIONAL CASHFLOW
Monthly Cashflow Definition
Monthly Cashflow Table link
CASHFLOW TABLE
MONTHLY CASHFLOW TABLE UNITS
RESERVES
INITIAL RESERVE
Discount rate table
Expenses
EXPENSES
WHICH YR:
EXPENSE:
Floor for LOC expense
Capital Charge
CAPITAL CHARGE ADJUSTMENT TABLE
Reserves
DTL ADJUSTMENT
First Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
Reserve used for required capital
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Second Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Third Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Investment Income Tax
INVESTMENT INCOME TAX
IIT RATE
IIT FACTOR
BOND YIELD RATE
ADJUSTMENT TO RATE
L =
Taxation
TAXATION METHOD
Corporate Tax Rate Table
TAX RATE ON CASHFLOW & RESERVES
ACCRUED TAX ($000's)
TAX RATE ON REQUIRED SURPLUS
ACCRUED TAX ($000's)
TAX RATE ON FREE SURPLUS
ACCRUED TAX ($000's)
PROPORTION OF IIT DEDUCTIBLE
DIFFERENTIAL EARNINGS RATE
Premium tax adjustment
TAX LOSS TREATMENT
X = (AMOUNT OF TAX LOSS)
Y =
Z =
Historical tax loss carryforwards
DAC tax method
T
DAC CAPITALIZATION RATE
Historical DAC Tax Balances
Taxable amount calculation
DAC tax basis
DAC tax amortization period
Experience Refund
Experience refund method
N =
Random seed specification
H = / L =
ER discount rate
Stochastic generate formula
Experience refund formula
Additional Reserve Adjustment
Claim fluctuation reserve ($000's)
Loss carry forward ($000's)
Reserve adjustment ($000's)
Book Profit Financials
Book profit reserve table
Book Profit required fund
RESERVE STRENGTHEN
DTL ADJUSTMENT
DTL ADJUSTMENT APPLIES
Statement DTL/DTA
HURDLE RATE
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
COLUMN 5 PROFIT MARGIN
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP financials
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
Value of Business Acquired
Amortization method
K factor for VOBA
Amortization base
DAC Recalculation
K factor for DAC
VOBA AMOUNT ($millions)
Amortization limit (years)
Amortization limit (months)
Amortization Table
Amortization Rate Table
UL Module Subfund Assumption Screen
Subfund Type
Subfund type
Duration Cashflow Adjustments
Yield Spread table
Yield Proportionate Adjustment table
Initial Asset Position
METHOD OF INPUT
INITIAL FREE SURPLUS
INITIAL LIFE FUND
RETAINED EARNINGS
Investment Earnings
INVESTMENT EARNINGS
CALENDAR YEAR INTEREST RATE TABLE
INV ACCT INCOME ADJ
Additional Cashflow
ADDITIONAL CASHFLOW
Monthly Cashflow Definition
Monthly Cashflow Table link
CASHFLOW TABLE
MONTHLY CASHFLOW TABLE UNITS
RESERVES
INITIAL RESERVE
Discount rate table
Expenses
EXPENSES
WHICH YR:
EXPENSE:
Floor for LOC expense
Reserves
DTL ADJUSTMENT
Capital Charge
CAPITAL CHARGE ADJUSTMENT TABLE
First Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
Reserve used for required capital
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Second Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Third Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Investment Income Tax
INVESTMENT INCOME TAX
IIT RATE
IIT FACTOR
BOND YIELD RATE
ADJUSTMENT TO RATE
L =
Taxation
TAXATION METHOD
Corporate Tax Rate Table
TAX RATE ON CASHFLOW & RESERVES
ACCRUED TAX ($000's)
TAX RATE ON REQUIRED SURPLUS
ACCRUED TAX ($000's)
TAX RATE ON FREE SURPLUS
ACCRUED TAX ($000's)
PROPORTION OF IIT DEDUCTIBLE
Premium tax adjustment
TAX LOSS TREATMENT
X = (AMOUNT OF TAX LOSS)
Y =
Z =
Historical tax loss carryforwards
DAC tax method
DAC CAPITALIZATION RATE
Historical DAC Tax Balances
Taxable amount calculation
DAC tax basis
DAC tax amortization period
Book Profit Financials
Book profit reserve table
Book Profit required fund
DTL ADJUSTMENT
DTL ADJUSTMENT APPLIES
Statement DTL/DTA
HURDLE RATE
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
COLUMN 5 PROFIT MARGIN
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP financials
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
US GAAP Unlocking
Unlock DAC / URL
Reinsurance Treatment
DAC k Factor
URL k Factor
SOP 03-1 additional liability
SOP 03-1 EGP interest adj
Amortization Rate Table
US GAAP cohort inforce info table
US GAAP Historical Results
Value of Business Acquired
Amortization method
K factor for VOBA
Amortization base
DAC Recalculation
K factor for DAC
VOBA AMOUNT ($millions)
Amortization limit (years)
Amortization limit (months)
Amortization Table
Amortization Rate Table
Par Module Subfund Assumption Screen
Subfund Type
Subfund type
Duration Cashflow Adjustments
Yield Spread table
Yield Proportionate Adjustment table
Initial Asset Position
METHOD OF INPUT
INITIAL FREE SURPLUS
INITIAL LIFE FUND
RETAINED EARNINGS
Investment Earnings
INVESTMENT EARNINGS
CALENDAR YEAR INTEREST RATE TABLE
Additional Cashflow
ADDITIONAL CASHFLOW
Monthly Cashflow Definition
Monthly Cashflow Table link
CASHFLOW TABLE
MONTHLY CASHFLOW TABLE UNITS
RESERVES
INITIAL RESERVE
Discount rate table
Expenses
EXPENSES
WHICH YR:
EXPENSE:
Reserves
DTL ADJUSTMENT
First Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
Reserve used for required capital
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Second Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Third Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
MCCSR Mortality Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
C1 To C4 RC Components Table
Investment Income Tax
INVESTMENT INCOME TAX
IIT RATE
IIT FACTOR
BOND YIELD RATE
ADJUSTMENT TO RATE
L =
Taxation
TAXATION METHOD
Corporate Tax Rate Table
TAX RATE ON CASHFLOW & RESERVES
ACCRUED TAX ($000's)
TAX RATE ON REQUIRED SURPLUS
ACCRUED TAX ($000's)
TAX RATE ON FREE SURPLUS
ACCRUED TAX ($000's)
PROPORTION OF IIT DEDUCTIBLE
Premium tax adjustment
TAX LOSS TREATMENT
X = (AMOUNT OF TAX LOSS)
Y =
Z =
Historical tax loss carryforwards
DAC tax method
DAC CAPITALIZATION RATE
Historical DAC Tax Balances
Taxable amount calculation
DAC tax basis
DAC tax amortization period
Shareholder Dividend
SHAREHOLDER DIVIDEND
X =
Book Profit Financials
Book profit reserve table
Book Profit required fund
RESERVE STRENGTHEN
DTL ADJUSTMENT
Statement DTL/DTA
HURDLE RATE
EMBEDDED VALUE: SHAREHOLDER DIVIDEND
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
COLUMN 5 PROFIT MARGIN
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP financials
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
US GAAP Unlocking
Withdrawals - Treat withdrawal (pro-rata) as negative premium deposit
Amortization Rate Table
US GAAP cohort inforce info table
US GAAP Historical Results
Value of Business Acquired
Amortization method
K factor for VOBA
Amortization base
DAC Recalculation
K factor for DAC
VOBA AMOUNT ($millions)
Amortization limit (years)
Amortization limit (months)
Amortization Table
Amortization Rate Table
Disability Module Subfund Assumption Screen
Subfund Type
Subfund type
Duration Cashflow Adjustments
Yield Spread table
Yield Proportionate Adjustment table
Initial Asset Position
METHOD OF INPUT
INITIAL FREE SURPLUS
INITIAL LIFE FUND
RETAINED EARNINGS
Investment Earnings
INVESTMENT EARNINGS
CALENDAR YEAR INTEREST RATE TABLE
Additional Cashflow
ADDITIONAL CASHFLOW
Monthly Cashflow Definition
Monthly Cashflow Table link
CASHFLOW TABLE
MONTHLY CASHFLOW TABLE UNITS
RESERVES
INITIAL RESERVE
Discount rate table
Expenses
EXPENSES
WHICH YR:
EXPENSE:
Capital Charge
CAPITAL CHARGE ADJUSTMENT TABLE
Reserves
DTL ADJUSTMENT
First Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
Reserve used for required capital
RC Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Second Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Third Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
LAPSE RISK COMPONENT
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MAX NEGATIVE RESERVE REDUCTION AS A PROPORTION OF TIER 1 (MCCSR)
PROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENT
COMPONENT FOR UNREGISTERED REINSURANCE
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Taxation
TAXATION METHOD
Corporate Tax Rate Table
TAX RATE ON CASHFLOW & RESERVES
ACCRUED TAX ($000's)
TAX RATE ON REQUIRED SURPLUS
ACCRUED TAX ($000's)
TAX RATE ON FREE SURPLUS
ACCRUED TAX ($000's)
Premium tax adjustment
TAX LOSS TREATMENT
X = (AMOUNT OF TAX LOSS)
Y =
Z =
Historical tax loss carryforwards
DAC tax method
DAC CAPITALIZATION RATE
Historical DAC Tax Balances
Taxable amount calculation
DAC tax basis
DAC tax amortization period
Experience Refund
Experience refund method
N =
Random seed specification
H = / L =
ER discount rate
Stochastic generate formula
Experience refund formula
Additional Reserve Adjustment
Claim fluctuation reserve ($000's)
Loss carry forward ($000's)
Reserve adjustment ($000's)
Book Profit Financials
Book profit reserve table
Book Profit required fund
DTL ADJUSTMENT
Statement DTL/DTA
HURDLE RATE
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
COLUMN 5 PROFIT MARGIN
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP financials
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
Value of Business Acquired
Amortization method
K factor for VOBA
Amortization base
DAC Recalculation
K factor for DAC
VOBA AMOUNT ($millions)
Amortization limit (years)
Amortization limit (months)
Amortization Table
Amortization Rate Table
Asset/Reinv Module Subfund Assumption Screen
Subfund Type
Liability Category
Subfund type
Duration Cashflow Adjustment
Yield Spread table
Yield Proportionate Adjustment table
Additional Cashflow
ADDITIONAL CASHFLOW
Monthly Cashflow Table link
ASSET CASHFLOW TABLE
MONTHLY CASHFLOW TABLE UNITS
Reporting Category
Reinvestment Category
REPORTING TYPE
ASSET VALUES
INITIAL ASSET VALUE
I =
IMR / Amortization Amounts (millions)
IMR amortization schedule
Bond And Mortgage Amortization Table
SHARES DEFERRED REALIZED GAIN
SHARES - TAX EXEMPT % OF AMORTIZATION OF DEFERRED REALIZED GAIN
REAL ESTATE DEFERRED REALIZED GAIN
REAL ESTATE - TAX EXEMPT % OF AMORTIZATION OF DEFERRED REALIZED GAIN
Asset accounting basis
Reporting Category
Reinvestment Category
Additional Cash Balance
ADDITIONAL CASH BALANCE
YEARS OF ADDITIONAL CASH BALANCE
AMOUNTS OF ADDITIONAL CASH BALANCE
Reporting Category
Reinvestment Category
Investment Expenses
INVESTMENT EXPENSES
INVESTMENT EXPENSE
Reporting Category
Fee Income
Fee income table
Required Surplus
REQUIRED SURPLUS
Z =
SUBFUND TARGET RATIO
REQUIRED SURPLUS FACTORS
Factor for impaired asset write-downs
Reinv Module Subfund Assumption Screen
General
Duration Cashflow Adjustment
Yield Spread table
Yield Proportionate Adjustment table
Investment Expenses
INVESTMENT EXPENSES
INVESTMENT EXPENSE
Reporting Category
Fee Income
Fee income table
Required Surplus
REQUIRED SURPLUS
Z =
SUBFUND TARGET RATIO
REQUIRED SURPLUS FACTORS
Annuity Module Subfund Assumption Screen
Subfund Type
Subfund type
Reinsurance Treaties
Duration Cashflow Adjustments
Yield Spread table
Yield Proportionate Adjustment table
Initial Asset Position
METHOD OF INPUT
INITIAL FREE SURPLUS
INITIAL LIFE FUND
RETAINED EARNINGS
Investment Earnings
INVESTMENT EARNINGS
CALENDAR YEAR INTEREST RATE TABLE
GAIN/LOSS INCOME ADJ
INV ACCT INCOME ADJ
Additional Cashflow
ADDITIONAL CASHFLOW
Monthly Cashflow Definition
Monthly Cashflow Table link
CASHFLOW TABLE
MONTHLY CASHFLOW TABLE UNITS
RESERVES
INITIAL RESERVE
Discount rate table
Expenses
EXPENSES
WHICH YR:
EXPENSE:
Reserves
DTL ADJUSTMENT
First Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
Reserve used for required capital
RC Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Second Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Third Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
Proportion of Deferred Tax Adjustment Adjustment
Components for DTA
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Taxation
TAXATION METHOD
Corporate Tax Rate Table
TAX RATE ON CASHFLOW & RESERVES
ACCRUED TAX ($000's)
TAX RATE ON REQUIRED SURPLUS
ACCRUED TAX ($000's)
TAX RATE ON FREE SURPLUS
ACCRUED TAX ($000's)
TAX LOSS TREATMENT
X = (AMOUNT OF TAX LOSS)
Y =
Z =
Historical tax loss carryforwards
DAC tax method
DAC CAPITALIZATION RATE
Historical DAC Tax Balances
Taxable amount calculation
DAC tax basis
DAC tax amortization period
Book Profit Financials
Book profit reserve table
Book Profit required fund
DTL ADJUSTMENT
DTL ADJUSTMENT APPLIES
Statement DTL/DTA
HURDLE RATE
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
COLUMN 5 PROFIT MARGIN
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP financials
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
US GAAP Unlocking
Unlock DAC / SIA / URL
DAC / SIA k factor
URL k Factor
Amortization Rate Table
US GAAP cohort inforce info table
US GAAP Historical Results
Value of Business Acquired
Amortization method
K factor for VOBA
Amortization base
VOBA AMOUNT ($millions)
Amortization limit (years)
Amortization limit (months)
Amortization Table
Amortization Rate Table
Group Annuity Module Subfund Assumption Screen
Subfund Type
Subfund type
Duration Cashflow Adjustments
Yield Spread table
Yield Proportionate Adjustment table
Initial Asset Position
METHOD OF INPUT
INITIAL FREE SURPLUS
INITIAL LIFE FUND
RETAINED EARNINGS
Investment Earnings
INVESTMENT EARNINGS
CALENDAR YEAR INTEREST RATE TABLE
INV ACCT INCOME ADJ
Additional Cashflow
ADDITIONAL CASHFLOW
Monthly Cashflow Definition
Monthly Cashflow Table link
CASHFLOW TABLE
MONTHLY CASHFLOW TABLE UNITS
RESERVES
INITIAL RESERVE
Discount rate table
Expenses
EXPENSES
WHICH YR:
EXPENSE:
DAC Recalculation
DAC Recalculation
Reserves
DTL ADJUSTMENT
First Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
Reserve used for required capital
RC Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Second Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Third Required Fund
REQUIRED SURPLUS
Z=
SUBFUND TARGET RATIO
REQUIRED CAPITAL
RC Components Table
CASH VALUE DEFICIENCIES
Negative Reserves adjusted by Net Actuarial Reserve
LIMITS ON AVAILABLE CAPITAL
TREATMENT OF NEGATIVE AND CV DEFICIENCY
MAXIMUM TIER 2
MAX NEGATIVE RES IN TIER 2
MIN REQUIRED SURPLUS
B (in $mill)
C% of CV Deficiency and Negative Reserves
Taxation
TAXATION METHOD
Corporate Tax Rate Table
TAX RATE ON CASHFLOW & RESERVES
ACCRUED TAX ($000's)
TAX RATE ON REQUIRED SURPLUS
ACCRUED TAX ($000's)
TAX RATE ON FREE SURPLUS
ACCRUED TAX ($000's)
TAX LOSS TREATMENT
X = (AMOUNT OF TAX LOSS)
Y =
Z =
Historical tax loss carryforwards
DAC tax method
DAC CAPITALIZATION RATE
Historical DAC Tax Balances
DAC tax basis
DAC tax amortization period
Book Profit Financials
Book Profit required fund
DTL ADJUSTMENT
HURDLE RATE
EMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUS
EMBEDDED VAL ADJUSTMENT
COLUMN 5 PROFIT MARGIN
NAIC Financials
NAIC Financials
NAIC required surplus
US GAAP Financials
US GAAP financials
US GAAP required fund
Alternative Financials
Alternative financials
Alternative financial required surplus
X =
Y =
Z =
Alternative financials required surplus interest rate
User Defined Stochastic Model Assumption Screen
Model Description
User Defined Stochastic Market Model
Average and Standard Deviation table
Lognormal Vector Process (composite) table
Dividends table
Scenario Column Link table
Index total return volatility table
Index total return drift table
AXIS Reports
Policy Year Results
Regular Module Policy Year Results
General Policy Year Results Help
Gross Premium
Commission & Bonus
Chargeback
Death Benefit
Surrender Benefit
Dividends
Other Benefits 1 to 4
Premium Tax
General Expense
IIT
Ceded Cashflow
Net Cashflow
Investment Income
Increase in Statutory Reserve
Income Tax
Book Profit
After Tax Income on Required Surplus
After Tax Income on Free Surplus
Contribution to Free Surplus
Embedded Value
No of Lives YS
Actual Face YS
Tax Reserve
Total Statutory Reserve
Statutory Deficiency Reserve
Second Reserve
Required Surplus
Asset Share
GAAP Benefit reserve
DAC capitalized
DAC amortized
DAC balance
GAAP equity
Pre tax GAAP income
Deferred tax liability
After Tax GAAP income
Return on Equity (%)
Ceded Premium
Statutory Deferred Tax Liability
Second Deferred Tax Liability
Third Deferred Tax Liability
Fourth Deferred Tax Liability
Fifth Deferred Tax Liability
Letter of Credit Expense
Letter of Credit Amount
No of Lives YE
Actual Face YE
Nominal Face YS
Nominal Face YE
Third Reserve
Fourth Reserve
Fifth Reserve
Statutory other benefit reserve
Second other benefit reserve
Third other benefit reserve
Fourth other benefit reserve
Fifth other benefit reserve
Tax other benefit reserve
Reserve details other benefit reserve 1
Reserve details other benefit reserve 2
Reserve details other benefit reserve 3
Reserve details other benefit reserve 4
ROP to Survivors
PRICING RESULTS SUMMARY
Fixed Summary Report
Cashflow Options
Cashflow Per $ Million Actual Initial Face
Cashflow per $ Thousand Nominal Initial Face
Cashflow per $ Thousand Nominal Face at Year Start
Cashflow per $ Thousand Nominal Face at Year End
Cashflow Per Initial Policy
Cashflow Per Policy at Year Start
Cashflow per Policy at Year End
Cashflow Per $1000 Initial Premium
Cashflow Per $1000 Premium at Year Start
Cashflow Per $ Million Actual Face at Year Start
Cashflow per $ Million Actual Face at Year End
Cashflow Per $ Thousand Actual Initial Face
Cashflow Per $ Thousand Actual Face at Year Start
Cashflow per $ Thousand Actual Face at Year End
Cashflow per $ Million Nominal Initial Face
Cashflow per $ Million Nominal Face at Year Start
Cashflow Per $ Million Nominal Face at Year End
Approx P.V. To Date Per $ Million Initial Actual Face
Approx P.V. To Date Per $ Thousand Initial Actual Face
Approx P.V. To Date Per Initial Policy
Approx P.V. To Date / P.V. of Premium To Date %
Approx P.V. To Date / P.V. Of All Premiums %
Approx P.V. To Date / P.V. of Actual Face Amount To Date (Per Thou)
Approx P.V. To Date / P.V. Of All Actual Face Amount (Per Thou)
UL Module Policy Year Results
General Policy Year Results Help
Gross Premium
Commission & Bonus
Chargeback
Death Benefit
Surrender Benefit
Other Benefit 1
Other Benefit 2
Other Benefit 3
Other Benefit 4
Premium Tax
General Expense
IIT
Ceded Cashflow
Net Cashflow
Investment Income
Increase in Statutory Reserve
Income Tax
Book Profit
After Tax Income on Required Surplus
After Tax Income on Free Surplus
Contribution to Free Surplus
Embedded Value
No of Lives YS
Actual Face YS
Fund at Year End
Tax Reserve
Statutory Reserve
Second Reserve
Third Reserve
Fourth Reserve
Fifth Reserve
Required Surplus
Asset Share
Mortality Charge
Mortality Actual
Expense Charge
Expense Actual
Interest Credited
Interest Actual
Source Of Profit Mortality
Source Of Profit Expense
Source Of Profit Interest
Source Of Profit Surrenders
Source Of Profit Bonus
Source Of Profit Other
Seg Fund Fees Received
Ceded Premium
Statutory Deferred Tax Liability
Second Deferred Tax Liability
Third Deferred Tax Liability
Transfer From Side Fund
Side Fund Year End
Transfer From Seg Fund
Adjustment to Fund Value
No of Lives YE
Actual Face YE
Nominal Face YS
Nominal Face YE
Statutory Deficiency Reserve
Letter of Credit Amount
Letter of Credit Expense
Fourth Deferred Tax Liability
Fifth Deferred Tax Liability
PRICING RESULTS SUMMARY
Fixed Summary Report
Cashflow Options
Cashflow Per $ Million Actual Initial Face
Cashflow per $ Thousand Nominal Initial Face
Cashflow per $ Thousand Nominal Face at Year Start
Cashflow per $ Thousand Nominal Face at Year End
Cashflow Per Initial Policy
Cashflow Per Policy at Year Start
Cashflow per Policy at Year End
Cashflow Per $1000 Initial Premium
Cashflow Per $1000 Premium at Year Start
Approx P.V. To Date Per $ Million Initial Actual Face
Approx P.V. To Date Per $ Thousand Initial Actual Face
Cashflow Per $ Million Actual Face at Year Start
Approx P.V. To Date Per Initial Policy
Approx P.V. To Date / P.V. of Premium To Date %
Approx P.V. To Date / P.V. Of All Premiums %
Approx P.V. To Date / P.V. of Actual Face Amount To Date (Per Thou)
Approx P.V. To Date / P.V. Of All Actual Face Amount (Per Thou)
Cashflow per $ Million Actual Face at Year End
Cashflow Per $ Thousand Actual Initial Face
Cashflow Per $ Thousand Actual Face at Year Start
Cashflow per $ Thousand Actual Face at Year End
Cashflow per $ Million Nominal Initial Face
Cashflow per $ Million Nominal Face at Year Start
Cashflow Per $ Million Nominal Face at Year End
Par Module Policy Year Results
General Policy Year Results Help
Gross Premium
Commission & Bonus
Chargeback
Death Benefit
Surrender Benefit
Other Benefits 1 to 4
Dividend
Terminal Dividend
Surrender Dividend
Premium Tax
General Expense
IIT
Ceded Cashflow
Net Cashflow
Investment Income
Increase in Statutory Reserve
Income Tax
Book Profit
After Tax Income on Required Surplus
After Tax Income on Free Surplus
Shareholder Dividend
Contribution to Free Surplus
Embedded Value
No of Lives YS
Actual Face YS
Required Surplus
Tax Reserve
Statutory Reserve
Second Reserve
Third Reserve
Fourth Reserve
Fifth Reserve
Asset Share
Ceded Premium
Statutory Deferred Tax Liability
Second Deferred Tax Liability
Third Deferred Tax Liability
No of Lives YE
Actual Face YE
Nominal Face YS
Nominal Face YE
Fourth Deferred Tax Liability
Fifth Deferred Tax Liability
PRICING RESULTS SUMMARY
Fixed Summary Report
Cashflow Options
Cashflow Per $ Million Actual Initial Face
Cashflow per $ Thousand Nominal Initial Face
Cashflow per $ Thousand Nominal Face at Year Start
Cashflow per $ Thousand Nominal Face at Year End
Cashflow Per Initial Policy
Cashflow Per Policy at Year Start
Cashflow per Policy at Year End
Cashflow Per $1000 Initial Premium
Cashflow Per $1000 Premium at Year Start
Approx P.V. To Date Per $ Million Initial Actual Face
Approx P.V. To Date Per $ Thousand Initial Actual Face
Cashflow Per $ Million Actual Face at Year Start
Approx P.V. To Date Per Initial Policy
Approx P.V. To Date / P.V. of Premium To Date %
Approx P.V. To Date / P.V. Of All Premiums %
Approx P.V. To Date / P.V. of Actual Face Amount To Date (Per Thou)
Approx P.V. To Date / P.V. Of All Actual Face Amount (Per Thou)
Cashflow per $ Million Actual Face at Year End
Cashflow Per $ Thousand Actual Initial Face
Cashflow Per $ Thousand Actual Face at Year Start
Cashflow per $ Thousand Actual Face at Year End
Cashflow per $ Million Nominal Initial Face
Cashflow per $ Million Nominal Face at Year Start
Cashflow Per $ Million Nominal Face at Year End
Disability Module Policy Year Results
General Policy Year Results Help
Gross Premium
Commission & Bonus
Chargeback
Paid Claims Causes 1, 2 & 3
Other Benefits 1 to 4
Surrender Benefit
Premium Tax
General Expense
Ceded Cashflow
Net Cashflow
Investment Income
Increase in Statutory Active Life Reserve
Increase in Statutory Disabled Life Reserve
Income Tax
Book Profit
After Tax Income on Required Surplus
After Tax Income on Free Surplus
Contribution to Free Surplus
Embedded Value
Active Lives YS
Initial Benefit YS
Statutory Active Life Reserve
Second Active Life Reserve
Third Active Life Reserve
Fourth Active Life Reserve
Fifth Active Life Reserve
Tax Reserves
Statutory Disabled Life Reserve
Second Disabled Life Reserve
Third Disabled Life Reserve
Fourth Disabled Life Reserve
Fifth Disabled Life Reserve
Required Surplus
Asset Share
Number of New Claims
Terminations from Disabled Status
Disabled Lives YE
Recoveries Returning to Active Status
Decrement Due to Lapses
Decrement Due to Other Benefit
Active Lives YE
Incurred Claims
Paid Claim Loss Ratio
Loss Ratio
PV Loss Ratio
GAAP Benefit reserve
DAC capitalized
DAC amortized
DAC balance
GAAP Equity
Pre Tax GAAP income
Deferred Tax Liability
After Tax GAAP income
Return on Equity (%)
Ceded Premium
`Active Life Reserve - Deferred Tax Liability (Statutory)
Second Deferred Tax Liability - Active Life Reserve
Third Deferred Tax Liability - Active Life Reserve
Fourth Deferred Tax Liability - Active Life Reserve
Fifth Deferred Tax Liability - Active Life Reserve
Statutory Deferred Tax Liability - Disabled Life Reserve
Second Deferred Tax Liability - Disabled Life Reserve
Third Deferred Tax Liability - Disabled Life Reserve
Fourth Deferred Tax Liability - Disabled Life Reserve
Fifth Deferred Tax Liability - Disabled Life Reserve
Death Benefit
Total Lives YE
Initial Benefit YE
ROP to Survivors
PRICING RESULTS SUMMARY
Fixed Summary Report
Cashflow Options
Cashflow Per $ 100,000 Initial Monthly Benefit
Cashflow Per $1000 Initial Premium
Cashflow Per $1000 Premium at Year Start
Approx P.V. To Date Per $ 100,000 Initial Monthly Benefit
Approx P.V. To Date Per $ 100 Initial Monthly Benefit
Approx P.V. To Date Per Initial Policy
Approx P.V. To Date / P.V. of Premium To Date %
Cashflow Per $ 100,000 Monthly Benefit at Year Start
Cashflow per $100,000 Monthly Benefit at Year End
Cashflow Per $ 100 Initial Monthly Benefit
Cashflow Per $ 100 Monthly Benefit Year Start
Cashflow per $100 Monthly Benefit at Year End
Cashflow Per Initial Policy
Cashflow Per Active Policy at Year Start
Cashflow per Active Policy at Year End
Approx P.V. To Date / P.V. Of All Premiums %
Annuity Module Policy Year Results
General Policy Year Results Help
Gross Premium
Commissions
Scheduled Withdrawal
`Surrender Benefit
Annuitized Benefit
Annuity Payout
Death Benefit
Premium Tax
General Expense
Segregated Fund Fees
Gross Cashflow
Investment Income
Increase In Statutory Reserve
Income Tax
Book Profit
After Tax Income On Required Surplus
After Tax Income On Free Surplus
Contribution To Free Surplus
Embedded Value
No Of Lives (Accum) YS
No Of Lives (Payout) YS
Fund At Year End
CSV At Year End
Statutory Reserve
Second Reserve
Third Reserve
Fourth Reserve
Fifth Reserve
Tax Reserve
Required Surplus
Asset Share
Maturity Benefit
Deferred Payout
Transfer From Seg Fund
No of Lives (Accum) YE
No of Lives (Payout) YE
Deferred Tax Liability (Stat)
Deferred Tax Liability (Scnd)
Deferred Tax Liability (3rd)
Deferred Tax Liability (4th)
Deferred Tax Liability (5th)
Chargeback
PRICING RESULTS SUMMARY
Fixed Summary Report
Cashflow Options
Cashflow Per Initial Policy
Cashflow Per Policy at Year Start
Cashflow per Policy at Year End
Cashflow Per $1000 Initial Premium
Cashflow Per $1000 Premium at Year Start
Approx P.V. To Date Per Initial Policy
Approx P.V. To Date / P.V. of Premium To Date %
Approx P.V. To Date / P.V. Of All Premiums %
Asset/Reinv Module Policy Year Results
General Policy Year Results Help
Cash Income
Cash Outgoes
Calls
Maturities
Defaults
Sales
Aquisition Cost
Expenses
Total Cashflow
PV of Cashflow
Duration of Cashflow
Earned Income
Amortization of Premium/Discount
Amortization of Gain/Loss
Default Gains
Depreciation
Investment Expense
Taxes
Net Investment Income
Present Value of Net Income
Required Surplus
Market Value
Amortized Cost Basis
Accrued Income
Unamortized Realized Gains/Losses
Amortized Unrealized Gains/Losses
Number of Assets Month Start
Number of Assets Acquired
Number of Assets Sold
Number of Assets Called
Number of Assets Defaulted
Number of Assets Month End
PRICING RESULTS SUMMARY
Fixed Summary Report
Cashflow Options
Cashflow Per $ Million Initial Par Value
Cashflow Per $ Million Par Value at Quarter Start
Cashflow Per $ Million Par Value at Quarter End
Cashflow Per $ Thousand Initial Par Value
Cashflow Per $ Thousand Par Value at Quarter Start
Cashflow Per $ Thousand Par Value at Quarter End
Cashflow Per Initial Asset
Cashflow Per Asset At Quarter Start
Cashflow Per Asset At Quarter End
Illustration Reports
Regular Module Illustration
Basic Premium
Other benefit premium
Issue Fee
Policy Fee
Total Premium
Face Amount
Other Benefit on Death
ROP on Death
ROUP on Death
Basic Cash Value
Other Benefit on Lapse
ROP on Lapse
ROUP on Lapse
Benefit on Other Benefit Decrement
ROP on Other Benefit Decrement
ROUP on other benefit decrement
Dividend
ROP to survivors
Other Benefit Amount 1 - 4
Reduced Paid Up Face Amount
ETI term
UL Module Illustration
General Illustrations Help
Investment Account/Side Fund
Adjustment to Fund Value
Rolled Over Amount
Fund Value Month Start
Net Premium Deposit
Bonus Month Start
Risk Charge
Other Benefit Charges
Expense Charge
MVA Charge Month Start
Transfer Month Start (investment accounts)
Interest Credited
Bonus Month End
Partial Withdrawl
MVA Charge Month End
Transfer Mth End
Fund Value Month End
Matured Deposits
Reinvested Interest
Surrender MVA
Current Term
Average Term Remaining
Current Credited Rate
Average Credited Rate
Current Benchmark Rate
Average Benchmark Rate
Competitors Rate
Main
Regular Premium
Minimum Premium
Dumpin Premium
Premium To Side Fund
Risk Charge Per $1000 net amount at risk
Face Amount Month Start
NAAR Fund Month Start
NAAR Month Start
Fund Month End
Side Fund Month End
CSV Period End
Total Cash Surrender Value Period End
Policy Loan Period End
Notional Account Period End
Other Benefit 1
Other Benefit 2
Other Benefit 3
Other Benefit 4
Accum NLG Prem Criteria 1 - 3
Accum Prem For NLG Criteria 1 - 3
Total
Adjustment to Fund Value
Rolled Over Amount
Fund Value Month Start
Total Premium
Premium Load
Bonus
Risk Charge
Not Acct Charge
Other Benefit 1 Charge
Other Benefit 2 Charge
Other Benefit 3 Charge
Other Benefit 4 Charge
Expense Charge
MVA Charge
Interest Credited
Partial Withdrawal
Transfer Month End (investment accounts)
Transfer (side fund)
Fund Value Month End
Matured Deposits
Reinvested Interest
Surrender Charge
Surrender MVA
Surrender Credit
Death Bonus
CSV Period End
Scheduled Payment
Average Benchmark Rate
Average Credited Rate
Fund Threshold For Risk Charge
Fund Threshold For Interest Credited
Par Module Illustration
General Illustrations Help
Main
Gross Premium
Face Amount
Basic CSV
Dividend
Terminal Dividend
Surrender Dividend
Other Benefits 1 to 4
Paid By Dividend
Net Premium
Cash Dividend
Death Benefit
Total CSV
One Year Term
Paidup Additions
Accumulated Cash
YS Start Death Benefit
Basic CSV
PUA CSV
Accumulated Cash
ADTB CSV
Total CSV At Year End
Ratio of Total CSV to Paid Prem (%)
Adjustment to Accumulated Div
Accum Div Yr Start
Premium Paid
Interest
Dividend
Accumulated Div Tr End
Adjustment to PUA
PUA Period Start
FA Of Premium
Bonus on PUA
FA Of Div
PUA for OYT
PUA Period End
Adjustment To Loan Balance
Policy Loan At Year Start
Policy Loan Interest
New Policy Loan Taken
Policy Loan Repaid
Policy Loan At Year End
Dividend adjustment from direct recognition
PUA dividend adjustment from direct recognition
Dividend used for policy loan
PUA dividend used for policy loan
Adjustment to OYT
Paidup Additions
Adjustment to PUA
PUA Period Start
FA of Premium
Bonus on PUA
Transfer
FA of Dividend
PUA of OYT
PUA Period End
PUA Cash Value
Paidup Additions For Additional Premiums
Adjustment to PUA
PUA Period Start
FA of Premium
Bonus on PUA
Transfer
FA of Dividend
PUA of OYT
PUA Period End
PUA Cash Value
Annuity Module Illustration
General Illustrations Help
Investment Account/Side Fund
Rolled Over Amount
Fund Value Month Start
Total Deposit
Expense Charge
MVA Charge Month Start
Transfer Month Start
Interest Credited
Guarantee Payment
Bonus
Equity Index Credited
Scheduled Withdrawal
MVA Charge Month End
Transfer Month End
Fund Value Month End
Matured Deposits
Reinvested Interest
Surrender MVA
Current Term
Average Term Remaining
Current Credited Rate
Average Credited Rate
Current Benchmark Rate
Average Benchmark Rate
Competitors Rate
Main
Regular Premium
Dumpin Premium
Premium Load
Premium Bonus
Net Deposit
Fund Value Month End
Surrender Bonus
Cash Value Month End
Annuitization Bonus Period End
Annuitization Value Before Guarantee
Minimum Income Base Value
Yrs Remaining In Ann Guar Waiting Period
Guaranteed Annuitization Prem Rate at YE
Current Annuitization Prem Rate at YE
Annuitization Value After Guarantee
Death Bonus Period End
Average Death Benefit
Def. Payout: Guaranteed Def. Annuity
Guar Fund 1 Period End
Yrs to Next Guar Fund 1 Reset
Guar Fund 2 Period End
Guar Fund 3 Period End
Guar Fund 4 Period End
Guar Fund 5 Period End
Guaranteed Withdrawal Amount
Guaranteed Withdrawal Base
Life Income Amount
SNFL Fund Period End
Total
Rolled Over Amount
Fund Value Month Start
Total Deposit
Expense Charge
MVA Charge
Interest Credited
Guarantee Payment
Bonus
Scheduled Withdrawals
Fund Value Month End
Matured Deposits
Reinvested Interest
Surrender Charge
Surrender MVA
Average benchmark rate
Average CR Rate
Group Annuity Module Illustration
Investment Account/Side Fund
Rolled Over Amount
Fund Value Period Start
Total Deposit
Transfer Month Start
Charges to Fund
Interest Credited
Bonus Month End
Scheduled Withdrawal
Cert Lapse Payout
Transfer Month End
Fund Value Period End
Matured Deposits
Reinvested Interest
Surrender MVA on Group Lapse
Current Term
Average Term Remaining
Current Credited Rate
Average Credited Rate
Current Benchmark Rate
Average Benchmark Rate
Competitors Rate
Fund Skim 1
Fund Skim 2
Fund Skim 3
Fund Skim 4
Main
Number of Certificates Period Start
Number of Certificates Entering
Number of Certificates Lapsing
Number of Certificates Period End
Fund Value Period End
CSV on Group Lapse Period End
Total
Rolled Over Amount
Fund Value Period Start
Initial Transfer Premium
New Entrant Premium
Recurring Premium
Premium Load
Total Deposit
Participant Fee Charged
Base Asset Charge Charged
Supplemental Asset Charge Charged
Seg Fund Management Fee Charged
Sales Expense Recovery Charge
Other Charges to Fund
Interest Credited
Bonus
Scheduled Withdrawal
Cert Lapse Payout
Fund Value Period End
Matured Deposits
Reinvested Interest
Surrender Charge on Group Lapse
Surrender MVA on Group Lapse
Average Benchmark Rate
Average Credited Rate
Asset/Reinv Module Illustration
General Illustrations Help
Asset Value at Period Start
Asset Cost at Period Start
Interest this Period
Calculated Payment this Period
Table Payment this Period
Prepayments this Period
Asset Value at Period End
Interest Rate
Calculated Tables
Regular Module Calculated Tables
PROFIT AS % GROSS PREMIUM
PROFIT AS % (PREMIUM - COMMISSION)
PROFIT AS % 1ST YEAR PREMIUM
PROFIT PER 1000 INFORCE VOLUME
PROFIT AS % OF DEATH CLAIMS
PROFIT AS % OF NET PREMIUM
PROFIT AS % 1ST YEAR COMMISSION
1ST YEAR PROFIT AS % 1ST YEAR PREMIUM
PROFIT AS % OF PV REQUIRED SURPLUS - ROE
PROFIT AS % OF PV REQ SURPLUS YE - ROE
PROFIT AS % OF PREMIUM LESS DIVIDEND
PROFIT AS % OF NET PREMIUM LESS DIVIDEND
Table Not Available For This Profit Margin
GROSS ROI TO DATE (%)
GROSS MARGINAL ROI TO DATE (%)
GROSS BECKER ROI TO DATE (%)
NET ROI TO DATE (%)
NET MARGINAL ROI TO DATE (%)
NET BECKER ROI TO DATE (%)
NET MEAN DAC PER NOMINAL 1000
NET MEAN RESERVES PER ACTUAL 1000
GROSS TERMINAL TAX RES PER NOMINAL 1000
GROSS TERMINAL TAX RESERVES PER ACTUAL 1000
GROSS MEAN RESERVES PER NOMINAL 1000
GROSS MEAN RESERVES PER ACTUAL 1000
NET MEAN RESERVES PER NOMINAL 1000
GROSS TERMINAL RESERVES PER NOMINAL 1000
GROSS TERMINAL RESERVES PER ACTUAL 1000
NET TERMINAL RESERVES PER NOMINAL 1000
NET TERMINAL RESERVES PER ACTUAL 1000
UL Module Calculated Tables
PROFIT AS % GROSS PREMIUM
PROFIT AS % (PREMIUM - COMMISSION)
PROFIT AS % 1ST YEAR PREMIUM
PROFIT PER 1000 INFORCE VOLUME
PROFIT AS % OF DEATH CLAIMS
PROFIT AS % OF NET PREMIUM
PROFIT AS % 1ST YEAR COMMISSION
1ST YEAR PROFIT AS % 1ST YEAR PREMIUM
PROFIT AS % OF PV REQUIRED SURPLUS - ROE
PROFIT AS % OF PV REQ SURPLUS YE - ROE
PROFIT AS % OF PREMIUM LESS DIVIDEND
Profit as % of PV risk charge + expense charge
Table Not Available For This Profit Margin
GROSS ROI TO DATE (%)
GROSS MARGINAL ROI TO DATE (%)
GROSS BECKER ROI TO DATE (%)
NET ROI TO DATE (%)
NET MARGINAL ROI TO DATE (%)
NET BECKER ROI TO DATE (%)
Par Module Calculated Tables
PROFIT AS % GROSS PREMIUM
PROFIT AS % (PREMIUM - COMMISSION)
PROFIT AS % 1ST YEAR PREMIUM
PROFIT PER 1000 INFORCE VOLUME
PROFIT AS % OF DEATH CLAIMS
PROFIT AS % OF NET PREMIUM
PROFIT AS % 1ST YEAR COMMISSION
1ST YEAR PROFIT AS % 1ST YEAR PREMIUM
PROFIT AS % OF PV REQUIRED SURPLUS - ROE
PROFIT AS % OF PV REQ SURPLUS YE - ROE
PROFIT AS % OF PREMIUM LESS DIVIDEND
PROFIT AS % OF NET PREMIUM LESS DIVIDEND
Table Not Available For This Profit Margin
GROSS ROI TO DATE (%)
GROSS MARGINAL ROI TO DATE (%)
GROSS BECKER ROI TO DATE (%)
NET ROI TO DATE (%)
NET MARGINAL ROI TO DATE (%)
NET BECKER ROI TO DATE (%)
Disability Module Calculated Tables
PROFIT AS % GROSS PREMIUM
PROFIT AS % (PREMIUM - COMMISSION)
PROFIT AS % 1ST YEAR PREMIUM
PROFIT PER 1000 INFORCE VOLUME
PROFIT AS % OF DEATH CLAIMS
PROFIT AS % OF NET PREMIUM
PROFIT AS % 1ST YEAR COMMISSION
1ST YEAR PROFIT AS % 1ST YEAR PREMIUM
PROFIT AS % OF PV REQUIRED SURPLUS - ROE
PROFIT AS % OF PV REQ SURPLUS YE - ROE
Table Not Available For This Profit Margin
GROSS ROI TO DATE (%)
GROSS MARGINAL ROI TO DATE (%)
GROSS BECKER ROI TO DATE (%)
NET ROI TO DATE (%)
NET MARGINAL ROI TO DATE (%)
NET BECKER ROI TO DATE (%)
Annuity Module Calculated Tables
PROFIT AS % GROSS PREMIUM
PROFIT AS % (PREMIUM - COMMISSION)
PROFIT AS % 1ST YEAR PREMIUM
Profit as % of PV Fund
Table Not Available For This Profit Margin
ROI to Date (%)
Marginal ROI to Date (%)
BECKER ROI TO DATE (%)
Group Annuity Module Calculated Tables
PROFIT AS % GROSS PREMIUM
PROFIT AS % (PREMIUM - COMMISSION)
PROFIT AS % 1ST YEAR PREMIUM
Profit as % of PV Fund
Table Not Available For This Profit Margin
ROI to Date (%)
Marginal ROI to Date (%)
BECKER ROI TO DATE (%)
Special Reserve Reports
Reserve Components Report
Regular Module Reserve Components Report
Reserve Components Report
Death benefit
Lapse Benefit
Other Benefits
Dividends
Compensation and premium tax
Other expenses
Reinsurer costs
Investment Income Tax
PV of valuation premium
Pure reserve
Deficiency reserve
Other adjustment
Total reserve
Annual valuation premium
UL Module Reserve Components Report
Reserve Components Report
Death Benefit
Lapse Benefit
Other Benefits
Compensation
Premium Tax
Other expenses
Reinsurer costs
Investment Income Tax
PV of Valuation premium
Pure reserve
Fund adjustment
Other adjustment
Total reserve
Par Module Reserve Components Report
Reserve Components Report
Policy benefits
Policy expenses
Reinsurer costs
Investment Income Tax
PV of valuation premium
Pure reserve
CSV of Paid-up Additions
Dividends accumulated on deposit
Other Adjustment
Total reserve
Disability Module Reserve Components Report
Reserve Components Report
Disability Benefits
Other Policy Benefits
Compensation and premium tax
Other Expenses
Reinsurer Costs
PV of valuation premium
Pure Reserve
Other Adjustment
Total Reserve
Annual valuation premium
Gross premium
Claim Cost Details
US GAAP Reserve Components Report
Overview of the Reserve Components Report
Regular Module US GAAP Reserve Components Report
Reserve Component Report
Benefit Reserve - PV of gross death/disability benefit
Benefit Reserve - PV of gross surrender benefit
Benefit Reserve - PV gross other benefits
Benefit Reserve - PV of gross dividends
Benefit Reserve - PV of gross maintenance costs
Benefit Reserve - PV of gross benefit reserve premium
Benefit Reserve - Other gross adjustment
Benefit Reserve - Gross benefit reserve
Benefit Reserve - Reinsurance adjustment
Benefit Reserve - Net benefit reserve
DAC Asset - PV of gross DAC amortization
DAC Asset - PV of gross DAC capitalization
DAC Asset - Other gross adjustment
DAC Asset - Gross DAC asset
DAC Asset - Reinsurance adjustment
DAC Asset - Net DAC asset
URL - PV of gross UR amortization
URL - PV of gross deferred unearned revenue
URL - Other gross adjustment
URL - Gross unearned revenue liability
URL - Reinsurance adjustment
URL - Net unearned revenue liability
Total Reserve - Past dividend reserve
Total Reserve - Other adjustment
Total Reserve - Total reserve
Miscellaneous - Number of lives Y/S
Miscellaneous - PV of inforce face
Miscellaneous - PV of gross premium
Miscellaneous - PV of DAC amortization base
Component of Valuation Premium - Maintenance expense premium
Component of Valuation Premium - Policy benefit premium
Component of Valuation Premium - Benefit reserve premium
Component of Valuation Premium - DAC amortized
Component of Valuation Premium - UR amortized
Component of Valuation Premium - Gross premium
Expense DAC Asset - PV of gross DAC amortization
Expense DAC Asset - PV of gross DAC capitalization
Expense DAC Asset - Other gross adjustment
Expense DAC Asset - Gross DAC asset
Par Module US GAAP Reserve Components Report
Reserve Component Report
Benefit Reserve - PV of gross death/disability benefit
Benefit Reserve - PV of gross surrender benefit
Benefit Reserve - PV gross other benefits
Benefit Reserve - PV of gross dividends
Benefit Reserve - PV of gross maintenance costs
Benefit Reserve - PV of gross benefit reserve premium
Benefit Reserve - Other gross adjustment
Benefit Reserve - Gross benefit reserve
Benefit Reserve - Reinsurance adjustment
Benefit Reserve - Net benefit reserve
DAC Asset - PV of gross DAC amortization
DAC Asset - PV of gross DAC capitalization
DAC Asset - Other gross adjustment
DAC Asset - Gross DAC asset
DAC Asset - Reinsurance adjustment
DAC Asset - Net DAC asset
URL - PV of gross UR amortization
URL - PV of gross deferred unearned revenue
URL - Other gross adjustment
URL - Gross unearned revenue liability
URL - Reinsurance adjustment
URL - Net unearned revenue liability
Total Reserve - Past dividend reserve
Total Reserve - Other adjustment
Total Reserve - Total reserve
Miscellaneous - Number of lives Y/S
Miscellaneous - PV of inforce face
Miscellaneous - PV of gross premium
Miscellaneous - PV of DAC amortization base
Component of Valuation Premium - Maintenance expense premium
Component of Valuation Premium - Policy benefit premium
Component of Valuation Premium - Benefit reserve premium
Component of Valuation Premium - DAC amortized
Component of Valuation Premium - UR amortized
Component of Valuation Premium - Gross premium
Disability Module US GAAP Reserve Components Report
Reserve Component Report
Benefit Reserve - PV of gross death/disability benefit
Benefit Reserve - PV of gross surrender benefit
Benefit Reserve - PV gross other benefits
Benefit Reserve - PV of gross dividends
Benefit Reserve - PV of gross maintenance costs
Benefit Reserve - PV of gross benefit reserve premium
Benefit Reserve - Other gross adjustment
Benefit Reserve - Gross benefit reserve
Benefit Reserve - Reinsurance adjustment
Benefit Reserve - Net benefit reserve
DAC Asset - PV of gross DAC amortization
DAC Asset - PV of gross DAC capitalization
DAC Asset - Other gross adjustment
DAC Asset - Gross DAC asset
DAC Asset - Reinsurance adjustment
DAC Asset - Net DAC asset
URL - PV of gross UR amortization
URL - PV of gross deferred unearned revenue
URL - Other gross adjustment
URL - Gross unearned revenue liability
URL - Reinsurance adjustment
URL - Net unearned revenue liability
Total Reserve - Past dividend reserve
Total Reserve - Other adjustment
Total Reserve - Total reserve
Miscellaneous - Number of lives Y/S
Miscellaneous - PV of inforce face
Miscellaneous - PV of gross premium
Miscellaneous - PV of DAC amortization base
Component of Valuation Premium - Maintenance expense premium
Component of Valuation Premium - Policy benefit premium
Component of Valuation Premium - Benefit reserve premium
Component of Valuation Premium - DAC amortized
Component of Valuation Premium - UR amortized
Component of Valuation Premium - Gross premium
Expense DAC Asset - PV of gross DAC amortization
Expense DAC Asset - PV of gross DAC capitalization
Expense DAC Asset - Other gross adjustment
Expense DAC Asset - Gross DAC asset
Claim Cost Details - Incidence Rate - Cause 1
Claim Cost Details - Incidence Rate - Cause 2
Claim Cost Details - Incidence Rate - Cause 3
Claim Cost Details - PV of Cause 1 Benefits
Claim Cost Details - PV of Cause 2 Benefits
Claim Cost Details - PV of Cause 3 Benefits
Claim Cost Details - Total Claim Costs
FAS120 Reserve Components Report
Par Module FAS120 Reserve Components Report
Benefit reserve - PV of gross death benefit
Benefit reserve - PV of gross surrender benefit
Benefit reserve - PV of gross other benefit
Benefit reserve - PV of gross benefit reserve premium
Benefit reserve - Other gross adjustment
Benefit reserve - Gross benefit reserve
Benefit reserve - Reinsurance adjustment
Benefit reserve - Net benefit reserve
DAC asset - PV of gross DAC amortization
DAC asset - PV of gross DAC capitalization
DAC asset - Other gross adjustment
DAC asset - Gross DAC asset
DAC asset - DAC reinsurance adjustment
DAC asset - Net DAC asset
Terminal Dividend Liability - PV of gross terminal dividend
Terminal Dividend Liability - PV of gross surrender dividend
Terminal Dividend Liability - PV of gross TDL amortization
Terminal Dividend Liability - Other gross adjustment
Terminal Dividend Liability - Gross Terminal Dividend Liability
Terminal Dividend Liability - Reinsurance adjustment
Terminal Dividend Liability - Net Terminal Dividend Liability
Total reserve - Reserve for past dividends
Total reserve - Other adjustment
Total reserve - Total net reserve
Miscellaneous - Number of lives Y/S
Miscellaneous - PV of gross premium
Miscellaneous - PV of expected gross margin
Component of Valuation Premium - Benefit reserve premium
Component of Valuation Premium - DAC amortized
Component of Valuation Premium - TDL amortized
Component of Valuation Premium - Gross premium
CARVM Reserve Components Report
UL Module CARVM Reserve Components Report
Death Benefit
Lapse Benefit
Policy Month
Other Benefits
Compensation
Premium Tax
Other expenses
Reinsurer costs
Investment Income Tax
PV of Valuation premium
Pure reserve
Fund adjustment
Other adjustment
Total reserve
Reserve Reconciliation Report
Regular Module Reserve Reconciliation Report
Period Start Unadjusted Reserve
Reserve Reconciliation Report
Valuation premium
Compensation less Chargeback
Premium tax
Investment Income Tax/Bonus
Other Expenses
Death/Disablement Benefits
Surrender Benefits
Other Benefits
Dividend payments
Ceded Cashflow
Required Interest
Released by Death/Disablement
Released by Lapse
Released by Other
Period End Unadjusted Reserve
Period End Adjustment
Period End Reserve
Year end Cash value
Check Sum
Mean res partial month discount factor
Mean res partial month cashflow adjustment
Unearned premium adjustment
UL Module Reserve Reconciliation Report
Period Start Unadjusted Reserve
Reserve Reconciliation Report
Valuation premium
Compensation less Chargeback
Premium Tax
Investment Income Tax
Other expenses
Death claims
Surrender benefits
Other benefits
Ceded cashflow
Required Interest
Released by Death
Released by Lapse
Released by Other
Period End Unadjusted Reserve
Period End Adjustment
Period End Reserve
Ending Cash value
Check Sum
Mean res partial month discount factor
Mean res partial month cashflow adjustment
Unearned premium adjustment
Par Module Reserve Reconciliation Report
Period Start Unadjusted Reserve
Reserve Reconciliation Report
Valuation premium
Compensation less Chargeback
Premium tax
Investment Income Tax/Bonus
Other Expenses
Death/Disablement Benefits
Surrender Benefits
Other Benefits
Dividend payments
Ceded Cashflow
Required Interest
Released by Death/Disablement
Released by Lapse
Released by Other
Period End Unadjusted Reserve
Period End Adjustment
Period End Reserve
Year end Cash value
Check Sum
Mean res partial month discount factor
Mean res partial month cashflow adjustment
Unearned premium adjustment
Disability Module Reserve Reconciliation Report
Period Start Unadjusted Reserve
Reserve Reconciliation Report
Valuation premium
Compensation less Chargeback
Premium tax
Investment Income Tax/Bonus
Other Expenses
Death/Disablement Benefits
Surrender Benefits
Other Benefits
Ceded Cashflow
Required Interest
Released by Death/Disablement
Released by Lapse
Released by Other
Period End Unadjusted Reserve
Period End Adjustment
Period End Reserve
Year end Cash value
Check Sum
Mean res partial month discount factor
Mean res partial month cashflow adjustment
Unearned premium adjustment
US GAAP Reserve Reconciliation Report
Overview of the Reserve Reconciliation Report
Regular Module US GAAP Reserve Reconciliation Report
Reserve Reconciliation Report
Benefit Reserve - P/S unadjusted gross benefit reserve
Benefit Reserve - Gross benefit reserve premium
Benefit Reserve - Gross maintenance costs
Benefit Reserve - Gross death / disability benefit
Benefit Reserve - Gross surrender benefit
Benefit Reserve - Gross other benefit
Benefit Reserve - Gross dividends
Benefit Reserve - Gross required interest
Benefit Reserve - Released by death / disablement
Benefit Reserve - Released by surrender
Benefit Reserve - Released by other
Benefit Reserve - P/E unadjusted gross benefit reserve
Benefit Reserve - Y/E gross adjustment
Benefit Reserve - Y/E gross benefit reserve
Benefit Reserve - Reinsurance adjustment
Benefit Reserve - Y/E net benefit reserve
Benefit Reserve - Y/E cash value
Benefit Reserve - Mean Res Partial Month Discount Factor
Benefit Reserve - Mean Res Partial Month Cashflow Adjustment
DAC Asset - Y/S unadjusted gross DAC asset
DAC Asset - Gross DAC capitalized
DAC Asset - Gross DAC interest
DAC Asset - Gross DAC amortized
DAC Asset - Released by death / disablement
DAC Asset - Released by surrender
DAC Asset - Released by other
DAC Asset - Y/E gross DAC asset
DAC Asset - Y/E gross adjustment
DAC Asset - Reinsurance adjustment
DAC Asset - Y/E net DAC asset
DAC Asset - Mean DAC Partial Month Discount Factor
DAC Asset - Mean DAC Partial Month Cashflow Adjustment
URL - P/S unadjusted gross unearned revenue liability
URL - Gross deferred unearned revenue
URL - Gross UR interest
URL - Gross UR amortized
URL - Released by death / disablement
URL - Released by surrender
URL - Released by other
URL - P/E unadjusted gross unearned revenue liability
URL - Y/E gross adjustment
URL - Y/E gross unearned revenue liability
URL - Reinsurance adjustment
URL - Y/E net unearned revenue liability
URL - Mean URL Partial Month Discount Factor
Total Reserve - Past dividend reserve Or Y/E fund
Total Reserve - Other adjustment
Total Reserve - Total reserve
Expense DAC Asset - P/S unadjusted gross DAC asset
Expense DAC Asset - Gross DAC capitalized
Expense DAC Asset - Gross DAC interest
Expense DAC Asset - Gross DAC amortized
Expense DAC Asset - Released by death / disablement
Expense DAC Asset - Released by surrender
Expense DAC Asset - Released by other
Expense DAC Asset - P/E unadjusted gross DAC asset
Expense DAC Asset - Y/E gross adjustment
Expense DAC Asset - Y/E gross DAC asset
UL Module US GAAP Reserve Reconciliation Report
Reserve Reconciliation Report
DAC Asset - Y/S unadjusted gross DAC asset
DAC Asset - Gross DAC capitalized
DAC Asset - Gross DAC interest
DAC Asset - Gross DAC amortized
DAC Asset - Released by death / disablement
DAC Asset - Released by surrender
DAC Asset - Released by other
DAC Asset - Y/E gross DAC asset
DAC Asset - Y/E gross adjustment
DAC Asset - Reinsurance adjustment
DAC Asset - Y/E net DAC asset adjustment
DAC Asset - Y/E net DAC asset
URL - P/S unadjusted gross unearned revenue liability
URL - Gross deferred unearned revenue
URL - Gross UR interest
URL - Gross UR amortized
URL - Released by death / disablement
URL - Released by surrender
URL - Released by other
URL - P/E unadjusted gross unearned revenue liability
URL - Y/E gross adjustment
URL - Y/E gross unearned revenue liability
URL - Reinsurance adjustment
URL - Y/E net URL adjustment
URL - Y/E net unearned revenue liability
Total Reserve - Past dividend reserve Or Y/E fund
Total Reserve - Total reserve
Par Module US GAAP Reserve Reconciliation Report
Reserve Reconciliation Report
Benefit Reserve - P/S unadjusted gross benefit reserve
Benefit Reserve - Gross benefit reserve premium
Benefit Reserve - Gross maintenance costs
Benefit Reserve - Gross death / disability benefit
Benefit Reserve - Gross surrender benefit
Benefit Reserve - Gross other benefit
Benefit Reserve - Gross dividends
Benefit Reserve - Gross required interest
Benefit Reserve - Released by death / disablement
Benefit Reserve - Released by surrender
Benefit Reserve - Released by other
Benefit Reserve - P/E unadjusted gross benefit reserve
Benefit Reserve - Y/E gross adjustment
Benefit Reserve - Y/E gross benefit reserve
Benefit Reserve - Reinsurance adjustment
Benefit Reserve - Y/E net benefit reserve
Benefit Reserve - Y/E cash value
Benefit Reserve - Mean Res Partial Month Discount Factor
Benefit Reserve - Mean Res Partial Month Cashflow Adjustment
DAC Asset - Y/S unadjusted gross DAC asset
DAC Asset - Gross DAC capitalized
DAC Asset - Gross DAC interest
DAC Asset - Gross DAC amortized
DAC Asset - Released by death / disablement
DAC Asset - Released by surrender
DAC Asset - Released by other
DAC Asset - P/E unadjusted gross DAC asset
DAC Asset - Y/E gross adjustment
DAC Asset - Y/E gross DAC asset
DAC Asset - Reinsurance adjustment
DAC Asset - Y/E net DAC asset
DAC Asset - Mean DAC Partial Month Discount Factor
DAC Asset - Mean DAC Partial Month Cashflow Adjustment
URL - P/S unadjusted gross unearned revenue liability
URL - Gross deferred unearned revenue
URL - Gross UR interest
URL - Gross UR amortized
URL - Released by death / disablement
URL - Released by surrender
URL - Released by other
URL - Y/E gross unearned revenue liability
URL - Y/E gross adjustment
URL - P/E unadjusted gross unearned revenue liability
URL - Reinsurance adjustment
URL - Y/E net unearned revenue liability
URL - Mean URL Partial Month Discount Factor
Total Reserve - Past dividend reserve Or Y/E fund
Total Reserve - Other adjustment
Total Reserve - Total reserve
Disability Module US GAAP Reserve Reconciliation Report
Reserve Reconciliation Report
Benefit Reserve - P/S unadjusted gross benefit reserve
Benefit Reserve - Gross benefit reserve premium
Benefit Reserve - Gross maintenance costs
Benefit Reserve - Gross death / disability benefit
Benefit Reserve - Gross surrender benefit
Benefit Reserve - Gross other benefit
Benefit Reserve - Gross dividends
Benefit Reserve - Gross required interest
Benefit Reserve - Released by death / disablement
Benefit Reserve - Released by surrender
Benefit Reserve - Released by other
Benefit Reserve - P/E unadjusted gross benefit reserve
Benefit Reserve - Y/E gross adjustment
Benefit Reserve - Y/E gross benefit reserve
Benefit Reserve - Reinsurance adjustment
Benefit Reserve - Y/E net benefit reserve
Benefit Reserve - Y/E cash value
Benefit Reserve - Mean Res Partial Month Discount Factor
Benefit Reserve - Mean Res Partial Month Cashflow Adjustment
DAC Asset - Y/S unadjusted gross DAC asset
DAC Asset - Gross DAC capitalized
DAC Asset - Gross DAC interest
DAC Asset - Gross DAC amortized
DAC Asset - Released by death / disablement
DAC Asset - Released by surrender
DAC Asset - Released by other
DAC Asset - P/E unadjusted gross DAC asset
DAC Asset - Y/E gross adjustment
DAC Asset - Y/E gross DAC asset
DAC Asset - Reinsurance adjustment
DAC Asset - Y/E net DAC asset
DAC Asset - Mean DAC Partial Month Discount Factor
DAC Asset - Mean DAC Partial Month Cashflow Adjustment
URL - P/S unadjusted gross unearned revenue liability
URL - Gross deferred unearned revenue
URL - Gross UR interest
URL - Gross UR amortized
URL - Released by death / disablement
URL - Released by surrender
URL - Released by other
URL - P/E unadjusted gross unearned revenue liability
URL - Y/E gross adjustment
URL - Y/E gross unearned revenue liability
URL - Reinsurance adjustment
URL - Y/E net unearned revenue liability
URL - Mean URL Partial Month Discount Factor
Total Reserve - Past dividend reserve Or Y/E fund
Total Reserve - Other adjustment
Total Reserve - Total reserve
Expense DAC Asset - P/S unadjusted gross DAC asset
Expense DAC Asset - Gross DAC capitalized
Expense DAC Asset - Gross DAC interest
Expense DAC Asset - Gross DAC amortized
Expense DAC Asset - Released by death / disablement
Expense DAC Asset - Released by surrender
Expense DAC Asset - Released by other
Expense DAC Asset - P/E unadjusted gross DAC asset
Expense DAC Asset - Y/E gross adjustment
Expense DAC Asset - Y/E gross DAC asset
FAS120 Reserve Reconciliation Report
Par Module FAS120 Reserve Reconciliation Report
Benefit reserve - Y/S unadjusted gross benefit reserve
Benefit reserve - Gross benefit reserve premium
Benefit reserve - Gross death benefit
Benefit reserve - Gross surrender benefit
Benefit reserve - Gross other benefit
Benefit reserve - Gross required interest
Benefit reserve - Released by death
Benefit reserve - Released by surrender
Benefit reserve - Released by other
Benefit reserve - Y/E gross adjustment
Benefit reserve - Y/E gross benefit reserve
Benefit reserve - Reinsurance adjustment
Benefit reserve - Y/E net benefit reserves
DAC asset - Y/S unadjusted gross DAC asset
DAC asset - Gross DAC capitalized
DAC asset - Gross DAC interest
DAC asset - Gross DAC amortized
DAC asset - Released by death
DAC asset - Released by surrender
DAC asset - Released by other
DAC asset - Y/E gross adjustment
DAC asset - Y/E gross DAC asset
DAC asset - Reinsurance adjustment
DAC asset - Y/E net DAC asset
Terminal Dividend Liability - Y/S unadjusted gross TDL
Terminal Dividend Liability - Gross terminal dividend
Terminal Dividend Liability - Gross surrender dividend
Terminal Dividend Liability - Gross TDL interest
Terminal Dividend Liability - Gross TDL amortized
Terminal Dividend Liability - Released by death
Terminal Dividend Liability - Released by surrender
Terminal Dividend Liability - Released by other
Terminal Dividend Liability - Y/E gross adjustment
Terminal Dividend Liability - Y/E gross TDL
Terminal Dividend Liability - Reinsurance adjustment
Terminal Dividend Liability - Y/E net TDL
Total reserve - Reserve for past dividends
Total Reserve - Other adjustment
Total Reserve - Total Y/E net reserve
Expected gross margin - Gross premium
Expected gross margin - Gross interest
Expected gross margin - Gross death benefit
Expected gross margin - Gross surrender benefit
Expected gross margin - Gross other benefit
Expected gross margin - Gross Maintenance cost and IIT
Expected gross margin - Gross Dividend
Expected gross margin - Change in gross benefit reserve
Expected gross margin - Other adjustment to EGM
Expected Gross Margin - Gross EGM
Expected Gross Margin - Reinsurance adjustment
Expected Gross Margin - Net EGM
CARVM Reserve Reconciliation Report
Annuity Module CARVM Reserve Reconciliation Report
Policy Month
Month End Survivorship Factor
Month End Survivorship Factor for AG34
Month Start Discount for Premium
Mid-Month Discount Factor for Death Benefit
Month End Discount Factor for Partial Withdrawal
Month End Discount Factor for CSV
Month End Discount Factor for Annuitization Benefit
AG33 No Withdrawal - Fund Value at Month End
AG33 No Withdrawals - CSV at Month End
AG33 No Withdrawals - Elective Ann Benefit Available at Month End
AG33 No Withdrawals - Non-Elective Ann Benefit Paid This Month
AG33 No Withdrawals - Death Benefit This Month
AG33 No Withdrawals - Guaranteed Prem This Month
AG33 No Withdrawals - Greater of PV (Full Surrender / Annuitization)
AG33 Partial Withdrawals - Fund Value at Month End
AG33 Partial Withdrawal - CSV at Month End
AG33 Partial Withdrawals - Elective Ann Benefit Available at Month End
AG33 Partial Withdrawals - Non-Elective Ann Benefit Paid This Month
AG33 Partial Withdrawals - Death Benefit This Month
AG33 Partial Withdrawals - Guaranteed Premium This Month
AG33 Partial withdrawals - Partial Withdrawals This Month
AG33 Partial Withdrawals - Greater of PV (Full Surrender / Annuitization)
Greatest PV for AG33
Final AG33 Reserve
AG34 Calculation - Fund Value at Mid-Month
AG34 Calculation - Death Benefit at Mid-Month
NAAR Death Benefit
PV NAAR Death Benefit
PV AG33 Stream No Withdrawals
PV AG33 Stream Withdrawals
Greatest PV for AG34
Final AG34 Reserve
Group Annuity Module CARVM Reserve Reconciliation Report
MS Discount Factor for Prem
ME Discount Factor for CSV
Fund Value at ME
CSV at Group Lapse at ME
Guaranteed Prem This Month
PV at Full Surrender
Greatest PV for AG33
Final AG33 Reserve
Calendar Year Projections
General Information
About Calendar Year Projections
Calendar Year Reports
Calendar Year Row Formula
Category Reports
Fixed Summary Report
Investment Summary Report
Gross Cashflows
Gross premium - first year
Gross premium - renewal
Gross premium - first year other ben
Gross premium - renewal other ben
Gross premium - single
Gross premium - annuity
Gross billed group charges
Gross premium tax
Gross commission - first year
Gross commission - renewal
Gross commission - bonus
Gross commission - other benefit
Gross chargeback
Total expense - first year
Total expense - renewal
Gross benefits - death
Gross benefits - disability
Gross benefits - annuity
Gross benefits - surrender
Gross benefits - maturity
Gross benefits - other
Gross benefits - other 1
Gross benefits - other 2
Gross benefits - other 3
Gross benefits - other 4
Gross cash dividends
Gross segregated fund fees received
Gross investment income tax
Total gross cashflow
Gross premium - first year accum ann
Gross premium - renewal accum ann
Gross premium - payout annuity
Gross experience refund
Gross commission - asset based (unadjusted)
Gross commission - risk charge based
Gross benefits - ROP to survivor
Adjustment to fund value
Gross Bonus Paid To Segregated Funds
Gross transfer from segregated fund
Gross transfer from designated fund
Gross Miscellaneous Items
Ceded Cashflows
Ceded premium - first year
Ceded premium - renewal
Ceded premium - first year other ben
Ceded premium - renewal other ben
Ceded premium tax
Ceded commission - first year
Ceded commission - renewal
Ceded commission - bonus
Ceded commission - other benefit
Ceded chargeback
Ceded benefits - death
Ceded benefits - disability
Ceded benefits - surrender
Ceded benefits - maturity
Ceded benefits - other
Ceded benefits - other 1
Ceded benefits - other 2
Ceded benefits - other 3
Ceded benefits - other 4
Ceded cash dividends
Total ceded cashflow
Ceded premium - treaty level
Ceded benefits - ROP to survivor
Ceded benefits - treaty level
Ceded modco adjustment
Net Cashflows and Income
Net premium - first year
Net premium - renewal
Net premium - first year other ben
Net premium - renewal other ben
Net premium - annuity
Net billed group charge
Net premium tax
Net commission - first year
Net commission - renewal
Net commission - bonus
Net commission - other benefit
Net chargeback
Expenses - first year
Expenses - renewal
Net benefits - death
Net benefits - disability
Net benefits - annuity
Net benefits - surrender
Net benefits - maturity
Net benefits - other
Net cash dividends
Net segregated fund fees received
Net investment income tax
Total net cashflow
Change in actuarial reserve
Investment inc on cashflow & res
Invest inc adjustment on cf & res
Corporate tax on cashflow & res
Profit on cashflow & reserve
Change in required surplus
Before tax income on req surplus
Invest inc adjustment on req surp
Corporate tax on required surplus
Shareholder dividend
Other Investment Revenue
Contribution to free surplus CTFS
After tax income on free surplus
Capital injection
Transfer of free surplus to fund
Total corporate tax
Total statement profit
Net premium - annuity
Net experience refund
Net benefit - annuity
Net benefits - ROP to survivor
Adjustment to fund value
Tax Loss Carryforward Balance
Tax Loss To Carryforward
Tax Loss Carryforward Used
Tax Loss Carryforward Lost
Tax Losses Recognized Immediately
Taxable Income Before Adjustments
IIT credit on surrender
Net Bonus Paid to Segregated Funds
Net benefits - annuitization
Net benefits - accum ph payout
Net benefits - annuity payout
Net premium - first year accum ann
Net premium - renewal accum ann
Net premium - payout annuity
Net benefits - annuitization
Net benefits - accum ph payout
Net benefits - annuity payout
Net transfer from segregated fund
Net transfer from designated fund
Modco adjustment
Reserves
Gross reserve
Gross - cash surrender value
Net reserve
Net - cash surrender value
Net - CSV deficiency reserve
Net - negative reserve
Net - reserve for corporate tax
Net - statutory deficiency res
Net - second deficiency res
Net - statutory maint exp res
Net - second maint expense res
Net - statutory DAC asset
Net - second DAC asset
Approp. for unlicenced reinsurance
Net disabled life reserve
Par policyholder surplus
PV at hurdle - future proft on CF?
Embedded value period end PV CTFS
Hurdle Rate
Gross - current surrender dividend
Net - current surrender dividend
Undiscounted Deferred Tax Liability
Gross - MVA on Lapse
Gross - MVA on Lapse (group lapse)
Partial withdrawal under GMWB
Partial withdrawal under LIA
Net - CSV with return of unearned prm
Interest rate - book profit fund
Interest rate - required surplus fund
Interest rate - free surplus fund
DTL in net actuarial reserve
Inforce - UL seg fund
Inforce - UL designated fund
Tier 1 for UL commission for new business written
Deposit to seg fund - first year
Deposit to seg fund - renewal
Seg fund factor method required surplus
Gross unearned premium
Ceded unearned premium
Gross Return of Unearned Prem - Lapse
Gross Return of Unearned Prem - Death
Letter of credit expense
Letter of credit amount
PV of ben to next anniversary
PV of com to next anniversary
PV of exp to next anniversary
UL fund included in face amount
UL additional face amount due to corridor
UL death benefits due to continuation guarantee
Accumulated Annual Tabular Minimum Premium
Accumulated Net Insurance Deposit
Annuity GMWB Expense Benchmark
Group ann sales expense recovery charge (SERC)
InvInc on av fund not using GA rate
Avg fund bal not using gen acct rat
Annuity guarantee fund X
Annuity guarantee fund X
Annuity guarantee fund X
Annuity guarantee fund X
Annuity guarantee fund X
UL period end cred rate - fund 1
UL period end cred rate - fund 2
UL period end cred rate - side fund
Mortgage - Principal Repaid
Reinvestment cashflow
Reinvestment weighted cashflow
Tax basis adj realized gain
Death Benefit in Excess of Fund Value
Annuitization Benefit in Excess of Fund Value
Book profit fund for int rate calc
Req surplus fund for int rate calc
Free surplus fund for int rate calc
Gross Return of Unearned Prem - Other Benefit
Commission Chargeback
Balance Sheet
Net actuarial reserve
Accrued tax
Surplus - required
Surplus - free
YTD accumulated retained earnings
Total assets (liability + surplus)
MCCSR - available capital Tier 1
MCCSR - available capital Tier 2
MCCSR - required capital
MCCSR ratio
Accumulated period book profit
Accumulated period req surplus
Inforce Statistics
NB written - gross - face amount
NB written - gross - monthly income
NB written - net - face amount
NB written - net - monthly income
NB written - nominal face amount
NB written - deferred annual payout
NB written - accum phase (premium)
NB written - annuity phase (payout)
Inforce - gross - face amount
Inforce - gross - paid-up face amount
Inforce - gross - monthly income
Inforce - gross - other benefit
Inforce - gross - other benefit 2
Inforce - gross - other benefit 3
Inforce - gross - other benefit 4
Inforce - net - face amount
Inforce - net - paid-up face amount
Inforce - net - monthly income
Inforce - net - other benefit
Inforce - net - other benefit 2
Inforce - net - other benefit 3
Inforce - net - other benefit 4
Inforce - nominal face
Inforce - deferred annual payout
Inforce - accum phase (fund)
Inforce - annuity phase (payout)
Inforce - annuity seg fund
Inforce - UL seg fund
Disabled - gross - monthly income
Disabled - net - monthly income
Gross annualized premium - written
Gross annualized premium - inforce
No of coverages - new business
No of coverages - new bus accum+seg
No of coverages - new bus annuity
No of coverages - inforce
No of coverages - inforce accum+seg
No of coverages - inforce annuity
No of coverages - disabled
No of cessions - new bus life
No of cessions - inforce life
No of cessions - disabled lives
No of pol for expense - new business
No of pol for expense - inforce
Inforce - gross - ETI face amount
Inforce - extra death benefit
Inforce - net - ETI face amount
Inforce - accrued annual payout
Inforce - bonus additions
Ceded annualized premium - written
Ceded annualized premium - inforce
Gross annualized prem - inforce other
Gross annualized prem - inforce other 1
Gross annualized prem - inforce other 2
Gross annualized prem - inforce other 3
Gross annualized prem - inforce other 4
Annualized UL prem written below T1
Annualized UL prem written above T1
No of coverages - certain period
No of coverages - inforce groups
No of coverages - YTD recoveries
Annuity Fund Reconciliation
Annuity fund + reset/maturity guarantee payment
Annuity fund + bonus
Annuity fund - released on annuit
Annuity fund at end of period
Surrender charges / MVA
Policyholder Fund Reconciliation
UL total fund - expense charge
UL total fund - MVA charge
UL total fund + bonus
UL total fund at end of period
UL fund 2 at end of period
UL side fund at end of period
Miscellaneous Items
Accum dividends on deposit
Face amount of term bonus additions
Face amount of paidup additions
Basic dividends declared
PUA bonus declared
Terminal dividends declared
Surrender dividends declared
Total dividends declared
PH dividend as SH dividend base
Provision for dividend
Gross basic cash surrender value
NAAR used for required surplus
Prem used for required surplus
Lapse component in required surplus
Total invest income G/L on lapse
+ UL fund 2 deposits
- UL fund 2 risk charge
- UL fund 2 other benefit charge
- UL fund 2 expense charge
+ UL fund 2 interest credited
- UL fund 2 released on lapse
- UL fund 2 released on death
- UL fund 2 released on partial wd
+ UL side fund deposits
- UL side fund expense charge
+ UL side fund interest credited
- UL side fund released on lapse
- UL side fund released on maturity
- UL side fund released on death
+ UL side fund transfer to exempt fund
+ UL side fund other adjustments
ACB used for T5 calculation
Liability duration
Time zero net statutory reserve
User def fixed exp - first year
User def fixed exp - renewal
Reserve release on death / incidence
Reserve release on lapse
Reserve release on other ben dec
Reserve release on DI termination
Guar term deposits rolled over
Accum ann avg cred rate period end
Gross Premium - Grp ann initial transfer
Gross Premium - Grp ann new ent transf
Gross Premium - Grp ann recurring
Net Premium - Grp ann initial transfer
Net Premium - Grp ann new ent transf
Net Premium - Grp ann recurring
Unlock DAC / URL
Unlock DAC / URL
Unlock DAC / URL
No of certificates inforce at start
+ Interest on accum dividends
+ New dividends to accumulate
- Accum dividends paid on lapse
- Accum dividends paid on death
+ Other adjustment/accum dividends
TAX RATE ON FREE SURPLUS
Annuity fund group initial transfer
Annuity fund group new entrant transfer
Annuity fund group recurring premium
UL PWD Net of Surr Chg
Weighted cashflow for interest calculation
Gross weighted cashflow for interest calculation
T5 for IIT calculation
Net liability cashflow in month
Gross - deferrable costs
Net - deferrable costs
Gross - deferrable cost weighted cashflow
Net - deferrable cost weighted cashflow
Gross - unearned revenue
Net - unearned revenue
Gross - unearned revenue weighted cashflow
Net - unearned revenue weighted cashflow
Net terminal dividends
Net terminal dividend weighted cashflow
Net - residual expenses
Net - residual expenses weighted cashflow
PV of liab CF on yield curve
Numerator of liab duration formula
Target minimum premium
Dumpin premium
Additional def payout purchased
Bonus additions declared
Annuitization bonus payout awarded
DAC amortization - PV of EGP/M (UL/Par)
DAC amortization- PV Gross EGP
DAC amortization - PV of deferrable costs (U/P)
DAC amortization - PV of unearned revenue (UL)
DAC amortization - PV of terminal/surrender dividends
Variance - other benefits
Variance - other benefits
Variance - other benefits
Variance - other benefits
Commission per group assets
Commission per group initial transfer
Commission per group new entrant transfer
Commission per group recurring premium
Commission per group
Additional expense charge - seg fund
Additional expense charge - non-seg fund
Annuity / UL Expense Charge Per Fund Category A
Annuity / UL Expense Charge Per Fund Category B
Annuity / UL Expense Charge Per Fund Category C
Annuity / UL Expense Charge Per Fund Total
Annuity Exp Chg Per Min Ann Base
Annuity Exp Chg Per Death Benefit
Annuity Exp Chg Per GMWB Table
Annuity GMWB extra DB payment
Annuity GMWB base
Issue expenses - group annuity
Group ann base asset charge
Group ann supplemental asset charge
Port rate cred - min/max constraints
Port rate cred - guaranteed min
Reserve details - main guar reserve less CSV floor
Reserve details - XXX reserve less main guar reserve
Reserve details - AG 38 reserve adjustment
Reserve details - AG 37 reserve adjustment
Designated investment cash flow
Assets sold in fund
Book value available for sale
Impaired assets additional capital required
Asset cashflow in month
PV of asset CF on yield curve
Numerator of asset duration formula
Impaired assets write-downs deducted
Write-downs on impaired assets
Realized G/L transferred to IMR
DAC tax - current
Gross - cash surrender value (group lapse)
Second reserve Cash Value deficiency
Inforce annuity fund + SF
- Accum dividends paid on maturity
- Accum dividends paid on partial surrender
Accrued dividends
Provision for accum dividends
Base dividend fund
Cash value for paidup additions
UL total fund other benefit 1, 2, 3 or 4 charge
UL total fund other benefit 1, 2, 3 or 4 charge
UL total fund other benefit 1, 2, 3 or 4 charge
UL total fund other benefit 1, 2, 3 or 4 charge
UL side fund released on other benefit
Group participant fee charged
Group participant fee billed
Seg fund management fee charged
Group ann SF mgmnt fee reduction
Transfer of designated fund spread
DAC amortization - PV of base STAT
DAC amortization - PV of def exp STAT
DAC amortization - PV of base SCND
DAC amortization - PV of def exp SCND
Variance - main benefit
Amount movement - terminations
Accum ann sched pay on mat deposits
Exp per exp benchmark - per fund A
Exp per exp benchmark - per fund B
Exp per exp benchmark - per EC / SFMF
Exp benchmark - per fund A
Exp benchmark - per fund B
Exp benchmark - per EC / SFMF
Non-issue expenses per cert
Non-issue expenses per group
Non-issue expenses per group assets
DAC tax - unamortized capitalized amount
DAC tax - asset
ER reserve adjustment
ER claim fluctuation reserve
ER loss carry forward
Present Value of Experience Refund
Taxable income adjustment from cell
- Accum dividends to pay OYT and PUA
Dividend paid on maturity
Dividend to pay for vanishing premium
Dividend to purchase OYT and PUA
General account rate
Group participant fee additional
Dynamic premium
DAC tax - non historical unamortized capitalized amount
Asset duration before matching
Matching asset duration
Statutory PFAD Components
Mortality/Morbidity PFAD
Interest PFAD
Lapse PFAD
Expense PFAD
Reserve with no PFAD
Mortality/Morbidity PFAD at time zero
Interest PFAD at time zero
Lapse PFAD at time zero
Expense PFAD at time zero
Other benefit PFAD
Termination PFAD
Annuitization PFAD
Partial withdrawal PFAD
Benchmark int rate PFAD
Seg fund mngmnt fee PFAD
Premium PFAD
Other benefit PFAD at time zero
Termination PFAD at time zero
Annuitization PFAD at time zero
Partial withdrawal PFAD at time 0
Benchmark int rate PFAD at time 0
Seg fund mngmnt fee PFAD at time 0
Premium PFAD at time 0
US GAAP Financials
GAAP premium - first year
GAAP premium - renewal
Total premium
Benefits - death
Benefits - disability
Benefits - surrender
Benefits - maturity
Benefits - dividends
Benefits - other
Total benefits
Change in GAAP reserves
Required interest
GAAP benefits
GAAP benefits as % of premiums
Premium tax
Commissions - first year
Commissions - renewal
Commissions - chargebacks
Total comm + prem tax
DAC - capitalized
DAC - amortized
GAAP expenses
GAAP benefits & expense
Other expenses
Excess investment income
GAAP income before tax
Federal income tax
Change in deferred tax liability
GAAP income after tax
GAAP equity
Return on equity
GAAP Required Surplus
Asset Income Statement Details
Earned income
Amortization of prem/discnt
Amortization of realized gain/loss
Amortization of unrealized gain/loss
Gain/loss on defaults
Gross income on invested assets
Income from reinvestment account
Investment income On CF and cash account
Gross investment income
Investment expenses
Net investment income = i
Gross rate of invest inc. earned
Net rate of invest inc. earned
IMR Amortization
IMR Amortization
IMR Amortization
IMR Amortization
Income from asset writedown
Other charges
Cashflows and Reinvestment
Inflows - income cashflow
Inflows - calls/prepayments
Inflows - maturities
Inflows - salvage value on defaults
Inflows - sales
Total asset inflows
Outflows - other income
Outflows - purchase commitments
Outflows - investment expenses
Total asset cashflow
Other Revenues
Cashflow from insurance operations
Investment income on cashflow
Amount available for reinvestment
Net flow from cashflow account
Reinvestment account - income
Reinvestment account - maturities
Assets purchased in office
Assets purchased in fund
Balance to reinvestment account
Inflows - mortgage lapse
Outflows - other charges
Asset Balance Sheet Details
Book value (excl accrued)
Accrued income
Unamortized realized gain
Amortized unrealized gain
Total invested assets
Cashflow account
Cashflow account accrued int
Reinvestment account
Reinvestment account accrued int
Total assets
Asset required surplus
Notional value (pay side)
Non Admitted IMR
Asset Market Values
Market value (excl accrued)
Market value of invested assets
Market value available for sale
Market Value Proportions
Market value bond
Market value mortgage
Market value share
Market value real estate
Market value other1
Market value other2
Market value cash
Adjustments
Adjusted realized gain
Taxable investment income adjustment
Modified duration Of liabilities
Modified duration of assets
Asset duration from cell
Option value
Asset Detail by Type (AXIS 9 Format Only)
Bonds - coupons
Bonds - calls
Bonds - maturities
Bonds - salvage on default
Bonds - sales
Bonds - purchase commitments
Bonds - investment expenses
Bonds - reinvestments
Bonds - total cashflow
Bonds - gain/loss on defaults
Bonds - weighted cashflow
Mortgages - payments
Mortgages - prepayments
Mortgages - maturities
Mortgages - salvage on default
Mortgages - sales
Mortgages - purchase commitments
Mortgages - investment expenses
Mortgages - reinvestments
Mortgages - total cashflow
Mortgages - gain/loss on defaults
Mortgages - weighted cashflow
Shares - dividends
Shares - calls
Shares - maturities
Shares - salvage on default
Shares - sales
Shares - purchase commitments
Shares - investment expenses
Shares - reinvestments
Shares - total cashflow
Shares - gain/loss on defaults
Shares - weighted cashflow
Real estate - rent
Real estate - calls
Real estate - maturities
Real estate - salvage on default
Real estate - sales
Real estate - purchase commitments
Real estate - investment expenses
Real estate - reinvestments
Real estate - total cashflow
Real estate - gain/loss on defaults
Real estate - weighted cashflow
Other 1 - income
Other 1 - calls
Other 1 - maturities
Other 1 - salvage on default
Other 1 - sales
Other 1 - purchase commitments
Other 1 - investment expenses
Other 1 - reinvestments
Other 1 - total cashflow
Other 1 - gain/loss on defaults
Other 1 - weighted cashflow
Other 2 - income
Other 2 - calls
Other 2 - maturities
Other 2 - salvage on default
Other 2 - sales
Other 2 - purchase commitments
Other 2 - investment expenses
Other 2 - reinvestments
Other 2 - total cashflow
Other 2 - gain/loss on defaults
Other 2 - weighted cashflow
Cash - interest;Cash - interest;Cash - interest;Cash 1 - interest;Cash 1 - interest;Cash 1 - interest;Cash 2 - interest;Cash 2 - interest;Cash 2 - interest;Cash 3 - interest;Cash 3 - interest;Cash 3 - interest;Cash 4 - interest;Cash 4 - interest;Cash 4 - interest;
Cash - maturities;Cash - maturities;Cash - maturities;Cash 1 - maturities;Cash 1 - maturities;Cash 1 - maturities;Cash 2 - maturities;Cash 2 - maturities;Cash 2 - maturities;Cash 3 - maturities;Cash 3 - maturities;Cash 3 - maturities;Cash 4 - maturities;Cash 4 - maturities;Cash 4 - maturities;
Cash - purchase commitments;Cash - purchase commitments;Cash - purchase commitments;Cash 1 - purchase commitments;Cash 1 - purchase commitments;Cash 1 - purchase commitments;Cash 2 - purchase commitments;Cash 2 - purchase commitments;Cash 2 - purchase commitments;Cash 3 - purchase commitments;Cash 3 - purchase commitments;Cash 3 - purchase commitments;Cash 4 - purchase commitments;Cash 4 - purchase commitments;Cash 4 - purchase commitments;
Cash - investment expenses;Cash - investment expenses;Cash - investment expenses;Cash 1 - investment expenses;Cash 1 - investment expenses;Cash 1 - investment expenses;Cash 2 - investment expenses;Cash 2 - investment expenses;Cash 2 - investment expenses;Cash 3 - investment expenses;Cash 3 - investment expenses;Cash 3 - investment expenses;Cash 4 - investment expenses;Cash 4 - investment expenses;Cash 4 - investment expenses;
Cash - reinvestments; Cash - reinvestments;Cash 1 - reinvestments; Cash 1 - reinvestments
Cash - total cashflow;Cash - total cashflow;Cash - total cashflow;Cash 1 - total cashflow;Cash 1 - total cashflow;Cash 1 - total cashflow;Cash 2 - total cashflow;Cash 2 - total cashflow;Cash 2 - total cashflow;Cash 3 - total cashflow;Cash 3 - total cashflow;Cash 3 - total cashflow;Cash 4 - total cashflow;Cash 4 - total cashflow;Cash 4 - total cashflow
Cash - gain/loss on defaults
Cash - weighted cashflow;Cash - weighted cashflow;Cash - weighted cashflow;Cash 1 - weighted cashflow;Cash 1 - weighted cashflow;Cash 1 - weighted cashflow;Cash 2 - weighted cashflow;Cash 2 - weighted cashflow;Cash 2 - weighted cashflow;Cash 3 - weighted cashflow;Cash 3 - weighted cashflow;Cash 3 - weighted cashflow;Cash 4 - weighted cashflow;Cash 4 - weighted cashflow;Cash 4 - weighted cashflow
Cash 1 - book value;Cash 1 - book value;Cash 1 - book value;Cash 2 - book value;Cash 2 - book value;Cash 2 - book value;Cash 3 - book value;Cash 3 - book value;Cash 3 - book value;Cash 4 - book value;Cash 4 - book value;Cash 4 - book value;
Cash 1 - market value;Cash 1 - market value;Cash 1 - market value;Cash 2 - market value;Cash 2 - market value;Cash 2 - market value;Cash 3 - market value;Cash 3 - market value;Cash 3 - market value;Cash 4 - market value;Cash 4 - market value;Cash 4 - market value;
Category Reports
Alternative Financials
Total investment income for Book Profit Fund
Corporate tax on cashflow & reserve
Total investment income for required surplus
Corporate tax on required surplus
Before tax income on free surplus
Tax on free surplus
Reserve
Free surplus
Required surplus
YTD accumulated retained earnings
Total net cash flow
Accrued tax
Total Assets
Capital charge
Investment expenses
Net Miscellaneous Items
Asset Accounting Basis
Earned income
Amort. of prem/discount
Income from realized G/L
Income from unrealized G/L
Income from asset writedown
IMR Amortization
Gain/loss on defaults
Asset Accounting Basis - Total Income
Amortized cost basis
Unamortized realized gain
Amortized unrealized gain
Interest Maintenance Reserve
Book value available for sale
Accumulated OCI
Adjusted realized gain
Taxable investment income adjustment
Realized G/L transferred to IMR
Realized G/L transferred to AVR
Unrealized G/L transferred to AVR
Asset Category
Asset Category - earned income
Asset Category - amort of prem/discnt
Asset Category - income from realized G/L
Asset Category - income from unrealized G/L
Asset Category - IMR amortization
Asset Category - G/L on defaults
Asset Category - investment expenses
Asset Category - income cashflow
Asset Category - calls/prepayments
Asset Category - maturities
Asset Category - salvage value on default
Asset Category - sales
Asset Category - principal repaid
Asset Category - designated investment cash flow
Asset Category - outgo cashflow
Asset Category - reinvestment purchases
Reinvestment sales cashflow
Asset Category - reinvestment cashflow
Asset Category - reinvestment weighted cashflow
Asset Category - purchase commitments
Asset Category - investment expense cf
Asset Category - amortized cost basis (excluding accrued income)
Asset Category - accrued income
Asset Category - unamort realized gain
Asset Category - amort unrealized gain
Asset Category - interest maintenance reserve
Book value available for sale
Asset Category - market value (excluding accrued income)
Asset Category - total market value for asset sales
Asset Category - required surplus
Asset Category - adjusted realized gain
Asset Category - realized G/L transferred to IMR
Asset Category - realized G/L transferred to AVR
Asset Category - unrealized G/L transferred to AVR
Taxable investment income adjustment
Asset Category - weighted cashflow
Monthly cashflow
Embedded option value
Accrued interest for calls and sinking fund payments
Present Value of Asset Cashflow on the Yield Curve
Numerator of Asset Duration Formula
Mortgage - Outstanding Principal
Par Value
Asset Category - notional value (pay side)
Write-downs on impaired assets
Cash balance
Income from asset writedown
Asset Category - other charges
Asset Category - other charges cf
Asset Valuation Reserve
Realized capital gain/loss
Unrealized capital gain/loss
Basic Contribution
Accumulated balances
Maximum reserve
Reserve objective
Adj towards reserve objective
Balance before transfers
Transfers
Adjustment down to maximum/up to zero
Asset valuation reserve
Ceded Reserve
Reserve
RPU/ETI reserve
Disabled life reserve
DAC asset
Unearned revenue reserve
Dividend Details
+ New dividends to accumulate
+ Interest on accum dividends
- Accum dividends paid on lapse
- Accum dividends paid on maturity
- Accum dividends paid on partial surrender
- Accum dividends paid on death
- Accum dividends paid on other benefits
- Accum dividends to pay OYT and PUA
+ Other adjustment/accum dividends
Accum dividends end of period
Fund Movement
Fund Movement - deposits
Fund Movement - bonus
Fund Movement - equity index credited
Fund Movement - risk charge
Fund Movement - other benefit charge
Fund Movement - expense charge
Fund movement - waived risk charge
Fund movement - waived other benefit charge
Fund movement - waived expense charge
Fund Movement - premium load
Fund Movement - MVA charge
Fund Movement - reset/mat/GMWB guarantee payment
Fund Movement - interest credited
Fund Movement - released on lapse
Fund Movement - released on group lapse
Fund Movement - released on maturity
Fund Movement - released on death
Fund Movement - released on other benefit
Fund Movement - released on PWD
Fund Movement - released on OYT and PUA
Fund Movement - released on annuitization
Fund Movement - transfer
Fund Movement - other adjustments
Fund Movement - Balance
Fund Movement - GMWB payment
Greeks Report
Liability/Asset
Independent Other Benefit Reserve
Gross/Net - total liability
Gross/Net - total liability (type 1)
Gross/Net - total liability (type 2)
Gross/Net - total liability (type 3)
Gross/Net - total liability (type 4)
Gross/Net - deferred policy premium
Gross/Net - deferred premium asset
Gross/Net - unearned valuation premium
Gross/Net - basic reserve
Net nondeduction reserve
Net pro-rata reserve
Net aggregate reserve
Liability Category
Investment Target Amount
Expense charges / loads / fees
Fund at end of period
Group annuity fund skim X
Guar term deposits rolled over
Average benchmark rate
Designated Transfer Cashflow
Designated Transfer Weighted Cashflow
Average credited rate
Average bonus rate
Option Value of Hedged Guarantees
PV Fees for Hedged Guarantees
Interest Credited
Total Cash Flow Account
Total Reinvestment Account
Total Reinvestment Account Cash Flow
Total Reinvestment Account Purchases
Net Transfer
Net Transfer Weighted Cashflow
Income From Cash Flow Account
Income From Reinvestment Account
Investment Income On Cashflow
NAIC Details
Gross deferred policy prem
Gross deferred premium asset
Gross unearned valuation premium
Gross basic reserve
Gross deficiency reserve
Net deferred policy premium
Net deferred premium asset
Net unearned valuation premium
Net basic reserve
Net deficiency reserve
Net nondeduction reserve
Net pro-rata reserve
Net CSV deficiency
Net aggregate reserve
Deposit contracts
AG34 Reserve
AG39 Reserve
NAIC Financials
Gross deferred policy premium
Gross deferred premium asset
Net deferred policy premium
Net deferred premium asset
Aggregate reserve
Provision for policyholders' dividends
Deferred tax asset
Required surplus
Total assets on NAIC basis
Tax on Realized capital gain (loss)
Tax on Change in net unrealized capital gain (loss)
Investment income on NAIC basis
Notional Account Reconciliation
Notional account balance
Notional account deposits
Notional account premium load
Notional account risk charge
Notional account other benefit charge
Notional account expense charge
Notional account interest credited
Notional account released on lapse
Notional account released on guar end
Notional account released on death
Notional account released on oth benefit
Notional account released on partial withdrawal
Notional account average credited rate
Policy Loan Movement
Policy Loan - loan taken
Policy Loan - interest
Policy Loan - repayment
Policy Loan - released on lapse
Policy Loan - release on maturity
Policy Loan - released on death
Policy Loan - release on other benefit
Policy Loan - other adjustments
Policy Loan - Balance
Reinsurance Treaty
Premium component 1
Premium component 2
Aggregate premium 1 min
Aggregate premium 2 min
Aggregate premium 1 max
Aggregate premium 2 max
Aggregate total premium max
Eligible claims
Aggregate claim deductible
Aggregate claim limit
Direct premium
Min ann inc base - inforce
Min ann inc base - waiting period
Min ann inc base - annuitized
Gross claim
Gross claim offset
Premium - first year
Premium - renewal
Annualized Premium - inforce
Annualized Premium - written
Premium per initial face
Premium - first year other ben
Premium - renewal other ben
Ceded premium - treaty level
Premium tax
Commission - first year
Commission - renewal
Commission - bonus
Commission - other benefit
Chargeback
Benefits - death
Benefits - disability
Benefits - surrender
Benefits - ROP to survivors
Benefits - maturity
Ceded benefits - treaty level
Benefits - other 1
Benefits - other 2
Benefits - other 3
Benefits - other 4
Benefits - cash dividends
Modco adj due to interest
Modco adj due to change in reserve
Modco reserve
NB face amount
NB monthly income
Inforce face amount
Inforce monthly income
Inforce other benefit 1
Inforce other benefit 2
Inforce other benefit 3
Inforce other benefit 4
Inforce ceded paid - up face amount
Inforce ceded ETI face
Required Surplus Basis
Lapse risk component
Lapse risk comp group A
Lapse risk comp group B
MCCSR expected claims
MCCSR mortality variance
MCCSR mortality duration numerator
MCCSR mortality duration denominator
Negative reserve
Tax affected neg res
Negative reserves reduction
Cash Value deficiency
Required Surplus Report
Required surplus
Impact of unregistered reins
Required capital
Investment account funds
Investment account C1
Required Capital - C1
Required Capital - C2
Required Capital - C3
Required Capital - C4
Required Capital - Other
Available capital tier 2
Approp. for unlicenced reinsurance
Lapse risk component
MCCSR mortality volatility component
MCCSR mortality component in C2
MCCSR mortality catastrophe component
MCCSR mortality variance
MCCSR mortality duration numerator
Net benefit amount
Premium
Claims
NAAR
Cash value deficiency
Neg reserves
Tax affected neg reserves
Negative reserves reduction
Reserve in TAR
DAC in TAR
Time zero required surplus
MCCSR Available capital tier 1
MCCSR Available capital tier 2
MCCSR required capital
MCCSR C1 required capital
MCCSR ratio
Approp for DTA
Seg fund factor method
Asset required surplus
Factor for impaired asset write-downs
Reserve
Gross reserve
Gross disabled life reserve
Gross ETI reserve
Gross paid up reserve
Gross deferred tax liability
Net reserve
Net disabled life reserve
Net ETI reserve
Net paid up reserve
Net deferred tax liability
Deferred tax liability for disabled life reserves
Net DTL for DAC tax
Net DTL for tax loss carryforward
Net statement reserve
Net statement DTL/DTA
Net statement DLR DTL/DTA
Provision for dividend
Net Additional Dividend Liability
Seg fund factor method reserve
Time zero net reserve
Time zero net deferred tax liability
Assumed disabled lives in the ALR factor
Net reserve from lower level
Net DLR from lower level
Reserve Components
Reserve Components
Residual margin
Reserve Release
Released on death
Released on Incidence
Released on surrender
Released on forced termination
Released on other ben dec
Release on DI termination
Release on annuitization
Reserve at period end
Solvency Capital Requirement Details
SCR - reinsurance default
SCR life - mortality
SCR life - mortality catastrophe
SCR life - expense
SCR life - lapse
SCR life - longevity
SCR life - disability
SCR life - diversification
SCR health
SCR non-life
SCR market - interest
SCR market - spread risk
SCR diversification
SCR operational
SCR deferred tax liability offset
US GAAP Cohort Category
Policyholder fund at end of period
Segregated fund at end of period
Surrender charges / MVA
Excess death benefit payments
Weighted excess DB payments
Excess annuitization payments
Gross maintenance costs
Interest credited
Deferable costs
Weighted deferrable costs
Gross liability cashflow
Weighted GCF for int calc
Ceded prems less benefits
Weighted ceded prems less benefits
Policyholder fund cashflow
Weighted policyholder fund cashflow
UL mortality risk charges
UL other benefit risk charges
UL premium loads
UL expense charges
UL surrender charges
UL total policy charges
Weighted UL Total policy charges
Credited rate times fund value
Gross assessments for SOP 03-1
Investment Income
EGP fund rollup
Deferrable expense fund rollup
Excess death ben payment fund rollup
Excess ann payment fund rollup
Exp assessment fund rollup for SOP 03-1
Expected gross profit
GMIB SOP 03-1 liability
GMDB SOP 03-1 liability
FAS 97 unamortized DAC balance
SOP 03-1 EGP adjustment
Net unearned revenue or div c/f
Net unearned revenue or div wgt c/f
Net residual expenses
Net residual expenses weighted c/f
Sales Inducements
Weighted sales inducements
Gross unearned revenue
Gross unearned revenue wgt c/f
Total net cashflow
Net weighted cashflow
DAC amortization - PV of terminal/surrender dividends
BP fund basis for earn rate calc
BP fund investment income
FAS 97 weighted EGP
FAS 97 estimated gross profit
FAS 97 expense margin
FAS 97 mortality margin
FAS 97 bonus margin
FAS 97 annuitization margin
FAS 97 surrender margin
FAS 97 other ben margin
FAS 97 interest margin
FAS 97 other margin
FAS 97 maintenance expenses
AV released on death
Death claims
FAS 97 interest earned on fund
Seg fund management fees
US GAAP Details
Required interest
Net DAC capitalized
Net DAC amortized and interest
Net DAC interest
Net DAC amortized
Net DAC asset
GAAP reserve
Net maint expense reserve
Net unearned revenue reserve
Net URR capitalized
Net URR interest
Net URR amortized
VOBA asset
Net PV assessments for SOP 03-1
Net PV excess DB for SOP 03-1
Net SOP 03-1 excess DB liability
Gross PV assessments for SOP 03-1
Gross PV excess DB for SOP 03-1
Gross GAAP reserve
Deposit contracts
Gross unearned revenue reserve
Net terminal dividend liability
Gross PV benefit reserve premium
Gross PV DAC asset premium
Gross PV unearned revenue reserve premium
Gross PV deferrable costs
Gross PV maintenance costs
Sales inducement asset capitalized
Sales inducement asset interest
Sales inducement asset amortized
Sales inducement asset
Gross PV unearned revenue
Ceded PV benefit reserve premium
Ceded PV DAC asset premium
Ceded PV unearned revenue reserve premium
Ceded PV deferrable costs
Ceded PV maintenance costs
Net PV unearned revenue
PV sales inducements
PV estimated gross profits
PV estimated gross profits - DAC
EGP-to-date this transfer period
EGP-to-date this trans period - DAC
Net DAC capitalized - Expense
Net DAC interest - Expense
Net DAC amortized - Expense
Net DAC asset - Expense
Gross unearned benefit reserve premium
Gross unearned DAC asset premium
Gross unearned URR premium
Gross unearned maintenance expense premium
Ceded unearned benefit reserve premium
Ceded unearned DAC asset premium
Ceded unearned URR premium
Ceded unearned maintenance expense premium
FAS 97 net DAC K-factor
FAS 97 net URR K-factor
FAS 97 gross URR K-factor
SOP 03-1 net benefit ratio
SOP 03-1 gross benefit ratio
FAS 97 sales inducement K-factor
FAS 97 discount rate
Accumulated net EGPs
Accumulated gross EGPs
Accumulated net deferred acq exp
Accumulated net unearned revenue
Accumulated gross unearned revenue
Accumulated net assessments
Accumulated gross assessments
Accumulated net excess benefits
Accumulated gross excess benefits
Accumulated chg in net SOP 03-1
Accumulated chg in gross SOP 03-1
Accumulated chg in net URR
Accumulated chg in gross URR
PV chg in net SOP 03-1 reserve
PV chg in gross SOP 03-1 reserve
PV chg in net URR
PV chg in gross URR
Net PV deferrable costs
US GAAP Financials
GAAP reserve
Net DAC asset
Net UE revenue reserve
Required interest
DAC capitalized
DAC amortized
Deferred tax liability
GAAP required surplus
Total assets on US GAAP basis
VOBA asset
Gross GAAP reserve
Gross UE revenue reserve
Investment income on US GAAP basis
Investment income on GAAP free surplus
Tax on investment income of GAAP free surplus
EBS
Coverage movement - death/incurrals
Coverage movement - deaths
Coverage movement - lapses
Coverage movement - forced termination
Coverage movement - reinstatement
Coverage movement - maturities
Coverage movement - other benefits
Coverage movement - terminations
Coverage movement - recoveries
Coverage movement - DI lump sum settlements
Coverage movement - incurrals
Coverage movement - annuitizations
Coverage movement - conversions
Coverage movement - expiries
Coverage movement - miscellaneous off
Coverage movement - miscellaneous on
Coverage movement - DI deaths
Amount movement - death/incurrals
Amount movement - deaths
Amount movement - lapses
Amount movement - forced termination
Amount movement - DI lump sum settlements
Amount movement - maturities
Amount movement - other benefits
Amount movement - recoveries
Amount movement - incurrals
Amount movement - annuitizations
Amount movement - conversions
Amount movement - miscellaneous off
Amount movement - miscellaneous on
Amount movement - DI deaths
Nominal amount movement - deaths
Nominal amount movement - lapses
Nominal amount movement - forced termination
Nominal amount movement - maturity
Nominal amount movement - other benefits
Nominal amount movement - reinstatement
Nominal amount movement - miscellaneous off
Nominal amount movement - miscellaneous on
Nominal amount movement - DI deaths
Nominal amount movement - terminations
Nominal amount movement - recoveries
Nominal amount movement - incurrals
Reserve less PFAD at issue
Expected interest on time zero reserve
PFAD at issue
Reserve adjustment for late reported new business
DAC adjustment for late reported new business
Unearned Revenue Reserve adjustment for late reported new business
Cashflow adjustment for late reported new business
DAC cashflow adjustment for late reported new business
URR cashflow adjustment for late reported new business
Actual fund for late reported new business
Expected fund for late reported new business
Actual premium
Actual Valuation Premium
Actual change in DPA
Actual DAC amortization
Actual Unearned Revenue Reserve Amortization
Actual premium
Actual deposit
Expected premium
Expected Valuation Premium
Expected DAC amortization
Expected DAC capitalization - non-issue
Expected DAC capitalization - issue
Expected Unearned Revenue Reserve amortization
Expected Unearned Revenue
Expected premium
Expected deposit
Act release of premium PFAD
Exp release of premium PFAD
Expected change in DPA
Actual investment income: Traditional
Actual DAC investment income
Actual URR investment income
Actual investment income: Fund based
Actual interest on PV of margins
Actual credited interest
Actual bonus
Expected investment income: Traditional
Expected DAC investment income
Expected Unearned Revenue Reserve investment income: Traditional
Expected investment income: Fund based
Expected interest on PV of margins
Expected credited interest
Expected bonus
Actual release of interest PFAD
Vendor Defined RMA Report - Expected release of interest PFAD
Act release of benchmark rate PFAD
Exp release of benchmark rate PFAD
Expected commission
Actual commission
Expected expense
Expected maintenance costs
Expected expense
Expected expense charge
Actual expense
Actual deferrable costs - issue
Actual deferrable costs - non-issue
Actual unearned revenue
Actual maintenance costs
Actual residual costs
Actual expense
Actual expense charge
Actual release of expense PFAD
Vendor Defined RMA Report - Expected release of expense PFAD
Act release of seg fund fee PFAD
Exp release of seg fund fee PFAD
Expected death benefit: Traditional
Expected death benefit: Fund based
Expected risk charge
Expected reserve less PFAD release on deaths
Expected PV of margins released on death
Expected fund released on death
Actual release of mortality PFAD
Vendor Defined RMA Report - Expected release of mortality PFAD
Actual death benefit: Traditional
Actual death benefit: Fund based
Actual risk charge
Actual reserve less PFAD released on deaths
Actual PV of margins released on death
Actual fund released on death
Cashflow adjustment for late reported death
Expected surrender benefit: Traditional
Expected surrender benefit: Fund based
Expected partial withdrawal benefit
Expected reserve less PFAD release on surrenders
Expected PV of margins released on surrender
Expected PV of margins released on forced termination
Expected fund released on surrender
Expected fund released on partial withdrawal
Act release of part withdrawal PFAD
Exp release of part withdrawal PFAD
Actual release of surrender PFAD
Vendor Defined RMA Report - Expected release of surrender PFAD
Actual surrender benefit: Traditional
Actual surrender benefit: Fund based
Actual partial withdrawal benefit
Actual reserve less PFAD released on surrenders
Actual PV of margins released on surrender
Actual PV of margins released on forced termination
Actual fund released on surrender
Actual fund released on partial withdrawal
Cashflow adjustment for late reported lapse
Cashflow adjustment for reinstatement
Actual reserve less PFAD increase on reinstatement
PFAD at reinstatement
Interest adjustment on reinstatement
Expected other benefit: Traditional
Expected other benefit: Fund based
Expected other benefit charge
Expected reserve less PFAD release on other benefits
Expected PV of margins released on other benefit
Expected fund released on other benefit
Actual release of other benefit PFAD
Vendor Defined RMA Report - Expected release of other ben PFAD
Actual other benefit: Traditional
Actual other benefit: Fund based
Actual other benefit charge
Actual reserve less PFAD released on other benefits
Actual PV of margins released on other benefit
Actual fund released on other benefit
Cashflow adjustment for late reported other benefit
Expected dividend and ROP
Actual dividend and ROP
Actual seg fund cashflow
Expected seg fund cashflow
Actual des fund cashflow
Expected des fund cashflow
Expected payout
Actual payout
Expected annuitization benefit
Expected PV of margins released on annuitization
Expected fund released on annuitization
Actual annuitization benefit
Actual PV of margins released on annuitization
Actual fund released on annuitization
Actual release of annuitization PFAD
Expected release of annuitization PFAD
Vendor Defined RMA Report - Expected cost of incurral, ALR basis
Actual disability benefits
Period end reserve on period start basis: Traditional
Period end reserve on expected period end fund
Expected period end fund
Actual reserve: Traditional
Actual reserve: Fund based
Expected reserve on actual period end fund
Actual period end fund
Expected cost of cause 1 incurral, PADded ALR basis
Expected cost of cause 1 incurrals, ALR basis
Expected release of ALR on cause 1 incurrals
Expected cost of cause 2 incurral, PADded ALR basis
Expected cost of cause 2 incurrals, ALR basis
Expected release of ALR on cause 2 incurrals
Expected cost of cause 3 incurral, PADded ALR basis
Expected cost of cause 3 incurrals, ALR basis
Expected release of ALR on cause 3 incurrals
Actual cost of cause 1 incurral, PADded DLR basis
Actual cost of cause 1 incurral, DLR basis
Actual release of ALR on cause 1 incurral
Cashflow adjustment for late reported cause 1 incurrals
Actual cost of cause 2 incurral, PADded DLR basis
Actual cost of cause 3 incurral, PADded DLR basis
Actual cost of cause 2 incurral, DLR basis
Actual cost of cause 3 incurral, DLR basis
Actual release of ALR on cause 2 incurral
Actual release of ALR on cause 3 incurral
Cashflow adjustment for late reported cause 2 incurrals
Cashflow adjustment for late reported cause 3 incurrals
Increase in IBNR
Actual release of disability PFAD
Expected disability claim payments cause 1
Expected DI death benefits cause 1
Expected DLR less PFAD released on terminations cause 1
Expected ALR less PFAD required on recovery cause 1
Expected disability claim payments cause 2
Expected disability claim payments cause 3
Expected DI death benefits cause 2
Expected DI death benefits cause 3
Expected DLR less PFAD released on terminations cause 2
Expected DLR less PFAD released on terminations cause 3
Expected ALR less PFAD required on recovery cause 2
Expected ALR less PFAD required on recovery cause 3
Actual disability claim payments cause 1
Actual DI death benefits cause 1
Actual DLR less PFAD released on termination cause 1
Actual ALR less PFAD required on recovery cause 1
Actual disability claim payments cause 2
Actual disability claim payments cause 3
Actual DI death benefits cause 2
Actual DI death benefits cause 3
Actual DLR less PFAD released on termination cause 2
Actual DLR less PFAD released on termination cause 3
Actual ALR less PFAD required on recovery cause 2
Actual ALR less PFAD required on recovery cause 3
Actual ALR less PFAD released on DI termination cause 1
Actual ALR less PFAD released on DI termination cause 2
Actual ALR less PFAD released on DI termination cause 3
Reserve (ALR) released on DI termination
Release of DLR less PFAD on settlement
Release of DLR less PFAD on claim adjustment
Actual DLR less PFAD released on claim adjustment cause 1
Actual DLR less PFAD released on claim adjustment cause 2
Actual DLR less PFAD released on claim adjustment cause 3
Actual release of disability termination PFAD (DLR)
Actual release of PFAD on claim adjustment
Vendor Defined RMA Report - Res increase from DI recoveries
Vendor Defined RMA Report - Expected res increase from DI recoveries
Vendor Defined RMA Report - Expected release of DI incidence PFAD
Vendor Defined RMA Report (DLR) - DLR increase from new claims
Vendor Defined RMA Report (DLR) - Expected investment income on DLR
Vendor Defined RMA Report (DLR) - Expected DI claims expense
Vendor Defined RMA Report (DLR) - Expected release of interest PFAD (DLR)
Vendor Defined RMA Report (DLR) - Expected release of expense PFAD (DLR)
Vendor Defined RMA Report (DLR) - Expected release of DI termination PFAD (DLR)
Expected release of recovery PFAD (DLR)
Vendor Defined RMA Report (DLR) - Expected DLR released on DI death
Vendor Defined RMA Report (DLR) - Expected DLR released on recovery
Vendor Defined RMA Report (DLR) - DLR released on DI death
Vendor Defined RMA Report (DLR) - DLR released on recovery
Vendor Defined RMA Report (DLR) - DLR released on settlements
Vendor Defined RMA Report (DLR) - DLR released on claim adjustment
Vendor Defined RMA Report (DLR) - Revaluation gain - DLR assumptions
Reserve less PFAD released on miscellaneous off
Actual PV of margins for miscellaneous off
Cashflow on Miscellaneous Off
Actual release of PFAD for Miscellaneous transactions
Reserve less PFAD at miscellaneous on
DAC asset increase from miscellaneous ons
Actual PV of margins for miscellaneous on
Cashflow on Miscellaneous On
Actual release of PFAD for Miscellaneous transactions
Revaluation gain - fund movement
Vendor Defined RMA Report - Revaluation gain - assumptions: Traditional
Revaluation gain - assumptions: Fund based
Fund adjustment gain
Disabled - gross - monthly income cause 1
Disabled - gross - monthly income cause 2
Disabled - gross - monthly income cause 3
Disabled - net - monthly income cause 1
Disabled - net - monthly income cause 2
Disabled - net - monthly income cause 3
Number of disabled lives - disabled cause 1
Number of disabled lives - disabled cause 2
Number of disabled lives - disabled cause 3
Disabled life movement - recoveries cause 1
Disabled life movement - recoveries cause 2
Disabled life movement - recoveries cause 3
Disabled life movement - settlements cause 1
Disabled life movement - settlements cause 2
Disabled life movement - settlements cause 3
Disabled life movement - incurrals cause 1
Disabled life movement - incurrals cause 2
Disabled life movement - incurrals cause 3
Disabled life movement - deaths cause 1
Disabled life movement - deaths cause 2
Disabled life movement - deaths cause 3
Disabled life movement - benefit period end cause 1
Disabled life movement - benefit period end cause 2
Disabled life movement - benefit period end cause 3
Expected number of disabled lives - disabled cause 1
Expected number of disabled lives - disabled cause 2
Expected number of disabled lives - disabled cause 3
Expected coverage movement - inforce
Expected coverage movement - deaths
Expected coverage movement - lapses
Expected coverage movement - forced termination
Expected coverage movement - maturities
Expected coverage movement - other benefits
Expected coverage movement - terminations
Expected disabled life movement - recoveries cause 1
Expected disabled life movement - recoveries cause 2
Expected disabled life movement - recoveries cause 3
Expected coverage movement - recoveries
Expected coverage movement - incurrals
Expected coverage movement - incurrals
Vendor Defined RMA Report - Reserve released on annuitization
Expected coverage movement - incurrals
Expected coverage movement - annuitizations
Expected coverage movement - conversions
Expected coverage movement - expiries
Expected disabled life movement - deaths cause 1
Expected disabled life movement - deaths cause 2
Expected disabled life movement - deaths cause 3
Expected disabled life movement - benefit period end cause 1
Expected disabled life movement - benefit period end cause 2
Expected disabled life movement - benefit period end cause 3
Disabled life monthly income movement - settlement cause 1
Disabled life monthly income movement - settlement cause 2
Disabled life monthly income movement - settlement cause 3
Disabled life monthly income movement - recoveries cause 1
Disabled life monthly income movement - recoveries cause 2
Disabled life monthly income movement - recoveries cause 3
Active life monthly income movement - incurrals cause 1
Active life monthly income movement - incurrals cause 2
Active life monthly income movement - incurrals cause 3
Disabled life monthly income movement - deaths cause 1
Disabled life monthly income movement - deaths cause 2
Disabled life monthly income movement - deaths cause 3
Disabled life monthly income movement - benefit period end cause 1
Disabled life monthly income movement - benefit period end cause 2
Disabled life monthly income movement - benefit period end cause 3
Expected amount movement - inforce
Expected active life monthly income - inforce
Expected disabled life monthly income - disabled cause 1
Expected disabled life monthly income - disabled cause 2
Expected disabled life monthly income - disabled cause 3
Expected amount movement - deaths
Expected amount movement - lapses
Expected amount movement - forced termination
Amount movement - lapses
Expected active life monthly income movement - lapses
Active life monthly income movement - reinstatements
Expected amount movement - maturities
Amount movement - maturities
Expected active life monthly income movement - maturities
Expected amount movement - other benefits
Amount movement - other benefits
Expected active life monthly income movement - other benefits
Expected amount movement - terminations
Amount movement - recoveries
Expected disabled life monthly income movement - recoveries cause 1
Expected disabled life monthly income movement - recoveries cause 2
Expected disabled life monthly income movement - recoveries cause 3
Expected active life monthly income movement - recoveries
Expected active life monthly income movement - incurrals
Expected active life monthly income movement - incurrals
Expected active life monthly income movement - incurrals
Active life monthly income movement - incurrals
Expected active life monthly income movement - incurrals
Expected amount movement - annuitizations
Expected amount movement - conversions
Expected disabled life monthly income movement - deaths cause 1
Expected disabled life monthly income movement - deaths cause 2
Expected disabled life monthly income movement - deaths cause 3
Expected disabled life monthly income movement - benefit period end cause 1
Expected disabled life monthly income movement - benefit period end cause 2
Expected disabled life monthly income movement - benefit period end cause 3
Amount movement - miscellaneous on
Amount movement - miscellaneous off
Exp nom amount movement - inforce
Exp nominal amount movement - deaths
Exp nominal amount movement - lapses
Exp nominal amount movement - forced termination
Exp nominal amount movement - maturity
Exp nominal amount movement - other benefits
Vendor Defined RMA Report - Expected reserve released on death
Vendor Defined RMA Report - Expected reserve released on surrender
Vendor Defined RMA Report - Expected reserve released on other benefit decrement
Vendor Defined RMA Report - Expected reserve released on incurral
Vendor Defined RMA Report - Expected reserve released on annuitization
Expected DAC asset released on death
Expected DAC asset released on surrender
Expected DAC asset released on other benefit
Expected DAC asset released on incurral
Expected DAC asset increase from DI recoveries
Expected Unearned Revenue Reserve released on death
Expected Unearned Revenue Reserve released on surrender
Expected Unearned Revenue Reserve released on other benefit
Expected Unearned Revenue Reserve released on incurral
Expected Unearned Revenue Reserve increase from DI recoveries
Vendor Defined RMA Report - Reserve released on death
Vendor Defined RMA Report - Reserve released on incurral
DAC asset released on death
DAC asset released on incurral
DAC asset increase from DI recoveries
DAC asset released on surrender
DAC asset released on other benefit
DAC asset released from miscellaneous off
DAC asset released on DI terminations
Unearned Revenue Reserve released on death
Unearned Revenue Reserve released on incurral
Unearned Revenue Reserve increase from DI recoveries
Unearned Revenue Reserve released on surrender
Unearned Revenue Reserve released on other benefit
Unearned Revenue Reserve released on miscellaneous off
Unearned Revenue Reserve released on DI termination
Expected Ceded Premium Adjustment
Actual Ceded Premium Adjustment
YRT ceded death benefit cost adjustment
YRT ceded other benefit cost adjustment
YRT ceded cost of cause 2 incurrals adjustment
YRT ceded cost of cause 3 incurrals adjustment
YRT ceded cost of cause 1 incurrals adjustment
YRT ceded dividend and ROP adjustment
YRT ceded cost adjustment
YRT ceded premium adjustment
YRT ceded credit adjustment
Fund and Office Levels
Asset Valuation Reserve
Annuity
GMDB excess over fund value
GMAB excess over fund value
Block Calendar Year Projections
Net liability cashflow (Cell)
Weighted CF for int calc (Cell)
Annuitization Benefit in Excess of Fund Value
Death Benefit in Excess of Fund Value
Working reserve (Cell)
Gross liability cashflow (Cell)
DAC tax basis amount (Cell)
Gross Premium - First Year
Gross Premium - Renewal Year
Premium load
Gross premium tax
Gross benefits - death
Gross benefits - surrender
Gross benefits - maturity
Gross benefits - accum ph payout
Gross benefits - annuitization
Gross transfer from segregated fund
Gross segregated fund fees received
Ceded premium - first year
Ceded premium renewal
Ceded Benefits - Death
Ceded Benefits - Maturity
Total ceded cashflow (Cell)
Expenses
Gross - statutory reserve
Gross - tax reserve
Gross commission - first year
Gross commission - renewal
Gross commission
Gross chargeback
Exp per exp benchmark - per fund A
Exp per exp benchmark - per fund B
Total expense - first year
Total expense - renewal
Change in actuarial reserve
Change in required surplus
Annuity / UL exp chg per fund - category A
Annuity / UL exp chg per fund - category B
Annuity / UL exp chg per fund - category C
Annuity exp chg per min ann base
Annuity exp chg per death ben
Annuity exp chg per GMWB table
Annuity GMWB extra DB payment
Annuity GMWB Expense Benchmark
Annuity GMDB excess over fund
Annuity GMAB excess over fund
Annuity partial withdrawal under GMWB
Annuity partial withdrawal under LIA
Dumpin Premium
Annuity fund interest credited
Annuity fund at end of period
CSV at end of period
Annuity guar fund 1 end of period
Annuity guar fund 2 end of period
Annuity guar fund 3 end of period
Annuity guar fund 4 end of period
Annuity guar fund 5 end of period
GMWB base at end of period
DAC Adjustment from Cell
Taxable income adjustment from cell
Commission Per Group Assets
Commission Per Group Recurring Premium
Group Annuity Base Asset Charge
Group Annuity Supplemental Asset Charge
Group Participant Fee - Charged
Group Participant Fee - Billed
Non-Issue Expenses Per Group
Non-Issue Expenses Per Certificate
Surrender Charges / MVA
Annualized UL prem written below T1
Annualized UL prem written above T1
Gross Face Amount Inforce
UL fund included in face amount
UL additional face amount due to corridor
UL death benefits due to continuation guarantee
Tier 1 for UL commission for NB written
No of coverages inforce
Number of Coverages - Inforce Groups
Number of Certificates Inforce at Start
Investment income on cashflow & reserve
Invest income adjustment on cashflow & reserve
Invest income adjustment on reqired surplus
Profit on cashflow & reserve
Total statement profit
Before tax income on req surplus
After tax income on free surplus
Segregated fund at end of period
Group participant fee additional
Net Bonus Paid to Segregated Fund
Coverage movement - deaths
Coverage movement - lapses
Coverage movement - maturities
Coverage movement - other benefits
Coverage movement - annuitizations
Net Liability Cashflow (pre-tax)
Weighted pre-tax CF for int calc
Ceded premium - treaty level
Ceded benefits - treaty level
Total DAC
Total reserves
Required surplus
Net liability cashflow (after-tax)
Contribution to free surplus
Working reserve
Total corporate tax
Accrued tax
Free surplus
Present value of surplus
Discount interest rate
General account interest rate
DAC tax basis amount
Total asset cashflow
Investment income on cashflow
Amount available for reinvestment
Net flow from cashflow account
Reinvestment account - income
Reinvestment account - maturities
Balance to reinvestment account
Book value available for sale
Total book value of invested assets
Total assets
Market value of invested assets
Market value available for sale
Asset cashflow in month
Liability duration used
Asset duration used
PV of pre-tax CF on discount rate
Net earned rate
Earnings by Source
Vendor Defined Traditional EBS Report
Overview of Traditional EBS Report
EBS Calendar Year Projection Lines
Cashflow adj for late reporting
Reserve adj for late reporting
Res less PFAD at issue
Expected interest on time zero reserve
PFAD at issue
Actual premium
Expected premium
Actual investment income
Expected investment income
Actual release of interest PFAD
Expected commission
Actual commission
Expected expense
Actual expense
Actual release of expense PFAD
Expected death benefit
Exp res less PFAD rel on deaths
Actual death benefit
Act res less PFAD rel on deaths
Expected payout
Actual payout
Actual release of mortality PFAD
Expected other benefit
Exp res less PFAD rel on other benefits
Actual other benefit
Act res less PFAD rel on other bens
Actual release of other ben PFAD
CF adj for late report other benefit
Expected lapse benefit
Exp res less PFAD rel on lapses
Actual lapse benefit
Act res less PFAD rel on lapses
Actual release of lapse PFAD
Expected annuitization
Exp res less PFAD rel annuitization
Actual annuitization
Actual res less PFAD rel annuitization
Expected payout
Actual payout
Exp cost of C1 incurral, ALR basis
Exp rel of ALR on C1 incurrals
Exp ALR less PFAD req on recover C1
Exp cost of C2 incurral, ALR basis
Exp rel of ALR on C2 incurrals
Exp ALR less PFAD req on recover C2
Act cost of C1 incurral, DLR basis
Act rel of ALR on C1 incurrals
Act cost of C2 incurral, DLR basis
Act rel of ALR on C2 incurrals
CF adj for late report C1 incurrals
CF adj for late report C2 incurrals
Act release of disab PFAD
Exp disability claim payments C1
Exp DI death payments C1
Exp DLR less PFAD rel on term C1
Exp disability claim payments C2
Exp DI death payments C2
Exp DLR less PFAD rel on term C2
Act disability claim payments C1
Act DI death payments C1
Act DLR less PFAD rel on term C1
Act ALR less PFAD req on recover C1
Act disability claim payments C2
Act DI death payments C2
Act DLR less PFAD rel on term C2
Act ALR less PFAD req on recover C2
Reserve release on claim adjustemnt
Act rel of disab term PFAD (DLR)
Expected dividend and ROP
Actual dividend and ROP
Cashflow on Misc Off
Reserve less PFAD released on Misc Off
Cashflow on Misc On
Reserve less PFAD at Misc On
Net increase in PFAD for policy change
Actual seg fund cashflow
Expected seg fund cashflow
Actual des fund cashflow
Expected des fund cashflow
P/e reserves on p/s basis
Actual period end reserve
EBS Report CY Row Formulas
Total Late Reporting Gain
Total New Business Gain
Total Premium Gain
Total Interest Gain
Total Commission Gain
Total Expense Gain
Total Mortality Gain
Expected Mortality Cost
Actual Mortality Cost
Total Lapse Gain
Expected Lapse Cost
Actual Lapse Cost
Total Other Benefit Gain
Expected Other Benefit Cost
Actual Other Benefit Cost
Total Annuitization Gain
Expected Annuitization Cost
Actual Annuitization Cost
Exp Net Cost of Incurrals
Act Net Cost of Incurrals
Total Disability Incidence Gain
Exp Cost of Disability Claim Runoff
Act Cost of Disability Claim Runoff
Total Disability Claim Payment Gain
Total Dividend Gain
Total Policy Change Gain
Total Seg Fund Cashflow Gain
Total Designated Fund Cashflow Gain
Gain from Valuation Basis Change
Total EBS Gain
Investment Income Adjustment
Other Residual Adjustment
Total Gain
Vendor Defined Fund Based EBS Report
Overview of Fund Based EBS Report
Cashflow adjustment for late reporting
Reserve adjustment for late reporting
Expected fund for late reporting
Actual fund for late reporting
Total late reporting gain
Reserve less PFAD at issue
PFAD at issue
Total new business gain
Actual premium
Actual deposit
Expected premium
Expected deposit
Total premium gain
Actual investment income (Fund based)
Actual interest on PV of spreads
Actual credited interest
Actual bonus
Actual investment income spread
Expected investment income (Fund based)
Expected interest on PV of spreads
Expected credited interest
Expected bonus
Expected investment income spread
Total investment income spread gain
Actual interest on PV of spreads
Actual release of interest PFAD
Total investment income gain (Fund based)
Expected commission
Actual commission
Total commission gain
Actual expense charge
Actual expense
Expected expense charge
Expected expense
Actual release of expense PFAD
Total expense gain (Fund based)
Actual risk charge
Actual death benefit (Fund based)
Actual fund released on death
Actual mortality spread
Expected risk charge
Expected death benefit (Fund based)
Expected fund released on death
Expected mortality spread
Total mortality spread gain
Expected payout
Actual payout
Total payout gain
Actual PV of spreads released on death
Expected PV of spreads released on death
Actual release of mortality PFAD
Total mortality gain (Fund based)
Actual other benefit charge
Actual other benefit (Fund based)
Actual fund released on other benefit
Actual other benefit spread
Expected other benefit charge
Expected other benefit (Fund based)
Expected fund released on other benefit
Expected other benefit spread
Total other benefit spread gain
Actual PV of spreads released on other benefit
Expected PV of spreads released on other benefit
Actual release of other benefit PFAD
Total other benefit gain (Fund based)
Actual fund released on partial withdrawal
Actual partial withdrawal benefit
Actual partial withdrawal charge
Expected fund released on partial withdrawal
Expected partial withdrawal benefit
Expected partial withdrawal charge
Total partial withdrawal charge gain
Actual fund released on surrender
Actual surrender benefit (Fund based)
Actual surrender charge
Expected fund released on surrender
Expected surrender benefit (Fund based)
Expected surrender charge
Total surrender charge gain
Actual PV of spreads released on surrender
Expected PV of spreads released on surrender
Actual release of surrender PFAD
Total Surrender Gain (Fund based)
Period end reserve on period start basis
Period end fund on period start basis
Actual period end reserve
Actual period end fund
Revaluation gain
Fund adjustment gain
Total valuation basis change gain
Total EBS gain
Investment income adjustment
Other residual adjustment
Total gain
Vendor Defined RMA Report
Overview of RMA Report
RMA Calendar Year Projection Lines
Reserve increase from DI recoveries
Exp res increase from DI recoveries
Expected premium
Exp investment income
Exp investment income on DLR
Expected commission
Expected expense
Exp DI claims expense
Expected lapse benefit
Expected other benefit
Expected payout
Exp cost of incurral, ALR basis
Expected dividend and ROP
Expected release of interest PFAD
Expected release of expense PFAD
Expected release of mortality PFAD
Expected release of lapse PFAD
Expected release of other ben PFAD
Exp release of disab PFAD ALR basis
Exp reserve rel on death
Exp reserve rel on lapse
Exp reserve rel on other ben dec
Exp reserve rel on incurral
Exp reserve rel on annuitization
Reserve rel on death
Reserve rel on lapse
Reserve rel on other benefit
Reserve rel on incurral
Reserve less PFAD rel on Misc Off
PFAD rel on Misc Off
Revaluation gain - assumptions
Act reserve
DLR increase from new claims
Exp investment income on DLR
Exp disability claim payments C1
Exp disability claim payments C2
Exp DI death payments C1
Exp DI death payments C2
Exp DI claims expense
Exp release of interest PFAD (DLR)
Exp release of expense PFAD (DLR)
Exp release of DI termination PFAD (DLR)
Exp DLR rel on DI death
Exp DLR rel on recovery
DLR rel on DI death
DLR rel on recovery
DLR rel on settlement
Revaluation gain - claim adjustments
Revaluation gain - DLR assumptions
RMA Report CY Row Formulas
Reserve at Period Start
Reserve increase from new business
Reserve increase from miscellaneous on
Reserve increase from reinstatements
Expected policy investment income
Expected policy expense
Expected reserve at period end
Reserve release on miscellaneous off
Period end reserve on period start basis
Reserve at period end
Residual reserve adjustment
DLR at period start
Expected cashflows (DLR)
Expected release of PFADs (DLR)
Expected DLR at period end
Expected DLR released on termination
Actual DLR released on termination
Period end DLR on period start basis
DLR at period end
Residual DLR adjustment
Actual DLR
Vendor Defined Fund Based RMA Report
Overview of Fund Based RMA Report
General account buildup
General account at start of period
General account deposits
General account interest credited
General account bonus
General account risk charge
General account other benefit charge
General account expense charge/loads/fees
General account reset/maturity/GMWB guarantee payment
General account MVA charge
General account account cashflows
General account released on lapse
General account released on maturity
General account released on death
General account released on other benefit
General account released on partial withdrawal
General account scheduled payment
General account released on annuitization
General account released on decrements and payments
General account transferred to/from side fund
General account other adjustments
Expected general account at end of period
General account residual
General account at end of period
Seg fund account buildup
Seg fund at start of period
Seg fund deposits
Seg fund interest credited
Seg fund bonus
Seg fund risk charges
Seg fund other benefit charges
Seg fund expense charges/loads/fees
Seg fund reset/maturity/GMWB guarantee payments
Seg fund credits and charges
Seg fund released on lapse
Seg fund released on maturity
Seg fund released on death
Seg fund released on other benefit
Seg fund released on partial withdrawal
Seg fund scheduled payments
Seg fund released on annuitization
Seg fund released on decrements and payments
Transfer to/from seg fund
Seg fund other adjustments
Expected seg fund at end of period
Seg fund residual
Seg fund at end of period
Present value of margins and PFADs
PV of margins & PFAD at period start
PV of margins & PFAD increase from new business
Expected interest margin
Expected commission margin
Expected expense margin
Expected mortality margin
Expected surrender margin
Expected partial withdrawal margin
Expected other benefit margin
Expected annuitization margin
Expected margins
Expected release of interest PFAD
Expected release of expense PFAD
Expected release of mortality PFAD
Expected release of surrender PFAD
Expected release of other benefit PFAD
Expected release of annuitization PFAD
Expected release of PFADs: Fund based
Expected PV of margins & PFAD at period end
Expected PV of margins released on death
Expected PV of margins released on surrender
Expected PV of margins released on other benefit
Expected PV of margins released on annuitization
Expected PV of margins released on decrements
Actual PV of margins released on death
Actual PV of margins released on surrender
Actual PV of margins released on other benefit
Actual PV of margins released on annuitization
Actual PV of margins released on decrements
Actual release of expense PFAD
Actual release of interest PFAD
Actual release of mortality PFAD
Actual release of other benefit PFAD
Actual release of surrender PFAD
Actual release of annuitization PFAD
Actual release of PFADs: Fund based
Period end PV of margins & PFAD on period start basis
Revaluation gain - fund movement
Revaluation gain - assumptions: Fund based
PV of margins & PFAD at period end
Residual PV of margins & PFAD adjustments
Actual PV of margins & PFAD on actual period end fund
Vendor Defined Coverage Movement Report
Overview of Coverage Movement Report
Coverage Movement Report Calendar Projection Lines
Number of coverages - new business
Coverage movement - conversions
Coverage movement - recoveries
Coverage movement - deaths
Coverage movement - incurrals
Coverage movement - lapses
Coverage movement - reinstatements
Coverage movement - other benefits
Coverage movement - maturities
Coverage movement - annuitizations
Coverage movement - expiries
Coverage movement - miscellaneous off
Coverage movement - miscellaneous on
Number of coverages - inforce
Expected coverage movement - conversions
Expected coverage movement - recoveries
Expected coverage movement - deaths
Expected coverage movement - incurrals
Expected coverage movement - lapses
Expected coverage movement - other benefits
Expected coverage movement - maturities
Expected coverage movement - annuitizations
Expected coverage movement - expiries
Expected coverage movement - inforce
New business written - gross - face amount
Amount movement - conversions
Amount movement - deaths
Amount movement - lapses
Amount movement - reinstatements
Amount movement - other benefits
Amount movement - maturities
Amount movement - annuitizations
Amount movement - miscellaneous off
Amount movement - miscellaneous on
Inforce - gross - face amount
Expected amount movement - conversions
Expected amount movement - deaths
Expected amount movement - lapses
Expected amount movement - other benefits
Expected amount movement - maturities
Expected amount movement - annuitizations
Expected amount movement - inforce
Coverage Movement Report Calendar Year Row Formulas
Number of coverages at period start
Number of coverages at period end
Residual number of coverages
Expected coverage movement - period end
Expected coverage movement - residual
Amount of coverage at period start
Amount of coverage at period end
Residual amount of coverage
Expected amount movement - period end
Expected amount movement - residual
Vendor Defined Disability Income Movement Report
Overview of Disability Income Movement Report
Disability Income Movement Report Calendar Projection Lines
Number of coverages - new business
Coverage movement - recoveries
Coverage movement - incurrals
Coverage movement - lapses
Coverage movement - reinstatements
Coverage movement - other benefits
Coverage movement - maturities
Coverage movement - miscellaneous off
Coverage movement - miscellaneous on
Number of coverages - inforce
Expected coverage movement - recoveries
Expected coverage movement - incurrals
Expected coverage movement - lapses
Expected coverage movement - other benefits
Expected coverage movement - maturities
Expected coverage movement - inforce
Disabled life movement - incurrals cause 1
Disabled life movement - recoveries cause 1
Disabled life movement - deaths cause 1
Disabled life movement - benefit period end cause 1
Disabled life movement - settlement cause 1
Number of disabled lives - disabled cause 1
Disabled life movement - incurrals cause 2
Disabled life movement - recoveries cause 2
Disabled life movement - deaths cause 2
Disabled life movement - benefit period end cause 2
Disabled life movement - settlements cause 2
Number of disabled lives - disabled cause 2
Expected disabled life movement - recoveries cause 1
Expected disabled life movement - deaths cause 1
Expected disabled life movement - benefit period end cause 1
Expected number of disabled lives - disabled cause 1
Expected disabled life movement - recoveries cause 2
Expected disabled life movement - deaths cause 2
Expected disabled life movement - benefit period end cause 2
Expected number of disabled lives - disabled cause 2
New business written - gross monthly income
Active life monthly income movement - recoveries
Active life monthly income movement - reinstatements
Active life monthly income movement - incurrals
Active life monthly income movement - lapses
Active life monthly income movement - other benefits
Active life monthly income movement - maturities
Active life monthly income movement - miscellaneous off
Active life monthly income movement - miscellaneous on
Inforce - gross monthly income
Expected active life monthly income movement - recoveries
Expected active life monthly income movement - incurrals
Expected active life monthly income movement - lapses
Expected active life monthly income movement - other benefits
Expected active life monthly income movement - maturities
Expected active life monthly income - inforce
Active life monthly income movement - incurrals cause 1
Disabled life monthly income movement - recoveries cause 1
Disabled life monthly income movement - deaths cause 1
Disabled life monthly income movement - benefit period end cause 1
Disabled life monthly income movement - settlement cause 1
Disabled - gross - monthly income cause 1
Active life monthly income movement - incurrals cause 2
Disabled life monthly income movement - recoveries cause 2
Disabled life monthly income movement - deaths cause 2
Disabled life monthly income movement - benefit period end cause 2
Disabled life monthly income movement - settlement cause 2
Disabled - gross - monthly income cause 2
Expected disabled life monthly income movement - recoveries cause 1
Expected disabled life monthly income movement - deaths cause 1
Expected disabled life monthly income movement - benefit period end cause 1
Expected disabled life monthly income - disabled cause 1
Expected disabled life monthly income movement - recoveries cause 2
Expected disabled life monthly income movement - deaths cause 2
Expected disabled life monthly income movement - benefit period end cause 2
Expected disabled life monthly income - disabled cause 2
Disability Income Movement Report Calendar Year Row Formulas
Number of coverages at period start
Number of coverages at period end
Residual number of coverages
Expected coverage movement - period end
Expected coverage movement - residual
Disabled life movement - number at period start cause 1
Disabled life movement - number at period end cause 1
Disabled life movement - residual cause 1
Disabled life movement - number at period start cause 2
Disabled life movement - number at period end cause 2
Disabled life movement - residual cause 2
Expected disabled life movement - number at period end cause 1
Expected disabled life movement - residuals cause 1
Expected disabled life movement - number at period end cause 2
Expected disabled life movement - residuals cause 2
Active life monthly income - period start
Active life monthly income movement - period end
Active life monthly income movement - residual
Expected active life monthly income movement - period end
Expected active life monthly income movement - residual
Disabled life monthly income movement - period start cause 1
Disabled life monthly income movement - period end cause 1
Disabled life monthly income movement - residuals cause 1
Disabled life monthly income movement - period start cause 2
Disabled life monthly income movement - period end cause 2
Disabled life monthly income movement - residuals cause 2
Expected disabled life monthly income movement - period end cause 1
Expected disabled life monthly income movement - residuals cause 1
Expected disabled life monthly income movement - period end cause 2
Expected disabled life monthly income movement - residuals cause 2
Vendor Defined US GAAP DAC MA Report
Overview of US GAAP DAC MA Report
US GAAP DAC MA Calendar Year Projection Lines
DAC adjustment for late reported new business
Expected DAC capitalization - issue
Expected DAC capitalization - non-issue
DAC asset increase from miscellaneous ons
DAC asset inrease from DI recoveries
Expected DAC asset increase from DI recoveries
Expected DAC asset amortization
Expected DAC asset investment income
Expected DAC asset released on death
Expected DAC asset released on surrender
Expected DAC asset released on other benefit
Expected DAC asset released on incurral
DAC asset released on death
DAC asset released on surrender
DAC asset released on other benefit
DAC asset released on incurral
DAC asset released on miscellaneous off
DAC asset released on DI terminations
Net DAC asset
US GAAP DAC MA Calendar Year Row Formulas
DAC asset at period end
Expected DAC asset at period end
Expected DAC asset released on decrements
Actual DAC asset released on decrements
Period end DAC asset on period start basis
DAC asset at period end
Residual DAC asset adjustment
Vendor Defined US GAAP URR MA Report
Overview of US GAAP URR MA Report
US GAAP URR MA Calendar Year Projection Lines
URR adjustment for late reported new business
Expected unearned revenue
URR increase from DI recoveries
Expected URR increase from DI recoveries
Expected URR amortization
Expected URR interest
Expected URR released on death
Expected URR released on surrender
Expected URR released on other benefit
Expected URR released on incurral
URR released on death
URR released on surrender
URR released on other benefit
URR released on incurral
URR released on miscellaneous off
URR released on DI termination
Net Unearned Revenue Reserve
US GAAP URR MA Calendar Year Row Formulas
URR at period start
Expected URR at period end
Expected URR released on decrements
Actual URR released on decrements
Period end URR on period start basis
URR at period end
Residual URR adjustment
Vendor Defined US GAAP Traditional RMA Report
Overview of US GAAP Traditional RMA Report
US GAAP Traditional RMA Calendar Year Projection Lines
Expected valuation premium
Expected death benefit: Traditional
Expected surrender benefit
Expected other benefit
Expected payout
Expected cost of incurral, ALR basis
Expected dividend and ROP
Expected ceded premium adjustment
Revaluation gain - assumptions
DLR increase from new claims
Exp investment income on DLR
Exp disability claim payments C1
Exp disability claim payments C2
Exp DI death payments C1
Exp DI death payments C2
Exp DI claims expense
Exp DLR rel on DI death
Exp DLR rel on recovery
DLR rel on DI death
DLR rel on recovery
DLR rel on settlement
DLR rel on claim adjustments
Revaluation gain - DLR assumptions
US GAAP Traditional RMA Calendar Year Row Formulas
Benefit reserve at period start
Benefit reserve increase from new business
Benefit reserve increase from miscellaneous on
Benefit reserve increase from reinstatements
Benefit reserve increase from DI recoveries
Expected benefit reserve increase from DI recoveries
Expected benefit reserve investment income
Expected benefit reserve maintenance costs
Expected benefit reserve cashflows
Expected benefit reserve at period end
Expected benefit reserve released on death
Expected benefit reserve released on surrender
Expected benefit reserve released on other benefit
Expected benefit reserve released on incurral
Expected benefit reserve released on decrements
Benefit reserve released on death
Benefit reserve released on surrender
Benefit reserve released on other benefit
Benefit reserve released on incurral
Benefit reserve released on miscellaneous off
Benefit reserve released on DI termination
Benefit reserve released on decrements
Period end benefit reserve on period start basis
Benefit reserve at period end
Residual benefit reserve adjustment
Actual benefit reserve: Traditional
DLR at period start
Expected cashflows (DLR)
Expected DLR at period end
Expected DLR released on termination
Actual DLR released on termination
Period end DLR on period start basis
DLR at period end
Residual DLR adjustment
Actual DLR
Vendor Defined US GAAP Traditional EBS Report
Overview of US GAAP Traditional EBS Report
US GAAP Traditional EBS Calendar Year Projection Lines
Cashflow adj for late reported new business
Reserve adj for late reported new business
Res less PFAD at issue
Expected interest on time zero reserve
Actual deferrable costs - issue
Expected DAC capitalization - issue
Actual premium
Actual valuation premium
Actual URR amortization
Actual unearned revenue
Actual ceded premium adjustment
YRT ceded premium adjustment
Actual DAC amortization
Actual residual costs
YRT ceded cost adjustment
Expected valuation premium
Expected ceded premium adjustment
YRT ceded credit adjustment
Actual investment income
Expected investment income
Expected maintenance costs
Actual maintenance costs
Expected DAC capitalization - non-issue
Actual deferrable costs - non-issue
Expected death benefit
Exp res less PFAD rel on deaths
Actual death benefit
Act res less PFAD rel on deaths
YRT ceded death benefit adjustment
Expected payout
Actual payout
CF adj for late reported death benefit
Expected other benefit
Exp res less PFAD rel on other benefits
Actual other benefit
Act res less PFAD rel on other bens
YRT ceded other benefit adjustment
CF adj for late reported other benefit
Expected lapse benefit
Exp res less PFAD rel on lapses
Actual lapse benefit
Act res less PFAD rel on lapses
CF adj for late report surrender benefit
Exp cost of C1 incurral, ALR basis
Exp rel of ALR on C1 incurrals
Exp ALR less PFAD req on recover C1
Exp cost of C2 incurral, ALR basis
Exp rel of ALR on C2 incurrals
Exp ALR less PFAD req on recover C2
Act cost of C1 incurral, DLR basis
Act rel of ALR on C1 incurrals
YRT ceded incurral cause 1 adjustment
Act cost of C2 incurral, DLR basis
Act rel of ALR on C2 incurrals
YRT ceded incurral cause 2 adjustment
CF adj for late reported C1 incurrals
CF adj for late reported C2 incurrals
Exp disability claim payments C1
Exp DI death benefits C1
Exp DLR less PFAD rel on term C1
Exp disability claim payments C2
Exp DI death benefits C2
Exp DLR less PFAD rel on term C2
Act disability claim payments C1
Act DI death payments C1
Act ALR less PFAD released on DI termination C1
Act DLR less PFAD rel on term C1
Act ALR less PFAD req on recovery C1
Actual DLR less PFAD released on claim adjustment C1
Act disability claim payments C2
Act DI death payments C2
Act ALR less PFAD released on DI termination C2
Act DLR less PFAD rel on term C2
Act ALR less PFAD req on recovery C2
Actual DLR less PFAD released on claim adjustment C2
Expected dividend and ROP
Actual dividend and ROP
YRT ceded dividend and ROP adjustment
Cashflow on Misc Off
Reserve less PFAD released on Misc Off
Cashflow on Misc On
Reserve less PFAD at Misc On
Expected DAC amortization
Expected URR amortization
Expected unearned revenue
P/e reserves on p/s basis
Actual period end reserve
US GAAP Traditional EBS Report CY Row Formulas
Total late reported new busines gain
US GAAP new business gain
Gross premium margin
US GAAP core margins
US GAAP premium gain
Total investment income gain: Traditional
US GAAP cost gain
Total mortality gain
Expected mortality cost
Actual mortality cost
Total lapse gain
Expected lapse cost
Actual lapse cost
Reinstatement gain
Total other benefit gain
Expected other benefit cost
Actual other benefit cost
Exp net cost of incurrals
Act net cost of incurrals
Total disability incidence gain
Exp cost of disability claim runoff
Act cost of disability claim runoff
Total disability claim payment gain
Total dividend gain
Total policy change gain
US GAAP amortization gain
US GAAP unearned revenue gain
US GAAP YRT proportional ceded gain
US GAAP experience gains
Period end DLR on period start basis
Actual DLR
Total revaluation gain: Traditional
US GAAP total EBS gain
Investment income adjustment
US GAAP residual adjustment
Total Gain
Seriatim Reports
Seriatim Calendar Year Reports
Seriatim Summary Reports
Components of Statutory Reserve
Statutory PFAD Components
UL Policyholder Values
Valuation Premium Values
Vanish Premium Duration
UL Premium Values
Additional Dividend Liability
NY File Components
Valuation Premium Values 2
Annuity Constant Yield Reserve IRR
Valuation Premium for Other Benefits
Premium Adjustment
DAC Asset Valuation Premium
Ceded Seriatim Summary Reports
Miscellaneous Reports
Summary Report
Overview Of Summary Report
Built-In Functions In Summary Report
Summary Report Function - ABS(X)
Summary Report Function - ACCRINT(I,Ft,S,R,P,F[,B])
Summary Report Function - ACCRINTM(I, S, R, P[, B])
Summary Report Function - ACOS(X)
Summary Report Function - AND(...)
Summary Report Function - ASIN(X)
Summary Report Function - ATAN(X)
Summary Report Function - ATAN2(X,Y)
Summary Report Function - AVG(...)
Summary Report Function - CAVG(...,C)
Summary Report Function - CCOUNT(...,C)
Summary Report Function - CEIL(X)
Summary Report Function - CELLREF(N1, N2)
Summary Report Function - CHAR(N)
Summary Report Function - CHOOSE(N, ...)
Summary Report Function - CLEAN(S)
Summary Report Function - CMAX(...,C)
Summary Report Function - CMIN(...,C)
Summary Report Function - CODE(S)
Summary Report Function - COL(C)
Summary Report Function - COLS(R)
Summary Report Function - CORR(R1,R2)
Summary Report Function - COS(X)
Summary Report Function - COSH(X)
Summary Report Function - COUNT(...)
Summary Report Function - COUPDAYBS(S, M, F[, B])
Summary Report Function - COUPDAYS(S,M,F[,B])
Summary Report Function - COUPDAYSNC(S, M, F[, B])
Summary Report Function - COUPNCD(S, M, F[, B])
Summary Report Function - COUPNUM(S,M,F[,B])
Summary Report Function - COUPPCD(S, M, F[, B])
Summary Report Function - CSTD(...,C)
Summary Report Function - CSTDS(...,C)
Summary Report Function - CSUM(...,C)
Summary Report Function - CTERM(R,FV,PV)
Summary Report Function - CUMIPMT(R,NP,PV,S,E,T)
Summary Report Function - CUMPRINC(R, NP, PV, S, E, T)
Summary Report Function - CVAR(...,C)
Summary Report Function - CVARS(...,C)
Summary Report Function - DATE(Y, M, D)
Summary Report Function - DATEVALUE(S)
Summary Report Function - DAY(DT)
Summary Report Function - DAYS360(S, E)
Summary Report Function - DB(C, S, L, P[, M])
Summary Report Function - DDB(C, S, L, N)
Summary Report Function - DEGREES(X)
Summary Report Function - DET(M)
Summary Report Function - DFT(R)
Summary Report Function - DISC(S, M, P, R[, B])
Summary Report Function - DOLLARDE(FD, F)
Summary Report Function - DOLLARFR(DD, F)
Summary Report Function - DOT(R1,R2)
Summary Report Function - DURATION(S, M, R, Y, F[, B])
Summary Report Function - EDATE(S, M)
Summary Report Function - EFFECT(NR, NP)
Summary Report Function - EIGEN(M)
Summary Report Function - EOMONTH(S, M)
Summary Report Function - ERF(L[,U])
Summary Report Function - ERFC(L)
Summary Report Function - EXACT(S1,S2)
Summary Report Function - EXP(X)
Summary Report Function - F(M,N,X)
Summary Report Function - FACT(N)
Summary Report Function - FALSE
Summary Report Function - FFT(R)
Summary Report Function - FILEEXISTS(S)
Summary Report Function - FIND(S1,S2,N)
Summary Report Function - FLOOR(X)
Summary Report Function - FORECAST(...)
Summary Report Function - FRAC(X)
Summary Report Function - FREQUENCY(R, B)
Summary Report Function - FTEST(R1,R2)
Summary Report Function - FV(P, R, N)
Summary Report Function - FVSCHEDULE(P, S)
Summary Report Function - GAMMA(X)
Summary Report Function - GMEAN(...)
Summary Report Function - GRAND
Summary Report Function - HEXTONUM(S)
Summary Report Function - HLOOKUP(X, S, R)
Summary Report Function - HMEAN(...)
Summary Report Function - HOUR(DT)
Summary Report Function - IF(X,T,F)
Summary Report Function - INIT(X1, X2)
Summary Report Function - INT(X)
Summary Report Function - INTERP2D(R1, R2, N)
Summary Report Function - INTERP3D(R, X, Y)
Summary Report Function - INTRATE(S, M, I, R[, B])
Summary Report Function - INVDFT(R)
Summary Report Function - INVERT(M)
Summary Report Function - INVFFT(R)
Summary Report Function - IPMT(R, P, NP, PV, FV[, T])
Summary Report Function - IRR(G, F)
Summary Report Function - ISERROR(X)
Summary Report Function - ISNUMBER(X)
Summary Report Function - ISSTRING(X)
Summary Report Function - LARGE(R,N)
Summary Report Function - LEFT(S,N)
Summary Report Function - LENGTH(S)
Summary Report Function - LINFIT(X, Y)
Summary Report Function - LLS(A, Y)
Summary Report Function - LN(X)
Summary Report Function - LNGAMMA(X)
Summary Report Function - LOG(X)
Summary Report Function - LOG10(X)
Summary Report Function - LOG2(X)
Summary Report Function - LOWER(S)
Summary Report Function - MATCH(V, R[, T])
Summary Report Function - MAX(...)
Summary Report Function - MDURATION(S, M, R, Y, F[, B])
Summary Report Function - MEDIAN(...)
Summary Report Function - MID(S,N1,N2)
Summary Report Function - MIN(...)
Summary Report Function - MINUTE(DT)
Summary Report Function - MIRR(CF, FR, RR)
Summary Report Function - MMUL(M1, M2)
Summary Report Function - MOD(X,Y)
Summary Report Function - MODE(...)
Summary Report Function - MODULUS(X,Y)
Summary Report Function - MONTH(DT)
Summary Report Function - MSQ(...)
Summary Report Function - N(R)
Summary Report Function - NAND(...)
Summary Report Function - NETWORKDAYS(S, E[, H])
Summary Report Function - NOMINAL(ER, NP)
Summary Report Function - NOR(...)
Summary Report Function - NOT(X)
Summary Report Function - NOW
Summary Report Function - NUMTOHEX(X)
Summary Report Function - ODDFPRICE(S, M, I, FC, R, Y, RD, F[, B])
Summary Report Function - ODDFYIELD(S, M, I, FC, R, PR, RD, F[, B])
Summary Report Function - OR(...)
Summary Report Function - PERCENTILE(R,N)
Summary Report Function - PERCENTRANK(R,N)
Summary Report Function - PERMUT(S,T)
Summary Report Function - PI
Summary Report Function - PLS(X, Y, d)
Summary Report Function - PMT(PV, R, N)
Summary Report Function - POLY(X,...)
Summary Report Function - POLYCOEF(X, Y, d)
Summary Report Function - PPMT(R, P, NP, PV, FV, T)
Summary Report Function - PRICE(S, M, R, Y, RD, F[, B])
Summary Report Function - PRICEDISC(S, M, D, RD[, B])
Summary Report Function - PRICEMAT(S, M, I, R, Y[, B])
Summary Report Function - PRODUCT(X,...)
Summary Report Function - PROPER(S)
Summary Report Function - PTTEST(R1,R2)
Summary Report Function - PV(P, R, N)
Summary Report Function - QUARTILE(R,Q)
Summary Report Function - RADIANS(X)
Summary Report Function - RAND
Summary Report Function - RANGEREF(N1, N2, N3, N4)
Summary Report Function - RANK(E,R,[O])
Summary Report Function - RATE(FV, PV, N)
Summary Report Function - RECEIVED(S, M, I, D, [, B])
Summary Report Function - REGEX(S1,S2)
Summary Report Function - REPEAT(S,N)
Summary Report Function - REPLACE(S1,N1,N2,S2)
Summary Report Function - RIGHT(S, N)
Summary Report Function - RMS(...)
Summary Report Function - ROUND(X,n)
Summary Report Function - ROW(C)
Summary Report Function - ROWS(R)
Summary Report Function - S(R)
Summary Report Function - SECOND(DT)
Summary Report Function - SIGMOID(X)
Summary Report Function - SIN(X)
Summary Report Function - SINH(X)
Summary Report Function - SLN(C,S,L)
Summary Report Function - SMALL(R,N)
Summary Report Function - SQRT(X)
Summary Report Function - SSE(...)
Summary Report Function - SSQ(...)
Summary Report Function - STD(...)
Summary Report Function - STDS(...)
Summary Report Function - STRCAT(...)
Summary Report Function - STRCAT(...)
Summary Report Function - STRING(X,N)
Summary Report Function - STRLEN(...)
Summary Report Function - SUM(...)
Summary Report Function - SUMPRODUCT(R1,R2)
Summary Report Function - SYD(C, S, L, N)
Summary Report Function - T(N,T)
Summary Report Function - TAN(X)
Summary Report Function - TANH(X)
Summary Report Function - TBILLEQ(S, M, D)
Summary Report Function - TBILLYIELD(S, M, D)
Summary Report Function - TERM(P, R, FV)
Summary Report Function - TIME(H, M, S)
Summary Report Function - TIMEVALUE(S)
Summary Report Function - TODAY
Summary Report Function - TRANSPOSE(M)
Summary Report Function - TREND(NX, KX, KY)
Summary Report Function - TRIM(S)
Summary Report Function - TRUE
Summary Report Function - TTEST(R,X)
Summary Report Function - TTEST2EV(R1,R2)
Summary Report Function - TTEST2UV(R1,R2)
Summary Report Function - UPPER(S)
Summary Report Function - VALUE(S)
Summary Report Function - VAR(...)
Summary Report Function - VARS(...)
Summary Report Function - VDB(C, S, L, S, E)
Summary Report Function - VECLEN(...)
Summary Report Function - VLOOKUP(X, S, C)
Summary Report Function - VSUM(...)
Summary Report Function - WEEKDAY(D)
Summary Report Function - WORKDAY(S, D[, H])
Summary Report Function - XIRR(G, V, D)
Summary Report Function - XNPV(R, V, D)
Summary Report Function - XOR(...)
Summary Report Function - YEAR(DT)
Summary Report Function - YEARFRAC(S, E[, B])
Summary Report Function - YIELD(S, M, R, PR, RD, F[, B])
Summary Report Function - YIELDMAT(S, M, I, R, PR[, B])
AXIS Version
AXIS Version With Date
Accumulated Investment Income on Required Surplus
Block:Inforce Date Annuity Guar Fund X
Block:Inforce Date Fund Value
Block:Inforce Date Policy Count
Block:Inforce Date Policy Count For Exp
Block:Num of Excl. Scenarios
Block:Num of Scenarios
Block:Seriatim Rec. Processed
Cell PV of Asset Cash Flow on YC
Cell PV of Liability Cash Flow on YC
Dataset Long Name
Dataset Name
Date
Division of PVs
Duration of Worst Case Surplus
Embedded Value
IS:Conv of proj cashflow
IS:Dur of proj cashflow
IS:Duration
IS:PV of cashflow
Inforce Date Annuity GMWB Base
Init. Tot. Asset Requirement
Internal Rate of Return
Num. Lives at Worst Case Surplus
PV At Hurdle Rate
PV of After-Tax CF
PV of Pre-Tax CF
Present Value
ROE (Becker)
ROI (Becker)
Report Category
Report Name
Std Scenario Aggregate Amount
Sum
Summary
User Name
Valuation Date Required Capital
Valuation Date Reserve
Value
When Maximum
When Minimum
AXIS Version
AXIS Version With Date
Adjustments at start and end period
Average
Cell PV of Asset Cash Flow on YC
Cell PV of Liability Cash Flow on YC
Current Date
Current Date Time
Current Time
Dataset Long Name
Dataset Name
Date
IS:Conv of proj cashflow
IS:Dur of proj cashflow
IS:Duration
IS:PV of cashflow
Internal Rate of Return
Maximum
Minimum
Object Name
Object Type
PV At Hurdle Rate
PV of Total Cashflow
Partial Duration
Present Value
Property set
ROE (Becker)
ROI (Becker)
Report Name
Sum
Summary report's cell property
Unit Used
User Name
Valuation Date
Value
Value at Valuation Date
When Maximum
When Minimum
Block Summary Report
Block:Inforce Date Annuity Guar Fund X
Block:Inforce Date Fund Value
Block:Inforce Date Policy Count
Block:Inforce Date Policy Count For Exp
Block:Num of Excl. Scenarios
Block:Num of Scenarios
Block:Seriatim Rec. Processed
Division of PVs
Duration of Worst Case Surplus
Embedded Value
Inforce Date Annuity GMWB Base
Init. Tot. Asset Requirement
Internal Rate of Return
Num. Lives at Worst Case Surplus
PV of After-Tax CF
PV of Pre-Tax CF
Present Value
Report Category
Std Scenario Aggregate Amount
Sum
Summary
Valuation Date Required Capital
Valuation Date Reserve
Value
Difference
Breakeven Month
Present Value Lowest (Highest)
IS: All Inv. Asset IRR
One Line Per Cell Report
Monthly Cashflow Report
Reinvestment Report
Regulation XXX/New York 147 Report
CRVM / XXX / AG 37 Report
CARVM Report
T5 Report
Exempt Test Report
US Policyholder Tax Test Report
UL Module US Policyholder Tax Test Report
US Policyholder Tax Test Report
Cumulative 7-pay premiums
Guideline single premium
Cumulative guideline level premiums
Cumulative max premium allowed to pass tests
Cumulative premiums paid
Excess of max premium over premium paid
System Log
What Assumptions Report
Compare Assumptions between Datasets
Exempt Test Plus T5 Report
Regular Module Exempt Test Plus T5 Report
Exempt Test Report
Formula ETP line per 1000 of benefit
Total ETP line face amount per nominal 1000
TOTAL ETP LINE AT YEAR END
GROSS TERMINAL TAX RES PER NOMINAL 1000
YEAR END CASH VALUES PER NOMINAL 1000
Total Accum Fund Year End
Excess of ETP line over Accum Fund
T5 Mortality
Net Cost of Pure Insurance
Adjusted cost base yr end
T5 taxable gain yr end
T5 accrual taxation at year end
UL Module Exempt Test Plus T5 Report
Exempt Test Report
Formula ETP line per 1000 of ben
Total ETP line face per nominal 1000
TOTAL ETP LINE AT YEAR END
GROSS TERMINAL TAX RES PER NOMINAL 1000
YEAR END CASH VALUES PER NOMINAL 1000
Total accum fund per nom 1000 ye
Excess of ETP line over Accum Fund
T5 mortality
Net cost of pure insurance
Adjusted cost base yr end
T5 taxable gain year end
T5 accrual taxation at year end
Par Module Exempt Test Plus T5 Report
Exempt Test Report
Formula ETP line per 1000 of benefit
Total ETP line face amount per nominal 1000
TOTAL ETP LINE AT YEAR END
GROSS TERMINAL TAX RES PER NOMINAL 1000
Total cash value payable yr end
Total accumulating fund per nominal 1000 at YE
Excess of ETP line over Accum Fund
Year end paidup cash value used in exempt test
Year end one year term related CSV used in exempt test
T5 mortality
Net cost of pure insurance
Adjusted cost base yr end
T5 taxable gain yr end
T5 accrual taxation at year end
Projection Assumptions
Reserve Factors
Miscellaneous Calculated Values
UL Module Miscellaneous Calculated Values
Miscellaneous Calculated Values
Regular Module Miscellaneous Calculated Values
Miscellaneous Calculated Values
DI Module Miscellaneous Calculated Values
Miscellaneous Calculated Values
Reserve Factors
DLR Details
Payout Annuity Reserve Reconciliation
Vendor Defined Calendar Year Row Formulas
Alternative Financials Row Formula
Total statement profit
Contribution to free surplus
Change in required surplus
Profit on cashflow & reserve
Change in Reserve
Asset Category Row Formula
Gross Adjusted Cash Type Rate
Net Adjusted Cash Type Rate
Gross Adjusted Cash Type Rate YTD
Net Adjusted Cash Type Rate YTD
Gross Earned Rate YTD
Net Earned Rate YTD
Gross Earned Rate
Net Earned Rate
Inv Income
Total Inv Assets
Gross Earned Rate Adj YTD
Net Earned Rate Adj YTD
Investment Expense CF
Purchase Commitments
Reinvestment Purchases
Gross Earned Rate Adj
Net Earned Rate Adj
Total Inv Assets Adj
Inv Income Adj
Calendar Year Row Formula
Disabled life movement - number at period start cause 3
Disabled life movement - number at period end cause 3
Disabled life movement - residual cause 3
Expected disabled life movement - number at period end cause 3
Expected disabled life movement - residual cause 3
Disabled life monthly income movement - period start cause 3
Disabled life monthly income movement - period end cause 3
Disabled life monthly income movement - residual cause 3
Expected disabled life monthly income movement - period end cause 3
Expected disabled life monthly income movement - residual cause 3
Asset gross earned rate YTD
Asset net earned rate YTD
Asset gross earned rate
Asset net earned rate
US GAAP YRT proportional ceded gain
US GAAP unearned revenue gain
Residual Unearned Revenue Reserve adjustment
Unearned Revenue Reserve at period end
Period end Unearned Revenue Reserve on period start basis
Unearned Revenue Reserve released on decrements
Expected Unearned Revenue Reserve released on decrements
Expected Unearned Revenue Reserve at period end
Unearned Revenue Reserve at period start
US GAAP amortization gain
Expected benefit reserve maintenance costs
DAC tax amortization period - Amortized over 11 years
US GAAP total EBS gain
US GAAP experience gains
US GAAP cost gain
US GAAP premium gain
US GAAP core margins
Gross premium margin
US GAAP new business gain
Residual benefit reserve adjustment
Benefit reserve at period end
Period end benefit reserve on period start basis
Expected benefit reserve released on decrements
Expected benefit reserve released on incurral
Expected benefit reserve released on other benefit
Expected benefit reserve released on surrender
Expected benefit reserve released on death
Benefit reserve released on DI termination
Benefit reserve released on miscellaneous off
Benefit reserve released on decrements
Benefit reserve released on incurral
Benefit reserve released on other benefit
Benefit reserve released on surrender
Benefit reserve released on death
Expected benefit reserve at period end
Expected benefit reserve cashflows
Expected benefit reserve investment income
Expected benefit reserve increase from DI recoveries
Benefit reserve increase from DI recoveries
Benefit reserve increase from reinstatements
Benefit reserve increase from miscellaneous on
Benefit reserve increase from new business
Benefit reserve period start
Actual benefit reserve: Traditional
Residual DAC asset adjustment
DAC asset at period end
Period end DAC asset on period start assumptions
Actual DAC asset released on decrements
Expected DAC asset released on decrements
Expected DAC asset at period end
DAC asset at period start
Seg fund other adjustments
Transfer to/from seg fund
Seg fund released on annuitization
Seg fund released on scheduled payments
Seg fund released on partial withdrawal
Seg fund released on other benefit
Seg fund released on death
Seg fund released on maturity
Seg fund released on lapse
Seg fund reset/maturity/GMWB gaurantee payments
Seg fund expese charges/loads/fees
Seg fund other benefit charges
Seg fund risk charges
Seg fund bonus
Seg fund interest credited
Seg fund deposits
Actual release of PFADs: Fund based
General account residual
Expected general account at period end
General account other adjustments
General account transfer to/from side fund
General account released on decrements and payments
General account released on annuitization
General account released on scheduled payments
General account released on partial withdrawal
General account released on other benefit
General account released on death
General account released on maturity
General account released on lapse
General account cashflows
General account MVA charge
General account reset/maturity/GMWB guarantee payment
General account expense charge/loads/fees
General account other benefit charge
General account risk charge
General account bonus
General account interest credited
General account deposits
General account at start of period
General account at end of period
Seg fund residual
Expected seg fund at end of period
Seg fund released on decrements and payments
Seg fund credits and charges
Seg fund at start of period
Residual PV of margins & PFAD adjustment
PV of margins & PFAD at period end
Period end PV of margins & PFAD on period start basis
Actual PV of margins released on decrements
Expected PV of margins released on decrements
Expected PV of margins & PFAD at period end
Expected release of PFADs: Fund based
Expected margins
Expected annuitization margin
Expected partial withdrawal margin
Expected surrender margin
Expected expense margin
Expected commission margin
Expected interest margin
PV of margins & PFAD increase from new business
PV of margins & PFAD at period start
NAAR / Net DB
Macaulay Duration of Death Claims
Standard Deviation of Death Claims
Vendor Defined RMA Report - Reserve increase from reinstatement
Expected amount movement - residual
Expected amount movement - period end
Expected disabled life monthly income movement - residual cause 2
Expected disabled life monthly income movement - residual cause 1
Expected disabled life monthly income movement - period end cause 2
Expected disabled life monthly income movement - period end cause 1
Disabled life monthly income movement - residual cause 2
Disabled life monthly income movement - residual cause 1
Disabled life monthly income movement - period end cause 2
Disabled life monthly income movement - period end cause 1
Disabled life monthly income movement - period start cause 2
Disabled life monthly income movement - period start cause 1
Expected active life monthly income movement - residual
Expected active life monthly income movement - period end
Active life monthly income movement - residual
Active life monthly income movement - period end
Active life monthly income movement - period start
Expected disabled life movement - residual cause 2
Expected disabled life movement - residual cause 1
Expected disabled life movement - number at period end cause 2
Expected disabled life movement - number at period end cause 1
Disabled life movement - residual cause 2
Disabled life movement - residual cause 1
Disabled life movement - number at period end cause 2
Disabled life movement - number at period end cause 1
Disabled life movement - number at period start cause 2
Disabled life movement - number at period start cause 1
Expected coverage movement - residual
Expected coverage movement - period end
Reinstatement gain
Vendor Defined RMA Report - Expected policy investment income
Vendor Defined RMA Report - Expected policy expense
Vendor Defined RMA Report (DLR) - Actual DLR
Vendor Defined RMA Report (DLR) - DLR at period start
Expected DI death benefit
Expected DI payments
Vendor Defined RMA Report (DLR) - Residual DLR adjustment
Vendor Defined RMA Report (DLR) - DLR at period end
Vendor Defined RMA Report (DLR) - Period end DLR on period start basis
Vendor Defined RMA Report (DLR) - Actual DLR released on termination
Vendor Defined RMA Report (DLR) - Expected DLR released on termination
Vendor Defined RMA Report (DLR) - Expected DLR at period end
Vendor Defined RMA Report (DLR) - Expected release of PFADs (DLR)
Vendor Defined RMA Report (DLR) - Expected cashflows (DLR)
Vendor Defined RMA Report - Actual reserve released on decrements
Vendor Defined RMA Report - Expected reserve released on decrements
Vendor Defined RMA Report - Expected release of PFADs in reserve
Vendor Defined RMA Report - Expected cashflows (reserve)
Actual cost of disability claim runoff
Expected cost of disability claim runoff
Actual net cost of incurrals
Expected net cost of incurrals
Total disability claim payment gain
Total disability incidence gain
Vendor Defined RMA Report - Reserve increase from miscellaneous on
Vendor Defined RMA Report - Reserve released on miscellaneous off
Net Incr in PFAD for pol change
Total policy change gain
Available capital, total
Available capital / Required capital
Actual PV of margins & PFAD on actual period end fund
Total revaluation gain: Composite
Fund based revaluation gain - assumptions
Traditional revaluation gain - assumptions
Total revaluation gain - Fund based
Total revaluation gain: Traditional
Other residual adjustment
Investment income adjustment: Fund based
Total EBS Gain
Total surrender gain: Composite
Fund based surrender gain
Fund based partial withdrawal gain
Traditional surrender gain
Total other benefit gain: Composite
Fund based other benefit gain
Traditional other benefit gain
Total mortality gain: Composite
Fund based mortality gain
Traditional mortality gain
Total expense gain: Composite
Fund based expense gain
Traditional expense gain
Total investment income gain: Composite
Fund based investment income gain
Traditional investment income gain
Total premium gain: Composite
Fund based premium gain
Traditional premium gain
Expected PV of margins & PFAD on expected period end fund
Expected PV of margins & PFAD on actual period end fund
Actual investment income on fund
Expected investment income on fund
Total annuitization charge gain
Required capital - C1
MCCSR ratio
MCCSR Available capital tier 2
MCCSR Available capital tier 1
MCCSR required capital
Available capital, total (MCCSR)
Available capital, tier 1
Required capital, total
Expected partial withdrawal charge
Actual partial withdrawal charge
Total surrender charge gain
Total partial withdrawal charge gain
Total payout gain
Total investment income spread gain
Total EBS gain: Fund based
Total other benefit gain: Fund based
Total other benefit margin gain
Expected other benefit margin
Actual other benefit margin
Total surrender gain: Fund based
Actual surrender charge
Expected surrender charge
Total mortality gain: Fund based
Total mortality margin gain
Actual mortality margin
Expected mortality margin
Total expense gain: Fund based
Total investment income gain: Fund based
Expected investment income spread
Actual investment income spread
Non asset component of required surplus
Residual amount of coverage
Amount of coverage at period end
Amount of coverage at period start
Investment income adjustment: Traditional
Total gain
Residual number of coverages
Total new business gain
Total late reported new business gain
Total Inv Assets Adj
Total Inv Assets
Inv Income Adj
Inv Income
Gross Earned Rate Adj YTD
Net Earned Rate Adj YTD
Net Earned Rate YTD
Gross Earned Rate YTD
Net Earned Rate Adj
Net Earned Rate
Gross Earned Rate Adj
Gross Earned Rate
Asset Category - investment expense cf
Number of coverages at period end
Number of coverages at period start
Cash - income
Other asset - income
Inflows - coupons and interest
Inflows - mortgage payments
Inflows - dividends
Inflows - rent
Inflows - other income
Other asset - amortized cost basis
Cash and equivalents - amortized cost basis
Market value - shares
Market value - real estate
Market value other1
Market value other2
Market value - cash
Market Value (%)
Cash - Adjusted Realized Gain
Cash - Interest
Cash - Maturities
Cash - Purchase Commitments
Cash - Investment Expense
Cash - Reinvestments
Cash - Total Cashflow
Cash - Gain/Loss on Defaults
Cash - Weighted Cashflow
Share - Amortized Cost Basis (incl accrued)
Real Estate - Amortized Cost Basis (incl accrued)
Cash 1 - Book Value of Invested Assets
Cash 1 - Market Value
Cash 2, 3, or 4 - Book Value of Invested Assets
Cash 2, 3, or 4 - Market Value
Outflows - other income
Outflows - investment expenses
Market value - bond acc interest
Market value - mortgages accrued interest
Market value - mortgage (excluding accrued interest)
Acquired Real Estate - Par Value
Acquired Real Estate - Other Mortgage OS Principal
Acquired Real Estate - PVACF, YC vs shock Y
Acquired Real Estate - PV asset CF on Yield Curve
Acquired Real Estate - Accrued Interest from Calls/SF payments
Acquired Real Estate - Option Value
Acquired Real Estate - Monthly Cashflow
Acquired Real Estate - Weighted Monthly Cashflow
Acquired Real Estate - Taxable Invest Income Adj
Acquired Real Estate - Adjusted Realized Gain
Acquired Real Estate - Required Surplus
Acquired Real Estate - Market Value (excl accrued)
Acquired Real Estate - Amortized Unrealized Gains
Acquired Real Estate - Unamortized Realized Gain
Acquired Real Estate - Accrued Income
Acquired Real Estate - Amortized Cost Basis (excl accrued)
Acquired Real Estate - Investment Expense CF
Acquired Real Estate - Purchase Commitments
Acquired Real Estate - Reinvestment Purchases
Acquired Real Estate - Outgo Cashflow
Acquired Real Estate - Sales
Acquired Real Estate - Salvage Value on Default
Acquired Real Estate - Maturities
Acquired Real Estate - calls/prepayments
Acquired Real Estate - Income Cashflow
Acquired Real Estate - Investment Expenses
Acquired Real Estate - Gain/Loss on Defaults
Acquired Real Estate - Amortization of Unrealized Gain/Loss
Acquired Real Estate - Amortization Realized Gain/Loss
Acquired Real Estate - Amortization of Premium/Discount
Acquired Real Estate - Earned Income
Cash 2, 3, or 4 - Par Value
Cash 2, 3, or 4 - Mortgage Outstanding Principal
Cash 2, 3, or 4 - PVACF, YC vs. Shock Y
Cash 2, 3, or 4 - PV Asset CF on Yield Curve
Cash 2, 3, or 4 - Accrued Interest from Calls/SF payments
Cash 2, 3, or 4 - Option Value
Cash 2, 3, or 4 - Total Cashflow
Cash 2, 3, or 4 - Weighted Cashflow
Cash 2, 3, or 4 - Taxable Invest Income Adj
Cash 2, 3, or 4 - Adjusted Realized Gain
Cash 2, 3, or 4 - Required Surplus
Cash 2, 3, or 4 - Market Value (excl accrued)
Cash 2, 3, or 4 - Amortized Unrealized Gain
Cash 2, 3, or 4 - Unamortized Realized Gain
Cash 2, 3, or 4 - Accrued Income
Cash 2, 3, or 4 - Amortized Cost Basis (excl accrued)
Cash 2, 3, or 4 - Investment Expense CF
Cash 2, 3, or 4 - Purchase Commitments
Cash 2, 3, or 4 - Reinvestment Purchases
Cash 2, 3, or 4 - Outgo Cashflow
Cash 2, 3, or 4 - Sales
Cash 2, 3, or 4 - Salvage Value on Default
Cash 2, 3, or 4 - Maturities
Cash 2, 3, or 4 - Calls/Prepayments
Cash 2, 3, or 4 - Interest
Cash 2, 3, or 4 - Investment Expense
Cash 2, 3, or 4 - Gain/Loss on Defaults
Cash 2, 3, or 4 - Amortization of Unrealized Gain/Loss
Cash 2, 3, or 4 - Amortization of Realized Gain/Loss
Cash 2, 3, or 4 - Amortization of Premium/Discount
Cash 2, 3, or 4 - Earned Income
Cash 1 - Par Value
Cash 1 - Mortgage Outstanding Principal
Cash 1 - PVACF, YC vs. Shock Y
Cash 1 - PV Asset CF on Yield Curve
Cash 1 - Accrued Interest from Calls/SF payments
Cash 1 - Option Value
Cash 1 - Total Cashflow
Cash 1 - Weighted Cashflow
Cash 1 - Taxable Investment Income Adj.
Cash 1 - Adjusted Realized Gain
Cash 1 - Required Surplus
Cash 1 - Market Value (excl accrued)
Cash 1 - Amortized Unrealized Gain
Cash 1 - Unamortized Realized Gains
Cash 1 - Accrued Income
Cash 1 - Amorizted Cost Basis (excl accrued)
Cash 1 - Investment Expenses CF
Cash 1 - Purchase Commitments
Cash 1 - Reinvestments
Cash 1 - Outgo Cashflow
Cash 1 - Sales
Cash 1 - Salvage Value on Defaults
Cash 1 - Maturities
Cash 1 - Calls/Prepayments
Cash 1 - Interest
Cash 1 - Investment Expenses
Cash 1 - Gain/Loss on Defaults
Cash 1 - Amortization of Unrealized Gain/Loss
Cash 1 - Amortization of Realized Gain/Loss
Cash 1 - Amortization of Premium/Discount
Cash 1 - Earned Income
Other 1 or 2 - Par Value
Other 1 or 2 - Mortgage Outstanding Principal
Other 1 or 2 - PVACF, YC vs Shock Y
Other 1 or 2 - PV Asset CF on Yield Curve
Other 1 or 2 - Accrued Int from Calls/SF Payments
Other 1 or 2 - Option Value
Other 1 or 2 - Total Cashflow
Other 1 or 2 - Weighted Cashflow
Other 1 or 2 - Taxable Investment Income Adjustment
Other asset - adjusted realized gain
Other 1 or 2 - Required Surplus
Other 1 or 2 - Market Value (excl accrued)
Other 1 or 2 - Amortized Unrealized Gain
Other 1 or 2 - Unamortized Realized Gains
Other 1 or 2 - Accrued Income
Other 1 or 2 - Amortized Cost Basis (excl accrued)
Other 1 or 2 - Investment Expense CF
Other 1 or 2 - Purchase Commitments
Other 1 or 2 - Reinvestments
Other 1 or 2 - Outgo Cashflow
Other 1 or 2 - Sales
Other 1 or 2 - Salvage on Defaults
Other 1 or 2 - Maturities
Other 1 or 2 - Calls
Other 1 or 2 - Income
Other 1 or 2 - Investment Expense
Other 1 or 2 - Gain/Loss on Defaults
Other 1 or 2 - Amortization of Unrealized Gain/Loss
Other 1 or 2 - Amortization of Realized Gain/Loss
Other 1 or 2 - Amortization of Premium/Discount
Other 1 or 2 - Earned Income
Real Estate - Par Value
Real Estate - Mortgage Outstanding Principal
Real Estate - PVACF, YC vs. Shock Y
Real Estate - PV of Asset CF on Yield Curve
Real Estate - Accrued Interest from Calls/SF Payments
Real Estate - Option Value
Real Estate - Total Cashflow
Real Estate - Weighted Cashflow
Real Estate - Taxable Investment Income Adj.
Real Estate - Adjusted Realized Gain
Real Estate - Required Surplus
Real Estate - Market Value (excl accrued)
Real Estate - Amortized Unrealized Gains
Real Estate - Deferred Realized Gain
Real Estate - Accrued Income
Real Estate - Amortized Cost Basis (excl accrued)
Real Estate - Investment Expense CF
Real Estate - Purchase Commitments
Real Estate - Reinvestments
Real Estate - Outgo Cashflow
Real Estate - Sales
Real Estate - Salvage on Defaults
Real Estate - Maturities
Real Estate - Calls
Real Estate - Rent
Real Estate - Investment Expenses
Real Estate - Gain/Loss on Defaults
Real Estate - Amortization of Unrealized Gain/Loss
Real Estate - Amortization of Realized Gain/Loss
Real Estate - Amortization of Premium/Discount
Real Estate - Earned Income
Share - Par Value
Share - Mortgage Outstanding Principal
Share - PVACF on YC - PVACF on Shock Y
Share - PV of Asset CF on Yield Curve
Share - Accrued Accrued Interest from Calls/SF Payments
Share - Option Value
Share - Total Cashflow
Share - Weighted Cashflow
Share - Taxable Investment Income Adj
Share - Adjusted Realized Gain
Share - Required Surplus
Share - Market Value (excl accrued)
Share - Amortized Unrealized Gains
Share - Deferred Realized Gain
Share - Accrued Income
Share - Amortized Cost Basis (excl accrued)
Share - Investment Expense CF
Share - Purchase Commitments
Share - Reinvestments
Share - Outgo Cashflow
Share - Sales
Share - Salvage on Defaults
Share - Maturities
Share - Calls
Share - Dividends
Share - Investment Expenses
Share - Gain/Loss on Defaults
Share - Amortization of Unrealized Gains/Losses
Share - Amortization of Realized Gains/Losses
Share - Amortization of Premium/Discount
Share - Earned Income
Mortgage - Par Value
Mortgage - Outstanding Principal
Mortgage - PVACF on YC - PVACF on Shock YC
Mortgage - PV of Asset CF on Yield Curve
Mortgage - Accrued Int, Calls/SF Payments
Mortgage - Option Value
Mortgage - Total Cashflow
Mortgage - Weighted Cashflow
Mortgage - Taxable Investment Income Adj
Mortgages - Adjusted Realized Gain
Mortgage - Required Surplus
Mortgage - Market Value (excl accrued)
Mortgage - Amortized Unrealized Gain
Mortgage - Unamortized Realized Gain
Mortgage - Accrued Interest
Mortgage - Amortized Cost Basis (excl accrued)
Mortgage - Investment Expense CF
Mortgage - Purchase Commitments
Mortgage - Reinvestments
Mortgage - Outgo Cashflow
Mortgage - Sales
Mortgage - Salvage on Defaults
Mortgage - Maturities
Mortgage - Prepayments
Mortgage - Payments
Mortgage - Investment Expenses
Mortgage - Gain/Loss on Defaults
Mortgage - Amortization of Unrealized Gain/Loss
Mortgage - Amortization of Realized Gain/Loss
Mortgages - Amortization of Premium/Discount
Mortgage - Earned Income
Bond - Par Value
Bond - Mortgage Outstanding Principal
PVACF on YC - PVACF on Shock YC
Bond - Present Value of Cashflow on Yield Curve
Bond - Accrued int from calls/SF payment
Bond - Option Value
Bond - Total Cash Flow
Bond - Weighted Cashflow
Bond - Taxable Invest Income Adjustment
Bond - Adjusted Realized Gain
Bond - Required Surplus
Bond - Market Value (excl accrued)
Bond - Amortized unrealized gains
Bond - Unamortized Realized Gain
Bond - Accrued Interest
Bond - Amortized Cost Basis (excl accrued)
Bond - Investment Expense CF
Bond - Purchase Commitments
Bond - Reinvestments
Bond - Outgo Cashflow
Bond - Sales
Bond - Salvage on Defaults
Bond - Maturities
Bond - Calls
Bond - Coupons
Bond - Investment Expenses
Bond - Gain/Loss on Defaults
Bond - Amortization of Unrealized Gain or Loss
Bond - Amortization of Realized Gain/Loss
Bond - Amortization of Premium/Discount
Bond - Earned Income
Vendor Defined RMA Report - Expected reserve at period end
Total disability benefit gain
Actual annuitization charge
Expected annuitization charge
Total annuitization gain
Vendor Defined RMA Report - Reserve increase from new business
Total des fund cashflow gain
Total seg fund cashflow gain
Vendor Defined RMA Report - Residual reserve adjustment
Vendor Defined RMA Report - Reserve at period end
Vendor Defined RMA Report - Period end reserve on period start basis
Vendor Defined RMA Report - Reserve at period start
Total EBS gain: Traditional
Total dividend gain
Total other benefit gain: Traditional
Actual other benefit cost
Expected other benefit cost
Total surrender gain: Traditional
Actual surrender cost
Expected surrender cost
Total mortality gain: Traditional
Actual mortality cost
Expected mortality cost
Total expense gain: Traditional
Total commission gain
Total investment income gain: Traditional
Liability Category Row Formula
Total Net Investment Income
Invested Asset Amortized Cost Basis (Including Accrued Interest)
Total net investment income
Total asset purchases
Income from CF and cash account
Total book value of invested assets
Net Earned Rate YTD
Net Earned Rate
NAIC Financials Row Formula
Reserve adjustments on reinsurance ceded
Interest on reserve deposits
Deposit contracts
Interest on deposit funds
Dividends to stockholders
Miscellaneous adjustments
Capital paid in
Aggregate reinsurance recovery
Asset valuation reserve
Interest maintenance reserve
Current federal and foreign income taxes
Total surplus
Free surplus
Target surplus
Total liability including separate accounts
Separate account liabilities
Total liability excluding separate accounts
Total assets including separate accounts
Separate account assets
Total assets excluding separate accounts
Deferred premium asset
Cash and invested assets
Capital and surplus
Change in AVR
Change in non admitted assets
Change in net deferred income tax
Change in net unrealized capital gain (loss)
Net income
Net realized capital gain (loss) less FIT
Net gain after dividends and FIT
Federal income tax (FIT)
Net gain after dividends before FIT
Dividends to policyholders
Net gain before dividends and FIT
Total benefits and expenses
Net transfers to (from) Separate accounts
Increase in loading on DPA
Insurance taxes, licenses and fees
General insurance expense
Commission gross
Total benefits
Increase in aggregate reserves
Other policy benefits
Surrender benefits
Disability benefits
Annuity benefits
Matured endowments
Death Benefits
Total revenues
Income from fees - Separate account
Commission on reinsurance ceded
Amortization of IMR
Net investment income
Premiums and annuity considerations
Reinsurance Treaty Row Formula
Other benefit
Required Surplus Row Formula
MCCSR total available capital
Total surplus
Ratio of NAAR to net death benefits
Standard deviation of death claims
Available capital, total
Available capital tier 1
Total asset requirement
US GAAP Financials Row Formula
Provision for unearned revenue
Federal income taxes
GAAP total surplus
GAAP free surplus
Total liabilities including separate accounts
Separate account liabilities
Total liabilities excluding separate accounts
Accrued tax
Policyholders' account balances
Future policyholder benefits
Total assets including separate accounts
Separate account assets
Total assets excluding separate accounts
Reinsurance recoveries
Deferred acquisition costs
Cash and invested assets
Income
Change in deferred tax liability
Income before federal income tax
Miscellaneous adjustments
Net reinsurance revenue
Increase in ceded benefit liability
Incurred prepaid ceded expenses
Ceded allowances
Ceded other benefits
Ceded maturity and surrender benefits
Ceded death and disability claims
Ceded revenue
Total gross expenses
Other expense
Operating expense
Commission
Reduction in DAC and VOBA
Total gross benefits
Increase in benefit liability
Other credits
Interest credited
Other benefits
Policyholder dividends and experience refunds
Annuity payments
Maturity and surrender benefits
Death and disability claims
Total gross revenue
Investment income
Total insurance revenue
Reduction in Provision for unearned revenue
Contract charges
Insurance premiums
Other AXIS Objects
Global Scenarios
Scenario Processing Screen
Historic Scenario
Future Scenario
Supplement Table
Scenario Definition
Monthly Cashflow Table
Forward Rates, Par Rates and Spot Rates Â
Asset Pricing Model
Batch Processes
Calendar Year projections recalculation
Output Options
Seriatim Calendar Year Report Output Options
Valuation factors recalculation
Batch testing
Scenario/Override Options
Fund Options
Office Option
Subfund Option
Distributed Processing Options
Generate
Generate Technique
Batch Generate Options
Cell Selection
Predefined Generate Options
Table Adjustment Options
Profit Target Options
Column Specific Selection Options
Column Specific Table Generate Options
Entry Age Table Generate Options
Scalar Generate Options
Generate Tolerance
Composite Table Generate Options
Entry Age Table Within a Composite Table Generate Options
Cell Generate Options
Save Options
Table Generate Options
Fund Target Options
Reserve Target Options
Profit Loading Options
Crossover Target Options
Generate Information
Table Adjustments and Rounding
Continuation Guarantee Options
Calendar Year Target Options
Summary Report Target Options
Vanish Premium Options
Column Specific Table Within a Composite Table Generate Options
ALM risk report
Office/ Fund/Subfund Options
Dataset Macro
Batch Process Selection
Scenario generator
Scenario Analyzer
Analyzer basis
Results Analyzer
Import/Export Macro
Batch Process Selection
Dataset Parameters
Table Adjust
Portfolio rate capture
Earned Rate
Source Info
Outputs Info
Which Portfolio
Captured rate limits
DataLink Macro Batch
DataLink Formula Batch
DataLink Record Collection Batch
Convert from Delimited File Batch
Cell Selection Options
Override Set Usage Options
Import/Export
Batch Import Process
Batch Process to Read from an External File
Batch Process to Send to an External File
Macro Action - Import
Export System Log
Module Selection Information
One Line per Cell Output Options
Override Set Usage Options
Seriatim Calendar Year Projections
Seriatim Run Options
Seriatim Output Options
Seriatim Summary Report
Summary Output Items
Table Adjust Format
Table Adjust Options
Selection List
ALM Risk Report Options
Reports
Report information
Calendar year report options
Export to database options Dialogue
Policy year results options
Pricing results options
Illustration Result Options
Valuation Table Options
Table Selection List
Export to ASCII File Options
Cell Run Options
System Batch
Dataset Recal Options
Batch Process Selection List
Scenario Analyser
Scenario Basis
Statistics Basis
Cell Recalculation Options
Output Options
Scenario Usage Options
Valuation Options
Valuation Output Options 1
Valuation Output Options 2
Valuation File Options
Cell Output Options
Batch Execution Wizard
Final Results Analyzed Options
Statistics Basis
Scenario Analyser Or Batch Testing
Scenario Selection Options
Print options
Cell Inclusion Report Options
Batch Output
Table Selection Dialog
Revaluation points options
Block Options
Block recalculation
Block Calendar Year Projections Export Options
Distributed Processing Mode
Block Calendar Year Projections Export Options 2
Export to PDF file
Export to Excel
Transposing Results
Cell Run Options
Cell Run Options in Batch Testing
Run Filter Selection in Batch Testing Wizard
Run Options
Block Run Options
Dataset Formula Batches
OAD Analyzer
Block Recalculation Batch
Scenario Generator
Update Assumptions Batch
Output Manager
Batch Static Scenario Set Generator
Experience Studies Seriatim Report Options
Seriatim Summary Report Export Options
Distributed Processing Mode
Selection Conditions
Assumption Overrides
Seriatim Overrides
New Object Wizards
New Office Wizard
New Fund Wizard
New Subfund Wizard
New Cell Wizard
New Investment Account Wizard
New Table Wizard
New Scenario Processing Screen Wizard
New Scenario Wizard
New Scenario Supplement Table Wizard
New Reinvestment Strategy Wizard
New Override Wizard
New Override Set Wizard
New System Batch Wizard
New Batch Wizard
New Filter Wizard
New Policy Year Results Report Wizard
New Illustration Report Wizard
New Calendar Year Report Wizard
New Seriatim Calendar Year Report Wizard
New Seriatim Summary Report Wizard
New Summary Report Wizard
New Asset Category Wizard
New Liability Category Wizard
New Calendar Year Row Formula Wizard
New Property Set Wizard
New Object Set Wizard
New Database Link Wizard
New Remote Table Wizard
New Query Wizard
New Hedge Strategy Wizard
Dataset Parameters
Period and Dates Tab
Scenario Tab
Custom Codes
EBS Tab
Periodicity Display Tab
Report Preference Tab
Category Results Tab
DataLink Dataset Parameters
Duration Calculations
Partial duration bands table
Reserve Order Tab
Required Funds Tab
User Values Tab
System Parameters
Preferences Tab
Security Key Tab
Advanced Tab
Printer Tab
Directories Tab
System Log Tab
Confirmation Tab
Batch Tab
Table Edit Tab
Formula Tab
Distributed Processing Tab
Stochastic Processing
Miscellaneous Dialogues
Remote Table Definition Screen
Query Definition Screen
Import tables from SOA Standard format
Export tables to SOA Standard format
The Object Explorer
Send E-mail/Problem Report Wizard
Fund Generate Wizard
Where Used Dialogue
Text Found In Formulae Dialogue
Backup Wizard
Backup/Restore
Dataset Selection List
Restore s file
ZIP file location
Restore to path
Options
Import/Export Processes
Viewing Data from the Import/Export Database
The Import/Export Table Viewer
Importing from the Import/Export Database
Import/Export Batch Processes
Exporting Assumptions
Exporting Names
Exporting Links
Exporting Projections
Customizing the Import/Export Database
DataLink
Seriatim Record Display Windows
About Seriatim Processing in AXIS
The Seriatim Record List
The Seriatim Supplementary Information Window
DataLink Object Definition Dialogues
Table Definition Form
Support For Datalink Table Storage Over 2GB
New Field Definition Form
Field Properties Definition Form
Using the Status Date
Processing Options in DataLink
Scan Source File Window
Table View Window
Formula Expression Edit Window
Query Definition Screens
DataLink Policy Information Table
Mandatory Fields for Regular Life
Optional Fields and Vectors for Regular Life
Optional Tables for Regular Life
Mandatory Fields for Universal Life
Optional Fields and Vectors for Universal Life
Optional Tables for Universal Life
Mandatory Fields for Par Life
Optional Fields and Vectors for Par Life
Optional Tables for Par Life
Mandatory Fields for Disability
Optional Fields and Vectors for Disability
Optional Tables for Disability
Mandatory Fields for Annuity
Optional Fields and Vectors for Annuity
Optional Tables for Annuity
Optional Fields and Vectors for Group Annuity
Mandatory Fields for Group Annuity
Optional Tables For Group Annuity
Optional Vector Tables for Group Annuity
DataLink Reference Tables
About DataLink Reference Tables
Using Seriatim Optional Tables
Using the Cells Table in Liability Modules
Using the Cells Table in the Asset Module
Using the Subfunds Table
Using the AXIS Table Values Table
Using the Investment Accounts Table
Using the Other Benefit Objects Table
Using the Reinsurance Terms Table
Using the Risk Classes Table
Using the AXIS Scenario Values Table
DataLink Optional Vector Tables
Using Optional Vector Tables
Optional Vector Tables for Regular Life
Optional Vector Tables for Universal Life
Optional Vector Tables for Par Life
Optional Vector Tables for Disability
Optional Vector Tables for Annuity
Reserve Interest Rate Optional Vector Tables
Commissions per Premium Optional Vector Table
Long Optional Vector Tables
Minimum Face Amount Optional Vector Table
Minimum Non-Seg Credited Rate
Flat Extra Premium Vector Table
Flat Extra Mortality Rate
Commission For Flat Extra Premium
DataLink Supplementary Information Tables
About Supplementary Information Tables
Other Benefits Table
Cession Information Table
Mandatory Fields - Deposit Information Table (Annuity and Group Annuity)
Optional Fields - Deposit Information Table (Annuity)
Optional Fields - Deposit Information Table (Group Annuity)
Mandatory Fields - Current Fund Value Tables (UL)
Optional Fields - Current Fund Value Table (UL)
Current Cashflow Allocation Table (UL and Annuity)
Deposit History Table (Annuity)
Target Regular Premium Table (UL)
Mandatory and Optional Fields - Policy Movement Transactions Table
Mandatory and Optional Fields - Fund Movement Transactions Table
Mandatory and Optional Fields - Future Fund Values Table (UL)
Mandatory and Optional Fields - Future Policyholder Values Table (UL)
Mandatory Fields - Future Cashflow Allocation Table
Mandatory and Optional Fields - Future Policyholder Values Table (Annuity)
Mandatory and Optional Fields - Future Deposit Information Table (Annuity)
Mandatory and Optional Fields - Claim Information Table
Joint Life Information Table
DataLink Supplementary Information Tables (EBS)
Policy Movement Transaction Table
Fund Movement Transaction Table
Future Fund Values Table
Future Policyholder Values Table
Future Cashflow Allocation Table
Claim Information Table
DataLink Batch Processes
Batch Macro
Batch Formula
Batch Record Collection
Batch Convert from Delimited File
DataLink Wizards
New DataLink Table Wizard
New DataLink File Wizard
New Query Wizard
Converting AXIS 9 Datasets - Step 1
Converting AXIS 9 Datasets - Step 2
Investment Account Info Table
Scenario Tools
About ScenarioTools
Scenario Generator
About Scenario Generator
Scenario Generator Specifications
Scenario Generator Type
Scenario Format Assumptions
Scenario Format
Number Of Scenarios to Generate
Output Rate Type
Output Curve Type
Random Number Assumptions
Random Uniform (0,1)
Internal rand() function
Linear Congruential Generator
Mersenne Twister Random number generator
Seed
Converting to Normal
COS Method
Numerical Method
Base Scenario
Scenario Generator Links
Correlated Monte Carlo Simulation For Yield Curves
Correlated Monte Carlo Simulation for Yield Curve (Ravindran 1998)
Yield Curve
Input Rate Type
Spot Rates
Spot Rate Volatility
Example - Ravindran Yield Curve Model
Risk Neutrality
Lognormal Distribution
Correlated Monte Carlo Simulation For Equities
Correlated Monte Carlo Simulation for Equities (Ravindran 1998)
Risk Free Rate Type
Risk Free Rate
Dividend Rate Type
Dividend Rates
Equity/Asset Volatility
Correlation Coefficient Matrix
Example - Ravindran Equity Model
Stochastic Asset Model For Actuarial Use
Stochastic Asset Model For Actuarial Use (Wilkie 1995)
Inflation Model
Share Dividend Yield Model
Share Dividend Model
Long-Term Interest Rates Model
Short-Term Interest Rates Model
Stationary Autoregressive Models
Stationary Moving Average Models
Mean Reversion
Two Factor Lognormal Model
Two Factor Lognormal Model (Boyle and Tan 1998)
General Parameters
Rate Type
Current Assumptions: Short and Long Rates
Long Term Average Assumptions: Short and Long Rates
Volatilities of Short and Long Rates
Correlation (rho)
Short and Long Reversions
Blending Period
Calibration of Monthly Short and Long Rates
Example - Two Factor Lognormal Model
Calibrated Correlated Monte Carlo Simulation
Calibrated Correlated Monte Carlo Simulation
Yield Curve
Input Rate Type
Spot Rates
Spot Rate Volatility
Arbitrage-Free
Correlated Lognormal Equities - Real World
Correlated Lognormal Equities - Real World
Real World Assumptions
Lognormal Distribution for Equities
Correlated Equity Information Table
Correlation Matrix Table
Regime Switching Lognormal Model
Regime Switching Lognormal Model
Regime Switching Assumptions
Equity Assumptions
Lognormal Distribution for Equities
Correlated Equity Information Table
Correlation Matrix Table
Generator Type
Calibration of Regime Parameters
Link to Scenario Generator
CALM Prescribed Scenarios
Prescribed CALM Scenarios
Real Estate Income Model
Real Estate Yield Model
Mersenne Twister Generator Copyright -
User-defined Generator
User-defined Parameters
Market model
Imported values - long
User Defined Deterministic Scenario Generator
Market Model Choice
Imported values - uniform random on ]0,1[
Stochastic Scenario generator
Correlation Coefficient Matrix Table
Market Model
About Market Model
Regime Switching Lognormal (RSLN)
Number of Components
Equity Total Return composite table
Dividend table
Scenario Column Link table
Max number of observations
Data for fitting table
Fitting process report
Random process
Fit
Fitting method
Maximum likelihood fitting method
Sensitivity
RSLN Market model screen
Integrated Hull-White LN
About Integrated Hull-White LN
Yield Curve input table
Equity total growth drift table
Equity total return volatility table
Correlation Coefficient Matrix
Dividends table
User Defined Stochastic
About User Defined Stochastic
Scenario Analyser
About Scenario Analyser
Output Destination
Output - Statistics Basis
Output - Equity Rates
Output - Scenario Columns
Scenario Selection List
Results Analyser
About Results Analyser
Office/Fund/Subfund Options
Office/Fund/Subfund Selection List
Cell Recalculation Options
Output Options
Scenario Selection List
Summary Statistics Results
Option adjusted Duration
Yield Curve Options
Average and Standard Deviation table
Lognormal Vector Process (composite) table
Basic Scripts in AXIS
Auxiliary Functions
Constants in Formula Tables for Market Model
AXIS Variables in Formula Tables for Market Model
Conversion functions in Formula Tables
Float Point Error While Generating Scenarios
Hull and White model
Scenario set
Equity Index Components
Suggested Reference Sources for Scenario Data
Component to Output Link Table
Features In Testing And Features To Be Removed
POLICY LOANS Option
Reserve Method - CARVM
SFAS 97 Unearned Revenue - Amortize all unearned revenues over estimated gross profit
Reserve Method
GAAP valuation start date - Value from purchase date, include UE prem at purchase date
RESERVE FOR OTHER BENEFIT - Set up NLP reserve for other benefit reporting type N
New Variable Annuity Features
Reserve Revaluation
Reinsurance Terms X
NAIC Nondeduction/Pro-rata refund reserves
NLP reserve for OYT
Additional Rebalancing - At each reinvestment point after target mix is met
Mortality Projection
SURR CHARGE Table
Alternative Interpolation Method for CALM Scenarios
Unlock DAC / URL - Unlock statutory DAC / URL
Experience Refund Features
Stochastic Asset Model For Actuarial Use (Wilkie 1995)
Variance - main benefit
USER DEFINED SCALARS - USAGE SWITCH - Allow negative default rates for pricing
Unlock DAC / TDL - Unlock statutory DAC / TDL
LAPSE AFTER VANISH PREM - Borrow instead of restarting premium
Optional Tables for Universal Life
Capturing Actual Policy Movement Data
Block (Reg, UL, Par, Disability) (Beta)
Multiple Paid-up Assurance Bases
Mean Market Value based on Policy Year Yield Curve
Disable Late Report Dec. Cashflow Adjust.
OYT shortfalls - Free for first N years, limited shortfalls with vanish premium
Overview to MCCSR Mortality Components
Composite table section for (pricing) expense used in SFAS 120
Reserve for other benefit - Use reserve method specified in other benefit object
Risk Class and Rules Table Functionality
Calculation type - Stock option
Statement DTL/DTA - Carve out the deferred tax using Cdn carve out meth two (current tax rates)
Output .prn files from Val Factor Recalc Batch run
UDT
Seg Fund Factor Method Formula for 2005
CALCULATION TYPE - Interest rate swap
Implicit calculation of DAC for SFAS 120
USER DEFINED SCALARS - USAGE SWITCH - Scalar Not Used
USER DEFINED TABLES - Table Not Used
Guarantee Fund Method - Not Used
NLP (Canadian Stat) Reserve Method
INFLATION SOURCE - use inflation table
Tax Res as Combo of Stat/Scnd/UE Prm
Tax Res Based on Scnd/UE Prm
CRVM with Face Amount Freeze
Reserve revaluation
Mat bonus per guar term in Group Ann
Notional Account Deferral Period Table
Premium options 2 and 3
Surrender Charge Based on Accumulated Interest Credited
User Defined Tables - table not used
User Defined Tables - accum phase: extra sch withdrawal
CASH VALUE definition - MIN (fund, W% of guarantee fund for CSV) - surr charge
USER DEFINED TABLES - Investment Income Adjustment
USER DEFINED SCALARS - USAGE SWITCH - X = spread to adjust investment income in statutory reserve
POLICY FEE TREATMENT - policy fee is ignored during fund calculations
Required Surplus Excess of Reserves
Overview of EBS Modules in AXIS
DTL Disallow With Some Reserve Adjustment
N
Fund bonus table
Second DPL Capitalized and Interest
Special Ceded Benefit
Actuarial Guideline 38 ACLI 2006 Proposed Revisions
Ceded Other Benefits Per Base Nominal Face Amount
Reserve details - main guar reserve less CSV floor
SFAS 120 Reserve Reconciliation Report
DIVIDEND OPTION - Dividend option not used
USER DEFINED TABLES - Table not used
First Year Premium - Waived for the first M months
Required Capital Factors (%) Table
DLR Details
CALENDAR YEAR RESULTS - Use BondEdge's cashflow service (provided by Interactive Data)
Experience Studies
Asset Valuation Reserve
Tax reserve ceiling applied after other reserves are calculated
Modified Zillmer Reserve Method
Second Reserve Release Details
STAT and Second Reserve Components
Non-US GAAP VOBA
Display all Liability Cats in Group Annuity
Allow Seriatim PM To Coincide With CM - Annuity
Premium Calculation Table
Use Old Earned Rate Validation
Claim Adj For ROP Benefit optional field
Key Code 25, 26 and 27
Use Flat Tax Rate And Don't Accrue DAC Tax
Include AVR and Nonadmitted IMR in Req Surplus
Use ceded premium for reinsurance valuation premium
Notional acct banded features with AG 38
CMO Tranches Information Table
Joint Life Tables in Single Life Cell
Partial Surrenders With CRVM Reserves
CRVM VALUATION PREMIUM MODE - Monthly distribution for main, monthly distribution for secondary guarantee
Mortality table for XXX reserves
X% of Unregistered Reinsurance
Solvency Capital Requirements Table
Multiple Asset Accounting Bases
Hedged Liabilities
Allow Seriatim PM To Coincide With CM - Reg & DI
Old Required Surplus Basis
Alternative Illustration GMP generation
Compound basis for continuous expense charges
80 Years of Maximum Duration in DI
GAAP Definition Switch for C1 and TAR
Different Corporate Tax Rate For Discounted DTL
Required Surplus Method
Portfolio rate credited - min/max constraints
What's New in AXIS?
AXIS 12 - Our Latest Release
The Introduction of AXIS 12
Enhanced Stochastic Processing
More Features Added to GridLink
Reserve Method Objects
Multiple Life Joint Life Policies in Universal Life
Risk Classes and Rules Tables
Dynamic Block Reporting Categories
New Features Introduced in AXIS 11
The Introduction of AXIS 11
Formula Tables
System Formulas
Dynamic PPM Valuation for UL
Running One Modelpoint in Volumes Table
Capturing Earned Rates by Liability Category
Improvements in DataLink (Aug 2003)
Enhancements to Other Benefits - Phase 1 (Oct, 2003)
Stochastic Processing Module
Distributed Processing Improvements
Introduction of Multiple Reinsurance
Compound Tables
Portable Document File (PDF) Support
Additional Reserve Sections in Cells
Risk Classes and Rules Tables
AXIS GridLink Module
Formula Based Modification Tables
New Asset Types
Additional CALM Scenarios
2005 Seg Fund Factor Method in MCCSR
New Mortality Components in 2005 MCCSR
Calibrating the Regime Switching Lognormal Model Generator
Embedded Scenario Processing
Asset Accounting under CICA 3855
2006 CALM Scenarios
Enhancements to AXIS GridLink