HospitalExp_Breakdown.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Org Type	For-profit		Non-Profit		Public/Academic		Large Rural		Small Rural		Payvider Provider		Payvider Plan		Payvider
2	Org Name	Community Health Systems		Memorial Hermann		UW Medicine		Pullman Regional Hospital		Three Rivers Hospital		Geisinger Clinic		Geisinger Health Plan		Geisinger Combined
3	Unit & Year	Millions, FY 2022	% of Expenses	Dollars, FY 2022	% of Expenses	Thousands, FY 2022	% of Expenses	Dollars, FY 2022	% of Expenses	Dollars, FY 2022	% of Expenses	Dollars, FY 2020	% of Expenses	Dollars, FY 2020	% of Expenses	Dollars, FY 2020	% of Expenses
4	Net Revenue	$ 12,211		$ 7,314,063,690		$ 2,561,369		$ 88,729,317		$ 15,375,724		$ 1,625,266,006		$ 1,380,938,040		$ 3,006,204,046
5	Salaries and benefits	$ 5,330	46.8%	$ 3,089,668,824	48.1%	$ 1,300,234	50.8%	$ 45,770,813	64.8%	$ 8,246,859	45.0%	$ 1,007,856,101	55.4%	$ 58,967,860	4.3%	$ 1,066,823,961	33.5%
6	Supplies	$ 1,975	17.3%	$ 1,095,530,725	17.1%	$ 484,256	18.9%	$ 14,157,872	20.1%	$ 1,704,651	9.3%	$ 383,163,249	21.1%		0.0%	$ 383,163,249	12.0%
7	Other operating expenses	$ 3,336	29.3%	$ 1,693,763,862	26.4%	$ 602,336	23.5%	$ 18,054,854	25.6%	$ 7,568,352	41.3%	$ 395,426,856	21.7%	$ 1,291,371,114	94.7%	$ 1,686,797,970	53.0%
8	Professional service fees	NA		$ 1,238,045,853	19.3%	$ 513,349	20.0%	$ 8,532,069	12.1%	$ 4,279,613	23.4%	$ 234,376,462	12.9%	$ 110,974,808	8.1%	$ 345,351,270	10.8%
9	Lease cost and rent	$ 317	2.8%	$ 208,014,255	3.2%	NA		$ 839,400	1.2%	$ 119,784	0.7%	$ 18,318,265	1.0%	$ 1,947,354	0.1%	$ 20,265,619	0.6%
10	Depreciation and amortization	$ 534	4.7%	$ 336,718,682	5.2%	$ 118,075	4.6%	$ 3,029,616	4.3%	$ 633,323	3.5%	$ 15,087,851	0.8%	$ 10,879,652	0.8%	$ 25,967,503	0.8%
11	Total operating expenses	$ 11,390		$ 6,423,696,348		$ 2,504,901		$ 70,594,549		$ 18,311,469		$ 1,819,852,322		$ 1,363,898,091		$ 3,183,750,413
12	Net Operating Income	$ 821	6.7%	$ 890,367,342	12.2%	$ 56,468	2.2%	$ 18,134,768	20.4%	$ (2,935,745)	-19.1%	$ (194,586,316)	-12.0%	17,039,949	1.2%	$ (177,546,367)	-5.9%
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100