Civic Intelligence

Shamrock Foundation

990PF • Fiscal year 2017 • EIN 41-1893618

Jul 01, 2016 to Jun 30, 2017 • Filed on May 14, 2018

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

38th percentile

0.00x

Higher debt load relative to assets than 38% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Source year 2017

Liabilities / Revenue

51st percentile

0.02x

Higher debt load relative to revenue than 51% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Source year 2017

Net Margin

7th percentile

-59%

Higher net margin than 7% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Source year 2017

Top Officer Pay

54th percentile

$0

Higher top officer pay than 54% of similar nonprofits.

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

2017 filings • $500k-$1M nonprofits • Source year 2017

Asset Growth

26th percentile

-3.4%

Faster asset growth than 26% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Annualized from 2016 to 2017

Revenue Growth

24th percentile

-8.3%

Faster revenue growth than 24% of similar nonprofits.

2017 filings • $500k-$1M nonprofits • Annualized from 2016 to 2017

Assets

Down

$558,290

Down $19,546 (-3.4%) from 2016

Net Assets

Down

$557,620

Down $19,530 (-3.4%) from 2016

Liabilities

Down

$670

Down $16 (-2.3%) from 2016

Revenue

Down

$33,106

Down $2,979 (-8.3%) from 2016

Expenses

Up

$52,636

Up $4,890 (+10%) from 2016

Net Income

Down

-$19,530

Down $7,869 (-67%) from 2016

Historical Trend

Balance Sheet Trend

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

2017

Assets$558,290
Liabilities$670
Net Assets$557,620

Operations Trend

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

2017

Revenue$33,106
Expenses$52,636
Net Income-$19,530
Jump To
Filing Snapshot
Filing Period
Jul 1, 2016 to Jun 30, 2017
Signed
May 14, 2018
Return Version
2016v3.0
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
WILLIAM SLATTERYSec/Treas-$0--
JOAN SLATTERYPresident-$0--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid Grant-TO HELP THE ORGANIZATIONGOODMINNEAPOLIS, MN, US$15,000
Paid Grant-TO HELP THE ORGANZATIONGOODMINNEAPOLIS, MN, US$10,000
Paid Grant-TO HELP THE ORGANIZATIONGOODST PAUL, MN, US$10,000
Paid Grant-TO HELP THE ORGANIZATIONGOODVICTORIA, MN, US$5,000
Paid Grant-TO HELP THE ORGANIZATIONGOODMINNEAPOLIS, MN, US$5,000
Paid Grant-TO HELP THE ORGANIZATIONGOODMINNETONKA, MN, US$5,000
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
2018-05-14
Discuss with paid preparer
Yes

Preparer

Firm
Orenstein Llp
Address
2600 WAYZATA BOULEVARD, MINNEAPOLIS, MN 55405-2123
Preparer
James L Orenstein CPA
Phone
6123741234
Raw XML Appendix351 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
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt085875
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt117374
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt236254
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt352546
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt451523
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt549285
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt662589
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt774324
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt886900
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt941620
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt090636
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt163524
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt263352
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt355328
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt455327
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt564363
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt689871
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt7152591
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt884888
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt952232
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
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt024430
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/RelatedOrExemptFunctionIncmAmt08676
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt024430
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt08676
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt033106
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt024430
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt08676
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt050000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt050000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncmAmt024430
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt024430
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt024430
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-19530
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt049966
IRS990PF/AnalysisOfRevenueAndExpenses/InterestRevAndExpnssAmt08
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt08676
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt031189
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt025
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt01917
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt01917
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0686
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt024430
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt050000
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt01917
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt052636
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt033106
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt033106
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt01917
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt02636
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02001-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12001-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt020455
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt120835
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-472
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt19148
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-472
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt19148
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt019983
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt129983
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc01824.818 SHS DFA FIVE YEAR GLBL FIXED INC PRTF INSTL
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1818.331 SHS DFA US SMALL CAP VALUE PRFT INSTL
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02017-05-05
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12017-05-05
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt08676
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-19530
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0557620
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0577150
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0557620
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt037590
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt037590
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt037590
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt037902
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0312
IRS990PF/DistributableAmountGrp/TotalTaxAmt0312
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/Form2220AttachedInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0312
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0312
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0312
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0312
IRS990PF/FMVAssetsEOYAmt0772112
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableBOYAmt0686
IRS990PF/Form990PFBalanceSheetsGrp/AccountsPayableEOYAmt0670
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0577492
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0558290
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0772112
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/PrepaidExpensesBOYAmt0344
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0577836
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0558290
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0772112
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt0686
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt0670
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0577836
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0558290
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0577150
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0557620
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedBOYAmt0577150
IRS990PF/Form990PFBalanceSheetsGrp/UnrestrictedEOYAmt0557620
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0769593
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0-874
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0770467
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt011544
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt037902
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0758049
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0769593
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/AdjNetVlNoncharitableAssetsAmt045469
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt045781
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt044658
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt049656
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt045876
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt041786
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt039836
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.059982
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.06103
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.06278
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.05901
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.05901
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.05809
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd0false
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0312
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0758049
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0731804
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0791010
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0777375
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0708131
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0685783
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt050000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.299911
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt049688
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt050000
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0312
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt050000
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/ExcessBusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/MaintainedExpenditureRspnsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProceedsOrNetIncomeInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
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/Form990TFiledInd0false
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/Expenses1Amt02292
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/Amt25000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt35000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt410000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt510000
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 ORGANIZATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4TO HELP THE ORGANZATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt5TO HELP THE ORGANIZATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt4GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt5GOOD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0HOLY FAMILY CATHOLIC HIGH SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm1RISEN CHRIST SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm2URBAN VENTURES LEADERSHIP FDN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm3GILDA'S CLUB TWIN CITIES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm4CHRISTO REY JESUIT HIGH SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm5TRINITY SOBER HOMES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt4NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt5NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt08101 KOCHIA LANE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt11120 EAST 37TH STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt23041 4TH AVENUE SOUTH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt310560 WAYZATA BOULEVARD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt42924 4TH AVE SO
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt5550 SOUTH SNELLING AVENUE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0VICTORIA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1MINNEAPOLIS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2MINNEAPOLIS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3MINNETONKA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4MINNEAPOLIS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm5ST PAUL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd4MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd5MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd055386
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd155407
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd255408
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd355305
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd455408
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd555116
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt050000
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/AppliedToCurrentYearAmt037590
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt037590
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt08752
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt010793
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt09581
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt06808
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt05875
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt05875
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt048344
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt012410
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt08752
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt010793
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt09581
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt06808
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt050000
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt012410
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt054219
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt041809
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0LICENSES
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt025
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/AdjustedNetIncomeAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt01917
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0INVESTMENT FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt01917
TaxesSchedule/TaxesDetail/Amt0344
TaxesSchedule/TaxesDetail/Amt1342
TaxesSchedule/TaxesDetail/CategoryTxt0FEDERAL TAXES -2014
TaxesSchedule/TaxesDetail/CategoryTxt1FEDERAL TAXES -2015
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0WILLIAM SLATTERY
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Sec/Treas
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-05-14
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/PreparerFirmName/BusinessNameLine1Txt0ORENSTEIN LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02600 WAYZATA BOULEVARD
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0MINNEAPOLIS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0554052123
ReturnHeader/PreparerPersonGrp/PhoneNum06123741234
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JAMES L ORENSTEIN CPA
ReturnHeader/ReturnTs02018-05-14T09:59:00-07:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02016-07-01
ReturnHeader/TaxPeriodEndDt02017-06-30
ReturnHeader/TaxYr02016

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

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