Civic Intelligence

Merlin Charitable Foundation

990PF • Fiscal year 2017 • EIN 46-4351193

Jan 01, 2017 to Dec 31, 2017 • Filed on Mar 01, 2018

10 Flagg CircleWaltham, MA 02453

(708) 387-1200

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

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

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

Liabilities / Revenue

59th percentile

0.00x

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

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

Net Margin

3rd percentile

-381%

Higher net margin than 3% of similar nonprofits.

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

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

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

Asset Growth

33rd percentile

-5.7%

Faster asset growth than 33% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

2nd percentile

-98%

Faster revenue growth than 2% of similar nonprofits.

2017 filings • <$500k nonprofits • Annualized from 2016 to 2017

Assets

Down

$215,643

Down $13,026 (-5.7%) from 2016

Net Assets

Down

$215,643

Down $13,026 (-5.7%) from 2016

Liabilities

Flat

$0

Flat from 2016

Revenue

Down

$3,418

Down $133,569 (-98%) from 2016

Expenses

Up

$16,444

Up $9,507 (+137%) from 2016

Net Income

Down

-$13,026

Down $143,076 (-110%) from 2016

Historical Trend

Balance Sheet Trend

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

$300K$200K$100K$0Assets 2013: $30,000Liabilities 2013: $02013Assets 2014: $95,172Liabilities 2014: $02014Assets 2015: $98,619Liabilities 2015: $0Net Assets 2015: $98,6192015Assets 2016: $228,669Liabilities 2016: $0Net Assets 2016: $228,6692016Assets 2017: $215,643Liabilities 2017: $0Net Assets 2017: $215,6432017Assets 2018: $206,475Liabilities 2018: $0Net Assets 2018: $206,4752018Assets 2019: $196,698Liabilities 2019: $0Net Assets 2019: $196,6982019Assets 2020: $256,365Liabilities 2020: $0Net Assets 2020: $256,3652020Assets 2021: $257,916Liabilities 2021: $0Net Assets 2021: $257,9162021Assets 2022: $252,188Liabilities 2022: $0Net Assets 2022: $252,1882022Assets 2023: $246,901Liabilities 2023: $0Net Assets 2023: $246,9012023Assets 2024: $252,655Liabilities 2024: $0Net Assets 2024: $252,6552024

Highlighted filing

2017

Assets$215,643
Liabilities$0
Net Assets$215,643

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2013: $30,000Expenses 2013: $0Net Income 2013: $30,0002013Revenue 2014: $71,707Expenses 2014: $6,534Net Income 2014: $65,1732014Revenue 2015: $11,522Expenses 2015: $8,076Net Income 2015: $3,4462015Revenue 2016: $136,987Expenses 2016: $6,937Net Income 2016: $130,0502016Revenue 2017: $3,418Expenses 2017: $16,444Net Income 2017: -$13,0262017Revenue 2018: $4,826Expenses 2018: $13,994Net Income 2018: -$9,1682018Revenue 2019: $5,262Expenses 2019: $15,039Net Income 2019: -$9,7772019Revenue 2020: $77,269Expenses 2020: $17,602Net Income 2020: $59,6672020Revenue 2021: $27,399Expenses 2021: $25,848Net Income 2021: $1,5512021Revenue 2022: $22,255Expenses 2022: $27,983Net Income 2022: -$5,7282022Revenue 2023: $21,403Expenses 2023: $26,690Net Income 2023: -$5,2872023Revenue 2024: $32,682Expenses 2024: $26,928Net Income 2024: $5,7542024

Highlighted filing

2017

Revenue$3,418
Expenses$16,444
Net Income-$13,026
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Mar 1, 2018
Return Version
2017v2.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
MARGARET K PRIMAK OFFICERTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Merlin Charitable Foundation
EIN
46-4351193
Address
10 FLAGG CIRCLE, Waltham, MA 02453

Signing Officer

Name
Maragret K Primak
Title
Officer
Phone
7817889388
Signed
2018-03-01
Discuss with paid preparer
Yes

Preparer

Firm
Passarelli Statewide Ltd
Address
9240 Broadway Ave, Brookfield, IL 60513
Preparer
Daniel Krage
Phone
7083871200
Raw XML Appendix286 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/AdjustedNetIncomeAmt00
AccountingFeesSchedule/AccountingFeesDetail/AdjustedNetIncomeAmt10
AccountingFeesSchedule/AccountingFeesDetail/Amt035
AccountingFeesSchedule/AccountingFeesDetail/Amt1350
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0FILING FEE - MA
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt1TAX PREP FEE
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt035
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt1350
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt00
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt10
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0215292
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0236991
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0INVESTMENTS
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt03419
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt03419
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt03419
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt0385
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt0385
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt016000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt016000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt03418
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt03418
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-13026
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt03379
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt059
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt039
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt059
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt016444
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt039
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt016444
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt03418
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt03418
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt0444
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt039
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt0444
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-13026
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0215643
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0228669
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0215643
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt011617
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt011617
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt011617
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt011651
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt034
IRS990PF/DistributableAmountGrp/TotalTaxAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt034
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/FMVAssetsEOYAmt0237342
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt0406
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt0351
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt0351
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0228263
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0215292
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0236991
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0228669
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0215643
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0237342
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0228669
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0215643
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0228669
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0215643
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedBOYAmt0228669
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt0215643
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0236572
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0378
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0236194
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt03549
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt011651
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0233023
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0236572
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0MARGARET K PRIMAK OFFICER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt010 FLAGG CIRCLE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Waltham
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd002453
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt07180
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt07214
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt06937
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt08076
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.030814
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.041593
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.081664
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt034
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0233023
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0166784
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt098893
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt016444
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.123257
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt016410
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt016444
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt034
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt016444
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/IndividualWithBooksNm0MARGARET K PRIMAK OFFICER
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt010 FLAGG CIRCLE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Waltham
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd002453
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MA
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum07817889388
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt04500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt11000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt22000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt31500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt4500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt51000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt62000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt72000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt81000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt9500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0PROVIDE HEALTHCARE IN WAR-TORN NATIONS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1PROVIDE WOMEN CONTRACEPTIVES IN AFRICA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2PROVIDE WOMEN CONTRACEPTIVES IN S AMERICA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3PURCHASE OF BED NETS FOR AFFECTED AREAS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4GIRLS EDUCATION IN PAKISTAN AND AFGHANISTAN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt5PROVIDE DEWORMING SERVICES IN AFRICAN VILLAGES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt6MITIGATING EFFECTS OF CLIMATE CHANGE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt7UNDERGRAD LIBERAL ARTS EDUCATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt8OPPOSING MINORITY VOTER DISCRIMINATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt9HURRICANE AID TO PUERTO RICO
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/AddressLine1Txt010 Bricket Road
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CityNm0ST ALBANS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/CountryCd0UK
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/ForeignPostalCd0AL1 3JX
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientForeignAddress/ProvinceOrStateNm0HERTS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt4PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt5PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt6PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt7PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt8PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt9PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0DOCTORS WITHOUT BORDERS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm1PATHFINDER INTERNATIONAL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm2INTERNATIONAL PLANNED PARENTHOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm3AGAINST MALARIA FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm4CENTRAL ASIA INSTITUTE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm5EVIDENCE ACTION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm6ENVIRONMENTAL DEFENSE FUND
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm7LAWRENCE UNIVERSITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm8LAWYERS COMMITTEE FOR CIVIL RIGHTS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm9HISPANIC FEDERATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0333 7TH AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt19 GALEN STREET SUITE 217
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt2125 MAIDEN LANE 9TH FLOOR
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt3PO Box 7209
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt4PO Box 65480
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt518 TREMONT ST
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt6711 E BOLDT WAY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt71401 NEW YORK AVE NW 400
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt855 EXCHANGE PLACE 5TH FLOOR
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0New York
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1Watertown
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2New York
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3Bozeman
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4Washington
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm5Boston
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm6Appleton
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm7Washington
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm8New York
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1MA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3MT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd4DC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd5MA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd6WI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd7DC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd8NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd010001
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd102472
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd210038
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd359771
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd420035
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd502108
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd654911
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd720005
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd810005
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt016000
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/AppliedToCurrentYearAmt011617
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt011617
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt04827
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt04827
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt016444
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt04827
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt04827
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt00
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt10
TaxesSchedule/TaxesDetail/Amt039
TaxesSchedule/TaxesDetail/Amt120
TaxesSchedule/TaxesDetail/CategoryTxt0FOREIGN TAXES PAID
TaxesSchedule/TaxesDetail/CategoryTxt1EXCISE TAX
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt039
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt120
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt039
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt10
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0MARAGRET K PRIMAK
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0OFFICER
ReturnHeader/BusinessOfficerGrp/PhoneNum07817889388
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-03-01
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MERLIN CHARITABLE FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0MERL
ReturnHeader/Filer/EIN0464351193
ReturnHeader/Filer/USAddress/AddressLine1Txt010 FLAGG CIRCLE
ReturnHeader/Filer/USAddress/CityNm0Waltham
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MA
ReturnHeader/Filer/USAddress/ZIPCd002453
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0FEA4A300338DCC8F8437301FBED07E3045190EF6
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0FEA4A300338DCC8F8437301FBED07E3045190EF6
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId01502492018130vzneznm
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02018-05-10
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt050.247.170.245
ReturnHeader/FilingSecurityInformation/IPDt02018-05-10
ReturnHeader/FilingSecurityInformation/IPTm011:59:31
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0202013576
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Passarelli Statewide Ltd
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt09240 Broadway Ave
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Brookfield
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd060513
ReturnHeader/PreparerPersonGrp/PhoneNum07083871200
ReturnHeader/PreparerPersonGrp/PreparationDt02018-05-10
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Daniel Krage
ReturnHeader/ReturnTs02018-05-10T11:57:52-04: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

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.53$0.00$2.53$0.33$0.27$0.06
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.47$0.00$2.47$0.21$0.27$0.05
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.52$0.00$2.52$0.22$0.28$0.06
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.58$0.00$2.58$0.27$0.26$0.02
2020Detailed filing. Detailed filing data is available for this year.$2.56$0.00$2.56$0.77$0.18$0.60
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.97$0.00$1.97$0.05$0.15$0.10
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.06$0.00$2.06$0.05$0.14$0.09
2017Detailed filing. Detailed filing data is available for this year.$2.16$0.00$2.16$0.03$0.16$0.13
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.29$0.00$2.29$1.37$0.07$1.30
2015Detailed filing. Detailed filing data is available for this year.$0.99$0.00$0.99$0.12$0.08$0.03
2014Summary only. Only limited summary data is available for this year.$0.95$0.00$0.72$0.07$0.65
2013Summary only. Only limited summary data is available for this year.$0.30$0.00$0.30$0.00$0.30