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 Lansing-East Lansing, MI Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Lansing-East Lansing appears in SBA's files with 915 approved loans and $367.3 million gross for FY2017 to FY2026, a standing of 104 of 928. Of those loans 829 are 7(a) and 86 are 504. Median loan in Lansing: $150,000. Lansing reads 0.72x against the national figure. Within Lansing, half of loans are $50,000 to $416,500. Franchises account for 9.4% of loans. The area is home to a state capital and a large university, but this page rests only on lending records, which say nothing about those institutions' economic weight.
The Huntington National Bank holds 385 of the area's 7(a) loans, $64.5 million, while the next names, Capitol National Bank with 31 loans and $21.0 million and CASE CU with 30 loans and $7.4 million, are far smaller. On 504, Michigan Certified Development Corporation is the sole name listed, with 76 loans and $49.8 million. Lansing lender figures are SBA's records. Lansing names hold or held those loans. Lansing counts show volume only, and Lansing counts judge no lender or requirement.
Full-service restaurant tops Lansing's named classes with 50 loans; limited-service restaurant has 32, fitness center 20, hotel and motel 18 and coffee shop and snack bar 15, while 681 loans fall outside the named classes. Ingham County holds 585 loans, Eaton County 188 and Clinton County 142. Annual count slid from 105 loans and $33.7 million in FY2017 to 54 loans and $29.5 million in FY2026, the low of the span, though FY2025 reached a peak of 112 loans and $52.2 million.
Lansing cancellations after approval reached at least 10.7%. Lansing approvals span FY2017 to FY2024. Lansing reaches 12.6% when undisbursed loans count. In Lansing, 403 funded loans show charge-offs. Lansing floors them at 4.5% or more. Lansing has 2.7% within five years. Every Lansing rate here is a floor, as open Lansing loans may move it. Lansing follows county placement. Lansing matches each project's county by name. Lansing then applies the July 2023 delineation. Lansing leaves out loans with unplaceable counties, and Lansing counts all approvals, named or not. A study for a Lansing-area project should test demand where the site sits, build cost honest to a modest ticket, a conservative-year debt service run, and value drawn from nearby sales. Restaurants, the lead class, need sales per seat and occupancy checks; coffee shops need ticket size and rent against a small footprint. Daniel Smith, MAI, signs every Lansing study. Loan Analytics prepares each Lansing study.
| Loans approved, FY2017 to FY2026 | 915 |
|---|---|
| Gross dollars approved | $367.3 million |
| Median loan | $150,000 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $416,500 |
| SBA 7(a) loans | 829 |
| SBA 504 loans | 86 |
| Franchise share of loans | 9.4% |
| Rank among metro and micro areas by loans | 104 of 928 |
| Median loan against the national median | 0.72x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 10.7% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 12.6% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 4.5% |
| Charged off within five years of approval | 2.7% |
| Loans in that cohort | 403 |
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 Lansing-East Lansing, MI Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 105 | $33.7 million |
| FY2018 | 111 | $28.8 million |
| FY2019 | 95 | $33.1 million |
| FY2020 | 60 | $19.7 million |
| FY2021 | 85 | $57.3 million |
| FY2022 | 88 | $38.5 million |
| FY2023 | 96 | $37.8 million |
| FY2024 | 109 | $36.6 million |
| FY2025 | 112 | $52.2 million |
| FY2026 | 54 | $29.5 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 681 |
| Full-service restaurant | 50 |
| Limited-service restaurant | 32 |
| Fitness center | 20 |
| Hotel and motel | 18 |
| Coffee shop and snack bar | 15 |
| Assisted living (without nursing care) | 14 |
| Automotive mechanical repair (car and truck) | 14 |
| Child care center | 11 |
| Car wash | 9 |
| Dental office | 8 |
| Medical office (physicians) | 8 |
| Self storage | 7 |
| Liquor 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 | 76 | $49.8 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 385 | $64.5 million |
| Capitol National Bank | 31 | $21.0 million |
| CASE CU | 30 | $7.4 million |
| The Dart Bank | 28 | $18.9 million |
| Fifth Third Bank | 26 | $6.4 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 |
|---|---|
| Ingham County, MI | 585 |
| Eaton County, MI | 188 |
| Clinton County, MI | 142 |
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-29620.
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 Lansing-East Lansing, 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