Question

In: Finance

A bond is currently selling for $1,300 and pays $65/year (on an annual basis) for 10...

A bond is currently selling for $1,300 and pays $65/year (on an annual basis) for 10 years. What is the IRR of the bond? (Note that this is the same as asking the bond’s YTM.)

Solutions

Expert Solution

YTM = 3%

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

Yield to maturity is the rate of return the investor will get if he/she hold the bold till maturity period

So YTM is like internal rate of return, if we discount all the cash inflow from the bond using YTM, the present value will be equal to the bond current price.

YTM is calculated using Excel, the function used is (IRR)

Pls refer below table

Year

Cash flow

Amount

0

Bod price (Outflow)

-1300

1

Coupon (Inflow)

65

2

Coupon (Inflow)

65

3

Coupon (Inflow)

65

4

Coupon (Inflow)

65

5

Coupon (Inflow)

65

6

Coupon (Inflow)

65

7

Coupon (Inflow)

65

8

Coupon (Inflow)

65

9

Coupon (Inflow)

65

10

Par + Coupon (Inflow

1065

YTM

2.99%

Formula

=IRR(G44:G64)

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

Hope that helps.

Feel free to comment if you need further assistance J


Related Solutions

A 10-year bond pays 8% annual interest (paid semiannually). If similar bonds are currently yielding 6%...
A 10-year bond pays 8% annual interest (paid semiannually). If similar bonds are currently yielding 6% annually, what is the market value of the bond? A. $1,000.00 B. $1,147.20 C. $1,148.77 D. $1,080.00
A 6-year 7.2% annual coupon bond is selling to yield 6.5%. The bond pays interest annually....
A 6-year 7.2% annual coupon bond is selling to yield 6.5%. The bond pays interest annually. The par value of the bond is $100. a. What is the price of the 6-year 7.2% coupon bond selling to yield 6.5%? b. What is the price of this bond one year later assuming the yield is unchanged at 6.5%? c. Suppose that one year later the yield of the bond decreases to 6.3%. What is the price change attributable to moving to...
Consider a 10-year bond with a face value of $100 that pays an annual coupon of...
Consider a 10-year bond with a face value of $100 that pays an annual coupon of 8%. Assume spot rates are flat at 5%. a.Find the bond’s price and modified duration. b.Suppose that its yields increase by 10bps. Calculate the change in the bond’s price using your bond pricing formula and then using the duration approximation. How big is the difference? c.Suppose now that its yields increase by 200bps. Repeat your calculations for part b.
A bond is in a risk class that pays 5% per year. The bond pays annual...
A bond is in a risk class that pays 5% per year. The bond pays annual interest of $400 (and the first interest payment is one year from today) and will mature in 10 years at a value of $10,000. What is the price of the bond?
A 10-year U.S. Treasury bond with a par value of $ 1000 is currently selling for...
A 10-year U.S. Treasury bond with a par value of $ 1000 is currently selling for $ 1025. The bond carries a 7.5% p.a. coupon payable annually. If purchased today and held to maturity, what is its expected yield to maturity? Does your answer change if the coupon payments of 7.5% p.a. are made half-yearly (i.e. 3.75% every half -year)? How & why? Could you please show me step by step calculations so I can understand? thank you.
An 10-year IBM bond is currently selling for $791.36. The coupon rate is 10% paid annually....
An 10-year IBM bond is currently selling for $791.36. The coupon rate is 10% paid annually. What will be the price of the bond six years from today if the same yield to maturity hold? $855.81 $936.60 $783.72 $844.46 $813.56
A 10-year annual payment corporate bond has a market price of $1,050. It pays annual interest...
A 10-year annual payment corporate bond has a market price of $1,050. It pays annual interest of $100 and its required rate of return is 9 percent. Is the bond fairly priced, underpriced, or overpriced? Also find the magnitude of the mispricing (if any).
5. The current stock price of TransContinentalAirways is $65 per share. TCA currently pays an annual...
5. The current stock price of TransContinentalAirways is $65 per share. TCA currently pays an annual per-share dividend of $3. Over the past 5 years this dividend has grown annually at a rate of 23%. A respected analyst assumes that the current growth rate of dividends will hold up for the next 5 years, after which dividend growth will slow to 5% annually. Use the twostagegordon function to compute the cost of equity. Complete in Excel, please include formulas
Calculate the duration for a $1,000, 4‐year bond with a 4.5 percent annual coupon, currently selling at par.
  Calculate the duration for a $1,000, 4‐year bond with a 4.5 percent annual coupon, currently selling at par. Use the bond’s duration to estimate the percentage change in the bond’s price for a decrease in the market interest rate to 3.5 percent.
What is the YTM on a 10%, 20-year simi-annual coupon bond that that currently trades for...
What is the YTM on a 10%, 20-year simi-annual coupon bond that that currently trades for $1,013?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT