Explore BrainMass
Share

# Yield on Bonds

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

1. If U.S. Treasury yields are as follows:
3 month 6.0%
6 month 6.3%
1 year 6.5%
2 year 6.6%
5 year 6.4%
10 year 7.5%
30 year 8.0%

a. What is the expected yield on notes from year 1 to 2, assuming the PEH holds?
b. What is the expected yield on notes from year 2 to 5, assuming the PEH holds?
c. If inflation for the next year is expected to be 4.5%, what would the expected real rate of interest be on the 3-month T-bill?
d. If inflation spikes during this period, and the actual inflation rate comes in ex-post at 6.3%, what would the actual real rate of interest be on the 3-month Treasury bill?
e. It the expectations for inflation are as follows:
Years 1 and 2 4.5%
Years 3 to 6 4.0%
Years 7 to 15 3.5%
Years 16 to 30 3.2%

Assume the following for the MRP: Years 1 to 10 .1%
Years 11 to 20 .05%
Years 20 on 0%
What is the real rate of return on the 30 year T-Bond? On the 10 year bond?
f. Using the information from part e, and assuming a real rate of return of 3%, what would the nominal rate of return be on a 15-year Treasury bond ?
g. Plot the yield curve for these Treasury securities.
h. Using the three theories we have discussed, explain how each one helps explain the shape of this yield curve.

2. If the listed bonds have the following returns, identify the combined DRP & LP's. (assume that there is no ISP. ) Use the Treasuries above as your benchmarks.
AAA 10 year 11%
BBB 30 year 15%
B 5 year 12.5%

---
(See attached files for full problem description)

https://brainmass.com/math/graphs-and-functions/yield-on-bonds-53522

#### Solution Summary

Calculates the yield on treasury securities and plots the yield curve.

\$2.19

## Spreedsheet Problem - Bonds and Stocks

7-8 Bond yields:
A 10-year, 12 percent semiannual coupon bond, with a par value of \$1,000, may be called in 4 years at a call price of \$1,060. The bond sells for \$1,100. (Assume that the bond has just been issued.)
a. What is the bond's yield to maturity?
b. What is the bond's current yield?
c. What is the bond's capital gain or loss yield?
d. What is the bond's yield to call?

7-22 Bond Valuation
Rework Problem 7-8 using a spreadsheet model. After completeing parts a through d, answer the following related questions.
e. How would the price of the bond be affected by changing interest rates? Hint: Conduct a sensitivity analysis of price to change in the yield to maturity, which is also the going market interest rate of interest falls below the coupon rate. That is an oversimplification, but assume it anyway for purposes of this problem.)

f. Now assume that the date is 10/25/2002. Assume further that our 12 percent, 10-year bond was issued on 7/01/2002, is callable on 7/01/2006 at \$1,060, will mature on 6/30/2012, pays interest semiannually (January 1 and July 1), and sells for \$1,100. Use your spreadsheet to find (1) the bond's yield to maturity and (2) its yield to call.

I need help with problem set 7-8 questions a through d in excel and problem set 7-22 e and f. No need to re-write the questions. Just show Question "a", Question "b"...Question "f" with excel.

Thanks.

View Full Posting Details