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 Kansas City, MO-KS Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Kansas City, MO-KS spans two states, and the SBA record reflects it: 4,186 loans totalling $2.30 billion across FY2017 to FY2026, a rank of 35 of 928. The median loan is $265,350, a ratio of 1.28x to the country, while loans in the middle of the range start at $100,000 and top out at $639,850. Franchise brands account for 16.5% of loans. Approvals divide into 3,818 under 7(a) and 368 under 504.
A further 2,970 loans belong to no tracked class. The first named class is full-service restaurant, 156 loans, limited-service restaurant has 139, fitness center 122 and child care center 97. Veterinary clinic reaches 33 and data center 16, with multifamily at 6. By county, Johnson County, KS leads with 1,632 loans, narrowly ahead of Jackson County, MO at 1,310, then Clay County, MO at 417, Wyandotte County, KS at 221 and Platte County, MO at 176.
The holder listed against each loan is whoever SBA shows today; that locates a loan without describing a lender's conduct. In first place on 7(a) stands U.S. Bank, National Association, with 401 loans and $72.2 million, UMB Bank, National Association 199 and $79.0 million, First National Bank of Omaha 157, Small Business Bank 146 and Commerce Bank 142. For 504, Heartland Business Capital, Inc. holds 157 loans and $113.7 million and Rural Missouri, Inc. 116 loans and $115.2 million, with Wakarusa Valley Development, Inc. at 32.
SBA records show 10.9% or more of approvals from FY2017 to FY2024 cancelled, and 11.7% once undisbursed loans are included. Across 1,757 funded loans from FY2017 to FY2021 approvals, 4.5% are charged off to date and 2.3% were within five years of approval, and both remain floors. Loan counts ranged from 352 in FY2018 to 515 in FY2025, when dollars reached $279.1 million.
A Kansas City study should place the project on the correct side of the state line, since lenders and programs differ, and test demand in the immediate county. It must show cost, debt service coverage at the floors above and appraisal support. Counties are matched under the July 2023 delineation; a loan that cannot be placed is dropped. Nothing in this reading predicts approval, and it is written for borrowers and lenders both.
| Loans approved, FY2017 to FY2026 | 4,186 |
|---|---|
| Gross dollars approved | $2.30 billion |
| Median loan | $265,350 |
| Middle half of loans, from | $100,000 |
| Middle half of loans, to | $639,850 |
| SBA 7(a) loans | 3,818 |
| SBA 504 loans | 368 |
| Franchise share of loans | 16.5% |
| Rank among metro and micro areas by loans | 35 of 928 |
| Median loan against the national median | 1.28x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 10.9% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 11.7% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 4.5% |
| Charged off within five years of approval | 2.3% |
| Loans in that cohort | 1,757 |
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 Kansas City, MO-KS Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 422 | $181.0 million |
| FY2018 | 352 | $220.8 million |
| FY2019 | 376 | $178.5 million |
| FY2020 | 375 | $181.4 million |
| FY2021 | 464 | $307.5 million |
| FY2022 | 419 | $187.6 million |
| FY2023 | 401 | $235.7 million |
| FY2024 | 486 | $265.7 million |
| FY2025 | 515 | $279.1 million |
| FY2026 | 376 | $264.1 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 2,970 |
| Full-service restaurant | 156 |
| Limited-service restaurant | 139 |
| Fitness center | 122 |
| Child care center | 97 |
| Automotive mechanical repair (car and truck) | 87 |
| Coffee shop and snack bar | 75 |
| Dental office | 69 |
| Liquor store | 65 |
| Beauty salon | 58 |
| Hotel and motel | 55 |
| Medical office (physicians) | 42 |
| Veterinary clinic | 33 |
| Beverage manufacturing (breweries, wineries, distilleries) | 27 |
| Gas station and truck stop | 26 |
| Rehabilitation and therapy clinic | 25 |
| Car wash | 20 |
| Nonresidential lessor (flex, office and retail investor buildings) | 17 |
| Data center | 16 |
| Self storage | 14 |
| Caterers (includes banquet halls with catering staff) | 14 |
| Assisted living (without nursing care) | 10 |
| Grocery store | 9 |
| Skilled nursing | 8 |
| Multifamily (lessors of residential buildings) | 6 |
| Life science lab (research and development) | 5 |
| School (elementary and secondary, including charter) | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Heartland Business Capital, Inc. | 157 | $113.7 million |
| Rural Missouri, Inc. | 116 | $115.2 million |
| Wakarusa Valley Development, Inc. | 32 | $25.1 million |
| Frontier Financial Partners, Inc. | 30 | $29.1 million |
| Clay/Platte Development Corporation | 20 | $12.3 million |
| Lender | Loans | Dollars |
|---|---|---|
| U.S. Bank, National Association | 401 | $72.2 million |
| UMB Bank, National Association | 199 | $79.0 million |
| First National Bank of Omaha | 157 | $62.4 million |
| Small Business Bank | 146 | $36.2 million |
| Commerce Bank | 142 | $37.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 |
|---|---|
| Johnson County, KS | 1,632 |
| Jackson County, MO | 1,310 |
| Clay County, MO | 417 |
| Wyandotte County, KS | 221 |
| Platte County, MO | 176 |
| Cass County, MO | 149 |
| Leavenworth County, KS | 102 |
| Miami County, KS | 49 |
| Lafayette County, MO | 48 |
| Bates County, MO | 21 |
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-28140.
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 Kansas City, MO-KS 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