Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating FED TAX in Excel
Update: Missing attachment has been added.
I have noticed various queries regarding calc of fed tax. I have this need also, and have set up a Vlookup mechanism. But now I have a much simpler method. It will handle rates for different years, and all tax status. This is my first time here and I just noticed the attachment option. But here are the higlights: 1) Put your input on one line. The M is MFJ, and the 90000 is the agi. m 2012 90000 2) Set up a range for the years and tax status. The following shows 2011 and 2012 and Single and MFJ. a) You should recognize most of the columns. b) The column with the "error" is the IF statement. It will show "t" (true) only once regardless of year or tax status. The T shows way down in 2012 M. c) When the column is true, the tax is calculated. (See attachment). 3) In the Tax column, use autosum so the tax appears in only one cell. (See attachment. Its all muddled in this rich text). 2011 s $0 $8,500 error 10% $0 $0 2011 s $8,500 $34,500 error 15% $850 $0 2011 s $34,500 $83,600 error 25% $4,750 $0 2011 s $83,600 $174,400 error 28% $17,025 $0 2011 s $174,400 $379,150 error 33% $42,449 $0 2011 s $379,150 $10,000,000 error 35% $110,016 $0 2012 s $0 $8,500 error 10% $0 $0 2012 s $8,500 $34,500 error 15% $850 $0 2012 s $34,500 $83,600 error 25% $4,750 $0 2012 s $83,600 $174,400 error 28% $17,025 $0 2012 s $174,400 $379,150 error 33% $42,449 $0 2012 s $379,150 $10,000,000 error 35% $110,016 $0 2011 m $0 $8,500 error 10% $0 $0 2011 m $8,500 $34,500 error 15% $850 $0 2011 m $34,500 $83,600 error 25% $4,750 $0 2011 m $83,600 $174,400 error 28% $17,025 $0 2011 m $174,400 $379,150 error 33% $42,449 $0 2011 m $379,150 $10,000,000 error 35% $110,016 $0 2012 m $0 $8,500 error 10% $0 $0 2012 m $8,500 $34,500 error 15% $850 $0 2012 m $34,500 $83,600 error 25% $4,750 $0 2012 m $83,600 $174,400 t 28% $17,025 $18,817 2012 m $174,400 $379,150 error 33% $42,449 $0 2012 m $379,150 $10,000,000 error 35% $110,016 $0 A single answer ---------------------------------------------------------------------------- $18,817 Last edited by peterylo : January 27th 13 at 01:00 PM Reason: Added attachment |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel sometimes not Calculating??? | Excel Discussion (Misc queries) | |||
Calculating In Excel | Excel Discussion (Misc queries) | |||
Excel not Calculating | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
CALCULATING WORKSHEETS (INCLUDING AGE CALCULATING SHEETS) FOR DOWNLOADING, GREAT FOR PENSIONS/LIFE INSURANCE CALCULATIONS! | Excel Programming |