$105,000 bond redeemable at par on October 15, 2028 is purchased on May 9,2017. The bondi ayable semi-annually and the yield (market interest rate) is 2.24 % compounded semi-annually. hould this bond sell at a Premium or a Discount? (Premium or Discount) ) Determine the value of the coupon. 2.) Use Excel's COUPNUM function to find the number of coupons left on the bond. =) Determine the Present Value of the bond, at the last coupon date. Rounded to 2 decimals. d.) Determine the Present Value of the coupons at the last coupon date. Rounded to 2 decimals. e.) What is the purchase price of the bond on the last coupon date?

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter6: Fixed-income Securities: Characteristics And Valuation
Section: Chapter Questions
Problem 13P
icon
Related questions
Question
n
A $105,000 bond redeemable at par on October 15, 2028 is purchased on May 9,2017. The bond interest rate (coupon rate) is 8.94%
payable semi-annually and the yield (market interest rate) is 2.24% compounded semi-annually.
Should this bond sell at a Premium or a Discount?
(Premium or Discount)
a.) Determine the value of the coupon.
b.) Use Excel's COUPNUM function to find the number of coupons left on the bond.
c.) Determine the Present Value of the bond, at the last coupon date.
Rounded to 2 decimals.
d.) Determine the Present Value of the coupons at the last coupon date.
Rounded to 2 decimals.
e.) What is the purchase price of the bond on the last coupon date?
1.) Use Excel's COUPDAYBS to determine the number of days from the last coupon date to the purchase date
g.) Use Excel's COUPDAYS to determine the number of days between coupon dates.
h.) Use the ratio of days as 'n' to calculate the purchase price of the bond on the settlement date
Transcribed Image Text:n A $105,000 bond redeemable at par on October 15, 2028 is purchased on May 9,2017. The bond interest rate (coupon rate) is 8.94% payable semi-annually and the yield (market interest rate) is 2.24% compounded semi-annually. Should this bond sell at a Premium or a Discount? (Premium or Discount) a.) Determine the value of the coupon. b.) Use Excel's COUPNUM function to find the number of coupons left on the bond. c.) Determine the Present Value of the bond, at the last coupon date. Rounded to 2 decimals. d.) Determine the Present Value of the coupons at the last coupon date. Rounded to 2 decimals. e.) What is the purchase price of the bond on the last coupon date? 1.) Use Excel's COUPDAYBS to determine the number of days from the last coupon date to the purchase date g.) Use Excel's COUPDAYS to determine the number of days between coupon dates. h.) Use the ratio of days as 'n' to calculate the purchase price of the bond on the settlement date
Expert Solution
steps

Step by step

Solved in 2 steps with 1 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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT