Civic Intelligence

Bertaud Family Foundation

990PF • Fiscal year 2012 • EIN 26-1507752

Jan 01, 2012 to Dec 31, 2012 • Filed on May 29, 2013

345 West Austin Avenue60048
Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

35th percentile

0.00x

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

2012 filings • $500k-$1M nonprofits • Source year 2012

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

72nd percentile

$0

Higher top officer pay than 72% of similar nonprofits.

2012 filings • $500k-$1M nonprofits • Source year 2012

Asset Growth

22nd percentile

-5.4%

Faster asset growth than 22% of similar nonprofits.

2012 filings • $500k-$1M nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Assets

Down

$698,564

Down $40,239 (-5.4%) from 2011

Net Assets

Down

$698,564

Down $40,239 (-5.4%) from 2011

Liabilities

Flat

$0

Flat from 2011

Revenue

-

No earlier filing loaded for comparison.

Expenses

Down

$49,365

Down $2,744 (-5.3%) from 2011

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.

$800K$600K$400K$200K$0Assets 2010: $770,118Liabilities 2010: $0Net Assets 2010: $770,1182010Assets 2011: $738,803Liabilities 2011: $0Net Assets 2011: $738,8032011Assets 2012: $698,564Liabilities 2012: $0Net Assets 2012: $698,5642012Assets 2013: $680,043Liabilities 2013: $0Net Assets 2013: $680,0432013Assets 2014: $672,461Liabilities 2014: $0Net Assets 2014: $672,4612014Assets 2015: $693,692Liabilities 2015: $0Net Assets 2015: $693,6922015Assets 2016: $664,936Liabilities 2016: $0Net Assets 2016: $664,9362016Assets 2017: $659,763Liabilities 2017: $0Net Assets 2017: $659,7632017Assets 2018: $700,446Liabilities 2018: $0Net Assets 2018: $700,4462018Assets 2019: $672,599Liabilities 2019: $0Net Assets 2019: $672,5992019Assets 2020: $755,566Liabilities 2020: $0Net Assets 2020: $755,5662020Assets 2021: $738,069Liabilities 2021: $0Net Assets 2021: $738,0692021Assets 2022: $703,538Liabilities 2022: $0Net Assets 2022: $703,5382022Assets 2023: $683,513Liabilities 2023: $0Net Assets 2023: $683,5132023Assets 2024: $667,884Liabilities 2024: $528Net Assets 2024: $667,3562024

Highlighted filing

2012

Assets$698,564
Liabilities$0
Net Assets$698,564

Operations Trend

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

$150K$100K$50K$0-$50KExpenses 2010: $46,6082010Expenses 2011: $52,1092011Expenses 2012: $49,3652012Revenue 2013: $32,159Expenses 2013: $50,680Net Income 2013: -$18,5212013Revenue 2014: $45,320Expenses 2014: $52,902Net Income 2014: -$7,5822014Revenue 2015: $73,290Expenses 2015: $52,059Net Income 2015: $21,2312015Revenue 2016: $22,120Expenses 2016: $50,876Net Income 2016: -$28,7562016Revenue 2017: $45,337Expenses 2017: $50,510Net Income 2017: -$5,1732017Revenue 2018: $92,949Expenses 2018: $52,020Net Income 2018: $40,9292018Revenue 2019: $24,408Expenses 2019: $52,255Net Income 2019: -$27,8472019Revenue 2020: $120,211Expenses 2020: $37,244Net Income 2020: $82,9672020Revenue 2021: $38,803Expenses 2021: $56,300Net Income 2021: -$17,4972021Revenue 2022: $10,902Expenses 2022: $45,433Net Income 2022: -$34,5312022Revenue 2023: $24,984Expenses 2023: $45,009Net Income 2023: -$20,0252023Revenue 2024: $33,932Expenses 2024: $50,089Net Income 2024: -$16,1572024

Highlighted filing

2012

Revenue-
Expenses$49,365
Net Income-
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
May 29, 2013
Return Version
2012v2.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
FRANCOIS X BERTAUDPresident-$0--
JEANNE M BERTAUDSecretary-$0--
MARC H BERTAUDTreasurer-$0--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid Grant-ASSIST CHARITABLE GOALSPUBLICMUNDELEIN, IL, US$10,000
Paid Grant-ASSIST CHARITABLE GOALSPUBLICLAKE FOREST, IL, US$6,540
Paid Grant-ASSIST CHARITABLE GOALSPUBLICGENEVA, IL, US$6,430
Paid Grant-ASSIST CHARITABLE GOALSPUBLICLIBERTYVILLE, IL, US$3,560
Paid Grant-ASSIST CHARITABLE GOALSPUBLICLIBERTYVILLE, IL, US$3,270
Paid Grant-ASSIST CHARITABLE GOALSPUBLICWAUKEGAN, IL, US$3,270
Paid Grant-ASSIST CHARITABLE GOALSPUBLICLAKE FOREST, IL, US$2,000
Paid Grant-ASSIST CHARITABLE GOALSPUBLICLIBERTYVILLE, IL, US$1,000
Paid Grant-ASSIST CHARITABLE GOALPUBLICLIBERTYVILLE, IL, US$360
Filing and Contact Details

Filer

EIN
26-1507752
Raw XML Appendix391 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
AccountingFeesSchedule/AccountingFees/Amount06196
AccountingFeesSchedule/AccountingFees/Category0ACCOUNTING
AccountingFeesSchedule/AccountingFees/NetInvestmentIncome06196
CompensationExplanation/Compensation/PersonName0FRANCOIS X BERTAUD
CompensationExplanation/Compensation/PersonName1JEANNE M BERTAUD
CompensationExplanation/Compensation/PersonName2MARC H BERTAUD
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue0162114
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue1277733
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYBookValue2220633
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV0178777
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV1291904
InvestmentsCorpStockSchedule/InvestmentsCorpStock/EOYFMV2214902
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock0INVESTMENTS - AMERITRADE FOUNDATION
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock1INVESTMENTS - AMERITRADE FOUNDATION
InvestmentsCorpStockSchedule/InvestmentsCorpStock/NameOfStock2INVESTMENTS - AMERITRADE FOUNDATION
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionAmount021624
IRS990PF/AnalysisIncomeProducingActy/DividendsAndIntFromSecPartVII/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionAmount0-12580
IRS990PF/AnalysisIncomeProducingActy/GainSalesAssetsOthThanInvntry/ExclusionCode018
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionAmount04
IRS990PF/AnalysisIncomeProducingActy/IntOnSavingsAndTempCashInvst/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/OtherInvestmentIncomePartVII/ExclusionAmount078
IRS990PF/AnalysisIncomeProducingActy/OtherInvestmentIncomePartVII/ExclusionCode014
IRS990PF/AnalysisIncomeProducingActy/SubtotalsPartXVIA/ExclusionAmount09126
IRS990PF/AnalysisIncomeProducingActy/TotalPartXVIA09126
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncm06196
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnss06196
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps036430
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss036430
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncm021624
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnss021624
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses0-40239
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPrice0184731
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsNetInvstIncm04
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsRevAndExpnss04
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAssetsRevAndExpnss0-12580
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome09171
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncm078
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnss078
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncm06162
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnss06162
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncm0177
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnss0577
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps036430
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm012535
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss049365
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome021706
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses09126
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm012535
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss012935
IRS990PF/BalanceSheets/CashBOY036502
IRS990PF/BalanceSheets/CashEOY038084
IRS990PF/BalanceSheets/CashEOYFMV038084
IRS990PF/BalanceSheets/InvestmentsCorpStockBOY0702301
IRS990PF/BalanceSheets/InvestmentsCorpStockEOY0660480
IRS990PF/BalanceSheets/InvestmentsCorpStockEOYFMV0685583
IRS990PF/BalanceSheets/OrgThatFollowSFAS1170X
IRS990PF/BalanceSheets/TotalAssetsBOY0738803
IRS990PF/BalanceSheets/TotalAssetsEOY0698564
IRS990PF/BalanceSheets/TotalAssetsEOYFMV0723667
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY0738803
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY0698564
IRS990PF/BalanceSheets/TotalNetAssetsBOY0738803
IRS990PF/BalanceSheets/TotalNetAssetsEOY0698564
IRS990PF/BalanceSheets/UnrestrictedBOY0738803
IRS990PF/BalanceSheets/UnrestrictedEOY0698564
IRS990PF/CapitalGainsAndLosses/CapitalGainNetIncome0-12580
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis041502
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis126058
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis2117126
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis32469
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis4130
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis52913
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/CostOrOtherBasis67113
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset0PUBLICLY TRADED SECURITIES 1
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset1PUBLICLY TRADED SECURITIES 1
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset2PUBLICLY TRADED SECURITIES 2
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset3PUBLICLY TRADED SECURITIES 2
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset4PUBLICLY TRADED SECURITIES 3
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset5PUBLICLY TRADED SECURITIES 3
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/DescriptionOfAsset6PUBLICLY TRADED SECURITIES 3
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss0-776
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss13446
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss2-18038
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss3355
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss486
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainOrLoss51422
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses0-776
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses13446
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses2-18038
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses3355
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses486
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GainsMinusExcessOrLosses51422
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice040726
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice129504
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice299088
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice32824
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice4216
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice54335
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/GrossSalesPrice67113
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired0P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired1P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired2P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired3P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired4P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired5P
IRS990PF/CapitalGainsAndLosses/CapitalGainsAndLossesInfo/HowAcquired6P
IRS990PF/CapitalGainsAndLosses/NetShortTermCapitalGainOrLoss0-335
IRS990PF/ChangesInNetAssetsFundBalances/ExcessOfRevenueOverExpenses0-40239
IRS990PF/ChangesInNetAssetsFundBalances/Subtotal0698564
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesBOY0738803
IRS990PF/ChangesInNetAssetsFundBalances/TotalNetAssetsFundBalancesEOY0698564
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted035670
IRS990PF/DistributableAmount/DistributableAmountBeforeAdj035670
IRS990PF/DistributableAmount/DistributableAmountBeforeDed035670
IRS990PF/DistributableAmount/MinimumInvestmentReturn035853
IRS990PF/DistributableAmount/TaxBasedOnInvestmentIncome0183
IRS990PF/DistributableAmount/TotalTax0183
IRS990PF/ExciseTaxBasedOnInvestmentIncm/AmountCreditedToNextYear01200
IRS990PF/ExciseTaxBasedOnInvestmentIncm/EstTaxPaymentsAndOverpayment01383
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax0183
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Overpayment01200
IRS990PF/ExciseTaxBasedOnInvestmentIncm/Subtotal0183
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome0183
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TotalCreditsAndPayments01383
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY0723667
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets0727972
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances041402
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities0686570
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable010920
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn035853
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets0717052
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets0727972
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition02.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition12.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition22.00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation20
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc20
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances10
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances20
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0FRANCOIS X BERTAUD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName1JEANNE M BERTAUD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName2MARC H BERTAUD
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0PRESIDENT
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title1SECRETARY
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title2TREASURER
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10345 W AUSTIN AVE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine11345 W AUSTIN AVE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine1228429 IVY LANE NORTH
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0LIBERTYVILLE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City1LIBERTYVILLE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City2LIBERTYVILLE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0IL
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State1IL
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State2IL
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode060048
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode160048
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode2600489797
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct038270
IRS990PF/QlfyUndSect4940eForReducedTax/AdjustedNoncharitableAssets038178
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.053243
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.048685
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.050762
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.062535
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear400.042790
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear500.061442
IRS990PF/QlfyUndSect4940eForReducedTax/LiableFor4942Tax0false
IRS990PF/QlfyUndSect4940eForReducedTax/NetNoncharitableAssets0717052
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear10751050
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear20673768
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear30562997
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear40829638
IRS990PF/QlfyUndSect4940eForReducedTax/NoncharitableAssetsYear5065102
IRS990PF/QlfyUndSect4940eForReducedTax/OnePercentNetInvestmentIncome092
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions036430
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear1036565
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear2034202
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear3035207
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear4035500
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributionsYear504000
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.266214
IRS990PF/QualifyingDistributions/AdjQualifyingDistributions036430
IRS990PF/QualifyingDistributions/ExpensesAndContributions036430
IRS990PF/QualifyingDistributions/QualifyingDistributions036430
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0true
IRS990PF/StatementsRegardingActivities/BooksInCareOfPersonName0FRANCOIS X BERTAUD
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber08473677768
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10345 W AUSTIN AVE
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0LIBERTYVILLE
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0IL
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode060048
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/Form990PFFiledWithAG0true
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0true
IRS990PF/StatementsRegardingActivities/StatesFiledWith0IL
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000false
IRS990PF/StatementsRegardingActivities/WebsiteAddress0N/A
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/BusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals0false
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations0false
IRS990PF/StatementsRegardingActy4720/InfluenceElection0false
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation0false
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose0false
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical0false
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/SumOfProgramRelatedInvestments/Description10N/A
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount03560
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount110000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount23270
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount32000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount46430
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount56540
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount63270
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount71000
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/Amount8360
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution0ASSIST CHARITABLE GOALS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution1ASSIST CHARITABLE GOALS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution2ASSIST CHARITABLE GOALS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution3ASSIST CHARITABLE GOALS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution4ASSIST CHARITABLE GOALS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution5ASSIST CHARITABLE GOALS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution6ASSIST CHARITABLE GOALS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution7ASSIST CHARITABLE GOALS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/PurposeOfGrantOrContribution8ASSIST CHARITABLE GOAL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus0PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus1PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus2PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus3PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus4PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus5PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus6PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus7PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientFoundationStatus8PUBLIC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName0THE LAKE COUNTY HAVEN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName1CARMEL CATHOLIC HIGH SCHOOL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName2MARISTELLA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName3BERNARD P FLORIANI FOUNDATION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName4FOOD PANTRY OF NOTHERN ILLINOIS
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName5MOTHERS TRUST FOUNDATION
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName6HEALTH REACH INC
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName7LIBERTYVILLE CO-OP
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientPersonName8ADLER MUSIC ARTS CENTER
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship0NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship1NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship2NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship3NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship4NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship5NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship6NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship7NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientRelationship8NONE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine10POBOX 127
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine111 CARMEL PARKWAY
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine12745 N MILWAUKEE AVE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine13985 E MAPLEWOOD RD
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine14273 DEARBORN COURT
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine15400 E ILLINOIS ROAD
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine161800 GRAND AVENUE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine17PO BOX 13
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/AddressLine181700 N MILWAUKEE AVE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City0LIBERTYVILLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City1MUNDELEIN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City2LIBERTYVILLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City3LAKE FOREST
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City4GENEVA
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City5LAKE FOREST
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City6WAUKEGAN
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City7LIBERTYVILLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/City8LIBERTYVILLE
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State0IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State1IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State2IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State3IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State4IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State5IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State6IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State7IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/State8IL
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode060048
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode160060
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode260048
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode360045
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode460134
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode560045
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode660085
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode760048
IRS990PF/SupplementaryInformation/GrantOrContriPaidDuringYear/RecipientUSAddress/ZIPCode860048
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/TotGrantOrContriPaidDuringYear036430
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO0false
IRS990PF/UndistributedIncome/AppliedToCurrentYear035670
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted035670
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear201954
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear307065
IRS990PF/UndistributedIncome/ExcessDistriCarryoverYear50846
IRS990PF/UndistributedIncome/ExcessDistriCyovFromYear50846
IRS990PF/UndistributedIncome/ExcessDistriCyovToNextYear09779
IRS990PF/UndistributedIncome/ExcessFromCurrentYear0760
IRS990PF/UndistributedIncome/ExcessFromYear201954
IRS990PF/UndistributedIncome/ExcessFromYear307065
IRS990PF/UndistributedIncome/QualifyingDistributions036430
IRS990PF/UndistributedIncome/RemainingDistriFromCorpus0760
IRS990PF/UndistributedIncome/TotalCorpus010625
IRS990PF/UndistributedIncome/TotalExcessDistriCarryover09865
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
OtherIncomeSchedule2/OtherIncome/Description0OTHER INCOME
OtherIncomeSchedule2/OtherIncome/NetInvestmentIncome078
OtherIncomeSchedule2/OtherIncome/RevenueAndExpensesPerBooks078
OtherProfessionalFeesSchedule/OtherProfessionalFees/Amount06067
OtherProfessionalFeesSchedule/OtherProfessionalFees/Amount195
OtherProfessionalFeesSchedule/OtherProfessionalFees/Category0INVESTMENT FEES
OtherProfessionalFeesSchedule/OtherProfessionalFees/Category1PROFESSIONAL FEES
OtherProfessionalFeesSchedule/OtherProfessionalFees/NetInvestmentIncome06067
OtherProfessionalFeesSchedule/OtherProfessionalFees/NetInvestmentIncome195
TaxesSchedule/Taxes/Amount0162
TaxesSchedule/Taxes/Amount1400
TaxesSchedule/Taxes/Amount215
TaxesSchedule/Taxes/Category0FOREIGN TAXES
TaxesSchedule/Taxes/Category1FEDERAL TAX
TaxesSchedule/Taxes/Category2IL CHARITY BUREAU
TaxesSchedule/Taxes/NetInvestmentIncome0162
TaxesSchedule/Taxes/NetInvestmentIncome115
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/Filer/EIN0261507752
ReturnHeader/Filer/Name/BusinessNameLine10BERTAUD FAMILY FOUNDATION
ReturnHeader/Filer/NameControl0BERT
ReturnHeader/Filer/Phone08474415644
ReturnHeader/Filer/USAddress/AddressLine10345 WEST AUSTIN AVENUE
ReturnHeader/Filer/USAddress/City0LIBERTYVILLE
ReturnHeader/Filer/USAddress/State0IL
ReturnHeader/Filer/USAddress/ZIPCode060048
ReturnHeader/Officer/DateSigned02013-05-29
ReturnHeader/Officer/Name0FRANCOIS X BERTAUD
ReturnHeader/Officer/Phone08474415644
ReturnHeader/Officer/Title0PRESIDENT
ReturnHeader/Preparer/DatePrepared02013-05-29
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10HTH LLC CPA'S
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine10501 PETERSON ROAD
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0LIBERTYVILLE
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0IL
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0600481011
ReturnHeader/Preparer/Name0JILL L KUKSA CPA
ReturnHeader/Preparer/Phone08472470200
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-05-31T11:56:16-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$6.68$0.01$6.67$0.34$0.50$0.16
2023Detailed filing. Detailed filing data is available for this year.$6.84$0.00$6.84$0.25$0.45$0.20
2022Detailed filing. Detailed filing data is available for this year.$7.04$0.00$7.04$0.11$0.45$0.35
2021Detailed filing. Detailed filing data is available for this year.$7.38$0.00$7.38$0.39$0.56$0.17
2020Detailed filing. Detailed filing data is available for this year.$7.56$0.00$7.56$1.20$0.37$0.83
2019Detailed filing. Detailed filing data is available for this year.$6.73$0.00$6.73$0.24$0.52$0.28
2018Detailed filing. Detailed filing data is available for this year.$7.00$0.00$7.00$0.93$0.52$0.41
2017Detailed filing. Detailed filing data is available for this year.$6.60$0.00$6.60$0.45$0.51$0.05
2016Detailed filing. Detailed filing data is available for this year.$6.65$0.00$6.65$0.22$0.51$0.29
2015Detailed filing. Detailed filing data is available for this year.$6.94$0.00$6.94$0.73$0.52$0.21
2014Detailed filing. Detailed filing data is available for this year.$6.72$0.00$6.72$0.45$0.53$0.08
2013Detailed filing. Detailed filing data is available for this year.$6.80$0.00$6.80$0.32$0.51$0.19
2012Detailed filing. Detailed filing data is available for this year.$6.99$0.00$6.99$0.49
2011Detailed filing. Detailed filing data is available for this year.$7.39$0.00$7.39$0.52
2010Detailed filing. Detailed filing data is available for this year.$7.70$0.00$7.70$0.47