In: Finance
Firm R currently has $1,500,000 of debt outstanding with a before tax annual coupon of 5.2%, a constant EBIT of $2,000,000 and 450,000 shares outstanding at a market price of $28.00. The firm is considering issuing $1,000,000 of debt at a before tax cost of 7.25% and using the proceeds to repurchase stock at the new post-announcement market price. If this plan is implemented, it is expected that the required return on equity would rise to 10%. The firm's marginal tax rate is 32%..
What is the market value of the firm before the announcement of the issue of the new debt?
$15,228,000
$15,933,000
$14,100,000
$14,805,000
36.
Required information
What is the estimated value of the firm after the new debt issue?
$17,036,558
$16,282,728
$15,830,430
$15,076,600
37.
Required information
What is the estimated share price after the capital structure change?
$31.68
$32.58
$34.09
$30.17
38.
Required information
How many shares remain outstanding after the capital structure change?
416,855 shares
471,046 shares
450,203 shares
437,697 shares

Formula sheet
| A | B | C | D | E | F | G | H | I | J | K | 
| 2 | ||||||||||
| 3 | Before new debt Issue: | |||||||||
| 4 | Market Value of Debt | 1500000 | ||||||||
| 5 | Coupon rate of debt | 0.052 | ||||||||
| 6 | EBIT | 2000000 | ||||||||
| 7 | Numbers of shares outstanding | 450000 | ||||||||
| 8 | Market Price | 28 | ||||||||
| 9 | ||||||||||
| 10 | New Debt issue: | |||||||||
| 11 | Amount of New Debt issue | 1000000 | ||||||||
| 12 | Coupon rate on new debt issued | 0.0725 | ||||||||
| 13 | ||||||||||
| 14 | Calculation of Market Value of firm before debt issue: | |||||||||
| 15 | ||||||||||
| 16 | Market value of debt before new debt issue | =D4 | ||||||||
| 17 | Market value of equity before new debt issue | =D7*D8 | =D7*D8 | |||||||
| 18 | Total Market Value | =SUM(D16:D17) | =SUM(D16:D17) | |||||||
| 19 | ||||||||||
| 20 | Hence Total market value before debt issue is | =D18 | ||||||||
| 21 | Thus the third option is correct. | |||||||||
| 22 | ||||||||||
| 23 | Calculation of Value of firm after debt issue: | |||||||||
| 24 | ||||||||||
| 25 | Market Value | Weight | Cost | |||||||
| 26 | Old Debt | =D4 | =D26/$D$28 | 0.052 | ||||||
| 27 | New Debt | =D11 | =D27/$D$28 | 0.0725 | ||||||
| 28 | =SUM(D26:D27) | |||||||||
| 29 | ||||||||||
| 30 | Cost of Debt | =Weighted average cost of debt | ||||||||
| 31 | =SUMPRODUCT(E26:E27,F26:F27) | =SUMPRODUCT(E26:E27,F26:F27) | ||||||||
| 32 | ||||||||||
| 33 | Market Value of Equity After new debt issue | =D17-D11 | ||||||||
| 34 | Required return on equity | 0.1 | ||||||||
| 35 | ||||||||||
| 36 | Formula for WACC is given as: | |||||||||
| 37 | WACC = r(E) × w(E) + r(D) × (1 – t) × w(D) | |||||||||
| 38 | Where, r(E) and r(D) are cost of equity and cost of debt, w(E) is weight of equity and W(D) is weight of debt and t is the tax rate | |||||||||
| 39 | ||||||||||
| 40 | Weight of equity, w(E) | =Market Capitalization / Enterprise Value | ||||||||
| 41 | =D33/(D33+D28) | =D33/(D33+D28) | ||||||||
| 42 | ||||||||||
| 43 | Weight of debt, w(D) | =1- Weight of equity | ||||||||
| 44 | =1-D41 | |||||||||
| 45 | ||||||||||
| 46 | Calculation of WACC | |||||||||
| 47 | Tax rate | 0.32 | ||||||||
| 48 | Source of capital | Weight(w) | Cost(c) | |||||||
| 49 | Debt | =D44 | =D31 | |||||||
| 50 | Equity | =D41 | =D34 | |||||||
| 51 | ||||||||||
| 52 | WACC | = r(E) × w(E) + r(D) × (1 – t) × w(D) | ||||||||
| 53 | =E50*D50+E49*(1-D47)*D49 | =E50*D50+E49*(1-D47)*D49 | ||||||||
| 54 | ||||||||||
| 55 | Hence WACC is | =D53 | ||||||||
| 56 | ||||||||||
| 57 | Value of the firm can be calculated by find the present value of free cash flow at WACC. | |||||||||
| 58 | ||||||||||
| 59 | Free Cash Flow = Operating Cash Flow - Capital Expenditures - Change in working capital | |||||||||
| 60 | Operating Cash Flow = EBIT*(1-Tax Rate)+Depreciation | |||||||||
| 61 | ||||||||||
| 62 | EBIT | 2000000 | ||||||||
| 63 | Tax Rate | 0.32 | ||||||||
| 64 | ||||||||||
| 65 | Free Cash Flow | =D62*(1-D63) | =D62*(1-D63) | |||||||
| 66 | WACC | =D55 | ||||||||
| 67 | ||||||||||
| 68 | Value of the firm | =Present value of Perpetuity | ||||||||
| 69 | =D65/D66 | |||||||||
| 70 | ||||||||||
| 71 | Hence Value of the firm is | =D69 | ||||||||
| 72 | ||||||||||
| 73 | Calculation of Estimated share price after change in capital structure: | |||||||||
| 74 | ||||||||||
| 75 | Value of Firm after debt issue | =D71 | ||||||||
| 76 | Value of Debt | =D28 | ||||||||
| 77 | Value of equity after change | =D75-D76 | ||||||||
| 78 | ||||||||||
| 79 | Amount of Debt issued | =D11 | ||||||||
| 80 | Market Value per share | =D8 | ||||||||
| 81 | Number of shares bought Back | =D79/D80 | ||||||||
| 82 | ||||||||||
| 83 | Numbers of shares outstanding before change | 450000 | ||||||||
| 84 | Number of shares bought back | =D81 | ||||||||
| 85 | Number of shares oustanding after change | =D83-D84 | ||||||||
| 86 | ||||||||||
| 87 | Estimated share price after issue | =Value of equity after change / Number of shares outstanding after change | ||||||||
| 88 | =D77/D85 | =D77/D85 | ||||||||
| 89 | ||||||||||
| 90 | Hence Estimated Share price after change | =D88 | ||||||||
| 91 | ||||||||||
| 92 | Number of shares outstanding after the issue | =D85 | ||||||||
| 93 | ||||||||||
| 94 | The answers seems to be a bit different from the options given but the procedure is correct. | |||||||||
| 95 | Please check the question data again and let me know. | |||||||||
| 96 | ||||||||||