Home Draw Insert Page Layout Formulas Review Data View Times New Roman 14 LG Pasta BIUM aA EE Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for C33 4 x fx A Problem 6-12 Suppose a 10 yow, $1,000 bond with componendi coupons is trading for $1.034.74 Complete the prowing old tog data or prelows calculations. In RON CUNG, simple alrerer all you wal. To copy paste a formula araw a row or down a con abroute call or a mladowli rent may be preferred a pic function it to be wied the directions will spect the we of that function. Do not ope in umerical data into all or function and make a reference to the call in which the dane w found. Make your computations only In the eville highlighted low. In all cases, mile otherwise directed to the earlier appearance of the data is your formular wally the Gwen Data section What is the bood's yield to maturity (expresied APR With semiannual compounding? b. If the band's yield to micurity changes to 9% APR, what will the band's price be? Maturity Gean) Face value Coupon rate Boed price $ 10 1.000 8% 1,034.74 $ . What is the band's yield to maturity (expressed as APR with some compounding 15 Coupon L Number of periods 37 Yidd to my SB 29 b. If the bond's yield to maturity changes to APR what will the band's price be? 20 21 Yidd to 90% 21 Semanal yield 24 Bond price 21 24 2 Requirements s cell DIS, by using dl references, calculate the upon payment of the bond (pt) 2 In cell D16, by using colles, the number of periode pt) In dll D17, by wing all forces, the yield to city of the hond (pt) Note Omit the opende is the RATE function 4 In edl 23, by using cell reflect the only to ty of the bond pt) 5 s cell 024 by using elleros, calculate the new pole of the bodd pt) 21 30 6-12