Worked Example: USDA B&I Hotel Acquisition Feasibility Study in Georgia
A worked example of the feasibility study a lender would read for a hotel project in Georgia, financed with a USDA Business and Industry guaranteed loan.
What SBA's own loan files show about lending in the Atlanta-Sandy Springs-Roswell, GA Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Atlanta-Sandy Springs-Roswell, GA holds rank 7 of 928 by loans, with 13,525 approvals for FY2017 to FY2026, $10.15 billion gross. Ticket size in Atlanta leans high in Atlanta, with $350,000 at the median in Atlanta, 1.68x the national median in Atlanta. The middle half of Atlanta approvals runs from $150,000 up to $880,000. In Atlanta, a request far outside $150,000 to $880,000 will draw questions. The Atlanta study should answer them early in Atlanta.
In Atlanta, SBA 7(a) accounts for 12,360 loans, against 1,165 under SBA 504. 19.5% of the Atlanta loans went to franchised businesses. Atlanta named classes stand full-service restaurant with 836, limited-service restaurant with 648 and child care center with 404. The Atlanta total of 13,525 also contains 8,648 loans that no named class captures in Atlanta. By project county, Atlanta loans fall in Fulton County, GA with 3,152, Gwinnett County, GA with 2,451 and Cobb County, GA with 1,848 in Atlanta.
In Atlanta, holder lists use SBA's record of the loans a bank now holds or once held, as current holder in Atlanta, and say nothing of lender standards. Atlanta holders should be read that way. Atlanta SBA 7(a) holders at the top in Atlanta: Wells Fargo Bank National Association with 945 loans worth $133.9 million; The Huntington National Bank with 725 loans worth $346.4 million; Newtek Bank, National Association with 550 loans worth $202.0 million. In Atlanta, SBA 504 holders are in Atlanta led by Florida Business Development Corporation with 363 loans worth $379.5 million; Capital Partners Certified Development Company with 355 loans worth $430.4 million; Small Business Access Partners, Inc. with 246 loans worth $275.8 million. In Atlanta, the top holder leads the rest. An Atlanta borrower may still approach any lender in Atlanta.
Among FY2017 to FY2024 approvals, Atlanta cancellation after approval is 11.8%, a floor. An Atlanta ceiling of 12.6% treats unfunded loans as cancelled. Atlanta charge-offs to date, a floor, run 6.3% for the 5,474 loans disbursed from FY2017 to FY2021 in Atlanta; 3.8% came within five years. FY2025, at 1,897 loans, tops the printed yearly counts for Atlanta. Atlanta membership follows its project county, which is looked up by county name in the July 2023 area list, so a loan whose county cannot be placed falls outside every area. The 13,525 loans in Atlanta-Sandy Springs-Roswell, GA include those in no named class.
Start with demand in Atlanta. Count the customers within reach of the actual site in Atlanta, not the metropolitan area in Atlanta, then test a late opening in Atlanta. Cost needs care in Atlanta. The middle half runs $150,000 to $880,000, but the budget needs local bids, adding a visible contingency for Atlanta. Finally, Atlanta debt service coverage. Present the ratio for the amount and again on weaker revenue, so the margin in Atlanta of safety shows in Atlanta. The value view meets an Atlanta appraisal, so each source behind the numbers must hold up before an appraiser in Atlanta. Inside Atlanta-Sandy Springs-Roswell, GA, submarkets differ widely. Its 13,525 loans average across them all, so an Atlanta study must name the Atlanta submarket it means. With Atlanta at 1.68x the national median in Atlanta, projects run large in Atlanta. The study must justify its project for Atlanta against $350,000.
| Loans approved, FY2017 to FY2026 | 13,525 |
|---|---|
| Gross dollars approved | $10.15 billion |
| Median loan | $350,000 |
| Middle half of loans, from | $150,000 |
| Middle half of loans, to | $880,000 |
| SBA 7(a) loans | 12,360 |
| SBA 504 loans | 1,165 |
| Franchise share of loans | 19.5% |
| Rank among metro and micro areas by loans | 7 of 928 |
| Median loan against the national median | 1.68x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 11.8% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 12.6% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 6.3% |
| Charged off within five years of approval | 3.8% |
| Loans in that cohort | 5,474 |
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 Atlanta-Sandy Springs-Roswell, GA Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 1,325 | $933.8 million |
| FY2018 | 1,314 | $922.0 million |
| FY2019 | 1,208 | $891.5 million |
| FY2020 | 997 | $777.4 million |
| FY2021 | 1,353 | $1.33 billion |
| FY2022 | 1,116 | $925.8 million |
| FY2023 | 1,363 | $979.1 million |
| FY2024 | 1,665 | $1.11 billion |
| FY2025 | 1,897 | $1.25 billion |
| FY2026 | 1,287 | $1.04 billion |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 8,648 |
| Full-service restaurant | 836 |
| Limited-service restaurant | 648 |
| Child care center | 404 |
| Liquor store | 347 |
| Gas station and truck stop | 333 |
| Hotel and motel | 331 |
| Fitness center | 276 |
| Medical office (physicians) | 230 |
| Automotive mechanical repair (car and truck) | 192 |
| Coffee shop and snack bar | 184 |
| Beauty salon | 166 |
| Car wash | 160 |
| Dental office | 150 |
| Rehabilitation and therapy clinic | 85 |
| Grocery store | 81 |
| Veterinary clinic | 76 |
| Self storage | 55 |
| Beverage manufacturing (breweries, wineries, distilleries) | 54 |
| Assisted living (without nursing care) | 50 |
| Caterers (includes banquet halls with catering staff) | 42 |
| School (elementary and secondary, including charter) | 33 |
| Nonresidential lessor (flex, office and retail investor buildings) | 27 |
| Data center | 24 |
| Warehouse and distribution | 18 |
| Behavioral health and addiction treatment | 16 |
| Urgent care and ambulatory surgery | 12 |
| Parking lot and garage | 10 |
| Life science lab (research and development) | 9 |
| Hospital | 7 |
| Skilled nursing | 6 |
| Diagnostic imaging center | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Florida Business Development Corporation | 363 | $379.5 million |
| Capital Partners Certified Development Company | 355 | $430.4 million |
| Small Business Access Partners, Inc. | 246 | $275.8 million |
| Georgia Certified Development Corporation | 110 | $138.0 million |
| CSRA Local Development Corporation | 51 | $55.4 million |
| Lender | Loans | Dollars |
|---|---|---|
| Wells Fargo Bank National Association | 945 | $133.9 million |
| The Huntington National Bank | 725 | $346.4 million |
| Newtek Bank, National Association | 550 | $202.0 million |
| Metro City Bank | 515 | $882.7 million |
| Northeast Bank (ME) | 497 | $74.1 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 |
|---|---|
| Fulton County, GA | 3,152 |
| Gwinnett County, GA | 2,451 |
| Cobb County, GA | 1,848 |
| DeKalb County, GA | 1,568 |
| Forsyth County, GA | 681 |
| Cherokee County, GA | 614 |
| Henry County, GA | 433 |
| Fayette County, GA | 347 |
| Clayton County, GA | 322 |
| Douglas County, GA | 255 |
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-12060.
A worked example of the feasibility study a lender would read for a hotel project in Georgia, 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 Atlanta-Sandy Springs-Roswell, GA 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