The Howland Carpet Company has grown rapidly during the past 5 years. Recently, its commercial bank urged the company to consider increasing its permanent financing. Its bank loan under a line of credit has risen to $250,000 carrying an 8% interest rate. Howland has been 30 to 60 days late in paying trade creditors.

Discussions with an investment banker have resulted in the decision to raise $500,000 at this time period investment bankers have assured the firm that the following alternatives are feasible (flotation costs will be ignored).

• Alternative 1: sell common stock at $8.
• Alternative 2: sell convertible bonds at an 8% coupon, convertible into 100 shares of common stock for each $1,000 bond (i.e., the conversion price is $10 per share).
• Alternative 3 Collins cell debentures at an 8% coupon, each $1,000 bond carrying 100 warrants to buy common stock at $10.

John L. Howland, the president, owns 80% of the common stock and wishes to maintain control of the company. There are 100,000 shares outstanding. The following are extracts of Howlands latest financial statements:

Balance Sheet
		Line of Credit	$ 250,000.00
		Other Current Liabilities	$ 150,000.00
		Long Term Debt	$ -
		Common stock, par $1	100,000
		Retained Earnings	$ 50,000.00
total Assets	$ 550,000.00	Total Claims	$ 550,000.00
Income statement
		Sales	$ 1,100,000.00
		All Costs Except Interest	$ 990,000.00
		EBIT	$ 110,000.00
		Interest	$ 20,000.00
		Pre-Tax Earnings	$ 90,000.00
		Taxes (40%)	$ 36,000.00
		Net Income	$ 54,000.00
		Shares Outstanding	100,000
		Earnings per Share	$ 0.54
		Price/Earnings Ratio	15.83
		Market Price of Stock	$ 8.55

1. Show the New Balance sheet under each alternative. For alternatives two and three, show the balance sheet after conversion of the bonds or exercise of the warrants. Assume that half of the funds raised will be used to pay off the bank loan and half to increase total sales.
2. Show Mr. Howlands control position under each alternative, assuming that he does not purchase additional shares.
3. What is the effect on earnings per share of each alternative, assuming the profits before interest and taxes will be 20% of total assets?
4. What will be the debt ratio (TL/ TA) under each alternative?
5. Which of the three alternatives would you recommend to Mr. Howland, and why?

Please show how to this in Excel with formulas so I can do a new problem on my own. Thank you in advance!