Civic Intelligence

The Ralph Manwarren Charitable Trust

990PF • Fiscal year 2019 • EIN 20-4239764

Jan 01, 2019 to Dec 31, 2019 • Filed on Mar 09, 2020

Organization Profile
PO Box 929 310 Main StLakefield, MN 56150

(507) 662-6621

Siviq Scores

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

Liabilities / Assets

29th percentile

0.00x

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

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

Liabilities / Revenue

29th percentile

0.00x

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

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

Net Margin

1st percentile

-614%

Higher net margin than 1% of similar nonprofits.

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

Top Officer Pay

46th percentile

$7,500

Higher top officer pay than 46% of similar nonprofits.

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

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

Asset Growth

14th percentile

-6.9%

Faster asset growth than 14% of similar nonprofits.

2019 filings • $1M-$5M nonprofits • Annualized from 2018 to 2019

Revenue Growth

4th percentile

-63%

Faster revenue growth than 4% of similar nonprofits.

2019 filings • $1M-$5M nonprofits • Annualized from 2018 to 2019

Balance Sheet
Liabilities / Assets29th percentile

Assets

Down

$1,109,487

Down $81,718 (-6.9%) from 2018

Net Assets

Down

$1,109,487

Down $81,718 (-6.9%) from 2018

Liabilities

Flat

$0

Flat from 2018

Revenue And Expenses
Liabilities / Revenue29th percentileNet Margin1st percentile

Revenue

Down

$13,307

Down $22,709 (-63%) from 2018

Expenses

Up

$95,025

Up $21,766 (+30%) from 2018

Net Income

Down

-$81,718

Down $44,475 (-119%) from 2018

Historical Trend

Balance Sheet Trend

Asset Growth14th 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

2019

Assets$1,109,487
Liabilities$0
Net Assets$1,109,487
Open 2019 Filing

Operations Trend

Revenue Growth4th 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

2019

Revenue$13,307
Expenses$95,025
Net Income-$81,718
Open 2019 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2019 to Dec 31, 2019
Signed
Mar 9, 2020
Return Version
2019v5.0
Compensation and Service Providers
Top Officer Pay46th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Robert GuntherTrustee-$7,500-$7,500
Patrick CostelloTrustee-$7,500-$7,500
Filing and Contact Details

Filer

Filer Name
The Ralph Manwarren Charitable Trust
EIN
20-4239764
Phone
5076626621
Address
PO Box 929 310 Main St, Lakefield, MN 56150

Signing Officer

Name
Patrick Costello
Title
Trustee
Phone
5076626621
Signed
2020-03-09
Discuss with paid preparer
Yes

Preparer

Firm
Eide Bailly LLP
Address
800 Nicollet Mall Ste 1300, Minneapolis, MN 55402-7033
Preparer
Deb Nelson CPA
Phone
6122536500
Raw XML Appendix355 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/Amt05000
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0Accounting Fees
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt05000
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt00
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt0178689
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt199923
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt2550000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0Advisors Tactical Incom
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1Nuveen PFD Income Opporturnities Fund
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt2United Bankers Bank - Bonds
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt0184084
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt195970
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt2550000
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd1AT COST
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd2AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt027174
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt0-18635
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt0841
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/OtherInvestmentIncmPartVIIGrp/ExclusionAmt03927
IRS990PF/AnalysisIncomeProducingActyGrp/OtherInvestmentIncmPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt013307
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt013307
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt05000
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt05000
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt010875
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt04125
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt015000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt075000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt075000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt027174
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt027174
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-81718
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0172075
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt0841
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt0841
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt0-18635
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt027817
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt025
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt025
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncmAmt03927
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt03927
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt090900
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt04125
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt095025
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt031942
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt013307
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt015900
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt04125
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt020025
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0190710
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-18635
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-18635
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0172075
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0LPL Financial
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt0-18635
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-81718
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01109487
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01191205
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01109487
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt054461
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt054461
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt054461
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt054739
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0278
IRS990PF/DistributableAmountGrp/TotalTaxAmt0278
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt0426
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0704
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0278
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt0426
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0278
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0278
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0704
IRS990PF/FMVAssetsEOYAmt01110929
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0834681
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt0828612
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt0830054
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblAmt070685
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblBOYAmt071571
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblEOYAmt070685
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblEOYFMVAmt070685
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt01191205
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt01109487
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0284953
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0210190
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0210190
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01191205
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01109487
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01110929
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01191205
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01109487
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01191205
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01109487
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01111460
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0272085
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0768690
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt016672
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt070685
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt054739
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01094788
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01111460
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/AddressLine1Txt0PO Box 28
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1PO Box 929
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Gambier
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1Lakefield
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0OH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1MN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd043022
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd156150
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt082086
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt082364
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt067657
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt0110821
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt0146981
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt096535
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt083364
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.074979
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.057741
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.084669
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.110638
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.067006
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.054840
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0278
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt01094788
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt01171734
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt01308871
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt01328489
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt01440693
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt01520143
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt090900
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.374894
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt090622
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt090900
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0278
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt090900
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/SubjToTaxRmnrtnExPrchtPymtInd00
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/AddressLine1Txt0PO Box 28
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Gambier
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0OH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd043022
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0MN
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0Robert Gunther
IRS990PF/StatementsRegardingActyGrp/PhoneNum05073609223
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/Amt110000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt255000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Baseball improvements.
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1Endowment fund.
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2Ag fund.
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0Jackson County Central School District
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1Southwest Initiative Foundation
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt2Southwest Minnesota State University Foundation
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0GOV
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt01128 N Hwy
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt115 3rd Avenue NW
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt21501 State Street
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Jackson
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1Hutchinson
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2Marshall
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd056143
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd155350
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd256258
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt075000
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/AppliedToCurrentYearAmt054461
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt054461
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt09705
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt045985
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt064579
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0156708
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt036439
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt09705
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt045985
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt064579
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt090900
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt036439
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0156708
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0120269
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0MN Filing Fee
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt025
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt025
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt03914
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt113
OtherIncomeSchedule2/OtherIncomeDetail/Desc0Loan Interest
OtherIncomeSchedule2/OtherIncomeDetail/Desc1Miscellaneous Investment Income
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt03914
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt113
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt03914
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt113
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/BalanceDueAmt070685
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/BorrowerNameGrp/PersonNm0Richard G Grein and Cheryl A Grein
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/ConsiderationFMVAmt073000
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/InsiderRelationshipTxt0None
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/InterestRt05.500000000000
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/LenderConsiderationDesc0Cash
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/LoanMaturityDt02050-04
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/LoanOriginalAmt073000
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/LoanPurposeTxt0Below Market Rate Mortgage
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/NoteDt02017-10
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/RepaymentTermsTxt0$400 Monthly installments due on the 20th.
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/SecurityProvidedBorrowerTxt0Property
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0Patrick Costello
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/PhoneNum05076626621
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-03-09
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0The Ralph Manwarren Charitable Trust
ReturnHeader/Filer/BusinessNameControlTxt0RALP
ReturnHeader/Filer/EIN0204239764
ReturnHeader/Filer/PhoneNum05076626621
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO Box 929 310 Main St
ReturnHeader/Filer/USAddress/CityNm0Lakefield
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MN
ReturnHeader/Filer/USAddress/ZIPCd056150
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0450250958
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Eide Bailly LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0800 Nicollet Mall Ste 1300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Minneapolis
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0554027033
ReturnHeader/PreparerPersonGrp/PhoneNum06122536500
ReturnHeader/PreparerPersonGrp/PreparationDt02020-03-09
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Deb Nelson CPA
ReturnHeader/ReturnTs02020-03-12T15:20:34-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02019-01-01
ReturnHeader/TaxPeriodEndDt02019-12-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,109,487
Liabilities
$0
Net assets
$1,109,487
Revenue
$13,307
Expenses
$95,025
Net income
-$81,718
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