Worked Example: Conventional Bank Construction-to-Permanent Multifamily Feasibility Study in Nebraska
A worked example of the feasibility study a lender would read for a multifamily project in Nebraska, financed with a conventional bank loan.
What SBA's own loan files show about lending in the Omaha, NE-IA Metro Area, every asset class together, and what a feasibility study for a project there has to test.
1,811 SBA approvals landed here for Omaha projects from FY2017 through FY2026, carrying $932.3 million across every asset class. Omaha holds rank 58 of 928 against every other statistical area, Omaha among them. The median ticket in Omaha is $225,000, while the middle half span $75,000 to $569,500. Loan size here is 1.08x of the national median; ticket size is not what distinguishes this area.
The program split in Omaha is 1,594 under 7(a) and 217 under 504, leaving 504 as the minority route. Franchise brands account for 14.6% of loans. In 7(a), the biggest holder is U.S. Bank, National Association: 162 loans, $13.1 million in all, followed by Union Bank and Trust Company (NE) with 133 loans and $57.2 million. 124 loans sit with First National Bank of Omaha, and Wells Fargo Bank National Association at 106. On 504, Nebraska Economic Development Corporation comes first: 188 loans, $176.7 million. Iowa Business Growth Company trails with 13. Read the lender lines as SBA records of holdings. U.S. Bank, National Association appears for the loans SBA assigns to it; that says nothing about how Union Bank and Trust Company (NE) underwrites.
The larger share of the Omaha record falls outside the class table: 1,325 loans filed under other codes. The rows below are a incomplete view. Among tracked classes, full-service restaurant tops with 85 loans, then child care center with 70 and fitness center with 50. Further down sit limited-service restaurant, 45 loans and beauty salon at 36. By county, Douglas County, NE accounts for 1,234 loans, followed by Sarpy County, NE with 350 and Pottawattamie County, IA with 92. Demand differs between these counties, and the area label hides that spread.
Of FY2017 to FY2024 approvals in Omaha, no fewer than 11.7% were cancelled before the loan closed out; counting loans still undisbursed as cancelled raises the ceiling to 12.5%. 4.4% is the minimum for charge-offs to date in the FY2017 to FY2021 cohort, which holds 770 disbursed loans; within five years of credit approval the rate was 2.9%. Time is still passing on these loans, making these floors that can climb and cannot fall. Annual approvals peaked in FY2024 at 204 loans and $93.6 million; the thinnest Omaha year before FY2026 was FY2023, with 151 loans for $68.7 million. Membership in the Omaha, NE-IA metro area follows the project county: Douglas County, NE, Sarpy County, NE and the rest, county membership follows the 2023 delineation, and an unplaced Omaha county drops its loans from Omaha and every area.
Any Omaha feasibility study should be built for the project's own county, since area totals mix several markets. With full-service restaurant first in the Omaha class table, it has to examine how Omaha diners split by daypart and the lease term against payback, then the lunch and dinner balance. For child care center, the next class in Omaha, the questions are playground and safety build-out and staff wages against rates charged. Debt service coverage in Omaha needs a poor-year test; comparable transactions near the site must support the value.
| Loans approved, FY2017 to FY2026 | 1,811 |
|---|---|
| Gross dollars approved | $932.3 million |
| Median loan | $225,000 |
| Middle half of loans, from | $75,000 |
| Middle half of loans, to | $569,500 |
| SBA 7(a) loans | 1,594 |
| SBA 504 loans | 217 |
| Franchise share of loans | 14.6% |
| Rank among metro and micro areas by loans | 58 of 928 |
| Median loan against the national median | 1.08x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 11.7% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 12.5% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 4.4% |
| Charged off within five years of approval | 2.9% |
| Loans in that cohort | 770 |
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 Omaha, NE-IA Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 187 | $78.5 million |
| FY2018 | 163 | $62.4 million |
| FY2019 | 182 | $80.9 million |
| FY2020 | 160 | $74.7 million |
| FY2021 | 194 | $130.3 million |
| FY2022 | 188 | $113.5 million |
| FY2023 | 151 | $68.7 million |
| FY2024 | 204 | $93.6 million |
| FY2025 | 204 | $105.8 million |
| FY2026 | 178 | $123.8 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 1,325 |
| Full-service restaurant | 85 |
| Child care center | 70 |
| Fitness center | 50 |
| Limited-service restaurant | 45 |
| Beauty salon | 36 |
| Coffee shop and snack bar | 27 |
| Hotel and motel | 20 |
| Dental office | 18 |
| Automotive mechanical repair (car and truck) | 17 |
| Beverage manufacturing (breweries, wineries, distilleries) | 12 |
| Veterinary clinic | 12 |
| Car wash | 11 |
| Rehabilitation and therapy clinic | 11 |
| Self storage | 10 |
| Assisted living (without nursing care) | 10 |
| Gas station and truck stop | 9 |
| Medical office (physicians) | 8 |
| Nonresidential lessor (flex, office and retail investor buildings) | 6 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Nebraska Economic Development Corporation | 188 | $176.7 million |
| Iowa Business Growth Company | 13 | $8.4 million |
| Siouxland Economic Development Corporation | 11 | $12.8 million |
| Lender | Loans | Dollars |
|---|---|---|
| U.S. Bank, National Association | 162 | $13.1 million |
| Union Bank and Trust Company (NE) | 133 | $57.2 million |
| First National Bank of Omaha | 124 | $35.4 million |
| Wells Fargo Bank National Association | 106 | $39.5 million |
| Associated Bank National Association | 84 | $40.6 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 |
|---|---|
| Douglas County, NE | 1,234 |
| Sarpy County, NE | 350 |
| Pottawattamie County, IA | 92 |
| Cass County, NE | 42 |
| Saunders County, NE | 36 |
| Washington County, NE | 29 |
| Mills County, IA | 17 |
| Harrison County, IA | 11 |
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-36540.
A worked example of the feasibility study a lender would read for a multifamily project in Nebraska, financed with a conventional bank loan.
Loan Analytics prepares the feasibility study a lender reads before it commits: for a commercial project in the Omaha, NE-IA 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