(Enter your own data in the yellow fields)      
(Use "tab"key to enable data entry and for navigation to other yellow boxes)  
(Use "reset" button to return original "default data")  
(Put curser on yellow box you want to change and use backspace key as needed)  
      VENDOR CALLS ANALYSIS & PROJECTIONS:  
1 CALLS MADE (ANSWERED CALLS)        
2 DISCUSSIONS WITH DECISION MAKERS (% OF CALLS MADE)   VENDOR PROGRAM  
3 DISCUSSION WITH SUBORDINATE ONLY (% OF CALLS MADE)  
4 VOICE MAIL LEFT WITH DM   (% OF CALLS MADE)  
5 EMAIL SENT TO DM   (% OF CALLS MADE)  
6 LEADS RECEIVED (B31 X I35)   (% OF CALLS MADE)  
7 APPLICATIONS RECEIVED   (% OF LEADS)  
8 COST OF EQUIPMENT PER LEASE        
9 APPLICATION $ SUBMITTED (B36 X B37)        
10 APPLICATON $ APPROVED   (APPROVAL RATIO)  
11 APPLICATION 4 FUNDED   (FUNDING RATIO)  
12 AGENT COMMISSION          
13 INCOME (B40 X B41)          
14 INCOME FOR # OF PERIODS   (PERIODS)  
                           
YEAR 1     MONTHLY AND ANNUAL INCOME GOALS:    
MONTH: 1 2 3 4 5 6 7 8 9 10 11 12 TOTALS
END USER INCOME $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
VENDOR INCOME $ - $ -
END USER REPEAT $ - $ - $ - $ -
VENDOR REPEAT $ - $ -  
TOTAL
YTD  
                           
YEAR 2                          
MONTH: 1 2 3 4 5 6 7 8 9 10 11 12 TOTALS
END USER INCOME $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
VENDOR INCOME
END USER REPEAT
VENDOR REPEAT
TOTAL
YTD  
                           
YEAR 3                          
MONTH: 1 2 3 4 5 6 7 8 9 10 11 12 TOTALS
END USER INCOME $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
VENDOR INCOME
END USER REPEAT
VENDOR REPEAT $ 1,900 $ 2,000 $ 2,100 $ 2,200 $ 2,300 $ 2,400 $ 2,500 $ 2,600 $ 2,700 $ 2,800 $ 2,900 $ 3,000
TOTAL
YTD  
 
 

Convert Excel spreadsheet to HTML page