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 South Bend-Mishawaka, IN-MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
The agency approved 627 SBA loans for South Bend-Mishawaka projects over FY2017 to FY2026, carrying $281.1 million throughout every asset class. By loan count, South Bend-Mishawaka ranks 146 of 928 against every other statistical area, South Bend-Mishawaka among them. The local median loan is $150,000, while the middle half range over $50,000 to $410,000. South Bend-Mishawaka borrowers borrow less, at 0.72x of the national median. Smaller South Bend-Mishawaka tickets are the first thing that sets South Bend-Mishawaka apart.
The metro area shows 556 loans under 7(a), against 71 under 504; in South Bend-Mishawaka, 7(a) holds the larger share. Franchise brands account for 12.6% of loans in this metro area. In South Bend-Mishawaka, on the 7(a) South Bend-Mishawaka side, The Huntington National Bank leads with 74 loans and $16.3 million. Second place is Centier Bank: 39 loans, $15.1 million. The count for KeyBank National Association is 22 loans, then 19 for Horizon Bank. 504 lending here runs through Business Development Corporation (BDC), at 61 loans and $28.9 million. These are SBA's records of South Bend-Mishawaka loans held or once held. The threshold for The Huntington National Bank appears as the holder SBA shows; no row describes how Centier Bank treats borrowers.
The larger share of the South Bend-Mishawaka record falls outside the class table: 461 loans that carry codes outside the South Bend-Mishawaka table. The South Bend-Mishawaka class rows therefore describe a minority of South Bend-Mishawaka lending. The South Bend-Mishawaka class table opens with full-service restaurant, 27 loans, ahead of hotel and motel at 26, and beauty salon at 24. Further down sit limited-service restaurant, 16 loans and automotive South Bend-Mishawaka mechanical repair (car and truck) at 13. St. Joseph County, IN is the largest source of loans, with 553, followed by Cass County, MI with 74. Demand differs between these counties, so the South Bend-Mishawaka figure hides some spread.
Looking at FY2017 to FY2024 approvals, South Bend-Mishawaka cancellations came to at least 9.4%. Treating undisbursed South Bend-Mishawaka loans as cancelled gives a ceiling of 11.3%. The FY2017 to FY2021 cohort of 308 disbursed South Bend-Mishawaka loans shows South Bend-Mishawaka charge-offs to date of at least 2.6%. The five-year rate is withheld because the group is below 30 loans, and any South Bend-Mishawaka figure would be a guess. The cohort is still maturing, making these floors where a future reading can add but never subtract. Annual approvals peaked in FY2017 at 85 loans and $30.3 million. FY2020, with 43 loans and $19.6 million, was the weakest year before FY2026. South Bend-Mishawaka is built from project counties such as St. Joseph County, IN; county membership follows the 2023 delineation, while any county the name pairing misses is omitted from South Bend-Mishawaka.
A study for a South Bend-Mishawaka project has to be prepared for the particular county, because the metro South Bend-Mishawaka area total blends different markets. In South Bend-Mishawaka, with full-service restaurant first in the South Bend-Mishawaka class table, it has to examine liquor licence timing and cost and what prime cost leaves for debt, then kitchen capacity against peak service. For hotel and motel, the next class in South Bend-Mishawaka, depend on what competing South Bend-Mishawaka rooms charge and on room-night demand by segment. A South Bend-Mishawaka operator's coverage has to clear even if sales slip; comparable sales near the South Bend-Mishawaka site must support the value. Since South Bend-Mishawaka loans skew small, a bigger request will draw questions the report should answer first.
| Loans approved, FY2017 to FY2026 | 627 |
|---|---|
| Gross dollars approved | $281.1 million |
| Median loan | $150,000 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $410,000 |
| SBA 7(a) loans | 556 |
| SBA 504 loans | 71 |
| Franchise share of loans | 12.6% |
| Rank among metro and micro areas by loans | 146 of 928 |
| Median loan against the national median | 0.72x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 9.4% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 11.3% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 2.6% |
| Charged off within five years of approval | withheld |
| Loans in that cohort | 308 |
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 South Bend-Mishawaka, IN-MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 85 | $30.3 million |
| FY2018 | 72 | $44.1 million |
| FY2019 | 71 | $17.3 million |
| FY2020 | 43 | $19.6 million |
| FY2021 | 68 | $38.2 million |
| FY2022 | 73 | $31.2 million |
| FY2023 | 61 | $20.7 million |
| FY2024 | 58 | $31.3 million |
| FY2025 | 55 | $25.1 million |
| FY2026 | 41 | $23.3 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 461 |
| Full-service restaurant | 27 |
| Hotel and motel | 26 |
| Beauty salon | 24 |
| Limited-service restaurant | 16 |
| Automotive mechanical repair (car and truck) | 13 |
| Coffee shop and snack bar | 10 |
| Dental office | 6 |
| Fitness center | 6 |
| Gas station and truck stop | 5 |
| Veterinary clinic | 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) | 61 | $28.9 million |
| Lender | Loans | Dollars |
|---|---|---|
| 1st Source Bank | 217 | $40.5 million |
| The Huntington National Bank | 74 | $16.3 million |
| Centier Bank | 39 | $15.1 million |
| KeyBank National Association | 22 | $13.0 million |
| Horizon Bank | 19 | $5.2 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 |
|---|---|
| St. Joseph County, IN | 553 |
| Cass County, MI | 74 |
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-43780.
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 South Bend-Mishawaka, IN-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