Civic Intelligence

The Ralph Manwarren Charitable Trust

990PF • Fiscal year 2020 • EIN 20-4239764

Jan 01, 2020 to Dec 31, 2020 • Filed on Feb 17, 2021

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

30th percentile

0.00x

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

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

Liabilities / Revenue

29th percentile

0.00x

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

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

Net Margin

3rd percentile

-267%

Higher net margin than 3% of similar nonprofits.

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

Top Officer Pay

48th percentile

$7,500

Higher top officer pay than 48% of similar nonprofits.

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

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

Asset Growth

19th percentile

-4.0%

Faster asset growth than 19% of similar nonprofits.

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

Revenue Growth

78th percentile

26%

Faster revenue growth than 78% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets30th percentile

Assets

Down

$1,064,704

Down $44,783 (-4.0%) from 2019

Net Assets

Down

$1,064,704

Down $44,783 (-4.0%) from 2019

Liabilities

Flat

$0

Flat from 2019

Revenue And Expenses
Liabilities / Revenue29th percentileNet Margin3rd percentile

Revenue

Up

$16,758

Up $3,451 (+26%) from 2019

Expenses

Down

$61,541

Down $33,484 (-35%) from 2019

Net Income

Up

-$44,783

Up $36,935 (+45%) from 2019

Historical Trend

Balance Sheet Trend

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

2020

Assets$1,064,704
Liabilities$0
Net Assets$1,064,704
Open 2020 Filing

Operations Trend

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

2020

Revenue$16,758
Expenses$61,541
Net Income-$44,783
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Feb 17, 2021
Return Version
2020v4.0
Compensation and Service Providers
Top Officer Pay48th 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
2021-02-17
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 Appendix321 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/Amt04000
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0Accounting Fees
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt04000
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt00
InvestmentsOtherSchedule2/InvestmentsOtherGrp/BookValueAmt01296
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0Advisors Tactical Incom
InvestmentsOtherSchedule2/InvestmentsOtherGrp/EOYFMVAmt01269
InvestmentsOtherSchedule2/InvestmentsOtherGrp/ListedAtCostOrFMVCd0AT COST
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionAmt028326
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt0-16528
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionAmt01096
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/OtherInvestmentIncmPartVIIGrp/ExclusionAmt03864
IRS990PF/AnalysisIncomeProducingActyGrp/OtherInvestmentIncmPartVIIGrp/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt016758
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt016758
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt04000
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt04000
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt010875
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt04125
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt015000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt041000
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt041000
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt028326
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt028326
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-44783
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0273947
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt01096
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt01096
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt0-16528
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt027645
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt025
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt01516
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt01541
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeNetInvstIncmAmt03864
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt03864
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt055900
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt05641
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt061541
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt033286
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt016758
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt014900
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt05641
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt020541
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0290475
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0-16528
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0-16528
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0273947
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0Publicly Traded Securities
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt0-16528
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-44783
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01064704
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01109487
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01064704
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt052389
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt052389
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt052389
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt052773
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0384
IRS990PF/DistributableAmountGrp/TotalTaxAmt0384
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt042
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/BackupWithholdingWithheldAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt0426
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExemptFrgnOrgTaxWthldAtSrceAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0384
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt042
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0384
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0384
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt0426
IRS990PF/FMVAssetsEOYAmt01064677
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt0828612
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYAmt01296
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt01269
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblAmt069749
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblBOYAmt070685
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblEOYAmt069749
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblEOYFMVAmt069749
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt01109487
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt01064704
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt0210190
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt0993659
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt0993659
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01109487
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt01064704
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01064677
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01109487
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt01064704
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01109487
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt01064704
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01071523
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt0328393
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0673381
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt016073
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt069749
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt052773
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01055450
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01071523
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/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt055900
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt055900
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt055900
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/Amt01000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt140000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Endowment fund.
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1Ag fund.
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0Southwest Initiative Foundation
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1Southwest Minnesota State University Foundation
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt015 3rd Avenue NW
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt11501 State Street
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Hutchinson
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1Marshall
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1MN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd055350
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd156258
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt041000
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/AppliedToCurrentYearAmt052389
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt00
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt052389
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt036439
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt09705
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt045985
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt064579
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0160219
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt03511
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt036439
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt09705
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt045985
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt064579
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt055900
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt03511
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0160219
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0156708
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0MN Filing Fee
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1Miscellaneous Investment Expense
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt025
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt11516
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt025
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt11516
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt03864
OtherIncomeSchedule2/OtherIncomeDetail/Desc0Loan Interest
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt03864
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt03864
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/BalanceDueAmt069749
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/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd02
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0Patrick Costello
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/PhoneNum05076626621
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-02-17
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/PreparationDt02021-02-17
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Deb Nelson CPA
ReturnHeader/ReturnTs02021-03-08T12:46:18-06:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0Patrick
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0Costello
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$1,064,704
Liabilities
$0
Net assets
$1,064,704
Revenue
$16,758
Expenses
$61,541
Net income
-$44,783
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. 2020 filings • $1M-$5M nonprofits