Feasibility Study Data for the Madison, WI Metro Area

What SBA's own loan files show about lending in the Madison, WI Metro Area, every asset class together, and what a feasibility study for a project there has to test.

Madison, WI: volume and loan size, median $234,000

Madison stands 63 of 928 by loans, drawing 1,680 SBA approvals over FY2017 to FY2026, $930.4 million gross. In Madison, $234,000 is the median loan, 1.13x the national median. Half of Madison loans sit between $75,000 and $596,250, larger tickets than the national norm in Madison. Lenders working Madison see tickets from $75,000 to $596,250 most often. A Madison study should place its project inside that $75,000 to $596,250 range in Madison.

In Madison, SBA 7(a) carries 1,376 loans and SBA 504 carries 304. In Madison, franchise brands account for 12.4% of the loans. In Madison, leading classes: full-service restaurant with 68, limited-service restaurant with 68 and child care center with 61. Another 1,148 approvals fall in no named class, so Madison totals 1,680 loans, more than its classes combined. In Madison, the counties carrying most volume are Dane County, WI with 1,454, Columbia County, WI with 159 and Green County, WI with 42 in Madison.

Madison: holders of SBA loans in Madison, WI

In Madison, holder lists use SBA's listing of loans each institution carries or carried, as current holder, and claim nothing about requirements. Madison holders should be read that way in Madison. Heading the Madison SBA 7(a) list: Summit CU with 294 loans worth $40.8 million; Lake Ridge Bank with 163 loans worth $49.6 million; U.S. Bank in Madison, National Association with 73 loans worth $13.5 million. The Madison SBA 504 side shows WBD, Inc. with 287 loans worth $331.8 million. The first holder in Madison sets the pace. Even so, a Madison borrower may take a study elsewhere in Madison.

Among Madison approvals of FY2017 to FY2024, 10.3% were cancelled after approval, a floor. A Madison ceiling, counting undisbursed loans as cancelled, is 11.2%. The cohort of 822 Madison loans disbursed FY2017 to FY2021 shows 3.6% charged off to date, a floor, and 3.0% within five years. Madison trend: the busiest year is FY2017, at 212 loans. Placement in Madison hinges upon a project's county, from the file against the July 2023 delineation, so a loan whose county is blank sits in none of the areas. The 1,680 loans in Madison, WI include those that fall in no named class in Madison.

Madison: what a project study must test, per Madison, WI

Start with demand in Madison. Measure the trade area around the exact address in Madison, not the metropolitan area in Madison, and keep the forecast cautious in Madison. Cost needs care in Madison. Lenders fund a $234,000 median here, yet rebuild the budget from quotes, and contingency kept apart in Madison. Finally, Madison debt service coverage. Calculate coverage at the loan size then in a stress case, naming the cushion left in Madison. The value view meets a Madison appraisal, so the study's value logic should be verifiable in Madison. In Madison, 1,680 loans spread over many neighbourhoods, and a Madison study must say which it targets in Madison. With the median at 1.13x the national level, a smaller Madison project may look unusual in Madison. The study should explain its sizing for Madison against $234,000.

SBA loans in the Madison, WI Metro Area

Loans approved, FY2017 to FY20261,680
Gross dollars approved$930.4 million
Median loan$234,000
Middle half of loans, from$75,000
Middle half of loans, to$596,250
SBA 7(a) loans1,376
SBA 504 loans304
Franchise share of loans12.4%
Rank among metro and micro areas by loans63 of 928
Median loan against the national median1.13x

Cancellation and charge-off

Cancelled after approval, FY2017 to FY2024 approvals (a floor)10.3%
The same, counting loans still undisbursed as cancelled (a ceiling)11.2%
Charged off to date, FY2017 to FY2021 disbursed loans (a floor)3.6%
Charged off within five years of approval3.0%
Loans in that cohort822

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 Madison, WI Metro Area, by fiscal year

050100150200250FY2017FY2018FY2019FY2020FY2021FY2022FY2023FY2024FY2025FY2026Loans, FY2017: 212Loans, FY2018: 184Loans, FY2019: 192Loans, FY2020: 155Loans, FY2021: 183Loans, FY2022: 178Loans, FY2023: 101Loans, FY2024: 138Loans, FY2025: 167Loans, FY2026: 170
Fiscal yearLoansDollars
FY2017212$93.0 million
FY2018184$76.9 million
FY2019192$81.0 million
FY2020155$100.2 million
FY2021183$118.6 million
FY2022178$110.1 million
FY2023101$76.6 million
FY2024138$86.0 million
FY2025167$89.8 million
FY2026170$98.1 million

Loans by asset class

Asset classLoans
Not in any of the 39 asset classes1,148
Full-service restaurant68
Limited-service restaurant68
Child care center61
Fitness center55
Beverage manufacturing (breweries, wineries, distilleries)34
Beauty salon34
Automotive mechanical repair (car and truck)31
Hotel and motel25
Self storage24
Gas station and truck stop13
Veterinary clinic12
Grocery store12
Coffee shop and snack bar11
Liquor store10
Assisted living (without nursing care)9
Behavioral health and addiction treatment8
Medical office (physicians)8
Rehabilitation and therapy clinic7
Nonresidential lessor (flex, office and retail investor buildings)6
Dental office5
Life science lab (research and development)5
Caterers (includes banquet halls with catering staff)5

Classes with 5 or more loans; smaller ones are withheld, and more where a small one could be derived.

Most active SBA lenders

SBA 504: lenders by loans approved (the current holder of each loan, as SBA reports it)
LenderLoansDollars
WBD, Inc.287$331.8 million
SBA 7(a): lenders by loans approved (the current holder of each loan, as SBA reports it)
LenderLoansDollars
Summit CU294$40.8 million
Lake Ridge Bank163$49.6 million
U.S. Bank, National Association73$13.5 million
Byline Bank66$61.4 million
The Huntington National Bank61$22.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.

Where the loans are, by county

CountyLoans
Dane County, WI1,454
Columbia County, WI159
Green County, WI42
Iowa County, WI25

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-31540.

Loan Analytics prepares the feasibility study a lender reads before it commits: for a commercial project in the Madison, WI 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