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)?

Answer quickly will rate

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)?
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?
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
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)
PLEASE PUT THE FORMULA OF EXCEL. THANK YOU You find a zero coupon bond with a...
PLEASE PUT THE FORMULA OF EXCEL. THANK YOU You find a zero coupon bond with a par value of $10,000 and 17 years to maturity. The yield to maturity on this bond is 4.9 percent. Assume semiannual compounding periods. What is the price of the bond? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d6 Settlement date: 1/1/2000 d7 maturity date:1/1/2017 d8: coupon rate: 0.00% d9: coupons per year: 2 d10: redemption value:...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT