Assumptions

Assumption input and calculations for individual policies.

This Space is a child Space of Projection, and it holds assumption parameters and rates used by the Projection Space.

Parameters

Since Projection is parameterized with PolicyID and ScenID, this Space is also parameterized as a child space of Projection. For example, simplelife.Projection[1].Assumptions.ExpsMaintSA() represents the expense maintenance per sum assured for Policy 1.

PolicyID

Policy ID

Type

int

ScenID

Scenario ID, defaults to 1.

Type

int, optional

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 simplelife.Projection.Policy.Product()

polt

Alias for simplelife.Projection.Policy.PolicyType()

gen

Alias for simplelife.Projection.Policy.Gen()

sex

Alias for simplelife.Projection.Policy.Sex()

AsmpLookup

Alias for simplelife.Input.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
InflRate()	Inflation rate
LastAge()	Age at which mortality becomes 1
MortFactor(y)	Mortality factor
MortTable()	Mortality Table
SurrRate(y)	Surrender Rate

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

InflRate()

Inflation rate

LastAge()

Age at which mortality becomes 1

MortFactor(y)

Mortality factor

MortTable()

Mortality Table

SurrRate(y)

Surrender Rate