BE Aerospace Case Solution
BE Aerospace Case Solution
BE Aerospace Case Solution
University of Dhaka
Course Name: Cases in Financial Decision Making
Course Code: F-506
Report on “Optimum Capital Structure of B/E Aerospace. INC”
Submitted to:
Submitted by:
GROUP#08
Section: B
Batch: 21st
Department of Finance
University of Dhaka
We have tried sincerely to comprehend and translate our knowledge in writing this report. We
enjoyed this group work and gladly attend any of your calls to clarify on our point, if necessary.
Hope you would find the report in appropriate manner.
Sincerely yours,
__________________
On behalf group no 8
Faima Akter
Roll no: 21-911, Section: B
Batch: 21st
Department of Finance,
University of Dhaka.
Acknowledgement
It is a pleasure for us to submit this report to our respected teacher Dr. Gazi Mohammad Hasan
Jamil, Associate Professor, Department of Finance, University of Dhaka. At first we want to
convey our thanks and gratitude to him for assigning us to prepare the report. It would not have
been possible for us to complete the report without his help.
In preparing this report, we got full co-operation from our group-mates and that was a great
advantage for us. We would like to thank all the members of our group who helped us sincerely
from every aspect. An individual can achieve no noble achievement by his/her alone trial. We
are indebted to a number of persons for their kind recommendation, direction, co-operation and
their collaboration.
All of the efforts ended at a desired point for the co-operation and hard work, sincerity and
seriousness of our group members and our combined effort was really helpful for making this
report. So, all of them as well as our group members are worth of pure compliment.
Executive Summary
Methodology
We have used the information available in the case and some website to find out the value for
each share. The case published by University of Virginia on “Optimum Capital Structure of B/E
Aerospace Inc.”. In case of unavailability of any information, we have used our judgment and
realistic assumption.
Chapter 01: Case Overview
Chapter 02: Economic Analysis
Chapter 03: Industry Analysis
Chapter
Chapter
04: Company
04: Valuation
Analysis
Chapter 05: Valuation on
Different Alternatives
Absolute Valuation
To find out the optimal capital structure of B/E Aerospace Inc. we have calculated intrinsic value
of B/E Aerospace based on the forecasted period from 2005-2009. For the purpose of this
valuation we have first of all converted the fiscal year ended to calendar year ended. We need
same level of data to maintain the consistency. For our valuation we have taken some
assumptions which are tabulated below:
Assumptions
1 Fixed Asset percentage 75%
Short term asset percentage 25%
Total Asset 100%
2 Risk Free Rate (3 years Treasury Notes) 3.51%
3 Annual terminal growth rate 6.50%
United states GDP growth rate 3.80%
United states Inflation rate 2.70%
4 Long term asset will remain fixed after 2014
5 Working Capital will increase at the rate of sales growth rate 10%
We have calculated WACC to different capital Structure. The calculation is shown below:
To calculate the market return monthly price data of NASDAQ index has been taken from year
1990-2004.
Table: Value per share for base scenario Amount in million USD
Simulation tells us how different change in an independent variables change the dependent
variables remaining other things constant. On the other hand sensitivity analysis tells us how 1%
changes in independent variables change the dependent variable.
We have also run simulation model and sensitivity analysis in the base case with the help of
Crystal ball. In this case our dependent variable is Value per share and the independent variables
are sales growth rate, tax rate, terminal growth rate, depreciation rate and WACC. The result is
as follows:
Here we can see that at 95% confidence level value per share will be within the range of 2.70 to
24.43. That means all the independent variables separately holding ceteris paribus condition will
make the furcating variables within the range of those values if the simulation is conducted
10000 times.
Relative Valuation
As all competitor data was not available so we couldn’t calculate some value for relative
valuation. As Boeing is not perfect competitor so we couldn’t take this company’s data. Other
two companies C&D and Britax are both private companies. So they cannot be considered for
relative valuation. That’s why we have considered Zodiac for our relative valuation. Result is
shown as follows:
Zodiac Aerospace
Share Number 52775425
Price in 2004 6.57
Sales 400
Sales in Euro 544000000
Sales Per Share 10.30782793
price to sales 0.637379673
Sales of B/E 10.45045045
Price Per share 6.660904693
Overvalued
As we already know the share price in 2004 is 10.2 relative price is 6.66 we the share is
overvalued in the market.
Chapter 06: Alternative
Courses of Actions
Alternative scenarios
Some alternative scenarios of the capital structure of B/E Aerospace Incorporation have been
considered and based on these scenarios financial information are forecasted to calculate the
value per share. These scenarios are
$50 million from the available cash can be used to repay debt
$100 million worth of shares can be issued to repay debt and reduce the interest expense
The company can repurchase some stocks when cash becomes available
Addition of deferred tax to the equity
The company may face a terrorist attack in 2005
Alternative 1: Repayment of debt worth of $50 million from available cash
Table: Calculation of WACC
After the repayment, the amount of total debt is reduced to USD 629 million from USD 679
million. Total amount of equity has remained unchanged. New weight of debt is 78% and weight
of equity is 22%. Weighted average cost of capital is 12.01%.
Table: Value per share after the repayment of debt Amount in million USD
Change in the capital structure leads the value per share of the company to $7.38. Comparing
with the current share price it can be concluded that the shares of the company are overvalued.
Alternative 2: Issuing $100 million worth of shares to repay debt and reduce
the interest expense
Table: Calculation of WACC
After the new issue of stock and repayment of debt with the issued money, the total amount of
debt reduced to USD 579 million and value of equity increased to USD 280 million. New weight
of debt is 67% and weight of equity is 33%. Weighted average cost of capital is 13.55%.
Table: Value per share after the issue of new stock Amount in million USD
Table: Value per share after the stock repurchase Amount million USD
Though the intrinsic value of the share seems good after stock repurchase, it can create serious
liquidity issue for the company because this strategy will reduce the cash balance significantly.
Management believes that addition of USD 75 million deferred tax will result in a one-time
income benefit. It will increase the equity to USD 255 million.
Table: Value per share after the addition of deferred tax Amount million USD
The FCFF valuation based on the information, if the fourth alternative is chosen, shows that the
price per share of B/E Aerospace Incorporation should be $5.98. However, the current market
price of the share is $10.20. This indicates that the shares are overvalued.
Table: Value per share when there is no change in capital structure Amount million USD
Table: Value per share when $50 million USD is used to repay debt Amount in million USD
Table: Value per share when deferred tax is added to equity Amount in million USD
Table: Value per share when $50 million USD worth of shares is issued to repay debt (Amount in million
USD)
We have also run simulation and sensitivity analysis in the case of Terrorist Attack. . In this case
our dependent variable is Value per share and the independent variables are sales growth rate, tax
rate, terminal growth rate, depreciation rate and WACC. The result is as follows:
Here we can see that at 95% confidence level value per share will be within the range of .12 to
10.28. That means all the independent variables separately holding ceteris paribus condition will
make the furcating variables within the range of those values if the simulation is conducted
100000 times.
In sensitivity Chart we see that only two variables are affecting the values of share price
significantly. One is WACC and the other is terminal growth rate. For one % change of WACC
the values per share will be decreased by 84%. Again for increasing 1% of terminal growth rate
value per share will decrease by15. 9%.
Decision: Cash Dividend or Repurchase:
In our case manager is also concerned about cash dividend or stock repurchase in case of funds
availability. So we have also considered this issue in our case. First of all to elicit interest in
equity company must have enough positive earning or higher retained earnings. In case of B/E
aerospace both are absent. From 2003 annual reports we have found that this company has large
amount of negative retained earnings. In the forecasted period we can notice that the company
will have negative net income. Adjusting this negative income retained earnings cannot be offset.
In this case giving cash dividend and stock repurchase won’t be a good decision. The forcased
scenario will be as follows:
Retained earnings
-381.00
2003 2004 2005 2006 2007 2008 2009
-382.00
-383.00
Retained earnings
-384.00
-385.00
-386.00
-387.00
Again the company has highest possibility of bankruptcy in near future. So in case of fund
availability they shouldn’t declare cash dividend or repurchase any stock.
Recommendations:
Considering the above valuation and other alternative scenarios we can summarize the result as
follows:
Here we can see that value per share is and value of the firm is higher in case of Stock
Repurchase. But this alternative is not viable, as the company has large amount of negative
earnings and net income. In this case our next alternative is the base case where the company
sold some shares and paid the debt holder of 156million dollar at the end of the base period.
Appendix:
1. Ratings:
Statement of operations data 31/12/2001 31/12/2002 31/12/2003 31/12/2004
Net Sales 678.15 601.5 624.4 725.20
Cost of sales 511.18 417.9 453.6 491.20
Gross Profit 166.97 183.6 170.8 234.00
Operating expenses 0.00 0.00
Selling, general & admin 136.87 144.5 105.8 117.87
Research & development & Engineering 44.40 43.5 44.7 52.00
Operating earnings -14.30 -4.4 20.3 64.13
Interest expenses, net 59.45 69 70.6 79.20
Loss on debt 7.75 0 1.2 0.00
Loos/ Earnings before tax -81.50 -73.4 -51.5 -15.07
Income taxes 1.87 2.7 2 1.87
Net Loss/ Earnings -83.37 -76.1 -53.5 -16.93
Basic net loss/earnings per share 0.00 0 0.00
Net loss/earnings -3.28 -2.327217125 -1.49 -0.31
Weighted Avg. common shares 25.40 32.7 36 55.50
Balance sheet data 2001 2002 2003 2004 2005 2006 2007 2008 2009
Cash and cash equivalents 142.967 156.9 147.6 168.267 118.267
Working capital 283.15 262.9 274.3 85.733 94.30667 103.7373 114.1111 125.5222 138.0744
Total assets 1096.25 1067.1 1052.5 1430.8 1468.854 1510.957 1557.539 1609.076 1666.096
Total debt 813.933 836 882 679 629
Stockholders’ equity 135.3 69.3 31.9 180 255 255 255 255 255
Fixed asset 822.1875 800.325 789.375 1073.1 1073.1 1073.1 1073.1 1073.1 1073.1
Depreciation 42.80 46.80 28.30 28.00 46.27107 46.27107 46.27107 46.27107 46.27107
Chnages in net working capital -20.25 11.4 -188.567 8.573 9.430667 10.37373 11.41111 12.55222
Short term asset 274.0625 266.775 263.125 357.7 395.7542 437.8568 484.4385 535.9759 592.9961
4. Common size:
12/31/2001 12/31/2002 12/31/2003 12/31/2004 Average Balance sheet data 12/31/2001 12/31/2002 12/31/2003 12/31/2004 Average
Net sales 100.00% 100.00% 100.00% 100.00% Cash and cash equivalents 13.04% 14.70% 14.02% 11.76% 13.38%
Cost of sales 75.38% 69.48% 72.65% 67.73% 71.31% Working capital 25.83% 24.64% 26.06% 5.99% 20.63%
Gross profit 24.62% 30.52% 27.35% 32.27% 28.69% Total assets 100% 100% 100% 100% 100%
Operating expenses Total debt 74.25% 78.34% 83.80% 47.46% 70.96%
Selling, general & administrative 20.18% 24.02% 16.94% 16.25% 19.35% Stockholders’ equity 12.34% 6.49% 3.03% 12.58% 8.61%
Research, development & engineering 6.55% 7.23% 7.16% 7.17% 7.03%
Operating earnings -2.11% -0.73% 3.25% 8.84% 2.31%
Interest expenses, net 8.77% 11.47% 11.31% 10.92% 10.62%
Loss on debt extinguishment 1.14% 0.00% 0.19% 0.00% 0.33%
(Loss) Earnings before income taxes -12.02% -12.20% -8.25% -2.08% -8.64%
Income taxes 0.28% 0.45% 0.32% 0.26% 0.33%
Net (loss) earnings -12.29% -12.65% -8.57% -2.33% -8.96%