JOHN WILLIAM PLANSOEN ETAL TR 27871: Form 990PF, tax year 2018
View the entire original 990 at ProPublica ↗
- Organization
- JOHN WILLIAM PLANSOEN ETAL TR 27871 (EIN 22-6020281)
- Tax period
- 2018-01-01 to 2018-12-31
- Filed
- 2019-04-29
- IRS object ID
- 201921199349100187
- Schema version
- 2018v3.0
- 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
- Form 990-PF
- Accounting Fees Schedule
- Compensation Explanation
- Investments Corp Bonds Schedule
- Investments Corp Stock Schedule
- Investments Govt Obligations Sch
- Legal Fees Schedule
- Other Decreases Schedule
- Other Expenses Schedule
- Other Increases Schedule
- Taxes Schedule
Return header ReturnHeader
| Field | Value | IRS element (for citing) |
|---|---|---|
| Return | 2019-04-29T11:00:14-05:00 | ReturnTs |
| Tax Period End | 2018-12-31 | TaxPeriodEndDt |
| Return Type | 990PF | ReturnTypeCd |
| Tax Period Begin | 2018-01-01 | TaxPeriodBeginDt |
Filer Filer
| Field | Value | IRS element (for citing) |
|---|---|---|
| EIN | 226020281 | EIN |
Business Name BusinessName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | JOHN W PLANSOEN TRUST | BusinessNameLine1Txt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Control | PLAN | BusinessNameControlTxt |
| Phone | 8557392921 | PhoneNum |
US Address USAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 6325 S RAINBOW BLVD STE 300 | AddressLine1Txt |
| City | LAS VEGAS | CityNm |
| State Abbreviation | NV | StateAbbreviationCd |
| ZIP | 89118 | ZIPCd |
Business Officer BusinessOfficerGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Person | - | PersonNm |
| Person Title | CO-TRUSTEE | PersonTitleTxt |
| Phone | 8557392921 | PhoneNum |
| Signature | 2019-04-26 | SignatureDt |
Filing Security Information FilingSecurityInformation
IP Address IPAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| I Pv4 Address | 159.45.71.18 | IPv4AddressTxt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Filing License Type | P | FilingLicenseTypeCd |
| At Submission Creation Device Id | 409D1F3AC03F24F6E2A22DAA496F1D7D5531D93A | AtSubmissionCreationDeviceId |
| At Submission Filing Device Id | FEDD693B2DC88DB60E8225749939C78844CAE381 | AtSubmissionFilingDeviceId |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tax | 2018 | TaxYr |
| Build TS | 2019-02-21 02:37:17Z | BuildTS |
Form 990-PF IRS990PF
| Field | Value | IRS element (for citing) |
|---|---|---|
| Organization4947a1 Trtd PF | Yes (X) | Organization4947a1TrtdPFInd |
| FMV Assets EOY | $4,717,807 | FMVAssetsEOYAmt |
Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses
| Field | Value | IRS element (for citing) |
|---|---|---|
| Schedule B Not Required | Yes (X) | ScheduleBNotRequiredInd |
| Dividends Rev And Expnss | $142,940 | DividendsRevAndExpnssAmt |
| Dividends Net Invst Incm | $142,668 | DividendsNetInvstIncmAmt |
| Net Gain Sale Ast Rev And Expnss | $131,633 | NetGainSaleAstRevAndExpnssAmt |
| Gross Sales Price | $391,630 | GrossSalesPriceAmt |
| Cap Gain Net Incm Net Invst Incm | $131,633 | CapGainNetIncmNetInvstIncmAmt |
| Net ST Capital Gain Adj Net Incm | $0 | NetSTCapitalGainAdjNetIncmAmt |
| Total Rev And Expnss | $274,573 | TotalRevAndExpnssAmt |
| Total Net Invst Incm | $274,301 | TotalNetInvstIncmAmt |
| Comp Ofcr Dir Trst Rev And Expnss | $18,410 | CompOfcrDirTrstRevAndExpnssAmt |
| Comp Ofcr Dir Trst Net Invst Incm | $9,204 | CompOfcrDirTrstNetInvstIncmAmt |
| Comp Ofcr Dir Trst Dsbrs Chrtbl | $9,206 | CompOfcrDirTrstDsbrsChrtblAmt |
| Oth Empl Slrs Wgs Net Invst Incm | $0 | OthEmplSlrsWgsNetInvstIncmAmt |
| Oth Empl Slrs Wgs Adj Net Incm | $0 | OthEmplSlrsWgsAdjNetIncmAmt |
| Oth Empl Slrs Wgs Dsbrs Chrtbl | $0 | OthEmplSlrsWgsDsbrsChrtblAmt |
| Pension Empl Bnft Net Invst Incm | $0 | PensionEmplBnftNetInvstIncmAmt |
| Pension Empl Bnft Adj Net Incm | $0 | PensionEmplBnftAdjNetIncmAmt |
| Legal Fees Rev And Expnss | $152 | LegalFeesRevAndExpnssAmt |
| Legal Fees Net Invst Incm | $114 | LegalFeesNetInvstIncmAmt |
| Legal Fees Adj Net Incm | $0 | LegalFeesAdjNetIncmAmt |
| Legal Fees Dsbrs Chrtbl | $38 | LegalFeesDsbrsChrtblAmt |
| Accounting Fees Rev And Expnss | $1,000 | AccountingFeesRevAndExpnssAmt |
| Accounting Fees Net Invst Incm | $0 | AccountingFeesNetInvstIncmAmt |
| Accounting Fees Adj Net Incm | $0 | AccountingFeesAdjNetIncmAmt |
| Accounting Fees Chrtbl Prps | $1,000 | AccountingFeesChrtblPrpsAmt |
| Other Prof Fees Dsbrs Chrtbl | $0 | OtherProfFeesDsbrsChrtblAmt |
| Interest Dsbrs Chrtbl | $0 | InterestDsbrsChrtblAmt |
| Taxes Rev And Expnss | $9,953 | TaxesRevAndExpnssAmt |
| Taxes Net Invst Incm | $78 | TaxesNetInvstIncmAmt |
| Taxes Dsbrs Chrtbl | $0 | TaxesDsbrsChrtblAmt |
| Deprec And Dpltn Rev And Expnss | $0 | DeprecAndDpltnRevAndExpnssAmt |
| Deprec And Dpltn Net Invst Incm | $0 | DeprecAndDpltnNetInvstIncmAmt |
| Trav Conf Meeting Net Invst Incm | $0 | TravConfMeetingNetInvstIncmAmt |
| Trav Conf Meeting Adj Net Incm | $0 | TravConfMeetingAdjNetIncmAmt |
| Printing And Pub Net Invst Incm | $0 | PrintingAndPubNetInvstIncmAmt |
| Printing And Pub Adj Net Incm | $0 | PrintingAndPubAdjNetIncmAmt |
| Other Expenses Rev And Expnss | $7,380 | OtherExpensesRevAndExpnssAmt |
| Other Expenses Net Invst Incm | $10 | OtherExpensesNetInvstIncmAmt |
| Other Expenses Dsbrs Chrtbl | $7,370 | OtherExpensesDsbrsChrtblAmt |
| Tot Opr Expenses Rev And Expnss | $36,895 | TotOprExpensesRevAndExpnssAmt |
| Tot Opr Expenses Net Invst Incm | $9,406 | TotOprExpensesNetInvstIncmAmt |
| Tot Opr Expenses Adj Net Incm | $0 | TotOprExpensesAdjNetIncmAmt |
| Tot Opr Expenses Dsbrs Chrtbl | $17,614 | TotOprExpensesDsbrsChrtblAmt |
| Contri Paid Rev And Expnss | $200,000 | ContriPaidRevAndExpnssAmt |
| Contri Paid Dsbrs Chrtbl | $200,000 | ContriPaidDsbrsChrtblAmt |
| Total Expenses Rev And Expnss | $236,895 | TotalExpensesRevAndExpnssAmt |
| Total Expenses Net Invst Incm | $9,406 | TotalExpensesNetInvstIncmAmt |
| Total Expenses Adj Net Incm | $0 | TotalExpensesAdjNetIncmAmt |
| Total Expenses Dsbrs Chrtbl | $217,614 | TotalExpensesDsbrsChrtblAmt |
| Excess Revenue Over Expenses | $37,678 | ExcessRevenueOverExpensesAmt |
| Net Investment Income | $264,895 | NetInvestmentIncomeAmt |
| Adjusted Net Income | $0 | AdjustedNetIncomeAmt |
Form990 PF Balance Sheets Form990PFBalanceSheetsGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Sav And Temp Cash Invst BOY | $442,158 | SavAndTempCashInvstBOYAmt |
| Sav And Temp Cash Invst EOY | $296,643 | SavAndTempCashInvstEOYAmt |
| Sav And Temp Cash Invst EOYFMV | $296,643 | SavAndTempCashInvstEOYFMVAmt |
| Acct Rcvbl EOY | $0 | AcctRcvblEOYAmt |
| Acct Rcvbl EOYFMV | $0 | AcctRcvblEOYFMVAmt |
| Other Rcvbl Allwnc Dbtfl Acct | $0 | OtherRcvblAllwncDbtflAcctAmt |
| US Government Obligations BOY | $248,639 | USGovernmentObligationsBOYAmt |
| US Government Obligations EOY | $457,648 | USGovernmentObligationsEOYAmt |
| US Govt Obligations EOYFMV | $454,420 | USGovtObligationsEOYFMVAmt |
| Corporate Stock BOY | $1,165,154 | CorporateStockBOYAmt |
| Corporate Stock EOY | $1,159,040 | CorporateStockEOYAmt |
| Corporate Stock EOYFMV | $2,989,198 | CorporateStockEOYFMVAmt |
| Corporate Bonds BOY | $1,053,046 | CorporateBondsBOYAmt |
| Corporate Bonds EOY | $1,036,869 | CorporateBondsEOYAmt |
| Corporate Bonds EOYFMV | $977,546 | CorporateBondsEOYFMVAmt |
| Other Investments EOYFMV | $0 | OtherInvestmentsEOYFMVAmt |
| Total Assets BOY | $2,908,997 | TotalAssetsBOYAmt |
| Total Assets EOY | $2,950,200 | TotalAssetsEOYAmt |
| Total Assets EOYFMV | $4,717,807 | TotalAssetsEOYFMVAmt |
| Total Liabilities EOY | $0 | TotalLiabilitiesEOYAmt |
| Org Does Not Follow SFAS117 | Yes (X) | OrgDoesNotFollowSFAS117Ind |
| Capital Stock BOY | $2,908,997 | CapitalStockBOYAmt |
| Capital Stock EOY | $2,950,200 | CapitalStockEOYAmt |
| Tot Net Ast Or Fund Balances BOY | $2,908,997 | TotNetAstOrFundBalancesBOYAmt |
| Tot Net Ast Or Fund Balances EOY | $2,950,200 | TotNetAstOrFundBalancesEOYAmt |
| Total Liabilities Net Ast BOY | $2,908,997 | TotalLiabilitiesNetAstBOYAmt |
| Total Liabilities Net Ast EOY | $2,950,200 | TotalLiabilitiesNetAstEOYAmt |
Chg In Net Assets Fund Balances ChgInNetAssetsFundBalancesGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Tot Net Ast Or Fund Balances BOY | $2,908,997 | TotNetAstOrFundBalancesBOYAmt |
| Excess Revenue Over Expenses | $37,678 | ExcessRevenueOverExpensesAmt |
| Other Increases | $5,417 | OtherIncreasesAmt |
| Subtotal | $2,952,092 | SubtotalAmt |
| Other Decreases | $1,892 | OtherDecreasesAmt |
| Tot Net Ast Or Fund Balances EOY | $2,950,200 | TotNetAstOrFundBalancesEOYAmt |
Cap Gains Loss Tx Invst Incm Detail CapGainsLossTxInvstIncmDetail
Cap Gains Loss Tx Invst Incm CapGainsLossTxInvstIncmGrp (10 entries)
| PropertyPropertyDesc | AcquiredAcquiredDt | SoldSoldDt | Gross Sales PriceGrossSalesPriceAmt | Cost Or Other BasisCostOrOtherBasisAmt | Gain Or LossGainOrLossAmt | Gains Minus Excess Or LossesGainsMinusExcessOrLossesAmt | How AcquiredHowAcquiredCd |
|---|---|---|---|---|---|---|---|
| 30000. BERKSHIRE HATHAWAY 5.400% 5/15/18 | 2014-03-03 | 2018-05-15 | $30,000 | $34,730 | -$4,730 | -$4,730 | |
| 25000. GTE CORP 6.840% 4/15/18 | 1998-04-23 | 2018-04-15 | $25,000 | $24,975 | $25 | $25 | |
| 35000. GENERAL ELEC CAP COR 4.650% 10/17/21 | 2014-03-03 | 2018-11-06 | $35,355 | $38,821 | -$3,466 | -$3,466 | |
| 30000. GOLDMAN SACHS GROUP 5.950% 1/18/18 | 2016-04-22 | 2018-01-18 | $30,000 | $32,113 | -$2,113 | -$2,113 | |
| 370. ISHARES RUSSELL MID-CAP ETF | 2011-09-26 | 2018-02-14 | $75,546 | $33,193 | $42,353 | $42,353 | |
| 505. ISHARES RUSSELL 2000 ETF | 2011-09-26 | 2018-02-14 | $75,006 | $32,728 | $42,278 | $42,278 | |
| 15000. KINDER MORGAN ENER 5.950% 2/15/18 | 2014-03-03 | 2018-02-15 | $15,000 | $17,263 | -$2,263 | -$2,263 | |
| 580. PRAXAIR INC COM | 2009-02-26 | 2018-10-31 | $94,801 | $34,998 | $59,803 | $59,803 | |
| 10000. TIME WARNER INC 4.875% 3/15/20 | 2014-03-03 | 2018-09-27 | $10,283 | $11,176 | -$893 | -$893 | |
| CAPITAL GAIN DIVIDENDS | $639 | P |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Capital Gain Net Income | $131,633 | CapitalGainNetIncomeAmt |
Qlfy Und Sect4940e Reduced Tax QlfyUndSect4940eReducedTaxGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Liable Section4942 Tax | false | LiableSection4942TaxInd |
| Adjusted Qlfy Distri Yr1 | $216,091 | AdjustedQlfyDistriYr1Amt |
| Net Vl Noncharitable Assets Yr1 | $4,902,535 | NetVlNoncharitableAssetsYr1Amt |
| Distribution Yr1 | 0.044077 | DistributionYr1Rt |
| Adjusted Qlfy Distri Yr2 | $211,556 | AdjustedQlfyDistriYr2Amt |
| Net Vl Noncharitable Assets Yr2 | $4,693,740 | NetVlNoncharitableAssetsYr2Amt |
| Distribution Yr2 | 0.045072 | DistributionYr2Rt |
| Adjusted Qlfy Distri Yr3 | $253,648 | AdjustedQlfyDistriYr3Amt |
| Net Vl Noncharitable Assets Yr3 | $4,670,446 | NetVlNoncharitableAssetsYr3Amt |
| Distribution Yr3 | 0.054309 | DistributionYr3Rt |
| Adjusted Qlfy Distri Yr4 | $234,077 | AdjustedQlfyDistriYr4Amt |
| Net Vl Noncharitable Assets Yr4 | $4,721,942 | NetVlNoncharitableAssetsYr4Amt |
| Distribution Yr4 | 0.049572 | DistributionYr4Rt |
| Adjusted Qlfy Distri Yr5 | $225,319 | AdjustedQlfyDistriYr5Amt |
| Net Vl Noncharitable Assets Yr5 | $4,439,625 | NetVlNoncharitableAssetsYr5Amt |
| Distribution Yr5 | 0.050752 | DistributionYr5Rt |
| Total Distribution | 0.243782 | TotalDistributionRt |
| Average Distribution | 0.048756 | AverageDistributionRt |
| Net Vl Noncharitable Assets | $5,018,665 | NetVlNoncharitableAssetsAmt |
| Adj Net Vl Noncharitable Assets | $244,690 | AdjNetVlNoncharitableAssetsAmt |
| Net Investment Income Pct | $2,649 | NetInvestmentIncomePctAmt |
| Adj Nonchrtbl Net Invst Incm Pct | $247,339 | AdjNonchrtblNetInvstIncmPctAmt |
| Qualifying Distributions | $217,614 | QualifyingDistributionsAmt |
Excise Tax Based On Invst Incm ExciseTaxBasedOnInvstIncmGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Investment Income Excise Tax | $5,298 | InvestmentIncomeExciseTaxAmt |
| Tax Under Section511 | $0 | TaxUnderSection511Amt |
| Subtotal | $5,298 | SubtotalAmt |
| Subtitle A Tax | $0 | SubtitleATaxAmt |
| Tax Based On Investment Income | $5,298 | TaxBasedOnInvestmentIncomeAmt |
| Estimated Plus Ovpmt Incm Tx | $7,492 | EstimatedPlusOvpmtIncmTxAmt |
| Extsn Request Income Tax Paid | $0 | ExtsnRequestIncomeTaxPaidAmt |
| Total Payments And Credits | $7,492 | TotalPaymentsAndCreditsAmt |
| Es Penalty | $0 | EsPenaltyAmt |
| Overpayment | $2,194 | OverpaymentAmt |
| Applied To ES Tax | $2,194 | AppliedToESTaxAmt |
| Refund | $0 | RefundAmt |
Statements Regarding Acty StatementsRegardingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Legislative Political Acty | false | LegislativePoliticalActyInd |
| More Than100 Spent | false | MoreThan100SpentInd |
| Form1120 POL Filed | false | Form1120POLFiledInd |
| Activities Not Previously Rpt | false | ActivitiesNotPreviouslyRptInd |
| Changes To Articles Or Bylaws | false | ChangesToArticlesOrBylawsInd |
| Unrelated Bus Incm Over Limit | false | UnrelatedBusIncmOverLimitInd |
| Organization Dissolved Etc | false | OrganizationDissolvedEtcInd |
| Section508e Rqr Satisfied | Yes (true) | Section508eRqrSatisfiedInd |
| At Least5000 In Assets | Yes (true) | AtLeast5000InAssetsInd |
| Org Report Or Register State | NJ | OrgReportOrRegisterStateCd |
| Form990 PF Filed With Atty Gen | Yes (true) | Form990PFFiledWithAttyGenInd |
| Private Operating Foundation | false | PrivateOperatingFoundationInd |
| New Substantial Contributors | false | NewSubstantialContributorsInd |
| Own Controlled Entity | false | OwnControlledEntityInd |
| Donor Advised Fund | false | DonorAdvisedFundInd |
| Comply With Public Insp Rqr | Yes (true) | ComplyWithPublicInspRqrInd |
Persons With Books Name PersonsWithBooksName
| Field | Value | IRS element (for citing) |
|---|---|---|
| Business Name Line1 | WELLS FARGO BANK NA | BusinessNameLine1Txt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Phone | 8557392921 | PhoneNum |
Location Of Books US Address LocationOfBooksUSAddress
| Field | Value | IRS element (for citing) |
|---|---|---|
| Address Line1 | 100 N MAIN ST FL 6 D4001-065 | AddressLine1Txt |
| City | WINSTONSALEM | CityNm |
| State Abbreviation | NC | StateAbbreviationCd |
| ZIP | 271013818 | ZIPCd |
| Field | Value | IRS element (for citing) |
|---|---|---|
| NECT Filing In Lieu OF Form1041 | Yes (X) | NECTFilingInLieuOFForm1041Ind |
| Foreign Accounts Question | false | ForeignAccountsQuestionInd |
Statements Regarding Acty4720 StatementsRegardingActy4720Grp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Sale Or Exch Disqualified Prsn | false | SaleOrExchDisqualifiedPrsnInd |
| Brrw Or Lend Disqualified Prsn | false | BrrwOrLendDisqualifiedPrsnInd |
| Furn Goods Disqualified Prsn | Yes (true) | FurnGoodsDisqualifiedPrsnInd |
| Pay Comp Disqualified Prsn | Yes (true) | PayCompDisqualifiedPrsnInd |
| Transfer Ast Disqualified Prsn | false | TransferAstDisqualifiedPrsnInd |
| Payment To Government Official | false | PaymentToGovernmentOfficialInd |
| Acts Fail To Qlfy As Exceptions | false | ActsFailToQlfyAsExceptionsInd |
| Uncorrected Prior Acts | false | UncorrectedPriorActsInd |
| Undistributed Income PY | false | UndistributedIncomePYInd |
| Business Holdings | false | BusinessHoldingsInd |
| Jeopardy Investments | false | JeopardyInvestmentsInd |
| Uncorrected PY Jeopardy Invst | false | UncorrectedPYJeopardyInvstInd |
| Influence Legislation | false | InfluenceLegislationInd |
| Influence Election | false | InfluenceElectionInd |
| Grants To Individuals | false | GrantsToIndividualsInd |
| Grants To Organizations | false | GrantsToOrganizationsInd |
| Noncharitable Purpose | false | NoncharitablePurposeInd |
| Rcv Fnds To Pay Prsnl Bnft Cntrct | false | RcvFndsToPayPrsnlBnftCntrctInd |
| Pay Premiums Prsnl Bnft Cntrct | false | PayPremiumsPrsnlBnftCntrctInd |
| Prohibited Tax Shelter Trans | false | ProhibitedTaxShelterTransInd |
| Subj To Tax Rmnrtn Ex Prcht Pymt | false | SubjToTaxRmnrtnExPrchtPymtInd |
Officer Dir Trst Key Empl Info OfficerDirTrstKeyEmplInfoGrp
Officer Dir Trst Key Empl OfficerDirTrstKeyEmplGrp (2 entries)
| Address Line1USAddress/AddressLine1Txt | CityUSAddress/CityNm | State AbbreviationUSAddress/StateAbbreviationCd | ZIPUSAddress/ZIPCd | TitleTitleTxt | Average Hrs Per Wk Devoted To PosAverageHrsPerWkDevotedToPosRt | CompensationCompensationAmt |
|---|---|---|---|---|---|---|
| WELLS FARGO | ||||||
| 1525 WEST WT HARRIS BLVD | CHARLOTTE | NC | 282881114 | CO-TRUSTEE | 1 | $12,272 |
| HELEN POST | ||||||
| 15 CACHE CAY DRIVE | VERO BEACH | FL | 32963 | CO-TRUSTEE | 1 | $6,138 |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Comp Of Hghst Pd Empl Or NONE | NONE | CompOfHghstPdEmplOrNONETxt |
| Other Employee Paid Over50k | 0 | OtherEmployeePaidOver50kCnt |
| Comp Of Hghst Pd Cntrct Or NONE | NONE | CompOfHghstPdCntrctOrNONETxt |
| Contractor Paid Over50k | 0 | ContractorPaidOver50kCnt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Summary Of Direct Chrtbl Acty | SummaryOfDirectChrtblActyGrp | |
| Sum Of Program Related Invst | SumOfProgramRelatedInvstGrp |
Minimum Investment Return MinimumInvestmentReturnGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Average Monthly FMV Of Sec | $4,688,558 | AverageMonthlyFMVOfSecAmt |
| Average Monthly Cash Balances | $406,533 | AverageMonthlyCashBalancesAmt |
| FMV All Other Noncharitable Ast | $0 | FMVAllOtherNoncharitableAstAmt |
| Total FMV Of Unused Assets | $5,095,091 | TotalFMVOfUnusedAssetsAmt |
| Reduction Claimed | $0 | ReductionClaimedAmt |
| Acquisition Indebtedness | $0 | AcquisitionIndebtednessAmt |
| Adjusted Total FMV Of Unused Ast | $5,095,091 | AdjustedTotalFMVOfUnusedAstAmt |
| Cash Deemed Charitable | $76,426 | CashDeemedCharitableAmt |
| Net Vl Noncharitable Assets | $5,018,665 | NetVlNoncharitableAssetsAmt |
| Minimum Investment Return | $250,933 | MinimumInvestmentReturnAmt |
Distributable Amount DistributableAmountGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Minimum Investment Return | $250,933 | MinimumInvestmentReturnAmt |
| Tax Based On Investment Income | $5,298 | TaxBasedOnInvestmentIncomeAmt |
| Total Tax | $5,298 | TotalTaxAmt |
| Distributable Before Adj | $245,635 | DistributableBeforeAdjAmt |
| Recoveries Qualfied Distri | $0 | RecoveriesQualfiedDistriAmt |
| Distributable Before Ded | $245,635 | DistributableBeforeDedAmt |
| Deduction From Distributable | $0 | DeductionFromDistributableAmt |
| Distributable As Adjusted | $245,635 | DistributableAsAdjustedAmt |
Qualifying Distri Part XII QualifyingDistriPartXIIGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Expenses And Contributions | $217,614 | ExpensesAndContributionsAmt |
| Program Related Invst Total | $0 | ProgramRelatedInvstTotalAmt |
| Charitable Assets Acquis Paid | $0 | CharitableAssetsAcquisPaidAmt |
| Set Aside Suitability Test | $0 | SetAsideSuitabilityTestAmt |
| Set Aside Cash Distri Test | $0 | SetAsideCashDistriTestAmt |
| Qualifying Distributions | $217,614 | QualifyingDistributionsAmt |
| Pct Sect4940e Org Net Invst Incm | $0 | PctSect4940eOrgNetInvstIncmAmt |
| Adjusted Qualifying Distri | $217,614 | AdjustedQualifyingDistriAmt |
Undistributed Income UndistributedIncomeGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Distributable As Adjusted | $245,635 | DistributableAsAdjustedAmt |
| Undistributed Income PY | $27,546 | UndistributedIncomePYAmt |
| Total For Prior Years | $0 | TotalForPriorYearsAmt |
| Excess Distribution Cyov Yr5 | $0 | ExcessDistributionCyovYr5Amt |
| Excess Distribution Cyov Yr4 | $0 | ExcessDistributionCyovYr4Amt |
| Excess Distribution Cyov Yr3 | $0 | ExcessDistributionCyovYr3Amt |
| Excess Distribution Cyov Yr2 | $0 | ExcessDistributionCyovYr2Amt |
| Excess Distribution Cyov Yr1 | $0 | ExcessDistributionCyovYr1Amt |
| Total Excess Distribution Cyov | $0 | TotalExcessDistributionCyovAmt |
| Qualifying Distributions | $217,614 | QualifyingDistributionsAmt |
| Applied To Year1 | $27,546 | AppliedToYear1Amt |
| Applied To Prior Years | $0 | AppliedToPriorYearsAmt |
| Treated As Distri From Corpus | $0 | TreatedAsDistriFromCorpusAmt |
| Applied To Current Year | $190,068 | AppliedToCurrentYearAmt |
| Remaining Distri From Corpus | $0 | RemainingDistriFromCorpusAmt |
| Excess Distri Cyov App CY Corpus | $0 | ExcessDistriCyovAppCYCorpusAmt |
| Excess Distribution Cyov App CY | $0 | ExcessDistributionCyovAppCYAmt |
| Total Corpus | $0 | TotalCorpusAmt |
| Prior Year Undistributed Incm | $0 | PriorYearUndistributedIncmAmt |
| Prior Year Deficiency Or Tax | $0 | PriorYearDeficiencyOrTaxAmt |
| Taxable1 | $0 | Taxable1Amt |
| Taxable2 | $0 | Taxable2Amt |
| Undistributed Income CY | $55,567 | UndistributedIncomeCYAmt |
| Corpus Distri170b1 E Or4942g3 | $0 | CorpusDistri170b1EOr4942g3Amt |
| Excess Distri Cyov From Yr5 | $0 | ExcessDistriCyovFromYr5Amt |
| Excess Distri Cyov To Next Yr | $0 | ExcessDistriCyovToNextYrAmt |
| Excess From Year4 | $0 | ExcessFromYear4Amt |
| Excess From Year3 | $0 | ExcessFromYear3Amt |
| Excess From Year2 | $0 | ExcessFromYear2Amt |
| Excess From Year1 | $0 | ExcessFromYear1Amt |
| Excess From Current Year | $0 | ExcessFromCurrentYearAmt |
Supplementary Information SupplementaryInformationGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Only Contri To Preselected | Yes (X) | OnlyContriToPreselectedInd |
Grant Or Contribution Pd Dur Yr GrantOrContributionPdDurYrGrp (6 entries)
| Address Line1RecipientUSAddress/AddressLine1Txt | CityRecipientUSAddress/CityNm | State AbbreviationRecipientUSAddress/StateAbbreviationCd | ZIPRecipientUSAddress/ZIPCd | Recipient RelationshipRecipientRelationshipTxt | Recipient Foundation StatusRecipientFoundationStatusTxt | Grant Or Contribution PurposeGrantOrContributionPurposeTxt | AmtAmt | Business Name Line2RecipientBusinessName/BusinessNameLine2Txt |
|---|---|---|---|---|---|---|---|---|
| GORDON COLLEGE | ||||||||
| 255 GRAPEVINE RD | WENHAM | MA | 01984 | NONE | PC | FRIENDS OF MUSIC | $30,000 | |
| GORDON-CONWELL THEOLOGICAL SEMINARY | ||||||||
| 130 ESSEX STREET | SOUTH HAMILTON | MA | 01982 | NONE | PC | SCHOLARSHIP SUPPORT | $35,000 | |
| FIRST PRESBYTERIAN CHURCH AT | ||||||||
| 326 BLOOMFIELD AVE | CALDWELL | NJ | 07006 | NONE | PC | PROGRAMMING SUPPORT | $55,000 | CALDWELL |
| CROYA FOUNDATION INC | ||||||||
| PO BOX 582 | LAKE FOREST | IL | 60045 | NONE | PC | PROGRAMMING SUPPORT | $30,000 | |
| WILLOW CREEK COMMUNITY CHURCH INC | ||||||||
| 2200 SHERMER ROAD | GLENVIEW | IL | 60026 | NONE | PC | PROGRAMMING SUPPORT | $10,000 | |
| ELAWA FARM FOUNDATION | ||||||||
| 1401 MIDDLEFORK DR | LAKE FOREST | IL | 60045 | NONE | PC | PROGRAMMING SUPPORT | $40,000 | |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Grant Or Contri Pd Dur Yr | $200,000 | TotalGrantOrContriPdDurYrAmt |
Analysis Income Producing Acty AnalysisIncomeProducingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Fees Contracts From Govt Ag | FeesContractsFromGovtAgGrp | |
| Membership Dues And Assmnt | MembershipDuesAndAssmntGrp | |
| Int On Sav And Temp Cash Invst | IntOnSavAndTempCashInvstGrp |
Div And Int From Sec Part VII DivAndIntFromSecPartVIIGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 14 | ExclusionCd |
| Exclusion | $142,940 | ExclusionAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Net Rntl Incm Re Debt Fincd Prop | NetRntlIncmReDebtFincdPropGrp | |
| Net Rntl Incm Re Not Debt Fincd Prop | NetRntlIncmReNotDebtFincdProp | |
| Net Rental Income Personal Prop | NetRentalIncomePersonalPropGrp | |
| Other Investment Incm Part VII | OtherInvestmentIncmPartVIIGrp |
Gain Sales Ast Oth Than Invntry GainSalesAstOthThanInvntryGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | 18 | ExclusionCd |
| Exclusion | $131,633 | ExclusionAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Net Income Loss From Special Evt | NetIncomeLossFromSpecialEvtGrp | |
| Gross Profit Loss Sls Of Invntry | GrossProfitLossSlsOfInvntryGrp |
Subtotals Incm Producing Acty SubtotalsIncmProducingActyGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Exclusion | $274,573 | ExclusionAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Total Income Producing Acty | $274,573 | TotalIncomeProducingActyAmt |
| Field | Value | IRS element (for citing) |
|---|---|---|
| Rln Of Acty To Accom Of Exmpt Prps | RlnOfActyToAccomOfExmptPrpsGrp |
Trnsfr Trans Rln Nonchrtbl EO TrnsfrTransRlnNonchrtblEOGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Trnsfr Of Cash To Nonchrtbl EO | false | TrnsfrOfCashToNonchrtblEOInd |
| Trnsfr Other Asset Nonchrtbl EO | false | TrnsfrOtherAssetNonchrtblEOInd |
| Sales Or Exchanges Of Assets | false | SalesOrExchangesOfAssetsInd |
| Purchase Of Assets Nonchrtbl EO | false | PurchaseOfAssetsNonchrtblEOInd |
| Rental Of Facilities Oth Assets | false | RentalOfFacilitiesOthAssetsInd |
| Reimbursement Arrangements | false | ReimbursementArrangementsInd |
| Loans Or Loan Guarantees | false | LoansOrLoanGuaranteesInd |
| Performance Of Services Etc | false | PerformanceOfServicesEtcInd |
| Sharing Of Facilities Etc | false | SharingOfFacilitiesEtcInd |
| Relationships Nonchrtbl EO | false | RelationshipsNonchrtblEOInd |
Accounting Fees Schedule AccountingFeesSchedule
Accounting Fees Detail AccountingFeesDetail
| Field | Value | IRS element (for citing) |
|---|---|---|
| Category | TAX PREPARATION FEE (NON-ALLOC | CategoryTxt |
| Amt | $1,000 | Amt |
| Disbursements Charitable Prps | $1,000 | DisbursementsCharitablePrpsAmt |
Compensation Explanation CompensationExplanation
Compensation Explanation CompensationExplanationGrp (2 entries)
| Short ExplanationShortExplanationTxt |
|---|
| WELLS FARGO |
| TRUST ADMIN FEE SEE ATTACHED FOOTNOTE |
| HELEN POST |
| TRUST ADMIN FEE |
Investments Corp Bonds Schedule InvestmentsCorpBondsSchedule
Investments Corporate Bonds InvestmentsCorporateBondsGrp (32 entries)
| BondBondNm | EOY Book ValueEOYBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|
| 362320AZ6 GTE CORP | ||
| 031162AZ3 AMGEN INC | $29,282 | $25,050 |
| 06051GEC9 BANK OF AMERICA CORP | $34,681 | $31,013 |
| 084664BE0 BERKSHIRE HATHAWAY | ||
| 166751AJ6 CHEVRON CORP | $34,478 | $30,094 |
| 260543CF8 DOW CHEMICAL CO/THE | $15,866 | $15,264 |
| 277911491 EATON VANCE FLOATING | $86,893 | $82,451 |
| 36962G5J9 GENERAL ELEC CAP COR | ||
| 406216BD2 HALLIBURTON COMPANY | $30,360 | $29,779 |
| 494550AY2 KINDER MORGAN ENER | ||
| 693390841 PIMCO HIGH YIELD FD- | $129,858 | $110,741 |
| 713448BN7 PEPSICO INC | $33,554 | $30,545 |
| 742718DY2 PROCTER & GAMBLE CO/ | $33,869 | $34,456 |
| 887317AF2 TIME WARNER INC | ||
| 931142CU5 WAL-MART STORES INC | $32,172 | $30,302 |
| 94973VAS6 WELLPOINT INC | $10,836 | $10,176 |
| 037833AK6 APPLE INC | $28,604 | $29,008 |
| 46625HHU7 JPMORGAN CHASE & CO | $21,429 | $20,360 |
| 913017BV0 UNITED TECHNOLOGIES | $20,140 | $19,585 |
| 92343VBR4 VERIZON COMMUNICATIO | $10,918 | $10,644 |
| 38141GFG4 GOLDMAN SACHS GROUP | ||
| 437076AW2 HOME DEPOT INC | $33,188 | $30,896 |
| 464288588 ISHARES MBS ETF | $75,748 | $73,255 |
| 59156RBH0 METLIFE INC | $30,142 | $30,207 |
| 66989HAG3 NOVARTIS CAPITAL COR | $31,913 | $30,171 |
| 256210105 DODGE & COX INCOME F | $155,000 | $148,719 |
| 922031737 VANGUARD INFLAT-PROT | $45,000 | $42,549 |
| 38148LAE6 GOLDMAN SACHS GROUP | $19,998 | $19,135 |
| 606822BA1 MITSUBISHI UFJ FIN | $24,845 | $25,115 |
| 61746BEA0 MORGAN STANLEY | $19,671 | $19,576 |
| 86562MAQ3 SUMITOMO MITSUI FINL | $24,142 | $24,360 |
| 961214DW0 WESTPAC BANKING CORP | $24,282 | $24,095 |
Investments Corp Stock Schedule InvestmentsCorpStockSchedule
Investments Corporate Stock InvestmentsCorporateStockGrp (43 entries)
| StockStockNm | EOY Book ValueEOYBookValueAmt | EOYFMVEOYFMVAmt |
|---|---|---|
| 580135101 MCDONALDS CORP | $31,419 | $79,907 |
| 778296103 ROSS STORES INC | $16,729 | $143,104 |
| 194162103 COLGATE PALMOLIVE CO | $25,271 | $50,592 |
| 370334104 GENERAL MILLS INC | $28,398 | $31,152 |
| 30231G102 EXXON MOBIL CORPORAT | $5,005 | $165,020 |
| 001055102 AFLAC INC | $33,452 | $61,506 |
| 46625H100 JPMORGAN CHASE & CO | $31,410 | $129,835 |
| 693475105 PNC FINANCIAL SERVIC | $29,794 | $58,455 |
| 110122108 BRISTOL MYERS SQUIBB | $30,045 | $77,970 |
| 478160104 JOHNSON & JOHNSON | $32,154 | $77,430 |
| 655844108 NORFOLK SOUTHERN COR | $25,319 | $115,894 |
| 913017109 UNITED TECHNOLOGIES | $29,294 | $74,536 |
| 88579Y101 3M CO | $32,534 | $71,453 |
| 458140100 INTEL CORP | $19,433 | $69,222 |
| 459200101 INTERNATIONAL BUSINE | $13,696 | $90,936 |
| 74005P104 PRAXAIR INC COM | ||
| 00206R102 AT & T INC | $10,912 | $108,110 |
| 92343V104 VERIZON COMMUNICATIO | $23,850 | $161,689 |
| 65339F101 NEXTERA ENERGY INC | $2,891 | $83,434 |
| 037833100 APPLE INC | $78,390 | $161,684 |
| 14040H105 CAPITAL ONE FINANCIA | $43,001 | $75,590 |
| 369604103 GENERAL ELECTRIC CO | $19,258 | $9,198 |
| 437076102 HOME DEPOT INC | $41,481 | $206,184 |
| 464287499 ISHARES RUSSELL MID- | $34,987 | $72,509 |
| 464287655 ISHARES RUSSELL 2000 | $32,080 | $66,281 |
| 58155Q103 MCKESSON CORP | $41,971 | $60,759 |
| 87612E106 TARGET CORP | $31,296 | $39,654 |
| 91324P102 UNITEDHEALTH GROUP I | $44,016 | $224,208 |
| H1467J104 CHUBB LTD | $91,080 | $150,366 |
| 02079K107 ALPHABET INC CL C | $15,491 | $15,534 |
| 03076C106 AMERIPRISE FINL INC | $12,764 | $8,350 |
| 126650100 CVS HEALTH CORPORATI | $29,006 | $26,536 |
| 17275R102 CISCO SYSTEMS INC | $27,555 | $32,498 |
| 172967424 CITIGROUP INC. | $13,412 | $9,631 |
| 192446102 COGNIZANT TECH SOLUT | $11,515 | $10,157 |
| 25243Q205 DIAGEO PLC - ADR | $11,033 | $11,344 |
| 375558103 GILEAD SCIENCES INC | $10,861 | $9,383 |
| 532457108 ELI LILLY & CO COM | $10,045 | $13,886 |
| 594918104 MICROSOFT CORP | $15,076 | $18,283 |
| 654106103 NIKE INC CL B | $5,924 | $7,414 |
| 771195104 ROCHE HOLDINGS LTD - | $6,366 | $6,371 |
| H84989104 TE CONNECTIVITY LTD | $16,022 | $12,630 |
| G5494J103 LINDE PLC | $94,804 | $90,503 |
Investments Govt Obligations Sch InvestmentsGovtObligationsSch
| Field | Value | IRS element (for citing) |
|---|---|---|
| US Govt Obligations Book Vl EOY | $457,648 | USGovtObligationsBookVlEOYAmt |
| US Govt Obligations EOYFMV | $454,420 | USGovtObligationsEOYFMVAmt |
Legal Fees Schedule LegalFeesSchedule
Legal Fees LegalFeesGrp
| Field | Value | IRS element (for citing) |
|---|---|---|
| Category | ARCHER & GREINER - LEGAL SVC | CategoryTxt |
| Legal Fees | $152 | LegalFeesAmt |
| Net Investment Income | $114 | NetInvestmentIncomeAmt |
| Disbursements Charitable Prps | $38 | DisbursementsCharitablePrpsAmt |
Other Decreases Schedule OtherDecreasesSchedule
Other Decreases Detail OtherDecreasesDetail (2 entries)
| DescDesc | AmtAmt |
|---|---|
| MUTUAL FUND POSTING DATE AFTER TYE | $1,379 |
| ACCD INT POSTING CURR YR EFF NEXT YR | $513 |
Other Expenses Schedule OtherExpensesSchedule
Other Expenses Schedule OtherExpensesScheduleGrp (2 entries)
| DescDesc | Revenue And Expenses Per BooksRevenueAndExpensesPerBooksAmt | Net Investment IncomeNetInvestmentIncomeAmt | Disbursements Charitable PrpsDisbursementsCharitablePrpsAmt |
|---|---|---|---|
| GRANT CONSULTANT FEE | $7,370 | $0 | $7,370 |
| ADR FEES | $10 | $10 | $0 |
Other Increases Schedule OtherIncreasesSchedule
Other Increases Detail OtherIncreasesDetail (3 entries)
| DescDesc | AmtAmt |
|---|---|
| MUTUAL FUND TAX EFFECTIVE DATE BEFORE TYE | $1,193 |
| ROUNDING | $2 |
| ROC ADJUSTMENT | $4,222 |
Taxes Schedule TaxesSchedule
Taxes Detail TaxesDetail (3 entries)
| CategoryCategoryTxt | AmtAmt | Net Investment IncomeNetInvestmentIncomeAmt | Disbursements Charitable PrpsDisbursementsCharitablePrpsAmt |
|---|---|---|---|
| FOREIGN TAXES | $78 | $78 | $0 |
| FEDERAL TAX PAYMENT - PRIOR YE | $2,383 | $0 | $0 |
| FEDERAL ESTIMATES - PRINCIPAL | $7,492 | $0 | $0 |
Comments