Civic Intelligence

Columbus Pipes & Drums

990EZ • Fiscal year 2017 • EIN 46-3557325

Jan 01, 2017 to Dec 31, 2017 • Filed on May 15, 2018

Organization ProfileN/A
120 Marconi BlvdColumbus, OH 43215

(614) 645-0348

Siviq Scores

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

Liabilities / Assets

56th percentile

0.00x

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

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

Liabilities / Revenue

56th percentile

0.00x

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

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

Net Margin

20th percentile

-13%

Higher net margin than 20% of similar nonprofits.

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

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

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

Asset Growth

32nd percentile

-7.2%

Faster asset growth than 32% of similar nonprofits.

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

Revenue Growth

78th percentile

29%

Faster revenue growth than 78% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets56th percentile

Assets

Down

$29,842

Down $2,322 (-7.2%) from 2016

Net Assets

Down

$29,842

Down $2,322 (-7.2%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin20th percentile

Revenue

Up

$17,284

Up $3,845 (+29%) from 2016

Expenses

Up

$19,606

Up $5,700 (+41%) from 2016

Net Income

Down

-$2,322

Down $1,855 (-397%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth32nd percentile

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

$80K$60K$40K$20K$0Assets 2013: $23,289Liabilities 2013: $02013Assets 2014: $22,587Net Assets 2014: $22,5872014Assets 2015: $32,631Liabilities 2015: $0Net Assets 2015: $32,6312015Assets 2016: $32,164Liabilities 2016: $0Net Assets 2016: $32,1642016Assets 2017: $29,842Liabilities 2017: $0Net Assets 2017: $29,8422017Assets 2018: $44,135Liabilities 2018: $0Net Assets 2018: $44,1352018Assets 2019: $55,896Liabilities 2019: $0Net Assets 2019: $55,8962019Assets 2020: $63,053Liabilities 2020: $0Net Assets 2020: $63,0532020Assets 2021: $58,714Liabilities 2021: $0Net Assets 2021: $58,7142021

Highlighted filing

2017

Assets$29,842
Liabilities$0
Net Assets$29,842
Open 2017 Filing

Operations Trend

Revenue Growth78th percentile

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

$30K$20K$10K$0-$10KRevenue 2013: $7,053Expenses 2013: $2,347Net Income 2013: $4,7062013Revenue 2014: $21,667Expenses 2014: $22,369Net Income 2014: -$7022014Revenue 2015: $18,366Expenses 2015: $8,322Net Income 2015: $10,0442015Revenue 2016: $13,439Expenses 2016: $13,906Net Income 2016: -$4672016Revenue 2017: $17,284Expenses 2017: $19,606Net Income 2017: -$2,3222017Revenue 2018: $23,998Expenses 2018: $9,705Net Income 2018: $14,2932018Revenue 2019: $23,853Expenses 2019: $12,092Net Income 2019: $11,7612019Revenue 2020: $15,516Expenses 2020: $8,359Net Income 2020: $7,1572020Revenue 2021: $400Expenses 2021: $4,739Net Income 2021: -$4,3392021

Highlighted filing

2017

Revenue$17,284
Expenses$19,606
Net Income-$2,322
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 15, 2018
Return Version
2017v2.2
Gross Receipts
$23,496
Mission and Program Overview

Mission

See Schedule O

Program Services

DescriptionGrantsExpenses
THE PIPE AND DRUM CORP PERFORMED AT VARIOUS EVENTS AND CELEBRATIONS THE FUNDS RAISED PAY FOR UNIFORMS INSTRUMENTS LOCAL TRANSPORATION AND TRAINING FOR OUR BAND MEMBERS-$23,027
PROVIDE FINANCIAL ASSISTANCE TO POLICE OFFICERS FAMILIES WHO HAVE SUFFERED UNFORTUNATE CIRCUMSTANCES-$2,350
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
KENNETH DECKERSecretary Treasurer-$0--
MARTIN KESTNERPresident-$0--
JAMES PARSONSVice President-$0--
Filing and Contact Details

Filer

Filer Name
Columbus Pipes & Drums
EIN
46-3557325
Address
120 MARCONI BLVD, Columbus, OH 43215

Signing Officer

Name
Kenneth Decker
Title
Secretarytreasu
Phone
6146450348
Signed
2018-05-15
Discuss with paid preparer
Yes

Preparer

Firm
Blue Line Tax Service
Address
5020 Grove City Road, Grove City, OH 43123
Preparer
Renita Dean
Phone
6142770507
Supplemental Narrative

Additional Explanations

General explanation attachment

“Form 990-EZ, Part III - Primary Exempt PurposeREPRESENT THE COLUMBUS POLICE AND FIRE DEPARMENTS AT COMMUNITY EVENTS, MEMORIAL SERVICES, CELEBRATIONS, AND PARADES WITH BAGPIPE AND DRUM CORP.”

Description of other expenses Part I line 16

“Description AmountWEBSITE HOSTING 197SUPPLIES 64TRAVEL 11,265FUNDRAISING EXP 1,950MISC 399REPAIRS, EQUIPMENT, UNIFORMS 2,417DONATIONS 2,350”

Raw XML Appendix149 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/PersonNm0KEN DECKER
IRS990EZ/BooksInCareOfDetail/PhoneNum06146450348
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0120 MARCONI BLVD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Columbus
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd043215
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt032164
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt029842
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt09443
IRS990EZ/CostOfGoodsSoldAmt06212
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-2322
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0705
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt032164
IRS990EZ/Form990TotalAssetsGrp/EOYAmt029842
IRS990EZ/FundraisingGrossIncomeAmt07096
IRS990EZ/GrossProfitLossSlsOfInvntryAmt0745
IRS990EZ/GrossReceiptsAmt023496
IRS990EZ/GrossSalesOfInventoryAmt06957
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt032164
IRS990EZ/NetAssetsOrFundBalancesEOYAmt029842
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt032164
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt029842
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0KENNETH DECKER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MARTIN KESTNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JAMES PARSONS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0SECRETARY TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2VICE PRESIDENT
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt018642
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0See Schedule O
IRS990EZ/PrintingPublicationsPostageAmt0259
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0THE PIPE AND DRUM CORP PERFORMED AT VARIOUS EVENTS AND CELEBRATIONS THE FUNDS RAISED PAY FOR UNIFORMS INSTRUMENTS LOCAL TRANSPORATION AND TRAINING FOR OUR BAND MEMBERS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1PROVIDE FINANCIAL ASSISTANCE TO POLICE OFFICERS FAMILIES WHO HAVE SUFFERED UNFORTUNATE CIRCUMSTANCES
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt023027
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt12350
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsNetIncomeLossAmt07096
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt019606
IRS990EZ/TotalProgramServiceExpensesAmt025377
IRS990EZ/TotalRevenueAmt017284
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt09443
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt07600
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt01381
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt04025
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt01425
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt023874
IRS990ScheduleA/GrossReceiptsRltdActivitiesAmt030755
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.45420
IRS990ScheduleA/PublicSupportPY170Pct00.40070
IRS990ScheduleA/PublicSupportTotal170Amt023874
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt09443
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt07600
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt01381
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt04025
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt01425
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt023874
IRS990ScheduleA/TotalSupportAmt052557
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/CurrentTaxYearAmt07096
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/CurrentTaxYearMinus2YearsAmt013442
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/CurrentTaxYearMinus3YearsAmt05970
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/CurrentTaxYearMinus4YearsAmt02175
IRS990ScheduleA/UnrelatedBusinessNetIncm170Grp/TotalAmt028683
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Form 990-EZ, Part III - Primary Exempt PurposeREPRESENT THE COLUMBUS POLICE AND FIRE DEPARMENTS AT COMMUNITY EVENTS, MEMORIAL SERVICES, CELEBRATIONS, AND PARADES WITH BAGPIPE AND DRUM CORP.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Description AmountWEBSITE HOSTING 197SUPPLIES 64TRAVEL 11,265FUNDRAISING EXP 1,950MISC 399REPAIRS, EQUIPMENT, UNIFORMS 2,417DONATIONS 2,350
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0General explanation attachment
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other expenses Part I line 16
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KENNETH DECKER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0SECRETARYTREASU
ReturnHeader/BusinessOfficerGrp/PhoneNum06146450348
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0COLUMBUS PIPES & DRUMS
ReturnHeader/Filer/BusinessNameControlTxt0COLU
ReturnHeader/Filer/EIN0463557325
ReturnHeader/Filer/USAddress/AddressLine1Txt0120 MARCONI BLVD
ReturnHeader/Filer/USAddress/CityNm0Columbus
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd043215
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0BD3E6A1DC7A1837542742B1AD63C315BAE7108BC
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0BD3E6A1DC7A1837542742B1AD63C315BAE7108BC
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId03128062018135ya5enn2
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-05-15
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt071.72.112.236
ReturnHeader/FilingSecurityInformation/IPDt02018-05-15
ReturnHeader/FilingSecurityInformation/IPTm016:00:14
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0814325689
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Blue Line Tax Service
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt05020 Grove City Road
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Grove City
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd043123
ReturnHeader/PreparerPersonGrp/PhoneNum06142770507
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-15
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Renita Dean
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-05-15T15:34:03-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
$29,842
Liabilities
$0
Net assets
$29,842
Revenue
$17,284
Expenses
$19,606
Net income
-$2,322
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2021Detailed filing. Detailed filing data is available for this year.$58.7$0.00$58.7$0.40$4.74$4.34
2020Detailed filing. Detailed filing data is available for this year.$63.1$0.00$63.1$15.5$8.36$7.16
2019Detailed filing. Detailed filing data is available for this year.$55.9$0.00$55.9$23.9$12.1$11.8
2018Detailed filing. Detailed filing data is available for this year.$44.1$0.00$44.1$24.0$9.71$14.3
2017Detailed filing. Detailed filing data is available for this year.$29.8$0.00$29.8$17.3$19.6$2.32
2016Detailed filing. Detailed filing data is available for this year.$32.2$0.00$32.2$13.4$13.9$0.47
2015Detailed filing. Detailed filing data is available for this year.$32.6$0.00$32.6$18.4$8.32$10.0
2014Detailed filing. Detailed filing data is available for this year.$22.6$22.6$21.7$22.4$0.70
2013Summary only. Only limited summary data is available for this year.$23.3$0.00$7.05$2.35$4.71