WIXLIB

Growing Pains PanelPresentation - FAOGSeptember 10, 2019 David Rosado@CandidDotOrg candid.org

What if EACH community foundationcould know what ALL communityfoundations collectively know?@CandidDotOrg candid.org

Table of contents1.Results of FAOG survey of members2.Appendix

Sample – 93 responsesRespondents in Each Asset Size Under 25 M to 50 M to 100 M 150 M 200 M 250 M 300 M 350 M 400 M 450 M 500 M 600 M 700 M 900 M 1 Billion 25 M under 50 under to under to under to under to under to under to under to under to under to under to under to under to underandM 100 M 150 M 200 M 250 M 300 M 350 M 400 M 450 M 500 M 600 M 700 M 800 M 1 Billion Above@CandidDotOrg candid.org

Number of full-time equivalents (FTEs)Asset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25M2223426 25M- 50M445710511 50M 100M4551011-15516 100M 250M51011-1516-2021-2511-1526 250M 500M1011-1516-2026-3031-4011-1516 500M- 1B16-2021-2541-4950 andabove50 andabove50 andabove8 1B31-4041-4950 andabove50 andabove50 andabove50 andabove10@CandidDotOrg candid.org

Number of fundsAsset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25M51-7576-100151-200151-200151-200151-2006 25M- 50M101-150201-250251-300251-300401-500251-30011 50M 100M25-50201-250301-400401-500601-700301-40016 100M 250M201-250401-500501-600701-800Over 1000601-70026 250M 500M251-300601-700801-900Over 1000Over 1000Over 100016 500M- 1B801-900Over 1000Over 1000Over 1000Over 1000Over 10008 1B9011000Over 1000Over 1000Over 1000Over 1000Over 100010@CandidDotOrg candid.org

Number of gifts processed annuallyAsset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25M 100101 - 250101 - 250501 - 7501501 - 2000101 - 2506 25M- 50M251 - 500 751 - 10001001 - 15001501 - 20001501 - 20001001 - 1500 11 50M 100M101 - 2501001 - 15001501 - 20007501 –10,0001001 - 1500 16 100M 250M251 - 500 1001 - 15002001 - 3000 2001 - 30007501 –10,0002001 300026 250M 500M101 - 2501501 - 20003001 - 4000 4001 - 5000 over 10,0002001 300016 500M- 1B1001 15001501 - 20003001 - 4000 over 10Kover 10,0002001 30008 1B751 10001501 - 20002001 - 3000 5001 - 7500over 10,0002001 300010751 - 1000@CandidDotOrg candid.org

Number of grants processed annuallyAsset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25M 50101 - 250101 - 250101 - 250101 - 250101 - 2506 25M- 50M251 - 500251 - 500251 - 500501 - 750751 - 1000251 - 50011 50M- 100M50 - 100251 - 500751 - 10001001 - 15001001 - 1500751 - 100016 100M- 250M501 - 750751 - 10001001 - 15002001 - 3000Over 50001001 - 150026 250M- 500M1001 - 15001501 - 20002001 - 30004001 - 5000Over 50002001 - 300016 500M- 1B2001 - 30004001 - 5000Over 5000Over 5000Over 5000Over 50008 1B1501 - 20004001 - 5000Over 5000Over 5000Over 5000Over 500010@CandidDotOrg candid.org

Total administrative budgetAsset Size RangeMin25th %Median75th %MaxModeNo. ofResponses 25M 250K 250K 250K - 500K 500K 750K 750K - 1M 250K6 25M- 50M 250K - 500K 250K 500K 500K - 750K 500K 750K 500K 750K 500K 750K11 50M- 100M 250K - 500K 500K 750K 750K - 1M 1M 1.5M 1.5M - 3M 750K - 1M16 100M- 250M 500K - 750K 1M - 1.5M 1.5M - 3M 1.5M 3M 3M - 5M 1.5M - 3M26 250M- 500M 1M - 1.5M 1.5M - 3M 1.5M - 3M 3M 5M 5M - 7.5M 1.5M - 3M16 500M- 1B 1.5M - 3M 1.5M - 3M 5M - 7.5M 7.5M 10M 7.5M 10M 7.5M 10M8 1B 250K - 500K 5M - 7.5M 10M 10M 10M 10M10@CandidDotOrg candid.org

FTEs and fundsNo. ofResponsesFTE RangeMin25th %Median75th 201-250301-400401-500801-900Over r 1000801-900921-25301-400501-600801-900901-1000Over 1000801-900626-30501-600601-700901-1000Over 1000Over 1000Over 1000431-50301-400801-900Over 1000Over 1000Over 1000Over 10007 50Over 1000Over 1000Over 1000Over 1000Over 1000Over 100011@CandidDotOrg candid.org

FTEs and gift transactionsNo. ofResponsesFTE RangeMin25th %Median75th %MaxMode1-3101 - 250101 - 250101 - 250751 - 10001501 - 200025-504-5Under 100501 - 7501001 - 15001001 - 15002001 - 3000151-200136-10501 - 7501001 - 15001501 - 20002001 - 30007501 - 10000151-2002111-15101 - 250751 - 10001501 - 20002001 - 30005001 - 7500201-2501716-20751 - 10001501 - 20003001 - 40004001 - 5000over 10000251-300921-251501 - 20002001 - 30004001 - 50005001 - 75007501 - 10000251-300626-302001 - 30002001 - 30003001 - 40007501 - 10000over 10000251-300431-50751 - 10001001 - 15002001 - 30004001 - 50005001 - 7500251-3007 50751 - 10001501 - 20002001 - 30005001 - 7500over 10000251-30011@CandidDotOrg candid.org5

FTEs and grant transactionsNo. ofResponsesFTE RangeMin25th %Median75th %MaxMode1-3Under 100101 - 250251 - 500251 - 500251 - 50051-754-5101 - 250501 - 750501 - 7501001 - 15001501 - 200076-100136-10501 - 750751 - 10001001 - 15001501 - 20003001 - 4000201-2502111-15501 - 7501001 - 15001501 - 20003001 - 40007501 - 10000301-4001716-201501 - 20001501 - 20003001 - 40005001 - 75007501 - 10000301-400921-25751 - 10001501 - 20004001 - 50007501 - 100007501 - 10000401-500626-302001 - 30003001 - 40007501 - 100007501 - 100007501 - 10000601-700431-503001 - 40004001 - 50005001 - 75007501 - 100007501 - 10000601-7007 502001 - 30005001 - 75007501 - 100007501 - 100007501 - 10000601-70011@CandidDotOrg candid.org5

Does your community foundation lease orown office space?LeaseLease some, own someOwn6%44%37%50%26%32%57%Under 100M 100- 500MOver 500M6%Under 100M 100- 500M42%Over 500M@CandidDotOrg candid.org

If lease, what is the current lease cost? 95K 228Kmedianon average (n 53)ThousandsMedianAverage 800K 740K 745K 700K 600K 500K 400K 356K 300K 218K 200K 100K 163K 16K 16K 26K 37K 25M 25M- 50M 34K 69K 92K 98K 116K 0K 50M- 100M 100M- 250M 250M- 500M 500M- 1B 1B@CandidDotOrg candid.org

If lease, what is the total square footage?5,3469,013medianon average (n 3015,00010,0005,9095,0001,819 1,8192,205 2,307 25M 25M- 50M8,1246,800 6,9365,4383,4540 50M- 100M 100M- 250M 250M- 500M 500M- 1B 1B@CandidDotOrg candid.org

If lease, what is the total cost per square foot? 16 21medianaverage (n 52)MedianAverage 60 50 50 38 40 30 20 17 11 20 17 11 11 10 13 15 19 15 15 18 0 25M 25M- 50M 50M- 100M 100M- 250M 250M- 500M 500M- 1B 1B@CandidDotOrg candid.org

Where is payroll processed?Payroll is outsourced to athird party providerPayroll is processed inhouse30%11%23%70%Under 100M37% 100- 500MOver 500M@CandidDotOrg candid.org

Where is payroll processed and whatplatforms do you use?6%Payroll is outsourced to athird party providerPayroll is processed inhouse3%30%20%ADPPaychexOther-13%Examples of other platforms RL70%35%15%6%ADPPaychexPEO PlatformOther@CandidDotOrg candid.org

Number of FTEs with HR ResponsibilitiesAsset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25M.1 to .25.1 to .25.1 to .25.1 to .25.1 to .25.1 to .256 25M- 50M.1 to .25.1 to .25.1 to .25.25 - .50.75-1.00.1 to .2511 50M- 100M .1 to .25.1 to .25.1 to .25.25 - .50More than 2 .1 to .2516 100M 250M.1 to .25.1 to .25.25 - .50.5 - .75.75-1.00.1 to .2526 250M 500M.1 to .25.1 to .25.25 - .50.75-1.001.25 - 2.1 to .2516 500M- 1B.1 to .25.5 - .751.25 - 21.25 - 21.25 - 21.25 - 28 1B.1 to .25.5 - .75More than 2 More than 2 More than 2 More than 210@CandidDotOrg candid.org

# of respondents with HR Director by asset size8731 25M 25M- 50M 50M- 100M 100M- 250M 250M- 500M 500- 1B 1B@CandidDotOrg candid.org

# of respondents with HR Director by FTE total10431-34-56-1011-151116-2021-2526-3031-50 50@CandidDotOrg candid.org

Number of investment poolsAsset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25M1122216 25M- 50M11225211 50M- 100M1246-10more than20116 100M- 250M 1346-106-106-1026 250M- 500M 1245more than20416 500M- 1B236-10more than20more than20more than208 1B24511-20more than20410@CandidDotOrg candid.org

Number of FTEs with investment managementoversight responsibilitiesAsset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25Mless than .5less than .5less than .512less than .56 25M- 50Mless than .5less than .5less than .511less than .511 50M- 100Mless than .5less than .5less than .512less than .516 100M- 250Mless than .5less than .5.5 to less than112.5 to less than261 250M- 500Mless than .5less than .5113116 500M- 1B.5 to less than1123338 1Bless than .53more than 3more than 3more than 3101@CandidDotOrg candid.org

Number of FTEs dedicated to technologyAsset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25Mless than .5less than .5less than .5less than .5less than .5less than .55 25M- 50Mless than .5less than .5less than .5.5 to lessthan 11less than .511 50M- 100Mless than .5less than .5less than .512less than .516 100M 250Mless than .5less than .5less than .5.5 to lessthan 11less than .525 250M 500Mless than .5less than .5.5 to lessthan 111less than .516 500M- 1Bless than .5.5 to lessthan 123more than 3 2 1B122more than 3 more than 3 2810@CandidDotOrg candid.org

Does your foundation outsource IT?14%86%NoYes@CandidDotOrg candid.org

Annual Cost of Outsourced IT 15K median 38Kon average (n 75)ThousandsAverageMedian 180K 164K 160K 150K 140K 120K 108K 100K 86K 80K 60K 40K 20K 28K 26K 4K 5K 8K 7K 16K 15K 15K 21K 0K 25M 25M- 50M 50M- 100M 100M- 250M 250M- 500M 500M- 1B 1B@CandidDotOrg candid.org

Annual amount spent on all ongoing technologyAsset SizeRangeMin25th %Median75th %MaxModeNo. ofResponses 25MLess than 50,000Less than 50,000Less than 50,000Less than 50,000Less than 50,000Less than 50,0006 25M- 50MLess than 50,000Less than 50,000Less than 50,000Less than 50,000 50,000 74,999Less than 50,00011 50M- 100MLess than 50,000Less than 50,000 50,000 74,999 50,000 74,999 100,000 149,999Less than 50,00016 100M- 250MLess than 50,000 50,000 74,999 75,000 99,999 100,000 149,999 150,000 199,999 100,000 149,99926 250M- 500MLess than 50,000 50,000 74,999 100,000 149,999 150,000 199,999 200,000 299,999 150,000 199,99916 500M- 1B 150,000 199,999 200,000 299,999 300,000and greater 300,000and greater 300,000and greater 300,000and greater8 1B 100,000 149,999 300,000and greater 300,000and greater 300,000and greater 300,000and greater 300,000and greater10@CandidDotOrg candid.org

Does your foundation have an Office Manager?49%51%NoYes@CandidDotOrg candid.org

Does your foundation have an Office Manager?12713797Yes569134 25M 25M- 50MNo73 50M- 100M 100M- 250M 250M- 500MAsset Size Range 500M- 1B 1B

Does your foundation have an Office -20# FTEs21-2526-3031-50 50

How many hats does your CEO wear?**(in addition to their core responsibilities)1.51.01.0 1.0List of roles: HR and/or payroll Investmentmanagementoversight Technology oversight Office Manager1.0 1.00.50.30.10.0 25M 25M- 50M0.00.00.0 50M- 100M 100M- 250M 250M- 500M 500M- 1BMedian0.1 1BAverageMax3242211Min1000000

How many hats does your CFO wear ?**(in addition to their core responsibilities)543.52.53.64 3.943.82.92.72.51.81 25M 25M- 50M 50M- 100M 100M- 250M 250M- 500M 500M- 1BMedian 1BAverageMax6666685Min0000110List of roles: HR and/or payroll Payables Gifts and other deposits Bank and/or investmentaccounts Journal entry and/ormonthly financialstatements Investment managementoversight Technology oversight Office Manager

Table of contents1.Results of FAOG survey of members2.Appendix

What payroll platforms do you 111111111111111-@CandidDotOrg candid.org

Individuals with technology oversightresponsibilities57%Number of staff titles containing “technology”: 18,or 34%33%17%13%8%3%OtherCFO or VP ofFinanceOffice ManagerDatabase ManagerCOO or VP ofOperations2%Chief Technology or VP of g candid.org

Title of staff with HR/payroll responsibilities-72.04%Examples of other titles:-Staff/Senior Accountant (18% of all “other)-Operations associate-Bookkeeper-Executive Assistant39.78%20.43%18.28%15.05%CFOOtherHR DirectorControllerCEO10.75%10.75%Office ManagerCOO@CandidDotOrg candid.org

Individuals with authority - sign checks and/orinitiate withdrawals or transfers99%53%52%18%President, CEO orExecutive DirectorCFO or VP of FinanceDesignated BoardMembersOther13%13%CFO/COO or VP ofFinance andOperationsCOO or VP ofOperations@CandidDotOrg candid.org