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 Jackson, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Jackson drew 252 SBA approvals across FY2017 to FY2026, worth $104.0 million gross. By loan count, Jackson stands 270 of 928 among all areas. The Jackson median loan is $153,600. Jackson middle half: $50,000 to $432,825. 0.74x is the Jackson median set beside the national one. In Jackson, 232 loans were 7(a) and 20 were 504. 9.1% of the loans in Jackson carry a franchise brand. Those 252 Jackson loans carry $104.0 million.
Jackson leaders: limited-service restaurant (12), then full-service restaurant (8), then rehabilitation and therapy clinic (5). 194 Jackson loans sit in no tracked class. Most Jackson credit is general business lending. SBA locates every Jackson loan in Jackson County, MI, 252 in all.
A Jackson lender row names today's holder; the Jackson originator may be another. Among Jackson 7(a) holders: The Huntington National Bank (105 loans, $17.5 million), Fifth Third Bank (17 loans, $12.5 million), and Chelsea State Bank (9 loans, $2.4 million). Jackson holders under 504 include Michigan Certified Development Corporation (15 loans, $11.7 million). Jackson rows serve a borrower as background. No Jackson row recommends any institution.
12.8% is the Jackson cancellation floor for FY2017 to FY2024 approvals. Jackson withholds a ceiling: Jackson loans are too few. The Jackson charge-off rate is withheld. Too few Jackson loans were disbursed FY2017 to FY2021, so no rate is safe. Jackson rates are floors. Loans season, and Jackson events can still raise them. In Jackson, a county name places each loan. Jackson follows the July 2023 delineation. Jackson omits loans with no county match. Jackson totals count loans outside the tracked classes.
Jackson approvals were thinnest in FY2019 (15 loans, $2.9 million) and heaviest in FY2025 (41 loans, $21.0 million). The first year, FY2017, shows 26 loans and $10.3 million for Jackson. FY2026 closes the Jackson series at 16 loans, $3.9 million. A Jackson study weighs local demand against Jackson County, MI competitors, not national patterns. The Jackson median is $153,600. Set Jackson budgets beside it; nationally it is 0.74x. Jackson debt service gets a rate shock. The Jackson floors above explain the caution. Jackson appraisal evidence comes from area sales. Jackson income evidence sits beside it. Absorption near Jackson County, MI is tested for Jackson on a slow case. The Jackson study states its limits beside Jackson County, MI findings.
| Loans approved, FY2017 to FY2026 | 252 |
|---|---|
| Gross dollars approved | $104.0 million |
| Median loan | $153,600 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $432,825 |
| SBA 7(a) loans | 232 |
| SBA 504 loans | 20 |
| Franchise share of loans | 9.1% |
| Rank among metro and micro areas by loans | 270 of 928 |
| Median loan against the national median | 0.74x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 12.8% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | withheld |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | withheld |
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 Jackson, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 26 | $10.3 million |
| FY2018 | 29 | $12.8 million |
| FY2019 | 15 | $2.9 million |
| FY2020 | 15 | $4.0 million |
| FY2021 | 34 | $17.3 million |
| FY2022 | 22 | $8.0 million |
| FY2023 | 30 | $4.9 million |
| FY2024 | 24 | $18.8 million |
| FY2025 | 41 | $21.0 million |
| FY2026 | 16 | $3.9 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 194 |
| Limited-service restaurant | 12 |
| Full-service restaurant | 8 |
| Rehabilitation and therapy clinic | 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 | 15 | $11.7 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 105 | $17.5 million |
| Fifth Third Bank | 17 | $12.5 million |
| Bank Michigan | 12 | $8.4 million |
| Chelsea State Bank | 9 | $2.4 million |
| First Merchants Bank | 8 | $2.6 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 |
|---|---|
| Jackson County, MI | 252 |
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-27100.
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 Jackson, 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