VALUATION -PROBLEM SOLVING FOR THE CASE STUDY
Name
Institution
Instructor
Course
Date
Question 1
Potential value creation in the transitions:
1. Use of a risk hedging financial contract, the swap.
2. Acquisition of an undervalued target.
3. Evading tax liability.
The management under the advisory of analyst believe that the company requires to make intensive, heavy investments which is not feasible if the Seagate Inc. remains a public company
The other capital reorganisations alternatives are involving significant tax liability and considering the present nature of events that Seagate is a public Company, the tax liability will result to loss of the wealth of the shareholders where the capital restructuring option involves
…show more content…
When, the company status is converted to private, the management will enjoy exorbitant management incentives. The management are the greatest winners because of the informational efficient advantage that they enjoy.
Question 3
Free cash flow, all the assumptions prescribed followed, no additional assumptions is considered.
Question 4
The maximum amount of cash in the LBO is equal to the discounted free cash flows
Given the interest rate of the BBB rated debt is 9.18%, and assuming that the terminal value beyond the 2008 is $ 0.00, we have no model to forecast the future free cash flows beyond 2008
141.3/(1.0981)^ 1+ 708/(1.09.0481)^ 2+ 916/(1.0981)^3 + 924.2/(1.0981)^ 4+ 1124/(1.0981)^5 + 1313.56/(1.0981)^6 + 1440/(1.0981)^ 7 + 1581.82/(1.0981)^8
= 129.5+ 594.3 + 703.8 + 650.4 + 724.52 + 775.5 + 778.68 + 748.2
= $5.1069 Billion.
Seagate is rated as BBB in the credit rating, EBIT coverage in the year 1999 is 8.9%, as per the history of buyout the debt to equity ratio is over 6; 4, since this debt ratio is used to be associated with optimally low cost of overall cost of capital in the technology sector data given.
Question 5
The debt is borrowed between BB and B rated securities, assume the weight of each is 0.5, and there rate are 9.18% and 10.44% respectively.
Let Kd be the cost debt capital, Ke be the cost of equity capital and WACC the overall cost of capital, β is the
($372 + $135 + 500) / ($2.21 - ($0.83 + .40)) = 1,028 [+/- 31]
Company does not have big amount of debt to pay. In 1994 its outstanding debt is only 36.4% of its total assets which is a healthy rate. Its current assets are higher 2.4 times than its current liability. Also company has no outstanding interest to pay. Price earning ratio of 42.80 is highest among the competitors. (Pls. see exhibit 2, 3&4) for details. So we can safely conclude that BBBY has great potential to sustain.
By the end of 1999, Seagate had a BBB credit rating issued by S&P for its long-term debt. Based upon historical operating performance, it would seem that Seagate’s leverage ratio has high volatility due to its high volatility in market value of equity and operational performance. However, we believe that the current leverage ratio is above its optimal leverage because in 1998 the firm had a -2.72 EBIT interest coverage ratio using the greater debt load of $703 million on its books. In the recapitalization for the leveraged buyout, a
What is the correct capital structure and weighted average cost of capital for discounting the investment’s free cash flow?
2. Forecast the firm’s financial statements for 2002 and 2003. What will be the external financing requirements of the firm in those years? Can the firm repay its loan within a reasonable period? In order to forecast the financial statements of 2002 and 2003, the following assumptions need to be made. The growth of sales is 15%, same as 2001, which is estimated by managers. The rate of production costs and expenses per sales is constant to 50%. Administration and selling expenses is the average of last 4 years. The depreciation is $7.8 million per year, which is calculated by $54.6 million divided by 7 years. Tax rate is 24.5%, which is provided. The dividend is $2 million per year only when the company makes profits. Therefore, we assume that there will be no dividend in 2003. Gross PPE will be $27.3 million (54.6/2) per year. We also assume there is no more long term debt, because any funds need in the case are short term debt, it keeps at $18.2 million. According to the forecast, Star River needs external financing approximately $94 million and $107 million in 2002 and 2003, respectively. In order to analysis if the company can repay the debt, we need to know the interest coverage ratio, current ratio and D/E ratio. The interest coverage ratios through the forecast were 1.23 and 0.87 respectively, which is the danger signal to the managers, because in 2003, the profits even not
* Determine the investment’s value without leverage, VU, by discounting its free cash flows at the
665 0.34 174 216 537 234 122 1.2 0.2 60.4 9.6 0.22 65.0 2,149 554 66.6 2,483 80,300 492 14 23 6 21 15 874 524 12,216 30
5.000,00 $ 7.500 151.250 20 35.000,00 $ 12.500 321.250 26 $ 58,20 $ 110.000,00 4.000 333.500 83 115,38
Also, according to its leverage ratios, the company’s debts are not only very high, but are also increasing. Its decreasing TIE ratio indicates that its capability to pay interests is decreasing. The company’s efficiency ratios indicate that despite the fact that its fixed assets are increasingly being utilized to generate sales during the years 1990-1991 as indicated by its increasing fixed asset turnover ratio, the decreasing total assets turnover indicate that overall the company’s total assets are not efficiently being put to use. Thus, as a whole its asset management is becoming less efficient. Last but not the least, based on its profitability ratios, the company’s ability to make profit is decreasing.
Thus the WAVG Cost of Debt (including L/T debt and preferred stock) = rd = 8.633%
We assume linear increase in the EBIT and EBITDA at 3% for 1999 from 1998 figures. Considering the debt will be long-term, we test both 10- and 20-year corporate yields as interest rates to see what would be the coverage ratios, using the 1999 projected figures.
Further, we would pay off the debt using our excess free cash flow to pay off the debt. By the end of the 5th year, we would sell the firm and gain from any excess value found within the firm.
The market value of debt was calculated using the existing yield of maturity on a 5 yar bond issued on a private placement basis on July 1, 2000. With the coupon of 5.75% and the discount price of 97, YTM for this bond is 6.62%. With a discount price being 97, the market value of debt is 17,654M.
Since there are significant changes in the company for the last 3 years such as descending trend in car and truck market in 1991, sale of one of their core electronics business, terminated Volvo agreement etc.; the company thinks that their financial value (equity and debt ratios and weights) and accordingly cost of capital is changed. Also company has free cash (derived from the sales of electronics
The final section of the statement of cash flows is the financing section, which shows the dividends paid, the purchases of stock, the net borrowings, and other possible cash flows from financing activities. A positive trend for investors is the fact that dividends paid has increased (even though it is negative to the firm) as well as sale purchase of stock, from 2009 to 2011 and even increased quarterly in 2011. The net borrowings is off an on from 2009 to 2011 possibly because of certain funds needed in particular years. In 2009, it was $5,746,000,000 and in 2010, it was $190,000,000. It shot back up again in 2011, with $5,960,000,000.