Gregory Taketa | Gregarious Consulting

Home » Financial Planning » Income Tax Bracket Calculator for MS Excel

Income Tax Bracket Calculator for MS Excel

Gregory Taketa

Gregory Taketa

Gregory Taketa is the Data Decanter, serving refined, well-breathed data analysis while keeping out the sediments.

View Full Profile →

Enter your email address to follow this blog and receive notifications of new posts by email.

Archives

Download XSLX (MS Excel 2010+)

Although internet applications already provide your estimated income tax for a given income, filing status and tax year, they can be cumbersome when you are considering multiple “What-If” scenarios, including:

  • Changing Filing Status (e.g. getting married)
  • Predicting Taxes for Hypothetical Future Tax Rates and Brackets
  • Calculating Both Federal and State Income Taxes Simultaneously

Fortunately, Gregory Taketa the Data Decanter has formed an easy Spreadsheet on which you can estimate your Federal and State (up to 9 brackets) Income Tax Liabilities.

Tax Bracket

Simply Input Your Estimated Taxable Income for Your Filing Status, and Voila! You can quickly estimate your Income Taxes!

You CAN:

  • Compare Taxes for Different Filing Statuses
  • Estimate State Taxes if 9 or fewer Tax Brackets
  • Estimate Marginal Tax Rates for Financial Decisions (Should I pay off loans first or invest in stocks, given my tax situation?)
  • Estimate impacts for many hypothetical Tax Brackets and Rates:
Tax Bracket Input

You can insert the Federal Tax Brackets and Rates for any year (up to 7 brackets), and State Tax Brackets and Rates for any year (up to 9 Brackets). Here is TY 2014 for Fed & CA.

Disclaimer: Gregory Taketa is not a Tax Professional at this time, and he is not responsible for any consequences arising from your use of this application. Please consult your Tax Advisor before making a decision.  This application may contain rounding errors and other errors.  You may contact greg@gregariousconsulting.com to report errors.

As an example of possible further analysis, my file provides a small case in which you and a partner are wondering whether there is a financial benefit to getting married.  Many experts say that normally Married Filing Jointly is useful when your incomes are disparate and not so useful when your incomes are close.  By inputting various incomes for you and your partner, you can see the Estimated Tax Differences to draw your own conclusions (again, please consult your Tax Advisor before committing to a decision).

2 Persons

In this example, when Taxable Incomes are close to each other, MFJ offers little cost savings from each person’s filing Singly.

This is one of many applications Gregory Taketa the Data Decanter can create to help you make tough decisions.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s