Years ending Dec   2008 2009 2010 2011    
6-7th YEARS ASSUMPTIONS    
  Help with Entering Assumptions
   
Sales & Costs        
Change in sales over previous year (%)[1] ->> 53.6 32.2 20.0 15.0    
Gross margin (%) ->> 52.4 52.0 51.0 51.0    
Overhead expenses ($000) ->> 11,272 14,729 17,500 19,000    
Annual sales per employee ($000) ->> 74 86 95 101    
         
Various Items        
Operating lease payments ($000) ->> 140 180 190 190    
Miscellaneous income ($000) ->> 120 120 120 120    
Bad debts ($000) ->> 162 238 300 350    
Intangible asset amortization ($000) ->>        
Dividends declared ($000) ->> 1,000 1,250 1,500 2,000    
Effective federal/state tax rate (%) ->> 15.0 20.0 20.0 20.0    
         
Fixed Assets        
Capital expend - excl leases ($000) ->> 3,100 2,700 2,500 3,000    
Disposals of fixed assets ($000):        
 -Proceeds ->> 150        
 -Cost ->> 60        
 -Accumulated depreciation ->> 60        
         
Stock & Shares        
Proceeds of new stock issues ($000) ->>        
Number of new shares issued (000s) ->>        
         
Debt & Leases        
Change in longterm debt/notes ($000) ->> (50) (50) (50) (50)    
Change in 'other loans' ($000) ->> (20) (20) (20) (20)    
Int payable on 'other loans' ($000) ->>        
New lease obligations ($000) ->> 250 300 350 350    
Lease interest ($000) ->> 200 200 200 200    
Lease repayments ($000) ->> 220 220 220 220    
         
Working Capital        
Accounts receivable (days sales) ->> 49 48 48 48    
Inventory (days sales) ->> 32 32 32 32    
Accounts payable (days costs & exs) ->> 30 30 30 30    
               

[1]
If percentage changes are set to zero, no projections will be generated for the 4th & 5th years. If there is no growth in sales but 4th & 5th year projections are required, enter very small values (e.g. 0.001).