please formula or excel to calculet and explain as much you can.

Missing information on a bond. Your broker faxed to you the following information about two monthly coupon bonds that you are considering as a potential investment. Unfortunately, your fax machine is blurring some of the items, and all you can read from the fax on the two different bonds is the following: Fill in the missing data from the information that the broker sent. What is the price of the IBM coupon bond? (Round to the nearest cent.) What is the coupon rate of the AOL coupon bond? l% (Round to the nearest whole percent.) Data Table -X (Click on the following icon in order to copy its contents into a spreadsheet.) Features Face value (Par) Coupon rate Yield to maturity. Years to maturity Price IBM Coupon Bond $1,000 5.5% 8.5% AOL Coupon Bond $1,000 ? 9.5% 10 25 ? $761.55