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 Cadillac, MI Micro Area, every asset class together, and what a feasibility study for a project there has to test.
108 approvals within Cadillac, MI over FY2017 to FY2026 add up to $29.1 million in gross dollars. For context, Cadillac comes in at 452 of 928 among all CBSAs on approvals. $100,000 stands as the typical loan; the middle half lies between $40,075 and $289,500. Here, the local median is 0.48x in proportion to the national median, which puts ticket size below the national norm. Beyond that, Cadillac holds only projects inside its borders, never a whole state's average: 108 approvals on file.
101 SBA 7(a) loans sit beside 7 SBA 504 loans. Here, 14.8% of the loans carry franchised units here. In practice, in 7(a), the biggest lending names by number appear as The Huntington National Bank at 54 loans and $6.5 million, Horizon Bank holding 21 loans for $5.4 million, then Live Oak Banking Company with 5 loans for $3.2 million. Separately, no 504 lender in Cadillac has enough loans to be named. Lender names come from SBA data covering 108 loans; they describe completed approvals and nothing further, and not the terms that lenders want around Cadillac.
Limited-service restaurant at 6 followed by coffee shop and snack bar with 6 lead the named classes by approvals. Then, 75 loans fall beyond all named classes, so its $29.1 million total reaches beyond any class table. Among the counties, Wexford County (72) followed by Missaukee County (36) come first. Worth noting: by year, FY2017 opens at 10 loans and $3.7 million; years in between that Loan Analytics withholds are left out, while FY2022 closes the tally at 7 loans and $3.4 million.
9.0% of FY2017 through FY2024 loans in Cadillac were cancelled before disbursement, a floor. The matching ceiling on this page stays withheld, leaving the floor alone. In practice, no default floor is shown for Cadillac, MI; the disbursed cohort holds too few loans, and a blank is not zero. In practice, take each share printed here like a floor, since loans approved recently received little time to cancel or default, across 108 loans. In practice, area membership here is the statistical area holding every loan's county of the project, from July 2023 boundaries; project counties are tied name to name, while an approval whose county does not map is absent from each area list as a rule. For context, class or no class, any 7(a) and 504 approval in Cadillac is counted towards its $29.1 million total.
Around Cadillac, a proper study aimed at a project must begin with the specific operator, and not the 108-loan file. Local demand in Cadillac is tested first: can Cadillac's trade area sustain the volume needed, set against rivals around Wexford County? Beyond that, the local median is 0.48x of the national median, so typical tickets stay compact; a larger project should demonstrate why its size is sound. Then, the coverage test binds demand to cost in Cadillac: forecast income tested against loan payments, plus a weak-sales case. Also, an independent appraisal finishes the job in Cadillac: the as-built value must carry the amount asked for. A borrower holding a third-party study of Cadillac, when first speaking with a lender, addresses those floors before they are raised; approval is for lender and SBA in Cadillac, never the study.
| Loans approved, FY2017 to FY2026 | 108 |
|---|---|
| Gross dollars approved | $29.1 million |
| Median loan | $100,000 |
| Middle half of loans, from | $40,075 |
| Middle half of loans, to | $289,500 |
| SBA 7(a) loans | 101 |
| SBA 504 loans | 7 |
| Franchise share of loans | 14.8% |
| Rank among metro and micro areas by loans | 452 of 928 |
| Median loan against the national median | 0.48x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 9.0% |
|---|---|
| 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 Cadillac, MI Micro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 10 | $3.7 million |
| FY2018 | 14 | $2.7 million |
| FY2019 | 10 | $814,700 |
| FY2020 | 20 | $2.8 million |
| FY2021 | 7 | $3.8 million |
| FY2022 | 7 | $3.4 million |
| FY2023 | withheld | withheld |
| FY2024 | withheld | withheld |
| FY2025 | withheld | withheld |
| FY2026 | withheld | withheld |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 75 |
| Limited-service restaurant | 6 |
| Coffee shop and snack bar | 6 |
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 | 54 | $6.5 million |
| Horizon Bank | 21 | $5.4 million |
| Live Oak Banking Company | 5 | $3.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 |
|---|---|
| Wexford County, MI | 72 |
| Missaukee County, MI | 36 |
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-15620.
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 Cadillac, 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