Columbia Banking System, Inc. Financial Ratios — COLB Stock

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	2025 Y
Return on Common Equity (%)	8.64	6.06	5.68	5.35	5.83	5.9	6.11	7.8	8.43	-44.37	15.77	11.91	8.47	9.78	8.06
Return on Assets (%)	0.64	0.87	0.84	0.86	0.97	0.95	0.96	1.2	1.27	-5.25	1.4	1.08	0.83	1.03	0.93
Return on Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Gross Margin (%)	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100
EBITDA Margin (%)	2.66	3.02	4.49	4.12	4.5	5.2	5.06	4.3	3.43	2.89	2.47	2.23	7.21	7.78	6.13
Operating Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Incremental Operating Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Pretax Margin (%)	22.5	29.21	28.96	24.26	30.3	31.66	30.49	34.7	37.2	-112.51	43.74	35.49	23.59	37.27	31.64
Profit Margin (%)	15.07	19.17	18.66	15.53	19.43	20.18	21.17	25.96	28.09	-117.68	32.94	26.53	17.48	27.68	23.9
Net Income to Common Margin (%)	15	19.05	18.52	15.48	19.4	20.17	21.16	25.96	28.09	-117.68	32.94	26.53	17.48	27.68	23.9
Effective Tax Rate (%)	33.03	34.35	35.54	36	35.89	36.27	30.58	25.18	24.48	- -	24.7	25.26	25.9	25.73	24.45
Dvd Payout Ratio (%)	33.67	44.98	51.26	67.1	60.43	61.3	59.99	54.99	52.27	-12.14	43.71	54.13	77.36	56.18	60.91
Sustainable Growth Rate (%)	5.73	3.34	2.77	1.76	2.31	2.28	2.44	3.51	4.02	-49.76	8.88	5.46	1.92	4.29	3.15

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	2025 Y
Total Debt	441	450	441	1,357	1,245	1,216	1,180	1,141	1,389	1,229	483	1,409	4,505	3,539	3,635
ST Debt	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
LT Debt	441	450	441	1,357	1,245	1,216	1,180	1,141	1,389	1,229	483	1,409	4,505	3,539	3,635
Total Debt/EBITDA	33.54	28.03	18.64	34.62	24.14	20.51	20.36	21.8	32.1	32.78	15.33	49.79	31.28	23.59	25.78
Net Debt/EBITDA	-11.99	-5.87	-14.8	-6.32	9.14	-3.95	9.42	9.91	-2.14	-38.91	-75.38	0.81	15.4	11.07	8.9
Total Debt/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Net Debt/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EBITDA to Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EBITDA-CapEx/Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EBIT to Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Common Equity/Total Assets	14.17	14.41	14.89	16.65	16.46	15.87	15.55	15.28	14.85	8.83	8.97	9.13	10.23	10.82	12.08
Long-Term Debt/Equity (%)	26.38	26.08	25.51	35.93	32.36	31.03	29.73	28.14	32.21	45.43	17.56	56.83	90.19	69.15	46.36
Long-Term Debt/Capital (%)	21.21	20.92	20.28	26.49	24.43	23.59	22.81	21.71	24.49	32.24	14.95	32.65	45.78	38.81	31.05
Long-Term Debt/Total Assets (%)	3.82	3.81	3.79	6	5.32	4.9	4.6	4.24	4.82	4.2	1.58	4.43	8.63	6.86	5.44
Total Debt/Equity (%)	26.38	26.08	25.51	35.93	32.36	31.03	29.73	28.14	32.21	45.43	17.56	56.83	90.19	69.15	46.36
Total Debt/Capital (%)	21.21	20.92	20.28	26.49	24.43	23.59	22.81	21.71	24.49	32.24	14.95	32.65	45.78	38.81	31.05
Total Debt/Total Assets (%)	3.82	3.81	3.79	6	5.32	4.9	4.6	4.24	4.82	4.2	1.58	4.43	8.63	6.86	5.44
Net Debt to Equity	-9.43	-5.46	-20.25	-6.56	12.26	-5.97	13.75	12.79	-2.15	-53.92	-86.36	0.93	44.38	32.45	16.01
Net Debt/Capital (%)	-10.64	-5.86	-25.3	-7.05	10.91	-6.31	12.02	11.19	-2.15	-117.86	-506.47	0.76	28.86	22.94	13.45
EBITDA	13	16	24	39	52	59	58	52	43	37	31	28	144	150	141
EBITDA-CapEx	-21	-7	-11	-23	-18	59	58	52	43	37	31	28	144	150	141
Operating Income (Loss)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

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	2025 Y
Cash Ratio	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Current Ratio	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Quick Ratio	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
CFO/Avg Current Liab	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Common Equity/Total Assets	14.17	14.41	14.89	16.65	16.46	15.87	15.55	15.28	14.85	8.83	8.97	9.13	10.23	10.82	12.08
Long-Term Debt/Equity (%)	26.38	26.08	25.51	35.93	32.36	31.03	29.73	28.14	32.21	45.43	17.56	56.83	90.19	69.15	46.36
Long-Term Debt/Capital (%)	21.21	20.92	20.28	26.49	24.43	23.59	22.81	21.71	24.49	32.24	14.95	32.65	45.78	38.81	31.05
Long-Term Debt/Total Assets (%)	3.82	3.81	3.79	6	5.32	4.9	4.6	4.24	4.82	4.2	1.58	4.43	8.63	6.86	5.44
Total Debt/Equity (%)	26.38	26.08	25.51	35.93	32.36	31.03	29.73	28.14	32.21	45.43	17.56	56.83	90.19	69.15	46.36
Total Debt/Capital (%)	21.21	20.92	20.28	26.49	24.43	23.59	22.81	21.71	24.49	32.24	14.95	32.65	45.78	38.81	31.05
Total Debt/Total Assets (%)	3.82	3.81	3.79	6	5.32	4.9	4.6	4.24	4.82	4.2	1.58	4.43	8.63	6.86	5.44
CFO/Total Liabilities	1.84	0.24	4.22	1.9	1.93	1.99	2.37	2.21	-0.33	0.35	2.38	3.63	1.42	1.42	1.26
CFO/CapEx	5.37	1.08	12.21	5.75	5.43	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Altman's Z-Score	0.06	0.07	0.08	0.06	0.08	0.08	0.08	0.08	0.09	- -	0.01	0.02	0.03	0.03	0.04

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	2025 Y
Accounts Receivable Turnover	32.3	18.45	20.77	26.39	22.64	20.94	19.07	18.1	17.91	16.81	16.53	15.08	40.81	- -	- -
Days Sales Outstanding	11.3	19.79	17.58	13.83	16.12	17.43	19.14	20.16	20.38	21.71	22.08	24.21	8.94	- -	- -
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)

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	2025 Y
Market Capitalization	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
- Cash & Cash Equivalents	599	544	790	1,605	774	1,449	634	623	1,363	2,573	2,762	1,295	2,157	1,878	2,380
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	441	450	441	1,357	1,245	1,216	1,180	1,141	1,389	1,229	483	1,409	4,505	3,539	3,635
Enterprise Value	-3,326	-2,719	-2,141	-2,546	-2,051	-2,935	-2,520	-2,458	-2,788	-4,277	-6,149	-3,081	-6,482	-6,614	885
Total Capital	2,080	2,149	2,173	5,123	5,097	5,154	5,174	5,257	5,674	3,810	3,230	4,316	9,840	9,119	11,708
Total Debt/Capital (%)	21.21	20.92	20.28	26.49	24.43	23.59	22.81	21.71	24.49	32.24	14.95	32.65	45.78	38.81	31.05
Total Debt / EV	-0.13	-0.17	-0.21	-0.53	-0.61	-0.41	-0.47	-0.46	-0.5	-0.29	-0.08	-0.46	-0.69	-0.54	4.11
EV/Sales	- -	- -	1.78	2.74	4.46	6.06	6.16	4.54	4.9	2.8	0.8	2.72	- -	3.74	0.38
EV/EBITDA	- -	- -	39.62	66.42	99.08	116.56	121.58	105.75	142.71	96.83	32.31	122.1	- -	48.13	6.28
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Cash Flow to Firm	- -	- -	2.24	7.28	13.57	16.64	13.67	10.96	- -	38.7	1.54	3.25	- -	10.95	1.19
EV/Free Cash Flow to Firm	- -	- -	2.07	6.2	11.46	16.64	13.67	10.96	- -	38.7	1.54	3.25	- -	10.95	1.19
Diluted Market Cap	2,205	2,012	3,084	5,178	7,186	9,870	9,593	8,011	8,978	7,906	7,185	6,550	5,226	5,654	6,683
Diluted Enterprise Value	2,047	1,918	2,734	4,930	7,658	9,636	10,139	8,529	9,005	6,561	4,906	6,665	7,573	7,315	7,938
EV per Share	- -	- -	8.37	13.96	23.2	31.36	32	25.13	28.04	16.48	4.65	15.93	- -	34.6	- -
TTM Sales	494	531	527	951	1,145	1,140	1,145	1,218	1,260	1,295	1,276	1,270	1,997	1,929	2,301
TTM EBITDA	13	16	24	39	52	59	58	52	43	37	31	28	144	150	141
TTM Operating Income	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
TTM Cash Flow to Firm	182	25	418	358	377	415	516	505	-80	94	663	1,065	670	659	746
TTM Free Cash Flow to Firm	216	47	452	420	446	415	516	505	-80	94	663	1,065	670	659	746

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	2025 Y
Price/Free Cash Flow	10.19	42.42	6.82	12.34	16.11	23.77	18.61	15.85	-111.56	84.31	10.84	6.15	7.8	8.58	8.96
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value	-3,326	-2,719	-2,141	-2,546	-2,051	-2,935	-2,520	-2,458	-2,788	-4,277	-6,149	-3,081	-6,482	-6,614	885
Low Price	13.46	16.18	18.27	23.59	24.6	26.17	35.67	31.35	30.65	19.11	30.09	26.97	17.54	17.08	19.61
EV/Sales	- -	- -	1.78	2.74	4.46	6.06	6.16	4.54	4.9	2.8	0.8	2.72	- -	3.74	0.38
EV/EBITDA	- -	- -	39.62	66.42	99.08	116.56	121.58	105.75	142.71	96.83	32.31	122.1	- -	48.13	6.28
Price/Earnings	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Free Cash Flow Average	9.49	45.63	5.76	11.81	15.25	16.99	17.3	18.02	-100.34	69.94	12.93	6.45	6.72	7.33	8.2
Price/Free Cash Flow High	11.71	55.61	7.04	13.57	17.97	24.09	20.59	20.41	-113.51	95.88	16.79	7.69	9.72	10.44	9.49
Price/Free Cash Flow Low	7.12	38.26	4.53	10.54	12.19	13.92	15.28	13.7	-84.03	44.88	9.97	5.51	5.13	5.43	6.29
EV/Sales Average	3.83	3.89	4.27	4.92	0.41	5.96	0.48	0.43	0.02	4.03	4.91	0.09	1.18	0.86	0.55
EV/Sales High	4.8	4.78	5.37	5.7	0.41	8.54	0.48	0.43	0.02	5.91	6.91	0.09	1.18	0.86	0.55
EV/Sales Low	2.79	3.23	3.22	4.37	0.41	4.85	0.48	0.43	0.02	2.21	3.38	0.09	1.18	0.86	0.55
EV/EBITDA Average	-11.99	-5.87	-14.8	-6.32	9.14	-3.95	9.42	9.91	0.61	-35.88	-72.35	4.05	16.3	11.07	8.9
EV/EBITDA High	-11.99	-5.87	-14.8	-6.32	9.14	-3.95	9.42	9.91	0.61	-35.88	-72.35	4.05	16.3	11.07	8.9
EV/EBITDA Low	-11.99	-5.87	-14.8	-6.32	9.14	-3.95	9.42	9.91	0.61	-35.88	-72.35	4.05	16.3	11.07	8.9
EV/EBIT Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Last Price	19.27	17.94	27.49	27.61	32.51	44.68	43.44	36.29	40.69	35.9	32.72	30.13	26.68	27.01	27.95
High Price	22.14	23.52	28.37	30.36	36.27	45.27	48.06	46.71	41.4	40.83	50.68	37.66	33.24	32.85	29.61
Enterprise Value Average	-158	-94	-350	-248	472	-234	546	519	27	-1,345	-2,279	115	2,347	1,661	1,255
Enterprise Value High	-158	-94	-350	-248	472	-234	546	519	27	-1,345	-2,279	115	2,347	1,661	1,255
Enterprise Value Low	-158	-94	-350	-248	472	-234	546	519	27	-1,345	-2,279	115	2,347	1,661	1,255

	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	2025 Y
Shares Outstanding	112	112	112	220	220	220	220	220	220	220	217	217	209	210	295
Diluted Weighted Avg Shares	114	112	112	188	221	221	221	221	221	220	220	217	196	209	239
Basic Weighted Avg Shares	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Revenue per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EBITDA per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Operating Income per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Basic EPS, GAAP	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Basic EPS from Cont Ops	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted EPS, GAAP	0.65	0.9	0.87	0.78	1.01	1.04	1.1	1.43	1.6	-6.92	1.91	1.55	1.78	2.55	2.3
Diluted EPS from Cont Ops	0.65	0.91	0.88	0.79	1.01	1.04	1.1	1.43	1.6	-6.92	1.91	1.55	1.78	2.55	2.3
Dividend per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Free Cash Flow per Basic Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash & Equivalents per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Book Value per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Tangible Book Value per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Columbia Banking System, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)