First, we need to find the | |||||
WACC to discount Free cash flows of Brown | |||||
by using the formula: | |||||
WACC=(Wt.Debt*After-tax Cost Debt)+(Wt. equity*Cost Equity) | |||||
ie.(25%*8%)+(75%*22%)= | |||||
18.5% | |||||
2004 | 2005 | 2006 | 2007 | Thereafter | |
Year | 1 | 2 | 3 | 4 | |
1.Net sales | 260 | 265 | 280 | 290 | 300 |
2.COGS(Sales*50%) | -130 | -132.5 | -140 | -145 | -150 |
3. Admn. &Sell. Exp. | -25 | -25 | -25 | -30 | -30 |
4.Depreciation | -15 | -17 | -18 | -23 | -30 |
5.EBT(1+2+3+4) | 90 | 90.5 | 97 | 92 | 90 |
6.Tax at 34%(Row 5*34%) | -30.6 | -30.77 | -32.98 | -31.28 | -30.6 |
7.EAT(5+6) | 59.4 | 59.73 | 64.02 | 60.72 | 59.4 |
8. Add back: depn. | 15 | 17 | 18 | 23 | 30 |
9. Opg. Cash flow | 74.4 | 76.73 | 82.02 | 83.72 | 89.4 |
10. CAPEX | -22 | -18 | -18 | -20 | -22 |
11.FCFF(9+10) | 52.4 | 58.73 | 64.02 | 63.72 | 67.4 |
12. Terminal FCFF(67.4/18.5%) | 364.3243 | ||||
13. Total FCFF(11+12) | 52.4 | 58.73 | 64.02 | 428.0443 | |
14. PV F at 18.5%(1/1.185^n) | 0.843882 | 0.712137 | 0.600959 | 0.507139 | |
15. PV at 18.5% | 44.21941 | 41.82378 | 38.4734 | 217.0778 | |
16. NPV (sum of row 15) | 341.5944 | ||||
17.Current market value of Brown's Debt | 75 | ||||
18. Brown's FCFE(16-17) | 266.5944 | ||||
Millions | |||||
a. NPV of acquisition=Value of Brown Corporation's FCFs=341.5944 millions | |||||
b. Current market value of Brown's common stock is 200 millions,ie. less than the actual or true value $ 266 millions ,calculated as above, discounting its FCFs--which indicates under-valuation of its stock by the market forces indicating less demand by investors. | |||||
Hence NOT RECOMMENDED to buy. | |||||
Freeca-fro vaaion) The Brown Corporationis viewed as a possble takeover burget y Cicron, Inc. Currentdy, Brown...
ㄈ 그 . ) The Brown Corporation is viewed as a possible takeover target y Cicron, Inc. Currentdy, Brown uses 20 percent debt in is cupital structure, but Cicron plans o increase the debt ratio to 25 percent if the scquistion is consummated The fer-tar cost of debt capital for Brown is estimated to be 8 percent, which holds constant under either apital structure. The cost of equty sfter th acquisition is eapected to be 22 percent. The current mar...
Free cafoa valuation) The Brown Corporation is viewed as a posible takeover turget y Cicron, Inc. Curentdy, Brown uses 20 percent debt in its capital structure, but Cicron plans to increase the debt ratio to 25 percent if the acquisition is consummated. The after-tax cost of debt apital for Brown is estimated to be 8 percent,which holds constant under either capital structure. The cost of equity fer the acquisition is eapected to be 22 percent. The current mar- ket value...
URGENT!
37 min left
Pre re oswer uget eecab y Clicron, Inc. CurreadyBrown uses 20 percent debt in is capital structure, but Cicron plans to increae the debt ratio to 25 percent if the scquistion is consummated The after-tar cost of debt capital for Brown is estimated to be 8percent, which holds constant under either apital structure. The cost of equity sfer the acquisition is expected to be 22 percent. The curent ket value of Brown' oustanding debt is S75...
1 question (60%) The Prime Corporation is viewed as a possible takeover tar- get by TVC Enterprises, Inc. Currently, Prime uses 25 percent debt in its capital structure, but TVC plans to increase the debt ratio to 40 percent if the acquisition is consummated Prime's after-tax cost of debt is 10 percent, which should hold constant. The c after the acquisition is expected to be 20 percent. The current market value of Prime's debt outstanding is $30 million, all of...
1 question (60%) Prime Corporation is viewed as a possible takeover tar- get by TVC Enterprises, Inc. Currently, Prime uses 25 percent debt in its capital structure, but TVC plans to increase the debt ratio to 40 percent if the acquisition is consummated. Prime's after-tax cost of debt is 10 percent, which should hold constant. The cost of equity after the acquisition is expected to be 20 percent. The current market value of Primes debt outstanding is $30 million, all...