Civic Intelligence

Robert E Bartlett Family Foundation

EIN 86-6272604 • Moline, IL

2960 15th AvenueMoline, IL 61265
Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on the latest valid filing.

Source year 2020

Liabilities / Revenue

66th percentile

0.00x

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

<$500k nonprofits • Source year 2020

Net Margin

4th percentile

-1233%

Higher net margin than 4% of similar nonprofits.

<$500k nonprofits • Source year 2020

Top Officer Pay

81st percentile

$0

Higher top officer pay than 81% of similar nonprofits.

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

<$500k nonprofits • Source year 2020

Asset Growth

12th percentile

-100%

Faster asset growth than 12% of similar nonprofits.

<$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

11th percentile

-78%

Faster revenue growth than 11% of similar nonprofits.

<$500k nonprofits • Annualized from 2019 to 2020

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$0

Down $241,689 (-100%) from 2019

Liabilities

Flat

$0

Flat from 2019

Net Assets

Down

$0

Down $241,689 (-100%) from 2019

Operations
Liabilities / Revenue66th percentileNet Margin4th percentile

Revenue

Down

$19,599

Down $67,576 (-78%) from 2019

Expenses

Down

$261,288

Down $3,656,862 (-93%) from 2019

Net Income

Up

-$241,689

Up $3,589,286 (+94%) from 2019

Trend Graphs

Balance Sheet Trend

Asset Growth12th percentile

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

$300K$200K$100K$0Assets 2011: $1Liabilities 2011: $02011Assets 2012: $1Liabilities 2012: $02012Assets 2013: $1Liabilities 2013: $02013Assets 2015: $0Liabilities 2015: $0Net Assets 2015: $02015Assets 2019: $241,689Liabilities 2019: $0Net Assets 2019: $241,6892019Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020

Highlighted filing

2020

Assets$0
Liabilities$0
Net Assets$0
Open 2020 Filing

Operations Trend

Revenue Growth11th percentile

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

$4.0M$2.0M$0-$2.0M-$4.0MRevenue 2011: $1Expenses 2011: $0Net Income 2011: $12011Revenue 2012: $1Expenses 2012: $0Net Income 2012: $12012Revenue 2013: $1Expenses 2013: $0Net Income 2013: $12013Revenue 2015: $0Expenses 2015: $0Net Income 2015: $02015Revenue 2019: $87,175Expenses 2019: $3,918,150Net Income 2019: -$3,830,9752019Revenue 2020: $19,599Expenses 2020: $261,288Net Income 2020: -$241,6892020

Highlighted filing

2020

Revenue$19,599
Expenses$261,288
Net Income-$241,689
Open 2020 Filing

Filings

Most recent year

2020 • Form 990PFXML pending. An XML filing is linked for this year, but detailed extraction is still pending.

Open filing
Assets
$0
Liabilities
$0
Net assets
$0
Revenue
$19,599
Expenses
$261,288
Net income
-$241,689
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.00$0.00$0.00$0.02$0.26$0.24
2019XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.24$0.00$0.24$0.09$3.92$3.83
2015Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.00$0.00
2013Summary only. Only limited summary data is available for this year.$0.00$0.00$0.00$0.00$0.00
2012Summary only. Only limited summary data is available for this year.$0.00$0.00$0.00$0.00$0.00
2011Summary only. Only limited summary data is available for this year.$0.00$0.00$0.00$0.00$0.00
Latest Detailed Filing

The latest 2020 filing currently has linked XML that has not been fully parsed yet. Showing the latest detailed filing from 2015 below.

Jump To
Filing Snapshot
Filing Period
Jan 1, 2015 to Dec 31, 2015
Signed
Jul 25, 2016
Return Version
2015v2.0
Compensation and Service Providers
Top Officer Pay81st percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Deborah H BrackeTrustee-$0--
Thomas K BrackeTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Robert E Bartlett Family Foundation
EIN
86-6272604
Phone
3097646352
Address
2960 15th Avenue, Moline, IL 61265

Signing Officer

Name
Deborah H Bracke
Title
Trustee
Signed
2016-07-25
Discuss with paid preparer
Yes

Preparer

Firm
Kaiser & Carolin PC
Address
8767 E Via de Ventura Suite 270, Scottsdale, AZ 85258-3383
Preparer
Michael C Kaiser CPA
Phone
4809227074
Raw XML Appendix142 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
GeneralExplanationAttachment/GeneralExplanationGrp/FormAndLineReferenceDesc0General Explanation Supplemental Information for Form 990-PF
GeneralExplanationAttachment/GeneralExplanationGrp/MediumExplanationTxt0This entity had no activity during the tax year ended December 31, 2015.
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt00
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/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt10.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0Deborah H Bracke
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1Thomas K Bracke
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt02960 15th Avenue
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt12960 15th Avenue
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Moline
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1Moline
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd061265
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd161265
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/ExcessBusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/MaintainedExpenditureRspnsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProceedsOrNetIncomeInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0false
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0false
IRS990PF/StatementsRegardingActyGrp/Form990TFiledInd0false
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt08767 E Via De Ventura
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Scottsdale
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0AZ
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd085258
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0Kaiser & Carolin PC
IRS990PF/StatementsRegardingActyGrp/PhoneNum04809227074
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
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/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
ReturnHeader/BuildTS02016-09-27 15:27:22Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Deborah H Bracke
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/SignatureDt02016-07-25
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Robert E Bartlett Family Foundation
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0Deborah H Bracke Trustee
ReturnHeader/Filer/BusinessNameControlTxt0ROBE
ReturnHeader/Filer/EIN0866272604
ReturnHeader/Filer/PhoneNum03097646352
ReturnHeader/Filer/USAddress/AddressLine1Txt02960 15th Avenue
ReturnHeader/Filer/USAddress/CityNm0Moline
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd061265
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Kaiser & Carolin PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt08767 E Via de Ventura Suite 270
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Scottsdale
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0AZ
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0852583383
ReturnHeader/PreparerPersonGrp/PhoneNum04809227074
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Michael C Kaiser CPA
ReturnHeader/ReturnTs02016-07-25T08:12:49-07:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02015-01-01
ReturnHeader/TaxPeriodEndDt02015-12-31
ReturnHeader/TaxYr02015

Document Assets

No mirrored PDF or thumbnail assets are attached yet.