%
CapRateCity
Free cap rate calculators for every US market
MarketsMissouriColumbia

Columbia, MO Cap Rate: 3.12% — Rental Property Analysis

Columbia is a mid-range market in the Midwest with a smaller market with 128,000 residents. At a 3.12% estimated cap rate, this is a appreciation-focused market where rents of $1,400/mo lag behind home prices. With a median home price of $310,000 and steady population growth supports long-term rental demand, Columbia is primarily an appreciation play that requires creative strategies to generate positive cash flow.

Market data powered by Zillow Home Value Index (ZHVI) and Zillow Observed Rent Index (ZORI) · Updated Feb 2026

Challenging for pure cash flow
Based on $310,000 median price and $1,400/mo median rent
Est. Cap Rate
3.12%
1% Rule
0.45%
Fails
GRM
18.5x
Price / Income
6.4x

Market Data

Median Home Price$310,000
Median Monthly Rent$1,400
Property Tax Rate1.22%
Population128,000
Population Growth0.8% / yr
Median Household Income$48,600
Vacancy Rate5.2%
Annual Appreciation2.6%

2026 Market Update: Columbia

Columbia's 0.5% rent-to-price ratio is well below the 1% rule. At median prices of $310,000, the $1,400/mo rent produces only $805/mo in NOI. Investors here need to target below-median properties or pursue value-add strategies to make the numbers work.

At current rates, a 20% down conventional loan ($62K at 7%) would result in approximately $-844/mo cash flow — negative at median prices. Larger down payments, seller financing, or buying 15–25% below median are strategies to turn the numbers positive.

Property taxes consume 23% of gross rent here — one of the highest ratios in our dataset. This significantly compresses margins and makes Columbia a market where tax-conscious underwriting is essential. Every deal should be stress-tested with potential assessment increases.

Deal Modeling & Scenarios for Columbia

All figures below are computed from Columbia's real market medians. Use them as a baseline; override with property-specific numbers in the calculators.

Property Tax Bill in Real Dollars

Annual$3,782
Monthly$315
% of Gross Rent22.5%

At 1.22% effective rate on the $310,000 median price, the annual tax bill is $3,782 — that's near national average (+15% vs the national average of ~1.06%). Verify the actual assessed value before purchase; sale-triggered reassessments can push the bill higher than the seller's current statement.

5-Year Cap Rate Trajectory

If Columbia continues appreciating at 2.6%/yr while rents grow at a conservative 3%/yr, cap rate holds roughly steady as price growth outpaces rent. Year-by-year projection at the median:

YearEst. PriceEst. Rent/MoCap Rate
Today$310K$1,4003.1%
Year 1$318K$1,4423.1%
Year 2$326K$1,4853.1%
Year 3$335K$1,5303.2%
Year 4$344K$1,5763.2%
Year 5$352K$1,6233.2%

Three Financing Scenarios

Same median-priced Columbia property — different capital structures. All-cash maximizes cap rate. Leverage trades cash flow for higher cash-on-cash return when the spread between cap rate and borrowing cost is positive.

ScenarioCash InvestedMonthly Cash FlowAnnual CFCash-on-Cash
All cash$310K$805$9,6643.1%
20% down conventional @ 7%$71K$-844$-10,126-14.2%
25% down DSCR @ 8.5%$90K$-983$-11,791-13.1%

Three Price Tiers: Below, At, and Above the Median

Properties don't always trade at the median. Lower-priced units typically offer higher cap rates but harder operations; higher-priced properties tend to compress cap rates while attracting better tenants. All-cash assumptions below:

TierPriceRent/MoNOI/YrCap RateMonthly CF
Below median (~75% price)$233K$1,190$7,4863.2%$624
At median$310K$1,400$8,2162.7%$685
Above median (~125% price)$388K$1,610$8,9472.3%$746

Total Return Over a 5-Year Hold

Cap rate is just one piece. Real estate returns come from four sources: cash flow, appreciation, principal paydown, and tax benefits. Assuming 20% down conventional financing at 7% and a 5-year hold at Columbia's historical appreciation rate of 2.6%:

Cash Flow (5yr)$-50,630
Appreciation$42K
Principal Paydown$19K
Total Return$10K

On a $62K down payment, that's a 16.8% total ROI over 5 years (not annualized). Tax benefits from depreciation are additional and depend on your personal tax bracket.

Risk Flags Specific to Columbia

Automated checks against the underlying data — surface only the risks that actually apply to Columbia, not generic boilerplate:

Worth notingProperty tax rate of 1.22% is above national average. Verify the assessed value before purchase — sale-triggered reassessments can push your actual bill up.
Watch closelyRent-to-price ratio of 0.45% is well below the 1% rule. Achieving positive cash flow at median prices requires below-market purchases, larger down payments, or value-add strategies.
Worth notingPrice-to-income ratio of 6.4x suggests homeownership is stretched locally — supports rental demand, but limits the buyer pool for any future exit.

Cap Rate Calculator — Columbia

Pre-filled with Columbia medians. Adjust to match a specific property.

Property Details
$
$
3–8% typical
%
Monthly Expenses
1.22% rate
$
$
8–10% of rent
$
8–12% of rent
$
Cap Rate
2.54%Low
Net Operating Income ÷ Purchase Price
NOI / Year
$7,886
net operating income
Gross Rent Multiplier
18.5x
High (>15)
1% Rule
0.45%
✗ Fails
Monthly Cash Flow
$657
before debt service
Annual Breakdown
Gross Rental Income$16,800
Less Vacancy−$874
Effective Income$15,926
Less Operating Expenses−$8,040
Net Operating Income$7,886
Sponsored
Analyze Deals Faster with DealCheck
Import any property, get instant investment analysis — cap rates, cash flow, rehab estimates, and offer calculations. Used by 350,000+ investors.
Try DealCheck Free →

Cash-on-Cash Return — Columbia

Factor in financing to see your actual return on invested capital in Columbia.

$
$77,500
%
%
years
$
taxes + ins + maint + mgmt
$
$
Cash-on-Cash Return
-9.73%Weak
Annual Cash Flow ÷ Total Cash Invested
Total Cash Invested
$86,800
$77,500 down + $9,300 closing
Monthly Mortgage
$1,516
on $233K loan
Monthly Cash Flow
$-704
after all expenses
Annual Cash Flow
$-8,445
before taxes
Cash Flow Breakdown
Monthly Rent$1,400
Less Expenses−$588
Less Mortgage−$1,516
Monthly Cash Flow$-704

Is Columbia a Good Place to Invest in Rental Property?

Columbia, MO has a population of 128,000 and has been growing at 0.8% annually — roughly in line with national trends, meaning demand is stable but not exceptional. The median home price of $310,000 paired with median rents of $1,400/mo produces an estimated cap rate of 3.12%.

Property taxes at 1.22% fall within the national average range and shouldn't present unusual challenges. The vacancy rate of 5.2% is moderate and within normal parameters for a healthy rental market.

At a price-to-income ratio of 6.4x, homes cost about 6.4 times the local median income of $48,600. This elevated ratio means homeownership is stretched, supporting rental demand but limiting buyer pools. Home values have appreciated at roughly 2.6% annually. Steady appreciation means total returns will be primarily cash flow-driven — the more sustainable model for long-term wealth building.

Bottom line: At current median prices, Columbia is challenging for pure cash flow investing. Consider BRRRR strategies with below-market purchases, or look at neighboring metros with stronger price-to-rent ratios.

Sponsored
Get AI-Powered Property Insights
Homesage.ai analyzes 140 million properties with AI — spot hidden deals, assess property condition, and find investment opportunities. Free to try.
Analyze Properties →

Columbia Investment Guides

Explore Columbia Data

Free Download
Top 25 Cash Flow Cities (2026)
See how Columbia compares to the best cash flow markets in America.
Get the Report →
Analyze listings in Columbia instantly — cap rate, cash flow & more on every Zillow listing
Chrome Extension →
Sponsored
Investor Gear
Google Nest Thermostat
Google
$130
FLIR ONE Gen 3 Thermal Camera
FLIR
$179
Schlage Connect Keypad Deadbolt
Schlage
$229
The CapRateCity Report
Weekly market analysis: highest cap rate cities, emerging markets, and deal breakdowns. Free, no spam.

Related Cities Near Columbia

Similar Markets in the Midwest

Cedar Rapids, IA$235K · $1,120/mo
3.1%
Bellefontaine, OH$240K · $1,180/mo
3.1%
Marinette, WI$195K · $1,000/mo
3.1%
Niles, MI$265K · $1,260/mo
3.1%
Hutchinson, MN$285K · $1,250/mo
3.1%
Run a BRRRR analysis for Columbia
Model a buy-rehab-refinance deal with Columbia data pre-loaded.
Open BRRRR Calculator →