Best Grok prompts for Actuaries

Using the Society of Actuaries' 2022 Valuation Basic Table and assuming a 2% annual increase in mortality rates, calculate the expected number of deaths for a population of 100,000 individuals aged 65-75 over the next 10 years, incorporating factors such as smoking prevalence, obesity rates, and air quality indexes. Then, compare these projections to historical data from the past 5 years to identify any significant deviations or trends. Finally, provide a sensitivity analysis to determine how changes in the assumed mortality rate increase would impact the results.

Develop a stochastic model to simulate the potential impact of a category 4 hurricane on a portfolio of 500 commercial properties in a coastal region, using a combination of historical storm data, geographic information systems, and machine learning algorithms to estimate damage probabilities and financial losses. Assume a 10% chance of a category 4 hurricane occurring in the next 12 months and a 5% chance of a category 5 hurricane. Then, calculate the expected losses and 95th percentile losses for the portfolio, and provide a breakdown of the results by property type and location.

Using the projected benefit obligation (PBO) method, calculate the funded status of a defined benefit pension plan with 10,000 participants, assuming a 7% annual rate of return on assets, a 3% annual increase in salaries, and a 20-year amortization period for any shortfalls. Then, perform a scenario analysis to determine the impact of a 1% decrease in the discount rate, a 10% decrease in asset values, and a 5% increase in life expectancy on the plan's funded status. Finally, provide a recommendation for the annual contribution required to achieve a fully funded status within the next 10 years.

Analyze the historical healthcare cost trend data for a large employer group, incorporating factors such as demographic changes, inflation, and advances in medical technology. Using a combination of linear regression and machine learning algorithms, forecast the future cost trend over the next 5 years, assuming a 5% annual increase in healthcare utilization and a 2% annual increase in provider fees. Then, calculate the expected costs and provide a breakdown of the results by type of service (e.g., inpatient, outpatient, pharmaceuticals). Finally, identify potential areas for cost savings and provide recommendations for plan design changes or disease management programs.