Main  /  Demo  /  Demo Menu  /  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/07  
 12 Months  
12/31/08  
 12 Months  
12/31/09  
 9 Months  
09/30/10  
   12 Months  
12/31/10  
 12 Months  
12/31/11  
 12 Months  
12/31/12  
 12 Months  
12/31/13  
 12 Months  
12/31/14  
 
Year-to-Year Change in Net Sales NA   55.4%   5.8%   NA    
 
Gross Margin % 25.3%   27.3%   30.4%   28.2%    
 
Operating Expenses as % of Net Sales 12.8%   11.2%   11.8%   13.2%    
 
Other Income (Expense) $(32)   $(16)   $(20)   $(36)    
 
Interest Rate on Borrowings NA   NA   NA   NA    
 
Interest Rate on Subordinated Debt NA   NA   NA   NA    
 
Income Tax Rate 6.9%   33.6%   30.0%   32.4%    
 
Cash $61   $102   $101   $353    
 
Number of Days Sales in Accounts Receivable 94.4   92.8   102.1   94.6    
 
Number of Days Cost of Goods Sold in Inventory 149.6   123.5   124.0   191.9    
 
Other Current Assets $75   $79   $86   $117    
 
Intangibles $563   $561   $572   $1,445    
 
Investments $0   $0   $0   $0    
 
Other Assets $48   $69   $62   $107    
 
Current Maturities $9   $69   $7   $22    
 
Number of Days Cost of Goods Sold in Accounts Payable 44.5   45.9   30.9   57.0    
 
Number of Days Operating Expenses in Accrued Expenses 265.8   272.8   202.4   217.8    
 
Taxes Payable $55   $70   $46   $70    
 
Other Current Obligations $0   $0   $0   $0    
 
Other Current Liabilities $158   $252   $183   $271    
 
Term Loan $527   $502   $500   $1,487    
 
Subordinated Debt $0   $0   $0   $0    
 
Other Long Term Obligations $161   $218   $198   $229    
 
Other Liabilities $50   $53   $82   $92    
 
Common Stock $672   $679   $688   $1,056    
 
Preferred Stock $0   $0   $0   $0    
 
Other Equity $(3)   $(96)   $(2)   $(18)    
 
Treasury Stock $(1)   $(1)   $(1)   $(1)    
 
Capital Expenditures (Net) NA   $87   $63   $110    
 
Dividends as % of Net Earnings 0.0%   0.0%   0.0%   0.0%    
 
Depreciation (Net) NA   $9   $37   $20    
 
Estimated Borrowing Base as a % of Accounts Receivable 80.0%   80.0%   80.0%   80.0%    
 
Estimated Borrowing Base as a % of Inventory 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%    
 
Common Shares Outstanding (Fully Diluted) 70   75   76   81