Civic Intelligence

Rose G Deal Educational Charitable Trus

EIN 45-6973021 • Rossville, TN

425 Crangle RoadRossville, TN 38066
Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on the latest valid filing.

Source year 2017

Liabilities / Revenue

66th percentile

0.00x

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

<$500k nonprofits • Source year 2017

Net Margin

1st percentile

-1819675%

Higher net margin than 1% of similar nonprofits.

<$500k nonprofits • Source year 2017

Top Officer Pay

81st percentile

$0

Higher top officer pay than 81% of similar nonprofits.

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

<$500k nonprofits • Source year 2017

Asset Growth

12th percentile

-100%

Faster asset growth than 12% of similar nonprofits.

<$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

5th percentile

-99%

Faster revenue growth than 5% of similar nonprofits.

<$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$0

Down $72,787 (-100%) from 2016

Liabilities

Flat

$0

Flat from 2016

Net Assets

Down

$0

Down $72,787 (-100%) from 2016

Operations
Liabilities / Revenue66th percentileNet Margin1st percentile

Revenue

Down

$4

Down $396 (-99%) from 2016

Expenses

Down

$72,791

Down $4,196,184 (-98%) from 2016

Net Income

Up

-$72,787

Up $4,195,788 (+98%) from 2016

Trend Graphs

Balance Sheet Trend

Asset Growth12th percentile

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

$6.0M$4.0M$2.0M$0Assets 2012: $1Liabilities 2012: $02012Assets 2013: $2,026,424Liabilities 2013: $6,894Net Assets 2013: $2,019,5302013Assets 2014: $5,382,352Liabilities 2014: $1Net Assets 2014: $5,382,3522014Assets 2015: $4,341,362Liabilities 2015: $1Net Assets 2015: $4,341,3622015Assets 2016: $72,787Liabilities 2016: $0Net Assets 2016: $72,7872016Assets 2017: $0Liabilities 2017: $0Net Assets 2017: $02017

Highlighted filing

2017

Assets$0
Liabilities$0
Net Assets$0
Open 2017 Filing

Operations Trend

Revenue Growth5th percentile

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

$5.0M$0-$5.0MRevenue 2012: $1Expenses 2012: $0Net Income 2012: $12012Revenue 2013: $2,027,474Expenses 2013: $7,944Net Income 2013: $2,019,5302013Revenue 2014: $3,379,024Expenses 2014: $16,202Net Income 2014: $3,362,8222014Revenue 2015: $3,310Expenses 2015: $1,044,300Net Income 2015: -$1,040,9902015Revenue 2016: $400Expenses 2016: $4,268,975Net Income 2016: -$4,268,5752016Revenue 2017: $4Expenses 2017: $72,791Net Income 2017: -$72,7872017

Highlighted filing

2017

Revenue$4
Expenses$72,791
Net Income-$72,787
Open 2017 Filing

Filings

Most recent year

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

Open filing
Assets
$0
Liabilities
$0
Net assets
$0
Revenue
$4
Expenses
$72,791
Net income
-$72,787
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2017Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$0.00$0.07$0.07
2016Detailed filing. Detailed filing data is available for this year.$0.07$0.00$0.07$0.00$4.27$4.27
2015Detailed filing. Detailed filing data is available for this year.$4.34$0.00$4.34$0.00$1.04$1.04
2014Detailed filing. Detailed filing data is available for this year.$5.38$0.00$5.38$3.38$0.02$3.36
2013Detailed filing. Detailed filing data is available for this year.$2.03$0.01$2.02$2.03$0.01$2.02
2012Summary only. Only limited summary data is available for this year.$0.00$0.00$0.00$0.00$0.00
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Feb 10, 2018
Return Version
2017v2.2
Compensation and Service Providers
Top Officer Pay81st percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Terry L PolsgroveTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Rose G Deal Educational Charitable Trus
EIN
45-6973021
Phone
9014841008
Address
425 Crangle Road, Rossville, TN 38066

Signing Officer

Name
Terry L Polsgrove
Title
Trustee
Signed
2018-02-10
Discuss with paid preparer
Yes

Preparer

Firm
Terry Polsgrove CPA
Address
425 Crangle Road, Rossville, TN 38066
Preparer
Terry Polsgrove
Phone
9014841008
Raw XML Appendix184 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/AdjustedNetIncomeAmt05291
AccountingFeesSchedule/AccountingFeesDetail/Amt05291
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0Trust Administration and Tax Preparation
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt05291
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt05291
IRS990PF/AnalysisIncomeProducingActyGrp/IntOnSavAndTempCashInvstGrp/UnrelatedBusinessTaxblIncmAmt04
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt04
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesAdjNetIncmAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt067500
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt067500
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-72787
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavingsAdjNetIncmAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavNetInvstIncmAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalAdjNetIncmAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt072791
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt072791
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt04
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt05291
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt05291
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-72787
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt072787
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FinalReturnInd0X
IRS990PF/FMVAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt072787
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt072787
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt072787
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt072787
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt072787
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt00
IRS990PF/MethodOfAccountingAccrualInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt00
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt00
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt00
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0Terry L Polsgrove
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0425 Crangle Road
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Rossville
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0TN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd038066
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt072791
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt072791
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt072791
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/ExcessBusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/MaintainedExpenditureRspnsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProceedsOrNetIncomeInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransactionsFailToQlfyAsExcInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistrIncmSect4942a2NotAppInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/Form990TFiledInd0false
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0425 Crangle Road
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Rossville
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0TN
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd038066
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0true
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0TN
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0Terry Polsgrove CPA
IRS990PF/StatementsRegardingActyGrp/PhoneNum09014841008
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt067500
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Furtherance of Liberal Arts Program-Construction of Dedicated Facility
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0Christian Brothers University
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0650 E Parkway S
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Memphis
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0TN
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd038104
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt067500
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt03975
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt0622278
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt0699044
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt072791
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt03975
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt0622278
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt072791
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt072791
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt0699044
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt0626253
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
LiquidationExplanationStmt/ExplanationTxt0Purpose for which trust was established is complete. All funds have been distributed to primary beneficiary of the trust.
ReturnHeader/BuildTS02018-06-14 16:35:46Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0Terry L Polsgrove
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-02-10
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Rose G Deal Educational Charitable Trus
ReturnHeader/Filer/BusinessNameControlTxt0ROSE
ReturnHeader/Filer/EIN0456973021
ReturnHeader/Filer/PhoneNum09014841008
ReturnHeader/Filer/USAddress/AddressLine1Txt0425 Crangle Road
ReturnHeader/Filer/USAddress/CityNm0Rossville
ReturnHeader/Filer/USAddress/StateAbbreviationCd0TN
ReturnHeader/Filer/USAddress/ZIPCd038066
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0621721858
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Terry Polsgrove CPA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0425 Crangle Road
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Rossville
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd038066
ReturnHeader/PreparerPersonGrp/PhoneNum09014841008
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Terry Polsgrove
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02018-02-10T10:31:57-08:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.