In_House_Revenue_Estimate (4).xlsx

	A	B	C	D	E	F	G	H	I	J	K
1
2	Payer Mix		Est. Payer Count	Rate	Amount Billed	ALS Count	BLS Count	Est. ALS Revenue	Est. BLS Revenue	Est. Total Revenue	Collection Rate
3	Medicare	41%	870	$1,400	$1,218,028	268	602	$139,006	$262,871	$401,878	33%
4	Medicare (Managed)	10%	212	$1,400	$297,080	65	147	$29,001	$53,103	$82,104	28%
5	Medicaid	29%	615	$1,400	$861,532	190	426	$67,915	$128,432	$196,347	23%
6	Private Insurance (65%)	13%	276	$1,400	$386,204	85	191	$77,344	$173,688	$251,033	65%
7	Private Pay - Uninsured (15%)	4%	85	$1,400	$118,832	26	59	$5,492	$12,333	$17,825	15%
8	Veterens Administration	3%	64	$1,400	$89,124	20	44	$10,171	$19,234	$29,406	33%
9	TOTAL	100%	2,122		$2,970,800	654	1468	$328,929	$649,662	$978,592	33%
10
11
12
13	Bottom Line					Payer Mix Collection Assumptions
14	Payer Mix: Updated as of 3/31/23 - 9 Months of Data from GC					Medicare: 100% of Reimbursement Rate (ALS $518.57) (BLS $436.69)
15	Payer Count: Actual Count as of 12/31 (6 Months of Data from GC) Doubled					Managed Medicare: Subtract an Estimated $250 Deductable from Either ALS or BLS Reimbursement and Assume Only 70% Collection
16	Rate: Advice from A.P. Triton ($100 roughly = $23,342)					Private Insureance: Assume 65% Collection
17	Amount Billed: Multiply rate Times Count					Private Pay: Assume 15% Collection
18	ALS Count: Multiply ALS % (31%) by Payer Count					Veterans Administration: Assume Same as Medicare
19	BLS Count: Multiply BLS % (69%) by Payer Count					Medicaid: Same Process as Medicare But Using Lower Reimbursement Rates
20	ALS Revenue: Multiply ALS Reimbursement Rate by ALS Count					Reimbursement Rates		Medicare	VT Medicaid
21	BLS Revenue: Multiply BLS Reimbursement Rate by BLS Count					ALS - AO433		750.56	$0.00
22	Total Revenue: Aaa ALS Revenue and BLS Revenue					ALS - AO427		$518.57	$358.20
23						BLS - AO429		$436.69	$301.64
24	ALS	460	31%			Private Insurance Collection Rate			65%	$910
25	BLS	1033	69%			Private Pay Collection Rate			15%
26		1493	100%			Estimated Managed Medicare Deductable			$ 250
27						Managed Medicare Deductable Collection Rate			70%
28									30%
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