Since the passing of the new tax law effective in 2018, major tax software vendors such as TurboTax, H&R Block, and TaxACT updated their online tax calculators.
- TaxCaster by TurboTax
- Free Income Tax Calculator by H&R Block
- Tax Calculator by TaxACT
These tax calculators do an adequate job for the most part. However, none of them includes the premium tax credit when you get health insurance under the Affordable Care Act (ACA), also known as Obamacare. To millions of people who get subsidy for health insurance from the ACA, this is a major gap, because their income affects the amount of subsidy they will receive. Getting more subsidy reduces their tax dollar for dollar; qualifying for less subsidy increases their tax dollar for dollar.
The most accurate way to project taxes is to use the downloaded/installed tax software. However, tax software for the current year won’t be available until November or December. I found a link to a spreadsheet posted to the Bogleheads Wiki. It’s called Personal Finance Toolbox. It’s an actual spreadsheet file, not an online one. You will need Microsoft Excel or compatible software to open it. As with anything downloaded from the Internet, you will have to trust the source. With 13 tabs, this spreadsheet does a lot of things. It looks overwhelming if you are only looking for one feature out of many.
I will show you how this spreadsheet can help calculate the effect of Roth conversion or long-term capital gains when you receive subsidy for health insurance from ACA. I used version 11.13 released on July 20, 2018. I don’t know the author of this spreadsheet. Nor did I verify its accuracy. I assume it’s reasonably accurate because it looks like the author put a lot of work into it.
Scenario
Two adults, both age 60, retired, married filing jointly, no dependents. They live on $40k traditional IRA withdrawals and $5k qualified dividends. They have no other income or deductions. The full price of the second lowest cost Silver plan from the ACA marketplace is $2,000/month. They chose that plan, paying $250/month out of pocket, with $1,750/month from the advance subsidy. Questions:
- How does it affect their taxes if they convert additional $10,000 from their traditional IRA to Roth?
- How does it affect their taxes if they realize $10,000 in long-term capital gains?
Personal Finance Toolbox
We go to the Calculations tab. First we enter their filing status, number of dependents, and ages starting at cell G2.
Next we enter their income. Because they are retired, we skip the paycheck items and we go down to non-paycheck income starting at cell D23. We only input into cells in green. Use annual numbers here.
Then we go down to the monthly average expense section and enter the full price health insurance premium and the advance subsidy in cells B113 and B114. Remember to enter the monthly numbers here. Enter the advance subsidy amount as a negative number.
Now scroll to the far right to cell AC87 or use the find function in your spreadsheet software to locate “Form 8962.” Enter the full price of the second lowest cost Silver plan in cell AE99. Use the annual number here. You may notice it shows “Other 48” in this area. If you live in Alaska or Hawaii, enter “AK” or “HI” in cell H35.
Finally, we go back to the tax calculation area starting at cell F11. This shows their baseline estimated federal income tax.
As you see from above, the spreadsheet estimates that this retired couple will pay $2,552 in federal income tax. With $45,000 in AGI, that’s average tax rate under 6%. Normally they would be good candidates for converting a part of their traditional IRA to Roth to take advantage of their low tax rate before they start Social Security and before RMDs start.
Roth Conversion
What happens if they convert $10,000 from traditional IRA to Roth? We go to the non-paycheck income section and change cell D31 for “tIRA distribution” from $40,000 to $50,000.
Now we go back to the tax calculation area starting at cell F11. The estimated total federal income tax changes from $2,552 in the baseline to $4,997.
$4,997 – $2,552 = $2,445. This means they will pay additional $2,445 in federal income tax when they convert $10,000 to Roth. That’s 24.5% marginal tax rate (higher if the state also taxes the conversion). Due to the loss in health insurance subsidy, the Roth conversion is effectively taxed twice as high as otherwise.
Long-Term Capital Gains
What happens if instead of converting $10,000 to Roth they realize $10,000 in long-term capital gains? We go to the non-paycheck income section, change cell D31 for “tIRA distribution” back to $40,000, and we enter $10,000 in cell D27 for “Long-term capital gains (LTCG).”
Now we go back to the tax calculation area starting at cell F11. The estimated total federal income tax changes from $2,552 in the baseline to $3,858.
$3,858 – $2,552 = $1,306. This means they will pay additional $1,306 in federal income tax, or a 13% marginal tax rate when they realize $10,000 long-term capital gains. Long-term capital gains are normally taxed at 0% at their income level. The tax increase in this scenario comes 100% from qualifying for a lower ACA health insurance subsidy. The marginal tax rate is higher still if you add state income tax on the capital gains.
***
This exercise shows that converting to Roth or realizing long-term capital gains while receiving the health insurance subsidy from ACA will incur higher federal income tax than if you are not receiving the health insurance subsidy. The Personal Finance Toolbox spreadsheet does a good job in calculating the effect. It isn’t the easiest to use when you have to go all over the place to find the right spot for your inputs and look at the results. However, it works once you know where to enter things and what to look for. It includes the effect on ACA subsidy when tax calculators from major tax software vendors don’t. I thank its author for making this tool available.
Learn the Nuts and Bolts
I put everything I use to manage my money in a book. My Financial Toolbox guides you to a clear course of action.
Brian says
This looks interesting. I plan to download the spreadsheet and try it out.
What I’ve done so far is to use our 2017 tax program, saving last year’s tax filing to a file named “Estimated 2018 Taxes,” manually over-ridden the personal exemptions with $0 and manually over-ridden the standard deduction with $24,000 (since our itemized deductions are less than that).
Then, entering our known & projected 2018 income, we establish a baseline income/tax estimate and then tweak the numbers for various “what if” scenarios.
Through tax-efficiently withdrawing from our assets, we keep our MAGI low enough to qualify for subsidized Marketplace insurance, we’ve had to (carefully) keep up with these “what if” scenarios the past five years.
Looking forward to trying out that spreadsheet!
Harry Sit says
Come next year it will be easier to use the tax software after they update the software for the new law.
Kevin says
Thank you Harry for this article. I hope it will help many to be able to better project their tax implications early in their tax year so they don’t fall into the trap I did the first year the ACA went into effect.
I had two operations and my wife had one that year so my medical expenses hit the Max out of Pocket for that year $10,500. So I wanted to pay all my medical bills and so withdrew money from my IRA to do so. I withdrew enough to pay those costs, my health insurance costs and a little more.
One GRAVE mistake I made was assuming that since those moneys went towards medical expenses they were not taxable just as they did not incur the 10% early withdrawal tax from early distrubution from my IRA….WRONG! It was included in my MAGI and the extra I took out put me over the 400% of Federal Poverty Level Limitation for qualifying for the ACA credit and I had to pay back the $10,000 credit I had received. Had I known that taking that money out would have disqualified me for the credit and also known that by taking just a little less … OR… DEFERRED PAYING PART OF MY MEDICAL BILL until January of 2015 and thus shifting taking some of the money to a new tax year my extra tax bill would have gone up only $2500 instead of $10,000.
Unfortunately there were no tax programs that were prepared for the new ACA available until late that year. I used Turbo Tax in April of 2015 for my 2014 taxes and their software even missed that the IRA distributions should not have incurred the extra 10% penalty because my medical expenses were high enough. My 2015 tax preparer caught that in the first couple of minutes looking at my 2014 return and filed an amended return and got that money back for me. That was only the second time in more than 40 years I didn’t do my own taxes. The other involved a real estate sale and monthly contract.
In your first two scenarios above if they had taken or converted $25,000 they would have exceed the 400% by just $40 and been subject to repaying the ACA credit and their tax bill would have gone up to $23,729… an almost 50% tax!
One note the FPL changes every year and is published around November of the year before it changes and is based the year before the tax year it is published for. Harry does a good job of explaining that here: https://thefinancebuff.com/federal-poverty-levels-for-obamacare.html. That link did pop up as the number one listed in my sear for 2018 Federal Poverty Level. Some links don’t do as good a job explaining the FPL and can be a bit confusing for some.
Brian says
We have been cautious – probably over-cautious – so as not to exceed that 400% FPL threshold that you mention. We’ve purchased our health insurance through the Marketplace since its inception five years ago. We’ve been careful to tax-efficiently withdraw from our investments during this time – keeping a solid track on our MAGI the entire time.
When I read your narrative, about pulling money from your IRA to pay your medical bills, I knew exactly where you were headed. I thought, “Uh-oh. I’ll be he hit that 400% FPL limit!”
We were fortunate to have read a number of horror scenarios about this “cliff” as the ACA rolled out, and carefully set up our income and tax estimations every year to consider the various FPL thresholds.
Best of luck in keeping on top of this in future years.
Eric Gold says
Bottom line, the ACA credit is reduced as income increases.
I just call the effect an income tax. Even though it is not meant to be one, that is the effect for most taxpayers.
The tricky part is that a jump to a higher contribution rate tier is applied to the *entire* ACA AGI. Tiers are at 2x, 2.5x, and 3x of the household FPL. If you stay within the same contribution tier, any added income will incur at most 9.69% tax since that is the maximum contribution tier for eligible incomes.
It’s a bit of irony really, that people have misunderstood for years income tax brackets as applying to the entire income yet the ACA tax credit (reduction) does just that.
Brian says
Interestingly, if the initial MAGI estimate winds up being low (due for instance, to an income windfall late in the year), each FPL tier has a repayment limitation such that the entire amount of excess APTC may not need to be repaid. So, jumping to a higher contribution rate tier may not necessarily be a bad thing. In fact, it may net some positive income since the APTC repayment is limited. (But, stay away from the dreaded 400% FPL tier!) https://www.irs.gov/affordable-care-act/individuals-and-families/four-things-to-know-about-advance-payments-of-the-premium-tax-credit
Eric Gold says
I meant to add ..
This is the function for the ACA brackets:
=If(levelized>300,969,If(levelized>250,821+(levelized-250)*148/50,643+(levelized-200)*178/50))
The function returns a value that when divided by 10,000 gives the contribution percent to apply to ACA AGI.
Levelized has to be calculated separately as the household FPL * 100
Eric Gold says
Example for above:
We are a two person household in Colorado, so our
FPL = 12,060+4180 = $16,240.
If our ACA AGI was $40k, our household FPL ratio is 40000/16240 = 2.463
Levelized then would be 2.463*100 = 246.
The ACA brackets in our case are at:
16240*2 = $32,480
16240*2.5 = $40,600
16240*3.0 = $48,720
16240*4.0 = $64,960
CORRECTION TO ABOVE POST:
The contribution percentage is always applied to the entire ACA AGI; the point here is that each bracket has a slope of either 148/50 or 178/50. The brackets are regressive.
Bruce Wilson says
This calculator looks interesting.
I have been looking for a calculator to help decide Roth conversions, whether to do them, if i do them, a plan to make them.
The best relatively simple one i found was on Schwab’s website.
Any other you might suggest for Roth decisions without the ACA piece?
Brian says
Having just reviewed this calculator and plugged in my own information, it looks as if this calculator can help with the Roth conversion question that you’re looking for. (The narrative above walks you through all that.)
The ACA piece is only one cell (Cell G31) that it pulls from the Form 8962 calculation (starting at Cell AC87). Simply disregard the single ACA piece (Net PTC) and what’s left is the regular tax portion impacted by the Roth conversion that you’re interested in.
Harry Sit says
If you don’t need the ACA piece you have many choices. All 3 calculators linked at the top will be able to do it. You run it once without Roth conversion (or converting a smaller amount). You write down the bottom line number or print out the results. You run it again with Roth conversion (or converting a larger amount). You look at the bottom line number and see how much more you will pay.
KD says
Harry, Please correct me if I am wrong. In the Calculations Tab of the spreadsheet, cell U48 shows you the marginal tax rate on ordinary income and cell U49 shows you the marginal tax rate on LTCG/QD. I checked it out and it seems to match a sample calculation I did that included ACA PTC effects. The marginal rate shown there includes effect of both, federal and state income tax.
Harry Sit says
KD – You are right. It calculates the marginal tax rates by increasing the ordinary income and long-term capital gains by $100 respectively. I only showed federal income tax in this post. The numbers in U48 and U49 include both federal and state. The state income tax is estimated from the state entry in H35.
MDM says
All correct. I find the marginal rate graph more useful but those two cells work as described.
MDM says
Harry, great article! I’ll probably link to it in the ‘Instructions’ tab when uploading a new version.
This spreadsheet started as a simple tool to help people organize their case study numbers for the mrmoneymustache forum, and has indeed grown over the years.
Updates are published in https://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/. That’s also a good place (or PMing via the MMM forum) for people to report bugs, suggest enhancements, etc.
I also read the Bogleheads forum, and am happy to see it used there under the “personal finance toolbox” moniker.
In Excel (other programs don’t seem to work as well), the chart near cell J106 can show the various marginal rates in picture form.
Thanks again for the great write-up,
MDM
Harry Sit says
Thank you for the hard work in putting this together. It sounds like “Personal Finance Toolbox” isn’t the official name. Should it be called the “Case Study Spreadsheet” instead?
MDM says
Good question. 🙂
Case Study Spreadsheet is the original name, and fit the original purpose. Because its scope has increased over time, calling it Personal Finance Toolbox is not unreasonable.
Whatever one calls it, if it proves useful to people then I’m happy.
FinancialDave says
Harry,
I used this spreadsheet extensively (though not the ACA part) a few months back to understand the marginal rates as they apply to the decision on whether it makes sense to do Roth conversions, or contributions vs putting the money in traditional, when child tax credits and the “Savers credit” comes into the picture. The answer is much the same — you need to be careful when you are in these very nonlinear areas of the tax codes because you can easily make the wrong decision.
Charlie says
I just started playing around with this spreadsheet. A seemingly important data value is the SLCSP, which they don’t tell you until you receive your 1095 form in January. This is our first year in ACA, so the only thing I found was a tool on healthcare.gov to estimate the SLCSP for 2017 and a couple previous years. The amount calculated ($1,171) seems a little bit low to me as our 2018 bronze plan premium is over $1,400/month before APTC. If the SLCSP is wrong’, doesn’t that pretty much mess up this analysis?
Much of what I’ve previously read suggests to do as much Roth conversions as possible (of course without going over the subsidy cliff!) during the years before turning 70. Is that strategy not as desirable now because of the tax analysis contained in this spreadsheet??
Also, if you’ve already done some Roth conversion, it appears they can’t be undone in 2018 and future. So you really have to be careful and thoughtful in strategizing!
Thanks for this spreadsheet and all the great discussion!
Harry Sit says
The healthcare exchange usually lets you shop before you apply. You can see the prices of all Silver plans offered in your area. Put in an income above 400% FPL when you shop. Then use second lowest price for your calculation.
The equivalent additional tax from reducing your premium tax credit makes Roth conversion not as appealing than otherwise but that marginal tax rate may still be lower than the marginal tax rate you face after 70-1/2. You have to do the math and make some guesses. It’s not as clear cut as when you don’t need ACA premium tax credit.
Brian says
Each year during enrollment, after entering all the information they ask for, I snapshot and save all the relevant information for all the Bronze, Silver, and Gold plans. That way I’ve also saved the SLCSP and don’t have to wait until January for the 1095 Form. (I learned my lesson the very first year, in 2014, to archive as much as possible, just in case there’s a discrepancy.)
For us, the SLCSP estimator tool has almost always been wrong. (And the 1095 Form always matched the estimator tool.) But I always provided what I knew to be the correct SLCSP $ amount when I filed my tax return. Twice the IRS asked me for additional information regarding the SLCSP amount that I had filed. Twice they accepted my screen snapshot of that SLCSP for evidence.
You do have an alternative. If you go to https://www.healthcare.gov/see-plans/#/ and then click on (where it indicates in fine print) “Looking for 2018 Plans and Prices?” – you can re-enter your 2018 family/income information and then take a look at the 2018 SLCSP. When I try this method, it’s off by only 8 cents from the amount in the screen snapshot I had taken during enrollment.
Regarding Roth conversions, what I have concluded – feel free to correct me if I have this wrong – is that if I do a Roth conversion while receiving an ACA subsidy, given that my MAGI is so low now and the Roth conversions increases the MAGI, I then have to repay so much of the APTC subsidy to the IRS (even well before the “cliff”) that it doesn’t make the conversion financially worthwhile. Typically you would do a Roth conversion, being careful to remain in your tax bracket. But, the APTC subsidy payback is so much harsher, occurring before the tax bracket movement starts (unless you happen to hit one of the repayment limitation thresholds, then limiting how much of the subsidy you have to pay back). In any case, be cautious on this point. (Instead of using that spreadsheet for this Roth conversion estimation, I used my tax program from last year and simply entered multiple hypothetical Roth conversions in increments of $1K, and then charted into an Excel spreadsheet the resultant tax liabilities for each increment. Gives a close enough estimate.)
Best of luck for you on this topic.
(We’ve been on Exchange ACA Silver HMO insurance since it started in 2014. Next year we move briefly to an HDHP w/HSA and then on to Medicare & all the issues related to that.)
Charlie says
Harry and Brian, thank you for that very valuable SLCSP methodology! As I mentioned above, the online tool gave me a result of $1,171. When I went back into 2018 plans for our ages/location, the SLCSP was actually $1,786, over $600 higher. That changes the game around for sure and I’ll play with the spreadsheet some more and also try out last years TTax program with overrides.
The screenshot suggestion is excellent as well. The fact the IRS questioned your number vs. Form 1095 and accepted yours is very useful info.
Many thanks!
Eric Gold says
I use my local state marketplace but I imagine that other states and the federal are similar: I set my tax credit monthly use to zero and can then see the actual premium cost of the plans. This lets me identify my SLCSP and choose a bronze plan that leaves enough tax credit for dental.
By the way, note Harry’s choice of a plan with HSA eligibility.
Charlie says
Interestingly, the 1095 I just received for 2018 nailed the SCLSP amount to the penny! That was a nice surprise and it will be a pleasure to not have the IRS ask about any discrepancies.
The spreadsheet was most helpful in doing sensitivity analysis before end of year. I purchased TurboTax in December to help. I was comparing the results between the two and they tracked very nicely.
Like Harry, we chose an HSA compatible plan which allowed for up to $7,900 contribution for 2018 (can be made up through April 15th, 2019). The HSA contributions are both tax deductible and reduce MAGI for ACA purposes.
Chris says
Brian, yesterday I called the marketplace helpline at healthcare.gov to try to get my 2020 SLCSP. The agent I spoke to had no idea what I was talking about and I had to explain what SLCSP is to her about 5 times before she told me she had no way to obtain that information. I asked for a supervisor, who did know what SLCSP is but told me I just had to wait for the 1095 form in January. Luckily, I subsequently reviewed the comments here and used your link. Maybe you could offer some training over there?
Kevin says
I have a question I hope someone can answer. When I looked at my 2017 tax return form 1095 lists SLCSP as $1,366.31 yet there was only one option for a silver plan for my county and that premium was $1,596.26. A difference of $229.85 per month or over $2500 per year! For 2018 and 2019 I still only have one silver plan available.
If I have only one silver plan available why isn’t the SLCSP the same as my premium for my silver plan?
That year they also made a mistake in my 1095 form and forgot I had a spouse and to include her part of the premium. My accountant didn’t even catch it and I had to apply for a new form 1095 before I could have my taxes done.
Chris says
Is it too late to comment on this article? I just realized I screwed up and did too large of a Roth conversion. I did just under $50,000 because I had very little income in 2019 and am head of household with 1 child. I was expecting to get taxed at the 12% rate. Instead I owe $9,987 in federal tax. Putting different numbers in my tax program, if I had only done $47,000, it goes down to $5,197 and if I did $30,000, it would only be $2,012. I don’t suppose there are any programs in this covid-19 time that would allow me to change my conversion amount or do anything else to lower this tax bill?
David Folts says
If you need to bring your MAGI down $3,000, have you considered buying and then selling a stock for a $3,000 capital loss? Given the volatility in the market, perhaps this is an option to consider.
Bruce Wilson says
Chris, I am not an expert, but I do not believe you can undo the Roth conversion.
Up until a year or so ago you could, but the Secure Act changed that because some people were abusing the system.
The only thing I can think of to possibly lower your taxable income would be to do a Traditional IRA contribution for 2019. You can only contribute IF you have earned income like from a job. It would be the box 1 number on your W-2. The max you can contribute would be $6,000 if you are under 50 years old. You could contribute $7,000 if over 50 years old. If your box 1 number is say $4000 that would be the max you could contribute, regardless of age. Whatever amount you contribute would lower your taxable income by that amount. If you do this make sure you are contributing for the 2019 year.
Hao says
Hi Harry,
Thank you for your helpful articles regarding ACA health insurance & tax optimization. I am researching for the future and your articles help me understand bit by bit the complicated process. I greatly appreciate your scenarios and conclusion, “… converting to Roth or realizing long-term capital gains while receiving the health insurance subsidy from ACA will incur higher federal income tax than if you are not receiving the health insurance subsidy”. Your article helps improve tax planning.