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 Tucson, AZ Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Tucson, Arizona, shows 1,432 SBA approvals for FY2017 to FY2026 and $829.0 million gross, rank 72 of 928 on loan count. Its loans split 1,289 under 7(a) and 143 under 504. Tucson's median loan is $277,700, or 1.34x the national figure, with the central half running $100,000 to $646,550, and franchises account for 13.3% of loans. All placed loans sit in Pima County, so the Tucson record is the Pima County record.
Tucson is unusual among nearby areas because its largest named class is limited-service restaurant at 47 loans, just ahead of full-service restaurant at 46, with hotel and motel at 37, medical office at 31 and dental office at 28. Medical and dental offices together show that professional-practice real estate has a place in local lending, which calls for payer mix, chair or room count and the owner-dependence of revenue to be tested. A total of 1,006 loans sit outside the named classes. Volume began at 159 loans and $72.4 million in FY2017, dipped to 104 loans in FY2022, peaked at 193 loans and $88.2 million in FY2025, and ended at 157 loans and $116.4 million in FY2026, the highest dollar year.
Wells Fargo Bank National Association holds 177 loans and $71.6 million under 7(a), Zions Bancorporation, National Association 101 loans and $43.5 million, and U.S. Bank, National Association 84 loans and $13.2 million. Under 504, Arizona Capital Source holds 98 loans and $68.6 million and The Mortgage Capital Development Corporation 23 loans and $37.9 million. Each Tucson name is listed because SBA's records show loans it holds or held in Tucson; the list ranks no service and states no requirement.
Tucson's cancellation floor is lower than most of its peers: 8.8% for approvals of FY2017 to FY2024, 9.9% when undisbursed loans count as cancelled. Among 625 funded Tucson loans, charge-offs stand at 6.1% or more, with 3.0% inside five years; loans still open can raise these. Tucson's area is Pima County, placed through the July 2023 delineation by name, and a loan with an unplaceable county is left out. A feasibility study for a Tucson project should test local demand, cost, coverage on a conservative year and comparable-based value; for the restaurant and hotel classes that lead, it should add seasonal occupancy, rate and sales per seat. Daniel Smith, MAI, signs each study.
| Loans approved, FY2017 to FY2026 | 1,432 |
|---|---|
| Gross dollars approved | $829.0 million |
| Median loan | $277,700 |
| Middle half of loans, from | $100,000 |
| Middle half of loans, to | $646,550 |
| SBA 7(a) loans | 1,289 |
| SBA 504 loans | 143 |
| Franchise share of loans | 13.3% |
| Rank among metro and micro areas by loans | 72 of 928 |
| Median loan against the national median | 1.34x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 8.8% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 9.9% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 6.1% |
| Charged off within five years of approval | 3.0% |
| Loans in that cohort | 625 |
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 Tucson, AZ Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 159 | $72.4 million |
| FY2018 | 159 | $72.9 million |
| FY2019 | 122 | $52.6 million |
| FY2020 | 116 | $50.7 million |
| FY2021 | 129 | $125.5 million |
| FY2022 | 104 | $73.0 million |
| FY2023 | 129 | $84.7 million |
| FY2024 | 164 | $92.6 million |
| FY2025 | 193 | $88.2 million |
| FY2026 | 157 | $116.4 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 1,006 |
| Limited-service restaurant | 47 |
| Full-service restaurant | 46 |
| Hotel and motel | 37 |
| Medical office (physicians) | 31 |
| Dental office | 28 |
| Fitness center | 28 |
| Assisted living (without nursing care) | 27 |
| Coffee shop and snack bar | 26 |
| Automotive mechanical repair (car and truck) | 25 |
| Beauty salon | 24 |
| Child care center | 15 |
| Veterinary clinic | 13 |
| Car wash | 11 |
| Rehabilitation and therapy clinic | 11 |
| Self storage | 7 |
| Beverage manufacturing (breweries, wineries, distilleries) | 6 |
| Gas station and truck stop | 5 |
| Nonresidential lessor (flex, office and retail investor buildings) | 5 |
| School (elementary and secondary, including charter) | 5 |
| 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 |
|---|---|---|
| Arizona Capital Source | 98 | $68.6 million |
| The Mortgage Capital Development Corporation | 23 | $37.9 million |
| CDC Small Business Finance Corp. | 14 | $13.0 million |
| Lender | Loans | Dollars |
|---|---|---|
| Wells Fargo Bank National Association | 177 | $71.6 million |
| Zions Bancorporation, National Association | 101 | $43.5 million |
| U.S. Bank, National Association | 84 | $13.2 million |
| PNC Bank, National Association | 75 | $30.8 million |
| JPMorgan Chase Bank, National Association | 71 | $25.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 |
|---|---|
| Pima County, AZ | 1,432 |
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-46060.
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 Tucson, 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