We’re far enough along in the year that I’m reasonably confident in my total income for the year, so I’ve calculated how much federal income tax I should pay overall for the year.
To follow along, open up a new Excel spreadsheet.
In cell A1, enter the sum of your federal taxable earnings for the year. This isn’t your total gross earnings because you could have pre-tax deductions. My paychecks each month actually show what my federal taxable wages are.
In cell A2, enter your standard deduction (or the sum of your itemized deductions, if you plan on using those when filing instead). Personally, I prefer to do this calculation as it relates to the amount of federal income tax deducted from my paycheck using both the standard deduction and the sum of my itemized deductions to have a better margin of error. For 2012, this is :
- $5,950 for singles and married individuals filing separately
- $11,900 for married couples filing a joint return
- $8,700 for heads of household
In cell A3, enter the number of personal and dependent exemptions you can use. If you’re single, this is only 1.
In cell A4, enter:
where $3,800 is the value of each personal and dependent exemption .
In cell A5, enter the sum of your interest and ordinary dividends.
In cell A6, enter:
This is an approximation of your total taxable income. Disclaimer: I’m excluding more complex cases that don’t apply to me. You should do your own figuring if you have further income that I haven’t covered here.
In cell A7, enter:
This formula will calculate your total tax due if the amount in cell A6 was less than $178,650.
I ran this calculation with both the standard deduction and an estimated sum of my itemized deductions. I estimate the sum of my itemized deductions to be higher than the standard deduction, so I should owe a bit less tax (< $1,000 less) if I itemize.
I will have paid more federal income tax than the amount in A7 assuming the standard deduction with my November paycheck, which means that, mathematically, I don’t need to pay any income tax on my December paycheck to cover all of my tax owing for the year.
I did a similar calculation last year and didn’t really believe that I didn’t need to pay as much income tax with my December paycheck as my employer had been taking off each month. I ended up with the refund that I expected. But this year I’ve calculated that I even if I skip paying federal income taxes with December’s paycheck, I will still overpay by about $400, assuming that I take the standard deduction, which makes my margin of error in skipping paying federal income taxes with December’s paycheck about $1,000.
A resource that has helped me quite a bit in estimating my federal income taxes due is the IRS Withholding Calculator. Running the calculator this past Sunday, it seemed to think that I had already received my November paycheck, so I had to include the taxes I expect to be withheld from November’s paycheck in the field labelled “Enter the total Federal income tax withheld to date in 2012 (including amounts withheld from bonuses or which you expect to have withheld for bonuses):”. You can double check where it thinks you are in the pay year by looking at the amount under “Projected withholding for rest of year:” on the concluding page. If that is equal to “Total tax withheld from last check:” and you’re paid monthly, then it thinks you’ve already seen your November paycheck.
This year, I’m going to trust the math. I’m going to take the IRS Withholding Calculator’s suggestion of setting my W-4 allowances to 23 in early December so that my employer doesn’t withhold any federal income tax from my last paycheck of the year. That means that I’ll have a huge paycheck in December, since I’m also done with paying Social Security taxes and my 401(k) contribution will be less than other months.
Next year? I’m going to set my W-4 allowances to 2 instead of the 1 that I had been using this year and I’m going to adjust my RSU vests to have only 28% withheld instead of the 35% I had set it to to offset only 25% being withheld from them earlier in the year. I’ll continue to take a look at these calculations several times a year. I’ll need to evaluate whether I want to have less federal income tax withheld from each of my paychecks to take into account my itemized deductions now that I own a place, but for the first part of the year, I’m going to assume just the standard deduction on my paychecks. I would, after all, rather have too much withheld than end up paying penalties because I didn’t pay enough federal income tax throughout the year.