Need Calculation with formulas in excel

Hightower, Inc. plans to announce it will issue $2.0 million of perpetual debt and use the proceeds to repurchase common stock. The bonds will sell at par with a coupon rate of 5%. Hightower, Inc. is currently an all-equity company worth $7.5 million with 400,000 shares of common stock outstanding. After the sale of the bonds, the company will maintain the new capital structure indefinitely. The company currently generates annual pretax earnings of $1.5 million. This level of earnings is expected to remain constant in perpetuity. The tax rate is 35%.

  1. What is the expected return on the company’s equity before the announcement of the debt issue?
  2. Construct the company’s market value balance sheet immediately after the announcement of the debt issue.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.