Civic Intelligence

Guernsey Foundation

990EZ • Fiscal year 2012 • EIN 23-7059684

Jan 01, 2012 to Dec 31, 2012 • Filed on May 08, 2013

Organization Profile
1224 Alton Darby Creek Rd43228
Siviq Scores

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

Liabilities / Assets

59th percentile

0.01x

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

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

Liabilities / Revenue

93rd percentile

0.60x

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

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

Net Margin

2nd percentile

-266%

Higher net margin than 2% of similar nonprofits.

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

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

51st percentile

1.6%

Faster asset growth than 51% of similar nonprofits.

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

Revenue Growth

Score unavailable

No value available

A valid growth rate could not be computed from the available filing history.

Annualized from 2011 to 2012

Balance Sheet
Liabilities / Assets59th percentile

Assets

Down

$325,253

Down $15,143 (-4.4%) from 2010

Net Assets

Down

$322,378

Down $17,570 (-5.2%) from 2010

Liabilities

Up

$2,875

Up $2,427 (+542%) from 2010

Revenue And Expenses
Liabilities / Revenue93rd percentileNet Margin2nd percentile

Revenue

Up

$4,806

Up $2,533 (+111%) from 2010

Expenses

Down

$17,566

Down $1,744 (-9.0%) from 2010

Net Income

Up

-$12,760

Up $4,277 (+25%) from 2010

Historical Trend

Balance Sheet Trend

Asset Growth51st percentile

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

$400K$300K$200K$100K$0Assets 2010: $340,396Liabilities 2010: $448Net Assets 2010: $339,9482010Assets 2012: $325,253Liabilities 2012: $2,875Net Assets 2012: $322,3782012Assets 2013: $349,823Liabilities 2013: $1,750Net Assets 2013: $348,0732013Assets 2014: $306,494Liabilities 2014: $1,783Net Assets 2014: $304,7112014Assets 2015: $285,712Liabilities 2015: $1,355Net Assets 2015: $284,3572015Assets 2016: $281,124Liabilities 2016: $1,524Net Assets 2016: $279,6002016Assets 2020: $191,063Liabilities 2020: $1,824Net Assets 2020: $189,2392020Assets 2021: $328,285Liabilities 2021: $0Net Assets 2021: $328,2852021

Highlighted filing

2012

Assets$325,253
Liabilities$2,875
Net Assets$322,378
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$100K$50K$0-$50KRevenue 2010: $2,273Expenses 2010: $19,310Net Income 2010: -$17,0372010Revenue 2012: $4,806Expenses 2012: $17,566Net Income 2012: -$12,7602012Revenue 2013: $41,455Expenses 2013: $15,761Net Income 2013: $25,6942013Revenue 2014: $15,861Expenses 2014: $59,223Net Income 2014: -$43,3622014Revenue 2015: $320Expenses 2015: $20,474Net Income 2015: -$20,1542015Revenue 2016: $11,634Expenses 2016: $17,633Net Income 2016: -$5,9992016Revenue 2020: $21,966Expenses 2020: $9,266Net Income 2020: $12,7002020Revenue 2021: $35,524Expenses 2021: $9,156Net Income 2021: $26,3682021

Highlighted filing

2012

Revenue$4,806
Expenses$17,566
Net Income-$12,760
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
May 8, 2013
Return Version
2012v2.0
Filing and Contact Details

Filer

EIN
23-7059684
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/ActivitiesNotPreviouslyRpt0false
IRS990EZ/CashSavingsAndInvestments/BOY0311075
IRS990EZ/CashSavingsAndInvestments/EOY0316248
IRS990EZ/ContributionsGiftsGrantsEtc065
IRS990EZ/CostOfGoodsSold00
IRS990EZ/CostOtherBasisAndSalesExpenses070000
IRS990EZ/DidOrgFileForm1120POLThisYear0false
IRS990EZ/DoesOrgHaveHospital0false
IRS990EZ/EngagedInExcessBenefitTrans0false
IRS990EZ/EngageInLobbyingActivities0false
IRS990EZ/EngagePoliticalCmpgnActivities0false
IRS990EZ/ExcessOrDeficitForYear0-12760
IRS990EZ/FeesAndOthPymtToIndContractors01410
IRS990EZ/FiledScheduleA0false
IRS990EZ/ForeignFinancialAccount0false
IRS990EZ/ForeignOffice0false
IRS990EZ/FundraisingGrossIncome00
IRS990EZ/GainOrLossFromSaleOfAssets00
IRS990EZ/GamingGrossIncome00
IRS990EZ/GrantsAndSimilarAmountsPaid03825
IRS990EZ/GroProfitLossSalesOfInventory00
IRS990EZ/GrossAmountFromSaleOfAssets070000
IRS990EZ/GrossReceipts074806
IRS990EZ/InfoInScheduleOPartI0X
IRS990EZ/InfoInScheduleOPartII0X
IRS990EZ/InvestmentIncome04741
IRS990EZ/MadeChangesToOrgnzngEtcDoc0false
IRS990EZ/MadeLoansToFromOfficers0false
IRS990EZ/MaintainAnyDonorAdvisedFunds0false
IRS990EZ/MembershipDues00
IRS990EZ/MethodOfAccountingAccrual0X
IRS990EZ/NetAssetsOrFundBalances/BOY0317475
IRS990EZ/NetAssetsOrFundBalancesBOY0317475
IRS990EZ/NetAssetsOrFundBalances/EOY0322378
IRS990EZ/NetAssetsOrFundBalancesEOY0322378
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition05.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition15.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition25.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AvgHoursPerWkDevotedToPosition35.00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation00
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation10
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation20
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Compensation30
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName0BLAINE CROSSER
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName1CLARK VILTER
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName2DR JOHN MOZIER
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/PersonName3SETH JOHNSON
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title0Trustee
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title1Trustee
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title2Trustee
IRS990EZ/OfficerDirectorTrusteeKeyEmpl/Title3Admin Sec
IRS990EZ/OperatingSchool0false
IRS990EZ/Organization501c30X
IRS990EZ/OrganizationDissolvedEtc0false
IRS990EZ/OrganizationHadUBI0false
IRS990EZ/OtherAssetsTotal/BOY09005
IRS990EZ/OtherAssetsTotal/EOY09005
IRS990EZ/OtherChangesInNetAssets017663
IRS990EZ/OtherExpensesTotal012331
IRS990EZ/PartVIAHghstPaidCntrctProfSer0NONE
IRS990EZ/PartVIOfCompOfHighestPaidEmpl0NONE
IRS990EZ/PrimaryExemptPurpose0See Attached Statement
IRS990EZ/ProgramServiceAccomplishment/DescriptionProgramServiceAccom0TO FURTHER EDUCATION AND RESEARCH IN DAIRY INDUSTRY
IRS990EZ/ProgramServiceAccomplishment/ProgramServiceExpenses03825
IRS990EZ/ProgramServiceRevenue00
IRS990EZ/ProhibitedTaxShelterTrans0false
IRS990EZ/RelatedOrgControlledEntity0false
IRS990EZ/RelatedOrgSection527Org0false
IRS990EZ/ScheduleBNotRequired0X
IRS990EZ/SpecialEventsDirectExpenses00
IRS990EZ/SpecialEventsNetIncomeLoss00
IRS990EZ/SubjectToProxyTax0false
IRS990EZ/SumOfTotalLiabilities/BOY02605
IRS990EZ/SumOfTotalLiabilities/EOY02875
IRS990EZ/TanningServicesProvided0false
IRS990EZ/TheBooksAreInCareOf/AddressUS/AddressLine101224 ALTON DARBY CREEK RD
IRS990EZ/TheBooksAreInCareOf/AddressUS/City0COLUMBUS
IRS990EZ/TheBooksAreInCareOf/AddressUS/State0OH
IRS990EZ/TheBooksAreInCareOf/AddressUS/ZIPCode043228
IRS990EZ/TheBooksAreInCareOf/NamePerson0SETH JOHNSON
IRS990EZ/TheBooksAreInCareOf/TelephoneNumber06148642409
IRS990EZ/TotalAssets/BOY0320080
IRS990EZ/TotalAssets/EOY0325253
IRS990EZ/TotalExpenses017566
IRS990EZ/TotalProgramServiceExpenses03825
IRS990EZ/TotalRevenue04806
IRS990EZ/TransactionWithControlEntity0false
IRS990EZ/TrnsfrsExemptNonCharRelatedOrg0false
IRS990EZ/WebSite0www.usguernsey.com/foundation/
IRS990ScheduleA/AmountsSubstContributorsTotal07784
IRS990ScheduleA/FactsAndCircumstancesTest0PT II LINE 17B: ORGANIZATION MAINTAINS A CONTINUOUS AND BONA FIDE PROGRAM; FOR SOLICITATION OF FUNDS FROM THE GENERAL PUBLIC, COMMUNITY,; AND MEMBERSHIP GROUP INVOLVED.; DUE TO THE ORGANIZATIONS SMALL SIZE AND IRREGULAR CONTRIBUTION INCOME, IT DOESN'T; FIT THE PUBLIC SUPPORT TEST IN SOME YEARS. IN FACT, IT ISN'T REQUIRED TO FILE THE; 990-EZ AT ALL IN 2012 BECAUSE IT IS UNDER THE $25,000 GROSS RECEIPTS THRESHOLD.; HOWEVER THE ORGANIZATION DESIRES TO FILE FOR FULL DISCLOSURE PURPOSES; AND FOR CONSISTENCY IN REPORTING.;
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYear065
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus2Years0260
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus3Years01215
IRS990ScheduleA/GiftsGrantsContribReceived170/CurrentTaxYearMinus4Years010038
IRS990ScheduleA/GiftsGrantsContribReceived170/Total011578
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYear04741
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYearMinus1Year03331
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYearMinus2Years05327
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYearMinus3Years08399
IRS990ScheduleA/GrossInvestmentIncome170/CurrentTaxYearMinus4Years013050
IRS990ScheduleA/GrossInvestmentIncome170/Total034848
IRS990ScheduleA/InvestmentIncomePercentage00
IRS990ScheduleA/PubliclySupportedOrg170b1Avi0X
IRS990ScheduleA/PublicSupportPercentage50900
IRS990ScheduleA/PublicSupportPertcentage17000.08170
IRS990ScheduleA/PublicSupportPertcentPriorYear00.10210
IRS990ScheduleA/PublicSupportTotal17003794
IRS990ScheduleA/PublicSupportTotal50900
IRS990ScheduleA/TenPercentTestPriorYear0X
IRS990ScheduleA/Total170/CurrentTaxYear065
IRS990ScheduleA/Total170/CurrentTaxYearMinus2Years0260
IRS990ScheduleA/Total170/CurrentTaxYearMinus3Years01215
IRS990ScheduleA/Total170/CurrentTaxYearMinus4Years010038
IRS990ScheduleA/Total170/Total011578
IRS990ScheduleA/TotalSupport046426
IRS990ScheduleO/GeneralExplanation/Explanation0RESEARCH PROJECT RESEARCH NEOGEN CORPORATION N/A 3825.
IRS990ScheduleO/GeneralExplanation/Explanation1INVESTMENT FEES 1722. ADMINISTRATIVE FEES 4200. ADVERTISING 4025. BANK CHARGES 319. APPRAISAL FEES 2065.
IRS990ScheduleO/GeneralExplanation/Explanation2UNREALIZED GAIN ON SECURITIES 17663.
IRS990ScheduleO/GeneralExplanation/Explanation3ACCOUNTS RECEIVABLE 2168. 2168. AGA LOAN 6837. 6837.
IRS990ScheduleO/GeneralExplanation/Explanation4ACCOUNTS PAYABLE 2605. 2525. FUNDS DUE AGA 350.
IRS990ScheduleO/GeneralExplanation/Explanation5APPRAISAL FEE
IRS990ScheduleO/GeneralExplanation/Identifier0Form 990EZ, Part I, Line 10
IRS990ScheduleO/GeneralExplanation/Identifier1Form 990EZ, Part I, Line 16
IRS990ScheduleO/GeneralExplanation/Identifier2Form 990EZ, Part I, Line 20
IRS990ScheduleO/GeneralExplanation/Identifier3Form 990EZ, Part II, Line 24
IRS990ScheduleO/GeneralExplanation/Identifier4Form 990EZ, Part II, Line 26
IRS990ScheduleO/GeneralExplanation/Identifier5Form 990, Part IX, Line 24f
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0237059684
ReturnHeader/Filer/Name/BusinessNameLine10GUERNSEY FOUNDATION
ReturnHeader/Filer/NameControl0GUER
ReturnHeader/Filer/Phone06148642409
ReturnHeader/Filer/USAddress/AddressLine101224 ALTON DARBY CREEK RD
ReturnHeader/Filer/USAddress/City0COLUMBUS
ReturnHeader/Filer/USAddress/State0OH
ReturnHeader/Filer/USAddress/ZIPCode043228
ReturnHeader/Officer/AuthorizeThirdParty0true
ReturnHeader/Officer/DateSigned02013-05-08
ReturnHeader/Officer/Name0SETH JOHNSON
ReturnHeader/Officer/Phone06148642409
ReturnHeader/Officer/Title0ADMIN SECRETARY
ReturnHeader/Preparer/DatePrepared02013-08-13
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10THE ACCOUNTING DEPT INC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10405A N BRICE RD PO BOX 577
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0BLACKLICK
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0OH
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode043004
ReturnHeader/Preparer/Name0BOBBI J CRAWFORD
ReturnHeader/Preparer/Phone06147599967
ReturnHeader/ReturnType0990EZ
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-08-13T07:04:33-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990EZFacts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
$325,253
Liabilities
$2,875
Net assets
$322,378
Revenue
$4,806
Expenses
$17,566
Net income
-$12,760
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.28$0.00$3.28$0.36$0.09$0.26
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.91$0.02$1.89$0.22$0.09$0.13
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.81$0.02$2.80$0.12$0.18$0.06
2015Detailed filing. Detailed filing data is available for this year.$2.86$0.01$2.84$0.00$0.20$0.20
2014Detailed filing. Detailed filing data is available for this year.$3.06$0.02$3.05$0.16$0.59$0.43
2013Detailed filing. Detailed filing data is available for this year.$3.50$0.02$3.48$0.41$0.16$0.26
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.25$0.03$3.22$0.05$0.18$0.13
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.40$0.00$3.40$0.02$0.19$0.17