Civic Intelligence

Squier Family Foundation

990T • Fiscal year 2023 • EIN 06-1577514

Jan 01, 2023 to Dec 31, 2023 • Filed on Nov 14, 2024

Organization Profile
1000 Beach Road 197Vero Beach, FL 32963

(202) 862-1880

Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses

Revenue

-

No earlier filing loaded for comparison.

Expenses

-

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$8.0M$6.0M$4.0M$2.0M$0Assets 2011: $764,908Liabilities 2011: $02011Assets 2012: $888,138Liabilities 2012: $02012Assets 2013: $822,023Liabilities 2013: $02013Assets 2014: $1,118,014Liabilities 2014: $02014Assets 2015: $1,538,942Liabilities 2015: $02015Assets 2018: $3,718,518Liabilities 2018: $0Net Assets 2018: $3,718,5182018Assets 2019: $3,871,195Liabilities 2019: $0Net Assets 2019: $3,871,1952019Assets 2020: $4,365,138Liabilities 2020: $0Net Assets 2020: $4,365,1382020Assets 2021: $5,595,739Liabilities 2021: $0Net Assets 2021: $5,595,7392021Assets 2022: $6,317,513Liabilities 2022: $0Net Assets 2022: $6,317,5132022Assets 2023: $6,799,634Liabilities 2023: $1,000Net Assets 2023: $6,798,6342023Assets 2024: $6,779,195Liabilities 2024: $0Net Assets 2024: $6,779,1952024

Latest loaded filing

2024

Assets$6,779,195
Liabilities$0
Net Assets$6,779,195
Open 2024 Filing

Operations Trend

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

$2.0M$1.5M$1.0M$500K$0Revenue 2011: $479,324Expenses 2011: $121,309Net Income 2011: $358,0152011Revenue 2012: $458,729Expenses 2012: $109,083Net Income 2012: $349,6462012Revenue 2013: $446,694Expenses 2013: $159,391Net Income 2013: $287,3032013Revenue 2014: $532,566Expenses 2014: $194,318Net Income 2014: $338,2482014Revenue 2015: $962,451Expenses 2015: $311,807Net Income 2015: $650,6442015Revenue 2018: $476,126Expenses 2018: $235,224Net Income 2018: $240,9022018Revenue 2019: $444,105Expenses 2019: $253,197Net Income 2019: $190,9082019Revenue 2020: $887,771Expenses 2020: $345,671Net Income 2020: $542,1002020Revenue 2021: $1,886,213Expenses 2021: $343,162Net Income 2021: $1,543,0512021Revenue 2022: $1,191,556Expenses 2022: $503,284Net Income 2022: $688,2722022Revenue 2023: $1,201,089Expenses 2023: $739,101Net Income 2023: $461,9882023Revenue 2024: $1,042,104Expenses 2024: $827,195Net Income 2024: $214,9092024

Latest loaded filing

2024

Revenue$1,042,104
Expenses$827,195
Net Income$214,909
Open 2024 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Nov 14, 2024
Return Version
2023v7.0
Filing and Contact Details

Filer

Filer Name
Squier Family Foundation
EIN
06-1577514
Phone
2028621880
Address
1000 BEACH ROAD 197, VERO BEACH, FL 32963

Signing Officer

Name
David Squier
Title
Trustee
Phone
2028621880
Signed
2024-11-14
Discuss with paid preparer
Yes

Preparer

Firm
Rosemckenna Pllc
Address
1717 PENNSYLVANIA AVE NW 750, WASHINGTON, DC 20006
Preparer
Kristen Mckenna
Phone
2028621880
Raw XML Appendix100 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
IRS1041ScheduleI/AdjAlternativeMinTaxableIncAmt0220998
IRS1041ScheduleI/AdjustedRegularTaxAmt077302
IRS1041ScheduleI/AdjustedTotalIncomeAmt0214939
IRS1041ScheduleI/AlternativeMinimumTaxAmt00
IRS1041ScheduleI/AlternativeMinTaxableIncomeAmt0220998
IRS1041ScheduleI/EstateOrTrustShrLessExemptAmt0220998
IRS1041ScheduleI/MaximumCapitalGainsOrNetAmt057465
IRS1041ScheduleI/NetOperatingLossDeductionAmt06059
IRS1041ScheduleI/PassiveActivityAmt00
IRS1041ScheduleI/TentativeAlternativeMinTaxAmt057465
IRS990T/AddressChangeInd0X
IRS990T/BalanceDueAmt052957
IRS990T/BooksInCareOfDetail/PersonNm0DAVID SQUIER
IRS990T/BooksInCareOfDetail/PhoneNum02028621880
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt01000 BEACH ROAD APT 197
IRS990T/BooksInCareOfDetail/USAddress/CityNm0VERO BEACH
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0FL
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd032963
IRS990T/BookValueAssetsEOYAmt06799634
IRS990T/CharitableContributionsDedAmt00
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form2220AttachedInd0X
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cTrustInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OtherTaxesAmt00
IRS990T/PaidTaxLiabilityAmt00
IRS990T/Post2017NOLCarryoverGrp/AvlblPost2017NOLCarryoverAmt06059
IRS990T/Post2017NOLCarryoverGrp/PrincipalBusinessActivityCd0523000
IRS990T/PriorYearOverpaymentCreditAmt024345
IRS990TScheduleA/NetOperatingLossDeductionAmt06059
IRS990TScheduleA/PrincipalBusinessActivityCd0523000
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TaxesAndLicensesAmt09000
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt09000
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt0229998
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0229998
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0229998
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0INVESTMENT ACTIVITY (QPI) - 1.512(A)-6(C)(1)
IRS990TScheduleA/UBIBeforeNOLDedAmt0220998
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0214939
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableTrustAmt077302
IRS990T/TaxLessCreditsAmt077302
IRS990T/TaxRateScheduleInd0X
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt024345
IRS990T/TotalTaxAmt077302
IRS990T/TotalTaxComputationAmt077302
IRS990T/TotalUBTIAmt0213939
IRS990T/TotalUBTIBeforeNOLSpecificAmt0214939
IRS990T/TotalUBTIBeforeSection199AAmt0214939
IRS990T/TotalUBTIComputedAmt0214939
ReturnHeader/BuildTS02024-10-15 13:58:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0DAVID SQUIER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum02028621880
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-11-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0SQUIER FAMILY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0SQUI
ReturnHeader/Filer/EIN0061577514
ReturnHeader/Filer/PhoneNum02028621880
ReturnHeader/Filer/USAddress/AddressLine1Txt01000 BEACH ROAD 197
ReturnHeader/Filer/USAddress/CityNm0VERO BEACH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0FL
ReturnHeader/Filer/USAddress/ZIPCd032963
ReturnHeader/IRSResponsiblePrtyInfoCurrInd01
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0454149985
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ROSEMCKENNA PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01717 PENNSYLVANIA AVE NW 750
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0WASHINGTON
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0DC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd020006
ReturnHeader/PreparerPersonGrp/PhoneNum02028621880
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0KRISTEN MCKENNA
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02024-11-15T09:53:20-06:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/TaxPeriodBeginDt02023-01-01
ReturnHeader/TaxPeriodEndDt02023-12-31
ReturnHeader/TaxYr02023

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2023 • Form 990TFacts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
-
Liabilities
-
Net assets
-
Revenue
-
Expenses
-
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$6.78$0.00$6.78$1.04$0.83$0.21
2023Detailed filing. Detailed filing data is available for this year.$6.80$0.00$6.80$1.20$0.74$0.46
2023Facts available. Structured filing facts are available, but richer extracted sections are limited.
2022Detailed filing. Detailed filing data is available for this year.$6.32$0.00$6.32$1.19$0.50$0.69
2021Detailed filing. Detailed filing data is available for this year.$5.60$0.00$5.60$1.89$0.34$1.54
2020Detailed filing. Detailed filing data is available for this year.$4.37$0.00$4.37$0.89$0.35$0.54
2019Detailed filing. Detailed filing data is available for this year.$3.87$0.00$3.87$0.44$0.25$0.19
2018Detailed filing. Detailed filing data is available for this year.$3.72$0.00$3.72$0.48$0.24$0.24
2015Summary only. Only limited summary data is available for this year.$1.54$0.00$0.96$0.31$0.65
2014Summary only. Only limited summary data is available for this year.$1.12$0.00$0.53$0.19$0.34
2013Summary only. Only limited summary data is available for this year.$0.82$0.00$0.45$0.16$0.29
2012Summary only. Only limited summary data is available for this year.$0.89$0.00$0.46$0.11$0.35
2011Summary only. Only limited summary data is available for this year.$0.76$0.00$0.48$0.12$0.36