This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've gone with "The Denver Health and Hospitals Foundation", like others there seems to be a bit of confusion over the fundraising efficiency calculation. In the documentation it states it is calculated as
(When Calculating Using Form 990) = Average of Part IX line 25D ÷ Average of Part VIII line 1h
I couldn't find a line 25D in the data, so took what I considered the closest one which is "Total functional expenses" which appears in Part IX line 25(A)
Step 1: read and parse all files (17eofinextract990 and pub78), save to .yxdb for faster access. Step 2: determine agencies that fit criteria specified. Step 3: read and parse 2 previous year files (16eofinextract990 and 15eofinextract990), save to yxdb for faster access. Step 4: determine averages of lessdirfndrang and totcntrbgfts for all agencies in step 2 over last 3 years ('15, '16, '17). Step 5: calculate efficiencies for all agencies: avg_lessdirfndrang/avg_totcntrbgfts. Step 6: sort efficiencies in ascending order for top agency.