Civic Intelligence

Pigeon Forge Rotary Club

990EZ • Fiscal year 2017 • EIN 45-2998632

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

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

86th percentile

0.27x

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

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

Liabilities / Revenue

91st percentile

0.51x

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

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

Net Margin

79th percentile

20%

Higher net margin than 79% of similar nonprofits.

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

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.

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

Asset Growth

89th percentile

40%

Faster asset growth than 89% of similar nonprofits.

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

Revenue Growth

56th percentile

2.2%

Faster revenue growth than 56% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets86th percentile

Assets

Up

$273,238

Up $78,430 (+40%) from 2016

Net Assets

Up

$199,835

Up $28,554 (+17%) from 2016

Liabilities

Up

$73,403

Up $49,876 (+212%) from 2016

Revenue And Expenses
Liabilities / Revenue91st percentileNet Margin79th percentile

Revenue

Up

$142,794

Up $3,078 (+2.2%) from 2016

Expenses

Down

$114,240

Down $24,478 (-18%) from 2016

Net Income

Up

$28,554

Up $27,556 (+2761%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth89th 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

2017

Assets$273,238
Liabilities$73,403
Net Assets$199,835
Open 2017 Filing

Operations Trend

Revenue Growth56th 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

2017

Revenue$142,794
Expenses$114,240
Net Income$28,554
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
Nov 12, 2017
Return Version
2016v3.0
Gross Receipts
$142,794
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
ROB OGLEPresident-$0--
BRECKINRIDGE MORGANVice President-$0--
MEGAN MCCLURESecretary-$0--
ROBERT GUERRERATreasurerPT$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Craft Fair----
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 Guerrera
Title
Treasurer
Phone
8653353068
Signed
2017-11-12
Discuss with paid preparer
Yes

Preparer

Firm
Millstone Accounting Services Cpas
Address
1670 MIDDLE CREEK ROAD, SEVIERVILLE, TN 37862
Preparer
Joyce Guerrera CPA
Phone
8654289787
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description amountclub operations 12,450committed projects & comm service 63,458craft fair & fundraising 38,297”

Description of other assets Part II line 24

“Category beginning of year end of yearaccounts receivable - dues 23,885 27,183miscellaneous receivable 4,250 0”

Description of total liabilities Part II line 26

“Category beginning of year end of yearconduit liabilities 23,527 73,403”

Raw XML Appendix128 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/BOYAmt0166673
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0246055
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt08183
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt028554
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0194808
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0273238
IRS990EZ/FundraisingGrossIncomeAmt0128696
IRS990EZ/GrossReceiptsAmt0142794
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0265
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt05650
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0171281
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0199835
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0171281
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0199835
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt03.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt13.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt23.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt35.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0ROB OGLE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1BRECKINRIDGE MORGAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2MEGAN MCCLURE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3ROBERT GUERRERA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt028135
IRS990EZ/OtherAssetsTotalDetail/EOYAmt027183
IRS990EZ/OtherExpensesTotalAmt0114205
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0FUNDRAISING BRANCH OF ROTARY INTL
IRS990EZ/PrintingPublicationsPostageAmt035
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0NOT APPLICABLE
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsNetIncomeLossAmt0128696
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt023527
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt073403
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0114240
IRS990EZ/TotalProgramServiceExpensesAmt00
IRS990EZ/TotalRevenueAmt0142794
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.PIGEONFORGEROTARY.COM
IRS990ScheduleG/AgrmtProfFundraisingActyInd0false
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0CRAFT FAIR
IRS990ScheduleG/LicensedStatesCd0TN
IRS990ScheduleG/SpecialFundraisingEventsInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION AMOUNTCLUB OPERATIONS 12,450COMMITTED PROJECTS & COMM SERVICE 63,458CRAFT FAIR & FUNDRAISING 38,297
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS RECEIVABLE - DUES 23,885 27,183MISCELLANEOUS RECEIVABLE 4,250 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2CATEGORY BEGINNING OF YEAR END OF YEARCONDUIT LIABILITIES 23,527 73,403
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/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT GUERRERA
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum08653353068
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-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/FederalOriginalSubmissionId06245082017316qlrk0b5
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02017-11-12
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt073.121.130.130
ReturnHeader/FilingSecurityInformation/IPDt02017-11-12
ReturnHeader/FilingSecurityInformation/IPTm012:00:28
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0621609104
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MILLSTONE ACCOUNTING SERVICES CPAS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01670 MIDDLE CREEK ROAD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0SEVIERVILLE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd037862
ReturnHeader/PreparerPersonGrp/PhoneNum08654289787
ReturnHeader/PreparerPersonGrp/PreparationDt02017-11-12
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Joyce Guerrera CPA
ReturnHeader/ReturnTs02017-11-12T05:59:28-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

Displayed year

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

Open filing
Assets
$273,238
Liabilities
$73,403
Net assets
$199,835
Revenue
$142,794
Expenses
$114,240
Net income
$28,554
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
2017Detailed filing. Detailed filing data is available for this year.$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