Bourdon Software has 6.4 percent coupon bonds on the market with 18 years to maturity. The bonds make semiannual payments and currently sell for 106.8 percent of par. What is the current yield on the bonds?The YTM? The effective annual yield?

Please answer using Excel.

Input area: Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) Output area: Current yield Yield to maturity Effective annual rate