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 Midland, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
For Midland, the agency's approval files list 155 approved loans over FY2017 through FY2026, totalling $57.0 million of gross dollars. Midland sits across the whole list of areas, on volume, number 364 of 928. The central half of Midland approvals spans $50,000 to $350,000, with a middle figure of $141,000; that puts the median at 0.68x the national median. Around Midland County, MI, SBA 7(a) holds 142 loans, and 13 under SBA 504. Franchises make up 12.3% of the loans.
Further, of the business classes we break out for Midland, full-service restaurant is largest with 10 loans, and then limited-service restaurant (9) and assisted living, 5 loans. A further 105 loans in Midland fall outside the classes. Every loan in Midland sits in Midland County, MI, at 155 loans, so a feasibility study around Midland a single-county exercise.
Lenders listed for Midland are found in SBA's public Midland records of the 155 approvals in Midland, by present or former holder; such records tie each file though settle nothing about lender underwriting. Next, for 7(a) lending in Midland, SBA lists The Huntington National Bank (64 loans, $12.4 million); after it, Horizon Bank (10 loans, $5.3 million). An applicant in Midland can ask the Midland lender The Huntington National Bank or other Midland holders near Midland County, MI what paperwork it expects, then shape the Midland study to satisfy those answers.
Among Midland approvals from FY2017 to FY2024, at least 11.8% ended in cancellation after approval in Midland, which is a floor; the full Midland share is no lower. Worth noting, the charge-off rate around Midland County, MI is left blank on the page, since too few Midland loans funded. That absence, across Midland, is not to be taken as no losses. Notably, across the years, Midland was strongest in FY2020 at 23 loans and $15.3 million, and bottomed out in FY2017 at 7 loans and $1.8 million.
Around Midland County, MI, demand comes first: who lives in Midland County, MI, who travels in, how that compares with Midland overall, and whether the 10 full-service restaurant loans leave room. Cost: $141,000 is the Midland median and $50,000 to $350,000 the central range, so a Midland County, MI site should cost itself against that $141,000 benchmark. Coverage: Midland cash flow outlasts a sluggish year against with the 11.8% rate of cancellation and the charge-off floor for Midland, which is also suppressed since the cohort is thin. An appraisal in Midland needs to agree with the value lent against. Midland adopts the 2023 July area map; a case whose home county finds no place is missing from all areas, Midland as well, whereas the totals cover loans outside the classes named.
| Loans approved, FY2017 to FY2026 | 155 |
|---|---|
| Gross dollars approved | $57.0 million |
| Median loan | $141,000 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $350,000 |
| SBA 7(a) loans | 142 |
| SBA 504 loans | 13 |
| Franchise share of loans | 12.3% |
| Rank among metro and micro areas by loans | 364 of 928 |
| Median loan against the national median | 0.68x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 11.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 Midland, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 7 | $1.8 million |
| FY2018 | 19 | $6.3 million |
| FY2019 | 11 | $3.1 million |
| FY2020 | 23 | $15.3 million |
| FY2021 | 20 | $4.0 million |
| FY2022 | 18 | $7.0 million |
| FY2023 | 12 | $2.2 million |
| FY2024 | 17 | $5.4 million |
| FY2025 | 12 | $3.2 million |
| FY2026 | 16 | $8.8 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 105 |
| Full-service restaurant | 10 |
| Limited-service restaurant | 9 |
| Assisted living (without nursing care) | 5 |
| Beauty salon | 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 | 64 | $12.4 million |
| 1st State Bank | 14 | $10.8 million |
| Horizon Bank | 10 | $5.3 million |
| Isabella Bank | 9 | $4.7 million |
| ChoiceOne 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 |
|---|---|
| Midland County, MI | 155 |
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-33220.
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 Midland, 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