answer quesrion in excel

1. Sheehan Corp. is forecasting an EPS of $3.00 for the coming year on its 500,000 outstanding shares of stock. Its capital budget is forecasted at $800,000, and it is committed to maintaining a $2.00 dividend per share. It finances with debt and common equity, but it wants to avoid issuing any new common stock during the coming year. Given these constraints, what percentage of the capital budget must be financed with debt?

2. Mortal Inc. expects to have a capital budget of $500,000 next year. The company wants to maintain a target capital structure with 30% debt and 70% equity, and its forecasted net income is $400,000. If the company follows the residual dividend policy, how much in dividends, if any, will it pay?

3. Ting Technology has a capital budget of $850,000, it wants to maintain a target capital structure of 35% debt and 65% equity, and it also wants to pay a dividend of $400,000. If the company follows a residual dividend policy, how much net income must it earn to meet its capital budgeting requirements and pay the dividend, all while keeping its capital structure in balance?

4. DeAngelo Corp.'s projected net income is $150.0 million, its target capital structure is 25% debt and 75% equity, and its target payout ratio is 65%. DeAngelo has more positive NPV projects than it can finance without issuing new stock, but its board of directors had decreed that it cannot issue any new shares in the foreseeable future. The CFO now wants to determine how the maximum capital budget would be affected by changes in capital structure policy and/or the target dividend payout policy. Versus the current policy, how much larger could the capital budget be if (1) the target debt ratio were raised to 75%, other things held constant, (2) the target payout ratio were lowered to 20%, other things held constant, and (3) the debt ratio and payout were both changed by the indicated amounts, Increase in Capital Budget:
Increase Debt to 75% Lower Payout to 20% Do Both

5. The following data apply to Grullon-Ikenberry Inc. (GII):
Value of operations $1,000, Short-term investments $100, Debt $300, Number of shares 100; The company plans on distributing $50 million as dividend payments. What will the intrinsic per share stock price be immediately after the distribution?

6. Dentaltech Inc. projects the following data for the coming year. If the firm follows the residual dividend policy and also maintains its target capital structure, what will its payout ratio be? EBIT $2,000,000 Capital budget $850,000 Interest rate 10% % Debt 40%
Debt outstanding $5,000,000 % Equity 60%
Shares outstanding $5,000,000 Tax rate 40%

7. The A. J. Croft Company (AJC) currently has $200,000 market value (and book value) of perpetual debt outstanding carrying a coupon rate of 6%. Its earnings before interest and taxes (EBIT) are $100,000, and it is a zero growth company. AJC's current cost of equity is 8.8%, and its tax rate is 40%. The firm has 10,000 shares of common stock outstanding selling at a price per share of $60.00.
The firm is considering moving to a capital structure that is comprised of 40% debt and 60% equity, based on market values. The new funds would be used to replace the old debt and to repurchase stock. It is estimated that the increase in risk resulting from the additional leverage would cause the required rate of return on debt to rise to 7%, while the required rate of return on equity would rise to 9.5%. If this plan were carried out, what would be AJC's new WACC and total value?

8. Michaely Inc. is an all-equity firm with 200,000 shares outstanding. It has $2,000,000 of EBIT, which is expected to remain constant in the future. The company pays out all of its earnings, so earnings per share (EPS) equal dividends per shares (DPS). Its tax rate is 40%.
The company is considering issuing $5,000,000 of 10.0% bonds and using the proceeds to repurchase stock. The risk-free rate is 6.5%, the market risk premium is 5.0%, and the beta is currently 0.90, but the CFO believes beta would rise to 1.10 if the recapitalization occurs.
Assuming that the shares can be repurchased at the price that existed prior to the recapitalization, what would the price be following the recapitalization?

9. Vafeas Inc.'s capital structure consists of 80% debt and 20% common equity, its beta is 1.60, and its tax rate is 35%. However, the CFO thinks the company has too much debt, and he is considering moving to a capital structure with 40% debt and 60% equity. The risk-free rate is 5.0% and the market risk premium is 6.0%. By how much would the capital structure shift change the firm's cost of equity?

10. Simon Software Co. is trying to estimate its optimal capital structure. Right now, Simon has a capital structure that consists of 20% debt and 80% equity, based on market values. (Its D/S ratio is 0.25.) The risk-free rate is 6% and the market risk premium, rM – rRF, is 5%. Currently the company’s cost of equity, which is based on the CAPM, is 12% and its tax rate is 40%. What would be Simon’s estimated cost of equity if it were to change its capital structure to 50% debt and 50% equity?

11. The A. J. Croft Company (AJC) currently has $200,000 market value (and book value) of perpetual debt outstanding carrying a coupon rate of 6%. Its earnings before interest and taxes (EBIT) are $100,000, and it is a zero growth company. AJC's current cost of equity is 8.8%, and its tax rate is 40%. The firm has 10,000 shares of common stock outstanding selling at a price per share of $60.00.
What is AJC's current total market value and weighted average cost of capital?

12. LeCompte Learning Solutions is considering making a change to its capital structure in hopes of increasing its value. The company's capital structure consists of debt and common stock. In order to estimate the cost of debt, the company has produced the following table:
 

 
The company uses the CAPM to estimate its cost of common equity, rs. The risk-free rate is 5% and the market risk premium is 6%. LeCompte estimates that if it had no debt its beta would be 1.0. (Its "unlevered beta," bU, equals 1.0.) The company's tax rate, T, is 40%.
 
On the basis of this information, what is LeCompte's optimal capital structure, and what is the firm's cost of capital at this optimal capital structure?

13. Whited Products recently completed a 4-for-1 stock split. Prior to the split, its stock sold for $120 per share. If the firm's total market value increased by 5% as a result of increased liquidity caused by the split, what was the stock price following the split?

14. DeAngelo Corp.'s projected net income is $150.0 million, its target capital structure is 25% debt and 75% equity, and its target payout ratio is 65%. DeAngelo has more positive NPV projects than it can finance without issuing new stock, but its board of directors had decreed that it cannot issue any new shares in the foreseeable future. The CFO now wants to determine how the maximum capital budget would be affected by changes in capital structure policy and/or the target dividend payout policy. Versus the current policy, how much larger could the capital budget be if (1) the target debt ratio were raised to 75%, other things held constant, (2) the target payout ratio were lowered to 20%, other things held constant, and (3) the debt ratio and payout were both changed by the indicated amounts.
Increase in Capital Budget
Increase Debt to 75% Lower Payout to 20% Do Both

15. Mortal Inc. expects to have a capital budget of $500,000 next year. The company wants to maintain a target capital structure with 30% debt and 70% equity, and its forecasted net income is $400,000. If the company follows the residual dividend policy, how much in dividends, if any, will it pay?

16.. Keys Financial has done extremely well in recent years, and its stock now sells for $175 per share. Management wants to get the price down to a more typical level, which it thinks is $25 per share. What stock split would be required to get to this price, assuming the transaction has no effect on the total market value? Put another way, how many new shares should be given per one old share?

17. Banerjee Inc. wants to maintain a target capital structure with 30% debt and 70% equity. Its forecasted net income is $550,000, and its board of directors has decreed that no new stock can be issued during the coming year. If the firm follows the residual dividend policy, what is the maximum capital budget that is consistent with maintaining the target capital structure?

18. Vafeas Inc.'s capital structure consists of 80% debt and 20% common equity, its beta is 1.60, and its tax rate is 35%. However, the CFO thinks the company has too much debt, and he is considering moving to a capital structure with 40% debt and 60% equity. The risk-free rate is 5.0% and the market risk premium is 6.0%. By how much would the capital structure shift change the firm's cost of equity?

19. Dabney Electronics currently has no debt. Its operating income is $20 million and its tax rate is 40%. It pays out all of its net income as dividends and has a zero growth rate. The current stock price is $40 per share, and it has 2.5 million shares of stock outstanding. If it moves to a capital structure that has 40% debt and 60% equity (based on market values), its investment bankers believe its weighted average cost of capital would be 10%. What would its stock price be if it changes to the new capital structure?

20. Ang Enterprises has a levered beta of 1.10, its capital structure consists of 40% debt and 60% equity, and its tax rate is 40%. What would Ang's beta be if it used no debt, i.e., what is its unlevered beta?