Show how to do on excel.

Greene Co. is planning a project for which it will issue new bonds. Bonds in the same risk class issued by similar firm are currently priced at $954.90, have a face value of $1,000, 25 years remaining to maturity, and pay coupons of $75 every year. If Greene's marginal tax rate is 34%, what is the pre-tax YTM for the debt?

Select one:

a. 8.12%

b. 7.20%

c. 7.92%

d. 7.50%