PROTOTYPE — Not for official use. Data and outputs are for demonstration only and do not constitute official HHS determinations.
← delinquency review

CITY OF DETROIT WATER & SEWERAGE

UEI JMBRMBB9KSC5 · MI · local · FY 2025-07-01 → 2026-06-30
FY2026: Not yet due

Filed FY2025; overdue for FY2024 ($9.6M observed); FY2026 not yet due; 2 years undetermined.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Not yet due $217.3M $1.0M2027-03-30
2025Filed $217.7M $750K2026-03-300$58.5M372% 2025-06-GSAFAC-0000409350 ↗
2024Overdue $141.4M $750K2025-03-30494d past due
2023Undetermined $164.1M $750K2024-03-30
2022Undetermined $1.26B $750K2023-03-30
Obligation
$113.9M
Outlay
$148.5M
Subaward recv
$68.9M
Subaward passed
$19.8M
Loan face value
$0
Awards
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Centers for Disease Control and Prevention HHS$890K$3.5M$865K$0$0
Office of the Assistant Secretary for Health HHS$0$230K$0$0
Health Resources and Services Administration HHS$0$2.9M$0$0
Centers for Medicare and Medicaid Services HHS$0$19.4M$0$0
Non-HHS federal money $113.0M$145.0M$45.5M$19.8M$0

Relationships

Three independent link types, one card each. They overlap — the same money can appear under more than one, so never add them together.

link_type = audit_coverage

Whose single audit accounts for this entity, and whose this entity accounts for. The LINKS are standing — they apply to every year, and a gap in the observed span is a gap in FAC reporting, not a year the entity stood alone. The rolled AMOUNTS below follow the selected fiscal year, so the entity count there can be smaller than the standing list.

Covered by
Self-covered — no other entity’s audit accounts for this one.
Audit scope — FY2026
Covers 2 entities holding $217.3M of observed federal money .
This entity’s audit covers (1)
EntityObservedLatest statusYrs delinq.Latest observed
CITY OF DETROIT
GS94M2VMNMJ3
FY2025Not yet due$214.6M
link_type = corporate_parent

From SAM.gov registration: the headquarters an entity registered under, and the entities registered beneath it. A registration record, not an org chart — it does not mean the parent runs the entity’s programs. The link itself never changes, but the lists below follow the selected year: an entity only appears in years it had federal activity.

Rolls up to
CITY OF DETROIT GS94M2VMNMJ3
X9UKXNMYN768 X9UKXNMYN768
Rolls up to this entity
Nothing — no entity rolls up to this one.
derived — not a link_type

Not a stored relationship. These entities are found by taking this entity’s parent and looking up everything else registered under it — so they will not appear in any row keyed to this entity’s own UEI. Shown because the coverage lead above rests on them: if a sibling provably covers other entities, it may account for this one too.

Show the query
SELECT related_uei, link_type FROM pub.entity_link
WHERE link_type = 'corporate_parent'
  AND uei = 'GS94M2VMNMJ3'      -- this entity's parent
  AND related_uei <> 'JMBRMBB9KSC5';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
DETROIT BUILDING AUTHORITY
H9XMMVNG3TB3
Overdue1$85.4M
CITY OF DETROIT
CRWJSGLZ3KX1
Not yet due4$79.7M
CITY OF DETROIT-HEALTH DEPARTMENT
Y4Q5E7DM4GC5
Not yet due4$11.5M
DETROIT, MICHIGAN,, CITY OF
T2FCFPG1SGA9
Under threshold2$841K
DETROIT, CITY OF
KNFAKMWL5MU8
Under threshold1$674K
CITY OF DETROIT FIRE DEPT
JJF6KSWURYX7
Under threshold$346K
CITY OF DETROIT FIRE DEPT
JJF6KSWURYX7
Under threshold$346K
DETROIT, CITY OF
HW91D5KJL727
Under threshold3$194K
CITY OF DETROIT HOMELAND SECURITY
XNKZAWS7Q6L8
Under threshold$90K
KEVQHFS61JN7
KEVQHFS61JN7
VNGPSRRZG498
VNGPSRRZG498