Civic Intelligence

Rotary Charitable Projects Foundation of Elgin ILL

990EZ • Fiscal year 2017 • EIN 36-6118259

Jul 01, 2016 to Jun 30, 2017 • Filed on Sep 29, 2017

PO Box 604Elgin, IL 60121

(847) 337-7984

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2017

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2017

Net Margin

25th percentile

-8.8%

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

54th percentile

4.2%

Faster asset growth than 54% of similar nonprofits.

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

Revenue Growth

19th percentile

-26%

Faster revenue growth than 19% of similar nonprofits.

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

Assets

Up

$153,708

Up $6,199 (+4.2%) from 2016

Net Assets

Up

$153,708

Up $6,574 (+4.5%) from 2016

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Down

$29,706

Down $10,505 (-26%) from 2016

Expenses

Down

$32,327

Down $487 (-1.5%) from 2016

Net Income

Down

-$2,621

Down $10,018 (-135%) from 2016

Historical Trend

Balance Sheet Trend

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

$200K$150K$100K$50K$0Assets 2011: $113,057Liabilities 2011: $1,500Net Assets 2011: $111,5572011Assets 2012: $118,402Liabilities 2012: $0Net Assets 2012: $118,4022012Assets 2013: $130,409Liabilities 2013: $1,200Net Assets 2013: $129,2092013Assets 2014: $171,118Liabilities 2014: $0Net Assets 2014: $171,1182014Assets 2015: $138,454Liabilities 2015: $0Net Assets 2015: $138,4542015Assets 2016: $147,509Liabilities 2016: $375Net Assets 2016: $147,1342016Assets 2017: $153,708Net Assets 2017: $153,7082017Assets 2018: $160,912Net Assets 2018: $160,9122018

Highlighted filing

2017

Assets$153,708
Liabilities-
Net Assets$153,708

Operations Trend

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

$100K$50K$0-$50KRevenue 2011: $57,034Expenses 2011: $42,147Net Income 2011: $14,8872011Revenue 2012: $61,103Expenses 2012: $54,258Net Income 2012: $6,8452012Revenue 2013: $58,380Expenses 2013: $47,573Net Income 2013: $10,8072013Revenue 2014: $64,197Expenses 2014: $22,288Net Income 2014: $41,9092014Revenue 2015: $36,567Expenses 2015: $69,231Net Income 2015: -$32,6642015Revenue 2016: $40,211Expenses 2016: $32,814Net Income 2016: $7,3972016Revenue 2017: $29,706Expenses 2017: $32,327Net Income 2017: -$2,6212017Revenue 2018: $34,300Expenses 2018: $32,988Net Income 2018: $1,3122018

Highlighted filing

2017

Revenue$29,706
Expenses$32,327
Net Income-$2,621
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Sep 29, 2017
Return Version
2016v3.0
Gross Receipts
$40,407
Mission and Program Overview

Mission

To provide scholarships and support of other charitable organizations.

Program Services

DescriptionGrantsExpenses
SCHOLARSHIPS PROVIDED$16,000$16,000
SUPPORT OF OTHER CHARITABLE ORGANIZATIONS.$7,200$7,200
FUNDING FOR YOUTH PROGRAMS.$1,050$1,050
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
RANDY BRITTAINPresident-$0--
MICHAEL MCKAYSecretary-$0--
RICK MOGLARDirector-$0--
CRAIG LAMPDirector-$0--
CYNTHIA ROZYCKITreasurer-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Rotary 5000$21,357$21,357$1,047$20,310
Total Events$21,357$21,357$10,701$10,656
Filing and Contact Details

Filer

Filer Name
Rotary Charitable Projects
EIN
36-6118259
Phone
8473377984
Address
PO BOX 604, ELGIN, IL 60121

Signing Officer

Name
Randy Brittain
Title
President
Phone
8477418000
Signed
2017-09-29
Discuss with paid preparer
Yes

Preparer

Firm
Eric J Fernandez & Co
Address
895 W MAIN ST STE 1000, WEST DUNDEE, IL 60118-2057
Preparer
Carl L Swanson
Phone
8474287400
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10

Elgin community college foundation 1700 spartan drive elgin, il 60123 10,000 0 0

Form 990-ez, Part I, Line 16

Expenses office 41 student day awards 6,836 paypal fees 110 interact expense 190 total 7,177

Form 990-ez, Part I, Line 20

Unrealized gain on market valuation 9,195

Form 990-ez, Part II, Line 24

Pledges receivable 1,370 580 due from rotary club of elgin il 150 0 american funds 90,593 100,229 total 92,113 100,809

Form 990-ez, Part II, Line 26

Accounts payable and accrued expenses 375 0

Raw XML Appendix189 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/PersonNm0CYNTHIA ROZYCKI
IRS990EZ/BooksInCareOfDetail/PhoneNum08473377984
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 604
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0ELGIN
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd060121
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt055396
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt052899
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt018609
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-2621
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0900
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0147509
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0153708
IRS990EZ/FundraisingGrossIncomeAmt021357
IRS990EZ/GrantsAndSimilarAmountsPaidAmt024250
IRS990EZ/GrossReceiptsAmt040407
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0441
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0147134
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0153708
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0147134
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0153708
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt31.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt41.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0RANDY BRITTAIN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MICHAEL MCKAY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2RICK MOGLAR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3CRAIG LAMP
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4CYNTHIA ROZYCKI
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt092113
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0100809
IRS990EZ/OtherChangesInNetAssetsAmt09195
IRS990EZ/OtherExpensesTotalAmt07177
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE SCHOLARSHIPS AND SUPPORT OF OTHER CHARITABLE ORGANIZATIONS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0SCHOLARSHIPS PROVIDED
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1SUPPORT OF OTHER CHARITABLE ORGANIZATIONS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2FUNDING FOR YOUTH PROGRAMS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt016000
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt17200
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt21050
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt016000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt17200
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt21050
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt010701
IRS990EZ/SpecialEventsNetIncomeLossAmt010656
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0IL
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt0375
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt032327
IRS990EZ/TotalProgramServiceExpensesAmt024250
IRS990EZ/TotalRevenueAmt029706
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationOtherDesc0CLUB
IRS990EZ/TypeOfOrganizationOtherInd0X
IRS990EZ/WebsiteAddressTxt0WWW.ROTARYCLUBOFELGIN.ORG
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt018609
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt025490
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt019552
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt036133
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt031701
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt0131485
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt0441
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt01639
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt01810
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt015384
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt010890
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt030164
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt021357
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt024875
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt028814
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt031095
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt029013
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0135154
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt0441
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt01639
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt01810
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt015384
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt010890
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt030164
IRS990ScheduleA/InvestmentIncomeCYPct00.10000
IRS990ScheduleA/InvestmentIncomePYPct00.09000
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.89840
IRS990ScheduleA/PublicSupportPY509Pct00.90750
IRS990ScheduleA/PublicSupportTotal509Amt0266639
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt039966
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt050365
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt048366
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt067228
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt060714
IRS990ScheduleA/Total509Grp/TotalAmt0266639
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt040407
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt052004
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt050176
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt082612
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt071604
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0296803
IRS990ScheduleG/FundraisingEventInformationGrp/CashPrizesEvent1Amt04800
IRS990ScheduleG/FundraisingEventInformationGrp/CashPrizesTotalEventsAmt04800
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt010701
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0ROTARY 5000
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageEvent1Amt04854
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageTotalEventsAmt04854
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt021357
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt021357
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt021357
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt021357
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt010656
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt01047
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt01047
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0ELGIN COMMUNITY COLLEGE FOUNDATION 1700 SPARTAN DRIVE ELGIN, IL 60123 10,000 0 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES OFFICE 41 STUDENT DAY AWARDS 6,836 PAYPAL FEES 110 INTERACT EXPENSE 190 TOTAL 7,177
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2UNREALIZED GAIN ON MARKET VALUATION 9,195
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3PLEDGES RECEIVABLE 1,370 580 DUE FROM ROTARY CLUB OF ELGIN IL 150 0 AMERICAN FUNDS 90,593 100,229 TOTAL 92,113 100,809
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4ACCOUNTS PAYABLE AND ACCRUED EXPENSES 375 0
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART I, LINE 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990-EZ, PART II, LINE 26
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0RANDY BRITTAIN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum08477418000
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-09-29
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROTARY CHARITABLE PROJECTS
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0FOUNDATION OF ELGIN ILLINOIS 60123
ReturnHeader/Filer/BusinessNameControlTxt0ROTA
ReturnHeader/Filer/EIN0366118259
ReturnHeader/Filer/PhoneNum08473377984
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 604
ReturnHeader/Filer/USAddress/CityNm0ELGIN
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060121
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId00EC7524827FD4F4F56914D46D871263604CBF856
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0DF3EEAC05A2AA73DCD8DCCC8BD7AF83DEAC9CD4D
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0363141842
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ERIC J FERNANDEZ & CO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0895 W MAIN ST STE 1000
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0WEST DUNDEE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0601182057
ReturnHeader/PreparerPersonGrp/PhoneNum08474287400
ReturnHeader/PreparerPersonGrp/PreparationDt02017-09-29
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0CARL L SWANSON
ReturnHeader/ReturnTs02017-10-30T12:37:40-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings