Dropbox, Inc. Financial Ratios — 1Q5 Stock

Profitability (USD)

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Return on Common Equity (%)	- -	- -	- -	- -	-7.1	-44.88	- -	- -	- -	- -	- -
Return on Assets (%)	- -	- -	-11.04	-35.73	-2.4	-10.08	12.26	17.84	14.89	14.34	16.48
Return on Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	23.56	22.02	28.41
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	22.12	20.4	27.32
Gross Margin (%)	32.53	53.76	66.67	71.64	75.26	78.34	79.42	80.89	80.87	82.53	80.13
EBITDA Margin (%)	-25.94	-0.22	6.15	-23.51	5.6	-6.15	19.73	14.56	28.33	24.47	33.58
Operating Margin (%)	-50.71	-22.9	-10.27	-35.5	-4.85	6.33	14.17	15.33	15.33	19.08	27.28
Incremental Operating Margin (%)	- -	46.76	30.46	- -	153.38	79.85	75.61	30.42	15.28	220.6	- -
Pretax Margin (%)	-53.93	-24.27	-10.07	-34.5	-3.13	-13.07	13.87	8.29	22.16	20.01	24.5
Profit Margin (%)	-53.97	-24.88	-10.09	-34.84	-3.17	-13.39	15.56	23.79	18.13	17.75	20.17
Net Income to Common Margin (%)	-53.97	-24.88	-10.09	-34.84	-3.17	-13.39	15.56	23.79	18.13	17.75	20.17
Effective Tax Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	18.18	11.28	17.68
Dvd Payout Ratio (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Sustainable Growth Rate (%)	- -	- -	- -	- -	-7.1	-44.88	- -	- -	- -	- -	- -

Credit (USD)

Credit Ratios API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Total Debt	- -	257	174	164	1,007	1,120	2,369	2,295	2,031	2,997	3,587
ST Debt	- -	128	103	74	157	188	199	184	174	198	906
LT Debt	- -	130	72	90	850	931	2,170	2,111	1,857	2,798	2,681
Total Debt/EBITDA	- -	-135.37	2.56	-0.5	10.82	-9.51	5.56	6.78	2.87	4.81	4.24
Net Debt/EBITDA	- -	185.63	-6.31	1.59	-5.93	2.68	1.97	3.37	1.08	1.65	2.29
Total Debt/EBIT	- -	-1.33	-1.53	-0.33	-12.51	-4.04	8.63	12.66	3.77	6.16	5.21
Net Debt/EBIT	- -	1.82	3.78	1.05	6.85	1.14	3.05	6.29	1.42	2.11	2.82
EBITDA to Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	10.77
EBITDA-CapEx/Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	10.76
EBIT to Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	8.75
Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	79
Common Equity/Total Assets	- -	-49.04	-50.24	39.95	29.95	13.98	-9.51	-9.95	-5.56	-22.63	-63.17
Long-Term Debt/Equity (%)	- -	105.54	69.58	13.28	105.16	278.97	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	- -	34.11	25.83	10.7	46.83	64.07	104.59	106.33	99.58	124.69	149.79
Long-Term Debt/Total Assets (%)	- -	12.91	7.02	5.31	31.49	39.01	70.2	67.87	62.24	84.16	94.24
Total Debt/Equity (%)	- -	209.45	169.39	24.19	124.53	335.38	-805.95	-741.63	-1,224.73	-398.27	-199.59
Total Debt/Capital (%)	- -	67.68	62.88	19.48	55.46	77.03	114.17	115.59	108.89	133.53	200.41
Total Debt/Total Assets (%)	- -	25.61	17.09	9.66	37.3	46.9	76.62	73.78	68.06	90.12	126.09
Net Debt to Equity	- -	-287.21	-417.88	-76.73	-68.2	-94.34	-284.89	-368.84	-460.13	-136.39	-108.1
Net Debt/Capital (%)	- -	-1,291.94	281.41	-161.67	-43.62	-27.66	54.31	65.12	61.04	112.04	216.22
EBITDA	-157	-2	68	-327	93	-118	426	338	709	624	847
EBITDA-CapEx	-161	-10	67	-330	91	-118	419	337	708	623	846
Operating Income (Loss)	-306	-193	-114	-494	-80	121	306	357	384	486	688

Liquidity (USD)

Liquidity Ratios API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Cash Ratio	- -	0.56	0.58	1.3	1.14	1.03	1.46	1.12	1.13	1.32	0.55
Current Ratio	- -	0.65	0.7	1.45	1.23	1.13	1.57	1.25	1.26	1.44	0.63
Quick Ratio	- -	0.58	0.62	1.33	1.18	1.07	1.5	1.17	1.19	1.37	0.59
CFO/Avg Current Liab	- -	- -	0.48	0.54	0.57	0.54	0.64	0.67	0.65	0.74	0.61
Common Equity/Total Assets	- -	-49.04	-50.24	39.95	29.95	13.98	-9.51	-9.95	-5.56	-22.63	-63.17
Long-Term Debt/Equity (%)	- -	105.54	69.58	13.28	105.16	278.97	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	- -	34.11	25.83	10.7	46.83	64.07	104.59	106.33	99.58	124.69	149.79
Long-Term Debt/Total Assets (%)	- -	12.91	7.02	5.31	31.49	39.01	70.2	67.87	62.24	84.16	94.24
Total Debt/Equity (%)	- -	209.45	169.39	24.19	124.53	335.38	-805.95	-741.63	-1,224.73	-398.27	-199.59
Total Debt/Capital (%)	- -	67.68	62.88	19.48	55.46	77.03	114.17	115.59	108.89	133.53	200.41
Total Debt/Total Assets (%)	- -	25.61	17.09	9.66	37.3	46.9	76.62	73.78	68.06	90.12	126.09
CFO/Total Liabilities	- -	28.66	36.02	41.82	27.95	27.8	21.56	23.32	24.88	21.93	20.5
CFO/CapEx	3.22	29.72	412.88	141.8	310.88	2,854	107.32	724.82	2,612.33	4,470.5	2,379.5
Altman's Z-Score	- -	- -	- -	3.74	2.04	2.43	1.69	1.35	2.01	1.45	0.28

Working Capital (USD)

Working Capital Ratios API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Accounts Receivable Turnover	- -	- -	52.21	48.07	50.88	47.79	46.41	44.97	40.84	36.64	33.73
Days Sales Outstanding	- -	- -	6.99	7.59	7.17	7.64	7.87	8.12	8.94	9.96	10.82
Inventory Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover Days	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Conversion Cycle	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Inventory to Cash Days	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

Enterprise Value API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Market Capitalization	- -	- -	- -	8,603	7,398	9,381	9,265	7,778	9,892	8,967	6,744
- Cash & Cash Equivalents	- -	353	430	519	551	315	533	233	615	1,328	891
+ Preferred Equity and Hybrid Capital	- -	615	615	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	- -	257	174	164	1,007	1,120	2,369	2,295	2,031	2,997	3,587
Enterprise Value	- -	- -	- -	7,677	7,246	9,379	9,916	8,729	10,567	10,369	9,293
Total Capital	- -	380	277	841	1,815	1,453	2,075	1,985	1,865	2,244	1,790
Total Debt/Capital (%)	- -	67.68	62.88	19.48	55.46	77.03	114.17	115.59	108.89	133.53	200.41
Total Debt / EV	- -	- -	- -	0.02	0.14	0.12	0.24	0.26	0.19	0.29	0.39
EV/Sales	- -	- -	- -	5.52	4.36	4.9	4.6	3.75	4.22	4.07	3.69
EV/EBITDA	- -	- -	- -	- -	77.91	- -	23.29	25.8	14.91	16.63	10.98
EV/EBIT	- -	- -	- -	- -	- -	- -	36.14	48.15	19.62	21.33	13.49
EV/Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	13.48	11.6	9.14
EV/Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	13.49	11.6	9.15
Diluted Market Cap	- -	- -	- -	7,532	7,302	9,578	9,766	8,088	10,154	9,800	7,574
Diluted Enterprise Value	- -	- -	- -	6,606	7,150	9,576	10,417	9,039	10,828	11,203	10,123
EV per Share	- -	- -	- -	18.74	17.38	23.11	26.41	24.98	31.38	35.04	38.26
TTM Sales	604	845	1,107	1,392	1,661	1,914	2,158	2,325	2,502	2,548	2,521
TTM EBITDA	-157	-2	68	-327	93	-118	426	338	709	624	847
TTM Operating Income	-306	-193	-114	-494	-80	121	306	357	384	486	688
TTM Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	784	894	1,017
TTM Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	783	894	1,016

Multiples (USD)

Valuation Multiples API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Price/Free Cash Flow	- -	- -	- -	17.83	13.86	16.79	13.51	10.16	12.96	10.96	7.96
EV/EBIT	- -	- -	- -	- -	- -	- -	36.14	48.15	19.62	21.33	13.49
Enterprise Value	- -	- -	- -	7,677	7,246	9,379	9,916	8,729	10,567	10,369	9,293
Low Price	- -	- -	- -	19.42	16.7	15.14	21.03	19.12	18.88	20.65	23.4
EV/Sales	- -	- -	- -	5.52	4.36	4.9	4.6	3.75	4.22	4.07	3.69
EV/EBITDA	- -	- -	- -	- -	77.91	- -	23.29	25.8	14.91	16.63	10.98
Price/Earnings	- -	- -	- -	- -	- -	- -	28.51	14.54	22.1	21.32	14.65
Price/Earnings Average	- -	- -	- -	- -	- -	- -	31.65	14.58	18.79	17.9	15.22
Price/Earnings High	- -	- -	- -	- -	- -	- -	37.92	16.8	23.21	23.53	17.63
Price/Earnings Low	- -	- -	- -	- -	- -	- -	24.3	12.49	14.2	14.53	12.35
Price/Book Value	- -	- -	- -	12.71	9.15	28.1	-31.53	-25.14	-59.66	-11.92	-3.75
Price/Book Value Average	- -	- -	- -	16.87	11.18	24.43	-34.99	-25.22	-50.72	-10.01	-3.9
Price/Book Value High	- -	- -	- -	26.07	13.59	30.4	-41.93	-29.05	-62.67	-13.15	-4.51
Price/Book Value Low	- -	- -	- -	11.75	8.61	18.4	-26.87	-21.6	-38.34	-8.12	-3.16
Price/Tangible Book Value	- -	- -	- -	15.21	14.05	147.97	-13.16	-9.71	-15.8	-7.17	-2.95
Price/Tangible Book Value Average	- -	- -	- -	20.18	17.17	128.61	-14.61	-9.74	-13.43	-6.02	-3.06
Price/Tangible Book Value High	- -	- -	- -	31.19	20.86	160.04	-17.5	-11.22	-16.6	-7.92	-3.55
Price/Tangible Book Value Low	- -	- -	- -	14.07	13.23	96.9	-11.21	-8.34	-10.15	-4.89	-2.49
Price/Sales	- -	- -	- -	5.41	4.4	5	4.44	3.46	4.01	3.78	2.95
Price/Sales Average	- -	- -	- -	7.18	5.37	4.35	4.92	3.47	3.41	3.18	3.07
Price/Sales High	- -	- -	- -	11.1	6.53	5.41	5.9	4	4.21	4.18	3.55
Price/Sales Low	- -	- -	- -	5	4.14	3.28	3.78	2.97	2.57	2.58	2.49
Price/Cash Flow	- -	- -	- -	17.7	13.82	16.78	13.12	10.09	12.79	10.78	7.83
Price/Cash Flow Average	- -	- -	- -	23.49	16.88	14.58	14.56	10.12	10.87	9.06	8.13
Price/Cash Flow High	- -	- -	- -	36.31	20.52	18.15	17.45	11.65	13.44	11.9	9.42
Price/Cash Flow Low	- -	- -	- -	16.37	13	10.99	11.18	8.66	8.22	7.35	6.6
Price/Free Cash Flow Average	- -	- -	- -	23.66	16.93	14.59	14.99	10.19	11.02	9.21	8.27
Price/Free Cash Flow High	- -	- -	- -	36.57	20.58	18.15	17.97	11.74	13.61	12.1	9.58
Price/Free Cash Flow Low	- -	- -	- -	16.49	13.05	10.99	11.51	8.73	8.33	7.47	6.71
EV/Sales Average	- -	- -	- -	7.54	5.35	4.26	5.07	3.77	3.63	3.5	3.79
EV/Sales High	- -	- -	- -	12.01	6.52	5.3	6.01	4.27	4.42	4.43	4.23
EV/Sales Low	- -	- -	- -	5.05	4.1	3.21	3.96	3.28	2.81	2.95	3.27
EV/EBITDA Average	- -	- -	- -	- -	95.54	- -	25.68	25.87	12.82	14.32	11.28
EV/EBITDA High	- -	- -	- -	- -	116.48	- -	30.47	29.37	15.61	18.12	12.6
EV/EBITDA Low	- -	- -	- -	- -	73.23	- -	20.07	22.56	9.92	12.05	9.73
EV/EBIT Average	- -	- -	- -	- -	- -	- -	39.85	48.28	16.86	18.37	13.86
EV/EBIT High	- -	- -	- -	- -	- -	- -	47.28	54.82	20.54	23.24	15.47
EV/EBIT Low	- -	- -	- -	- -	- -	- -	31.15	42.1	13.05	15.45	11.95
Last Price	- -	- -	- -	21	17.74	23.12	24.67	22.26	29.38	30.3	27.76
High Price	- -	- -	- -	43.07	26.34	25	32.82	25.72	30.86	33.44	33.4
Enterprise Value Average	- -	- -	- -	10,489	8,885	8,152	10,935	8,754	9,084	8,931	9,552
Enterprise Value High	- -	- -	- -	16,716	10,833	10,144	12,974	9,939	11,066	11,298	10,662
Enterprise Value Low	- -	- -	- -	7,030	6,811	6,142	8,547	7,633	7,031	7,512	8,234

Per Share Data Items (USD)

Per-Share Data API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Shares Outstanding	58	393	395	410	417	406	376	349	337	296	243
Diluted Weighted Avg Shares	359	359	393	359	412	414	396	363	346	323	273
Basic Weighted Avg Shares	359	359	393	359	412	414	388	361	341	318	268
Revenue per Share	1.68	2.36	2.82	3.88	4.04	4.62	5.56	6.44	7.33	8.01	9.4
EBITDA per Share	-0.44	-0.01	0.17	-0.91	0.23	-0.28	1.1	0.94	2.08	1.96	3.16
Operating Income per Share	-0.85	-0.54	-0.29	-1.38	-0.2	0.29	0.79	0.99	1.12	1.53	2.56
Basic EPS, GAAP	-0.91	-0.59	-0.28	-1.35	-0.13	-0.62	0.87	1.53	1.33	1.42	1.89
Basic EPS from Cont Ops	-0.91	-0.59	-0.28	-1.35	-0.13	-0.62	0.87	1.53	1.33	1.42	1.89
Diluted EPS, GAAP	-0.91	-0.59	-0.28	-1.35	-0.13	-0.62	0.85	1.52	1.31	1.4	1.86
Diluted EPS from Cont Ops	-0.91	-0.59	-0.28	-1.35	-0.13	-0.62	0.85	1.52	1.31	1.4	1.86
Dividend per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	0.04	0.7	0.84	1.19	1.28	1.38	1.88	2.21	2.3	2.81	3.55
Free Cash Flow per Basic Share	0.03	0.68	0.84	1.18	1.28	1.38	1.86	2.2	2.3	2.81	3.55
Cash & Equivalents per Share	- -	0.9	1.09	2.66	2.78	2.76	4.58	3.84	4.03	5.39	4.27
Book Value per Share	- -	-1.25	-1.3	1.65	1.94	0.82	-0.78	-0.89	-0.49	-2.54	-7.4
Tangible Book Value per Share	- -	-1.56	-1.59	1.38	1.26	0.16	-1.88	-2.29	-1.86	-4.22	-9.41