FURP.ORG / PUBLIC DATA EXPLORER

HANSEN FAMILY FOUNDATION: Form 990PF, tax year 2012

View the entire original 990 at ProPublica ↗

Organization
HANSEN FAMILY FOUNDATION (EIN 41-1740710)
Tax period
2012-01-01 to 2012-12-31
Filed
2013-05-10
IRS object ID
201311309349100506
Schema version
2012v2.1
Source
Download XML · Original 990 at ProPublica

Every field in the e-filed return. Faint text is the IRS element name, for citing.

Return header ReturnHeader

FieldValueIRS element (for citing)
Timestamp2013-05-10T08:47:27-05:00Timestamp
Tax Period End Date2012-12-31TaxPeriodEndDate

Preparer Firm PreparerFirm

FieldValueIRS element (for citing)
EIN390859910EIN

Preparer Firm Business Name PreparerFirmBusinessName

FieldValueIRS element (for citing)
Business Name Line1Baker Tilly Virchow Krause LLPBusinessNameLine1

Preparer Firm US Address PreparerFirmUSAddress

FieldValueIRS element (for citing)
Address Line1225 S 6th St Ste 2300AddressLine1
CityMinneapolisCity
StateMNState
ZIP Code55402ZIPCode
FieldValueIRS element (for citing)
Return Type990PFReturnType
Tax Period Begin Date2012-01-01TaxPeriodBeginDate

Filer Filer

FieldValueIRS element (for citing)
EIN411740710EIN

Name Name

FieldValueIRS element (for citing)
Business Name Line1Hansen Family FoundationBusinessNameLine1
FieldValueIRS element (for citing)
Name ControlHANSNameControl
Phone9529129895Phone

US Address USAddress

FieldValueIRS element (for citing)
Address Line115413 Milan WayAddressLine1
CityNaplesCity
StateFLState
ZIP Code34110ZIPCode

Officer Officer

FieldValueIRS element (for citing)
NameHARVEY HANSENName
TitleTRUSTEETitle
Phone9529129895Phone
Date Signed2013-05-08DateSigned
Authorize Third Party1AuthorizeThirdParty

Preparer Preparer

FieldValueIRS element (for citing)
NameTherese M Nelson CPAName
PTINP00035774PTIN
Phone6128764500Phone
FieldValueIRS element (for citing)
Tax Year2012TaxYear
Build TS2016-02-24 21:20:13ZBuildTS

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Exempt PFXExemptPF
FMV Assets EOY3779445FMVAssetsEOY
Method Of Accounting CashXMethodOfAccountingCash

Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses

FieldValueIRS element (for citing)
Not Required To Attach Schedule BXNotRequiredToAttachScheduleB
Dividends Rev And Expnss83894DividendsRevAndExpnss
Dividends Net Invst Incm83894DividendsNetInvstIncm
Net Gain Sale Assets Rev And Expnss141032NetGainSaleAssetsRevAndExpnss
Gross Sales Price1560592GrossSalesPrice
Capital Gain Net Incm Net Invst Incm141032CapitalGainNetIncmNetInvstIncm
Total Revenue And Expenses224926TotalRevenueAndExpenses
Total Net Investment Income224926TotalNetInvestmentIncome
Comp Ofcr Dir Trst Rev And Expnss0CompOfcrDirTrstRevAndExpnss
Comp Ofcr Dir Trst Net Invst Incm0CompOfcrDirTrstNetInvstIncm
Comp Ofcr Dir Trst Dsbrs Chrtbl Prps0CompOfcrDirTrstDsbrsChrtblPrps
Accounting Fees Rev And Expnss10300AccountingFeesRevAndExpnss
Accounting Fees Net Invst Incm0AccountingFeesNetInvstIncm
Accounting Fees Dsbrs Chrtbl Prps10300AccountingFeesDsbrsChrtblPrps
Other Prof Fees Rev And Expnss51382OtherProfFeesRevAndExpnss
Other Prof Fees Net Invst Incm51382OtherProfFeesNetInvstIncm
Other Prof Fees Dsbrs Chrtbl Prps0OtherProfFeesDsbrsChrtblPrps
Taxes Rev And Expnss2816TaxesRevAndExpnss
Taxes Net Invst Incm1198TaxesNetInvstIncm
Taxes Dsbrs Chrtbl Prps25TaxesDsbrsChrtblPrps
Tot Opr Expenses Rev And Expnss64498TotOprExpensesRevAndExpnss
Tot Opr Expenses Net Invst Incm52580TotOprExpensesNetInvstIncm
Tot Opr Expenses Dsbrs Chrtbl Prps10325TotOprExpensesDsbrsChrtblPrps
Contri Gifts Paid Rev And Expnss164200ContriGiftsPaidRevAndExpnss
Contri Gifts Paid Dsbrs Chrtbl Prps164200ContriGiftsPaidDsbrsChrtblPrps
Total Expenses Rev And Expnss228698TotalExpensesRevAndExpnss
Total Expenses Net Invst Incm52580TotalExpensesNetInvstIncm
Total Expenses Dsbrs Chrtbl Prps174525TotalExpensesDsbrsChrtblPrps
Excess Of Revenue Over Expenses-3772ExcessOfRevenueOverExpenses
Net Investment Income172346NetInvestmentIncome

Balance Sheets BalanceSheets

FieldValueIRS element (for citing)
Cash BOY594184CashBOY
Cash EOY211431CashEOY
Cash EOYFMV211431CashEOYFMV
Investments Other BOY2762610InvestmentsOtherBOY
Investments Other EOY3141591InvestmentsOtherEOY
Investments Other EOYFMV3568014InvestmentsOtherEOYFMV
Total Assets BOY3356794TotalAssetsBOY
Total Assets EOY3353022TotalAssetsEOY
Total Assets EOYFMV3779445TotalAssetsEOYFMV
Total Liabilities BOY0TotalLiabilitiesBOY
Total Liabilities EOY0TotalLiabilitiesEOY
Org That Do Not Follow SFAS117XOrgThatDoNotFollowSFAS117
Capital Stock BOY0CapitalStockBOY
Capital Stock EOY0CapitalStockEOY
Paid In Or Capital Surplus BOY0PaidInOrCapitalSurplusBOY
Paid In Or Capital Surplus EOY0PaidInOrCapitalSurplusEOY
Retained Earnings BOY3356794RetainedEarningsBOY
Retained Earnings EOY3353022RetainedEarningsEOY
Total Net Assets BOY3356794TotalNetAssetsBOY
Total Net Assets EOY3353022TotalNetAssetsEOY
Total Liabilities Net Assets BOY3356794TotalLiabilitiesNetAssetsBOY
Total Liabilities Net Assets EOY3353022TotalLiabilitiesNetAssetsEOY

Changes In Net Assets Fund Balances ChangesInNetAssetsFundBalances

FieldValueIRS element (for citing)
Total Net Assets Fund Balances BOY3356794TotalNetAssetsFundBalancesBOY
Excess Of Revenue Over Expenses-3772ExcessOfRevenueOverExpenses
Other Increases0OtherIncreases
Subtotal3353022Subtotal
Other Decreases0OtherDecreases
Total Net Assets Fund Balances EOY3353022TotalNetAssetsFundBalancesEOY

Capital Gains And Losses CapitalGainsAndLosses

Capital Gains And Losses Info CapitalGainsAndLossesInfo (5 entries)

Description Of AssetDescriptionOfAssetHow AcquiredHowAcquiredGross Sales PriceGrossSalesPriceCost Or Other BasisCostOrOtherBasisGain Or LossGainOrLossGains Minus Excess Or LossesGainsMinusExcessOrLosses
FIDELITY SHORT TERM GAINP9776209612511636916369
FIDELITY LONG TERM GAINP565057456537108520108520
FIDELITY CASH IN LIEUP130130130
FIDELITY RETURN OF PRINCIPALP20511772279279
Capital Gains DividendsP157341573415734
FieldValueIRS element (for citing)
Capital Gain Net Income141032CapitalGainNetIncome

Qlfy Und Sect4940e For Reduced Tax QlfyUndSect4940eForReducedTax

FieldValueIRS element (for citing)
Liable For4942 Tax0LiableFor4942Tax
Qualifying Distributions Year1164600QualifyingDistributionsYear1
Noncharitable Assets Year13714211NoncharitableAssetsYear1
Distribution Ratio Year10.044316DistributionRatioYear1
Qualifying Distributions Year2160314QualifyingDistributionsYear2
Noncharitable Assets Year23479142NoncharitableAssetsYear2
Distribution Ratio Year20.046079DistributionRatioYear2
Qualifying Distributions Year3221649QualifyingDistributionsYear3
Noncharitable Assets Year33163686NoncharitableAssetsYear3
Distribution Ratio Year30.070060DistributionRatioYear3
Qualifying Distributions Year4222139QualifyingDistributionsYear4
Noncharitable Assets Year44136956NoncharitableAssetsYear4
Distribution Ratio Year40.053696DistributionRatioYear4
Qualifying Distributions Year5221175QualifyingDistributionsYear5
Noncharitable Assets Year54976894NoncharitableAssetsYear5
Distribution Ratio Year50.044440DistributionRatioYear5
Total Distribution Ratio0.258591TotalDistributionRatio
Average Distribution Ratio0.051718AverageDistributionRatio
Net Noncharitable Assets3678273NetNoncharitableAssets
Adjusted Noncharitable Assets190233AdjustedNoncharitableAssets
One Percent Net Investment Income1723OnePercentNetInvestmentIncome
Adj Nonchrtbl Assets And One191956AdjNonchrtblAssetsAndOnePct
Qualifying Distributions174525QualifyingDistributions

Excise Tax Based On Investment Incm ExciseTaxBasedOnInvestmentIncm

FieldValueIRS element (for citing)
Investment Income Excise Tax3447InvestmentIncomeExciseTax
Tax Under Section5110TaxUnderSection511
Subtotal3447Subtotal
Subtitle A Tax0SubtitleATax
Tax Based On Investment Income3447TaxBasedOnInvestmentIncome
Est Tax Payments And Overpayment1200EstTaxPaymentsAndOverpayment
Total Credits And Payments1200TotalCreditsAndPayments
Form2220 AttachedXForm2220Attached
Tax Due2247TaxDue

Statements Regarding Activities StatementsRegardingActivities

FieldValueIRS element (for citing)
Legislative Political Activities0LegislativePoliticalActivities
More Than100 Spent0MoreThan100Spent
Form1120 POL Filed0Form1120POLFiled
Sect4955 Tax On Organization0Sect4955TaxOnOrganization
Sect4955 Tax On Managers0Sect4955TaxOnManagers
Reimbursement Of Tax0ReimbursementOfTax
Activities Not Prev Reported0ActivitiesNotPrevReported
Changes To Articles Or Bylaws0ChangesToArticlesOrBylaws
Unrelated Bus Income Over10000UnrelatedBusIncomeOver1000
Termination Etc0TerminationEtc
Requirements Of Sect508e1RequirementsOfSect508e
At Least5000 In Assets1AtLeast5000InAssets
States Filed WithMNStatesFiledWith
Form990 PF Filed With AG1Form990PFFiledWithAG
Private Operating Foundation0PrivateOperatingFoundation
New Substantial Contributors0NewSubstantialContributors
Interest In Controlled Entity0InterestInControlledEntity
Applicable Insurance Contract0ApplicableInsuranceContract
Comply With Public Inspection Rqr1ComplyWithPublicInspectionRqr
Website AddressN/AWebsiteAddress
Books In Care Of Person NameHARVEY C HANSEN TRUSTEEBooksInCareOfPersonName
Books In Care Of Phone Number9529129895BooksInCareOfPhoneNumber

Books In Care Of US Address BooksInCareOfUSAddress

FieldValueIRS element (for citing)
Address Line115413 MILAN WAYAddressLine1
CityNAPLESCity
StateFLState
ZIP Code34110ZIPCode
FieldValueIRS element (for citing)
Foreign Bank0ForeignBank

Statements Regarding Acty4720 StatementsRegardingActy4720

FieldValueIRS element (for citing)
Sale Or Exchange With Dsqfly Person0SaleOrExchangeWithDsqflyPerson
Borrow Or Lend With Dsqfly Person0BorrowOrLendWithDsqflyPerson
Furnished Goods With Dsqfly Person0FurnishedGoodsWithDsqflyPerson
Pay Compensation To Dsqfly Person0PayCompensationToDsqflyPerson
Transfer Assets To Dsqfly Person0TransferAssetsToDsqflyPerson
Payment To Government Offical0PaymentToGovernmentOffical
Uncorrected Prior Acts0UncorrectedPriorActs
Undistributed Income Prior Years0UndistributedIncomePriorYears
Business Holdings0BusinessHoldings
Jeopardy Investments0JeopardyInvestments
Uncorrected Jeopardy Investments0UncorrectedJeopardyInvestments
Influence Legislation0InfluenceLegislation
Influence Election0InfluenceElection
Grants To Individuals0GrantsToIndividuals
Grants To Organizations0GrantsToOrganizations
Noncharitable Purpose0NoncharitablePurpose
Rcv Funds To Pay Prsnl Bnft Contract0RcvFundsToPayPrsnlBnftContract
Pay Premiums Prsnl Bnft Contract0PayPremiumsPrsnlBnftContract
Prohibited Tax Shelter Transactn0ProhibitedTaxShelterTransactn

Ofcr Dir Trustees Key Employee Info OfcrDirTrusteesKeyEmployeeInfo

Ofcr Dir Trustees Or Key Employee OfcrDirTrusteesOrKeyEmployee (3 entries)

Address Line1USAddress/AddressLine1CityUSAddress/CityStateUSAddress/StateZIP CodeUSAddress/ZIPCodeTitleTitleAvg Hours Per Wk Devoted To PositionAvgHoursPerWkDevotedToPositionCompensationCompensationContri To Empl Benefit Plans EtcContriToEmplBenefitPlansEtcExpense Account Other AllowancesExpenseAccountOtherAllowances
HARVEY C HANSEN
15413 MILAN WAYNAPLESFL34110TRUSTEE0.00000
CARL M HANSEN
4960 LINCOLN DRIVEEDINAMN55436TRUSTEE0.00000
KELSEY L PIQUETTE
4505 GILFORD DRIVEEDINAMN55435TRUSTEE0.00000
FieldValueIRS element (for citing)
Comp Of Highest Paid Empl NONENONECompOfHighestPaidEmplNONE
Tot Number Of Oth Empl Paid Over50k0TotNumberOfOthEmplPaidOver50k
Comp Of Hghst Paid Cntrct NONENONECompOfHghstPaidCntrctNONE
Tot Number Of Cntrct Paid Over50k0TotNumberOfCntrctPaidOver50k

Sum Of Program Related Investments SumOfProgramRelatedInvestments

FieldValueIRS element (for citing)
Total0Total

Minimum Investment Return MinimumInvestmentReturn

FieldValueIRS element (for citing)
Avg Monthly FMV Of Securities3534827AvgMonthlyFMVOfSecurities
Avg Monthly Cash Balances199460AvgMonthlyCashBalances
FMV All Other Noncharitable Assets0FMVAllOtherNoncharitableAssets
Total FMV Of Unused Assets3734287TotalFMVOfUnusedAssets
Reduction Claimed0ReductionClaimed
Acquisition Indebtedness0AcquisitionIndebtedness
Adj Total FMV Of Unused Assets3734287AdjTotalFMVOfUnusedAssets
Cash Deemed Charitable56014CashDeemedCharitable
Net Noncharitable Assets3678273NetNoncharitableAssets
Minimum Investment Return183914MinimumInvestmentReturn

Distributable DistributableAmount

FieldValueIRS element (for citing)
Minimum Investment Return183914MinimumInvestmentReturn
Tax Based On Investment Income3447TaxBasedOnInvestmentIncome
Total Tax3447TotalTax
Distributable Amount Before Adj180467DistributableAmountBeforeAdj
Recoveries Qlfy Distributions0RecoveriesQlfyDistributions
Distributable Amount Before Ded180467DistributableAmountBeforeDed
Deduction Fr Distributable$0DeductionFrDistributableAmount
Distributable Amount As Adjusted180467DistributableAmountAsAdjusted

Qualifying Distributions QualifyingDistributions

FieldValueIRS element (for citing)
Expenses And Contributions174525ExpensesAndContributions
Program Related Investments Total0ProgramRelatedInvestmentsTotal
Qualifying Distributions174525QualifyingDistributions
One Pct Sect4940e Org Net Invst Incm0OnePctSect4940eOrgNetInvstIncm
Adj Qualifying Distributions174525AdjQualifyingDistributions

Undistributed Income UndistributedIncome

FieldValueIRS element (for citing)
Distributable Amount As Adjusted180467DistributableAmountAsAdjusted
Undistributed Income Prior Year173833UndistributedIncomePriorYear
Total For Prior Years0TotalForPriorYears
Total Excess Distri Carryover0TotalExcessDistriCarryover
Qualifying Distributions174525QualifyingDistributions
Applied To Year1173833AppliedToYear1
Applied To Prior Years0AppliedToPriorYears
Treated As Distri From Corpus0TreatedAsDistriFromCorpus
Applied To Current Year692AppliedToCurrentYear
Remaining Distri From Corpus0RemainingDistriFromCorpus
Excess Distri Cyov App CY Corpus0ExcessDistriCyovAppCYCorpus
Excess Distri Cyov Applied CY0ExcessDistriCyovAppliedCY
Total Corpus0TotalCorpus
Prior Year Undistributed Income0PriorYearUndistributedIncome
Prior Year Deficiency Or Tax0PriorYearDeficiencyOrTax
Taxable Amount10TaxableAmount1
Taxable Amount20TaxableAmount2
Undistributed Income CY179775UndistributedIncomeCY
Distri From Corpus170b1 E Or4942g30DistriFromCorpus170b1EOr4942g3
Excess Distri Cyov From Year50ExcessDistriCyovFromYear5
Excess Distri Cyov To Next Year0ExcessDistriCyovToNextYear

Supplementary Information SupplementaryInformation

FieldValueIRS element (for citing)
Only Contributes To PreselectedXOnlyContributesToPreselected

Grant Or Contri Paid During Year GrantOrContriPaidDuringYear (14 entries)

Address Line1RecipientUSAddress/AddressLine1CityRecipientUSAddress/CityStateRecipientUSAddress/StateZIP CodeRecipientUSAddress/ZIPCodeRecipient RelationshipRecipientRelationshipRecipient Foundation StatusRecipientFoundationStatusPurpose Of Grant Or ContributionPurposeOfGrantOrContributionAmountAmount
BENHILDE MARGARETS SCHOOL
2501 HWY 100 SOST LOUIS PARKMN55416N/A501C3EDUCATIONAL$2,500
CHILDRENS CANCER RESEARCH
7801 EAST BUSH LAKE RD STE 130MINNEAPOLISMN55439N/A501C3MEDICAL$35,000
CHILDRENS HOSPITAL FOUNDATION
2545 CHICAGO AVE SO STE 617MINNEAPOLISMN55404N/A501C3MEDICAL$10,000
CHS HEALTHCARE FOUNDATION
1454 MADISON AVEIMMOKALEEFL34142N/A501C3MEDICAL$1,000
EDINA EDUCATION FUND
5701 NORMANDALE ROADEDINAMN55424N/A501C3EDUCATIONAL$2,500
JESSICA SCHWARTZBAUER FOUNDATION
6107 WATERFORDEDINAMN55436N/A501C3CHARITABLE$1,000
MAJESTIC HILLS RANCH
24580 DAKOTA AVENUELAKEVILLEMN55044N/A501C3CHARITABLE$5,000
MAYO CLINIC
200 FIRST STREET SWROCHESTERMN55905N/A501C3MEDICAL$25,000
MINNEAPOLIS HEART INSTITUTE FOUNDATION
920 EAST 28TH STREET STE 100MINNEAPOLISMN55407N/A501C3MEDICAL$10,000
MINNESOTANS MILITARY APPRECIATION FUND
PO BOX 2070MINNEAPOLISMN55402N/A501C3CHARITABLE$10,000
PARKINSONS ASSOCIATION OF MINNESOTA
6601 LYNDALE AVE SOMINNEAPOLISMN55423N/A501C3MEDICAL$200
THE BLAKE SCHOOL
110 BLAKE ROADHOPKINSMN55343N/A501C3CHARITABLE$10,000
WISHES & MORE
961 HILLWIND ROADFRIDLEYMN55432N/A501C3CHARITABLE$50,000
WOUNDED WARRIORS PROJECT
PO BOX 78516TOPEKAKS66675N/A501C3CHARITABLE$2,000
FieldValueIRS element (for citing)
Tot Grant Or Contri Paid During Year164200TotGrantOrContriPaidDuringYear
Tot Grant Or Contri Approved Future0TotGrantOrContriApprovedFuture

Analysis Income Producing Acty AnalysisIncomeProducingActy

Dividends And Int From Sec Part VII DividendsAndIntFromSecPartVII

FieldValueIRS element (for citing)
Exclusion Code14ExclusionCode
Exclusion$83,894ExclusionAmount

Gain Sales Assets Oth Than Invntry GainSalesAssetsOthThanInvntry

FieldValueIRS element (for citing)
Exclusion Code18ExclusionCode
Exclusion$141,032ExclusionAmount

Subtotals Part XVIA SubtotalsPartXVIA

FieldValueIRS element (for citing)
Unrelated Business Income$0UnrelatedBusinessIncomeAmount
Exclusion$224,926ExclusionAmount
Related Or Exempt Function Income0RelatedOrExemptFunctionIncome
FieldValueIRS element (for citing)
Total Part XVIA224926TotalPartXVIA

Trnsfr Tr Rln With Noncharitable EO TrnsfrTrRlnWithNoncharitableEO

FieldValueIRS element (for citing)
Trnsfr Of Cash To Noncharitable EO0TrnsfrOfCashToNoncharitableEO
Trnsfr Oth Assets Noncharitable EO0TrnsfrOthAssetsNoncharitableEO
Sales Or Exchanges Of Assets0SalesOrExchangesOfAssets
Purchase Assets Noncharitable EO0PurchaseAssetsNoncharitableEO
Rental Of Facilities Etc0RentalOfFacilitiesEtc
Reimbursement Arrangements0ReimbursementArrangements
Loans Or Loan Guarantees0LoansOrLoanGuarantees
Performance Of Services Etc0PerformanceOfServicesEtc
Sharing Of Facilities Etc0SharingOfFacilitiesEtc
Relationships Noncharitable E Os0RelationshipsNoncharitableEOs

Accounting Fees Schedule AccountingFeesSchedule

Accounting Fees AccountingFees

FieldValueIRS element (for citing)
CategoryACCOUNTING FEESCategory
Amount$10,300Amount
Net Investment Income0NetInvestmentIncome
Disbursements Charitable Prps10300DisbursementsCharitablePrps

Investments Other Schedule2 InvestmentsOtherSchedule2

Investments Other InvestmentsOther

FieldValueIRS element (for citing)
Category Or ItemSTOCKS & BONDSCategoryOrItem
Listed At Cost Or FMVAT COSTListedAtCostOrFMV
Book Value3141591BookValue
EOYFMV3568014EOYFMV

Other Professional Fees Schedule OtherProfessionalFeesSchedule

Other Professional Fees OtherProfessionalFees (3 entries)

CategoryCategoryAmountAmountNet Investment IncomeNetInvestmentIncomeDisbursements Charitable PrpsDisbursementsCharitablePrps
MANAGEMENT FEES$51,343513430
INVESTMENT EXPENSES$27270
FOREIGN FEES$12120

Taxes Schedule TaxesSchedule

Taxes Taxes (3 entries)

CategoryCategoryAmountAmountNet Investment IncomeNetInvestmentIncomeDisbursements Charitable PrpsDisbursementsCharitablePrps
FOREIGN TAX WITHHELD$1,19811980
MINNESOTA FILING FEE$25025
FEDERAL TAX$1,59300