Using the prices and cash flows of Treasury coupon bonds shown below, determine the par bond...

Using the prices and cash flows of Treasury coupon bonds shown below, determine the par bond yield for each of the Treasury securities.

Bond	Price	Year 1	Year 2	Year 3
1	99.50	105
2	101.25	6	106
3	100.25	7	7	107

Using Excel, solve the above problem and graph the resulting Treasury par bond yield curve (show formula). Suppose that the 6-month, 12-month, 18-month, and 24-month zero rates are 5%, 6%, 6.5%, and 7% respectively. What is the two-year par yield?

Solutions

Expert Solution

Please see the table below. All financials are in $. Please see the second row to understand the mathematics. The last column colored in yellow contains your answer. Adjacent cell in blue shows the excel formula used to get the answer.

Hence, the graph will be:

---------------------------

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

Below is a list of prices for $1,000-par zero-coupon Treasury securities of various maturities. An 11%...

Below is a list of prices for $1,000-par zero-coupon Treasury securities of various maturities. An 11% coupon $100 par bond pays an semi-annual coupon and will mature in 1.5 years. What should be the YTM on the bond? Assume semi-annual interest compounding for this question. Maturity (periods) Price of $1,000 par bond 1 943.4 2 873.52 3 770

bond prices. price the bonds from the following table with semiannually coupon payments. par value. coupon...

bond prices. price the bonds from the following table with semiannually coupon payments. par value. coupon rate. YearTM. YieldTM. price $5,000.00. 8% 5. 8% ? $1,000.00. 5% 10. 11% ? $1,000.00. 11% 20. 9% ? $5,000.00. 6% 5. 7% ?

Bond prices. Price the bonds from the following table with annual coupon payments. Par Value Coupon...

Bond prices. Price the bonds from the following table with annual coupon payments. Par Value Coupon Rate Years to Maturity Yield to Maturity Price $1,000.00 6% 25 10% ? $1,000.00 8% 30 12% ? $5,000.00 12% 15 11% ? $1,000.00 7% 5 6% ? a. Find the price for the bond in the following table: (Round to the nearest cent.) Par Value Coupon Rate Years to Maturity Yield to Maturity Price $1,000.00 6% 25 10% $_______ b. Find the price...

Bond prices. Price the bonds from the following table with semiannual coupon LOADING... payments. Par Value...

Bond prices. Price the bonds from the following table with semiannual coupon LOADING... payments. Par Value Coupon Rate Years to Maturity Yield to Maturity Price $5 ,000.00 10% 20 11% ? $1 ,000.00 9% 20 6% ? $1 ,000.00 6% 15 7% ? $5 ,000.00 5% 20 9% ?

a) Suppose the following zero-coupon bonds are trading at the prices shown below per $150 face...

a) Suppose the following zero-coupon bonds are trading at the prices shown below per $150 face value. Determine the corresponding yield to maturity for each bond. Maturity 1 year 2 years 3 years 4 years Price $86.45 $82.25 $77.58 $73.42 b) Assume that it is January 15th, 2010 and the U.S. Treasury has just issued securities with January 15th, 2018 maturity, $1000 par value and a 4% coupon rate with semiannual coupons. Since the original maturity is only 8 years,...

For the alternatives shown below, determine the incremental rate of return for cash flows for Q...

For the alternatives shown below, determine the incremental rate of return for cash flows for Q – P. Alternative P Alternative Q First cost, $ -50,000 -85,000 Annual operating cost, $ per year -8,600 -2,000 Annual revenue, $ per year 22,000 45,000 Salvage value, $ 3,000 8,000 Life, years 2 3

In the bond market, we find the following Treasury bonds and their prices. Bond price $980...

In the bond market, we find the following Treasury bonds and their prices. Bond price $980 $98 $96 Maturity 2 years 1 year 2 years Face value $1,000 $100 $100 Coupon rate 10% 0% 0% a) Compute the YTMs for the above three bonds. b) Using the two zero coupon bonds, compute the forward rate that is applied for the period from the end of Year 1 to the end of Year 2. c) Suppose that we need the above...

Prices of several bonds are given below: Half Bond Principal($) Time to maturity(years) Annual coupon($) Bond...

Prices of several bonds are given below: *Half Bond Principal($) Time to maturity(years) Annual coupon*($) Bond price($) 100 0.5 0 98.9 100 1 0 97.5 100 1.5 4 101.6 100 2 4 101.9 the stated coupon is assumed to be paid semiannually. (a) Use the bootstrap method to find the 0.5-year, 1-year, 1.5-year and 2-year zero rates per annum with continuous compounding. (b) What is the continuously compounded forward rate for the period between the 1-year point and the 2-year...

5. The table below shows various bond prices at different maturity levels for zero coupon bonds....

5. The table below shows various bond prices at different maturity levels for zero coupon bonds. Based on this information, how would you describe the shape of the yield curve – is it: flat, upward sloping, downward sloping or there is not enough information present to make a determination? What does this shape mean? Note that the bonds all have $1,000 face value. maturity price maturity price 1 950.24 2 900.70 3 860.38 4 820.27 The current yields for zero-coupon...

A. Bond Prices A $1,000 par bond that pays interest semiannually has a quoted coupon rate...

A. Bond Prices A $1,000 par bond that pays interest semiannually has a quoted coupon rate of 7%, a promised yield to maturity of 7.6% and exactly 4 years to maturity. What is the bond's current value? B. Bond Prices A $1,000 par bond that pays interest semiannually has a quoted coupon rate of 6%, a promised yield to maturity of 4.8% and exactly 12 years to maturity. The present value of the coupon stream represents ______ of the total...

Subjects