COMPARATIVE ANALYSIS THROUGH AUGUST              
                   
NAME TOTAL CHARGE PERCENT HOURS WRITEUP BILLING BILLING PROFIT PROFIT PER
YEAR HOURS HOURS CHARGABLE BILLED WRITEDOWN   PER HOUR   HOUR BILLED
                   
EMPLOYEE 1                  
20XX 0 0 #DIV/0! 0.00 $0.00 $0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
        0.00          
EMPLOYEE 2                  
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
EMPLOYEE 3                  
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
EMPLOYEE 4                  
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
                   
EMPLOYEE 5                  
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
                   
EMPLOYEE 6                  
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
                   
NON-FULL-TIME EQUIVALENTS                
20XX                  
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
                   
TOTAL                  
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
20XX 0 0 #DIV/0! 0.00 $0.00 0.00 #DIV/0! 0.00 #DIV/0!
                   
3-YEAR 0.00 0.00 #DIV/0! 0.00 0.00 $0.00 #DIV/0! $0.00 #DIV/0!
AVERAGE                  
                   
LESS FIRM ADMIN 0 0.00 #DIV/0! 0.00 0.00 0.00 #DIV/0! 0.00 #DIV/0!
.                  
NET WITHOUT FIRM ADMINISTRATOR 0.00 0.00 #DIV/0! 0.00 0.00 0.00 #DIV/0! 0.00 #DIV/0!
as an average                  
                   
NOTE ****THE PROFIT NUMBER COMES FROM A SEPARATE ANALYSIS  CALCULATING DIRECTLY ATTRIBUTABLE COSTS SUCH AS COMP, DUES, CPE, PENSION, P/R TAXES, ETC                  
                   

Click filename below to access file

Month_to_Month_Analysis.xls




Business Forms Privacy Policy Also See Terms of Service.