First page of the Quarterly Estimated Tax CalculatorExcel workbook preview

IRS records and US tax

Quarterly Estimated Tax Calculator

Estimated tax payment worksheet in Excel for 2026: Form 1040-ES individual calculator with self-employment tax and safe harbors, plus a corporate installment calculator.

Excel workbook · 18 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

Estimated tax is how income that has no withholding gets paid during the year: self-employment profit, interest and rents for individuals, and the whole federal income tax for a C corporation. Underpaying an installment can lead to a penalty even if the full tax is paid with the return, so owners and controllers need the required amount for each due date and a record of what was paid.

This calculator has two worksheets. The individual one follows the 2026 Form 1040-ES worksheets, including self-employment tax, the tax rate schedules and the prior-year safe harbor. The corporate one follows the Publication 542 worksheet and the Form 2220 instructions for large corporations. Every rate sits in a cited input table, so the file can be updated each year.

Who it is for

The self-employed owner, or the controller paying a corporation's quarterly federal tax, who needs the required installments worked out and tracked against due dates.

What is inside

  • Individual sheet that follows the 2026 Form 1040-ES Estimated Tax Worksheet line by line, including the self-employment tax worksheet
  • Safe harbor test: 90% of current-year tax or 100% (110% above the AGI threshold) of prior-year tax
  • Corporation sheet based on the Pub 542 worksheet, with the large corporation rule from the Form 2220 instructions
  • Payment Schedule sheet for both calculators with due dates, amounts paid and a status that turns red when a past-due installment is short
  • 2026 Rates sheet with the four tax rate schedules (28 brackets), standard deductions and every rate and threshold as a cited input
  • Built-in check that recomputes each bracket's base tax and compares it with the IRS figure
  • Worked examples for an invented sole proprietor and a calendar-year C corporation

How to use it

Check the 2026 Rates sheet against the current Form 1040-ES, then enter the yellow input cells on the Individual or Corporation sheet.

Files

  • XLSXquarterly-estimated-tax-calculator.xlsx18 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

Who has to pay quarterly estimated tax?

Form 1040-ES (2026) says an individual generally must pay estimated tax if they expect to owe at least $1,000 after withholding and refundable credits, and expect withholding to be less than the smaller of 90% of the current-year tax or 100% of the prior-year tax. Publication 542 says a corporation generally must pay installments if it expects tax of $500 or more.

When are 2026 estimated tax payments due?

For individuals, Form 1040-ES (2026) lists April 15, June 15 and September 15, 2026, and January 15, 2027. Corporations pay by the 15th day of the 4th, 6th, 9th and 12th months of the tax year, which is April 15, June 15, September 15 and December 15 for a calendar year. A date on a weekend or holiday moves to the next business day.

What is the prior-year safe harbor?

An individual can base the payments on 100% of the prior-year tax, or 110% if prior-year AGI was more than $150,000 ($75,000 if married filing separately), instead of 90% of the current-year tax. A corporation can use 100% of the prior-year tax if that return covered 12 months and showed tax, but a large corporation can use it for the first installment only.