I need the answer in excel please :)

Jan Volk, financial manager of Green Sea Transport (GST, has been asked by her boss to review GST's outstanding debt issues for possible bond refunding. Five years ago, GST issued $40,000,000 of 11%, 25-year debt. The issue, with semiannual coupons, is currently callable at a premium of 11%, or $110 for each $1,000 par value bond. Flotation costs on this issue were 6%, or $2,400,000.

Volk believes that GST could issue 20-year debt today with a coupon rate of 8%. The firm has placed many issues in the capital markets during the last 10 years, and its debt flotation costs are currently estimated to be 4% of the issue's value. GST's federal-plus-state tax rate is 40%.

Help Volk conduct the refunding analysis by answering the following questions.

e. What is the semi annual tax savings that arises from amortizing the flotation costs on the new issue? What is the forgone semiannual tax savings on the old-issue floatation costs?

f. What is the semi annual after-tax interest savings that would result from the refunding?

g. Thus far, Volk has identified two future cash flows: 1: The net of new-issue flotation cost tax savings and old-issue flotation cost tax savings that are lost if refunding occurs and 2: After-tax interest savings. What is the sum of these two semiannual cash flows? What is the appropriate discount rate to apply to these future cash flows? What is their present value?

h. What is the NPV of refunding? Should GST refund now or wait until later?