in Chapter 23 of Hull's Options, Futures, and Derivatives he has an example (i.e. example 23.4) which shows how the Credit VaR formula is applied. The answer in the formula is 0.128. I can't seem to get the same answer since the N that get is either ±3.1951 or ±1.1351. It seems I need to get a distribution of N(0.551) = 0.128. May I ask how should be formula be understood? Thanks.enter image description here


1 Answer 1


Here is the excel formula with steps:





They keep changing the names of the function - e.g., NORMSDIST is NORM.S.DIST(-1.135,TRUE)in the recent versions, and same for NORMSINV = NORM.S.INV

  • $\begingroup$ I see, now I understand. Thank you very much. $\endgroup$ Commented Dec 22, 2019 at 23:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.