Downloadable Excel Spreadsheet

The spreadsheet attached to this website is designed to give you a picture of your personal Tax Hump. It consists of four tabs:

  1. The [Marginal] tab accepts your personal tax related input and calculates your taxes with and without including your optional "What If" data. We will discuss this tab in great detail shortly.
  2. The [Brackets] tab captures the Married TRUE/FALSE information from the Marginal tab, then copies the appropriate tax bracket information from the bottom of the page to the top where it will then be used for all of the tax calculations.
  3. The [Graph] tab uses 1,000 data points to create a graph of your personal Tax Hump.
  4. The [Graph2] tab creates a parallel personal Tax Hump including your What If data.

Downloading

Before I give you the link to my Parallel Taxes Excel Spreadsheet, read the following instructions so you can properly save it to your hard drive.

Your browser does not properly emulate Excel, so the graph that is displayed on the google drive page will probably have a few extra strange lines in it. Just ignore the extra lines for now and do the following after you follow the link!

Hit the down arrow in the upper right corner of the page to download the file to your computer.

Then open the file with Excel, if you have it:

It will open read only, so hit the [Enable Editing] button before you save the file to your disk.

OK, here is the link to download the spreadsheet, ParallelTaxes.xlsx, from my google drive. As I understand it, everything on google drive is auto scanned for viruses, but use it at your own risk!

https://drive.google.com/open?id=1k_3sVyEoyD6l7qv_B7GeRgyoSrgLaUqp

This is what you get!

You enter your personal information in the yellow frames at the top left of the Marginal tab.

The Extra Income frames below your input will detect the increase in your taxes from the Tax Calculator, compare it to the amount of extra income you are looking at in the What If column and calculate your Federal Marginal Tax Rate and your total marginal rate including your personal state and local tax rates.

The To LTCG and To Hump let you know how much additional income you can afford before entering your personal tax hump. This information is supplied for both your now and What If situations. Red numbers are negative and let you know how far your income is into the hump, how much you have to cut back to avoid the hump!

You are also given the information on how much of your Tax Delayed Social Security has been taxed and how much is still tax free income!

It is important to note that the To Hump and To LTCG numbers represent the available increase in "Taxable Income". Just remember that while you are in the 85% taxability bracket for your Social Security Benefits, each additional dollar of actual income increases your taxable income by $1.85. The amount of additional income / IRA or 401k withdrawals is the second number in each case, the at 85% number!

A picture is worth a thousand words!

But in this case it could be worth thousands of dollars!

The extra income frames indicated that the extra $5,000 would cost $2,130 in extra Federal taxes. If this extra cash had been withdrawn or converted before retirement at the 22% Federal tax bracket, the Federal tax would have only been $1,100, a $1,030 savings if you were aware of the future interaction of your desired standard of living and your personal tax hump.

Your Tax Hump did not change in this example because the What If data only included $5,000 of extra taxable income, so the solid purple marginal bracket line is directly over the solid red line. The dotted red line illustrates your Federal Tax Brackets while the dotted green line illustrates the 50% and 85% parallel taxation of your Social Security benefits for the combined Spouse and You data.

The important data is represented by the tic marks. The solid green tick mark illustrates the gross income data that you entered in the Spouse and You columns. Note its relationship to the solid red marginal tax line, you are very close to you personal Tax Hump. Also note the distance between the solid green gross income tick and the solid blue After Fed Tax tick.

What If your situation at the end of the tax year was a little different?

You enjoyed a comfortable year on a $59,000 gross income, paying only $2,738 in Federal taxes.

Looking at your solid green tick mark, and the To LTCG (at 85%) data, you can take additional taxable income out of your IRA at the 22.2% marginal tax rate this year which could help you to avoid the 40.7% marginal tax hump next year!

The spreadsheet says that you can take about $5,500 out of your IRA, but you decide to play it safe and take out only $5,000 and the spreadsheet indicates that you will only pay 22.2% in Federal taxes.

If you take the extra $5,000 out of your IRA in December, you could take that much less out in January! Next year, if all goes as normal, you would be able to do the same for an extra $10,000, or, if an unexpected expense happened during that year, you could have covered it without paying any of your huge Hump Taxes!

As with everything else on this website, verify your estimated taxes with and without the extra income from other sources.

Federal Tax Brackets

The [Brackets] tab of the spreadsheet is used to create the proper tax brackets, deductions, and long term gain tax levels.

The two tax data tables at the top of the page are created by your input on two entries just below the tax data tables.

As indicated, the Married True/False value is copied from cell H3 on the [Marginal] tab which is defined by if you have entered any non-zero dollar amounts in the spouse column at the top left of the [Marginal] tab.

You can enter 2018 or 2019 in the selected year cell, but the safest way to do this is to click on the cell, a small down arrow will appear next to the cell, click on the down arrow, then select a valid year from the drop down list.


Variable HTML website, maintained with MySSI
Copyright © 2012, BitWare Solutions