The project is spreadsheet problems solving. It is necessary to turn in soft copy of the excel solution. It should be well organized and easy to follow. Question) A bond that settle on June 7, 2013, matures on July 1, 2033, and may be called at any time after July, 2023, at a price of 103. The Coupon rate on the bond is 5 percent and the price if 113.00.what is the yield to maturity and yield to call on this bond?

The project is spreadsheet problems solving. It is necessary to turn in soft copy of the excel solution. It should be well organized and easy to follow. Question) A bond that settle on June 7, 2013, matures on July 1, 2033, and may be called at any time after July, 2023, at a price of 103. The Coupon rate on the bond is 5 percent and the price if 113.00.what is the yield to maturity and yield to call on this bond?

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter6: Fixed-income Securities: Characteristics And Valuation

Section: Chapter Questions

Problem 20P

See similar textbooks

Similar questions

The project is spreadsheet problems solving. It is necessary to turn in soft copy of the excel solution. It should be well organized and easy to follow. Question) A Treasury bond that settles on August 10, 2013, matures on April 15, 2018. The coupon rate is 5.6 percent and the quoted price is 104. What is the bond’s yield maturity?
Find the duration of a bond with a settlement date of May 27, 2025, and maturity date November 15, 2036. The coupon rate of the bond is 6.0%, and the bond pays coupons semiannually. The bond is selling at a bond-equivalent yield to maturity of 8.0%. Use Spreadsheet 16.3. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. X Answer is complete but not entirely correct. Macaulay duration Modified duration 11.98 X 11.52 X
Refer to this chart and look at the Treasury bond maturing in March 2022. Required: How much would you have to pay to purchase one of these bonds? Note: Do not round intermediate calculations. Round your answer to 3 decimal places. What is its coupon rate? Note: Round your answer to 3 decimal places. What is the yield to maturity of the bond? Note: Do not round intermediate calculations. Round your answer to 3 decimal places.
A bond that has a face value of $1,500 and coupon rate of 3.10% payable semi- annually was redeemable on July 1, 2035. Calculate the purchase price of the bond on February 10, 2029 when the yield was 3.60% compounded semi-annually. Please include a well-labelled timeline diagram. Full solutions should be shown on separate sheets of paper. Submit your solutions. a. What was the purchase price of the bond? Round to the nearest cent b. What was the amount of discount or premium on the bond? (click to select) v amount is Round to the nearest cent
Find the duration of a bond with a settlement date of May 27, 2023, and maturity date November 15, 2034. The coupon rate of the bond is 9.0%, and the bond pays coupons semiannually. The bond is selling at a bond-equivalent yield to maturity of 10.0%. Use Spreadsheet 16.2. (Do not round intermediate calculations. Round your answers to 4 decimal places.)
Find the duration of a bond with a settlement date of May 27, 2023, and maturity date November 15, 2034. The coupon rate of the bond is 7.5%, and the bond pays coupons semiannually. The bond is selling at a bond-equivalent yield to maturity of 5.5%. Use Spreadsheet 16.2. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
Find the YTM of a Treasury bond which you are considering purchasing. The settlement date is Oct. 1, 2023. The bond matures on Dec. 15, 2026 and has a 4.25% coupon rate (the maturity date tells you when the coupon payments are made). The quoted price for the bond is 102:12.
Find the duration of a bond with a settlement date of May 27, 2025, and maturity date November 15, 2036. The coupon rate of the bond is 8.0%, and the bond pays coupons semiannually. The bond is selling at a bond- equivalent yield to maturity of 8.0%. Use Spreadsheet 16.3 Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Macaulay duration Modified duration
The closing price of a U.S. Treasury bond with a face value of $1400 is quoted as 105.45 points, for a current yield of 3.7%. If you buy this bond, how much annual interest will you receive? Make sure your final answer is in a statement form. Show all your math formula/setun math work, and your answer in the space below.
A Treasury bond that settles on October 18, 2019, matures on March 30, 2038. The coupon rate is 6.20 percent, and the bond has a yield to maturity of 5.71 percent. What are the Macaulay duration and modified duration? (Use the duration functions in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
A Treasury bond that settles on October 18, 2022, matures on March 30, 2041. The coupon rate is 6.10 percent, and the bond has a yield to maturity of 5.57 percent. What are the Macaulay duration and modified duration? Note: Use the duration functions in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places. Answer is complete but not entirely correct. Macaulay duration 11.4179 Modified duration 10.8154 X
A Treasury bond that settles on October 18, 2019, matures on March 30, 2038. The coupon rate is 5.45 percent, and the bond has a yield to maturity of 4.66 percent. What are the Macaulay duration and modified duration? (Use the duration functions in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) X Answer is complete but not entirely correct. Macaulay duration Modified duration 12.0670 11.5297