PLEASE USE EXCEL TO SOLVE THE FOLLOWING CASE:

Nealon Energy Corporation engages in the acquisition, exploration, development, and production of natural gas and oil in the continental United States. The company has grown rapidly over the last 5 years as it has expanded into horizontal drilling techniques for the development of the massive deposits of both gas and oil in shale formations. The companys operations in the Haynesville shale (located in northwest Louisiana) have been so significant that it needs to construct a natural gas gathering and processing center near Bossier City, Louisiana, at an estimated cost of $70 million.

To finance the new facility Nealon has $20 million in profits that it will use to finance a portion of the expansion and plans to sell a bond issue to raise the remaining $50 million. The decision to use so much debt financing for the project was largely due to the argument by company CEO (Douglas Nealon Sr.) that debt financing is inexpensive relative to common stock (which the firm has used in the past). Company CFO Doug Nealon Jr. (son of the company founder) did not object to the decision to use all debt but pondered the issue of what cost of capital to use for the expansion project. There is no doubt but that the out-of-pocket cost of financing was equal to the new interest that must be paid on the debt. However, the CFO also knew that by using debt for this project the firm would eventually have to use equity in the future if it wanted to maintain the balance of debt and equity it had in its capital structure and not become overly dependent on borrowed funds.

The following balance sheet reflects the mix of capital sources that Nealon has used in the past. Although the percentages would vary over time, the firm tended to manage its capital structure back toward these proportions:

• Target Capital Structure Weights: Bonds 40% Common Stock 60%

The firm currently has one issue of bonds outstanding. The bonds have a par value of $1,000 per bond, carry an 8 percent coupon rate of interest, have 16 years to maturity, and are selling for $1,035. Nealons common stock has a current market price of $35 and the firm paid a $2.50 dividend last year that is expected to increase at an annual rate of 6 percent for the foreseeable future.

a. What is the yield to maturity for Nealons bonds under current market conditions?

b. What is the cost of new debt financing to Nealon based on current market prices after both taxes (you may use a 34 percent marginal tax rate for your estimate) and flotation costs of $30 per bond have been considered?

c. What is the investors required rate of return for Nealons common stock? If Nealon were to sell new shares of common stock, it would incur a cost of $2.00 per share. What is your estimate of the cost of new equity financing raised from the sale of common stock?

d. Compute the weighted average cost of capital for Nealons investment using the weights reflected in the actual financing mix (that is, $20 million in retained earnings and $50 million in bonds).

e. Compute the weighted average cost of capital for Nealon where the firm maintains its target capital structure by reducing its debt offering to 40 percent of the $70 million in new capital, or $28 million, using $20 million in retained earnings and raising $22 million through a new equity offering.

f. If you were the CFO for the company, would you prefer to use the calculation of the cost of capital in part (d) or (e) to evaluate the new project? Why?