Appendix 5 - Fee Projections Worksheet
Fee Projections Worksheet
Use this format to make fee projections. Multiply your estimated monthly billable hours times your average billing rate to derive your projected billable fees. Multiply that by the percentage of fees actually billed to clients and by the percentage of billed fees you expect to collect from clients. The result is projected fees received.
| |
Jan |
Feb |
Mar |
Apr |
Mar |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Total |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Billabe Hours Worked
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Average Billing Rate
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected Billable Fees
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% Billed (Invoiced)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected Billed Fees
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% Collected
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected Fees Received
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
David Epperson, CPA, is a Partner at Saville Dodgen & Company, an accounting firm, Dallas, Texas, (214) 922-9727,
depperson@sdc-cpa.com; www.savilledodgen.com