First, I need to explain the difference between the 'W' forms ... again ... < sigh >.
_______ The W-2 is prepared by your employer and given to you. _______
_______ The W-4 is prepared by you and given to your employer. _______
Next, any advice to "put 1 on the W2" ( should be W-4 ) is bad advice. Everyone's situation is different
and advice to put a certain number without knowing your situation is BAD ADVICE - every time. Stop it!
Quote:
Originally Posted by decafdave
Does your spreadsheet allow for comparison of exemptions? ... I'd like to make it flexible enough to allow exemption inputs.
|
I don't understand the question. You don't get "inputs" you get get to take an exemption for each person in your family.
If what I put below doesn't clarify things, you might want to re-word the question.
( I like the Hangul, BTW. I'm a Kanji/katakana/hiragana-guy myself. )
Here is what you do. It is a two-step process ( using 2010 numbers ).
(1) Estimate your income.
Your gross pay is $1,000/paycheck. You get 26 paychecks, you make $26,000.
If you are getting withheld $100 each pay, then at the end of the year, you
will have
$ 2,600 withheld for federal taxes. Is that enough? See step (2).
All it takes to estimate pay is 26 rows on your spreadsheet.
(2) Estimate your taxes. Use the 1040 form and put in the lines that apply to you.
Line 7 ... Wages ............................... 26,000
Line 8 ... Interest ................................. 100
Line 37 .. Adjusted Gross Income ......... 26,100
Line 40 .. Standard Deduction ............... 5,800 ( or itemized deductions )
Line 41 .. Personal Exemption(s) ............ 3,650
Line 43 .. Taxable Income ................... 16,650
Next, find the tax schedule and calculate your tax that you will owe:
•10% on income between $0 and $8,375 ........................... 838
•15% on the income between $8,375 and $34,000; .......... 1,241
•25% on higher amounts .... and so on ...
.................................................. .... Total tax owed is
$ 2,079.
Based on these calculations, you will be getting a refund of
$ 2,600 less
$ 2,079 equals
$ 521
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Jacking with the W-4 form:
If you put more exemptions on the form, your withholdings will go down.
If you are being withheld too much, then you need to put more exemptions.
Don't bother filling out the worthless worksheet on the back.
Example 1 - People who just started a job in September
might be able to take 5 or 6 exemptions since their
Line 43 .. Taxable Income won't be as high as the
withholding tables that your employer uses indicates that it will be.
That is, you might have a salary of $60k, but if you start on Sept 1st, you will only make $20k.
There is no sense being taxed at the $60k rate ( $8,819 ) when you will only owe $1,164.
Example 2 - A person might also have a mortgage where they pay $20k in interest and taxes.
If that person itemizes ( using Schedule A ), then they will also be able to deduct state
withholding taxes and such. Again, they
might need to use 7 or 8 exemptions on their
W-4 form.
Finally, you can't know exactly how many exemptions you need to take on the W-4 without knowing the tax tables.
If you have too much withheld and you modify your W-4 then the next time you get paid, you can see the effect.
If it's
still not enough, take more exemptions by giving your employer yet another W-4 form.
( Your employer could figure it out for you, but it is easier to just take a shot and modify later. )
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
If you are hourly and have varying amounts of gross pay then you will have to make as good of an
estimate that you can, over the rest of the year, what your hours and pay will be. In Mar/Apr, you
might not be able to guess very well. By Oct/Nov, you can come pretty close. A good strategy is
to have too much withheld and increase your exemptions in Sep and later in Oct/Nov so that you
have much larger net paychecks later in the year - rather than wait for your IRS refund.
On the subject of state taxes, the spreadsheet is done the same way - using your state's tax
form and using your state's tax schedule. If you live in CA, or NJ, or IL, ... my sympathy to you.
Without knowing a person's tax situation, you cannot advise them to take any certain number of exemptions.
When preparing taxes and giving tax or investment advice, the advisor needs to
ask questions first.