|
DON'T Forget Taxes and Healthcare in Projected Spending!
05-20-2019, 01:35 PM
|
#1
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2008
Location: NC
Posts: 21,150
|
DON'T Forget Taxes and Healthcare in Projected Spending!
Sometimes I see (very) early retirees who share their projected spending without accounting for healthcare expenses. I also see folks here sometimes ask if FIRECALC accounts for taxes for you - it does NOT. In my experience, both expenses must be seriously considered when you figure out your projected spending in retirement.
__________________
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57
Target AA: 50% equity funds / 45% bonds / 5% cash
Target WR: Approx 1.5% Approx 20% SI (secure income, SS only)
|
|
|
|
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 Early-Retirement.org 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!
|
05-20-2019, 01:42 PM
|
#2
|
Moderator
Join Date: Oct 2010
Posts: 10,626
|
Most spending categories can be just eyeballed and smoothed across the entire plan based on historical values. But for both taxes and healthcare, it seems to me, need to be customized based on situation and age, and historical values are very much less useful.
I wonder if these things get left out because they're harder to model.
|
|
|
05-20-2019, 01:57 PM
|
#3
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: May 2013
Location: Les Bois
Posts: 5,761
|
agree both need to be modeled
taxes can change drastically in retirement - I'm planning to live off taxable investments (plus our pensions, rentals, interest and dividends) for the next several years so my taxable income will be about 25% of what it was in 2018, maybe lower.
For health costs, I assumed the max out of pocket for a bronze plan for myself and a MAPD plan for DW. Not that difficult to model.
__________________
You can't be a retirement plan actuary without a retirement plan, otherwise you lose all credibility...
|
|
|
05-20-2019, 02:08 PM
|
#4
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2007
Posts: 13,184
|
I used to only budget health insurance costs for medical. Between health issues as I've gotten older, bad luck, and higher deductibles, I figure premiums+deductible, if not Max OOP, and it's a bonus if I come under.
My fed taxes are minimal but the state keeps taking.
|
|
|
05-20-2019, 02:29 PM
|
#5
|
Thinks s/he gets paid by the post
Join Date: Sep 2017
Posts: 1,110
|
Yes! The piece I left out when initially working through expenses was layering in deductibles and the out of pocket $ after medicare kicks in. Dental is another chunk that goes into healthcare and can end up being $$$.
|
|
|
05-20-2019, 03:41 PM
|
#6
|
Moderator Emeritus
Join Date: Jan 2007
Location: New Orleans
Posts: 47,468
|
Quote:
Originally Posted by tb001
Dental is another chunk that goes into healthcare and can end up being $$$.
|
+1
Dental was the one I completely forgot, plus I didn't realize how much higher dental expenses would be at age 65 compared with age 45. Luckily I had enough of a "fudge factor" to cover these expenses.
Originally I thought that fudge factor could end up being used to partly cover (potential) massive inflation, but instead it is sending my dentist's kids to college....
|
|
|
05-20-2019, 03:46 PM
|
#7
|
Thinks s/he gets paid by the post
Join Date: Dec 2015
Posts: 1,155
|
AMEN! HC is likely to be the largest single line-item expense that any of us will incur. Even IF you can manage income for ACA subsidy purposes TODAY, there is no guarantee that benefit will remain going forward, and the cost of non-subsidized (by ACA or corporate benefits) HC is MASSIVE depending on your age and where you live.
I'm budgeting $25K per year ($15K+ annual premiums for the two of us, with $5K+/pp deductibles and co-poays) with a 5% annual bump for HC between now and Medicare, and even that is probably less than we will need.
HC is easily our biggest ER expense, and that REALLY sucks.
ETA - also highly recommend estimating Federal, State and any other taxes and keeping current on payments quarterly. I've never been good at this, and it's bit me every single year at tax time with penalties for under-payment or late payments. I resolved to do "better" this year and so far...not doing a whole lot better at it. But at least I estimated what my 2019 tax liabilities will be..now I just need to figure out how and when to pay what I need every quarter and all will be good..err...better.
|
|
|
05-20-2019, 03:59 PM
|
#8
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2009
Posts: 6,679
|
I split my income taxes into two parts. The first is a "basic" part, based on the monthly and quarterly taxable dividends I receive to pay my expenses. That is part of my budget. The second part is an "excess" layer, the part generated by the more volatile and unpredictable cap gain distributions. There, I am not worried about additional income taxes because the additional distributions themselves can be used to pay the additional taxes.
HI is part of my medium-term budget and I have assigned its own inflation rate to it (10%, to all medical expenses) which is higher than the rest of my budget.
__________________
Retired in late 2008 at age 45. Cashed in company stock, bought a lot of shares in a big bond fund and am living nicely off its dividends. IRA, SS, and a pension await me at age 60 and later. No kids, no debts.
"I want my money working for me instead of me working for my money!"
|
|
|
05-20-2019, 04:02 PM
|
#9
|
Full time employment: Posting here.
Join Date: Jul 2005
Posts: 614
|
Taxes were somewhat of a grey area for me up until recently. My spreadsheet contains cells for $ withdrawal (based upon a withdrawal % chosen from a drop-down), $ total income (to account for pension and social security (if chosen to include those items, again from a drop-down) and federal taxes (state/local taxes are my next project). I created an Excel VBA function to calculate federal taxes based on the withdrawal (from investments) and regular income (i.e., pension/ss). [Edit begin] I then put the calculated tax in the main spreadsheet, calculate fixed expenses based on this tax amount (i.e., fixed expenses known beforehand + taxes), and any discretionary money left over (total income - fixed expenses).[Edit end] If anyone finds it helpful, I include the code below. It's not perfect, as it assumes all of the investment withdrawal are either qualified dividends and/or long-term capital gains from taxable accounts. But it brings me close. I'm sure it can be easily modified to calculate taxes on withdrawals from tax sheltered accounts. I just figured, I can probably draw from taxable accounts until RMDs, at which time DW and I will be collecting social security. The function also assumes you're filing married filing jointly, but again, that's just a matter of changing the values in the tax reference sheet. Finally, the function assumes you're taking the standard deduction as a married couple filing jointly.
The calculation of tax uses another sheet that I use as reference with tax brackets. Basically:
Income Floor (In my spreadsheet, column E)
Income Ceiling (In my spreadsheet, column F)
Bracket Amt (ceiling - floor) (In my spreadsheet, column G)
Regular income tax rate (In my spreadsheet, column H)
Short-term capital gains rate (In my spreadsheet, column I)
Long-term capital gains rate (In my spreadsheet, column J)
Here is the VBA function with comments. I hope someone finds it useful. If you find problems with it, I'd appreciate it if you let me/us know.
Code:
' Takes withdrawal amount and total income amount as params
Private Function CalcTaxes(cWithdrawal As Currency, cTotalIncome As Currency) As Currency
Dim cRegularIncome As Currency
Dim cInvestmentIncome As Currency
Dim taxBracketCell As Range
Dim cBracketAmtTot As Currency
Dim cTaxAmt As Currency
Dim nTaxBracketRow As Integer
Dim cStandardDeduction As Currency
' Add fixed property tax, which is contained in a reference sheet
cTaxAmt = Sheet7.Range("PROPERTY_TAX").Value
' Get regular income and apply standard deduction contained in a reference sheet
cRegularIncome = cTotalIncome - cWithdrawal
cStandardDeduction = MaxVal(Sheet7.Range("STANDARD_DEDUCTION") - cRegularIncome, 0)
cRegularIncome = MaxVal(cRegularIncome - Sheet7.Range("STANDARD_DEDUCTION"), 0)
' Calculate tax on regular income
cBracketAmtTot = 0
nTaxBracketRow = 2
' Iterate through the tax bracket sheet. Column G corresponds to Bracket Amt
For Each taxBracketCell In Sheet6.Range("G3:G11")
If cRegularIncome < cBracketAmtTot Then Exit For
nTaxBracketRow = taxBracketCell.Cells.Row
cTaxAmt = cTaxAmt + (MinVal(cRegularIncome - cBracketAmtTot, taxBracketCell.Value) * Sheet6.Range("H" & nTaxBracketRow))
cBracketAmtTot = cBracketAmtTot + taxBracketCell.Value
Next taxBracketCell
' Apply any remaining standard deduction to investment income
cInvestmentIncome = cWithdrawal - cStandardDeduction
' Calculate tax on investment income
If cRegularIncome < cBracketAmtTot Then
cTaxAmt = cTaxAmt + (MinVal(cBracketAmtTot - cRegularIncome, cInvestmentIncome) * Sheet6.Range("J" & nTaxBracketRow))
End If
nTaxBracketRow = nTaxBracketRow + 1
' Iterate through the tax bracket sheet. Column G corresponds to Bracket Amt
For Each taxBracketCell In Sheet6.Range("G" & nTaxBracketRow & ":G11")
If cRegularIncome + cInvestmentIncome < cBracketAmtTot Then Exit For
cTaxAmt = cTaxAmt + (MinVal(cRegularIncome + cInvestmentIncome - cBracketAmtTot, taxBracketCell.Value) * Sheet6.Range("J" & taxBracketCell.Cells.Row))
cBracketAmtTot = cBracketAmtTot + taxBracketCell.Value
Next taxBracketCell
' Return calculated tax
CalcTaxes = cTaxAmt
End Function
|
|
|
05-20-2019, 04:07 PM
|
#10
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2016
Posts: 9,373
|
Quote:
Originally Posted by Midpack
Sometimes I see (very) early retirees who share their projected spending without accounting for healthcare expenses. I also see folks here sometimes ask if FIRECALC accounts for taxes for you - it does NOT. In my experience, both expenses must be seriously considered when you figure out your projected spending in retirement.
|
So, in using FIRECalc there is no place to plug in tax percentage, right?
|
|
|
05-20-2019, 04:08 PM
|
#11
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 50,000
|
Quote:
Originally Posted by street
So, in using FIRECalc there is no place to plug in tax percentage, right?
|
Right. One way to include it is simply consider it as another expense item in your annual spend.
__________________
Numbers is hard
|
|
|
05-20-2019, 04:11 PM
|
#12
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2016
Posts: 9,373
|
Quote:
Originally Posted by REWahoo
Right. One way to include it is simply consider it as another expense item in your annual spend.
|
Gotcha
|
|
|
05-20-2019, 06:34 PM
|
#13
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2008
Location: NC
Posts: 21,150
|
Quote:
Originally Posted by 24601NoMore
ETA - also highly recommend estimating Federal, State and any other taxes and keeping current on payments quarterly. I've never been good at this, and it's bit me every single year at tax time with penalties for under-payment or late payments. I resolved to do "better" this year and so far...not doing a whole lot better at it. But at least I estimated what my 2019 tax liabilities will be..now I just need to figure out how and when to pay what I need every quarter and all will be good..err...better.
|
I have 4 reminders on my iPhone/iPad each two weeks before estimated taxes are due, or I’d never remember. I wrote a spreadsheet to enter dividends, cap gains, etc. that calculates federal and state estimated taxes for me. You can also use Turbo Tax to do it, though the spreadsheet is clearer to me for projecting future quarters.
I shoot to pay 95% of estimated taxes, I want to owe without having a penalty, like most I assume.
__________________
No one agrees with other people's opinions; they merely agree with their own opinions -- expressed by somebody else. Sydney Tremayne
Retired Jun 2011 at age 57
Target AA: 50% equity funds / 45% bonds / 5% cash
Target WR: Approx 1.5% Approx 20% SI (secure income, SS only)
|
|
|
05-21-2019, 07:32 AM
|
#14
|
Moderator
Join Date: Oct 2010
Posts: 10,626
|
The act of paying taxes seems like an easier problem as compared to modeling taxes over the entire plan duration. A few of us don't bother with quarterly and just dial-in the withholding from tIRA/401k pulls.
It's interesting that people model premiums and max out of pocket every year. That's conservative, but for us, unrealistic. I guess if your plan survives that level of health care spending, you're in good shape.
|
|
|
05-21-2019, 07:48 AM
|
#15
|
Thinks s/he gets paid by the post
Join Date: Sep 2017
Posts: 1,110
|
Sensational, not sure if you were referring to me. I don’t actually model this to any level of detail—I just have a generous healthcare plug that increases over time. I did take the time at one point to price plans in 5 year increments (e.g. cost of plan for DH and I at 50, 55, 60, 65) to get a feel for how it increases with age to make sure my plug was reasonable. At some point I realized our out of pocket/deductible spend was large enough to warrant a line item in our annual budget, so increased the healthcare plug again.
It’s one of our largest costs, so I definitely want to make sure I’m not wildly off. I’ve ended up increasing the plug by about 30% as I better understood what goes into it and baked in additional conservatism.
|
|
|
05-21-2019, 07:50 AM
|
#16
|
Recycles dryer sheets
Join Date: Oct 2015
Location: Fairfield
Posts: 206
|
Good points. I would also model healthcare expenses without ACA subsidies now that it has been ruled unconstitutional by a federal judge, and given the composition of the supreme court.
|
|
|
05-21-2019, 07:58 AM
|
#17
|
Thinks s/he gets paid by the post
Join Date: Aug 2013
Location: North
Posts: 4,023
|
Quote:
Originally Posted by Midpack
Sometimes I see (very) early retirees who share their projected spending without accounting for healthcare expenses. I also see folks here sometimes ask if FIRECALC accounts for taxes for you - it does NOT. In my experience, both expenses must be seriously considered when you figure out your projected spending in retirement.
|
Good point Midpack! Soo, the one and only FA I have met with was an EJ rep out on Maui when I was working there. I had some time on my hands and decided to humor myself. I was so prepared when I walked in, he said he couldn't court me into EJ...as I knew enough to DIY.
But I asked, what should I be worried about that I'm not thinking about. He said the X factor to Early Retirement (and the reason so many ER hopefuls fail) is because of health and healthcare costs. He said those with high healthcare costs fail more often than others.
For us, I figure I am budgeting based on today's expenses *including 21k a year for our mortgage and 20k for daycare expenses. I figure that 41k of expense I am paying during accumulation will just be substituted for Health Care costs when I switch to ER. IF healthcare is more than $41,000 a year in 13 years, I will likely need to OMY it lol.
__________________
Time > $$$ ~ 100% equities ~ FIRE @2031
|
|
|
05-21-2019, 08:16 AM
|
#18
|
Moderator
Join Date: Oct 2010
Posts: 10,626
|
TB, not specifically you, as the theme is a common one. I'm grateful that, right now at least, PTC pays the premiums and we rarely use HC service, so the actual expenses for us have been near zero for HC, and i-orp manages the taxes (optimizes after tax spend).
I probably should do what you have done and put in an increasing plug, but I really have never planned at that level... it's always just been total available to spend was sufficient, but not what items the spending would be on. Maybe I'll build a new sheet.
|
|
|
05-21-2019, 12:11 PM
|
#19
|
Full time employment: Posting here.
Join Date: Feb 2018
Location: An Un-Organized Township of Maine
Posts: 801
|
I am on a military pension. My pension puts us just barely below the threshold for paying income taxes.
We do pay income taxes on our investment income.
__________________
Retired at 42 and I have been enjoying retirement for 18 years [so far].
|
|
|
05-21-2019, 01:06 PM
|
#20
|
Thinks s/he gets paid by the post
Join Date: Jul 2015
Location: Beaverton
Posts: 1,382
|
Always had all of this in my spreadsheets prior to retiring. I have reviewed and actual to estimated expenses have been within 5%. I didn't want to be surprised by anything short of a catastrophe
__________________
Jump in, the water's warm.
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|