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 Lincoln, NE Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Lincoln, NE is a metropolitan area, and its 802 SBA approvals in FY2017 to FY2026 carried $342.8 million in gross dollars. Lincoln counts as an upper-tier area, ranked 121 of 928 by loans. In Lincoln, NE, every asset class is pooled for Lincoln. That view of Lincoln is missing from NE and national tables.
$176,000 is the Lincoln median loan, and the middle half runs $65,500 to $447,750. Lincoln sits below the national level: its 0.85x ratio to the national median means Lincoln requests sized nationally may look large. Lincoln counts 692 loans under 7(a) and 110 under 504, so 7(a) carries the Lincoln mix. 10.0% of Lincoln loans went to franchised businesses, so a Lincoln study names the brand, if any, for Lincoln.
Tracked classes in Lincoln, with loan counts: full-service restaurant 29, limited-service restaurant 22, automotive mechanical repair 19, fitness center 19. In Lincoln, 613 loans belong to no tracked class, which keeps these totals from being a pure property count. Lincoln lending concentrates by county: Lancaster County, NE (781 loans) and Seward County, NE (21 loans). Lincoln 7(a) volume: Union Bank and Trust Company (NE) ($58.3 million, 204 loans); First State Bank Nebraska ($39.3 million, 107 loans); Cornhusker Bank ($17.4 million, 53 loans). Union Bank and Trust Company (NE), with 204 loans, tops the Lincoln rows, each an SBA record of Lincoln loans held or once held; none judges Lincoln lenders.
Lincoln goes from 101 loans in FY2017 to 70 in FY2026, ending lower: the peak was 101 in FY2017, and the trough 62 in FY2019. In Lincoln, cancellations after approval reach 12.9% as a floor for FY2017 to FY2024; the ceiling is withheld there, and withheld is not zero in Lincoln. Of the 343 loans in the Lincoln cohort for FY2017 to FY2021, 2.3% are charged off, a floor. The Lincoln five-year loss figure is withheld; Lincoln cannot read it as zero. Lincoln faces a geography limit: Lincoln, NE uses the July 2023 definition; 802 loans are matched by county, and unplaceable Lincoln loans are omitted, so Lincoln counts and rates are floors.
Any Lincoln study defines its Lincoln trade area first, since lending in Lancaster County, NE differs from lending across Lincoln, NE. If a Lincoln concept resembles full-service restaurant, Lincoln offers size and lender precedent; other Lincoln concepts must rest on their own Lincoln evidence. Test Lincoln coverage of debt service on a $176,000 loan, and on a $447,750 loan, after pricing Lincoln costs from bids. Lincoln is metropolitan, so submarkets differ, and a Lincoln appraisal should use the site's own Lincoln submarket comparables. Nothing printed for Lincoln predicts approval; each Lincoln lender still reviews a study.
| Loans approved, FY2017 to FY2026 | 802 |
|---|---|
| Gross dollars approved | $342.8 million |
| Median loan | $176,000 |
| Middle half of loans, from | $65,500 |
| Middle half of loans, to | $447,750 |
| SBA 7(a) loans | 692 |
| SBA 504 loans | 110 |
| Franchise share of loans | 10.0% |
| Rank among metro and micro areas by loans | 121 of 928 |
| Median loan against the national median | 0.85x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 12.9% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | withheld |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 2.3% |
| Charged off within five years of approval | withheld |
| Loans in that cohort | 343 |
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 Lincoln, NE Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 101 | $30.9 million |
| FY2018 | 70 | $27.3 million |
| FY2019 | 62 | $24.8 million |
| FY2020 | 68 | $33.4 million |
| FY2021 | 93 | $51.3 million |
| FY2022 | 91 | $40.9 million |
| FY2023 | 80 | $27.7 million |
| FY2024 | 85 | $43.7 million |
| FY2025 | 82 | $35.0 million |
| FY2026 | 70 | $27.8 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 613 |
| Full-service restaurant | 29 |
| Limited-service restaurant | 22 |
| Automotive mechanical repair (car and truck) | 19 |
| Fitness center | 19 |
| Beauty salon | 15 |
| Medical office (physicians) | 14 |
| Dental office | 12 |
| Veterinary clinic | 8 |
| Coffee shop and snack bar | 8 |
| Hotel and motel | 7 |
| Child care center | 7 |
| Rehabilitation and therapy clinic | 6 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Union Bank and Trust Company (NE) | 204 | $58.3 million |
| First State Bank Nebraska | 107 | $39.3 million |
| Cornhusker Bank | 53 | $17.4 million |
| U.S. Bank, National Association | 49 | $3.6 million |
| Wells Fargo Bank National Association | 31 | $9.5 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 |
|---|---|
| Lancaster County, NE | 781 |
| Seward County, NE | 21 |
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-30700.
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 Lincoln, NE 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