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.

1. Which type of security (stocks or bonds) would the firm need to sell to accomplish this?

2. How much would it have to sell? (Enter your answer in dollars not millions. Do not round intermediate calculations and round your final answer to 2 decimal places.

Current Equity Ration:

Current Debt Ratios:

Current D/E Ratio:

Sell Bonds or Stocks?

New Debt Ration:

Amount of Securities to Buy and Sell:

Please show all the excel formulas used to solve for this question