Best Gemini prompts for Actuaries

Using the Society of Actuaries' (SOA) most recent mortality tables, calculate the expected change in life insurance policy reserves for a portfolio of 10,000 policies, assuming a 2% increase in mortality rates across all age groups, and provide a sensitivity analysis to determine the impact of varying mortality improvement rates on reserve requirements, considering both the current and proposed tables, and including a comparison of the results to the previous year's reserve calculations, taking into account any changes in policyholder demographics or benefit structures.

Develop a stochastic model to estimate potential losses from a Category 4 hurricane impacting a coastal region with a high concentration of insured properties, using historical storm data and industry-accepted catastrophe modeling software, and generate a report detailing the expected losses by zip code, including a breakdown of the losses by policy type (e.g., residential, commercial, industrial) and a sensitivity analysis to determine the impact of varying storm tracks and intensities on the overall loss estimate, considering both the frequency and severity of potential losses.

Calculate the funding status of a defined benefit pension plan with 5,000 participants, assuming a 7% annual rate of return on plan assets and a 3% annual increase in benefit payments, and determine the required annual contributions to achieve a funded status of at least 80% within the next 5 years, considering the impact of potential changes in plan demographics, investment returns, and regulatory requirements, and provide a report detailing the results of the analysis, including a breakdown of the contributions by year and a sensitivity analysis to determine the impact of varying assumptions on the required contributions.

Using a generalized linear model (GLM) and a dataset of policyholder characteristics, claims history, and premium payments, develop a predictive model to estimate the expected claims frequency and severity for a portfolio of auto insurance policies, and calculate the optimal premium rates for each policy, considering the impact of potential changes in policyholder behavior, claims trends, and regulatory requirements, and provide a report detailing the results of the analysis, including a breakdown of the premium rates by policyholder segment and a sensitivity analysis to determine the impact of varying assumptions on the premium rates.