Civic Intelligence

The Ralph Manwarren Charitable Trust

990PF • Fiscal year 2013 • EIN 20-4239764

Jan 01, 2013 to Dec 31, 2013 • Filed on May 01, 2014

Organization Profile
PO Box 929 310 Main St56150

(507) 662-6621

Siviq Scores

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

Liabilities / Assets

27th percentile

0.00x

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

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

Liabilities / Revenue

30th percentile

0.00x

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

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

Net Margin

7th percentile

-73%

Higher net margin than 7% of similar nonprofits.

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

Top Officer Pay

50th percentile

$7,500

Higher top officer pay than 50% of similar nonprofits.

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

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

Asset Growth

21st percentile

-4.1%

Faster asset growth than 21% of similar nonprofits.

2013 filings • $1M-$5M nonprofits • Annualized from 2011 to 2013

Revenue Growth

58th percentile

8.3%

Faster revenue growth than 58% of similar nonprofits.

2013 filings • $1M-$5M nonprofits • Annualized from 2011 to 2013

Balance Sheet
Liabilities / Assets27th percentile

Assets

Down

$1,552,291

Down $133,824 (-7.9%) from 2011

Net Assets

$1,552,291

No earlier filing loaded for comparison.

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / Revenue30th percentileNet Margin7th percentile

Revenue

Up

$43,755

Up $6,445 (+17%) from 2011

Expenses

Down

$75,800

Down $40,453 (-35%) from 2011

Net Income

Up

-$32,045

Up $46,898 (+59%) from 2011

Historical Trend

Balance Sheet Trend

Asset Growth21st percentile

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

$2.0M$1.5M$1.0M$500K$0Assets 2007: $1,183,046Liabilities 2007: $02007Assets 2008: $1,705,214Liabilities 2008: $02008Assets 2009: $1,690,419Liabilities 2009: $02009Assets 2010: $1,761,150Liabilities 2010: $02010Assets 2011: $1,686,115Liabilities 2011: $02011Assets 2013: $1,552,291Liabilities 2013: $0Net Assets 2013: $1,552,2912013Assets 2014: $1,524,961Liabilities 2014: $0Net Assets 2014: $1,524,9612014Assets 2015: $1,452,198Liabilities 2015: $0Net Assets 2015: $1,452,1982015Assets 2016: $1,309,148Liabilities 2016: $0Net Assets 2016: $1,309,1482016Assets 2017: $1,228,448Liabilities 2017: $0Net Assets 2017: $1,228,4482017Assets 2018: $1,191,205Liabilities 2018: $0Net Assets 2018: $1,191,2052018Assets 2019: $1,109,487Liabilities 2019: $0Net Assets 2019: $1,109,4872019Assets 2020: $1,064,704Liabilities 2020: $0Net Assets 2020: $1,064,7042020Assets 2021: $1,013,266Liabilities 2021: $0Net Assets 2021: $1,013,2662021Assets 2022: $951,120Liabilities 2022: $0Net Assets 2022: $951,1202022Assets 2023: $946,003Liabilities 2023: $0Net Assets 2023: $946,0032023Assets 2024: $836,339Liabilities 2024: $0Net Assets 2024: $836,3392024Assets 2025: $545,145Liabilities 2025: $0Net Assets 2025: $545,1452025

Highlighted filing

2013

Assets$1,552,291
Liabilities$0
Net Assets$1,552,291
Open 2013 Filing

Operations Trend

Revenue Growth58th percentile

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

$1.0M$500K$0-$500KRevenue 2007: $255,159Expenses 2007: $10,136Net Income 2007: $245,0232007Revenue 2008: $593,153Expenses 2008: $70,985Net Income 2008: $522,1682008Revenue 2009: $56,687Expenses 2009: $71,482Net Income 2009: -$14,7952009Revenue 2010: $171,135Expenses 2010: $100,404Net Income 2010: $70,7312010Revenue 2011: $37,310Expenses 2011: $116,253Net Income 2011: -$78,9432011Revenue 2013: $43,755Expenses 2013: $75,800Net Income 2013: -$32,0452013Revenue 2014: $62,052Expenses 2014: $89,382Net Income 2014: -$27,3302014Revenue 2015: $33,894Expenses 2015: $106,657Net Income 2015: -$72,7632015Revenue 2016: $8,449Expenses 2016: $151,499Net Income 2016: -$143,0502016Revenue 2017: $37,044Expenses 2017: $117,744Net Income 2017: -$80,7002017Revenue 2018: $36,016Expenses 2018: $73,259Net Income 2018: -$37,2432018Revenue 2019: $13,307Expenses 2019: $95,025Net Income 2019: -$81,7182019Revenue 2020: $16,758Expenses 2020: $61,541Net Income 2020: -$44,7832020Revenue 2021: $8,553Expenses 2021: $59,991Net Income 2021: -$51,4382021Revenue 2022: $5,979Expenses 2022: $68,125Net Income 2022: -$62,1462022Revenue 2023: $16,233Expenses 2023: $21,350Net Income 2023: -$5,1172023Revenue 2024: $14,336Expenses 2024: $124,000Net Income 2024: -$109,6642024Revenue 2025: $13,164Expenses 2025: $304,358Net Income 2025: -$291,1942025

Highlighted filing

2013

Revenue$43,755
Expenses$75,800
Net Income-$32,045
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2013 to Dec 31, 2013
Signed
May 1, 2014
Return Version
2013v3.0
Compensation and Service Providers
Top Officer Pay50th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
ROBERT GUNTHERTrustee-$7,500-$7,500
PATRICK COSTELLOTrustee-$7,500-$7,500
Filing and Contact Details

Filer

EIN
20-4239764
Phone
5076626621

Signing Officer

Name
Patrick Costello
Title
Trustee
Phone
5076626621
Signed
2014-05-01
Discuss with paid preparer
Yes

Preparer

Preparer
Deb Nelson CPA
Phone
6122536500
Raw XML Appendix341 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/Amt03750
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING FEES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt03750
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt00
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm0BOND FUND OF AMERICA INC. CLASS A
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm1CAPITAL INCOME BLDR. FUND CLASS A
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/BondNm2INCOME FUND OF AMERICA INC. CLASS A
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt053000
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt133000
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYBookValueAmt233000
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt048574
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt129803
InvestmentsCorpBondsSchedule/InvestmentsCorporateBondsGrp/EOYFMVAmt233937
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt045723
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt141263
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt059007
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt148892
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0AMCAP FUND INC. CLASS A
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm1AMERICAN MUTUAL FUND INC. CLASS A
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt0163887
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt1100111
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt2915000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0ADVISORS DISCIPLINED UNIT 927 TACTICAL
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1NUVEEN MULTI STRATEGY INCOME & GROWTH
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2UNITED BANKERS BANK - BONDS
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt0176769
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt181382
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt2915000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd2AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt032950
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt09584
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt0494
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/OtherInvestmentIncmPartVIIGrp/ExclusionAmt0727
IRS990PF/AnalysisIncomeProducingActyGrp/OtherInvestmentIncmPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt043755
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt043755
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt03750
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt03750
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt09584
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt010875
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt04125
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt015000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt055000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt055000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt032950
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt032950
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-32045
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt09584
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt0494
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt0494
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt09584
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt039280
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncmAmt0727
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt0727
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt030
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt030
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesNetInvstIncmAmt0320
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt02020
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt069625
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt04475
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt075800
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt043755
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt043755
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt014625
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt04475
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt020800
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt09584
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt09584
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt09584
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt09584
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-32045
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01552291
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01584336
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01552291
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt076603
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt076603
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt076603
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt077389
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0786
IRS990PF/DistributableAmountGrp/TotalTaxAmt0786
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt074
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0860
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0786
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt074
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0786
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0786
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0860
IRS990PF/FMVAssetsEOYAmt01560671
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsBOYAmt0119000
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYAmt0119000
IRS990PF/Form990PFBalanceSheetsGrp/CorporateBondsEOYFMVAmt0112314
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt081635
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt086986
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0107899
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt01165861
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt01178998
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt01173151
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt01584336
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt01552291
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0217840
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0167307
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0167307
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01584336
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01552291
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01560671
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01584336
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01552291
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01584336
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01552291
IRS990PF/InitialReturnFormerPubChrtyInd0X
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01571351
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0196675
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01374676
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt023570
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt077389
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01547781
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01571351
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.25
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt11.25
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt07500
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt17500
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0ROBERT GUNTHER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1PATRICK COSTELLO
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine10313 SW GREENWOOD AVENUE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine11PO BOX 929
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City0TOPEKA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City1LAKEFIELD
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State0KS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State1MN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode066606
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode156150
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd01
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt069625
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt069625
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt069625
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd00
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/PayCompDisqualifiedPrsnInd01
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/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine10313 SW GREENWOOD AVENUE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/City0TOPEKA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/State0KS
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCode066606
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MN
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine10ROBERT GUNTHER
IRS990PF/StatementsRegardingActyGrp/PhoneNum07854401026
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/Amt020000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt110000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt210000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt315000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GENERAL OPERATIONS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1GENERAL OPERATIONS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2GENERAL OPERATIONS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3GENERAL OPERATIONS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine10ALPHA GAMMA RHO LAMBDA CHAPTER EDUCATIONAL FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine11SOUTHWEST INITIATIVE FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine12SOUTHWEST MINNESOTA STATE UNIVERSITY FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine13HURON LAKE-OKABENA COMMUNITY FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine10PO BOX 8221
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1115 3RD AVENUE NW
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine121501 STATE STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine13C/O SWIF 15 3RD AVENUE NW
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City0ST PAUL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City1HUTCHINSON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City2MARSHALL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City3HUTCHINSON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State0MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State1MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State2MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State3MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode055108
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode155350
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode256258
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode355350
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt055000
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/AppliedToCurrentYearAmt026470
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt043155
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt076603
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt069625
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt050133
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt043155
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt0727
OtherIncomeSchedule2/OtherIncomeDetail/Desc0OTHER INVESTMENT INCOME
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt0727
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt0727
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt030
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0INVESTMENT MANAGEMENT FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt030
TaxesSchedule/TaxesDetail/Amt01700
TaxesSchedule/TaxesDetail/Amt1320
TaxesSchedule/TaxesDetail/CategoryTxt0EXCISE TAXES
TaxesSchedule/TaxesDetail/CategoryTxt1FOREIGN TAXES
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt1320
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0PATRICK COSTELLO
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum05076626621
ReturnHeader/BusinessOfficerGrp/SignatureDt02014-05-01
ReturnHeader/Filer/BusinessName/BusinessNameLine10THE RALPH MANWARREN CHARITABLE TRUST
ReturnHeader/Filer/BusinessNameControlTxt0RALP
ReturnHeader/Filer/EIN0204239764
ReturnHeader/Filer/PhoneNum05076626621
ReturnHeader/Filer/USAddress/AddressLine10PO BOX 929 310 MAIN ST
ReturnHeader/Filer/USAddress/City0LAKEFIELD
ReturnHeader/Filer/USAddress/State0MN
ReturnHeader/Filer/USAddress/ZIPCode056150
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0450250958
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine10EIDE BAILLY LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine10800 NICOLLET MALL STE 1300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/City0MINNEAPOLIS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/State0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCode0554027033
ReturnHeader/PreparerPersonGrp/PhoneNum06122536500
ReturnHeader/PreparerPersonGrp/PreparationDt02014-04-30
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DEB NELSON CPA
ReturnHeader/ReturnTs02014-05-01T07:17:53-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02013-01-01
ReturnHeader/TaxPeriodEndDt02013-12-31
ReturnHeader/TaxYr02013

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2013 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$1,552,291
Liabilities
$0
Net assets
$1,552,291
Revenue
$43,755
Expenses
$75,800
Net income
-$32,045
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$0.55$0.00$0.55$0.01$0.30$0.29
2024Detailed filing. Detailed filing data is available for this year.$0.84$0.00$0.84$0.01$0.12$0.11
2023Detailed filing. Detailed filing data is available for this year.$0.95$0.00$0.95$0.02$0.02$0.01
2022Detailed filing. Detailed filing data is available for this year.$0.95$0.00$0.95$0.01$0.07$0.06
2021Detailed filing. Detailed filing data is available for this year.$1.01$0.00$1.01$0.01$0.06$0.05
2020Detailed filing. Detailed filing data is available for this year.$1.06$0.00$1.06$0.02$0.06$0.04
2019Detailed filing. Detailed filing data is available for this year.$1.11$0.00$1.11$0.01$0.10$0.08
2018Detailed filing. Detailed filing data is available for this year.$1.19$0.00$1.19$0.04$0.07$0.04
2017Detailed filing. Detailed filing data is available for this year.$1.23$0.00$1.23$0.04$0.12$0.08
2016Detailed filing. Detailed filing data is available for this year.$1.31$0.00$1.31$0.01$0.15$0.14
2015Detailed filing. Detailed filing data is available for this year.$1.45$0.00$1.45$0.03$0.11$0.07
2014Detailed filing. Detailed filing data is available for this year.$1.52$0.00$1.52$0.06$0.09$0.03
2013Detailed filing. Detailed filing data is available for this year.$1.55$0.00$1.55$0.04$0.08$0.03
2011Summary only. Only limited summary data is available for this year.$1.69$0.00$0.04$0.12$0.08
2010Summary only. Only limited summary data is available for this year.$1.76$0.00$0.17$0.10$0.07
2009Summary only. Only limited summary data is available for this year.$1.69$0.00$0.06$0.07$0.01
2008Summary only. Only limited summary data is available for this year.$1.71$0.00$0.59$0.07$0.52
2007Summary only. Only limited summary data is available for this year.$1.18$0.00$0.26$0.01$0.25
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2013 filings • $1M-$5M nonprofits