Civic Intelligence

Constellation Charitable Foundation

990PF • Fiscal year 2020 • EIN 04-3584076

Jul 01, 2019 to Jun 30, 2020

Cambridge, MA
Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

17th percentile

0.00x

Higher debt load relative to assets than 17% of similar nonprofits.

2020 filings • $25M-$50M nonprofits • Source year 2020

Liabilities / Revenue

21st percentile

0.02x

Higher debt load relative to revenue than 21% of similar nonprofits.

2020 filings • $25M-$50M nonprofits • Source year 2020

Net Margin

4th percentile

-164%

Higher net margin than 4% of similar nonprofits.

2020 filings • $25M-$50M nonprofits • Source year 2020

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2020

Asset Growth

21st percentile

-1.8%

Faster asset growth than 21% of similar nonprofits.

2020 filings • $25M-$50M nonprofits • Annualized from 2019 to 2020

Revenue Growth

1st percentile

-98%

Faster revenue growth than 1% of similar nonprofits.

2020 filings • $25M-$50M nonprofits • Annualized from 2019 to 2020

Assets

Down

$41,481,823

Down $773,077 (-1.8%) from 2019

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

Up

$11,791

Up $9,060 (+332%) from 2019

Revenue

Down

$665,359

Down $36,794,593 (-98%) from 2019

Expenses

Up

$1,759,737

Up $947,340 (+117%) from 2019

Net Income

Down

-$1,094,378

Down $37,741,933 (-103%) from 2019

Historical Trend

Balance Sheet Trend

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$60M$40M$20M$0Assets 2011: $13,048,678Liabilities 2011: $8,340,000Net Assets 2011: $4,708,6782011Assets 2012: $13,262,740Liabilities 2012: $8,340,000Net Assets 2012: $4,922,7402012Assets 2013: $13,496,835Liabilities 2013: $8,340,000Net Assets 2013: $5,156,8352013Assets 2014: $13,592,030Liabilities 2014: $8,340,000Net Assets 2014: $5,252,0302014Assets 2015: $13,733,045Liabilities 2015: $8,340,000Net Assets 2015: $5,393,0452015Assets 2016: $13,758,402Liabilities 2016: $8,340,000Net Assets 2016: $5,418,4022016Assets 2017: $13,834,052Liabilities 2017: $8,415,655Net Assets 2017: $5,418,3972017Assets 2018: $13,995,673Liabilities 2018: $8,579,162Net Assets 2018: $5,416,5112018Assets 2019: $42,254,900Liabilities 2019: $2,731Net Assets 2019: $42,252,1692019Assets 2020: $41,481,823Liabilities 2020: $11,7912020Assets 2021: $40,953,030Liabilities 2021: $0Net Assets 2021: $40,953,0302021Assets 2022: $39,649,707Liabilities 2022: $10,015,767Net Assets 2022: $29,633,9402022Assets 2023: $39,418,912Liabilities 2023: $9,509,218Net Assets 2023: $29,909,6942023Assets 2024: $39,864,029Liabilities 2024: $5,205,721Net Assets 2024: $34,658,3082024

Highlighted filing

2020

Assets$41,481,823
Liabilities$11,791
Net Assets-

Operations Trend

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$40M$30M$20M$10M$0-$10MRevenue 2011: $355,660Expenses 2011: $24,747Net Income 2011: $330,9132011Revenue 2012: $291,755Expenses 2012: $77,693Net Income 2012: $214,0622012Revenue 2013: $253,529Expenses 2013: $19,434Net Income 2013: $234,0952013Revenue 2014: $115,590Expenses 2014: $20,395Net Income 2014: $95,1952014Revenue 2015: $151,301Expenses 2015: $10,286Net Income 2015: $141,0152015Revenue 2016: $33,932Expenses 2016: $8,575Net Income 2016: $25,3572016Revenue 2017: $9,760Expenses 2017: $9,765Net Income 2017: -$52017Revenue 2018: $7,460Expenses 2018: $9,346Net Income 2018: -$1,8862018Revenue 2019: $37,459,952Expenses 2019: $812,397Net Income 2019: $36,647,5552019Revenue 2020: $665,359Expenses 2020: $1,759,737Net Income 2020: -$1,094,3782020Revenue 2021: $670,433Expenses 2021: $518,825Net Income 2021: $151,6082021Revenue 2022: $800,146Expenses 2022: $516,967Net Income 2022: $283,1792022Revenue 2023: $882,663Expenses 2023: $1,119,394Net Income 2023: -$236,7312023Revenue 2024: $1,268,156Expenses 2024: $1,622,891Net Income 2024: -$354,7352024

Highlighted filing

2020

Revenue$665,359
Expenses$1,759,737
Net Income-$1,094,378
Filing Detail Status

This 2020 filing currently has summary financial data only. Detailed schedules, leadership, and program rows are not available for this filing yet.

Jump To
Filing Snapshot
Filing Period
Jul 1, 2019 to Jun 30, 2020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$39.9$5.21$34.7$1.27$1.62$0.35
2023Detailed filing. Detailed filing data is available for this year.$39.4$9.51$29.9$0.88$1.12$0.24
2022Detailed filing. Detailed filing data is available for this year.$39.6$10.0$29.6$0.80$0.52$0.28
2021Detailed filing. Detailed filing data is available for this year.$41.0$0.00$41.0$0.67$0.52$0.15
2020Summary only. Only limited summary data is available for this year.$41.5$0.01$0.67$1.76$1.09
2019Summary only. Only limited summary data is available for this year.$42.3$0.00$42.3$37.5$0.81$36.6
2018Summary only. Only limited summary data is available for this year.$14.0$8.58$5.42$0.01$0.01$0.00
2017Summary only. Only limited summary data is available for this year.$13.8$8.42$5.42$0.01$0.01$0.00
2016Summary only. Only limited summary data is available for this year.$13.8$8.34$5.42$0.03$0.01$0.03
2015Summary only. Only limited summary data is available for this year.$13.7$8.34$5.39$0.15$0.01$0.14
2014Summary only. Only limited summary data is available for this year.$13.6$8.34$5.25$0.12$0.02$0.10
2013Summary only. Only limited summary data is available for this year.$13.5$8.34$5.16$0.25$0.02$0.23
2012Summary only. Only limited summary data is available for this year.$13.3$8.34$4.92$0.29$0.08$0.21
2011Summary only. Only limited summary data is available for this year.$13.0$8.34$4.71$0.36$0.02$0.33