Civic Intelligence

Pigeon Forge Rotary Club

990EZ • Fiscal year 2018 • EIN 45-2998632

Jul 01, 2017 to Jun 30, 2018 • Filed on Nov 12, 2018

Organization ProfileWWW.PIGEONFORGEROTARY.COM
P O Box 213Pigeon Forge, TN 37868

(865) 428-9787

Siviq Scores

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

Liabilities / Assets

80th percentile

0.15x

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

2018 filings • 501(c)4 • <$500k nonprofits • Source year 2018

Liabilities / Revenue

85th percentile

0.25x

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

2018 filings • 501(c)4 • <$500k nonprofits • Source year 2018

Net Margin

20th percentile

-15%

Higher net margin than 20% of similar nonprofits.

2018 filings • 501(c)4 • <$500k nonprofits • Source year 2018

Top Officer Pay

86th percentile

$0

Higher top officer pay than 86% of similar nonprofits.

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

2018 filings • 501(c)4 • <$500k nonprofits • Source year 2018

Asset Growth

14th percentile

-22%

Faster asset growth than 14% of similar nonprofits.

2018 filings • 501(c)4 • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

29th percentile

-11%

Faster revenue growth than 29% of similar nonprofits.

2018 filings • 501(c)4 • <$500k nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / Assets80th percentile

Assets

Down

$212,748

Down $60,490 (-22%) from 2017

Net Assets

Down

$181,218

Down $18,617 (-9.3%) from 2017

Liabilities

Down

$31,530

Down $41,873 (-57%) from 2017

Revenue And Expenses
Liabilities / Revenue85th percentileNet Margin20th percentile

Revenue

Down

$127,671

Down $15,123 (-11%) from 2017

Expenses

Up

$146,288

Up $32,048 (+28%) from 2017

Net Income

Down

-$18,617

Down $47,171 (-165%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth14th percentile

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

$400K$300K$200K$100K$0Assets 2016: $194,808Liabilities 2016: $23,527Net Assets 2016: $171,2812016Assets 2017: $273,238Liabilities 2017: $73,403Net Assets 2017: $199,8352017Assets 2018: $212,748Liabilities 2018: $31,530Net Assets 2018: $181,2182018Assets 2020: $252,259Liabilities 2020: $23,141Net Assets 2020: $229,1182020Assets 2021: $215,801Liabilities 2021: $20,452Net Assets 2021: $195,3492021Assets 2022: $277,847Liabilities 2022: $28,297Net Assets 2022: $249,5502022Assets 2023: $312,175Liabilities 2023: $28,448Net Assets 2023: $283,7272023Assets 2025: $284,448Liabilities 2025: $0Net Assets 2025: $284,4482025

Highlighted filing

2018

Assets$212,748
Liabilities$31,530
Net Assets$181,218
Open 2018 Filing

Operations Trend

Revenue Growth29th percentile

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

$200K$100K$0-$100KRevenue 2016: $139,716Expenses 2016: $138,718Net Income 2016: $9982016Revenue 2017: $142,794Expenses 2017: $114,240Net Income 2017: $28,5542017Revenue 2018: $127,671Expenses 2018: $146,288Net Income 2018: -$18,6172018Revenue 2020: $149,076Expenses 2020: $117,315Net Income 2020: $31,7612020Revenue 2021: $32,698Expenses 2021: $66,467Net Income 2021: -$33,7692021Revenue 2022: $146,420Expenses 2022: $92,219Net Income 2022: $54,2012022Revenue 2023: $167,676Expenses 2023: $133,499Net Income 2023: $34,1772023Revenue 2025: $187,133Expenses 2025: $184,834Net Income 2025: $2,2992025

Highlighted filing

2018

Revenue$127,671
Expenses$146,288
Net Income-$18,617
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Nov 12, 2018
Return Version
2017v2.2
Gross Receipts
$127,671
Mission and Program Overview

Mission

Fundraising branch of rotary intl

Program Services

DescriptionGrantsExpenses
NOT APPLICABLE--
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
BEN CLABOPresident-$0--
LADONNA TWYMANVice President-$0--
MEGAN MCCLURESecretary-$0--
ROBERT GUERRERATreasurerPT$0--
CHRISTIE BALOGDirector-$0--
MARY BROWNDirector-$0--
DON GIBSONDirector-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Craft Fair$113,818$113,818$26,105$87,713
Total Events$113,818$113,818$40,313$73,505
Filing and Contact Details

Filer

Filer Name
Pigeon Forge Rotary Club
EIN
45-2998632
Address
P O BOX 213, PIGEON FORGE, TN 37868

Signing Officer

Name
Robert a Guerrera
Title
Treasurer
Phone
8653353068
Signed
2018-11-12
Discuss with paid preparer
Yes

Preparer

Firm
Millstone & Weir Inc
Address
P O Box 4897, SEVIERVILLE, TN 37864
Preparer
Joyce Guerrera CPA
Phone
8654289787
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description amountclub operations 16,842committed projects & comm service 88,691craft fair & fundraising 40,313bank service charges 46prior year changes to b.s. 396”

Description of other assets Part II line 24

“Category beginning of year end of yearaccounts receivable - dues 27,183 28,848”

Description of total liabilities Part II line 26

“Category beginning of year end of yearconduit liabilities 73,403 31,530”

Raw XML Appendix154 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/PersonNm0ROBERT GUERRERA
IRS990EZ/BooksInCareOfDetail/PhoneNum08654289787
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0P O BOX 213
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0PIGEON FORGE
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0TN
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd037868
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0246055
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0183900
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt03675
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-18617
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0273238
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0212748
IRS990EZ/FundraisingGrossIncomeAmt0118238
IRS990EZ/GrossReceiptsAmt0127671
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0183
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt05575
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0199835
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0181218
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0199835
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0181218
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt03.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt13.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt23.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt43.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt53.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt63.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0BEN CLABO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1LADONNA TWYMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2MEGAN MCCLURE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3ROBERT GUERRERA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4CHRISTIE BALOG
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5MARY BROWN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6DON GIBSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt027183
IRS990EZ/OtherAssetsTotalDetail/EOYAmt028848
IRS990EZ/OtherExpensesTotalAmt0146288
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0FUNDRAISING BRANCH OF ROTARY INTL
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0NOT APPLICABLE
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SpecialEventsNetIncomeLossAmt0118238
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt073403
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt031530
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0146288
IRS990EZ/TotalProgramServiceExpensesAmt00
IRS990EZ/TotalRevenueAmt0127671
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.PIGEONFORGEROTARY.COM
IRS990ScheduleG/AgrmtProfFundraisingActyInd0false
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt040313
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0CRAFT FAIR
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt0113818
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt0113818
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt0113818
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt0113818
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt073505
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt026105
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt026105
IRS990ScheduleG/FundraisingEventInformationGrp/RentFacilityCostsEvent1Amt014208
IRS990ScheduleG/FundraisingEventInformationGrp/RentFcltyCostsTotalEventsAmt014208
IRS990ScheduleG/LicensedStatesCd0TN
IRS990ScheduleG/SpecialFundraisingEventsInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION AMOUNTCLUB OPERATIONS 16,842COMMITTED PROJECTS & COMM SERVICE 88,691CRAFT FAIR & FUNDRAISING 40,313BANK SERVICE CHARGES 46PRIOR YEAR CHANGES TO B.S. 396
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS RECEIVABLE - DUES 27,183 28,848
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2CATEGORY BEGINNING OF YEAR END OF YEARCONDUIT LIABILITIES 73,403 31,530
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other expenses Part I line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Description of other assets Part II line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Description of total liabilities Part II line 26
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT A GUERRERA
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum08653353068
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-11-12
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0PIGEON FORGE ROTARY CLUB
ReturnHeader/Filer/BusinessNameControlTxt0PIGE
ReturnHeader/Filer/EIN0452998632
ReturnHeader/Filer/USAddress/AddressLine1Txt0P O BOX 213
ReturnHeader/Filer/USAddress/CityNm0PIGEON FORGE
ReturnHeader/Filer/USAddress/StateAbbreviationCd0TN
ReturnHeader/Filer/USAddress/ZIPCd037868
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0EF20E66EA62B4650A1EBDC4E52011FBD317543CB
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0EF20E66EA62B4650A1EBDC4E52011FBD317543CB
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId06247612018316eis3iry
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-11-12
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt073.121.130.130
ReturnHeader/FilingSecurityInformation/IPDt02018-11-12
ReturnHeader/FilingSecurityInformation/IPTm018:31:26
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0823577539
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MILLSTONE & WEIR INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0P O Box 4897
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0SEVIERVILLE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd037864
ReturnHeader/PreparerPersonGrp/PhoneNum08654289787
ReturnHeader/PreparerPersonGrp/PreparationDt02018-11-12
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JOYCE GUERRERA CPA
ReturnHeader/ReturnTs02018-11-12T14:14:23-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2018 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$212,748
Liabilities
$31,530
Net assets
$181,218
Revenue
$127,671
Expenses
$146,288
Net income
-$18,617
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$2.84$0.00$2.84$1.87$1.85$0.02
2023Detailed filing. Detailed filing data is available for this year.$3.12$0.28$2.84$1.68$1.33$0.34
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.78$0.28$2.50$1.46$0.92$0.54
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.16$0.20$1.95$0.33$0.66$0.34
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.52$0.23$2.29$1.49$1.17$0.32
2018Detailed filing. Detailed filing data is available for this year.$2.13$0.32$1.81$1.28$1.46$0.19
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.73$0.73$2.00$1.43$1.14$0.29
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.95$0.24$1.71$1.40$1.39$0.01
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2018 filings • 501(c)4 • <$500k nonprofits