Years ending Jan   06-07 07-08 08-09 09-10  
ASSUMPTIONS FOR 4TH & 5TH YEARS  
  Help with Entering Assumptions
 
   
Sales & Costs      
Change in sales over previous year (%)[1] ->> 21.3 20.1 15.0 10.0  
Gross margin (%) ->> 42.5 43.2 43.0 45.0  
Overhead expenses ($000) ->> 1,962 2,188 2,400 2,600  
Annual sales per employee ($000) ->> 47 51 55 60  
       
Various Items      
Operating lease payments ($000) ->> 72 72 80 90  
Miscellaneous income ($000) ->> 120 120 200 230  
Bad debts ($000) ->> 42 58 40 45  
Intangible asset amortization ($000) ->> 2      
Dividends declared ($000) ->> 125 150 140  
Effective federal/state tax rate (%) ->> 7.0 8.0 8.0 8.0  
       
Fixed Assets      
Capital expend - excl leases ($000) ->> 250 525 350 300  
Disposals of fixed assets ($000):      
 -Proceeds ->> 150 70 100    
 -Cost ->> 50 20 35    
 -Accumulated depreciation ->> 25 35 20    
       
Stocks & Shares      
Proceeds of new stock issues ($000) ->> 200      
Number of new shares issued (000s) ->> 50      
       
Debt & Leases      
Change in longterm debt/notes ($000) ->> (100) 100      
Change in 'other loans' ($000) ->> 150 (50) 50 50  
Int payable on 'other loans' ($000) ->> 3 4 10 10  
New lease obligations ($000) ->> 60   100 100  
Lease interest ($000) ->> 40 40 30 30  
Lease repayments ($000) ->> 40 40 50 50  
       
Working Capital      
Accounts receivable (days sales) ->> 46 45 45 45  
Inventory (days sales) ->> 30 30 30 30  
Accounts payable (days costs & expenses) ->> 30 29 32 32  
             

[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).