Civic Intelligence

Columbian Guild Inc

990EZ • Fiscal year 2018 • EIN 48-0734017

Jan 01, 2018 to Dec 31, 2018 • Filed on Mar 11, 2019

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.

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

Liabilities / Revenue

54th percentile

0.00x

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

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

Net Margin

84th percentile

20%

Higher net margin than 84% of similar nonprofits.

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

Top Officer Pay

93rd percentile

$0

Higher top officer pay than 93% of similar nonprofits.

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

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

Asset Growth

97th percentile

140%

Faster asset growth than 97% of similar nonprofits.

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

Revenue Growth

13th percentile

-22%

Faster revenue growth than 13% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets53rd percentile

Assets

Up

$10,385

Up $6,065 (+140%) from 2017

Net Assets

Up

$10,385

Up $6,065 (+140%) from 2017

Liabilities

Flat

$0

Flat from 2017

Revenue And Expenses
Liabilities / Revenue54th percentileNet Margin84th percentile

Revenue

Down

$30,241

Down $8,694 (-22%) from 2017

Expenses

Down

$24,176

Down $15,795 (-40%) from 2017

Net Income

Up

$6,065

Up $7,101 (+685%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth97th 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

2018

Assets$10,385
Liabilities$0
Net Assets$10,385
Open 2018 Filing

Operations Trend

Revenue Growth13th 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

2018

Revenue$30,241
Expenses$24,176
Net Income$6,065
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2018 to Dec 31, 2018
Signed
Mar 11, 2019
Return Version
2018v3.1
Gross Receipts
$30,241
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 Pay93rd 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
2019-03-11
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 AmountREIMBURSEMENTS 58PROGRAMMING 23,927”

Description of other expenses Part I line 16

“Description AmountDUES PAID 3,422MEETING 912OFFICE AND SUPPLIES 720OCCUPANY 129DONATIONS 18,993”

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/BOYAmt04320
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt010385
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt06065
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt04320
IRS990EZ/Form990TotalAssetsGrp/EOYAmt010385
IRS990EZ/GrossReceiptsAmt030241
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/InvestmentIncomeAmt028
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt06228
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt04320
IRS990EZ/NetAssetsOrFundBalancesEOYAmt010385
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt04320
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt010385
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/OtherExpensesTotalAmt024176
IRS990EZ/OtherRevenueTotalAmt023985
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/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt024176
IRS990EZ/TotalRevenueAmt030241
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountREIMBURSEMENTS 58PROGRAMMING 23,927
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description AmountDUES PAID 3,422MEETING 912OFFICE AND SUPPLIES 720OCCUPANY 129DONATIONS 18,993
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other revenue Part I line 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other expenses Part I line 16
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0DAN STREMEL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06202271500
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-03-11
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/AtSubmissionCreationDeviceId087BEABB1C874854748E0CD86B8339258BE0E0C1E
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId087BEABB1C874854748E0CD86B8339258BE0E0C1E
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId04800872019203mx4avkq
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02019-07-22
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt024.249.46.123
ReturnHeader/FilingSecurityInformation/IPDt02019-07-22
ReturnHeader/FilingSecurityInformation/IPTm014:11:03
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/PreparationDt02019-07-22
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0RON SCHNEWEIS
ReturnHeader/ReturnTs02019-07-22T14:09:53-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02018-01-01
ReturnHeader/TaxPeriodEndDt02018-12-31
ReturnHeader/TaxYr02018

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
$10,385
Liabilities
$0
Net assets
$10,385
Revenue
$30,241
Expenses
$24,176
Net income
$6,065
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
2018Detailed filing. Detailed filing data is available for this year.$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