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 Grand Rapids-Wyoming-Kentwood, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
3,883 SBA loans for projects in Grand Rapids-Wyoming-Kentwood, MI from FY2017 to FY2026 carry $1.36 billion in gross dollars. Grand Rapids-Wyoming-Kentwood ranks 36 of 928 within the complete list of metropolitan and micropolitan areas by loans. $100,000 marks the median; half of all loans spans $41,850 to $325,500. Then, the area median comes to 0.48x in proportion to the country's median, meaning loans tend to run below the figure for the nation. For context, Grand Rapids-Wyoming-Kentwood counts only its home counties, never a state's mix of markets: 3,883 loans overall.
3,529 7(a) approvals stand against 354 loans in 504. 8.2% of the approvals go to franchised units here. Then, within 7(a) cases, the biggest banks and lenders by count are The Huntington National Bank booking 2,342 loans totalling $355.8 million, Fifth Third Bank booking 139 loans and $78.8 million, then ChoiceOne Bank holding 66 loans for $34.6 million. For context, for 504, the leading program intermediaries by loans come out as Great Lakes Commercial Finance at 224 loans totalling $162.4 million. Separately, all the names come from SBA data for 3,883 loans; they list completed approvals and no more, not the terms that lenders require around Grand Rapids-Wyoming-Kentwood.
178 in full-service restaurant, 87 for limited-service restaurant, 70 for fitness center, plus automotive mechanical repair with 63 rank first by class in loan count. 3,114 loans sit beyond all named classes, so its $1.36 billion total is wider than what the classes show. 5 approvals in nonresidential lessor within Grand Rapids-Wyoming-Kentwood make too small a base for a pattern. Separately, among the counties, Kent County (2,591), Ottawa County (947), and Montcalm County (124) lead the loan count. Next, over the approval years, FY2017 opens at 467 loans and $134.2 million; no year beats the opening one, and FY2026, the last complete year, concludes the run at 259 loans and $131.6 million.
10.4% of FY2017 to FY2024 loans in Grand Rapids-Wyoming-Kentwood were cancelled after approval before disbursement, and that is a floor; 12.1% marks the ceiling with undisbursed loans included. 2.9% among FY2017 to FY2021 disbursed loans in Grand Rapids-Wyoming-Kentwood have been charged off, a floor; 1.6% went to charge-off by the fifth year after approval, across a cohort of 1,830 disbursed loans. Beyond that, read each share above like a lower bound, because loans written lately have had little opportunity to cancel or default; the file has 3,883 loans in all. Then, a Grand Rapids-Wyoming-Kentwood entry here rests on the core-based area holding any loan's county of project, using the July 2023 boundaries in force; each county were matched by name alone, and a loan whose county cannot be assigned is missing from each area list without exception. Then, named class or not, every approval in either program in the area is included within its $1.36 billion total.
Within Grand Rapids-Wyoming-Kentwood, a study covering a property opens with the specific operator, not the average of the 3,883-loan file. In addition, local demand in Grand Rapids-Wyoming-Kentwood opens the work: will Grand Rapids-Wyoming-Kentwood's surrounding market support the receipts projected, set against rivals in areas such as Kent County? In addition, the area median comes to 0.48x measured against the nation's median, so typical tickets run small; an outsized request must make the case that its debt is serviceable. For context, coverage of debt service ties revenue to cost for Grand Rapids-Wyoming-Kentwood: projected operating income compared with the payments due, plus a weak-sales case. Here, the appraisal finishes the job on the Grand Rapids-Wyoming-Kentwood site: value as built has to cover the sum put forward. For context, an applicant carrying an outside feasibility study of Grand Rapids-Wyoming-Kentwood, prior to approaching the lenders above, addresses these rates before they are raised; the final word is with the bank and SBA in Grand Rapids-Wyoming-Kentwood, and a study cannot change that.
| Loans approved, FY2017 to FY2026 | 3,883 |
|---|---|
| Gross dollars approved | $1.36 billion |
| Median loan | $100,000 |
| Middle half of loans, from | $41,850 |
| Middle half of loans, to | $325,500 |
| SBA 7(a) loans | 3,529 |
| SBA 504 loans | 354 |
| Franchise share of loans | 8.2% |
| Rank among metro and micro areas by loans | 36 of 928 |
| Median loan against the national median | 0.48x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 10.4% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 12.1% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 2.9% |
| Charged off within five years of approval | 1.6% |
| Loans in that cohort | 1,830 |
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 Grand Rapids-Wyoming-Kentwood, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 467 | $134.2 million |
| FY2018 | 455 | $108.8 million |
| FY2019 | 418 | $111.9 million |
| FY2020 | 334 | $103.2 million |
| FY2021 | 395 | $155.0 million |
| FY2022 | 360 | $160.0 million |
| FY2023 | 388 | $139.9 million |
| FY2024 | 435 | $165.4 million |
| FY2025 | 372 | $149.9 million |
| FY2026 | 259 | $131.6 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 3,114 |
| Full-service restaurant | 178 |
| Limited-service restaurant | 87 |
| Fitness center | 70 |
| Automotive mechanical repair (car and truck) | 63 |
| Beauty salon | 44 |
| Dental office | 32 |
| Coffee shop and snack bar | 29 |
| Beverage manufacturing (breweries, wineries, distilleries) | 27 |
| Grocery store | 27 |
| Medical office (physicians) | 24 |
| Liquor store | 22 |
| Hotel and motel | 21 |
| Child care center | 21 |
| Self storage | 19 |
| Caterers (includes banquet halls with catering staff) | 19 |
| Car wash | 18 |
| Veterinary clinic | 14 |
| Rehabilitation and therapy clinic | 12 |
| Assisted living (without nursing care) | 8 |
| Gas station and truck stop | 6 |
| Behavioral health and addiction treatment | 6 |
| Nonresidential lessor (flex, office and retail investor buildings) | 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 | 224 | $162.4 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 2,342 | $355.8 million |
| Fifth Third Bank | 139 | $78.8 million |
| ChoiceOne Bank | 66 | $34.6 million |
| Old National Bank | 65 | $49.0 million |
| Highpoint Community Bank | 54 | $13.8 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 |
|---|---|
| Kent County, MI | 2,591 |
| Ottawa County, MI | 947 |
| Montcalm County, MI | 124 |
| Barry County, MI | 114 |
| Ionia County, MI | 107 |
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-24340.
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 Grand Rapids-Wyoming-Kentwood, 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