- This topic has 1 reply, 2 voices, and was last updated 3 months ago by
John Moffat.
John Moffat.Viewing 2 posts - 1 through 2 (of 2 total)
-
Posts
-
sarah762
- Topics: 67
- Replies: 127
- ☆☆
I used excel formula to calculate N(-d1) which equals to 0.48, but the answer shown is 0.5298.
[ =NORMSDIST(-0.06) ] —> formula I used.
Did I calculate wrongly?
John Moffat
- Topics: 57
- Replies: 49993
- ☆☆☆☆☆
d1 = – 0.055
Therefore -d1 = +0.055.
From the tables (which is quicker that using an excel formula), N(+0.055) is half way between 0.0239 and 0.0199, and you then need to add 0.5 as I explain in my lectures.
sarah762
John MoffatViewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.