Furst Co: Bond Yields. What is the YTM?

Please explain how to do the following on a spreadsheet. I am having difficulty in doing this.

Furst Co. issued 12-year bonds 2 years ago at a coupon rate of 8.4 percent. The bonds make semiannual payments. If these bonds currently sell for 87 percent of par value, what is the YTM?

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/furst-co-bond-yields-what-is-the-ytm-2e7

Solution Preview

...set up the CF schedule on excel and used the goal seek function to arrive at a semi-annual yield of ...