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 Yakima, WA Metro Area, every asset class together, and what a feasibility study for a project there has to test.
454 loans within Yakima, WA over FY2017 through FY2026 carry $266.8 million gross. Also, Yakima stands at 180 of 928 against the complete list of CBSAs on approvals. Worth noting: $200,000 gives the midpoint; the bulk of loans spans $50,000 to $753,375. The typical loan here is 0.96x compared with the country's median, leaving the typical loan beneath the national middle. Separately, Yakima keeps to its own counties, not a mix of unrelated markets: 454 approvals overall.
420 loans under 7(a) compare with 34 loans in 504. Worth noting: 11.7% of all approvals go to franchisees in this area. Across 7(a), the top institutions by number appear as Banner Bank with 89 loans for $15.6 million, U.S. Bank, National Association booking 49 loans totalling $13.3 million; and Columbia Bank (OR) at 45 loans for $6.0 million. Under 504 approvals, the busiest program intermediaries by number appear as Evergreen Business Capital holding 17 loans and $13.1 million followed by Northwest Business Development Association holding 11 loans totalling $9.0 million. In turn, these names come from SBA's own records for 454 loans; they record past loans alone, not the standards that lenders require across Yakima.
52 for gas station and truck stop, full-service restaurant at 22, 15 in hotel and motel, plus 10 in grocery store rank first by class in the file. 280 approvals fall outside the named classes, so the 454-loan file reaches beyond any class table. Then, 5 approvals in medical office across Yakima are too few to show any claim. In practice, Yakima County holds every one of 454 loans, so the area and the county match. For context, taking each approval year, FY2017 begins at 42 loans and $20.0 million; FY2025 is the busiest year at 59 loans and $29.5 million, then FY2026, the latest year, ends the series at 48 loans and $31.5 million.
11.5% among FY2017 to FY2024 approvals in Yakima have been cancelled before disbursement, a floor. Here, the ceiling count on this page is not released, so the floor alone is shown. Here, no loss floor is posted for Yakima, WA; too few disbursed loans sit in that cohort, so a blank here is not a zero. Take every rate above like a lower bound, as loans written in the latest years have had little runway to cancel or go bad, across 454 loans. In turn, membership here means the metro or micro area holding the loan's project county, under the July 2023 delineation; the counties were matched on name, while a loan whose home county does not map is dropped from every area total by design. Separately, inside and outside the classes, each approval in either program in Yakima is tallied towards its $266.8 million total.
In Yakima, a proper study of a property should start at the subject property, not the average of the 454-loan file. Here, demand in Yakima opens the work: will Yakima's trade area sustain the income modelled, measured against nearby supply around Yakima County? Next, the local median is 0.96x measured against the national median, so most loans here are small; a project that outsizes them must show why its size is sound. Debt service coverage links revenue to cost for Yakima: forecast income compared with the payments due, with a weak-sales case. Next, the appraisal settles the question for Yakima: market value on completion must carry the borrowing sought. Here, an applicant holding an arm's-length report of Yakima, ahead of approaching any lender, has met the outcome floors before they are raised; the decision belongs to the bank and SBA in Yakima, never the study.
| Loans approved, FY2017 to FY2026 | 454 |
|---|---|
| Gross dollars approved | $266.8 million |
| Median loan | $200,000 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $753,375 |
| SBA 7(a) loans | 420 |
| SBA 504 loans | 34 |
| Franchise share of loans | 11.7% |
| Rank among metro and micro areas by loans | 180 of 928 |
| Median loan against the national median | 0.96x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 11.5% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | withheld |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | withheld |
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 Yakima, WA Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 42 | $20.0 million |
| FY2018 | 51 | $34.6 million |
| FY2019 | 38 | $16.5 million |
| FY2020 | 23 | $11.9 million |
| FY2021 | 57 | $42.5 million |
| FY2022 | 42 | $30.8 million |
| FY2023 | 44 | $12.0 million |
| FY2024 | 50 | $37.4 million |
| FY2025 | 59 | $29.5 million |
| FY2026 | 48 | $31.5 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 280 |
| Gas station and truck stop | 52 |
| Full-service restaurant | 22 |
| Hotel and motel | 15 |
| Grocery store | 10 |
| Dental office | 9 |
| Limited-service restaurant | 9 |
| Automotive mechanical repair (car and truck) | 8 |
| Child care center | 8 |
| Coffee shop and snack bar | 7 |
| Car wash | 6 |
| Fitness center | 6 |
| Medical office (physicians) | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Evergreen Business Capital | 17 | $13.1 million |
| Northwest Business Development Association | 11 | $9.0 million |
| Ameritrust CDC | 6 | $3.9 million |
| Lender | Loans | Dollars |
|---|---|---|
| Banner Bank | 89 | $15.6 million |
| U.S. Bank, National Association | 49 | $13.3 million |
| Columbia Bank (OR) | 45 | $6.0 million |
| KeyBank National Association | 25 | $7.7 million |
| Readycap Lending, LLC | 18 | $17.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 |
|---|---|
| Yakima County, WA | 454 |
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-49420.
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 Yakima, 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