Table 3: Summary statistics
This table displays summary descriptive statistics of the variables used
Statistic N Mean St. Dev. Min Pctl(25) Pctl(75) Max
Panel A: Endogenous Variables
∆Log (loans) 3,359,757 0.124 0.626 −1.128 −0.161 0.392 1.985
∆Log (borrowing) 1,038,853 0.335 0.825 −1.232 −0.134 0.739 2.488
∆Log (N.emplo) 1,038,853 −0.008 0.201 −0.693 0.000 0.000 0.624
Panel B: Variables of Interest
Low.D2MDA 5,301,688 0.422 0.494 0.000 0.000 1.000 1.000
L.Dist.MDA 5,301,688 0.062 0.065 0.002 0.026 0.072 0.334
Exp.Firm 5,301,688 0.422 0.494 0.000 0.000 1.000 1.000
Panel C: Control variables
L.OCR 5,301,688 0.105 0.011 0.070 0.097 0.111 0.485
L.TA.log 5,291,458 26.323 1.383 19.424 25.614 27.240 27.240
L.RWA/TA 5,291,458 0.388 0.117 0.156 0.283 0.449 0.811
L.MKT FUNDING/TA 5,291,456 0.147 0.096 0.000 0.090 0.218 0.422
L.NIM 5,259,679 0.013 0.007 0.001 0.010 0.016 0.033
L.NPL 5,277,218 0.045 0.043 0.001 0.023 0.048 0.260
L.LIQUID/TA 5,291,458 0.188 0.134 0.006 0.091 0.248 0.482
L.DIVERS 5,259,679 0.485 0.182 −0.128 0.350 0.605 0.966
L.OFF BS 5,288,863 0.247 0.093 −0.001 0.169 0.336 0.452
L.LOAN/TA 5,291,458 0.786 0.088 0.399 0.758 0.845 0.967
L.CIR 5,253,107 0.696 0.222 0.246 0.601 0.761 2.402
L.PROVISION/TA 5,287,075 0.006 0.004 0.00003 0.004 0.008 0.027
TLTRO.III 5,259,636 0.055 0.049 0.000 0.011 0.095 0.161
S.MORA 4,700,501 0.005 0.062 0.000 0.000 0.000 1.000
S.GUAR 4,700,501 0.157 0.320 0.000 0.000 0.000 1.000
DIVIDEND.REST 5,301,688 0.002 0.003 −0.0005 0.000 0.003 0.024
L.FORBEARANCE 5,244,999 0.028 0.028 0.001 0.009 0.041 0.157
Note: ∆ Log (loans) is the change in bank-firm lending in logarithm. ∆ Log (borrowing) is
the change in the logarithm of a firm’s total borrowing. ∆Log (N.emplo) is the logarithmic
change in the number of employees at the firm level. Low.D2MDA is a dummy variable that
takes the value 1 if a bank has a pre-pandemic distance to the MDA trigger below the first
quartile of the distance to MDA trigger distribution. L.Dist.MDA is the lag of the distance to
the MDA trigger. Exp.Firm is a dummy variable that takes the value 1 for firms that prior to
the pandemic have more than 25% of their credit originating from vulnerable banks. L.OCR is
the lag of the Overall Capital Requirement Ratio. L.TA.log is the lag of the logarithm of bank
total assets. L.RW is the lag of risk weight assets-to-total assets ratio. L.MKT FUNDING/TA
is the lag of the debt securities-to-total asset ratio. L.NIM is the lag of the net interest margins.
L.NPLs in the lag of the non-performing loans-to-total loans ratio. L.LIQUID/TA is the lag of
the ratio of cash and financial assets held for trading-to-total assets. L.DIVERS is the lag of the
ratio of non-interest income-to-operating income. L.OFF BS is the lag of the ratio of off-balance
sheet activities-to-total assets. L.LOAN/TA is the lag of the credit exposures-to-total assets
ratio. L.CIR is the lag of the cost-to-income ratio. L.PROVISION/TA is the lag of the ratio of
provisions-to-total assets. TLTRO.III is the ratio of targeted long term refinancing operations
III-to-total assets. Sh Mora is the bank-firm share of loans under moratorium. Sh Guara is the
ECB Working Paper Series No 2644 / February 2022