AXIS Online Help

About the AXIS Help SystemAXIS 12 Users GuideAn Introduction to AXIS 12About AXIS 12Getting StartedInstalling AXISWindows BasicsBasic AXIS ConceptsModules in AXISWhat Are Datasets?Objects and the View MenuWhat is a Cell?How AXIS uses TablesWhat are Policy Year ResultsWhat are Calendar Year Projections?Modeling vs. SeriatimHow AXIS handles ReinsuranceSubfunds, Funds, and OfficesGlobal ScenariosReinvestment StrategiesBatch Objects and Batch OperationsCell Override SetsSystem and Dataset ParametersOnline HelpThe AXIS 12 InterfaceThe Main Application WindowUsing the Menu BarThe File MenuSetting System ParametersSetting Dataset ParametersUsing the Standard ToolbarThe Object ExplorerWorking With CellsWorking Interactively With ObjectsHow to Select ObjectsUsing the Actions ButtonUsing the Cell Assumption ScreenOrganization of the Cell Assumption ScreenNavigating Around the Cell Assumption ScreenHow to Customize the Cell Assumption ScreenEntering Data in the Cell Asssumption ScreenAges in AXISRunning a CellViewing Standard ReportsCreating Custom ReportsOpening the CRE from the View MenuOpening the CRE from Within a ReportThe Report Editor WindowUsing the Report Editor Action ButtonsUsing the Formula Definition WindowPrinting ReportsRunning an IllustrationWorking With TablesHow Tables are Organized in AXISSelecting and Viewing TablesThe Table Icons in the Assumption ScreenBasics of Table EditingTable Editing Action ButtonsTables with Expandable ColumnsTable Buffer OptionsGenerating TablesEditing Table HeaderOther Objects in AXISWhat are Investment Accounts?Assumption Screen FiltersWhat Are Custom Reports?What are Object Sets?What is a Remote Table?Batch OperationsWhat are Batch Processes?What are System Batch Processes?Using the Batch WizardsImport Export OptionsOverview of Import and Export OptionsWhat is the Import/Export Database?Exporting Assumptions to the Import/Export DatabaseExporting Projections to the Import/Export DatabaseViewing and Comparing ProjectionsExport and Import of AXIS Table valuesAXIS ScriptAbout AXIS Script LanguageIntroduction to the Basic Elements of AXIS ScriptUsing the AXIS Script EditorUsing the AXIS Script DebuggerReference Guide to AXIS Script Statements & EventsReference Guide to AXIS Script FunctionsRecommendations for Programming with AXIS ScriptSeriatim Processing with DataLinkIntroduction to AXIS DataLinkWhat is AXIS DataLink?DataLink Flow DiagramData RequirementsUsing DataLink for Asset ProjectsUsing DataLink for Insurance ProjectsBasic Concepts and Terms in DataLinkObjects Used by DataLinkWorking with DataLink Object ListsWorking with Formulas in DataLinkSample Database ApplicationsGetting StartedProject Development OverviewSetting DataLink Dataset ParametersCopying an Existing DatabasePreparing Logical Source FilesDefining a TableBasics of Table DefinitionTable Definition OverviewThe Table Object ViewEditing the Table DefinitionThe Status DateAdding New FieldsAdjusting Field AttributesDefining Input FieldsCreating an Input FieldScanning a Source FileValidating Source DataConverting Source DataUsing a Formula Procedure During LoadingTesting the Field DefinitionsDefining Calculated FieldsCreating Calculated FieldsDefining a Mapping Rules TableUsing a Formula Procedure During MappingUsing the Formula Expression Edit WindowTesting the Field DefinitionsDefining a Formula ProcedureWhat is a Formula Procedure?Defining Formula ProceduresSyntax Rules for Formula ProceduresInternal System VariablesUser Defined VariablesUsing Comment StatementsUsing Conditional BranchingDO CASE ... ENDCASEIF ... ELSE ... ENDIFFOR...ENDFOR / NEXTPredefined DataLink FunctionsPredefined DataLink File FunctionsUsing Global User Defined Formula ProceduresBatch Processing in DataLinkFormula Procedure BatchesCross Table FormulasRecord Collection BatchesDataLink Batch MacrosUsing the Cells Reference TableUsing the Cells Table in Liability ModulesAsset Cell Assumption TablesUsing Subfunds Reference TablesUsing the AXIS Table Values TableCommunicating with AXISExporting Seriatim Files to AXISUsing AXIS Seriatim ReportsDocumentationViewing DataLink ObjectsArchiving Your DataCreating QueriesWhat is a Query?Specifying Query SourcesConditional Record SelectionDefining Query Output FieldsWorking with Query ResultsAdvanced TopicsAbout User Defined TablesAbout User Defined TablesUsing a User Defined Table to Hold Supplementary Policy DataUsing a User Defined Table to Hold Mapping Rule Source DataUsing a User Defined Table to Perform a Table LookupHow to Export Selected Records to CellsHow to Generate Multiple Policy Info RecordsHow to Generate Unique Policy ID'sHow to Load Selected Records from the Source FileGlossary of TermsEarnings by SourceOverview of Earnings by Source in AXISPreparing to Use EBSChoosing an EBS Reporting PeriodSetting EBS ParametersCapturing Actual Policy Movement DataCapturing Actual Fund Movement DataCreating Calendar Year EBS ReportsExperience AnalysisAdvanced Applications in AXISHow to Approach CALM in AXISUsing AXIS in a Production EnvironmentDistributed ProcessingDistributed Processing - OverviewDistributed Processing on a Multi-Processor ComputerDistributed Processing over Multiple MachinesDistributed Processing from the Command LineStochastic Processing in AXISWhat is Stochastic Processing?Overview to Stochastic Processing in AXISDefining Scenarios for Stochastic ProcessingThe Block ObjectViewing Results from Block ProcessingEmbedded Scenario ProcessingUser Guide for EIA Hedging FunctionalityAbstractProduct Design and General SettingsFixed Guarantee PortionIndexed Crediting PortionScenario Generator for HWLN modelScenario Generator Parameter SpecificationExample - Data DescriptionCorrespondence between the Cell and the ScenariosConsistency Test with Blank Summary ReportAppendixAppendix A Model Consistency ProofAppendix B Questions and AnswersAppendix C The EIA Formula Table ScriptsAXIS Reference ManualAXIS Assumption ScreensOffice Assumption ScreenResults CalculatedRESULTS CALCULATEDCapital MovementsSHAREHOLDER DIVIDENDX =INJECTION METHODY =YEARINJECTION ($K)SH DIVIDEND ($K)Investment EarningsINVESTMENT EARNINGSINTEREST RATE FOR CASHFLOWINTEREST RATE FOR REINVESTMENTINTEREST RATE FOR BORROWINGUSE REINVESTMENT STRATEGYINTEREST ALLOCATION METHODNET INVESTMENT INCOME RATEMONTHLY PERIOD EARNED RATE officeREINVESTMENT STRATEGY OVERRIDEN =Required SurplusREQUIRED SURPLUSRequired Surplus Component TablePROPORTION OF PREMIUMSPROPORTION OF CLAIMSPROPORTION OF RESERVEPROPORTION OF DLRPROPORTION OF CSVPROPORTION OF UL FUNDPROPORTION OF NAARPROPORTION OF LAPSE RISK COMPONENTPROPORTION OF CV DEFPROPORTION OF NEGATIVE RESERVE FROM FUND TOTALPROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENTOTHER COMPONENTAsset factor (a)INCLUDE FREE SURPLUSASSET ADJUSTMENTLIMITS ON AVAILABLE CAPITALTREATMENT OF NEGATIVE AND CV DEFICIENCYMAXIMUM TIER 2MAX NEGATIVE RES IN TIER 2MIN REQUIRED SURPLUSB (in $million)C% of CV Deficiency and Negative ReservesGAAP EQUITY & INCOMEHandling MCCSR 2003 Revisions in AXISAsset Amortization AmountsINITIAL DEFERRED ASSET AMOUNTS METHODAMORTIZATION OF G/L ON PAST BOND DISPOSALS FOR YEARS 1 to 20AMORTIZATION OF G/L ON PAST MORTGAGE DISPOSALS FOR YEARS 1 to 20SHARES - DEFERRED REALIZED GAINREAL ESTATE - DEFERRED REALIZED GAINTaxationTAXATION METHODCorporate Tax Rate TableBASIC TAXTAX RATE ON CASHFLOW & RESERVESACCRUED TAX ($000's)TAX RATE ON REQUIRED SURPLUSACCRUED TAX ($000's)TAX RATE ON FREE SURPLUSACCRUED TAX ($000's)CAPITAL TAX CALCULATION FORMULAADDITIONAL TAXSURTAX ON CORPORATE TAXLARGE CORPORATIONS TAXPROPORTION OF IIT DEDUCTIBLEDIFFERENTIAL EARNINGS RATEMUTUAL COMPANY TAX ON STAT or 2ND RESERVETAX LOSS TREATMENTX = AMOUNT OF TAX LOSSY = YEARS OF TAX LOSS CARRY FORWARDZ = YEARS OF TAX LOSS CARRYBACKHISTORICAL TAX LOSS CARRYFORWARDSDAC TAX METHODTDAC CAPITALIZATION RATE (US)HISTORICAL DAC TAX BALANCESTAXABLE AMOUNT CALCULATIONDAC TAX BASISDAC TAX AMORTIZATION PERIODEmbedded ValueHURDLE RATEEMBEDDED VALUEEMBEDDED VALUEEMBEDDED VALUE ADJSummary ScreenCOLUMN 5 PROFIT MARGINFund Assumption ScreenInitial Asset PositionMETHOD OF INPUTINITIAL FREE SURPLUSInitial Total AssetPROPORTION OF NET ACTUARIAL RESERVE USED AS TOTAL ASSETPROPORTION OF INVESTED ASSETS FROM THE ASSET SUBFUNDSRetained earningsTransfers of Free SurplusX =AMOUNT OF TRANSFERInvestment EarningsGENERAL ACCOUNT INVESTMENT EARNINGSUSE REINVESTMENT STRATEGYINTEREST RATE FOR CASHFLOWINTEREST RATE FOR REINVESTMENTINTEREST RATE FOR BORROWINGINTEREST ALLOCATION METHODLIABILITY CATEGORY INVESTMENT EARNINGSNET INVESTMENT INCOME RATEMONTHLY PERIOD EARNED RATEREINVESTMENT STRATEGY OVERRIDEN =ExpensesEXPENSES fundWHICH YREXPENSE fundNet Actuarial ReserveNET ACTUARIAL RESERVE FORMULADTL AdjustmentDTL Adjustment AppliesRequired SurplusREQUIRED SURPLUSPROPORTION OF PREMIUMSPROPORTION OF CLAIMSPROPORTION OF RESERVEPROPORTION OF DLRPROPORTION OF CSVPROPORTION OF UL FUNDPROPORTION OF NAARNAAR COMPONENTPercentage of Lapse Risk ComponentPROPORTION OF CV DEFICIENCIESCASH VALUE DEFICIENCIESPROPORTION OF NEGATIVE RESERVE FROM SUBFUND TOTALPROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENTCOMPONENT FOR UNREGISTERED REINSURANCEOther ComponentAsset factor (a)ASSET ADJUSTMENTLIMITS ON AVAILABLE CAPITALTREATMENT OF NEGATIVE AND CV DEFICIENCIESMAXIMUM TIER 2MAX NEGATIVE RES IN TIER 2MIN REQUIRED SURPLUSB (in $million)C% of CV Def and Neg ResGAAP EQUITY & INCOMEAmortization AmountsINITIAL DEFERRED ASSET AMOUNTS METHODAMORTIZATION OF G/L ON PAST BOND DISPOSALS FOR YEARS 1 to 20AMORTIZATION OF G/L ON PAST MORTGAGE DISPOSALS FOR YEARS 1 to 20SHARES - DEFERRED REALIZED GAINREAL ESTATE - DEFERRED REALIZED GAINTaxationTAXATION METHODCorporate Tax Rate TableTAX RATE ON CASHFLOW & RESERVESACCRUED TAX ($000's)TAX RATE ON REQUIRED SURPLUSACCRUED TAX ($000's)TAX RATE ON FREE SURPLUSACCRUED TAX ($000's)PROPORTION OF IIT DEDUCTIBLEDIFFERENTIAL EARNINGS RATEMUTUAL COMPANY TAX ON 2ND RESERVETAX LOSS TREATMENTX = AMOUNT OF TAX LOSSY = YEARS OF CARRY FORWARDZ = YEARS OF TAX LOSS CARRYBACKHISTORICAL TAX LOSS CARRYFORWARDSDAC TAX METHODTDAC CAPITALIZATION RATE (US)HISTORICAL DAC TAX BALANCESTAXABLE AMOUNT CALCULATIONDAC TAX BASISDAC TAX AMORTIZATION PERIODFund InformationFUND INFORMATIONINITIAL SHAREHOLDER SURPLUSMAX. SHAREHOLDER DIVIDENDEmbedded ValueHURDLE RATEEMBEDDED VALUEEMBEDDED VALUE ADJSummary ScreenCOLUMN 5 PROFIT MARGINExperience RefundExperience refund methodRandom seed specificationER discount rateStochastic generate formulaExperience refund formulaAdditional reserve adjustmentClaim fluctuation reserve Loss carry forwardReserve adjustmentSubfund Assumption ScreensLiability Modules SubfundsSubfund TypeSUBFUND TYPEREINSURANCE TREATIESDURATION CASHFLOW ADJUSTMENTSInitial Asset PositionMETHOD OF INPUTINITIAL FREE SURPLUSINITIAL LIFE FUNDRETAINED EARNINGSInvestment EarningsINVESTMENT EARNINGSCALENDAR YEAR INTEREST RATE TABLEAdditional CashflowADDITIONAL CASHFLOW METHODMONTHLY CASHFLOW TABLECASHFLOW TABLERESERVESINITIAL RESERVEI =ExpensesEXPENSES subfundWHICH YREXPENSE subfundNet Actuarial ReserveNET ACTUARIAL RESERVE FORMULADTL AdjustmentDTL Adjustment AppliesCAPITAL CHARGE ADJUSTMENT TABLERequired SurplusMETHOD FOR CALCULATING REQUIRED SURPLUSPROPORTION OF PREMIUMSELECT PREMIUMS FOR REQUIRED SURPLUS CALCULATIONPROPORTION OF CLAIMSPROPORTION OF RESERVESCHOICE OF RESERVESPROPORTION OF UL FUNDPROPORTION OF DLRPROPORTION OF CSVPROPORTION OF NAARNAAR COMPONENTPROPORTION OF LAPSE RISK COMPONENTLAPSE RISK COMPONENTPROPORTION OF CV DefCASH VALUE DEFICIENCIESPROPORTION OF UNREGISTERED REINSURANCE ADJUSTMENTCOMPONENT FOR UNREGISTERED REINSURANCEOTHER COMPONENTAsset factor (a)LIMITS ON AVAILABLE CAPITALTREATMENT OF NEGATIVE AND CV DEFICIENCYMAXIMUM TIER 2MAX NEGATIVE RES IN TIER 2MIN REQUIRED SURPLUSB (in $million)C% of CV Deficiency and Negative ReservesGAAP EQUITY AND INCOMEInvestment Income TaxINVESTMENT INCOME TAXIIT RATEIIT FACTORBOND YIELD RATEADJUSTMENT TO RATEL = TaxationTAXATION METHODCorporate Tax Rate TableTAX RATE ON CASHFLOW & RESERVESACCRUED TAX ($000's)TAX RATE ON REQUIRED SURPLUSACCRUED TAX ($000's)TAX RATE ON FREE SURPLUSACCRUED TAX ($000's)PROPORTION OF IIT DEDUCTIBLEDIFFERENTIAL EARNINGS RATEMUTUAL COMPANY TAX ON 2ND RESERVETAX LOSS TREATMENTX = AMOUNT OF TAX LOSSY = YEARS OF CARRY FORWARDZ = YEARS OF TAX LOSS CARRYBACKHISTORICAL TAX LOSS CARRYFORWARDSDAC TAX METHODTDAC CAPITALIZATION RATE (US)HISTORICAL DAC TAX BALANCESTAXABLE AMOUNT CALCULATIONDAC TAX BASISDAC TAX AMORTIZATION PERIODEmbedded ValueHURDLE RATEEMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUSEMBEDDED VALUE ADJSummary ScreenCOLUMN 5 PROFIT MARGINUS GAAP UnlockingUNLOCK DAC/URL/TDLREINSURANCE TREATMENTDAC K FACTORURL K FACTORAMORTIZATION RATE TABLEACCUMULATED NET EGP/MACCUMULATED NET DEFERRABLE COSTSACCUMULATED NET UNEARNED REVENUEACCUMULATED NET TERMINAL DIVIDENDSExperience RefundExperience refund methodRandom seed specificationER discount rateStochastic generate formulaExperience refund formulaAdditional reserve adjustmentClaim fluctuation reserve Loss carry forwardReserve adjustmentValue of Business Acquired AMORTIZATION METHODRECALCULATE DACVOBA AMOUNT AMORTIZATION LIMIT AMORTIZATION TABLEAsset/Reinv Module SubfundsSubfund Type/GeneralSUBFUND TYPEDURATION CASHFLOW ADJUSTMENTAdditional CashflowADDITIONAL CASHFLOW METHODMONTHLY CASHFLOW TABLEASSET CASHFLOW TABLEREPORTING TYPEASSET VALUESINITIAL ASSET VALUEI =Amortization AmountsBond And Mortgage Amortization TableSHARES DEFERRED REALIZED GAINREAL ESTATE DEFERRED REALIZED GAINAdditional Cash BalanceADDITIONAL CASH BALANCEYEARS OF ADDITIONAL CASH BALANCEAMOUNTS OF ADDITIONAL CASH BALANCEInvestment ExpensesINVESTMENT EXPENSESYEARS OF INVESTMENT EXPENSESAMOUNTS OF INVESTMENT EXPENSEFee Income Fee Income tableRequired SurplusREQUIRED SURPLUSPROPORTION OF CALCULATED AMOUNTREQUIRED SURPLUS FACTORSCell Assumption ScreensRegular Module CellsProcessing SectionCALENDAR YEAR RESULTSCell CodeSCENARIO DEPENDENCYPROJECTION METHODISSUE MONTH METHODTIMING OF ISSUEend of day nINFORCE ADJUSTMENTVOLUMESSERIATIM INFORCEAGE DISTRIBUTIONMODAL DISTRIBUTIONPOLICY YEAR RESULTSPricing Issue Year and MonthRisk classRisk class life 1 and life 2Product Features SectionPREMIUMSGUARANTEED PREMIUMSCOMMISSIONSBONUS & CBKFACE AMOUNTCASH VALUEROPDIVIDENDPAIDUP VALUEOther BenefitsVALDISTRIBUTION TABLESALESAGE MIX DURATIONAGE MIX BASISLIFE STATUS1ST LIFE IS2ND LIFE ISCONTAGION FACTORMaturity AgeCSV FormulaX%Mid Year CSVMATURITY VALMVDISTRIBUTION OF SALES BY MODEMODAL PREMIUM FACTORSPOLICY FEE WITH EACH PREMIUMPROPORTION OF LAPSE AT YR ENDPREMIUM RATESPREMIUM BASISyears of guaranteed premiumSINGLE PREMIUM PLANUNEARNED PREMIUMSUNEARNED COMMISSIONEXPENSE BASISDIVIDEND PAID ON LAPSEXDIVIDEND PAID ON DEATHXDIRECT RECAPTURE CHARGEISSUE FEE PER POLCOMMISSION RATE ON ISSUE FEEPROP OF POLICY FEE COMMISSIONABLEPurchase assumptionsMultiple Reinsurance SectionOverview of Multiple ReinsuranceMultiple reinsuranceReinsurance termsNet amount at riskSingle Reinsurance SectionSingle ReinsuranceReinsurance TablesPremiumsPremium adjustmentCommissionBonus & chargebackFace amountCash valueDividendOther Benefit Set TableCEDED POLICY FEEInterest on premiumPremium taxPREMIUM TAX RATE FROM REINSURERPREMIUM TAX BASIS CEDEDPREMIUM TAX BASIS CEDED ADJPREMIUM TAX REFUND CEDEDUNEARNED CEDED PREMIUMSUNEARNED CEDED COMMREINSURANCE METHODADJ FOR UNREGISTEREDROP BENEFITROP BASISOther benefit reinsurance basisCEDED PREMIUM FOR JT LIFECEDED RECAPTURE CHARGEPremium payableProportion of pol fee commissionableGeneral Assumptions SectionSPARE FIELDKEYCODEPREM VOLUMECALC. TABLE 1RESRV DETAILSY =DECREMENTSRES FACTORSGAAP EQUITY & INCOMEGAAP FINANCIALSCALCULATION OF MORTALITY PADMINIMUM Q REFERENCE TABLEF factor (VTP 8)Pricing Assumptions SectionMORTALITYMORT LIFE 2AIDS EXTRA QAIDS LIFE 2INTERESTOther Benefit Rates TablePAIDUP PROPLAPSE RATEEXPENSE tableCAPITAL CHARGEMODIFICATIONADJUSTMENT TABLE 1ADJUSTMENT TABLE 2RECAPTURE RATESTART ACCUMULATING PROFIT MEASURES AT POLICY YEARAIDS EXTRA Q TABLELAPSE ATADJUSTMENT TABLE 1 optionADJUSTMENT TABLE 2 optionDISCOUNT RATEDISCOUNT RATE BASISDISCOUNT INTEREST RATE TABLEHURDLE RATEEMBEDDED VALUEEMBEDDED VALUE ADJPROFIT MARGINPROFIT EMERGENCE (PV)PROFIT EMERGENCE (ROI)ROI DefinitionTime Zero StrainTaxes SectionTAX METHODXCORPORATE TAX RATESDIFFERENTIAL EARNINGSPREMIUM TAX RATEPREMIUM TAX BASISYTAX EXEMPT INVESTMENT INCOME TABLEPREMIUM TAX REFUNDTAX LOSS TREATMENTDAC TAX METHODTDAC TAX CAPITALIZATION RATEDAC TAX BASISDAC TAX AMORTIZATION PERIODCANADIAN IIT RATEIIT BOND YIELD DEFINITIONPROPORTION OF IIT DEDUCTIBLEIIT PAYMENT FREQUENCYT5 CALCULATIONPolicyholder Tax SectionExempt Test Policy AssumptionsMortalityMortality for Joint LivesInterestExempt Test DurationAccumulating FundETP Line TreatmentExempt Test Mortality TablesT5 AssumptionsT5 CalculationsAccumulating FundACB MortalityACB Mortality TablesStatutory, Second, Third, Fourth, Fifth and Tax Reserves SectionsReserve MethodReserve Assumption TablesPremium table for valuationCommission table for valuationBonus & chargeback table for valuationInput Terminal Reserve Factors TablePremium limitMortality minimum: First lifeMortality minimum: Second lifeMortality PADAdditional PADYearsAIDS extra q tablesLapse atAdjustment table 1 optionAdjustment table 2 optionValuation start dateLimitationStatutory reserve floorRecognition of claimsYIIT liabilityDeferred tax liabilityCompensation in reserveInterest to DAC balanceDAC amortization patternDAC amortization periodGAAP maintenance expense reserve floorCeded GAAP maintenance compensationCeded compensation for DACReserve for dividend optionReserve for other benefitReserve for paidupReserve adjustmentTax reserve ceilingTax reserve lapsesReinsurance treatmentTerm for reservesPremium deficiencyNXXX unitary/segmentedXXX deficiency reservesXXX select factorsXXX time horizonNXXX valn prem capXXX level policy feeXXX seg mort ratio adj factorZ =Gtd premiums for NY Reg 147Expense Amortization PeriodNRenewal amount of insuranceLapse rate PADLapse margin (X =)Maximum lapse rateValuation modeSubstandard methodReinsurance expenseReserve revaluationM =N =Revaluation methodLapse PAD treatmentValuation scenariosValuation mortality adjustmentDirect premium adjustmentGuaranteed Premium AdjustmentCeded Premium AdjustmentValuation interest rateNIMean Reserve MethodTime zero reserveAdjustment by unearned premXYRT reinsurance creditPPM valuation premiumInterpolation timingNondeduction reservePremium basis for DPA/UEPModal loading for DPA/UEPProportional coinsurance DPA/UEPLRequired Surplus SectionREQUIRED SURPLUSXRequired Surplus Factors (%)PREMIUM DEFINITIONLapse Risk ComponentABStatutory PFAD Analysis SectionSTAT PFAD ANALYSISReserve Recalculation OrderMortality MADXOther benefit MADXInterest MADXLapse MADXExpense MADXUser Defined Scalars SectionUSER DEFINED SCALARS - USAGE SWITCHUSER DEFINED SCALARS - VALUESUser Defined Tables SectionUSER DEFINED TABLESUL Module CellsProcessing SectionCALENDAR YEAR RESULTSCell CodeSCENARIO DEPENDENCYPROJECTION METHODISSUE MONTH METHODTIMING OF ISSUEend of day nINFORCE ADJUSTMENTVOLUMESSERIATIM INFORCEAGE DISTRIBUTIONPOLICY YEAR RESULTSPricing Issue Year and MonthRisk classRisk class life 1 and life 2Block Reporting Category Formula TableProduct Features SectionTARGET REGULAR PREMTarget Regular Premium AdjustmentMINIMUM PREMTARGET DUMPIN PREMMAXIMUM PREMIUM INFLATIONPREM LOADGUARANTEE PREM LOADEXP CHARGEGUARANTEE EXP CHARGECREDITED iFUND BONUSSURR CHARGESECOND FUNDFACE AMOUNTCOMMISSIONBONUS & CBKRISK CHARGEGUARANTEE RISK CHARGEEARNED RISK CHARGEEXTRA COMMOther BenefitsDISTRIBUTION TABLESALESPremium distribution byPremium distributionADDITIONAL POLICY FEEPROP. OF POLICY FEE COMMISSIONABLELapse Distribution During the Year (INIT/YR N+)AGE MIX DURATIONAGE MIX BASISLIFE STATUS1st LIFE IS2ND LIFE ISCONTAGION FACTORMaturity AgeMINIMUM PREM TABLE switchNPOLICY FEE TREATMENTCREDITED INTERESTSUM OF PREMS IN FAEXPENSE BASISFIRST YR COMMISSIONSPOLICY TERMINATESNAAR METHODMINIMUM NAARX =Y =Risk Charge AdjustmentEXTRA COMM TABLEUNEARNED COMMISSIONPARTIAL WITHDRAWALFREQUENCY OF CHARGESMATURITY VALUEINFLATION SOURCESEG FUND OPTIONSACCUMULATING FUND FOR ILLUSTRATIONFACE AMOUNT ADJUSTMENT OPTIONFA Attained Age =FA Duration =FA Minimum =FA Maximum Proportional Decrease =TARGET VANISHING PREMIUM DURATIONVANISH DURATIONVANISH ATTAINED AGEVANISH ULTIMATE TARGET FUNDSURRENDER BONUS AS % of T5 AMOUNT ON LAPSE (IIT CREDIT)ACB NAAR For Surrender BonusMVA Sign LimitationProduct Features - Continuation guarantee (NLG)Continuation guarantee optionX =Y = Z =Continuation guarantee criteriaWaiver of fund chargesNA Deferral PeriodNA ChargeNA Minimum premNA Prem loadNA MF prem loadNA Exp chargeNA Credited iNA Risk chargeNA MF risk chargeNA COI discountX =Y =NA NAAR methodNA charge optionProduct Features - Fund 1 InvestmentsFund 1 InvestmentAllocation Rules TablePending AccountPending Account OptionNegative Balance Interest SpreadHolding Account Option for Pending AccountHolding Account Maximum Balance XProduct Features - Side FundSIDE FUND OPTIONTHRESHOLD FUNDCOMMISSIONInvestment AccountProduct Features - Policy LoansPolicy Loans OptionLoan account adjustmentPOLICY LOAN CHARGELOAN ACCOUNT CREDITED RATEPOLICY LOAN REPAYMENTMultiple Reinsurance SectionOverview of Multiple ReinsuranceMultiple ReinsuranceReinsurance TermsNet Amount At RiskSingle Reinsurance SectionSingle ReinsuranceProp CededFace AmountCommissionBonus & chbkRisk ChargeOther BenefitsDef CommDef Bon & ChbkPremium TaxPremium Tax RatePremium Tax BasisPrem Tax Basis AdjReinsurance ModeReinsurance MethodTreatment of Mat ValWUnearned Ceded PremsYUnearned Ceded CommZAdj for UnregisteredXEarned Risk Charge for YRTGeneral Assumptions SectionSPARE FIELDKEYCODERESRV DETAILSVAL YRDECREMENTSCALCULATION OF MORTALITY PADMINIMUM Q REFERENCE TABLEF factor (VTP 8)Pricing Assumptions SectionTOTAL PREMIUM TABLEPartial Withdrawal TableDYNAMIC PREMIUM ADJDYNAMIC PREMIUM ADJ APPLIESM =N =MORTALITYMORT LIFE 2AIDS EXTRA QAIDS LIFE 2INTERESTOther Benefit Rates TableLAPSE RATEEXTRA LAPSEEXPENSE tableCAPITAL CHARGEMODIFICATIONADJUSTMENT TABLE 1ADJUSTMENT TABLE 2START ACCUMULATING PROFIT MEASURES AT POLICY YEARAIDS EXTRA Q TABLELAPSE ATADJUSTMENT TABLE 1 optionADJUSTMENT TABLE 2 optionDISCOUNT RATEDISCOUNT RATE BASISDISCOUNT INTEREST RATE TABLEHURDLE RATEEMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUSEMBEDDED VALUE ADJPROFIT MARGINPROFIT EMERGENCE (PV)PROFIT EMERGENCE (ROI)ROI DefinitionTime Zero StrainTaxes SectionTAX METHODXCORPORATE TAX RATESDIFFERENTIAL EARNINGSTAX EXEMPT INVESTMENT INCOME TABLEPREMIUM TAX RATEPREMIUM TAX-BASISPREM TAX BASIS RE-INSDAC TAX METHODTDAC CAPITALIZATION RATEDAC TAX BASISDAC TAX AMORTIZATION PERIODCANADIAN IIT RATEPROPORTION OF IIT DEDUCTIBLEIIT BOND YIELD DEFINITIONIIT PAYMENT FREQUENCYPolicyholder Tax SectionExempt Test Policy AssumptionsMortalityMortality for Joint LivesInterestExempt Test DurationAccumulating FundETP Line TreatmentAdditional Exempt Test Policy LinesExempt Test Mortality TablesT5 AssumptionsACB MortalityAccumulating FundPolicy loan interest impact on ACBT5 CalculationACB Mortality TablesUS Policyholder Tax7-Pay TestGuideline Single PremiumGuideline Level PremiumStatutory, Second, Third, Fourth, Fifth and Tax Reserves SectionsReserve MethodReserve Assumption TablesInput Terminal Reserve Factors TableFund based reserve adjustmentIIT RateMortality: Minimum 1st lifeMortality Minimum: Second LifeMORTALITY PADAIDS EXTRA Q TABLELAPSE ATADJUSTMENT TABLE 1 optionADJUSTMENT TABLE 2 optionLIMITATIONStatutory Reserve FloorClaim RecognitionIIT LIABILITYTAX RESERVE CEILINGDAC amortization periodDEFERRED TAX LIABILITYDeferrable comp for DACDeferrable expense for DACLapse rate PADLapse rate margin (X =)Extra lapse PADReserve for other benefitReinsurance expense methodReinsurance expense modeSFAS97 Unearned RevenueReinsurance treatmentNegative unearned revenueDeficiency reserveSecondary guaranteeSelect factors for CRVM / GMDBCRVM / XXX basic reserveXXX Segment Mortality Ratio Adjustment FactorZ =XXX Notional Account Minimally Funded Risk ChargeXXX Notional Account Premium LoadAXXX adjustmentExpense allowancePremium for expense allowanceRenewal amount of insuranceFirst year valuation premiumReserve adjustmentCRVM Valuation modeTabular cost floorReserve revaluationTotal Premium TablePartial Withdrawal TableInterpolationValuation scenariosDynamic premium adjustmentDynamic Premium Adjustment AppliesM =N =Mean Reserve MethodTIME ZERO RESERVEYRT REINSURANCE CREDITFUND/CSV BASED RESERVESRequired Surplus SectionREQUIRED SURPLUS METHODXRequired Surplus Factors (%)Reserve ComponentLapse Risk ComponentABStatutory PFAD Analysis SectionSTAT PFAD ANALYSISReserve Recalculation OrderMortality MADXOther benefit MADXInterest MADXLapse MADXExpense MADXUser Defined Scalars SectionUSER DEFINED SCALARS - USAGE SWITCHUSER DEFINED SCALARS - VALUESUser Defined Tables SectionUSER DEFINED TABLESPar Module CellsProcessing SectionCALENDAR YEAR RESULTSCell CodeSCENARIO DEPENDENCYPROJECTION METHODISSUE MONTH METHODTIMING OF ISSUEend of day nINFORCE ADJUSTMENTVOLUMESDEFINED ASSERIATIM INFORCEAGE DISTRIBUTIONMODAL DISTRIBUTIONPOLICY YEAR RESULTSPricing Issue Year and MonthRisk classRisk class life 1 and life 2Dividend Assumptions SectionMORTALITYMort life 2AIDS EXTRA QAIDS life 2INTERESTOther Benefit Rates TableLAPSE RATEEXPENSES tableMODIFICATIONADJUSTMENT TABLE 1ADJUSTMENT TABLE 2DIVIDEND ADJUSTMENTProduct Feature Tables for Dividend CalculationsDIVIDEND FORMULADividend Formula AdjustmentInflation of ExpensesTreatment of Generated DividendCSV (Dividend Expected) FormulaDividend Expense BaseTreatment of ROUPDividend FloorsADJUSTMENT TABLE 1 optionADJUSTMENT TABLE 2 optionProduct Features SectionPREMIUMSFACE AMOUNTCASH VALUEROPCOMMISSIONSBONUS & CBKDIVIDENDTERMINAL DIVSURR DIVENHANCE FACEYRT TERM COSTPAIDUP NSPPAIDUP CSVVANISH DURATION (ISSUE AGE)PUA Bonus / Extra DividendOther BenefitsSHAREHOLDER DIVIDEND RATEDIVIDEND OPTIONEnhance Face optionN =VANISH PREMIUMVANISH DURATIONVANISH ATTAINED AGENO. OF SHORTFALLS FREEPROPORTION IN THE RESERVEVALDISTRIBUTION TABLESALESAGE MIX DURATIONAGE MIX BASISLIFE STATUS1ST LIFE IS2ND LIFE ISMATURITY AGEPOLICY SIZE ISCSV Formula optionXMid Year CSVMATURITY VALMVDISTRIBUTION OF SALES BY MODEMODAL PREMIUM FACTORSPOLICY FEE WITH EACH PREMIUMPROPORTION OF LAPSES AT YR ENDPREMIUM RATESUNEARNED PREMIUMSUNEARNED COMMISSIONEXPENSE BASISDIVIDEND TABLE HOLDSREGULAR DIV ON DEATHXREGULAR DIV ON LAPSEXSURR/TERM DIV TABLETerm div adjustSURRENDER DIV TIMINGPROP. OF POLICY FEE COMMISSIONABLEProduct Features - Additional Premiums SectionMethodFirst Year PremiumCash Out of PUAAllocation of bonusAdditional Premium Rate TableCommission TablePremium Load TableBonus on PUA TableAdditional Premium LimitBonus on PUA optionMultiple Reinsurance SectionOverview of Multiple ReinsuranceMultiple reinsuranceReinsurance termsNet amount at riskInput factorsSingle Reinsurance SectionSingle ReinsuranceReinsurance TablesOther Benefit Set TablePREMIUM TAX RATE FROM REINSURER PREMIUM TAX BASIS CEDEDPREMIUM TAX BASIS CEDED ADJPREMIUM TAX REFUND CEDEDUNEARNED CEDED PREMIUMSUNEARNED CEDED COMMREINSURANCE METHODROP BENEFITCEDED RATIO FOR OTHER BENCEDED POLICY FEEPROP COMMISSIONABLEGeneral Assumptions SectionSPARE FIELDKEYCODEPREM VOLUMECALC. TABLE 1RESRV DETAILSY =DECREMENTSCALCULATION OF MORTALITY PADMINIMUM Q REFERENCE TABLEF factor (VTP 8)Pricing Assumptions SectionPricing Assumption TablesSTART ACCUMULATING PROFIT MEASURES AT POLICY YEARAIDS EXTRA Q TABLELAPSE ATDISCOUNT RATEDISCOUNT RATE BASISDISCOUNT INTEREST RATE TABLEHURDLE RATEEMBEDDED VALUE: SHAREHOLDER DIVIDENDEMBEDDED VALUE: CONTRIBUTIONS TO FREE SURPLUSEMBEDDED VALUE ADJPROFIT MARGINPROFIT EMERGENCE (PV)PROFIT EMERGENCE (ROI)ROI DefinitionTime Zero StrainTaxes SectionTAX METHODXCORPORATE TAX RATESPREMIUM TAX RATECANADIAN IIT RATETAX EXEMPT INVESTMENT INCOME TABLEPREMIUM TAX BASISYPREMIUM TAX BASIS ADJPREMIUM TAX REFUNDDAC TAX METHODTDAC CAPITALIZATION RATEDAC TAX BASISDAC TAX AMORTIZATION PERIODCANADIAN IIT RATEPROPORTION OF IIT DEDUCTIBLEIIT BOND YIELD DEFINITIONIIT PAYMENT FREQUENCYPolicyholder Tax SectionExempt Test Policy AssumptionsMortalityMortality for Joint LivesInterestExempt Test DurationAccumulating FundETP Line TreatmentExempt Test Mortality TableT5 AssumptionsT5 CalculationAccumulating FundACB MortalityACB Mortality TableStatutory, Second, Third, Fourth, Fifth and Tax Reserves SectionsReserve MethodReserve Assumption TablesCommission table for valuationBonus & Chargeback table for valuationInput Terminal Reserve Factors TablePREMIUM LIMITMORTALITY MINIMUM: FIRST LIFEMORTALITY MINIMUM: SECOND LIFEMORTALITY PADADDITIONAL PADYEARSAIDS EXTRA Q TABLELAPSE ATAdjustment Table 1 optionAdjustment Table 2 optionLIMITATIONStatutory Reserve FloorRECOGNITION OF CLAIMSIIT LIABILITYDEFERRED TAX LIABILITYCompensation in reserveDividend table for valuationSurrender Dividend TableInterest to DAC balanceDAC amortization patternDAC amortization period (yrs)GAAP maintenance expense reserve floorCeded GAAP maintenance compensationCeded compensation for DACTerminal dividend liabilityRESERVE APPROACHOYT NLP methodOTHER BENEFIT RESERVEOther Benefit for NLP (N=)TAX RESERVE LAPSESREINSURANCE TREATMENTUS expense allowanceRenewal amount of insuranceLAPSE RATE PADLapse margin % (X =)Valuation modeSubstandard methodReinsurance expenseReserve revaluationM =N =Revaluation method