Using Excel’s “LAMBDA” Function to Compute Modified Duration, Dollar Duration, and Bond Convexity

Tom Arnold, University of Richmond
Joseph Farizo, University of Richmond
Andrew C. Szakmary, University of Richmond
Nancy Tran, University of Richmond

Abstract

We create a modified duration function that is more accessible than Excel’s current Macaulay duration function (=DURATION) which requires several details about the bond.

The dollar duration and convexity functions are not currently available in Excel’s default functions. When these functions are copied to a second Excel file, the functions automatically become available as functions within the second file without the need for recreating the functions.

We provide instructions on how to implement the =LAMBDA function to more than just the creation of the bond application functions.