PC Review


Reply
Thread Tools Rate Thread

calculate diffence between old salary and new salary

 
 
Felicia Pickett
Guest
Posts: n/a
 
      5th Apr 2010
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?
 
Reply With Quote
 
 
 
 
trip_to_tokyo
Guest
Posts: n/a
 
      5th Apr 2010
USD 100 per day times the number of working days in the year.

If my comments have helped please hit Yes.

Thanks.



"Felicia Pickett" wrote:

> 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?

 
Reply With Quote
 
Ziggy
Guest
Posts: n/a
 
      5th Apr 2010
On Apr 5, 1:56*pm, trip_to_tokyo <i...@pierrefondes.com> wrote:
> USD 100 per day times the number of working days in the year.
>
> If my comments have helped please hit Yes.
>
> Thanks.
>
>
>
> "Felicia Pickett" wrote:
> > 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?- Hide quoted text -

>
> - 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

 
Reply With Quote
 
Billns
Guest
Posts: n/a
 
      6th Apr 2010
On 4/5/2010 12:54 PM, Felicia Pickett wrote:
> 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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Short Way to Calculate Salary Increases John Microsoft Excel Worksheet Functions 0 29th Jul 2008 07:16 PM
calculate years worked by 3% * salary in excel =?Utf-8?B?bGF1cmVudGl1bTM=?= Microsoft Excel Worksheet Functions 2 18th Jan 2006 12:39 AM
how do I create a spreadsheet to calculate % benefits and salary =?Utf-8?B?RXhlY3V0aXZlIEFzc3Q=?= Microsoft Access 2 10th Jan 2006 09:35 PM
How to calculate pension contribution on salary? pgruening Microsoft Excel Misc 3 7th Sep 2005 09:28 PM
Re: How to calculate pension contribution on salary? swatsp0p Microsoft Excel Misc 0 7th Sep 2005 09:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:35 PM.