Civic Intelligence

Columbian Guild Inc

990EZ • Fiscal year 2017 • EIN 48-0734017

Jan 01, 2017 to Dec 31, 2017 • Filed on Jan 24, 2018

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.

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

Liabilities / Revenue

53rd percentile

0.00x

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

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

Net Margin

32nd percentile

-2.7%

Higher net margin than 32% of similar nonprofits.

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

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.

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

Asset Growth

13th percentile

-19%

Faster asset growth than 13% of similar nonprofits.

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

Revenue Growth

92nd percentile

46%

Faster revenue growth than 92% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets53rd percentile

Assets

Down

$4,320

Down $1,036 (-19%) from 2016

Net Assets

Down

$4,320

Down $1,036 (-19%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue53rd percentileNet Margin32nd percentile

Revenue

Up

$38,935

Up $12,328 (+46%) from 2016

Expenses

Up

$39,971

Up $13,059 (+49%) from 2016

Net Income

Down

-$1,036

Down $731 (-240%) from 2016

Historical Trend

Balance Sheet Trend

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

2017

Assets$4,320
Liabilities$0
Net Assets$4,320
Open 2017 Filing

Operations Trend

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

2017

Revenue$38,935
Expenses$39,971
Net Income-$1,036
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Jan 24, 2018
Return Version
2017v2.2
Gross Receipts
$38,935
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 Stramel
Title
President
Phone
6202271500
Signed
2018-01-24
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 31,073”

Description of other expenses Part I line 16

“Description AmountDUES PAID 3,650MEETING 1,824OFFICE AND SUPPLIES 1,539OCCUPANY 326DONATIONS 32,632”

Raw XML Appendix97 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/BOYAmt05356
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt04320
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-1036
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt05356
IRS990EZ/Form990TotalAssetsGrp/EOYAmt04320
IRS990EZ/GrossReceiptsAmt038935
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt07862
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt05356
IRS990EZ/NetAssetsOrFundBalancesEOYAmt04320
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt05356
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt04320
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/OtherExpensesTotalAmt039971
IRS990EZ/OtherRevenueTotalAmt031073
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/TotalExpensesAmt039971
IRS990EZ/TotalRevenueAmt038935
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountPROGRAMMING 31,073
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description AmountDUES PAID 3,650MEETING 1,824OFFICE AND SUPPLIES 1,539OCCUPANY 326DONATIONS 32,632
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other revenue Part I line 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other expenses Part I line 16
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0DAN STRAMEL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06202271500
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-01-24
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/FederalOriginalSubmissionId048008720181071ebo0cy
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-04-17
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt070.182.250.172
ReturnHeader/FilingSecurityInformation/IPDt02018-04-17
ReturnHeader/FilingSecurityInformation/IPTm014:56:56
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/PreparationDt02018-04-17
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0RON SCHNEWEIS
ReturnHeader/ReturnTs02018-04-17T06:54:24-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$4,320
Liabilities
$0
Net assets
$4,320
Revenue
$38,935
Expenses
$39,971
Net income
-$1,036
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
2017Detailed filing. Detailed filing data is available for this year.$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. 2017 filings • 501(c)7 • <$500k nonprofits