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 Petoskey, MI Micro Area, every asset class together, and what a feasibility study for a project there has to test.
Petoskey, MI is a micropolitan area, and its 138 SBA approvals in FY2017 to FY2026 carried $50.4 million in gross dollars. Petoskey counts as a mid-table area, ranked 392 of 928 by loans. Petoskey is read whole, every class counted. A slice of MI is not how Petoskey is treated.
$50,000 to $350,000 spans the middle half of Petoskey loans, and $115,500 is the median. Petoskey sits well below the national level: its 0.56x ratio to the national median means Petoskey requests sized nationally may look large. Petoskey counts 129 loans under 7(a) and 9 under 504, so 7(a) carries the Petoskey mix. Petoskey franchised businesses took 4.3% of loans, so a branded concept in Petoskey needs a brand-cost check in Petoskey.
Petoskey: full-service restaurant (18 loans); limited-service restaurant (9 loans) head the tracked-class list. The 88 loans in no tracked class keep Petoskey totals from reading as pure property; much Petoskey borrowing funds operating businesses. Petoskey counts by county run 138 loans in Emmet County, MI; a Petoskey study should say which it covers. The Huntington National Bank ($17.0 million, 72 loans); Citizens National Bank of Cheboygan ($4.2 million, 13 loans); Fifth Third Bank ($3.5 million, 7 loans) lead 7(a) lending in Petoskey. The Huntington National Bank's 72 loans, like every Petoskey lender figure, are an SBA record of Petoskey loans held or once held. No Petoskey lender is judged by these counts.
The Petoskey series opens at 7 loans in FY2017 and closes at 14, higher than the start; its high is 22 loans ($8.0 million) in FY2025, its low 7 in FY2017. Petoskey cancellations stand at 7.8%, a floor, for Petoskey approvals in FY2017 to FY2024; Petoskey's ceiling is withheld, never zero in Petoskey. A charge-off floor for Petoskey would rest on a thin cohort of 138 loans, so Petoskey withholds it; withheld is not zero. Petoskey faces a geography limit: Petoskey, MI uses the July 2023 definition; 138 loans are matched by county, and unplaceable Petoskey loans are omitted, so Petoskey counts and rates are floors.
For Petoskey, a study tests Petoskey demand within a defined trade area, since Emmet County, MI dominates Petoskey loan counts. If a Petoskey concept resembles full-service restaurant, Petoskey offers size and lender precedent; other Petoskey concepts must rest on their own Petoskey evidence. The Petoskey cost section uses local quotes; run Petoskey debt service coverage for loans near $115,500 and near $350,000. Petoskey is micropolitan, so sales are sparse; the Petoskey appraisal must state its reach in Petoskey, MI. The Petoskey record frames questions, and each lender in Petoskey decides on its own.
| Loans approved, FY2017 to FY2026 | 138 |
|---|---|
| Gross dollars approved | $50.4 million |
| Median loan | $115,500 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $350,000 |
| SBA 7(a) loans | 129 |
| SBA 504 loans | 9 |
| Franchise share of loans | 4.3% |
| Rank among metro and micro areas by loans | 392 of 928 |
| Median loan against the national median | 0.56x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 7.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 Petoskey, MI Micro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 7 | $1.3 million |
| FY2018 | 15 | $1.8 million |
| FY2019 | 9 | $1.3 million |
| FY2020 | 9 | $2.4 million |
| FY2021 | 16 | $6.6 million |
| FY2022 | 8 | $1.1 million |
| FY2023 | 18 | $8.9 million |
| FY2024 | 20 | $11.5 million |
| FY2025 | 22 | $8.0 million |
| FY2026 | 14 | $7.5 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 88 |
| Full-service restaurant | 18 |
| Limited-service restaurant | 9 |
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 | 72 | $17.0 million |
| Citizens National Bank of Cheboygan | 13 | $4.2 million |
| 4Front Credit Union | 8 | $2.7 million |
| Fifth Third Bank | 7 | $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 |
|---|---|
| Emmet County, MI | 138 |
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-37950.
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 Petoskey, MI Micro 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