PRC2021.3.6 Released August 1, 2021

  • Corrected a 1-year error in the application of scheduled withdrawals from “your” inherited IRA account (the withdrawal was occurring one year too early)
  • Corrected an import error: The maximum IRMAA value on the Roth conversion page was always being set to “No Limit” during imports from a 2021 export file


PRC2021.3.5 Released July 31, 2021

  • Changed Tennessee state tax rate to zero, thus making it a no-tax state.
  • Corrected an error in the annual adjustment of Capital Loss Carryover for the regular investment account
  • Corrected an error in the calculation of capital gains taxes on qualified dividends in the case where there is a positive Capital Loss Carryover amount


PRC2021.3.4 Released June 24, 2021

  • Removed the code added in v3.3 which attempted to correct for the occasional loss of PRC’s nav menu in some versions of Excel for Macs; that code had a negative effect on PRC page scrolling. The ultimate workaround for the loss of the nav menus is unknown at this point.


PRC2021.3.3 Released June 15, 2021

  • Made a correction to the implementation of the American Rescue Plan Act of 2021 in regard to Roth conversions in 2021 and 2022 with no ACA insurance
  • Added some code in an attempt to correct for an Excel for Macs issue related to occasional loss of PRC’s navigation menu when changing pages


PRC2021.3.2 Released June 9, 2021

  • Made a minor correction to the “dollar difference” display on the optimized withdrawal priorities section of the Analysis > Optimization page.


PRC2021.3.1 Released June 9, 2021

  • Corrected an error in the calculation of first-year expenses on new property loans on the Expenses > Property page.
  • Added a new state tax bracket for top-earners in Arizona
  • Implemented the ACA-related changes associated with the American Rescue Plan Act of 2021 for Monte Carlo and historical analyses (inadvertently omitted from v3.0)


PRC2021.3.0 Released May 31, 2021

  • Implemented the ACA-related changes associated with the American Rescue Plan Act of 2021
  • Corrected the formatting of the pay-out start field for Annuity #2 for scenarios 2 and 3 on the Income page.
  • Made a change to allow entry of negative values on Unrealized Capital Gains for Regular Investment Accounts on the Financial Assets > Initial Balances page.
  • Corrected a couple of errors related to cash-out refinancing on rental properties
  • On the Analysis > Optimization page, displayed the dollar difference between the optimized withdrawal priorities and the user-specified withdrawal prioritues


PRC2021.2.4 Released Mar 22, 2021

  • Added columns for cash value life insurance and ROR for Spouse’s Tax-Deferred Account on the Tabular Projections > View Mgmt page
  • Made a small correction in the Social Security start age optimization algorithm
  • Corrected a potential circular reference error in the HELOC model
  • During Roth optimizations for single individuals, ensured that the mode for the spouse’s conversion was set to “No Conversions”
  • Made a minor correction to the consumption smoothing algorithm relative to pre-retirement years
  • Made a correction to exclude miscellaneous expenses and non-QCD charitable donations when a spending strategy other than “As Specified” or “As Specified with Smoothing” is selected
  • Corrected an error in the Monte Carlo and Historical analyses (Qualified Charitable Distributions were being computed incorrectly)


PRC2021.2.3 Released Mar 1, 2021

  • Replaced the “Dd” with a blank in the age column of tabular outputs and the time axis of graphs
  • Added “Spouse Tax-Deferred Account” rate of return values to the PDF Inputs Report
  • Corrected the withdrawal order description in the PDF Input Report
  • Corrected a regression error on the Analysis > Optimization page (period 2 and 3 withdrawal order results not being displayed; this error was introduced in v1.6)


PRC2021.2.2 Released Feb 22, 2021

  • Made some conditional formatting changes to the Input Report (printable PDF)
  • Corrected an error in the state income tax table for Pennsylvania
  • Corrected a regression error on the Tabular Projection > View Mgmt page (the column headers were accidentally hidden in v2.1)


PRC2021.2.1 Released Feb 19, 2021

  • Corrected an error in the conditional formatting on the Financial Assets > Taxation page
  • Corrected an error in the constant spending algorithm in the case where retirement began prior to the start of the modeling period
  • Corrected an error that causes a run-time error when attempting to change the position of the column headers on any of the tabular projection pages
  • Made an adjustment to the formatting of the secondary navigation links on the Tabular Projection pages to make them fully visible on Excel 2007


PRC2021.2 Released Feb 8, 2021

  • Corrected an error in the calculation of the tax-exempt interest contribution to MAGI for healthcare which, in turn, affects ACA subsidy calculations
  • Enhanced the ACA healthcare calculations to automatically adjust the Second Lowest Cost Silver Plan cost for married couples when the first partner goes on
  • Medicare which, in turn, affects ACA subsidy calculations
  • Corrected a case where the 10% penalty was not applied on early withdrawals from tax-deferred accounts


PRC2021.1.9 Released Feb 1, 2021

  • Corrected a potential source of error with historical analyses that use only asset classes with historical sequences dating back to 1871


PRC2021.1.8 Released Jan 30, 2021

  • Corrected an error in the calculation of overall asset allocation


PRC2021.1.7 Released Jan 26, 2021

  • Corrected a typo in a formula related to paying college expenses with a 529 plan for Child #4


PRC2021.1.6 Released Jan 26, 2021

  • Made an enhancement on the Analysis > Roth Conversions page to highlight the Prioritization field if it’s left blank and to automatically fill it in with “You” if it’s left blank when optimization is done.
  • Added an “Adopt” button on the Analysis > Optimization page to enable the user to adopt the results of the optimized withdrawal order algorithm
  • Corrected a non-convergence issue with the earliest retirement date optimization algorithm when using different life expectancies across the three scenarios


PRC2021.1.5 Released Jan 24, 2021

  • Corrected a Monte Carlo analysis error that results in use of a zero standard deviation for assets 4 through 10.
  • Corrected the operation of the dollar units button on the Analysis > Compare Fixed Rate Analysis Results page

PRC2021.1.4 Released Jan 24, 2021

  • Corrected a run-time error associated with use of the today’s-to-future$ converter on the Income page
  • Corrected the pull-down menu on the Source Account field for purchasing annuities for the spouse (on the Income page)
  • Added code to adjust the vertical axis on the Roth conversion page after each automated optimization event


PRC2021.1.3 Released Jan 21, 2021

  • Corrected the code that shows and hides the expense graphs on the Run Analysis page; this was causing run-time errors on Excel 2007 and 2010 configurations.


PRC2021.1.2 Released Jan 20, 2021

  • Corrected errors in the state income tax calculations for the states of MS and NM


PRC2021.1.1 Released Jan 19, 2021

  • Corrected an error that had the potential to cause Historical analysis to report an invalid scenario
  • Eliminated the source of a potential error in the calculation of Social Security spousal benefits for a single person (obviously there are none)
  • Corrected an error related to importing from the latest PRC2020.3.10 (PRC2021 thinks it’s a 2021 export file)
  • Corrected a formula in one cell of the Total Expenses in the table at the bottom of the Property Expenses page


PRC2021.0 Initial Release Jan 18, 2021