Civic Intelligence

Teamsters Local 317 Education and Learning Trust

990EZ • Fiscal year 2017 • EIN 20-2603729

Jan 01, 2017 to Dec 31, 2017 • Filed on Jun 28, 2018

PO Box 11037 Franklin Sq StationSyracuse, NY 13218

(315) 471-4164

Siviq Scores

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

Liabilities / Assets

90th percentile

0.56x

Higher debt load relative to assets than 90% of similar nonprofits.

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

Liabilities / Revenue

97th percentile

1.52x

Higher debt load relative to revenue than 97% of similar nonprofits.

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

Net Margin

80th percentile

24%

Higher net margin than 80% 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

30th percentile

-8.6%

Faster asset growth than 30% of similar nonprofits.

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

Revenue Growth

8th percentile

-54%

Faster revenue growth than 8% of similar nonprofits.

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

Assets

Down

$92,182

Down $8,699 (-8.6%) from 2016

Net Assets

Up

$40,960

Up $8,112 (+25%) from 2016

Liabilities

Down

$51,222

Down $16,811 (-25%) from 2016

Revenue

Down

$33,780

Down $40,230 (-54%) from 2016

Expenses

Down

$25,668

Down $24,116 (-48%) from 2016

Net Income

Down

$8,112

Down $16,114 (-67%) from 2016

Historical Trend

Balance Sheet Trend

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

$200K$100K$0-$100KAssets 2010: $61,892Liabilities 2010: $146,020Net Assets 2010: -$84,1282010Assets 2011: $43,995Liabilities 2011: $138,743Net Assets 2011: -$94,7482011Assets 2012: $30,012Liabilities 2012: $129,661Net Assets 2012: -$99,6492012Assets 2013: $19,788Liabilities 2013: $116,313Net Assets 2013: -$96,5252013Assets 2014: $43,435Liabilities 2014: $100,418Net Assets 2014: -$56,9832014Assets 2015: $93,215Liabilities 2015: $84,593Net Assets 2015: $8,6222015Assets 2016: $100,881Liabilities 2016: $68,033Net Assets 2016: $32,8482016Assets 2017: $92,182Liabilities 2017: $51,222Net Assets 2017: $40,9602017Assets 2018: $88,350Liabilities 2018: $33,687Net Assets 2018: $54,6632018Assets 2019: $84,561Liabilities 2019: $16,204Net Assets 2019: $68,3572019Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020

Highlighted filing

2017

Assets$92,182
Liabilities$51,222
Net Assets$40,960

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2010: $71,715Expenses 2010: $71,049Net Income 2010: $6662010Revenue 2011: $41,940Expenses 2011: $52,560Net Income 2011: -$10,6202011Revenue 2012: $52,361Expenses 2012: $57,262Net Income 2012: -$4,9012012Revenue 2013: $38,800Expenses 2013: $35,676Net Income 2013: $3,1242013Revenue 2014: $79,040Expenses 2014: $39,498Net Income 2014: $39,5422014Revenue 2015: $122,070Expenses 2015: $56,465Net Income 2015: $65,6052015Revenue 2016: $74,010Expenses 2016: $49,784Net Income 2016: $24,2262016Revenue 2017: $33,780Expenses 2017: $25,668Net Income 2017: $8,1122017Revenue 2018: $29,090Expenses 2018: $15,387Net Income 2018: $13,7032018Revenue 2019: $25,419Expenses 2019: $11,725Net Income 2019: $13,6942019Revenue 2020: $6,564Expenses 2020: $3,692Net Income 2020: $2,8722020

Highlighted filing

2017

Revenue$33,780
Expenses$25,668
Net Income$8,112
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Jun 28, 2018
Return Version
2017v2.3
Gross Receipts
$33,780
Mission and Program Overview

Mission

To offer courses to enhance an individual's occupational skills.

Program Services

DescriptionGrantsExpenses
TO ADVANCE THE WELL BEING OF TEAMSTER BY THE CREATION AND OPERATION OF AN EDUCATION AND TRAINING ORGANIZATION TO OFFER COURSES TO ENHANCE 50 INDIVIDUAL OCCUPATIONAL SKILLS.$0$25,668
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
DUANE WRIGHTTrustee-$0--
MIKE CIMILLUCATrustee-$0--
MARK D MAYTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Teamsters Local 317 Education and
EIN
20-2603729
Phone
3154714164
Address
PO BOX 11037 FRANKLIN SQ STATION, SYRACUSE, NY 13218

Signing Officer

Name
Mark D May
Title
Trustee
Phone
3154714164
Signed
2018-06-28
Discuss with paid preparer
Yes

Preparer

Firm
D'ARCANGELO & CO LLP
Address
120 LOMOND COURT, UTICA, NY 13502-5950
Preparer
Courtney a Pearsall CPA
Phone
3157355216
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 8 - Other Revenue

Description: advertising income. Amount: 18,000.

Form 990-ez, Part I, Line 16 - Other Expenses

Description: office expenses. Amount: 43. Description: insurance. Amount: 7,530. Description: interest. Amount: 1,201. Description: truck operating expenses. Amount: 6,762. Description: registrations and fees. Amount: 1,776. Description: physical and drug testing. Amount: 716. Total to form 990-ez, line 16: 18,028.

Form 990-ez, Part II, Line 24 - Other Assets

Description: prepaid expenses. Beg. Of year amount: 3,276. End of year amount: 3,231.

Form 990-ez, Part II, Line 26 - Other Liabilities

Description: loan payable - local 317. Beg. Of year amount: 67,624. End of year amount: 50,825. Description: payroll taxes. Beg. Of year amount: 409. End of year amount: 397.

Raw XML Appendix153 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/ActivitiesNotPreviouslyRptInd00
IRS990EZ/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0KELLIE MANGAN
IRS990EZ/BooksInCareOfDetail/PhoneNum03154714164
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0566 SPENCER STREET
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0SYRACUSE
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0NY
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd013204
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt097605
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt088951
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/EngagedInExcessBenefitTransInd00
IRS990EZ/ExcessOrDeficitForYearAmt08112
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt03533
IRS990EZ/FiledScheduleAInd01
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0100881
IRS990EZ/Form990TotalAssetsGrp/EOYAmt092182
IRS990EZ/GrossReceiptsAmt033780
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/LobbyingActivitiesInd00
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt032848
IRS990EZ/NetAssetsOrFundBalancesEOYAmt040960
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt032848
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt040960
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.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/PersonNm0DUANE WRIGHT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MIKE CIMILLUCA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2MARK D MAY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TRUSTEE
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherAssetsTotalDetail/BOYAmt03276
IRS990EZ/OtherAssetsTotalDetail/EOYAmt03231
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/OtherExpensesTotalAmt018028
IRS990EZ/OtherRevenueTotalAmt018000
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0TO OFFER COURSES TO ENHANCE AN INDIVIDUAL'S OCCUPATIONAL SKILLS.
IRS990EZ/ProgramServiceRevenueAmt015780
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO ADVANCE THE WELL BEING OF TEAMSTER BY THE CREATION AND OPERATION OF AN EDUCATION AND TRAINING ORGANIZATION TO OFFER COURSES TO ENHANCE 50 INDIVIDUAL OCCUPATIONAL SKILLS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt025668
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/SalariesOtherCompEmplBnftAmt04107
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd01
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt068033
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt051222
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt025668
IRS990EZ/TotalProgramServiceExpensesAmt025668
IRS990EZ/TotalRevenueAmt033780
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd00
IRS990EZ/TypeOfOrganizationTrustInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/SchoolInd0X
IRS990ScheduleE/ComplianceWithRevProc7550Ind01
IRS990ScheduleE/DiscriminateRaceAdmissPlcyInd00
IRS990ScheduleE/DiscriminateRaceAthltProgInd00
IRS990ScheduleE/DiscriminateRaceEducPlcyInd00
IRS990ScheduleE/DiscriminateRaceEmplmFcultyInd00
IRS990ScheduleE/DiscriminateRaceOtherActyInd00
IRS990ScheduleE/DiscriminateRaceSchsInd00
IRS990ScheduleE/DiscriminateRaceStdntsRghtsInd00
IRS990ScheduleE/DiscriminateRaceUseOfFcltsInd00
IRS990ScheduleE/GovernmentFinancialAidRcvdInd00
IRS990ScheduleE/GovernmentFinancialAidRvkdInd00
IRS990ScheduleE/MaintainCpyOfAllSolInd01
IRS990ScheduleE/MaintainCpyOfBrochuresEtcInd01
IRS990ScheduleE/MaintainRacialCompRecsInd01
IRS990ScheduleE/MaintainScholarshipsRecsInd01
IRS990ScheduleE/NondiscriminatoryPolicyStmtInd01
IRS990ScheduleE/PlcyPblczdViaBroadcastMediaInd01
IRS990ScheduleE/PolicyStmtInBrochuresEtcInd01
IRS990ScheduleE/SupplementalInformationDetail/ExplanationTxt0THE FOLLOWING NOTICE APPEARED IN THE POST STANDARD ON FEBRUARY 1, 2009: "THE 317 DRIVING SCHOOL ADMITS STUDENTS OF ANY RACE, COLOR, NATIONAL ORIGIN, AND ETHNIC ORIGIN TO ALL RIGHTS, PRIVILEGES, PROGRAMS, AND ACTIVITIES GENERALLY ACCORDED OR MAKE AVAILABLE TO STUDENTS AT THE SCHOOL. IT DOES NOT DISCRIMINATE ON THE BASIS OF RACE, COLOR, NATIONAL ORIGIN AND ETHNIC ORIGIN IN ADMINISTRATION OF ITS EDUCATIONAL POLICIES, ADMISSIONS POLICIES, SCHOLARSHIP AND LOAN PROGRAMS, AND OTHER SCHOOL ADMINISTERED PROGRAMS".
IRS990ScheduleE/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE E, PART I, LINE 3
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION: ADVERTISING INCOME. AMOUNT: 18,000.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1DESCRIPTION: OFFICE EXPENSES. AMOUNT: 43. DESCRIPTION: INSURANCE. AMOUNT: 7,530. DESCRIPTION: INTEREST. AMOUNT: 1,201. DESCRIPTION: TRUCK OPERATING EXPENSES. AMOUNT: 6,762. DESCRIPTION: REGISTRATIONS AND FEES. AMOUNT: 1,776. DESCRIPTION: PHYSICAL AND DRUG TESTING. AMOUNT: 716. TOTAL TO FORM 990-EZ, LINE 16: 18,028.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DESCRIPTION: PREPAID EXPENSES. BEG. OF YEAR AMOUNT: 3,276. END OF YEAR AMOUNT: 3,231.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3DESCRIPTION: LOAN PAYABLE - LOCAL 317. BEG. OF YEAR AMOUNT: 67,624. END OF YEAR AMOUNT: 50,825. DESCRIPTION: PAYROLL TAXES. BEG. OF YEAR AMOUNT: 409. END OF YEAR AMOUNT: 397.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 8 - OTHER REVENUE
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16 - OTHER EXPENSES
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 24 - OTHER ASSETS
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 26 - OTHER LIABILITIES
TransferPrsnlBnftContractsDecl/DeclarationDesc0THE ORGANIZATION DID NOT, DURING THE YEAR, RECEIVE ANY FUNDS, DIRECTLY,OR INDIRECTLY, TO PAY PREMIUMS ON A PERSONAL BENEFIT CONTRACT.THE ORGANIZATION, DID NOT, DURING THE YEAR, PAY ANY PREMIUMS, DIRECTLY,OR INDIRECTLY, ON A PERSONAL BENEFIT CONTRACT.
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0MARK D MAY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum03154714164
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-06-28
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0TEAMSTERS LOCAL 317 EDUCATION AND
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0LEARNING TRUST
ReturnHeader/Filer/BusinessNameControlTxt0TEAM
ReturnHeader/Filer/EIN0202603729
ReturnHeader/Filer/PhoneNum03154714164
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 11037 FRANKLIN SQ STATION
ReturnHeader/Filer/USAddress/CityNm0SYRACUSE
ReturnHeader/Filer/USAddress/StateAbbreviationCd0NY
ReturnHeader/Filer/USAddress/ZIPCd013218
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId01BE6195DF1D7FDC71E685761E3EB3E78AE452CB6
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A515CF4B3DD06CED8D750AC084C2E03101E91E81
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0209.217.215.146
ReturnHeader/FilingSecurityInformation/IPDt02018-06-28
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0ED
ReturnHeader/FilingSecurityInformation/IPTm016:28:27
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0132550103
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0D'ARCANGELO & CO LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0120 LOMOND COURT
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0UTICA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0NY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0135025950
ReturnHeader/PreparerPersonGrp/PhoneNum03157355216
ReturnHeader/PreparerPersonGrp/PreparationDt02018-06-28
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0COURTNEY A PEARSALL CPA
ReturnHeader/ReturnTs02018-06-29T12:29:25-05: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