ZuoTi.Pro
Question

Claire’s issued a 7 year, 6.125% coupon bond with a $100 par value in January 2013...

Claire’s issued a 7 year, 6.125% coupon bond with a $100 par value in January 2013 that matures in January 2020. The table below has the price of the bond when issued and for the past four Januaries. Determine the yield to maturity for each of the dates.

If an investor bought this bond January 2015 and sold it in January 2017 (receiving two coupon payment) what would be the return on investment?

Price Jan-13 $100.00

Jan-14 $70.00

Jan-15 $30.00

Jan-16 $17.50

Jan-17 $50.00

If you can use excel that would be much appreciated!

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

1) The picture of excel sheet shows the formula calculation used for YTM in the formula bar.

2) 6.125% or 6.13% are same just rounded off.

3) ROI = Current Value- Begining Value / Begining Value

= 50-30 / 30

= 66.67 %

Hope this was helpful :)


Bock1 Earal Sanjana Dudheria Insert Page Layout Formulas Data Review View Help Tell me what you want to do Cut Wrap TextPercentageNormalBad Good Cambria Copy Fnmat Printer Sort & Find & iller Sele:l B I U--, C)-스, Merge &eenter, er, % , sas, C Conditional Format a s Neutral Calculation Check Cel Insert Daletr Foimat = Clear. Furmalling Table Ciptoerc Number Eciting U8 Answer to Question Number Particulars Face Value Annual Coupon Rate Years To Maturity Bond Price YTM 201320142015 2016 2017 100 6.13% 100 6.13% 100 6·13% 100 6.13% 100 6.13% 17.5 41% 706 36% 30 11%41 10 16 200 21 26 + 100%

0 0
Add a comment
Know the answer?
Add Answer to:
Claire’s issued a 7 year, 6.125% coupon bond with a $100 par value in January 2013...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • A bond face value is $1000, with a 6-year maturity. Its annual coupon rate is 7%...

    A bond face value is $1000, with a 6-year maturity. Its annual coupon rate is 7% and issuer makes semi-annual coupon payments. The annual yield of maturity for the bond is 6%. The bond was issued on 7/1/2017. An investor bought it on 8/1/2019. Calculate its dirty price, accrued interests, and clean price.

  • 1. In january 2016, Anheuser-Busch issued an outstanding bond that pays at a 3.3% coupon rate,...

    1. In january 2016, Anheuser-Busch issued an outstanding bond that pays at a 3.3% coupon rate, matures in january 2023, and has a yield maturity of 2.82%. In January 2017, Santander Holdings issued an outstanding bond that pays a 3.571% coupon rate, matures in january 2023, and has a yield maturity of 3.341% a. Does the Anheuser-Busch bond sell at premium, par, or discount? How do you Know? How about Santander bond? b. Which bond would you guess has a...

  • A government bond issued in France has a coupon rate of 7 percent, a face value...

    A government bond issued in France has a coupon rate of 7 percent, a face value of 100 euros, and matures in five years. The bond pays annual interest payments. Calculate the price of the bond (in euros) if the yield to maturity is 3.5 percent.

  • It is January 9, 2017. The price of a Treasury bond with a 5% coupon that...

    It is January 9, 2017. The price of a Treasury bond with a 5% coupon that matures on Oct 12, 2030, is quoted as 102-02. What is the cash price? (This bond pays coupons on Oct 12 and Apr 12. Excel might be helpful in calculating the difference in dates.) (required precision: 0.01 +/- 0.01)

  • It is January 9, 2017. The price of a Treasury bond with a 6% coupon that...

    It is January 9, 2017. The price of a Treasury bond with a 6% coupon that matures on Oct 12, 2030, is quoted as 102-04. What is the cash price? (This bond pays coupons on Oct 12 and Apr 12. Excel might be helpful in calculating the difference in dates.) (required precision: 0.01 +/- 0.01)

  • A bond with a par value of $100 is currently trading at a price of $104....

    A bond with a par value of $100 is currently trading at a price of $104. The bond has a coupon rate of 4.16%, and it has exactly 10 years remaining until maturity. What is the bond’s current yield? An investor buys a bond with a $100 par value and a 5% coupon rate for $97. The bond pays interest semiannually. Exactly one year later, just after receiving the second coupon payment, the investor sells the bond for $96. What...

  • Bond Valuation A 20-year, 8% semiannual coupon bond with a par value of $1,000 sells for...

    Bond Valuation A 20-year, 8% semiannual coupon bond with a par value of $1,000 sells for $1,100. (Assume that the bond has just been issued.) 20 Basic Input Data: Years to maturity: Periods per year: Periods to maturity: Coupon rate: Par value: Periodic payment: Current price 8% $1,000 $1,100 c. What would be the price of a zero coupon bond if the face value of the bond is $1,000 in 3 years and if the yield to maturity of similary...

  • Question 2 A firm issues a bond today with a $1,000 face value, an 8% coupon...

    Question 2 A firm issues a bond today with a $1,000 face value, an 8% coupon interest rate, and a 25-year maturity. An investor purchases the bond for $1,000. (2.1) What is the yield to maturity (YTM)? Explain. (2.2) Suppose the investor bought the bond described previously for $900. What is the YTM? (2.3) Suppose the bond described previously has a price of $1,100 five years after it is issued. What is the YTM at that time?

  • Company A issued a 5 year 4.5% coupon bond with a stated value (par) of $12,000,000...

    Company A issued a 5 year 4.5% coupon bond with a stated value (par) of $12,000,000 on September 30, 2019 when the market rate of interest (yield to maturity) was 3.75%. The bond pays interest semiannually. 1. What is the price of the bond? 2. Now assume the above bond was settled (purchased) on 12/31/2019. a. What is the cash (dirty) price of the bond? b. What is the ask (quote or clean) price of the bond?

  • Bond Valuation A 20-year, 8% semiannual coupon bond with a par value of $1,000 sells for...

    Bond Valuation A 20-year, 8% semiannual coupon bond with a par value of $1,000 sells for $1,100. (Assume that the bond has just been issued.) Basic Input Data: Years to maturity: Periods per year. Periods to maturity: Coupon rate: Par value: Periodic payment: Current price 8% $1,000 $1,100 b. What would be the price of the bond if market interest rates change to: 12% 6% 10% Nominal market rate, r: Value of bond:

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT