New: Copilot Will Review Your Completed Actuarial Financial Planner Workbook

Many users have told me they aren’t always sure how to enter their assets and spending liabilities into the Actuarial Financial Planner (AFP) Excel workbooks. That’s completely understandable — the actuarial approach is powerful, but it’s also more detailed than traditional “safe withdrawal rate” tools.

To make things easier, Microsoft Copilot can now review your completed AFP workbook and provide a clear, structured summary of what you entered — along with comments on your actuarial funded status.

Increase Your Discretionary Retirement Spending While You Are Healthy and Active—Part 2

Retirement researchers increasingly recognize that real spending does not remain flat throughout retirement. As Dr. David Blanchett emphasized in his recent Think Advisor article:

 “Integrating reduced real spending into retirement income models not only improves the outcome of decisions around appropriate portfolio withdrawal rates, but also optimal portfolios, allocations to lifetime income, and so forth. Therefore, the more widely reduced real spending is leveraged in retirement research and financial planning tools, the more realistic the guidance is going to be.”

FAQ: How to Input Data for Deferred Assets and Expected Non‑Recurring Expenses in the Actuarial Financial Planner

Households often have assets they expect to use during retirement that are not level streams of income, as well as expenses that are not expected to recur every year. These items need special handling in the Actuarial Financial Planner (AFP) because they occur at specific future dates and often carry different risk characteristics than ongoing retirement spending.

How to Use Copilot to Implement the Actuarial Approach

We have recently received inquiries as to how to use Copilot to implement the Actuarial Approach. Copilot can use different data sources to provide reasonable results, but we recommend that you provide Copilot with the specific data required by the Actuarial Financial Planner. This post explains the best way to use Copilot — whether you are an advisor working with clients or a retiree managing your own plan.

Planning Key: Plan to Live Longer Than You Expect to Live

Prudent retirement planning requires using a planning horizon longer than your life expectancy. In prior posts we have recommend using the Actuarial Longevity Illustrator and the three-step process outlined in our Advisor Perspectives article to select your household lifetime planning period(s). In this post, we will once again discuss the importance, in planning and retirement decision-making, of focusing on how long you plan to live, not on how long you expect to live. 

2026 Trustees Report Issued — Once Again, Results Are Worse Than We Predicted

The 2026 OASDI Trustees Report was released today. Last month, we estimated that Social Security’s long‑range actuarial balance as of January 1, 2026 would be –4.14% of the present value of taxable payroll over the next 75 years (down from –3.82% in 2025), corresponding to a funded status of roughly 76%. Our estimate turned out to be optimistic.

Understanding the Retirement Probability Simulator (RPS): A Complement to the Actuarial Financial Planner

We recently came across a Monte Carlo modelling tool called the Retirement Probability Simulator (RPS). It is a free tool available at DIYretiree.com that our readers may find useful in their financial planning.

In this post, we will discuss the similarities and differences between our Actuarial Financial Planner (AFP) model for retirees and near retirees and the RPS (for retirees and pre-retirees) and how they can work together.

Announcement: Microsoft Copilot Joins Our Retirement Planning Team

We are pleased to announce that Microsoft Copilot is now an integrated part of our “How Much Can I Afford to Spend in Retirement?” team. Copilot enhances our actuarial approach by providing structured reasoning, rapid scenario analysis, and clear explanations of complex financial tradeoffs.

ChatGPT says the Actuarial Approach and its Funded Status Metric “Stands Above the Alternatives”

We recently asked ChatGPT two questions about using the Actuarial Approach and its Funded Status metric to evaluate a household’s retirement sustainability. ChatGPT had high praise for the Actuarial Approach. 

How Bad Will the News Be in the 2026 Social Security Trustees Report?

The 2026 OASDI Trustees Report is expected to be issued in the near future.  Last year, the 2025 report was released in June.   Like we did last year, we will take a shot at predicting this year’s 75-year actuarial balance (deficit) before the report is issued.