Civic Intelligence

Wagner Edelman Family Foundation

EIN 81-1077915 • Olathe, KS

122636 S HalletOlathe, KS 66062
Siviq Scores

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

Liabilities / Assets

95th percentile

1.00x

Higher debt load relative to assets than 95% of similar nonprofits.

<$500k nonprofits • Source year 2019

Liabilities / Revenue

66th percentile

0.00x

Higher debt load relative to revenue than 66% of similar nonprofits.

<$500k nonprofits • Source year 2019

Net Margin

95th percentile

83%

Higher net margin than 95% of similar nonprofits.

<$500k nonprofits • Source year 2019

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 2019

Asset Growth

12th percentile

-100%

Faster asset growth than 12% of similar nonprofits.

<$500k nonprofits • Annualized from 2018 to 2019

Revenue Growth

19th percentile

-49%

Faster revenue growth than 19% of similar nonprofits.

<$500k nonprofits • Annualized from 2018 to 2019

Assets

Down

$1

Down $58,702 (-100%) from 2018

Liabilities

Up

$1

Up $1 from 2018

Net Assets

Down

$0

Down $58,703 (-100%) from 2018

Revenue

Down

$159,367

Down $152,513 (-49%) from 2018

Expenses

Down

$27,394

Down $201,087 (-88%) from 2018

Net Income

Up

$131,973

Up $48,574 (+58%) from 2018

Trend Graphs

Balance Sheet Trend

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

$800K$600K$400K$200K$0Assets 2016: $605,266Liabilities 2016: $0Net Assets 2016: $605,2662016Assets 2018: $58,703Liabilities 2018: $0Net Assets 2018: $58,7032018Assets 2019: $1Liabilities 2019: $1Net Assets 2019: $02019

Highlighted filing

2019

Assets$1
Liabilities$1
Net Assets$0

Operations Trend

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

$400K$300K$200K$100K$0Revenue 2016: $5,654Expenses 2016: $5,000Net Income 2016: $6542016Revenue 2018: $311,880Expenses 2018: $228,481Net Income 2018: $83,3992018Revenue 2019: $159,367Expenses 2019: $27,394Net Income 2019: $131,9732019

Highlighted filing

2019

Revenue$159,367
Expenses$27,394
Net Income$131,973

Filings

Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2019 to Dec 31, 2019
Signed
Apr 30, 2021
Return Version
2019v5.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
JUDY WAGNERTrusteePT$0--
Robert WagnerTrusteePT$0--
Gregory WagnerManagerPT$0--
Filing and Contact Details

Filer

Filer Name
Wagner Edelman Family Foundation
EIN
81-1077915
Address
122636 S HALLET, Olathe, KS 66062

Signing Officer

Name
Judy Wagner
Title
Trustee
Phone
9136360888
Signed
2021-04-30
Discuss with paid preparer
No

Preparer

Firm
Tax Bureau Service Corp
Address
1835 NW 112 AVE STE 164, Miami, FL 33172
Preparer
Laura Sanchez
Phone
6469964212
Raw XML Appendix194 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
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd003
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt023669
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt0159426
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0131973
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt013
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt03725
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt0-72
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt027394
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt0159367
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt03725
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0131973
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0190676
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt058703
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0190676
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/FMVAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt018500
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt058703
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt040203
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt058703
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt058703
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt058703
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt00
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt00
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt00
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt025.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt120.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt210.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0JUDY WAGNER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1Robert Wagner
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2Gregory Wagner
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2Manager
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt012636 S HALLET Street
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt112636 S Hallet Street
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt29905 W 61St Street
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Olathe
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1Olathe
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2Shawnee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0KS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1KS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2KS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd066062
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd166062
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd266203
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0false
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0false
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0JUDY WAGNER
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt012636 S HALLET ST
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Olathe
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0KS
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd066062
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum09136360888
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0None
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0NONE
IRS990PF/SumOfProgramRelatedInvstGrp/Expenses1Amt00
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0JUDY WAGNER
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm1Robert Wagner
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm2Gregory Wagner
IRS990PF/SupplementaryInformationGrp/ShareholderManagerNm0None
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt00
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/ExcessDistributionCyovYr1Amt0228481
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0228481
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt0228481
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0228481
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0228481
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/ContributorInformationGrp/ContributorNum01
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm0JR WAGNER FAMILY IRR TRUST
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt012636 S HALLET
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm0Olathe
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd0KS
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd066062
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt09426
IRS990ScheduleB/GeneralRuleInd0X
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Operations
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1Contract Services
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0395
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt13330
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt00
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt10
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt20
OtherIncomeSchedule2/OtherIncomeDetail/Desc0Arkansas MISS LP
OtherIncomeSchedule2/OtherIncomeDetail/Desc1Chartered Medical Solutions II
OtherIncomeSchedule2/OtherIncomeDetail/Desc2Chartered Medical Solutions LP
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt00
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt10
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt20
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt0-19
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt1-18
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt2-35
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0JUDY WAGNER
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum09136360888
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-04-30
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0WAGNER EDELMAN FAMILY FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0WAGN
ReturnHeader/Filer/EIN0811077915
ReturnHeader/Filer/USAddress/AddressLine1Txt0122636 S HALLET
ReturnHeader/Filer/USAddress/CityNm0Olathe
ReturnHeader/Filer/USAddress/StateAbbreviationCd0KS
ReturnHeader/Filer/USAddress/ZIPCd066062
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0TAX BUREAU SERVICE CORP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01835 NW 112 AVE STE 164
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Miami
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0FL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd033172
ReturnHeader/PreparerPersonGrp/PhoneNum06469964212
ReturnHeader/PreparerPersonGrp/PreparationDt02021-07-22
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0LAURA SANCHEZ
ReturnHeader/ReturnTs02021-07-22T16:37:12-04:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02019-01-01
ReturnHeader/TaxPeriodEndDt02019-12-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.