Civic Intelligence

Midnight Sun Inc VII Co Ubs Farmland Investors LLC

990 • Fiscal year 2017 • EIN 80-0198669

Jul 01, 2016 to Jun 30, 2017

Organization ProfileN/A
Hartford, CT
Siviq Scores

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

Liabilities / Assets

36th percentile

0.01x

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

2017 filings • 501(c)25 • $25M-$50M nonprofits • Source year 2017

Liabilities / Revenue

38th percentile

0.11x

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

2017 filings • 501(c)25 • $25M-$50M nonprofits • Source year 2017

Net Margin

58th percentile

90%

Higher net margin than 58% of similar nonprofits.

2017 filings • 501(c)25 • $25M-$50M nonprofits • Source year 2017

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2017

Asset Growth

28th percentile

-1.2%

Faster asset growth than 28% of similar nonprofits.

2017 filings • 501(c)25 • $25M-$50M nonprofits • Annualized from 2016 to 2017

Revenue Growth

12th percentile

-12%

Faster revenue growth than 12% of similar nonprofits.

2017 filings • 501(c)25 • $25M-$50M nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets36th percentile

Assets

Down

$28,797,629

Down $337,200 (-1.2%) from 2016

Net Assets

Down

$28,535,426

Down $338,000 (-1.2%) from 2016

Liabilities

Up

$262,203

Up $800 (+0.3%) from 2016

Revenue And Expenses
Liabilities / Revenue38th percentileNet Margin58th percentile

Revenue

Down

$2,400,825

Down $321,211 (-12%) from 2016

Expenses

Up

$238,824

Up $1,795 (+0.8%) from 2016

Net Income

Down

$2,162,001

Down $323,006 (-13%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth28th percentile

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

$40M$30M$20M$10M$0Assets 2011: $20,816,653Liabilities 2011: $279,951Net Assets 2011: $20,536,7022011Assets 2012: $21,510,185Liabilities 2012: $267,369Net Assets 2012: $21,242,8162012Assets 2013: $23,852,428Liabilities 2013: $503,228Net Assets 2013: $23,349,2002013Assets 2014: $27,877,730Liabilities 2014: $261,204Net Assets 2014: $27,616,5262014Assets 2015: $28,250,071Liabilities 2015: $388,342Net Assets 2015: $27,861,7292015Assets 2016: $29,134,829Liabilities 2016: $261,403Net Assets 2016: $28,873,4262016Assets 2017: $28,797,629Liabilities 2017: $262,203Net Assets 2017: $28,535,4262017Assets 2018: $29,066,784Liabilities 2018: $262,403Net Assets 2018: $28,804,3812018Assets 2019: $30,079,281Liabilities 2019: $262,478Net Assets 2019: $29,816,8032019Assets 2020: $29,081,502Liabilities 2020: $262,553Net Assets 2020: $28,818,9492020Assets 2021: $31,400,056Liabilities 2021: $267,035Net Assets 2021: $31,133,0212021Assets 2022: $33,594,717Liabilities 2022: $266,967Net Assets 2022: $33,327,7502022Assets 2023: $35,112,081Liabilities 2023: $262,851Net Assets 2023: $34,849,2302023Assets 2024: $35,346,391Liabilities 2024: $262,593Net Assets 2024: $35,083,7982024

Highlighted filing

2017

Assets$28,797,629
Liabilities$262,203
Net Assets$28,535,426
Open 2017 Filing

Operations Trend

Revenue Growth12th percentile

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

$3.0M$2.0M$1.0M$0Revenue 2011: $2,126,326Expenses 2011: $0Net Income 2011: $2,126,3262011Revenue 2012: $2,179,206Expenses 2012: $173,092Net Income 2012: $2,006,1142012Revenue 2013: $2,039,633Expenses 2013: $183,249Net Income 2013: $1,856,3842013Revenue 2014: $2,832,800Expenses 2014: $215,474Net Income 2014: $2,617,3262014Revenue 2015: $254,993Expenses 2015: $228,051Net Income 2015: $26,9422015Revenue 2016: $2,722,036Expenses 2016: $237,029Net Income 2016: $2,485,0072016Revenue 2017: $2,400,825Expenses 2017: $238,824Net Income 2017: $2,162,0012017Revenue 2018: $1,907,469Expenses 2018: $238,514Net Income 2018: $1,668,9552018Revenue 2019: $2,234,336Expenses 2019: $241,914Net Income 2019: $1,992,4222019Revenue 2020: $1,958,228Expenses 2020: $246,081Net Income 2020: $1,712,1472020Revenue 2021: $2,303,301Expenses 2021: $219,228Net Income 2021: $2,084,0732021Revenue 2022: $1,731,260Expenses 2022: $216,532Net Income 2022: $1,514,7282022Revenue 2023: $1,244,014Expenses 2023: $222,534Net Income 2023: $1,021,4802023Revenue 2024: $1,156,326Expenses 2024: $221,758Net Income 2024: $934,5682024

Highlighted filing

2017

Revenue$2,400,825
Expenses$238,824
Net Income$2,162,001
Open 2017 Filing
Filing Detail Status

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

View Latest Detailed Filing (2024)
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Mission and Program Overview

Mission

The corporation is organized for the exclusive purpose of acquiring, holding title to, and collecting income from real property. The entire amount of income (less expenses) is remitted to one or more organizations described in the irc section 501(c)(25), which are shareholders.

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2017 • Form 990Summary only. Only limited summary data is available for this year.

Open filing
Assets
$28,797,629
Liabilities
$262,203
Net assets
$28,535,426
Revenue
$2,400,825
Expenses
$238,824
Net income
$2,162,001
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$35.3$0.26$35.1$1.16$0.22$0.93
2023Detailed filing. Detailed filing data is available for this year.$35.1$0.26$34.8$1.24$0.22$1.02
2022Detailed filing. Detailed filing data is available for this year.$33.6$0.27$33.3$1.73$0.22$1.51
2021Detailed filing. Detailed filing data is available for this year.$31.4$0.27$31.1$2.30$0.22$2.08
2020Detailed filing. Detailed filing data is available for this year.$29.1$0.26$28.8$1.96$0.25$1.71
2019Detailed filing. Detailed filing data is available for this year.$30.1$0.26$29.8$2.23$0.24$1.99
2018Summary only. Only limited summary data is available for this year.$29.1$0.26$28.8$1.91$0.24$1.67
2017Summary only. Only limited summary data is available for this year.$28.8$0.26$28.5$2.40$0.24$2.16
2016Summary only. Only limited summary data is available for this year.$29.1$0.26$28.9$2.72$0.24$2.49
2015Summary only. Only limited summary data is available for this year.$28.3$0.39$27.9$0.25$0.23$0.03
2014Summary only. Only limited summary data is available for this year.$27.9$0.26$27.6$2.83$0.22$2.62
2013Summary only. Only limited summary data is available for this year.$23.9$0.50$23.3$2.04$0.18$1.86
2012Summary only. Only limited summary data is available for this year.$21.5$0.27$21.2$2.18$0.17$2.01
2011Summary only. Only limited summary data is available for this year.$20.8$0.28$20.5$2.13$0.00$2.13