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 Monroe, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
In Monroe, SBA's files record 295 loans over FY2017 to FY2026, totalling $117.4 million of gross dollars. Monroe ranks across every metro and micro area, by loans, number 245 of 928. The middle half of Monroe loans sits between $50,000 and $452,500, around a typical loan of $104,000; that puts the median at 0.50x the nationwide median. Split by program, Monroe shows 287 loans in 7(a) against 8 in 504. Franchises make up 12.9% of approvals.
Next, within the business classes we show for Monroe, full-service restaurant leads with 17 loans, trailed by limited-service restaurant (17) and liquor store with 14. Another 198 loans in Monroe fall outside the classes. Every loan in Monroe falls in Monroe County, MI, at 295 loans, which makes our work around Monroe a single-county exercise.
Institutions shown for Monroe come from SBA's official Monroe records of the 295 approved loans in Monroe, under their current or past holder; the records locate each position but say nothing of what lenders require. Beyond that, under 7(a) in Monroe, the largest holders are The Huntington National Bank, with 155 loans for $32.8 million; next, KeyBank National Association at 16 loans and $4.6 million. An applicant near Monroe County, MI should write the Monroe study to stand on its own evidence, whichever institution holds the loan.
Looking at Monroe approvals from FY2017 to FY2024, at least 15.4% were cancelled after approval in Monroe, and that is a floor; the full Monroe share can only be higher. In the same files, the charge-off rate for Monroe County, MI is left blank here by Loan Analytics, because under 30 Monroe loans reached disbursement in that cohort. That gap, across Monroe, must never be read as zero losses. Beyond that, on the calendar, Monroe topped out in FY2024 at 49 loans and $17.9 million, and was weakest in FY2026 at 21 loans and $17.0 million.
For Monroe, begin with demand: who works in Monroe County, MI, who visits from nearby, set against Monroe overall, and what gap the 17 full-service restaurant loans leave. Cost: $104,000 is the Monroe median and $50,000 to $452,500 the central range, so a Monroe County, MI site must price itself against that $104,000 median. Then coverage: Monroe coverage survives a weak year against the 15.4% cancellation floor plus the charge-off rate for Monroe, which is also withheld on a thin cohort. The Monroe appraisal must support the worth financed. Monroe adopts the 2023 July area map; a record whose county entry is unmapped drops out of any area, Monroe among them, but the totals keep loans not in the listed classes.
| Loans approved, FY2017 to FY2026 | 295 |
|---|---|
| Gross dollars approved | $117.4 million |
| Median loan | $104,000 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $452,500 |
| SBA 7(a) loans | 287 |
| SBA 504 loans | 8 |
| Franchise share of loans | 12.9% |
| Rank among metro and micro areas by loans | 245 of 928 |
| Median loan against the national median | 0.50x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 15.4% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 17.8% |
| 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 Monroe, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 31 | $3.2 million |
| FY2018 | 31 | $10.9 million |
| FY2019 | 23 | $10.4 million |
| FY2020 | 25 | $11.5 million |
| FY2021 | 22 | $12.8 million |
| FY2022 | 26 | $12.7 million |
| FY2023 | 34 | $7.9 million |
| FY2024 | 49 | $17.9 million |
| FY2025 | 33 | $13.2 million |
| FY2026 | 21 | $17.0 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 198 |
| Full-service restaurant | 17 |
| Limited-service restaurant | 17 |
| Liquor store | 14 |
| Fitness center | 9 |
| Gas station and truck stop | 5 |
| Beverage manufacturing (breweries, wineries, distilleries) | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 155 | $32.8 million |
| KeyBank National Association | 16 | $4.6 million |
| First Merchants Bank | 13 | $2.7 million |
| Celtic Bank Corporation | 9 | $7.3 million |
| Live Oak Banking Company | 7 | $6.5 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 |
|---|---|
| Monroe County, MI | 295 |
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-33780.
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 Monroe, 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