Intro You purchase the following bond. The bond makes interest payments on April 10 and Oct. 10 of every year: 1 Purchase date 8/19/2021 2 Maturity date 10/10/2037 3 First call date 4/10/2029 4 Coupon rate 2.8% 5 Price 83.7 6 Face value 100 7 Payment frequency 8 Day count basis 30/360 9 Call price 134.18 What is the bond's yield to maturity using Excel's YIELD function? What is the bond's yield to call using Excel's YIELD function?

Intro You purchase the following bond. The bond makes interest payments on April 10 and Oct. 10 of every year: 1 Purchase date 8/19/2021 2 Maturity date 10/10/2037 3 First call date 4/10/2029 4 Coupon rate 2.8% 5 Price 83.7 6 Face value 100 7 Payment frequency 8 Day count basis 30/360 9 Call price 134.18 What is the bond's yield to maturity using Excel's YIELD function? What is the bond's yield to call using Excel's YIELD function?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter12: Investing In Stocks And Bonds

Section: Chapter Questions

Problem 6FPE

See similar textbooks

Similar questions

A bond has following characteristics: it was issued on 14.06.2018 and has 10 years to maturity. Coupon is paid semi-annually and carries interest rate of 3,2%. Market interest rate is currently 2,9% for similar issues. Investor purchased the bond on 19.11.2021. a. Calculate MacDuration b. Calculate ModDuration c. When market interest rates increase by 50 basis points, calculate price effect using results obtained in question (b)
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
Suppose a sixy ear bond is purchased for $4800. The face value of the bond when it matures is $7032. Find the APR.
Assume that today's date is August 15, 2015 and that the Kroger Bond is a semiannual-coupon bond with 1000 USD of Face value. Look at the table below with information of Kroger Bond and fill in the missed number with question mark: Type Issue date Price (% of face value) Coupon rate Maturity date YTM Current Yield Rating Bond April-2003 115.25 7.25% 2/15/2029 ??? 8.637% AAA
Problem: You are given the following data for two bonds with semiannual payments (A and B) Bond Settlement Date B 2/15/2020 2/15/2020 Maturity Date Coupon rate 2/15/2040 2/15/2040 4% 8% Similar bonds with 20 year to maturity sell for 9% coupon rates in the market. a) Calculate the bond value for bond A and B b) Calculate the YTM for bond A and B Bond Valuation Settlement Date 2/15/2020 2/15/2020 Maturity Date Coupon rate Required return Redemption Value Frequency Basis Calculate the PV of the bond in U.S. S 2/15/2040 2/15/2040 8% 4% 4.50% 4.50% 100 100 2 a) Use the Price Function B) Use the Yield Function
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 8.5%, 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.) Macaulay duration Modified duration
Vhat is the yield of each of the following bonds, if interest (coupon) is paid semiannually? 6% 20 8.02 % 5800.00 d of the following bond if interest (coupon) is 1 Data Table - X Years to Coupon Rate Matunty 12% 10 (Click on the following icon n in order to copy its contents into a spreadsheet.) eld of the following bond if interest (coupon) is Par Value $1,000.00 Yield to Maturity Matunty Doupon Rale 6% Price $800.00 $1,000.00 S3.110.00 $1.130.00 క Noturty 20 10 Coupon ato $1.000.00 12% 7% 20 $5,000.00 $1.000.00 7% 20 8% yield of the following bond if interest (coupon) is Yoars to Coupon Hate Print Done Maturity 00 8%
You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2019 and the bond has a par value of $1,000. Rate ?? 5.324 6.173 Maturity Mo/Yr May 29 a. Asked price b. Bid price May 34 May 44 Bid Asked 103.5488 103.5366 104.4978 104.6435 ?? Chg +.3041 +.4317 ?? +.5431 Ask Yld 6.039 ?? 4.071 a. In the above table, find the Treasury bond that matures in May 2044. What is the asked price of this bond in dollars? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. If the bid-ask spread for this bond is .0538, what is the bid price in dollars? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
A Treasury bond that settles on August 10, 2022, matures on November 5, 2029. The coupon rate is 6.8 percent and the 11811 32 quoted price is What is the bond's yield to maturity? Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Yield to maturity A Treasury bond that settles on August 10, 2022, matures on November 5, 2029. The coupon rate is 6.8 percent and the quoted price is 118 11/32. What is the bond's yield to maturity? Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Yield to maturity
c) Suppose you observe the following three bonds. Assume that all bonds are denominated at $100 face value per contract and that they pay their coupons annually. Price Coupon Maturity (years) Bond A 111.42 15 3 Bond B 108.33 15 Bond C 116.61 15 1 i) Compute the spot rates r0,1, r0,2 and r0,3. ii) Compute the forward rates r1,2 and r2,3.
The following Bond Data is provided on the FINRA website: Suppose Today's date is 07/11/2023 • Bond Maturity Date: 07/11/2031 Today's Bond Price: $81.95 Bond PAR value: $100 Bond Coupon Rate: 1.8% (coupons are paid semiannually). What is the computed yield to maturity of this Bond? Enter your answer in the format: 0.1234 Hint: Gather N, PV, PMT, FV and compute I/Y; Assume there are 365 days in a year.
Based on the following information for a bond, what is the bond's coupon rate? (EXCEL EQUATION IF POSSIBLE) Years to maturity 25 Par value 1000 Interest rate 0.1 current price 1200 Coupon payments are made semiannually. a. .1108 b. .1082 c. .1331 d. .1219