To calculate the number of years until maturity, assume that it is currently January 15,...

90.2K

Verified Solution

Question

Finance

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?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students