Restaurant Feasibility Study in the Barnstable Town, MA Metro Area

What SBA's own loan files show about full-service restaurant lending in the Barnstable Town, MA Metro Area, and what a feasibility study for a project there has to test.

Cape Cod: restaurants with a big 504 share

Barnstable Town is one county, Barnstable County, and its restaurant file is unusual for a close split between programs: 59 loans are SBA 7(a) and 45 are SBA 504, so nearly as many borrowers are financing property as are financing operations. The location quotient of 1.84x makes restaurants a far bigger part of Cape lending than of lending nationwide. SBA approved 104 loans worth $50.2 million between FY2017 and FY2026.

Among 821 areas Barnstable Town stands 51st for full-service restaurant lending, and the class leads the area's own 39. Median size, $250,400, equals 0.91x the national level, and half the loans lie from $75,000 to $613,500. Loan Analytics withholds the franchise share for the Cape; it is not printed, and not zero either.

Savings bank and development companies

The Cape Cod Five Cents Savings Bank is shown with 17 of the 7(a) loans, only $1.8 million in all, a book of very small loans. Eastern Bank holds 9 worth $1.8 million, and TD Bank, National Association 9 worth $960,000. Three 504 holders appear. Bay Colony Development Corporation has 11 loans ($5.4 million); Granite State Economic Development Corporation has 10 ($8.8 million); South Eastern Economic Development Corporation has 5 ($2.0 million). Holdings are what SBA records today, and they say nothing about any holder's intentions.

Cape restaurants saw at least 17.7% of FY2017 to FY2024 approvals cancelled, the loss figure to weigh most. The cancellation ceiling is missing too, and so is the charge-off rate to date, as Loan Analytics withholds them; they are blank, not zero. By year, approvals ran 13 in FY2017, 7 in FY2022, 17 in FY2025, worth $5.0 million, and 8 in FY2026, also worth $5.0 million.

What a Cape Cod restaurant study must test

Seasonality is the first thing to test. A study should model monthly revenue across a summer peak and a thin winter, with a cash reserve that carries payroll and the loan payment through the off-season, and it should test how many covers the building can serve in July against how few it will serve in January. The labor supply, including seasonal housing for staff, is another constraint. Where the borrower buys the building under the 504 program, the appraisal has to weigh a seasonal use and local zoning, septic and permitting limits. The lone county in the file means a study can use county-level evidence, but it should still test the specific village, parking and walk-in trade. Counts for Barnstable County omit a loan if the July 2023 list does not match its county.

SBA full-service restaurant loans in the Barnstable Town, MA Metro Area

Loans approved, FY2017 to FY2026104
Gross dollars approved$50.2 million
Median loan$250,400
Middle half of loans, from$75,000
Middle half of loans, to$613,500
SBA 7(a) loans59
SBA 504 loans45
Franchise share of loanswithheld
Rank among metro and micro areas for full-service restaurant loans51 of 821
Rank of full-service restaurant among the classes in this area1 of 39
Location quotient (share of loans against the national share)1.84x
Median loan against the national median for the class0.91x

Cancellation and charge-off

Cancelled after approval, FY2017 to FY2024 approvals (a floor)17.7%
The same, counting loans still undisbursed as cancelled (a ceiling)withheld
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 full-service restaurant loans approved in the Barnstable Town, MA Metro Area, by fiscal year

05101520FY2017FY2018FY2019FY2020FY2021FY2022FY2023FY2024FY2025FY2026Loans, FY2017: 13Loans, FY2018: 11Loans, FY2019: 9Loans, FY2020: 10Loans, FY2021: 8Loans, FY2022: 7Loans, FY2023: 13Loans, FY2024: 8Loans, FY2025: 17Loans, FY2026: 8
Fiscal yearLoansDollars
FY201713$7.2 million
FY201811$2.5 million
FY20199$4.4 million
FY202010$11.8 million
FY20218$3.8 million
FY20227$4.1 million
FY202313$2.7 million
FY20248$3.6 million
FY202517$5.0 million
FY20268$5.0 million

Most active SBA lenders

SBA 504: lenders by loans approved (the current holder of each loan, as SBA reports it)
LenderLoansDollars
Bay Colony Development Corporation11$5.4 million
Granite State Economic Development Corporation10$8.8 million
South Eastern Economic Development Corporation5$2.0 million
SBA 7(a): lenders by loans approved (the current holder of each loan, as SBA reports it)
LenderLoansDollars
The Cape Cod Five Cents Savings Bank17$1.8 million
Eastern Bank9$1.8 million
TD Bank, National Association9$960,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.

Where the loans are, by county

CountyLoans
Barnstable County, MA104

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.

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 MA-12700-C34.

Loan Analytics prepares the feasibility study a lender reads before it commits: for a full-service restaurant project in the Barnstable Town, MA 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.

Request Scope & Timeline

Start with the data.

Contact Us