please solve using microsoft excel and show formulas if possible

16. Genworth Financial's 5.25% Series A cumulative preferred stock has a par value of $50 and inter- est rate of 5.25% payable quarterly on the first day of March, June, September, and December. The stock is callable at par from 1 June 2011. If the stock trades at $45.50 on 2 June 2005, what is its yield to first call (YTC)