Civic Intelligence

Brewer Alice Testamentary Trust

990PF • Fiscal year 2017 • EIN 61-6321918

Jan 01, 2017 to Dec 31, 2017 • Filed on Apr 03, 2018

Organization Profile
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

35th percentile

0.00x

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

2017 filings • $500k-$1M nonprofits • Source year 2017

Liabilities / Revenue

35th percentile

0.00x

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

2017 filings • $500k-$1M nonprofits • Source year 2017

Net Margin

10th percentile

-38%

Higher net margin than 10% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Source year 2017

Top Officer Pay

60th percentile

$8,540

Higher top officer pay than 60% of similar nonprofits.

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

2017 filings • $500k-$1M nonprofits • Source year 2017

Asset Growth

33rd percentile

-1.7%

Faster asset growth than 33% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Annualized from 2016 to 2017

Revenue Growth

86th percentile

64%

Faster revenue growth than 86% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets35th percentile

Assets

Down

$678,522

Down $11,648 (-1.7%) from 2016

Net Assets

Down

$678,522

Down $11,648 (-1.7%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue35th percentileNet Margin10th percentile

Revenue

Up

$30,754

Up $11,996 (+64%) from 2016

Expenses

Up

$42,403

Up $177 (+0.4%) from 2016

Net Income

Up

-$11,649

Up $11,819 (+50%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth33rd percentile

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

$800K$600K$400K$200K$0Assets 2011: $739,437Liabilities 2011: $02011Assets 2012: $735,292Liabilities 2012: $0Net Assets 2012: $735,2922012Assets 2013: $725,728Liabilities 2013: $0Net Assets 2013: $725,7282013Assets 2014: $727,761Liabilities 2014: $0Net Assets 2014: $727,7612014Assets 2015: $713,637Liabilities 2015: $0Net Assets 2015: $713,6372015Assets 2016: $690,170Liabilities 2016: $0Net Assets 2016: $690,1702016Assets 2017: $678,522Liabilities 2017: $0Net Assets 2017: $678,5222017Assets 2018: $667,089Liabilities 2018: $0Net Assets 2018: $667,0892018Assets 2019: $652,996Liabilities 2019: $0Net Assets 2019: $652,9962019Assets 2020: $644,491Liabilities 2020: $0Net Assets 2020: $644,4912020Assets 2021: $628,584Liabilities 2021: $0Net Assets 2021: $628,5842021Assets 2022: $607,918Liabilities 2022: $0Net Assets 2022: $607,9182022Assets 2023: $608,042Liabilities 2023: $0Net Assets 2023: $608,0422023Assets 2024: $604,327Liabilities 2024: $0Net Assets 2024: $604,3272024

Highlighted filing

2017

Assets$678,522
Liabilities$0
Net Assets$678,522
Open 2017 Filing

Operations Trend

Revenue Growth86th percentile

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

$60K$40K$20K$0-$20K-$40KRevenue 2011: $26,736Expenses 2011: $32,600Net Income 2011: -$5,8642011Expenses 2012: $33,5692012Revenue 2013: $22,305Expenses 2013: $31,964Net Income 2013: -$9,6592013Revenue 2014: $43,493Expenses 2014: $40,616Net Income 2014: $2,8772014Revenue 2015: $28,396Expenses 2015: $42,520Net Income 2015: -$14,1242015Revenue 2016: $18,758Expenses 2016: $42,226Net Income 2016: -$23,4682016Revenue 2017: $30,754Expenses 2017: $42,403Net Income 2017: -$11,6492017Revenue 2018: $31,875Expenses 2018: $42,916Net Income 2018: -$11,0412018Revenue 2019: $28,122Expenses 2019: $42,217Net Income 2019: -$14,0952019Revenue 2020: $30,058Expenses 2020: $38,270Net Income 2020: -$8,2122020Revenue 2021: $23,177Expenses 2021: $38,314Net Income 2021: -$15,1372021Revenue 2022: $20,361Expenses 2022: $41,085Net Income 2022: -$20,7242022Revenue 2023: $34,758Expenses 2023: $34,954Net Income 2023: -$1962023Revenue 2024: $34,494Expenses 2024: $38,267Net Income 2024: -$3,7732024

Highlighted filing

2017

Revenue$30,754
Expenses$42,403
Net Income-$11,649
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Apr 3, 2018
Return Version
2017v2.2
Compensation and Service Providers
Top Officer Pay60th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrustee-$8,540-$8,540
DAVID BUNTINGTrustee-$2,400-$2,400
Filing and Contact Details

Filer

Filer Name
Brewer Alice Testamentary Trust
EIN
61-6321918
Phone
4127625188
Address
PO BOX 609, PITTSBURGH, PA 15230-9738

Signing Officer

Name
Pnc Bank N a by
Title
Vice President
Phone
4127625188
Signed
2018-04-03
Raw XML Appendix340 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
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt018556
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt012171
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/Desc0FEDERAL TAX REFUND
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionAmt027
IRS990PF/AnalysisIncomeProducingActyGrp/OtherRevenueDescribedGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt030754
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt030754
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt012171
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt05470
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt05470
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt010940
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt030000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt030000
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt018556
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt018556
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-11649
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt028625
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt01380
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesRevAndExpnssAmt01380
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt012171
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt025257
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt015
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt015
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt027
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt068
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt036865
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt05470
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt042403
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt030727
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt030754
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt06865
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt05470
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt012403
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02013-04-05
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12006-11-02
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22013-04-05
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt04619
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt12991
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt28844
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt01881
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt13509
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt2-844
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt37625
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt01881
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt13509
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt2-844
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt06500
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt16500
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt28000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0163.687 MFS VALUE FUND CLASS I FUND 893
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc196.841 T ROWE PRICE GROWTH STOCK FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2654.129 TEMPLETON GLOBAL BOND FUND AD FUND
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc3CAPITAL GAIN DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02017-09-14
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12017-09-14
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22017-09-14
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt012171
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-11649
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt01
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0678522
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0690170
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0678522
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt036476
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt036476
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt036476
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt036729
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0253
IRS990PF/DistributableAmountGrp/TotalTaxAmt0253
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0136
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0253
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0253
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0253
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0117
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0136
IRS990PF/FMVAssetsEOYAmt0739148
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt0690170
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt0678522
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0558124
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt0549281
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt0558864
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0109397
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0101787
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0152830
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt022649
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt027454
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt027454
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0690170
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0678522
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0739148
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0690170
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0678522
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0690170
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0678522
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0745763
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0745763
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt011186
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt036729
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0734577
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0745763
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt12
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt02400
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt18540
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0DAVID BUNTING
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1PNC BANK NA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt01900 E 9TH STREET
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt11900 E 9TH STREET
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0CLEVELAND
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1CLEVELAND
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0OH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1OH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd044114
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd144114
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt031987
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt032240
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt036285
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt036366
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt035570
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt027010
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt027855
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.043545
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.050149
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.048447
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.046071
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.035638
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.037422
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0253
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0734577
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0723551
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0750636
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0772063
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0757893
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0744354
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt036865
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.217727
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt036612
IRS990PF/QualifyingDistriPartXIIGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt036865
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0253
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt036865
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideCashDistriTestAmt00
IRS990PF/QualifyingDistriPartXIIGrp/SetAsideSuitabilityTestAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0true
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0true
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0620 LIBERTY AVENUE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0PITTSBURGH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0PA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd015222
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0PNC BANK NA
IRS990PF/StatementsRegardingActyGrp/PhoneNum04127625188
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0ISSUED SCHOLARSHIPS TO 6 INDIVIDUALS FOR STUDY AT TWO INSTITUTIONS
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/FormAndInfoAndMaterialsTxt0SEE COPY OF APPLICATION
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPersonNm0GUIDANCE OFFICE OF WARREN TOWNSHIP
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPhoneNum08006228036
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/AddressLine1Txt017962 GAGES LAKE RD
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/CityNm0GAGES LAKE
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/StateAbbreviationCd0IL
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/ZIPCd060330
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RestrictionsOnAwardsTxt0SEE GUIDELINES ON APPLICATION
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/SubmissionDeadlinesTxt0APRIL 1
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt030000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0SCHOLARSHIPS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0SCHOLARSHIP RECIPIENTS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0INDIVIDUALS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0BOX 609
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0PITTSBURGH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0PA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd015230
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt030000
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt07828
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt029037
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt036476
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt036865
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt028648
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt029037
LegalFeesSchedule/LegalFeesGrp/CategoryTxt0LEGAL FEES - PRINCIPAL (ALLOCA
LegalFeesSchedule/LegalFeesGrp/DisbursementsCharitablePrpsAmt01380
LegalFeesSchedule/LegalFeesGrp/LegalFeesAmt01380
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0STATE FILING FEES
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt015
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt015
OtherIncomeSchedule2/OtherIncomeDetail/Desc0FEDERAL TAX REFUND FROM PRIOR YEAR
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt00
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt027
OtherIncreasesSchedule/OtherIncreasesDetail/Amt01
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0ROUNDING ADJUSTMENT
TaxesSchedule/TaxesDetail/Amt068
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL ESTIMATES - PRINCIPAL
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/PersonNm0PNC BANK N A BY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum04127625188
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-04-03
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0BREWER ALICE TESTAMENTARY TRUST
ReturnHeader/Filer/BusinessNameControlTxt0BREW
ReturnHeader/Filer/EIN0616321918
ReturnHeader/Filer/PhoneNum04127625188
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 609
ReturnHeader/Filer/USAddress/CityNm0PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd0152309738
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId03BB8C0E9FEC78F69228AD1801D614A994052CE46
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId03BB8C0E9FEC78F69228AD1801D614A994052CE46
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0161.150.176.3
ReturnHeader/ReturnTs02018-04-04T09:11:03-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$678,522
Liabilities
$0
Net assets
$678,522
Revenue
$30,754
Expenses
$42,403
Net income
-$11,649
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$6.04$0.00$6.04$0.34$0.38$0.04
2023Detailed filing. Detailed filing data is available for this year.$6.08$0.00$6.08$0.35$0.35$0.00
2022Detailed filing. Detailed filing data is available for this year.$6.08$0.00$6.08$0.20$0.41$0.21
2021Detailed filing. Detailed filing data is available for this year.$6.29$0.00$6.29$0.23$0.38$0.15
2020Detailed filing. Detailed filing data is available for this year.$6.44$0.00$6.44$0.30$0.38$0.08
2019Detailed filing. Detailed filing data is available for this year.$6.53$0.00$6.53$0.28$0.42$0.14
2018Detailed filing. Detailed filing data is available for this year.$6.67$0.00$6.67$0.32$0.43$0.11
2017Detailed filing. Detailed filing data is available for this year.$6.79$0.00$6.79$0.31$0.42$0.12
2016Detailed filing. Detailed filing data is available for this year.$6.90$0.00$6.90$0.19$0.42$0.23
2015Detailed filing. Detailed filing data is available for this year.$7.14$0.00$7.14$0.28$0.43$0.14
2014Detailed filing. Detailed filing data is available for this year.$7.28$0.00$7.28$0.43$0.41$0.03
2013Detailed filing. Detailed filing data is available for this year.$7.26$0.00$7.26$0.22$0.32$0.10
2012Detailed filing. Detailed filing data is available for this year.$7.35$0.00$7.35$0.34
2011Summary only. Only limited summary data is available for this year.$7.39$0.00$0.27$0.33$0.06