Hotel Feasibility Study in the Madison, WI Metro Area

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

Madison: hotels eighth, with a tilt toward 504

Hotels and motels take 8 of 39 among Madison's classes in SBA's file, and Madison sits at 93 of 807 among areas. Adding FY2017 to FY2026 together gives Madison 25 loans and $48.4 million. In Madison the class is under-weighted at 0.81x on location quotient, with a $1.9 million median that is 0.88x the national figure.

Loans in the middle half of the Madison range start at $798,000 and top out at $2.8 million. The program tally leans toward 504, with 10 under 7(a) against 15, so 504 carries the larger count. Franchise units are 56.0% of the loans. Dane County holds 16 of the 25 loans. No holder reaches 5 loans in Madison, so no lender is named.

FY2020 shows 0 loans and $0, while FY2024 shows 7 loans worth $16.2 million, a large figure for seven loans. In Madison, a gap means few loans, not none. Cancellation and charge-off rates for Madison are not printed. Flags and tiers cannot be told apart, because hotels and motels sit in one code.

What a Madison hotel study must demonstrate

A median of $1.9 million with a middle half from $798,000 to $2.8 million gives a lender a wide range to measure against, so the study should say where the project sits and why. Occupancy and nightly rate must be shown against what land, building and furnishings cost, with the payment covered at an occupancy below plan. The class ranks 8th locally and the location quotient is 0.81x, so hotels are a middling part of the Madison book. Brand fees, nearby competing properties and the appraisal's income basis all belong in the study.

How the program mix bears on a plan

With 15 of the 25 loans under 504, a plan for a Madison hotel should say whether it assumes a 504 structure or a 7(a) one, because the two lead to different budgets and timing. The page does not describe program rules, only the counts, so a borrower should confirm structure with a lender before sizing. The one printed busy year, FY2024, is a reminder that individual large loans can dominate a small cell.

SBA hotel and motel loans in the Madison, WI Metro Area

Loans approved, FY2017 to FY202625
Gross dollars approved$48.4 million
Median loan$1.9 million
Middle half of loans, from$798,000
Middle half of loans, to$2.8 million
SBA 7(a) loans10
SBA 504 loans15
Franchise share of loans56.0%
Rank among metro and micro areas for hotel and motel loans93 of 807
Rank of hotel and motel among the classes in this area8 of 39
Location quotient (share of loans against the national share)0.81x
Median loan against the national median for the class0.88x

Cancellation and charge-off

Cancelled after approval, FY2017 to FY2024 approvals (a floor)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 hotel and motel loans approved in the Madison, WI Metro Area, by fiscal year

02468FY2017FY2018FY2019FY2020FY2021FY2022FY2023FY2024FY2025FY2026Loans, FY2020: 0Loans, FY2024: 7
Fiscal yearLoansDollars
FY2017withheldwithheld
FY2018withheldwithheld
FY2019withheldwithheld
FY20200$0
FY2021withheldwithheld
FY2022withheldwithheld
FY2023withheldwithheld
FY20247$16.2 million
FY2025withheldwithheld
FY2026withheldwithheld

Where the loans are, by county

CountyLoans
Dane County, WI16

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.

One code for hotels and motels; limited service and full service cannot be separated.

Shared code: Hotels and motels share 721110.

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

Loan Analytics prepares the feasibility study a lender reads before it commits: for a hotel and motel 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