Camilo Páez

    HomeServicesBlogBooksProjectsExperiences
    ServicesReal Estate ValuationAbout meSite mapPrivacy policy

© 2024 Camilo Páez, all rights reserved

← Real Estate Analyzer
Bogotá real estate · Data model

Bogotá Rental & Investment Property Valuation, Explained

How much should an apartment in Bogotá rent for? How much should you pay for an investment property to hit your target yield? This page walks through the exact math behind the free Real Estate Analyzer — built on 11,981 real listings across 12 of Bogotá's 20 official localities.

11,981Real listings analyzed
12 / 20Bogotá localities covered
Q2 2026Data last refreshed
Estimate a rental price →Calculate an investment →

Why this exists

Most rental and sale price guidance in Bogotá is anecdotal — a broker's gut feeling, or a handful of nearby listings eyeballed on a classifieds site. This tool replaces that with a calibrated model: every locality has its own price-per-m² range, yield, and sample size, all derived from real market data instead of asking prices alone. The goal is simple — give renters, buyers, and small investors a defensible number before they negotiate.

How the math works

The valuation model is a five-step pipeline. Each step is transparent and reproducible — there is no black box.

01

1. Locality (or barrio) base rate

Every one of the 12 modeled localities — and, where sample size allows, individual barrios within them — has a calibrated rental price-per-m² range (low–high) derived from real listings. This is the foundation the rest of the model builds on.

basePerM2 = midpoint(localityRentalRange)
base = basePerM2 × area_m2
02

2. Estrato (socioeconomic stratum) multiplier

Colombia classifies residential property into strata 1–6 based on socioeconomic conditions, and stratum is one of the strongest predictors of price within a given locality. The model applies a multiplier ranging from 0.72× at stratum 1 to 1.48× at stratum 6.

stratumMultiplier ∈ {1: 0.72, 2: 0.83, 3: 0.93, 4: 1.08, 5: 1.26, 6: 1.48}
03

3. Bedroom and amenity premiums

Each bedroom beyond the first adds a flat premium, scaled to the locality's price tier (high / mid / low). Amenities — parking, gym, pool, doorman — each add their own tier-scaled premium, calibrated from the price difference between otherwise-similar listings with and without that amenity.

adjustedBase = base + (bedrooms − 1) × bedroomPremium[tier] + Σ amenityPremium[tier]
04

4. Final point estimate and uncertainty band

The stratum multiplier is applied last, then the model outputs a ±12% range around that point estimate rather than a single number — because real markets have variance, and presenting a single false-precise figure would be misleading. In backtesting, the true market price falls inside this range in roughly 75% of comparable listings.

point = adjustedBase × stratumMultiplier
range = [point × 0.88, point × 1.12]
05

5. Converting to investment value via rental yield

Every locality also has a calibrated average annual rental yield (annual rent ÷ property value). The investment calculator inverts this relationship two ways: given a price, it tells you the expected monthly income; given a target income, it tells you the maximum price that still hits your yield goal.

propertyValue = (monthlyRent × 12) / avgYield
expectedMonthlyRent = (propertyValue × avgYield) / 12

What goes into the model

A summary of the inputs and how each one moves the estimate.

InputRangeEffect on price
Locality / barrio12 localities, 98 barriosSets the base price-per-m²
Estrato1 – 60.72× to 1.48× multiplier
Bedrooms1 – 6Flat premium per extra bedroom, by tier
Amenitiesparking, gym, pool, doormanFlat premium per amenity, by tier
Area (m²)20 – 500Linear scaling of the base rate

Data & honest limitations

The model explains roughly 68% of observed rental price variance (R² ≈ 0.68). The remaining 32% comes from factors not captured here: floor level, natural light, building age, view, and hyper-local block-by-block effects. It covers apartments only — not houses or commercial space — and only the 12 of Bogotá's 20 localities where sample size was large enough to be statistically meaningful. Listings reflect asking prices, not closed transaction prices, which tend to run slightly below ask.

Want this done for your specific property?

The free tool gives you a fast estimate. If you want a full ROI assessment, locality screening across multiple candidates, or negotiation support backed by this data, that's a paid advisory service.

See real estate investment advisory →

Frequently asked questions

Is the Bogotá rental valuation tool free?

Yes. Both the rental estimator and the investment calculator are free, with no login required.

How many localities does Bogotá actually have?

Bogotá D.C. is officially divided into 20 localities. This model currently covers 12 of them — the ones with enough listing volume to produce a statistically reliable estimate. The remaining localities have too few comparable listings to model responsibly yet.

How accurate is the rent estimate?

The model captures about 68% of observed price variance (R² ≈ 0.68) and the true market price falls inside the displayed ±12% range roughly 75% of the time. It is a reference guide, not a certified appraisal.

What is rental yield and why does it matter for investment decisions?

Rental yield is annual rental income divided by the property's purchase price. A property priced at COP 500M generating COP 30M/year in rent has a 6% yield. Comparing yield across localities is usually a better investment signal than comparing price alone.

Can I get a custom assessment for a property I am considering?

Yes — that is exactly what the real estate investment advisory service covers: a structured ROI assessment for a specific property or shortlist, going beyond what the free tool outputs.