17020841116
17020841116
17020841116
08/23/2018
Operating Expenses
Selling Expenses 2,750.0 2,868.0 2,875.0 3,570.0 3,250.0
Admin & Other Expenses 5,805.0 5,900.0 5,802.0 6,120.0 6,054.0
Rent & Maintenance 1,350.0 1,357.0 1,350.0 1,380.0 1,390.0
Total Operating Expenses 9,905.0 10,125.0 10,027.0 11,070.0 10,694.0
% of Sales 14.5% 14.1% 13.3% 14.1% 13.1%
Assets
Cash and Marketable Securities 4,382.2 7,941.2 9,706.1 12,505.9 9,372.8
Accounts Receivable 5,137.7 5,754.2 6,721.6 6,990.5 7,515.1
Inventory 7,956.8 8,409.9 8,946.6 9,425.3 14,912.5
Fixed Assets 11,415.0 10,623.5 11,411.2 11,260.0 10,984.0
Total Assets 28,891.7 32,728.8 36,785.5 40,181.7 42,784.5
Notes:
* Sales and EBITDA are from the final year before the date of the deal.
** Price is for the entire firm (enterprise value).
PROJECTIONS
Operating Expenses
90,630.2
2.00%
66,780.0
73.7%
23,850.2
26.3%
3,897.1
4.3%
6,706.6
7.4%
1,540.7
1.7%
12,144.5
13.4%
11,705.8
12.9%
(1099.0)
(1100.0)
(444.3)
25%
PRECEDENT TRANSACTIONS ANALYSIS
All figures are in $000's
Target Company Date Sales* EBITDA* Price** Description EBITDA Mu
Aristocrat Products Apr-08 135,000.0 14,850.0 $ 81,675 Automotive care
Franston Dec-12 120,000.0 7,200.0 $ 36,000 Automotive care
Specialty Care Nov-11 98,000.0 5,880.0 $ 28,224 Automotive care
Direct All Jun-10 365,000.0 29,200.0 $ 292,000 Automotive care
Venator Jul-14 75,000.0 7,500.0 $ 35,250 Automotive care
Notes:
* Sales and EBITDA are from the final year before the date of the deal.
** Price is for the entire firm (enterprise value).
6.0x
5.0x
Estimated Value of Buck Auto Care Products
DCF 2016F 2017F 2018F 2019F 2020F
WACC Calculation
Weighting: Amounts %
Debt (Wd) 16,385.6 38.3%
Equity (We) 26,398.9 61.7%
Tax rate (t) 25.0%
Cost of Equity (Ke) 22.50%
Cost of Debt Before-Tax 6.00%
Cost of Debt After-Tax (Kd) 4.50%
WACC(Kc) 15.61%
Growth after 20 1.50%
Present Value (PV) of FCFs
Discount Factor 0.87 0.75 0.65 0.56 0.48
PV of FCF 3,703.9 4,121.2 4,036.4 3,552.6 3,280.9
Total PV of FCFs $ 18,694.9
Using
Multiple Using FCFF growth
Terminal Value Calculation Approach Approach
58528.89 48746.9622130832
PV 28344.0192 23606.8841654144
Ke $ 42,301.83
20%
21%
22%
23%
24%
25%
28530
Estimated Value of Buck Auto Care Products
DCF 2016F 2017F 2018F 2019F 2020F
WACC Calculation
Weighting: Amounts %
Debt (Wd) 16,385.6 38.3%
Equity (We) 26,348.9 61.7%
Tax rate (t) 25.0%
Cost of Equity (Ke) 22.50%
Cost of Debt Before-Tax 6.00%
Cost of Debt After-Tax (Kd) 4.50%
WACC(Kc) 15.60%
Growth after 20 1.50%
Present Value (PV) of FCFs
Discount Factor 0.87 0.87 0.87 0.87 0.87
PV of FCF 4,521.8 5,595.6 6,244.2 6,341.9 6,725.9
Total PV of FCFs $ 29,429.4
Using
Using FCFF
Multiple growth
Terminal Value Calculation Approach Approach
58528.89 55975.52
PV 28353.9088 27116.9469
Ke $ 56,546.32
20%
21%
22%
23%
24%
58528.894521897
Estimated Value of Buck Auto Care Products
DCF 2016F 2017F 2018F 2019F 2020F
WACC Calculation
Weighting: Amounts %
Debt (Wd) 13,500.0 33.8%
Equity (We) 26,398.9 66.2%
Tax rate (t) 25.0%
Cost of Equity (Ke) 22.50%
Cost of Debt Before-Tax 6.00%
Cost of Debt After-Tax (Kd) 4.50%
WACC(Kc) 16.41%
Growth after 20 1.50%
Present Value (PV) of FCFs
Discount Factor 0.86 0.74 0.63 0.54 0.47
PV of FCF 3,159.8 3,491.6 3,396.2 2,968.4 3,169.2
Total PV of FCFs $ 16,185.2
Using
Multiple Using FCFF growth
Terminal Value Calculation Approach Approach
46120.7891107404
Ke 62305.969
20%
21%
22%
23%
24%
25%
Terminal
58528.8945218972