Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask R. Klein, EA Your Own Question

R. Klein, EA, Accountant

Category: Finance

Satisfied Customers: 3374

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/

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.