Civic Intelligence

Rotary District 7870 Foundation

990EZ • Fiscal year 2013 • EIN 26-0197796

Jul 01, 2012 to Jun 30, 2013 • Filed on Nov 14, 2013

9 Old Coach Road03304
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 2013

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2013

Net Margin

77th percentile

20%

Higher net margin than 77% of similar nonprofits.

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

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2013

Asset Growth

51st percentile

2.2%

Faster asset growth than 51% of similar nonprofits.

2013 filings • 501(c)3 • <$500k nonprofits • Annualized from 2012 to 2013

Revenue Growth

13th percentile

-36%

Faster revenue growth than 13% of similar nonprofits.

2013 filings • 501(c)3 • <$500k nonprofits • Annualized from 2012 to 2013

Assets

Up

$371,930

Up $8,143 (+2.2%) from 2012

Net Assets

Up

$371,930

Up $8,143 (+2.2%) from 2012

Liabilities

-

No earlier filing loaded for comparison.

Revenue

Down

$40,361

Down $22,414 (-36%) from 2012

Expenses

Down

$32,146

Down $40,104 (-56%) from 2012

Net Income

Up

$8,215

Up $17,690 (+187%) from 2012

Historical Trend

Balance Sheet Trend

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

$800K$600K$400K$200K$0Assets 2012: $363,787Net Assets 2012: $363,7872012Assets 2013: $371,930Net Assets 2013: $371,9302013Assets 2014: $379,977Net Assets 2014: $379,9772014Assets 2015: $384,389Net Assets 2015: $384,3892015Assets 2016: $394,494Net Assets 2016: $394,4942016Assets 2017: $425,885Liabilities 2017: $0Net Assets 2017: $425,8852017Assets 2018: $424,047Liabilities 2018: $0Net Assets 2018: $424,0472018Assets 2019: $443,654Net Assets 2019: $443,6542019Assets 2020: $439,705Net Assets 2020: $439,7052020Assets 2021: $497,787Net Assets 2021: $497,7872021Assets 2022: $521,328Liabilities 2022: $1Net Assets 2022: $521,3272022Assets 2023: $505,600Liabilities 2023: $0Net Assets 2023: $505,6002023Assets 2024: $534,398Liabilities 2024: $0Net Assets 2024: $534,3982024Assets 2025: $613,585Liabilities 2025: $1Net Assets 2025: $613,5842025

Highlighted filing

2013

Assets$371,930
Liabilities-
Net Assets$371,930

Operations Trend

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

$300K$200K$100K$0-$100KRevenue 2012: $62,775Expenses 2012: $72,250Net Income 2012: -$9,4752012Revenue 2013: $40,361Expenses 2013: $32,146Net Income 2013: $8,2152013Revenue 2014: $48,212Expenses 2014: $48,868Net Income 2014: -$6562014Revenue 2015: $37,519Expenses 2015: $30,787Net Income 2015: $6,7322015Revenue 2016: $30,521Expenses 2016: $20,180Net Income 2016: $10,3412016Revenue 2017: $34,639Expenses 2017: $14,714Net Income 2017: $19,9252017Revenue 2018: $22,444Expenses 2018: $26,386Net Income 2018: -$3,9422018Revenue 2019: $36,030Expenses 2019: $21,587Net Income 2019: $14,4432019Revenue 2020: $26,719Expenses 2020: $22,951Net Income 2020: $3,7682020Revenue 2021: $39,533Expenses 2021: $21,130Net Income 2021: $18,4032021Revenue 2022: $243,828Expenses 2022: $189,957Net Income 2022: $53,8712022Revenue 2023: $66,891Expenses 2023: $82,618Net Income 2023: -$15,7272023Revenue 2024: $61,857Expenses 2024: $38,555Net Income 2024: $23,3022024Revenue 2025: $127,316Expenses 2025: $63,610Net Income 2025: $63,7062025

Highlighted filing

2013

Revenue$40,361
Expenses$32,146
Net Income$8,215
Jump To
Filing Snapshot
Filing Period
Jul 1, 2012 to Jun 30, 2013
Signed
Nov 14, 2013
Return Version
2012v2.3
Mission and Program Overview

Mission

For charitable, educational and scientific purposes

Filing and Contact Details

Filer

EIN
26-0197796
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
CompensationExplanation/Compensation/PersonName0JAN MCELROY
CompensationExplanation/Compensation/PersonName1ALLEY BOUCHER
CompensationExplanation/Compensation/PersonName2ALAN KANEGSBERG
CompensationExplanation/Compensation/PersonName3BARRY GRIFFITH
CompensationExplanation/Compensation/PersonName4PETER L POWERS
CompensationExplanation/Compensation/PersonName5DAVID HOOPES
CompensationExplanation/Compensation/PersonName6RICHARD BERRYMAN
CompensationExplanation/Compensation/PersonName7RICK MANGANELLO
CompensationExplanation/Compensation/PersonName8A ROBERT COUCH
CompensationExplanation/Compensation/PersonName9HUGH HAGGERTY
CompensationExplanation/Compensation/PersonName10CHRISTOPHER PARKINSON
IRS990EZ/ActivitiesNotPreviouslyRpt0false
IRS990EZ/CashSavingsAndInvestments/BOY0125849
IRS990EZ/CashSavingsAndInvestments/EOY0134054
IRS990EZ/ContributionsGiftsGrantsEtc031764
IRS990EZ/DidOrgFileForm1120POLThisYear0false
IRS990EZ/DoesOrgHaveHospital0false
IRS990EZ/EngagedInExcessBenefitTrans0false
IRS990EZ/EngageInLobbyingActivities0false
IRS990EZ/EngagePoliticalCmpgnActivities0false
IRS990EZ/ExcessOrDeficitForYear08215
IRS990EZ/FiledScheduleA0true
IRS990EZ/ForeignFinancialAccount0false
IRS990EZ/ForeignOffice0false
IRS990EZ/GrossReceipts040361
IRS990EZ/InfoInScheduleOPartI0X
IRS990EZ/InfoInScheduleOPartII0X
IRS990EZ/InfoInScheduleOPartIII0X
IRS990EZ/InvestmentIncome04922
IRS990EZ/MadeChangesToOrgnzngEtcDoc0false
IRS990EZ/MadeLoansToFromOfficers0false
IRS990EZ/MaintainAnyDonorAdvisedFunds0false
IRS990EZ/MethodOfAccountingCash0X
IRS990EZ/NetAssetsOrFundBalances/BOY0363787
IRS990EZ/NetAssetsOrFundBalancesBOY0363787
IRS990EZ/NetAssetsOrFundBalances/EOY0371930
IRS990EZ/NetAssetsOrFundBalancesEOY0371930
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition01.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition13.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition23.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition31.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition41.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition53.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition61.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition71.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition81.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition91.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition101.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation50
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation60
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation70
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation80
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation90
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation100
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName0JAN MCELROY
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName1ALLEY BOUCHER
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName2ALAN KANEGSBERG
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName3BARRY GRIFFITH
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName4PETER L POWERS
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName5DAVID HOOPES
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName6RICHARD BERRYMAN
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName7RICK MANGANELLO
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName8A ROBERT COUCH
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName9HUGH HAGGERTY
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName10CHRISTOPHER PARKINSON
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title0TRUSTEE AT L
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title1PRESIDENT
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title2TREASURER
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title3TRUSTEE-PAST
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title4TRUSTEE-PDG
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title5SECRETARY
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title6TRUSTEE-PAST
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title7TRUSTEE-PDG
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title8TRUSTEE-AT L
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title9TRUSTEE-AT L
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title10TRUSTEE-AT L
IRS990EZ/OperatingSchool0false
IRS990EZ/Organization501c30X
IRS990EZ/OrganizationDissolvedEtc0false
IRS990EZ/OrganizationHadUBI0false
IRS990EZ/OtherAssetsTotal/BOY0237938
IRS990EZ/OtherAssetsTotal/EOY0237876
IRS990EZ/OtherChangesInNetAssets0-72
IRS990EZ/OtherExpensesTotal032146
IRS990EZ/OtherRevenueTotal03675
IRS990EZ/PartVIAHghstPaidCntrctProfSer0NONE
IRS990EZ/PartVIOfCompOfHighestPaidEmpl0NONE
IRS990EZ/PrimaryExemptPurpose0FOR CHARITABLE, EDUCATIONAL AND SCIENTIFIC PURPOSES
IRS990EZ/ProgramServiceAccomplishment/DescriptionProgramServiceAccom0TO SEND TEAMS OF ROTARIANS AND STUDENTS TO HONDURAS AND HAITI TO BUILD AND REPAIR SCHOOLS, PROVIDE WATER FILTERS AND THEIR INSTALLATION AND TRAINING, AND PROVIDE MEDICAL EQUIPMENT AND ONSITE MEDICAL SERVICES FOR RESIDENTS OF THE COUNTRIES
IRS990EZ/ProgramServiceAccomplishment/DescriptionProgramServiceAccom1TO PROVIDE FOR THE PRESERVATION & MAINTENANCE OF THE "LITTLE RED SCHOOLHOUSE" ATTENDED BY PAUL HARRIS, FOUNDER OF ROTARY INTERNATIONAL, AND ALSO ARTIFACTS OF HISTORIC SIGNIFICANCE FOR PUBLIC DISPLAY, EDUCATION & STUDY BY MEMBERS OF SOCIETY.
IRS990EZ/ProgramServiceAccomplishment/ProgramServiceExpenses018339
IRS990EZ/ProgramServiceAccomplishment/ProgramServiceExpenses112205
IRS990EZ/ProhibitedTaxShelterTrans0false
IRS990EZ/RelatedOrgControlledEntity0false
IRS990EZ/ScheduleBNotRequired0X
IRS990EZ/StatesWhereCopyOfReturnIsFiled0NH
IRS990EZ/SubjectToProxyTax0false
IRS990EZ/TanningServicesProvided0false
IRS990EZ/TheBooksAreInCareOf/AddressUS/AddressLine109 OLD COACH ROAD
IRS990EZ/TheBooksAreInCareOf/AddressUS/City0BOW
IRS990EZ/TheBooksAreInCareOf/AddressUS/State0NH
IRS990EZ/TheBooksAreInCareOf/AddressUS/ZIPCode003304
IRS990EZ/TheBooksAreInCareOf/NamePerson0ALAN KANEGSBERG
IRS990EZ/TheBooksAreInCareOf/TelephoneNumber06032246377
IRS990EZ/TotalAssets/BOY0363787
IRS990EZ/TotalAssets/EOY0371930
IRS990EZ/TotalExpenses032146
IRS990EZ/TotalProgramServiceExpenses030544
IRS990EZ/TotalRevenue040361
IRS990EZ/TransactionWithControlEntity0false
IRS990EZ/TrnsfrsExemptNonCharRelatedOrg0false
IRS990EZ/WebSite0N/A
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYear031764
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYearMinus1Year049683
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYearMinus2Years032707
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYearMinus3Years013176
IRS990ScheduleA/GiftsGrantsContribReceived509/CurrentTaxYearMinus4Years016288
IRS990ScheduleA/GiftsGrantsContribReceived509/Total0143618
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYear08597
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYearMinus1Year013092
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYearMinus2Years08694
IRS990ScheduleA/GrossReceiptsFromAdmissions/CurrentTaxYearMinus3Years03801
IRS990ScheduleA/GrossReceiptsFromAdmissions/Total034184
IRS990ScheduleA/InvestmentIncomePercentage00.00000
IRS990ScheduleA/PriorYearSupportPercentage00.98590
IRS990ScheduleA/PubliclySupportedOrg509a20X
IRS990ScheduleA/PublicSupportPercentage50901.00000
IRS990ScheduleA/PublicSupportTotal5090177802
IRS990ScheduleA/ThirtyThreePercntTestsCY5090X
IRS990ScheduleA/Total509/CurrentTaxYear040361
IRS990ScheduleA/Total509/CurrentTaxYearMinus1Year062775
IRS990ScheduleA/Total509/CurrentTaxYearMinus2Years041401
IRS990ScheduleA/Total509/CurrentTaxYearMinus3Years016977
IRS990ScheduleA/Total509/CurrentTaxYearMinus4Years016288
IRS990ScheduleA/Total509/Total0177802
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYear040361
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYearMinus1Year062775
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYearMinus2Years041401
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYearMinus3Years016977
IRS990ScheduleA/TotalSupportTotal/CurrentTaxYearMinus4Years016288
IRS990ScheduleA/TotalSupportTotal/Total0177802
IRS990ScheduleO/GeneralExplanation/Explanation0AMIGOS HONDURAS PARTICIP FEES 3,375 MISCELLANEOUS FUNCTION INCOME 300 TOTAL 3,675
IRS990ScheduleO/GeneralExplanation/Explanation1EXPENSES IN COUNTRY EXPENSES 3,722 OPERATING EXPENSES-AMIG 75 MEDICAL SUPPLIES 1,000 CONSTRUCTION MATERIALS 7,000 PURE WATER PROJECTS 2,500 LITERACY PROJECTS 3,958 WIRE FEES 84 MAINTENANCE-LRS 245 BUILDING REPAIRS-LRS 2,854 INSURANCE-LRS 1,657 PROPANE-LRS 2,845 ELECTRICITY-LRS 695 WATER & SEWER-LRS 628 REAL ESTATE TAX-LRS 242 FUND RSNG-PH MEM. GARDN 1,602 PAUL HARRIS MEM GARDEN 3,039 TOTAL 32,146
IRS990ScheduleO/GeneralExplanation/Explanation2UNREALIZED GAIN -VANGUARD INVESTMENT 0 UNREALIZED LOSSES ON INVESTMENT -72
IRS990ScheduleO/GeneralExplanation/Explanation3INVENTORIES FOR SALE OR USE 1,938 1,876 LITTLE RED SCHOOLHOUSE FMV D/O TRANS 236,000 236,000 TOTAL 237,938 237,876
IRS990ScheduleO/GeneralExplanation/Explanation4TO SEND TEAMS OF ROTARIANS AND STUDENTS TO HONDURAS AND HAITI TO BUILD AND REPAIR SCHOOLS, PROVIDE WATER FILTERS AND THEIR INSTALLATION AND TRAINING, AND PROVIDE MEDICAL EQUIPMENT AND ONSITE MEDICAL SERVICES FOR RESIDENTS OF THE COUNTRIES
IRS990ScheduleO/GeneralExplanation/Explanation5TO PROVIDE FOR THE PRESERVATION & MAINTENANCE OF THE "LITTLE RED SCHOOLHOUSE" ATTENDED BY PAUL HARRIS, FOUNDER OF ROTARY INTERNATIONAL, AND ALSO ARTIFACTS OF HISTORIC SIGNIFICANCE FOR PUBLIC DISPLAY, EDUCATION & STUDY BY MEMBERS OF SOCIETY.
IRS990ScheduleO/GeneralExplanation/Identifier0OTHER REVENUE
IRS990ScheduleO/GeneralExplanation/Identifier1OTHER EXPENSES
IRS990ScheduleO/GeneralExplanation/Identifier2OTHER CHANGES IN NET ASSETS OR FUND BALANCES
IRS990ScheduleO/GeneralExplanation/Identifier3OTHER ASSETS
IRS990ScheduleO/GeneralExplanation/Identifier4FIRST ACCOMPLISHMENT
IRS990ScheduleO/GeneralExplanation/Identifier5SECOND ACCOMPLISHMENT
IRS990ScheduleO/GeneralExplanation/ReturnReference0FORM 990-EZ, PART I, LINE 8
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/GeneralExplanation/ReturnReference2FORM 990-EZ, PART I, LINE 20
IRS990ScheduleO/GeneralExplanation/ReturnReference3FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/GeneralExplanation/ReturnReference4FORM 990-EZ, PART III, LINE 28
IRS990ScheduleO/GeneralExplanation/ReturnReference5FORM 990-EZ, PART III, LINE 29
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/Filer/EIN0260197796
ReturnHeader/Filer/Name/BusinessNameLine10ROTARY DISTRICT 7870 FOUNDATION
ReturnHeader/Filer/NameControl0ROTA
ReturnHeader/Filer/USAddress/AddressLine109 OLD COACH ROAD
ReturnHeader/Filer/USAddress/City0BOW
ReturnHeader/Filer/USAddress/State0NH
ReturnHeader/Filer/USAddress/ZIPCode003304
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-11-14
ReturnHeader/Officer/Name0ALAN KANEGSBERG
ReturnHeader/Officer/Title0TREASURER
ReturnHeader/Preparer/DatePrepared02013-11-14
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10BURNHAM & MALMBORG
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10155 MANCHESTER STREET
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0CONCORD
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0NH
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode003301
ReturnHeader/Preparer/Name0HERBERT C BURNHAM
ReturnHeader/Preparer/Phone06032257600
ReturnHeader/ReturnType0990EZ
ReturnHeader/TaxPeriodBeginDate02012-07-01
ReturnHeader/TaxPeriodEndDate02013-06-30
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-11-14T15:25:10-06:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Facts available. Structured filing facts are available, but richer extracted sections are limited.$6.14$0.00$6.14$1.27$0.64$0.64
2024Detailed filing. Detailed filing data is available for this year.$5.34$0.00$5.34$0.62$0.39$0.23
2023Detailed filing. Detailed filing data is available for this year.$5.06$0.00$5.06$0.67$0.83$0.16
2022Detailed filing. Detailed filing data is available for this year.$5.21$0.00$5.21$2.44$1.90$0.54
2021Detailed filing. Detailed filing data is available for this year.$4.98$4.98$0.40$0.21$0.18
2020Detailed filing. Detailed filing data is available for this year.$4.40$4.40$0.27$0.23$0.04
2019Detailed filing. Detailed filing data is available for this year.$4.44$4.44$0.36$0.22$0.14
2018Detailed filing. Detailed filing data is available for this year.$4.24$0.00$4.24$0.22$0.26$0.04
2017Detailed filing. Detailed filing data is available for this year.$4.26$0.00$4.26$0.35$0.15$0.20
2016Detailed filing. Detailed filing data is available for this year.$3.94$3.94$0.31$0.20$0.10
2015Detailed filing. Detailed filing data is available for this year.$3.84$3.84$0.38$0.31$0.07
2014Detailed filing. Detailed filing data is available for this year.$3.80$3.80$0.48$0.49$0.01
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.72$3.72$0.40$0.32$0.08
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.64$3.64$0.63$0.72$0.09