Question

In: Finance

What is the current price of an Apple bond that has a 7.2%coupon, 15 years...

What is the current price of an Apple bond that has a 7.2% coupon, 15 years to maturity, a YTM of 6% and semiannual payments?

please need steps in excel format

Solutions

Expert Solution

Face Value of Bond = $1000

Semi-Annual Coupon Payment = $1000*12% = $120

No of years to maturity = 15 years*2 = 30 years

Semi-annual YTM = 6%/2 = 3%

Calculating the Price of Bond using the Excel "PV" function:-

SO, the current price of an Apple bond is $1117,60

Note- Shown in Yellow are formulas.


Related Solutions

Compute the price of a 7.2 percent coupon bond with 15 years left to maturity and...
Compute the price of a 7.2 percent coupon bond with 15 years left to maturity and a market interest rate of 10.0 percent. (Assume interest payments are semiannual.) (Do not round intermediate calculations. Round your final answer to 2 decimal places.) IS this a Discount or Premium Bond?
Consider a bond with a coupon of 7.2 percent, five years to maturity, and a current...
Consider a bond with a coupon of 7.2 percent, five years to maturity, and a current price of $1,027.60. Suppose the yield on the bond suddenly increases by 2 percent. a. Use duration to estimate the new price of the bond. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Price: ______ b. Calculate the new bond price using the usual bond pricing formula. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Price:...
A 4.30 percent coupon municipal bond has 15 years left to maturity and has a price...
A 4.30 percent coupon municipal bond has 15 years left to maturity and has a price quote of 97.85. The bond can be called in four years. The call premium is one year of coupon payments. (Assume interest payments are semiannual and a par value of $5,000.) a) Compute the bond’s current yield. b) Compute the yield to maturity. c) Compute the taxable equivalent yield (for an investor in the 30 percent marginal tax bracket). d) Compute the yield to...
1. A semi-annual coupon bond with 25 years until maturity has a coupon rate of 7.2...
1. A semi-annual coupon bond with 25 years until maturity has a coupon rate of 7.2 percent and a yield to maturity of 6 percent. If the par value is $1000, what is the price of the bond?
Compute Bond Price Compute the price of a 8.0 percent coupon bond with 15 years left...
Compute Bond Price Compute the price of a 8.0 percent coupon bond with 15 years left to maturity and a market interest rate of 7.0 percent. (Assume interest payments are semi-annual.) Is this a discount or premium bond?
Bond J has a coupon of 7.2 percent. Bond K has a coupon of 11.2 percent....
Bond J has a coupon of 7.2 percent. Bond K has a coupon of 11.2 percent. Both bonds have 12 years to maturity and have a YTM of 8.4 percent. a. If interest rates suddenly rise by 1.8 percent, what is the percentage price change of these bonds? (A negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) %Δ in Price Bond J: %...
Bond J has a coupon of 7.2 percent. Bond K has a coupon of 11.2 percent....
Bond J has a coupon of 7.2 percent. Bond K has a coupon of 11.2 percent. Both bonds have 12 years to maturity and have a YTM of 8.4 percent. a. If interest rates suddenly rise by 1.8 percent, what is the percentage price change of these bonds? (A negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) %Δ in Price Bond J: %...
What is the price of a bond with a coupon of 6%, a maturity of 15...
What is the price of a bond with a coupon of 6%, a maturity of 15 years, and a yield (annual) of 9.1% if the bond is an annual pay bond? What if the bond is a semi-annual pay bond and the yield is a semi-annually compounded 9.1%? If the bonds are otherwise identical, which one is a better deal?
What is the price of the bond if the coupon rate is 6%, has 20 years...
What is the price of the bond if the coupon rate is 6%, has 20 years left to maturity and the YTM is 6%? If the variance for a stock return is 0.0148 then the standard deviation is?
There is a 5.4 percent coupon bond with nine years to maturity and a current price...
There is a 5.4 percent coupon bond with nine years to maturity and a current price of $1,055.20. What is the dollar value of an 01 for the bond? (Do not round intermediate calculations. Round your answer to 3 decimal places. Omit the "$" sign in your response.)   Dollar value $   
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT