| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | gvkey | year | lw_debtcon_full | lw_equitycon_full | lw_debtcon_prim | lw_equitycon_prim |
2 | 1000 | 1972 | 0.2064431638 | -0.31646107 | -0.2471440859 | -0.2565625195 |
3 | 1000 | 1973 | -0.1563216123 | -0.301703709 | 0.07504294813 | -0.3670498823 |
4 | 1000 | 1974 | 0.04022533313 | -0.1983153404 | 0.2220500065 | -0.4128346749 |
5 | 1000 | 1975 | -0.04589582934 | -0.2386130157 | 0.7538876507 | -0.6806638643 |
6 | 1000 | 1976 | 0.001417418745 | -0.2779186565 | 0.1443533887 | -0.5478543278 |
7 | 1000 | 1977 | 0.3567302085 | -0.2981412113 | 0.2362598008 | -0.5474108491 |
8 | 1001 | 1984 | 0.07942664474 | -0.1733323973 | -0.4064203464 | 0.3961692639 |
9 | 1001 | 1985 | 0.1087749776 | -0.1446152697 | -0.528902001 | 0.2967094062 |
10 | 1003 | 1983 | -0.3601645951 | 0.3882965486 | -0.03140011001 | 0.9322947371 |
11 | 1003 | 1984 | -0.488578836 | 0.1624464683 | 0.05863982259 | 0.8170311193 |
12 | 1003 | 1987 | 0.1566853817 | -0.42479214 | -0.07615476177 | -0.3762935917 |
13 | 1003 | 1988 | 0.4155995617 | -0.1430699747 | 0.01983186549 | -0.3370585627 |
14 | 1003 | 1989 | 0.2763567797 | 0.1721638768 | -0.4256101033 | -0.1152101327 |
15 | 1003 | 1990 | 0.2253633724 | 0.03344676046 | -0.4612588663 | -0.1049201258 |
16 | 1004 | 1972 | -0.2933573714 | 0.4987857425 | -0.36119062 | 0.1238245801 |
17 | 1004 | 1973 | -0.1560785855 | 0.09942351592 | 0.1756610797 | 0.1319079035 |
18 | 1004 | 1974 | -0.2823194771 | 0.01369871783 | 0.1479656489 | -0.008784648975 |
19 | 1004 | 1975 | -0.008203503615 | -0.1882773269 | 0.7200936254 | -0.2603707005 |
20 | 1004 | 1976 | 0.652962201 | -0.4005372306 | 0.5393314003 | -0.09188584338 |
21 | 1004 | 1977 | 0.6975959632 | -0.2717124784 | 0.4426273726 | -0.2790093795 |
22 | 1004 | 1978 | 0.5140964818 | -0.5842477349 | 0.7008125395 | -0.3397926927 |
23 | 1004 | 1979 | 0.5030339888 | -0.5627334324 | 0.7222544081 | -0.7552490568 |
24 | 1004 | 1980 | 0.3379806156 | -0.4823782837 | 0.518029635 | -0.5034770321 |
25 | 1004 | 1981 | 0.8419380326 | -0.4205099945 | 0.1430173656 | 0.2901880656 |
26 | 1004 | 1982 | 1.078302169 | -0.479385708 | 0.5787943103 | -0.4981428658 |
27 | 1004 | 1983 | 0.6568971506 | -0.7036136941 | 0.4048942038 | -0.1363581129 |
28 | 1004 | 1984 | 0.4659899419 | -0.660777047 | 0.1131655287 | -0.3132375104 |
29 | 1004 | 1985 | 0.2807270845 | -0.6829289737 | 0.3480924068 | -0.2939364992 |
30 | 1004 | 1986 | 0.3228226499 | -0.7138125686 | 0.1718860712 | -0.7143113164 |
31 | 1004 | 1987 | 0.2052789197 | -0.6805914157 | 0.5939792807 | -0.7151529747 |
32 | 1004 | 1988 | 0.261581006 | -0.5229256574 | 0.775497659 | -0.3976964532 |
33 | 1004 | 1989 | 0.3651021181 | -0.4541221631 | -0.2300518623 | -0.06077306528 |
34 | 1004 | 1990 | 0.129138558 | -0.415153044 | 0.1319679727 | -0.313827838 |
35 | 1004 | 1991 | 0.1912635322 | -0.3098442755 | 0.2642184241 | -0.3280905986 |
36 | 1004 | 1992 | 0.2819325811 | -0.4014032507 | 0.04168911685 | -0.3033266459 |
37 | 1004 | 1993 | 0.4363477976 | -0.4688712198 | 0.2028865209 | -0.2922226428 |
38 | 1004 | 1994 | 0.2180112649 | -0.4452037552 | 0.2294037154 | -0.397392414 |
39 | 1004 | 1995 | 0.3042531067 | -0.3770935709 | -0.07663365584 | -0.6165310033 |
40 | 1004 | 1996 | 0.2072835822 | -0.3982460243 | -0.02150007136 | -0.6099004614 |
41 | 1004 | 1997 | -0.6771175404 | -0.187955097 | -0.7162984741 | -0.06096169214 |
42 | 1004 | 1998 | -0.3244164641 | -0.3082002642 | -0.4739324453 | -0.1630911285 |
43 | 1004 | 1999 | -0.2437259058 | -0.3017137411 | -0.02000498844 | 0.006234031861 |
44 | 1004 | 2000 | -0.255228474 | 0.06642184015 | -0.0553745221 | 0.300937734 |
45 | 1004 | 2001 | -1.020182766 | -0.06962340211 | -0.9809209757 | 0.1181526555 |
46 | 1004 | 2002 | 0.4239482608 | 0.1616244438 | 0.5779718274 | 0.412415045 |
47 | 1004 | 2003 | 1.313203457 | 0.1432068193 | 1.12080972 | 0.2965693775 |
48 | 1004 | 2004 | 0.6423997951 | 0.5278268797 | 0.7072876073 | 0.6589443057 |
49 | 1004 | 2005 | 0.9635217649 | 0.4005510772 | 0.9749892218 | 0.5202739276 |
50 | 1004 | 2006 | 0.4716812564 | 0.3841759746 | 0.464058368 | 0.5456643099 |
51 | 1004 | 2007 | 0.7068131226 | 0.28087404 | 0.7993422835 | 0.258581943 |
52 | 1004 | 2008 | 0.6457680686 | -0.06650414458 | 0.7508479624 | -0.1089721836 |
53 | 1004 | 2009 | 0.6658950381 | 0.2086409122 | 0.5595556885 | 0.1000099829 |
54 | 1004 | 2010 | 0.7072176554 | 0.1594444478 | 0.6663677268 | 0.1597127754 |
55 | 1004 | 2011 | 1.483927749 | -0.02439788025 | 1.726887616 | 0.153322368 |
56 | 1004 | 2012 | 2.613505751 | 0.4434471714 | 2.220482844 | 0.5109720961 |
57 | 1004 | 2013 | 1.616208033 | 0.7840731211 | 1.377240743 | 0.9260548014 |
58 | 1004 | 2014 | 1.499959253 | 0.6981715788 | 1.450908258 | 0.7221964025 |
59 | 1004 | 2015 | 1.513748807 | 0.2737371079 | 1.349061799 | 0.3571976102 |
60 | 1004 | 2016 | 0.4651582513 | -0.9530575319 | 0.1958814874 | 0.4823268885 |
61 | 1004 | 2017 | 0.4320260276 | -0.8082543676 | 0.2605450664 | -0.2040429852 |
62 | 1004 | 2018 | 0.4000271281 | -0.7686614458 | 0.2381880095 | -0.4160766965 |
63 | 1004 | 2019 | 0.6570259033 | -0.6346789186 | 0.2628976758 | -0.546816245 |
64 | 1004 | 2020 | 0.2632526585 | -0.5060635526 | 0.4351717125 | 0.3986229076 |
65 | 1004 | 2021 | 0.4222281272 | -0.6423685238 | 0.6586317295 | -0.2722420909 |
66 | 1004 | 2022 | 0.3289174625 | -0.5831908579 | 0.4589277865 | -0.5588622803 |
67 | 1004 | 2023 | 0.4584855567 | -0.7369237484 | 0.4427858316 | -0.137588733 |
68 | 1004 | 2024 | 0.7768821919 | -0.3029326915 | 0.3472384883 | 0.3180197352 |
69 | 1004 | 2025 | 0.6261531909 | -0.1176215816 | 0.924436565 | -0.9315053852 |
70 | 1005 | 1975 | -0.3468094685 | 1.351364682 | -0.6224906899 | 0.5584993973 |
71 | 1005 | 1976 | -0.3805003929 | 1.373937946 | -0.3025665109 | 1.631316914 |
72 | 1005 | 1977 | -0.4032035867 | 1.349762203 | -0.4556310343 | 1.147105696 |
73 | 1005 | 1978 | -0.3758992239 | 1.369307174 | -0.7387678996 | 0.2104736624 |
74 | 1005 | 1979 | -0.4290873554 | 0.8991164893 | -0.9420634326 | 0.6225062888 |
75 | 1005 | 1980 | -0.3595490242 | 0.04535927958 | -0.8587402715 | 0.13747341 |
76 | 1005 | 1981 | 0.2935922764 | -0.4645168952 | -0.6312542082 | -0.159435174 |
77 | 1006 | 1981 | -0.5007707828 | 0.7835877014 | -0.08032099347 | 0.7360442085 |
78 | 1006 | 1982 | -0.3373585142 | 0.7172577793 | -0.3907829728 | 0.2953175786 |
79 | 1007 | 1979 | -0.2448073991 | 0.9498830522 | -0.02577767118 | 0.6214847325 |
80 | 1007 | 1980 | -0.7782967786 | 0.5259163478 | -0.09099580856 | 0.4984580597 |
81 | 1007 | 1981 | -0.1840444901 | 0.6316449927 | -0.1266783886 | 0.3419320191 |
82 | 1007 | 1982 | -0.7147652239 | 0.3571333555 | -0.2363797813 | 0.552523812 |
83 | 1007 | 1983 | -0.5400114755 | 0.6747315223 | -0.3963125151 | 0.1394924153 |
84 | 1007 | 1984 | -0.4141844367 | 0.4912431633 | -0.3665119624 | 0.7089709558 |
85 | 1008 | 1985 | -0.3913444196 | 1.449757665 | -0.479203504 | 0.9495865142 |
86 | 1008 | 1986 | -0.6275165169 | 1.028508193 | -0.3652467509 | 0.9065388437 |
87 | 1009 | 1982 | 0.5216523123 | 0.06434349566 | -0.2134540594 | 0.01437857318 |
88 | 1009 | 1983 | 0.3810410463 | -0.2131193669 | -0.1761017886 | 1.042311848 |
89 | 1009 | 1984 | 0.1327143927 | -0.3229730471 | -0.04820660615 | 0.1522658033 |
90 | 1009 | 1985 | 0.456655898 | -0.08325384077 | -0.1659962555 | 0.1984284149 |
91 | 1009 | 1986 | 0.07698704464 | -0.3774426574 | 0.173884179 | -0.3718954638 |
92 | 1009 | 1987 | 0.5938601857 | -0.1872249248 | 0.3271450736 | -0.5171060734 |
93 | 1009 | 1988 | 0.4427238704 | -0.5388741924 | -0.5259306172 | -0.3010985916 |
94 | 1009 | 1989 | 0.8565386862 | -0.5929904977 | -0.05251316669 | -0.3115748528 |
95 | 1009 | 1990 | 0.9894067705 | -0.6175726517 | 0.1414803048 | -0.1873358149 |
96 | 1009 | 1991 | 0.9404898388 | -0.5857421684 | -0.1687879275 | -0.238079127 |
97 | 1009 | 1992 | 0.8567923218 | -0.6557922761 | -0.1279738166 | -0.132768285 |
98 | 1009 | 1993 | 0.8630741379 | -0.6009874003 | 0.2158328273 | -0.4921175486 |
99 | 1009 | 1994 | 0.9402017419 | -0.673265184 | 1.072590999 | -0.2722442069 |
100 | 1010 | 1972 | 0.3178404435 | -0.4336359318 | 0.5802041117 | -0.6650332386 |