Skip to content
Nonprofiteer
← CONSTELLATION FUND

Form 990 for tax year 2022

Filed by CONSTELLATION FUND.

Totals

Total revenue
$6,538,143
Total expenses
$5,318,413
Contributions and grants received
$6,778,970
Grants paid
$3,480,000
Program service revenue
$0
Investment income
-$6,901
Other revenue
-$233,926
Total assets, end of year
$9,015,015
Total liabilities, end of year
$400,617
Net assets or fund balances, end of year
$8,614,398
Program services expenses (Part IX)
$4,350,717
Management and general expenses
$411,697
Fundraising expenses
$555,999
Program service expenses (Part III)
$4,350,717

Program services were 81.8% of total expenses calculated — Part IX's program-services column over total expenses, both as filed.

Line items

Every line the filer filed in Parts VIII, IX and X, as filed and in filed order. Blank columns are left out, and the lines are not forced to add up to the totals above.

Revenue

Part VIII, the statement of revenue.

  • 1c · Fundraising events

    $425,891

  • 1f · All other contributions, gifts and grants

    $6,353,079

  • 1g · Noncash contributions included above

    $476,675

  • 3 · Investment income

    total $987 · excluded $987

  • 7a · Gross sales of assets other than inventory

    securities $1,046,754

  • 7b · Less cost or other basis and sales expenses

    securities $1,054,642

  • 7c · Gain or loss

    securities -$7,888

  • 7d · Net gain or loss

    total -$7,888 · excluded -$7,888

  • 8a · Fundraising events: gross income

    $0

  • 8a · Fundraising events: contributions included on line 1c

    $425,891

  • 8b · Fundraising events: direct expenses

    $233,926

  • 8c · Net income from fundraising events

    total -$233,926 · excluded -$233,926

Functional expenses

Part IX, the statement of functional expenses.

  • 1 · Grants to domestic organizations and governments

    total $3,480,000 · program services $3,480,000

  • 5 · Compensation of officers, directors and key employees

    total $639,422 · program services $404,754 · management and general $98,471 · fundraising $136,197

  • 7 · Other salaries and wages

    total $689,841 · program services $335,516 · management and general $82,886 · fundraising $271,439

  • 8 · Pension plan contributions

    total $10,054 · program services $8,169 · fundraising $1,885

  • 9 · Other employee benefits

    total $30,556 · program services $3,170 · management and general $2,937 · fundraising $24,449

  • 10 · Payroll taxes

    total $91,643 · program services $58,010 · management and general $14,113 · fundraising $19,520

  • 11b · Fees: legal

    total $2,668 · program services $2,255 · management and general $413

  • 11c · Fees: accounting

    total $54,197 · management and general $54,197

  • 11g · Fees: other

    total $107,104 · program services $7,415 · management and general $99,689

  • 12 · Advertising and promotion

    total $3,258 · management and general $3,258

  • 13 · Office expenses

    total $6,238 · program services $282 · management and general $5,075 · fundraising $881

  • 16 · Occupancy

    total $61,373 · program services $35,179 · management and general $8,318 · fundraising $17,876

  • 17 · Travel

    total $30,456 · program services $10,776 · management and general $19,038 · fundraising $642

  • 19 · Conferences, conventions and meetings

    total $2,864 · management and general $2,864

  • 23 · Insurance

    total $4,533 · program services $44 · management and general $4,489

  • 24a · Other expenses: Meetings and events

    total $72,424 · fundraising $72,424

  • 24b · Other expenses: Dues and subscriptions

    total $19,908 · program services $1,506 · management and general $12,257 · fundraising $6,145

  • 24c · Other expenses: Equipment

    total $6,940 · program services $3,596 · management and general $3,344

  • 24d · Other expenses: Bank charges

    total $4,934 · program services $45 · management and general $348 · fundraising $4,541

Balance sheet

Part X, book values.

  • 1 · Cash, non-interest-bearing

    beginning of year $156,284 · end of year $163,156

  • 2 · Savings and temporary cash investments

    beginning of year $4,518,236 · end of year $5,284,228

  • 3 · Pledges and grants receivable

    beginning of year $3,621,568 · end of year $3,269,328

  • 4 · Accounts receivable

    beginning of year $1,374

  • 9 · Prepaid expenses and deferred charges

    beginning of year $13,801 · end of year $10,892

  • 11 · Investments: publicly traded securities

    beginning of year $254,078 · end of year $279,109

  • 15 · Other assets

    beginning of year $15,738 · end of year $8,302

  • 17 · Accounts payable and accrued expenses

    beginning of year $16,411 · end of year $20,617

  • 18 · Grants payable

    beginning of year $1,170,000 · end of year $380,000

  • 27 · Net assets without donor restrictions

    beginning of year $464,065 · end of year $589,464

  • 28 · Net assets with donor restrictions

    beginning of year $6,930,603 · end of year $8,024,934

Mission and programs · 2022

Mission

Fight poverty in the Twin Cities by raising the living standards of individuals living below the poverty line in our seven-county metropolitan area.

  • The Constellation Fund is built to harness the incisive power of modern analytics alongside on-the-ground insights to allocate precious philanthropic resources to the people and partners creating the most impact in the fight against poverty in the Twin Cities. We use quantitative metrics alongside qualitative analysis to select our grantee partners. Our metrics are built using the best available evidence to develop metrics that allow Constellation to reliably project the long-term quality-of-life impact of poverty-fighting services resulting in a benefit-cost ratio used to help objectively build a portfolio of the most impactful nonprofits across a broad spectrum of programs and interventions. In fiscal year 2023, this approach led Constellation to invest over $3.2 million into 31 poverty-fighting nonprofits working across four impact areas education, employment, health, and housing. Constellation's evidence-driven analysis projects that these nonprofits will turn every dollar of that investment into an average of $4.70 of lifetime health and income improvements for individuals and families experiencing poverty in our community. The average projected impact of the nonprofits receiving Constellation funding last year was more than three times greater than the average of $1.51-to-1 for all other organizations that we evaluated in 2021.The Constellation Fund continues to expand the reach of our signature capacity building program, Beyond Dollars. Beyond Dollars creates best-in-class pro bono experiences through curated teams of volunteer employees from Fortune 500 corporations to mid-sized companies, who deliver unparalleled capacity-building services to our impactful nonprofit partners.

    Expenses $4,350,717 · Grants $3,480,000

As filed on the 2022 return. The filer continues this part on Schedule O, which is not shown here.

Listed in Part VII

  • Andrew Dayton

    CEO/Treasurer/Secretary

    Total calculated
    $0
    Hours/week
    40
  • Tim Welsh

    Board Chairperson

    Total calculated
    $0
    Hours/week
    0.5
  • Eric Dayton

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Wendy Nelson

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Marcia Page

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Lynne Redleaf

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Susan Bass Roberts

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Pahoua Yang Hoffman

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • John O'Neil

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Armando Camacho

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Dr Fayneese Miller

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Katie Clark Seiben

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Susan Corridoni

    Board Member

    Total calculated
    $0
    Hours/week
    0.5
  • Saanii Hernandez

    Chief Operating Officer

    Total calculated
    $179,494
    From this org
    $160,086
    From related orgs
    $0
    Other
    $19,408
    Hours/week
    40

    Schedule J breakdown matched by us

    Base
    $160,086
    Bonus
    $0
    Other
    $0
    Deferred
    $0
    Nontaxable benefits
    $19,408
    Filer's total
    $179,494
  • Ryan Petersen

    Chief Advancement Officer

    Total calculated
    $162,296
    From this org
    $142,483
    From related orgs
    $0
    Other
    $19,813
    Hours/week
    40

    Schedule J breakdown matched by us

    Base
    $142,483
    Bonus
    $0
    Other
    $0
    Deferred
    $0
    Nontaxable benefits
    $19,813
    Filer's total
    $162,296
  • Jose Diaz PhD

    Chief Economist

    Total calculated
    $129,286
    From this org
    $125,000
    From related orgs
    $0
    Other
    $4,286
    Hours/week
    40
  • Sandy Carr

    Chief Impact Officer

    Total calculated
    $120,225
    From this org
    $115,610
    From related orgs
    $0
    Other
    $4,615
    Hours/week
    40

Compensation is as filed in Part VII: reportable pay from this organization and from related organizations, other compensation, and hours per week. The total, marked calculated, is our sum of the three dollar columns, with a blank column counted as $0; the form itself has no total. On a Form 990-EZ the columns are Part IV's instead, and on a Form 990-PF Part VIII's — compensation, contributions to benefit plans, and expense account — and the total sums those. A Schedule J breakdown is as filed: base pay, bonus, other, deferred compensation and nontaxable benefits from this organization, with any from related organizations beside each, and the filer's own total. It is shown with the Part VII listing of the same name on the same return. The form gives no key between the two, so that pairing is ours, and is marked matched by us.

Schedule J

Answered yes

  • 3 · Approval by the board or compensation committee

Answered no

  • 4a · Severance or change-of-control payment
  • 4b · Supplemental nonqualified retirement plan
  • 4c · Equity-based compensation arrangement
  • 5a · Pay contingent on this organization's revenues
  • 5b · Pay contingent on a related organization's revenues
  • 6a · Pay contingent on this organization's net earnings
  • 6b · Pay contingent on a related organization's net earnings
  • 7 · Other non-fixed payments
  • 8 · Paid under the initial-contract exception

Part I's answers as filed. A line not listed was left unanswered; on lines 1a and 3 that means the box was not checked.

Grants on this return

The 10 largest by cash amount. The API serves every itemized grant.

Provenance

Return type
form_990
Tax year
2022
Filed
5 December 2023
IRS schema version
2022v5.0
Source object
202333559349301218

Check it against the return as filed: the GivingTuesday Data Lake hosts a public copy of the original XML.

The source document this was parsed from is served over the API, which is where bulk and document access live.