Problem 7-8 Yield to call

Seven years ago the Templeton Company issued 15-year bonds with a 11% annual coupon rate at their $1,000 par value. The bonds had a 5% call premium, with 5 years of call protection. Today Templeton called the bonds.

1. A.Computetherealizedrateofreturnforaninvestorwhopurchasedthebondswhentheywereissuedandheldthemuntiltheywerecalled.Roundyouranswertotwodecimalplaces.

Please how me how to compute based on Excel formulas.