You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2022. All of the bonds have a par value of $1,000 and pay semiannual coupons. Rate ?? 6.052 6.143 Maturity Month/Year May 33 May 36 May 42 Bid 103.4560 104.4900 ?? Asked 103.5288 104.6357 ?? Change +.3248 +.4245 +.5353 Ask Yield 5.919 ?? 3.951 In the above table, find the Treasury bond that matures in May 2036. What is your yield to maturity if you buy this bond? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter6: Fixed-income Securities: Characteristics And Valuation
Section: Chapter Questions
Problem 20P
icon
Related questions
Question

Can you solve this problem using excel and its functions. 

You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2022. All
of the bonds have a par value of $1,000 and pay semiannual coupons.
Rate
??
6.052
6.143
Maturity
Month/Year
May 33
May 36
May 42
Yield to maturity
Bid
103.4560
Asked
103.5288
104.4900 104.6357
??
??
In the above table, find the Treasury bond that matures in May 2036. What is your yield to maturity if you buy this bond?
Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.
Change Ask Yield
+.3248 5.919
??
+.4245
+.5353
3.951
%
Transcribed Image Text:You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2022. All of the bonds have a par value of $1,000 and pay semiannual coupons. Rate ?? 6.052 6.143 Maturity Month/Year May 33 May 36 May 42 Yield to maturity Bid 103.4560 Asked 103.5288 104.4900 104.6357 ?? ?? In the above table, find the Treasury bond that matures in May 2036. What is your yield to maturity if you buy this bond? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. Change Ask Yield +.3248 5.919 ?? +.4245 +.5353 3.951 %
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Rate Of Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage