Central Florida Behavioral Health Network, Inc. DATA ANALYTICS AND - PowerPoint PPT Presentation

Central Florida Behavioral Health Network, Inc. DATA ANALYTICS AND BENCHMARKING FISCAL YEAR ENDED JUNE 30, 2018 JUNE 28, 2019

Managing Entities Surveyed  Central Florida Behavioral Health Network, Inc. (CFBHN)  Big Bend Community Based Care, Inc. (BBCBC)  Broward Behavioral Health Coalition, Inc. (BBHC)  Central Florida Cares Health System, Inc. (CFCHS)  Lutheran Services Florida, Inc. (LSF)  Southeast Florida Behavioral Health Network, Inc. (SEFBHN)  South Florida Behavioral Health Network, Inc. (SFBHN) Solely for the use of Central Florida Behavioral Health Network, Inc. 2 MHM including Management and those charged with Governance

Program Efficiency % of costs dedicated to programming 2018 2017 100.00% 2016 99.00% 98.00% 98.26% 97.43% 97.44% 97.00% 96.76% 96.64% 96.57% 96.55% 96.48% 96.42% 96.40% 96.32% 96.43% 96.00% 95.78% 95.96% 95.27% 95.33% 95.30% 95.30% 95.00% 94.86% 94.62% 94.00% 93.76% 93.00% 92.00% CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Solely for the use of Central Florida Behavioral Health Network, Inc. 3 MHM including Management and those charged with Governance

Operating Reliance Southeast Central Florida Big Bend Broward Florida South Florida Behavioral Community Behavioral Central Florida Lutheran Behavioral Behavioral Health Based Care, Health Cares Health Services Health Health Network, Inc. Inc. Coalition, Inc. System, Inc. Florida, Inc. Network, Inc. Network, Inc. Unrestricted Program Revenue $ 190,361,354 $ 98,288,620 $ 60,037,164 $ 71,612,403 $ 116,175,919 $ 60,967,330 $ 87,560,330 Total Expenses $ 190,485,751 $ 98,384,890 $ 60,037,164 $ 71,727,349 $ 114,888,727 $ 60,967,075 $ 87,566,720 Operating Reliance 99.93% 99.90% 100.00% 99.84% 101.12% 100.00% 99.99% Solely for the use of Central Florida Behavioral Health Network, Inc. 4 MHM including Management and those charged with Governance

Working Capital and Liquidity Southeast Central Florida Big Bend Broward Florida South Florida Behavioral Community Behavioral Central Florida Lutheran Behavioral Behavioral Health Based Care, Health Cares Health Services Health Health Network, Inc. Inc. Coalition, Inc. System, Inc. Florida, Inc. Network, Inc. Network, Inc. Total Current Assets $ 21,232,874 $ 13,809,920 $ 10,198,177 $ 10,623,951 $ 19,929,346 $ 6,665,369 $ 14,297,136 Total Current Liabilities $ 19,356,895 $ 14,758,277 $ 10,179,391 $ 10,436,496 $ 10,206,691 $ 6,628,361 $ 13,357,984 Current Ratio 1.10 0.94 1.00 1.02 1.95 1.01 1.07 Cash + Total Receivables $ 21,202,268 $ 13,706,549 $ 10,095,649 $ 10,555,012 $ 19,929,346 $ 6,647,138 $ 14,153,064 Total Current Liabilities $ 19,356,895 $ 14,758,277 $ 10,179,391 $ 10,436,496 $ 10,206,691 $ 6,628,361 $ 13,357,984 Quick Ratio 1.10 0.93 0.99 1.01 1.95 1.00 1.06 Solely for the use of Central Florida Behavioral Health Network, Inc. 5 MHM including Management and those charged with Governance

Receivables, Payables & Cash Position Southeast Central Florida Big Bend Broward Florida South Florida Behavioral Community Behavioral Central Florida Lutheran Behavioral Behavioral Health Based Care, Health Cares Health Services Health Health Network, Inc. Inc. Coalition, Inc. System, Inc. Florida, Inc. Network, Inc. Network, Inc. Total Receivables $ 20,407,795 $ 5,653,556 $ 9,442,563 $ 6,412,886 $ 16,957,185 $ 5,062,481 $ 6,818,800 Total Revenue (less in-kind) $ 190,356,330 $ 98,288,620 $ 60,037,164 $ 71,612,403 $ 116,175,919 $ 60,967,330 $ 87,560,330 Receivable Days 39 21 57 33 53 30 28 Payables $ 18,397,780 $ 12,823,701 $ 9,159,540 $ 7,896,484 $ 10,206,691 $ 5,600,551 $ 10,402,289 Total Expenditures (less depreciation & in-kind plus capital) $ 190,338,653 $ 97,875,923 $ 60,030,360 $ 71,534,593 $ 114,888,727 $ 60,968,334 $ 87,549,453 Payable Days 35 48 56 40 32 34 43 Unrestricted Cash $ 794,473 $ 8,052,993 $ 653,086 $ 4,142,126 $ 2,972,161 $ 1,584,657 $ 7,344,264 Total Expenses (less depreciation & in-kind) $ 190,338,653 $ 97,875,923 $ 60,030,360 $ 71,534,593 $ 114,888,727 $ 60,968,334 $ 87,549,453 Days Cash Reserve 2 30 4 21 9 9 31 Solely for the use of Central Florida Behavioral Health Network, Inc. 6 MHM including Management and those charged with Governance

Number of Days Revenue in AR 2018 2017 2016 57 53 39 33 33 30 30 29 28 28 27 27 27 27 25 23 21 21 18 15 4 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Solely for the use of Central Florida Behavioral Health Network, Inc. 7 MHM including Management and those charged with Governance

Number of Days Expenses in AP 2018 2017 2016 56 53 52 52 48 43 43 41 41 40 40 39 38 38 35 35 34 32 32 31 13 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Solely for the use of Central Florida Behavioral Health Network, Inc. 8 MHM including Management and those charged with Governance

Days Cash Reserve 2018 2017 2016 35 34 32 31 30 25 24 23 23 21 21 19 19 18 16 9 9 7 7 4 2 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Solely for the use of Central Florida Behavioral Health Network, Inc. 9 MHM including Management and those charged with Governance

2018, 2017, and 2016 70 60 Number of Days in Accounts 50 Receivable 40 Number of Days Expenses in 30 AP 2018 20 Number of Days in Cash 10 Reserve - CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN 60 50 Number of Days in Accounts Receivable 40 30 Number of Days Expenses in 2017 AP 20 Number of Days in Cash 10 Reserve - CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN 60 50 Number of Days in Accounts 40 Receivable 30 Number of Days Expenses in 2016 AP 20 Number of Days in Cash 10 Reserve - CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and 10 those charged with Governance

Ratio Explanations Ratio Expla lanation • Administrative Cost • Direct and indirect administrative expenses as a percentage of total entity expenses. Measures efficiency of administrative function in relation to total Rate costs. • Program Efficiency • Total direct expenses as a percentage of total entity expenses. The inverse of the administrative cost rate. Measures the efficiency of $ used for programmatic purposes in relation to total costs. • Administrative • Total administrative expenses divided by the # of clients served by the Dollars/Cost Per ME and its provider agencies. Client • Operating Reliance • Unrestricted program revenue divided by total expenses. Indicates how able a NFP entity is to fund costs from program revenue alone. The ratio for ME’s is expected to be near 100%. Solely for the use of Central Florida Behavioral Health Network, Inc. 11 MHM including Management and those charged with Governance

Ratio Explanations - Continued Ratio Expla lanation • Current Ratio • Current assets divided by current liabilities. Measures the overall liquidity position of an organization. • Quick Ratio • Cash plus total receivables divided by current liabilities. Also a liquidity measure but focuses on cash and receivables. • Receivable Days • Accounts receivable divided by total revenue (excluding in-kind) with the result multiplied by 365. The resulting number reflects the length of time it takes to collect receivables. • Payable Days • Payables divided by total expenses (excluding in-kind and depreciation) plus capital expenditures with the result multiplied by 365. Rough measure of how timely an organization is in meeting payment obligations. • Unrestricted cash divided by total expenses (excluding in-kind and • Days Cash Reserve depreciation) with the result multiplied by 365. Measures the amount of cash on hand to meet future expenses. Expectation for ME with no other programming activity is generally very low given the nature of operations. Solely for the use of Central Florida Behavioral Health Network, Inc. 12 MHM including Management and those charged with Governance

? ? ? ? QUESTIONS Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 13 MHM