Worked Example: SBA 504 Owner-Occupied Retail Feasibility Study in Michigan
A worked example of the feasibility study a lender would read for an owner-occupied retail project in Michigan, financed with an SBA 504 loan.
What SBA's own loan files show about lending in the Detroit-Warren-Dearborn, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Detroit-Warren-Dearborn ranks 11 of 928 metro and micro areas by number of loans, with 11,143 approvals and $4.50 billion in gross dollars from FY2017 to FY2026. What marks this area is the modest ticket. A median of $140,000 is only 0.67x the nation's figure, with the central half of loans spanning $50,000 to $382,150. Franchise brands account for 10.5% of loans. Nearly all the lending is 7(a), 10,553 loans against 590 under 504, so the area is a market of working-capital and modest acquisition loans far more than of large real estate financings.
The class table is dominated by what lies outside it: 8,297 loans belong to none of the tracked asset classes. Among named classes, full-service restaurant is first at 492 loans, with limited-service restaurant at 388, liquor store at 279 and fitness center at 167. Hotel and motel has 81 loans, assisted living 32, and self storage 33. Geographically the book is anchored in Oakland County, MI at 4,141 loans and Wayne County, MI at 3,520, followed by Macomb County, MI at 2,544, Livingston County, MI at 488, St. Clair County, MI at 297 and Lapeer County, MI at 153.
Each name below is the holder SBA currently shows against a loan, which says where paper sits today and nothing about how an institution decides. The Huntington National Bank holds 5,372 7(a) loans worth $933.0 million, a concentration that no other holder here approaches; Fifth Third Bank follows with 643, JPMorgan Chase Bank, National Association with 327, Citizens Bank, National Association with 291 and ChoiceOne Bank with 240 loans worth $184.1 million. The 504 table is headed by Michigan Certified Development Corporation at 379 loans and $335.5 million, Oakland County Business Finance Corporation 113 and Great Lakes Commercial Finance 90.
Cancellations after approval reached 11.7% for FY2017 to FY2024 approvals, a floor, and 13.7% as a ceiling that treats loans still undisbursed as cancelled. Of the 4,729 loans in the funded cohort for FY2017 to FY2021, charge-offs total 5.1% to date and 2.9% at the five-year mark; both are minimums while loans stay open. Annual volume bottomed at 850 loans in FY2020 and reached 1,320 in FY2024, while dollars peaked at $575.0 million in FY2025.
For a Detroit-area project, a study must separate demand in the specific county from the metro's broad averages, and must show that the project's cost fits the lower loan scale lenders here are used to. Debt service coverage should survive these loss floors, and the appraisal must back the collateral value. The July 2023 delineation draws the area lines; a loan from a county it cannot place is excluded here and elsewhere. We offer this context to lenders and borrowers alike, with no promise of approval.
| Loans approved, FY2017 to FY2026 | 11,143 |
|---|---|
| Gross dollars approved | $4.50 billion |
| Median loan | $140,000 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $382,150 |
| SBA 7(a) loans | 10,553 |
| SBA 504 loans | 590 |
| Franchise share of loans | 10.5% |
| Rank among metro and micro areas by loans | 11 of 928 |
| Median loan against the national median | 0.67x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 11.7% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 13.7% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 5.1% |
| Charged off within five years of approval | 2.9% |
| Loans in that cohort | 4,729 |
Both rates are floors. SBA withholds the status of open loans, so a loan counts as charged off only once SBA reports it; a rate needs at least 30 loans in its cohort and is otherwise not reported.
SBA loans approved in the Detroit-Warren-Dearborn, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 1,254 | $444.7 million |
| FY2018 | 1,286 | $357.0 million |
| FY2019 | 1,040 | $377.5 million |
| FY2020 | 850 | $351.3 million |
| FY2021 | 1,005 | $507.3 million |
| FY2022 | 1,064 | $410.8 million |
| FY2023 | 1,278 | $483.5 million |
| FY2024 | 1,320 | $518.1 million |
| FY2025 | 1,284 | $575.0 million |
| FY2026 | 762 | $471.0 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 8,297 |
| Full-service restaurant | 492 |
| Limited-service restaurant | 388 |
| Liquor store | 279 |
| Fitness center | 167 |
| Automotive mechanical repair (car and truck) | 163 |
| Beauty salon | 142 |
| Coffee shop and snack bar | 141 |
| Child care center | 137 |
| Medical office (physicians) | 136 |
| Dental office | 109 |
| Grocery store | 95 |
| Car wash | 88 |
| Hotel and motel | 81 |
| Rehabilitation and therapy clinic | 69 |
| Gas station and truck stop | 67 |
| Beverage manufacturing (breweries, wineries, distilleries) | 39 |
| Caterers (includes banquet halls with catering staff) | 38 |
| Self storage | 33 |
| Assisted living (without nursing care) | 32 |
| Veterinary clinic | 25 |
| Nonresidential lessor (flex, office and retail investor buildings) | 19 |
| Data center | 17 |
| Skilled nursing | 16 |
| School (elementary and secondary, including charter) | 15 |
| Behavioral health and addiction treatment | 13 |
| Marina | 8 |
| Warehouse and distribution | 6 |
| Hospital | 6 |
| Manufactured housing community (lessors of other real estate) | 5 |
| Urgent care and ambulatory surgery | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Michigan Certified Development Corporation | 379 | $335.5 million |
| Oakland County Business Finance Corporation | 113 | $82.9 million |
| Great Lakes Commercial Finance | 90 | $122.9 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 5,372 | $933.0 million |
| Fifth Third Bank | 643 | $294.7 million |
| JPMorgan Chase Bank, National Association | 327 | $92.6 million |
| Citizens Bank, National Association | 291 | $82.1 million |
| ChoiceOne Bank | 240 | $184.1 million |
Lenders with 5 or more loans here; a lender with fewer is not listed, and loans SBA or a receiver holds are counted but never listed as a lender.
| County | Loans |
|---|---|
| Oakland County, MI | 4,141 |
| Wayne County, MI | 3,520 |
| Macomb County, MI | 2,544 |
| Livingston County, MI | 488 |
| St. Clair County, MI | 297 |
| Lapeer County, MI | 153 |
Counties with 5 or more loans; smaller ones are not listed.
Metro is the CBSA (metropolitan or micropolitan statistical area) of the loan's project county, July 2023 delineation (OMB Bulletin 23-01). The county is matched by name (manifests/ld2/county-cbsa-map.csv); a loan whose county cannot be placed in a 2023 CBSA is left out of every metro.
All assets: every 7(a) and 504 approval in the metro, including those outside the 39 asset classes.
A value marked withheld rests on fewer than 5 loans, or is withheld so that such a figure cannot be derived from other published figures.
Source: U.S. Small Business Administration, 7(a) and 504 loan-level FOIA files (data.sba.gov), as of 2026-09-30; areas from the U.S. Census Bureau CBSA delineation, July 2023 (OMB Bulletin 23-01); Loan Analytics metro cell MT-19820.
A worked example of the feasibility study a lender would read for an owner-occupied retail project in Michigan, financed with an SBA 504 loan.
Loan Analytics prepares the feasibility study a lender reads before it commits: for a commercial project in the Detroit-Warren-Dearborn, MI Metro Area, financed under SBA 7(a), SBA 504, USDA Business and Industry or a conventional bank loan. Tell us the project and the lender's deadline, and we reply with scope, timeline and fee.
Start with the data.
Contact Us