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 Sioux City, IA-NE-SD Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Sioux City, IA-NE-SD is a metropolitan area, and its 147 SBA approvals in FY2017 to FY2026 carried $104.5 million in gross dollars. Sioux City differs most on loan size: a $366,500 median, 1.76x of the national median, and Sioux City's gap clears our margin. Sioux City is set apart on losses too (Sioux City, IA-NE-SD); its floor, from 147 loans, is withheld in Sioux City; a withheld floor is not zero. Sioux City ranks as a mid-table area, 374 of 928 by loan count. In Sioux City, IA-NE-SD, every asset class is pooled for Sioux City. That view of Sioux City crosses the IA, NE, and SD line, which no state page shows.
$366,500 is the Sioux City median loan, and the middle half runs $143,000 to $780,000. Sioux City sits well above the national level, at 1.76x the national median, so a Sioux City study should size its request from Sioux City approvals. Sioux City: 7(a) leads the mix, with 104 7(a) loans against 43 under 504. Sioux City franchise loans reach 15.6%, so brand standards often shape a Sioux City request there.
Sioux City tracked classes among 147 loans, by loan count: full-service restaurant: 9; limited-service restaurant: 9. Sioux City also holds 104 loans outside every tracked class; Sioux City small business lending shows here. Woodbury County, IA (97 loans), Union County, SD (40 loans), and Dakota County, NE (10 loans) lead by county; a Sioux City study names which county it covers. Sioux City 7(a) leaders: GBC International Bank ($25.8 million, 12 loans); U.S. Bank, National Association ($283,000, 11 loans); Wells Fargo Bank National Association ($4.2 million, 7 loans). Siouxland Economic Development Corporation ($18.2 million, 23 loans); Dakota Business Finance ($6.5 million, 12 loans) lead 504 lending in Sioux City. SBA keeps records of Sioux City loans each lender holds or held; GBC International Bank leads with 12, and no Sioux City lender is judged.
Sioux City approvals peaked in FY2020 at 25 loans and $14.5 million, bottomed at 8 in FY2024, and ended FY2026 at 11, lower than the 22 of FY2017. Of Sioux City approvals in FY2017 to FY2024, Sioux City saw at least 11.3% cancelled, and at most 11.3% if Sioux City loans still undisbursed count as cancelled in Sioux City. Sioux City: no charge-off floor is printed. Its Sioux City cohort is too thin; Sioux City withholds it; withheld is not zero. Sioux City faces a geography limit: Sioux City, IA-NE-SD uses the July 2023 definition; 147 loans are matched by county, and unplaceable Sioux City loans are omitted, so Sioux City counts and rates are floors.
Any Sioux City study defines its Sioux City trade area first, since lending in Woodbury County, IA differs from lending across Sioux City, IA-NE-SD. If a Sioux City concept resembles full-service restaurant, Sioux City offers size and lender precedent; other Sioux City concepts must rest on their own Sioux City evidence. The Sioux City cost section uses local quotes; run Sioux City debt service coverage for loans near $366,500 and near $780,000. Sioux City, IA-NE-SD spans IA, NE, and SD, so a Sioux City study weighs licensing and incentives in IA, NE, and SD separately, and a Sioux City appraisal needs Sioux City comparables from the right side of Sioux City, IA-NE-SD. Sioux City appraisals compare within one submarket of Sioux City, IA-NE-SD, not across averages. Nothing printed for Sioux City predicts approval; each Sioux City lender still reviews a study.
| Loans approved, FY2017 to FY2026 | 147 |
|---|---|
| Gross dollars approved | $104.5 million |
| Median loan | $366,500 |
| Middle half of loans, from | $143,000 |
| Middle half of loans, to | $780,000 |
| SBA 7(a) loans | 104 |
| SBA 504 loans | 43 |
| Franchise share of loans | 15.6% |
| Rank among metro and micro areas by loans | 374 of 928 |
| Median loan against the national median | 1.76x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 11.3% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 11.3% |
| 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 Sioux City, IA-NE-SD Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 22 | $12.3 million |
| FY2018 | 9 | $4.7 million |
| FY2019 | 12 | $11.0 million |
| FY2020 | 25 | $14.5 million |
| FY2021 | 18 | $12.9 million |
| FY2022 | 19 | $14.0 million |
| FY2023 | 11 | $7.3 million |
| FY2024 | 8 | $7.4 million |
| FY2025 | 12 | $5.5 million |
| FY2026 | 11 | $14.8 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 104 |
| Full-service restaurant | 9 |
| Limited-service restaurant | 9 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Siouxland Economic Development Corporation | 23 | $18.2 million |
| Dakota Business Finance | 12 | $6.5 million |
| Lender | Loans | Dollars |
|---|---|---|
| GBC International Bank | 12 | $25.8 million |
| U.S. Bank, National Association | 11 | $283,000 |
| Wells Fargo Bank National Association | 7 | $4.2 million |
| Northwest Bank (IA) | 7 | $2.8 million |
| First Bank & Trust | 5 | $6.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 |
|---|---|
| Woodbury County, IA | 97 |
| Union County, SD | 40 |
| Dakota County, NE | 10 |
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-43580.
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 Sioux City, IA-NE-SD 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