STRATEGY STUDIO / PUBLIC DATA EXPLORER

THE MERWIN FOUNDATION: Form 990PF, tax year 2017

View the entire original 990 at ProPublica ↗

Organization
THE MERWIN FOUNDATION (EIN 36-7699613)
Tax period
2017-01-01 to 2017-12-31
Filed
2018-06-21
IRS object ID
201831729349100108
Schema version
2017v2.3
Source
Download XML · Original 990 at ProPublica

Every field in the e-filed return. Faint text is the IRS element name, for citing.

Return header ReturnHeader

FieldValueIRS element (for citing)
Return2018-06-21T12:05:36-05:00ReturnTs
Tax Period End2017-12-31TaxPeriodEndDt

Preparer Firm PreparerFirmGrp

FieldValueIRS element (for citing)
Preparer Firm EIN464411427PreparerFirmEIN

Preparer Firm Name PreparerFirmName

FieldValueIRS element (for citing)
Business Name Line1GRAHAM NEWLIN LLCBusinessNameLine1Txt

Preparer US Address PreparerUSAddress

FieldValueIRS element (for citing)
Address Line1202 N CENTER STAddressLine1Txt
CityBLOOMINGTONCityNm
State AbbreviationILStateAbbreviationCd
ZIP617013901ZIPCd
FieldValueIRS element (for citing)
Return Type990PFReturnTypeCd
Tax Period Begin2017-01-01TaxPeriodBeginDt

Filer Filer

FieldValueIRS element (for citing)
EIN367699613EIN

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1THE MERWIN FOUNDATIONBusinessNameLine1Txt
FieldValueIRS element (for citing)
Business Name ControlMERWBusinessNameControlTxt
Phone3096642135PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line1PO BOX 1665AddressLine1Txt
CityBLOOMINGTONCityNm
State AbbreviationILStateAbbreviationCd
ZIP617021665ZIPCd

Business Officer BusinessOfficerGrp

FieldValueIRS element (for citing)
PersonSHARON MERWINPersonNm
Person TitlePRESIDENTPersonTitleTxt
Phone3096642135PhoneNum
Signature2018-06-18SignatureDt
Discuss With Paid PreparerYes (true)DiscussWithPaidPreparerInd

Preparer Person PreparerPersonGrp

FieldValueIRS element (for citing)
Preparer PersonBRUCE W BREITWEISERPreparerPersonNm
PTINP00361715PTIN
Phone3122781130PhoneNum
Preparation2018-06-21PreparationDt
Self EmployedYes (X)SelfEmployedInd
FieldValueIRS element (for citing)
Tax2017TaxYr
Build TS2022-09-23 18:48:47ZBuildTS

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Initial ReturnYes (X)InitialReturnInd
Organization501c3 Exempt PFYes (X)Organization501c3ExemptPFInd
FMV Assets EOY$5,514,595FMVAssetsEOYAmt
Method Of Accounting CashYes (X)MethodOfAccountingCashInd

Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses

FieldValueIRS element (for citing)
Schedule B Not RequiredYes (X)ScheduleBNotRequiredInd
Total Rev And Expnss$0TotalRevAndExpnssAmt
Total Net Invst Incm$0TotalNetInvstIncmAmt
Tot Opr Expenses Rev And Expnss$0TotOprExpensesRevAndExpnssAmt
Tot Opr Expenses Net Invst Incm$0TotOprExpensesNetInvstIncmAmt
Tot Opr Expenses Dsbrs Chrtbl$0TotOprExpensesDsbrsChrtblAmt
Contri Paid Rev And Expnss$0ContriPaidRevAndExpnssAmt
Contri Paid Dsbrs Chrtbl$0ContriPaidDsbrsChrtblAmt
Total Expenses Rev And Expnss$0TotalExpensesRevAndExpnssAmt
Total Expenses Net Invst Incm$0TotalExpensesNetInvstIncmAmt
Total Expenses Dsbrs Chrtbl$0TotalExpensesDsbrsChrtblAmt
Excess Revenue Over Expenses$0ExcessRevenueOverExpensesAmt
Net Investment Income$0NetInvestmentIncomeAmt

Form990 PF Balance Sheets Form990PFBalanceSheetsGrp

FieldValueIRS element (for citing)
Sav And Temp Cash Invst EOY$662,172SavAndTempCashInvstEOYAmt
Sav And Temp Cash Invst EOYFMV$662,172SavAndTempCashInvstEOYFMVAmt
Corporate Stock EOY$4,852,423CorporateStockEOYAmt
Corporate Stock EOYFMV$4,852,423CorporateStockEOYFMVAmt
Total Assets EOY$5,514,595TotalAssetsEOYAmt
Total Assets EOYFMV$5,514,595TotalAssetsEOYFMVAmt
Total Liabilities EOY$0TotalLiabilitiesEOYAmt
Organization Follows SFAS117Yes (X)OrganizationFollowsSFAS117Ind
Unrestricted EOY$5,514,595UnrestrictedEOYAmt
Tot Net Ast Or Fund Balances EOY$5,514,595TotNetAstOrFundBalancesEOYAmt
Total Liabilities Net Ast BOY$0TotalLiabilitiesNetAstBOYAmt
Total Liabilities Net Ast EOY$5,514,595TotalLiabilitiesNetAstEOYAmt

Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp

FieldValueIRS element (for citing)
Other Increases$5,514,595OtherIncreasesAmt
Subtotal$5,514,595SubtotalAmt
Tot Net Ast Or Fund Balances EOY$5,514,595TotNetAstOrFundBalancesEOYAmt

Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp

FieldValueIRS element (for citing)
Investment Income Excise Tax$0InvestmentIncomeExciseTaxAmt

Statements Regarding Acty StatementsRegardingActyGrp

FieldValueIRS element (for citing)
Legislative Political ActyfalseLegislativePoliticalActyInd
More Than100 SpentfalseMoreThan100SpentInd
Form1120 POL FiledfalseForm1120POLFiledInd
Activities Not Previously RptfalseActivitiesNotPreviouslyRptInd
Changes To Articles Or BylawsfalseChangesToArticlesOrBylawsInd
Unrelated Bus Incm Over LimitfalseUnrelatedBusIncmOverLimitInd
Organization Dissolved EtcfalseOrganizationDissolvedEtcInd
Section508e Rqr SatisfiedYes (true)Section508eRqrSatisfiedInd
At Least5000 In AssetsYes (true)AtLeast5000InAssetsInd
Org Report Or Register StateILOrgReportOrRegisterStateCd
Form990 PF Filed With Atty GenYes (true)Form990PFFiledWithAttyGenInd
Private Operating FoundationfalsePrivateOperatingFoundationInd
New Substantial ContributorsfalseNewSubstantialContributorsInd
Own Controlled EntityfalseOwnControlledEntityInd
Donor Advised FundfalseDonorAdvisedFundInd
Comply With Public Insp RqrYes (true)ComplyWithPublicInspRqrInd
Website AddressN/AWebsiteAddressTxt

Persons With Books Name PersonsWithBooksName

FieldValueIRS element (for citing)
Business Name Line1COLORADO STATE BANK AND TRUSTBusinessNameLine1Txt
FieldValueIRS element (for citing)
Phone3038647253PhoneNum

Location Of Books US Address LocationOfBooksUSAddress

FieldValueIRS element (for citing)
Address Line1PO BOX 1270AddressLine1Txt
CityTULSACityNm
State AbbreviationOKStateAbbreviationCd
ZIP741011270ZIPCd
FieldValueIRS element (for citing)
Foreign Accounts QuestionfalseForeignAccountsQuestionInd

Statements Regarding Acty4720 StatementsRegardingActy4720Grp

FieldValueIRS element (for citing)
Sale Or Exch Disqualified PrsnfalseSaleOrExchDisqualifiedPrsnInd
Brrw Or Lend Disqualified PrsnfalseBrrwOrLendDisqualifiedPrsnInd
Furn Goods Disqualified PrsnfalseFurnGoodsDisqualifiedPrsnInd
Pay Comp Disqualified PrsnfalsePayCompDisqualifiedPrsnInd
Transfer Ast Disqualified PrsnfalseTransferAstDisqualifiedPrsnInd
Payment To Government OfficialfalsePaymentToGovernmentOfficialInd
Uncorrected Prior ActsfalseUncorrectedPriorActsInd
Undistributed Income PYfalseUndistributedIncomePYInd
Business HoldingsfalseBusinessHoldingsInd
Jeopardy InvestmentsfalseJeopardyInvestmentsInd
Uncorrected PY Jeopardy InvstfalseUncorrectedPYJeopardyInvstInd
Influence LegislationfalseInfluenceLegislationInd
Influence ElectionfalseInfluenceElectionInd
Grants To IndividualsfalseGrantsToIndividualsInd
Grants To OrganizationsfalseGrantsToOrganizationsInd
Noncharitable PurposefalseNoncharitablePurposeInd
Rcv Fnds To Pay Prsnl Bnft CntrctfalseRcvFndsToPayPrsnlBnftCntrctInd
Pay Premiums Prsnl Bnft CntrctfalsePayPremiumsPrsnlBnftCntrctInd
Prohibited Tax Shelter TransfalseProhibitedTaxShelterTransInd

Officer Dir Trst Key Empl Info OfficerDirTrstKeyEmplInfoGrp

Officer Dir Trst Key Empl OfficerDirTrstKeyEmplGrp (3 entries)

Address Line1USAddress/AddressLine1TxtCityUSAddress/CityNmState AbbreviationUSAddress/StateAbbreviationCdZIPUSAddress/ZIPCdTitleTitleTxtAverage Hrs Per Wk Devoted To PosAverageHrsPerWkDevotedToPosRtCompensationCompensationAmtEmployee Benefit ProgramEmployeeBenefitProgramAmtExpense Account Other AllwncExpenseAccountOtherAllwncAmt
SHARON MERWIN
PO BOX 1665BLOOMINGTONIL617021665PRESIDENT000.00$0$0$0
LAURA REARDON
PO BOX 1665BLOOMINGTONIL617021665VICE-PRES000.00$0$0$0
GUY FRAKER
101 N MAINBLOOMINGTONIL61701SEC/TREAS000.00$0$0$0
FieldValueIRS element (for citing)
Comp Of Hghst Pd Empl Or NONENONECompOfHghstPdEmplOrNONETxt
Comp Of Hghst Pd Cntrct Or NONENONECompOfHghstPdCntrctOrNONETxt

Sum Of Program Related Invst SumOfProgramRelatedInvstGrp

FieldValueIRS element (for citing)
Description1N/ADescription1Txt

Minimum Investment Return MinimumInvestmentReturnGrp

FieldValueIRS element (for citing)
Average Monthly FMV Of Sec$3,840,642AverageMonthlyFMVOfSecAmt
Average Monthly Cash Balances$1,260,714AverageMonthlyCashBalancesAmt
FMV All Other Noncharitable Ast$0FMVAllOtherNoncharitableAstAmt
Total FMV Of Unused Assets$5,101,356TotalFMVOfUnusedAssetsAmt
Adjusted Total FMV Of Unused Ast$5,101,356AdjustedTotalFMVOfUnusedAstAmt
Cash Deemed Charitable$76,520CashDeemedCharitableAmt
Net Vl Noncharitable Assets$5,024,836NetVlNoncharitableAssetsAmt
Minimum Investment Return$251,242MinimumInvestmentReturnAmt

Distributable Amount DistributableAmountGrp

FieldValueIRS element (for citing)
Minimum Investment Return$251,242MinimumInvestmentReturnAmt
Distributable Before Adj$251,242DistributableBeforeAdjAmt
Distributable Before Ded$251,242DistributableBeforeDedAmt
Distributable As Adjusted$251,242DistributableAsAdjustedAmt

Qualifying Distri Part XII QualifyingDistriPartXIIGrp

FieldValueIRS element (for citing)
Expenses And Contributions$0ExpensesAndContributionsAmt
Qualifying Distributions$0QualifyingDistributionsAmt

Undistributed Income UndistributedIncomeGrp

FieldValueIRS element (for citing)
Distributable As Adjusted$251,242DistributableAsAdjustedAmt
Undistributed Income CY$251,242UndistributedIncomeCYAmt

Supplementary Information SupplementaryInformationGrp

FieldValueIRS element (for citing)
Only Contri To PreselectedYes (X)OnlyContriToPreselectedInd

Trnsfr Trans Rln Nonchrtbl EO TrnsfrTransRlnNonchrtblEOGrp

FieldValueIRS element (for citing)
Trnsfr Of Cash To Nonchrtbl EOfalseTrnsfrOfCashToNonchrtblEOInd
Trnsfr Other Asset Nonchrtbl EOfalseTrnsfrOtherAssetNonchrtblEOInd
Sales Or Exchanges Of AssetsfalseSalesOrExchangesOfAssetsInd
Purchase Of Assets Nonchrtbl EOfalsePurchaseOfAssetsNonchrtblEOInd
Rental Of Facilities Oth AssetsfalseRentalOfFacilitiesOthAssetsInd
Reimbursement ArrangementsfalseReimbursementArrangementsInd
Loans Or Loan GuaranteesfalseLoansOrLoanGuaranteesInd
Performance Of Services EtcfalsePerformanceOfServicesEtcInd
Sharing Of Facilities EtcfalseSharingOfFacilitiesEtcInd
Relationships Nonchrtbl EOfalseRelationshipsNonchrtblEOInd

Investments Corp Stock Schedule InvestmentsCorpStockSchedule

Investments Corporate Stock InvestmentsCorporateStockGrp (27 entries)

StockStockNmEOY Book ValueEOYBookValueAmtEOYFMVEOYFMVAmt
ACULON, INC. SERIES B PREFERRED STK$1$1
ALLERGAN PLC$163,580$163,580
ALPHABET INC.$209,280$209,280
AON$177,550$177,550
AT&T$145,800$145,800
BANK OF AMERICA$177,120$177,120
BERSHIRE HATHAWAY$297,330$297,330
CBRE GROUP INC$316,163$316,163
CELGENE CORP$73,052$73,052
CROWN CASTLE INTL CORP NEW$166,515$166,515
EATON CORP$252,832$252,832
GILEAD SCIENCES INC$53,730$53,730
GOLDMAN SACHS$267,498$267,498
GRUPO TELEVISA SA SPONS ADR$113,420$113,420
INTEL CORP$323,120$323,120
JELD-WEN HOLDINGS$192,913$192,913
JP MORGAN CHASE & CO$213,880$213,880
LIBERTY INTERACTIVE CORP QVC GROUP$158,730$158,730
MARSH & MCLENNAN$162,780$162,780
MCDONALD'S CORP$176,423$176,423
METLIFE INC$109,968$109,968
NIKE INC$225,180$225,180
PEMBINA PIPELINE$180,900$180,900
ROBERT HALF INTL INC$222,160$222,160
VALEO SA$167,509$167,509
WELBILT INC.$84,636$84,636
T ROWE PRICE GROUP$220,353$220,353

Other Increases Schedule OtherIncreasesSchedule

Other Increases Detail OtherIncreasesDetail

FieldValueIRS element (for citing)
DescTRANSFER FROM EIN 37-1401906Desc
Amt$5,514,595Amt