Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Apr 5, 1:56*pm, trip_to_tokyo 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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. -- David Biddulph "Felicia Pickett" wrote in message ... 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? |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Short Way to Calculate Salary Increases | Excel Worksheet Functions | |||
Salary | Excel Discussion (Misc queries) | |||
Salary programme | Excel Discussion (Misc queries) | |||
calculate years worked by 3% * salary in excel | Excel Worksheet Functions | |||
How to calculate pension contribution on salary? | Excel Discussion (Misc queries) |