PilotWombat

Obviously, there has been a lot of hullabaloo going on around here with regards to the MBCBP and just what exactly it means for your retirement. Specifically, which was better...saving on taxes now and getting a lower return, or taking the hit on taxes and getting a potentially better return over the long run. Well, I wanted to see what the actual numbers were, so I put together a spreadsheet to compare them.

I am making no guarantees on the accuracy of the calculations, and I am certainly not going to say this will apply to your own specific situation. However, I think I did the calculations right, and I think it provides a good primer on what the MBCBP offers versus just taking the money and investing it on your own.

I will make updates to the calculations and features as the days and weeks go on, so keep checking back for the most current version. If you find something glaringly wrong, please PM me and I'll look into it.

https://www.dropbox.com/s/34pll180is...v1.0.xlsx?dl=0
Instructions:
- Click the link and click "No thanks, continue to view"
- This is a read only copy, so to make your own calculations, download the file on the top right via "Direct download". You may have to click "No thanks, continue to download" again.
- Once saved, open and click "Enable Editing".
- Change the yellow boxed items as desired to fit your own situation and assumptions.

tennisguru

You sir are brilliant.

EDVPLT

I have a few questions cause I am trying to understand what this MBCBP is and just 401(k) at Delta.

1) I understand as of now there is a 16% DC. In addition to the DC, is there a company match on a % I put in as well? I thought I saw this on APC or something where they also match 100% of 6%.

2) I will have close to a 40 year career at Delta and when I do this tool it shows I would be getting about $40,000 more a year without the MBCBP. Is there some spark notes on this MBCBP or a good link/article that explains exactly what this is so I can get a better understanding.

Thanks!

Iceberg

16% DC only, there is no match.

You’re probably not wrong on your look at the MBCBP. It’s more of a short time insurance, long term hindrance type of program. <-My opinion only, of course.

interceptorpilo

The fact that the OP has the withdrawal rate of MMIC at 4% and the annuity from the “other plan” at 6% makes me think there is definitely a hidden agenda on the OP’s part. At least it appears that way. Since the other plan is not inheritable then a fair comparison would be to give a reasonable return on the money say 8% for MMIC and draw it down to zero at some age say 85. I think that comparison would show the MMIC wildly better for almost everybody.

Denny Crane

I assume you mean the MBCBP is the "other plan?" If so, you are wrong, it is inheritable. Now if an annuity is purchased with it all bets are off but the plan itself is inheritable.

Denny

iaflyer

What's an "MMIC"?

Also, you know that everyone can change the numbers in seconds and it recalculates... It's not like we need to get a new piece of paper out and figure it all out again.

DWC CAP10 USAF

MMIC = My Money I’m in Charge

interceptorpilo

ok Denny

thank you for that information. Yes I mean the MBCBP. That is a lot of letters! Where is it written down it is inheritable? Is it to spouse only? Young children? Even so then the horizon of the MY MONEY should be until the actuarial age of your spouse. There are so many assumptions made for the my money comparison that are negative that it is clear where the OP’s thought process is.

PilotWombat

No black helicopters here. I explained my defaults in another post, which I'll quote here:

My main goal is give people accurate information. If I have any agenda, it's to counter the very vocal people on this forum that are saying "MMIC" is the only and best way, and the MBCBP is worthless. It is not worthless and provides a lot of value to a lot of people. Maybe taking that money cash will work better for you, though. As with most investments, it is mostly dependent on your time horizon.