Civic Intelligence

Columbus Commercial Real Estate Women

990EZ • Fiscal year 2020 • EIN 31-1245428

Jan 01, 2020 to Dec 31, 2020 • Filed on May 06, 2021

6797 North High Street Ste 325Columbus, OH 43085

(785) 832-1808

Siviq Scores

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

Liabilities / Assets

59th percentile

0.02x

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

2020 filings • 501(c)6 • <$500k nonprofits • Source year 2020

Liabilities / Revenue

66th percentile

0.05x

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

2020 filings • 501(c)6 • <$500k nonprofits • Source year 2020

Net Margin

80th percentile

25%

Higher net margin than 80% of similar nonprofits.

2020 filings • 501(c)6 • <$500k nonprofits • Source year 2020

Top Officer Pay

70th percentile

$0

Higher top officer pay than 70% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

2020 filings • 501(c)6 • <$500k nonprofits • Source year 2020

Asset Growth

60th percentile

8.5%

Faster asset growth than 60% of similar nonprofits.

2020 filings • 501(c)6 • <$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

36th percentile

-32%

Faster revenue growth than 36% of similar nonprofits.

2020 filings • 501(c)6 • <$500k nonprofits • Annualized from 2019 to 2020

Assets

Up

$87,805

Up $6,844 (+8.5%) from 2019

Net Assets

Up

$85,778

Up $9,437 (+12%) from 2019

Liabilities

Down

$2,027

Down $2,593 (-56%) from 2019

Revenue

Down

$38,001

Down $18,279 (-32%) from 2019

Expenses

Down

$28,564

Down $25,873 (-48%) from 2019

Net Income

Up

$9,437

Up $7,594 (+412%) from 2019

Historical Trend

Balance Sheet Trend

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

$150K$100K$50K$0Assets 2010: $35,890Net Assets 2010: $35,8902010Assets 2011: $34,940Net Assets 2011: $34,9402011Assets 2012: $43,105Net Assets 2012: $43,1052012Assets 2013: $47,702Net Assets 2013: $47,7022013Assets 2014: $61,012Liabilities 2014: $9,517Net Assets 2014: $51,4952014Assets 2015: $68,979Liabilities 2015: $12,471Net Assets 2015: $56,5082015Assets 2016: $68,308Liabilities 2016: $9,814Net Assets 2016: $58,4942016Assets 2017: $71,972Liabilities 2017: $4,690Net Assets 2017: $67,2822017Assets 2018: $79,377Liabilities 2018: $4,879Net Assets 2018: $74,4982018Assets 2019: $80,961Liabilities 2019: $4,620Net Assets 2019: $76,3412019Assets 2020: $87,805Liabilities 2020: $2,027Net Assets 2020: $85,7782020Assets 2021: $87,297Liabilities 2021: $4,274Net Assets 2021: $83,0232021Assets 2022: $78,112Liabilities 2022: $2,112Net Assets 2022: $76,0002022Assets 2024: $103,095Liabilities 2024: $6,650Net Assets 2024: $96,4452024

Highlighted filing

2020

Assets$87,805
Liabilities$2,027
Net Assets$85,778

Operations Trend

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

$80K$60K$40K$20K$0-$20KRevenue 2010: $35,605Expenses 2010: $47,053Net Income 2010: -$11,4482010Revenue 2011: $32,680Expenses 2011: $33,630Net Income 2011: -$9502011Revenue 2012: $38,875Expenses 2012: $30,710Net Income 2012: $8,1652012Revenue 2013: $38,251Expenses 2013: $33,655Net Income 2013: $4,5962013Revenue 2014: $37,559Expenses 2014: $33,766Net Income 2014: $3,7932014Revenue 2015: $57,600Expenses 2015: $52,587Net Income 2015: $5,0132015Revenue 2016: $64,462Expenses 2016: $62,476Net Income 2016: $1,9862016Revenue 2017: $63,803Expenses 2017: $55,006Net Income 2017: $8,7972017Revenue 2018: $66,679Expenses 2018: $59,463Net Income 2018: $7,2162018Revenue 2019: $56,280Expenses 2019: $54,437Net Income 2019: $1,8432019Revenue 2020: $38,001Expenses 2020: $28,564Net Income 2020: $9,4372020Revenue 2021: $24,155Expenses 2021: $26,910Net Income 2021: -$2,7552021Revenue 2022: $34,315Expenses 2022: $41,340Net Income 2022: -$7,0252022Revenue 2024: $67,130Expenses 2024: $43,832Net Income 2024: $23,2982024

Highlighted filing

2020

Revenue$38,001
Expenses$28,564
Net Income$9,437
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
May 6, 2021
Return Version
2020v4.0
Gross Receipts
$38,001
Mission and Program Overview

Mission

To influence the success of the commercial real estate industry by advancing the achievements of women, crew columbus aims to lead the commercial real estate industry in our area; provide informative and educational events to our members and community; and create an environment for women and men to network in a welcoming and engaging environment.

Program Services

DescriptionGrantsExpenses
HELD MONTHLY MEETINGS TO DISCUSS DEVELOPMENTS IN THE FIELD OF COMMERCIAL REAL ESTATE. PUBLICATION OF QUARTERLY NEWSLETTER TO INFORM MEMBERS OF CHAPTER ACTIVITIES AND INDUSTRY DEVELOPMENTS.--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
SARAH LYNNPast Preside-$0--
ALEXANDRA KERNSPresident-$0--
CIERRA RIDERDirector-COM-$0--
CAROLYN CYBULSKIDirector-Mem-$0--
BETSY LISKADirector-Pro-$0--
BONNIE ROBERTSTreasurer-$0--
ABIGAIL HAMPTONSecretary-$0--
LAUREN JOHNSONPresident El-$0--
Filing and Contact Details

Filer

Filer Name
Columbus Crew
EIN
31-1245428
Address
6797 NORTH HIGH STREET STE 325, COLUMBUS, OH 43085

Signing Officer

Name
Bonnie Roberts
Title
Treasurer
Phone
6144313332
Signed
2021-05-06
Discuss with paid preparer
Yes

Preparer

Firm
Ss&c Solutions Inc
Address
3320 CLINTON PARKWAY COURT SUITE 1, LAWRENCE, KS 66047
Preparer
Michele C Hammann CPA
Phone
7858384484
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10

Crew network dues 12,040 1201 wakarusa dr, ste d lawrence ks 66049

Form 990-ez, Part I, Line 16

Expenses marketing/advertising 743 office expenses 508 administrative expense 275 website maint/hosting/email 382 delegate conference expenses 5,376 program expenses 4,466 membership expenses 100 sponsorship expenses 1,470 total 13,320

Form 990-ez, Part II, Line 24

Accounts receivable 1,820 137 prepaid expenses and deferred charges 300 0 total 2,120 137

Form 990-ez, Part II, Line 26

Accounts payable and accrued expenses 65 177 deferred revenue 4,555 1,850

Form 990-ez, Part III

To influence the success of the commercial real estate industry by advancing the achievements of women, crew columbus aims to lead the commercial real estate industry in our area; provide informative and educational events to our members and community; and create an environment for women and men to network in a welcoming and engaging environment.

Raw XML Appendix134 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
CompensationExplanation/CompensationExplanationGrp/PersonNm0SARAH LYNN
CompensationExplanation/CompensationExplanationGrp/PersonNm1ALEXANDRA KERNS
CompensationExplanation/CompensationExplanationGrp/PersonNm2CIERRA RIDER
CompensationExplanation/CompensationExplanationGrp/PersonNm3CAROLYN CYBULSKI
CompensationExplanation/CompensationExplanationGrp/PersonNm4BETSY LISKA
CompensationExplanation/CompensationExplanationGrp/PersonNm5BONNIE ROBERTS
CompensationExplanation/CompensationExplanationGrp/PersonNm6ABIGAIL HAMPTON
CompensationExplanation/CompensationExplanationGrp/PersonNm7LAUREN JOHNSON
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0NANCY EMERSON
IRS990EZ/BooksInCareOfDetail/PhoneNum07858321808
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01201 WAKARUSA DR SUITE D
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0LAWRENCE
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0KS
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd066049
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt078841
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt087668
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt033565
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt09437
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt03194
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt080961
IRS990EZ/Form990TotalAssetsGrp/EOYAmt087805
IRS990EZ/GrantsAndSimilarAmountsPaidAmt012040
IRS990EZ/GrossReceiptsAmt038001
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0516
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt076341
IRS990EZ/NetAssetsOrFundBalancesEOYAmt085778
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt076341
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt085778
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt52.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt62.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt72.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/PersonNm0SARAH LYNN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1ALEXANDRA KERNS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2CIERRA RIDER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3CAROLYN CYBULSKI
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4BETSY LISKA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5BONNIE ROBERTS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6ABIGAIL HAMPTON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7LAUREN JOHNSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PAST PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2DIRECTOR-COM
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIRECTOR-MEM
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR-PRO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7PRESIDENT EL
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt02120
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0137
IRS990EZ/OtherExpensesTotalAmt013320
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO INFLUENCE THE SUCCESS OF THE COMMERCIAL REAL ESTATE INDUSTRY BY ADVANCING THE ACHIEVEMENTS OF WOMEN, CREW COLUMBUS AIMS TO LEAD THE COMMERCIAL REAL ESTATE INDUSTRY IN OUR AREA; PROVIDE INFORMATIVE AND EDUCATIONAL EVENTS TO OUR MEMBERS AND COMMUNITY; AND CREATE AN ENVIRONMENT FOR WOMEN AND MEN TO NETWORK IN A WELCOMING AND ENGAGING ENVIRONMENT.
IRS990EZ/PrintingPublicationsPostageAmt010
IRS990EZ/ProgramServiceRevenueAmt03920
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0HELD MONTHLY MEETINGS TO DISCUSS DEVELOPMENTS IN THE FIELD OF COMMERCIAL REAL ESTATE. PUBLICATION OF QUARTERLY NEWSLETTER TO INFORM MEMBERS OF CHAPTER ACTIVITIES AND INDUSTRY DEVELOPMENTS.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt04620
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt02027
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt028564
IRS990EZ/TotalRevenueAmt038001
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.CREWCOLS.ORG
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0CREW NETWORK DUES 12,040 1201 WAKARUSA DR, STE D LAWRENCE KS 66049
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES MARKETING/ADVERTISING 743 OFFICE EXPENSES 508 ADMINISTRATIVE EXPENSE 275 WEBSITE MAINT/HOSTING/EMAIL 382 DELEGATE CONFERENCE EXPENSES 5,376 PROGRAM EXPENSES 4,466 MEMBERSHIP EXPENSES 100 SPONSORSHIP EXPENSES 1,470 TOTAL 13,320
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2ACCOUNTS RECEIVABLE 1,820 137 PREPAID EXPENSES AND DEFERRED CHARGES 300 0 TOTAL 2,120 137
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3ACCOUNTS PAYABLE AND ACCRUED EXPENSES 65 177 DEFERRED REVENUE 4,555 1,850
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4TO INFLUENCE THE SUCCESS OF THE COMMERCIAL REAL ESTATE INDUSTRY BY ADVANCING THE ACHIEVEMENTS OF WOMEN, CREW COLUMBUS AIMS TO LEAD THE COMMERCIAL REAL ESTATE INDUSTRY IN OUR AREA; PROVIDE INFORMATIVE AND EDUCATIONAL EVENTS TO OUR MEMBERS AND COMMUNITY; AND CREATE AN ENVIRONMENT FOR WOMEN AND MEN TO NETWORK IN A WELCOMING AND ENGAGING ENVIRONMENT.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990-EZ, PART III
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0BONNIE ROBERTS
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum06144313332
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-05-06
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0COLUMBUS CREW
ReturnHeader/Filer/BusinessNameControlTxt0COLU
ReturnHeader/Filer/EIN0311245428
ReturnHeader/Filer/USAddress/AddressLine1Txt06797 NORTH HIGH STREET STE 325
ReturnHeader/Filer/USAddress/CityNm0COLUMBUS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd043085
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0480969601
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0SS&C SOLUTIONS INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt03320 CLINTON PARKWAY COURT SUITE 1
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0LAWRENCE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0KS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd066047
ReturnHeader/PreparerPersonGrp/PhoneNum07858384484
ReturnHeader/PreparerPersonGrp/PreparationDt02021-05-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MICHELE C HAMMANN CPA
ReturnHeader/ReturnTs02021-05-14T15:51:21-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0BONNIE
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0ROBERTS
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

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.$1.03$0.07$0.96$0.67$0.44$0.23
2022Detailed filing. Detailed filing data is available for this year.$0.78$0.02$0.76$0.34$0.41$0.07
2021Detailed filing. Detailed filing data is available for this year.$0.87$0.04$0.83$0.24$0.27$0.03
2020Detailed filing. Detailed filing data is available for this year.$0.88$0.02$0.86$0.38$0.29$0.09
2019Detailed filing. Detailed filing data is available for this year.$0.81$0.05$0.76$0.56$0.54$0.02
2018Detailed filing. Detailed filing data is available for this year.$0.79$0.05$0.74$0.67$0.59$0.07
2017Detailed filing. Detailed filing data is available for this year.$0.72$0.05$0.67$0.64$0.55$0.09
2016Detailed filing. Detailed filing data is available for this year.$0.68$0.10$0.58$0.64$0.62$0.02
2015Detailed filing. Detailed filing data is available for this year.$0.69$0.12$0.57$0.58$0.53$0.05
2014Detailed filing. Detailed filing data is available for this year.$0.61$0.10$0.51$0.38$0.34$0.04
2013Detailed filing. Detailed filing data is available for this year.$0.48$0.48$0.38$0.34$0.05
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.43$0.43$0.39$0.31$0.08
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.35$0.35$0.33$0.34$0.01
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.36$0.36$0.36$0.47$0.11