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 Aberdeen, WA Micro Area, every asset class together, and what a feasibility study for a project there has to test.
SBA files rank Aberdeen 415 of 928 metro and micro areas by loans: 127 approvals in FY2017 to FY2026, worth $138.3 million gross. The median loan is $536,000, which is 2.58x the national median, so Aberdeen is a larger-ticket market than the national figure suggests. The middle half of Aberdeen loans runs from $190,000 to $1.5 million, a wide band, and any Aberdeen borrower should weigh a request against the $536,000 median rather than against a smaller local norm.
The split between SBA 7(a) and SBA 504 is not shown for Aberdeen, so this page gives no program counts. As SBA flags them, 18.1% of Aberdeen loans are franchise loans. Asset by asset, hotel and motel loans number 26, gas station and truck stop loans 19 and grocery store loans 9, followed by full-service restaurants at 8 and limited-service restaurants at 7. A further 47 loans sit in no named class, so the class lines never sum to 127. All of the loans trace to Grays Harbor County, WA, with 127 approvals, so Aberdeen is a one-county market.
Each lender named below holds the loans listed today according to SBA, which says nothing about who first approved them. The SBA 7(a) table opens with Open Bank, which holds 13 loans worth $30.4 million. Banner Bank holds 12 loans worth $4.2 million, U.S. Bank, National Association holds 9 loans worth $1.3 million, KeyBank National Association holds 8 loans worth $5.2 million, and Commonwealth Business Bank holds 7 loans worth $7.5 million. No SBA 504 lender names are listed for Aberdeen. A borrower may still approach any lender, and the table is a record of holdings only.
Of Aberdeen approvals from FY2017 to FY2024, at least 7.4% were cancelled after approval. The higher figure that counts undisbursed loans as cancelled is not printed here, and nothing has been guessed in its place. No charge-off rate is printed for loans paid out in FY2017 to FY2021, because the group is under 30 loans, and printing no rate at that size is Loan Analytics' own presentation rule, not SBA's. The gap is not zero and not estimated. The busiest year was FY2026, a complete fiscal year, with 21 loans and $19.3 million; FY2018 followed with 19 loans and $24.2 million, and FY2024 also had 19 loans. Loans are assigned to Aberdeen by county name using the July 2023 area definitions, which leaves any loan with an unmatched county outside every area. The total of 127 also counts the 47 loans outside the named classes.
Demand is the opening test. A study should test the pull of the proposed site itself, and let a weak first year pass through the model. The budget is next. Borrowers see a $536,000 median, and each budget line should cite a source and include a reserve for slow months. Coverage of the loan payment follows: report coverage on the proposed loan next to a case with softer income, with interest and term stated. Appraisers challenge weak assumptions, so every income assumption must explain any gap between the site and its comparables. The record offers a thin base of 127 loans, and a study should disclose any benchmark it borrows from elsewhere. With the median at 2.58x the national level, a smaller project may look unusual here, and the study should explain its sizing against $536,000.
| Loans approved, FY2017 to FY2026 | 127 |
|---|---|
| Gross dollars approved | $138.3 million |
| Median loan | $536,000 |
| Middle half of loans, from | $190,000 |
| Middle half of loans, to | $1.5 million |
| SBA 7(a) loans | withheld |
| SBA 504 loans | withheld |
| Franchise share of loans | 18.1% |
| Rank among metro and micro areas by loans | 415 of 928 |
| Median loan against the national median | 2.58x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 7.4% |
|---|---|
| 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 Aberdeen, WA Micro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 5 | $2.6 million |
| FY2018 | 19 | $24.2 million |
| FY2019 | 9 | $12.5 million |
| FY2020 | 11 | $12.4 million |
| FY2021 | 15 | $15.4 million |
| FY2022 | 9 | $13.2 million |
| FY2023 | 7 | $5.7 million |
| FY2024 | 19 | $21.5 million |
| FY2025 | 12 | $11.6 million |
| FY2026 | 21 | $19.3 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 47 |
| Hotel and motel | 26 |
| Gas station and truck stop | 19 |
| Grocery store | 9 |
| Full-service restaurant | 8 |
| Limited-service restaurant | 7 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Open Bank | 13 | $30.4 million |
| Banner Bank | 12 | $4.2 million |
| U.S. Bank, National Association | 9 | $1.3 million |
| KeyBank National Association | 8 | $5.2 million |
| Commonwealth Business Bank | 7 | $7.5 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 |
|---|---|
| Grays Harbor County, WA | 127 |
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-10140.
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 Aberdeen, WA Micro 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