Version 18.1 of the Retiree Portfolio Model model is now available.
This update adds new features along with other improvements and updates. Calculated results have not changed from 18.0 so only those who would like to use one of the new features need to download it.
Note: the model was updated as of April 16 5PM for minor fixes and improvements to the "clear entries" and "load entries" macros. Not essential, but re-download if you want this tweak.
Version 18.1 can be downloaded from Dropbox via this link: https://www.dropbox.com/s/id0188t4gh70u ... .xlsm?dl=0
Changes in version 18.1 include:
Added option to make yearly IRA contributions in IRAs 1 and 2. Note: Taxes on IRA withdrawals have not been adjusted (reduced) for these after-tax contributions as of v18.1.
Added option to reduce Social Security benefits in a future year as being forecast by the SS Admin (e.g., 23% reduction in 2035). Tip of the hat to i-ORP for this idea!
Added option to manually enter yearly living expenses and yearly amounts in the state AGI calculation on the Details page. Use if adjustments are needed to programmed entries.
Added editable areas to document yearly living expenses, SS benefits and tax calculator notes.
Improved estimates of Income Related Medicare Adjustments and ACA Premium Tax Credits.
Updated and improved bonus Federal income tax estimator, including the ability to calculate either 2017 or 2018 taxes. Many thanks to Boglehead rennale for his valuable suggestions and help in this effort.
Formatting change on Summary page to show expenses, etc. as positive numbers (without brackets).
Added and adjusted page breaks for better printing results
Other informational labels, instructions and comments as suggested by users.
Significant new features can have unforeseen problems so please contact me via PM or post in this thread with any issues you find, or suggestions you may have.