Interest rates Assigmnent - Trading session

User Generated

qlnzna118

Business Finance

Description

. In a recent trading session, the benchmark 30-year Treasury bond’s market price went up

8.62 dollars per $1000 face value to 1032.38 dollars, while its yield fell from .07 to .068. The

bond’s market price then went up another 7.62 dollars per $1000 face value as the yield

fell further to .0665 from .068. Report answers for the following (using average of latest

two bond prices for duration and average of latest three bond prices for convexity):

1. Convexity, using the average of all three market prices of the bond in the denominator

of the formula.

2. First modified duration, using average of first two market prices of the bond in the

denominator of the formula.

3. Second modified duration, using average of second and third prices of the bond.

4. The expected rise in bond price if the interest rate were to fall another 20 basis points

(.002) from .0665, using the average of two modified durations and convexity.

B. Estimate term structure of discount factors, spot rates and forward rates by using data

on five semi-annual coupon paying bonds with $100 face value each: The bonds,

respectively, have 1.25, 5.35, 10.4, 15.15 and 20.2 years to maturity; pay coupon at

annual rates of 4.62, 5.62, 6.62, 7.62, and 8.62 percent of face value; and are trading at quoted

spot market prices in dollars of 98.62, 99.62, 100.62, 101.62 and 102.62. Specify the discount factor

function d(t) by a third degree polynomial with unknown parameters a, b, and c, as

done in class. Using estimated d(t) function, determine spot rate and forward rate

functions by assuming half-year compounding. Then write the values of the following

based on your estimation.

5. Coefficient of parameter a in first bond price equation.

6. Coefficient of parameter b in first bond price equation.

7. Coefficient of parameter c in first bond price equation.

8. Coefficient of parameter a in second bond price equation.

9. Coefficient of parameter b in second bond price equation.

10.Coefficient of parameter c in second bond price equation.

11.Coefficient of parameter a in third bond price equation.

12.Coefficient of parameter b in third bond price equation.

13.Coefficient of parameter c in third bond price equation.

14.Coefficient of parameter a in fourth bond price equation.

15.Coefficient of parameter b in fourth bond price equation.

16.Coefficient of parameter c in fourth bond price equation.

17.Coefficient of parameter a in fifth bond price equation.

18.Coefficient of parameter b in fifth bond price equation.

19.Coefficient of parameter c in fifth bond price equation.

20.Parameter a.

21.Parameter b.

22.Parameter c.

23.Current price of a dollar at 5th year.

24.Current price of a dollar at 7th year.

25.Current price of a dollar at 10th year.

26.Current price of a dollar at 15th year.

27.Spot rate for term 2 year.

28.Spot rate for term 5 year.

29.Spot rate for term 10 year.

30.Spot rate for term 17 year.

31.Forward rate for half year period 2.5 to 3.0 years.

32.Forward rate for half year period 5.5 to 6.0 years.

33.Forward rate for half year period 10.5 to 11.0 years.

34.Forward rate for half year period 15.5 to 16.0 years.

C. Estimate the 2-year, 5-year, and 10-year key rate durations of a 20-year bond carrying a

coupon of 8.6 percent on face value $100 paid semi-annually. The given term structure

starts with 3.1 percent spot rate of interest at time zero and rises at a rate of 0.002 (.2%)

per half year thereafter. Take a 20 basis point (.002) move in each key interest rate to

calculate the key rate durations by the method done in class and given in textbook.

Report answers for the following:

35. Current fair price of the bond with the given term structure.

36. Price change needed to calculate 2-year key rate duration.

37. Price change needed to calculate 5-year key rate duration.

38. Price change needed to calculate 10-year key rate duration.

39. 2-year key rate duration.

40. 5-year key rate duration.

41. 10-year key rate duration.

D. Using the following data on the price of a bond and the corresponding interest rate

(assuming a flat term structure) and regression method, estimate convexity and duration of

the bond:

Price Interest Rate

99 .06

100 .057

101.5 .052

102 .049

105 .044

106.5 .038

108 .033

108.5 .031

110.1 .028

42. What is the estimated value of Duration?

43. What is the estimated value of Convexity?

Unformatted Attachment Preview

Interest rates are expressed as annualized rates for the term specified. Report your interest rate answers as fractional numbers like 0.11 for 11% per year. A. In a recent trading session, the benchmark 30-year Treasury bond’s market price went up 8.62 dollars per $1000 face value to 1032.38 dollars, while its yield fell from .07 to .068. The bond’s market price then went up another 7.62 dollars per $1000 face value as the yield fell further to .0665 from .068. Report answers for the following (using average of latest two bond prices for duration and average of latest three bond prices for convexity): 1. Convexity, using the average of all three market prices of the bond in the denominator of the formula. 2. First modified duration, using average of first two market prices of the bond in the denominator of the formula. 3. Second modified duration, using average of second and third prices of the bond. 4. The expected rise in bond price if the interest rate were to fall another 20 basis points (.002) from .0665, using the average of two modified durations and convexity. B. Estimate term structure of discount factors, spot rates and forward rates by using data on five semi-annual coupon paying bonds with $100 face value each: The bonds, respectively, have 1.25, 5.35, 10.4, 15.15 and 20.2 years to maturity; pay coupon at annual rates of 4.62, 5.62, 6.62, 7.62, and 8.62 percent of face value; and are trading at quoted spot market prices in dollars of 98.62, 99.62, 100.62, 101.62 and 102.62. Specify the discount factor function d(t) by a third degree polynomial with unknown parameters a, b, and c, as done in class. Using estimated d(t) function, determine spot rate and forward rate functions by assuming half-year compounding. Then write the values of the following based on your estimation. 5. Coefficient of parameter a in first bond price equation. 6. Coefficient of parameter b in first bond price equation. 7. Coefficient of parameter c in first bond price equation. 8. Coefficient of parameter a in second bond price equation. 9. Coefficient of parameter b in second bond price equation. 10.Coefficient of parameter c in second bond price equation. 11.Coefficient of parameter a in third bond price equation. 12.Coefficient of parameter b in third bond price equation. 13.Coefficient of parameter c in third bond price equation. 14.Coefficient of parameter a in fourth bond price equation. 15.Coefficient of parameter b in fourth bond price equation. 16.Coefficient of parameter c in fourth bond price equation. 17.Coefficient of parameter a in fifth bond price equation. 18.Coefficient of parameter b in fifth bond price equation. 19.Coefficient of parameter c in fifth bond price equation. 20.Parameter a. 21.Parameter b. 22.Parameter c. 23.Current price of a dollar at 5th year. 24.Current price of a dollar at 7th year. 25.Current price of a dollar at 10th year. 26.Current price of a dollar at 15th year. 27.Spot rate for term 2 year. 28.Spot rate for term 5 year. 29.Spot rate for term 10 year. 30.Spot rate for term 17 year. 31.Forward rate for half year period 2.5 to 3.0 years. 32.Forward rate for half year period 5.5 to 6.0 years. 33.Forward rate for half year period 10.5 to 11.0 years. 34.Forward rate for half year period 15.5 to 16.0 years. C. Estimate the 2-year, 5-year, and 10-year key rate durations of a 20-year bond carrying a coupon of 8.6 percent on face value $100 paid semi-annually. The given term structure starts with 3.1 percent spot rate of interest at time zero and rises at a rate of 0.002 (.2%) per half year thereafter. Take a 20 basis point (.002) move in each key interest rate to calculate the key rate durations by the method done in class and given in textbook. Report answers for the following: 35. Current fair price of the bond with the given term structure. 36. Price change needed to calculate 2-year key rate duration. 37. Price change needed to calculate 5-year key rate duration. 38. Price change needed to calculate 10-year key rate duration. 39. 2-year key rate duration. 40. 5-year key rate duration. 41. 10-year key rate duration. D. Using the following data on the price of a bond and the corresponding interest rate (assuming a flat term structure) and regression method, estimate convexity and duration of the bond: Price Interest Rate 99 .06 100 .057 101.5 .052 102 .049 105 .044 106.5 .038 108 .033 108.5 .031 110.1 .028 42. What is the estimated value of Duration? 43. What is the estimated value of Convexity?
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, here is your assignment :) ..Also, I attached the excel solution for some part of B and c to support the calculation :)

Interest rates are expressed as annualized rates for the term specified. Report your
interest rate answers as fractional numbers like 0.11 for 11% per year.

A. In a recent trading session, the benchmark 30-year Treasury bond’s market price went up
8.62 dollars per $1000 face value to 1032.38 dollars, while its yield fell from .07 to .068. The
bond’s market price then went up another 7.62 dollars per $1000 face value as the yield
fell further to .0665 from .068. Report answers for the following (using average of latest
two bond prices for duration and average of latest three bond prices for convexity):
As, first modified duration is to be calculated using first 2 mkt price average i.e. = $(1032.38*2- 8.62)/2 =
1028.07
1. Convexity, using the average of all three market prices of the bond in the denominator
of the formula.
Solution:
Convexity can be calculated using the formula
change in price /Average price = - duration* change in rate + change in rate2/2 *convexity.....................(I)
Initial Price: 1032.38 - 8.62) -1 = 1022.76
Final Price: (1032.38-7.62)-1 = 1023.76
Change in price = Final price of bind - initial price of bond = 1023.76 - 1022.76 = $1.76
Average price = (1023.76 +1032.38+ 1022.76)/3 = 1026.3
change in rate will be average of two change in rates = (0.002+ 0.0015)/2 = 0.00175
Put all values in equation (I)
1.76/1026.3 = - (4.19+4.90)/2 * 0.00175 + 0.001752/2 * 1000
Convexity = 41
2. First modified duration, using average of first two market prices of the bond in the
denominator of the formula.
Solution:
First Modified duration = (8.62/1028.07)/0.002 = 𝟒. 𝟏𝟗

3. Second modified duration, using average of second and third prices of the bond.

Solution:
2nd Modified duration = (7.62/(1032.38 ∗ 2 + 7.62)/2)/(0.068 − 0.0665) = 𝟒. 𝟗𝟎
4. The expected rise in bond price if the interest rate were to fall another 20 basis points
(.002) from .0665, using the average of two modified durations and convexity.
Solution:
Expected rise in price based on the interest rate fall by 0.002 points using equation (I)
change in price /1032.38 = -041*0.002 + 41*0.0022/2
Change in price = 1032.3*0.001 = $1.03
Expected rise in bond price = $1.03

B. Estimate term structure of discount factors, spot rates and forward rates by using data
on five semi-annual coupon paying bonds with $100 face value each: The bonds,
respectively, have 1.25, 5.35, 10.4, 15.15 and 20.2 years to maturity; pay coupon at
annual rates of 4.62, 5.62, 6.62, 7.62, and 8.62 percent of face value; and are trading at quoted
spot market prices in dollars of 98.62, 99.62, 100.62, 101.62 and 102.62. Specify the discount factor
function d(t) by a third degree polynomial with unknown parameters a, b, and c, as
done in class. Using estimated d(t) function, determine spot rate and forward rate
functions by assuming half-year compounding. Then write the values of the following
based on your estimation.
5. Coefficient of parameter a in first bond price equation.
6. Coefficient of parameter b in first bond price equation.
7. Coefficient of parameter c in first bond price equation.
Solution:
98.62 = 4.15 x d (1.25) + 4.15 x d (5.35) + 4.15 x (10.4) + 4.15 (15.15) + 104.15 x d (20.2)

98.62 = 4.15 x [1 + a (1.25) + b (1.25)^2 + c (1.25)^3] + 4.15 x [1 + a (5.35) + b (5.35)^2 + c (5.35)^3] +
4.15 x [1 + a (10.4) + b (10.4)^2 + c (10.4)^3] + 4.15 x [1 + a (15.15) + b (15.15)^2 + c (15.15)^3] +
104.15 x [1 + a (20.2) + b (20.2)^2 + c (20.2)^3]
98.62 = (4.15 + 4.15 + 4.15 + 4.15 + 104.15) + a (1.25 + 5.35 + 10.4 + 15.15 + 20.2) + b (1.25^2 +
5.35^2 + 10.4^2 + 15.15^2 + 20.2^2) + c (1.25^3 + 5.35^3 + 10.4^3 + 15.15^3 + 20.2^3)
98.62 = 120.75 + 217.2525a + 13363.07b + 929126.8 c-217.2525a - 13363.07b - 929126.8 c = 18.45

8. Coefficient of parameter a in second bond price equation.
9. Coefficient of parameter b in second bond price equation.
10.Coefficient of parameter c in second bond price equation.
Solution:
99.62 = 4.65 x d (1.25) + 4.65 x d (5.35) + 4.65 x (10.4) + 4.65 (15.15) + 104.65 x d (20.2)

99.62 = 4.65 x [1 + a (1.25) + b (1.25)^2 + c (1.25)^3] + 4.65 x [1 + a (5.35) + b (5.35)^2 + c (5.35)^3] +
4.65 x [1 + a (10.4) + b (10.4)^2 + c (10.4)^3] + 4.65 x [1 + a (15.15) + b (15.15)^2 + c (15.15)^3] +
104.65 x [1 + a (20.2) + b (20.2)^2 + c (20.2)^3]
99.62 = (4.65 + 4.65 + 4.65 + 4.65 + 104.65) + a (1.25 + 5.35 + 10.4 + 15.15 + 20.2) + b (1.25^2 +
5.35^2 + 10.4^2 + 15.15^2 + 20.2^2) + c (1.25^3 + 5.35^3 + 10.4^3 + 15.15^3 + 20.2^3)
99.62 = 123.25 + 52.35a + 775.9075b + 12999.62 c-243.4275a -16777.06b – 1307042c = 20.95
11.Coefficient of parameter a in third bond price equation.
12.Coefficient of parameter b in third bond price equation.
13.Coefficient of parameter c in third bond price equation.
Solution:

100.62 = 5.15 x d (1.25) + 5.15 x d (5.35) + 5.15 x (10.4) + 5.15 (15.15) + 105.15 x d (20.2)

100.62 = 5.15 x [1 + a (1.25) + b (1.25)^2 + c (1.25)^3] + 5.15 x [1 + a (5.35) + b (5.35)^2 + c (5.35)^3]
+ 5.15 x [1 + a (10.4) + b (10.4)^2 + c (10.4)^3] + 5.15 x [1 + a (15.15) + b (15.15)^2 + c (15.15)^3] +
105.15 x [1 + a (20.2) + b (20.2)^2 + c (20.2)^3]
100.62 = (5.15 + 5.15 + 5.15 + 5.15 + 105.15) + a (1.25 + 5.35 + 10.4 + 15.15 + 20.2) + b (1.25^2 +
5.35^2 + 10.4^2 + 15.15^2 + 20.2^2) + c (1.25^3 + 5.35^3 + 10.4^3 + 15.15^3 + 20.2^3)-269.6025a –
20579.01b – 1775630c = 21.45

14.Coeffic...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags