Question

In: Finance

In Figure 6.7, we saw a plot of the yield curve on stripped Treasury bonds and...

In Figure 6.7, we saw a plot of the yield curve on stripped Treasury bonds and pointed out that bonds of different maturities may sell at different yields to maturity. In principle, when we are valuing a stream of cash flows, each cash flow should be discounted by the yield appropriate to its particular maturity. Suppose the yield curve on (zero-coupon) Treasury strips is as follows: Years to Maturity Yield to Maturity 1 4.0 % 2 5.0 3–5 5.5 6–10 6.0 You wish to value a 10-year bond with a coupon rate of 10%, paid annually. a. Complete the below table to value each of the bond’s annual cash flows using this table of yields. Add up the present values of the bond’s 10 cash flows to obtain the bond price. (Do not round intermediate calculations. Enter your "YTM" answers as a percent rounded to 1 decimal place and round "PV of Cash Flow" answers to 8 decimal places.) b.What is the bond’s yield to maturity? (Do not round intermediate calculations. Enter your answer as a percent rounded to 1 decimal place.) c. Compare the yield to maturity of the 10-year, 10% coupon bond with that of a 10-year zero coupon bond or Treasury strip. Which is higher? 10% coupon bond Zero coupon bond

Solutions

Expert Solution

I have answered the question below using excel and have attached the image below.

Please up vote for the same and thanks!!!

Do reach out in the comments for any queries

Answer:

a.

year ytm % cash flow from bond pv of cash flow
1 4% 100            96.15
2 5% 100            90.70
3 5.50% 100            85.16
4 5.50% 100            80.72
5 5.50% 100            76.51
6 6% 100            70.50
7 6% 100            66.51
8 6% 100            62.74
9 6% 100            59.19
10 6% 1100          614.23

explanantion:

Coupon = bond face value * coupon rate = 1000 * 10% = 100

PV = coupon / ( (1 + ytm)^ year)

b. To calculate the YTM, we use the goal seek function.

we know the cash flows, and the bond price (sum of all PVs from part a). So we use the goal seek function as shown above to find the YTm.

c. YTM of 10,yr, 10% coupon bond is 5.91% (as calculated in part b) while YTM of 10yr zero coupon bond is 6%. Hence, YTM of zero coupon bond is higher.


Related Solutions

Find the current Daily Yield Curve Rates published by the Treasury. Plot the Yield curve using...
Find the current Daily Yield Curve Rates published by the Treasury. Plot the Yield curve using a line chart in Excel. Be sure to label both axes. Based upon your plot, what do you believe likely to happen to interest rates in the future?
The Treasury yield curve plots the yields on Treasury notes and bonds relative to the ____...
The Treasury yield curve plots the yields on Treasury notes and bonds relative to the ____ of those securities. face value par value maturity coupon rate Victoria Tennis is trying to decide which one of two projects it should accept. Both projects have the same start-up costs. Project 1 will produce annual cash flows of $52,000 a year for six years. Project 2 will produce cash flows of $48,000 a year for eight years. The company requires a 15 percent...
Suppose we have the yield and maturity information on treasury securities from a current yield curve....
Suppose we have the yield and maturity information on treasury securities from a current yield curve. A 1-year T-bond currently yields 4.50% and a 3-year T-bond yields 9.80%. Assuming the pure expectations theory is correct, what is the market's forecast for interest rates on a 2-year treasury security, 1 year from now? a. 11.16% b. 13.44% c. 14.49% d. 26.67% e. 12.55%
The following information applies to the next 6 questions. Suppose that the stripped U.S. Treasury bonds...
The following information applies to the next 6 questions. Suppose that the stripped U.S. Treasury bonds were priced as follows in Jan 2015: Maturity (years) Price 1 96.1538 2 90.7029 3 83.9619 What is the estimated 1-year spot interest rate for Treasury securities? What is the estimated 2-year spot interest rate for Treasury securities? 3% 4% 5% 6% 7% What is the estimated 3-year spot interest rate for Treasury securities? 3% 4% 5% 6% 7% What is the estimated forward...
1) If the Treasury yield curve is flat (horizontal), can we say that the investors expect...
1) If the Treasury yield curve is flat (horizontal), can we say that the investors expect that the inflation rates will go down in the future? Please state: Agree, disagree, or uncertain. 2) If the inflation rates are expected to stay the same (at the level we have now) in the future, we can conclude that the yield curve is flat (horizontal). Please state: Agree, disagree, or uncertain. 3) If the inflation rates are expected to go down in the...
Examine yield curve shapes using daily yield curve rates provided by U.S. department of treasury ....
Examine yield curve shapes using daily yield curve rates provided by U.S. department of treasury . a) Report treasure yield rates (1 month, 3 month, 6 month, 1 year, 2 year, 3 year, 5 year, 7 year, 10 year, 20 year, 30 year) on Jan. 02, 2014, Jan. 02, 2015, Jan. 04, 2016, Jan. 03, 2017, Jan. 02, 2018, Jan. 02, 2019, and Sep. 02, 2019. b) Compute each term spreads for seven term structures. c) Plot seven yield curves...
Imagine that the yield curve is currently flat. The Treasury announces that they will no longer...
Imagine that the yield curve is currently flat. The Treasury announces that they will no longer issue securities with maturities longer than two years. As a result, long-term government bonds will be refinanced using only relatively short-term debt. If the "market segmentation theory" of the yield curve is correct, what will happen to the slope of the yield curve as a result of this policy change? Explain briefly. Explain the impact of the new policy on the yield curve, therefore...
During recession, the yield for corporate bonds tends to increase and the yield for US Treasury...
During recession, the yield for corporate bonds tends to increase and the yield for US Treasury securities tends to decrease .Briefly explain why. Give a real-world example as part of your reasoning.
A classic example of a discount loan is If the US Treasury Yield Curve is upward...
A classic example of a discount loan is If the US Treasury Yield Curve is upward sloping then it is indicating a A. downturn in the economy B. upturn in the economy C. no change to the economy (i.e. the economy is in transition phase) D. The US Treasury Yield Curve yield does not signal the direction of the economy. E. The US Treasury Yield Curve maps out corporate borrowing levels Using the Fischer Equation what is the nominal rate...
Suppose 2-year Treasury bonds yield 5.3%, while 1-year bonds yield 3.6%. r* is 1%, and the...
Suppose 2-year Treasury bonds yield 5.3%, while 1-year bonds yield 3.6%. r* is 1%, and the maturity risk premium is zero. Negative expected inflation rates, if any, should be indicated by a minus sign. Using the expectations theory, what is the yield on a 1-year bond, 1 year from now? Calculate the yield using a geometric average. Do not round intermediate calculations. Round your answer to two decimal places. b. What is the expected inflation rate in Year 1? Do...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT