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

SLIDE 1

Central Florida Behavioral Health Network, Inc.

DATA ANALYTICS AND BENCHMARKING FISCAL YEAR ENDED JUNE 30, 2018 JUNE 28, 2019

SLIDE 2

Managing Entities Surveyed

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

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)

MHM

SLIDE 3

Program Efficiency

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

% of costs dedicated to programming

92.00% 93.00% 94.00% 95.00% 96.00% 97.00% 98.00% 99.00% 100.00% CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN

96.64% 98.26% 95.78% 96.55% 96.48% 95.27% 95.30% 96.57% 97.44% 94.86% 96.32% 96.42% 94.62% 95.30% 96.76% 97.43% 93.76% 96.40% 96.43% 95.33% 95.96%

2018 2017 2016

SLIDE 4

Operating Reliance

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

Central Florida Behavioral Health Network, Inc. Big Bend Community Based Care, Inc. Broward Behavioral Health Coalition, Inc. Central Florida Cares Health System, Inc. Lutheran Services Florida, Inc. Southeast Florida Behavioral Health Network, Inc. South Florida Behavioral Health 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%

SLIDE 5

Working Capital and Liquidity

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

Central Florida Behavioral Health Network, Inc. Big Bend Community Based Care, Inc. Broward Behavioral Health Coalition, Inc. Central Florida Cares Health System, Inc. Lutheran Services Florida, Inc. Southeast Florida Behavioral Health Network, Inc. South Florida Behavioral Health 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

SLIDE 6

Receivables, Payables & Cash Position

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

Central Florida Behavioral Health Network, Inc. Big Bend Community Based Care, Inc. Broward Behavioral Health Coalition, Inc. Central Florida Cares Health System, Inc. Lutheran Services Florida, Inc. Southeast Florida Behavioral Health Network, Inc. South Florida Behavioral Health 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

SLIDE 7

Number of Days Revenue in AR

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

39 21 57 33 53 30 28 18 21 29 27 27 27 27 23 4 28 15 30 25 33 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN

2018 2017 2016

SLIDE 8

Number of Days Expenses in AP

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

35 48 56 40 32 34 43 35 39 52 32 13 31 41 38 41 52 38 40 43 53 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN

2018 2017 2016

SLIDE 9

Days Cash Reserve

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

2 30 4 21 9 9 31 21 25 23 19 16 7 35 19 34 23 24 7 18 32 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN

2018 2017 2016

SLIDE 10

2018, 2017, and 2016

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

10

2018 2017

10

20 30 40 50 60 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Number of Days in Accounts Receivable Number of Days Expenses in AP Number of Days in Cash Reserve

2016

10

20 30 40 50 60 70 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Number of Days in Accounts Receivable Number of Days Expenses in AP Number of Days in Cash Reserve

10

20 30 40 50 60 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Number of Days in Accounts Receivable Number of Days Expenses in AP Number of Days in Cash Reserve

SLIDE 11

Ratio Explanations

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

Ratio Expla lanation

Administrative Cost

Rate

Direct and indirect administrative expenses as a percentage of total entity
expenses. Measures efficiency of administrative function in relation to total

costs.

Program Efficiency
Total direct expenses as a percentage of total entity expenses. The inverse
f the administrative cost rate. Measures the efficiency of $ used for

programmatic purposes in relation to total costs.

Administrative

Dollars/Cost Per Client

Total administrative expenses divided by the # of clients served by the

ME and its provider agencies.

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%.

SLIDE 12

Ratio Explanations - Continued

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

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

f 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.

Days Cash Reserve
Unrestricted cash divided by total expenses (excluding in-kind and

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.

SLIDE 13

?

QUESTIONS

? ? ?

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