Years ending           05-06 05-06 05-06 05-06 06-07 06-07 06-07 06-07 07-08 07-08 07-08 07-08    
Jan           1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr    
ASSUMPTIONS FOR 2nd & 3rd YEARS AND PROJECTIONS FOR 1st YEAR - OTHER ITEMS    
  Help with Entering Assumptions
   
Various Items                    
Annualised sales per employee ($000) ->> 91 86 83 90 90 90 90 90 90 90 90 90    
                     
Operating lease payments ($000) ->> 3 3 3 3 3 3 3 3 3 3 3 3    
Miscellaneous income ($000) ->> 3 3 3 3 9 9 9 9 9 9 9 9    
Intangible asset amortization ($000) ->> 3 3 3 3 2      
Dividends declared ($000) ->>       10   10   15    
Dividend payments ($000)       10   10   15    
     
Taxes    
Effective federal/state tax rate (%) ->> ->> ->> ->> 7.0 ->> ->> ->> 7.0 ->> ->> ->> 8.0    
Federal/state tax payments ($000) - 2 - - - 6 - -    
     
Fixed Assets    
Closing fixed assets at cost ($000) 75 69 69 99 99 99 94 144 139 139 139 127 127    
Opening accumulated depreciation ($000) 25 24 24 25 25 27 27 30 30 33 35 31    
                     
Composite depreciation rate (% pa) ->> 3.0 3.0 3.0 3.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0    
                     
Capital expenditure ($000) ->> 30       50      
Capital expend payments ($000) 9 30     50              
     
Disposals of fixed assets ($000):                    
 -Proceeds ->> 6     5   10   10      
 -Cost ->> 6     5   5   12      
 -Accumulated depreciation ->> 2     2   3   7      
                     
Stocks, Shares & Investment                    
Proceeds of new stock issues ($000) ->> 5     30      
No of new shares issued (000s) ->> 3     20      
                     
Debt                    
Increases in longterm debt/notes ($000) ->> 10          
Longterm debt/note repayments ($000) ->> 5 5 5 5 5 5 5 5      
                     
Interest rates (% pa):                    
 -Cash at bank ->> 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0    
 -Short-term loans/line of credit ->> 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5    
 -Longterm debt/notes ->> 12.5 12.5 12.5 12.5 12.5 12.5 12.5 12.5 12.5 12.5 12.5 12.5    
                     
Total longterm debt/notes outstanding ($000) 35 30 25 20 15 10 5    
Proportions payable within one year:                    
 -Longterm debt/notes (as % total) ->> 25 25 25 25 50 50 50 50 50 50 50 50    
                     
Working Capital                    
Accounts receivable (days sales) ->> 38 39 39 39 45 45 45 45 45 45 45 45    
Inventory (days sales) ->> 13 12 11 10 12 12 12 12 12 12 12 12    
Accounts payable (days costs & expenses) ->> 23 19 20 20 23 23 23 23 23 23 23 23    
                     
Level of prepaid expenses ($000) ->> 15 13 13 13 13 8 8 8 8 12 12 12 12    
Level of accrued expenses ($000) ->> 6 2 2 2 2 5 5 5 5 9 9 9 9    
                     
Sales Tax                    
Effective Sales Tax rate for sales (%) ->> 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0    
Effective Sales Tax rate on inputs (%) ->>          
                                       
 
Supplementary Data & Calculations: