Civic Intelligence

Robinson Ranch LLC

990EZ • Fiscal year 2017 • EIN 26-3216499

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

Organization Profile
1231 E Ardmore RdPhoenix, AZ 85042

(602) 268-4972

Siviq Scores

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

Liabilities / Assets

96th percentile

1.54x

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

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

Liabilities / Revenue

92nd percentile

0.45x

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

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

Net Margin

30th percentile

-5.3%

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

24th percentile

-15%

Faster asset growth than 24% of similar nonprofits.

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

Revenue Growth

39th percentile

-5.7%

Faster revenue growth than 39% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets96th percentile

Assets

Down

$29,160

Down $5,138 (-15%) from 2016

Net Assets

Down

-$7,137

Down $5,725 (-405%) from 2016

Liabilities

Up

$44,950

Up $8,723 (+24%) from 2016

Revenue And Expenses
Liabilities / Revenue92nd percentileNet Margin30th percentile

Revenue

Down

$98,956

Down $6,035 (-5.7%) from 2016

Expenses

Down

$104,164

Down $3,204 (-3.0%) from 2016

Net Income

Down

-$5,208

Down $2,831 (-119%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth24th percentile

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

$200K$150K$100K$50K$0-$50KAssets 2011: $20,492Liabilities 2011: $15,523Net Assets 2011: $4,9692011Assets 2012: $4,466Liabilities 2012: $6,332Net Assets 2012: -$1,8662012Assets 2013: $21,782Liabilities 2013: $17,175Net Assets 2013: $4,6072013Assets 2014: $31,354Liabilities 2014: $23,405Net Assets 2014: $7,9492014Assets 2015: $31,887Liabilities 2015: $30,922Net Assets 2015: $9652015Assets 2016: $34,298Liabilities 2016: $36,227Net Assets 2016: -$1,4122016Assets 2017: $29,160Liabilities 2017: $44,950Net Assets 2017: -$7,1372017Assets 2018: $57,457Liabilities 2018: $6,743Net Assets 2018: $21,4192018Assets 2019: $77,776Liabilities 2019: $1,057Net Assets 2019: $76,7192019Assets 2020: $94,547Liabilities 2020: $4,834Net Assets 2020: $89,7132020Assets 2021: $104,659Liabilities 2021: $0Net Assets 2021: $104,6592021Assets 2022: $132,800Liabilities 2022: $0Net Assets 2022: $132,8002022Assets 2023: $160,879Liabilities 2023: $14,735Net Assets 2023: $146,1442023Assets 2024: $139,973Liabilities 2024: $7,813Net Assets 2024: $132,1602024

Highlighted filing

2017

Assets$29,160
Liabilities$44,950
Net Assets-$7,137
Open 2017 Filing

Operations Trend

Revenue Growth39th percentile

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

$200K$150K$100K$50K$0-$50KRevenue 2011: $35,417Expenses 2011: $31,772Net Income 2011: $3,6452011Revenue 2012: $64,110Expenses 2012: $62,561Net Income 2012: $1,5492012Revenue 2013: $76,790Expenses 2013: $70,229Net Income 2013: $6,5612013Revenue 2014: $99,422Expenses 2014: $95,690Net Income 2014: $3,7322014Revenue 2015: $91,221Expenses 2015: $98,223Net Income 2015: -$7,0022015Revenue 2016: $104,991Expenses 2016: $107,368Net Income 2016: -$2,3772016Revenue 2017: $98,956Expenses 2017: $104,164Net Income 2017: -$5,2082017Revenue 2018: $151,049Expenses 2018: $113,840Net Income 2018: $37,2092018Revenue 2019: $139,684Expenses 2019: $113,679Net Income 2019: $26,0052019Revenue 2020: $129,059Expenses 2020: $116,065Net Income 2020: $12,9942020Revenue 2021: $157,328Expenses 2021: $142,382Net Income 2021: $14,9462021Revenue 2022: $181,733Expenses 2022: $153,592Net Income 2022: $28,1412022Revenue 2023: $166,185Expenses 2023: $152,841Net Income 2023: $13,3442023Revenue 2024: $153,062Expenses 2024: $167,046Net Income 2024: -$13,9842024

Highlighted filing

2017

Revenue$98,956
Expenses$104,164
Net Income-$5,208
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Jun 12, 2018
Return Version
2017v2.2
Gross Receipts
$98,956
Mission and Program Overview

Mission

therapuetic riding & education

therapuetic riding and educatio

Program Services

DescriptionGrantsExpenses
equine feed our program horses are the cornerstone of our nonprofit Healthy horses require excellent feed to do their jobs 480 benefitted$73,682$16,959
property rental utilization of 2 property sites for our riding classes and clinics 263 benefitted$9,665$12,229
instructor payroll our riding instructors teach methods of horse riding to disabled riders families able bodied riders underprivilege 51b--
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
john robinsonExec DirecFT$0--
Sheila RobinsonProgram DirectorPT$0--
Jerry RiggsDirectorPT$0--
Fred ColbertDirectorPT$0--
Filing and Contact Details

Filer

Filer Name
Robinson Ranch LLC
EIN
26-3216499
Phone
6022684972
Address
1231 E Ardmore Rd, PHOENIX, AZ 85042

Signing Officer

Name
John Robinson
Title
Trustee
Signed
2018-06-12

Preparer

Firm
FacTS Finex Accounting and Tax Svcs
Address
4425 E Agave Rd Bldg 4 Ste 117, PHOENIX, AZ 85044
Preparer
Aashish M Parekh CTP
Phone
4808290020
Supplemental Narrative

Additional Explanations

990 ez part 1 line 8

“special events income 9665”

990 ez part 1 line 10

“awards and grant exp 16959”

990 EZ Part 1 Line 16

“Program costs 2480 event cost 5225 equine stable expenses 15456 farming exp 646 other exp 4006 vehicle exp 8606 suspens income and susp exp diff 1722”

Raw XML Appendix155 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/PersonNm0GWS Advisors LLC M Allen
IRS990EZ/BooksInCareOfDetail/PhoneNum04803901361
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0215 S Dobson RD Ste 4
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0CHANDLER
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0AZ
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd085224
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt02334
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt01785
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt03111
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-5208
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt016647
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/Form990TotalAssetsGrp/BOYAmt034298
IRS990EZ/Form990TotalAssetsGrp/EOYAmt029160
IRS990EZ/GrantsAndSimilarAmountsPaidAmt016959
IRS990EZ/GrossProfitLossSlsOfInvntryAmt01592
IRS990EZ/GrossReceiptsAmt098956
IRS990EZ/GrossSalesOfInventoryAmt01592
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LandAndBuildingsGrp/BOYAmt016423
IRS990EZ/LandAndBuildingsGrp/EOYAmt016881
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt010906
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-1929
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0-7137
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-1929
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0-15790
IRS990EZ/OccupancyRentUtltsAndMaintAmt019135
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt060
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt130
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt210
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt310
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0john robinson
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Sheila Robinson
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Jerry Riggs
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Fred Colbert
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0exec direc
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Program Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3director
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt015541
IRS990EZ/OtherAssetsTotalDetail/EOYAmt010494
IRS990EZ/OtherExpensesTotalAmt034674
IRS990EZ/OtherRevenueTotalAmt09665
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0therapuetic riding and educatio
IRS990EZ/PrintingPublicationsPostageAmt012240
IRS990EZ/ProgramServiceRevenueAmt073682
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0equine feed our program horses are the cornerstone of our nonprofit Healthy horses require excellent feed to do their jobs 480 benefitted
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1property rental utilization of 2 property sites for our riding classes and clinics 263 benefitted
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2instructor payroll our riding instructors teach methods of horse riding to disabled riders families able bodied riders underprivilege 51b
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt073682
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt19665
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt016959
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt112229
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt04509
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt036227
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt044950
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0104164
IRS990EZ/TotalProgramServiceExpensesAmt029188
IRS990EZ/TotalRevenueAmt098956
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationOtherDesc0LLC
IRS990EZ/TypeOfOrganizationOtherInd0X
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt03111
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt08850
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt022034
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt016134
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt014811
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt064940
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearAmt095845
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus1YearAmt096185
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus2YearsAmt073805
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus3YearsAmt083688
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/CurrentTaxYearMinus4YearsAmt056370
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt0405893
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct01.00000
IRS990ScheduleA/PublicSupportPY509Pct01.00000
IRS990ScheduleA/PublicSupportTotal509Amt0470833
IRS990ScheduleA/SupportSumAmt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt098956
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt0105035
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt095839
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt099822
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt071181
IRS990ScheduleA/Total509Grp/TotalAmt0470833
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt098956
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt0105035
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt095839
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt099822
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt071181
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt0470833
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0special events income 9665
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1awards and grant exp 16959
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2PROGRAM COSTS 2480 EVENT COST 5225 EQUINE STABLE EXPENSES 15456 FARMING EXP 646 OTHER EXP 4006 VEHICLE EXP 8606 SUSPENS INCOME AND SUSP EXP DIFF 1722
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0990 ez part 1 line 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1990 ez part 1 line 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2990 EZ PART 1 LINE 16
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0John Robinson
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-06-12
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Robinson Ranch LLC
ReturnHeader/Filer/BusinessNameControlTxt0ROBI
ReturnHeader/Filer/EIN0263216499
ReturnHeader/Filer/PhoneNum06022684972
ReturnHeader/Filer/USAddress/AddressLine1Txt01231 E Ardmore Rd
ReturnHeader/Filer/USAddress/CityNm0PHOENIX
ReturnHeader/Filer/USAddress/StateAbbreviationCd0AZ
ReturnHeader/Filer/USAddress/ZIPCd085042
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0DCDC36411A57FDDDC0AA673FE39008443566F0A0
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId012EE1BD2F4C786D43F34AE1BDBC31C27C61EA807
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId08610582018247h001276
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt070.166.110.30
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0861045228
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0FacTS Finex Accounting and Tax Svcs
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt04425 E Agave Rd Bldg 4 Ste 117
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PHOENIX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0AZ
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd085044
ReturnHeader/PreparerPersonGrp/PhoneNum04808290020
ReturnHeader/PreparerPersonGrp/PreparationDt02018-04-13
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Aashish M Parekh CTP
ReturnHeader/ReturnTs02018-09-04T16:46:33-07: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
$29,160
Liabilities
$44,950
Net assets
-$7,137
Revenue
$98,956
Expenses
$104,164
Net income
-$5,208
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.40$0.08$1.32$1.53$1.67$0.14
2023Detailed filing. Detailed filing data is available for this year.$1.61$0.15$1.46$1.66$1.53$0.13
2022Detailed filing. Detailed filing data is available for this year.$1.33$0.00$1.33$1.82$1.54$0.28
2021Detailed filing. Detailed filing data is available for this year.$1.05$0.00$1.05$1.57$1.42$0.15
2020Detailed filing. Detailed filing data is available for this year.$0.95$0.05$0.90$1.29$1.16$0.13
2019Detailed filing. Detailed filing data is available for this year.$0.78$0.01$0.77$1.40$1.14$0.26
2018Detailed filing. Detailed filing data is available for this year.$0.57$0.07$0.21$1.51$1.14$0.37
2017Detailed filing. Detailed filing data is available for this year.$0.29$0.45$0.07$0.99$1.04$0.05
2016Detailed filing. Detailed filing data is available for this year.$0.34$0.36$0.01$1.05$1.07$0.02
2015Detailed filing. Detailed filing data is available for this year.$0.32$0.31$0.01$0.91$0.98$0.07
2014Detailed filing. Detailed filing data is available for this year.$0.31$0.23$0.08$0.99$0.96$0.04
2013Detailed filing. Detailed filing data is available for this year.$0.22$0.17$0.05$0.77$0.70$0.07
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.04$0.06$0.02$0.64$0.63$0.02
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$0.20$0.16$0.05$0.35$0.32$0.04