Worked Example: SBA 7(a) Gas Station Feasibility Study in Tennessee
A worked example of the feasibility study a lender would read for a gas station project in Tennessee, financed with an SBA 7(a) loan.
What SBA's own loan files show about lending in the Nashville-Davidson--Murfreesboro--Franklin, TN Metro Area, every asset class together, and what a feasibility study for a project there has to test.
2,844 SBA loans within Nashville-Davidson--Murfreesboro--Franklin, TN over FY2017 to FY2026 add up to $1.72 billion gross. Beyond that, Nashville-Davidson--Murfreesboro--Franklin sits at 44 of 928 among the full set of CBSAs counted by loans. In turn, $250,000 sets the midpoint; the central half spans $75,000 to $645,750. Also, the median in Nashville-Davidson--Murfreesboro--Franklin stands at 1.20x in proportion to the country's median, which puts ticket size over what the country sees. Beyond that, Nashville-Davidson--Murfreesboro--Franklin is limited to the counties in its area, unlike a state page, which gives a mix of unrelated markets: 2,844 loans in total.
2,771 loans in 7(a) stand against 73 loans under 504. For context, 20.8% of the approvals belong to franchisees in Nashville-Davidson--Murfreesboro--Franklin. In addition, within 7(a) cases, the biggest names by loans stand as U.S. Bank, National Association with 428 loans for $74.8 million, The Huntington National Bank with 249 loans totalling $95.9 million, followed by Pinnacle Bank (TN) with 181 loans for $180.4 million. In addition, within 504 approvals, the busiest CDCs on loan count stand as Brightbridge, Inc. with 40 loans and $66.9 million then South Central Tennessee Business Development Corporation holding 16 loans and $25.1 million. Beyond that, lender names follow SBA files on 2,844 loans; they show loans held and nothing further, not what lenders apply around Nashville-Davidson--Murfreesboro--Franklin.
Limited-service restaurant with 129, 125 in full-service restaurant, fitness center with 109, plus dental office at 54 rank first by class by approvals. In practice, 2,059 loans fall apart from the named classes, so its $1.72 billion total covers more than the class list. Worth noting: 5 approvals in data center across Nashville-Davidson--Murfreesboro--Franklin make too small a base to read as a trend. Looking at counties, Davidson County (1,168), Williamson County (583); and Rutherford County (355) take the largest shares. For context, taking each approval year, FY2017 starts at 184 loans and $112.9 million; FY2025 is the high point at 464 loans and $254.7 million, then FY2026 completes the file at 387 loans and $244.2 million.
11.7% among FY2017 to FY2024 loans in Nashville-Davidson--Murfreesboro--Franklin were cancelled before they funded, and that is a floor; 13.4% is the ceiling with undisbursed loans included. Separately, 6.5% among FY2017 to FY2021 disbursed loans in Nashville-Davidson--Murfreesboro--Franklin were charged off, a floor; 3.8% were charged off within five years of being approved, in a cohort of 893 loans. Also, treat each share in this section as a lower bound, because approvals made lately have had scant opportunity to cancel or go bad; the file has 2,844 loans in all. For context, each area in this file follows the statistical area holding any loan's home county, from the July 2023 definitions as issued; counties were matched on name, while any loan whose site county falls in no CBSA is excluded from every area. Separately, counting every class and none, each approval in either program in Nashville-Davidson--Murfreesboro--Franklin is added toward its $1.72 billion total.
Throughout Nashville-Davidson--Murfreesboro--Franklin, a study covering a project begins with the actual proposal, never the 2,844-loan file. In turn, market demand in Nashville-Davidson--Murfreesboro--Franklin leads the work: can Nashville-Davidson--Murfreesboro--Franklin's trade area carry the turnover planned, measured against nearby supply in and near Davidson County? The area median comes to 1.20x of the nation's median, so test the real scope against offers from local contractors. Debt service coverage links demand to cost for Nashville-Davidson--Murfreesboro--Franklin: projected operating income tested against loan payments, with a case of falling revenue. Then the appraisal closes the loop in Nashville-Davidson--Murfreesboro--Franklin: the as-built value has to bear the sum asked for. Worth noting: a sponsor carrying a third-party report of Nashville-Davidson--Murfreesboro--Franklin, ahead of calling on any lender, addresses the floors before they are raised; approval rests with the lender and the SBA guarantee office for Nashville-Davidson--Murfreesboro--Franklin, never the study.
| Loans approved, FY2017 to FY2026 | 2,844 |
|---|---|
| Gross dollars approved | $1.72 billion |
| Median loan | $250,000 |
| Middle half of loans, from | $75,000 |
| Middle half of loans, to | $645,750 |
| SBA 7(a) loans | 2,771 |
| SBA 504 loans | 73 |
| Franchise share of loans | 20.8% |
| Rank among metro and micro areas by loans | 44 of 928 |
| Median loan against the national median | 1.20x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 11.7% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 13.4% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 6.5% |
| Charged off within five years of approval | 3.8% |
| Loans in that cohort | 893 |
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 Nashville-Davidson--Murfreesboro--Franklin, TN Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 184 | $112.9 million |
| FY2018 | 213 | $120.4 million |
| FY2019 | 196 | $124.2 million |
| FY2020 | 187 | $133.0 million |
| FY2021 | 234 | $191.1 million |
| FY2022 | 239 | $130.9 million |
| FY2023 | 332 | $181.1 million |
| FY2024 | 408 | $226.7 million |
| FY2025 | 464 | $254.7 million |
| FY2026 | 387 | $244.2 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 2,059 |
| Limited-service restaurant | 129 |
| Full-service restaurant | 125 |
| Fitness center | 109 |
| Dental office | 54 |
| Coffee shop and snack bar | 51 |
| Child care center | 44 |
| Beauty salon | 44 |
| Automotive mechanical repair (car and truck) | 42 |
| Car wash | 25 |
| Medical office (physicians) | 25 |
| Hotel and motel | 24 |
| Veterinary clinic | 15 |
| Grocery store | 15 |
| Gas station and truck stop | 12 |
| Caterers (includes banquet halls with catering staff) | 10 |
| Liquor store | 10 |
| Rehabilitation and therapy clinic | 7 |
| Self storage | 6 |
| Assisted living (without nursing care) | 6 |
| Beverage manufacturing (breweries, wineries, distilleries) | 6 |
| Nonresidential lessor (flex, office and retail investor buildings) | 6 |
| Data center | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Brightbridge, Inc. | 40 | $66.9 million |
| South Central Tennessee Business Development Corporation | 16 | $25.1 million |
| Mid-Cumberland Area Development Corporation | 11 | $12.5 million |
| Lender | Loans | Dollars |
|---|---|---|
| U.S. Bank, National Association | 428 | $74.8 million |
| The Huntington National Bank | 249 | $95.9 million |
| Pinnacle Bank (TN) | 181 | $180.4 million |
| Newtek Bank, National Association | 147 | $51.0 million |
| Northeast Bank (ME) | 119 | $15.0 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 |
|---|---|
| Davidson County, TN | 1,168 |
| Williamson County, TN | 583 |
| Rutherford County, TN | 355 |
| Sumner County, TN | 230 |
| Wilson County, TN | 168 |
| Maury County, TN | 152 |
| Robertson County, TN | 72 |
| Dickson County, TN | 46 |
| Cheatham County, TN | 42 |
| Hickman County, TN | 9 |
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-34980.
A worked example of the feasibility study a lender would read for a gas station project in Tennessee, financed with an SBA 7(a) loan.
Loan Analytics prepares the feasibility study a lender reads before it commits: for a commercial project in the Nashville-Davidson--Murfreesboro--Franklin, TN 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