US Personal Tax Estimator (Federal + State)

What you get

A multi-sheet Excel workbook that estimates your total US federal and state income tax liability across wages, 1099 self-employment income, capital gains, dividends, and retirement contributions. It applies 2025 estimated federal income-tax brackets alongside the standard deduction, calculates self-employment tax on net freelance earnings, and references approximate income-tax rates for ten major states. All outputs are rough projections for planning purposes only and do not constitute tax advice.

Who it's for

This workbook is built for W-2 employees with freelance or investment income, full-time independent contractors, and self-employed individuals who want a realistic tax projection before year-end — or at any point mid-year when there is still time to adjust withholding, make a retirement contribution, or set aside cash for quarterly payments.

What's inside

• Inputs Sheet — a single entry point for filing status, wages, 1099 income, short- and long-term capital gains, qualified dividends, and pre-tax retirement contributions
• Federal Tax Calculation — applies 2025 estimated marginal brackets and the standard deduction to derive taxable income and gross federal tax owed
• Self-Employment Tax Calculator — computes the full Social Security and Medicare obligation on net 1099 earnings and surfaces the deductible half for use against gross income
• State Income Tax Lookup — a VLOOKUP-driven reference table covering approximate flat and marginal rates for ten major states
• Quarterly Estimate Planner — spreads remaining federal liability across the four IRS Form 1040-ES due dates with a running balance to track payments already made
• Summary Sheet — consolidates federal income tax, self-employment tax, and state tax into a single projected annual liability, clearly marked as an estimate only

How to use it

Open the file in Microsoft Excel or upload it to Google Sheets. Enter your income figures, filing status, and home state in the Inputs sheet — the Federal, State, and Self-Employment sheets update automatically from there. Review the Summary sheet for your projected total and use the Quarterly Estimate Planner to size each installment. Consult a qualified CPA or enrolled agent before making filing decisions.