ou are considering a 30-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 11.29%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ fill in the blank 2

ou are considering a 30-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 11.29%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ fill in the blank 2

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 7R

See similar textbooks

Similar questions

Bradford Manufacturing Company has just issued a 13-year, 13% coupon interest rate, $1,000-par bond that pays interest Semi annually. The required return is currently 15%, and the company is certain it will remain at 15% until the bond matures in 13 years. a). Assuming that the required return does remain at 15% until maturity, find the value of the bond. b) a bond’s yield to maturity is 9% and coupon interest rate is 18%,state whether the price of the bond will be at a premium to par, at par, or at a discount to par.
Dewey, Cheatham & Howe, a regional brokerage house, has an issue of $1,000 par value bonds with 18 years left until maturity. The coupon rate is 7.7%, with semi-annual payments. If the current price of the bond is $1,175, what is the bond’s YTM?
Verbrugge Company has a level-coupon bond outstanding that pays coupon interest of $120 per year and has 10 years to maturity. The face value of the bond is $1,000. If the yield for similar bonds is currently 14%, what is the bond’s current market value? For the Verbrugge Company bond described in Problem 1, find the bond’s value if the yield for similar bonds decreases to 12%. For the Verbrugge Company bond described in Problem 1, find the bond’s value if the yield for similar bonds decreases to 9%. Suppose the Verbrugge bond paid interest semiannually. What is its value if the yield is 14%? A firm issues an annual bond today with a $1,000 face value, an 8% annual coupon interest rate, and 25-year maturity. An investor purchases the bond for $1,000. What is the yield to maturity (YTM)? Suppose the investor bought the bond described in the previous problem for $900. What’s the YTM?
Given below is information about three RM $5000 par value bonds, each of which pays coupon semiannually. The required rate of return on each bond is 12%. Calculate the value of the bonds and determine whether the bond is selling at discount, premium or par value……. Bond Coupon Rate (%) Maturity (years) 1 10 5 2 12 10 3 14 15 Using the above table, if the company decided to pay coupon annually (12%), calculate the value of the bonds and determine whether the bond is selling at discount, premium or par value Explain the of Bonds available in the market for the Companies to raise fund……Is there any difference in the value of semiannually and annually……
On May 1, 2021, you are considering to buy a newly-issued ABC Company bond, which is quoted as "ABC 8.2s45" in the WSJ and has a par value of $1,000. The company pays coupon interests every 6 months. If you require a 7.9% return on this bond, how much would you pay for this bond? (Hint: Identify annual coupon rate, years to maturity, and yield to maturity to compute the bond price.) Group of answer choices $1,029.11 $1,034.52 $1,033.68 $1,030.95 $1,032.06
BA Corp is issuing a 10-year bond with a coupon rate of 8 percent. The interest rate for similar bonds is currently 6 percent. Assuming annual payments, what is the value of the bond? Knight, Inc., has issued a three-year bond that pays a coupon rate of 6.10 percent. Coupon payments are made semiannually. Given the market rate of interest of 5.80 percent, what is the market value of the bond? Diane Carter is interested in buying a five-year zero coupon bond with a face value of $1,000. She understands that the market interest rate for similar investments is 9 percent. Assume annual coupon payments. What is the current value of this bond? Ruth Hornsby is looking to invest in a three-year bond that makes semiannual coupon payments at a rate of 5.875 percent. If these bonds have a market price of $981.13, what yield to maturity can she expect to earn? Rudy Sandberg wants to invest in four-year bonds that are currently priced at $868.43. These bonds have a coupon rate of 6 percent and make…
ou are considering a 15-year, $1,000 par value bond. Its coupon rate is 9%, and interest is paid semiannually. If you require an "effective" annual interest rate (not a nominal rate) of 7.1225%, how much should you be willing to pay for the bond? Do not round intermediate calculations. Round your answer to the nearest cent.
Carrie's Clothes, Inc. has a five-year bond outstanding that pays $60 annually. The face value of each bond is $1,000, and the bond sells for $890. What is the bond's coupon rate? Round your answer to two decimal places. % What is the current yield? Round your answer to two decimal places. % What is the yield to maturity? Use Appendix B and Appendix D to answer the question. Round your answer to the nearest whole number. %
Carrie's Clothes, Inc. has a six-year bond outstanding that pays $80 annually. The face value of each bond is $1,000, and the bond sells for $920. What is the bond's coupon rate? Round your answer to two decimal places. .......... % What is the current yield? Round your answer to two decimal places. ........... % What is the yield to maturity? Use Appendix B and Appendix D to answer the question. Round your answer to the nearest whole number. ......... %
You are pricing a 10-year, 7 percent coupon bond with a $1,000 face value. Coupon payments are made semi-annually and the first payment is due in exactly six months. Other semi-annual pay bonds of similar maturity and credit quality are trading at a default spread of 1% over and above the yield to maturity of the 10-year Government issued bond, which is 6.0% pa. Compute the fair value of this bond
Pybus, Inc. is considering issuing bonds that will mature in 23years with an annual coupon rate of 9 percent. Their par value will be $1,000, and the interest will be paid semiannually. Pybus is hoping to get a AA rating on its bonds and, if it does, the yield to maturity on similar AA bonds is 7percent. However, Pybus is not sure whether the new bonds will receive a AA rating. If they receive an A rating, the yield to maturity on similar A bonds is 8 percent. What will be the price of these bonds if they receive either an A or a AA rating? The price of the Pybus bonds if they receive a AA rating will be $__________ (Round to the nearest cent.)
On May 1, 2021, you are considering to buy a newly-issued ABC Company bond, which is quoted as "ABC 5.6s34" in the WSJ and has a par value of $1,000. The company pays coupon interests every 6 months. If you require a 6.9% return on this bond, how much would you pay for this bond? (Hint: Identify annual coupon rate, years to maturity, and yield to maturity to compute the bond price.) Group of answer choices a. $883.78 b. $889.60 c. $885.22 d. $886.60 e. $887.12