Civic Intelligence

Mershon Living Tr

990PF • Fiscal year 2013 • EIN 37-6260224

Jan 01, 2013 to Dec 31, 2013 • Filed on Mar 28, 2014

PO Box 609Pittsburgh, PA 15230-9738

(412) 762-5188

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

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

2013 filings • <$500k nonprofits • Source year 2013

Liabilities / Revenue

60th percentile

0.00x

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

2013 filings • <$500k nonprofits • Source year 2013

Net Margin

46th percentile

1.0%

Higher net margin than 46% of similar nonprofits.

2013 filings • <$500k nonprofits • Source year 2013

Top Officer Pay

78th percentile

$2,901

Higher top officer pay than 78% of similar nonprofits.

Top officer pay equals 31.9% of source-year revenue.

2013 filings • <$500k nonprofits • Source year 2013

Asset Growth

49th percentile

0.4%

Faster asset growth than 49% of similar nonprofits.

2013 filings • <$500k nonprofits • Annualized from 2012 to 2013

Revenue Growth

2nd percentile

-96%

Faster revenue growth than 2% of similar nonprofits.

2013 filings • <$500k nonprofits • Annualized from 2012 to 2013

Assets

Up

$199,476

Up $842 (+0.4%) from 2012

Net Assets

$199,476

No earlier filing loaded for comparison.

Liabilities

Up

$1

Up $1 from 2012

Revenue

Down

$9,107

Down $250,466 (-96%) from 2012

Expenses

Down

$9,013

Down $40,537 (-82%) from 2012

Net Income

Down

$94

Down $209,929 (-100%) from 2012

Historical Trend

Balance Sheet Trend

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

$300K$200K$100K$0Assets 2012: $198,634Liabilities 2012: $02012Assets 2013: $199,476Liabilities 2013: $1Net Assets 2013: $199,4762013Assets 2014: $209,177Liabilities 2014: $1Net Assets 2014: $209,1772014Assets 2015: $211,453Liabilities 2015: $1Net Assets 2015: $211,4532015Assets 2017: $208,003Liabilities 2017: $0Net Assets 2017: $208,0032017Assets 2018: $275,119Liabilities 2018: $0Net Assets 2018: $275,1192018Assets 2019: $289,173Liabilities 2019: $1Net Assets 2019: $289,1732019Assets 2020: $254,013Liabilities 2020: $1Net Assets 2020: $254,0132020Assets 2021: $261,828Liabilities 2021: $1Net Assets 2021: $261,8282021Assets 2022: $249,520Liabilities 2022: $1Net Assets 2022: $249,5202022Assets 2023: $239,646Liabilities 2023: $12023Assets 2024: $235,109Liabilities 2024: $0Net Assets 2024: $235,1092024

Highlighted filing

2013

Assets$199,476
Liabilities$1
Net Assets$199,476

Operations Trend

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

$300K$200K$100K$0-$100KRevenue 2012: $259,573Expenses 2012: $49,550Net Income 2012: $210,0232012Revenue 2013: $9,107Expenses 2013: $9,013Net Income 2013: $942013Revenue 2014: $19,682Expenses 2014: $9,231Net Income 2014: $10,4512014Revenue 2015: $13,133Expenses 2015: $10,860Net Income 2015: $2,2732015Revenue 2017: $21,913Expenses 2017: $15,397Net Income 2017: $6,5162017Revenue 2018: $83,471Expenses 2018: $16,358Net Income 2018: $67,1132018Revenue 2019: $30,236Expenses 2019: $16,183Net Income 2019: $14,0532019Revenue 2020: $8,341Expenses 2020: $15,650Net Income 2020: -$7,3092020Revenue 2021: $23,894Expenses 2021: $16,119Net Income 2021: $7,7752021Revenue 2022: $978Expenses 2022: $16,147Net Income 2022: -$15,1692022Revenue 2023: $5,860Expenses 2023: $15,957Net Income 2023: -$10,0972023Revenue 2024: $12,647Expenses 2024: $17,080Net Income 2024: -$4,4332024

Highlighted filing

2013

Revenue$9,107
Expenses$9,013
Net Income$94
Jump To
Filing Snapshot
Filing Period
Jan 1, 2013 to Dec 31, 2013
Signed
Mar 28, 2014
Return Version
2013v3.0
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrustee-$2,901-$2,901
Filing and Contact Details

Filer

EIN
37-6260224
Phone
4127625188

Signing Officer

Name
John W Alrutz
Title
Assistant Vice President
Phone
4127625188
Signed
2014-03-28
Raw XML Appendix293 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/AllOtherProgramRelatedInvstGrp/Amt00
AllOthProgRltdInvestmentsSch/AllOtherProgramRelatedInvstGrp/Desc0N/A
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt082026
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1101724
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0MUTUAL FUND - FIXED INCOME
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1MUTUAL FUND - EQUITIES
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt084322
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt1166641
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt04835
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt04267
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt05
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt09107
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt09107
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt04263
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt01451
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt01450
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt02901
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt05000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt05000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt04835
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt04835
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt094
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt09375
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt05
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt05
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt04267
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt07653
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt0922
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0922
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0190
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt07373
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt01450
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt09013
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt09103
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt09107
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt02373
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt01450
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt04013
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt05112
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-112
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt14375
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-112
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt14375
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt05000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt14375
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0SALES OF PUBLICLY TRADED SECURITIES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt04263
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt094
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt0748
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0199476
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0198634
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0199476
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt012060
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt012060
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt012060
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt012213
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0153
IRS990PF/DistributableAmountGrp/TotalTaxAmt0153
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0100
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0153
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0153
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0153
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt053
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0100
IRS990PF/FMVAssetsEOYAmt0266689
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0198634
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0193501
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0188110
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0183750
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0250963
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt05975
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt010524
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt015726
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt015726
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0198634
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0199476
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0266689
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0198634
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0199476
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0198634
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0199476
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0247970
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0247970
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt03720
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt012213
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0244250
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0247970
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt02901
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0PNC BANK NA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine10620 LIBERTY AVENUE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City0PITTSBURGH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State0PA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode015222
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization4947a1TrtdPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt044844
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt044921
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt047972
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.183598
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.183598
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt077
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0244250
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0261288
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt07373
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.183598
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt07373
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt07373
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt07373
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd00
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd01
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd01
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd00
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine10620 LIBERTY AVENUE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/City0PITTSBURGH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/State0PA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCode0152222705
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NECTFilingInLieuOFForm1041Ind0X
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine10PNC BANK NA
IRS990PF/StatementsRegardingActyGrp/PhoneNum04127625188
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxExemptInterestAmt00
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0ISSUED SCHOLARSHIPS TO 2 STUDENTS FOR STUDY AT 1 UNIVERSITY
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt05000
IRS990PF/SumOfProgramRelatedInvstGrp/AllOtherProgramRltdInvstTotAmt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt02500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt12500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1SCHOLARSHIP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine10BRITTANY N WATZNAUER - DRAKE UNIVERSITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine11DANIELLE R WATZNAUER - DRAKE UNIVERSITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PUBLIC CHARITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PUBLIC CHARITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine102507 UNIVERSITY AVENUE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine112507 UNIVERSITY AVENUE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City0DES MOINES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City1DES MOINES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State0IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State1IA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode0503114505
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode1503114505
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt05000
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt07373
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt012060
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt04687
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt034998
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt04687
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt030311
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt030311
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt07373
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt030311
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt034998
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0STATE AG FILING FEE
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1SCHOLARSHIP MANAGEMENT FEE
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt030
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt1892
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt030
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt1892
OtherIncreasesSchedule/OtherIncreasesDetail/Amount0748
OtherIncreasesSchedule/OtherIncreasesDetail/Description0DIFFERENCE BETWEEN TAX COST AND CARRYING VALUE
TaxesSchedule/TaxesDetail/Amt090
TaxesSchedule/TaxesDetail/Amt1100
TaxesSchedule/TaxesDetail/CategoryTxt0PRIOR YEAR TAX BALANCE DUE
TaxesSchedule/TaxesDetail/CategoryTxt1ESTIMATED TAXES PAID FOR 12/31/13
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt10
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/BusinessOfficerGrp/PersonNm0JOHN W ALRUTZ
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0ASSISTANT VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum04127625188
ReturnHeader/BusinessOfficerGrp/SignatureDt02014-03-28
ReturnHeader/Filer/BusinessName/BusinessNameLine10MERSHON CHARITABLE TRUST PNC BANK NA
ReturnHeader/Filer/BusinessNameControlTxt0MERS
ReturnHeader/Filer/EIN0376260224
ReturnHeader/Filer/PhoneNum04127625188
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 609
ReturnHeader/Filer/USAddress/City0PITTSBURGH
ReturnHeader/Filer/USAddress/State0PA
ReturnHeader/Filer/USAddress/ZIPCode0152309738
ReturnHeader/ReturnTs02014-03-31T06:19:38-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02013-01-01
ReturnHeader/TaxPeriodEndDt02013-12-31
ReturnHeader/TaxYr02013

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$2.35$0.00$2.35$0.13$0.17$0.04
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.40$0.00$0.06$0.16$0.10
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.50$0.00$2.50$0.01$0.16$0.15
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.62$0.00$2.62$0.24$0.16$0.08
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.54$0.00$2.54$0.08$0.16$0.07
2019Detailed filing. Detailed filing data is available for this year.$2.89$0.00$2.89$0.30$0.16$0.14
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.75$0.00$2.75$0.83$0.16$0.67
2017Detailed filing. Detailed filing data is available for this year.$2.08$0.00$2.08$0.22$0.15$0.07
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.11$0.00$2.11$0.13$0.11$0.02
2014Detailed filing. Detailed filing data is available for this year.$2.09$0.00$2.09$0.20$0.09$0.10
2013Detailed filing. Detailed filing data is available for this year.$1.99$0.00$1.99$0.09$0.09$0.00
2012Summary only. Only limited summary data is available for this year.$1.99$0.00$2.60$0.50$2.10