Civic Intelligence

Andrew Squire Testamentary Trust 20-0940460

990 • Fiscal year 2020 • EIN 34-6506892

Jan 01, 2020 to Dec 31, 2020 • Filed on May 07, 2021

Organization ProfileN/A
4900 Tiedeman Road Oh-01-49-0150Brooklyn, OH 44144

(216) 689-0969

Siviq Scores

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

Liabilities / Assets

3rd percentile

0.00x

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

2020 filings • 501(c)3 • $50M-$100M nonprofits • Source year 2020

Liabilities / Revenue

3rd percentile

0.00x

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

2020 filings • 501(c)3 • $50M-$100M nonprofits • Source year 2020

Net Margin

7th percentile

-35%

Higher net margin than 7% of similar nonprofits.

2020 filings • 501(c)3 • $50M-$100M nonprofits • Source year 2020

Top Officer Pay

44th percentile

$312,536

Higher top officer pay than 44% of similar nonprofits.

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

2020 filings • 501(c)3 • $50M-$100M nonprofits • Source year 2020

Asset Growth

20th percentile

-1.7%

Faster asset growth than 20% of similar nonprofits.

2020 filings • 501(c)3 • $50M-$100M nonprofits • Annualized from 2019 to 2020

Revenue Growth

5th percentile

-51%

Faster revenue growth than 5% of similar nonprofits.

2020 filings • 501(c)3 • $50M-$100M nonprofits • Annualized from 2019 to 2020

Balance Sheet
Liabilities / Assets3rd percentile

Assets

Down

$55,206,125

Down $966,313 (-1.7%) from 2019

Net Assets

Down

$55,206,125

Down $966,313 (-1.7%) from 2019

Liabilities

Flat

$0

Flat from 2019

Revenue And Expenses
Liabilities / Revenue3rd percentileNet Margin7th percentile

Revenue

Down

$2,759,650

Down $2,927,804 (-51%) from 2019

Expenses

Down

$3,725,963

Down $84,836 (-2.2%) from 2019

Net Income

Down

-$966,313

Down $2,842,968 (-151%) from 2019

Historical Trend

Balance Sheet Trend

Asset Growth20th percentile

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

$60M$40M$20M$0Assets 2019: $56,172,438Liabilities 2019: $0Net Assets 2019: $56,172,4382019Assets 2020: $55,206,125Liabilities 2020: $0Net Assets 2020: $55,206,1252020Assets 2021: $54,339,048Liabilities 2021: $0Net Assets 2021: $54,339,0482021Assets 2022: $52,615,783Liabilities 2022: $0Net Assets 2022: $52,615,7832022Assets 2023: $51,023,028Liabilities 2023: $0Net Assets 2023: $51,023,0282023Assets 2024: $52,123,464Liabilities 2024: $0Net Assets 2024: $52,123,4642024

Highlighted filing

2020

Assets$55,206,125
Liabilities$0
Net Assets$55,206,125
Open 2020 Filing

Operations Trend

Revenue Growth5th percentile

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

$6.0M$4.0M$2.0M$0-$2.0M-$4.0MRevenue 2019: $5,687,454Expenses 2019: $3,810,799Net Income 2019: $1,876,6552019Revenue 2020: $2,759,650Expenses 2020: $3,725,963Net Income 2020: -$966,3132020Revenue 2021: $3,104,740Expenses 2021: $3,679,075Net Income 2021: -$574,3352021Revenue 2022: $2,294,557Expenses 2022: $4,310,563Net Income 2022: -$2,016,0062022Revenue 2023: $2,408,953Expenses 2023: $4,001,708Net Income 2023: -$1,592,7552023Revenue 2024: $4,991,760Expenses 2024: $3,891,324Net Income 2024: $1,100,4362024

Highlighted filing

2020

Revenue$2,759,650
Expenses$3,725,963
Net Income-$966,313
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
May 7, 2021
Return Version
2020v4.0
Gross Receipts
$5,532,034
Mission and Program Overview

Mission

Under the terms of the will and codicils of andrew squire who died january 5, 1934, the trustees are directed to make grants to case western reserve university. Grants are to be used in preserving ,maintaining and operating squire farm, one of the properties and educational functions of the university and to the extent grants are not needed for such purpose, then to be use by the university for the benefit of flora stone mather college of said university.

Balance Sheet Detail
LineBeginningEndChange
Assets
Cap Stk Tr Prin Current Funds$56,172,438--
Rtn Earn Endowment Incm Other Fnds-$55,206,125-
Investments Other Securities$56,172,437$55,206,124▼ $966,313
Total Assets$56,172,438$55,206,125▼ $966,313
Other Assets Total$1$1→ $0
Liabilities
Total Liabilities$0$0→ $0
Net Assets / Fund Balance
Total Net Assets Fund Balance$56,172,438$55,206,125▼ $966,313
Total Liabilities and Net Assets / Fund Balance$56,172,438$55,206,125▼ $966,313

Asset Categories

AssetBook ValueDepreciationBasis
Other Assets Org$1--
Other Securities$54,773,024--
Compensation and Service Providers
Top Officer Pay44th percentile

Employees

NameTitleBaseTotal
-Co-trustee$312,536$312,536

Board Members and Trustees

NameTitle
Allen H FordCo-trustee
David HuntCo-trustee
Revenue and Support

Revenue Composition

Contributions and Grants
$0
Program Service Revenue
$0
Investment Income
$2,739,450
Other Revenue
$20,200
Change in Net Assets
$-966,313
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Grants and Similar Amounts Paid$3,394,972
Salaries, Compensation, and Employee Benefits$312,536
Other Expenses$18,455
Professional Fundraising Fees$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Grants to Domestic Orgs$3,394,972--$3,394,972
Current Officers, Directors, Trustees, and Key Employees-$312,536-$312,536
All Other Expenses-$16,355-$16,355
Fees for Services Accounting-$2,100-$2,100
Total Functional Expenses$3,394,972$330,991$0$3,725,963
International Activity

Grant and Assistance Recipients

RecipientLocationCategoryPurposeAmount
Case Western Reserve UniversityCleveland, OH170(b)(1)(A)(iii)Benefit of Squire Farm and Mather College$3,393,972
Fundraising, Events, and Gaming
Fundraising activities
No
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Professional Fundraising Fees$0
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Business relationship with 35% controlled entity
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
No
Other officer compensation reviewed
No
Conflict-of-interest policy
No
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Part VI, Line 12A

“No conflict of interest policy exists for the trust. Keybank n.a. Has a corporate conflict of interest policy.”

Part VI, Line 14

“The trust has no written document retention or destruction policy. Keybank n a has a corporate document retention and destruction policy.”

Part VI, Line 15 A and B

“Keybank is co-trustee, is compensated as such, and makes all decisions with respect to the operation and administration of thetrust.”

EXPLANATION FOR FORM 990, PAGE 6, PART VI, LINE 1A

“KEYBANK IS CO-TRUSTEE.”

Form 990, Page 6, Part VI, Line 11-description of Process for Review

“All returns are thoroughly prepared and reviewed by our internal professional tax department.”

Form 990, Page 6, Part VI, Line 19

“Documents are available upon request by mail or by phone within two weeks of receipt of the request.”

Filing and Contact Details

Filer

Filer Name
Andrew Squire Testamentary Trust
EIN
34-6506892
Phone
2166890969
Address
4900 TIEDEMAN ROAD OH-01-49-0150, BROOKLYN, OH 44144

Signing Officer

Name
Keybank Byp S Chmura
Title
Vice President
Phone
2166890969
Signed
2021-05-07
Discuss with paid preparer
Yes

Organization Details

Formed
1934
Legal Domicile
Oh
Voting Board Members
0
Independent Board Members
0
Employees
0

Preparer

Firm
Pricewaterhousecoopers Llp
Address
1850 N CENTRAL AVE STE 700, PHOENIX, AZ 85004
Preparer
Jeffrey E Kuhlin
Phone
4123556000
Raw XML Appendix393 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
IRS990/AccountantCompileOrReviewInd0false
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0UNDER THE TERMS OF THE WILL AND CODICILS OF ANDREW SQUIRE WHO DIED JANUARY 5, 1934, THE TRUSTEES ARE DIRECTED TO MAKE GRANTS TO CASE WESTERN RESERVE UNIVERSITY. GRANTS ARE TO BE USED IN PRESERVING ,MAINTAINING AND OPERATING SQUIRE FARM, ONE OF THE PROPERTIES AND EDUCATIONAL FUNCTIONS OF THE UNIVERSITY AND TO THE EXTENT GRANTS ARE NOT NEEDED FOR SUCH PURPOSE, THEN TO BE USE BY THE UNIVERSITY FOR THE BENEFIT OF FLORA STONE MATHER COLLEGE OF SAID UNIVERSITY.
IRS990/AllOtherExpensesGrp/ManagementAndGeneralAmt016355
IRS990/AllOtherExpensesGrp/TotalAmt016355
IRS990/BooksInCareOfDetail/BusinessName/BusinessNameLine1Txt0KeyBank NA
IRS990/BooksInCareOfDetail/PhoneNum02168134556
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt04900 Tiedeman Rd OH-01-49-0150
IRS990/BooksInCareOfDetail/USAddress/CityNm0Brooklyn
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990/BooksInCareOfDetail/USAddress/ZIPCd0441442302
IRS990/BusinessRlnWith35CtrlEntInd0false
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CapStkTrPrinCurrentFundsGrp/BOYAmt056172438
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompCurrentOfcrDirectorsGrp/ManagementAndGeneralAmt0312536
IRS990/CompCurrentOfcrDirectorsGrp/TotalAmt0312536
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt00
IRS990/CYGrantsAndSimilarPaidAmt03394972
IRS990/CYInvestmentIncomeAmt02739450
IRS990/CYOtherExpensesAmt018455
IRS990/CYOtherRevenueAmt020200
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt0-966313
IRS990/CYSalariesCompEmpBnftPaidAmt0312536
IRS990/CYTotalExpensesAmt03725963
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt02759650
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/Desc0THIS TRUST DISTRIBUTES ITS INCOME TO CASE WESTERN RESERVE UNIVERSITY FOR THE BENEFIT OF SQUIRE FARM AND MATHER COLLEGE. UNDER THE OHIO INSTITUTIONAL TRUST FUNDS ACTOF 1999, THE BENEFICIARY HAS CHOSEN TO RECEIVE THE MAXIMUM OF INCOME BASED ON THE GREATER OF 5% OF AFV OR TRADITIONAL INCOME. KEYBANK MAINTAINS A RESPONSIVENESS TO THE NEEDS AND ACTIVITIES OF THE BENEFICIARY ORGANIZATION IN THE ATTAINMENT OF ITS MISSION.
IRS990/DescribedInSection501c3Ind0true
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0false
IRS990/DonorAdvisedFundInd0false
IRS990/DonorRstrOrQuasiEndowmentsInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd0false
IRS990/ExpenseAmt03394972
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt02100
IRS990/FeesForServicesAccountingGrp/TotalAmt02100
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form8282PropertyDisposedOfInd0false
IRS990/Form990PartVIISectionAGrp/BusinessName/BusinessNameLine1Txt0KEYBANK N A
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/InstitutionalTrusteeInd0X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/PersonNm0ALLEN H FORD
IRS990/Form990PartVIISectionAGrp/PersonNm1DAVID HUNT
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt2312536
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/TitleTxt0CO-TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt1CO-TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt2CO-TRUSTEE
IRS990/Form990ProvidedToGvrnBodyInd0true
IRS990/FormationYr01934
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedInd0false
IRS990/FundraisingActivitiesInd0false
IRS990/GainOrLossGrp/SecuritiesAmt02124553
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt00
IRS990/GrantAmt03393972
IRS990/GrantsToDomesticOrgsGrp/ProgramServicesAmt03394972
IRS990/GrantsToDomesticOrgsGrp/TotalAmt03394972
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0true
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossAmountSalesAssetsGrp/SecuritiesAmt04896937
IRS990/GrossReceiptsAmt05532034
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt00
IRS990/IndivRcvdGreaterThan100KCnt01
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartIIIInd0X
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InvestmentIncomeGrp/ExclusionAmt0614897
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt0614897
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsOtherSecuritiesGrp/BOYAmt056172437
IRS990/InvestmentsOtherSecuritiesGrp/EOYAmt055206124
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LegalDomicileStateCd0OH
IRS990/LessCostOthBasisSalesExpnssGrp/SecuritiesAmt02772384
IRS990/LoanOutstandingInd0false
IRS990/LobbyingActivitiesInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingCashInd0X
IRS990/MinutesOfCommitteesInd0true
IRS990/MinutesOfGoverningBodyInd0true
IRS990/MissionDesc0UNDER THE TERMS OF THE WILL AND CODICILS OF ANDREW SQUIRE WHO DIED JANUARY 5, 1934, THE TRUSTEES ARE DIRECTED TO MAKE GRANTS TO CASE WESTERN RESERVE UNIVERSITY. GRANTS ARE TO BE USED IN PRESERVING ,MAINTAINING AND OPERATING SQUIRE FARM, ONE OF THE PROPERTIES AND EDUCATIONAL FUNCTIONS OF THE UNIVERSITY AND TO THE EXTENT GRANTS ARE NOT NEEDED FOR SUCH PURPOSE, THEN TO BE USE BY THE UNIVERSITY FOR THE BENEFIT OF FLORA STONE MATHER COLLEGE OF SAID UNIVERSITY.
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesBOYAmt056172438
IRS990/NetAssetsOrFundBalancesEOYAmt055206125
IRS990/NetGainOrLossInvestmentsGrp/ExclusionAmt02124553
IRS990/NetGainOrLossInvestmentsGrp/TotalRevenueColumnAmt02124553
IRS990/NetUnrelatedBusTxblIncmAmt00
IRS990/NondeductibleContributionsInd0false
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrgDoesNotFollowFASB117Ind0X
IRS990/OtherAssetsTotalGrp/BOYAmt01
IRS990/OtherAssetsTotalGrp/EOYAmt01
IRS990/OtherExpensesGrp/Desc0990T ESTIMATED TAX PYMT
IRS990/OtherRevenueMiscGrp/Desc0IRS 990T TAX REFUND 2018 TAX YEAR\
IRS990/OtherRevenueMiscGrp/ExclusionAmt020200
IRS990/OtherRevenueMiscGrp/TotalRevenueColumnAmt020200
IRS990/OtherRevenueTotalAmt020200
IRS990/PartialLiquidationInd0false
IRS990/PayPremiumsPrsnlBnftCntrctInd0false
IRS990/PoliticalCampaignActyInd0false
IRS990/PrincipalOfcrBusinessName/BusinessNameLine1Txt0KEYBANK NA TRUSTEE
IRS990/ProfessionalFundraisingInd0false
IRS990/ProgSrvcAccomActy2Grp/Desc0GRANT PAID TO CLEVELAND BOTANICAL GARDEN ARE FOR GENERAL SUPPORT OF THE GARDEN IN MEMORY OF ELEANOR SQUIRE'S COLLECTION OF GARDENING BOOKS WHICH INSPIRED THE FOUNDING OF THE GARDEN CENTER OF GREATER CLEVELAND, NOW KNOWN AS THE BOTANICAL GARDENS ALSO UTILIZED FOR EDUCATIONAL PURPOSES BY CASE WESTERN RESERVE UNIVERSITY.
IRS990/ProgSrvcAccomActy2Grp/ExpenseAmt01000
IRS990/ProgSrvcAccomActy2Grp/GrantAmt01000
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYExcessBenefitTransInd0false
IRS990/PYGrantsAndSimilarPaidAmt03489376
IRS990/PYInvestmentIncomeAmt05493334
IRS990/PYOtherExpensesAmt02200
IRS990/PYOtherRevenueAmt0194120
IRS990/PYRevenuesLessExpensesAmt01876655
IRS990/PYSalariesCompEmpBnftPaidAmt0319223
IRS990/PYTotalExpensesAmt03810799
IRS990/PYTotalRevenueAmt05687454
IRS990/QuidProQuoContributionsInd0false
IRS990/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990/ReconcilationRevenueExpnssAmt0-966313
IRS990/RelatedEntityInd0false
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0true
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990/RtnEarnEndowmentIncmOthFndsGrp/EOYAmt055206125
IRS990ScheduleA/AdjustedNetIncomeGrp/AdjustedGrossIncomeGrp/CurrentYearAmt0614897
IRS990ScheduleA/AdjustedNetIncomeGrp/AdjustedGrossIncomeGrp/PriorYearAmt0766144
IRS990ScheduleA/AdjustedNetIncomeGrp/DepreciationDepletionGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/NetSTCapitalGainAdjNetIncmGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherExpensesGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherGrossIncomeGrp/CurrentYearAmt0614897
IRS990ScheduleA/AdjustedNetIncomeGrp/OtherGrossIncomeGrp/PriorYearAmt0766144
IRS990ScheduleA/AdjustedNetIncomeGrp/ProductionIncomeGrp/CurrentYearAmt0330991
IRS990ScheduleA/AdjustedNetIncomeGrp/ProductionIncomeGrp/PriorYearAmt0321423
IRS990ScheduleA/AdjustedNetIncomeGrp/RecoveriesPYDistributionsGrp/PriorYearAmt00
IRS990ScheduleA/AdjustedNetIncomeGrp/TotalAdjustedNetIncomeGrp/CurrentYearAmt0283906
IRS990ScheduleA/AdjustedNetIncomeGrp/TotalAdjustedNetIncomeGrp/PriorYearAmt0444721
IRS990ScheduleA/DistributableAmountGrp/CYAdjNetIncomeDistributableAmt0444721
IRS990ScheduleA/DistributableAmountGrp/CYDistributableAsAdjustedAmt02337473
IRS990ScheduleA/DistributableAmountGrp/CYGreaterAdjustedMinimumAmt02337473
IRS990ScheduleA/DistributableAmountGrp/CYIncomeTaxImposedPYAmt00
IRS990ScheduleA/DistributableAmountGrp/CYPct85AdjustedNetIncomeAmt0378013
IRS990ScheduleA/DistributableAmountGrp/CYTotalMinAstDistributableAmt02337473
IRS990ScheduleA/DistributionAllocationsGrp/CarryoverPYNotAppliedAmt00
IRS990ScheduleA/DistributionAllocationsGrp/CYDistribAppUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/CYDistributableAsAdjustedAmt02337473
IRS990ScheduleA/DistributionAllocationsGrp/CyovAppliedUnderdistrCPYAmt02337473
IRS990ScheduleA/DistributionAllocationsGrp/CyovAppliedUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/CYTotalAnnualDistributionsAmt03394972
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionAmt03394972
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovAmt03512031
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr1Amt03489376
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr2Amt02360128
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr3Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr4Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistributionCyovYr5Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessDistriCyovToNextYrAmt06907003
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear1Amt03394972
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear2Amt03489376
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear3Amt022655
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear4Amt00
IRS990ScheduleA/DistributionAllocationsGrp/ExcessFromYear5Amt00
IRS990ScheduleA/DistributionAllocationsGrp/RemainingUnderdistriCYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/RemainingUnderdistriPYAmt00
IRS990ScheduleA/DistributionAllocationsGrp/TotalExcessDistributionCyovAmt05849504
IRS990ScheduleA/DistributionAllocationsGrp/UnderdistributionsAmt00
IRS990ScheduleA/DistributionsGrp/CYAdministrativeExpensePaidAmt00
IRS990ScheduleA/DistributionsGrp/CYDistriAttentiveSuprtOrgAmt03394972
IRS990ScheduleA/DistributionsGrp/CYDistributableAsAdjustedAmt02337473
IRS990ScheduleA/DistributionsGrp/CYDistributionYrRt01.0
IRS990ScheduleA/DistributionsGrp/CYOtherDistributionsAmt00
IRS990ScheduleA/DistributionsGrp/CYPaidAccomplishExemptPrpsAmt03394972
IRS990ScheduleA/DistributionsGrp/CYPdInExcessIncomeActivityAmt00
IRS990ScheduleA/DistributionsGrp/CYTotalAnnualDistributionsAmt03394972
IRS990ScheduleA/DistributionsGrp/ExemptUseAssetsAcquisPaidAmt00
IRS990ScheduleA/DistributionsGrp/QualifiedSetAsideAmt00
IRS990ScheduleA/Form990SchASupportingOrgGrp/Contribution35ControlledInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionControllerInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ContributionFamilyInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ControlledDisqualifiedPrsnInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnControllIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/DisqualifiedPrsnOwnrIntInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ExcessBusinessHoldingsRulesInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/ListedByNameGoverningDocInd0true
IRS990ScheduleA/Form990SchASupportingOrgGrp/LoanDisqualifiedPersonInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/OrganizationChangeSuprtOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/PaymentSubstantialContribtrInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgNotOrganizedUSInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportedOrgSectionC456Ind0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SupportNonSupportedOrgInd0false
IRS990ScheduleA/Form990SchASupportingOrgGrp/SuprtOrgNoIRSDeterminationInd0false
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/OfficersCloseRelationshipInd0false
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/SupportedOrgVoiceInvestmentInd0true
IRS990ScheduleA/Form990SchAType3SprtOrgAllGrp/TimelyProvidedDocumentsInd0true
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0Keybank representatives have completed an extensive internal review of supporting organization accounts. this was done in concert with in house counsel and individual determinations were made with respect to the relationships. The beneficiaries have the right to remove the trustee and the trustee has the right to amend the trust to insure continuation of 509(a)3 status.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt1KeyBank as Co-Trustee welcomes the input of the charitable beneficiaries as to investments.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt2KeyBank, as Co-Trustee, maintains a close and continuous working relationship with Case Western Reserve University and theCleveland Botanical Garden. All supported organizationsmaintain a significant voice as they have the right to remove theTrustee and replace with another corporate Trustee. The Trustee hasthe authority to amend the document to insure the continuation of
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt3509(a)(3) status. The supported organizations receive periodic statements reflecting all activity in the trust regarding income ,expenses and investments. KeyBank welcomes the input of the supported organizations as to investments.
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0LINE 2
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc1Line 3
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc2Line 8
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc3Line 8 Continued
IRS990ScheduleA/MinimumAssetAmountGrp/AcquisitionIndebtednessGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/AdjustedFMVLessIndebtednessGrp/CurrentYearAmt066557042
IRS990ScheduleA/MinimumAssetAmountGrp/AdjustedFMVLessIndebtednessGrp/PriorYearAmt067801967
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyCashBalancesGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyFMVOfSecGrp/CurrentYearAmt066557042
IRS990ScheduleA/MinimumAssetAmountGrp/AverageMonthlyFMVOfSecGrp/PriorYearAmt067801967
IRS990ScheduleA/MinimumAssetAmountGrp/CashDeemedCharitableGrp/CurrentYearAmt0998356
IRS990ScheduleA/MinimumAssetAmountGrp/CashDeemedCharitableGrp/PriorYearAmt01017030
IRS990ScheduleA/MinimumAssetAmountGrp/DiscountClaimedAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/FMVOtherNonExemptUseAssetGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/NetVlNonExemptUseAssetsGrp/CurrentYearAmt065558686
IRS990ScheduleA/MinimumAssetAmountGrp/NetVlNonExemptUseAssetsGrp/PriorYearAmt066784937
IRS990ScheduleA/MinimumAssetAmountGrp/PctOfNetVlNonExemptUseAstGrp/CurrentYearAmt02294554
IRS990ScheduleA/MinimumAssetAmountGrp/PctOfNetVlNonExemptUseAstGrp/PriorYearAmt02337473
IRS990ScheduleA/MinimumAssetAmountGrp/RecoveriesPYDistriMinAssetGrp/PriorYearAmt00
IRS990ScheduleA/MinimumAssetAmountGrp/TotalFMVOfNonExemptUseAssetGrp/CurrentYearAmt066557042
IRS990ScheduleA/MinimumAssetAmountGrp/TotalFMVOfNonExemptUseAssetGrp/PriorYearAmt067801967
IRS990ScheduleA/MinimumAssetAmountGrp/TotalMinimumAssetGrp/CurrentYearAmt02294554
IRS990ScheduleA/MinimumAssetAmountGrp/TotalMinimumAssetGrp/PriorYearAmt02337473
IRS990ScheduleA/OtherSupportSumAmt00
IRS990ScheduleA/SupportedOrganizationsCnt02
IRS990ScheduleA/SupportedOrganizationsTotalCnt02
IRS990ScheduleA/SupportedOrgInformationGrp/EIN0341018992
IRS990ScheduleA/SupportedOrgInformationGrp/EIN1340239538
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd0true
IRS990ScheduleA/SupportedOrgInformationGrp/GoverningDocumentListedInd1true
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd05
IRS990ScheduleA/SupportedOrgInformationGrp/OrganizationTypeCd17
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt00
IRS990ScheduleA/SupportedOrgInformationGrp/OtherSupportAmt10
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt03393972
IRS990ScheduleA/SupportedOrgInformationGrp/SupportAmt11000
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt0CASE WESTERN RESERVE UNIV
IRS990ScheduleA/SupportedOrgInformationGrp/SupportedOrganizationName/BusinessNameLine1Txt1CLEVE BOTANICAL GARDEN
IRS990ScheduleA/SupportingOrganization509a3Ind0X
IRS990ScheduleA/SupportingOrgType3NonFuncInd0X
IRS990ScheduleA/SupportSumAmt03394972
IRS990/ScheduleBRequiredInd0false
IRS990ScheduleD/OtherAssetsOrgGrp/BookValueAmt01
IRS990ScheduleD/OtherAssetsOrgGrp/Desc0PORTRAIT OF A SQUIRE
IRS990ScheduleD/OtherAssetsOrgGrp/Desc1XXX-XX-XXXX PORTRAIT OF A SQUIRE
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt0433100
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt154773024
IRS990ScheduleD/OtherSecuritiesGrp/Desc0KT SHORT TERM INVESTMENT FUND
IRS990ScheduleD/OtherSecuritiesGrp/Desc1CASE WESTERN RESERVE UNIVERSITY FUN
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd0C
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd1C
IRS990ScheduleD/TotalBookValueOtherAssetsAmt01
IRS990ScheduleD/TotalBookValueSecuritiesAmt055206124
IRS990ScheduleI/GrantRecordsMaintainedInd0true
IRS990ScheduleI/RecipientTable/CashGrantAmt03393972
IRS990ScheduleI/RecipientTable/IRCSectionDesc0170(b)(1)(A)(iii)
IRS990ScheduleI/RecipientTable/PurposeOfGrantTxt0BENEFIT OF SQUIRE FARM AND MATHER COLLEGE
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt0CASE WESTERN RESERVE UNIVERSITY
IRS990ScheduleI/RecipientTable/RecipientEIN0341018992
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt011000 CEDAR AVE
IRS990ScheduleI/RecipientTable/USAddress/CityNm0CLEVELAND
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd0OH
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd044106
IRS990ScheduleI/SupplementalInformationDetail/ExplanationTxt0GRANTS ARE MADE TO 501(c)(3 ) ORGANIZATIONS THAT ARE NAMED IN THE TRUST DOCUMENT. OUR ADMINISTRATIVE REPRESENTATIVES ARE IN PERIODIC CONTACT WITH REPRESENTATIVES OF THE CHARITIES IN ORDER TO BE IN COMPLIANCE WITH THE TRUST PROVISIONS.
IRS990ScheduleI/SupplementalInformationDetail/FormAndLineReferenceDesc0EXPLANATION FOR FORM 990, SCHEDULE I, PART 1, LINE 2
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0NO CONFLICT OF INTEREST POLICY EXISTS FOR THE TRUST. KEYBANK N.A. HAS A CORPORATE CONFLICT OF INTEREST POLICY.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1THE TRUST HAS NO WRITTEN DOCUMENT RETENTION OR DESTRUCTION POLICY. KEYBANK N A HAS A CORPORATE DOCUMENT RETENTION AND DESTRUCTION POLICY.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2KEYBANK IS CO-TRUSTEE, IS COMPENSATED AS SUCH, AND MAKES ALL DECISIONS WITH RESPECT TO THE OPERATION AND ADMINISTRATION OF THETRUST.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3KEYBANK IS CO-TRUSTEE.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4ALL RETURNS ARE THOROUGHLY PREPARED AND REVIEWED BY OUR INTERNAL PROFESSIONAL TAX DEPARTMENT.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5DOCUMENTS ARE AVAILABLE UPON REQUEST BY MAIL OR BY PHONE WITHIN TWO WEEKS OF RECEIPT OF THE REQUEST.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0PART VI, LINE 12A
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1PART VI, LINE 14
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2PART VI, LINE 15 A AND B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3EXPLANATION FOR FORM 990, PAGE 6, PART VI, LINE 1a
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990, PAGE 6, PART VI, LINE 11-DESCRIPTION OF PROCESS FOR REVIEW
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FORM 990, PAGE 6, PART VI, LINE 19
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/StatesWhereCopyOfReturnIsFldCd0OH
IRS990/SubjectToExcsTaxNetInvstIncInd0false
IRS990/SubjectToProxyTaxInd0false
IRS990/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt056172438
IRS990/TotalAssetsEOYAmt055206125
IRS990/TotalAssetsGrp/BOYAmt056172438
IRS990/TotalAssetsGrp/EOYAmt055206125
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt0330991
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt03394972
IRS990/TotalFunctionalExpensesGrp/TotalAmt03725963
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesBOYAmt00
IRS990/TotalLiabilitiesEOYAmt00
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt00
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt056172438
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt055206125
IRS990/TotalOtherCompensationAmt00
IRS990/TotalProgramServiceExpensesAmt03395972
IRS990/TotalReportableCompFromOrgAmt0312536
IRS990/TotalRevenueGrp/ExclusionAmt02759650
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt02759650
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt056172438
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt055206125
IRS990/TotReportableCompRltdOrgAmt00
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/TypeOfOrganizationTrustInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UponRequestInd0X
IRS990/VotingMembersGoverningBodyCnt00
IRS990/VotingMembersIndependentCnt00
IRS990/WebsiteAddressTxt0N/A
IRS990/WhistleblowerPolicyInd0false
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KEYBANK BYP S CHMURA
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PhoneNum02166890969
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-05-07
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ANDREW SQUIRE TESTAMENTARY TRUST
ReturnHeader/Filer/BusinessNameControlTxt0SQUI
ReturnHeader/Filer/EIN0346506892
ReturnHeader/Filer/PhoneNum02166890969
ReturnHeader/Filer/USAddress/AddressLine1Txt04900 TIEDEMAN ROAD OH-01-49-0150
ReturnHeader/Filer/USAddress/CityNm0BROOKLYN
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd044144
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0134008324
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PRICEWATERHOUSECOOPERS LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01850 N CENTRAL AVE STE 700
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PHOENIX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0AZ
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd085004
ReturnHeader/PreparerPersonGrp/PhoneNum04123556000
ReturnHeader/PreparerPersonGrp/PreparationDt02021-05-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JEFFREY E KUHLIN
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02021-05-12T09:00:35-05:00
ReturnHeader/ReturnTypeCd0990
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$55,206,125
Liabilities
$0
Net assets
$55,206,125
Revenue
$2,759,650
Expenses
$3,725,963
Net income
-$966,313
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$52.1$0.00$52.1$4.99$3.89$1.10
2023Detailed filing. Detailed filing data is available for this year.$51.0$0.00$51.0$2.41$4.00$1.59
2022Detailed filing. Detailed filing data is available for this year.$52.6$0.00$52.6$2.29$4.31$2.02
2021Detailed filing. Detailed filing data is available for this year.$54.3$0.00$54.3$3.10$3.68$0.57
2020Detailed filing. Detailed filing data is available for this year.$55.2$0.00$55.2$2.76$3.73$0.97
2019Detailed filing. Detailed filing data is available for this year.$56.2$0.00$56.2$5.69$3.81$1.88