Civic Intelligence

Red Hawk Ranch Water Company

990EZ • Fiscal year 2017 • EIN 46-0845780

Jan 01, 2017 to Dec 31, 2017 • Filed on Jun 07, 2018

PO Box 981463Park City, UT 84098-1463

(435) 640-1150

Siviq Scores

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

Liabilities / Assets

65th percentile

0.05x

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

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

Liabilities / Revenue

72nd percentile

0.20x

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

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

Net Margin

95th percentile

53%

Higher net margin than 95% of similar nonprofits.

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

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

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

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

Asset Growth

Score unavailable

No value available

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

Source year 2017

Revenue Growth

Score unavailable

No value available

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

Source year 2017

Assets

$220,649

No earlier filing loaded for comparison.

Net Assets

$208,986

No earlier filing loaded for comparison.

Liabilities

$11,663

No earlier filing loaded for comparison.

Revenue

$59,333

No earlier filing loaded for comparison.

Expenses

$27,696

No earlier filing loaded for comparison.

Net Income

$31,637

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$400K$300K$200K$100K$0Assets 2017: $220,649Liabilities 2017: $11,663Net Assets 2017: $208,9862017Assets 2018: $217,789Liabilities 2018: $11,663Net Assets 2018: $206,1262018Assets 2019: $235,146Liabilities 2019: $8,787Net Assets 2019: $226,3592019Assets 2020: $233,492Liabilities 2020: $7,0392020Assets 2021: $242,045Liabilities 2021: $500Net Assets 2021: $241,5452021Assets 2022: $238,154Liabilities 2022: $564Net Assets 2022: $237,5902022Assets 2023: $257,732Liabilities 2023: $0Net Assets 2023: $257,7322023Assets 2024: $351,789Liabilities 2024: $1,931Net Assets 2024: $349,8582024

Highlighted filing

2017

Assets$220,649
Liabilities$11,663
Net Assets$208,986

Operations Trend

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

$200K$150K$100K$50K$0-$50KRevenue 2017: $59,333Expenses 2017: $27,696Net Income 2017: $31,6372017Revenue 2018: $58,553Expenses 2018: $61,413Net Income 2018: -$2,8602018Revenue 2019: $62,313Expenses 2019: $42,080Net Income 2019: $20,2332019Revenue 2020: $46,809Expenses 2020: $46,715Net Income 2020: $942020Revenue 2021: $59,214Expenses 2021: $44,122Net Income 2021: $15,0922021Revenue 2022: $43,269Expenses 2022: $47,224Net Income 2022: -$3,9552022Revenue 2023: $80,366Expenses 2023: $60,224Net Income 2023: $20,1422023Revenue 2024: $191,451Expenses 2024: $99,325Net Income 2024: $92,1262024

Highlighted filing

2017

Revenue$59,333
Expenses$27,696
Net Income$31,637
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Jun 7, 2018
Return Version
2017v2.3
Gross Receipts
$59,333
Mission and Program Overview

Mission

Provide water to homeowners

Provide water to homeowners connected to the water system.

Program Services

DescriptionGrantsExpenses
PROVIDED WATER TO HOMEOWNERS CONNECTED TO THE WATER SYSTEM.--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOAN ROSENTHALPresidentPT$0--
JON KUSNERTrustee-$0--
CHUCK COONRADTTrustee-$0--
JOREN PETERSONTreasurer-$0--
KENT FULLERTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Red Hawk Ranch Water Company
EIN
46-0845780
Phone
4356401150
Address
PO BOX 981463, PARK CITY, UT 84098-1463

Signing Officer

Name
Joan Rosenthal
Title
President
Phone
4356401150
Signed
2018-06-07
Discuss with paid preparer
Yes

Preparer

Firm
James L Druffner CPA
Address
1912 SIDEWINDER DR STE 200A, PARK CITY, UT 84060-7257
Preparer
Melody L Gritton
Phone
4356494592
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16

Expenses postage 10 insurance 3,300 utilities 4,623 telephone 1,268 water shares and taxes 7,020 repairs 2,363 total 18,584

Form 990-ez, Part II, Line 24

Accounts receivable 0 9,137 total 0 9,137

Form 990-ez, Part II, Line 26

Accounts payable and accrued expenses 483 0 loans 15,453 11,663

Form 990-ez, Part V, Line 34

1) add "annual recording of all water usage through corporation meters, and stockholder permanent and temporary meters. Permanent records shall be kept for those meter readings by the corporation. Records shall be submitted to the utah division of water resources at the end of each calendar year." 2) amend to be in compliance with new cc&r's under qualifications. 3) modify late fees that can be applied. 4) add the legal description to the proerties so the document could be recorded with summity county, utah.

Raw XML Appendix115 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/PersonNm0BRENDA LAKE
IRS990EZ/BooksInCareOfDetail/PhoneNum04356401150
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 981463
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0PARK CITY
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0UT
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd084098
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt0193285
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt0211512
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0true
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt031637
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt09112
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0193285
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0220649
IRS990EZ/GrossReceiptsAmt059333
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/InvestmentIncomeAmt0302
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0177349
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0208986
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0177349
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0208986
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt05.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt40.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0JOAN ROSENTHAL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JON KUSNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2CHUCK COONRADT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3JOREN PETERSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4KENT FULLER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2TRUSTEE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4TRUSTEE
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/EOYAmt09137
IRS990EZ/OtherExpensesTotalAmt018584
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE WATER TO HOMEOWNERS CONNECTED TO THE WATER SYSTEM.
IRS990EZ/ProgramServiceRevenueAmt059031
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDED WATER TO HOMEOWNERS CONNECTED TO THE WATER SYSTEM.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt015936
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt011663
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt027696
IRS990EZ/TotalRevenueAmt059333
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0EXPENSES POSTAGE 10 INSURANCE 3,300 UTILITIES 4,623 TELEPHONE 1,268 WATER SHARES AND TAXES 7,020 REPAIRS 2,363 TOTAL 18,584
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1ACCOUNTS RECEIVABLE 0 9,137 TOTAL 0 9,137
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2ACCOUNTS PAYABLE AND ACCRUED EXPENSES 483 0 LOANS 15,453 11,663
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt31) ADD "ANNUAL RECORDING OF ALL WATER USAGE THROUGH CORPORATION METERS, AND STOCKHOLDER PERMANENT AND TEMPORARY METERS. PERMANENT RECORDS SHALL BE KEPT FOR THOSE METER READINGS BY THE CORPORATION. RECORDS SHALL BE SUBMITTED TO THE UTAH DIVISION OF WATER RESOURCES AT THE END OF EACH CALENDAR YEAR." 2) AMEND TO BE IN COMPLIANCE WITH NEW CC&R'S UNDER QUALIFICATIONS. 3) MODIFY LATE FEES THAT CAN BE APPLIED. 4) ADD THE LEGAL DESCRIPTION TO THE PROERTIES SO THE DOCUMENT COULD BE RECORDED WITH SUMMITY COUNTY, UTAH.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART V, LINE 34
ReasonableCauseExplanation/ExplanationTxt0IT WAS THOUGHT A POSTCARD (FORM 990-N) WAS FILED AND FOUND OUT IT WAS NOT AND GROSS RECEIPTS ON AVERAGE FOR THE LAST THREE YEARS WAS IN EXCESS OF THE 50,000 AVERAGE.
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JOAN ROSENTHAL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum04356401150
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-06-07
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0RED HAWK RANCH WATER COMPANY
ReturnHeader/Filer/BusinessNameControlTxt0REDH
ReturnHeader/Filer/EIN0460845780
ReturnHeader/Filer/PhoneNum04356401150
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 981463
ReturnHeader/Filer/USAddress/CityNm0PARK CITY
ReturnHeader/Filer/USAddress/StateAbbreviationCd0UT
ReturnHeader/Filer/USAddress/ZIPCd0840981463
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId08A75D3FE9B7684DDFC5BD170BE8A61607B6E8AF4
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0512D3B021EAF4AD83FED7795D91C84703401AAA2
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt073.131.202.95
ReturnHeader/FilingSecurityInformation/IPDt02018-06-07
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm011:34:48
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0870533469
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0JAMES L DRUFFNER CPA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01912 SIDEWINDER DR STE 200A
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PARK CITY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0UT
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0840607257
ReturnHeader/PreparerPersonGrp/PhoneNum04356494592
ReturnHeader/PreparerPersonGrp/PreparationDt02018-06-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0MELODY L GRITTON
ReturnHeader/ReturnTs02018-06-07T10:34:48-06: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