Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually...
please show work in excel formula, Thanks G А C Е F Н J 1 2 Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually and 16 years to maturity. The yield to maturity on these bonds is 3.9 percent and the bonds have a par value of $5,000. What is the dollar price of the bond? 4 5 6 Settlement date 1/1/2000 Maturity date Coupon rate Coupons per year Redemption value (%...
How to use excel function to solve this problem? D8 X fox 3.7% AB E F G H Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually and 16 years to maturity. The yield to maturity on these bonds is 3.9 percent and the bonds have a par value of $5,000. What is the dollar price of the bond? 1/1/2000 1/1/2016 3.70%! Settlement date Maturity date Coupon rate Coupons per year Redemption value...
Union Local School District has bonds outstanding with a coupon rate of 5.1 percent paid semiannually and 18 years to maturity. The yield to maturity on these bonds is 4.6 percent and the bonds have a par value of $10,000. What is the dollar price of the bond? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Bond price $
Union Local School District has a bond outstanding with a coupon rate of 3.2 percent paid semiannually and 23 years to maturity. The yield to maturity on this bond is 2.6 percent, and the bond has a par value of $5,000. What is the price of the bond?
please answer question in excel and show the formula to get the answer ( I must have the formula) Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 3.8 percent. What is the dollar price of the bond? 1/1/2000 1/1/2013 4.90% Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to...
Chamberlain Co. wants to issue new 20-year bonds for some much-needed expansion projects The company currently has 7 percent coupon bonds on the market that sell for $1,083, make semiannual payments, and mature in 20 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? Settlement date 1/1/2000 Maturity date Annual coupon rate Coupons per year Redemption value (% of par) Bond price (% of par) 1/1/2020 7% 2 100...
Sweet Sue Foods has bonds outstanding with a coupon rate of 5.32 percent paid semiannually and sell for $1,956.84. The bonds have a par value of $2,000 and 17 years to maturity. What is the current yield for these bonds?
Sweet Sue Foods has bonds outstanding with a coupon rate of 5.11 percent paid semiannually and sell for $2,085.62. The bonds have a par value of $2,000 and 17 years to maturity. What is the current yield for these bonds?
Sweet Sue Foods has bonds outstanding with a coupon rate of 5.26 percent paid semiannually and sell for $2,133.14. The bonds have a par value of $2,000 and 17 years to maturity. What is the current yield for these bonds?
Sqeekers Co. issued 15-year bonds a year ago at a coupon rate of 4.1 percent. The bonds make semi-annual payments and have a standard par value of $1,000. The YTM on these bonds is 4.5 percent. What is the current price of the bond? Settlement date (MM/DD/YYYY) Maturity date (MM/DD/YYYY) Years to Maturity (# of years) Coupon rate (%) Coupons per year (# per year) Face value (% of par) Yield to maturity (%) Par value ($)