Bond Valuation Price Function in Excel

More videos at facpub.stjohns.edu/~moyr/vide...

[@mouhamadoudiallo-cn8sp]

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

[@A--TruongNgocDiemTuyet]

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

[@judeoni5613]

Thank you for sharing. It was helpful.

[@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

[@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.