Question

Please post with mathematical formulas, not an excel sheet5. You have decided to invest in two bonds. Bond X is an n-year bond with semiannual coupons, while bond Y is zero-coupon bon

0 0
Add a comment Improve this question Transcribed image text
Answer #1

For Bond X,

As the present value of the Redemption amount (R) is 381.5,, we get the following equation

381.5 = R / (1+i)n, ( eq. 1) where i is the yield of Bond X as well as that of bond Y

For Bond Y, the redemption amount is the same i.e. R , so we get the equation as

647.80. = R/(1+i)(n/2) , (eq. 2)

Dividing equation 1 and 2, we get

381.5/647.8 = 1/ (1+i)(n/2)   (eq. 3)

Substituting the above in equation 2, we get

647.8 = R* 381.5/647.8 which gives

R = 647.8*647.8/381.5 = 1099. 986 or apx. 1100

Taking R as 1100 , we now get the price(P) for Bond X as

P= present value of Cash flows of Bond X  

P = 1000* (r/2)/ (1+i)0.5 + 1000*(r/2)/ (1+i)1+....+1000 * (r/2) /(1+i)n+ 1100/(1+i)n

where r= coupon rate of Bond X,

Here, there are 2n terms representing present value of 2n semiannual coupon payments and last term is present value of Redemption amount

By applying GP formula

P = 1000 *(r/2) * (1- (1+i)-n) / ((1+i)(1/2) -1) + 1100 * (1+i)-n

From equation 3, we know. (1+i)-(n/2) = 381.5/647.8 = 0.588916

So, (1+i)-n = 0.5889162= 0.346822

And Using the Binomial approximation ,

(1+i)(1/2)= 1+i/2+.... very small terms = 1+i/2

So, (1+i)(1/2)-1 = i/2

Substituting in the price equation we get

P = 1000 *(r/2) * (1-0.346822) / ( i/2) + 1100 * 0.346822

= 1000 * (r/i) * 0.653178 + 381.504

= 653.178 * 1.03125 + 381.504

= 1055.09 or appx. 1055

So, the price of the bond is 1055

Add a comment
Know the answer?
Add Answer to:
Please post with mathematical formulas, not an excel sheet 5. You have decided to invest in two bonds. Bond X is an n-ye...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Please answer with mathematical formulas, not an excel sheet please 3. John borrows an amount at...

    Please answer with mathematical formulas, not an excel sheet please 3. John borrows an amount at an annual interest rate of 8%. He repays all interest and principal in a lump sum at the end of ten years John uses the amount borrowed to purchase a 5-year bond with a par value of 1000 with coupons at a nominal rate of 10% payable semiannually, with the first coupon paid at the end of 6-month period from now. The bond is...

  • You have a choice of two bonds X and Y. Bond X is a $1,000 par...

    You have a choice of two bonds X and Y. Bond X is a $1,000 par value30-year 8% semiannual coupon government bond selling at $920. Bond Y is a $1,000 par value 20-year 10% semiannual coupon corporate bond selling at $1,057. You believe that the yield curve for government securities will be flat after 5 years at 7.5% compounded semiannually, while that for the corporate bond Y will be 8.5% compounded semiannually after 5 years. If you can re-invest coupons...

  • please use excel coding Bond X is a premium bond making semiannual payments. The bond pays...

    please use excel coding Bond X is a premium bond making semiannual payments. The bond pays a 9 percent coupon, has a YTM of 7 percent, and has 13 years to maturity. Bond Y is a discount bond making semiannual payments. This bond pays a 7 percent coupon, has a YTM of 9 percent, and also has 13 years to maturity. What is the dollar price of each bond today? If interest rates remain unchanged, what do you expect the...

  • Course: Theory of Interest (Actuarial Science) Chapter: Bonds Problem: An n-year zero coupon bond with a...

    Course: Theory of Interest (Actuarial Science) Chapter: Bonds Problem: An n-year zero coupon bond with a par value of $1,000 was purchased for $600. A 2n-year $1000 par value bond with annual coupons of $X was purchased for $850. A 3n-year $1000 part value bond with annual coupons of $X was purchased for $P. All 3 bonds have the same yield rate. Compute P. (Hint: Use zero-coupon bond to find the value of v^n. Use the second bond to solve...

  • please show work in excel formula, Thanks N Chamberlain Co. wants to issue new 20-year bonds...

    please show work in excel formula, Thanks N 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? 1/1/2000 1/1/2020 Settlement date Maturity date Annual coupon rate Coupons per year Redemption value (% of par)...

  • PLEASE WRITE THE ANSWER AS A EXCEL FORMULA X 5 Calculating a bond price - Excel...

    PLEASE WRITE THE ANSWER AS A EXCEL FORMULA X 5 Calculating a bond price - Excel ? X = INSERT - Sign In FILE HOME PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 AA - A Paste B IU Alignment Number Cells Editing 5.12 oints Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Skipped A1 AB E F G H eBook Print Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9...

  • You are given the following: Bond 1 Bond 2 Coupon rate of 4%, payable semi-annually Coupon...

    You are given the following: Bond 1 Bond 2 Coupon rate of 4%, payable semi-annually Coupon rate of 8%, payable quarterly Effective annual yield rate is 5% Effective annual yield rate is X 20 years bond 10 years bond Redemption Value is $100 Redemption Value is $100 Price is $Y Price is $Y Find X 0.0500 0.075 0.0975 0.1200 0.1025

  • MUST BE DONE ON EXCEL USING EXCEL FORMULAS 2) You are looking at a bond with...

    MUST BE DONE ON EXCEL USING EXCEL FORMULAS 2) You are looking at a bond with 13 years to maturity, has a coupon rate of 4% paid semi- annually, and a price of 105. What is the Yield to Maturity of the bond?

  • 8. You have just received an inheritance of $20,000. You wish to invest in fixed income...

    8. You have just received an inheritance of $20,000. You wish to invest in fixed income securities such as bonds, which you think are less risky than stocks. After some research, you have narrowed down your choices to the following three fixed income securities: One-year Treasury Bill: Face value of $1000 Yield to maturity of 1.74% Coupon Bond A: Two years to maturity Face value of $1000 Coupon rate of 3%, with semi-annual coupon payments Price multiple of face value...

  • 6. Bond Valuation A BBB-rated corporate bond has a yield to maturity of 9%. AU.S. Treasury...

    6. Bond Valuation A BBB-rated corporate bond has a yield to maturity of 9%. AU.S. Treasury security has a yield to maturity of 7.5% These yields are quoted as APRS with semiannual compounding. Both bonds pay semiannual coupons at an annual rate of 8.4% and have five years to maturity a. What is the price (expressed as a percentage of the face value) of the Treasury bond? b. What is the price (expressed as a percentage of the face value)...

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