Thanks MDM.
In row 2 and 3 column B I entered my gross income... then entered the pretax expense for medical/dental/etc below, however, it is adding to to the total in row 10 B rather than subtracting from. Should row 2 and 3 column B be net?
B2 and B3 should be monthly gross.
All entries (except where specifically indicated otherwise: e.g., B28 and B29) should be positive numbers.
If you use the inputs shown here (B2: =101000/12; B3: =14000/12), do you get the same results in row 10?
Ok - It worked the second time around.
What a great tool... not to mention I am ok with the outcomes. Our goal is to be done when our kids go away to school in 17 years, modeling those dates provided we will have an excess of 892,000 and we could hit in 10 years! Motivating!
So how about investment order?
Right now I put 7% in 401k (No match but they put 8% in a cash pension that grows at 30 year treasury rate... so very low return of 2.5-3.5%), I put 400/month in Roth (200 each), and I have not been frugal with the rest (lots of big vacations, dinners, etc.) recently but it's time to adjust the mindset.
As someone has stated earlier... I am not taking the full benefit and paying much more tax than needed.
My thought moving forward:
1. I did not participate in my company HSA ... Mistake and I will next year.
2. 18% Margin rate - I will max out my Roth 2nd
3. 80% remaining available in 401k? This will allow me to utilize the roth ladder for the gap years until 62.
4. 20% in cash (taxable) mutual funds.
Thoughts?