Question

Suppose that Papa Bell, Inc.'s, equity is currently selling for $41 per share, with 3.6 million...

Suppose that Papa Bell, Inc.'s, equity is currently selling for $41 per share, with 3.6 million shares outstanding. The firm also has 8,000 bonds outstanding, which are selling at 95% of par. Assume Papa Bell was considering an active change to its capital structure so as to have a D/E of 0.5. Which type of security (stocks or bonds) would the firm need to sell to accomplish this? How much would it have to sell? (Enter your answer in dollars not in millions. Do not round intermediate calculations and round your final answer to 2 decimal places.)

Share Price: $41.00

Shares Outstanding: 3,600,000

Bonds Outstanding: 8,000

Bond Price (% of Par): 95%

Proposed New D/E Ratio: 0.50

Complete the following analysis. Do not hard code values in your calculations, and do not round intermediate calculations.

Current Equity Ratio:

Current Debt Ratio:

Current D/E Ratio:

Sell Bonds or Stock?:

New Debt Ratio:

Amount of Securities to Buy and Sell:

I found this question in Chegg study; however, all calculations is done manually and I need to know how to entered it in a spreadsheet that is provide it.

Homework Answers

Answer #1

Answer:- As given that,

Equity Value = 3.6*41 = 147.6m

Debt Value = 1000*95%*8000 = 7600000 = 7.6m

Total Liabilities = 147.6+7.6m = 155.2m

Current Equity Ratio = Equity Value/Total Liabilities = 147.6/155.2 = 0.95:1

Current debt ratio = Debt Value/Total Liabilities = 7.6/155.2 = 0.05:1

Current Debt/Equity Ratio = Debt/Equity = 7.6/147.6 = 0.0515:1

Proposed debt/Equity Ratio = 0.5:1

Therefore Proposed debt = 0.5*Total Liabilities = 0.5*155.2 = 77.6m

Existing debt = 7.6m

So, Debt have to be increased by = 77.6-7.6 = 70m

So, Bonds have to bought & Hence shares have to be sold

Number of share to be sold = 70m/41 = 1707317.07 shares

Therefore Number of shares to be sold = 1707317.07

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
papa bell, Inc’s Equity is currently selling for $43 per share, with 3.8 shares outstanding. The...
papa bell, Inc’s Equity is currently selling for $43 per share, with 3.8 shares outstanding. The firm also has 9000 bonds outstanding, which are selling at 93 percent of par. Assume papa bell was considering an active change to its capital structure so as to have a D/E .3. Therefore what is the selling amount? Answer please NOT in millions only dollars and only round the answer to two decimal points
Suppose that Lil John Industries' equity is currently selling for $36 per share and that 1.9...
Suppose that Lil John Industries' equity is currently selling for $36 per share and that 1.9 million shares are outstanding. Assume the form also has 29,000 bonds outstanding, and they are selling at 104 percent of par. What are the firm's current capital structure weights? (Do not round intermediate calculations. Round your answers to 2 decimals places.) Capital Structure Weights Equity ?????? % Debt ?????? % Suppose that Lil John Industries’ equity is currently selling for $28 per share and...
Suppose that a company's equity is currently selling for $27.25 per share and that there are...
Suppose that a company's equity is currently selling for $27.25 per share and that there are 4.3 million shares outstanding and 23 thousand bonds outstanding, which are selling at 98 percent of par. If the firm was considering an active change to their capital structure so that the firm would have a D/E of 1.8, which type of security (stocks or bonds) would they need to sell to accomplish this, and how much would they have to sell? (Round your...
Suppose that a company's equity is currently selling for $42.00 per share and that there are...
Suppose that a company's equity is currently selling for $42.00 per share and that there are 1.8 million shares outstanding and 28 thousand bonds outstanding, which are selling at 111.00 percent of par. If the firm was considering an active change to their capital structure so that the firm would have a D/E of 1.8, which type of security (stocks or bonds) would they need to sell to accomplish this, and how much would they have to sell? (Round your...
Suppose that Lil John Industries’ equity is currently selling for $38 per share and that 3.1...
Suppose that Lil John Industries’ equity is currently selling for $38 per share and that 3.1 million shares are outstanding. The firm also has 61,000 bonds outstanding, which are selling at 104 percent of par. Assume Lil John was considering an active change to its capital structure so that the firm would have a (D/E) of 1.3. Which type of security (stocks or bonds) would it need to sell to accomplish this? sell bonds and buy back stock sell stocks...
Suppose that a company's equity is currently selling for $24.25 per share and that there are...
Suppose that a company's equity is currently selling for $24.25 per share and that there are 3.1 million shares outstanding. If the firm also has 11.0 thousand bonds outstanding, which are selling at 92.5 percent of par, what are the firm's current capital structure weights for equity and debt respectively? a. 26.22%, 73.78% b. 86.46%, 13.54% c. 88.08%, 11.92% d. 50%, 50%
Suppose that Lil John Industries’ equity is currently selling for $29 per share and that 1.2...
Suppose that Lil John Industries’ equity is currently selling for $29 per share and that 1.2 million shares are outstanding. Assume the firm also has 22,000 bonds outstanding, and they are selling at 103 percent of par. What are the firm’s current capital structure weights?
Suppose that shares in Tasty Bites Pizza, Inc., are trading for $46 per share, with 6...
Suppose that shares in Tasty Bites Pizza, Inc., are trading for $46 per share, with 6 million shares outstanding. If the firm also has 12,000 bonds outstanding and they're selling at 97 percent of par, what are the firm's current capital structure weights? A. Equity 14.85 percent; debt 85.15 percent B. Equity 4.05 percent; debt 95.95 percent C. Equity 95.78 percent; debt 4.05 percent D. Equity 85.15 percent; debt 14.85 percent
Ashman Motors is currently an​ all-equity firm. It has two million shares​ outstanding, selling for ​$43...
Ashman Motors is currently an​ all-equity firm. It has two million shares​ outstanding, selling for ​$43 per share. The company has a beta of 1.5​, with the current​ risk-free rate at 4.7​% and the market premium at 7.7​%. The tax rate is 15​% for the company. Ashman has decided to sell ​$43 million of bonds and retire half its stock. The bonds will have a yield to maturity of 10.8​%. The beta of the company will rise to 1.9 with...
Bonaime, Inc., has 6.9 million shares of common stock outstanding. The current share price is $61.90,...
Bonaime, Inc., has 6.9 million shares of common stock outstanding. The current share price is $61.90, and the book value per share is $4.90. The company also has two bond issues outstanding. The first bond issue has a face value of $70.9 million, a coupon rate of 7.4 percent, and sells for 93.5 percent of par. The second issue has a face value of $35.9 million, a coupon rate of 7.4 percent, and sells for 92.5 percent of par. The...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT