Question

Please do not use excel and use financial formulas 1. Consider the following five bonds, all...

Please do not use excel and use financial formulas

1. Consider the following five bonds, all with notional amounts of $100.00, that are trading in a liquid market on September 30th 2018

i. T-bill 1: 1 year maturity, no annual coupon, market price = $99.01

ii. T-bill 1: 3 year maturity, no annual coupon, market price = $92.86

iii. Bond 1: 4 year maturity, 4% annual coupon, market price = $103.92

iv. Bond 2: 5 year maturity, 2% annual coupon, market price = $95.52

v. Bond 3: 5 year maturity, 8% annual coupon, market price = $123.31

a. How would you characterize the market that these bonds are trading in? What does this imply with respect to pricing a new bond that is just introduced into the market, with cashflow dates that align with the exiting bonds?

b. Given this market, what are the discount factors and implied zero coupon rates associated with annual terms 1 – 5 years? (show all your work)

c. What would be the price of a new bond introduced into the market with a $100 notional, 4 year maturity and an annual coupon rate of 3%?

d. Suppose another T-bill is introduced into the market with a $100 notional (no coupon) and a maturity date of 1.5 years. What is the challenge here and how might you address it? What would be a good price for this T-bill?

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

Ans a) The market currently is not yielding (YTM) more than 3% on 5 year 8% coupon bond. This signifies that some bonds are priced at a premium with respect to YTM percentages eventually leading to a loss in overall return at maturity when compared to annual coupon rate. YTM for first two bonds can be calculated as (Face Vale/Market Price)^1/Year to Maturity -1 which gives YTM as 1.00% for (i) T Bill and 2.50% for (ii) T Bill respectively. The other bonds can be calculated as Coupon Paid on Bond + (Face Value-Current Price)/Term this whole will be divided by (Face Value+Current Price)/2 this will give YTM for all Coupon rated bonds which will come as (iii) 2.96%; (iv) 2.96% and (v) 3.00%.

Pricing of new Bonds with Coupon rate more than 3.00% should be at a premium otherwise it can be Zero Coupon Bond where Market will price it effectively at 2.50% YTM. The market is highly liquid which means too much cash in the market but too few takers.

Ans b) The answer to this Question is already provided above with Year 1 T Bill yielding 1.00%, Year 3 T Bill yielding 2.50% and Year 4 to Year 5 Bonds yields ranging from 2.96% to 3.00%.

Ans c) Cash flows for this bond will be Year 1 $3.00 coupon payment, Year 2 $3 coupon payment, Year 3 $3 coupon payment, Year 4 $3 and $100 notional price so $103.00. If we use YTM of 2.96% as our discount rate then Price of the Bond should be PV of Cash Flow 1: $3*(1/(1+0.0296)^1)=2.914, likewise PV of Cash Flow 2:$3*(1/1+0.0296)^2)=2.830, PV of Cash Flow 3: $3*(1/1+0.0296)^3)=2.749 and Cash Flow 4: $103*(1/1+0.0296)^4)=91.656 thus total Value of all Cash Flows or Price of Bond= $100.149.

Ans d) The challenge in the T Bill for 1.5 years maturity date is that we know the annualized yield to maturity of 1.00% and semi annual rate is not available. Thus what we can do to price the T Bill is to use annualized YTM rate and get the payment semi annually thus we can discount at the rate 0.50% for 3 cash flows. Thus the formula would be PV Cash Flows 1= 0.50*DF@ the price of T Bill will be $100.00 only

Add a comment
Know the answer?
Add Answer to:
Please do not use excel and use financial formulas 1. Consider the following five bonds, all...
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
  • Consider the following five bonds, all with notional amounts of $100.00, that are trading in a...

    Consider the following five bonds, all with notional amounts of $100.00, that are trading in a liquid market on September 30th 2018 T-bill 1: 1 year maturity, no annual coupon, market price = $99.01 T-bill 1: 3 year maturity, no annual coupon, market price = $92.86 Bond 1: 4 year maturity, 4% annual coupon, market price = $103.92 Bond 2: 5 year maturity, 2% annual coupon, market price = $95.52 Bond 3: 5 year maturity, 8% annual coupon, market price...

  • Consider the following five bonds, all with notional amounts of $100.00, that are trading in a...

    Consider the following five bonds, all with notional amounts of $100.00, that are trading in a liquid market on September 30th 2018 T-bill 1: 1 year maturity, no annual coupon, market price = $99.01 T-bill 1: 3 year maturity, no annual coupon, market price = $92.86 Bond 1: 4 year maturity, 4% annual coupon, market price = $103.92 Bond 2: 5 year maturity, 2% annual coupon, market price = $95.52 Bond 3: 5 year maturity, 8% annual coupon, market price...

  • Consider the following five bonds, all with notional amounts of $100.00, that are trading in a...

    Consider the following five bonds, all with notional amounts of $100.00, that are trading in a liquid market on September 30th 2018 T-bill 1: 1 year maturity, no annual coupon, market price = $99.01 T-bill 1: 3 year maturity, no annual coupon, market price = $92.86 Bond 1: 4 year maturity, 4% annual coupon, market price = $103.92 Bond 2: 5 year maturity, 2% annual coupon, market price = $95.52 Bond 3: 5 year maturity, 8% annual coupon, market price...

  • Please copy and paste your Excel bond calculations under each relevant question. Do NOT submit an...

    Please copy and paste your Excel bond calculations under each relevant question. Do NOT submit an Excel spreadsheet, only your word document with your name on it. A) A 30-year Treasury bond expiring on February 15, 2048 with a 3% coupon has a yield of 5%. Calculate its price. Assume the bond’s settlement date is June 30th, 2018. B) You want to buy a bond that pays an annual coupon of 4.2% on March 31st of each year. On June...

  • Use financial formulas in Excel to show work for Requirement #1 and #5 of each part...

    Use financial formulas in Excel to show work for Requirement #1 and #5 of each part Bill Corporation issued six-year, 7% bonds with a total face value of $1,250,000 on January 1, 2019. Interest is paid semi-annually on June 30 and December 31. The market rate of interest on this date was 10.0%. Bill uses the effective interest rate method. Required: Determine the proceeds of the bond sale on 1/1/19. Explain your method of calculation. Using the present value of...

  • Please answer ALL, Thank you ! 1. Ivanhoe Inc. has seven-year bonds outstanding that pay a...

    Please answer ALL, Thank you ! 1. Ivanhoe Inc. has seven-year bonds outstanding that pay a 11 percent coupon rate. Investors buying these bonds today can expect to earn a yield to maturity of 6.950 percent. What is the current value of these bonds? Assume annual coupon payments -Current Value: 2. Barbara Jones is looking to invest in a three-year bond that makes semi-annual coupon payments at a rate of 5.375 percent. If these bonds have a market price of...

  • Question 9. [19 points) PART A. Consider the following spot rates on 1-year zero-coupon bonds: Year...

    Question 9. [19 points) PART A. Consider the following spot rates on 1-year zero-coupon bonds: Year Spot Rates (or Yields to Maturity) 1 2 3 8.0% 8.5% 9.0% 9.5% 4 a. What is the equilibrium price of a 4-year, 9% coupon bond paying a principal of $100 at maturity and coupons annually? Question 9. [19 points] PART A. Consider the following spot rates on 1-year zero-coupon bonds: Year Spot Rates (or Yields to Maturity) 1 2 3 4 8.0% 8.5%...

  • please explain how to calculate in a financial calculator Question 2. MTV Corporation has 7 percent coupon bonds on...

    please explain how to calculate in a financial calculator Question 2. MTV Corporation has 7 percent coupon bonds on the market with a par of $1,000 and 8 years left to maturity. The bonds make semi-annual interest payments. If the market interest rate on these bonds is 6 percent, what is the current bond price? Question 3. Jones Corporation has zero coupon bonds on the market with a par of $1,000 and 8 years left to maturity. If the market...

  • Calculate the price of 8.0% semi-annual bond. The bond was originally issued with a 10-year term...

    Calculate the price of 8.0% semi-annual bond. The bond was originally issued with a 10-year term to maturity and exactly five years remain until maturity. The rates on new 10-year semi-annual bonds of comparable risk are 7.0% and on new five-year semi-annual bonds of comparable risk are 6.0%. Suppose you had an 8%, $10,000 semi-annual bond with three years remaining to maturity. The yield on new three-year bonds of comparable quality is 6%. Calculate what your bond is worth in...

  • Bond Coupon Rate Maturity Year Par Value 1 7.5% 2032 1000 2 8.25% 2029 1000 3...

    Bond Coupon Rate Maturity Year Par Value 1 7.5% 2032 1000 2 8.25% 2029 1000 3 6.0% 2023 1000 a.) Assuming that bonds pay annual coupon, estimate the market value of each bond at a discount rate of 7.4% b.) Assuming that bonds pay annual coupon, what will happen to the price of each bond if market rates suddenly decrease from 7.4% to 6.2%? Which of the three bonds will have the greatest percentage change in price? c.) Assuming that...

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