Year Ended December 31, 1994 1995 1996 1997 1998 1999
Year Ended December 31, 1994 1995 1996 1997 1998 1999
Year Ended December 31, 1994 1995 1996 1997 1998 1999
Expense Adjustments
Non-Recurring Items 0 36 52 -3 40 -6
Directors Wages and Fees 42 40 83 78 64 74
Professional Fees 24 44 68 140 143 123
Terminated Operations 0 0 0 236 41 0
Contributions and Other Items 0 2 3 4 41 28
Adjusted Pre-Tax Income 391 400 537 1,135 1,544 1,665
a Projections include only current HDC properties, and include no assumptions regarding additional future acquisitions.
b Includes Rent, Insurance, Real Estate Taxes, and other Tax Expenses.
c Includes $50,000 in claim settlement in 1996; $189,000 in losses on a club termination in 1997; $40,000 in purchase financin
d Figure includes $80,000 and $528,000 of losses for the company’s new Andover facility for 1999 and 2000, respectively.
e Does not reflect a full year of ownership of HDC’s Lexington facility, which would result in an additional $200,000 of EBITDA
ber 31,
2000a 2001a 2002a
0 0 0
91 96 102
126 130 130
0 0 0
17 19 22
1,946 2,307 2,948
future acquisitions.
As of
September 30, 1999
Assets
Current assets
Cash and Marketable Securities 997
Accounts receivable 226
Inventory 21
Prepaid and Other Current Items 127
Total Current Assets 1,371
Property, Plant and Equipment
Property and Equipment 12,047
Construction in Progress 1,320
Total Property, Plant and Equipment 13,367
Less: Accumulated Depreciation (3,349)
Net Property and Equipment 10,018
Other Assets 716
Total Assets 12,105
Multiple 5 5
Plus:
Excess Cash 750
Less:
Corporate debt (excluding Lexington) 1,917 1,917
Lexington real estate debt 5,750 0
Assumptions Considered
Discount rate 10.00%
Marginal tax rate 40.00%
Life of Lexington real estate(assumed)in Years 25.00
Lexington real estate depreciation(Straight line Method) 260,000.00
Leasing
Lease payment 925,000.00
Expected growth in lease payments 5.00%
at 8.75%
Leasing
Leasing Expense 925,000.00
Tax @ 40% 370,000.00
Incremental cash flow 555,000.00
Net Present value (11,100,000.00)
7 8
260000 260000
104000 104000
53368.4442959935 48516.76754181
Tax shield @ 40% PV of tax shield Year Depreciation Tax shield @ 40% PV of tax shield
104000 44106.15231074 17 260000 104000 20575.84556561
104000 40096.50210067 18 260000 104000 18705.31415056
104000 36451.36554606 19 260000 104000 17004.83104596
104000 33137.60504188 20 260000 104000 15458.93731451
104000 30125.09549262 21 260000 104000 14053.57937683
104000 27386.45044783 22 260000 104000 12775.98125166
104000 24896.77313439 23 260000 104000 11614.5284106
104000 22633.43012218 24 260000 104000 10558.66219146
25 260000 104000 9598.783810415
13 14 15 16 17 18 19
260000 260000 260000 260000 260000 260000 260000
104000 104000 104000 104000 104000 104000 104000
30125.09549 27386.45045 24896.77313 22633.43012 20575.84557 18705.31415 17004.83105
20 21 22 23 24 25
260000 260000 260000 260000 260000 260000
104000 104000 104000 104000 104000 104000
15458.93731 14053.57938 12775.98125 11614.52841 10558.66219 9598.78381
Multiple Approach
Owing Leasing
Revenue 3,900,000.00 3,900,000.00
Expenses 0.00 925,000.00
EBITDA 3,900,000.00 2,975,000.00
Multiple 5 5
Project value 19,500,000.00 14,875,000.00
Debt 5,750,000.00 0.00
Excess cash 0.00 750,000.00
Equity Value 13,750,000.00 15,625,000.00
Result The purchase decision is not value additon method by multiple approach
ultiple approach
Proposed Solution (in Case)
Lease Payments must exceed repayments by 110%
Lease Payments 525,000.00 (Assumption: bank repayment
Annual bank repayment 477,272.73
Amount of bank loan 3,131,552.48