Civic Intelligence

Upon This Rock

990EZ • Fiscal year 2010 • EIN 43-1946905

Jan 01, 2010 to Dec 31, 2010 • Filed on Aug 15, 2011

PO Box 64465781
Siviq Scores

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

Liabilities / Assets

87th percentile

0.65x

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

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

Liabilities / Revenue

92nd percentile

0.90x

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

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

Net Margin

20th percentile

-18%

Higher net margin than 20% of similar nonprofits.

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

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2010

Asset Growth

Score unavailable

No value available

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

Source year 2010

Revenue Growth

Score unavailable

No value available

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

Source year 2010

Assets

$251,279

No earlier filing loaded for comparison.

Net Assets

$87,573

No earlier filing loaded for comparison.

Liabilities

$163,706

No earlier filing loaded for comparison.

Revenue

$181,261

No earlier filing loaded for comparison.

Expenses

$213,894

No earlier filing loaded for comparison.

Net Income

-$32,633

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

2010

Assets$251,279
Liabilities$163,706
Net Assets$87,573

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

2010

Revenue$181,261
Expenses$213,894
Net Income-$32,633
Jump To
Filing Snapshot
Filing Period
Jan 1, 2010 to Dec 31, 2010
Signed
Aug 15, 2011
Return Version
2010v3.4
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 Appendix190 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/ActivitiesNotPreviouslyRpt00
IRS990EZ/AmountOfTaxImposedOnOrgMgr00
IRS990EZ/AmountOfTaxReimbursedByOrg00
IRS990EZ/BenefitsPaidToOrForMembers00
IRS990EZ/CashSavingsAndInvestments/BOY038901
IRS990EZ/CashSavingsAndInvestments/EOY029073
IRS990EZ/ContributionsGiftsGrantsEtc0181261
IRS990EZ/CostOfGoodsSold00
IRS990EZ/CostOtherBasisAndSalesExpenses00
IRS990EZ/DidOrgFileForm1120POLThisYear00
IRS990EZ/DirectIndirectPoliticalExpend00
IRS990EZ/DoesOrgHaveHospital00
IRS990EZ/EngagedInExcessBenefitTrans00
IRS990EZ/EngageInLobbyingActivities00
IRS990EZ/EngagePoliticalCmpgnActivities00
IRS990EZ/ExcessOrDeficitForYear0-32633
IRS990EZ/FeesAndOthPymtToIndContractors00
IRS990EZ/FiledScheduleA01
IRS990EZ/ForeignFinancialAccount00
IRS990EZ/ForeignOffice00
IRS990EZ/FundraisingGrossIncome00
IRS990EZ/GainOrLossFromSaleOfAssets00
IRS990EZ/GamingGrossIncome00
IRS990EZ/GrantsAndSimilarAmountsPaid00
IRS990EZ/GroProfitLossSalesOfInventory00
IRS990EZ/GrossAmountFromSaleOfAssets00
IRS990EZ/GrossReceipts0181261
IRS990EZ/GrossSalesOfInventory00
IRS990EZ/InfoInScheduleOPartI0X
IRS990EZ/InfoInScheduleOPartII0X
IRS990EZ/InvestmentIncome00
IRS990EZ/LandAndBuildings/BOY0210263
IRS990EZ/LandAndBuildings/EOY0205178
IRS990EZ/MadeChangesToOrgnzngEtcDoc00
IRS990EZ/MadeLoansToFromOfficers00
IRS990EZ/MaintainAnyDonorAdvisedFunds00
IRS990EZ/MembershipDues00
IRS990EZ/MethodOfAccountingCash0X
IRS990EZ/NetAssetsOrFundBalances/BOY0120206
IRS990EZ/NetAssetsOrFundBalancesBOY0120206
IRS990EZ/NetAssetsOrFundBalances/EOY087573
IRS990EZ/NetAssetsOrFundBalancesEOY087573
IRS990EZ/OccupancyRentUtilitiesAndMaint023265
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine102769 W Camino Alto
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine116801 W Dogwood
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine12202 Walnut
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine13PO Box 205
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/AddressLine147008 W Farm Rd 94
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City0Springfield
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City1Springfield
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City2West Plains
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City3Miller
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/City4Springfield
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State0MO
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State1MO
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State2MO
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State3MO
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/State4MO
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode065810
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode165802
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode265775
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode365707
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode465803
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition02
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition12
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition22
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition32
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition42
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ContriToEmplBenefitPlansEtc40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/ExpenseAccountOtherAllowances40
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName0Carol Tinsley
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName1Danny Stanton
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName2Adam Madden
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName3Ed Mosher
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName4Linda Garrison
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title0Vice President
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title1Board Member
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title2President
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title3Board Member
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title4Board Member
IRS990EZ/OperatingSchool00
IRS990EZ/Organization501c30X
IRS990EZ/OrganizationDissolvedEtc00
IRS990EZ/OrganizationHadUBI00
IRS990EZ/OtherAssetsTotal/BOY038281
IRS990EZ/OtherAssetsTotal/EOY017028
IRS990EZ/OtherChangesInNetAssets00
IRS990EZ/OtherExpensesTotal073984
IRS990EZ/OtherRevenueTotal00
IRS990EZ/PartVIAHghstPaidCntrctProfSer0NONE
IRS990EZ/PartVIOfCompOfHighestPaidEmpl0NONE
IRS990EZ/PrimaryExemptPurpose0To facilitate short term mission trips to the US and abroad
IRS990EZ/PrintingPublicationsPostage01678
IRS990EZ/ProgramServiceAccomplishment/DescriptionProgramServiceAccom0Religious Programs, General/Other: Upon This Rock performed ministry activities in Mexico and the US in 2010. Improvements were made to many buildings in Reynosa, MX. Vacation Bible Schools were held in and around Reynosa. Outreach Events were held in local baseball and soccer fields. We also had a Medical clinic that was held at an orphanage, homeless shelter and several churches(8 Events)
IRS990EZ/ProgramServiceAccomplishment/GrantsAndAllocations00
IRS990EZ/ProgramServiceAccomplishment/ProgramServiceExpenses0212894
IRS990EZ/ProgramServiceRevenue00
IRS990EZ/ProhibitedTaxShelterTrans00
IRS990EZ/RelatedOrgControlledEntity00
IRS990EZ/SalariesOtherCompEmplBenefits0114967
IRS990EZ/ScheduleBNotRequired0X
IRS990EZ/SpecialEventsDirectExpenses00
IRS990EZ/SpecialEventsNetIncomeLoss00
IRS990EZ/SumOfTotalLiabilities/BOY0167239
IRS990EZ/SumOfTotalLiabilities/EOY0163706
IRS990EZ/TanningServicesProvided00
IRS990EZ/TaxImposedUnderIRC491100
IRS990EZ/TaxImposedUnderIRC491200
IRS990EZ/TaxImposedUnderIRC495500
IRS990EZ/TheBooksAreInCareOf/AddressUS/AddressLine10906 W Acacia Avenue 5114 Box
IRS990EZ/TheBooksAreInCareOf/AddressUS/City0Alamo
IRS990EZ/TheBooksAreInCareOf/AddressUS/State0TX
IRS990EZ/TheBooksAreInCareOf/AddressUS/ZIPCode078516
IRS990EZ/TheBooksAreInCareOf/NamePerson0J Shawn Estes
IRS990EZ/TheBooksAreInCareOf/TelephoneNumber04172172425
IRS990EZ/TotalAssets/BOY0287445
IRS990EZ/TotalAssets/EOY0251279
IRS990EZ/TotalExpenses0213894
IRS990EZ/TotalProgramServiceExpenses0212894
IRS990EZ/TotalRevenue0181261
IRS990EZ/TrnsfrsExemptNonCharRelatedOrg00
IRS990EZ/WebSite0www.utri.org
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYear0181261
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus1Year0221638
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus2Years0201344
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus3Years0170123
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus4Years0112623
IRS990ScheduleA/GiftsGrantsContribReceived170/Total0886989
IRS990ScheduleA/OtherIncome170/CurrentTaxYearMinus4Years00
IRS990ScheduleA/OtherIncome170/Total00
IRS990ScheduleA/PubliclySupportedOrg170b1Avi0X
IRS990ScheduleA/PublicSupportPertcentage17001
IRS990ScheduleA/PublicSupportPertcentPriorYear01
IRS990ScheduleA/PublicSupportTotal1700886989
IRS990ScheduleA/TaxRevLeviedForOrgBenefit170/CurrentTaxYearMinus4Years00
IRS990ScheduleA/TaxRevLeviedForOrgBenefit170/Total00
IRS990ScheduleA/ThirtyThreePercntTestsCY1700X
IRS990ScheduleA/Total170/CurrentTaxYear0181261
IRS990ScheduleA/Total170/CurrentTaxYearMinus1Year0221638
IRS990ScheduleA/Total170/CurrentTaxYearMinus2Years0201344
IRS990ScheduleA/Total170/CurrentTaxYearMinus3Years0170123
IRS990ScheduleA/Total170/CurrentTaxYearMinus4Years0112623
IRS990ScheduleA/Total170/Total0886989
IRS990ScheduleA/TotalSupport0886989
IRS990ScheduleA/ValueSrvcFcltsFurnishedByGovt/CurrentTaxYearMinus4Years00
IRS990ScheduleA/ValueSrvcFcltsFurnishedByGovt/Total00
IRS990ScheduleO/GeneralExplanation/Explanation00.
IRS990ScheduleO/GeneralExplanation/Explanation1Expenses: 73,984
IRS990ScheduleO/GeneralExplanation/Explanation2F, F & E
IRS990ScheduleO/GeneralExplanation/Explanation3Loan Payable
IRS990ScheduleO/GeneralExplanation/Identifier0F99Z_P01_S00_L10
IRS990ScheduleO/GeneralExplanation/Identifier1F99Z_P01_S00_L16
IRS990ScheduleO/GeneralExplanation/Identifier2F99Z_P02_S00_L24
IRS990ScheduleO/GeneralExplanation/Identifier3F99Z_P02_S00_L26
IRS990ScheduleO/GeneralExplanation/ReturnReference0Form 990-EZ, Part I, Line 10
IRS990ScheduleO/GeneralExplanation/ReturnReference1Form 990-EZ, Part I, Line 16
IRS990ScheduleO/GeneralExplanation/ReturnReference2Form 990-EZ, Part II, Line 24
IRS990ScheduleO/GeneralExplanation/ReturnReference3Form 990-EZ, Part II, Line 26
ReasonableCauseExplanation/Explanation0Additional time was needed to file an accurate return.
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0431946905
ReturnHeader/Filer/Name/BusinessNameLine10UPON THIS ROCK
ReturnHeader/Filer/NameControl0UPON
ReturnHeader/Filer/Phone04172172425
ReturnHeader/Filer/USAddress/AddressLine10PO Box 644
ReturnHeader/Filer/USAddress/City0Willard
ReturnHeader/Filer/USAddress/State0MO
ReturnHeader/Filer/USAddress/ZIPCode065781
ReturnHeader/Officer/DateSigned02011-08-15
ReturnHeader/Officer/Name0J Shawn Estes
ReturnHeader/Officer/Phone04172172425
ReturnHeader/Officer/Title0Administrator
ReturnHeader/ReturnType0990EZ
ReturnHeader/TaxPeriodBeginDate02010-01-01
ReturnHeader/TaxPeriodEndDate02010-12-31
ReturnHeader/TaxYear02010
ReturnHeader/Timestamp02011-08-15T13:56:10-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings