Civic Intelligence

Trojan Villa Inc

990EZ • Fiscal year 2016 • EIN 43-1120765

Jan 01, 2016 to Dec 31, 2016 • Filed on Aug 30, 2017

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

81st percentile

0.16x

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

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

Liabilities / Revenue

84th percentile

0.22x

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

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

Net Margin

79th percentile

19%

Higher net margin than 79% of similar nonprofits.

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

Top Officer Pay

85th percentile

$0

Higher top officer pay than 85% of similar nonprofits.

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

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

Asset Growth

26th percentile

-9.1%

Faster asset growth than 26% of similar nonprofits.

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

Revenue Growth

43rd percentile

-2.7%

Faster revenue growth than 43% of similar nonprofits.

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

Assets

Down

$188,981

Down $18,868 (-9.1%) from 2015

Net Assets

Up

$158,456

Up $25,996 (+20%) from 2015

Liabilities

Down

$30,525

Down $44,864 (-60%) from 2015

Revenue

Down

$136,004

Down $3,818 (-2.7%) from 2015

Expenses

Up

$110,008

Up $8,806 (+8.7%) from 2015

Net Income

Down

$25,996

Down $12,624 (-33%) from 2015

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

2016

Assets$188,981
Liabilities$30,525
Net Assets$158,456

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

2016

Revenue$136,004
Expenses$110,008
Net Income$25,996
Jump To
Filing Snapshot
Filing Period
Jan 1, 2016 to Dec 31, 2016
Signed
Aug 30, 2017
Return Version
2016v3.0
Gross Receipts
$136,004
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
2017-08-30
Discuss with paid preparer
Yes

Preparer

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

Additional Explanations

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

Interest 2,199

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

Depreciation 17,890

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

OFFICE SUPPLIES 95

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

PEST CONTROL 438

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

REPAIRS 26,185

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

INSURANCE 7,829

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

UTILITIES 20,316

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

General maintenance 25,688

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

Water and sanitation 3,934

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

TRASH 2,756

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

Laundry room expense 2,103

Form 990-EZ, Part II, Line 24, Other Assets

ACCOUNTS RECEIVABLE Beginning of year 405, End of year 0

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

ACCOUNTS PAYABLE Beginning of year 0, End of year 270

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

SECURITY DEPOSTS Beginning of year 9,698, End of year 8,668

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

MORTGAGE PAYALBE Beginning of year 65,691, End of year 21,587

Raw XML Appendix154 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/BOYAmt071783
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt071210
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt025996
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0575
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0207849
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0188981
IRS990EZ/GrossReceiptsAmt0136004
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt091
IRS990EZ/LandAndBuildingsGrp/BOYAmt0135661
IRS990EZ/LandAndBuildingsGrp/EOYAmt0117771
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0132460
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0158456
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0132460
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0158456
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/OtherAssetsTotalDetail/BOYAmt0405
IRS990EZ/OtherExpensesTotalAmt0109433
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE LOW COST HOUSING FOR SENIOR CITIZENS
IRS990EZ/ProgramServiceRevenueAmt0135913
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt031 RENTAL UNITS FOR SENIOR CITIZENS REVENUES ON LINE 2, EXPENSES DETAILED ON LINE 16
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt075389
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt030525
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0110008
IRS990EZ/TotalRevenueAmt0136004
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Interest 2,199
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Depreciation 17,890
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2OFFICE SUPPLIES 95
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3PEST CONTROL 438
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4REPAIRS 26,185
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5INSURANCE 7,829
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6UTILITIES 20,316
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7GENERAL MAINTENANCE 25,688
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8WATER AND SANITATION 3,934
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9TRASH 2,756
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt10LAUNDRY ROOM EXPENSE 2,103
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt11ACCOUNTS RECEIVABLE Beginning of year 405, End of year 0
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt12ACCOUNTS PAYABLE Beginning of year 0, End of year 270
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt13SECURITY DEPOSTS Beginning of year 9,698, End of year 8,668
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt14MORTGAGE PAYALBE Beginning of year 65,691, End of year 21,587
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 II, Line 24, Other Assets
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc12Form 990-EZ, Part II, Line 26, Liabilities
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc13Form 990-EZ, Part II, Line 26, Liabilities
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc14Form 990-EZ, Part II, Line 26, Liabilities
ReturnHeader/BuildTS02017-02-10 21:41:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DORIS LOURANCE
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/SignatureDt02017-08-30
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/AtSubmissionCreationDeviceId0C2025C56C385C7CE23E80876C6BD1EC452EB8215
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0C2025C56C385C7CE23E80876C6BD1EC452EB8215
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt024.217.9.144
ReturnHeader/FilingSecurityInformation/IPDt02017-08-30
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm020:47:58
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/PreparationDt02017-08-30
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0DONALD L MOELLMAN EA
ReturnHeader/ReturnTs02017-08-30T04:07:27-00:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02016-01-01
ReturnHeader/TaxPeriodEndDt02016-12-31
ReturnHeader/TaxYr02016

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
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.96$0.10$1.85$1.35$1.08$0.27
2016Detailed filing. Detailed filing data is available for this year.$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