Worked Example: SBA 504 Hotel Feasibility Study in Washington
A worked example of the feasibility study a lender would read for a hotel project in Washington, financed with an SBA 504 loan.
What SBA's own loan files show about lending in the Kennewick-Richland, WA Metro Area, every asset class together, and what a feasibility study for a project there has to test.
587 SBA approvals landed here for Kennewick-Richland projects over FY2017 to FY2026, for $292.1 million gross. The metro area sits at 154 of 928, Kennewick-Richland, among all metro and micro areas, counting Kennewick-Richland. The median ticket in Kennewick-Richland is $150,000, whereas the middle half cover $50,000 to $519,500. The national comparison is plain: at 0.72x of the national median. Nationally, Kennewick-Richland loans run larger than they do here.
The program split in Kennewick-Richland is 531 under 7(a) and 56 under 504, so 7(a) leads here. In Kennewick-Richland, the franchise share of Kennewick-Richland loans is 12.3%. In 7(a), the biggest holder is Banner Bank: 105 loans, $23.1 million in all, followed by HAPO Community CU with 76 loans and $7.7 million. Third on the list is Columbia Bank (OR), 56 loans, and U.S. Bank, National Association at 45. Under 504, Northwest Business Development Association is the lead holder with 35 loans and $28.8 million, just ahead of Evergreen Business Capital at 16. Lender Kennewick-Richland figures here are SBA records, nothing more. The line for Banner Bank appears as the holder SBA reports; it is no judgment of policy at HAPO Community CU or elsewhere.
Most of the Kennewick-Richland total sits outside the tracked asset classes: 400 loans that carry codes outside the Kennewick-Richland table. The Kennewick-Richland class rows therefore describe a minority of Kennewick-Richland lending. The Kennewick-Richland class table opens with full-service restaurant, 33 loans, then gas station and truck stop with 18, and limited-service restaurant at 14. Further down sit beverage manufacturing (breweries, wineries, distilleries), 13 loans and dental office at 13. By county, Benton County, WA accounts for 435 loans and then Franklin County, WA at 152.
Of FY2017 to FY2024 approvals in Kennewick-Richland, no fewer than 12.0% were cancelled before the loan closed out; the 12.0% floor has no ceiling beside it, since Loan Analytics keeps that value back and offers no estimate of it. For the 236 loans disbursed in FY2017 to FY2021, Kennewick-Richland charge-offs to date are no smaller than 3.8%. The five-year rate is withheld since the cohort is below 30 Kennewick-Richland loans, which is why no figure appears. Older loans can still default, so these rates are floors and can merely rise. Annual approvals peaked in FY2025 at 80 loans and $37.1 million. Before FY2026 the weakest year was FY2020 (42 loans, $27.0 million). Membership in the Kennewick-Richland, WA metro area follows the project county: Benton County, WA, Franklin County, WA and the rest, the July 2023 delineation determines which counties belong, yet Kennewick-Richland counties that defy matching stay out of all totals.
A study for a Kennewick-Richland project has to be prepared for one site and one county, because the metro Kennewick-Richland area total blends different markets. In the Kennewick-Richland table the largest class is full-service restaurant, so the study should test Kennewick-Richland dining rooms and their weeknight trade, liquor licence timing and cost and the lunch and dinner balance. Projects in gas station and truck stop here depend on pump count against queues and on fuel gallons and inside sales. A Kennewick-Richland operator's coverage has to survive a weak year; the valuation must depend on nearby sales, not distant averages. Since Kennewick-Richland loans skew small, a larger request should explain why this project warrants it.
| Loans approved, FY2017 to FY2026 | 587 |
|---|---|
| Gross dollars approved | $292.1 million |
| Median loan | $150,000 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $519,500 |
| SBA 7(a) loans | 531 |
| SBA 504 loans | 56 |
| Franchise share of loans | 12.3% |
| Rank among metro and micro areas by loans | 154 of 928 |
| Median loan against the national median | 0.72x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 12.0% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | withheld |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 3.8% |
| Charged off within five years of approval | withheld |
| Loans in that cohort | 236 |
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 Kennewick-Richland, WA Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 62 | $33.9 million |
| FY2018 | 58 | $35.8 million |
| FY2019 | 54 | $24.2 million |
| FY2020 | 42 | $27.0 million |
| FY2021 | 59 | $37.7 million |
| FY2022 | 56 | $25.3 million |
| FY2023 | 59 | $20.1 million |
| FY2024 | 60 | $19.4 million |
| FY2025 | 80 | $37.1 million |
| FY2026 | 57 | $31.6 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 400 |
| Full-service restaurant | 33 |
| Gas station and truck stop | 18 |
| Limited-service restaurant | 14 |
| Beverage manufacturing (breweries, wineries, distilleries) | 13 |
| Dental office | 13 |
| Automotive mechanical repair (car and truck) | 13 |
| Coffee shop and snack bar | 13 |
| Fitness center | 11 |
| Hotel and motel | 10 |
| Medical office (physicians) | 10 |
| Assisted living (without nursing care) | 7 |
| Rehabilitation and therapy clinic | 6 |
| Grocery store | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Northwest Business Development Association | 35 | $28.8 million |
| Evergreen Business Capital | 16 | $19.7 million |
| Lender | Loans | Dollars |
|---|---|---|
| Banner Bank | 105 | $23.1 million |
| HAPO Community CU | 76 | $7.7 million |
| Columbia Bank (OR) | 56 | $21.1 million |
| U.S. Bank, National Association | 45 | $8.8 million |
| KeyBank National Association | 24 | $9.7 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 |
|---|---|
| Benton County, WA | 435 |
| Franklin County, WA | 152 |
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-28420.
A worked example of the feasibility study a lender would read for a hotel project in Washington, financed with an SBA 504 loan.
Loan Analytics prepares the feasibility study a lender reads before it commits: for a commercial project in the Kennewick-Richland, WA 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