Weights vector

Actuarial Excel Addin

as a parameter of the LifeIns function

A weights vector is composed of contiguous worksheet cells (horizontal or vertical). Each cell contains a one-year weight starting at AgeIns. The last weight is used until the end of the insurance coverage period.

For ease of use in the various Excel formulas, the range of cells can be contained in a named range.

Example #1

100% insurance coverage for the first 5 years, 50% thereafter.

Cells_{1 to 5}:: 100%
Cell₆:: 50%

Example #2

Insurance coverage declining by 10% each year until it reaches a 50% coverage.

Cell₁:: 100%
Cell₂:: 90%
Cell₃:: 80%
Cell₄:: 70%
Cell₅:: 60%
Cell₆:: 50%