Civic Intelligence

Constellation Charitable Foundation

990 • Fiscal year 2012 • EIN 04-3584076

Jul 01, 2011 to Jun 30, 2012

Cambridge, MA
Siviq Scores

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

Liabilities / Assets

80th percentile

0.63x

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

2012 filings • $10M-$25M nonprofits • Source year 2012

Liabilities / Revenue

99th percentile

28.59x

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

2012 filings • $10M-$25M nonprofits • Source year 2012

Net Margin

92nd percentile

73%

Higher net margin than 92% of similar nonprofits.

2012 filings • $10M-$25M nonprofits • Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

48th percentile

1.6%

Faster asset growth than 48% of similar nonprofits.

2012 filings • $10M-$25M nonprofits • Annualized from 2011 to 2012

Revenue Growth

21st percentile

-18%

Faster revenue growth than 21% of similar nonprofits.

2012 filings • $10M-$25M nonprofits • Annualized from 2011 to 2012

Assets

Up

$13,262,740

Up $214,062 (+1.6%) from 2011

Net Assets

Up

$4,922,740

Up $214,062 (+4.5%) from 2011

Liabilities

Flat

$8,340,000

Flat from 2011

Revenue

Down

$291,755

Down $63,905 (-18%) from 2011

Expenses

Up

$77,693

Up $52,946 (+214%) from 2011

Net Income

Down

$214,062

Down $116,851 (-35%) from 2011

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

2012

Assets$13,262,740
Liabilities$8,340,000
Net Assets$4,922,740

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

2012

Revenue$291,755
Expenses$77,693
Net Income$214,062
Filing Detail Status

This 2012 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, 2011 to Jun 30, 2012

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