Question

In: Finance

Problem 2 Maturity Spot Rate 1 5.0700 2 5.1248 3 5.1873 4 5.2557 5 5.3281 6...

Problem 2

Maturity

Spot Rate

1

5.0700

2

5.1248

3

5.1873

4

5.2557

5

5.3281

6

5.4026

7

5.4773

a) Compute the Forward Rate Curve for the adjacent Term Structure

b) Price 5 year, 8% annual coupon bond. Assume these are risk adjusted rates.

c) Show that you will arrive at the same price by using the forward rates

Problem 3

What is the YTM of the above bond? What should its Par yield be?

Solutions

Expert Solution

a) Forward Rate f (t-1, 1) = [(1 + s(t))t / (1 + s(t-1))t-1 ] – 1

where,

s(t):t-period Spot Rate

s(t)-1:t-1-period Spot Rate

f(t-1, 1): forward Rate applicable for the period (t-1,1)

Maturity

(t)

Spot Rate

(S)

Forward Rate(t-1,1)

F(t-1,1)

1

5.0700%

5.0700%

2

5.1248%

5.1796%

3

5.1873%

5.3124%

4

5.2557%

5.4612%

5

5.3281%

5.6182%

6

5.4026%

5.7759%

7

5.4773%

5.9266%

Excel formula for Forward Rate at t=2 is,

F(1,1) = ((1+S2)^t2)/((1+S1)^t1)-1

F(1,1) = ((1+5.1248%)^2)/((1+5.0700%)^1)-1 = 5.1796%

Similarly, we can compute F(t-1,1) for all maturities as in above excel and draw the Forward rate curve as below:

b) Price of 5 year, 8% annual coupon bond

Using Spot rate, Price of bond = C/(1+S1) + C/(1+S2)2 + C/(1+S3)3 + C/(1+S4)4 + C/(1+S5)5 + FV/(1+S5)5

Where, C is coupon payment

FV is par value

S1, S2, S3, S4, S5 are spot rates for respective maturity

Considering FV i,e, par value = $1000

Maturity

(t)

Spot Rate

(S)

Cash flows

(CF)

Discounting factor using Spot rates

D = 1/(1+S)t

PV

CF*D

1

5.0700%

80

0.951746455

76.13972

2

5.1248%

80

0.904877178

72.39017

3

5.1873%

80

0.859231277

68.7385

4

5.2557%

80

0.814737122

65.17897

5

5.3281%

1080

0.771398428

833.1103

Price of Bond = sum of PV = $1115.56

C) Using Forward rate, Price of bond

P = C/(1+F(0,1))

+C/{(1+F(0,1))* (1+F(1,1))}

+ C/{(1+F(0,1))* (1+F(1,1))* (1+F(2,1)) }

+ C/{(1+F(0,1))* (1+F(1,1))* (1+F(2,1))* (1+F(3,1))}

+ C/{(1+F(0,1))* (1+F(1,1))* (1+F(2,1))* (1+F(3,1))* (1+F(4,1))}

+ FV/{(1+F(0,1))* (1+F(1,1))* (1+F(2,1))* (1+F(3,1))* (1+F(4,1))}

Where, P is price of bond

C is coupon payment

FV is par value

F(0,1), F(1,1) F(2,1), F(3,1), F(4,1) are forward rates for respective maturity

Considering FV i,e, par value = $1000

Maturity

(t)

Forward Rate(t-1,1)

Cash flows

CF

Discounting factor using Spot rates

D = 1/{(1+F(0,1))* (1+F(1,1))…. (1+F(t-1,1))}

PV

(CF*D)

1

5.0700%

80

0.951746455

76.13972

2

5.1796%

80

0.904877178

72.39017

3

5.3124%

80

0.859231277

68.7385

4

5.4612%

80

0.814737122

65.17897

5

5.6182%

1080

0.771398428

833.1103

Price of Bond = sum of PV = $1115.56

Hence, we can see that the price of bond is same by using either spot rates or forward rates.

3) YTM of Bond

Price of bond = C/(1+YTM) + C/(1+YTM)2 + C/(1+YTM)3 + C/(1+YTM)4 + C/(1+YTM)5 + FV/(1+YTM)5

Where, C is coupon payment

FV is par value

YTM is Yield to maturity

For above bond,

1115.56 = 80/(1+YTM) + 80/(1+YTM)2 + 80/(1+YTM)3 + 80/(1+YTM)4 + 90/(1+YTM)5 + 1000/(1+YTM)5

Solve for YTM,

YTM = 5.3081%


Related Solutions

Problem 1 ✓ Problem 2 Problem 3 ✓ Problem 4 … Problem 5 … Problem 6...
Problem 1 ✓ Problem 2 Problem 3 ✓ Problem 4 … Problem 5 … Problem 6 ✓ Problem 7 Problem 8 Problem 9 close sidebar webwork / f2019stat213 / stat_213_assignment_3 / 5 STAT 213 Assignment 3: Problem 5 Previous Problem Problem List Next Problem (1 point) To examine the effectiveness of its four annual advertising promotions, a mail order company has sent a questionnaire to each of its customers, asking how many of the previous year's promotions prompted orders that...
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5...
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5 8 7 6 5 7 7 6 7 8 8 8 9 7 8 10 12 11 Test the significance of the correlation coefficient. Then use math test scores (X) to predict physics test scores (Y).  Do the following: Create a scatterplot of X and Y. Write the regression equation and interpret the regression coefficients (i.e., intercept and slope). Predict the physics score for each....
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Find mean, median, mode, variance, standard deviation, coefficient of variation, range, 70th percentile, 3rdquartile of the data and skewness and define what each of these statistics measure. For example, mean is a measure of the central tendency, what about the rest? Use Chebyshev’s rule to find...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Split the dataset in two equal parts. You have 30 datavalues. If you split the data in two equal parts each part will contain 15 data values.  Call the first part Y and second part X.Draw scatter plot of the 2 datasets, X being on the horizontal...
tens Units 1 5 2 3 4 8 5 2 5 6 9 6 1 3...
tens Units 1 5 2 3 4 8 5 2 5 6 9 6 1 3 5 4 7 9 7 0 0 4 5 6 9 9 8 1 3 5 6 8 9 9 0 1 2 3 5 9 The table represent a random sample of 31 test scores taken from a large lecture class. Find the following [round to 2 decimal points X. XX] a) [2 pts] Find the 5 number summary [L, Q1, Q2, Q3,...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot...
X 1 3 5 3 4 4 Y 2 5 4 3 4 6 A: Plot the date B: find the line of best fit C: determine ŷ AT x=3 D: Find r and r^2 E: explain r and r^2
2. Consider functions f : {1, 2, 3, 4, 5, 6} → {1, 2, 3, 4,...
2. Consider functions f : {1, 2, 3, 4, 5, 6} → {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}. (a) How many of these functions are strictly increasing (i.e. f(1) < f(2) < f(3) < f(4) < f(5) < f(6))? Hint: How many different possibilities are there for the range of f? For each range of f, how many strictly increasing functions are there? (b) How many of these functions are non-decreasing (i.e. f(1) ≤ f(2) ≤...
The 1-year spot rate is 8%, the 2-year spot-rate is 7%, and the 3-year spot rate...
The 1-year spot rate is 8%, the 2-year spot-rate is 7%, and the 3-year spot rate is 6%. What is the YTM on a 3-year, 1% annual coupon bond?
The term structure shows the following Treasury spot rates: Maturity in years 1 2 3 4...
The term structure shows the following Treasury spot rates: Maturity in years 1 2 3 4 5 Spot Rate in % 0.6 1.1 1.6 1.9 2.6 Attempt 1/10 for 10 pts. Part 1 What is the implied 1-year forward rate one year from now? 4+ decimals Attempt 1/10 for 10 pts. Part 2 What is the implied 1-year forward rate two years from now? 4+ decimals Attempt 1/10 for 10 pts. Part 3 What is the implied 1-year forward rate...
PROBLEM 5. A box contains 10 tickets labeled 1, 2, 3, 4, 5, 6, 7, 8,...
PROBLEM 5. A box contains 10 tickets labeled 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. Draw four tickets and find the probability that the largest number drawn is 8 if: (a) the draws are made with replacement. (b) the draws are made without replacement. PROBLEM 6. Suppose a bakery mixes up a batch of cookie dough for 1,000 cookies. If there are raisins in the dough, it's reasonable to assume raisins will independently have a .001 chance...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT