Civic Intelligence

Upon This Rock

990 • Fiscal year 2012 • EIN 43-1946905

Jan 01, 2012 to Dec 31, 2012 • Filed on Sep 15, 2013

PO Box 64465781
Siviq Scores

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

Liabilities / Assets

90th percentile

0.65x

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

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

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

28th percentile

-12%

Faster asset growth than 28% of similar nonprofits.

2012 filings • 501(c)3 • <$500k nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Assets

Down

$216,677

Down $28,493 (-12%) from 2011

Net Assets

Down

$75,832

Down $15,329 (-17%) from 2011

Liabilities

Down

$140,845

Down $13,164 (-8.5%) from 2011

Revenue

-

No earlier filing loaded for comparison.

Expenses

Down

$180,484

Down $49,712 (-22%) from 2011

Net Income

-

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.

$300K$200K$100K$0Assets 2010: $251,279Liabilities 2010: $163,706Net Assets 2010: $87,5732010Assets 2011: $245,170Liabilities 2011: $154,009Net Assets 2011: $91,1612011Assets 2012: $216,677Liabilities 2012: $140,845Net Assets 2012: $75,8322012Assets 2013: $209,474Liabilities 2013: $146,072Net Assets 2013: $63,4022013

Highlighted filing

2012

Assets$216,677
Liabilities$140,845
Net Assets$75,832

Operations Trend

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

$300K$200K$100K$0-$100KRevenue 2010: $181,261Expenses 2010: $213,894Net Income 2010: -$32,6332010Expenses 2011: $230,1962011Expenses 2012: $180,4842012Revenue 2013: $55,845Expenses 2013: $68,275Net Income 2013: -$12,4302013

Highlighted filing

2012

Revenue-
Expenses$180,484
Net Income-
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
Sep 15, 2013
Return Version
2012v2.1
Gross Receipts
$166,054
Mission and Program Overview

Mission

To facilitate short term mission trips to the us and abroad.

Filing and Contact Details

Filer

EIN
43-1946905
Raw XML Appendix307 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
IRS990/AccountantCompileOrReview0false
IRS990/AccountsPayableAccruedExpenses/BOY019405
IRS990/AccountsPayableAccruedExpenses/EOY012824
IRS990/ActivitiesConductedPartnership0false
IRS990/ActivityOrMissionDescription0TO FACILITATE SHORT TERM MISSION TRIPS TO THE US AND ABROAD.
IRS990/AddressPrincipalOfficerUS/AddressLine10PO BOX 644
IRS990/AddressPrincipalOfficerUS/City0WILLARD
IRS990/AddressPrincipalOfficerUS/State0MO
IRS990/AddressPrincipalOfficerUS/ZIPCode065781
IRS990/Advertising/ProgramServices01409
IRS990/Advertising/Total01409
IRS990/AllOtherContributions0164204
IRS990/BenefitsPaidToMembersCY00
IRS990/BsnssRltnshpThruFamilyMember0false
IRS990/BsnssRltnshpWithOrganization0false
IRS990/CashNonInterestBearing/BOY037330
IRS990/CashNonInterestBearing/EOY012943
IRS990/ChangesToOrganizingDocs0false
IRS990/CollectionsOfArt0false
IRS990/CompensationFromOtherSources0false
IRS990/CompensationProcessCEO0false
IRS990/CompensationProcessOther0false
IRS990/ComplianceWithBackupWitholding0false
IRS990/ConferencesMeetings/ProgramServices0890
IRS990/ConferencesMeetings/Total0890
IRS990/ConflictOfInterestPolicy0false
IRS990/ConservationEasements0false
IRS990/ConsolidatedAuditFinancialStmt0false
IRS990/ContributionsGrantsCurrentYear0164204
IRS990/ContributionsGrantsPriorYear0225144
IRS990/CreditCounseling0false
IRS990/DecisionsSubjectToApproval0false
IRS990/DeductibleContributionsOfArt0false
IRS990/DeductibleNonCashContributions0false
IRS990/DelegationOfManagementDuties0false
IRS990/DepreciationDepletion/ProgramServices012708
IRS990/DepreciationDepletion/Total012708
IRS990/DescribedIn501C30true
IRS990/Description0RELIGIOUS PROGRAMS, GENERAL/OTHER: UPON THIS ROCK PERFORED MINISTRY ACTIVITIES IN MEXICO AND THE US IN 2012.
IRS990/DisregardedEntity0false
IRS990/DocumentRetentionPolicy0true
IRS990/DoingBusinessAs/BusinessNameLine10CLAY ANDERSON
IRS990/DonorAdvisedFunds0false
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers0false
IRS990/EmploymentTaxReturnsFiled0true
IRS990/ExcessBenefitTransaction0false
IRS990/Expense0180484
IRS990/FamilyOrBusinessRelationship0false
IRS990/FederalGrantAuditRequired0false
IRS990/FeesForServicesOther/ProgramServices07900
IRS990/FeesForServicesOther/Total07900
IRS990/ForeignActivities0false
IRS990/ForeignFinancialAccount0false
IRS990/ForeignOffice0false
IRS990/Form8282PropertyDisposedOf0false
IRS990/Form990PartVIISectionA/AverageHoursPerWeek02.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek12.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek22.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek32.00
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector1X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector2X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector3X
IRS990/Form990PartVIISectionA/NamePerson0ADAM MADDEN
IRS990/Form990PartVIISectionA/NamePerson1LINDA GARRISON
IRS990/Form990PartVIISectionA/NamePerson2ED MOSHER
IRS990/Form990PartVIISectionA/NamePerson3CAROL TINSLEY
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/OtherCompensation10
IRS990/Form990PartVIISectionA/OtherCompensation20
IRS990/Form990PartVIISectionA/OtherCompensation30
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization10
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization20
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization30
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs10
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs20
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs30
IRS990/Form990PartVIISectionA/Title0PRESIDENT
IRS990/Form990PartVIISectionA/Title1BOARD MEMBER
IRS990/Form990PartVIISectionA/Title2BOARD MEMBER
IRS990/Form990PartVIISectionA/Title3VICE PRESIDE
IRS990/Form990ProvidedToGoverningBody0false
IRS990/FormersListed0false
IRS990/FSAudited0false
IRS990/FundraisingActivities0false
IRS990/FundsToPayPremiums0false
IRS990/GainOrLoss/Other0951
IRS990/Gaming0false
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsToIndividuals0false
IRS990/GrantsToOrganizations0false
IRS990/GrantToRelatedPerson0false
IRS990/GrossAmountSalesAssets/Other01850
IRS990/GrossReceipts0166054
IRS990/GroupReturnForAffiliates0false
IRS990/Hospital0false
IRS990/IndependentAuditFinancialStmt0false
IRS990/IndoorTanningServices0false
IRS990/InfoInScheduleOPartVI0X
IRS990/Insurance/ProgramServices01994
IRS990/Insurance/Total01994
IRS990/Interest/ProgramServices03405
IRS990/Interest/Total03405
IRS990/InvestmentIncomeCurrentYear0951
IRS990/InvestmentIncomePriorYear08640
IRS990/InvestmentInJointVenture0false
IRS990/LandBldgEquipmentAccumDeprec0107089
IRS990/LandBuildingsEquipmentBasis0310823
IRS990/LandBuildingsEquipmentBasisNet/BOY0207840
IRS990/LandBuildingsEquipmentBasisNet/EOY0203734
IRS990/LessCostOthBasisSalesExpenses/Other0899
IRS990/LoanToOfficerOrDQP0false
IRS990/LobbyingActivities0false
IRS990/LocalChapters0false
IRS990/MaterialDiversionOrMisuse0false
IRS990/MembersOrStockholders0false
IRS990/MethodOfAccountingAccrual0X
IRS990/MinutesOfCommittees0true
IRS990/MinutesOfGoverningBody0true
IRS990/MissionDescription0TO FACILITATE SHORT TERM MISSION TRIPS TO THE US AND ABROAD.
IRS990/MoreThan5000KToIndividuals0false
IRS990/MoreThan5000KToOrganizations0false
IRS990/MortNotesPyblSecuredInvestProp/BOY0134604
IRS990/MortNotesPyblSecuredInvestProp/EOY0128021
IRS990/NameOfPrincipalOfficerPerson0J SHAWN ESTES
IRS990/NbrIndependentVotingMembers05
IRS990/NbrVotingGoverningBodyMembers05
IRS990/NbrVotingMembersGoverningBody05
IRS990/NetAssetsOrFundBalancesBOY091161
IRS990/NetAssetsOrFundBalancesEOY075832
IRS990/NetGainOrLossInvestments/RelatedOrExemptFunctionIncome0951
IRS990/NetGainOrLossInvestments/TotalRevenueColumn0951
IRS990/NoListedPersonsCompensated0X
IRS990/NonDeductibleContributions0true
IRS990/NonDeductibleDisclosure0true
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers05
IRS990/NumberOfEmployees05
IRS990/NumberW2GIncluded00
IRS990/Occupancy/ProgramServices09312
IRS990/Occupancy/Total09312
IRS990/OfficeExpenses/ProgramServices010144
IRS990/OfficeExpenses/Total010144
IRS990/OfficerEntityWithBsnssRltnshp0false
IRS990/OfficerMailingAddress0false
IRS990/Organization501c30X
IRS990/OtherEmployeeBenefits/ProgramServices020461
IRS990/OtherEmployeeBenefits/Total020461
IRS990/OtherExpensePriorYear0111530
IRS990/OtherExpensesCurrentYear083601
IRS990/OtherExpenses/Description0TEAM EXPENSE
IRS990/OtherExpenses/Description1VEHICLE EXPENSE
IRS990/OtherExpenses/Description2OUTREACH
IRS990/OtherExpenses/ProgramServices019210
IRS990/OtherExpenses/ProgramServices111783
IRS990/OtherExpenses/ProgramServices23829
IRS990/OtherExpenses/Total019210
IRS990/OtherExpenses/Total111783
IRS990/OtherExpenses/Total23829
IRS990/OtherRevenueCurrentYear00
IRS990/OtherSalariesAndWages/ProgramServices073914
IRS990/OtherSalariesAndWages/Total073914
IRS990/PartialLiquidation0false
IRS990/PayrollTaxes/ProgramServices02508
IRS990/PayrollTaxes/Total02508
IRS990/PoliticalActivities0false
IRS990/PremiumsPaid0false
IRS990/PriorExcessBenefitTransaction0false
IRS990/ProfessionalFundraising0false
IRS990/ProgramServiceRevenueCY00
IRS990/ProhibitedTaxShelterTrans0false
IRS990/QuidProQuoContributions0false
IRS990/ReconcilationRevenueExpenses0-15329
IRS990/RelatedEntity0false
IRS990/RelatedOrgControlledEntity0false
IRS990/ReportFin48Footnote0false
IRS990/ReportInvestOthSecurities0false
IRS990/ReportLandBldgEquip0true
IRS990/ReportOtherAssets0false
IRS990/ReportOtherLiabilities0false
IRS990/ReportProgRelInvest0false
IRS990/RetainedEarningsEndowmentEtc/BOY091161
IRS990/RetainedEarningsEndowmentEtc/EOY075832
IRS990/Revenue0165020
IRS990/RevenuesLessExpensesCY0-15329
IRS990/RevenuesLessExpensesPriorYear03588
IRS990/SalariesEtcCurrentYear096883
IRS990/SalariesEtcPriorYear0118666
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYear0165020
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus1Year0233786
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus2Years0181261
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus3Years0221638
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus4Years0201344
IRS990ScheduleA/GiftsGrantsContribReceived170/Total01003049
IRS990ScheduleA/PubliclySupportedOrg170b1Avi0X
IRS990ScheduleA/PublicSupportPertcentage17001.00000
IRS990ScheduleA/PublicSupportTotal17001003049
IRS990ScheduleA/ThirtyThreePercntTestsCY1700X
IRS990ScheduleA/Total170/CurrentTaxYear0165020
IRS990ScheduleA/Total170/CurrentTaxYearMinus1Year0233786
IRS990ScheduleA/Total170/CurrentTaxYearMinus2Years0181261
IRS990ScheduleA/Total170/CurrentTaxYearMinus3Years0221638
IRS990ScheduleA/Total170/CurrentTaxYearMinus4Years0201344
IRS990ScheduleA/Total170/Total01003049
IRS990ScheduleA/TotalSupport01003049
IRS990/ScheduleBRequired0false
IRS990ScheduleD/Buildings/BookValue0162508
IRS990ScheduleD/Buildings/Depreciation035807
IRS990ScheduleD/Buildings/OtherCostOrOtherBasis0198315
IRS990ScheduleD/Equipment/BookValue08726
IRS990ScheduleD/Equipment/Depreciation071282
IRS990ScheduleD/Equipment/OtherCostOrOtherBasis080008
IRS990ScheduleD/Land/BookValue032500
IRS990ScheduleD/Land/OtherCostOrOtherBasis032500
IRS990ScheduleD/TotalOfBookValueLandBuildings0203734
IRS990/ScheduleJRequired0false
IRS990ScheduleO/GeneralExplanation/Explanation0MANAGEMENT AND ADMINISTATION REVIEW THIS RETURN FOR ACCURACY AND COMPLIANCE.
IRS990ScheduleO/GeneralExplanation/Explanation1THE DOCUMENTS ARE AVALIBLE UPON REQUEST.
IRS990ScheduleO/GeneralExplanation/Identifier0ORGANIZATION'S PROCESS USED TO REVIEW FORM 990
IRS990ScheduleO/GeneralExplanation/Identifier1GOVERNING DOCUMENTS DISCLOSURE EXPLANATION
IRS990ScheduleO/GeneralExplanation/ReturnReference0FORM 990, PAGE 6, PART VI, LINE 11B
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990, PAGE 6, PART VI, LINE 19
IRS990/ScheduleORequired0true
IRS990/School0false
IRS990/SignificantChange0false
IRS990/SignificantNewProgramServices0false
IRS990/StateLegalDomicile0MO
IRS990/SubjectToProxyTax0false
IRS990/TaxablePartyNotification0false
IRS990/TaxExemptBonds0false
IRS990/Terminated0false
IRS990/TermOrPermanentEndowments0false
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine10906 W ACACIA AVE 5114
IRS990/TheBooksAreInCareOf/AddressUS/City0ALAMO
IRS990/TheBooksAreInCareOf/AddressUS/State0TX
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode078516
IRS990/TheBooksAreInCareOf/NamePerson0CLAY ANDERSON
IRS990/TheBooksAreInCareOf/TelephoneNumber04178944316
IRS990/TotalAssets/BOY0245170
IRS990/TotalAssetsBOY0245170
IRS990/TotalAssets/EOY0216677
IRS990/TotalAssetsEOY0216677
IRS990/TotalCompGT150K0false
IRS990/TotalContributions0164204
IRS990/TotalExpensesCurrentYear0180484
IRS990/TotalExpensesPriorYear0230196
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral00
IRS990/TotalFunctionalExpenses/ProgramServices0180484
IRS990/TotalFunctionalExpenses/Total0180484
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY0154009
IRS990/TotalLiabilitiesBOY0154009
IRS990/TotalLiabilities/EOY0140845
IRS990/TotalLiabilitiesEOY0140845
IRS990/TotalLiabNetAssetsFundBalances/BOY0245170
IRS990/TotalLiabNetAssetsFundBalances/EOY0216677
IRS990/TotalNbrEmployees05
IRS990/TotalNbrVolunteers05
IRS990/TotalNetAssetsFundBalances/BOY091161
IRS990/TotalNetAssetsFundBalances/EOY075832
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProgramServiceExpense0180484
IRS990/TotalRevenueCurrentYear0165155
IRS990/TotalRevenuePriorYear0233784
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome0951
IRS990/TotalRevenue/TotalRevenueColumn0165155
IRS990/TransfersToExemptNonChrtblOrg0false
IRS990/Travel/ProgramServices01017
IRS990/Travel/Total01017
IRS990/TypeOfOrganizationCorporation0X
IRS990/UnrelatedBusinessIncome0false
IRS990/UponRequest0X
IRS990/WebSite0WWW.UTRI.ORG
IRS990/WhistleblowerPolicy0false
IRS990/YearFormation02001
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0431946905
ReturnHeader/Filer/Name/BusinessNameLine10UPON THIS ROCK
ReturnHeader/Filer/NameControl0UPON
ReturnHeader/Filer/Phone04178944316
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 644
ReturnHeader/Filer/USAddress/City0WILLARD
ReturnHeader/Filer/USAddress/State0MO
ReturnHeader/Filer/USAddress/ZIPCode065781
ReturnHeader/Officer/DateSigned02013-09-15
ReturnHeader/Officer/Name0J SHAWN ESTES
ReturnHeader/Officer/Phone04178944316
ReturnHeader/Officer/Title0ADMINISTRATOR
ReturnHeader/Preparer/DatePrepared02013-09-17
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10CUNNINGHAM SHAVERS CHRISTENSEN
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10WRIGHT LLP
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0AUSTIN AVE WACO
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0TX
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0767011693
ReturnHeader/Preparer/Name0DANNY R WRIGHT CPA
ReturnHeader/Preparer/Phone02547523436
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-09-17T09:31:29-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings