A New Lease On Firm Behavior (Data)
By Matteo Binfare, Robert Connolly, Fotis Grigoris, and Crocker Liu
Working paper, 2023
Last Update: 24 October 2023
This page provides an updated version of the data underlying our paper A New Lease On Firm Behavior. This data is obtained by scraping each firm’s 10-K and 10-Q accounting reports to acquire two variables disclosed under the Financial Accounting Standards Board’s recently implemented Accounting Standards Update (ASC) 2016-02: Leases (Topic 842). Among other changes, this accounting standards update required firms to begin disclosing
- The weighted average discount rate used to compute the present value of operating lease commitments
- The weighted average remaining life of the firm’s operating leases
Below, we provide summary statistics associated with each of these two variables for all firms preparing accounting statements in accordance with these updated requirements (provided the firm reports a strictly positive lease liability and the discount rate is not missing).
We also provide the data (in .xlsx format) for other interested academic researchers. If you use this data in your own research, please cite our paper A New Lease On Firm Behavior. See the BibTeX reference for our paper here.
Summary statistics
Variable | N | Mean | SD | p25 | Median | p75 |
---|---|---|---|---|---|---|
Weighted Average Discount Rate (%) | 43,169 | 5.74 | 2.80 | 3.86 | 5.10 | 7.00 |
Weighted Average Remaining Life (Years) | 43,169 | 7.67 | 9.09 | 3.90 | 6.00 | 8.56 |
Data (zipped .xlsx file)
Updated data underlying ‘A New Lease On Firm Behavior’
The data contains the following variables:
- CIK: The Central Index Key of the filer
- FDATE: The filing date of the statement
- RDATE: The fiscal period end date associated with the statement
- OPLEASE_DR: The weighted average discount rate used to value operating lease liabilities, disclosed in accordance with ASC 842
- OPLEASE_WAL: The weighted average remaining life of operating leases, disclosed in accordance with ASC 842
Return to Research