EXCEL TEMPLATE) Watchstone Concrete Products issued 30-year maturity bonds 15 years ago with a coupon rate of 10.75%. The principal amount was $15,000,000. Interest rates have steadily decreased and the company could issue new bonds today at a coupon rate of 9.50%. The new issue would be used to pay off the old bonds and would have a maturity of 15 years. The original issue had flotation costs of $375,000 which were set up on an amortization schedule over 30 years with equal amounts each year. The old bonds are callable with a premium of 4.5%. An investment banking firm would charge a flotation fee of $225,000 on the new issue that would be amortized over the life of the new bonds. Rovers marginal tax rate is 25%. Calculate the NPV of the bond refund

a.Old and nwe Bond Principal?

b.Old and new Bond Interest Rate?

c.Old and new Bond Flotation Cost?

d.Old and new Bond Maturity (Years)?

e.Tax Rate?

f.Call Premium Rate?