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 Kearney, NE Micro Area, every asset class together, and what a feasibility study for a project there has to test.
105 approvals for projects in Kearney, NE over FY2017 through FY2026 total $46.5 million gross. Then, Kearney sits at 457 of 928 among all CBSAs by loan count. In turn, $203,000 stands as the central loan; the central half falls between $100,000 and $520,000. Also, the area median comes to 0.98x compared with the median nationwide, so tickets run less than the national middle. In turn, Kearney holds only projects inside its borders, not a mix of unrelated markets: 105 loans in total.
84 loans under 7(a) stand against 21 loans in 504. In turn, 13.3% of the approvals belong to franchisees in this area. Beyond that, within 7(a) approvals, the biggest lenders by loans come out as First National Bank of Omaha with 18 loans worth $4.4 million, Custer Federal State Bank holding 14 loans worth $3.2 million, then Exchange Bank (NE) with 12 loans for $7.7 million. Beyond that, within 504 cases, the biggest program intermediaries by approvals are Nebraska Economic Development Corporation holding 21 loans for $12.8 million. Also, lender names come from SBA data for 105 approvals; they record loans made only, not what lenders apply across Kearney.
Limited-service restaurant at 12 comes first among the classes in the file. In turn, 76 loans fall beyond the named classes, so the Kearney total is wider than the class list. Here, looking at counties, Buffalo County (97) then Kearney County (8) take the largest shares. Here, over the approval years, FY2017 leads off at 10 loans and $1.9 million; withheld years in between are not filled in, and FY2024 rounds out the record at 13 loans and $2.4 million.
10.9% of FY2017 through FY2024 approvals in Kearney were cancelled before funding, a floor; 10.9% is the ceiling counting undisbursed loans. Also, 0.00% among FY2017 through FY2021 loans disbursed in Kearney were charged off to date, a floor; 0.00% were charged off by the fifth year post-approval, in a cohort of 52 disbursed loans. Treat every rate on this page as a floor, as approvals made lately have had limited time to cancel or default, across 105 loans. An area on this page is the statistical area that takes in every loan's county of project, following July 2023 boundaries as adopted; every county were matched by name alone, so any loan whose project county cannot be assigned is missing from every area total without exception. With or without a named class, every 7(a) or 504 loan in Kearney is added toward its $46.5 million total.
Across Kearney, a proper study of a project starts from the subject property, and not the 105-loan file. Next, customer demand in Kearney opens the work: does Kearney's household base support the turnover planned, net of nearby competition around Buffalo County? Worth noting: the median here stands at 0.98x against the national median, so typical tickets come in light; a bigger scheme must show comparable deals justify its size. Next, coverage of debt service joins revenue to cost in Kearney: forecast income set against loan payments, and a downside case. In turn, the valuation closes the loop in Kearney: the as-built value must cover the borrowing asked for. Worth noting: an applicant carrying a separate study for Kearney, prior to meeting a lender, has dealt with those floors up front; approval rests with SBA and the lender in Kearney, and no study promises it.
| Loans approved, FY2017 to FY2026 | 105 |
|---|---|
| Gross dollars approved | $46.5 million |
| Median loan | $203,000 |
| Middle half of loans, from | $100,000 |
| Middle half of loans, to | $520,000 |
| SBA 7(a) loans | 84 |
| SBA 504 loans | 21 |
| Franchise share of loans | 13.3% |
| Rank among metro and micro areas by loans | 457 of 928 |
| Median loan against the national median | 0.98x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 10.9% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 10.9% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 0.00% |
| Charged off within five years of approval | 0.00% |
| Loans in that cohort | 52 |
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 Kearney, NE Micro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 10 | $1.9 million |
| FY2018 | 9 | $9.6 million |
| FY2019 | 10 | $3.5 million |
| FY2020 | 16 | $7.2 million |
| FY2021 | 12 | $5.6 million |
| FY2022 | 11 | $5.8 million |
| FY2023 | 11 | $5.8 million |
| FY2024 | 13 | $2.4 million |
| FY2025 | withheld | withheld |
| FY2026 | withheld | withheld |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 76 |
| Limited-service restaurant | 12 |
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 | 21 | $12.8 million |
| Lender | Loans | Dollars |
|---|---|---|
| First National Bank of Omaha | 18 | $4.4 million |
| Custer Federal State Bank | 14 | $3.2 million |
| Exchange Bank (NE) | 12 | $7.7 million |
| First State Bank Nebraska | 7 | $8.0 million |
| U.S. Bank, National Association | 5 | $119,000 |
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 |
|---|---|
| Buffalo County, NE | 97 |
| Kearney County, NE | 8 |
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-28260.
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 Kearney, NE Micro 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