Beyond the Spreadsheet: A Professional’s Review of the Brentmark Retirement Plan Analyzer

In the world of financial planning software, most tools are designed for advisors. They are complex, expensive, and often output reports that are more confusing than clarifying for the client. For decades, my analysis of retirement income strategies—particularly the monumental decision of when to claim Social Security—relied on building intricate, multi-tab spreadsheets. It was a time-consuming process prone to manual error. Then I discovered a category of software built not for the advisor, but for the discerning individual and the estate planning professional: the standalone retirement analyzer. Among these, the Brentmark Retirement Plan Analyzer has established itself as a niche but powerful tool. Having used it to model countless scenarios, I can provide a clear-eyed assessment of its capabilities, its ideal user, and where it fits in the landscape of retirement planning.

Brentmark Software is a company that specializes in advanced tools for estate planning, charitable giving, and financial analysis. Their products are not marketed with flashy advertisements; they are known by word-of-mouth among attorneys, CPAs, and fee-only financial planners who need precision for complex client situations. The Retirement Plan Analyzer (RPA) is a Windows-based desktop application that focuses with laser precision on one of the most critical phases of financial life: the transition from accumulation to distribution.

The Core Function: Modeling the Distribution Phase

While many free online calculators ask for your age and savings and spit out a simple “you’re on track” message, the Brentmark RPA operates on a different level of sophistication. Its primary purpose is to answer nuanced, inter-dependent questions:

• What is the optimal Social Security claiming strategy for a married couple, considering spousal benefits, survivor benefits, and life expectancy?
• What is the most tax-efficient withdrawal sequence? Should I draw from my IRA first or my taxable brokerage account? When should I consider Roth conversions?
• What is the long-term impact of taking a pension as a lump sum versus a lifetime annuity?
• How required minimum distributions (RMDs) will affect my tax burden and overall plan?

The software doesn’t just give you an answer; it builds a year-by-year projection of your income, taxes, cash flow, and estate value through age 115.

The Standout Feature: Social Security Analysis

This is, in my opinion, the RPA’s killer feature. Deciding when to claim Social Security is often a million-dollar decision for a couple, and the RPA models this with exceptional granularity. You can input both spouses’ birth dates and Primary Insurance Amounts (PIA). The software then allows you to compare countless claiming scenarios side-by-side.

For example, you can model:

• Scenario A: Both spouses claim at age 62.
• Scenario B: One spouse claims early, the other delays until age 70.
• Scenario C: One spouse files and suspends (for those still eligible) to allow the other to claim a spousal benefit.

The software calculates the cumulative, after-tax benefits for each scenario over your lifetime. It can vividly illustrate how a decision to delay benefits, while forgoing income in the short term, can result in significantly higher, inflation-adjusted lifetime income, especially for the surviving spouse. The value of this analysis alone can justify the software’s cost for someone on the cusp of retirement.

Tax Planning Precision: Its Greatest Strength

Where the Brentmark RPA truly separates itself from simple calculators is in its tax engine. It doesn’t use a flat tax rate; it actually calculates your federal income tax liability year-by-year based on your projected income streams.

This allows you to see the real-world impact of decisions like:

• Roth Conversions: Should you convert a portion of your Traditional IRA to a Roth IRA in a low-income year before RMDs or Social Security kick in? The RPA can show you the upfront tax cost versus the long-term tax savings, helping you find the optimal conversion amount that doesn’t push you into a higher tax bracket.
• Withdrawal Order: It can model the consequences of drawing down accounts in different orders. Taking money from a taxable brokerage account first might allow tax-deferred accounts more time to grow, but it might also be less efficient than balancing withdrawals to keep your taxable income level and avoid IRMAA (Income-Related Monthly Adjustment Amount) Medicare surcharges.

The ability to project your marginal tax bracket years into the future is an incredibly powerful planning tool that is absent from most consumer-grade software.

The Practicalities: Cost, Interface, and Who It’s For

Cost: The software is purchased for a one-time fee (typically a few hundred dollars), not a subscription. This is a significant advantage for a professional who will use it for multiple clients or an individual who wants to run unlimited scenarios over time.

Interface: It is a Windows program with an interface that feels functional, not modern. It is dense with data input fields and outputs detailed, tabular reports. It is not “fun” to use like some slick mobile apps, but it is incredibly thorough.

Ideal User Profile: This is not a tool for everyone.

• The DIY Retiree: An individual or couple with a complex financial picture (multiple income sources, concerns about taxes) who possesses a high degree of financial literacy and comfort with detailed data.
• The Estate Planning Professional: Attorneys and CPAs who need to provide clients with definitive analysis on pension choices or Social Security strategies without the overhead of a full-scale financial planning platform.
• The Fee-Only Financial Advisor: Especially those serving middle-market clients where a full-scale subscription to MoneyGuidePro or eMoney might be cost-prohibitive per client.

Limitations and Considerations

The RPA is a specialist tool, and that comes with trade-offs.

• No Investment Assumptions: It does not model different asset allocations or market returns. You input a fixed, assumed rate of return for each account. This is a limitation for accumulation planning but is often a reasonable simplification for distribution planning, where spending and tax strategy are more impactful than chasing extra returns.
• Estate Focus, Not Investment Focus: It tells you how much you can spend and how to minimize taxes, but it won’t tell you what to invest in.
• Steep Learning Curve: The number of input fields can be daunting. It requires you to have a firm grasp of your financial data and the concepts behind it.

The Verdict: A Precision Instrument for a Specific Task

The Brentmark Retirement Plan Analyzer is not a holistic financial plan. It will not tell you if you are saving enough or how to allocate your portfolio. Instead, it is a precision instrument designed for one critical job: optimizing the spending of your nest egg once you have it.

For the individual who has accumulated assets and is facing the complex web of Social Security rules and tax implications, it offers a level of clarity that is difficult to achieve elsewhere. The value it can provide by identifying the optimal Social Security strategy or a tax-efficient Roth conversion plan can easily save a user tens of thousands of dollars over a retirement—far outweighing its one-time cost.

In a world of simplified, sometimes patronizing financial tools, the Brentmark RPA treats the user like an adult. It provides deep, actuarial-level analysis without a sales pitch or an ulterior motive to manage your assets. For the right person, it is an invaluable partner in making the most important decisions of their financial life.