How JustAnswer Works:
• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
Ask R. Klein, EA Your Own Question
R. Klein, EA, Accountant
Category: Finance
Satisfied Customers: 3375
Experience:  TurboTax Expert. QuickBooks Certified Pro Advisor
63817126
Type Your Finance Question Here...
R. Klein, EA is online now

# Forecasting for FICA, FUTA and SUTA on a 12 month spread. I

### Customer Question

Forecasting for FICA, FUTA and SUTA on a 12 month spread. I

Resolved Question:

Forecasting for FICA, FUTA and SUTA on a 12 month spread. I have a spreadsheet that has Salaries & Wages in \$ dollars going accross the top sheet for 12 months. I want to compute the FICA tax at rate of 7.65% but I have some earners that might reach their caps as the months go by each month. What is the best way to calculate the true tax exposure for each month. In other words I have maybe 4 employees reaching the \$106,800 cap in April then 4 more in May and so forth. Taking 7.65% for each month's S&W would overstate these particular employees tax expense. What I am trying to figure out is there some kid of tax factor that I should use? How would that work in setting up my spreadsheet/
Submitted: 3 years ago.
Category: Finance
Expert:  R. Klein, EA replied 3 years ago.

R. Klein, EA :

Thank you for your question today.

R. Klein, EA :

In 2014, the cap will be at 117K

R. Klein, EA :

there is no percentage amount of salary that computes the cap. It is 7.65% for SS & Medicare combined up to the earnings limit.

R. Klein, EA :

BUT THEN....there is an additional Medicare tax that must be withheld equal to 0.9% after you hit 200K earnings for the calendar year.

R. Klein, EA :

Plus, the Medicare amount of 1.45% does NOT have a cap at all.

R. Klein, EA :

In your Excel spreadsheet, you'll need a column for taxable SS wages in addition Taxable Wages

R. Klein, EA :

Then you can compute the tax amount in another column for SS tax (6.2%). You can use an If/Then type statement in the calculation such that "If YTD wages in the Taxable SS column is less than 117001, then SS tax = 62% of that column, otherwise the amount is 0"

R. Klein, EA :

You would have another column for "additional Medicare tax", similarly, although the column would calculate as "If the YTD SS wages are >200.000 then the Additional Medicare tax is 0.9% of the amount over \$200K"

Customer :

Do you have an example worksheet?

R. Klein, EA :

No, but you'll need to have several intermediary columns, as noted above.

R. Klein, EA :

For each pay period, you have a current earnings and a YTD amount. The tricky calculations are when you hot the YTD trigger amounts.

R. Klein, EA :

The calculation in Excel looks something like this, although I don't have enough time right now to do the full TRUE calculation.

R. Klein, EA :

Assume cell A1 has the current period check and B1 is the YTD after that check.

R. Klein, EA :

Formula would look like =if(A2>117000,0,(A1*0.062))

R. Klein, EA :

This says "If the YTD amount is Greater than 117K, then the SS amount = 0. If this is false, then the SS amount for this check is 6.2% times A1"

R. Klein, EA :

To do this fully accurately, where the TRUE statement is 0, you would need an IF statement in case the current period check carries the YTD amount OVER the 117K threshold, but PART of the current period check is taxed.