Civic Intelligence

Shamrock Foundation

990PF • Fiscal year 2020 • EIN 41-1893618

Jul 01, 2019 to Jun 30, 2020 • Filed on May 17, 2021

Organization Profile
21955 Minnetonka BlvdExcelsior, MN 55331

(952) 470-8635

Siviq Scores

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

Liabilities / Assets

57th percentile

0.00x

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

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

Liabilities / Revenue

57th percentile

0.00x

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

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

Net Margin

1st percentile

-20828%

Higher net margin than 1% of similar nonprofits.

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

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.

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

Asset Growth

29th percentile

-8.2%

Faster asset growth than 29% of similar nonprofits.

2020 filings • <$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

3rd percentile

-99%

Faster revenue growth than 3% of similar nonprofits.

2020 filings • <$500k nonprofits • Annualized from 2019 to 2020

Balance Sheet
Liabilities / Assets57th percentile

Assets

Down

$493,615

Down $43,948 (-8.2%) from 2019

Net Assets

Down

$493,615

Down $43,948 (-8.2%) from 2019

Liabilities

Flat

$0

Flat from 2019

Revenue And Expenses
Liabilities / Revenue57th percentileNet Margin1st percentile

Revenue

Down

$211

Down $33,130 (-99%) from 2019

Expenses

Down

$44,159

Down $10,132 (-19%) from 2019

Net Income

Down

-$43,948

Down $22,998 (-110%) from 2019

Historical Trend

Balance Sheet Trend

Asset Growth29th percentile

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

$800K$600K$400K$200K$0Assets 2010: $624,411Liabilities 2010: $0Net Assets 2010: $624,4112010Assets 2011: $609,467Liabilities 2011: $0Net Assets 2011: $609,4672011Assets 2012: $591,956Liabilities 2012: $0Net Assets 2012: $591,9562012Assets 2013: $594,906Liabilities 2013: $0Net Assets 2013: $594,9062013Assets 2014: $606,428Liabilities 2014: $0Net Assets 2014: $606,4282014Assets 2015: $588,811Liabilities 2015: $0Net Assets 2015: $588,8112015Assets 2016: $577,836Liabilities 2016: $686Net Assets 2016: $577,1502016Assets 2017: $558,290Liabilities 2017: $670Net Assets 2017: $557,6202017Assets 2018: $558,513Liabilities 2018: $0Net Assets 2018: $558,5132018Assets 2019: $537,563Liabilities 2019: $0Net Assets 2019: $537,5632019Assets 2020: $493,615Liabilities 2020: $0Net Assets 2020: $493,6152020Assets 2021: $451,946Liabilities 2021: $0Net Assets 2021: $451,9462021Assets 2022: $412,089Liabilities 2022: $0Net Assets 2022: $412,0892022Assets 2023: $382,054Liabilities 2023: $0Net Assets 2023: $382,0542023Assets 2024: $349,900Liabilities 2024: $0Net Assets 2024: $349,9002024

Highlighted filing

2020

Assets$493,615
Liabilities$0
Net Assets$493,615
Open 2020 Filing

Operations Trend

Revenue Growth3rd percentile

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

$100K$50K$0-$50KExpenses 2010: $40,8892010Expenses 2011: $42,0082011Expenses 2012: $42,1382012Expenses 2013: $43,8182013Revenue 2014: $61,507Expenses 2014: $49,985Net Income 2014: $11,5222014Revenue 2015: $34,401Expenses 2015: $52,018Net Income 2015: -$17,6172015Revenue 2016: $36,085Expenses 2016: $47,746Net Income 2016: -$11,6612016Revenue 2017: $33,106Expenses 2017: $52,636Net Income 2017: -$19,5302017Revenue 2018: $52,921Expenses 2018: $52,028Net Income 2018: $8932018Revenue 2019: $33,341Expenses 2019: $54,291Net Income 2019: -$20,9502019Revenue 2020: $211Expenses 2020: $44,159Net Income 2020: -$43,9482020Revenue 2021: $10,494Expenses 2021: $52,163Net Income 2021: -$41,6692021Revenue 2022: $25,781Expenses 2022: $65,638Net Income 2022: -$39,8572022Revenue 2023: $23,844Expenses 2023: $53,879Net Income 2023: -$30,0352023Revenue 2024: $20,163Expenses 2024: $52,317Net Income 2024: -$32,1542024

Highlighted filing

2020

Revenue$211
Expenses$44,159
Net Income-$43,948
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2019 to Jun 30, 2020
Signed
May 17, 2021
Return Version
2019v5.0
Compensation and Service Providers
Top Officer Pay77th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
WILLIAM SLATTERYSec/Treas-$0--
JOAN SLATTERYPresident-$0--
Filing and Contact Details

Filer

Filer Name
Shamrock Foundation
EIN
41-1893618
Phone
9524708635
Address
21955 MINNETONKA BLVD, EXCELSIOR, MN 55331

Signing Officer

Name
William Slattery
Title
Sec/Treas
Signed
2021-05-17
Discuss with paid preparer
Yes

Preparer

Firm
Orenstein Llp
Address
2600 WAYZATA BOULEVARD, MINNEAPOLIS, MN 55405
Preparer
James L Orenstein
Phone
6123741234
Raw XML Appendix345 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/Amt02050
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt005
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt00
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt02050
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt017374
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt136254
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt253038
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt364331
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt462506
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt5116181
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt064898
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt180790
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt247833
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt362938
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt499359
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt5147384
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0VANGUARD INTERMED TRM INVST GR ADMIRAL
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm1S&P MIDCAP 400 EFT TRUST UNIT SER 1
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm2S&P 500 EFT TRUST UNIT SER 1
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm3VANGUARD SHORT TERM INVMT GRADE ADMIRAL
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm4DFA EMERGING MRKTS CORE EQU PORTF
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm5DFA INTL SMALL CAP VALUE
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm6DFA US SMALL CAP VALUE PRTF INSTL +
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm7DFA US LARGE CAP VALUE PRTF INSTL
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm8DFA FIVE YEAR GLBL FIXED INCOME PRTF INS
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm9DFA INTERNATIONAL VALUE PRTF INSTL
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm10VANGUARD INDEX FUNDS S&P 500
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt019105
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/RelatedOrExemptFunctionIncmAmt0-18894
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt019105
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt0-18894
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt0211
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt02050
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt02050
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt019105
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt040000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt040000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncmAmt019105
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt019105
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt019105
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-43948
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0282141
IRS990PF/AnalysisOfRevenueAndExpenses/InterestRevAndExpnssAmt017
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt0-18894
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt015279
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt025
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt01776
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt01776
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0291
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt019105
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt040000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt03826
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt044159
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt019105
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt0211
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt03826
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt04159
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02001-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12001-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22001-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt32001-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt42001-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt052409
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt167734
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt242471
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt385875
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt452546
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-9944
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1-2975
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt2-11520
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt33817
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt41728
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-9944
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1-2975
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt2-11520
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt33817
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt41728
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt042465
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt164759
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt230951
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt389692
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt454274
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd2P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd3P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd4P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc02740.747 SHS DFA EMERGING MRKTS CORE EQU PORTF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc16242.533 SHS DFA FIVE YEAR GLBL FIXED INC PRTF INSTL
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc22915.985 SHS DFA INTERNATIONAL VALUE PRTF INSTL
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc39267.442 SHS VANGUARD INTERMED TRM INST GR ADMIRAL
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc45180.482 SHS VANGUARD SHORT TERM INVMT GRADE ADMIRAL
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02020-04-03
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12020-03-24
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22020-03-20
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt32020-03-19
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt42020-03-19
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt0-18894
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-43948
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0493615
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0537563
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0493615
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt034790
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt034790
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt034790
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt035096
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0306
IRS990PF/DistributableAmountGrp/TotalTaxAmt0306
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/Form2220AttachedInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0306
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0306
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0306
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0306
IRS990PF/FMVAssetsEOYAmt0647133
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt03025
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt0143931
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt0143931
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0534538
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0349684
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0503202
IRS990PF/Form990PFBalanceSheetsGrp/NoDonorRstrNetAssestsBOYAmt0537563
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0537563
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0493615
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0647133
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0537563
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0493615
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0537563
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0493615
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0712607
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt060884
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0651723
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt010689
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt035096
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0701918
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0712607
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0WILLIAM SLATTERY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1JOAN SLATTERY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Sec/Treas
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1President
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt021955 MINNETONKA BLVD 5
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt121955 MINNETONKA BLVD 5
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0EXCELSIOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1EXCELSIOR
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1MN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd055331
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd155331
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt044525
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt044678
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt049709
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt049491
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt049688
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt044658
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt049656
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.063434
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.06634
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.06151
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.06552
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.06103
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.06278
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0153
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0701918
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0749328
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0804558
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0758388
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0731804
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0791010
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt040000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.317169
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt040000
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt040000
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt040000
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
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/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt02600 WAYZATA BLVD
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0MINNEAPOLIS
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MN
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd055405
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0ORENSTEIN LLP
IRS990PF/StatementsRegardingActyGrp/PhoneNum06123741234
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0GENERAL PHILANTHROPIC ACTIVITIES
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt03836
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/FormAndInfoAndMaterialsTxt0NONE
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientPersonNm0JOAN SLATTERY
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/AddressLine1Txt021955 MINNETONKA BLVD 5
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/CityNm0EXCELSIOR
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/StateAbbreviationCd0MN
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RecipientUSAddress/ZIPCd055391
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/RestrictionsOnAwardsTxt0NONE
IRS990PF/SupplementaryInformationGrp/ApplicationSubmissionInfoGrp/SubmissionDeadlinesTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt05000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt115000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt210000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt310000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0TO HELP THE ORGANIZATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1TO HELP THE ORGANIZATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2TO HELP THE ORGANIZATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3TO HELP THE ORGANZATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0HOLY FAMILY CATHOLIC HIGH SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm1RISEN CHRIST SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm2GILDA'S CLUB TWIN CITIES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm3CHRISTO REY JESUIT HIGH SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt08101 KOCHIA LANE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt11120 EAST 37TH STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt210560 WAYZATA BOULEVARD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt32924 4TH AVE SO
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0VICTORIA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1MINNEAPOLIS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2MINNETONKA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3MINNEAPOLIS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd055386
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd155407
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd255305
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd355408
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt040000
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/AppliedToCurrentYearAmt034790
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt034790
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt012825
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt010281
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt012393
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt08752
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt010793
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt010793
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt049461
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt05210
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt012825
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt010281
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt012393
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt08752
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt040000
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt05210
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt060254
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt055044
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0LICENSES
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt025
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/AdjustedNetIncomeAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt01776
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0INVESTMENT FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt01776
TaxesSchedule/TaxesDetail/Amt0291
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0WILLIAM SLATTERY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Sec/Treas
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-05-17
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SHAMROCK FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0SHAM
ReturnHeader/Filer/EIN0411893618
ReturnHeader/Filer/PhoneNum09524708635
ReturnHeader/Filer/USAddress/AddressLine1Txt021955 MINNETONKA BLVD
ReturnHeader/Filer/USAddress/CityNm0EXCELSIOR
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MN
ReturnHeader/Filer/USAddress/ZIPCd055331
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0411854544
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ORENSTEIN LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02600 WAYZATA BOULEVARD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0MINNEAPOLIS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd055405
ReturnHeader/PreparerPersonGrp/PhoneNum06123741234
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JAMES L ORENSTEIN
ReturnHeader/ReturnTs02021-05-17T14:03:30-07:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02019-07-01
ReturnHeader/TaxPeriodEndDt02020-06-30
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$493,615
Liabilities
$0
Net assets
$493,615
Revenue
$211
Expenses
$44,159
Net income
-$43,948
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$3.50$0.00$3.50$0.20$0.52$0.32
2023Detailed filing. Detailed filing data is available for this year.$3.82$0.00$3.82$0.24$0.54$0.30
2022Detailed filing. Detailed filing data is available for this year.$4.12$0.00$4.12$0.26$0.66$0.40
2021Detailed filing. Detailed filing data is available for this year.$4.52$0.00$4.52$0.10$0.52$0.42
2020Detailed filing. Detailed filing data is available for this year.$4.94$0.00$4.94$0.00$0.44$0.44
2019Detailed filing. Detailed filing data is available for this year.$5.38$0.00$5.38$0.33$0.54$0.21
2018Detailed filing. Detailed filing data is available for this year.$5.59$0.00$5.59$0.53$0.52$0.01
2017Detailed filing. Detailed filing data is available for this year.$5.58$0.01$5.58$0.33$0.53$0.20
2016Detailed filing. Detailed filing data is available for this year.$5.78$0.01$5.77$0.36$0.48$0.12
2015Detailed filing. Detailed filing data is available for this year.$5.89$0.00$5.89$0.34$0.52$0.18
2014Detailed filing. Detailed filing data is available for this year.$6.06$0.00$6.06$0.62$0.50$0.12
2013Detailed filing. Detailed filing data is available for this year.$5.95$0.00$5.95$0.44
2012Detailed filing. Detailed filing data is available for this year.$5.92$0.00$5.92$0.42
2011Detailed filing. Detailed filing data is available for this year.$6.09$0.00$6.09$0.42
2010Detailed filing. Detailed filing data is available for this year.$6.24$0.00$6.24$0.41