Overview of the CashValue_SE Model
mainThe CashValue_SE model projects monthly cashflows for generic hypothetical savings products. It can project both new business and in-force policies for a single sample model point at a time.
Key features include:
- Product Types: Supports 4 product specifications (A, B, C, D). A and B are single premium products (simulating variable annuities), while C and D are level premium whole life products (simulating variable life).
- Cashflow Logic: Premiums (net of loadings) are added to the account value; maintenance fees and cost-of-insurance charges are deducted at the start of each month; investment returns are then applied.
- Benefits:
- Death Benefit: The greater of the sum assured or the account value.
- Surrender Benefit: The account value net of surrender charges (if applicable).
- Maturity Benefit: For types A and B, the remaining account value is paid at maturity.
- Data Dependencies: Uses
product_spec_table.xlsxfor product parameters andstd_norm_rand.csvfor investment return calculations.