Civic Intelligence

Columbian Guild Inc

990EZ • Fiscal year 2014 • EIN 48-0734017

Jan 01, 2014 to Dec 31, 2014 • Filed on Jan 28, 2015

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

52nd percentile

0.00x

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

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

Liabilities / Revenue

52nd percentile

0.00x

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

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

Net Margin

58th percentile

5.5%

Higher net margin than 58% of similar nonprofits.

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

Top Officer Pay

91st percentile

$0

Higher top officer pay than 91% of similar nonprofits.

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

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

Asset Growth

45th percentile

0.0%

Faster asset growth than 45% of similar nonprofits.

2014 filings • 501(c)7 • <$500k nonprofits • Annualized from 2013 to 2014

Revenue Growth

49th percentile

1.6%

Faster revenue growth than 49% of similar nonprofits.

2014 filings • 501(c)7 • <$500k nonprofits • Annualized from 2013 to 2014

Balance Sheet
Liabilities / Assets52nd percentile

Assets

Up

$1

Up $1 from 2013

Net Assets

Up

$0

Up $2,356 (+100%) from 2013

Liabilities

Down

$0

Down $2,356 (-100%) from 2013

Revenue And Expenses
Liabilities / Revenue52nd percentileNet Margin58th percentile

Revenue

Up

$42,727

Up $654 (+1.6%) from 2013

Expenses

Down

$40,371

Down $4,058 (-9.1%) from 2013

Net Income

Up

$2,356

Up $4,712 (+200%) from 2013

Historical Trend

Balance Sheet Trend

Asset Growth45th 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: $1Liabilities 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

2014

Assets$1
Liabilities$0
Net Assets$0
Open 2014 Filing

Operations Trend

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

2014

Revenue$42,727
Expenses$40,371
Net Income$2,356
Open 2014 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2014 to Dec 31, 2014
Signed
Jan 28, 2015
Return Version
2014v5.0
Gross Receipts
$42,727
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 Pay91st 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
6202251421
Signed
2015-01-28
Discuss with paid preparer
Yes

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 260BENEFITS 10,520GIFTS DONATION 5,586TOOTSIE ROOLS 5,364TOY SHOW 1,982ARTS AND CRAFT 2,290TRANSFER 8,330”

Description of other expenses Part I line 16

“Description AmountMEETINGS 2,298DUES 3,836UBIT TAX 228OFFICE 3,880PROGRAMMING EXPENSES 30,129”

Description of total liabilities Part II line 26

“Category Beginning of Year End of YearKNIGHTS OF COLUMBUS 2,356 0”

Raw XML Appendix92 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/BOYAmt00
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt00
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt02356
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt00
IRS990EZ/Form990TotalAssetsGrp/EOYAmt00
IRS990EZ/GrossReceiptsAmt042727
IRS990EZ/GrossReceiptsForPublicUseAmt00
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InitiationFeesAndCapContriAmt00
IRS990EZ/InvestmentIncomeAmt06
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt08389
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-2356
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-2356
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt00
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/OtherExpensesTotalAmt040371
IRS990EZ/OtherRevenueTotalAmt034332
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/BOYAmt02356
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt040371
IRS990EZ/TotalRevenueAmt042727
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountREIMBURSEMENTS 260BENEFITS 10,520GIFTS DONATION 5,586TOOTSIE ROOLS 5,364TOY SHOW 1,982ARTS AND CRAFT 2,290TRANSFER 8,330
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description AmountMEETINGS 2,298DUES 3,836UBIT TAX 228OFFICE 3,880PROGRAMMING EXPENSES 30,129
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Category Beginning of Year End of YearKNIGHTS OF COLUMBUS 2,356 0
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other revenue Part I line 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other expenses Part I line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Description of total liabilities Part II line 26
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DAN STREMEL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum06202251421
ReturnHeader/BusinessOfficerGrp/SignatureDt02015-01-28
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/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/PreparationDt02015-04-03
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0RON SCHNEWEIS
ReturnHeader/ReturnTs02015-04-03T06:40:05-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02014-01-01
ReturnHeader/TaxPeriodEndDt02014-12-31
ReturnHeader/TaxYr02014

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1
Liabilities
$0
Net assets
$0
Revenue
$42,727
Expenses
$40,371
Net income
$2,356
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. 2014 filings • 501(c)7 • <$500k nonprofits