The Indigo Plan, The BrooksColumbiaMO65201
INVESTMENT ANALYSIS
Investment Verdict
Appreciation PlayThe investment thesis at The Indigo Plan, The Brooks, Columbia, MO, 65201 in Columbia is capital appreciation. Rental yield 5.97%. The 5.97% gross yield at $409,100 falls below cash-flow thresholds, but 5% annual value growth is forecast to deliver $113,027 in additional equity by year five, an equity gain that can outpace many higher-yield markets. Ziffy Mortgage finances appreciation-play assets via DSCR (1.11) without U.S. credit history; structure with a larger down payment to optimise coverage. Total projected return: $122,122.
| This Property | City Avg | |
|---|---|---|
| Gross Rental Yield | 6% | 6.8% |
| Monthly Cash Flow | $(514) | $1,420 |
City averages based on Columbia market data in our database. Property projections are estimates.
DSCR Loan Qualification
| Monthly Rental Income | $2,034 |
| Total Monthly Debt Service | $2,385 |
| DSCR Ratio | 0.85x |
Ziffy Mortgage typically prefers a DSCR of 1.0+, but in some cases you may qualify with a DSCR below 1. To explore if this deal qualifies for an investment mortgage, book time with your loan officer →
Estimates assume 6.0% rate / 30-yr fixed, 30% down, 1% tax, 0.5% insurance. Not a commitment to lend.
Single Family
Built in 2026
N/A lot
$N/A/sqft
No HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 65201, Columbia, MO area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 22,582 (100%) |
| Owner Occupied HU | 6,281 (27.8%) |
| Renter Occupied HU | 13,910 (61.6%) |
| Vacant Housing Units | 2,391 (10.6%) |
| Median Home Value | $312,605 |
| Average Home Value | $358,527 |
Housing Distribution
Address Breakdown
Residential
20,008
Single Family
15,512
Multi-Family
4,496
Businesses
1,763
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices
Ziffy AI Summary
A quick, investor-focused snapshot highlighting income strength, yield potential.
| Key metrics | Value |
|---|---|
| Price | $399,900 |
| Est. Rent | $3,200/mo |
| ROI | 18% |
- Attractive rent-to-price ratio for income stability
- Good fit for DSCR financing with healthy coverage
Single Family
Built in 2026
N/A lot
$N/A/sqft
No HOA
Neighborhood Data
Neighborhood data shown for ZIP Code: 65201, Columbia, MO area.
Housing Distribution
Housing Statistics
| Category | Value |
|---|---|
| Total HU (Housing Units) | 22,582 (100%) |
| Owner Occupied HU | 6,281 (27.8%) |
| Renter Occupied HU | 13,910 (61.6%) |
| Vacant Housing Units | 2,391 (10.6%) |
| Median Home Value | $312,605 |
| Average Home Value | $358,527 |
Housing Distribution
Address Breakdown
Residential
20,008
Single Family
15,512
Multi-Family
4,496
Businesses
1,763
Nearby investment properties with comparable rents
Nearby investment properties with comparable prices