Worked Example: Conventional Bank Marina Acquisition and Dock Expansion Feasibility Study in Kentucky
A worked example of the feasibility study a lender would read for a marina project in Kentucky, financed with a conventional bank loan.
What SBA's own loan files show about lending in the Cincinnati, OH-KY-IN Metro Area, every asset class together, and what a feasibility study for a project there has to test.
Cincinnati stretches over Ohio, Kentucky and Indiana, and its SBA record for FY2017 to FY2026 covers 5,781 loans and $2.45 billion gross, rank 24 of 928 on loan count. Tickets are small: the median loan is $150,000, only 0.72x the national figure, and half of loans fall in a band from $50,000 to $415,000. The median and the charge-off record both differ from the national pattern by more than the margin Loan Analytics requires. Of the loans, 5,458 are 7(a) and 323 are 504, and franchises hold 12.9% of the count.
Among named classes the largest is full-service restaurant at 276 loans, followed by limited-service restaurant at 208, fitness center at 115, beauty salon at 96 and hotel and motel at 80. A further 4,346 loans lie outside the named classes. Hamilton County, Ohio, has 2,443 loans, Butler County 947 and Warren County 709. Because the area crosses three states, a study must settle which state's licensing, tax and law govern the site before anything else, since Ohio, Kentucky and Indiana can differ on all three.
On the 7(a) side one name towers: The Huntington National Bank, 2,612 loans and $672.6 million. Next come U.S. Bank, National Association at 554 loans and $84.2 million, then First Commonwealth Bank at 173 loans and $93.3 million. In 504, Alloy Development Co., Inc. holds 264 loans and $202.2 million and Ohio Statewide Development Corporation 12 loans and $8.1 million. Holder status here is SBA's record, nothing else. It passes no judgment on any lender's practices and states nothing about what a given institution requires.
Cancelled after approval: 12.1% or more of FY2017 to FY2024 approvals, 14.1% if undisbursed loans count. Charged off: 3.5% or more of the 2,478 funded FY2017 to FY2021 loans, 2.0% within five years. Each is a floor. Volume moved from 561 loans and $227.1 million in FY2017 to a high of 673 loans and $330.5 million in FY2021, then down to 447 loans and $262.0 million in FY2026, the lowest count of the span. Cincinnati is assembled county by county from the July 2023 delineation, so a Cincinnati loan with an unplaceable county is dropped. With smaller tickets and restaurants leading, a study here should test sales per seat, occupancy cost and staffing, run coverage on a weaker year, and anchor value in nearby comparables. Daniel Smith, MAI, signs the work.
| Loans approved, FY2017 to FY2026 | 5,781 |
|---|---|
| Gross dollars approved | $2.45 billion |
| Median loan | $150,000 |
| Middle half of loans, from | $50,000 |
| Middle half of loans, to | $415,000 |
| SBA 7(a) loans | 5,458 |
| SBA 504 loans | 323 |
| Franchise share of loans | 12.9% |
| Rank among metro and micro areas by loans | 24 of 928 |
| Median loan against the national median | 0.72x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 12.1% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 14.1% |
| Charged off to date, FY2017 to FY2021 disbursed loans (a floor) | 3.5% |
| Charged off within five years of approval | 2.0% |
| Loans in that cohort | 2,478 |
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 Cincinnati, OH-KY-IN Metro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 561 | $227.1 million |
| FY2018 | 615 | $243.1 million |
| FY2019 | 566 | $216.0 million |
| FY2020 | 475 | $201.2 million |
| FY2021 | 673 | $330.5 million |
| FY2022 | 604 | $230.9 million |
| FY2023 | 617 | $216.6 million |
| FY2024 | 624 | $240.0 million |
| FY2025 | 599 | $280.1 million |
| FY2026 | 447 | $262.0 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 4,346 |
| Full-service restaurant | 276 |
| Limited-service restaurant | 208 |
| Fitness center | 115 |
| Beauty salon | 96 |
| Hotel and motel | 80 |
| Child care center | 79 |
| Dental office | 76 |
| Automotive mechanical repair (car and truck) | 66 |
| Coffee shop and snack bar | 64 |
| Beverage manufacturing (breweries, wineries, distilleries) | 54 |
| Medical office (physicians) | 40 |
| Caterers (includes banquet halls with catering staff) | 38 |
| Car wash | 31 |
| Gas station and truck stop | 29 |
| Liquor store | 27 |
| Veterinary clinic | 22 |
| Nonresidential lessor (flex, office and retail investor buildings) | 21 |
| Grocery store | 21 |
| Assisted living (without nursing care) | 15 |
| Self storage | 13 |
| Data center | 11 |
| Rehabilitation and therapy clinic | 10 |
| Behavioral health and addiction treatment | 9 |
| Manufactured housing community (lessors of other real estate) | 6 |
| Warehouse and distribution | 5 |
| School (elementary and secondary, including charter) | 5 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Alloy Development Co., Inc. | 264 | $202.2 million |
| Ohio Statewide Development Corporation | 12 | $8.1 million |
| Community Capital Development Corporation | 9 | $8.8 million |
| Citywide Small Business Development Corporation | 9 | $7.0 million |
| Community Ventures Corporation | 6 | $2.2 million |
| Lender | Loans | Dollars |
|---|---|---|
| The Huntington National Bank | 2,612 | $672.6 million |
| U.S. Bank, National Association | 554 | $84.2 million |
| First Commonwealth Bank | 173 | $93.3 million |
| KeyBank National Association | 163 | $107.8 million |
| Fifth Third Bank | 161 | $58.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 |
|---|---|
| Hamilton County, OH | 2,443 |
| Butler County, OH | 947 |
| Warren County, OH | 709 |
| Clermont County, OH | 616 |
| Kenton County, KY | 373 |
| Boone County, KY | 312 |
| Campbell County, KY | 157 |
| Dearborn County, IN | 72 |
| Brown County, OH | 52 |
| Grant County, KY | 34 |
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-17140.
A worked example of the feasibility study a lender would read for a marina project in Kentucky, financed with a conventional bank loan.
A worked example of the feasibility study a lender would read for a glamping resort project in Ohio, 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 Cincinnati, OH-KY-IN 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