Color-coded for ease of use, this printable billable rates worksheet totals wages, expenses, and hours.
Sample text from Billable Rates Worksheet:
Billable Rates Worksheet
| Wage Goals | Amount |
|---|---|
| Desired Salary for Self | |
| Desired Salary for Employee 1 | |
| Desired Salary for Employee 2 | |
| Desired Salary for Employee 3 | |
Wage Goal Total: |
| Expenses | Amount |
|---|---|
| Advertisement | |
| Mortgage/Rent | |
| Utilities | |
| Web Maintenance/Upgrades | |
| Taxes | |
| Supplies | |
| Repairs | |
| Miscellaneous | |
Expense Total: |
| Non-Billable Hours | Amount |
|---|---|
| Annual Sick Time Allotment | |
| Total Federal Holiday Hours | |
| Paid Time Off Total | |
| Overhead (50% of Billable Hours) | |
Total Non-Billable Hours: |
| Billable Hours | Amount |
|---|---|
| Projected Weekly Hours | |
| x 52 | |
Projected Annual Hours: |
|
- Non-Billable Hours |
- |
| = Billable Hours: |
= |
Wage Goal Total: |
|
+ Expense Total |
+ |
= Revenue Needed: |
|
+ Revenue x .05 (Profit Goal) |
= |
= Total Revenue Needed: |
= |
Total Revenue Needed: |
|
÷ Billable Hours |
÷ |
Hourly Billing Rate: |
= |
