Using Excel’s “LAMBDA” Feature to Produce Multi-Stage Stock Pricing Functions for the Classroom

Authors

Tom Arnold, University of RichmondFollow
Joseph Farizo, University of RichmondFollow
Jonathan Godbey

Abstract

Excel’s new “=LAMBDA” function is applied to multi-stage stock pricing. This provides a context for implementing the =LAMBDA function, a greater understanding of the concept of the time value of money, and a reduction in the complexity of performing the calculation. The =LAMBDA functions lessens the need for using VBA and macros and only requires basic knowledge of Excel function syntax.

Document Type

Working Paper

Publication Date

7-25-2024

Recommended Citation

Arnold, Tom, C., Joseph Farizo, Jonathan M. Goodbye. "Using Excel’s “LAMBDA” Feature to Produce Multi-Stage Stock Pricing Functions for the Classroom," University of Richmond Robins School of Business, (2024): 1-10.