Question

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?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Assumption Par Value of Bond is $ 1000

Market Price of Bond = PV of Cash Flows from it.

COupon payments are made semi Annually

i.e on Nov 12 & May 12.

First FInd the Value of Bond on NOV 12- 2019 ( Next Coupon Payment Date)

PVF = 1/(1+0.03625)^n

Disc CF = CF * PVF

Value of Bond on 19-12-2018 is dicounted value of 865.53 @ 2.9% ( 7.25% * 146 / 365 )

= 865.53 * 1 / 1.0290

= 841.14

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Find the duration of a bond with settlement date May 30, 2018, and maturity date November...
Find the duration of a bond with settlement date May 30, 2018, and maturity date November 21, 2027. The coupon rate of the bond is 5%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 6%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration: ??? Modified duration: ???
Find the duration of a bond with settlement date June 16, 2016, and maturity date December...
Find the duration of a bond with settlement date June 16, 2016, and maturity date December 25, 2025. The coupon rate of the bond is 5%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 6%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration = Modified duration =
Find the duration of a bond with settlement date June 16, 2016, and maturity date December...
Find the duration of a bond with settlement date June 16, 2016, and maturity date December 25, 2025. The coupon rate of the bond is 5%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 6%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration = Modified duration =
Find the duration of a bond with settlement date June 10, 2016, and maturity date December...
Find the duration of a bond with settlement date June 10, 2016, and maturity date December 13, 2025. The coupon rate of the bond is 7%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
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...
Dirty Bond Price A 4.4% bond matures October 15th, 2026. The trading date was June 25th,...
Dirty Bond Price A 4.4% bond matures October 15th, 2026. The trading date was June 25th, 2018. The YTM was 5.0% on that date. The bond pays coupons semiannually. Assume each month has 30 days and each semiannual coupon period has 180 days. The "dirty" price of the bond (cash price paid at the settlement date) should have been $______________.   Margin of error for correct responses: +/- $.05. It's not incomplete. This is all the information provided.
Given that settlement date of a bond is July 3, 2018 and the previous coupon date...
Given that settlement date of a bond is July 3, 2018 and the previous coupon date was June 30, 2018 and maturity date is June 30, 2020. What would be the fraction (f) to use to find the bond's dirty price on August 1, 2018?
Assume that on January 1, 2005, Ryan Industries issued ($1000 par) bonds with an annual coupon...
Assume that on January 1, 2005, Ryan Industries issued ($1000 par) bonds with an annual coupon rate of 12% paid semiannually. The bonds, when issued, had an original maturity of 30 years, so the maturity date is January 1, 2035. By january 1, 2018, the bond price was $1,177.70 in the market. What was the bond's market yield-to-maturity on January 1, 2018?
Question 6 Assume that a bond is issued with the following characteristics: Date of bonds: January...
Question 6 Assume that a bond is issued with the following characteristics: Date of bonds: January 1, 2005; maturity date: January 1, 2010; face value: $200,000; face interest rate: 10 percent paid semiannually (5 percent per period); market interest rate: 8 percent (4 percent per semiannual period); issue price: $216,222; bond premium is amortized using the straight-line method of amortization. What is the amount of bond premium amortization for the June 30, 2005, adjusting entry? A- $811 B- $1,622 C-...
Ailerone, Inc. has issued a bond with the following characteristics: Par Value 1,000 Settlement date 1/1/2000...
Ailerone, Inc. has issued a bond with the following characteristics: Par Value 1,000 Settlement date 1/1/2000 Maturity date 1/1/2015 Annual coupon rate   11.00% Coupons per year 2 Yield to maturity 12% What is the price of the bond? $931.18 $657.50 $30.00 $734.56
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT