Civic Intelligence

Franklin Residences Inc.

990EZ • Fiscal year 2018 • EIN 25-1592905

Jul 01, 2017 to Jun 30, 2018 • Filed on Dec 14, 2018

138 E King StShippensburg, PA 17257

(717) 477-2153

Siviq Scores

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

Liabilities / Assets

98th percentile

2.93x

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

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Liabilities / Revenue

99th percentile

4.05x

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

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Net Margin

51st percentile

3.5%

Higher net margin than 51% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

2018 filings • 501(c)3 • <$500k nonprofits • Source year 2018

Asset Growth

32nd percentile

-7.8%

Faster asset growth than 32% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

51st percentile

1.8%

Faster revenue growth than 51% of similar nonprofits.

2018 filings • 501(c)3 • <$500k nonprofits • Annualized from 2017 to 2018

Assets

Down

$157,284

Down $13,280 (-7.8%) from 2017

Net Assets

Up

-$303,350

Up $3,963 (+1.3%) from 2017

Liabilities

Down

$460,634

Down $17,243 (-3.6%) from 2017

Revenue

Up

$113,648

Up $2,053 (+1.8%) from 2017

Expenses

Down

$109,685

Down $3,036 (-2.7%) from 2017

Net Income

Up

$3,963

Up $5,089 (+452%) from 2017

Historical Trend

Balance Sheet Trend

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

$1.0M$500K$0-$500KAssets 2015: $212,084Liabilities 2015: $515,654Net Assets 2015: -$303,5702015Assets 2016: $194,638Liabilities 2016: $500,825Net Assets 2016: -$306,1872016Assets 2017: $170,564Liabilities 2017: $477,877Net Assets 2017: -$307,3132017Assets 2018: $157,284Liabilities 2018: $460,634Net Assets 2018: -$303,3502018Assets 2019: $158,407Liabilities 2019: $442,581Net Assets 2019: -$284,1742019Assets 2020: $171,975Liabilities 2020: $426,505Net Assets 2020: -$254,5302020Assets 2021: $167,566Liabilities 2021: $395,669Net Assets 2021: -$228,1032021Assets 2022: $186,739Liabilities 2022: $373,145Net Assets 2022: -$186,4062022Assets 2023: $210,570Liabilities 2023: $346,104Net Assets 2023: -$135,5342023Assets 2024: $228,369Liabilities 2024: $316,061Net Assets 2024: -$87,6922024Assets 2025: $244,874Liabilities 2025: $291,945Net Assets 2025: -$47,0712025

Highlighted filing

2018

Assets$157,284
Liabilities$460,634
Net Assets-$303,350

Operations Trend

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

$150K$100K$50K$0-$50KRevenue 2015: $117,289Expenses 2015: $132,295Net Income 2015: -$15,0062015Revenue 2016: $112,257Expenses 2016: $114,874Net Income 2016: -$2,6172016Revenue 2017: $111,595Expenses 2017: $112,721Net Income 2017: -$1,1262017Revenue 2018: $113,648Expenses 2018: $109,685Net Income 2018: $3,9632018Revenue 2019: $111,485Expenses 2019: $92,309Net Income 2019: $19,1762019Revenue 2020: $114,256Expenses 2020: $84,612Net Income 2020: $29,6442020Revenue 2021: $107,739Expenses 2021: $81,312Net Income 2021: $26,4272021Revenue 2022: $124,079Expenses 2022: $82,382Net Income 2022: $41,6972022Revenue 2023: $128,801Expenses 2023: $77,929Net Income 2023: $50,8722023Revenue 2024: $130,539Expenses 2024: $82,697Net Income 2024: $47,8422024Revenue 2025: $136,365Expenses 2025: $95,744Net Income 2025: $40,6212025

Highlighted filing

2018

Revenue$113,648
Expenses$109,685
Net Income$3,963
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Dec 14, 2018
Return Version
2017v2.2
Gross Receipts
$113,648
Mission and Program Overview

Mission

Housing for disabled individuals

Program Services

DescriptionGrantsExpenses
MANAGEMENT AND MAINTENANCE OF PROPERTIES THAT ARE USED TO HOUSE PSYCHOLOGICALLY DISABLED INDIVIDUALS-$89,372
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
RONALD FORRY JRDirector-$0--
HENRY MUENSTERMANDirector-$0--
NANCY WAGAMANPresident-$0--
LAUREN JAMESVice President-$0--
ELLEN ILESecretary/Treasurer-$0--
Filing and Contact Details

Filer

Filer Name
Franklin Residences Inc
EIN
25-1592905
Phone
7174772153
Address
138 E King St, Shippensburg, PA 17257

Signing Officer

Name
Craig Cordell
Title
Executive Director
Phone
7174772153
Signed
2018-12-14
Discuss with paid preparer
Yes

Preparer

Firm
Showalter & Miller CPA's
Address
42 E Main Street, Waynesboro, PA 17268-1634
Preparer
Ray L Miller CPA
Phone
7177628116
Supplemental Narrative

Additional Explanations

Form 990EZ, Part I, Line 8

Misc. revenue 1569.

Form 990EZ, Part I, Line 16

Management contract 12058.

Form 990EZ, Part I, Line 16

Bank charges 45.

Form 990EZ, Part I, Line 16

Misc. expenses 0.

Form 990EZ, Part I, Line 16

Inspection fees 270.

Form 990EZ, Part I, Line 16

Bad Debts 834.

Form 990EZ, Part I, Line 16

Telephone 360.

Form 990EZ, Part I, Line 16

Depreciation 24428.

Form 990EZ, Part II, Line 24

Accounts receivable 1297. 3681.

Form 990EZ, Part II, Line 24

Prepaid insurance 1766. 5825.

Form 990EZ, Part II, Line 26

Accounts payable 1002. 745.

Form 990EZ, Part II, Line 26

Accrued interest payable 3281. 3157.

Form 990EZ, Part II, Line 26

Prepaid resident rent 915. 1361.

Form 990EZ, Part II, Line 26

Tenant security deposits 2575. 2998.

Form 990EZ, Part II, Line 26

Long-term debt 470104. 452373.

Raw XML Appendix185 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/PersonNm0EXECUTIVE DIRECTOR
IRS990EZ/BooksInCareOfDetail/PhoneNum07174772153
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0138 E King St
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Shippensburg
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0PA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd017257
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt090261
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt094966
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt082657
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt03963
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt05727
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0170564
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0157284
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GainOrLossFromSaleOfAssetsAmt00
IRS990EZ/GamingGrossIncomeAmt00
IRS990EZ/GrossProfitLossSlsOfInvntryAmt00
IRS990EZ/GrossReceiptsAmt0113648
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt071
IRS990EZ/LandAndBuildingsGrp/BOYAmt077240
IRS990EZ/LandAndBuildingsGrp/EOYAmt052812
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt00
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-307313
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0-303350
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-307313
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0-303350
IRS990EZ/OccupancyRentUtltsAndMaintAmt065963
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt40.25
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0RONALD FORRY JR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1HENRY MUENSTERMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2NANCY WAGAMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3LAUREN JAMES
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4ELLEN ILE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Vice President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Secretary/Treasurer
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt03063
IRS990EZ/OtherAssetsTotalDetail/EOYAmt09506
IRS990EZ/OtherExpensesTotalAmt037995
IRS990EZ/OtherRevenueTotalAmt01569
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Housing for disabled individuals
IRS990EZ/ProgramServiceRevenueAmt029351
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MANAGEMENT AND MAINTENANCE OF PROPERTIES THAT ARE USED TO HOUSE PSYCHOLOGICALLY DISABLED INDIVIDUALS
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt089372
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SpecialEventsNetIncomeLossAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt0477877
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt0460634
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0109685
IRS990EZ/TotalProgramServiceExpensesAmt089372
IRS990EZ/TotalRevenueAmt0113648
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt082657
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt082289
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt076543
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt076744
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt078479
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0396712
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt071
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt046
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt042
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt041
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt041
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt0241
IRS990ScheduleA/GrossReceiptsRltdActivitiesAmt0174316
IRS990ScheduleA/InvestmentIncomeCYPct00
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.99940
IRS990ScheduleA/PublicSupportCY509Pct00
IRS990ScheduleA/PublicSupportPY170Pct00.99940
IRS990ScheduleA/PublicSupportTotal170Amt0396712
IRS990ScheduleA/PublicSupportTotal509Amt00
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt082657
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt082289
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt076543
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt076744
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt078479
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0396712
IRS990ScheduleA/TotalSupportAmt0396953
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Misc. revenue 1569.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Management contract 12058.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Bank charges 45.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Misc. expenses 0.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Inspection fees 270.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Bad Debts 834.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6Telephone 360.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Depreciation 24428.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt8Accounts receivable 1297. 3681.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt9Prepaid insurance 1766. 5825.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt10Accounts payable 1002. 745.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt11Accrued interest payable 3281. 3157.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt12Prepaid resident rent 915. 1361.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt13Tenant security deposits 2575. 2998.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt14Long-term debt 470104. 452373.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990EZ, Part I, Line 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Form 990EZ, Part I, Line 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc8Form 990EZ, Part II, Line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc9Form 990EZ, Part II, Line 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc10Form 990EZ, Part II, Line 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc11Form 990EZ, Part II, Line 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc12Form 990EZ, Part II, Line 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc13Form 990EZ, Part II, Line 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc14Form 990EZ, Part II, Line 26
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0CRAIG CORDELL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0EXECUTIVE DIRECTOR
ReturnHeader/BusinessOfficerGrp/PhoneNum07174772153
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-12-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Franklin Residences Inc
ReturnHeader/Filer/BusinessNameControlTxt0FRAN
ReturnHeader/Filer/EIN0251592905
ReturnHeader/Filer/PhoneNum07174772153
ReturnHeader/Filer/USAddress/AddressLine1Txt0138 E King St
ReturnHeader/Filer/USAddress/CityNm0Shippensburg
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd017257
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId04A74E8E2131C3ABE3C7095D63BC38C190254695C
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0B621F993ACDD8D2B549EAAA5FC6AF2D03CB5E476
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0174.54.94.113
ReturnHeader/FilingSecurityInformation/IPDt02018-12-18
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0PS
ReturnHeader/FilingSecurityInformation/IPTm015:42:06
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Showalter & Miller CPA's
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt042 E Main Street
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Waynesboro
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0172681634
ReturnHeader/PreparerPersonGrp/PhoneNum07177628116
ReturnHeader/PreparerPersonGrp/PreparationDt02018-12-18
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0RAY L MILLER CPA
ReturnHeader/ReturnTs02018-12-18T15:42:10-08:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings