ROBERT E HANSEN FAMILY FOUNDATION: Form 990PF, tax year 2011

View the entire original 990 at ProPublica ↗

Organization
ROBERT E HANSEN FAMILY FOUNDATION (EIN 76-0259279)
Tax period
2011-09-01 to 2012-08-31
Filed
2013-02-18
IRS object ID
201330499349100403
Schema version
2011v1.5
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-02-18T12:59:21-06:00Timestamp
Tax Period End Date2012-08-31TaxPeriodEndDate

Preparer Firm PreparerFirm

Preparer Firm Business Name PreparerFirmBusinessName

FieldValueIRS element (for citing)
Business Name Line1BKD LLPBusinessNameLine1

Preparer Firm US Address PreparerFirmUSAddress

FieldValueIRS element (for citing)
Address Line12800 Post Oak Blvd Ste 3200AddressLine1
CityHOUSTONCity
StateTXState
ZIP Code77056ZIPCode
FieldValueIRS element (for citing)
Return Type990PFReturnType
Tax Period Begin Date2011-09-01TaxPeriodBeginDate

Filer Filer

FieldValueIRS element (for citing)
EIN760259279EIN

Name Name

FieldValueIRS element (for citing)
Business Name Line1The Robert E Hansen Family FoundationBusinessNameLine1
Business Name Line2C/O Inge Alverson Bacon CPABusinessNameLine2
FieldValueIRS element (for citing)
In Care Of Name% MARJORIE SCHULTZInCareOfName
Name ControlROBENameControl
Phone9204210923Phone

US Address USAddress

FieldValueIRS element (for citing)
Address Line1253 N 1st Ave Suite 1AddressLine1
CitySturgeon BayCity
StateWIState
ZIP Code54235ZIPCode

Officer Officer

FieldValueIRS element (for citing)
NameMARGARET W H HANSENName
TitlePRESIDENT/TREASURERTitle
Date Signed2013-04-15DateSigned
Authorize Third PartytrueAuthorizeThirdParty

Preparer Preparer

FieldValueIRS element (for citing)
Phone7134994600Phone
FieldValueIRS element (for citing)
Tax Year2011TaxYear
Build TS2016-02-25 16:41:14ZBuildTS

Form 990-PF IRS990PF

FieldValueIRS element (for citing)
Address ChangeXAddressChange
Exempt PFXExemptPF
FMV Assets EOY1278880FMVAssetsEOY
Method Of Accounting AccrualXMethodOfAccountingAccrual

Analysis Of Revenue And Expenses AnalysisOfRevenueAndExpenses

FieldValueIRS element (for citing)
Contri Received Rev And Expnss0ContriReceivedRevAndExpnss
Interest On Savings Rev And Expnss24InterestOnSavingsRevAndExpnss
Interest On Savings Net Invst Incm24InterestOnSavingsNetInvstIncm
Dividends Rev And Expnss26532DividendsRevAndExpnss
Dividends Net Invst Incm26532DividendsNetInvstIncm
Net Gain Sale Assets Rev And Expnss78273NetGainSaleAssetsRevAndExpnss
Gross Sales Price1032881GrossSalesPrice
Capital Gain Net Incm Net Invst Incm78273CapitalGainNetIncmNetInvstIncm
Total Revenue And Expenses104829TotalRevenueAndExpenses
Total Net Investment Income104829TotalNetInvestmentIncome
Comp Ofcr Dir Trst Rev And Expnss0CompOfcrDirTrstRevAndExpnss
Accounting Fees Rev And Expnss3800AccountingFeesRevAndExpnss
Accounting Fees Net Invst Incm3800AccountingFeesNetInvstIncm
Accounting Fees Adj Net Incm0AccountingFeesAdjNetIncm
Accounting Fees Dsbrs Chrtbl Prps0AccountingFeesDsbrsChrtblPrps
Other Prof Fees Rev And Expnss5415OtherProfFeesRevAndExpnss
Other Prof Fees Net Invst Incm5415OtherProfFeesNetInvstIncm
Taxes Rev And Expnss1461TaxesRevAndExpnss
Taxes Net Invst Incm510TaxesNetInvstIncm
Tot Opr Expenses Rev And Expnss10676TotOprExpensesRevAndExpnss
Tot Opr Expenses Net Invst Incm9725TotOprExpensesNetInvstIncm
Tot Opr Expenses Adj Net Incm0TotOprExpensesAdjNetIncm
Tot Opr Expenses Dsbrs Chrtbl Prps0TotOprExpensesDsbrsChrtblPrps
Contri Gifts Paid Rev And Expnss155870ContriGiftsPaidRevAndExpnss
Contri Gifts Paid Dsbrs Chrtbl Prps155870ContriGiftsPaidDsbrsChrtblPrps
Total Expenses Rev And Expnss166546TotalExpensesRevAndExpnss
Total Expenses Net Invst Incm9725TotalExpensesNetInvstIncm
Total Expenses Adj Net Incm0TotalExpensesAdjNetIncm
Total Expenses Dsbrs Chrtbl Prps155870TotalExpensesDsbrsChrtblPrps
Excess Of Revenue Over Expenses-61717ExcessOfRevenueOverExpenses
Net Investment Income95104NetInvestmentIncome

Balance Sheets BalanceSheets

FieldValueIRS element (for citing)
Savings And Temp Cash Invst BOY383223SavingsAndTempCashInvstBOY
Savings And Temp Cash Invst EOY315164SavingsAndTempCashInvstEOY
Savings And Temp Cash Invst EOYFMV315164SavingsAndTempCashInvstEOYFMV
Investments Corp Stock BOY860308InvestmentsCorpStockBOY
Investments Corp Stock EOY867601InvestmentsCorpStockEOY
Investments Corp Stock EOYFMV962245InvestmentsCorpStockEOYFMV
Other Assets BOY2422OtherAssetsBOY
Other Assets EOY1471OtherAssetsEOY
Other Assets EOYFMV1471OtherAssetsEOYFMV
Total Assets BOY1245953TotalAssetsBOY
Total Assets EOY1184236TotalAssetsEOY
Total Assets EOYFMV1278880TotalAssetsEOYFMV
Accounts Payable BOY1715AccountsPayableBOY
Accounts Payable EOY1715AccountsPayableEOY
Total Liabilities BOY1715TotalLiabilitiesBOY
Total Liabilities EOY1715TotalLiabilitiesEOY
Org That Do Not Follow SFAS117XOrgThatDoNotFollowSFAS117
Capital Stock BOY1653142CapitalStockBOY
Capital Stock EOY1653142CapitalStockEOY
Retained Earnings BOY-408904RetainedEarningsBOY
Retained Earnings EOY-470621RetainedEarningsEOY
Total Net Assets BOY1244238TotalNetAssetsBOY
Total Net Assets EOY1182521TotalNetAssetsEOY
Total Liabilities Net Assets BOY1245953TotalLiabilitiesNetAssetsBOY
Total Liabilities Net Assets EOY1184236TotalLiabilitiesNetAssetsEOY

Changes In Net Assets Fund Balances ChangesInNetAssetsFundBalances

FieldValueIRS element (for citing)
Total Net Assets Fund Balances BOY1244238TotalNetAssetsFundBalancesBOY
Excess Of Revenue Over Expenses-61717ExcessOfRevenueOverExpenses
Subtotal1182521Subtotal
Total Net Assets Fund Balances EOY1182521TotalNetAssetsFundBalancesEOY

Capital Gains And Losses CapitalGainsAndLosses

Capital Gains And Losses Info CapitalGainsAndLossesInfo (2 entries)

Description Of AssetDescriptionOfAssetHow AcquiredHowAcquiredDate AcquiredDateAcquiredDate SoldDateSoldGross Sales PriceGrossSalesPriceCost Or Other BasisCostOrOtherBasisGain Or LossGainOrLossGains Minus Excess Or LossesGainsMinusExcessOrLosses
SEE SCHEDULE 1P2011-12-312011-12-317840347532143082030820
SEE SCHEDULE 1P2009-12-312011-12-312488472013944745347453
FieldValueIRS element (for citing)
Capital Gain Net Income78273CapitalGainNetIncome

Qlfy Und Sect4940e For Reduced Tax QlfyUndSect4940eForReducedTax

FieldValueIRS element (for citing)
Liable For4942 TaxfalseLiableFor4942Tax
Qualifying Distributions Year1184432QualifyingDistributionsYear1
Noncharitable Assets Year11398746NoncharitableAssetsYear1
Distribution Ratio Year10.131855DistributionRatioYear1
Qualifying Distributions Year2211179QualifyingDistributionsYear2
Noncharitable Assets Year21416366NoncharitableAssetsYear2
Distribution Ratio Year20.149099DistributionRatioYear2
Qualifying Distributions Year3134095QualifyingDistributionsYear3
Noncharitable Assets Year31356331NoncharitableAssetsYear3
Distribution Ratio Year30.098866DistributionRatioYear3
Qualifying Distributions Year4214135QualifyingDistributionsYear4
Noncharitable Assets Year42320242NoncharitableAssetsYear4
Distribution Ratio Year40.09229DistributionRatioYear4
Qualifying Distributions Year5207630QualifyingDistributionsYear5
Noncharitable Assets Year52615673NoncharitableAssetsYear5
Distribution Ratio Year50.079379DistributionRatioYear5
Total Distribution Ratio0.551489TotalDistributionRatio
Average Distribution Ratio0.110298AverageDistributionRatio
Net Noncharitable Assets1305895NetNoncharitableAssets
Adjusted Noncharitable Assets144038AdjustedNoncharitableAssets
One Percent Net Investment Income951OnePercentNetInvestmentIncome
Adj Nonchrtbl Assets And One144989AdjNonchrtblAssetsAndOnePct
Qualifying Distributions155870QualifyingDistributions

Excise Tax Based On Investment Incm ExciseTaxBasedOnInvestmentIncm

FieldValueIRS element (for citing)
Domestic Org Meeting Sect4940eXDomesticOrgMeetingSect4940e
Investment Income Excise Tax951InvestmentIncomeExciseTax
Subtotal951Subtotal
Tax Based On Investment Income951TaxBasedOnInvestmentIncome
Est Tax Payments And Overpayment2422EstTaxPaymentsAndOverpayment
Total Credits And Payments2422TotalCreditsAndPayments
Overpayment1471Overpayment
Amount Credited To Next Year1471AmountCreditedToNextYear

Statements Regarding Activities StatementsRegardingActivities

FieldValueIRS element (for citing)
Legislative Political ActivitiesfalseLegislativePoliticalActivities
More Than100 SpentfalseMoreThan100Spent
Form1120 POL FiledfalseForm1120POLFiled
Activities Not Prev ReportedfalseActivitiesNotPrevReported
Changes To Articles Or BylawsfalseChangesToArticlesOrBylaws
Unrelated Bus Income Over1000falseUnrelatedBusIncomeOver1000
Termination EtcfalseTerminationEtc
Requirements Of Sect508etrueRequirementsOfSect508e
At Least5000 In AssetstrueAtLeast5000InAssets
States Filed WithTXStatesFiledWith
Form990 PF Filed With AGtrueForm990PFFiledWithAG
Private Operating FoundationfalsePrivateOperatingFoundation
New Substantial ContributorsfalseNewSubstantialContributors
Interest In Controlled EntityfalseInterestInControlledEntity
Applicable Insurance ContractfalseApplicableInsuranceContract
Comply With Public Inspection RqrtrueComplyWithPublicInspectionRqr

Books In Care Of Business Name BooksInCareOfBusinessName

FieldValueIRS element (for citing)
Business Name Line1MARJORIE SCHULTZBusinessNameLine1
FieldValueIRS element (for citing)
Books In Care Of Phone Number7135213434BooksInCareOfPhoneNumber

Books In Care Of US Address BooksInCareOfUSAddress

FieldValueIRS element (for citing)
Address Line13401 LOUISIANA ST 380AddressLine1
CityHOUSTONCity
StateTXState
ZIP Code77006ZIPCode
FieldValueIRS element (for citing)
Foreign BankfalseForeignBank

Statements Regarding Acty4720 StatementsRegardingActy4720

FieldValueIRS element (for citing)
Sale Or Exchange With Dsqfly PersonfalseSaleOrExchangeWithDsqflyPerson
Borrow Or Lend With Dsqfly PersonfalseBorrowOrLendWithDsqflyPerson
Furnished Goods With Dsqfly PersonfalseFurnishedGoodsWithDsqflyPerson
Pay Compensation To Dsqfly PersonfalsePayCompensationToDsqflyPerson
Transfer Assets To Dsqfly PersonfalseTransferAssetsToDsqflyPerson
Payment To Government OfficalfalsePaymentToGovernmentOffical
Relying Curr Notice Disaster Asst1XRelyingCurrNoticeDisasterAsst1
Uncorrected Prior ActsfalseUncorrectedPriorActs
Undistributed Income Prior YearsfalseUndistributedIncomePriorYears
Undistr Income4942a2 Not AppliedfalseUndistrIncome4942a2NotApplied
Business HoldingsfalseBusinessHoldings
Influence LegislationfalseInfluenceLegislation
Influence ElectionfalseInfluenceElection
Grants To IndividualsfalseGrantsToIndividuals
Grants To OrganizationsfalseGrantsToOrganizations
Noncharitable PurposefalseNoncharitablePurpose
Rcv Funds To Pay Prsnl Bnft ContractfalseRcvFundsToPayPrsnlBnftContract
Pay Premiums Prsnl Bnft ContractfalsePayPremiumsPrsnlBnftContract
Prohibited Tax Shelter TransactnfalseProhibitedTaxShelterTransactn

Ofcr Dir Trustees Key Employee Info OfcrDirTrusteesKeyEmployeeInfo

Ofcr Dir Trustees Or Key Employee OfcrDirTrusteesOrKeyEmployee (4 entries)

Address Line1USAddress/AddressLine1CityUSAddress/CityStateUSAddress/StateZIP CodeUSAddress/ZIPCodeTitleTitleAvg Hours Per Wk Devoted To PositionAvgHoursPerWkDevotedToPositionCompensationCompensationContri To Empl Benefit Plans EtcContriToEmplBenefitPlansEtcExpense Account Other AllowancesExpenseAccountOtherAllowances
MARGARET W H HANSEN
253 N 1st Ave Suite 1Sturgeon BayWI54235PRESIDENT/TREASURER1.0000
ALEXANDER E HANSEN
253 N 1st Ave Suite 1Sturgeon BayWI54235VICE-PRESIDENT1.0000
LAURIE H SAXTON
253 N 1st Ave Suite 1Sturgeon BayWI54235SECRETARY1.0000
MARJORIE S SCHULTZ
253 N 1st Ave Suite 1Sturgeon BayWI54235ASSIST. SECRETARY1.0000

Summary Of Direct Charitable Acty SummaryOfDirectCharitableActy

FieldValueIRS element (for citing)
Description1FOUNDATION HAS NO DIRECT CHARITABLE ACTIVITIES. EXPENDITURES ARE IN THE FORM OF DONATIONS TO EACH CHARITY WHICH THE FOUNDATION HAS NO CONTROL OVER.Description1

Sum Of Program Related Investments SumOfProgramRelatedInvestments

FieldValueIRS element (for citing)
Description1NO PROGRAM RELATED INVESTMENTSDescription1

Minimum Investment Return MinimumInvestmentReturn

FieldValueIRS element (for citing)
Avg Monthly FMV Of Securities1052902AvgMonthlyFMVOfSecurities
Avg Monthly Cash Balances272880AvgMonthlyCashBalances
FMV All Other Noncharitable Assets0FMVAllOtherNoncharitableAssets
Total FMV Of Unused Assets1325782TotalFMVOfUnusedAssets
Acquisition Indebtedness0AcquisitionIndebtedness
Adj Total FMV Of Unused Assets1325782AdjTotalFMVOfUnusedAssets
Cash Deemed Charitable19887CashDeemedCharitable
Net Noncharitable Assets1305895NetNoncharitableAssets
Minimum Investment Return65295MinimumInvestmentReturn

Distributable DistributableAmount

FieldValueIRS element (for citing)
Minimum Investment Return65295MinimumInvestmentReturn
Tax Based On Investment Income951TaxBasedOnInvestmentIncome
Total Tax951TotalTax
Distributable Amount Before Adj64344DistributableAmountBeforeAdj
Distributable Amount Before Ded64344DistributableAmountBeforeDed
Distributable Amount As Adjusted64344DistributableAmountAsAdjusted

Qualifying Distributions QualifyingDistributions

FieldValueIRS element (for citing)
Expenses And Contributions155870ExpensesAndContributions
Program Related Investments Total0ProgramRelatedInvestmentsTotal
Amounts Paid Acq Charitable Assets0AmountsPaidAcqCharitableAssets
Amounts Set Aside Suitability Test0AmountsSetAsideSuitabilityTest
Amounts Set Aside Cash Distri Test0AmountsSetAsideCashDistriTest
Qualifying Distributions155870QualifyingDistributions
One Pct Sect4940e Org Net Invst Incm951OnePctSect4940eOrgNetInvstIncm
Adj Qualifying Distributions154919AdjQualifyingDistributions

Undistributed Income UndistributedIncome

FieldValueIRS element (for citing)
Distributable Amount As Adjusted64344DistributableAmountAsAdjusted
Prior Year12009PriorYear1
Prior Year22008PriorYear2
Prior Year32007PriorYear3
Excess Distri Carryover Year582736ExcessDistriCarryoverYear5
Excess Distri Carryover Year498433ExcessDistriCarryoverYear4
Excess Distri Carryover Year366378ExcessDistriCarryoverYear3
Excess Distri Carryover Year2140388ExcessDistriCarryoverYear2
Excess Distri Carryover Year1115381ExcessDistriCarryoverYear1
Total Excess Distri Carryover503316TotalExcessDistriCarryover
Qualifying Distributions155870QualifyingDistributions
Applied To Current Year64344AppliedToCurrentYear
Remaining Distri From Corpus91526RemainingDistriFromCorpus
Total Corpus594842TotalCorpus
Undistributed Income CY0UndistributedIncomeCY
Excess Distri Cyov From Year582736ExcessDistriCyovFromYear5
Excess Distri Cyov To Next Year512106ExcessDistriCyovToNextYear
Excess From Year498433ExcessFromYear4
Excess From Year366378ExcessFromYear3
Excess From Year2140388ExcessFromYear2
Excess From Year1115381ExcessFromYear1
Excess From Current Year91526ExcessFromCurrentYear
FieldValueIRS element (for citing)
Private Operating FoundationsPrivateOperatingFoundations

Supplementary Information SupplementaryInformation

FieldValueIRS element (for citing)
Contributing ManagerMARGARET W H HANSENContributingManager
Shareholder ManagerNAShareholderManager
Only Contributes To PreselectedXOnlyContributesToPreselected

Grant Or Contri Paid During Year GrantOrContriPaidDuringYear

Recipient Business Name RecipientBusinessName

FieldValueIRS element (for citing)
Business Name Line1SEE SCHEDULE 2BusinessNameLine1

Recipient US Address RecipientUSAddress

FieldValueIRS element (for citing)
Address Line1C/O 253 N 1ST AVE SUITE 1AddressLine1
CitySTURGEON BAYCity
StateWIState
ZIP Code54235ZIPCode
FieldValueIRS element (for citing)
Purpose Of Grant Or ContributionCHARITABLEPurposeOfGrantOrContribution
Amount$155,870Amount
FieldValueIRS element (for citing)
Tot Grant Or Contri Paid During Year155870TotGrantOrContriPaidDuringYear

Analysis Income Producing Acty AnalysisIncomeProducingActy

FieldValueIRS element (for citing)
Fees Contracts From Govt AgenciesFeesContractsFromGovtAgencies
Membership Dues And AssessmentsMembershipDuesAndAssessments

Int On Savings And Temp Cash Invst IntOnSavingsAndTempCashInvst

FieldValueIRS element (for citing)
Exclusion Code14ExclusionCode
Exclusion$24ExclusionAmount

Dividends And Int From Sec Part VII DividendsAndIntFromSecPartVII

FieldValueIRS element (for citing)
Exclusion Code14ExclusionCode
Exclusion$26,532ExclusionAmount
FieldValueIRS element (for citing)
Net Rental Incm Re Debt Fincd PropNetRentalIncmReDebtFincdProp
Net Rntl Incm Re Not Debt Fincd PropNetRntlIncmReNotDebtFincdProp
Net Rental Incm Personal PropertyNetRentalIncmPersonalProperty
Other Investment Income Part VIIOtherInvestmentIncomePartVII

Gain Sales Assets Oth Than Invntry GainSalesAssetsOthThanInvntry

FieldValueIRS element (for citing)
Exclusion Code18ExclusionCode
Exclusion$78,273ExclusionAmount
FieldValueIRS element (for citing)
Net Income Loss From Special EventsNetIncomeLossFromSpecialEvents
Gross Profit Loss Sales Of InvntryGrossProfitLossSalesOfInvntry

Subtotals Part XVIA SubtotalsPartXVIA

FieldValueIRS element (for citing)
Exclusion$104,829ExclusionAmount
FieldValueIRS element (for citing)
Total Part XVIA104829TotalPartXVIA

Trnsfr Tr Rln With Noncharitable EO TrnsfrTrRlnWithNoncharitableEO

FieldValueIRS element (for citing)
Trnsfr Of Cash To Noncharitable EOfalseTrnsfrOfCashToNoncharitableEO
Trnsfr Oth Assets Noncharitable EOfalseTrnsfrOthAssetsNoncharitableEO
Sales Or Exchanges Of AssetsfalseSalesOrExchangesOfAssets
Purchase Assets Noncharitable EOfalsePurchaseAssetsNoncharitableEO
Rental Of Facilities EtcfalseRentalOfFacilitiesEtc
Reimbursement ArrangementsfalseReimbursementArrangements
Loans Or Loan GuaranteesfalseLoansOrLoanGuarantees
Performance Of Services EtcfalsePerformanceOfServicesEtc
Sharing Of Facilities EtcfalseSharingOfFacilitiesEtc
Relationships Noncharitable E OsfalseRelationshipsNoncharitableEOs

Accounting Fees Schedule AccountingFeesSchedule

Accounting Fees AccountingFees

FieldValueIRS element (for citing)
CategoryACCOUNTING FEESCategory
Amount$3,800Amount
Net Investment Income3800NetInvestmentIncome

Depreciation Schedule DepreciationSchedule

Investments Corp Stock Schedule InvestmentsCorpStockSchedule

Investments Corp Stock InvestmentsCorpStock

FieldValueIRS element (for citing)
Name Of StockSEE ATTACHED SCHEDULE 3NameOfStock
EOY Book Value867601EOYBookValue
EOYFMV962245EOYFMV

Land Etc Schedule2 LandEtcSchedule2

Other Assets Schedule OtherAssetsSchedule

Other Assets OtherAssets

FieldValueIRS element (for citing)
DescriptionEXCISE TAXDescription
BOY Book Value2422BOYBookValue
EOY Book Value1471EOYBookValue
EOYFMV1471EOYFMV

Other Professional Fees Schedule OtherProfessionalFeesSchedule

Other Professional Fees OtherProfessionalFees (2 entries)

CategoryCategoryAmountAmountNet Investment IncomeNetInvestmentIncome
INVESTMENT FEES - HERNDON$5,2655265
BROKER FEES$150150

Taxes Schedule TaxesSchedule

Taxes Taxes (2 entries)

CategoryCategoryAmountAmountNet Investment IncomeNetInvestmentIncome
EXCISE TAX$951
FOREIGN TAX$510510

Comments

Anonymous: no account or email. Up to 2,000 characters, at most one link. Comments are checked automatically; some wait for review.