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 Traverse City, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Traverse City, MI is a metropolitan area, and its 687 SBA approvals in FY2017 to FY2026 carried $278.8 million in gross dollars. Traverse City is distinctive on size first: a $165,800 median loan, 0.80x the national median, outside our margin. Traverse City, MI departs nationally on losses: across 687 loans, the charge-off floor below for Traverse City sits outside our margin. Traverse City counts as an upper-tier area, ranked 137 of 928 by loans. In Traverse City, MI, every asset class is pooled for Traverse City. That view of Traverse City is missing from MI and national tables.
A Traverse City median loan of $165,800 sits inside a middle half of $58,500 to $415,000. Outside data makes Traverse City requests look heavy; at 0.80x, Traverse City is below the national level. Traverse City: 7(a) leads the mix, with 540 7(a) loans against 147 under 504. Traverse City franchise loans reach 8.0%, so brand standards often shape a Traverse City request there.
Tracked classes in Traverse City, with loan counts: full-service restaurant 40, hotel and motel 19, automotive mechanical repair 17, limited-service restaurant 16. 513 Traverse City loans sit outside the tracked classes, so Traverse City operating businesses show up in these totals. Traverse City counts by county run 496 loans in Grand Traverse County, MI, 108 loans in Leelanau County, MI, and 48 loans in Benzie County, MI; a Traverse City study should say which it covers. Traverse City 7(a) leaders: The Huntington National Bank ($50.3 million, 247 loans); Honor Bank ($12.1 million, 38 loans); Nicolet National Bank ($21.6 million, 36 loans). Traverse City 504 lending is led by 111 loans at Great Lakes Commercial Finance ($49.3 million); 36 loans at Michigan Certified Development Corporation ($22.7 million). Traverse City lender figures, The Huntington National Bank's 247 loans included, are an SBA record of Traverse City loans held or once held; no Traverse City lender is judged by them.
Traverse City goes from 77 loans in FY2017 to 36 in FY2026, ending lower: the peak was 94 in FY2021, and the trough 36 in FY2026. A Traverse City borrower should know the cancellation record: 9.5% as a floor and 10.9% as a ceiling, for FY2017 to FY2024 Traverse City approvals. Of the 353 loans in the Traverse City cohort for FY2017 to FY2021, 1.7% are charged off, a floor. The Traverse City five-year loss figure is withheld; Traverse City cannot read it as zero. Traverse City faces a geography limit: Traverse City, MI uses the July 2023 definition; 687 loans are matched by county, and unplaceable Traverse City loans are omitted, so Traverse City counts and rates are floors.
A Traverse City feasibility study begins with Traverse City demand from the right counties: Grand Traverse County, MI leads the loan counts, though Traverse City is wider. If a Traverse City concept resembles full-service restaurant, Traverse City offers size and lender precedent; other Traverse City concepts must rest on their own Traverse City evidence. Test Traverse City coverage of debt service on a $165,800 loan, and on a $415,000 loan, after pricing Traverse City costs from bids. Traverse City appraisals compare within one submarket of Traverse City, MI, not across averages. Nothing printed for Traverse City predicts approval; each Traverse City lender still reviews a study.
| Loans approved, FY2017 to FY2026 | 687 |
|---|---|
| Gross dollars approved | $278.8 million |
| Median loan | $165,800 |
| Middle half of loans, from | $58,500 |
| Middle half of loans, to | $415,000 |
| SBA 7(a) loans | 540 |
| SBA 504 loans | 147 |
| Franchise share of loans | 8.0% |
| Rank among metro and micro areas by loans | 137 of 928 |
| Median loan against the national median | 0.80x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 9.5% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 10.9% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 1.7% |
| Charged off within five years of approval | withheld |
| Loans in that cohort | 353 |
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 Traverse City, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 77 | $24.4 million |
| FY2018 | 89 | $31.3 million |
| FY2019 | 75 | $22.9 million |
| FY2020 | 63 | $17.3 million |
| FY2021 | 94 | $53.0 million |
| FY2022 | 72 | $33.6 million |
| FY2023 | 57 | $22.3 million |
| FY2024 | 62 | $36.9 million |
| FY2025 | 62 | $21.0 million |
| FY2026 | 36 | $16.0 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 513 |
| Full-service restaurant | 40 |
| Hotel and motel | 19 |
| Automotive mechanical repair (car and truck) | 17 |
| Limited-service restaurant | 16 |
| Beverage manufacturing (breweries, wineries, distilleries) | 11 |
| Medical office (physicians) | 8 |
| Dental office | 7 |
| Beauty salon | 6 |
| Car wash | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Great Lakes Commercial Finance | 111 | $49.3 million |
| Michigan Certified Development Corporation | 36 | $22.7 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 247 | $50.3 million |
| 4Front Credit Union | 50 | $12.4 million |
| Honor Bank | 38 | $12.1 million |
| Nicolet National Bank | 36 | $21.6 million |
| West Shore Bank | 19 | $10.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 |
|---|---|
| Grand Traverse County, MI | 496 |
| Leelanau County, MI | 108 |
| Benzie County, MI | 48 |
| Kalkaska County, MI | 35 |
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-45900.
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 Traverse City, 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