Question

When you buy a bond, the date of purchase (the settlement date) is often between two...

When you buy a bond, the date of purchase (the settlement date) is often between two coupon payment dates. In this situation, the price you pay (the invoice price) is the sum of the flat price and the accrued interest. Invoice price = Flat price + Accrued Interest For a semi-annual payment coupon bond, the accrued interest In this exercise, you compute the invoice price of a $1000 par value, 5% semi-annual payment coupon bond maturing on 30th June 2025 for various settlement dates. Use a yield to maturity of 6.2%. a) Calculate the invoice price (as a percentage of par value and in dollars) when the settlement date is 30th June 2019. b) Calculate the invoice price (as a percentage of par value and in dollars) when the settlement date is 5th September 2019. Calculate in excel with functions. How would I enter this into excel?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In this exercise, you compute the invoice price of a $1000 par value, 5% semiannual payment...
In this exercise, you compute the invoice price of a $1000 par value, 5% semiannual payment coupon bond maturing on 30th June 2025 for various settlement dates. Use a yield to maturity of 6.2%. a) Calculate the invoice price (as a percentage of par value and in dollars) when the settlement date is 30 June 2019. A. 932.68 B. 933.49 C. 940.63 D. 943.15 E. 951.18 b) Calculate the invoice price (as a percentage of par value and in dollars)...
Table 14.0 (for questions 14 and 15). Information regarding Bond G, sold for settlement on June...
Table 14.0 (for questions 14 and 15). Information regarding Bond G, sold for settlement on June 16, 2014. Annual Coupon 5% Coupon Payment Frequency Semiannual Interest Payment Dates 10 April and 10 October Maturity Date 10 October 2016 Day-count Convention 30/360 Annual Yield-to-Maturity 4% For Bond G listed in Table 14.0 what is the accrued interest per 100 of par value on the settlement date of June 26, 2014 is: 1.06 0.75 0.92 none of the above. What is the...
Suppose that a bond is purchased between coupon periods. The days between the settlement date and...
Suppose that a bond is purchased between coupon periods. The days between the settlement date and the next coupon period are 80. There are 182 days in the coupon period. Suppose that the bond purchased has a coupon rate of 7% and there are 8 semiannual coupon payments remaining. The par value of the bond is $100. a. What is the full price for this bond if a 6.2% annual discount rate is used? b. What is the accrued interest...
You are given the following information for a semi-annual coupon payment bond: Coupon rate: 2.5%, par...
You are given the following information for a semi-annual coupon payment bond: Coupon rate: 2.5%, par value $1,000 Price quote: 98:14 Days since last coupon settlement: 73 Days separating coupon payments 182 What is the flat price of the bond? How much is the accrued interest on the bond? What is the full price of the bond?
1.Consider a  semi-annual Treasury Bond with a settlement date of 9/22/2020 and a maturity date of 6/15/2025...
1.Consider a  semi-annual Treasury Bond with a settlement date of 9/22/2020 and a maturity date of 6/15/2025 and a coupon rate of 3.5%. The investor's estimated yield on the bond is 2.25%, what is the estimated quoted price? (Answer as a percent of the bonds face value)
Assume that June 19, 2018 is the settlement date. A bond was issued on November 12,...
Assume that June 19, 2018 is the settlement date. A bond was issued on November 12, 2005, and matures November 12, 2025. It pays a 4.50% coupon semiannually and has a yield on June 19, 2018 of 7.25%. What was the market rate of the above bond when it was first issued? How would I do this on excel?
A Delta Corporation bond issue is described below. It is sold for a settlement on July...
A Delta Corporation bond issue is described below. It is sold for a settlement on July 10, 2019. Annual Coupon 9 Coupon Payment Frequency Semiannual Interest payment dates 20 March, 20 September Maturity Date 20 September 2020 Day Count Convention 30/360 Annual Yield to Maturity 5 percent What is the full price of the bond that will settle on July 10, 2019?
On July 10, 2019, you purchase a $10,000 T-note that matures on December 31, 2028 (settlement...
On July 10, 2019, you purchase a $10,000 T-note that matures on December 31, 2028 (settlement occurs one day after purchase, so you receive actual ownership of the bond on July 11, 2019). The coupon rate on the T-note is 2.125 percent and the current price quoted on the bond is 98.250 percent. The last coupon payment occurred on June 30, 2019 (11 days before settlement), and the next coupon payment will be paid on December 31, 2019 (173 days...
A 6% German corporate bond is priced for settlement on 18 June 2015 at a yield...
A 6% German corporate bond is priced for settlement on 18 June 2015 at a yield (YTM) of 6%. The bond makes semi-annual coupon payments on 19 March and 19 September each year and matures on 19 September 2016. Assume the market uses an actual/actual convention to price this bond. a. What is the full price of this bond? (Hint: based on an actual/actual day-count convention there are 91 days between the last coupon date and the settlement date, and...
On October 5, 2019, you purchase a $13,000 T-note that matures on August 15, 2031 (settlement...
On October 5, 2019, you purchase a $13,000 T-note that matures on August 15, 2031 (settlement occurs two days after purchase, so you receive actual ownership of the bond on October 7, 2019). The coupon rate on the T-note is 5.375 percent and the current price quoted on the bond is 105.5 percent. The last coupon payment occurred on May 15, 2019 (145 days before settlement), and the next coupon payment will be paid on November 15, 2019 (39 days...