Main  /  Members  /  Demo Company  /  LBO Scenario #1a, Case 1  /  Financial Management Report

Financial Management Report
Demo Company
LBO Scenario #1a, Case 1
(Dollars and Shares in Thousands, Except Per Share Amounts)

  Actual   Forecast   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		  
 
1.    Working Capital Management:                   
                   
Net Working Capital:                   
                   
Current Assets$12,284  $10,421  $10,527  $12,717  $13,099  $14,937  $16,935  $20,075  $23,811  $28,255 
Current Liabilities(5,269)  (9,696)  (5,231)  (6,715)  (6,595)  (9,835)  (11,164)  (13,175)  (13,679)  (66,807) 
 
Net Working Capital$7,015  $725  $5,296  $6,002  $6,504  $5,102  $5,771  $6,900  $10,132  $(38,552) 
 
                   
                   
Current Ratio:                   
                   
Current Assets, divided by Current Liabilities2.33  1.07  2.01  1.89  1.99  1.52  1.52  1.52  1.74  0.42 
                   
                   
Quick Ratio:                   
                   
Cash plus Accounts Receivable divided by Current Liabilities1.47  0.65  1.23  1.10  1.03  0.88  0.86  0.87  1.00  0.24 
                   
                   
Net Working Capital Turnover:                   
                   
Net Sales, divided by Net Working Capital4.46  46.70  6.17  6.50  5.23  9.14  9.64  9.63  7.83  (2.46) 
                   
                   
2.    Asset Management:                   
                   
Number of Days Sales in Accounts Receivable                   
                   
Accounts Receivable, divided by Net Sales/36554.2  62.2  63.5  63.0  65.5  63.0  63.0  63.0  63.0  63.0 
                   
                   
Number of Days Cost of Goods Sold in Inventory                   
                   
Inventory, divided by Cost of Goods Sold / 36563.8  53.5  57.9  65.0  88.7  65.0  65.0  65.0  65.0  65.0 
                   
                   
Capital Expenditures (Net):                   
                   
Ending Property, Plant and Equipment, minus Beginning Property, Plant and Equipment$987  $2,128  $1,818  $3,210  $532  $3,210  $3,210  $3,210  $3,210  $3,210 
                   
                   
Depreciation (Net):                   
                   
Ending Accumulated Depreciation, minus Beginning Accumulated Depreciation$1,395  $1,176  $1,224  $1,592  $531  $1,592  $1,592  $1,592  $1,592  $1,592 
                   
                   
Net Property, Plant and Equipment:                   
                   
Property, Plant and Equipment, minus Accumulated Depreciation$10,205  $11,157  $11,751  $13,369  $13,370  $14,987  $19,618  $21,236  $22,854  $24,472 
                   
                   
Fixed Asset Turnover:                   
                   
Net Sales, divided by Net Property, Plant and Equipment3.07  3.04  2.78  2.92  2.54  3.11  2.84  3.13  3.47  3.87 
                   
                   
Total Asset Turnover:                   
                   
Net Sales, divided Total Assets1.38  1.54  1.44  1.46  1.26  1.47  0.61  0.73  0.85  0.99 
                   
                   
3.    Liabilities Management:                   
                   
Number of Days Cost of Goods Sold in Accounts Payable                   
                   
Accounts Payable, divided by Cost of Goods Sold / 36528.4  31.1  24.0  30.0  31.0  30.0  30.0  30.0  30.0  30.0 
                   
                   
Number of Days Operating Expenses in Accrued Expenses:                   
                   
Accrued Expenses, divided by Operating Expenses / 365221.4  213.4  163.2  165.0  170.0  165.0  165.0  165.0  165.0  165.0 
                   
                   
Current Maturities:                   
                   
Current Maturities of Long Term Debt$653  $5,049  $1,744  $2,327  $2,327  $2,327  $1,900  $1,900  $1,900  $1,900 
                   
                   
Long Term Liabilities, as % of Total Assets:                   
                   
Total Long Term Liabilities, divided by Total Assets21.3%  68.5%  77.5%  64.8%  64.3%  47.6%  68.7%  65.9%  62.8%  2.0% 
                   
                   
Total Liabilities, as % of Total Assets:                   
                   
Total Liabilities, divided by Total Assets44.5%  112.7%  100.6%  89.8%  88.6%  78.6%  81.0%  80.3%  77.5%  72.0% 
                   
                   
Debt-to-Worth Ratio:                   
                   
Total Liabilities, divided by Owners' Equity0.80  (8.90)  (170.04)  8.85  7.79  3.68  4.27  4.08  3.44  2.58 
                   
                   
4.    Profitability Management:                   
                   
Gross Margin on Sales:                   
                   
Net Sales, minus Cost of Goods Sold$8,872  $8,639  $8,923  $11,250  $2,380  $13,705  $16,641  $20,268  $24,677  $30,032 
                   
                   
Gross Margin %:                   
                   
Gross Margin on Sales, divided by Net Sales28.4%  25.5%  27.3%  28.8%  28.0%  29.4%  29.9%  30.5%  31.1%  31.7% 
                   
                   
Operating Earnings:                   
                   
Gross Margin on sales, minus Operating Expenses$4,820  $4,361  $4,619  $6,595  $1,205  $8,205  $10,279  $12,734  $15,752  $19,551 
                   
                   
Operating Earnings %:                   
                   
Operating Earnings, divided by Net Sales15.4%  12.9%  14.1%  16.9%  14.2%  17.6%  18.5%  19.2%  19.9%  20.6% 
                   
                   
Earnings Before Interest, Taxes, Depreciation and Amortization of Intangible Assets (Referred to as "EBITDA")                   
                   
Net Earnings, plus Interest Expense, plus Income Tax Expense, plus Depreciation, plus Amortization of Intangible Assets ("EBITDA")$5,493  $5,450  $6,120  $8,697  $1,936  $10,107  $11,871  $14,326  $17,344  $21,143 
                   
                   
EBITDA as % of Net Sales:                   
                   
EBITDA, divided by Net Sales17.6%  16.1%  18.7%  22.3%  22.8%  21.7%  21.3%  21.6%  21.9%  22.3% 
                   
                   
Earnings Before Income Taxes:                   
                   
Net Earnings, plus Income Taxes$3,635  $2,718  $3,007  $4,763  $964  $6,741  $(1,466)  $1,272  $4,458  $8,602 
                   
                   
Net Earnings Per Share:                   
                   
Net Earnings, divided by Common Shares Outstanding$21.51  $25.17  $30.07  $47.63  $9.64  $67.41  $(9.67)  $8.39  $29.42  $56.77 
                   
                   
Earnings Before Income Taxes as % of Net Sales:                   
                   
Earnings Before Income Taxes, divided by Net Sales11.6%  8.0%  9.2%  12.2%  11.3%  14.5%  (2.6)%  1.9%  5.6%  9.1% 
                   
                   
Net Earnings as % of Net Sales:                   
                   
Net Earnings, divided by Net Sales6.9%  7.4%  9.2%  12.2%  11.3%  14.5%  (1.7)%  1.3%  3.7%  6.0% 
                   
                   
5.    Debt Management:                   
                   
Senior Interest Expense:                   
                   
Interest on Line of Credit, plus Interest on Term Loan$363  $1,456  $1,789  $2,142  $391  $1,774  $1,380  $1,096  $928  $583 
                   
                   
Non-Senior Interest Expense:                   
                   
Interest on Subordinated Debt$0  $0  $0  $0  $0  $0  $6,558  $6,558  $6,558  $6,558 
                   
                   
Total Interest Expense:                   
                   
Senior Interest Expense, plus Non-Senior Interest Expense$363  $1,456  $1,789  $2,142  $391  $1,774  $7,938  $7,654  $7,486  $7,141 
                   
                   
EBITDA Coverage of Senior Interest Expense:                   
                   
EBITDA, divided by Senior Interest Expense15.13  3.74  3.42  4.06  4.95  5.70  8.60  13.07  18.69  36.27 
                   
                   
EBITDA Coverage of Total Interest Expense:                   
                   
EBITDA, divided by Total Interest Expense15.13  3.74  3.42  4.06  4.95  5.70  1.50  1.87  2.32  2.96 
                   
                   
Required Debt Service:                   
                   
Total Interest Expense, plus Current Maturities$1,016  $6,505  $3,533  $4,469  $2,718  $4,101  $9,838  $9,554  $9,386  $9,041 
                   
                   
EBITDA Coverage of Required Debt Service:                   
                   
EBITDA, divided by Required Debt Service5.41  0.84  1.73  1.95  0.71  2.46  1.21  1.50  1.85  2.34 
                   
                   
EBITDA minus Capex, divided By Required Debt Service:                   
                   
EBITDA minus Capital Expenditures, divided by Required Debt Service4.44  0.51  1.22  1.23  0.52  1.68  0.88  1.16  1.51  1.98 
                   
                   
Free Cash Flow:                   
                   
Net Earnings, plus Depreciation minus Capital Expenditures, minus Dividends$2,559  $(11,091)  $2,051  $1,240  $353  $2,427  $(2,585)  $(778)  $1,324  $4,059 
                   
                   
Cash Available for Debt Service:                   
                   
Free Cash Flow, plus Total Interest Expense$2,922  $(9,635)  $3,840  $3,382  $744  $4,201  $5,352  $6,875  $8,810  $11,200 
                   
                   
Debt Service Coverage:                   
                   
Cash Available for Debt Service, divided by Required Debt Service2.88  (1.48)  1.09  0.76  0.27  1.02  0.54  0.72  0.94  1.24 
                   
                   
6.    Estimated Bank Credit Availability:                   
                   
Borrowing Base Assets:                   
                   
Accounts Receivable$4,647  $5,766  $5,685  $6,738  $6,100  $8,046  $9,607  $11,470  $13,695  $16,352 
Inventory3,916  3,693  3,769  4,949  5,950  5,861  6,948  8,225  9,736  11,523 
Property, Plant and Equipment (Net)10,205  11,157  11,751  13,369  13,370  14,987  19,618  21,236  22,854  24,472 
                   
                   
Estimated Borrowing Base %:                   
                   
Accounts Receivable80.0%  80.0%  80.0%  80.0%  80.0%  80.0%  80.0%  80.0%  80.0%  80.0% 
Inventory35.0%  35.0%  35.0%  35.0%  35.0%  35.0%  35.0%  35.0%  35.0%  35.0% 
Property, Plant and Equipment50.0%  50.0%  50.0%  50.0%  50.0%  50.0%  50.0%  50.0%  50.0%  50.0% 
                   
                   
Estimated Amount Available to Borrow:                   
                   
Accounts Receivable$3,718  $4,613  $4,548  $5,390  $4,880  $6,437  $7,686  $9,176  $10,956  $13,082 
Inventory1,371  1,293  1,319  1,732  2,082  2,051  2,432  2,879  3,408  4,033 
Property, Plant and Equipment5,102  5,578  5,876  6,684  6,685  7,494  9,809  10,618  11,427  12,236 
 
 $10,191  $11,484  $11,743  $13,806  $13,647  $15,982  $19,927  $22,673  $25,791  $29,351 
                   
                   
Loans Outstanding:                   
                   
Line of Credit$0  $0  $0  $0  $0  $2,317  $3,181  $4,073  $3,251  $54,851 
Current Maturities653  5,049  1,744  2,327  2,327  2,327  1,900  1,900  1,900  1,900 
Term Loan2,986  14,742  17,476  17,396  17,396  15,069  7,600  5,700  3,800  1,900 
 
 $3,639  $19,791  $19,220  $19,723  $19,723  $19,713  $12,681  $11,673  $8,951  $58,651 
                   
                   
Estimated Net Bank Borrowing Availability:                   
                   
Estimated Amount Available to Borrow, minus Loans Outstanding$6,552  $(8,307)  $(7,477)  $(5,917)  $(6,076)  $(3,731)  $7,246  $11,000  $16,840  $(29,300)