Frank Spence Case Harvard Case Solution & Analysis

Frank Spence Case Case Study Solution

Valuation

Frank’s business evaluation was performed by using discounted cash flow method. The estimations have been taken from 1995 till 2000 giving us 6 annual periods to work with. Forecasting procedure has been conducted after incorporating sales growth of 3% as assumed by Frank. Furthermore, according to him, the operating income would increase by 18% each year hence, giving us EBIT for each year. Subsequently, the free cash flow for each year has been calculated in the case. Moving forward, Chris had used different rate of return, 12%, 15% and 18%, as he thought 15% WACC might be controversial. Continuing with that, discounted cash flow has been calculated using all the three rate of return. This has been shown in exhibit 1. From the table, it can be seen that discounted free cash flows for 12% return are the highest.

After that, NPV of the three cash flows has been calculated as $9555, 000 for 12% rate, $6412, 000 or 15% rate and $4487, 000 for 18% rate of return. The total debt of the business is $2939, 000 which is subtracted from the three enterprise values. The subtraction has given us a range for worth of equity which is $8,187,000 till $1,787,000. The range can be negotiated in the deal by the buyer and Frank. Exhibit 3 shows the range of equity value.

Recommendations

Frank spencer is looking for the best price to sell of its small distribution company and to enjoy his retirement. In an effort to do so he has used his contact to discuss the issue with Chris Saunders, working in First United. Chris has asked the mergers and acquisition department of his bank to further discuss about mergers and acquisition. While discussing about the valuation process, Chris has asked Frank about the future projections, by using which the future six years forecasting has been completed. After valuation through DCF method, it can be seen that equity valuation for the different WACCs has given us a range from $8,187,000 till $1,787,000.

The company’s small size doesn’t allow it to get listed on the stock exchange therefore valuation has to be conducted in a different way. It is recommended that Frank and Chris should have adopted the benchmark evaluation method to compare his prices and valuation with others and hence Frank could’ve sold his product after looking at close competitors.

Exhibits

Exhibit 1

0123456Terminal Value
1994199519961997199819992000
EBIT (Operating Income) $4,971 $4,993 $5,143 $5,297 $5,456 $5,620 $5,788 $5,788
tax $1,997 $2,057 $2,119 $2,182 $      2,248 $      2,315 $                 2,315
Free Cash Flow $1,559 $2,959 $3,047 $      3,139 $3,232 $3,329 $3,429 $                 3,473
Discounted free cash flow (12%) $        1,559 $             2,642 $              2,429 $      2,234 $      2,054 $      1,889 $      1,737 $                 1,760
Discounted free cash flow (15%) $        1,559 $             2,297 $              1,837 $      1,469 $      1,174 $         939 $         751 $                    761
Discounted free cash flow (18%) $        1,559 $             1,947 $              1,319 $         894 $         606 $         411 $         278 $                    282

Exhibit 2

Drug Wholesalers  Publicly Traded Company Analysis
($ In Millions)
Rank        Company              State5/30196
Stock Price
Market Value (A) of EquityNot Debt(B)Enterprise Value (C)LTM
Sales
LTM
Operating Margin (D)
Enterprise Value Multiple: Forward                                  Operating
PIE          Sales   EBITDA    Income
Market Value      Multiple Net             Book
Income          Value
1McKesson Corp. (MCK)(E)CA$43.63$1,916.40$485.60$2.402.0$13,189.001.9%14.400.18 x7.37 x9.58 x14.41 x1.83 x
2Bergen Brunswig Corp. (BBC)CA22.580882.4406.21,288.67,871.01.6%13.800.169.2510.4714.011.87
3Cardinal Health Inc. (CAH)OH46.0001,926.0325.42,251.45.790.02.4%22.550.3913.6816.1055.033.85
4FoxMeyer Health Corp. (FOX)TX18.125308.5320.3628.85,177.01.1%9.800.125.9210.687.340.61
5AmeriSource Health Corp. (ASHPA22.250300.4620.3920.74.726.02.0%NM0.198.719.73NMNM
6Brindle Western Industries (BINDIN15.500167.9166.2334.14,231.00.8%11.570.087.9510.2811.190.93
7Owens & Minor Inc. HIdg. (OMI)(VA13.000399.2323.3722.52.752.02.0%15.850.2610.4712.9010.541.59
8D & K Wholesale Drug Inc. (DKWMO6.12516.517.333.8320.01.2%12.010.116.918.9016.542.36
9Moore Medical Corp. (MMD)CT11.37532.623.756.2277.02.7%9.250.206.257.5010.841.41
High2.7%22.550.3913.6816.1055.033.85
Mean1.7%13.650.198.5010.6817.491.81
Median1.9%12.910.187.9510.2812.601.71
Low
0.8%9.250.085.927.507.340.61

Exhibit 3

12%15%18%
 NPV of Cash Flow $   9,555.33 $        6,412.64 $         4,487.63
 NPV of Terminal Value $   1,571.01 $           661.47 $            238.80
Enterprise Value $ 11,126.34 $        7,074.12 $         4,726.43
Debt $   2,939.00 $        2,939.00 $         2,939.00
Equity Value $   8,187.34  $        4,135.12  $         1,787.43

Exhibit 4

cost of debt8.2%
cost of equity17.6%
debt $             2,939.00
equity4552
tax40%
wd0.39
We0.61
WACC12.62%
Other Similar Case Solutions like

Frank Spence Case

Share This