Yield Curve and Bond Valuation Worksheet

Action Items: 
Go to the HYPERLINK “https://www.federalreserve.gov/releases/h15/data.htm”https://www.federalreserve.gov/releases/h15/data.htm to examine historical daily interest rates onU.S. Treasuries. 
Scroll down to “Treasury constant maturities” and in the row “1-month” under “Nominal” click “Business day.” 
As you can see, rates on the one-month U.S. Treasury bill are provided for each business day from July 31, 2001 to the present. For this assignment you are asked to pick a business date of 2010 this month.

Yield Curve and Bond Valuation Worksheet

Action Items:

  1. Go to the http://www.federalreserve.gov/releases/h15/data.htm to examine historical daily interest rates on U.S. Treasuries.
  2. Scroll down to “Treasury constant maturities” and in the row “1-month” under “Nominal” click “Business day.”

As you can see, rates on the one-month U.S. Treasury bill are provided for each business day from July 31, 2001 to the present. For this assignment you are asked to pick a business date of 2010 this month. look

Then, using this row and the subsequent rows below it under “Treasury Constant Maturities” determine the shape of the yield curve (See Figure 6.11in the textbook for examples of Treasury yield curves) on that date five years ago based on the rates published by the Fed by completing the table below for the listed Treasury maturities (see example below):

 

Business Date Chosen Five Years Ago 4 Dec 2010
1-month Nominal T-bill Rate on that Date  
3-month Nominal T-bill Rate on that Date  
6-month Nominal T-bill Rate on that Date  
1-year Nominal T-note Rate on that Date  
5-year Nominal T-note Rate on that Date  
10-year Nominal T-note Rate on that Date  
20-year Nominal T-bond Rate on that Date  
30-year Nominal T-bond Rate on that Date  

Answer the following questions:

  1. On your selected date was the yield curve rising, falling, or flat? What explanation(s) would you give for this shape?

 

 

 

 

 

 

 

  1. Assume that two U.S. Treasury securities were purchased at par ($1000) on 4 Dec 2010: 1) a 10-year T-note and 2) a 20-year T-bond. Also assume that for each of the two securities the reported nominal rate that you found above was the coupon rate at issuance.

 

Assuming semi-annual coupon payments, calculate the value of each bond today after 5 years based on the current 5-year Treasury constant maturity nominal rate for the original 10-year note and a current 15-year rate (assume it is the average of the current Treasury constant maturity nominal 10- and 20-year rates) for the original 20-year bond at http://www.federalreserve.gov/releases/h15/data.htm.

 

  1. Complete the following tables (see example below):

 

10-Year Bond Purchased for $1000 5 Years Ago

Original Value $1000
Coupon Rate (From table you completed above at the chosen date from 5 years ago, the original 10-year Nominal T-bond Rate divided by 2 for semi-annual payments)  
Current 5-Year Yield to Maturity (The most recent 5-year Nominal T-note Rate reported at the Fed site divided by 2 for semi-annual payments)  
Number of Semi-Annual Periods Remaining 10
Current Value*  
Gain or Loss on the Bond over the 5 years  

 

20-Year Bond Purchased for $1000 5 Years Ago

Original Value $1000
Coupon Rate (From table you completed above at the chosen date from 5 years ago, the original 20-year Nominal T-bond Rate divided by 2 for semi-annual payments)  
Current 15-Year Yield to Maturity (Take the average of the most recent 10- and 20-year Nominal T-bond Rates reported at the Fed site, and then divide this average rate by 2 for semi-annual payments)  
Number of Semi-Annual Periods Remaining 30
Current Value*  
Gain or Loss on the Bond over the 5 years  

*Current Value = PVBond = Coupon Payment +

 

  1. b) Did you gain or lose more on one bond relative to the other? Explain.

 

 

(NOTE: Students, the below is for example purposes only)

 

Assume today is June 20, 2011. I go back 5 years to 6/20/2006 and find the following rates (Should the date you choose not be a business day on any of these past dates then pick the rate on the next business day):

 

Business Date Chosen Five Years Ago 6/20/2006
1-month Nominal T-bill Rate on that Date 4.70%
3-month Nominal T-bill Rate on that Date 4.92%
6-month Nominal T-bill Rate on that Date 5.24%
1-year Nominal T-note Rate on that Date 5.23%
5-year Nominal T-note Rate on that Date 5.13%
10-year Nominal T-note Rate on that Date 5.15%
20-year Nominal T-bond Rate on that Date 5.33%
30-year Nominal T-bond Rate on that Date 5.19%
  1. Complete the following tables (see example below):

 

10-Year Bond Purchased for $1000 5 Years Ago

Original Value $1000
Coupon Rate (From table above at the chosen date from 5 years ago, the original 10-year Nominal T-bond Rate divided by 2 for semi-annual payments) 5.15%/2 = 2.575%
Current 5-Year Yield to Maturity (The most recent 5-year Nominal T-note Rate reported at the Fed site divided by 2 for semi-annual payments) 1.55%/2 = 0.775%
Number of Semi-Annual Periods Remaining 10
Current Value* See below.
Gain or Loss on the Bond over the 5 years See below.

*Current Value = PVBond = Coupon Payment +

PVB =

= $25.75[9.58663801] + $1000[0.92570356]= $246.86 + $925.70                               = $1,172.56

I compare this value with the initial investment of $1000 at par.

20-Year Bond Purchased for $1000 5 Years Ago

Original Value $1000
Coupon Rate (From table above at the chosen date from 5 years ago, the original 20-year Nominal T-bond Rate divided by 2 for semi-annual payments) 5.33%/2 = 2.665%
Current 15-Year Yield to Maturity (Take the average of the most recent 10- and 20-year Nominal T-bond   Rates reported at the Fed site, and then divide this average rate by 2 for semi-annual payments) 15 year average: (2.97% + 3.99%)/2= 3.48%

Semi-annual: 3.48%/2 = 1.74%

Number of Semi-Annual Periods Remaining 30
Current Value* See below.
Gain or Loss on the Bond over the 5 years See below.

*Current Value = PVBond = Coupon Payment +

PVB =

= $26.65[23.21825346] + $1000[0.59600239]= $618.77 + $596.00                               = $1,214.77

p(2)

Place your order now to enjoy great discounts on this or a similar topic.

People choose us because we provide:

Essays written from scratch, 100% original,

Delivery within deadlines,

Competitive prices and excellent quality,

24/7 customer support,

Priority on their privacy,

Unlimited free revisions upon request, and

Plagiarism free work,

 

r.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Yield Curve and Bond Valuation Worksheet

Action Items:

  1. Go to the http://www.federalreserve.gov/releases/h15/data.htm to examine historical daily interest rates on U.S. Treasuries.
  2. Scroll down to “Treasury constant maturities” and in the row “1-month” under “Nominal” click “Business day.”

As you can see, rates on the one-month U.S. Treasury bill are provided for each business day from July 31, 2001 to the present. For this assignment you are asked to pick a business date of 2010 this month. look

Then, using this row and the subsequent rows below it under “Treasury Constant Maturities” determine the shape of the yield curve (See Figure 6.11in the textbook for examples of Treasury yield curves) on that date five years ago based on the rates published by the Fed by completing the table below for the listed Treasury maturities (see example below):

 

Business Date Chosen Five Years Ago 4 Dec 2010
1-month Nominal T-bill Rate on that Date  
3-month Nominal T-bill Rate on that Date  
6-month Nominal T-bill Rate on that Date  
1-year Nominal T-note Rate on that Date  
5-year Nominal T-note Rate on that Date  
10-year Nominal T-note Rate on that Date  
20-year Nominal T-bond Rate on that Date  
30-year Nominal T-bond Rate on that Date  

Answer the following questions:

  1. On your selected date was the yield curve rising, falling, or flat? What explanation(s) would you give for this shape?

 

 

 

 

 

 

 

  1. Assume that two U.S. Treasury securities were purchased at par ($1000) on 4 Dec 2010: 1) a 10-year T-note and 2) a 20-year T-bond. Also assume that for each of the two securities the reported nominal rate that you found above was the coupon rate at issuance.

 

Assuming semi-annual coupon payments, calculate the value of each bond today after 5 years based on the current 5-year Treasury constant maturity nominal rate for the original 10-year note and a current 15-year rate (assume it is the average of the current Treasury constant maturity nominal 10- and 20-year rates) for the original 20-year bond at http://www.federalreserve.gov/releases/h15/data.htm.

 

  1. Complete the following tables (see example below):

 

10-Year Bond Purchased for $1000 5 Years Ago

Original Value $1000
Coupon Rate (From table you completed above at the chosen date from 5 years ago, the original 10-year Nominal T-bond Rate divided by 2 for semi-annual payments)  
Current 5-Year Yield to Maturity (The most recent 5-year Nominal T-note Rate reported at the Fed site divided by 2 for semi-annual payments)  
Number of Semi-Annual Periods Remaining 10
Current Value*  
Gain or Loss on the Bond over the 5 years  

 

20-Year Bond Purchased for $1000 5 Years Ago

Original Value $1000
Coupon Rate (From table you completed above at the chosen date from 5 years ago, the original 20-year Nominal T-bond Rate divided by 2 for semi-annual payments)  
Current 15-Year Yield to Maturity (Take the average of the most recent 10- and 20-year Nominal T-bond Rates reported at the Fed site, and then divide this average rate by 2 for semi-annual payments)  
Number of Semi-Annual Periods Remaining 30
Current Value*  
Gain or Loss on the Bond over the 5 years  

*Current Value = PVBond = Coupon Payment +

 

  1. b) Did you gain or lose more on one bond relative to the other? Explain.

 

 

(NOTE: Students, the below is for example purposes only)

 

Assume today is June 20, 2011. I go back 5 years to 6/20/2006 and find the following rates (Should the date you choose not be a business day on any of these past dates then pick the rate on the next business day):

 

Business Date Chosen Five Years Ago 6/20/2006
1-month Nominal T-bill Rate on that Date 4.70%
3-month Nominal T-bill Rate on that Date 4.92%
6-month Nominal T-bill Rate on that Date 5.24%
1-year Nominal T-note Rate on that Date 5.23%
5-year Nominal T-note Rate on that Date 5.13%
10-year Nominal T-note Rate on that Date 5.15%
20-year Nominal T-bond Rate on that Date 5.33%
30-year Nominal T-bond Rate on that Date 5.19%
  1. Complete the following tables (see example below):

 

10-Year Bond Purchased for $1000 5 Years Ago

Original Value $1000
Coupon Rate (From table above at the chosen date from 5 years ago, the original 10-year Nominal T-bond Rate divided by 2 for semi-annual payments) 5.15%/2 = 2.575%
Current 5-Year Yield to Maturity (The most recent 5-year Nominal T-note Rate reported at the Fed site divided by 2 for semi-annual payments) 1.55%/2 = 0.775%
Number of Semi-Annual Periods Remaining 10
Current Value* See below.
Gain or Loss on the Bond over the 5 years See below.

*Current Value = PVBond = Coupon Payment +

PVB =

= $25.75[9.58663801] + $1000[0.92570356]= $246.86 + $925.70                               = $1,172.56

I compare this value with the initial investment of $1000 at par.

20-Year Bond Purchased for $1000 5 Years Ago

Original Value $1000
Coupon Rate (From table above at the chosen date from 5 years ago, the original 20-year Nominal T-bond Rate divided by 2 for semi-annual payments) 5.33%/2 = 2.665%
Current 15-Year Yield to Maturity (Take the average of the most recent 10- and 20-year Nominal T-bond   Rates reported at the Fed site, and then divide this average rate by 2 for semi-annual payments) 15 year average: (2.97% + 3.99%)/2= 3.48%

Semi-annual: 3.48%/2 = 1.74%

Number of Semi-Annual Periods Remaining 30
Current Value* See below.
Gain or Loss on the Bond over the 5 years See below.

*Current Value = PVBond = Coupon Payment +

PVB =

= $26.65[23.21825346] + $1000[0.59600239]= $618.77 + $596.00                               = $1,214.77

I compare this value with the initial investment of $1000 at par.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Order Similar Assignment Now!

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered within 4 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: