Civic Intelligence

Ryan Bartel Foundation Inc.

990EZ • Fiscal year 2017 • EIN 47-5129027

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

Organization Profilewww.ryanbartelfoundation.org
40815 Hannah DriveWaterford, VA 20197

(703) 431-3675

Siviq Scores

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

Liabilities / Assets

67th percentile

0.02x

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

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

Liabilities / Revenue

72nd percentile

0.03x

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

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

Net Margin

95th percentile

71%

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

94th percentile

162%

Faster asset growth than 94% of similar nonprofits.

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

Revenue Growth

85th percentile

48%

Faster revenue growth than 85% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets67th percentile

Assets

Up

$109,450

Up $67,597 (+162%) from 2016

Net Assets

$106,950

No earlier filing loaded for comparison.

Liabilities

Up

$2,500

Up $2,500 from 2016

Revenue And Expenses
Liabilities / Revenue72nd percentileNet Margin95th percentile

Revenue

Up

$92,044

Up $29,901 (+48%) from 2016

Expenses

Up

$26,947

Up $6,637 (+33%) from 2016

Net Income

Up

$65,097

Up $23,264 (+56%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth94th percentile

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

$800K$600K$400K$200K$0Assets 2016: $41,853Liabilities 2016: $02016Assets 2017: $109,450Liabilities 2017: $2,500Net Assets 2017: $106,9502017Assets 2018: $116,036Liabilities 2018: $2,000Net Assets 2018: $114,0362018Assets 2019: $132,598Liabilities 2019: $0Net Assets 2019: $132,5982019Assets 2020: $178,094Liabilities 2020: $10,000Net Assets 2020: $168,0942020Assets 2021: $248,645Liabilities 2021: $15,000Net Assets 2021: $233,6452021Assets 2022: $425,389Liabilities 2022: $54,333Net Assets 2022: $371,0562022Assets 2023: $604,057Liabilities 2023: $9,645Net Assets 2023: $594,4122023Assets 2024: $786,277Liabilities 2024: $40,360Net Assets 2024: $745,9172024

Highlighted filing

2017

Assets$109,450
Liabilities$2,500
Net Assets$106,950
Open 2017 Filing

Operations Trend

Revenue Growth85th percentile

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

$800K$600K$400K$200K$0Revenue 2016: $62,143Expenses 2016: $20,310Net Income 2016: $41,8332016Revenue 2017: $92,044Expenses 2017: $26,947Net Income 2017: $65,0972017Revenue 2018: $124,434Expenses 2018: $117,348Net Income 2018: $7,0862018Revenue 2019: $167,259Expenses 2019: $148,697Net Income 2019: $18,5622019Revenue 2020: $211,070Expenses 2020: $175,488Net Income 2020: $35,5822020Revenue 2021: $263,347Expenses 2021: $197,796Net Income 2021: $65,5512021Revenue 2022: $394,788Expenses 2022: $257,377Net Income 2022: $137,4112022Revenue 2023: $560,244Expenses 2023: $336,888Net Income 2023: $223,3562023Revenue 2024: $688,983Expenses 2024: $537,478Net Income 2024: $151,5052024

Highlighted filing

2017

Revenue$92,044
Expenses$26,947
Net Income$65,097
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
May 14, 2018
Return Version
2017v2.3
Gross Receipts
$102,081
Mission and Program Overview

Mission

Education regarding Anti-Bullying and Suicide Prevention

Program Services

DescriptionGrantsExpenses
Provided community events to create awarness and provide support for teens dealing with depression, anxiety, and suicidal behavior. 6,000 people benefited.-$19,429
Provided scholarships to graduating seniors who demonstrated acceptance of others and stood up against bullying. 4 people benefited.$1,000$3,635
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Suzanne BartelPresident-$0--
Ben K BartelTreasurer/Secretary-$0--
Jeff HuberDirector-$0--
Heather DziewulskiDirector-$0--
Cathy PolanskiDirector-$0--
Geri FioreDirector-$0--
Suzanne NixonDirector-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
5K Color Run$29,199$20,059$10,037$10,022
Total Events$29,199$20,059$10,037$10,022
Filing and Contact Details

Filer

Filer Name
The Ryan Bartel Foundation Inc
EIN
47-5129027
Phone
7034313675
Address
40815 Hannah Drive, Waterford, VA 20197

Signing Officer

Name
Suzanne Bartel
Title
President
Signed
2018-05-14
Discuss with paid preparer
Yes

Preparer

Firm
Foundation Group Inc
Address
1321 Murfreesboro Pike Ste 610, Nashville, TN 37217
Preparer
William G McRay
Phone
6153619445
Supplemental Narrative

Additional Explanations

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

“Meals and entertainment 252”

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

“Supplies 1,232”

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

“Promotional Items 320”

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

“Information Technology 2,071”

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

“Program Expense Training 15,250”

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

“Program Expense Plaques 2,635”

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

“Business Registration Fees 125”

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

“Bank Service Charges 103”

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

“Program Expense Program/Event Supplies 2,108”

Form 990-EZ, Part II, Line 26, Liabilities

“Long Tern Liabilities Beginning of year 0, End of year 2,500”

Raw XML Appendix174 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/PersonNm0Pam Hemstreet
IRS990EZ/BooksInCareOfDetail/PhoneNum09548685668
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0707 Emerald Drive
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Leesburg
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0VA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd020176
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt041853
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0109450
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt082022
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt065097
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01150
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt041853
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0109450
IRS990EZ/FundraisingGrossIncomeAmt020059
IRS990EZ/GrantsAndSimilarAmountsPaidAmt01000
IRS990EZ/GrossReceiptsAmt0102081
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt041853
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0106950
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt041853
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0106950
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0002.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt5001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt6001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Suzanne Bartel
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Ben K Bartel
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Jeff Huber
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Heather Dziewulski
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4Cathy Polanski
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5Geri Fiore
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6Suzanne Nixon
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Treasurer/Secretary
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6Director
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt024096
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Education regarding Anti-Bullying and Suicide Prevention
IRS990EZ/PrintingPublicationsPostageAmt0701
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Provided community events to create awarness and provide support for teens dealing with depression, anxiety, and suicidal behavior. 6,000 people benefited.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1Provided scholarships to graduating seniors who demonstrated acceptance of others and stood up against bullying. 4 people benefited.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt01000
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt019429
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt13635
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt010037
IRS990EZ/SpecialEventsNetIncomeLossAmt010022
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0VA
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt02500
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TotalExpensesAmt026947
IRS990EZ/TotalProgramServiceExpensesAmt023064
IRS990EZ/TotalRevenueAmt092044
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0www.ryanbartelfoundation.org
IRS990ScheduleA/First5Years170Ind0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt082022
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt059248
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt03353
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0144623
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.00000
IRS990ScheduleA/PublicSupportCY509Pct00.00000
IRS990ScheduleA/PublicSupportTotal170Amt0144623
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt082022
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt059248
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt03353
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0144623
IRS990ScheduleA/TotalSupportAmt0144623
IRS990ScheduleG/FundraisingEventInformationGrp/CharitableContributionsTotAmt09140
IRS990ScheduleG/FundraisingEventInformationGrp/CharitableContriEvent1Amt09140
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt010037
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm05K Color Run
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt029199
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt029199
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt020059
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt020059
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt010022
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt010037
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt010037
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Meals and entertainment 252
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Supplies 1,232
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Promotional Items 320
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Information Technology 2,071
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Program Expense Training 15,250
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Program Expense Plaques 2,635
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Business Registration Fees 125
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Bank Service Charges 103
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8Program Expense Program/Event Supplies 2,108
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9Long Tern Liabilities Beginning of year 0, End of year 2,500
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc9Form 990-EZ, Part II, Line 26, Liabilities
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Suzanne Bartel
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0The Ryan Bartel Foundation Inc
ReturnHeader/Filer/BusinessNameControlTxt0RYAN
ReturnHeader/Filer/EIN0475129027
ReturnHeader/Filer/PhoneNum07034313675
ReturnHeader/Filer/USAddress/AddressLine1Txt040815 Hannah Drive
ReturnHeader/Filer/USAddress/CityNm0Waterford
ReturnHeader/Filer/USAddress/StateAbbreviationCd0VA
ReturnHeader/Filer/USAddress/ZIPCd020197
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0A1B95B656185A6E08FDF946E0DBFF63D868DFBBF
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A1B95B656185A6E08FDF946E0DBFF63D868DFBBF
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0173.10.209.165
ReturnHeader/FilingSecurityInformation/IPDt02018-05-14
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm014:59:05
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Foundation Group Inc
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01321 Murfreesboro Pike Ste 610
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Nashville
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd037217
ReturnHeader/PreparerPersonGrp/PhoneNum06153619445
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0William G McRay
ReturnHeader/ReturnTs02018-05-14T10:07:35-00: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
$109,450
Liabilities
$2,500
Net assets
$106,950
Revenue
$92,044
Expenses
$26,947
Net income
$65,097
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$7.86$0.40$7.46$6.89$5.37$1.52
2023Detailed filing. Detailed filing data is available for this year.$6.04$0.10$5.94$5.60$3.37$2.23
2022Detailed filing. Detailed filing data is available for this year.$4.25$0.54$3.71$3.95$2.57$1.37
2021Detailed filing. Detailed filing data is available for this year.$2.49$0.15$2.34$2.63$1.98$0.66
2020Detailed filing. Detailed filing data is available for this year.$1.78$0.10$1.68$2.11$1.75$0.36
2019Detailed filing. Detailed filing data is available for this year.$1.33$0.00$1.33$1.67$1.49$0.19
2018Detailed filing. Detailed filing data is available for this year.$1.16$0.02$1.14$1.24$1.17$0.07
2017Detailed filing. Detailed filing data is available for this year.$1.09$0.03$1.07$0.92$0.27$0.65
2016Summary only. Only limited summary data is available for this year.$0.42$0.00$0.62$0.20$0.42