Liberty TripAdvisor Holdings, Inc. Financial Ratios — LTRPA

Profitability (USD)

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
Return on Common Equity (%)	- -	198.79	-0.71	-2.76	-6.75	3.6	-100.38	-38.67	-17.89	- -	- -	- -	- -	- -
Return on Assets (%)	- -	27.29	-0.1	-0.3	-0.55	0.29	-6.22	-1.2	-0.44	-5.4	4.23	0.67	-6.95	-5.52
Return on Capital (%)	- -	34.32	- -	-0.87	- -	- -	- -	-3	- -	- -	- -	1.54	- -	- -
Return on Invested Capital (%)	- -	-0.44	- -	0.24	- -	- -	- -	-0.55	- -	- -	- -	1.34	- -	- -
Gross Margin (%)	29.03	33.33	77.08	77.88	77.96	75.91	79.03	77.65	75.19	54.47	68.29	94.77	93.34	92.86
EBITDA Margin (%)	1.94	0.61	29.11	27.69	18.21	15.99	13.96	17.83	19.17	-28.64	-3.88	12.4	12.42	9.92
Operating Margin (%)	- -	-9.09	-1.35	5.27	1.09	1.5	0.38	7.93	8.33	-56.46	-20.51	5.9	7.55	5.29
Incremental Operating Margin (%)	- -	- -	- -	28.47	-22.46	-18.18	-45.95	265.22	-3.64	- -	- -	46.27	15.88	-80.85
Pretax Margin (%)	0.65	669.09	-2.71	3.31	0.26	3	-115.36	2.97	-8.46	-167.88	-0.55	6.23	-54.08	-33.35
Profit Margin (%)	7.74	595.76	-0.68	-1.66	-2.56	1.37	-25.3	-3.96	-1.41	-39.4	19.84	2.01	-15.94	-9.7
Net Income to Common Margin (%)	7.74	595.76	-0.68	-1.66	-2.56	1.37	-25.3	-3.96	-1.41	-39.4	19.84	2.01	-15.94	-9.7
Effective Tax Rate (%)	- -	11.23	- -	79.55	- -	- -	- -	118.75	- -	- -	- -	50.54	- -	- -
Dvd Payout Ratio (%)	- -	3.89	- -	870	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Sustainable Growth Rate (%)	- -	191.05	-0.71	21.24	-6.75	3.6	-100.38	-38.67	-17.89	- -	- -	- -	- -	- -

Credit (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
Total Debt	- -	422	399	740	621	635	711	487	353	491	1,102	1,074	1,127	1,160
ST Debt	- -	79	99	78	1	80	7	220	- -	- -	- -	- -	- -	329
LT Debt	- -	343	300	662	620	555	704	267	353	491	1,102	1,074	1,127	831
Total Debt/EBITDA	- -	422	1.33	2.01	2.18	2.59	3.25	1.69	1.18	-2.84	-31.49	5.81	5.08	6.37
Net Debt/EBITDA	- -	53	0.15	0.63	-0.08	-0.08	0.07	-0.64	0.04	-0.39	-9.77	0.11	0.17	0.47
Total Debt/EBIT	- -	-28.13	-28.5	10.57	36.53	27.61	118.5	3.8	2.72	-1.44	-5.96	12.2	8.35	11.96
Net Debt/EBIT	- -	-3.53	-3.21	3.3	-1.35	-0.83	2.67	-1.45	0.09	-0.2	-1.85	0.24	0.27	0.88
EBITDA to Interest Expense	- -	1	25.08	28.31	10.18	9.8	8.76	11.08	13.59	-4.22	-0.58	2.85	3.31	2.56
EBITDA-CapEx/Interest Expense	- -	-5	20.08	21.38	6.18	6.88	6.16	8.73	9.82	-5.56	-0.58	2.85	3.31	2.56
EBIT to Interest Expense	- -	-15	-1.17	5.38	0.61	0.92	0.24	4.92	5.91	-8.32	-3.08	1.35	2.01	1.37
Interest Expense	- -	1	12	13	28	25	25	26	22	41	60	65	67	71
Common Equity/Total Assets	- -	13.73	13.85	8.32	7.87	8.16	3.59	2.57	2.37	-6.78	-10.69	-9.44	-20.31	-31.18
Long-Term Debt/Equity (%)	- -	6.1	5.38	12.38	11.41	10.23	18.76	7.15	10.69	21.28	51.81	47.48	91.48	124.4
Long-Term Debt/Capital (%)	- -	5.96	5.21	11.41	10.65	9.49	16.62	6.64	10.24	19.15	37.2	35.33	54.87	54.64
Long-Term Debt/Total Assets (%)	- -	4.76	4.23	8.99	8.51	7.62	12.84	5.11	7.47	12.02	25.18	23.16	31.66	28.75
Total Debt/Equity (%)	- -	7.51	7.15	13.84	11.42	11.71	18.94	13.04	10.69	21.28	51.81	47.48	91.48	173.65
Total Debt/Capital (%)	- -	7.34	6.93	12.75	10.67	10.85	16.78	12.11	10.24	19.15	37.2	35.33	54.87	76.27
Total Debt/Total Assets (%)	- -	5.86	5.63	10.05	8.52	8.72	12.96	9.32	7.47	12.02	25.18	23.16	31.66	40.14
Net Debt to Equity	- -	0.94	0.81	4.32	-0.42	-0.35	0.43	-4.95	0.36	2.95	16.08	0.93	3	12.72
Net Debt/Capital (%)	- -	0.98	0.83	4.36	-0.44	-0.37	0.45	-5.52	0.39	3.18	15.53	1.06	3.84	19.06
EBITDA	3	1	301	368	285	245	219	288	299	-173	-35	185	222	182
EBITDA-CapEx	-3	-5	241	278	173	172	154	227	216	-228	-35	185	222	182
Operating Income (Loss)	- -	-15	-14	70	17	23	6	128	130	-341	-185	88	135	97

Liquidity (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
Cash Ratio	- -	2.32	1.56	1.56	2.16	1.77	1.96	1.1	0.78	1.75	2.13	1.97	1.89	0.88
Current Ratio	- -	3.08	2.07	2.05	2.83	2.32	2.81	1.52	1.27	2.39	2.74	2.44	2.3	1.08
Quick Ratio	- -	2.84	1.95	1.95	2.72	2.21	2.58	1.44	1.21	2.3	2.67	2.36	2.23	1.04
CFO/Avg Current Liab	- -	-0.18	1.29	1.09	1.09	0.8	0.54	0.81	0.74	-0.63	0.32	0.88	0.41	0.15
Common Equity/Total Assets	- -	13.73	13.85	8.32	7.87	8.16	3.59	2.57	2.37	-6.78	-10.69	-9.44	-20.31	-31.18
Long-Term Debt/Equity (%)	- -	6.1	5.38	12.38	11.41	10.23	18.76	7.15	10.69	21.28	51.81	47.48	91.48	124.4
Long-Term Debt/Capital (%)	- -	5.96	5.21	11.41	10.65	9.49	16.62	6.64	10.24	19.15	37.2	35.33	54.87	54.64
Long-Term Debt/Total Assets (%)	- -	4.76	4.23	8.99	8.51	7.62	12.84	5.11	7.47	12.02	25.18	23.16	31.66	28.75
Total Debt/Equity (%)	- -	7.51	7.15	13.84	11.42	11.71	18.94	13.04	10.69	21.28	51.81	47.48	91.48	173.65
Total Debt/Capital (%)	- -	7.34	6.93	12.75	10.67	10.85	16.78	12.11	10.24	19.15	37.2	35.33	54.87	76.27
Total Debt/Total Assets (%)	- -	5.86	5.63	10.05	8.52	8.72	12.96	9.32	7.47	12.02	25.18	23.16	31.66	40.14
CFO/Total Liabilities	- -	-1.2	22.28	19.07	21.15	16.2	12.65	26.88	27.44	-12.09	4.31	16.41	9.71	5.9
CFO/CapEx	1.83	-3.17	5.6	4.28	3.49	4.12	3.37	6.56	4.71	-3.91	- -	- -	- -	- -
Altman's Z-Score	- -	2.59	3.11	3.46	3.41	2.74	2.17	2.64	2.66	-0.45	0.34	1.32	1.4	0.66

Working Capital (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
Accounts Receivable Turnover	- -	3.88	9.8	9.29	9.02	7.92	7.04	6.84	7.19	3.73	6.31	8.04	8.96	8.95
Days Sales Outstanding	- -	94.02	37.24	39.27	40.46	46.1	51.88	53.34	50.77	97.9	57.87	45.38	40.73	40.78
Inventory Turnover	- -	8.15	12.15	24.5	57.5	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	44.8	30.03	14.9	6.35	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	9.79	6.34	3.68	2.79	6.1	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover Days	- -	37.3	57.55	99.32	130.98	59.84	- -	- -	- -	- -	- -	- -	- -	- -
Cash Conversion Cycle	- -	101.51	9.73	-45.15	-84.17	-13.74	51.88	53.34	50.77	97.9	57.87	45.38	40.73	40.78
Inventory to Cash Days	- -	49.22	7.21	24.38	34.12	46.1	51.88	53.34	50.77	97.9	57.87	45.38	40.73	40.78
Inventories	- -	27	12	12	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	27	12	12	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
Market Capitalization	- -	- -	- -	1,991	2,276	1,129	707	1,176	551	326	163	51	65	- -
- Cash & Cash Equivalents	- -	369	354	509	644	654	695	672	341	423	760	1,053	1,090	1,075
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	4,340	4,373	4,450	4,628	4,621	3,329	3,400	2,981	2,350	2,328	2,404	1,650	1,262
+ Total Debt	- -	422	399	740	621	635	711	487	353	491	1,102	1,074	1,127	1,160
Enterprise Value	- -	4,274	4,287	6,564	6,834	5,613	4,017	4,391	3,544	2,744	2,833	2,476	1,752	1,347
Total Capital	- -	5,751	5,754	5,803	5,822	5,850	4,237	4,021	3,446	2,564	2,962	3,040	2,054	1,521
Total Debt/Capital (%)	- -	7.34	6.93	12.75	10.67	10.85	16.78	12.11	10.24	19.15	37.2	35.33	54.87	76.27
Total Debt / EV	- -	0.1	0.09	0.11	0.09	0.11	0.18	0.11	0.1	0.18	0.39	0.43	0.64	0.86
EV/Sales	- -	25.9	4.15	4.94	4.37	3.66	2.56	2.72	2.27	4.54	3.14	1.66	0.98	0.73
EV/EBITDA	- -	4,274	14.24	17.84	23.98	22.91	18.34	15.25	11.85	- -	- -	13.38	7.89	7.4
EV/EBIT	- -	- -	- -	93.77	401.97	244.03	669.54	34.3	27.26	- -	- -	28.14	12.97	13.89
EV/Cash Flow to Firm	- -	- -	13.21	16.93	13.97	17.19	16.68	11.11	8.64	- -	- -	5.87	5.9	6.49
EV/Free Cash Flow to Firm	- -	- -	11.15	13.74	11.37	14.05	13.14	9.63	7.18	- -	- -	5.87	5.9	6.49
Diluted Market Cap	- -	- -	- -	1,991	2,276	1,129	707	1,176	551	330	167	52	66	- -
Diluted Enterprise Value	- -	4,393	4,418	6,672	6,880	5,731	4,052	4,391	3,544	2,748	2,837	2,477	1,753	1,347
EV per Share	- -	57.99	58.17	88.7	91.11	74.84	53.56	59.34	47.26	36.58	37.77	32.58	23.05	- -
TTM Sales	155	165	1,034	1,329	1,565	1,532	1,569	1,615	1,560	604	902	1,492	1,788	1,835
TTM EBITDA	3	1	301	368	285	245	219	288	299	-173	-35	185	222	182
TTM Operating Income	- -	-15	-14	70	17	23	6	128	130	-341	-185	88	135	97
TTM Cash Flow to Firm	11	-18	324	388	489	327	241	395	410	-180	-359	422	297	208
TTM Free Cash Flow to Firm	17	-12	384	478	601	400	306	456	493	-125	-359	422	297	208

Multiples (USD)

API Chat

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
Price/Free Cash Flow	- -	- -	- -	4.19	4.52	3.02	2.49	2.55	1.16	-2.06	1.72	0.13	0.29	- -
EV/EBIT	- -	- -	- -	93.77	401.97	244.03	669.54	34.3	27.26	- -	- -	28.14	12.97	13.89
Enterprise Value	- -	4,274	4,287	6,564	6,834	5,613	4,017	4,391	3,544	2,744	2,833	2,476	1,752	1,347
Low Price	- -	- -	- -	23.91	22.09	14.83	7.9	8.45	6.01	0.86	2.01	0.57	0.15	0.21
EV/Sales	- -	25.9	4.15	4.94	4.37	3.66	2.56	2.72	2.27	4.54	3.14	1.66	0.98	0.73
EV/EBITDA	- -	4,274	14.24	17.84	23.98	22.91	18.34	15.25	11.85	- -	- -	13.38	7.89	7.4
Price/Earnings	- -	- -	- -	- -	- -	53.75	- -	- -	- -	- -	0.91	1.7	- -	- -
Price/Earnings Average	- -	- -	- -	-100.01	-54.55	75.22	-2.43	-15.98	-40.18	-0.97	1.75	3.41	-0.19	- -
Price/Earnings High	- -	- -	- -	-129.13	-65.81	106.64	-3.54	-23.85	-61.02	-2.45	3.24	6.28	-0.45	- -
Price/Earnings Low	- -	- -	- -	-80.42	-41.42	52.96	-1.49	-9.77	-20.49	-0.27	0.84	1.44	-0.04	- -
Price/Book Value	- -	- -	- -	3.25	3.97	1.9	3.59	8.78	4.92	-1.18	-0.35	-0.12	-0.09	- -
Price/Book Value Average	- -	- -	- -	3.59	3.81	2.66	4.89	7.63	7.89	-0.84	-0.67	-0.23	-0.08	- -
Price/Book Value High	- -	- -	- -	4.63	4.59	3.77	7.14	11.39	11.99	-2.1	-1.24	-0.43	-0.18	- -
Price/Book Value Low	- -	- -	- -	2.89	2.89	1.87	3.01	4.67	4.02	-0.23	-0.32	-0.1	-0.02	- -
Price/Tangible Book Value	- -	- -	- -	-1.98	-3.34	-2.09	-2.04	-4.14	-1.14	-0.38	-0.17	-0.07	-0.08	- -
Price/Tangible Book Value Average	- -	- -	- -	-2.19	-3.2	-2.93	-2.79	-3.6	-1.83	-0.27	-0.33	-0.13	-0.07	- -
Price/Tangible Book Value High	- -	- -	- -	-2.83	-3.87	-4.15	-4.06	-5.38	-2.78	-0.67	-0.61	-0.24	-0.16	- -
Price/Tangible Book Value Low	- -	- -	- -	-1.76	-2.43	-2.06	-1.71	-2.2	-0.93	-0.07	-0.16	-0.06	-0.01	- -
Price/Sales	- -	- -	- -	1.5	1.45	0.74	0.45	0.73	0.35	0.54	0.18	0.03	0.04	- -
Price/Sales Average	- -	- -	- -	1.66	1.39	1.03	0.61	0.63	0.57	0.38	0.35	0.07	0.03	- -
Price/Sales High	- -	- -	- -	2.14	1.68	1.46	0.9	0.95	0.86	0.96	0.64	0.13	0.07	- -
Price/Sales Low	- -	- -	- -	1.33	1.06	0.73	0.38	0.39	0.29	0.11	0.17	0.03	0.01	- -
Price/Cash Flow	- -	- -	- -	5.17	5.82	3.75	3.23	2.94	1.41	-1.51	1.68	0.13	0.29	- -
Price/Cash Flow Average	- -	- -	- -	5.71	5.58	5.25	4.4	2.56	2.26	-1.08	3.23	0.26	0.24	- -
Price/Cash Flow High	- -	- -	- -	7.38	6.73	7.44	6.42	3.82	3.43	-2.71	5.98	0.48	0.56	- -
Price/Cash Flow Low	- -	- -	- -	4.6	4.24	3.7	2.71	1.56	1.15	-0.3	1.55	0.11	0.05	- -
Price/Free Cash Flow Average	- -	- -	- -	4.63	4.34	4.22	3.39	2.22	1.86	-1.47	3.32	0.27	0.25	- -
Price/Free Cash Flow High	- -	- -	- -	5.98	5.23	5.99	4.95	3.31	2.83	-3.69	6.14	0.49	0.58	- -
Price/Free Cash Flow Low	- -	- -	- -	3.72	3.29	2.97	2.09	1.36	0.95	-0.41	1.6	0.11	0.05	- -
EV/Sales Average	- -	26.62	4.27	5.18	4.34	4.03	2.75	2.62	2.49	4.39	3.31	1.69	0.97	0.73
EV/Sales High	- -	26.62	4.27	5.66	4.62	4.47	3.03	2.94	2.78	4.97	3.6	1.75	1.01	0.73
EV/Sales Low	- -	26.62	4.27	4.85	4	3.73	2.51	2.38	2.21	4.11	3.13	1.65	0.95	0.73
EV/EBITDA Average	- -	4,393	14.68	18.7	23.81	25.23	19.67	14.71	12.97	-15.32	-85.25	13.66	7.85	7.4
EV/EBITDA High	- -	4,393	14.68	20.44	25.39	27.92	21.7	16.46	14.5	-17.34	-92.87	14.13	8.17	7.4
EV/EBITDA Low	- -	4,393	14.68	17.53	21.97	23.32	17.98	13.33	11.52	-14.35	-80.59	13.34	7.65	7.4
EV/EBIT Average	- -	-292.87	-315.57	98.3	399.24	268.77	718.11	33.11	29.82	-7.77	-16.13	28.72	12.91	13.89
EV/EBIT High	- -	-292.87	-315.57	107.46	425.74	297.46	791.88	37.04	33.35	-8.8	-17.57	29.7	13.44	13.89
EV/EBIT Low	- -	-292.87	-315.57	92.15	368.34	248.45	656.25	30	26.49	-7.28	-15.25	28.05	12.58	13.89
Last Price	- -	- -	- -	26.9	30.34	15.05	9.43	15.89	7.35	4.34	2.17	0.67	0.85	0.24
High Price	- -	- -	- -	38.39	35.1	29.86	18.75	20.63	17.9	7.76	7.74	2.48	1.68	1.95
Enterprise Value Average	- -	4,393	4,418	6,881	6,787	6,182	4,309	4,238	3,877	2,650	2,984	2,527	1,742	1,347
Enterprise Value High	- -	4,393	4,418	7,522	7,238	6,842	4,751	4,742	4,336	3,000	3,250	2,613	1,815	1,347
Enterprise Value Low	- -	4,393	4,418	6,450	6,262	5,714	3,938	3,840	3,444	2,482	2,821	2,468	1,698	1,347

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y
Shares Outstanding	- -	74	74	74	75	75	75	75	75	75	76	76	77	78
Diluted Weighted Avg Shares	74	74	74	74	75	75	75	74	75	76	77	77	78	- -
Basic Weighted Avg Shares	74	74	74	74	75	75	75	74	75	75	75	76	76	- -
Revenue per Share	2.11	2.24	14.03	17.96	20.87	20.43	20.92	21.82	20.8	8.05	12.03	19.63	23.53	- -
EBITDA per Share	0.04	0.01	4.08	4.97	3.8	3.27	2.92	3.89	3.99	-2.31	-0.47	2.43	2.92	- -
Operating Income per Share	- -	-0.2	-0.19	0.95	0.23	0.31	0.08	1.73	1.73	-4.55	-2.47	1.16	1.78	- -
Basic EPS, GAAP	0.16	13.34	-0.09	-0.3	-0.53	0.28	-5.29	-0.86	-0.29	-3.17	2.39	0.39	-3.75	- -
Basic EPS from Cont Ops	0.16	13.3	0.37	0.12	0.19	0.63	-21.08	-0.12	-1.55	-11.49	0.51	0.61	-13.42	- -
Diluted EPS, GAAP	0.16	13.34	-0.09	-0.3	-0.53	0.28	-5.29	-0.86	-0.29	-3.13	2.32	0.39	-3.65	- -
Diluted EPS from Cont Ops	0.16	13.3	0.37	0.12	0.19	0.63	-21.08	-0.12	-1.55	-11.34	0.49	0.6	-13.08	- -
Dividend per Share	- -	0.52	- -	4.7	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	0.15	-0.26	4.56	5.2	5.21	4.01	2.92	5.41	5.21	-2.87	1.29	5.13	2.97	- -
Free Cash Flow per Basic Share	0.07	-0.34	3.74	3.99	3.72	3.04	2.05	4.58	4.11	-3.6	1.29	5.13	2.97	- -
Cash & Equivalents per Share	- -	6.62	6.58	8.34	9.21	10.29	9.73	9.08	4.55	5.64	10.13	13.86	14.34	- -
Book Value per Share	- -	13.42	13.32	8.28	7.64	7.92	2.63	1.81	1.49	-3.69	-6.24	-5.76	-9.51	- -
Tangible Book Value per Share	- -	-10.94	-8.4	-13.57	-9.08	-7.19	-4.61	-3.84	-6.44	-11.56	-12.75	-10.21	-10.43	- -

Liberty TripAdvisor Holdings, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)