Question

How do you calculate the price of a bond after the settlement date (what's the formula)?

How do you calculate the price of a bond after the settlement date (what's the formula)?

Homework Answers

Answer #1

The PRICE formula in excel can be used to calculate the market price of bond per $100 face value.

Formula;

=PRICE(Settlelment, Maturity, rate, yld, redemption, frequency, [basis] )

where;

settlement = settlement date,

Maturity=maturity date on bond

rate=Annual coupon rate of the bond

frequency =no of coupons paid per year

Basis: the financial day count basis used by the bond.

There is another way where the market price is calculated by deriving the present value of the future interest payments and the redemption value by using the yield as the discount factot.

Bond Price = C1/(1+Y/k)^1 +C2/(1+Y/k)^2 +C3/(1+Y/k)^3 +..............Cn/(1+Y/k)^n +P/(1+Y/k)^kn

Where C =Interest payment for each period

n=no of years for maturity

Y =Yiled to maturity or Adjusted Market rate

k=no of coupon payments per year.

P=Par value of Bond

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
How do you calculate the price of a bond after the settlement date (what's the formula)?...
How do you calculate the price of a bond after the settlement date (what's the formula)? Answer quickly will rate
How do you calculate the dirty price of a bond after the settlement date (what's the...
How do you calculate the dirty price of a bond after the settlement date (what's the formula)?
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...
What is the formula to calculate market interest for a bond? And how do you calculate...
What is the formula to calculate market interest for a bond? And how do you calculate cost of debt?
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?
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
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?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT