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 Portland-Vancouver-Hillsboro, OR-WA Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Portland stands 23 of 928 by loans, drawing 6,061 SBA approvals over FY2017 to FY2026, $3.43 billion gross. The Portland median loan is $207,600, 1.00x the national median. That makes Portland an average-ticket market. In Portland, the middle half of in Portland loans runs from $50,000 to $669,100. Lenders working Portland see tickets from $50,000 to $669,100 most often. A Portland study should place its in Portland project inside that $50,000 to $669,100 range in Portland.
In Portland, SBA 7(a) carries 5,622 loans and SBA 504 carries 439. In Portland, franchise brands account for 8.3% of the loans. In Portland, leading classes: full-service restaurant with 304, limited-service restaurant with 158 and automotive mechanical repair with 104. Another 4,636 approvals fall in no named class, so Portland totals 6,061 loans, more than its classes combined. In Portland, the counties carrying most volume are Multnomah County, OR with 2,069, Washington County, OR with 1,297 and Clark County, WA with 1,192. A state line crosses Portland. Rules differ by side in Portland. Name the state behind each Portland input.
In Portland, holder lines build on what SBA reports in Portland on loans a lender holds or held in Portland, as current holder in Portland, and claim nothing about requirements. Portland holders should be read that way in Portland. Heading the Portland SBA 7(a) list in Portland: Columbia Bank (OR) with 932 loans worth $274.8 million; U.S. Bank, National Association with 883 loans worth $163.8 million; KeyBank National Association with 397 loans worth $206.3 million. The Portland SBA 504 side shows Evergreen Business Capital with 184 loans worth $201.3 million; Northwest Business Development Association with 127 loans worth $142.7 million; Cascade Capital Funding with 66 loans worth $81.3 million. In Portland, concentration among top holders says little. A Portland study should stand on evidence alone in Portland.
Among Portland approvals of FY2017 to FY2024, 12.2% were cancelled after approval, a floor. A Portland ceiling, counting undisbursed loans as cancelled, is 13.0%. The cohort of 2,566 Portland loans disbursed FY2017 to FY2021 shows 4.3% charged off so far, a floor, and 2.5% within five years. Portland trend: the busiest year is FY2025, at 780 loans. Each loan lands in Portland by project county, found by name lookup against the July 2023 delineation, so some loan whose county has no match joins no area at all. The 6,061 loans in Portland-Vancouver-Hillsboro, OR-WA include those in Portland with no named class.
Demand leads the Portland list. Map who lives and works near the actual site in Portland, not the metropolitan area in Portland, and keep the forecast cautious in Portland. Project cost follows in Portland. Loans near $207,600 are common, but the budget needs local bids, and contingency kept apart in Portland. Serviceability is the heart of Portland. Compute the ratio at the planned loan and again on weaker revenue, naming the cushion left in Portland. Portland appraisers challenge weak assumptions, so the cost-to-value story must hold up before an appraiser in Portland. Inside Portland-Vancouver-Hillsboro, OR-WA, submarkets differ widely. Its 6,061 loans average across them all, so a Portland study must name the Portland submarket it means. At 1.00x the national median, Portland projects run typical in size. The study must justify its project for Portland against $207,600.
| Loans approved, FY2017 to FY2026 | 6,061 |
|---|---|
| Gross dollars approved | $3.43 billion |
| Median loan | $207,600 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $669,100 |
| SBA 7(a) loans | 5,622 |
| SBA 504 loans | 439 |
| Franchise share of loans | 8.3% |
| Rank among metro and micro areas by loans | 23 of 928 |
| Median loan against the national median | 1.00x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 12.2% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 13.0% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 4.3% |
| Charged off within five years of approval | 2.5% |
| Loans in that cohort | 2,566 |
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 Portland-Vancouver-Hillsboro, OR-WA Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 602 | $309.7 million |
| FY2018 | 616 | $287.1 million |
| FY2019 | 628 | $312.7 million |
| FY2020 | 525 | $318.7 million |
| FY2021 | 554 | $413.4 million |
| FY2022 | 503 | $347.6 million |
| FY2023 | 559 | $385.3 million |
| FY2024 | 651 | $275.4 million |
| FY2025 | 780 | $398.0 million |
| FY2026 | 643 | $382.3 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 4,636 |
| Full-service restaurant | 304 |
| Limited-service restaurant | 158 |
| Automotive mechanical repair (car and truck) | 104 |
| Fitness center | 93 |
| Coffee shop and snack bar | 81 |
| Beverage manufacturing (breweries, wineries, distilleries) | 71 |
| Child care center | 70 |
| Assisted living (without nursing care) | 68 |
| Gas station and truck stop | 67 |
| Beauty salon | 67 |
| Dental office | 58 |
| Medical office (physicians) | 38 |
| Hotel and motel | 33 |
| Grocery store | 29 |
| Nonresidential lessor (flex, office and retail investor buildings) | 25 |
| Rehabilitation and therapy clinic | 23 |
| Skilled nursing | 18 |
| Caterers (includes banquet halls with catering staff) | 17 |
| Veterinary clinic | 16 |
| Data center | 14 |
| Liquor store | 14 |
| Self storage | 10 |
| Car wash | 9 |
| School (elementary and secondary, including charter) | 9 |
| Warehouse and distribution | 8 |
| Behavioral health and addiction treatment | 7 |
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 | 184 | $201.3 million |
| Northwest Business Development Association | 127 | $142.7 million |
| Cascade Capital Funding | 66 | $81.3 million |
| The Mortgage Capital Development Corporation | 43 | $63.2 million |
| Ameritrust CDC | 12 | $20.5 million |
| Lender | Loans | Dollars |
|---|---|---|
| Columbia Bank (OR) | 932 | $274.8 million |
| U.S. Bank, National Association | 883 | $163.8 million |
| KeyBank National Association | 397 | $206.3 million |
| Wells Fargo Bank National Association | 390 | $165.7 million |
| Banner Bank | 243 | $57.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 |
|---|---|
| Multnomah County, OR | 2,069 |
| Washington County, OR | 1,297 |
| Clark County, WA | 1,192 |
| Clackamas County, OR | 1,174 |
| Yamhill County, OR | 226 |
| Columbia County, OR | 88 |
| Skamania County, WA | 15 |
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-38900.
A worked example of the feasibility study a lender would read for a hotel project in Washington, financed with an SBA 504 loan.
A worked example of the feasibility study a lender would read for a gas station project in Oregon, financed with a USDA Business and Industry guaranteed loan.
Loan Analytics prepares the feasibility study a lender reads before it commits: for a commercial project in the Portland-Vancouver-Hillsboro, OR-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