Question
In: Finance
To calculate the number of years until maturity, assume that it is currently January 15, 2019....
To calculate the number of years until maturity, assume that it is currently January 15, 2019. All of the bonds have a $2000 par value and pay semiannual coupons.
Company(Ticket) Coupon Maturity Last price Last Yield EST$Vol
Xenon, Inc 5.400 Jan 15, 2024, 96.153 ?? 57.362
Kenny Corp 7.125 Jan 15, 2026 ?? 6.02 48.941
Williams Co ?? Jan 15, 2028, 95.165 6.85 43.802
31. What is the yield to maturity for the bond issued by Xenon, Inc..?
32. What price would you expect to pay for the Kenny Corp.bond? What is the bond's current yield?
33. What is the coupon rate for the Williams Co. bond?
How can i solve #31,32,33 for using excel?
Solutions
jeff jeffy answered 1 year agoRelated Solutions
To calculate the number of years until maturity, assume that it is currently January 15, 2013....
To calculate the number of years until maturity, assume that it
is currently January 15, 2013.
Company
(Ticker)
Coupon
Maturity
Last
Price
Last
Yield
EST $ Vol
(000’s)
Xenon, Inc. (XIC)
5.400
Jan 15, 2020
94.183
??
57,362
Kenny Corp. (KCC)
7.125
Jan 15, 2017
??
6.02
48,941
Williams Co. (WICO)
??
Jan 15, 2026
94.735
6.85
43,802
Required:
What is the yield to maturity for the bond issued by...
To calculate the number of years until maturity, assume that it is currently May 2013. Rate...
To calculate the number of years until maturity, assume that it
is currently May 2013.
Rate
Maturity Mo/Yr
Bid
Asked
Chg
Ask Yield
??
May 21
103.5540
103.6422
+.3093
2.449
5.524
May 26
104.5030
104.6487
+.4365
??
6.193
May 36
??
??
+.5483
4.151
* yes i know it says May 36. that's how it is worded in the
problem.
In the above table, find the Treasury bond that matures in May
2021. What is the coupon rate for this...
You find the following corporate bond quotes. To calculate the number of years until maturity, assume...
You find the following corporate bond quotes. To calculate the
number of years until maturity, assume that it is currently January
15, 2019. The bonds have a par value of $2,000 and semiannual
coupons.
Company
(Ticker)
Coupon
Maturity
Last
Price
Last
Yield
EST $ Vol
(000’s)
Xenon, Inc. (XIC)
6.300
Jan 15, 2032
94.273
??
57,371
Kenny Corp. (KCC)
7.210
Jan 15, 2031
??
5.32
48,950
Williams Co. (WICO)
??
Jan...
You find the following Treasury bond quotes. To calculate the number of years until maturity, assume...
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
Maturity
Mo/Yr
Bid
Asked
Chg
Ask
Yld
??
May 26
103.5423
103.5301
+.3261
5.939
6.102
May 31
104.4913
104.6370
+.4257
??
6.148
May 41
??
??
+.5366
3.971
a.
In...
You find the following Treasury bond quotes. To calculate the number of years until maturity, assume...
You find the following Treasury bond quotes. To calculate the
number of years until maturity, assume that it is currently May
2016. The bonds have a par value of $1,000.
Rate
Maturity
Mo/Yr
Bid
Asked
Chg
Ask
Yld
??
May
26
103.5488
103.6370
+.3041
2.369
5.324
May 31
104.4978
104.6435
+.4317
??
6.173
May 41
??
??
+.5431
4.071
In the above table, find the Treasury bond that matures in May
2026. What is the coupon rate for this bond?...
You find the following corporate bond quotes. To calculate the number of years until maturity, assume...
You find the following corporate bond quotes. To calculate the
number of years until maturity, assume that it is currently January
15, 2016. The bonds have a par value of $2,000.
Company
(Ticker)
Coupon
Maturity
Last
Price
Last
Yield
EST $
Vol
(000’s)
Xenon, Inc.
(XIC)
6.200
Jan 15, 2030
94.279
??
57,370
Kenny Corp. (KCC)
7.200
Jan 15,
2027
??
6.18
48,949
Williams Co. (WICO)
??
Jan 15,
2034
94.815
7.00
43,810
What is the yield to maturity for...
You find the following corporate bond quotes. To calculate the number of years until maturity, assume...
You find the following corporate bond quotes. To calculate the
number of years until maturity, assume that it is currently January
15, 2016. The bonds have a par value of $2,000.
Company
(Ticker)
Coupon
Maturity
Last
Price
Last
Yield
EST $
Vol
(000’s)
Xenon, Inc. (XIC)
5.600
Jan 15,
2022
94.203
??
57,364
Kenny Corp.
(KCC)
7.140
Jan 15,
2019
??
6.06
48,943
Williams Co.
(WICO)
??
Jan 15,
2025
96.755
6.31
43,804
What is the coupon rate for the...
You find the following Treasury bond quotes. To calculate the number of years until maturity, assume...
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
Maturity
Mo/Yr
Bid
Asked
Chg
Ask
Yld
??
May 24
103.5540
103.5418
+.3093
6.119
5.524
May 29
104.5030
104.6487
+.4365
??
6.193
May 39
??
??
+.5483
4.151
a.
In...
You find the following corporate bond quotes. To calculate the number of years until maturity, assume...
You find the following corporate bond quotes. To calculate the
number of years until maturity, assume that it is currently January
15, 2019. The bonds have a par value of $2,000 and semiannual
coupons.
Company
(Ticker)
Coupon
Maturity
Last
Price
Last
Yield
EST $ Vol
(000’s)
Xenon, Inc. (XIC)
6.00
Jan 15, 2031
94.255
??
57,368
Kenny Corp. (KCC)
7.18
Jan 15, 2028
??
6.14
48,947
Williams Co. (WICO)
??
Jan...
You find the following Treasury bond quotes. To calculate the number of years until maturity, assume...
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
Maturity
Mo/Yr
Bid
Asked
Chg
Ask
Yld
??
May 24
103.5540
103.5418
+.3093
6.119
5.524
May 29
104.5030
104.6487
+.4365
??
6.193
May 39
??
??
+.5483
4.151
a.
In...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Exercise 21-17 Indirect method; reconciliation of net income to net cash flows from operating activities [LO21-4]...
- 1. Summarize the four meanings of parrhesia as explained in the first section of the Foucault...
- Exercise 21-23 Cash flows from operating activities (direct method) [LO21-3] Portions of the financial statements for...
- A company currently pays a dividend of $3.25 per share (D0 = $3.25). It is estimated...
- Absenteeism is a major problem for some companies and in some industries. Suppose a study was...
- A
- Explain briefly the main challenges of business process integration for a small business with example ?
ADVERTISEMENT