Join Early Retirement Today
Thread Tools Search this Thread Display Modes
looking for advice on software for analysis
Old 04-01-2021, 04:13 PM   #1
Dryer sheet wannabe
Join Date: Apr 2012
Posts: 13
looking for advice on software for analysis

My husband and I need to make some decisions around timing of deferred comp payouts as well as timing of ROTH conversions. We will be juggling these variables along with how timing may impact ACA costs and IRMAA to ensure that we are being as cost/tax efficient as possible.

With that as the backdrop, what is the best software out there that can handle analyzing all of these moving parts? I am fairly adept at excel, but I dread building my own spreadsheet model for fear that I will miss something that could have significant financial consequences. And, yes, as my user name states, I am a cpa. However, I spent most of my career in corporate finance and know only enough to be dangerous in personal taxes

Thanks in advance for any information you can provide.
rasberrycpa is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 04-01-2021, 11:30 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Sunset's Avatar
Join Date: Jul 2014
Location: Spending the Kids Inheritance and living in Chicago
Posts: 13,906
It will be great if you find some, even if it answers only part of the question.
Fortune favors the prepared mind. ... Louis Pasteur
Sunset is offline   Reply With Quote
Old 04-02-2021, 03:23 AM   #3
Recycles dryer sheets
Join Date: Jul 2015
Posts: 380
Well - have a look at Retiree Portfolio Model from over at Bogleheads. I've only been playing around with it. It won't simply calculate the optimum for you, but based on your inputs it will give you the output.
clobber is offline   Reply With Quote
Old 04-02-2021, 05:50 AM   #4
Thinks s/he gets paid by the post
Join Date: Oct 2011
Location: Philadelphia
Posts: 1,067
I've never found anything that handles deferred comp gracefully. I always have to hack things. Even the firm that houses my deferred comp and offers financial planning to go along with it doesn't have a calculator that properly deals with deferred comp!

Personally, I've just built up a variety of home grown models that I sanity check with other calculators and rules-of-thumb.
Luck is when Preparation meets Opportunity.
Closet_Gamer is offline   Reply With Quote
Old 04-02-2021, 06:41 AM   #5
Thinks s/he gets paid by the post
Markola's Avatar
Join Date: Nov 2013
Location: Twin Cities
Posts: 3,278
If you’re a CPA, why not hire a CPA with expertise in that topic?
Markola is online now   Reply With Quote
Old 04-02-2021, 07:44 AM   #6
sengsational's Avatar
Join Date: Oct 2010
Posts: 9,560
If you've never tried i-orp, it might be worth a try. It runs an all-years optimization and includes the ability to Roth convert as well as income limit for the ACA. You will have to iterate on deferred compensation options, and might not be a way to input that. It's a web based tool, free. Look for the advanced link down nearer the bottom of the default page. Also, if you rebalance across all tax categories, put the same stock % in all 3 buckets.
sengsational is offline   Reply With Quote
Old 04-06-2021, 07:24 PM   #7
gone traveling
Join Date: Aug 2020
Posts: 682
The Retiree Portfolio Model (RPM) on Bogleheads suggested by @clobber is the best tool I have come across. i-orp is not helpful for me. TIAA has a tool that is unhelpful.

I built my own model 25 years ago, and have been tweaking it for that amount of time. It has evolved to be similar to the RPM, although less fancy.
chassis is offline   Reply With Quote
Old 04-07-2021, 04:29 AM   #8
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
target2019's Avatar
Join Date: Dec 2008
Location: Stuck in the mud somewhere in the NJ swamp
Posts: 8,380
I use a combination of my 10-year plan (one sheet summary), Flexible Retirement Planner, and TurboTax WhatIf worksheet. But I only have the Roth Conversion need in my model.

The aha moment for me was that with any of the tools I eventually had to take ownership of the problem, and understand the inputs and outputs. An app can give you an answer, but have you entered every variable correctly?

I would start with the RPM tool, but it is a challenge.
target2019 is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need some situation analysis/advice upupandaway FIRE and Money 18 12-28-2019 11:56 AM
Looking for good free CD/DVD burning software for Windows 7 easysurfer Other topics 17 02-20-2011 01:49 PM
Vanguard Retirement Analysis vs. 4% withdrawal analysis familyretired FIRE and Money 3 08-26-2005 02:33 AM

» Quick Links

All times are GMT -6. The time now is 09:20 PM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2022, vBulletin Solutions, Inc.