Civic Intelligence

Graham and Thelma Somerville Charitable Trust

990PF • Fiscal year 2013 • EIN 35-6547211

Nov 01, 2012 to Oct 31, 2013 • Filed on Dec 23, 2013

Organization Profile
PO Box 60915230-9738
Siviq Scores

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

Liabilities / Assets

27th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2013 filings • $1M-$5M nonprofits • Source year 2013

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2013

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2013

Top Officer Pay

58th percentile

$29,995

Higher top officer pay than 58% of similar nonprofits.

2013 filings • $1M-$5M nonprofits • Source year 2013

Asset Growth

58th percentile

3.7%

Faster asset growth than 58% of similar nonprofits.

2013 filings • $1M-$5M nonprofits • Annualized from 2012 to 2013

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets27th percentile

Assets

Up

$2,819,272

Up $100,707 (+3.7%) from 2012

Net Assets

Up

$2,819,272

Up $100,707 (+3.7%) from 2012

Liabilities

Flat

$0

Flat from 2012

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$232,323

Up $13,634 (+6.2%) from 2012

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth58th percentile

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

$4.0M$3.0M$2.0M$1.0M$0Assets 2012: $2,718,565Liabilities 2012: $0Net Assets 2012: $2,718,5652012Assets 2013: $2,819,272Liabilities 2013: $0Net Assets 2013: $2,819,2722013Assets 2014: $2,889,740Liabilities 2014: $0Net Assets 2014: $2,889,7402014Assets 2015: $2,951,929Liabilities 2015: $0Net Assets 2015: $2,951,9292015Assets 2016: $2,802,344Liabilities 2016: $0Net Assets 2016: $2,802,3442016Assets 2017: $2,751,284Liabilities 2017: $0Net Assets 2017: $2,751,2842017Assets 2019: $3,405,189Liabilities 2019: $0Net Assets 2019: $3,405,1892019Assets 2020: $3,230,825Liabilities 2020: $0Net Assets 2020: $3,230,8252020Assets 2021: $3,196,174Liabilities 2021: $0Net Assets 2021: $3,196,1742021

Highlighted filing

2013

Assets$2,819,272
Liabilities$0
Net Assets$2,819,272
Open 2013 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$400K$200K$0-$200KExpenses 2012: $218,6892012Expenses 2013: $232,3232013Revenue 2014: $301,735Expenses 2014: $254,423Net Income 2014: $47,3122014Revenue 2015: $284,556Expenses 2015: $196,738Net Income 2015: $87,8182015Revenue 2016: $136,937Expenses 2016: $286,523Net Income 2016: -$149,5862016Revenue 2017: $179,512Expenses 2017: $230,563Net Income 2017: -$51,0512017Revenue 2019: $176,821Expenses 2019: $259,465Net Income 2019: -$82,6442019Revenue 2020: $26,074Expenses 2020: $200,434Net Income 2020: -$174,3602020Revenue 2021: $227,243Expenses 2021: $257,499Net Income 2021: -$30,2562021

Highlighted filing

2013

Revenue-
Expenses$232,323
Net Income-
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Nov 1, 2012 to Oct 31, 2013
Signed
Dec 23, 2013
Return Version
2012v2.1
Compensation and Service Providers
Top Officer Pay58th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrustee-$29,995-$29,995
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid GrantARTHRITIS FOUNDATIONGENERAL SUPPORTPUBLIC CHARITYINDIANAPOLIS, IN, US$35,670
Paid GrantTURNSTONE CTR INCGENERAL SUPPORTPUBLIC CHARITYFORT WAYNE, IN, US$27,743
Paid GrantAMERICAN CANCER SOCIETYGENERAL SUPPORTPUBLIC CHARITYOKLAHOMA CITY, OK, US$27,742
Paid GrantAMERICAN LUNG ASSOCIATIONGENERAL SUPPORTPUBLIC CHARITYINDIANAPOLIS, IN, US$27,742
Paid GrantALZHEIMERS DISEASE & RELATEDGENERAL SUPPORTPUBLIC CHARITYINDIANAPOLIS, IN, US$13,872
Paid GrantCROSSROAD CHILD & FAMILY SVCSGENERAL SUPPORTPUBLIC CHARITYFORT WAYNE, IN, US$13,872
Paid GrantLEAGUE FT BLINDDISABLED INCGENERAL SUPPORTPUBLIC CHARITYFORT WAYNE, IN, US$13,872
Paid GrantSCANGENERAL SUPPORTPUBLIC CHARITYFORT WAYNE, IN, US$13,872
Paid GrantST MARY'S CATHOLIC CHURCHGENERAL SUPPORTPUBLIC CHARITYFORT WAYNE, IN, US$13,872
Paid GrantJR ACHIEVEMENT OF N INDIANAGENERAL SUPPORTPUBLIC CHARITYFORT WAYNE, IN, US$6,936
Paid GrantFORT WAYNE RESCUE MISSIONGENERAL SUPPORTPUBLIC CHARITYFORT WAYNE, IN, US$2,972
Filing and Contact Details

Filer

EIN
35-6547211
Raw XML Appendix393 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
AllOthProgRltdInvestmentsSch/AllOthProgRltdInvestments/Amount00
AllOthProgRltdInvestmentsSch/AllOthProgRltdInvestments/Description0N/A
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYBookValue01036948
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/EOYFMV01068280
InvestmentsCorpBondsSchedule/InvestmentsCorpBonds/NameOfBond0EQUITIES
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue01594454
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV02205282
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0FIXED INCOME
InvestmentsOtherSchedule2/InvestmentsOther/BookValue0125770
InvestmentsOtherSchedule2/InvestmentsOther/CategoryOrItem0OTHER
InvestmentsOtherSchedule2/InvestmentsOther/EOYFMV0123868
InvestmentsOtherSchedule2/InvestmentsOther/ListedAtCostOrFMV0AT COST
IRS990PF/AddressChange0X
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionAmount078464
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionAmount0254488
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionCode018
IRS990PF/AnalysisIncomeProducingActy/OtherInvestmentIncomePartVII/ExclusionAmount078
IRS990PF/AnalysisIncomeProducingActy/OtherInvestmentIncomePartVII/ExclusionCode018
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/ExclusionAmount0333030
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/RelatedOrExemptFunctionIncome00
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/UnrelatedBusinessIncomeAmount00
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA0333030
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm0254488
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblPrps014998
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncm014997
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnss029995
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps0198165
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss0198165
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm078464
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss078464
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0100707
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPrice01406526
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAssetsRevAndExpnss0254488
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome0317977
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncm078
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss078
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm056
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss04163
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps0213163
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm015053
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss0232323
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome0333030
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses0333030
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps014998
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm015053
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss034158
IRS990PF/BalanceSheets/CapitalStockBOY02718565
IRS990PF/BalanceSheets/CapitalStockEOY02819272
IRS990PF/BalanceSheets/InvestmentsCorpBondsBOY0987848
IRS990PF/BalanceSheets/InvestmentsCorpBondsEOY01036948
IRS990PF/BalanceSheets/InvestmentsCorpBondsEOYFMV01068280
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY01646355
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY01594454
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV02205282
IRS990PF/BalanceSheets/InvestmentsOtherBOY065338
IRS990PF/BalanceSheets/InvestmentsOtherEOY0125770
IRS990PF/BalanceSheets/InvestmentsOtherEOYFMV0123868
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/PaidInOrCapitalSurplusBOY00
IRS990PF/BalanceSheets/PaidInOrCapitalSurplusEOY00
IRS990PF/BalanceSheets/RetainedEarningsBOY00
IRS990PF/BalanceSheets/RetainedEarningsEOY00
IRS990PF/BalanceSheets/SavingsAndTempCashInvstBOY019024
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOY062100
IRS990PF/BalanceSheets/SavingsAndTempCashInvstEOYFMV062100
IRS990PF/BalanceSheets/TotalAssetsBOY02718565
IRS990PF/BalanceSheets/TotalAssetsEOY02819272
IRS990PF/BalanceSheets/TotalAssetsEOYFMV03459530
IRS990PF/BalanceSheets/TotalLiabilitiesBOY00
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY02718565
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY02819272
IRS990PF/BalanceSheets/TotalNetAssetsBOY02718565
IRS990PF/BalanceSheets/TotalNetAssetsEOY02819272
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome0254488
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis01152038
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset0SALES OF PUBLICLY TRADED SECURITIES
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset1CAPITAL GAINS DIVIDENDS
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss0248743
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss15745
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses0248743
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses15745
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice01400781
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice15745
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired0P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired1P
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0100707
IRS990PF/ChangesInNetAssetsFundBalances/OtherDecreases00
IRS990PF/ChangesInNetAssetsFundBalances/OtherIncreases00
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal02819272
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY02718565
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY02819272
IRS990PF/DistributableAmount/DeductionFrDistributableAmount00
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted0159414
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj0159414
IRS990PF/DistributableAmount/DistributableAmountBeforeDed0159414
IRS990PF/DistributableAmount/MinimumInvestmentReturn0165774
IRS990PF/DistributableAmount/RecoveriesQlfyDistributions00
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome06360
IRS990PF/DistributableAmount/TotalTax06360
IRS990PF/ExciseTaxBasedOnInvestmentIncm/EstTaxPaymentsAndOverpayment03100
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax06360
IRS990PF/ExciseTaxBasedOnInvestmentIncm/SubtitleATax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal06360
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome06360
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxDue03260
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TotalCreditsAndPayments03100
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY03459530
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AcquisitionIndebtedness00
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets03365973
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities03365973
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable050490
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn0165774
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets03315483
IRS990PF/MinimumInvestmentReturn/ReductionClaimed00
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets03365973
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition02.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation029995
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0PNC BANK NA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0TRUSTEE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10PO BOX 609
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0PITTSBURGH
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0PA
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode0152309738
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfCntrctPaidOver50k00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfOthEmplPaidOver50k00
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct0218176
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets0214996
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.064846
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.063692
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.079694
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.051198
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear400.064799
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax00
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets03315483
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear103177875
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear203216128
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear303015183
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear402678750
IRS990PF/QlfyUndSect4940eForReducedTax/OnePercentNetInvestmentIncome03180
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions0213163
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear10202405
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear20256305
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear30154372
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear40173580
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.259383
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions0213163
IRS990PF/QualifyingDistributions/ExpensesAndContributions0213163
IRS990PF/QualifyingDistributions/OnePctSect4940eOrgNetInvstIncm00
IRS990PF/QualifyingDistributions/ProgramRelatedInvestmentsTotal00
IRS990PF/QualifyingDistributions/QualifyingDistributions0213163
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported00
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract00
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets01
IRS990PF/StatementsRegardingActivities/BooksInCareOfBusinessName/BusinessNameLine10PNC BANK NA
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber08006228036
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10PO BOX 609
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0PITTSBURGH
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0PA
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode0152309738
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws00
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr01
IRS990PF/StatementsRegardingActivities/ForeignBank00
IRS990PF/StatementsRegardingActivities/Form1120POLFiled00
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG01
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity00
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities00
IRS990PF/StatementsRegardingActivities/MoreThan100Spent00
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors00
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation00
IRS990PF/StatementsRegardingActivities/ReimbursementOfTax00
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e01
IRS990PF/StatementsRegardingActivities/Sect4955TaxOnManagers00
IRS990PF/StatementsRegardingActivities/Sect4955TaxOnOrganization00
IRS990PF/StatementsRegardingActivities/StatesFiledWith0IN
IRS990PF/StatementsRegardingActivities/TerminationEtc00
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver100000
IRS990PF/StatementsRegardingActivities/WebsiteAddress0WWW.PNC.COM
IRS990PF/StatementsRegardingActy4720/ActsFailToQualifyAsExceptions00
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson00
IRS990PF/StatementsRegardingActy4720/BusinessHoldings00
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson00
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals00
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations00
IRS990PF/StatementsRegardingActy4720/InfluenceElection00
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation00
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments00
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose00
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson01
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical00
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract00
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn00
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract00
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson00
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson00
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments00
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs00
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears00
IRS990PF/SummaryOfDirectCharitableActy/Description10N/A
IRS990PF/SummaryOfDirectCharitableActy/Expenses100
IRS990PF/SumOfProgramRelatedInvestments/AllOthProgRltdInvestmentsTotal00
IRS990PF/SumOfProgramRelatedInvestments/Amount100
IRS990PF/SumOfProgramRelatedInvestments/Description10N/A
IRS990PF/SumOfProgramRelatedInvestments/Total00
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount013872
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount127742
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount227742
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount335670
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount413872
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount52972
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount66936
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount713872
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount813872
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount913872
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount1027743
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution1GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution2GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution3GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution4GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution5GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution6GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution7GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution8GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution9GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution10GENERAL SUPPORT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine10ALZHEIMERS DISEASE & RELATED
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine11AMERICAN CANCER SOCIETY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine12AMERICAN LUNG ASSOCIATION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine13ARTHRITIS FOUNDATION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine14CROSSROAD CHILD & FAMILY SVCS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine15FORT WAYNE RESCUE MISSION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine16JR ACHIEVEMENT OF N INDIANA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine17LEAGUE FT BLINDDISABLED INC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine18SCAN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine19ST MARY'S CATHOLIC CHURCH
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientBusinessName/BusinessNameLine110TURNSTONE CTR INC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus0PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus1PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus2PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus3PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus4PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus5PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus6PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus7PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus8PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus9PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus10PUBLIC CHARITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship0N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship1N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship2N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship3N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship4N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship5N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship6N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship7N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship8N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship9N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship10N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine1050 EAST 91ST ST STE 100
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine11PO BOX 720366
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine12115 W WASHINGTON STREET STE 1180
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine13615 N ALABAMA ST STE 430
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine142525 LAKE AVENUE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine15301 SUPERIOR ST
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine16601 NOBLE DRIVE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine175821 SOUTH ANTHONY BLVD
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine18500 W MAIN STREET
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine19PO BOX 11383
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine1103320 N CLINTON ST
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0INDIANAPOLIS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City1OKLAHOMA CITY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City2INDIANAPOLIS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City3INDIANAPOLIS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City4FORT WAYNE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City5FORT WAYNE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City6FORT WAYNE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City7FORT WAYNE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City8FORT WAYNE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City9FORT WAYNE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City10FORT WAYNE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State1OK
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State2IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State3IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State4IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State5IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State6IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State7IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State8IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State9IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State10IN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode046240
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode173162
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode246204
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode346204
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode446805
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode5468551116
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode646825
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode7468163701
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode846802
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode9468571383
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode10468055407
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/TotGrantOrContriApprovedFuture00
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear0198165
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO00
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO00
IRS990PF/UndistributedIncome/AppliedToCurrentYear0159414
IRS990PF/UndistributedIncome/AppliedToPriorYears00
IRS990PF/UndistributedIncome/AppliedToYear100
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted0159414
IRS990PF/UndistributedIncome/DistriFromCorpus170b1EOr4942g300
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear1046596
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear2098985
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear304935
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear4041549
IRS990PF/UndistributedIncome/ExcessDistriCyovAppCYCorpus00
IRS990PF/UndistributedIncome/ExcessDistriCyovAppliedCY00
IRS990PF/UndistributedIncome/ExcessDistriCyovFromYear500
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear0245814
IRS990PF/UndistributedIncome/ExcessFromCurrentYear053749
IRS990PF/UndistributedIncome/ExcessFromYear1046596
IRS990PF/UndistributedIncome/ExcessFromYear2098985
IRS990PF/UndistributedIncome/ExcessFromYear304935
IRS990PF/UndistributedIncome/ExcessFromYear4041549
IRS990PF/UndistributedIncome/PriorYearDeficiencyOrTax00
IRS990PF/UndistributedIncome/PriorYearUndistributedIncome00
IRS990PF/UndistributedIncome/QualifyingDistributions0213163
IRS990PF/UndistributedIncome/RemainingDistriFromCorpus053749
IRS990PF/UndistributedIncome/TaxableAmount100
IRS990PF/UndistributedIncome/TaxableAmount200
IRS990PF/UndistributedIncome/TotalCorpus0245814
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover0192065
IRS990PF/UndistributedIncome/TotalForPriorYears00
IRS990PF/UndistributedIncome/TreatedAsDistriFromCorpus00
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
IRS990PF/UndistributedIncome/UndistributedIncomePriorYear00
OtherIncomeSchedule2/OtherIncome/AdjustedNetIncome078
OtherIncomeSchedule2/OtherIncome/Description0PROCEEDS DUE ON CLASS ACTIONS
OtherIncomeSchedule2/OtherIncome/NetInvestmentIncome078
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks078
TaxesSchedule/Taxes/Amount01007
TaxesSchedule/Taxes/Amount13100
TaxesSchedule/Taxes/Amount256
TaxesSchedule/Taxes/Category0PRIOR YEAR TAX BALANCE DUE
TaxesSchedule/Taxes/Category1ESTIMATED TAX PAID
TaxesSchedule/Taxes/Category2FOREIGN TAXES PAID
TaxesSchedule/Taxes/DisbursementsCharitablePrps00
TaxesSchedule/Taxes/DisbursementsCharitablePrps10
TaxesSchedule/Taxes/DisbursementsCharitablePrps20
TaxesSchedule/Taxes/NetInvestmentIncome00
TaxesSchedule/Taxes/NetInvestmentIncome10
TaxesSchedule/Taxes/NetInvestmentIncome256
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/Filer/EIN0356547211
ReturnHeader/Filer/Name/BusinessNameLine10GRAHAM & THELMA SOMERVILLE CHARITABLE TR
ReturnHeader/Filer/Name/BusinessNameLine20PNC BANK NA
ReturnHeader/Filer/NameControl0GRAH
ReturnHeader/Filer/Phone08006228036
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 609
ReturnHeader/Filer/USAddress/City0PITTSBURGH
ReturnHeader/Filer/USAddress/State0PA
ReturnHeader/Filer/USAddress/ZIPCode0152309738
ReturnHeader/Officer/DateSigned02013-12-23
ReturnHeader/Officer/Name0TIMOTHY VARNER
ReturnHeader/Officer/Phone08006228036
ReturnHeader/Officer/Title0OFFICER
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-11-01
ReturnHeader/TaxPeriodEndDate02013-10-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-12-23T12:47:54-06:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2013 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$2,819,272
Liabilities
$0
Net assets
$2,819,272
Revenue
-
Expenses
$232,323
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.20$0.00$3.20$0.23$0.26$0.03
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$3.23$0.00$3.23$0.03$0.20$0.17
2019Detailed filing. Detailed filing data is available for this year.$3.41$0.00$3.41$0.18$0.26$0.08
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.75$0.00$2.75$0.18$0.23$0.05
2016Detailed filing. Detailed filing data is available for this year.$2.80$0.00$2.80$0.14$0.29$0.15
2015Detailed filing. Detailed filing data is available for this year.$2.95$0.00$2.95$0.28$0.20$0.09
2014Detailed filing. Detailed filing data is available for this year.$2.89$0.00$2.89$0.30$0.25$0.05
2013Detailed filing. Detailed filing data is available for this year.$2.82$0.00$2.82$0.23
2012Detailed filing. Detailed filing data is available for this year.$2.72$0.00$2.72$0.22