Main  /  Members  /  Demo Company  /  Multi-Year Scenario #1  /  Financial Forecast Assumptions


Financial Forecast Assumptions
Demo Company
Multi-year Scenario #1
(Dollars and Shares in Thousands, Except Per Share Amounts)

 Actual Forecast
  12 Months  
12/31/96  
 12 Months  
12/31/97  
 12 Months  
12/31/98  
 12 Months  
12/31/99  
 3 Months  
03/31/00  
   12 Months  
12/31/00  
 12 Months  
12/31/01  
 12 Months  
12/31/02  
 12 Months  
12/31/03  
 12 Months  
12/31/04  
 
Year-to-Year Change in Net Sales NA   8.2%   (3.4)%   19.4%   NA    
 
Gross Margin % 28.4%   25.5%   27.3%   28.8%   28.0%    
 
Operating Expenses as % of Net Sales 12.9%   12.6%   13.2%   11.9%   13.8%    
 
Other Income (Expense) $(822)   $(187)   $177   $310   $150    
 
Interest Rate on Borrowings NA   NA   NA   NA   NA    
 
Interest Rate on Subordinated Debt NA   NA   NA   NA   NA    
 
Income Tax Rate 40.8%   7.4%   0.0%   0.0%   0.0%    
 
Cash $3,120   $551   $765   $650   $669    
 
Number of Days Sales in Accounts Receivable 54.2   62.2   63.5   63.0   65.5    
 
Number of Days Cost of Goods Sold in Inventory 63.8   53.5   57.9   65.0   88.7    
 
Other Current Assets $601   $411   $308   $380   $380    
 
Intangibles $0   $0   $0   $0   $0    
 
Investments $0   $0   $0   $0   $0    
 
Other Assets $214   $373   $373   $749   $600    
 
Current Maturities $653   $5,049   $1,744   $2,327   $2,327    
 
Number of Days Cost of Goods Sold in Accounts Payable 28.4   31.1   24.0   30.0   31.0    
 
Number of Days Operating Expenses in Accrued Expenses 221.4   213.4   163.2   165.0   170.0    
 
Taxes Payable $0   $0   $0   $0   $0    
 
Other Current Obligations $0   $0   $0   $0   $0    
 
Other Current Liabilities $415   $0   $0   $0   $0    
 
Term Loan $2,986   $14,742   $17,476   $17,396   $17,396    
 
Subordinated Debt $0   $0   $0   $0   $0    
 
Other Long Term Obligations $0   $0   $0   $0   $0    
 
Other Liabilities $1,850   $292   $78   $0   $0    
 
Common Stock $5,239   $1   $1   $1   $1    
 
Preferred Stock $0   $0   $0   $0   $0    
 
Other Equity $0   $0   $0   $0   $0    
 
Treasury Stock $0   $0   $0   $0   $0    
 
Capital Expenditures (Net) $987   $2,128   $1,818   $3,210   $532    
 
Dividends as % of Net Earnings 0.0%   502.8%   12.0%   40.0%   63.3%    
 
Depreciation (Net) $1,395   $1,176   $1,224   $1,592   $531    
 
Estimated Borrowing Base as a % of Accounts Receivable 80.0%   80.0%   80.0%   80.0%   80.0%    
 
Estimated Borrowing Base as a % of Inventory 35.0%   35.0%   35.0%   35.0%   35.0%    
 
Estimated Borrowing Base as a % of
      Property, Plant and Equipment (Net)
50.0%   50.0%   50.0%   50.0%   50.0%    
 
Common Shares Outstanding (Fully Diluted) 100   100   100   100   100