<t>This is the VBA code to price a cap. Copy and paste it into the VBA editor, then you can use this function in Excel. It's very easy to implement and modify to price floors, swaptions...Hope this helps.Public Function Black76Call(F, X, r, tau, sigma)Dim DOne, DTwo, NDOne, NDTwoDOne = (Log(F / X) /...