thanks you soo much i am doing an online classe on edx on financial market analysis and your video was very helpfule
@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?
@judeoni5613
7 ай бұрын
Thank you for sharing. It was helpful.
@A--TruongNgocDiemTuyet
3 ай бұрын
Thank you so much, It helps me to make my homework
@shaziyashaduly5208
Жыл бұрын
thanks for the help
@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.
@dishantpatel7144
Жыл бұрын
You literally could have saved 2 minutes if you just typed =PRICE.. Appreciate the content however, very helpful and will be very useful.
Пікірлер: 12