Excel Functions in EAC ToolsExcel Functions in EAC Tools\Life insurance functionsLife insurance functions\DecrLifeInsJL

DecrLifeInsJL

DecrLifeInsJL returns the net single premium for a decreasing life insurance for two insured lives 𝑥 and 𝑦, payable upon the occurrence of the first death, based on assumptions for interest and mortality.

Syntax

DecrLifeInsJL (CurrentAgeX, CurrentAgeY, InterestRate, MortalityTableX, MortalityTableY, AgeSetbackX, AgeSetbackY, InitialAmount, [InsTiming])

Parameter Name

Description

CurrentAgeX

Current age of the 1st insured life 𝑥 (i.e. the age at the valuation date). May be provided as an integer, or as a fractional amount (e.g. years & months). If the age is not a whole number, the result is based on interpolation on results at whole ages.

CurrentAgeY

Current age of the 2nd insured life 𝑦 (i.e. the age at the valuation date). May be provided as an integer, or as a fractional amount (e.g. years & months). If the age is not a whole number, the result is based on interpolation on results at whole ages.

InterestRate

The interest rate(s) to discount future payments to calculate the present value.

·       Interest may be entered as a rate, e.g. 5% or .05; or 3 segments "i1/i2/i3". Other interest rate definitions that are available for annuities are not available for insurance.

·       Note: A value that is greater than 25% (i.e. 0.25) will be divided by 100; e.g. if you enter 2.75 it will be treated as .0275 or 2.75%.

MortalityTableX

Mortality table definition text string for the 1st insured life 𝑥.

MortalityTableY

Mortality table definition text string for the 2nd insured life 𝑦.
Optional, default = MortalityTableX.

AgeSetbackX

Mortality table age set-back for the 1st insured life 𝑥. A negative number is a set-forward.
Note that you can also define a setback using the "/sb" option in the table definition (or "/sf").
Optional, default = 0.

AgeSetbackY

Mortality table age set-back for the 2nd insured life 𝑦. A negative number is a set-forward.
Note that you can also define a setback using the "/sb" option in the table definition (or "/sf").
Optional, default = 0.

InitialAmount

Initial amount of life insurance, decreasing 1 per year.

InsTiming

Defines when the payments are made in the year of death.
Optional, default = 1.

AnnTiming

Description

0 or .5 or “mid”

mid-year

1 or “end”

end of year