Civic Intelligence

Pigeon Forge Rotary Club

990EZ • Fiscal year 2016 • EIN 45-2998632

Jul 01, 2015 to Jun 30, 2016 • Filed on Nov 09, 2016

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

78th percentile

0.12x

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

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

Liabilities / Revenue

82nd percentile

0.17x

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

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

Net Margin

44th percentile

0.7%

Higher net margin than 44% of similar nonprofits.

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

Top Officer Pay

85th percentile

$0

Higher top officer pay than 85% of similar nonprofits.

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

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

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2016

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2016

Balance Sheet
Liabilities / Assets78th percentile

Assets

$194,808

No earlier filing loaded for comparison.

Net Assets

$171,281

No earlier filing loaded for comparison.

Liabilities

$23,527

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / Revenue82nd percentileNet Margin44th percentile

Revenue

$139,716

No earlier filing loaded for comparison.

Expenses

$138,718

No earlier filing loaded for comparison.

Net Income

$998

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

2016

Assets$194,808
Liabilities$23,527
Net Assets$171,281
Open 2016 Filing

Operations Trend

Revenue GrowthScore unavailable

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

2016

Revenue$139,716
Expenses$138,718
Net Income$998
Open 2016 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2015 to Jun 30, 2016
Signed
Nov 9, 2016
Return Version
2015v2.1
Gross Receipts
$139,716
Mission and Program Overview

Mission

Fundraising branch of rotary intl

Program Services

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

Employees

NameTitleFull / Part TimeBaseOtherTotal
SUE CARRPresident-$0--
ROB OGLEVice President-$0--
BETTY ROBERTSONSecretary-$0--
ROBERT GUERRERATreasurer-$0--
JOHN STAFFORDDirector-$0--
MARY BROWNDirector-$0--
LAURIE TAYLORDirector-$0--
BEN CLABODirector-$0--
JIM GASSDirector-$0--
SCOTT HENSLEYDirector-$0--
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
2016-11-09
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 14,755committed projects & comm service 79,751craft fair & fundraising 44,212”

Description of other assets Part II line 24

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

Description of total liabilities Part II line 26

“Category beginning of year end of yearconduit liabilities 24,899 23,527”

Raw XML Appendix149 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/BOYAmt0166977
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0166673
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt04098
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0998
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0195182
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0194808
IRS990EZ/GrossReceiptsAmt0139716
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt071
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt04765
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0170283
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0171281
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0170283
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0171281
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt03.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt13.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt23.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt33.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt43.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt53.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt63.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt73.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt83.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt93.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt90
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt90
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt90
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0SUE CARR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1ROB OGLE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2BETTY ROBERTSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3ROBERT GUERRERA
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4JOHN STAFFORD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5MARY BROWN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6LAURIE TAYLOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7BEN CLABO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8JIM GASS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm9SCOTT HENSLEY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt9DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt028205
IRS990EZ/OtherAssetsTotalDetail/EOYAmt028135
IRS990EZ/OtherExpensesTotalAmt0138718
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0FUNDRAISING BRANCH OF ROTARY INTL
IRS990EZ/ProgramServiceRevenueAmt0130782
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0NOT APPLICABLE
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt024899
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt023527
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0138718
IRS990EZ/TotalProgramServiceExpensesAmt00
IRS990EZ/TotalRevenueAmt0139716
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0WWW.PIGEONFORGEROTARY.COM
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION AMOUNTCLUB OPERATIONS 14,755COMMITTED PROJECTS & COMM SERVICE 79,751CRAFT FAIR & FUNDRAISING 44,212
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CATEGORY BEGINNING OF YEAR END OF YEARACCOUNTS RECEIVABLE - DUES 28,205 23,885MISCELLANEOUS RECEIVABLE 0 4,250
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2CATEGORY BEGINNING OF YEAR END OF YEARCONDUIT LIABILITIES 24,899 23,527
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/SignatureDt02016-11-09
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/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/PreparationDt02016-11-09
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Joyce Guerrera CPA
ReturnHeader/ReturnTs02016-11-09T07:41:08-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02015-07-01
ReturnHeader/TaxPeriodEndDt02016-06-30
ReturnHeader/TaxYr02015

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$194,808
Liabilities
$23,527
Net assets
$171,281
Revenue
$139,716
Expenses
$138,718
Net income
$998
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
2016Detailed filing. Detailed filing data is available for this year.$1.95$0.24$1.71$1.40$1.39$0.01