30 Year Financial Data of Galapagos NV (GLPG)

GLPG- NAS (USA) Also traded in: Austria, Belgium, Germany, Netherlands, UK, USA
Galapagos NV ADR

Currently 1/5

Business Predictability Rank: 1-Star
Back Testing Results:
Average gain of all 1-Star stocks: 1.1% per year.
% of Stocks that are in still loss if held for 10yrs: 45%.
Read more:
What is Predictability Rank?
Performances of real portfolio
Top Ranked Predictable Companies

$162.19

0(0%) Volume: 101,092 3:15AM EDT

Avg Vol (1m): 175,640

Warning! GuruFocus has detected 1 Severe Warning Sign with GLPG. Click here to check it out.

Market Cap : 10.05 B	Enterprise Value : 8.81 B	P/E (TTM) :	P/B : 7.06

RSS

Manual of Stocks™ Web APP

Manual of Stocks™

Sorry. Only PremiumPlus Member can access this feature.

Free Trial

Also traded in: Austria, Belgium, Germany, Netherlands, UK, USA

Annual Rates (per share)	10 yrs*	5 yrs*	12 months*
Revenue Growth (%)	-4.10	15.10	80.20
EBITDA Growth (%)	N/A	N/A	N/A
Operating Income Growth (%)	N/A	-2.80	N/A
EPS without NRI Growth (%)	N/A	N/A	N/A
Free Cash Flow Growth (%)	N/A	N/A	N/A
Book Value Growth (%)	19.30	36.80	20.70

*12-month growth rate is calculated with the quarterly per share revenue (EBITDA, FCF, earnings) of the last 12 months over the per share revenue (EBITDA, FCF, earnings) over the previous 12 months. 5-year and 10-year growth rates are calculated with least-square regression based on the 6-year and 11-year annual numbers. Please click Growth Rate Calculation Example (GuruFocus) to see how GuruFocus calculates Wal-Mart Stores Inc (WMT)'s revenue growth rate. You can apply the same method to get the growth rate you want.

Trendline:

Embed

Subscribe to see/download 30-Year Financial data in one page.

7-Day Free Trial

* All numbers are in millions except for per share data, ratios, and percentage data * All shares outstanding data and per share data are split adjusted * Empty lines (lines with only 0's) are hidden by default * Preliminary data is from the companies' press releases. 10-Q/K data is not available yet. Preliminary data is not used in the calculation of Ratios,Scores or Rankings * Financial Statement Template: Manufacturing / Mining / Transportation / Utility / Others * Cash Flow from Operations Template: Indirect Method * For latest financial page display change, please click GuruFocus 30-Y Financials Page Item Changes

30-Y Financial Download

API Excel Add-In Video Tutorial

Standard View
Add View

A+ A- Show empty lines Hide the embedded charts

Export Excel file Export CSV file PDF

Set Default Questions

Fiscal Period	Trend	Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	TTM	Jun18	Sep18	Dec18	Mar19	Jun19
Per Share Data	Annuals (USD $)View: $ % YOY																	Quarterly

Revenue per Share													1.21	2.99	3.04	6.31	6.21	1.12	2.09	2.23	0.68	1.21
EBITDA per Share													-3.55	1.39	-2.64	-0.51	-1.12	-0.31	0.35	0.31	-0.90	-0.88
EBIT per Share													-3.65	1.29	-2.74	-0.62	-1.27	-0.36	0.33	0.30	-0.96	-0.94
Earnings per Share (Diluted)													-3.62	1.20	-2.77	-0.64	-1.31	-0.49	0.33	0.34	-1.01	-0.97
EPS without NRI													-3.62	1.20	-2.77	-0.64	-1.31	-0.49	0.33	0.34	-1.01	-0.97
Owner Earnings per Share (TTM)													-4.36	6.56	-4.57	-3.46	-4.70	-4.90	-3.92	-3.46	-3.92	-4.70
Free Cash Flow per Share													-3.70	5.42	-3.70	-3.41	-4.39	-1.21	-0.13	-1.16	-1.55	-1.55
Operating Cash Flow per Share													-3.50	5.53	-3.52	-3.11	-4.00	-1.16	-0.08	-1.00	-1.48	-1.44
Dividends per Share													--	--	--	--	--	--	--	--	--	--
Book Value per Share													10.19	17.36	23.53	26.91	23.72	20.31	27.06	26.91	24.41	23.72
Tangible Book per Share													10.15	17.33	23.47	26.83	23.57	20.28	27.02	26.83	24.27	23.57
Total Debt per Share													0.00	0.00	--	--	0.53	--	--	--	0.52	0.53
Month End Stock Price													62.88	64.19	93.76	91.74	162.19	92.18	112.43	91.74	117.78	128.93

Ratios	AnnualsView: $ % YOY																	Quarterly
Fiscal Period		Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	TTM	Jun18	Sep18	Dec18	Mar19	Jun19

ROE %													-39.58	9.51	-13.71	-2.58	-5.76	-9.49	5.72	4.92	-16.23	-16.30
ROE % Adjusted to Book Value													-6.41	2.57	-3.44	-0.76	-0.83	-2.09	1.38	1.44	-3.36	-3.00
ROA %													-31.63	7.01	-10.28	-2.11	-4.69	-6.96	4.41	4.04	-13.66	-13.71
Return-on-Tangible-Equity													-39.84	9.53	-13.73	-2.59	-5.78	-9.51	5.73	4.93	-16.30	-16.40
Return-on-Tangible-Asset													-31.80	7.03	-10.29	-2.11	-4.70	-6.97	4.42	4.05	-13.71	-13.77
ROC (Joel Greenblatt) %													-948.90	383.22	-763.11	-140.39	-192.73	-361.12	329.64	276.54	-507.91	-363.11
ROIC %													-386.24	--	--	--	--	--	--	--	--	--
WACC %													1.68	0.34	10.24	12.65	8.67	10.35	9.81	12.65	10.61	8.56
Effective Interest Rate on Debt %													30.26	1,861.81	2,873.15	16,662.87	33.26	--	--	--	75.07	23.28

Gross Margin %													-227.88	-7.76	-71.93	-11.79	-18.66	-64.43	15.35	14.35	-151.75	-60.67
Operating Margin %													-226.09	-8.87	-70.66	-15.51	-25.66	-67.94	12.93	8.18	-161.12	-75.54
Net Margin %													-299.30	41.70	-91.04	-10.13	-22.07	-43.83	15.64	14.06	-147.23	-80.44
FCF Margin %													-306.49	181.14	-121.54	-54.07	-71.43	-108.03	-6.02	-52.15	-226.96	-128.21

Debt-to-Equity													--	--	--	--	0.02	--	--	--	0.02	0.02
Equity-to-Asset													0.83	0.70	0.79	0.84	0.84	0.74	0.80	0.84	0.84	0.84
Debt-to-Asset													--	--	--	--	0.02	--	--	--	0.02	0.02
Gross-Profit-to-Asset %													-24.08	-1.31	-8.12	-2.45	-3.96	-10.23	4.33	4.12	-14.08	-10.34

Asset Turnover													0.11	0.17	0.11	0.21	0.21	0.04	0.07	0.07	0.02	0.04
Dividend Payout Ratio													--	--	--	--	--	--	--	--	--	--

Days Sales Outstanding													98.30	47.30	97.41	25.79	66.04	62.02	35.59	17.51	74.53	83.44
Days Payable													81.92	81.62	78.72	76.91	89.34	77.24	91.71	68.14	76.65	83.36
Days Inventory													0.90	0.83	0.46	0.32	0.24	0.32	0.31	0.28	0.15	--
Cash Conversion Cycle													17.28	-33.49	19.15	-50.80	-23.06	-14.90	-55.81	-50.35	-1.97	0.08

Inventory Turnover													403.42	439.17	799.78	1,140.45	1,514.62	283.48	293.49	323.58	598.78	--
COGS-to-Revenue													3.28	1.08	1.72	1.12	1.19	1.64	0.85	0.86	2.52	1.61
Inventory-to-Revenue													0.01	0.00	0.00	0.00	0.00	0.01	0.00	0.00	0.00	--

Income Statement	Annual (USD $) View: $%/share% YOY																	Quarterly
Fiscal Period		Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	TTM	Jun18	Sep18	Dec18	Mar19	Jun19

Revenue													43.1	136.6	150.4	328.6	335.4	58.0	110.7	121.0	37.3	66.4
Cost of Goods Sold													141.3	147.2	258.6	367.3	398.0	95.4	93.7	103.7	94.0	106.6
Gross Profit													-98.2	-10.6	-108.2	-38.7	-62.6	-37.4	17.0	17.4	-56.7	-40.3
Gross Margin %													-227.88	-7.76	-71.93	-11.79	-18.66	-64.43	15.35	14.35	-151.75	-60.67

Selling, General, & Admin. Expense													22.1	24.8	32.2	45.3	59.4	10.6	12.4	14.7	12.4	19.9
Research & Development													--	--	--	--	--	--	--	--	--	--
Other Operating Expense													-22.9	-23.3	-34.1	-33.0	-35.9	-8.6	-9.7	-7.3	-8.9	-10.0
Operating Income													-97.4	-12.1	-106.3	-51.0	-86.1	-39.4	14.3	9.9	-60.2	-50.1
Operating Margin %													-226.09	-8.87	-70.66	-15.51	-25.66	-67.94	12.93	8.18	-161.12	-75.54

Interest Income													1.4	10.5	3.6	5.9	3.2	7.6	3.0	-6.2	7.9	-1.5
Interest Expense													-0.1	-1.8	-1.1	-0.9	-3.8	-6.5	-0.5	1.1	-2.6	-1.7
Net Interest Income													1.2	8.7	2.0	4.4	-1.3	14.1	2.4	-5.8	5.3	-3.2
Other Income (Expense)													-34.1	60.6	-32.4	13.3	13.3	0.0	-0.0	13.3	0.0	0.0
Other Income (Minority Interest)													--	--	--	--	--	--	--	--	--	--
Pre-Tax Income													-130.3	57.2	-136.7	-33.2	-74.0	-25.3	16.8	17.5	-54.9	-53.3
Tax Provision													1.3	-0.2	-0.2	-0.1	-0.0	-0.1	0.6	-0.4	-0.1	-0.1
Tax Rate %													1.02	0.43	-0.17	-0.17	-0.04	-0.35	-3.34	2.56	-0.14	-0.13
Net Income (Continuing Operations)													-129.0	57.0	-136.9	-33.3	-74.0	-25.4	17.3	17.0	-55.0	-53.4
Net Income (Discontinued Operations)													--	--	--	--	--	--	--	--	--	--
Net Income													-129.0	57.0	-136.9	-33.3	-74.0	-25.4	17.3	17.0	-55.0	-53.4
Net Margin %													-299.30	41.70	-91.04	-10.13	-22.07	-43.83	15.64	14.06	-147.23	-80.44

Preferred Dividends													--	--	--	--	--	--	--	--	--	--
EPS (Basic)													-3.62	1.24	-2.77	-0.64	-1.30	-0.49	0.34	0.34	-1.01	-0.97
EPS (Diluted)													-3.62	1.20	-2.77	-0.64	-1.31	-0.49	0.33	0.34	-1.01	-0.97
Shares Outstanding (Diluted Average)													35.7	45.7	49.5	52.1	54.9	51.8	53.0	54.2	54.7	54.9

Depreciation, Depletion and Amortization													3.7	4.4	5.1	5.8	8.0	2.9	1.3	0.3	3.1	3.3
EBITDA													-126.6	63.4	-130.5	-26.6	-62.2	-16.0	18.6	16.7	-49.1	-48.4

Balance Sheet	Annuals (USD $)View: $%/share% YOY																	Quarterly
Fiscal Period		Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	Latest Q.	Jun18	Sep18	Dec18	Mar19	Jun19

Cash And Cash Equivalents													370.7	1,026.6	1,362.4	1,468.5	1,297.1	1,246.2	1,567.9	1,468.5	1,381.8	1,297.1
Marketable Securities													--	--	--	--	--	--	--	--	--	--
Cash, Cash Equivalents, Marketable Securities													370.7	1,026.6	1,362.4	1,468.5	1,297.1	1,246.2	1,567.9	1,468.5	1,381.8	1,297.1
Accounts Receivable													11.6	17.7	40.1	23.2	60.7	39.4	43.2	23.2	30.5	60.7
Notes Receivable													--	--	--	--	--	--	--	--	--	--
Other Current Receivables													5.9	7.1	9.3	14.9	--	--	--	14.9	--	--
Total Receivables													17.5	24.8	49.5	38.1	60.7	39.4	43.2	38.1	30.5	60.7
Inventories, Raw Materials & Components													--	--	--	--	--	--	--	--	--	--
Inventories, Work In Process													--	--	--	--	--	--	--	--	--	--
Inventories, Inventories Adjustments													--	--	--	--	--	--	--	--	--	--
Inventories, Finished Goods													--	--	--	--	--	--	--	--	--	--
Inventories, Other													0.4	0.3	0.3	0.3	--	0.3	0.3	0.3	--	--
Total Inventories													0.4	0.3	0.3	0.3	--	0.3	0.3	0.3	--	--
Other Current Assets													19.4	10.8	5.2	4.8	7.9	8.3	11.0	4.8	10.6	7.9
Total Current Assets													407.9	1,062.5	1,417.3	1,511.8	1,365.7	1,294.3	1,622.4	1,511.8	1,422.9	1,365.7

Investments And Advances													--	--	--	--	--	--	--	--	--	--
Land And Improvements													--	--	--	--	--	--	--	--	--	--
Buildings And Improvements													--	--	--	--	--	--	--	--	--	--
Machinery, Furniture, Equipment													31.9	34.5	42.9	47.2	--	--	--	47.2	--	--
Construction In Progress													--	--	--	--	--	--	--	--	--	--
Other Gross PPE													5.7	5.2	7.0	11.2	57.8	20.9	21.1	11.2	56.0	57.8
Gross Property, Plant and Equipment													37.6	39.7	49.9	58.4	57.8	20.9	21.1	58.4	56.0	57.8
Accumulated Depreciation													-22.6	-23.9	-30.2	-32.1	--	--	--	-32.1	--	--
Property, Plant and Equipment													15.0	15.8	19.8	26.3	57.8	20.9	21.1	26.3	56.0	57.8
Intangible Assets													1.7	1.1	3.0	4.1	8.1	1.6	2.4	4.1	7.3	8.1
Goodwill													--	--	--	--	--	--	--	--	--	--
Other Long Term Assets													57.4	63.4	82.2	95.4	102.7	90.2	87.5	95.4	96.0	102.7
Total Assets													482.0	1,142.8	1,522.2	1,637.7	1,534.3	1,406.9	1,733.4	1,637.7	1,582.1	1,534.3

Accounts Payable													31.7	32.9	55.8	77.4	97.4	80.8	94.2	77.4	79.0	97.4
Total Tax Payable													2.8	1.1	1.0	1.3	1.2	1.0	1.0	1.3	1.3	1.2
Other Current Payables													0.0	--	--	--	0.0	--	--	--	0.0	0.0
Current Accrued Expense													0.5	0.7	1.4	1.0	--	1.0	1.0	1.0	--	--
Accounts Payable & Accrued Expense													35.1	34.7	58.2	79.8	98.6	82.8	96.2	79.8	80.3	98.6
Short-Term Debt													--	--	--	--	--	--	--	--	--	--
Short-Term Capital Lease Obligation													0.1	0.1	0.0	--	5.8	--	--	--	5.2	5.8
Short-Term Debt & Capital Lease Obligation													0.1	0.1	0.0	--	5.8	--	--	--	5.2	5.8
Current Deferred Revenue													43.4	74.7	145.0	170.4	108.8	205.3	217.8	170.4	139.9	108.8
Current Deferred Taxes Liabilities													--	--	--	--	--	--	--	--	--	--
DeferredTaxAndRevenue													43.4	74.7	145.0	170.4	108.8	205.3	217.8	170.4	139.9	108.8
Other Current Liabilities													0.4	0.1	--	0.0	-0.0	0.0	--	0.0	-0.0	-0.0
Total Current Liabilities													78.9	109.5	203.2	250.2	213.2	288.1	314.0	250.2	225.4	213.2

Long-Term Debt													--	--	--	--	--	--	--	--	--	--
Long-Term Capital Lease Obligation													0.1	0.0	--	--	23.1	--	--	--	23.1	23.1
Long-Term Debt & Capital Lease Obligation													0.1	0.0	--	--	23.1	--	--	--	23.1	23.1
Debt-to-Equity													--	--	--	--	0.02	--	--	--	0.02	0.02
PensionAndRetirementBenefit													2.9	3.7	4.2	4.3	4.5	4.4	4.5	4.3	4.4	4.5
NonCurrent Deferred Liabilities													--	226.6	115.2	--	--	78.8	26.9	--	--	--
Other Long-Term Liabilities													2.6	2.7	2.0	1.8	1.6	1.1	1.5	1.8	0.8	1.6
Total Liabilities													84.4	342.4	324.6	256.3	242.4	372.3	346.9	256.3	253.6	242.4

Common Stock													202.0	236.2	276.2	269.1	269.5	275.2	275.0	269.1	268.2	269.5
Preferred Stock													--	--	--	--	--	--	--	--	--	--
Retained Earnings													-193.2	-118.4	-250.2	-338.8	-425.4	-401.6	-375.1	-338.8	-384.2	-425.4
Accumulated other comprehensive income (loss)													-0.5	-2.2	-3.6	-2.6	-2.5	-2.6	-2.6	-2.6	-2.3	-2.5
Additional Paid-In Capital													389.3	684.7	1,175.2	1,453.7	1,450.5	1,163.7	1,489.2	1,453.7	1,446.8	1,450.5
Treasury Stock													--	--	--	--	--	--	--	--	--	--
Other Stockholders Equity													0.0	0.0	-0.0	0.0	-0.0	0.0	--	0.0	0.0	-0.0
Total Stockholders Equity													397.6	800.3	1,197.6	1,381.4	1,291.9	1,034.6	1,386.5	1,381.4	1,328.5	1,291.9
Minority Interest													--	--	--	--	--	--	--	--	--	--
Total Equity													397.6	800.3	1,197.6	1,381.4	1,291.9	1,034.6	1,386.5	1,381.4	1,328.5	1,291.9
Equity-to-Asset													0.83	0.70	0.79	0.84	0.84	0.74	0.80	0.84	0.84	0.84

Cashflow Statement	Annuals (USD $)View: $%/share% YOY																	Quarterly
Fiscal Period		Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	TTM	Jun18	Sep18	Dec18	Mar19	Jun19

Net Income													-129.0	57.0	-136.9	-33.3	-74.0	-25.4	17.3	17.0	-55.0	-53.4
Net Foreign Currency Exchange Gain													-0.4	-5.8	32.5	-11.4	-7.0	-12.8	5.7	-11.0	-5.4	3.8
Net Income From Continuing Operations													-129.0	57.0	-136.9	-33.3	-74.0	-25.4	17.3	17.0	-55.0	-53.4
Depreciation, Depletion and Amortization													3.7	4.4	5.1	5.8	8.0	2.9	1.3	0.3	3.1	3.3
Change In Receivables													-7.9	-13.7	-32.7	-0.1	-33.6	-18.8	-0.1	3.7	-1.4	-35.8
Change In Inventory													-0.0	0.0	0.0	0.0	-0.0	0.0	-0.0	0.0	0.0	0.0
Change In Prepaid Assets													--	--	--	--	--	--	--	--	--	--
Change In Payables And Accrued Expense													-43.0	2.2	17.5	22.7	17.9	16.1	10.5	-11.8	-1.2	20.4
Change In Working Capital													-37.1	248.1	-93.0	-151.6	-183.2	-32.4	-28.5	-76.5	-31.8	-46.4
Change In DeferredTax													-1.3	0.2	0.2	0.1	0.0	0.1	-0.6	0.4	0.1	0.1
Stock Based Compensation													5.5	11.6	19.6	30.4	37.6	7.7	8.7	10.0	6.8	12.1
Asset Impairment Charge													--	--	--	1.2	--	--	--	--	--	--
Cash Flow from Discontinued Operations													--	--	--	--	--	--	--	--	--	--
Cash Flow from Others													33.4	-68.8	31.0	-14.7	-6.9	-13.0	-2.5	-5.4	-4.2	5.1
Cash Flow from Operations													-124.8	252.5	-174.0	-162.1	-218.5	-60.1	-4.2	-54.1	-81.0	-79.1

Purchase Of Property, Plant, Equipment													-6.6	-4.7	-6.3	-11.8	-14.1	-2.1	-1.5	-7.0	-2.4	-3.3
Sale Of Property, Plant, Equipment													--	--	0.0	--	0.0	--	--	--	0.0	0.0
Purchase Of Business													--	--	--	--	--	--	--	--	--	--
Sale Of Business													--	--	--	--	--	--	--	--	--	--
Purchase Of Investment													--	-2.9	--	-5.2	-0.2	--	--	--	-0.2	--
Sale Of Investment													--	--	0.4	2.7	0.1	--	--	--	0.1	--
Net Intangibles Purchase And Sale													-0.5	-0.3	-2.5	-3.8	-7.0	-0.4	-0.9	-2.0	-1.4	-2.6
Cash From Discontinued Investing Activities													--	--	--	--	--	--	--	--	--	--
Cash From Other Investing Activities													2.5	0.2	7.7	--	-2.5	-0.0	0.2	-2.7	--	0.0
Cash Flow from Investing													-4.7	-7.7	-0.6	-18.1	-23.7	-2.6	-2.3	-11.7	-3.8	-5.9

Issuance of Stock													303.6	413.6	430.7	337.0	--	--	--	--	--	--
Repurchase of Stock													--	--	--	--	--	--	--	--	--	--
Net Issuance of Preferred Stock													--	--	--	--	--	--	--	--	--	--
Net Issuance of Debt													-0.0	-0.1	-0.1	-0.0	-2.4	0.0	0.0	0.0	-1.4	-1.0
Cash Flow for Dividends													--	--	--	--	--	--	--	--	--	--
Other Financing													-7.9	4.1	-12.4	-9.5	338.6	1.6	328.1	1.6	3.9	4.9
Cash Flow from Financing													295.6	417.7	418.2	327.5	336.1	1.6	328.1	1.6	2.5	3.9

Effect of Exchange Rate Changes													0.1	5.1	-32.9	11.5	7.6	12.7	1.5	4.0	5.6	-3.5
Net Change in Cash													166.1	662.6	243.5	147.3	93.9	-61.1	321.6	-64.1	-82.3	-81.2
Capital Expenditure													-7.3	-5.1	-8.8	-15.6	-21.1	-2.6	-2.4	-9.0	-3.7	-5.9
Free Cash Flow													-132.1	247.5	-182.8	-177.7	-239.6	-62.7	-6.7	-63.1	-84.7	-85.1

Valuation Ratios	AnnualsView: $ % YOY																	Quarterly
Fiscal Period		Dec04	Dec05	Dec06	Dec07	Dec08	Dec09	Dec10	Dec11	Dec12	Dec13	Dec14	Dec15	Dec16	Dec17	Dec18	Current	Jun18	Sep18	Dec18	Mar19	Jun19


PE Ratio
Price-to-Owner-Earnings
PB Ratio
Price-to-Tangible-Book
Price-to-Free-Cash-Flow
Price-to-Operating-Cash-Flow
PS Ratio
PEG Ratio
EV-to-Revenue
EV-to-EBITDA
EV-to-EBIT
Earnings Yield (Joel Greenblatt) %
Forward Rate of Return (Yacktman) %
Shiller PE Ratio

Value Screens

Downloads | Tools

Strategies

Market Valuation

By Country

Articles

Submit Articles

Categories

Subscribe to see/download 30-Year Financial data in one page.