A new version of the Retiree Portfolio Model model is available which includes 2017 tax data and numerous minor updates. I recommend all users download it. Minor update June 13.
Version 17.0 can be downloaded from Dropbox via this link: https://www.dropbox.com/s/xzawrbf773a9r ... 0.xls?dl=0 [Updated Jan 12 after fixing macro name conflict problem. Updated Jan 13 to fix Fed Exemption error. Updated Jan 16 to fix Clear Entries error caused by Jan 12 fix. Updated Mar 18 to fix Summary page where too many columns were being hidden by the macro. Updated Apr 20 to fix calculation of state AGI that was adding back wrong Federal tax-exempt/non-taxed amount. Updated Jun 7 fixing "Year Single Rate Starts" 0 error that forced use of the single rate if no "End Age" was entered for either person. Thanks to sandramjet for finding this. Updated June 13 - fixed beginning of year balances for IRAs inherited in first model year to zero. Was doubling up the amounts. Thanks to BH jeffaron for discovering this malfunction.]
A new version of the model which excludes the Base case is also available for those who don't have a need for Roth conversion or SS benefits analyses that the standard model provides. While the hiding of the Base case can be done via macros, those who don't want to use macros or use programs that don't support macros, may find this a good alternative. This provides a simpler version of the model and most retirees post-age 70 will probably find this easier to use.
Version 17.0xb (excluding Base) can be downloaded from Dropbox via this link: https://www.dropbox.com/s/my8uzv1n2hvo4 ... b.xls?dl=0 [Updated as detailed above.]
Changes in 17.0 include:
>Updated tax rates and brackets to 2017 amounts. Set tax factors escalation rate to 2.2% (was 2.5%).
>Added option to have additional personal exemptions. Modified tax factor escalation method resulting in slightly different forecast amounts.
>Added macros to hide little used pages (ORP page now hidden by default), and improved hiding Base case amounts and comparisons.
>Added calculation of Federal income tax impact of Roth conversion on the RMD of the IRA used in the conversion.
>Modified "copy results" macros on Setup page to also copy settings and data to their respective storage area on the Results page.
>Updated format and corrected totals for omitted factors and suppressed zeros to make for easier reading on Summary page
>Fixed calculation of IRA earnings in final year if account is zero. RMD assumed to be on Jan 1 now for earnings calculation.
>Fixed earnings calculation for final year if any account has a balance.
If anyone finds a problem please PM me, or post it.
A happy and prosperous new year to all!