Worked Example: SBA 7(a) Hotel Feasibility Study in Arizona, a Closed Motor Inn Reopened as an Independent Lodge
A worked example of the feasibility study a lender would read for a hotel project in Arizona, financed with an SBA 7(a) loan.
What SBA's own loan files show about lending in the Sierra Vista-Douglas, AZ Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Sierra Vista-Douglas is Cochise County alone, with 147 SBA approvals for FY2017 to FY2026 and $88.5 million gross, rank 374 of 928; 137 are 7(a) and 10 are 504. Sierra Vista has a median loan of $287,000. Sierra Vista stands at 1.38x the national figure; in Sierra Vista, half of loans run $56,750 to $711,000. Brands hold 19.7% of the count.
Hotel and motel is the lead class at 15 loans, double its nearest rivals: 7 loans each for gas station and truck stop and for limited-service restaurant, then 6 for full-service restaurant; 87 loans sit outside the classes. A Sierra Vista-Douglas lodging study should probe how occupancy and rate move through the year, what a brand's improvement plan would cost, and what income alone says the property is worth. FY2017 brought 23 loans and $13.4 million; FY2020 fell to 8 loans and $5.7 million; FY2025 peaked at 24 loans and $14.2 million; FY2026 ended at 18 loans and $6.9 million.
On 7(a), 22 loans worth $5.3 million belong to Zions Bancorporation, National Association; 12 loans and $2.9 million to PNC Bank, National Association; and 10 loans and $1.3 million to U.S. Bank, National Association. Arizona Capital Source holds 5 loans and $2.5 million on 504. Sierra Vista lists come from SBA's holder records. Sierra Vista names hold or held the loans shown. Sierra Vista volume is no lender's verdict. Sierra Vista counts state no requirement.
Sierra Vista: cancelled after approval at least 12.4% of Sierra Vista's approvals. The Sierra Vista window is FY2017 to FY2024. Sierra Vista omits its ceiling; too few Sierra Vista loans back it. Sierra Vista charge-offs are withheld. The Sierra Vista cohort is too thin; Sierra Vista is not a zero. Open Sierra Vista loans may raise every Sierra Vista floor. The July 2023 delineation shapes Sierra Vista. Sierra Vista reads each project's county by name. Sierra Vista loses a loan with no placeable county. Sierra Vista counts every approval, named or not. Sierra Vista-Douglas gas-station work needs pump margin against shop sales and the state of the tanks; brand work needs royalty cost; and every project needs a debt service run on thin revenue. Daniel Smith, MAI, names each Sierra Vista study. Sierra Vista studies are prepared by Loan Analytics.
| Loans approved, FY2017 to FY2026 | 147 |
|---|---|
| Gross dollars approved | $88.5 million |
| Median loan | $287,000 |
| Middle half of loans, from | $56,750 |
| Middle half of loans, to | $711,000 |
| SBA 7(a) loans | 137 |
| SBA 504 loans | 10 |
| Franchise share of loans | 19.7% |
| Rank among metro and micro areas by loans | 374 of 928 |
| Median loan against the national median | 1.38x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 12.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 Sierra Vista-Douglas, AZ Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 23 | $13.4 million |
| FY2018 | 11 | $1.4 million |
| FY2019 | 13 | $14.1 million |
| FY2020 | 8 | $5.7 million |
| FY2021 | 15 | $12.1 million |
| FY2022 | 10 | $4.1 million |
| FY2023 | 13 | $8.1 million |
| FY2024 | 12 | $8.5 million |
| FY2025 | 24 | $14.2 million |
| FY2026 | 18 | $6.9 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 87 |
| Hotel and motel | 15 |
| Gas station and truck stop | 7 |
| Limited-service restaurant | 7 |
| Full-service restaurant | 6 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Arizona Capital Source | 5 | $2.5 million |
| Lender | Loans | Dollars |
|---|---|---|
| Zions Bancorporation, National Association | 22 | $5.3 million |
| PNC Bank, National Association | 12 | $2.9 million |
| U.S. Bank, National Association | 10 | $1.3 million |
| Live Oak Banking Company | 8 | $8.5 million |
| Wells Fargo Bank National Association | 8 | $391,000 |
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 |
|---|---|
| Cochise County, AZ | 147 |
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-43420.
A worked example of the feasibility study a lender would read for a hotel project in Arizona, 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 Sierra Vista-Douglas, AZ 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