Civic Intelligence

John Junell Trust UW 35072540

990 • Fiscal year 2010 • EIN 41-6015852

Jan 01, 2010 to Dec 31, 2010 • Filed on Apr 29, 2011

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

11th percentile

0.00x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2010

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2010

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2010

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2010

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets11th percentile

Assets

$1,260,700

No earlier filing loaded for comparison.

Net Assets

$1,260,700

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

$78,254

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

2010

Assets$1,260,700
Liabilities$0
Net Assets$1,260,700
Open 2010 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

2010

Revenue-
Expenses$78,254
Net Income-
Open 2010 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2010 to Dec 31, 2010
Signed
Apr 29, 2011
Return Version
2010v3.2
Gross Receipts
$989,961
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 Appendix246 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/BOY01644
IRS990/AccountsReceivable/EOY0731
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/ChangesToOrganizingDocs0false
IRS990/CollectionsOfArt0false
IRS990/CompCurrentOfficersDirectors/Fundraising00
IRS990/CompCurrentOfficersDirectors/ManagementAndGeneral010337
IRS990/CompCurrentOfficersDirectors/ProgramServices02866
IRS990/CompCurrentOfficersDirectors/Total013203
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/Expense067281
IRS990/FamilyOrBusinessRelationship0false
IRS990/FederalGrantAuditRequired0false
IRS990/ForeignActivities0false
IRS990/ForeignFinancialAccount0false
IRS990/ForeignOffice0false
IRS990/Form8282PropertyDisposedOf0false
IRS990/Form990PartVIISectionA/AverageHoursPerWeek01
IRS990/Form990PartVIISectionA/InstitutionalTrustee0X
IRS990/Form990PartVIISectionA/NameBusiness/BusinessNameLine10US BANK NATIONAL ASSOCIATION
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization013203
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/Title0CORP TRUSTEE
IRS990/Form990ProvidedToGoverningBody0false
IRS990/FormersListed0false
IRS990/FSAudited0false
IRS990/FundraisingActivities0false
IRS990/FundsToPayPremiums0false
IRS990/GainOrLoss/Securities0-7531
IRS990/Gaming0false
IRS990/Grants064390
IRS990/GrantsAndSimilarAmntsCY064390
IRS990/GrantsAndSimilarAmntsPriorYear069961
IRS990/GrantsToDomesticOrgs/ProgramServices064390
IRS990/GrantsToDomesticOrgs/Total064390
IRS990/GrantsToIndividuals0false
IRS990/GrantsToOrganizations0true
IRS990/GrantToRelatedPerson0false
IRS990/GrossAmountSalesAssets/Securities0961169
IRS990/GrossReceipts0989961
IRS990/GroupReturnForAffiliates0false
IRS990/Hospital0false
IRS990/IndependentAuditFinancialStmt0false
IRS990/IndoorTanningServices0false
IRS990/InfoInScheduleOPartVI0X
IRS990/InvestmentIncomeCurrentYear021261
IRS990/InvestmentIncomePriorYear0-16195
IRS990/InvestmentIncome/RelatedOrExemptFunctionIncome028792
IRS990/InvestmentIncome/TotalRevenueColumn028792
IRS990/InvestmentInJointVenture0false
IRS990/InvestmentsPubTradedSecurities/BOY01305762
IRS990/InvestmentsPubTradedSecurities/EOY01213792
IRS990/LessCostOthBasisSalesExpenses/Securities0968700
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/NbrVotingGoverningBodyMembers01
IRS990/NbrVotingMembersGoverningBody01
IRS990/NetAssetsOrFundBalancesBOY01317693
IRS990/NetAssetsOrFundBalancesEOY01260700
IRS990/NetGainOrLossInvestments/TotalRevenueColumn0-7531
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions0false
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp0false
IRS990/OfficerMailingAddress0false
IRS990/Organization501c30X
IRS990/OtherExpensePriorYear01356
IRS990/OtherExpensesCurrentYear0661
IRS990/OtherExpenses/Description0MN FILING FEE
IRS990/OtherExpenses/Description1FOREIGN TAXES PAID
IRS990/OtherExpenses/ManagementAndGeneral0636
IRS990/OtherExpenses/ProgramServices025
IRS990/OtherExpenses/Total025
IRS990/OtherExpenses/Total1636
IRS990/OtherLiabilities/BOY0463
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-56993
IRS990/RelatedEntity0false
IRS990/RelatedOrgControlledEntity0false
IRS990/ReportFin48Footnote0false
IRS990/ReportInvestOthSecurities0false
IRS990/ReportLandBldgEquip0false
IRS990/ReportOtherAssets0false
IRS990/ReportOtherLiabilities0false
IRS990/ReportProgRelInvest0false
IRS990/RetainedEarningsEndowmentEtc/BOY0761097
IRS990/RetainedEarningsEndowmentEtc/EOY0704104
IRS990/RevenuesLessExpensesCY0-56993
IRS990/RevenuesLessExpensesPriorYear0-97538
IRS990/SalariesEtcCurrentYear013203
IRS990/SalariesEtcPriorYear010026
IRS990/SavingsAndTempCashInvestments/BOY010750
IRS990/SavingsAndTempCashInvestments/EOY046177
IRS990ScheduleA/CertificationCheckbox0X
IRS990ScheduleA/ContribBy35ControlledEntity0false
IRS990ScheduleA/ContribByControllingIndividual0false
IRS990ScheduleA/ContributionByRelatedParty0false
IRS990ScheduleA/SumOfAmounts064390
IRS990ScheduleA/SupportedOrgInformation/Amount064390
IRS990ScheduleA/SupportedOrgInformation/EIN0416029402
IRS990ScheduleA/SupportedOrgInformation/ListedInGoverningDoc0true
IRS990ScheduleA/SupportedOrgInformation/Name/BusinessNameLine10MINNEAPOLIS FOUNDATION
IRS990ScheduleA/SupportedOrgInformation/OrganizedInUS0true
IRS990ScheduleA/SupportedOrgInformation/SupportedOrganizationNotified0true
IRS990ScheduleA/SupportedOrgInformation/TypeOfOrganization0501(c)3
IRS990ScheduleA/SupportingOrg509a3Type3Other0X
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/NoGrantMoreThan50000X
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/BOY01318156
IRS990/TotalAssetsBOY01318156
IRS990/TotalAssets/EOY01260700
IRS990/TotalAssetsEOY01260700
IRS990/TotalCompGT150K0false
IRS990/TotalExpensesCurrentYear078254
IRS990/TotalExpensesPriorYear081343
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral010973
IRS990/TotalFunctionalExpenses/ProgramServices067281
IRS990/TotalFunctionalExpenses/Total078254
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY0463
IRS990/TotalLiabilitiesBOY0463
IRS990/TotalLiabilities/EOY00
IRS990/TotalLiabilitiesEOY00
IRS990/TotalLiabNetAssetsFundBalances/BOY01318156
IRS990/TotalLiabNetAssetsFundBalances/EOY01260700
IRS990/TotalNbrEmployees00
IRS990/TotalNetAssetsFundBalances/BOY01317693
IRS990/TotalNetAssetsFundBalances/EOY01260700
IRS990/TotalOtherCompensation00
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProgramServiceExpense067281
IRS990/TotalReportableCompFrmRltdOrgs00
IRS990/TotalReportableCompFromOrg013203
IRS990/TotalRevenueCurrentYear021261
IRS990/TotalRevenuePriorYear0-16195
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome028792
IRS990/TotalRevenue/TotalRevenueColumn021261
IRS990/TransactionRelatedEntity0false
IRS990/TransfersToExemptNonChrtblOrg0false
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome0false
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy0false
IRS990/YearFormation01949
ReturnHeader/BuildTS02016-02-24 21:20:13Z
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/DateSigned02011-04-29
ReturnHeader/Officer/Name0KAREN BASSETT
ReturnHeader/Officer/Phone06123033208
ReturnHeader/Officer/Title0CORP. TRUSTEE
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02010-01-01
ReturnHeader/TaxPeriodEndDate02010-12-31
ReturnHeader/TaxYear02010
ReturnHeader/Timestamp02009-10-15T15:15:33+05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,260,700
Liabilities
$0
Net assets
$1,260,700
Revenue
-
Expenses
$78,254
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