Hourly Rates Calculator.xlsx

	A	B	C	D	E	F	G	H	I
1	The Hourly Rates "Formula" Worksheet
2	Use this handy worksheet to determine your hourly rate. Only populate cells highlighted in Yellow
3
4
5	1. Salary Goal		Estimate the gross revenue amount that you desire (wish) to make yearly in this cell.						R0.00
6
7	2. Operating Costs
8	Labour Costs and Other Direct Project Costs:					Monthly		Annual
9		Outsourcing or Hired help				R0.00		R0.00
10	Non-Labour Operating Costs					Monthly		Annual
11		Outside Services:
12			Legal			R0.00		R0.00
13			Accounting			R0.00		R0.00
14			Insurance			R0.00		R0.00
15			Other:			R0.00		R0.00
16		Advertising/Promotion
17			Website (hosting/domain)			R0.00		R0.00
18			Email Provider			R0.00		R0.00
19			Other:			R0.00		R0.00
20		Equipment Purchases (computer, printer, etc.)				R0.00		R0.00
21		Occupancy Expenses:
22			Rent			R0.00		R0.00
23			Utilities (Gas/Electric)			R0.00		R0.00
24			Telephone/Cell			R0.00		R0.00
25			Internet Service			R0.00		R0.00
26		Miscellaneous:
27			Office supplies/postage			R0.00		R0.00
28			Software & Updates			R0.00		R0.00
29			Bank Fees / Service Charges			R0.00		R0.00
30			Travel / Conferences / Entertainment			R0.00		R0.00
31			Membership Fees / Dues			R0.00		R0.00
32			Training & Development			R0.00		R0.00
33			Other:			R0.00		R0.00
34		Loan Payments				R0.00		R0.00
35		Other Operating Costs:				R0.00		R0.00
36	TOTAL Operating Costs							R0.00
37
38	3. Determine Billable Hours
39								Per Year
40	Potential hours available to work:			50.00	weeks @	30.00	hours per week	1,500
41		Less Vacation Time:		5.00	days @	24.00	hours per day	120
42		Less Sick Time:		14.00	days @	24.00	hours per day	336
43	Subtotal Potential Billable Hours							1,044
44		Less Non-Billable Work Hours:
45		Allow 15-20% of your potential billable hours towards marketing and administration, billing, ordering, phone calls, customer service, training. More for new VAs.
46				10.00	weeks @	5.00	hours per week	50
47		TOTAL BILLABLE HOURS							994
48
49	4. Determine Your Hourly Rate
50	1. Salary Goal							R0.00
51	2. Plus Operating Costs							R0.00
52		Subtotal						R0.00
53	3. Divided by Billable Hours							994
54						YOUR HOURLY RATE			R0.00
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100