|
|
calculate diffence between old salary and new salary
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?
|
|
0
|
|
|
|
Reply
|
 Utf
|
4/5/2010 7:54:14 PM |
|
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?
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/5/2010 7:56:15 PM
|
|
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" <FeliciaPickett@discussions.microsoft.com> wrote in
message news:E9586884-E5A1-49CB-BDC9-55E20A48DD14@microsoft.com...
> 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?
|
|
|
0
|
|
|
|
Reply
|
David
|
4/5/2010 8:24:05 PM
|
|
On Apr 5, 1:56=A0pm, 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 o=
n
> > annual increase?- Hide quoted text -
>
> - Show quoted text -
Usually I use 261 working days for the year =3D 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
|
|
|
0
|
|
|
|
Reply
|
Ziggy
|
4/5/2010 10:48:23 PM
|
|
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
|
|
|
0
|
|
|
|
Reply
|
Billns
|
4/6/2010 3:32:05 PM
|
|
|
4 Replies
447 Views
(page loaded in 0.089 seconds)
Similiar Articles: Using expressions in a report to calculate pay - microsoft.public ...... encountering is that I am trying to calculate pay ... expressions, how can I calculate the difference between two dates in ... calculate diffence between old salary and new ... How to calculate diffrence between two dates - microsoft.public ...... expressions, how can I calculate the difference between two ... contains dates for, say, new hires. I want to calculate the differences between ... ... days a customer takes to pay a ... Subtract colums in pivot table - microsoft.public.excel.misc ...... left) are values: "# Employees", "Total Pay" -Columns (across top) are Dates I want to calculate the difference between ... Pivot Table Creating New Columns that ... Formula for weeks - microsoft.public.excel.miscCalculate difference between current date & prior - microsoft ... I am looking for a formula that ... What Excel formula converts hourly wage to annual salary ... Salut Entre ... 6 Day working week (friday holiday) - microsoft.public.excel ...I need to calculate total days between 2 dates excluding each... ... > > is there any way to add a new formular or modify ... Federal Holidays - Work Schedules and Pay ... Finding Average of last 5 entries - microsoft.public.excel ...... entry, step back to the fifth-last-filled, calculate ... at 5:20 per call. I need to see what the new ... ... The difference between the last average and the first appears in ... WDDM driver problem - microsoft.public.development.device.drivers ...... having a subscription, > although you'll pay a fee. ... with releasing sources of WDDM drivers, is the difference between ... ve completed this initial step. Removing your old ... Help Please - microsoft.public.access... set of values from the mean, but merely the difference between ... will compute the variance any time he adds a new ... help, writing help, study skills, conversion calculator ... VB6 app longevity - microsoft.public.vb.general.discussion ...Someone ought to compile one of those old school ... At the moment I'm trying out KBasic, there is a new ... > Big difference between servers and desktop/workstation computers ... Problem with Macros - microsoft.public.mac.office.wordNow also when opening OLD Word Docs, I'm getting the ... unless I ask you to; or unless you intend to pay! ... The difference is that a deep scan opens compressed archives ... calculate diffence between old salary and new salary ExcelI 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 in calculate diffence between old salary and new salary - ExcelBanterExcel Worksheet Functions ... I have to figure out the impact if a daily salary increases. How do you calculate the ... USD 100 per day times the number of working ... 8/1/2012 9:51:45 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 