Civic Intelligence

The Douglas a Mercer Foundation C/O Douglas a Mercer

990PF • Fiscal year 2017 • EIN 30-0234768

Jan 01, 2017 to Dec 31, 2017 • Filed on Feb 21, 2018

Organization Profile
80 Towne Hill RoadBradford, MA 01835-8279

(978) 372-4926

Siviq Scores

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

Liabilities / Assets

25th percentile

0.00x

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

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

Liabilities / Revenue

25th percentile

0.00x

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

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

Net Margin

3rd percentile

-171%

Higher net margin than 3% of similar nonprofits.

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

Top Officer Pay

42nd percentile

$0

Higher top officer pay than 42% of similar nonprofits.

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

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

Asset Growth

42nd percentile

0.6%

Faster asset growth than 42% of similar nonprofits.

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

Revenue Growth

55th percentile

7.3%

Faster revenue growth than 55% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets25th percentile

Assets

Up

$1,659,640

Up $9,671 (+0.6%) from 2016

Net Assets

Up

$1,659,640

Up $9,671 (+0.6%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue And Expenses
Liabilities / Revenue25th percentileNet Margin3rd percentile

Revenue

Up

$48,117

Up $3,255 (+7.3%) from 2016

Expenses

Up

$130,520

Up $33 (+0.0%) from 2016

Net Income

Up

-$82,403

Up $3,222 (+3.8%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth42nd percentile

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

$2.0M$1.5M$1.0M$500K$0Assets 2010: $1,710,144Liabilities 2010: $0Net Assets 2010: $1,710,1442010Assets 2011: $1,688,224Liabilities 2011: $0Net Assets 2011: $1,688,2242011Assets 2012: $1,750,483Liabilities 2012: $0Net Assets 2012: $1,750,4832012Assets 2013: $1,777,216Liabilities 2013: $0Net Assets 2013: $1,777,2162013Assets 2014: $1,769,821Liabilities 2014: $0Net Assets 2014: $1,769,8212014Assets 2015: $1,604,516Liabilities 2015: $0Net Assets 2015: $1,604,5162015Assets 2016: $1,649,969Liabilities 2016: $0Net Assets 2016: $1,649,9692016Assets 2017: $1,659,640Liabilities 2017: $0Net Assets 2017: $1,659,6402017Assets 2018: $1,546,135Liabilities 2018: $0Net Assets 2018: $1,546,1352018

Highlighted filing

2017

Assets$1,659,640
Liabilities$0
Net Assets$1,659,640
Open 2017 Filing

Operations Trend

Revenue Growth55th percentile

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

$200K$100K$0-$100K-$200KExpenses 2010: $69,1632010Expenses 2011: $46,6142011Expenses 2012: $54,9152012Revenue 2013: $33,997Expenses 2013: $66,153Net Income 2013: -$32,1562013Revenue 2014: $45,151Expenses 2014: $117,042Net Income 2014: -$71,8912014Revenue 2015: $55,159Expenses 2015: $165,424Net Income 2015: -$110,2652015Revenue 2016: $44,862Expenses 2016: $130,487Net Income 2016: -$85,6252016Revenue 2017: $48,117Expenses 2017: $130,520Net Income 2017: -$82,4032017Revenue 2018: $3,746Expenses 2018: $65,768Net Income 2018: -$62,0222018

Highlighted filing

2017

Revenue$48,117
Expenses$130,520
Net Income-$82,403
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Feb 21, 2018
Return Version
2017v2.2
Compensation and Service Providers
Top Officer Pay42nd percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
DOUGLAS A MERCERPresident, Director-$0--
Filing and Contact Details

Filer

Filer Name
The Douglas a Mercer Foundation
EIN
30-0234768
Phone
9783724926
Address
80 TOWNE HILL ROAD, BRADFORD, MA 01835-8279

Signing Officer

Name
Douglas a Mercer
Title
President
Phone
9783724926
Signed
2018-02-21
Discuss with paid preparer
Yes

Preparer

Firm
Edelstein and Company Llp
Address
160 FEDERAL STREET 9TH FLOOR, BOSTON, MA 02110
Preparer
Scott Kaplowitch
Phone
6172276161
Raw XML Appendix306 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
AccountingFeesSchedule/AccountingFeesDetail/Amt01800
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0TAX PREPARATION
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt01800
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt00
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm0FIDELITY BOND FUNDS
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt0543362
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt0543362
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0997922
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0997922
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0FIDELITY SECURITIES
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt034024
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt013075
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt01018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt048117
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt048117
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt01800
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt01800
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt013075
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt0128000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt0128000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt034024
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt034024
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-82403
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt013075
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt01018
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt01018
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt0380
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesRevAndExpnssAmt0380
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt013075
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt048117
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0340
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt0130180
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0130520
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt048117
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt048117
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt02180
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt02520
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt013075
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt013075
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt013075
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt013075
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-82403
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt092074
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01659640
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01649969
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01659640
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt082743
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt082743
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt082743
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt083224
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0481
IRS990PF/DistributableAmountGrp/TotalTaxAmt0481
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0451
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0481
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0481
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0481
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt030
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0451
IRS990PF/FMVAssetsEOYAmt01659640
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0524070
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt0543362
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt0543362
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0886297
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0997922
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0997922
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt01649969
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt01659640
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0239602
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0118356
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0118356
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01649969
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01659640
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01659640
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01649969
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01659640
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01649969
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01659640
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01689832
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0214546
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01475286
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt025347
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt083224
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01664485
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01689832
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0DOUGLAS A MERCER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0PRESIDENT, DIRECTOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt080 TOWNE HILL ROAD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0BRADFORD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd001835
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt0102957
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt0103438
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt0129406
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt0164588
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0115040
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt062515
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt052196
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.061855
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.080328
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.097712
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.065273
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.035405
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.030559
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0481
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt01664485
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt01610967
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt01684420
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt01762446
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt01765705
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt01708015
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt0130180
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.309277
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt0129699
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt0130180
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0481
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt0130180
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
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/IndividualWithBooksNm0DOUGLAS A MERCER
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt080 TOWNE HILL ROAD
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0BRADFORD
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd001835
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0DE
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PhoneNum09783724926
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0DOUGLAS A MERCER
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt0128000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0EDUCATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0RENSSELAER POLYTECHNIC INSTITUTE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0110 EIGHTH STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0TROY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd012180
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt0128000
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/AppliedToCurrentYearAmt082743
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt082743
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt049756
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt025926
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0123119
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt047437
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt049756
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt025926
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt0130180
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt047437
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0123119
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt075682
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
LegalFeesSchedule/LegalFeesGrp/CategoryTxt0LEGAL FEES
LegalFeesSchedule/LegalFeesGrp/DisbursementsCharitablePrpsAmt0380
LegalFeesSchedule/LegalFeesGrp/LegalFeesAmt0380
LegalFeesSchedule/LegalFeesGrp/NetInvestmentIncomeAmt00
OtherIncreasesSchedule/OtherIncreasesDetail/Amt092074
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0UNREALIZED GAIN ON INVESTMENTS
TaxesSchedule/TaxesDetail/Amt0340
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL EXCISE TAX
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0DOUGLAS A MERCER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum09783724926
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-02-21
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0THE DOUGLAS A MERCER FOUNDATION
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0C/O DOUGLAS A MERCER
ReturnHeader/Filer/BusinessNameControlTxt0DOUG
ReturnHeader/Filer/EIN0300234768
ReturnHeader/Filer/PhoneNum09783724926
ReturnHeader/Filer/USAddress/AddressLine1Txt080 TOWNE HILL ROAD
ReturnHeader/Filer/USAddress/CityNm0BRADFORD
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MA
ReturnHeader/Filer/USAddress/ZIPCd0018358279
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0BF7B59384A5F0335E7334C3E3948748C245A0205
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0C1284B650163F101757B7047818B4EE77766F5D2
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt038.111.9.114
ReturnHeader/FilingSecurityInformation/IPDt02018-02-21
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0ES
ReturnHeader/FilingSecurityInformation/IPTm011:54:05
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0042442519
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0EDELSTEIN AND COMPANY LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0160 FEDERAL STREET 9TH FLOOR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0BOSTON
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd002110
ReturnHeader/PreparerPersonGrp/PhoneNum06172276161
ReturnHeader/PreparerPersonGrp/PreparationDt02018-02-21
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0SCOTT KAPLOWITCH
ReturnHeader/ReturnTs02018-02-26T15:02:20-06: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
$1,659,640
Liabilities
$0
Net assets
$1,659,640
Revenue
$48,117
Expenses
$130,520
Net income
-$82,403
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2018Detailed filing. Detailed filing data is available for this year.$1.55$0.00$1.55$0.00$0.07$0.06
2017Detailed filing. Detailed filing data is available for this year.$1.66$0.00$1.66$0.05$0.13$0.08
2016Detailed filing. Detailed filing data is available for this year.$1.65$0.00$1.65$0.04$0.13$0.09
2015Detailed filing. Detailed filing data is available for this year.$1.60$0.00$1.60$0.06$0.17$0.11
2014Detailed filing. Detailed filing data is available for this year.$1.77$0.00$1.77$0.05$0.12$0.07
2013Detailed filing. Detailed filing data is available for this year.$1.78$0.00$1.78$0.03$0.07$0.03
2012Detailed filing. Detailed filing data is available for this year.$1.75$0.00$1.75$0.05
2011Detailed filing. Detailed filing data is available for this year.$1.69$0.00$1.69$0.05
2010Detailed filing. Detailed filing data is available for this year.$1.71$0.00$1.71$0.07