Join Early Retirement Today
Reply
 
Thread Tools Display Modes
DON'T Forget Taxes and Healthcare in Projected Spending!
Old 05-20-2019, 01:35 PM   #1
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
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.
Attached Images
File Type: jpg Budg.jpg (50.8 KB, 84 views)
__________________
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)
Midpack is online now   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 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!

Old 05-20-2019, 01:42 PM   #2
Moderator
sengsational's Avatar
 
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.
sengsational is online now   Reply With Quote
Old 05-20-2019, 01:57 PM   #3
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Big_Hitter's Avatar
 
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...
Big_Hitter is offline   Reply With Quote
Old 05-20-2019, 02:08 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
RunningBum's Avatar
 
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.
RunningBum is offline   Reply With Quote
Old 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 $$$.
tb001 is offline   Reply With Quote
Old 05-20-2019, 03:41 PM   #6
Moderator Emeritus
W2R's Avatar
 
Join Date: Jan 2007
Location: New Orleans
Posts: 47,468
Quote:
Originally Posted by tb001 View Post
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....
W2R is offline   Reply With Quote
Old 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.
24601NoMore is offline   Reply With Quote
Old 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!"
scrabbler1 is online now   Reply With Quote
Old 05-20-2019, 04:02 PM   #9
Full time employment: Posting here.
Vincenzo Corleone's Avatar
 
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
Vincenzo Corleone is offline   Reply With Quote
Old 05-20-2019, 04:07 PM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
street's Avatar
 
Join Date: Nov 2016
Posts: 9,373
Quote:
Originally Posted by Midpack View Post
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?
street is online now   Reply With Quote
Old 05-20-2019, 04:08 PM   #11
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 50,000
Quote:
Originally Posted by street View Post
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
REWahoo is offline   Reply With Quote
Old 05-20-2019, 04:11 PM   #12
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
street's Avatar
 
Join Date: Nov 2016
Posts: 9,373
Quote:
Originally Posted by REWahoo View Post
Right. One way to include it is simply consider it as another expense item in your annual spend.
Gotcha
street is online now   Reply With Quote
Old 05-20-2019, 06:34 PM   #13
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Midpack's Avatar
 
Join Date: Jan 2008
Location: NC
Posts: 21,150
Quote:
Originally Posted by 24601NoMore View Post
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)
Midpack is online now   Reply With Quote
Old 05-21-2019, 07:32 AM   #14
Moderator
sengsational's Avatar
 
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.
sengsational is online now   Reply With Quote
Old 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.
tb001 is offline   Reply With Quote
Old 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.
StuckinCT is offline   Reply With Quote
Old 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 View Post
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
kgtest is offline   Reply With Quote
Old 05-21-2019, 08:16 AM   #18
Moderator
sengsational's Avatar
 
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.
sengsational is online now   Reply With Quote
Old 05-21-2019, 12:11 PM   #19
Full time employment: Posting here.
Offgrid Organic Farmer's Avatar
 
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].
Offgrid Organic Farmer is offline   Reply With Quote
Old 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.
Bir48die is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
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
PSA - don't forget to set the clock back MichaelB Other topics 7 11-04-2014 09:58 AM
2009 spending versus 2008 and projected budgets audreyh1 FIRE and Money 40 10-30-2009 08:18 AM
ER Consumption (Projected Spending Habits) chinaco Life after FIRE 15 04-09-2007 11:47 AM
Don't forget to spend it. setab Life after FIRE 18 12-26-2006 10:37 PM
Don't forget to claim your part of the $10,000,000,000 refund mickeyd FIRE and Money 1 12-26-2006 12:58 PM

» Quick Links

 
All times are GMT -6. The time now is 08:03 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.