Question

Assume that a 10-year, 2.5% annual coupon bond with semiannual (two periods per year) payments has...

Assume that a 10-year, 2.5% annual coupon bond with semiannual (two periods per year) payments has a par value of $1,000. Assume the bond can be called at the five-year mark (i.e., in 5 years) at a call price of $1,100. The bond currently sells for $950. Employ the Excel file to answer the following questions:

A) Assume the current annual market rate is 5% and the periodic market rate is half of the market rate. Use the Excel PV function to calculate the present value of the callable bond. Note for the PV function, a negative sign should be placed on both the payment and future value.

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

CELL REFERENCE IS GIVEN FOR EASY UNDERSTANDING

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A 20-year, 8% annual coupon bond with a par value of $1,000 may be called in...
A 20-year, 8% annual coupon bond with a par value of $1,000 may be called in 5 years at a call price of $1,040. The bond sells for $1,100. (Assume that the bond has just been issued.) Basic Input Data: Years to maturity: 20 Periods per year: 1 Periods to maturity: 20 Coupon rate: 8% Par value: $1,000 Periodic payment: $80 Current price $1,100 Call price: $1,040 Years till callable: 5 Periods till callable: 5 a.   What is the bond's...
You purchase for $900, $1000 par value 10-year 8% coupon bond with semiannual payments that is...
You purchase for $900, $1000 par value 10-year 8% coupon bond with semiannual payments that is callable in 5 years at $1,100. What is the bonds yield to call? (YTC)
In Excel with formulas-- A 10-year, 12 % semiannual coupon bond with a par value of...
In Excel with formulas-- A 10-year, 12 % semiannual coupon bond with a par value of $1,000 may be called in 7 years, at a call price of $1,100. The bond sells for $1,500. (Assume the bond has just been issued). a. What is the bond’s yields to maturity? b. What is the bond’s current yield? c. What is the bond’s capital gain or loss yield in the first year? d. What is the bond’s yield to call?
3) A bond currently sells for $850.  It has an eight-year maturity, an annual coupon of $80...
3) A bond currently sells for $850.  It has an eight-year maturity, an annual coupon of $80 but paid semi-annually, and a par value of $1,000. This bond has a callable feature. If this bond can be called after 5 years, for $1,025. (1) What is its annual yield to maturity?   (2) What is its current yield?     (3) What is the bond’s nominal yield to call (YTC)? (4)   If you bought this bond, would you be more likely to earn the YTM...
Assume that you are considering the purchase of a 10-year, noncallable bond with an annual coupon...
Assume that you are considering the purchase of a 10-year, noncallable bond with an annual coupon rate of 5%. The bond has a face value of $1,000, and it makes semiannual interest payments. If you require an 6% yield to maturity on this investment, what is the maximum price you should be willing to pay for the bond? Provide the correct excel function along with inputs
the current market price of Jones Corporation's 4 percent, 5-year bonds is $950. Coupon interest payments...
the current market price of Jones Corporation's 4 percent, 5-year bonds is $950. Coupon interest payments are semiannual, and the par value is equal to $1,000. What is the YTM? If the bond in the prior problem can be called in two years for a call price of $1,100, then what is the yield to call (YTC)?
A $1,000 par, 8%, 10 year bond, which pays semiannual coupons. The bond is callable in...
A $1,000 par, 8%, 10 year bond, which pays semiannual coupons. The bond is callable in 5 years at a call price of $1,050. If the current price of the bond is $1,100, what is its yield to maturity (YTM)?
A 15-year callable bond is currently issued at market interest rate of 7.67%. Annual coupon rate...
A 15-year callable bond is currently issued at market interest rate of 7.67%. Annual coupon rate is 10.5%. The callable bond will be called in 4 years at $1,100. What is YTC? (Assuming the bond is semi-annually compounding.) 1. 13.15% 2. 8.12% 3. 6.32% 4. 10.50% 5. 5.69%
Assume the following convertible bond data: We have a 20-year, 10.5% annual coupon, callable convertible bond...
Assume the following convertible bond data: We have a 20-year, 10.5% annual coupon, callable convertible bond with 5 years of call protection and $1,100 call price, selling at its $1,000 par value. A straight debt issue would require a 12% coupon. Bond will be called at the issue date anniversary if the conversion value is greater than $1,200. Firm’s last dividends paid was $1.48, and its constant growth rate is 8% per year. Stock price is now $20. The bond...
Redd Industries has just issued a callable, $1000 par value, five-year, 5% coupon bond with semiannual...
Redd Industries has just issued a callable, $1000 par value, five-year, 5% coupon bond with semiannual coupon payments. The bond can be called at par in three years or anytime thereafter on a coupon payment date. If the bond is currently trading for $950.00, then its yield to maturity is closest to: Select one: A. 6.5% B. 6.18% C. 6.0% D. 6.8% Redd Industries has just issued a callable, $1000 par value, five-year, 5% coupon bond with semiannual coupon payments....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT