Please answer in excel and show
formulas! Thanks!
Zero Coupon Bond is ISSUED AT DISCOUNT & REDEEMED AT PAR. There are NO COUPONS paid. The difference between the issue price and redemption price is implied yield.
Therefore, Implied Issue Price = Redemption Price i.e. Par Value/(1+Yeild to Maturity) = 1000/(1+0.12) = $892.857
Semi Annual Implied Interest Rate = CAGR = [(Future Price/Current Price)^1/Number of Periods]-1
where, Future Price = Par Value = 100, Current Price = Issue Price = 892.857, Number of Periods = 2*5 = 10
Therefore, [(1000/892.857)^1/10]-1 = (1.12^1/10)-1 = 1.011297-1 = 0.011297 = 1.1297%
1.1297 is Semi Annual Interest Rate.
Therefore, 1st Year's Implied Interest Rate = [(1+Semi Annual Rate)^2]-1 = [(1+0.011297)^2]-1 = 1.02272-1 = 0.02272 = 2.272%
Please answer in excel and show formulas! Thanks! Zero-coupon bond. What is the annual implied interest...
Zero-coupon bond. Wesley Company will issue a zero-coupon bond this coming month. The projected bond yield is 7%. If the par value is $1,000, what is the bond's price using a semiannual convention if a. the maturity is 10 years? b. the maturity is 35 years? c. the maturity is 70 years? d. the maturity is 80 years? a. What is the price of the bond using a semiannual convention if the maturity is 10 years? $ (Round to the...
Zero-coupon bond. Wesley Company will issue a zero-coupon bond this coming month. The projected bond yield is 8%. If the par value is $1,000, what is the bond's price using a semiannual convention if a. the maturity is 15 years? b. the maturity is 35 years? c. the maturity is 60 years? d. the maturity is 80 years? a. What is the price of the bond using a semiannual convention if the maturity is 15 years? $1 (Round to the...
Zero-coupon bond Wesley Company will issue a zero-coupon bond this coming month. The projected bond yield is 5% of the par value is $1,000, what is the bond's price using a semiannual convention it a. the maturity is 20 years? b. the maturity is 30 years? c. the maturity is 50 years? d. the maturity is 100 years? a. What is the price of the bond using a semiannual convention it the maturity is 20 years? (Round to the nearest...
1. What is a bond? 2. Does a zero-coupon bond pay interest? Explain your answer. 3. Endicott Enterprises Inc. has issued thirty-year semiannual coupon bonds with a face value of $1,000. If the annual coupon rate is 14% and the current yield to maturity is 8%, what is the firm’s current price per bond? 4. Delagold Corporation is issuing a zero-coupon bond that will have a maturity of fifty years. The bond’s par value is $1,000, and the current yield...
Zero.coupon bond Addison Company will issue a 2010-coupon bond this coming month. The band's projected yield is 7%. If the par value is $1,000, what is the bond's price using a semiannual convention if a. the maturity is 20 years? b. the matunty is 30 years? c. the maturity is 50 years? d. the matunity is 100 years? a. What is the price of the bond using a semiannual convention if the maturity is 20 years? (Round to the nearest...
A Treasury bond futures contract has a settlement price of 89'08. What is the implied annual yield? Price in whole units ? Price in 32nds ? Maturity in semiannual period ? Semiannual coupon payments ? Maturity value ? Price ? Semiannual implied yield ? Annual implied yield ?
Zero-coupon bond. Addison Company will issue a zero-coupon bond this coming month. The bond's projected yield is 8%. If the par value is $5,000, what is the bond's price using a semiannual convention if a. the maturity is 10 years? b. the maturity is 35 years? c. the maturity is 70 years? d. the maturity is 100 years?
Solution is needed in EXCEL format please (EXCEL formula needed) Example 1: Bond Pricing As with any financial instrument, the price of a bond is just the present value of the future cash flows. What is the price of a bond with semiannual coupon payments and the following characteristics? Coupon rate: 8.00% Years to maturity: 10 Yield to maturity: 7.50% Par value: $ 1,000 Since the bond has semiannual payments, the coupon payments will be: Coupon payments: Of course,...
3-Leaf Company is about to issue a bond with semiannual coupon payments, an annual coupon rate of 12%, and par value of $3,000. The yield to maturity for this bond is 10% a. What is the price of the bond if it matures in 15 years? a. What is the price of the bond if it matures in 15 years? (Round to the nearest cent.)
What is the price of a $1,000 par value, semi-annual coupon bond with 5 years to maturity, a coupon rate of 09.70% and a yield-to-maturity of 04.40%? Please show formula and solve using excel.