Attribute VB_Name = "Module2"
Public Function nabondcall(bs, bt, a, sg, s, t)
b2 = sg ^ 2 * (1 - Exp(-a * (s - t))) ^ 2 * (1 - Exp(-2 * a * t)) / (2 * a ^ 3)
d1 = (Log(bs / (k * bt)) + b2 / 2) / Sqr(b2)
d2 = d1 - Sqr(b2)
nd1 = Application.WorksheetFunction.NormSDist(d1)
nd2 = Application.WorksheetFunction.NormSDist(d2)
bondcall = bs * nd1 - k * bt * nd2
End Function