Civic Intelligence

Trojan Villa Inc

990EZ • Fiscal year 2017 • EIN 43-1120765

Jan 01, 2017 to Dec 31, 2017 • Filed on Nov 13, 2018

6132 Creech LaneTroy, MO 63379

(636) 528-9981

Siviq Scores

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

Liabilities / Assets

72nd percentile

0.05x

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

2017 filings • 501(c)4 • <$500k nonprofits • Source year 2017

Liabilities / Revenue

76th percentile

0.08x

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

2017 filings • 501(c)4 • <$500k nonprofits • Source year 2017

Net Margin

79th percentile

20%

Higher net margin than 79% of similar nonprofits.

2017 filings • 501(c)4 • <$500k nonprofits • Source year 2017

Top Officer Pay

86th percentile

$0

Higher top officer pay than 86% of similar nonprofits.

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

2017 filings • 501(c)4 • <$500k nonprofits • Source year 2017

Asset Growth

55th percentile

3.5%

Faster asset growth than 55% of similar nonprofits.

2017 filings • 501(c)4 • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

48th percentile

-0.6%

Faster revenue growth than 48% of similar nonprofits.

2017 filings • 501(c)4 • <$500k nonprofits • Annualized from 2016 to 2017

Assets

Up

$195,532

Up $6,551 (+3.5%) from 2016

Net Assets

Up

$185,219

Up $26,763 (+17%) from 2016

Liabilities

Down

$10,313

Down $20,212 (-66%) from 2016

Revenue

Down

$135,136

Down $868 (-0.6%) from 2016

Expenses

Down

$108,373

Down $1,635 (-1.5%) from 2016

Net Income

Up

$26,763

Up $767 (+3.0%) from 2016

Historical Trend

Balance Sheet Trend

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

$400K$300K$200K$100K$0Assets 2011: $265,274Liabilities 2011: $187,4582011Assets 2012: $235,979Liabilities 2012: $163,859Net Assets 2012: $72,1202012Assets 2013: $215,897Liabilities 2013: $136,664Net Assets 2013: $79,2332013Assets 2014: $201,721Liabilities 2014: $107,881Net Assets 2014: $93,8402014Assets 2015: $207,849Liabilities 2015: $75,389Net Assets 2015: $132,4602015Assets 2016: $188,981Liabilities 2016: $30,525Net Assets 2016: $158,4562016Assets 2017: $195,532Liabilities 2017: $10,313Net Assets 2017: $185,2192017Assets 2018: $206,381Liabilities 2018: $10,979Net Assets 2018: $195,4022018Assets 2019: $212,929Liabilities 2019: $10,498Net Assets 2019: $202,4312019Assets 2020: $209,288Liabilities 2020: $13,553Net Assets 2020: $195,7352020Assets 2021: $259,004Liabilities 2021: $13,5032021Assets 2022: $274,873Liabilities 2022: $15,158Net Assets 2022: $259,7152022Assets 2023: $303,835Liabilities 2023: $14,7302023

Highlighted filing

2017

Assets$195,532
Liabilities$10,313
Net Assets$185,219

Operations Trend

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

$200K$150K$100K$50K$0-$50KRevenue 2011: $116,670Expenses 2011: $101,124Net Income 2011: $15,5462011Revenue 2012: $107,543Expenses 2012: $113,239Net Income 2012: -$5,6962012Revenue 2013: $120,921Expenses 2013: $113,808Net Income 2013: $7,1132013Revenue 2014: $127,667Expenses 2014: $113,060Net Income 2014: $14,6072014Revenue 2015: $139,822Expenses 2015: $101,202Net Income 2015: $38,6202015Revenue 2016: $136,004Expenses 2016: $110,008Net Income 2016: $25,9962016Revenue 2017: $135,136Expenses 2017: $108,373Net Income 2017: $26,7632017Revenue 2018: $134,665Expenses 2018: $124,482Net Income 2018: $10,1832018Revenue 2019: $134,741Expenses 2019: $127,712Net Income 2019: $7,0292019Revenue 2020: $139,383Expenses 2020: $146,079Net Income 2020: -$6,6962020Revenue 2021: $147,849Expenses 2021: $98,083Net Income 2021: $49,7662021Revenue 2022: $156,406Expenses 2022: $142,192Net Income 2022: $14,2142022Revenue 2023: $150,392Expenses 2023: $121,002Net Income 2023: $29,3902023

Highlighted filing

2017

Revenue$135,136
Expenses$108,373
Net Income$26,763
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Nov 13, 2018
Return Version
2017v2.3
Gross Receipts
$135,136
Mission and Program Overview

Mission

Provide low cost housing for senior citi

Provide low cost housing for senior citizens

Program Services

DescriptionGrantsExpenses
31 RENTAL UNITS FOR SENIOR CITIZENS REVENUES ON LINE 2, EXPENSES DETAILED ON LINE 16--
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
MIKE BOCKHORSTPresident-$0--
JOE ROTHWEILVice -Pres-$0--
PAULINE McCARTHYSecretary-$0--
DORIS LOURANCETreasurerPT$0--
JOYCE DOWELLDirector-$0--
LINDA BRINERDirector-$0--
JIM BURLISONDirector-$0--
RICK INGERSOLDirector-$0--
JANIS STRAWHUNDirector-$0--
Filing and Contact Details

Filer

Filer Name
Trojan Villa Inc
EIN
43-1120765
Phone
6365289981
Address
6132 CREECH LANE, TROY, MO 63379

Signing Officer

Name
Doris Lourance
Title
Treasurer
Signed
2018-11-13
Discuss with paid preparer
No

Preparer

Firm
Moellman Accounting Inc
Address
PO BOX 502, TROY, MO 63379
Preparer
Donald L Moellman
Phone
6365288802
Supplemental Narrative

Additional Explanations

Form 990-EZ, Part I, Line 16, Other Expenses

Interest 377

Form 990-EZ, Part I, Line 16, Other Expenses

Depreciation 17,891

Form 990-EZ, Part I, Line 16, Other Expenses

Office supplies/computer 1,053

Form 990-EZ, Part I, Line 16, Other Expenses

PEST CONTROL 1,314

Form 990-EZ, Part I, Line 16, Other Expenses

REPAIRS 18,813

Form 990-EZ, Part I, Line 16, Other Expenses

INSURANCE 7,891

Form 990-EZ, Part I, Line 16, Other Expenses

UTILITIES 20,184

Form 990-EZ, Part I, Line 16, Other Expenses

General maintenance 29,248

Form 990-EZ, Part I, Line 16, Other Expenses

Water and sanitation 3,571

Form 990-EZ, Part I, Line 16, Other Expenses

TRASH 2,196

Form 990-EZ, Part I, Line 16, Other Expenses

Laundry room expense 1,391

Form 990-EZ, Part I, Line 16, Other Expenses

Replacement appliances 3,848

Form 990-EZ, Part I, Line 16, Other Expenses

REGISTRATION LICENSES 21

Form 990-EZ, Part II, Line 26, Liabilities

ACCOUNTS PAYABLE Beginning of year 270, End of year 0

Form 990-EZ, Part II, Line 26, Liabilities

SECURITY DEPOSTS Beginning of year 8,668, End of year 10,313

Form 990-EZ, Part II, Line 26, Liabilities

MORTGAGE PAYALBE Beginning of year 21,587, End of year 0

Raw XML Appendix157 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0DORIS LOURANCE
IRS990EZ/BooksInCareOfDetail/PhoneNum06365289981
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt06132 CREECH LANE
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0TROY
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MO
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd063379
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt071210
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt095652
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt026763
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0575
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0188981
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0195532
IRS990EZ/GrossReceiptsAmt0135136
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0166
IRS990EZ/LandAndBuildingsGrp/BOYAmt0117771
IRS990EZ/LandAndBuildingsGrp/EOYAmt099880
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt0134970
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0158456
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0185219
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0158456
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0185219
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2001.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3005.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt4000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt5000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt6000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt7000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt8000.50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0MIKE BOCKHORST
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JOE ROTHWEIL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2PAULINE McCARTHY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3DORIS LOURANCE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4JOYCE DOWELL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5LINDA BRINER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6JIM BURLISON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7RICK INGERSOL
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8JANIS STRAWHUN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1VICE -PRES
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7DIRECTOR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8DIRECTOR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt0107798
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE LOW COST HOUSING FOR SENIOR CITIZENS
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt031 RENTAL UNITS FOR SENIOR CITIZENS REVENUES ON LINE 2, EXPENSES DETAILED ON LINE 16
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt030525
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt010313
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0108373
IRS990EZ/TotalRevenueAmt0135136
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Interest 377
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Depreciation 17,891
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2OFFICE SUPPLIES/COMPUTER 1,053
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3PEST CONTROL 1,314
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4REPAIRS 18,813
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5INSURANCE 7,891
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6UTILITIES 20,184
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7GENERAL MAINTENANCE 29,248
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8WATER AND SANITATION 3,571
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9TRASH 2,196
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt10LAUNDRY ROOM EXPENSE 1,391
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt11REPLACEMENT APPLIANCES 3,848
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt12REGISTRATION LICENSES 21
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt13ACCOUNTS PAYABLE Beginning of year 270, End of year 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt14SECURITY DEPOSTS Beginning of year 8,668, End of year 10,313
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt15MORTGAGE PAYALBE Beginning of year 21,587, End of year 0
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc9Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc10Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc11Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc12Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc13Form 990-EZ, Part II, Line 26, Liabilities
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc14Form 990-EZ, Part II, Line 26, Liabilities
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc15Form 990-EZ, Part II, Line 26, Liabilities
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0DORIS LOURANCE
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-11-13
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0TROJAN VILLA INC
ReturnHeader/Filer/BusinessNameControlTxt0TROJ
ReturnHeader/Filer/EIN0431120765
ReturnHeader/Filer/PhoneNum06365289981
ReturnHeader/Filer/USAddress/AddressLine1Txt06132 CREECH LANE
ReturnHeader/Filer/USAddress/CityNm0TROY
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MO
ReturnHeader/Filer/USAddress/ZIPCd063379
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId06726B44A57E07BC6B48F8A26BAD6681596014D34
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId06726B44A57E07BC6B48F8A26BAD6681596014D34
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt024.217.9.144
ReturnHeader/FilingSecurityInformation/IPDt02018-11-13
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm021:40:24
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0MOELLMAN ACCOUNTING INC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0PO BOX 502
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0TROY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MO
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd063379
ReturnHeader/PreparerPersonGrp/PhoneNum06365288802
ReturnHeader/PreparerPersonGrp/PreparationDt02018-11-13
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DONALD L MOELLMAN
ReturnHeader/ReturnTs02018-11-13T03:40:44-00:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Summary only. Only limited summary data is available for this year.$3.04$0.15$1.50$1.21$0.29
2022Detailed filing. Detailed filing data is available for this year.$2.75$0.15$2.60$1.56$1.42$0.14
2021Summary only. Only limited summary data is available for this year.$2.59$0.14$1.48$0.98$0.50
2020Detailed filing. Detailed filing data is available for this year.$2.09$0.14$1.96$1.39$1.46$0.07
2019Detailed filing. Detailed filing data is available for this year.$2.13$0.10$2.02$1.35$1.28$0.07
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$2.06$0.11$1.95$1.35$1.24$0.10
2017Detailed filing. Detailed filing data is available for this year.$1.96$0.10$1.85$1.35$1.08$0.27
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.89$0.31$1.58$1.36$1.10$0.26
2015Detailed filing. Detailed filing data is available for this year.$2.08$0.75$1.32$1.40$1.01$0.39
2014Detailed filing. Detailed filing data is available for this year.$2.02$1.08$0.94$1.28$1.13$0.15
2013Detailed filing. Detailed filing data is available for this year.$2.16$1.37$0.79$1.21$1.14$0.07
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.36$1.64$0.72$1.08$1.13$0.06
2011Summary only. Only limited summary data is available for this year.$2.65$1.87$1.17$1.01$0.16