$ Consider a bond, paying semiannual coupons, with face value of US$1,000, maturing in 15 years and selling for US$7247. Find, wing Goal Seek the semiannual YTM, the bond-equivalent and the effice It we cells VS. AS to set up the cash flows for the lowl. The price in cell El calculated as the cash Mews wird an initially know YTM. Your objective is to find the YTM Mut make Well luris closing the "Gap toe. Note uw need to make an initials on the semi-ww YTM 1600 8 Face value Coupon rate Frequency of payments Time to mality years) Price 15 7242 Semiran un periode 000 0,00 OR 0 0,00 Cash flows Discounted cash flows 0,00 Price (culated as the sum of discounted cash flow 00 Seminal YTM Annual YTM 0.00% Gap (Difference between the known price and the calculated price -724,70