calculate diffence between old salary and new salary

[Felicia Pickett]

I have to figure out the impact if a daily salary increases. How do you
calculate the difference ex: $100/day to $200/day, what is the impact on
annual increase?

 

[trip_to_tokyo]

USD 100 per day times the number of working days in the year.

If my comments have helped please hit Yes.

Thanks.

 

[David Biddulph]

If A1 has the old daily salary and A2 has the new daily salary, the daily
difference is given by the formula =A2-A1 and the annual difference will be
=(A2-A1)*365 or =(A2-A1)*366 in a leap year.

 

[Ziggy]

USD 100 per day times the number of working days in the year.

If my comments have helped please hit Yes.

Thanks.





- Show quoted text -

Usually I use 261 working days for the year = 52 x 5 +1

If he/she is a contractor or an hourly employee you may want to deduct
holidays and/or time taken off.

If there are benefits involved you wil have to allow for that. Health
insurance is the biggest single item usually. 35% for benefits in the
52,000 per year is about right if the person has family health
insurance, a 401 K, FUTA, SUTS, WC, SS, MC, Vacation, ...
At the very least the employer has FICA at 6.2% for SS and 1.45% for
MC

 

[Billns]

I have to figure out the impact if a daily salary increases. How do you
calculate the difference ex: $100/day to $200/day, what is the impact on
annual increase?

Not trying to be facetious, but the annual salary should double -- the
annual increase is 100% -- in your example.

How you handle this in Excel depends on what you mean by "daily."
Does the worker get paid every day of the year or just workdays?

Bill