Best Claude prompts for Actuaries

Given a dataset of historical mortality rates by age and gender, and assuming a future trend that follows a specific pattern (e.g., linear decrease of 2% annually), adjust the current mortality rates to reflect projected future rates. Consider the impact of external factors such as improvements in medical technology and changes in lifestyle. Calculate the adjusted mortality rates for the next 10 years and provide a table comparing the original and adjusted rates. Additionally, assess the potential effect of these adjustments on life insurance policy pricing, considering a 5% profit margin and assuming that the company aims to maintain its current market share.

Conduct a sensitivity analysis to determine how variations in investment returns affect the liabilities of a defined benefit pension fund. Assume the fund has assets of $100 million, liabilities of $120 million, and an expected investment return of 7%. Analyze the impact of a 1%, 2%, and 3% change in investment returns on the fund's surplus or deficit over the next 20 years, considering an annual inflation rate of 2.5% and an average annual salary increase of 3%. Provide a graph illustrating the relationship between investment returns and the fund's financial position, along with a discussion on the implications for funding strategies and potential adjustments to investment portfolios.

Using a provided dataset of property insurance claims over the past 5 years, which includes information on claim frequency, severity, and policyholder characteristics, analyze the trends in claim frequency and severity over time. Apply regression analysis to identify significant factors influencing claim frequency and severity, such as policyholder age, location, and coverage limits. Estimate the expected claim frequency and average severity for the upcoming year, assuming no significant changes in policyholder demographics or external conditions. Also, calculate the 95th percentile of the predicted claim distribution to inform reinsurance decisions.

Validate a stochastic model used for asset liability management (ALM) by comparing its output with actual historical data. The model simulates the future asset and liability cash flows of a life insurance company over a 30-year horizon, using Monte Carlo simulations with 1,000 scenarios. The model inputs include expected returns on assets, interest rates, and mortality rates. Compare the simulated results with the actual outcomes over the past 10 years, analyzing any discrepancies and discussing potential reasons such as model simplifications or unforeseen economic events. Recommend adjustments to the model parameters or structure to improve its predictive accuracy.