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 Niles, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Niles drew 286 SBA approvals across FY2017 to FY2026, worth $133.8 million gross. By loan count, Niles stands 250 of 928 among all areas. Half the Niles loans are $184,850 or smaller. Niles loans in the middle half run $78,500 to $455,050. Set beside the nation, Niles stands at 0.89x. Niles splits into 262 loans under 7(a) and 24 under 504. 15.4% of the loans in Niles carry a franchise brand. Those 286 Niles loans carry $133.8 million.
Limited-service restaurant (23) tops Niles; full-service restaurant (15) and hotel and motel (12) follow. Fourth in Niles is coffee shop and snack bar, with 11 loans. 184 loans in Niles fit no class, so Niles class patterns say less. Niles consists of Berrien County, MI, where SBA places 286 loans.
In Niles, SBA lists the current holder of each loan. Niles holders under 7(a) include 65 loans at The Huntington National Bank ($14.4 million), 33 loans at Horizon Bank ($5.7 million), and 24 loans at United FCU ($12.5 million). Among Niles 504 holders: 12 loans at Business Development Corporation (BDC) ($9.0 million) and 6 loans at Great Lakes Commercial Finance ($3.9 million). For a Niles borrower, the rows are context only. No Niles row states a holder's terms.
8.7% is the Niles cancellation floor for FY2017 to FY2024 approvals. Niles withholds a ceiling: Niles loans are too few. Niles charge-offs: 4.9% among 143 loans disbursed FY2017 to FY2021, a floor. Niles withholds a five-year rate: Niles loans are too few. Treat Niles rates as floors. Later events lift them, Niles included. Niles loans are placed by county name. For Niles, the July 2023 list governs. Niles omits loans with no county match. The Niles total includes loans outside the classes.
The Niles trend peaks in FY2018 with 44 loans ($13.2 million) and bottoms in FY2020 with 19 ($9.0 million). The first year, FY2017, shows 36 loans and $15.7 million for Niles. FY2026 closes the Niles series at 21 loans, $12.1 million. In Niles, demand testing starts with Berrien County, MI and the businesses already serving it. The Niles median is $184,850. Set Niles budgets beside it; nationally it is 0.89x. Niles coverage is stressed with slower ramp-up. Niles reviewers will weigh the floors above. Niles value is tested against cost by appraisal. Niles comparables decide how. Sources and uses in Niles must tie to bids near Berrien County, MI. The Niles study states its limits beside Berrien County, MI findings.
| Loans approved, FY2017 to FY2026 | 286 |
|---|---|
| Gross dollars approved | $133.8 million |
| Median loan | $184,850 |
| Middle half of loans, from | $78,500 |
| Middle half of loans, to | $455,050 |
| SBA 7(a) loans | 262 |
| SBA 504 loans | 24 |
| Franchise share of loans | 15.4% |
| Rank among metro and micro areas by loans | 250 of 928 |
| Median loan against the national median | 0.89x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 8.7% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | withheld |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 4.9% |
| Charged off within five years of approval | withheld |
| Loans in that cohort | 143 |
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 Niles, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 36 | $15.7 million |
| FY2018 | 44 | $13.2 million |
| FY2019 | 29 | $11.6 million |
| FY2020 | 19 | $9.0 million |
| FY2021 | 31 | $24.0 million |
| FY2022 | 23 | $13.7 million |
| FY2023 | 19 | $5.1 million |
| FY2024 | 29 | $9.7 million |
| FY2025 | 35 | $19.5 million |
| FY2026 | 21 | $12.1 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 184 |
| Limited-service restaurant | 23 |
| Full-service restaurant | 15 |
| Hotel and motel | 12 |
| Coffee shop and snack bar | 11 |
| Beverage manufacturing (breweries, wineries, distilleries) | 8 |
| Veterinary clinic | 6 |
| Beauty salon | 6 |
| Grocery store | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Business Development Corporation (BDC) | 12 | $9.0 million |
| Great Lakes Commercial Finance | 6 | $3.9 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 65 | $14.4 million |
| 1st Source Bank | 33 | $6.8 million |
| Horizon Bank | 33 | $5.7 million |
| United FCU | 24 | $12.5 million |
| Fifth Third Bank | 9 | $3.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 |
|---|---|
| Berrien County, MI | 286 |
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-35660.
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 Niles, 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