Title Image

Don Xml's Grok This

The home of Don Demsak
Welcome to Don Xml's Grok This Sign in | Help
in Search

DonXml's Grok This

Consulting Rate Worksheet

Here’s a worksheet that FTEs and Consultants could use to convert their incomes from one to the other.  There are a lot of variables, but I’ll try to account for all that I know of.  This is written for the USA, but I’m sure you can easily translate it for other countries.

ConsultantRatePerHour – What the consultant get paid per hour

HoursPerWeek – The standard number of hours worked per week

VacationDays – Total number of vacation days in a year.  Consultants should make sure they take at least 2 weeks (that is 10 work days) per year.

Holidays – Total number of Holidays per year.  The typical amount in the USA is about 10 days.

EducationDays – Total number of days attending conferences and/or classes.

MarketingDays - Total number of days not working due to various marketing events.  A conference can be considered a marketing day or an education day, but only count it once.  This number can vary widely, depending on the person and the amount of work in a given location.  The less work, the more marketing you will need to do.

NumberOfWorkWeeks – The number of weeks actually worked.  There are typically about 10 holidays per year (2 work weeks), and then you add you vacation weeks (consultants should make sure they take at least 2 vacation weeks/year).

NumberOfWorkWeeks = 52 – ((VacationDays + Hoildays + EducationDays + MarketingDays) / 7 )

AnnualIncome – the amount of money you get for a give year.  This is before any deductions.

For a consultant:
AnnualIncome = ConsultantRatePerHour * HoursPerWeek * NumberOfWorkWeeks

For a FTE:
AnnualIncome = AnnualSalary + Bonuses

Now for the hard stuff, the conversion formulas, but first a few definitions:

InsuranceCosts – this should include Health, Life, Work’s Comp, Disability, Errors & Omissions.  For FTEs make sure you include every type of insurance in your benefit package.  This is an Annual number.

RetirementPlanning – This is a tough one.  This should be only Employer side stuff.  That is pension and retiree medical (that is if they offer it).  401K doesn’t count, because it is part of your AnnualIncome, but employer match does count, since it wasn’t in the AnnualIncome number.  This is an Annual number.

To convert a FTE to a W2 Consulting Rate (right side stuff is FTE numbers):

ConsultantRatePerHour = (AnnualIncome + RetirementPlanning + InsuranceCosts) / (HoursPerWeek * NumberOfWorkWeeks)

To convert a W2 consulting rate to a FTE AnnualIncome (right side stuff is in Consultant numbers):

AnnualIncome = (HoursPerWeek * NumberOfWorkWeeks * ConsultantRatePerHour) – ( InsuranceCosts + RetirementPlanning)

The harder conversion is when trying to compare 1099 consultants (that is consultants that have their own business and pay their own taxes).  They have 2 extra costs and 1 extra income:

EmployerTaxes – In the States you (being the employee and employer) will have pay the employer side payroll taxes, plus taxes on your business.  At minimum, you will have the employer FICA and Medicaid numbers (about 8% salary).  Then add Fed Income tax for you company (if it makes any money) and State and local taxes.

CostOfDoingBusiness – This is stuff like accountant fees, and marketing costs.  Marketing costs can include stuff like conferences, or even better put the conference cost towards education.

EducationCosts – As an independent you are responsible for your own education.  This is good and bad, as you need to budget for it, but you only need permission from yourself (and/or your spouse) to attend.  Remember, your future earnings will eventually be affected by your choices.  This amount should include the cost of the training, plus all travel expenses.  The plus side, you should be able to write most of this off your taxes (but contact an accountant first).

TaxDeductionSavings – If you have your own company, you can right off items that an FTE would not normally be able to deduct from their taxes.  This number is the amount on money you actually save by using these deductions.  Depending on your accountant this could be a little, or a lot.

To convert a FTE to a 1099 Consulting Rate (right side stuff is FTE numbers):

ConsultantRatePerHour = (AnnualIncome + RetirementPlanning + InsuranceCosts + EmployerTaxes + CostOfDoingBusiness + EducationCosts - TaxDeductionSavings) / (HoursPerWeek * NumberOfWorkWeeks)

To convert a 1099 consulting rate to a FTE AnnualIncome (right side stuff is in Consultant numbers):

AnnualIncome = (HoursPerWeek * NumberOfWorkWeeks * ConsultantRatePerHour) – ( InsuranceCosts + RetirementPlanning + EmployerTaxes + CostOfDoingBusiness + EducationCosts - TaxDeductionSavings  )

Published Thursday, December 18, 2003 9:10 AM by donxml

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

TrackBack said:

December 18, 2003 9:22 AM

TrackBack said:

December 18, 2003 11:16 AM

Bruce Johnson said:

My only comment is to suggest adding a couple of elements that, while I'm sure you're aware of, an inexperienced person wouldn't be. That would be the time spent on education and marketing for a consultant. For an FTE, marketing is not necessary and education is built into their salary. For a consultant, not marketing means starving. And not learning means starving at some point in the future when technology passes you but. So, with your indulgence, I'd suggest changing the definition of NumberOfWorkWeeks to be

(52 - 2 (for holidays) - 2 (for vacation)) * (1 - (.2 + .05))

The .2 value indicates that marketing requires 20% of a consultants time. This could also be considered the downtime between contracts. The .05 value represents two weeks a year (roughly) spent on education. This might be a little low, but you get the idea. And remember, your mileage may vary. ;)

Bruce Johnson
http://www.ObjectSharp.com/Bruce
December 18, 2003 12:26 PM

Larry O'Brien said:

+1 to Bruce's point. It's not at all unusual for me to spend 10 hours per week on non-billable administrative stuff (and I'm not even talking about fun stuff like education, exploratory programming, and networking at the "real friend" level). And this is stuff one can't neglect, where one doesn't get into a "flow," and from which one doesn't derive a lot of satisfaction / energy. That 20-25% of my time is, for me, easily more wearing than the entire rest of my week.
December 23, 2003 12:09 PM

TrackBack said:

January 4, 2004 7:03 PM

TrackBack said:

January 6, 2004 10:50 AM

CX Inc said:

As an independent, I'm often intrigued by the conversations I have with the FTE's I'm involved with on projects. Like us, their business/employment concerns revolve around:

- Net Income & (Net Income vs. Hrs)
- Personal Mental Challenge
- Peer Approval & Acceptance
- Leaving a Perpetual Legacy

On paper, I'm probably better off as an FTE somewhere, but I can't seem to put a price on the non financial objectives above that being my own boss seem to help with. As a "gun for hire", it's usually clear what my expected deliverables will be. I get to choose my projects, negotiate my contract terms, set my price, and produce the final product. The big risk is not being able to find clients that need my services to keep my business a float.

In the context of marketing, self promotion is prevailent in both FTE's, looking for advancement within their organizations, as well as by us independent contractors with a defined set of skills for sale. I wouldn't necessarily agree with "For an FTE, marketing is not necessary and education is built into their salary". For us entrepreneurs, we'd most likely compete with the type A's and workaholics of an organization. Many times if you analyze their actual hours they are being compensated by much less than logic of the worksheet above presents.

Just another consideration when given an FTE offer by a client.

Good luck....

August 15, 2004 11:24 PM

TrackBack said:

August 17, 2004 10:35 PM

Krellan said:

Thanks for coming up with these formulas! I made a spreadsheet for them, and the numbers came up to pretty much what I expected.

With luck, I will soon have my first 1099 consulting job, re-entering the IT industry after being laid off for a year and a half....
September 2, 2004 10:48 PM

Haacked said:

Krellan, have you posted that spreadsheet somewhere? That could be very useful to others! :)

Haacked.
February 24, 2005 1:10 PM

Steven said:

One simple formula I've used:

Annual salary / 1000 = hourly rate (1099)

If I want to make the equivalent of $90k a year, I must charge $90/hour.
April 13, 2005 11:56 AM

DonXml's Grok This said:

I put up my first cut on a worksheet that you can use to convert Consultant rates to/from FTE Salaries.
October 24, 2006 8:28 PM

Bobbie said:

Here's a question: How do I convert my current hourly rate (self-employed on a 1099 basis) to an hourly rate on a W-2 basis? I have a potential client who hires contractors, and I expect to get an offer of an hourly rate on a W-2 basis. No benefits and no promise of a minimum number of hours. Thanks for your input.
May 9, 2008 12:06 PM

David Booth said:

Very nice post, but where is the worksheet? I do not see a link to the spreadsheet that actually performs the calculations.
March 18, 2009 8:06 AM

Lance Aubry said:

I concur with the above, where can I find the spreadsheet? Thank you, Lance
July 30, 2009 11:18 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About donxml

I’m an independent consultant, specializing in .Net solutions architecture, based out of New Jersey who also doubles as an evangelist for XML, Domain Driven Design, enterprise architecture and .Net. I do not work for Microsoft, the W3C or any other big company that you may know of (at least not yet). I’ve been an indie for over ten years, and although I’ve been tempted a couple times to take a job with companies like Microsoft, I’ve haven’t found something better than my current situation. I work mostly with the large pharmaceuticals that are based here in New Jersey, and usually find myself on long term contracts. Definitely not the prototypical indie consultant, but it lets me dedicate time to my non-income generating activities like the developer community stuff, plus financing open source projects like XPathmania and MVP-XML. If you would like to talk to me about doing some contract work, just contact me via the contact page. My rates vary widely, depending on lots of different variables, but mostly distance from Jersey, and type of work. Plus, I’ve been known to donate some of my code for various projects.
Powered by Community Server, by Telligent Systems