Actuarial Mathematics Lab II

Topics

• Pension-plan concepts, normal cost and actuarial liability
• Excel formulas, lookup, date and text functions
• Spreadsheet charts, filtering and pivot tables
• VBA and user-defined functions
• Access databases, tables, forms and reports
• Database queries and SQL
• Life-insurance coverage and product types
• AXIS modules, datasets, funds, subfunds and cells
• Pricing a simple life-insurance plan in AXIS