Worked Example: Conventional Bank Gas Station Feasibility Study in Missouri
A worked example of the feasibility study a lender would read for a gas station project in Missouri, financed with a conventional bank loan.
What SBA's own loan files show about lending in the Columbia, MO Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Across Columbia, the SBA loan files carry 503 approvals over FY2017 to FY2026, totalling $173.8 million in gross dollars. Columbia stands across all metro and micro areas, on volume, in position 165 of 928. The core of Columbia lending falls between $51,150 and $373,650, and a median near $150,000; and the median sits at 0.72x the national median. By program, Columbia shows 453 loans under 7(a) and 50 under 504. Franchise brands account for 13.5% of the loans.
For the record, across the classes we show for Columbia, limited-service restaurant comes first with 36 loans, trailed by full-service restaurant, 34 loans and fitness center (18). Another 327 loans in Columbia sit outside every class. By county, Boone County, MO holds 467 loans, then Cooper County, MO (25) and Howard County, MO (11).
Banks and development companies named for Columbia come from SBA's own Columbia records of the 503 guaranteed loans in Columbia, under their current or past holder; those files log each file and imply no view of lender appetite. Further, in the 7(a) program near Boone County, MO, SBA's records name The Central Trust Bank at 128 loans and $21.6 million, followed by The Bank of Missouri ($25.5 million across 101 loans). On 504 in Columbia, the records show Enterprise Development Corporation, with 33 loans for $19.3 million and Rural Missouri, Inc. at 17 loans and $12.3 million. An applicant in Columbia may ask The Central Trust Bank or another Columbia holder near Boone County, MO for its document checklist, then fit the Columbia study to satisfy those requests.
Among Columbia approvals from FY2017 to FY2024, at least 9.8% ended in cancellation after approval in Columbia, a floor; the true Columbia rate can only be higher. Notably, of disbursed Columbia loans approved in FY2017 to FY2021, 7.1% stand charged off by now, likewise a floor; 4.5% went to charge-off within five years, among a group of 224 loans. Across the years, Columbia hit its high in FY2021 at 62 loans and $23.5 million, and was weakest in FY2026 at 29 loans and $14.0 million.
Around Boone County, MO, demand comes first: who shops in Boone County, MO, who travels in Cooper County, MO, set against Columbia as a whole, and how much room 36 limited-service restaurant loans leave. Cost next: $150,000 is the Columbia median and $51,150 to $373,650 the middle band, so a Boone County, MO site must justify its budget against this $150,000 benchmark. Then coverage: Columbia coverage survives a sluggish year against the 9.8% rate of cancellation and 7.1% rate of charge-off. The Boone County, MO appraisal must support the value financed. Columbia is cut from the July 2023 boundaries; a file whose county finds no place is excluded from all other areas, Columbia among them, but the totals retain loans apart from the named classes.
| Loans approved, FY2017 to FY2026 | 503 |
|---|---|
| Gross dollars approved | $173.8 million |
| Median loan | $150,000 |
| Middle half of loans, from | $51,150 |
| Middle half of loans, to | $373,650 |
| SBA 7(a) loans | 453 |
| SBA 504 loans | 50 |
| Franchise share of loans | 13.5% |
| Rank among metro and micro areas by loans | 165 of 928 |
| Median loan against the national median | 0.72x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 9.8% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | withheld |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 7.1% |
| Charged off within five years of approval | 4.5% |
| Loans in that cohort | 224 |
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 Columbia, MO Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 61 | $22.5 million |
| FY2018 | 40 | $22.1 million |
| FY2019 | 45 | $10.3 million |
| FY2020 | 46 | $10.6 million |
| FY2021 | 62 | $23.5 million |
| FY2022 | 59 | $18.2 million |
| FY2023 | 59 | $15.5 million |
| FY2024 | 47 | $14.5 million |
| FY2025 | 55 | $22.7 million |
| FY2026 | 29 | $14.0 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 327 |
| Limited-service restaurant | 36 |
| Full-service restaurant | 34 |
| Fitness center | 18 |
| Child care center | 14 |
| Hotel and motel | 11 |
| Beauty salon | 11 |
| Coffee shop and snack bar | 7 |
| Liquor store | 6 |
| Dental office | 5 |
| Veterinary clinic | 5 |
| Automotive mechanical repair (car and truck) | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Enterprise Development Corporation | 33 | $19.3 million |
| Rural Missouri, Inc. | 17 | $12.3 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Central Trust Bank | 128 | $21.6 million |
| The Bank of Missouri | 101 | $25.5 million |
| The Callaway Bank | 48 | $8.8 million |
| Hawthorn Bank | 43 | $8.5 million |
| Commerce Bank | 22 | $3.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 |
|---|---|
| Boone County, MO | 467 |
| Cooper County, MO | 25 |
| Howard County, MO | 11 |
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-17860.
A worked example of the feasibility study a lender would read for a gas station project in Missouri, financed with a conventional bank loan.
Loan Analytics prepares the feasibility study a lender reads before it commits: for a commercial project in the Columbia, MO 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