2024-07-08T09:21:36-07:00 2023-12-31 990 2023-01-01 352036110 DEARBORN COMMUNITY FOUNDATION INC DEAR 8125394115 322 Walnut Street Lawrenceburg IN 47025 Fred McCarter Executive Director 8125394115 2024-07-08 Fred McCarter 999009999 1 1 11 0 AAL2 X 2023 2023-04-26 12:10:37Z Jon Strautman Board President 322 Walnut Street Lawrenceburg IN 47025 4878280 0 X www.dearborncf.org X 1997 IN The Dearborn Community Foundation, Inc. is a catalyst to connect people who care with causes that improve the quality of life in our community by advancing cultural, educational and social opportunities, while preserving our community's heritage and helping donors to create a permanent legacy in Dearborn County. 15 15 4 50 0 0 1476105 2127331 0 0 1057963 916861 103216 55722 2637284 3099914 1446079 1192754 0 0 236534 264665 0 0 119405 167941 182184 1850554 1639603 786730 1460311 25543905 29333321 9000219 9998072 16543686 19335249 The Dearborn Community Foundation, Inc. is a catalyst to connect people who care with causes that improve the quality of life in our community by advancing cultural, educational and social opportunities, while preserving our community's heritage and helping donors to create a permanent legacy in Dearborn County. 0 0 1437211 1192754 0 The Dearborn Community Foundation awarded 334 grants and scholarships. Grants were awarded to non-profit organizations for the purpose of enhancing the Dearborn County Community and scholarships were awarded to local students for the purpose of furthering their education. 0 0 0 1437211 1 1 0 0 0 1 0 0 1 1 1 0 0 0 1 1 1 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 6 0 1 4 1 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 X 15 15 1 0 0 0 0 0 0 1 1 0 0 1 1 1 1 1 1 1 0 0 IN X Dearborn Community Foundation 8125394115 322 Walnut Street Lawrenceburg IN 47025 Fred McCarter Executive Director 40.0 0.00 X X 110156 0 9890 Ed Gordon Chairperson 3.0 0.0 X X 0 0 0 Michael McLaughlin President 3.0 0.0 X X 0 0 0 Jon Strautman Vice-President 3.00 2.00 X X 0 0 0 Lisa Moorhead Secretary 3.0 0.0 X X 0 0 0 Bridget Davidson Treasurer 3.0 0.00 X X 0 0 0 Becky Lyons Director 2.0 0 X 0 0 0 James Stock Director 2.0 0.0 X 0 0 0 Jeanne Lehn Director 2.0 0 X 0 0 0 Michael Hollenbeck Director 2.0 0.0 X 0 0 0 Ramzi Nuseibeh Director 2.0 0 X 0 0 0 Larry Campbell Director 2.0 0 X 0 0 0 Jan Tyler Director 2.0 0.0 X 0 0 0 Linda Gellert Director 2.00 0 X 0 0 0 Dave Lusby Director 2 0 X 0 0 0 Casey Finnegan Director 2.0 0.0 X 0 0 0 110156 0 9890 1 0 0 0 0 0 0 16493 0 1035335 1075503 5918 2127331 0 864825 0 0 864825 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1804588 0 1752552 0 52036 0 52036 0 0 52036 17460 16493 25814 -8354 0 -8354 0 0 0 0 0 0 0 0 0 0 0 0 Administrative Fee 900099 56868 56868 0 0 Change in Value of Split Interest Agreement 900099 7208 0 0 7208 0 0 0 0 64076 3099914 56868 0 915715 979786 979786 212968 212968 0 0 0 0 119446 47778 11945 59723 0 0 0 0 118352 72677 28986 16689 0 0 0 0 9327 5203 2554 1570 17540 7016 4385 6139 0 0 0 0 4973 995 1492 2486 11050 0 11050 0 0 0 0 0 0 0 76279 76279 0 0 0 0 0 0 8510 1702 1702 5106 7783 3112 1559 3112 17805 7122 3561 7122 0 0 0 0 15725 6290 4718 4717 617 186 123 308 0 0 0 0 1018 305 204 509 0 0 0 0 0 0 0 0 5498 2199 1650 1649 5005 1251 2503 1251 Printing 8760 3504 1752 3504 Donor Development 1848 0 0 1848 Scholarship Promotion/Admin 5981 5981 0 0 11332 2857 4803 3672 1639603 1437211 82987 119405 4984 6955 4088504 4687987 0 0 0 0 0 0 0 0 0 0 0 0 0 0 148954 143296 11156 5658 20803141 24034496 0 0 0 0 0 0 636120 598225 25543905 29333321 10876 13225 0 0 0 60000 0 0 8949595 9888766 0 39748 36081 9000219 9998072 X 2159634 2506553 14384052 16828696 16543686 19335249 25543905 29333321 X 1460311 2375423 0 0 0 -1044171 X 0 1 X 1 0 X 2150499 1231660 1407990 1476105 2127331 8393585 0 0 0 0 0 0 0 0 0 0 0 0 2150499 1231660 1407990 1476105 2127331 8393585 309813 8083772 674173 468522 914412 715783 864825 3637715 0 0 0 0 0 89610 59797 53545 103216 55722 361890 12393190 0 0.65228 0.68243 X Schedule A, Part II, Line 1 Unusual Grants and Contributions not included in Line 1 - 2019 - 1)$100,000 2) $455,066 3) $290,763 2020 1) $109,000 2) $100,000 2021 1) $421,057 2) $74,824 3) $30,000 4) $634,537 Schedule A, Part II, Line 10 Other Income - This line includes primarily administrative fees received, fundraiser net, and Change in Value of Split Interest Agreements. RESTRICTED RESTRICTED RESTRICTED RESTRICTED RESTRICTED RESTRICTED RESTRICTED RESTRICTED 22 0 125646 0 69684 0 4481162 0 1 1 0 1 X 14591186 961738 2158281 231617 0 256906 17222682 16740256 319605 -1997006 206622 0 265047 14591186 13690026 1059808 2439663 193411 0 255830 16740256 12786875 169434 1105965 164335 0 207913 13690026 10301590 804440 2042454 171194 0 190415 12786875 0.056 0.944 0 0 0 0 0 0 0 0 0 0 0 107902 106815 1087 0 41052 36481 4571 0 0 0 0 5658 0 Charitable Gift Annuity Payable 3885 Operating Lease Liability 32196 36081 X 3644247 2375423 0 0 389201 2764624 879623 76279 2144012 2220291 3099914 852684 0 0 0 256906 256906 595778 76279 967546 1043825 1639603 Schedule D, Part IV, Line 2b The organization's amount on Form 990 Part X Line 21 consists of two components. The first is the liability for funds held as agency endowments which represent funds placed on deposit with the Organization by other organizations based on their individual board resolutions. The second component is custodial funds that represent non-permanent grant programs. The Organization accounts for these transfers as a liability in accordance with applicable accounting standards. Schedule D, Part V, Line 4 The Organization's endowment funds are used to support charitable organizations that promote improvement in the quality of life in Dearborn County. Schedule D, Part X, Line 2 FIN 48 (ASC 740) The Organization is organized as a not-for-profit corporation under Section 501(c)(3) of the United States Internal Revenue Code. Accounting principles generally accepted in the United States of America require management to evaluate tax positions taken by the Organization and recognize a tax liability if the Organization has taken an uncertain position that more likely than not would not be sustained upon examination by various federal and state taxing authorities. Management has analyzed the tax positions taken by the Organization, and has concluded that as of December 31, 2023 and 2022, there are no uncertain positions taken or expected to be taken that would require recognition of a liability or disclosure in the accompanying financial statements. The Organization is subject to routine audits by taxing jurisdictions; however, there are currently no audits for any tax periods in progress. As such, the Organization is generally exempt from income taxes. However, the Organization is required to file Federal Form 990 - Return of Organization Exempt from Income Tax which is an informational return only. Schedule D, Part XI, Line 2d Endowment Administrative Fees that are interfund transactions. Schedule D, Part XI, Line 4b Other - net out to $2,144,012 - Other amounts included in Form 990 Part VIII Line 12 but not on Line 1 of Schedule D Part XI - 1) FASB Accounting Standards Codification (ASC) Not for Profits 958-605-55 Agency and Custodial Transactions that are reflected as adjustments to the liability and are not reflected in the Statement of Activities in the audited financial statements in accordance with accounting standards $2,169,826 and 2) Direct Fundraising expenses from Form 990 Part VIII Line 8 that are subtracted from revenues on Form 990 but are recorded as an expense and not netted against revenues in the audited financial statements $25,814. Schedule D, Part XII, Line 2d Endowment Administrative Fees that are interfund transactions. Schedule D, Part XII, Line 4b 1) Included in Form 990 Part IX Line 25 - (Total Functional Expenses) but not on Line 1 of Schedule D Part XII - 1) FASB Accounting Standards Codification (ASC) Not for Profits 958-605-55 Agency and Custodial Transactions that are reflected as adjustments to the liability and are not reflected in the Statement of Activities in the audited financial statements in accordance with accounting standards $993,360 and 2) Included in Sch D Part XII Line 1 but not in Line 25 of Form 990 Part IX Total Functional Expenses - Direct Fundraising expenses from line Form 990 Part VIII Line 8 subtracted from revenues in Form 990 that are recorded as an expense and not netted against revenues in the audited financial statements $25,814. 3) The two amounts (993,360 - 25,814) net out to $967,546 which equals Sch D Part XII Line 4b. Annual Golf Scramble 23828 14418 9410 0 2030 5000 2376 0 462 25th Anniversary Dinner 10125 2075 8050 0 1461 1618 10287 400 2180 0 33953 16493 17460 0 3491 6618 12663 400 2642 25814 -8354 1 All Saints Parish 25743 State Rt 1 Guilford IN 47022 351813863 3 12285 Parish Outreach Programs and Endowment Distribution City of Aurora 235 Main Street Aurora IN 47001 356000945 3 69327 Fire Dept Needs and Endowment Distribution Dearborn County Clearing House for Emergency Aid Inc PO Box 478 Aurora IN 47001 311158133 3 6346 Needs of the Organization, food & hygiene items & Endow Dist Dearborn County Historical Society Inc 508 West High Street Lawrenceburg IN 47025 351695394 3 11513 Furnace replacement, tech needs & Endow Dist Dearborn County Parks Foundation Inc 229 Main Street Aurora IN 47001 366000137 3 5583 Endowment Distribution Dearborn County Retired Teachers Foundation Inc 331 Abby Lane Batesville IN 47006 900911957 3 6766 Needs of Organization & Endow Dist Dearborn County Government 165 Mary Street Lawrenceburg IN 47028 356000137 3 68950 Endowment Distribution & JCAP Program Dillsboro Summer Recreation Inc PO Box 188 Dillsboro IN 47018 351824897 3 9000 Youth Baseball Programs & AED First Baptist Church of Moores Hill 16603 South Broadway Road Moores Hill IN 47032 351594402 3 25000 Roof Replacement of Historic Church Building Heart House Inc 6815 US 50 Aurora IN 47001 352036398 3 5500 Needs of the organization & Youth needs Hillforest Historical Foundation 213 Fifth Street Aurora IN 47001 351078976 3 17471 Endowment Dist & Youth Programs Ivy Tech Foundation 50 W Fall Creek Parkway North Dr Indinapolis IN 46208 237073977 3 61464 Streets Smart De-escalation Virtual Reality Training System & Endow Dist Lawrenceburg Babe Ruth Baseball 3018 Montclair Avenue Cincinnati OH 45211 352130130 3 8000 Youth Baseball Program Lawrenceburg Greendale Soccer Club 1161 Carroll Ave Greendale IN 47025 352131447 3 7262 Youth Soccer Program Equipment Lawrenceburg Community School Corporation 300 Tiger Blvd Lawrenceburg IN 47025 351147459 3 153419 Educational needs of Lawrenceburg Community Schools Laughery Valley Fraternal Order of Police Lodge 146 P O Box 3763 Lawrenceburg IN 47025 237585573 8 8568 Kids and Cops Program Lawrenceburg Lions Club 555 Tanner Avenue Lawrenceburg IN 47025 356063756 4 8000 Youth Baseball Program Lawrenceburg Main Street Inc 320 Walnut Street Lawrenceburg IN 47025 200456048 3 14950 Winter Wonderland Event Lawrenceburg Pee Wee Football 423 Walnut Street Lawrenceburg IN 47025 352077577 3 8000 Youth Football Program Equipment LifeTime Resources Inc 13091 Benedict Dr Dillsboro IN 47018 352076514 3 41369 Handicap Vehicles, Catch-A-Ride Program Fuel Costs, Endow Dist. Moores Hill Food Pantry Inc PO Box 215 Moores Hill IN 47032 300655678 3 6000 Needs of Organization and Food & Hygiene Items New Horizons Rehabilitation Inc P O Box 98 Batesville IN 47006 351169221 3 6509 Endowment Distribution North Dearborn Pantry Incorporated 2517 North Dearborn Rd West Harrison IN 47060 364598281 3 7513 Needs of the organization, food and hygiene items and Endowment Distribution Pregnancy Care Center 62 Doughty Rd Suite 5 Lawrenceburg IN 47025 351810708 3 8485 Needs of the organization, Baby care items and, Endowment Distribution Ross Foundation Inc P O Box 457 Dillsboro IN 47018 351796129 3 29249 Endowment Distribution South Dearborn Dollars For Scholars P O Box 396 Aurora IN 47001 042296967 3 19335 Endowment Distribution Southeastern Indiana Economic Opportunity Corporation 110 Importing Street Aurora IN 47001 351118476 3 6000 Covering Kids and Families Program and Emergency Aid for clients St Elizabeth Foundation 1 Medical Village Drive Ft Mitchell KY 41017 610445850 3 7018 New Dearborn Cancer Center and Endowment Distribution St John Ev Lutheran Church & School 222 Mechanic Street Aurora IN 47001 351049620 3 7545 Needs of the School and Endowment Distribution St Teresa Catholic Church 23345 Gavin Lane Lawrenceburg IN 47025 352083054 3 35000 Playground equipment St Vincent de Paul P O Box 22 Aurora IN 47001 310537510 3 6000 Needs of the Organization and Food and Hygiene Items Town of Dillsboro 13030 Executive Drive Dillsboro IN 47018 356004970 3 8178 Friendship Gallery Upgrades and Endowment Distribution Town of Moores Hill 16610 N Broadway Moores Hill IN 47032 351123470 3 6623 Park Upgrade and Endowment Distribution Trojans Youth Football Inc P O Box 40 Guilford IN 47022 351993885 3 8000 Youth Football Program Equipment Youth Encouragement Services Inc 11636 County Farm Rd Aurora IN 47001 310991515 3 9673 Needs of the organization and youth residents and Endowment Distribution Aurora Lions Club 110 Second Street Aurora IN 47001 356063310 4 30000 114th Aurora Farmers Fair 33 3 Scholarships 146 212968 0 Schedule I, Part I, Line 2 Dearborn Community Foundation requires recipients to provide a final grant report within 6 months of the grant award date. The final grant report includes all necessary documentation to ascertain the proper use of grant funds in accordance with the grant agreement. The grant agreement is signed by an authorized representative of the organization as well as an authorized representative of the Dearborn Community Foundation before funds are released to the grantee organization. The grant agreement specifically and clearly expresses the purpose of the grant. All unused grant funds must be returned to the Foundation by the grantee. Form 990, Part VI, Section A, Line 2 Board member Dave Lusby and Board member Becky Lyons are cousins. Form 990, Part VI, Section B, Line 11b The Foundation's Executive Director, Treasurer and Accountant review the 990 and then they review and explain the 990 with the entire Board of Directors prior to filing the return. Form 990, Part VI, Section B, Line 12c Each year the policy is distributed to each employee, Board and committee member. Everyone must then review the policy and disclose any conflicts of interest. If there are none then they must state that. Everyone also signs the form and submits the signed form back to the Foundation where is reviewed by staff and kept on file. At meetings, everyone is reminded to abstain from voting when there is a conflict of interest. If the conflict is interest is due to a family member, for example with a scholarship, the Board member leaves during the voting process. Additionally, grant committee members excuse themselves from the meeting when there is a grant in which a conflict of interest exists. DCF legal counsel provides a verbal explanation of conflict of interest and the parties that must be disclosed on the form at a Board meeting early in the year. Form 990, Part VI, Section B, Line 15 The Executive Director determines the compensation for all employees except for himself. Employees are reviewed annually and at that time compensation is also discussed. The. Executive Director's compensation is first determined by the Executive Committee subject to review and approval by the entire DCF Board at a subsequent meeting. The Executive Committee reviews the Executive Director's performance annually. Compensation is determined based on performance in relation to goals that were set in the prior year evaluation by the Executive Committee, experience of the Executive Director, and compensation data for similar organizations and and those with a comparable scope of responsibility at a regional, state and national level. Once compensation is determined by the Executive Committee, it is brought before the entire Board of Directors and voted on in a executive session of the Board. The review and decision are recorded in executive session minutes of both the Executive Committee and Board of Director's Board meetings. Form 990, Part VI, Section C, Line 19 The Organization makes its governing documents, conflict of interest policy and audited financial statements available to the public upon request. Form 990, Part XI, Line 9 Other changes in net assets consist of ASC 958 adjustments for agency endowments and custodial liabilities. Agency and Custodial activity is recorded in revenues (line 1 of Part XI), expenses (line 2 Part XI) and unrealized gains (losses) (Line 5 of Part XI) on Form 990 but in the financial statements are reflected as adjustments to the liability accounts and are not reflected as revenue and expenses in the Statement of activities in accordance with accounting standards. However, there was an interfund custodial grant that was included in the change in the liability account but the corresponding interfund revenue was not included in the 990 since it was not new revenue and overall, for the organization has zero impact on net assets as it was more of a movement of assets within the organization.