As the chief financial officer (CFO) of New Horizon Corporation, you are considering a recapitalization plan that will shift New Horizon’s capital structure from all common stock equity to 30% debt financing. New Horizon expects to generate $13.75 million in annual net operating profit indefinitely. The current unlevered capital structure consists of 2,200,000 shares of outstanding common stock and shareholders require an 8% return on equity. Ignoring taxes, create a spreadsheet that answers the following questions.

TO DO

a. Under the current capital structure, what is New Horizon’s firm value, EPS, stock price, and ROE?

b. How much debt will New Horizon need to issue to achieve the proposed capital structure and what will be the annual interest expense if the coupon rate for the debt is 5.4%?

c. How many shares of common stock will be outstanding under the proposed capital structure and what will be the new EPS and ROE?

d. What is New Horizon’s expected EPS and ROE under the current and proposed capital structure if it’s NOP is as likely to be $6.875 million or $20.625 million as it is $13.75 million?

e. Graph the effect financial leverage has on the New Horizon’s EPS sensitivity to changes in net operating profit for the current and proposed capital structures.

At what level of NOP is New Horizon’s EPS the same for both the current and proposed capital structures?