Civic Intelligence

The John Katie Hansen Family Foundation

EIN 20-3454511 • San Francisco, CA

Pub. 78 Eligible
2261 Market St Ste 10357San Francisco, CA 94114
Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

24th percentile

0.00x

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

$5M-$10M nonprofits • Source year 2024

Liabilities / Revenue

25th percentile

0.00x

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

$5M-$10M nonprofits • Source year 2024

Net Margin

7th percentile

-58%

Higher net margin than 7% of similar nonprofits.

$5M-$10M nonprofits • Source year 2024

Top Officer Pay

33rd percentile

$0

Higher top officer pay than 33% of similar nonprofits.

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

$5M-$10M nonprofits • Source year 2024

Asset Growth

24th percentile

-2.7%

Faster asset growth than 24% of similar nonprofits.

$5M-$10M nonprofits • Annualized from 2023 to 2024

Revenue Growth

88th percentile

108%

Faster revenue growth than 88% of similar nonprofits.

$5M-$10M nonprofits • Annualized from 2023 to 2024

Assets

Down

$7,279,311

Down $204,263 (-2.7%) from 2023

Liabilities

Flat

$0

Flat from 2023

Net Assets

Down

$7,279,311

Down $204,263 (-2.7%) from 2023

Revenue

Up

$350,037

Up $181,966 (+108%) from 2023

Expenses

Up

$554,300

Up $320,546 (+137%) from 2023

Net Income

Down

-$204,263

Down $138,580 (-211%) from 2023

Trend Graphs

Balance Sheet Trend

Grouped bars show assets, liabilities, and net assets across loaded filings.

$8.0M$6.0M$4.0M$2.0M$0Assets 2011: $6,124,158Liabilities 2011: $02011Assets 2012: $6,760,876Liabilities 2012: $02012Assets 2013: $5,943,865Liabilities 2013: $02013Assets 2014: $5,506,574Liabilities 2014: $0Net Assets 2014: $5,506,5742014Assets 2015: $5,768,628Liabilities 2015: $0Net Assets 2015: $5,768,6282015Assets 2016: $5,768,385Liabilities 2016: $0Net Assets 2016: $5,768,3852016Assets 2017: $6,757,075Liabilities 2017: $0Net Assets 2017: $6,757,0752017Assets 2018: $6,037,405Liabilities 2018: $0Net Assets 2018: $6,037,4052018Assets 2019: $6,583,151Liabilities 2019: $0Net Assets 2019: $6,583,1512019Assets 2020: $7,262,390Liabilities 2020: $1Net Assets 2020: $7,262,3892020Assets 2021: $7,578,812Liabilities 2021: $0Net Assets 2021: $7,578,8122021Assets 2022: $7,549,257Liabilities 2022: $0Net Assets 2022: $7,549,2572022Assets 2023: $7,483,574Liabilities 2023: $0Net Assets 2023: $7,483,5742023Assets 2024: $7,279,311Liabilities 2024: $0Net Assets 2024: $7,279,3112024

Highlighted filing

2024

Assets$7,279,311
Liabilities$0
Net Assets$7,279,311

Operations Trend

Revenue, expenses, and net income by year, with the latest filing highlighted.

$2.0M$1.0M$0-$1.0M-$2.0MRevenue 2011: $562,134Expenses 2011: $739,341Net Income 2011: -$177,2072011Revenue 2012: $1,131,243Expenses 2012: $1,195,188Net Income 2012: -$63,9452012Revenue 2013: $335,377Expenses 2013: $1,621,693Net Income 2013: -$1,286,3162013Revenue 2014: $705,049Expenses 2014: $1,080,761Net Income 2014: -$375,7122014Revenue 2015: $492,501Expenses 2015: $513,941Net Income 2015: -$21,4402015Revenue 2016: $685,133Expenses 2016: $481,689Net Income 2016: $203,4442016Revenue 2017: $391,701Expenses 2017: $211,030Net Income 2017: $180,6712017Revenue 2018: $587,446Expenses 2018: $516,031Net Income 2018: $71,4152018Revenue 2019: $377,566Expenses 2019: $622,875Net Income 2019: -$245,3092019Revenue 2020: $656,908Expenses 2020: $856,222Net Income 2020: -$199,3142020Revenue 2021: $950,049Expenses 2021: $538,411Net Income 2021: $411,6382021Revenue 2022: $250,472Expenses 2022: $280,027Net Income 2022: -$29,5552022Revenue 2023: $168,071Expenses 2023: $233,754Net Income 2023: -$65,6832023Revenue 2024: $350,037Expenses 2024: $554,300Net Income 2024: -$204,2632024

Highlighted filing

2024

Revenue$350,037
Expenses$554,300
Net Income-$204,263

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$7.28$0.00$7.28$0.35$0.55$0.20
2023Detailed filing. Detailed filing data is available for this year.$7.48$0.00$7.48$0.17$0.23$0.07
2022Detailed filing. Detailed filing data is available for this year.$7.55$0.00$7.55$0.25$0.28$0.03
2021Detailed filing. Detailed filing data is available for this year.$7.58$0.00$7.58$0.95$0.54$0.41
2020Detailed filing. Detailed filing data is available for this year.$7.26$0.00$7.26$0.66$0.86$0.20
2019Detailed filing. Detailed filing data is available for this year.$6.58$0.00$6.58$0.38$0.62$0.25
2018Detailed filing. Detailed filing data is available for this year.$6.04$0.00$6.04$0.59$0.52$0.07
2017Detailed filing. Detailed filing data is available for this year.$6.76$0.00$6.76$0.39$0.21$0.18
2016Detailed filing. Detailed filing data is available for this year.$5.77$0.00$5.77$0.69$0.48$0.20
2015Detailed filing. Detailed filing data is available for this year.$5.77$0.00$5.77$0.49$0.51$0.02
2014Detailed filing. Detailed filing data is available for this year.$5.51$0.00$5.51$0.71$1.08$0.38
2013Summary only. Only limited summary data is available for this year.$5.94$0.00$0.34$1.62$1.29
2012Summary only. Only limited summary data is available for this year.$6.76$0.00$1.13$1.20$0.06
2011Summary only. Only limited summary data is available for this year.$6.12$0.00$0.56$0.74$0.18
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2024 to Dec 31, 2024
Signed
Nov 17, 2025
Return Version
2024v5.2
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
KATIE VOGELHEIMPresidentFT$0--
JOHN HANSENVice PresidentPT$0--
JOHN BARRETT HANSENDirectorPT$0--
Filing and Contact Details

Filer

Filer Name
The John and Katie Hansen Family
EIN
20-3454511
Phone
4153640300
Address
2261 MARKET ST STE 10357, SAN FRANCISCO, CA 94114

Signing Officer

Name
Katie Vogelheim
Title
President
Signed
2025-11-17
Discuss with paid preparer
Yes

Preparer

Firm
Underwood & Roberts PLLC
Address
3110 Edwards Mill Rd Ste 300, Raleigh, NC 27612
Preparer
Suzanne M Plunket
Phone
9196648803
Raw XML Appendix305 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
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionAmt0244522
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/RelatedOrExemptFunctionIncmAmt0105515
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt0244522
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt0105515
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt0350037
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt0254918
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt0105515
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt0510053
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt0510053
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsAdjNetIncmAmt0244522
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt0244522
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt0244522
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-204263
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0617634
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt0105515
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt0350037
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt054643
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesAdjNetIncmAmt041953
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt041953
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesAdjNetIncmAmt02294
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt02294
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt0299165
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt044247
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt0510053
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0554300
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt0350037
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt0350037
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt044247
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt044247
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02023-08-23
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12024-01-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22010-03-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0110406
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt1385066
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt216647
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt06594
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt154643
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt244278
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt06594
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt154643
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt244278
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0117000
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt1439709
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt260925
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd2P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0BMO BANK - 1010 S/T COVERED
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1BMO BANK - 1010 L/T COVERED
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2BMO BANK - 1010 L/T NONCOVERED
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02024-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12024-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22024-12-31
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt0105515
IRS990PF/CapGainsLossTxInvstIncmDetail/NetShortTermCapitalGainLossAmt054643
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-204263
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt07279311
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt07483574
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt07279311
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt04866
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt04866
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt04866
IRS990PF/DistributableAmountGrp/TotalTaxAmt04866
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0134
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt05000
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt04866
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0134
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt04866
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt04866
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt05000
IRS990PF/FMVAssetsEOYAmt07279311
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYAmt01
IRS990PF/Form990PFBalanceSheetsGrp/OtherAssetsEOYFMVAmt01
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt07300215
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt07104581
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt07104581
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt07483574
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt07279311
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0183359
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0174729
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0174729
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt07483574
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt07279311
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt07279311
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt07483574
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt07279311
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt07483574
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt07279311
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt00
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt00
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt00
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt040.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt125.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt225.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0KATIE VOGELHEIM
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1JOHN HANSEN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2JOHN BARRETT HANSEN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0President
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1Vice President
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2Director
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt02261 MARKET ST STE 10357
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt12261 MARKET ST STE 10357
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt22261 MARKET ST STE 10357
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0SAN FRANCISCO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1SAN FRANCISCO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2SAN FRANCISCO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0CA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1CA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2CA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd094114
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd194114
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd294114
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt0510053
IRS990PF/PFQualifyingDistributionsGrp/QualifyingDistributionsAmt0510053
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/AddressLine1Txt02261 MARKET ST STE 10357
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0SAN FRANCISCO
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0CA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd094114
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0CA
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd1DE
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0KATIE VOGELHEIM
IRS990PF/StatementsRegardingActyGrp/PhoneNum04153640305
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt010000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt1310000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt2175000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt310000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt42053
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt53000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0FINANCIAL AID
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1GENERAL PURPOSES
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2GENERAL PURPOSE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3General Purpose Fund
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4GENERAL PURPOSE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt5GENERAL PURPOSE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PUBLIC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1501(C)(3)
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PUBLIC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt4PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt5PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0LOYOLA UNIVERSITY OF CHICAGO
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm1CONSERVATION INTERNATIONAL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm2HARVARD SCHOOL OF PUBLIC HEALTH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm3FRIENDS OF PAULISTS FATHERS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm4Dana Farber Cancer Research
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm5EAST BAY GERMAN INTERNATIONAL SCHOO
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1DONEE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2DONEE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3DONEE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt4DONEE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt5recipient
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0820 N MICHIGAN AVENUE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt12100 CRYSTAL DRIVE 500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt2677 HUNTINGTON AVENUE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt3415 W 59TH STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt4450 Brookline Ave
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt51070 41ST ST
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0CHICAGO
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1ARLINGTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2BOSTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3NEW YORK
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4BOSTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm5EMERYVILLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1VA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2MA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd4MA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd5CA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd060611
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd122202
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd202115
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd310019
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd402215
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd594608
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt0510053
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/DistributableAsAdjustedAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt0191027
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt0236084
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt0129976
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt0497508
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt0308996
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt0308996
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt01564648
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt0510053
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt0191027
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt0236084
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt0129976
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt0497508
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt0510053
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt0510053
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt01873644
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt01363591
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt0164
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt141389
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt2400
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0BANK SERVICE CHARGES
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1INVESTMENT MANAGEMENT FEES
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2Postage and Delivery
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0164
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt141389
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt2400
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt02294
TaxesSchedule/TaxesDetail/Amt02294
TaxesSchedule/TaxesDetail/CategoryTxt0taxes
ReturnHeader/BuildTS02025-03-06 01:10:19Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0KATIE VOGELHEIM
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/SignatureDt02025-11-17
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0THE JOHN AND KATIE HANSEN FAMILY
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0JOHN
ReturnHeader/Filer/EIN0203454511
ReturnHeader/Filer/PhoneNum04153640300
ReturnHeader/Filer/USAddress/AddressLine1Txt02261 MARKET ST STE 10357
ReturnHeader/Filer/USAddress/CityNm0SAN FRANCISCO
ReturnHeader/Filer/USAddress/StateAbbreviationCd0CA
ReturnHeader/Filer/USAddress/ZIPCd094114
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0030490995
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Underwood & Roberts PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt03110 Edwards Mill Rd Ste 300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Raleigh
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0NC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd027612
ReturnHeader/PreparerPersonGrp/PhoneNum09196648803
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Suzanne M Plunket
ReturnHeader/ReturnTs02025-11-17T09:59:43-08:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02024-01-01
ReturnHeader/TaxPeriodEndDt02024-12-31
ReturnHeader/TaxYr02024

Document Assets

No mirrored PDF or thumbnail assets are attached yet.