Civic Intelligence

Columbian Guild Inc

990EZ • Fiscal year 2016 • EIN 48-0734017

Jan 01, 2016 to Dec 31, 2016 • Filed on Jan 17, 2017

Organization Profile
800 West FrontviewDodge City, KS 67801

(620) 225-1421

Siviq Scores

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

Liabilities / Assets

53rd percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Liabilities / Revenue

53rd percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Net Margin

35th percentile

-1.1%

Higher net margin than 35% of similar nonprofits.

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

Top Officer Pay

92nd percentile

$0

Higher top officer pay than 92% of similar nonprofits.

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

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

Asset Growth

29th percentile

-5.4%

Faster asset growth than 29% of similar nonprofits.

2016 filings • 501(c)7 • <$500k nonprofits • Annualized from 2015 to 2016

Revenue Growth

7th percentile

-34%

Faster revenue growth than 7% of similar nonprofits.

2016 filings • 501(c)7 • <$500k nonprofits • Annualized from 2015 to 2016

Balance Sheet
Liabilities / Assets53rd percentile

Assets

Down

$5,356

Down $305 (-5.4%) from 2015

Net Assets

Down

$5,356

Down $305 (-5.4%) from 2015

Liabilities

Flat

$0

Flat from 2015

Revenue And Expenses
Liabilities / Revenue53rd percentileNet Margin35th percentile

Revenue

Down

$26,607

Down $13,837 (-34%) from 2015

Expenses

Down

$26,912

Down $7,871 (-23%) from 2015

Net Income

Down

-$305

Down $5,966 (-105%) from 2015

Historical Trend

Balance Sheet Trend

Asset Growth29th percentile

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

$800K$600K$400K$200K$0-$200KAssets 2011: $0Liabilities 2011: $0Net Assets 2011: $02011Assets 2013: $0Liabilities 2013: $2,356Net Assets 2013: -$2,3562013Assets 2014: $0Liabilities 2014: $0Net Assets 2014: $02014Assets 2015: $5,661Liabilities 2015: $0Net Assets 2015: $5,6612015Assets 2016: $5,356Liabilities 2016: $0Net Assets 2016: $5,3562016Assets 2017: $4,320Liabilities 2017: $0Net Assets 2017: $4,3202017Assets 2018: $10,385Liabilities 2018: $0Net Assets 2018: $10,3852018Assets 2020: $657,266Liabilities 2020: $248Net Assets 2020: $657,0182020Assets 2021: $661,822Liabilities 2021: $0Net Assets 2021: $661,8222021Assets 2022: $656,418Liabilities 2022: $0Net Assets 2022: $656,4182022Assets 2023: $669,248Liabilities 2023: $0Net Assets 2023: $669,2482023Assets 2024: $706,551Liabilities 2024: $0Net Assets 2024: $706,5512024

Highlighted filing

2016

Assets$5,356
Liabilities$0
Net Assets$5,356
Open 2016 Filing

Operations Trend

Revenue Growth7th percentile

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

$150K$100K$50K$0-$50K-$100KRevenue 2011: $79,581Expenses 2011: $79,581Net Income 2011: $02011Revenue 2013: $42,073Expenses 2013: $44,429Net Income 2013: -$2,3562013Revenue 2014: $42,727Expenses 2014: $40,371Net Income 2014: $2,3562014Revenue 2015: $40,444Expenses 2015: $34,783Net Income 2015: $5,6612015Revenue 2016: $26,607Expenses 2016: $26,912Net Income 2016: -$3052016Revenue 2017: $38,935Expenses 2017: $39,971Net Income 2017: -$1,0362017Revenue 2018: $30,241Expenses 2018: $24,176Net Income 2018: $6,0652018Revenue 2020: $45,189Expenses 2020: $100,568Net Income 2020: -$55,3792020Revenue 2021: $7,551Expenses 2021: $2,747Net Income 2021: $4,8042021Revenue 2022: $3,490Expenses 2022: $8,894Net Income 2022: -$5,4042022Revenue 2023: $12,830Expenses 2023: $0Net Income 2023: $12,8302023Revenue 2024: $37,303Expenses 2024: $0Net Income 2024: $37,3032024

Highlighted filing

2016

Revenue$26,607
Expenses$26,912
Net Income-$305
Open 2016 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
Jan 17, 2017
Return Version
2016v3.0
Gross Receipts
$26,607
Mission and Program Overview

Mission

MANAGEMENT OF PROPERTY

Program Services

DescriptionGrantsExpenses
MANAGEMENT OF BUILDING FOR KNIGHTS OF COLUMBUS THIRD DEGREE DODGE CITY KANSAS--
Compensation and Service Providers
Top Officer Pay92nd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
DAN STREMELPresidentPT$0--
Filing and Contact Details

Filer

Filer Name
Columbian Guild Inc
EIN
48-0734017
Address
800 WEST FRONTVIEW, Dodge City, KS 67801

Signing Officer

Name
Dan Stremel
Title
President
Phone
6202271500
Signed
2017-01-17
Discuss with paid preparer
No

Preparer

Firm
Schneweis Tax and Accounting
Address
212 E FRONTVIEW STE B, Dodge City, KS 67801
Preparer
Ron Schneweis
Phone
6202277754
Supplemental Narrative

Additional Explanations

Description of other revenue Part I line 8

“Description AmountPROGRAMMING 18,732”

Description of other expenses Part I line 16

“Description AmountDUES PAID 3,686MEETING 846OFFICE AND SUPPLIES 916DONATIONS 21,464”

Raw XML Appendix98 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/PersonNm0DAN STREMEL
IRS990EZ/BooksInCareOfDetail/PhoneNum06202251421
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0LOCAL
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0DODGE CITY
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0KS
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd067801
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt05661
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt05356
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-305
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt05661
IRS990EZ/Form990TotalAssetsGrp/EOYAmt05356
IRS990EZ/GrossReceiptsAmt026607
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt07875
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt05661
IRS990EZ/NetAssetsOrFundBalancesEOYAmt05356
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt05661
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt05356
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt010.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0DAN STREMEL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt026912
IRS990EZ/OtherRevenueTotalAmt018732
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0MANAGEMENT OF PROPERTY
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MANAGEMENT OF BUILDING FOR KNIGHTS OF COLUMBUS THIRD DEGREE DODGE CITY KANSAS
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt026912
IRS990EZ/TotalRevenueAmt026607
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountPROGRAMMING 18,732
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description AmountDUES PAID 3,686MEETING 846OFFICE AND SUPPLIES 916DONATIONS 21,464
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other revenue Part I line 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other expenses Part I line 16
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0DAN STREMEL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06202271500
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-01-17
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0COLUMBIAN GUILD INC
ReturnHeader/Filer/BusinessNameControlTxt0COLU
ReturnHeader/Filer/EIN0480734017
ReturnHeader/Filer/USAddress/AddressLine1Txt0800 WEST FRONTVIEW
ReturnHeader/Filer/USAddress/CityNm0Dodge City
ReturnHeader/Filer/USAddress/StateAbbreviationCd0KS
ReturnHeader/Filer/USAddress/ZIPCd067801
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId010D8984371FB0AAC6DFFA12B60C31F52A7AB3DDE
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId010D8984371FB0AAC6DFFA12B60C31F52A7AB3DDE
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId04800872017041fmap2b0
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02017-02-10
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt098.191.135.140
ReturnHeader/FilingSecurityInformation/IPDt02017-02-10
ReturnHeader/FilingSecurityInformation/IPTm007:52:28
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0200390173
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0SCHNEWEIS TAX AND ACCOUNTING
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0212 E FRONTVIEW STE B
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Dodge City
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0KS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd067801
ReturnHeader/PreparerPersonGrp/PhoneNum06202277754
ReturnHeader/PreparerPersonGrp/PreparationDt02017-02-10
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0RON SCHNEWEIS
ReturnHeader/ReturnTs02017-02-10T07:45:05-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-01-01
ReturnHeader/TaxPeriodEndDt02016-12-31
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$5,356
Liabilities
$0
Net assets
$5,356
Revenue
$26,607
Expenses
$26,912
Net income
-$305
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Facts available. Structured filing facts are available, but richer extracted sections are limited.$7.07$0.00$7.07$0.37$0.00$0.37
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.69$0.00$6.69$0.13$0.00$0.13
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.56$0.00$6.56$0.03$0.09$0.05
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.62$0.00$6.62$0.08$0.03$0.05
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$6.57$0.00$6.57$0.45$1.01$0.55
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.10$0.00$0.10$0.30$0.24$0.06
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.04$0.00$0.04$0.39$0.40$0.01
2016Detailed filing. Detailed filing data is available for this year.$0.05$0.00$0.05$0.27$0.27$0.00
2015Detailed filing. Detailed filing data is available for this year.$0.06$0.00$0.06$0.40$0.35$0.06
2014Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.43$0.40$0.02
2013Detailed filing. Detailed filing data is available for this year.$0.00$0.02$0.02$0.42$0.44$0.02
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.00$0.00$0.00$0.80$0.80$0.00
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2016 filings • 501(c)7 • <$500k nonprofits