Question

In: Finance

9. a. You’re considering buying a 10 year US Treasury 7% coupon bond with a face...

9.

a. You’re considering buying a 10 year US Treasury 7% coupon bond with a face value of $1000.   The bond pays coupons semi-annually.    The next coupon will be paid in 6 months.   The bond is currently selling for $977.12.   Using Excel’s IRR command, determine the YTM of the bond. Express your answer as an effective annual rate (EAR).   (Not at an APR).   

Report your answer as a decimal, not as a percent, using at least 4 significant digits.

Hint: Be careful here. Because you’ll need to express the cash flows with a 6 month frequency, the IRR command will return the YTM expressed as an effective 6-month rate.  

b. You’re considering buying a 7 year US Treasury 3% coupon bond with a face value of $1000.   The bond pays coupons semi-annually.    The next coupon will be paid in 6 months.   The bond has a YTM of 7.4% when expressed as an effective annual rate (EAR).   Determine the price of the bond.  Express you answer in dollars and cents.

HINT: If you use Excel’s NPV command, remember that it must not include the cash flow at t = 0. If you do the computation by hand, be sure to keep the accuracy of your computations high. I’d suggest you do both in order to check your answer before you enter it

Solutions

Expert Solution

Calc:

Q-1: There are 20 periods to bond as years are 10, whereas compounding is twice per year. IRR is used to calculated APR, then Effective rate is calculated using the formula =(1+APR/n)^n-1

Q-2 First Effective rate is converted to APR using the function =EFFECT(APR, frequency), then it is used as IRR to calculate the NPV or the price of the bond

If you have any queries you can ask in the comment section, thanks


Related Solutions

You are considering buying a 10-year U.S. Treasury bond at the upcoming Treasury auction. Assume that...
You are considering buying a 10-year U.S. Treasury bond at the upcoming Treasury auction. Assume that the bond has the following features: coupon rate: 2.27%, with semi-annual coupon payments Face value: $1,000 matures in 10 years In the auction, the annual yield to maturity determined by the auction is 2.92%. What is the price that you will pay for this bond? Do not round at intermediate steps in your calculation. Round your answer to the nearest penny. Do NOT include...
Suppose a 10-year zero coupon Treasury bond with a face value of $10, 000 sells for $6,000.
Suppose a 10-year zero coupon Treasury bond with a face value of $10, 000 sells for $6,000. a. Find the bond value. b. Suppose the price of the above bond rose to Kshs 7,500, find the new yield. c. Explain what happens when interest rates increase.
You are considering buying a bond with a 10-year maturity. The bond’s coupon rate is 8%...
You are considering buying a bond with a 10-year maturity. The bond’s coupon rate is 8% and the interest rate is paid semiannually. If youu want to earn an effective interest rate of 8.16%, how much should you be willing to pay for the bond? Where the value is 1.000.000.000.
A 9 percent, 7-year, semiannual coupon bond has a face value of $1,000. What is the...
A 9 percent, 7-year, semiannual coupon bond has a face value of $1,000. What is the current price of this bond if the market rate of return is 8.8 percent? $1,010.29 $1,011.49 $1,112.32 $1,111.24
b) Bond with 10 year maturity, a face value or $1,000, a coupon rate of 7%...
b) Bond with 10 year maturity, a face value or $1,000, a coupon rate of 7% (coupon is paid annually) and assume that the yield to maturity on the bond is 7%. Compute the duration of this bond. c) Next, we are going to analyze the effect of time to maturity on the duration of the bond. Compute the duration of a bond with a face value of $1,000, a coupon rate of 7% (coupon is paid annually) and a...
You’re considering investing in a 2-year 7% annual coupon bond priced at par. Alternatively, you’ll consider...
You’re considering investing in a 2-year 7% annual coupon bond priced at par. Alternatively, you’ll consider a 1-year 5% annual coupon bond priced at par and subsequently reinvesting all your proceeds in another identical 1-year bond. You expect the 1-year bond will yield 9% next year. Assuming you turn out to be right, which approach would generate the higher return? Invest in the 2-year bond. Invest in the 1-year and reinvest the proceeds in another 1-year.
A 5-year Treasury bond has a 3.7% yield. A 10-year Treasury bond yields 7%, and a...
A 5-year Treasury bond has a 3.7% yield. A 10-year Treasury bond yields 7%, and a 10-year corporate bond yields 8.5%. The market expects that inflation will average 3% over the next 10 years (IP10 = 3%). Assume that there is no maturity risk premium (MRP = 0) and that the annual real risk-free rate, r*, will remain constant over the next 10 years. (Hint: Remember that the default risk premium and the liquidity premium are zero for Treasury securities:...
2 years ago, a company issued a 10-year, 9% coupon bond with a face value of...
2 years ago, a company issued a 10-year, 9% coupon bond with a face value of $1000. The bond makes quarterly coupon payments. Today, the bond yields APR of 10% compounded semi-annually. What is the price of the bond today? I asked this question earlier but the answer I got is wrong. I am trying to figure out how to do this question correctly. Thank you!
Find the price of 10-year 5% coupon bond if the price of 10-year 7% coupon bond...
Find the price of 10-year 5% coupon bond if the price of 10-year 7% coupon bond is $107 and 10-year interest rate is 6.5%. All bonds have $100 face value and pay semi-annual coupons.
A 29-year U.S. Treasury bond with a face value of $1,000 pays a coupon of 5.25%...
A 29-year U.S. Treasury bond with a face value of $1,000 pays a coupon of 5.25% (2.625% of face value every six months). The reported yield to maturity is 4.8% (a six-month discount rate of 4.8/2 = 2.4%). (Do not round intermediate calculations. Round your answers to 2 decimal places.) a. What is the present value of the bond? b. If the yield to maturity changes to 1%, what will be the present value? c. If the yield to maturity...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT