Civic Intelligence

Missouri Chapter of Delta Upsilon

990EZ • Fiscal year 2018 • EIN 43-0240455

Jul 01, 2017 to Jun 30, 2018 • Filed on Aug 29, 2018

Organization ProfileN/A
104 East BroadwayColumbia, MO 65203

(573) 874-1040

Siviq Scores

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

Liabilities / Assets

100th percentile

30.29x

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

2018 filings • 501(c)7 • <$500k nonprofits • Source year 2018

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2018

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2018

Top Officer Pay

93rd percentile

$0

Higher top officer pay than 93% of similar nonprofits.

2018 filings • 501(c)7 • <$500k nonprofits • Source year 2018

Asset Growth

99th percentile

523%

Faster asset growth than 99% of similar nonprofits.

2018 filings • 501(c)7 • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

1st percentile

-100%

Faster revenue growth than 1% of similar nonprofits.

2018 filings • 501(c)7 • <$500k nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / Assets100th percentile

Assets

Up

$4,247

Up $3,565 (+523%) from 2017

Net Assets

Down

-$124,382

Down $19,435 (-19%) from 2017

Liabilities

Up

$128,629

Up $23,000 (+22%) from 2017

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

Down

$0

Down $561,569 (-100%) from 2017

Expenses

Down

$19,435

Down $650,432 (-97%) from 2017

Net Income

Up

-$19,435

Up $88,863 (+82%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth99th percentile

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

$1.0M$500K$0-$500KAssets 2012: $34,580Liabilities 2012: $133,815Net Assets 2012: -$99,2352012Assets 2013: $49,584Liabilities 2013: $170,008Net Assets 2013: -$120,4242013Assets 2014: $55,535Liabilities 2014: $133,128Net Assets 2014: -$77,5932014Assets 2015: $733,544Liabilities 2015: $738,243Net Assets 2015: -$4,6992015Assets 2016: $745,184Liabilities 2016: $726,433Net Assets 2016: $18,7512016Assets 2017: $682Liabilities 2017: $105,629Net Assets 2017: -$104,9472017Assets 2018: $4,247Liabilities 2018: $128,629Net Assets 2018: -$124,3822018Assets 2019: $129,714Liabilities 2019: $78,135Net Assets 2019: $51,5792019Assets 2020: $201,679Liabilities 2020: $145,000Net Assets 2020: $56,6792020Assets 2021: $298,833Liabilities 2021: $179,762Net Assets 2021: $119,0712021Assets 2022: $367,117Liabilities 2022: $246,010Net Assets 2022: $121,1072022Assets 2023: $339,746Liabilities 2023: $216,738Net Assets 2023: $123,0082023Assets 2024: $231,299Liabilities 2024: $102,298Net Assets 2024: $129,0012024Assets 2025: $510,540Liabilities 2025: $375,290Net Assets 2025: $135,2502025

Highlighted filing

2018

Assets$4,247
Liabilities$128,629
Net Assets-$124,382
Open 2018 Filing

Operations Trend

Revenue Growth1st percentile

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

$1.5M$1.0M$500K$0-$500KRevenue 2012: $543,198Expenses 2012: $566,134Net Income 2012: -$22,9362012Revenue 2013: $598,643Expenses 2013: $619,833Net Income 2013: -$21,1902013Revenue 2014: $632,326Expenses 2014: $589,495Net Income 2014: $42,8312014Revenue 2015: $111,706Expenses 2015: $38,812Net Income 2015: $72,8942015Revenue 2016: $689,844Expenses 2016: $666,394Net Income 2016: $23,4502016Revenue 2017: $561,569Expenses 2017: $669,867Net Income 2017: -$108,2982017Revenue 2018: $0Expenses 2018: $19,435Net Income 2018: -$19,4352018Revenue 2019: $68,888Expenses 2019: $21,556Net Income 2019: $47,3322019Revenue 2020: $728,132Expenses 2020: $723,032Net Income 2020: $5,1002020Revenue 2021: $1,040,506Expenses 2021: $1,036,914Net Income 2021: $3,5922021Revenue 2022: $1,195,932Expenses 2022: $1,193,896Net Income 2022: $2,0362022Revenue 2023: $1,299,295Expenses 2023: $1,297,394Net Income 2023: $1,9012023Revenue 2024: $1,312,384Expenses 2024: $1,306,391Net Income 2024: $5,9932024Revenue 2025: $1,288,951Expenses 2025: $1,282,702Net Income 2025: $6,2492025

Highlighted filing

2018

Revenue$0
Expenses$19,435
Net Income-$19,435
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Aug 29, 2018
Return Version
2017v2.2
Mission and Program Overview

Mission

Missouri chapter of an international mens fraternal organization. Providing philanthropic and fellowship opportunities for members during thier college career.

Program Services

DescriptionGrantsExpenses
MISSOURI CHAPTER OF AN INTERNATIONAL MEN'S FRATERNAL IRGANIZATION PROVIDING PHILANTHROPIC AND FELLOWSHIP OPPORTUNITIES FOR MEMBER'S DURING THEIR COLLEGE CAREER.--
Compensation and Service Providers
Top Officer Pay93rd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Bruce McKinneyAlumni-PresidenPT$0--
Terry BradyAlumni-SecretarPT$0--
Steve MermelsteinAlumni-TreasurePT$0--
Jeff KreutzAlumni-DirectorPT$0--
Chuck HatleyAlumni-DirectorPT$0--
Ted MurrayAlumni-DirectorPT$0--
Steve RuprechtAlumni-DirectorPT$0--
Collin SmithAlumni-DirectorPT$0--
Filing and Contact Details

Filer

Filer Name
Missouri Chapter of Delta Upsilon
EIN
43-0240455
Phone
5738741040
Address
104 EAST BROADWAY, COLUMBIA, MO 65203

Signing Officer

Name
Steve Mermelstein
Title
VP-finance
Signed
2018-08-29
Discuss with paid preparer
Yes

Preparer

Firm
Howe & Associates Pc
Address
104 E Broadway, Columbia, MO 65203
Preparer
Bill Howe
Phone
5738741040
Supplemental Narrative

Additional Explanations

Other Expenses.1002

“Office Expenses $22”

Other Expenses.1008

“Interest $4”

Other Expenses.1

“MISC FEES $2388”

Other Expenses.2

“Uncollectable accounts $475”

Other Assets.1

“ACCOUNTS RECEIVABLE - Beginning $475 ACCOUNTS RECEIVABLE - Ending $0”

Total Liabilities.1001

“Accounts Payable and Accrued Expenses - Beginning $105629 Accounts Payable and Accrued Expenses - Ending $128629”

Raw XML Appendix127 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0HOWE ASSOCIATES PC CPA'S
IRS990EZ/BooksInCareOfDetail/PhoneNum05738741040
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0104 EAST BROADWAY
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0COLUMBIA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd065203
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0207
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt04247
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-19435
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0682
IRS990EZ/Form990TotalAssetsGrp/EOYAmt04247
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/GroupExemptionNum05222
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-104947
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0-124382
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-104947
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0-124382
IRS990EZ/OccupancyRentUtltsAndMaintAmt016546
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt05.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt15.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt25.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt45.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt55.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt65.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt75.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Bruce McKinney
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Terry Brady
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Steve Mermelstein
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Jeff Kreutz
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4Chuck Hatley
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5Ted Murray
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6Steve Ruprecht
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7Collin Smith
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Alumni-Presiden
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Alumni-Secretar
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Alumni-Treasure
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Alumni-Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Alumni-Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5Alumni-Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6Alumni-Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7Alumni-Director
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationFiled990TInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt0475
IRS990EZ/OtherExpensesTotalAmt02889
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0MISSOURI CHAPTER OF AN INTERNATIONAL MENS FRATERNAL ORGANIZATION. PROVIDING PHILANTHROPIC AND FELLOWSHIP OPPORTUNITIES FOR MEMBERS DURING THIER COLLEGE CAREER.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MISSOURI CHAPTER OF AN INTERNATIONAL MEN'S FRATERNAL IRGANIZATION PROVIDING PHILANTHROPIC AND FELLOWSHIP OPPORTUNITIES FOR MEMBER'S DURING THEIR COLLEGE CAREER.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt0105629
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt0128629
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt019435
IRS990EZ/TotalRevenueAmt00
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Office Expenses $22
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Interest $4
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2MISC FEES $2388
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3UNCOLLECTABLE ACCOUNTS $475
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4ACCOUNTS RECEIVABLE - Beginning $475 ACCOUNTS RECEIVABLE - Ending $0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Accounts Payable and Accrued Expenses - Beginning $105629 Accounts Payable and Accrued Expenses - Ending $128629
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Other Expenses.1002
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Other Expenses.1008
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Other Assets.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Total Liabilities.1001
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Steve Mermelstein
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VP-FINANCE
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-08-29
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MISSOURI CHAPTER OF DELTA UPSILON
ReturnHeader/Filer/BusinessNameControlTxt0MISS
ReturnHeader/Filer/EIN0430240455
ReturnHeader/Filer/PhoneNum05738741040
ReturnHeader/Filer/USAddress/AddressLine1Txt0104 EAST BROADWAY
ReturnHeader/Filer/USAddress/CityNm0COLUMBIA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MO
ReturnHeader/Filer/USAddress/ZIPCd065203
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0431433737
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0HOWE & ASSOCIATES PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0104 E Broadway
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Columbia
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd065203
ReturnHeader/PreparerPersonGrp/PhoneNum05738741040
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Bill Howe
ReturnHeader/ReturnTs02018-08-29T12:29:34-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2018 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$4,247
Liabilities
$128,629
Net assets
-$124,382
Revenue
$0
Expenses
$19,435
Net income
-$19,435
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$0.51$0.38$0.14$1.29$1.28$0.01
2024Detailed filing. Detailed filing data is available for this year.$0.23$0.10$0.13$1.31$1.31$0.01
2023Detailed filing. Detailed filing data is available for this year.$0.34$0.22$0.12$1.30$1.30$0.00
2022Detailed filing. Detailed filing data is available for this year.$0.37$0.25$0.12$1.20$1.19$0.00
2021Detailed filing. Detailed filing data is available for this year.$0.30$0.18$0.12$1.04$1.04$0.00
2020Detailed filing. Detailed filing data is available for this year.$0.20$0.15$0.06$0.73$0.72$0.01
2019Detailed filing. Detailed filing data is available for this year.$0.13$0.08$0.05$0.07$0.02$0.05
2018Detailed filing. Detailed filing data is available for this year.$0.00$0.13$0.12$0.00$0.02$0.02
2017Detailed filing. Detailed filing data is available for this year.$0.00$0.11$0.10$0.56$0.67$0.11
2016Detailed filing. Detailed filing data is available for this year.$0.75$0.73$0.02$0.69$0.67$0.02
2015Summary only. Only limited summary data is available for this year.$0.73$0.74$0.00$0.11$0.04$0.07
2014Summary only. Only limited summary data is available for this year.$0.06$0.13$0.08$0.63$0.59$0.04
2013Summary only. Only limited summary data is available for this year.$0.05$0.17$0.12$0.60$0.62$0.02
2012Summary only. Only limited summary data is available for this year.$0.03$0.13$0.10$0.54$0.57$0.02