Worked Example: SBA 504 Change of Ownership Hotel Feasibility Study in Virginia
A worked example of the feasibility study a lender would read for a hotel project in Virginia, financed with an SBA 504 loan.
What SBA's own loan files show about lending in the Kingsport-Bristol, TN-VA Metro Area, every asset class together, and what a feasibility study for a project there has to test.
226 approvals within Kingsport-Bristol, TN-VA from FY2017 through FY2026 come to $137.9 million in gross dollars. Kingsport-Bristol sits at 292 of 928 among all core-based areas counted by loans. Beyond that, $250,000 is the middle loan; the inner half falls between $100,000 and $623,000. In practice, the median in Kingsport-Bristol stands at 1.20x compared with the median nationwide, which puts ticket size above the figure for the nation. In practice, Kingsport-Bristol keeps to the counties in its area, not the mix a statewide page shows: 226 approvals in total.
217 SBA 7(a) loans stand against 9 loans in 504. 14.6% of all approvals belong to franchised units here. Here, under 7(a) lending, the leading names by count appear as The First Bank and Trust Company with 82 loans and $26.5 million, First Community Bank (VA) booking 17 loans worth $6.0 million, then U.S. Bank, National Association holding 10 loans totalling $1.4 million. Next, no development company in Kingsport-Bristol reaches the listing threshold. Here, lender names are taken from SBA data for 226 loans; they show loans approved alone, never the standards that lenders apply in Kingsport-Bristol.
14 in hotel and motel, 10 for full-service restaurant, 7 for coffee shop and snack bar, followed by automotive mechanical repair at 6 come first among the classes. Beyond that, 152 loans lie beyond every named class, so the Kingsport-Bristol total covers more than any class table. Also, 5 approvals in fitness center inside Kingsport-Bristol are too few for a trend. In practice, looking at counties, Sullivan County (92), Washington County (79), then Bristol city (29) head the county list. TN and VA are both in Kingsport-Bristol, TN-VA, so lenders may differ across the line. In addition, across the years, FY2017 starts at 15 loans and $8.2 million; FY2022 is the high point at 33 loans and $13.6 million, while FY2026, a part year, finishes the file at 15 loans and $9.3 million.
16.2% of FY2017 to FY2024 approvals in Kingsport-Bristol have been cancelled before funding, a floor. The upper figure for Kingsport-Bristol stays withheld, leaving the floor alone. Then, 0.00% of FY2017 through FY2021 disbursed loans in Kingsport-Bristol were charged off, which is a floor; 0.00% went to charge-off within five years post-approval, out of 82 loans. Next, take every rate printed here like a lower bound, because loans approved recently received limited opportunity to cancel or go bad, across 226 loans. A Kingsport-Bristol entry in this file follows the CBSA holding a loan's home county, on July 2023 boundaries as adopted; every county get matched by name, while a record whose home county cannot be placed drops out of all areas as a rule. Inside and outside the classes, each 7(a) and 504 approval across Kingsport-Bristol is added into its $137.9 million total.
In Kingsport-Bristol, an independent study of a property should open with the specific operator, and not the 226-loan file. Customer demand in Kingsport-Bristol is tested first: will Kingsport-Bristol's household base sustain the revenue assumed, against competitors in areas such as Sullivan County? In turn, the local median is 1.20x against the median nationwide, so costs here may run higher; price the real scope against offers from area builders. Then, the coverage test joins sales to outlay in Kingsport-Bristol: expected net income measured on the debt payments, with a case of falling revenue. Also, the valuation completes the test for Kingsport-Bristol: value as built has to cover the amount put forward. Separately, a borrower holding an independent written study for Kingsport-Bristol, ahead of meeting a lender, has answered those floors early; approval stays with the lender and the agency in Kingsport-Bristol, not the author of a study.
| Loans approved, FY2017 to FY2026 | 226 |
|---|---|
| Gross dollars approved | $137.9 million |
| Median loan | $250,000 |
| Middle half of loans, from | $100,000 |
| Middle half of loans, to | $623,000 |
| SBA 7(a) loans | 217 |
| SBA 504 loans | 9 |
| Franchise share of loans | 14.6% |
| Rank among metro and micro areas by loans | 292 of 928 |
| Median loan against the national median | 1.20x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 16.2% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | withheld |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 0.00% |
| Charged off within five years of approval | 0.00% |
| Loans in that cohort | 82 |
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 Kingsport-Bristol, TN-VA Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 15 | $8.2 million |
| FY2018 | 17 | $9.5 million |
| FY2019 | 17 | $13.0 million |
| FY2020 | 29 | $10.1 million |
| FY2021 | 21 | $22.3 million |
| FY2022 | 33 | $13.6 million |
| FY2023 | 33 | $24.8 million |
| FY2024 | 14 | $9.0 million |
| FY2025 | 32 | $18.0 million |
| FY2026 | 15 | $9.3 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 152 |
| Hotel and motel | 14 |
| Full-service restaurant | 10 |
| Coffee shop and snack bar | 7 |
| Automotive mechanical repair (car and truck) | 6 |
| Gas station and truck stop | 5 |
| Fitness center | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| The First Bank and Trust Company | 82 | $26.5 million |
| First Community Bank (VA) | 17 | $6.0 million |
| U.S. Bank, National Association | 10 | $1.4 million |
| Live Oak Banking Company | 8 | $10.3 million |
| The Huntington National Bank | 6 | $2.9 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 |
|---|---|
| Sullivan County, TN | 92 |
| Washington County, VA | 79 |
| Bristol city, VA | 29 |
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-28700.
A worked example of the feasibility study a lender would read for a hotel project in Virginia, financed with an SBA 504 loan.
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 Kingsport-Bristol, TN-VA 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