Combined Federal Tax Estimator

An Excel spreadsheet to calculate all common US federal taxes combined together: income, payroll, capital gains, etc.

Quick and Comprehensive Tax Estimation

This calculator quickly estimates your total federal tax liability.
It properly combines the most common tax types for employed individuals in one place.

(Most other tax estimators focus only on one tax type (e.g., federal income tax only), or ask a ton of detailed questions that take forever to answer.)

Included:

Federal Income Tax (including Alternative Minimum Tax (AMT), short-term capital gains, ...)
Long-Term Capital Gains Tax
Social Security Tax
Medicare Taxes (including Additional Medicare Tax and Net Investment Income Tax (NIIT))

Philosophy: This is an estimation tool. It intentionally omits some deductions to keep things simple.
It's better to slightly overestimate (and get a refund) than underestimate (and face penalties).

[ ToP ]

Option A (embedded): Immediate Results

No setup required
Data cannot be saved
All common desktop browsers supported

Open in new tab.

[ ToP ]

Option B (your own copy): Save Your Data, Explore Scenarios

All data can be saved
Best for exploring different income and taxation scenarios
Requires free Microsoft account or Excel for desktop (Windows or Mac)

Get your own private copy of the calculator:

Open the Live Version (read only):
https://1drv.ms/x/c/08eb2a76c904b8dc/IQDJ_MIEvoibT5KEPsPYRUGtAQq8gxWxRYI-GZa5V8ZWGDk
[Show Preview]
Create your own copy:
Go to `File` > `Create a Copy`.
- To use with Excel Online (free): select `Create a copy online`.
- To use with Excel for Desktop (Windows or Mac): select `Download a Copy`.
  
  Alternatively, download the calculator Excel file directly from the GitHub repo. [Combined Tax Estimator.xlsx]

Screenshot: Create your own copy of this calculator

[ ToP ]

How to use

Input Your Income ('Estimator' tab, orange cells only):
- Enter your estimated income in section 'Your estimated income'.
- Each income category has 3 input fields. Use them however you like (they're simply added together).
- Only edit orange cells. All other cells are auto-computed.
- Some input cells are pre-filled with sample values. Make sure to override with your own values.
Review Your Results:
- 'Total Tax Summary' section: View estimated tax by type and your total.
- Detail sections below: See exactly how each tax is calculated.
- 'Parameters' tab: Reference tax rates and brackets for each year.

[ ToP ]

Tax types not considered

State and local taxes.
Self-Employment Tax.
Some nuances of Alternative Minimum Tax (AMT), such as Incentive Stock Options (ISO) exercise tax.
(This can significantly impact the AMT. There may be other AMT nuances that are not considered.)
There may be others, so focus on what is explicitly covered (see above).

[ ToP ]

⚠️ This calculator is not a qualified tax advice.

This tool is for estimation purposes only. It should be reasonably accurate for ~90% of employed individuals.
The calculator accounts for common income types, such as W-2, capital gains, rental income, and others.

For fully reliable tax calculations, especially for complex tax situations, always consult a qualified tax professional!

[ ToP ]

Questions & Contact

To ask a question or contact the author, submit an Issue on GitHub.