Bond Valuation Price Function in Excel

[@mouhamadoudiallo-cn8sp]

thanks you soo much i am doing an online classe on edx on financial market analysis and your video was very helpfule

[@judeoni5613]

Thank you for sharing. It was helpful.

[@A--TruongNgocDiemTuyet]

Thank you so much, It helps me to make my homework

[@marctravismba]

It seems that this function only works when the first coupon is exactly six months from the settlement date. Is that correct?

[@NathanGardnerinsanity]

Is this the way to get dirty or clean price?

[@rapidsecurityservices]

i am trying to use the formula with 10 year annual coupon payment, with 7% annual coupon payments, YTM of 6,7% and Face value of 1000, why is it giving me an answer of 572,6785 whilst it should be 1021,37? Probably this function is only possible with face values of 100 and not with 1000

[@RonaldMoy]

According to Excel it does it for $100 face value. I go the same answer as you. I was confused because you used a coma in the answer, rather than a period, which we use in the U.S.

[@rapidsecurityservices]

@@RonaldMoy How can i get the answer 1021, or is it not possible with the Price function?

[@RonaldMoy]

@@rapidsecurityservices You have to use $100 and then scale up.

[@shaziyashaduly5208]

thanks for the help

[@dishantpatel7144]

You literally could have saved 2 minutes if you just typed =PRICE.. Appreciate the content however, very helpful and will be very useful.

[@RonaldMoy]

thanks