Assumptions

Assumption input and calculations for individual policies.

This Space holds projection assumptions for each individual model point.

This Space is parameterized with PolicyID, and each ItemSpace of this Space is referenced in the Projection Spaces under the ItemSpace of SCR_life that has the same PolicyID as the ItemSpace of this Space.

For example Assumptions[1] is referenced in SCR_life(1).Projection(Risk) as asmp, where Risk is ‘base’, ‘mort’, ‘longev’,… etc.

Parameters

PolicyID

Policy ID

Type:

int

References

AssumptionTables

ExcelRange object holding data read from the Excel range AssumptionTable in input.xlsx.

MortalityTable

ExcelRange object holding mortality tables. The data is read from MortalityTables range in input.xlsx.

prod

Alias for Product()

polt

Alias for PolicyType()

gen

Alias for Gen()

sex

Alias for Sex()

AsmpLookup

Alias for AsmpLookup()

Cells

BaseMortRate(x)

Bae mortality rate

CnsmpTax()

Consumption tax rate

CommInitPrem()

Initial commission per premium

CommRenPrem()

Renewal commission per premium

CommRenTerm()

Renewal commission term

ExpsAcqAnnPrem()

Acquisition expense per annualized premium

ExpsAcqPol()

Acquisition expense per policy

ExpsAcqSA()

Acquisition expense per sum assured

ExpsMaintAnnPrem()

Maintenance expense per annualized premium

ExpsMaintPol()

Maintenance expense per policy

ExpsMaintSA()

Maintenance expense per sum assured

Gen()

InflRate()

Inflation rate

LastAge()

Age at which mortality becomes 1

MortFactor(y)

Mortality factor

MortTable()

Mortality Table

PolicyType()

Product()

Sex()

SurrRate(y)

Surrender Rate

BaseMortRate(x)[source]

Bae mortality rate

CnsmpTax()[source]

Consumption tax rate

CommInitPrem()[source]

Initial commission per premium

CommRenPrem()[source]

Renewal commission per premium

CommRenTerm()[source]

Renewal commission term

ExpsAcqAnnPrem()[source]

Acquisition expense per annualized premium

ExpsAcqPol()[source]

Acquisition expense per policy

ExpsAcqSA()[source]

Acquisition expense per sum assured

ExpsMaintAnnPrem()[source]

Maintenance expense per annualized premium

ExpsMaintPol()[source]

Maintenance expense per policy

ExpsMaintSA()[source]

Maintenance expense per sum assured

InflRate()[source]

Inflation rate

LastAge()[source]

Age at which mortality becomes 1

MortFactor(y)[source]

Mortality factor

MortTable()[source]

Mortality Table

SurrRate(y)[source]

Surrender Rate