Effect of Debt Issuance on Stock Valuation

NO PLAGERIASM, MUST BE ORIGINAL WORK.
THIS IS A 2 PAR TASSIGHNMENT, BOTH PARTS MUST BE COMPLETED PROPERLY
PART 1 WORD DOCUMENT ANSWERING ALL BULLET POINTS BELOW WITH A MINIMUM WORD COUNT OF 1200.
PART 2 EXCEL DOCUMENT, ALL CALCULATIONS MUST BE SHOWN ON EXCEL SHEET WITH ALL FORMULAS INPUTED INTO CELLS AS TO SHOW HOW ANSWERS ARE RECIEVED. ANSWERS ALONE ARE NOT SUFICIENT.
DO NOT WRITE QUESTIONS IN THE WORD DOCUMENT!!!!
ALL CITATIONS MUST INCLUDE PROPER REFERENCES IN APA FORMAT
Assignment Steps
Resources: Corporate Finance
Scenario: 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%.
Prepare a 1,200-word memo advising the management of Hightower, Inc. on the financial impact, including the following:

What is the expected return on the company’s equity before the announcement of the debt issue?
Construct the company’s market value balance sheet before the announcement of the debt issue. What is the price per share of the firm’s equity?
Construct the company’s market value balance sheet immediately after the announcement of the debt issue.
What is the company’s stock price per share immediately after the repurchase announcement?
How many shares will the company repurchase as a result of the debt issue? How many shares of common stock will remain after the repurchase?
What is the required return on the company’s equity after the restructuring?
Discuss the advantages and disadvantages of debt financing over equity financing.

Show all calculations and submit with your memo.
Format your paper consistent with APA guidelines.