Galapagos N.V. (GLPG) quarterly balance sheet — complete assets, liabilities & equity history
| Total Current Assets | 3.06B | 3.08B | 3.72B | 3.26B | 3.47B | 3.34B | 3.56B | 3.67B | 3.79B | 3.86B | 3.96B | 4.03B |
| Cash & Short-Term Investments | 2.98B | 3B | 3.58B | 3.09B | 3.3B | 3.12B | 3.34B | 3.43B | 3.56B | 3.68B | 3.81B | 3.87B |
| Cash Only | 66.81M | 87.87M | 75.74M | 71.67M | 108.07M | 64.24M | 55.52M | 72.33M | 73.37M | 166.8M | 159.38M | 98.02M |
| Short-Term Investments | 2.92B | 2.91B | 3.51B | 3.02B | 3.19B | 3.05B | 3.28B | 3.36B | 3.48B | 3.52B | 3.65B | 3.78B |
| Accounts Receivable | 54.03M | 53.2M | 91.26M | 87.84M | 83.49M | 88.09M | 87.23M | 101.54M | 92.05M | 65.66M | 73.04M | 67.58M |
| Days Sales Outstanding | 744.59 | 7.38 | 115.78 | 119.4 | 102.98 | 106.82 | 145.09 | 113.11 | 114.93 | -30.51 | 53.89 | 41.01 |
| Inventory | 17.69M | 22.49M | 26.96M | 33.79M | 38.52M | 51.19M | 65.56M | 63.36M | 80.56M | 73.98M | 55.6M | 48.87M |
| Days Inventory Outstanding | 376.82 | 5K | 257.69 | 699.13 | 294.04 | 47.56 | 312.14K | 395.51 | 2.76K | - | 843.12 | 1.07K |
| Other Current Assets | 6.77M | 5.61M | 13.26M | 42.17M | 53.05M | 82.49M | 67.86M | 69.86M | 55.93M | 36.72M | 15.73M | 40.77M |
| Total Non-Current Assets | 311.69M | 327.06M | 411.12M | 562.91M | 549.59M | 796.27M | 612.77M | 625.18M | 574.91M | 495.81M | 495.24M | 490.19M |
| Property, Plant & Equipment | 76.95M | 80.66M | 124.1M | 109.69M | 113.22M | 122.9M | 132.23M | 128.49M | 125.06M | 126.32M | 136.8M | 134.73M |
| Fixed Asset Turnover | 0.08x | 8.80x | 0.61x | 0.59x | 0.64x | 0.59x | 0.46x | 0.61x | 0.50x | -1.59x | 0.88x | 1.11x |
| Goodwill | 0 | 0 | 0 | 69.15M | 69.71M | 70.01M | 69.47M | 69.79M | 69.72M | 69.56M | 69.86M | 69.68M |
| Intangible Assets | 746K | 848K | 8.72M | 147.43M | 156.25M | 164.86M | 173.43M | 182.55M | 126M | 127.91M | 132.31M | 136.47M |
| Long-Term Investments | 47.93M | 46.81M | 274.39M | 46.93M | 50.85M | 253.12M | 49.13M | 51.38M | 0 | 13.57M | 0 | 0 |
| Other Non-Current Assets | 185.9M | 198.55M | 2.93M | 188.85M | 158.07M | 183.9M | 187.37M | 191.82M | 253.03M | 157.32M | 155.03M | 148.14M |
| Total Assets | 3.37B | 3.41B | 4.13B | 3.82B | 4.02B | 4.14B | 4.17B | 4.29B | 4.36B | 4.36B | 4.45B | 4.52B |
| Asset Turnover | 0.00x | 0.24x | 0.02x | 0.02x | 0.02x | 0.02x | 0.01x | 0.02x | 0.01x | -0.05x | 0.03x | 0.03x |
| Asset Growth % | -16.15% | -17.63% | -1.1% | -11% | -7.78% | -5.09% | -6.27% | -5.13% | -5.85% | -7.96% | -10.47% | -10.27% |
| Total Current Liabilities | 100.42M | 152.86M | 430.71M | 402.95M | 437.04M | 335.08M | 351.23M | 364.78M | 382.21M | 428.22M | 444.04M | 475.07M |
| Accounts Payable | 95.77M | 32.62M | 118.24M | 133.18M | 168.94M | 97.78M | 115.86M | 128.31M | 145.55M | 134.65M | 121.13M | 131.07M |
| Days Payables Outstanding | 1.2K | 15.25K | 1.07K | 2.92K | 874.25 | 87.02 | 591.15K | 752.6 | 5K | - | 2.04K | 3.06K |
| Short-Term Debt | 0 | 0 | 2.04M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Deferred Revenue (Current) | 32K | 32K | 270.39M | 230.24M | 230.63M | 232.48M | 230.93M | 232.21M | 232.46M | 256.27M | 315.46M | 330.63M |
| Other Current Liabilities | 2.13M | 117.5M | 39.62M | 36.87M | 34.2M | 5K | 0 | 0 | 0 | 32.04M | 0 | 0 |
| Current Ratio | 30.48x | 20.15x | 8.63x | 8.08x | 7.95x | 9.97x | 10.13x | 10.05x | 9.91x | 9.02x | 8.91x | 8.49x |
| Quick Ratio | 30.30x | 20.00x | 8.56x | 7.99x | 7.86x | 9.81x | 9.95x | 9.87x | 9.70x | 8.84x | 8.78x | 8.38x |
| Cash Conversion Cycle | -82.47 | -10.24K | -692.87 | -2.1K | -477.23 | 67.36 | -278.86K | -243.98 | -2.13K | - | -1.14K | -1.95K |
| Total Non-Current Liabilities | 18.64M | 17.79M | 820.61M | 771.45M | 837.01M | 903.7M | 958.4M | 1.02B | 1.08B | 1.13B | 1.39B | 1.46B |
| Long-Term Debt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Lease Obligations | 4.85M | 5.19M | 6.77M | 6.05M | 7.79M | 8.24M | 7.24M | 6.75M | 3.84M | 4.94M | 8.47M | 9.21M |
| Deferred Tax Liabilities | 0 | 0 | 0 | 17.88M | 18.72M | 20.66M | 20.97M | 21.84M | 22.73M | 23.61M | 25.32M | 26.31M |
| Other Non-Current Liabilities | 13.79M | 12.6M | 30.92M | 23.69M | 29.15M | 35.92M | 33.2M | 32.09M | 45.16M | 33.86M | 33.86M | 31.74M |
| Total Liabilities | 119.06M | 170.65M | 1.25B | 1.17B | 1.27B | 1.24B | 1.31B | 1.38B | 1.47B | 1.56B | 1.83B | 1.94B |
| Total Debt | 6.43M | 6.92M | 8.81M | 8.44M | 10.86M | 11.72M | 11.46M | 10.87M | 7.98M | 9.6M | 14.15M | 15.41M |
| Net Debt | -60.37M | -80.95M | -66.92M | -63.23M | -97.21M | -52.52M | -44.06M | -61.45M | -65.39M | -157.21M | -145.23M | -82.61M |
| Debt / Equity | 0.00x | 0.00x | 0.00x | 0.00x | 0.00x | 0.00x | 0.00x | 0.00x | 0.00x | 0.00x | 0.01x | 0.01x |
| Debt / EBITDA | - | 0.01x | - | - | - | - | - | 0.18x | 0.34x | - | 0.47x | 0.91x |
| Net Debt / EBITDA | - | -0.14x | - | - | - | - | - | -1.02x | -2.82x | - | -4.87x | -4.87x |
| Interest Coverage | - | - | -8.42x | - | -203.47x | - | -555.49x | 211.49x | 91.30x | - | 104.24x | 21.69x |
| Total Equity | 3.25B | 3.24B | 2.88B | 2.64B | 2.75B | 2.9B | 2.86B | 2.91B | 2.9B | 2.8B | 2.62B | 2.58B |
| Equity Growth % | 18.39% | 11.7% | 0.44% | -9.16% | -5.08% | 3.63% | 9.19% | 12.63% | 12.88% | 10.67% | -2.56% | -2.38% |
| Book Value per Share | 49.39 | 49.11 | 43.64 | 40.16 | 41.74 | 43.34 | 43.41 | 44.16 | 43.93 | 42.35 | 39.78 | 39.21 |
| Total Shareholders' Equity | 3.25B | 3.24B | 2.88B | 2.64B | 2.75B | 2.9B | 2.86B | 2.91B | 2.9B | 2.8B | 2.62B | 2.58B |
| Common Stock | 293.94M | 293.94M | 345.38M | 293.94M | 293.94M | 293.94M | 293.94M | 293.94M | 293.94M | 293.94M | 293.94M | 293.94M |
| Retained Earnings | 228.33M | 210.58M | -678.84M | -380.8M | -280.81M | -134.31M | -164.45M | -118.85M | -133.08M | -228.27M | -403.24M | -440.79M |
| Treasury Stock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accumulated OCI | -5.89M | -5.64M | -7.32M | -6.32M | -2.22M | 314K | -3.91M | -1.78M | -2.84M | -7.09M | -6.13M | -6.19M |
| Minority Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |