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 Kalamazoo-Portage, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Kalamazoo-Portage is Kalamazoo County alone, with 520 SBA approvals for FY2017 to FY2026 and $236.0 million gross, rank 160 of 928. Kalamazoo loans center on $200,000. Kalamazoo sits at 0.96x of the national figure. Kalamazoo: half of loans span $74,450 to $446,700. The program split is 458 loans under 7(a) and 62 under 504, and franchises account for 13.7% of loans.
Kalamazoo has one gap that matters. The charge-off rate to date is withheld here because too few funded loans stand behind it, and the five-year rate is withheld for the same reason; neither is zero. A reader should lean on the cancellation floor instead and on the lender evidence below, and a study should not assume that a missing rate means a clean record.
Full-service restaurant leads Kalamazoo at 26 loans, then limited-service restaurant at 18, fitness center and child care center at 15 each, and hotel and motel at 10; 367 loans sit outside the named classes. Count was 69 loans and $24.8 million in FY2017, the peak, fell to 43 loans and $15.2 million in FY2019, and closed at 57 loans and $32.5 million in FY2026. The Huntington National Bank holds 127 loans and $27.4 million under 7(a), Horizon Bank 43 loans and $12.0 million and Fifth Third Bank 21 loans and $5.5 million. In 504, Michigan Certified Development Corporation has 35 loans and $35.6 million, with Great Lakes Commercial Finance at 22 loans and $9.3 million. Kalamazoo lists rest on SBA's holder records. Kalamazoo names hold or held these loans. Kalamazoo counts are volume, and Kalamazoo counts promise no lender requirement.
Kalamazoo: cancelled after approval at least 9.8% of Kalamazoo's approvals. The Kalamazoo window is FY2017 to FY2024. Kalamazoo counts undisbursed loans for 11.2%. Kalamazoo reports no charge-off rate. Too few Kalamazoo loans back one; Kalamazoo is not a zero. Open Kalamazoo loans may raise every Kalamazoo floor. Kalamazoo is a county roll-up. Kalamazoo applies the July 2023 delineation. Kalamazoo matches each county by name. Kalamazoo omits loans whose counties fail to place. Kalamazoo still counts approvals outside named classes. A Kalamazoo study should test demand at the site, cost, debt service in a lean year and value from Kalamazoo County comparables; for child care, add licensed capacity and staffing ratios, and for fitness, membership churn. Loan Analytics prepares Kalamazoo studies. Daniel Smith, MAI, signs each Kalamazoo study.
| Loans approved, FY2017 to FY2026 | 520 |
|---|---|
| Gross dollars approved | $236.0 million |
| Median loan | $200,000 |
| Middle half of loans, from | $74,450 |
| Middle half of loans, to | $446,700 |
| SBA 7(a) loans | 458 |
| SBA 504 loans | 62 |
| Franchise share of loans | 13.7% |
| Rank among metro and micro areas by loans | 160 of 928 |
| Median loan against the national median | 0.96x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 9.8% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 11.2% |
| 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 Kalamazoo-Portage, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 69 | $24.8 million |
| FY2018 | 49 | $27.9 million |
| FY2019 | 43 | $15.2 million |
| FY2020 | 47 | $15.4 million |
| FY2021 | 55 | $30.3 million |
| FY2022 | 58 | $34.5 million |
| FY2023 | 50 | $13.5 million |
| FY2024 | 48 | $22.1 million |
| FY2025 | 44 | $19.7 million |
| FY2026 | 57 | $32.5 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 367 |
| Full-service restaurant | 26 |
| Limited-service restaurant | 18 |
| Fitness center | 15 |
| Child care center | 15 |
| Hotel and motel | 10 |
| Automotive mechanical repair (car and truck) | 10 |
| Beauty salon | 10 |
| Coffee shop and snack bar | 10 |
| Car wash | 6 |
| Dental office | 6 |
| Beverage manufacturing (breweries, wineries, distilleries) | 5 |
| Liquor store | 5 |
| 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 |
|---|---|---|
| Michigan Certified Development Corporation | 35 | $35.6 million |
| Great Lakes Commercial Finance | 22 | $9.3 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 127 | $27.4 million |
| Horizon Bank | 43 | $12.0 million |
| 1st Source Bank | 38 | $7.5 million |
| Fifth Third Bank | 21 | $5.5 million |
| Kellogg Community CU | 18 | $3.7 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 |
|---|---|
| Kalamazoo County, MI | 520 |
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-28020.
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 Kalamazoo-Portage, 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