Civic Intelligence

John Junell Trust UW 35072540

990 • Fiscal year 2012 • EIN 41-6015852

Jan 01, 2012 to Dec 31, 2012 • Filed on May 03, 2013

Organization ProfileN/A
P O Box 64713 Trust Tax Services55164-0713
Siviq Scores

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

Liabilities / Assets

12th percentile

0.00x

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

2012 filings • 501(c)3 • $1M-$5M nonprofits • Source year 2012

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

28th percentile

-3.3%

Faster asset growth than 28% of similar nonprofits.

2012 filings • 501(c)3 • $1M-$5M nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets12th percentile

Assets

Down

$1,219,947

Down $41,884 (-3.3%) from 2011

Net Assets

Down

$1,219,947

Down $41,884 (-3.3%) from 2011

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$77,689

Up $1,205 (+1.6%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth28th percentile

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

$1.5M$1.0M$500K$0Assets 2010: $1,260,700Liabilities 2010: $0Net Assets 2010: $1,260,7002010Assets 2011: $1,261,831Liabilities 2011: $0Net Assets 2011: $1,261,8312011Assets 2012: $1,219,947Liabilities 2012: $0Net Assets 2012: $1,219,9472012Assets 2013: $1,202,017Liabilities 2013: $197Net Assets 2013: $1,201,8202013Assets 2014: $1,224,578Liabilities 2014: $02014Assets 2015: $1,210,257Liabilities 2015: $0Net Assets 2015: $1,210,2572015Assets 2016: $1,162,987Liabilities 2016: $0Net Assets 2016: $1,162,9872016Assets 2017: $1,357,769Liabilities 2017: $0Net Assets 2017: $1,357,7692017Assets 2018: $1,354,835Liabilities 2018: $0Net Assets 2018: $1,354,8352018Assets 2019: $1,318,973Liabilities 2019: $0Net Assets 2019: $1,318,9732019Assets 2020: $1,270,080Liabilities 2020: $0Net Assets 2020: $1,270,0802020Assets 2021: $1,378,323Liabilities 2021: $0Net Assets 2021: $1,378,3232021Assets 2022: $1,341,480Liabilities 2022: $0Net Assets 2022: $1,341,4802022Assets 2023: $1,287,856Liabilities 2023: $0Net Assets 2023: $1,287,8562023Assets 2024: $1,251,960Liabilities 2024: $0Net Assets 2024: $1,251,9602024

Highlighted filing

2012

Assets$1,219,947
Liabilities$0
Net Assets$1,219,947
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$300K$200K$100K$0-$100KExpenses 2010: $78,2542010Expenses 2011: $76,4842011Expenses 2012: $77,6892012Revenue 2013: $63,979Expenses 2013: $82,106Net Income 2013: -$18,1272013Revenue 2014: $108,329Expenses 2014: $85,564Net Income 2014: $22,7652014Revenue 2015: $78,090Expenses 2015: $92,410Net Income 2015: -$14,3202015Revenue 2016: $40,494Expenses 2016: $87,766Net Income 2016: -$47,2722016Revenue 2017: $284,819Expenses 2017: $88,141Net Income 2017: $196,6782017Revenue 2018: $95,883Expenses 2018: $98,819Net Income 2018: -$2,9362018Revenue 2019: $50,195Expenses 2019: $86,083Net Income 2019: -$35,8882019Revenue 2020: $37,166Expenses 2020: $86,062Net Income 2020: -$48,8962020Revenue 2021: $194,018Expenses 2021: $85,710Net Income 2021: $108,3082021Revenue 2022: $59,295Expenses 2022: $95,521Net Income 2022: -$36,2262022Revenue 2023: $35,231Expenses 2023: $88,074Net Income 2023: -$52,8432023Revenue 2024: $53,293Expenses 2024: $88,466Net Income 2024: -$35,1732024

Highlighted filing

2012

Revenue-
Expenses$77,689
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
May 3, 2013
Return Version
2012v2.1
Gross Receipts
$79,805
Mission and Program Overview

Mission

To provide scholarships for university of michigan or university of minnesota students selected by the minneapolis foundation

Filing and Contact Details

Filer

EIN
41-6015852
Raw XML Appendix252 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/AccountantCompileOrReview0false
IRS990/AccountsReceivable/BOY0900
IRS990/AccountsReceivable/EOY04430
IRS990/ActivitiesConductedPartnership0false
IRS990/ActivityOrMissionDescription0TO PROVIDE SCHOLARSHIPS FOR UNIVERSITY OF MICHIGAN OR UNIVERSITY OF MINNESOTA STUDENTS SELECTED BY THE MINNEAPOLIS FOUNDATION
IRS990/BenefitsPaidToMembersCY00
IRS990/BsnssRltnshpThruFamilyMember0false
IRS990/BsnssRltnshpWithOrganization0false
IRS990/CapStckTrstPrinCurrentFunds/BOY0556596
IRS990/CapStckTrstPrinCurrentFunds/EOY0556596
IRS990/CashNonInterestBearing/BOY02516
IRS990/ChangesToOrganizingDocs0false
IRS990/CollectionsOfArt0false
IRS990/CompCurrentOfficersDirectors/Fundraising00
IRS990/CompCurrentOfficersDirectors/ManagementAndGeneral013115
IRS990/CompCurrentOfficersDirectors/ProgramServices03560
IRS990/CompCurrentOfficersDirectors/Total016675
IRS990/CompensationFromOtherSources0false
IRS990/CompensationProcessCEO0true
IRS990/CompensationProcessOther0false
IRS990/ComplianceWithBackupWitholding0true
IRS990/ConflictOfInterestPolicy0false
IRS990/ConservationEasements0false
IRS990/ConsolidatedAuditFinancialStmt0false
IRS990/ContributionsGrantsCurrentYear00
IRS990/CreditCounseling0false
IRS990/DecisionsSubjectToApproval0false
IRS990/DeductibleContributionsOfArt0false
IRS990/DeductibleNonCashContributions0false
IRS990/DelegationOfManagementDuties0false
IRS990/DescribedIn501C30true
IRS990/Description0TO PROVIDE SCHOLARSHIPS FOR UNIVERSITY OF MICHIGAN OR UNIVERSITY O MINNESOTA STUDENTS SELECTED BY THE MINNEAPOLIS FOUNDATION
IRS990/DisregardedEntity0false
IRS990/DocumentRetentionPolicy0false
IRS990/DonorAdvisedFunds0false
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers0false
IRS990/ExcessBenefitTransaction0false
IRS990/Expense063904
IRS990/FamilyOrBusinessRelationship0false
IRS990/FederalGrantAuditRequired0false
IRS990/ForeignActivities0false
IRS990/ForeignFinancialAccount0false
IRS990/ForeignOffice0false
IRS990/Form8282PropertyDisposedOf0false
IRS990/Form990PartVIISectionA/AverageHoursPerWeek01.00
IRS990/Form990PartVIISectionA/InstitutionalTrustee0X
IRS990/Form990PartVIISectionA/NameBusiness/BusinessNameLine10US BANK NA
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization016675
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/Title0CORP TRUSTEE
IRS990/Form990ProvidedToGoverningBody0false
IRS990/FormersListed0false
IRS990/FSAudited0false
IRS990/FundraisingActivities0false
IRS990/FundsToPayPremiums0false
IRS990/GainOrLoss/Securities05121
IRS990/Gaming0false
IRS990/Grants060319
IRS990/GrantsAndSimilarAmntsCY060319
IRS990/GrantsAndSimilarAmntsPriorYear059874
IRS990/GrantsToDomesticOrgs/ProgramServices060319
IRS990/GrantsToDomesticOrgs/Total060319
IRS990/GrantsToIndividuals0false
IRS990/GrantsToOrganizations0true
IRS990/GrantToRelatedPerson0false
IRS990/GrossAmountSalesAssets/Securities049121
IRS990/GrossReceipts079805
IRS990/GroupReturnForAffiliates0false
IRS990/Hospital0false
IRS990/IndependentAuditFinancialStmt0false
IRS990/IndoorTanningServices0false
IRS990/InfoInScheduleOPartVI0X
IRS990/InvestmentIncomeCurrentYear035805
IRS990/InvestmentIncomePriorYear077615
IRS990/InvestmentIncome/RelatedOrExemptFunctionIncome030684
IRS990/InvestmentIncome/TotalRevenueColumn030684
IRS990/InvestmentInJointVenture0false
IRS990/InvestmentsPubTradedSecurities/BOY01127540
IRS990/InvestmentsPubTradedSecurities/EOY01086209
IRS990/LessCostOthBasisSalesExpenses/Securities044000
IRS990/LoanToOfficerOrDQP0false
IRS990/LobbyingActivities0false
IRS990/LocalChapters0false
IRS990/MaterialDiversionOrMisuse0false
IRS990/MembersOrStockholders0false
IRS990/MethodOfAccountingCash0X
IRS990/MinutesOfCommittees0true
IRS990/MinutesOfGoverningBody0true
IRS990/MissionDescription0TO PROVIDE SCHOLARSHIPS FOR UNIVERSITY OF MICHIGAN OR UNIVERSITY OF MINNESOTA STUDENTS SELECTED BY THE MINNEAPOLIS FOUNDATION
IRS990/MoreThan5000KToIndividuals0false
IRS990/MoreThan5000KToOrganizations0false
IRS990/NbrIndependentVotingMembers00
IRS990/NbrVotingGoverningBodyMembers00
IRS990/NbrVotingMembersGoverningBody00
IRS990/NetAssetsOrFundBalancesBOY01261831
IRS990/NetAssetsOrFundBalancesEOY01219947
IRS990/NetGainOrLossInvestments/TotalRevenueColumn05121
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions0false
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp0false
IRS990/OfficerMailingAddress0false
IRS990/Organization501c30X
IRS990/OtherExpensePriorYear0840
IRS990/OtherExpensesCurrentYear0695
IRS990/OtherExpenses/Description0MN FILING FEE
IRS990/OtherExpenses/Description1FOREIGN TAXES PAID
IRS990/OtherExpenses/ManagementAndGeneral0670
IRS990/OtherExpenses/ProgramServices025
IRS990/OtherExpenses/Total025
IRS990/OtherExpenses/Total1670
IRS990/OtherRevenueCurrentYear00
IRS990/OtherRevenueMisc/Description0FILING FEE REFUND
IRS990/PartialLiquidation0false
IRS990/PoliticalActivities0false
IRS990/PremiumsPaid0false
IRS990/PriorExcessBenefitTransaction0false
IRS990/ProfessionalFundraising0false
IRS990/ProgramServiceRevenueCY00
IRS990/ProhibitedTaxShelterTrans0false
IRS990/QuidProQuoContributions0false
IRS990/ReconcilationRevenueExpenses0-41884
IRS990/RelatedEntity0false
IRS990/RelatedOrgControlledEntity0false
IRS990/ReportFin48Footnote0false
IRS990/ReportInvestOthSecurities0false
IRS990/ReportLandBldgEquip0false
IRS990/ReportOtherAssets0false
IRS990/ReportOtherLiabilities0false
IRS990/ReportProgRelInvest0false
IRS990/RetainedEarningsEndowmentEtc/BOY0705235
IRS990/RetainedEarningsEndowmentEtc/EOY0663351
IRS990/RevenuesLessExpensesCY0-41884
IRS990/RevenuesLessExpensesPriorYear01131
IRS990/SalariesEtcCurrentYear016675
IRS990/SalariesEtcPriorYear015770
IRS990/SavingsAndTempCashInvestments/BOY0130875
IRS990/SavingsAndTempCashInvestments/EOY0129308
IRS990ScheduleA/CertificationCheckbox0X
IRS990ScheduleA/ContribBy35ControlledEntity0false
IRS990ScheduleA/ContribByControllingIndividual0false
IRS990ScheduleA/ContributionByRelatedParty0false
IRS990ScheduleA/SumOfAmounts060319
IRS990ScheduleA/SupportedOrgInformation/Amount060319
IRS990ScheduleA/SupportedOrgInformation/EIN0416029402
IRS990ScheduleA/SupportedOrgInformation/ListedInGoverningDoc0true
IRS990ScheduleA/SupportedOrgInformation/Name/BusinessNameLine10MINNEAPOLIS FOUNDATION
IRS990ScheduleA/SupportedOrgInformation/OrganizedInUS0true
IRS990ScheduleA/SupportedOrgInformation/SupportedOrganizationNotified0true
IRS990ScheduleA/SupportedOrgInformation/TypeOfOrganization0501(c)3
IRS990ScheduleA/SupportingOrg509a3Type3NonFunc0X
IRS990ScheduleA/SupportingOrganization509a30X
IRS990ScheduleA/TotalNumberOfSupportedOrgs01
IRS990/ScheduleBRequired0false
IRS990ScheduleI/Form990ScheduleIPartIV/Explanation0THE MINNEAPOLIS FOUNDATION EXERCISES SOLE VOICE IN TIMING OF GRANTS, SELECTION OF GRANT RECIEPIENTS, AND GRANT PURPOSES, AND EXERCISED A VERY STRONG VOICE IN INVESTMENT MATTERS. THE FOUNDATION SETS THE ANNUAL PAYOUT PERCENTAGE AND MAY CHANGE THAT PAYOUT FROM TIME TO TIME AT THE FOUNDATION'S DESCRETION.
IRS990ScheduleI/Form990ScheduleIPartIV/Identifier0910
IRS990ScheduleI/Form990ScheduleIPartIV/ReturnReference0EXPLANATION FOR FORM 990, SCHEDULE I, PART 1, LINE 2
IRS990ScheduleI/RecipientTable/AddressUS/AddressLine10800 IDS CENTER 80 SOUTH EIGHTH ST
IRS990ScheduleI/RecipientTable/AddressUS/City0MINNEAPOLIS
IRS990ScheduleI/RecipientTable/AddressUS/State0MN
IRS990ScheduleI/RecipientTable/AddressUS/ZIPCode055402
IRS990ScheduleI/RecipientTable/AmountOfCashGrant060319
IRS990ScheduleI/RecipientTable/EINOfRecipient0416029402
IRS990ScheduleI/RecipientTable/IRCSection0501(c)3
IRS990ScheduleI/RecipientTable/RecipientNameBusiness/BusinessNameLine10THE MINNEAPOLIS FOUNDATION
IRS990ScheduleI/RecordsMaintained0true
IRS990/ScheduleJRequired0false
IRS990ScheduleO/GeneralExplanation/Explanation0NO REVIEW WAS OR WILL BE CONDUCTED
IRS990ScheduleO/GeneralExplanation/Explanation1THE FEE IS REVIEWED PERIODICALLY BY THE SOLE BENEFICIARY, THE MINNEAPOLIS FOUNDATION
IRS990ScheduleO/GeneralExplanation/Explanation2AVAILABLE UPON REQUEST
IRS990ScheduleO/GeneralExplanation/Identifier0FORM 990, PAGE 6, PART VI, LINE 11-DESCRIPTION OF PROCESS FOR REVIEW
IRS990ScheduleO/GeneralExplanation/Identifier1DESCRIPTION OF PROCESS FOR DETERMINING COMPENSATION
IRS990ScheduleO/GeneralExplanation/Identifier2DESCRIPTION FOR MAKING DOCUMENTS PUBLIC
IRS990ScheduleO/GeneralExplanation/ReturnReference0FORM 990, PAGE 6, PART VI, LINE 15a
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990, PAGE 6, PART VI, LINE 19
IRS990/ScheduleORequired0true
IRS990/School0false
IRS990/SignificantChange0false
IRS990/SignificantNewProgramServices0false
IRS990/StateLegalDomicile0MN
IRS990/StatesWhereCopyOfReturnIsFiled0MN
IRS990/TaxablePartyNotification0false
IRS990/TaxExemptBonds0false
IRS990/Terminated0false
IRS990/TermOrPermanentEndowments0false
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine10800 NICOLLET MALL
IRS990/TheBooksAreInCareOf/AddressUS/City0MINNEAPOLIS
IRS990/TheBooksAreInCareOf/AddressUS/State0MN
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode055402
IRS990/TheBooksAreInCareOf/NameBusiness/BusinessNameLine10US BANK NATIONAL ASSOCIATION
IRS990/TheBooksAreInCareOf/TelephoneNumber06123033208
IRS990/TotalAssets/BOY01261831
IRS990/TotalAssetsBOY01261831
IRS990/TotalAssets/EOY01219947
IRS990/TotalAssetsEOY01219947
IRS990/TotalCompGT150K0false
IRS990/TotalExpensesCurrentYear077689
IRS990/TotalExpensesPriorYear076484
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral013785
IRS990/TotalFunctionalExpenses/ProgramServices063904
IRS990/TotalFunctionalExpenses/Total077689
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY00
IRS990/TotalLiabilitiesBOY00
IRS990/TotalLiabilities/EOY00
IRS990/TotalLiabilitiesEOY00
IRS990/TotalLiabNetAssetsFundBalances/BOY01261831
IRS990/TotalLiabNetAssetsFundBalances/EOY01219947
IRS990/TotalNbrEmployees00
IRS990/TotalNetAssetsFundBalances/BOY01261831
IRS990/TotalNetAssetsFundBalances/EOY01219947
IRS990/TotalOtherCompensation00
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProgramServiceExpense063904
IRS990/TotalReportableCompFrmRltdOrgs00
IRS990/TotalReportableCompFromOrg016675
IRS990/TotalRevenueCurrentYear035805
IRS990/TotalRevenuePriorYear077615
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome030684
IRS990/TotalRevenue/TotalRevenueColumn035805
IRS990/TransfersToExemptNonChrtblOrg0false
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome0false
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy0false
IRS990/YearFormation01949
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0416015852
ReturnHeader/Filer/Name/BusinessNameLine10JOHN JUNELL TRUST UW 35072540
ReturnHeader/Filer/NameControl0JUNE
ReturnHeader/Filer/Phone06123033208
ReturnHeader/Filer/USAddress/AddressLine10P O BOX 64713 TRUST TAX SERVICES
ReturnHeader/Filer/USAddress/City0ST PAUL
ReturnHeader/Filer/USAddress/State0MN
ReturnHeader/Filer/USAddress/ZIPCode0551640713
ReturnHeader/Officer/DateSigned02013-05-03
ReturnHeader/Officer/Name0KAREN BASSETT
ReturnHeader/Officer/Phone06123033208
ReturnHeader/Officer/Title0CORP. TRUSTEE
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-06T12:14:21-06:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990Facts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
$1,219,947
Liabilities
$0
Net assets
$1,219,947
Revenue
-
Expenses
$77,689
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.25$0.00$1.25$0.05$0.09$0.04
2023Detailed filing. Detailed filing data is available for this year.$1.29$0.00$1.29$0.04$0.09$0.05
2022Detailed filing. Detailed filing data is available for this year.$1.34$0.00$1.34$0.06$0.10$0.04
2021Detailed filing. Detailed filing data is available for this year.$1.38$0.00$1.38$0.19$0.09$0.11
2020Detailed filing. Detailed filing data is available for this year.$1.27$0.00$1.27$0.04$0.09$0.05
2019Detailed filing. Detailed filing data is available for this year.$1.32$0.00$1.32$0.05$0.09$0.04
2018Detailed filing. Detailed filing data is available for this year.$1.35$0.00$1.35$0.10$0.10$0.00
2017Detailed filing. Detailed filing data is available for this year.$1.36$0.00$1.36$0.28$0.09$0.20
2016Detailed filing. Detailed filing data is available for this year.$1.16$0.00$1.16$0.04$0.09$0.05
2015Detailed filing. Detailed filing data is available for this year.$1.21$0.00$1.21$0.08$0.09$0.01
2014Summary only. Only limited summary data is available for this year.$1.22$0.00$0.11$0.09$0.02
2013Detailed filing. Detailed filing data is available for this year.$1.20$0.00$1.20$0.06$0.08$0.02
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.22$0.00$1.22$0.08
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.26$0.00$1.26$0.08
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$1.26$0.00$1.26$0.08