Civic Intelligence

Henry L and Geraldine D Metzger Charitable Tr

990PF • Fiscal year 2015 • EIN 81-6127516

Jan 01, 2015 to Dec 31, 2015 • Filed on Jun 16, 2016

c/o S Sheridan 8800 Lyra Dr No 450Columbus, OH 43240

(614) 340-6677

Siviq Scores

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

Liabilities / Assets

28th percentile

0.00x

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

2015 filings • $1M-$5M nonprofits • Source year 2015

Liabilities / Revenue

29th percentile

0.00x

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

2015 filings • $1M-$5M nonprofits • Source year 2015

Net Margin

6th percentile

-113%

Higher net margin than 6% of similar nonprofits.

2015 filings • $1M-$5M nonprofits • Source year 2015

Top Officer Pay

43rd percentile

$3,396

Higher top officer pay than 43% of similar nonprofits.

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

2015 filings • $1M-$5M nonprofits • Source year 2015

Asset Growth

12th percentile

-9.3%

Faster asset growth than 12% of similar nonprofits.

2015 filings • $1M-$5M nonprofits • Annualized from 2014 to 2015

Revenue Growth

7th percentile

-57%

Faster revenue growth than 7% of similar nonprofits.

2015 filings • $1M-$5M nonprofits • Annualized from 2014 to 2015

Assets

Down

$1,357,371

Down $139,962 (-9.3%) from 2014

Net Assets

Down

$1,357,371

Down $139,962 (-9.3%) from 2014

Liabilities

Flat

$1

Flat from 2014

Revenue

Down

$41,576

Down $54,862 (-57%) from 2014

Expenses

Down

$88,366

Down $27,737 (-24%) from 2014

Net Income

Down

-$46,790

Down $27,125 (-138%) from 2014

Historical Trend

Balance Sheet Trend

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

$2.0M$1.5M$1.0M$500K$0Assets 2010: $1,548,234Liabilities 2010: $0Net Assets 2010: $1,548,2342010Assets 2011: $1,474,792Liabilities 2011: $50,000Net Assets 2011: $1,424,7922011Assets 2012: $1,506,672Liabilities 2012: $0Net Assets 2012: $1,506,6722012Assets 2013: $1,597,941Liabilities 2013: $1Net Assets 2013: $1,597,9412013Assets 2014: $1,497,333Liabilities 2014: $1Net Assets 2014: $1,497,3332014Assets 2015: $1,357,371Liabilities 2015: $1Net Assets 2015: $1,357,3712015Assets 2016: $1,367,482Liabilities 2016: $0Net Assets 2016: $1,367,4822016Assets 2017: $1,468,636Liabilities 2017: $0Net Assets 2017: $1,468,6362017Assets 2018: $1,310,093Liabilities 2018: $0Net Assets 2018: $1,310,0932018Assets 2019: $1,278,722Liabilities 2019: $1Net Assets 2019: $1,278,7222019Assets 2020: $1,245,400Liabilities 2020: $1Net Assets 2020: $1,245,4002020Assets 2021: $70,446Liabilities 2021: $1Net Assets 2021: $70,4462021Assets 2022: $1,529Liabilities 2022: $0Net Assets 2022: $1,5292022Assets 2023: $0Liabilities 2023: $0Net Assets 2023: $02023

Highlighted filing

2015

Assets$1,357,371
Liabilities$1
Net Assets$1,357,371

Operations Trend

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

$2.0M$1.0M$0-$1.0M-$2.0MExpenses 2010: $78,5412010Expenses 2011: $97,6212011Expenses 2012: $98,2802012Revenue 2013: $58,815Expenses 2013: $96,737Net Income 2013: -$37,9222013Revenue 2014: $96,438Expenses 2014: $116,103Net Income 2014: -$19,6652014Revenue 2015: $41,576Expenses 2015: $88,366Net Income 2015: -$46,7902015Revenue 2016: $23,201Expenses 2016: $105,626Net Income 2016: -$82,4252016Revenue 2017: $61,764Expenses 2017: $77,412Net Income 2017: -$15,6482017Revenue 2018: $66,489Expenses 2018: $89,820Net Income 2018: -$23,3312018Revenue 2019: $50,370Expenses 2019: $81,741Net Income 2019: -$31,3712019Revenue 2020: $57,254Expenses 2020: $90,576Net Income 2020: -$33,3222020Revenue 2021: $269,798Expenses 2021: $1,585,901Net Income 2021: -$1,316,1032021Revenue 2022: $20Expenses 2022: $68,937Net Income 2022: -$68,9172022Revenue 2023: $3,760Expenses 2023: $5,289Net Income 2023: -$1,5292023

Highlighted filing

2015

Revenue$41,576
Expenses$88,366
Net Income-$46,790
Jump To
Filing Snapshot
Filing Period
Jan 1, 2015 to Dec 31, 2015
Signed
Jun 16, 2016
Return Version
2015v2.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
ALBERT SHERIDANTrustee-$3,396-$3,396
STEPHEN SHERIDANTrustee-$2,717-$2,717
PHILIP SHERIDANTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Henry L & Geraldine D Metzger
EIN
81-6127516
Phone
6143406677
Address
c/o S Sheridan 8800 Lyra Dr No 450, Columbus, OH 43240

Signing Officer

Name
Stephen Sheridan
Title
trustee
Phone
6143406677
Signed
2016-06-16
Discuss with paid preparer
Yes

Preparer

Firm
Blue & Co LLC
Address
8800 Lyra Drive Suite 450, Columbus, OH 43240
Preparer
Nancy Kirchner
Phone
6148852583
Raw XML Appendix362 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/AccountingFeesDetail/Amt010475
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt00
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt00
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt01328143
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt01328143
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt029909
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt011659
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt08
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt041576
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt041576
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt010475
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt011659
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt06113
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt071400
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt071400
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt029909
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt029909
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-46790
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0117771
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt08
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt08
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt011659
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt041576
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt091
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0287
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt071400
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt088366
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt041576
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt041576
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt016966
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt03292
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt155193
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt215061
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt332566
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-497
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt1-8008
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt24919
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt3-2586
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt417831
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-497
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt1-8008
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt24919
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt3-2586
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt417831
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt02795
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt147185
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt219980
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt329980
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt417831
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd2P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd3P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd4P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0AMERICAN HIGH INCOME
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1AMERICAN HIGH INCOME
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2GROWTH FUND OF AMERICA
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc3NEW WORLD A
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc4Capital Gains Dividends
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt011659
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-46790
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt093172
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01450543
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01497333
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01357371
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt071892
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt071892
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt071892
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt072724
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0832
IRS990PF/DistributableAmountGrp/TotalTaxAmt0832
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0404
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt01236
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0832
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0404
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0832
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0832
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt01236
IRS990PF/FMVAssetsEOYAmt01357371
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt01173728
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt01328143
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt01328143
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt01497333
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt01357371
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0323605
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt029228
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt029228
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01497333
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01357371
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01357371
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01497333
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01357371
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01497333
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01357371
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01476624
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt024899
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01451725
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt022149
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt072724
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01454475
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01476624
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt11.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt21.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt13396
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt22717
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/PersonNm0PHILIP SHERIDAN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1ALBERT SHERIDAN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2STEPHEN SHERIDAN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt01755 S STREET NW UNIT 9
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1433 BROOKSIDE DRIVE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt25948 tournament drive
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0WASHINGTON
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1COLUMBUS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2westerville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0DC
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1OH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2OH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd020009
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd143209
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd243082
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt073066
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt073482
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt091424
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt076000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt076500
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt071759
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt065872
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.050235
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.059926
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.048550
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.050773
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.047026
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.044902
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0416
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt01454475
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt01525627
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt01565401
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt01506711
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt01525950
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt01467002
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt071400
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.251177
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt071400
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt071400
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt071400
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd00
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0STEPHEN A SHERIDAN
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt08800 Lyra Drive Suite 450
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Columbus
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0OH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd043240
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0OH
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PhoneNum06143406677
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd01
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt010000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt146400
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt210000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt35000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0support of organization's mission
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1university support and scholarships
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2SUPPORT ORGANIZATION'S MISSION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3SUPPORT ORGANIZATION'S MISSION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0arthritis foundation
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1ohio northern university
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt2THE RONALD MCDONALD HOUSE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt3THE GAHANNA RELAY FOR LIFE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0501(c)(3)
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1501(c)(3)
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2501(c)(3)
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3501(c)(3)
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0none
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1none
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt03740 ridge mill dr
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt1525 s main street
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt2350 ERKENBRECHER AVE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt35555 FRANTZ ROAD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0hilliard
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1ada
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2CINCINNATI
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3DUBLIN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0OH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1OH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2OH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3OH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd043026
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd145810
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd245229
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd343017
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt071400
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt013303
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt058097
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt071892
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt071400
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt058589
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt058097
OtherDecreasesSchedule/OtherDecreasesDetail/Amt091926
OtherDecreasesSchedule/OtherDecreasesDetail/Amt11246
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0NET CHANGE IN UNREALIZED LOSS ON INVESTMENTS
OtherDecreasesSchedule/OtherDecreasesDetail/Desc1federal income taxes
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0court fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1bank fees
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt050
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt141
TaxesSchedule/TaxesDetail/Amt0287
TaxesSchedule/TaxesDetail/CategoryTxt0FOREIGN TAXES
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/BuildTS02016-09-27 15:27:22Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0Stephen Sheridan
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0trustee
ReturnHeader/BusinessOfficerGrp/PhoneNum06143406677
ReturnHeader/BusinessOfficerGrp/SignatureDt02016-06-16
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Henry L & Geraldine D Metzger
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0Charitable Trust
ReturnHeader/Filer/BusinessNameControlTxt0METZ
ReturnHeader/Filer/EIN0816127516
ReturnHeader/Filer/PhoneNum06143406677
ReturnHeader/Filer/USAddress/AddressLine1Txt0c/o S Sheridan 8800 Lyra Dr No 450
ReturnHeader/Filer/USAddress/CityNm0Columbus
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd043240
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0351178661
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Blue & Co LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt08800 Lyra Drive Suite 450
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Columbus
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd043240
ReturnHeader/PreparerPersonGrp/PhoneNum06148852583
ReturnHeader/PreparerPersonGrp/PreparationDt02016-06-16
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Nancy Kirchner
ReturnHeader/ReturnTs02016-06-17T08:37:16-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02015-01-01
ReturnHeader/TaxPeriodEndDt02015-12-31
ReturnHeader/TaxYr02015

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.01$0.00
2022Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.07$0.07
2021Detailed filing. Detailed filing data is available for this year.$0.07$0.00$0.07$0.27$1.59$1.32
2020Detailed filing. Detailed filing data is available for this year.$1.25$0.00$1.25$0.06$0.09$0.03
2019Detailed filing. Detailed filing data is available for this year.$1.28$0.00$1.28$0.05$0.08$0.03
2018Detailed filing. Detailed filing data is available for this year.$1.31$0.00$1.31$0.07$0.09$0.02
2017Detailed filing. Detailed filing data is available for this year.$1.47$0.00$1.47$0.06$0.08$0.02
2016Detailed filing. Detailed filing data is available for this year.$1.37$0.00$1.37$0.02$0.11$0.08
2015Detailed filing. Detailed filing data is available for this year.$1.36$0.00$1.36$0.04$0.09$0.05
2014Detailed filing. Detailed filing data is available for this year.$1.50$0.00$1.50$0.10$0.12$0.02
2013Detailed filing. Detailed filing data is available for this year.$1.60$0.00$1.60$0.06$0.10$0.04
2012Detailed filing. Detailed filing data is available for this year.$1.51$0.00$1.51$0.10
2011Detailed filing. Detailed filing data is available for this year.$1.47$0.05$1.42$0.10
2010Detailed filing. Detailed filing data is available for this year.$1.55$0.00$1.55$0.08