Worked Example: SBA 7(a) Gym Feasibility Study in Hawaii
A worked example of the feasibility study a lender would read for a gym project in Hawaii, financed with an SBA 7(a) loan.
What SBA's own loan files show about lending in the Kapaa, HI Micro Area, every asset class together, and what a feasibility study for a project there has to test.
125 SBA loans within Kapaa, HI over FY2017 to FY2026 come to $38.5 million gross. Beyond that, Kapaa comes in at 420 of 928 within all CBSAs by loans. $84,100 gives the median; the inner half extends from $40,000 to $445,500. In addition, the typical loan here is 0.40x compared with the nation's median, so tickets run short of what the country sees. For context, Kapaa keeps to its home counties, not a statewide average: 125 approvals altogether.
113 loans in 7(a) compare with 12 loans under 504. Worth noting: no share for franchises is shown for Kapaa; the base is too thin. Also, for 7(a) loans, the busiest banks and lenders on loan count are Central Pacific Bank booking 28 loans worth $1.1 million, Gather FCU holding 19 loans worth $5.2 million, followed by First Hawaiian Bank booking 9 loans worth $755,000. No development company in Kapaa has enough loans to be named. The names here are copied from SBA files covering 125 loans; they show loans made alone, never what lenders require around Kapaa.
Full-service restaurant with 11 comes first among the classes by approvals. 102 approvals fall outside every named class, so the Kapaa total reaches beyond any class table. Kauai County carries every one of 125 loans, so area and county match. In turn, by year, FY2017 opens at 31 loans and $4.9 million; a few years between are withheld, never estimated, then FY2026, a year not fully booked, rounds out the series at 7 loans and $5.3 million.
9.5% of FY2017 through FY2024 loans in Kapaa were cancelled before they funded, a floor; 9.5% is the upper bound counting undisbursed loans. Beyond that, no charge-off floor is printed for Kapaa, HI; the disbursed cohort is too small, and a gap never means zero. Treat each percentage in this section as a floor, as approvals made in the latest years have had scant opportunity to cancel or default, across 125 loans. Also, each area in this file rests on the CBSA which includes a loan's home county, following July 2023 boundaries as published; counties are tied name to name, but an approval whose project county cannot be assigned is excluded from every area total as a rule. Then, classed or unclassed, each approval in either program across Kapaa is counted in its $38.5 million total.
Across Kapaa, an independent study aimed at a venture must begin with the project itself, rather than the 125-loan file. Next, local demand in Kapaa is tested first: does Kapaa's trade area support the revenue assumed, set against rivals around Kauai County? Then, the area median comes to 0.40x measured against the median nationwide, so typical tickets stay compact; a bigger scheme should demonstrate comparable deals justify its size. Debt service coverage joins sales to outlay for Kapaa: projected operating income tested against loan payments, and a stress case. Then the appraisal ends the sequence for Kapaa: value as built must cover the amount put forward. Also, a borrower armed with a separate feasibility study of Kapaa, before calling on a lender, has answered these rates early; the final word is with the underwriters and SBA in Kapaa, and no study can promise it.
| Loans approved, FY2017 to FY2026 | 125 |
|---|---|
| Gross dollars approved | $38.5 million |
| Median loan | $84,100 |
| Middle half of loans, from | $40,000 |
| Middle half of loans, to | $445,500 |
| SBA 7(a) loans | 113 |
| SBA 504 loans | 12 |
| Franchise share of loans | withheld |
| Rank among metro and micro areas by loans | 420 of 928 |
| Median loan against the national median | 0.40x |
| Cancelled after approval, FY2017 to FY2024 approvals (a floor) | 9.5% |
|---|---|
| The same, counting loans still undisbursed as cancelled (a ceiling) | 9.5% |
| 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 Kapaa, HI Micro Area, by fiscal year
| Fiscal year | Loans | Dollars |
|---|---|---|
| FY2017 | 31 | $4.9 million |
| FY2018 | 19 | $8.2 million |
| FY2019 | 11 | $5.6 million |
| FY2020 | 8 | $2.0 million |
| FY2021 | withheld | withheld |
| FY2022 | withheld | withheld |
| FY2023 | 9 | $4.6 million |
| FY2024 | 20 | $4.9 million |
| FY2025 | 13 | $2.4 million |
| FY2026 | 7 | $5.3 million |
| Asset class | Loans |
|---|---|
| Not in any of the 39 asset classes | 102 |
| Full-service restaurant | 11 |
Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.
| Lender | Loans | Dollars |
|---|---|---|
| Central Pacific Bank | 28 | $1.1 million |
| Gather FCU | 19 | $5.2 million |
| First Hawaiian Bank | 9 | $755,000 |
| BayFirst National Bank | 7 | $1.3 million |
| Live Oak Banking Company | 6 | $4.9 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 |
|---|---|
| Kauai County, HI | 125 |
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-28180.
A worked example of the feasibility study a lender would read for a gym project in Hawaii, financed with an SBA 7(a) loan.
Loan Analytics prepares the feasibility study a lender reads before it commits: for a commercial project in the Kapaa, HI 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