Real Estate

Real estate sales projection simulator

Every month of sales delay is another month of interest, maintenance, and capital locked in the project.

Problem and approach

You invested millions in a development and you do not know whether you will sell enough in time to pay down the debt and turn a profit.

Simulate sales velocity, market absorption, and project cash flow to make confident pricing and marketing decisions.

Variables it will analyze

  • Total units
  • Absorption rate
  • Price per unit
  • Financing costs

Frequently asked questions

How do I estimate the market absorption rate?
Divide monthly sales of comparable projects in your area by the available inventory. You can adjust the result by product type and market conditions.
Does it account for interest rate impact?
Yes, you can model scenarios with different mortgage rates that affect buyer affordability and absorption speed.
Can I simulate tiered pricing?
Yes, you can configure price phases (pre-sale, construction, delivery) with increments between each stage.

Complete guide

Sales velocity, absorption rate and months of supply: the three metrics every developer and broker needs to master

In Latin America, the difference between a real estate project that sells out in 18 months and one that drags inventory for four years is usually measured with the same three metrics the Spanish-language SERP constantly blurs. Sales velocity is absolute: units placed per month. Monthly absorption rate converts that velocity into a percentage: units sold divided by available inventory. Months of supply is the practical inverse: remaining inventory divided by sales velocity — how long the offer would take to sell out if the pace holds constant. They are three complementary, non-interchangeable numbers, and the commercial team that separates them makes better pricing, marketing and phase-release decisions than the team that reports only one.

The base formula the simulator runs every time:

Monthly absorption (%) = (Units sold in the month ÷ Total available inventory) × 100

Months of supply = Remaining inventory ÷ Sales velocity (units/month)

Above 20% monthly absorption the market is considered a seller's market — upward price pressure, reduced commercial discounts, accelerated phase release. Between 15% and 20%, a neutral market; below 15% a buyer's market — with price adjustments, incentives, extended pre-sale windows and a revised marketing mix as consequence. Months of supply reinforce the read: under 6 months indicates a tight market, 6-9 equilibrium, more than 12 months excess supply that will drag prices down in 2-4 quarters.

Numeric example: 80-unit tower in Mexico City

A mixed-use development in the Polanco-Anzures zone with 80 units of 75-110 m² launched in February 2025. Average price USD 4,600/m², equivalent to USD 390,000 per average unit. After 6 months of marketing, 24 units sold — average velocity of 4 units/month.

  • Monthly absorption = 4 ÷ 80 = 5.0% on original inventory
  • Remaining inventory = 80 − 24 = 56 units
  • Months of supply = 56 ÷ 4 = 14 months to sell out
  • DR90 (cumulative sales in the first 90 days) = 14 units sold in the first 3 months = 17.5% of inventory

The Softec and Tinsa Mexico benchmark for Mexico City premium vertical residential is 4-6% monthly absorption and DR90 of 15%-22%. The project is inside the base corridor — no alarm signal, but also no room to raise prices in the next phase. If absorption fell to 2%, months of supply would double to 28 and the project would start carrying significant financing costs against revenue that is not arriving. The commercial decision is not "sell faster at any cost" but decide whether to release additional units, adjust product mix or pause the next phase until the pace reactivates.

Velocity of sales vs absorption vs months of supply — when to use which

Velocity of sales (absolute) is the operational metric of the sales team: it tells you how many calls to answer, walk-ins to handle, sales-office staff to maintain. It is the base of the weekly forecast.

The absorption rate (relative) is the steering committee's strategic metric: it compares projects of different sizes on a common base. A 40-unit project with 5% absorption sells 2/month; a 200-unit project with the same absorption sells 10/month. Absolute velocity is not comparable; absorption is.

Months of supply is the CFO's and the bank's metric: it answers the operational question "if everything stays the same, when do we recover capital?" It feeds directly into the cash flow model and the debt service coverage covenant of the bridge loan.

Pre-sales on plans: the distortion pure metrics miss

In LatAm, pre-sales on plans is the norm: up to 50%-70% of inventory is placed before breaking ground in mid-high residential projects. This distorts the classic absorption rate because the "sold" units are not physically available — they are promise contracts with staggered payment over 18-36 months. The simulator separates three states: reserved (refundable deposit), sold in pre-sale (signed contract, staggered payment), delivered/titled (transferred). The reservation-to-closing conversion — the rate at which deposits become signed contracts — is the real leading indicator of velocity, not signed contracts. In healthy Mexico City residential projects, that conversion is between 55% and 75%; below 40% there is a product, price or closing-process problem.

Softec Mexico and Tinsa LatAm publish that the difference between pre-sale DR90 and finished-construction DR90 can reach 15 percentage points: projects that sell 25% in the first 90 days with aggressive pre-sale discounts collapse to 10% when the discount disappears and price rises to delivery sheet. The simulator models that curve explicitly.

Phased release: releasing inventory in controlled waves

The phased release strategy — releasing inventory in waves (20-30 units at a time) instead of listing all 80 from day one — lifts apparent absorption rate and protects pricing. If you release 25 units and sell 10 in a month, partial absorption is 40% — a number the sales team uses to justify a price bump in the next wave. If you had listed all 80 and sold the same 10, the read absorption would be 12.5% and the pressure would be to lower price. Same transaction, different narrative, different price outcome. The simulator lets you model 2, 3 or 4 waves with independent absorption and pricing, exposing the revenue optimization that a single release masks.

NPV and equity multiple of projected revenue

Computing sales velocity without translating it into discounted cash flow leaves half the work undone. Each sold unit generates a payment schedule: 10%-20% down, monthly payments during construction, 70%-80% at closing. The NPV of future revenue is calculated discounting each cash-in at the project discount rate (typically 12%-15% for LatAm developers, 9%-11% for stabilized post-delivery projects). A 5% monthly absorption with staggered payment schedule yields a very different NPV from the same absorption with cash-on-signing. The equity multiple (EM = Total cash returned / Total equity invested) and the equity IRR derive from the same projection; the simulator calculates them in parallel with absorption rate so the investment committee sees all three numbers together.

Development yield on cost and exit cap rate

For mixed-use and post-stabilization rental projects, development yield on cost (YoC) — stabilized NOI divided by total project cost — is the metric crossed with absorption. If your YoC is 7.5% and the expected exit cap rate of the zone is 6.0%, you have a cap rate spread of 150 basis points — the premium of developing vs buying stabilized. Healthy spreads in LatAm vertical are 150-250 bps; below 100 bps the development risk is not justified and it is better to buy stabilized. This analysis complements absorption when the project has a rental component — a common case in mixed-use with ground-floor retail and housing above.

Developer mode vs agent mode

The simulator runs in two modes. Developer mode: you input your total inventory, prices per unit type, expected base/optimistic/pessimistic absorption and payment schedule; you receive month-by-month cash-in projection, time to sell-out, NPV and equity IRR. Agent/broker mode: you input monthly sales, active inventory in your zone, closed comps; you receive zonal absorption rate, months of supply, market classification (sellers/neutral/buyers) and context for your CMA (Comparative Market Analysis). Same engine, different views — one to project, one to measure.

LatAm benchmarks by city (2024-2025 reference)

Numbers vary by segment (affordable, middle, residential, premium) and by cycle phase; these are base reference ranges aggregated from Softec, Tinsa, Colliers and JLL LatAm:

  • Mexico City premium vertical (Polanco, Condesa, Roma, Santa Fe): monthly absorption 3.5%-5.5%, DR90 14%-22%, months of supply 18-28.
  • Playa del Carmen tourist condo: absorption 4%-7% in high season (Nov-Apr), 2%-3% in low season; volatile market with strong USD component.
  • Monterrey (Valle Oriente, San Pedro): absorption 4%-6%, DR90 18%-25%, market with strong absorption from post-nearshoring corporate migration.
  • Medellín El Poblado: absorption 3.5%-5%, heavily driven by USD expat demand.
  • Bogotá Chicó / Usaquén: absorption 2.5%-4%, long cycle, projects of 36-48 months to sell-out.

The simulator lets you load your city's benchmark and compare your pace against the base, red and green corridors — a data conversation, not an intuition one.

Factors that accelerate or slow absorption

The five most measurable acceleration drivers: (1) proximity to mass transit (Metro, Metrobús, Transmilenio) — +20%-35% in absorption vs the same product off-corridor; (2) product mix aligned with demographic demand — 1-2 bedroom units in areas with heavy millennial/DINK presence have 40%-60% higher absorption than 3-4 bedroom units with double parking; (3) price per m² inside the 90%-110% corridor of zone comp — pulling 20% above collapses absorption, 20% below burns margin without compensating in volume; (4) financing strategy — an agreement with 2-3 banks for express approval doubles the conversion from prospect to signed contract; (5) premium amenities aligned with the segment — rooftop, gym, co-working in millennial/prosumer vertical; family lounge, playrooms, valet parking in the family segment.

When your project is stalled and what to do

If your absorption has been 3 months below 60% of the zone's base corridor, there is a structural problem that more advertising will not solve. Typical diagnosis: (1) price out of market — review recent closed comps, not listed; (2) misaligned product — typology mix vs local demand; (3) slow closing process — bank approval time, titling bureaucracy; (4) brand/reputation — Google searches with complaints, Condusef/SFC resolutions against; (5) incompetent or misaligned sales force on incentives. The simulator does not diagnose these causes but does quantify the cost of inaction: every month of delay is bridge-loan interest, site maintenance, frozen capital and the risk that the market cycle closes before your project sells.

Conclusion

For LatAm developers, brokers and institutional investors, separating sales velocity, absorption rate and months of supply — and connecting the three to NPV, IRR and projected cash flow — is the difference between operating on anecdote and operating on evidence. In markets where pre-sales and phased release distort pure metrics, and where city-level benchmarks still live in Softec, Tinsa and Colliers paid reports, having a web tool that runs the calculations, compares against reference corridors and projects cash-in month by month is the minimum infrastructure of a modern commercial team.

Illustrative case

Composite case for instructional purposes: combines sector dynamics with realistic figures. Names are fictional and do not represent a specific company.

Case: Torre Capitán 72 — vertical residential project, Nuevo Polanco, Mexico City

Grupo Desarrollador Albor launched Torre Capitán 72 in March 2024, a 72-unit residential project of 72-124 m² in Nuevo Polanco, average price USD 4,800/m² and average ticket USD 425,000. The mix was 40 units of 72-88 m² (DINK/single professional segment) and 32 units of 95-124 m² (young family segment). Total investment USD 24M, with 30% equity (USD 7.2M) and 70% bridge loan (USD 16.8M) at TIIE+4.5 (roughly 15.5%) for 30 months.

In the first 6 months they sold 13 units — velocity 2.2 units/month, monthly absorption 3.1%, DR90 of only 9.7%. Softec's base corridor for Nuevo Polanco vertical in that segment was 4%-6% absorption and 16%-20% DR90. Albor was in the red. Projecting at the same velocity, estimated months of supply were 27 — with a 30-month bridge loan, the margin was non-existent.

The CFO loaded the data into the simulator in developer mode and compared three corrective scenarios:

  • A — 8% across-the-board price cut: projected absorption would rise to 4.0%, months of supply to 15, but NPV dropped USD 1.6M.
  • B — Phased release + selective reprice: release only the 30 remaining units in phase 2, adjust price on large units (-5%) and hold small ones, add an amenity package USD 180,000. Projected absorption 4.8%, months of supply 11, NPV −USD 0.6M vs original plan.
  • C — 3-bank express approval agreement + sales-office remodel + external broker with overrides: no price change, investment USD 220,000, projected absorption 4.5%, months of supply 12, NPV nearly neutral.

Albor executed the B + C combination. In the next 10 months they sold 42 additional units — velocity 4.2 units/month, absorption 5.8% over inventory released in phase 2. Phase 2 DR90 was 23%. The project closed with 55 of 72 units sold at 16 months from launch; the remaining 17 were placed in the next 8 months. Final equity IRR was 17.8%, vs 22% in the original plan but well above the 4% projected at month 6. The difference was made by separating velocity, absorption and months of supply, measuring them against a zonal benchmark, and executing before the bridge loan exhausted the cushion.

From theory to calculation

When you need more than a quick calculation, our advanced simulators model full scenarios with your data.

See advanced simulators

Sector reference ranges

Indicative ranges based on public sector literature and operational observation. Your business may differ — use the numbers as a starting point, not as a target.

MetricValueSource
Healthy monthly absorption — premium vertical, CDMX4-8 units/monthSoftec Reporte Vivienda Vertical México 2024
Average DR90 — vertical LatAm14-22%Tinsa LatAm Observatorio Residencial 2024
Stabilized residential cap rate — CDMX5-7%Colliers México Mercado de Capitales Q4 2024
Healthy spread — development vs stabilized cap rate200-400 bpsCBRE Cap Rate Survey México H2 2024
Seller's market monthly absorption threshold>20%National Association of Realtors Glossary / Rocket Mortgage
Healthy reservation-to-closing conversion — LatAm vertical70-85%JLL Residential Markets Latin America 2024
Balanced months of supply5-7 monthsULI Emerging Trends in Real Estate Latin America 2024
Average construction cost overrun — Mexico12-25%AMPI Reporte Anual Construcción Residencial 2024

Frequently asked questions

1What is real estate sales velocity?
It is the absolute number of units sold per unit of time, typically a month. A project that sells 4 units/month has a sales velocity of 4. It is the sales team's operational metric, distinct from absorption rate (percentage) and months of supply (time remaining to sell-out).
2How is absorption rate calculated in real estate?
Formula: Monthly absorption (%) = (Units sold in the month ÷ Total available inventory) × 100. Example: 4 units sold out of 80 available = 5% monthly absorption. Above 20% the market is classified as a seller's market; 15%-20% neutral; below 15% buyer's market.
3What is a good sales velocity for a project?
It depends on segment and city. For Mexico City premium vertical, the base corridor is 3.5%-5.5% monthly absorption (equivalent to 2.8-4.4 units/month on 80-unit inventory). For LatAm affordable housing projects the benchmark is higher, 6%-9% monthly due to the mass buyer profile.
4How many months of inventory are healthy in a development?
Between 6 and 9 months of inventory is considered balanced. Under 6 indicates a tight market (upward price pressure); more than 12 signals excess supply that will drag prices down in 2-4 quarters. Source: ULI Emerging Trends LatAm 2024.
5What is the difference between sales velocity and absorption rate?
Sales velocity is absolute (units/month); absorption rate is relative (% of total inventory). They are complementary: a 40-unit project selling 2/month has 5% absorption; a 200-unit project selling 10/month also has 5% despite selling 5x faster in absolute terms. Absorption allows comparing projects of different sizes.
6How do you project the time to sell out an inventory of units?
Months of supply = Remaining inventory ÷ Sales velocity. Example: 56 remaining units ÷ 4 units/month = 14 months to sell-out if the pace holds. The simulator runs three scenarios (optimistic, base, pessimistic) with variable absorption to bracket the exit range.
7What factors affect pre-sale sales velocity?
Five main drivers: (1) proximity to mass transit (+20%-35% vs off-corridor), (2) product mix aligned with demographic demand, (3) price per m² inside the 90%-110% range of the zone comp, (4) financing strategy with bank partnership, (5) amenities aligned with the target segment.
8How do you compare sell-through rate across projects?
Sell-through rate = cumulative units sold ÷ total inventory × 100. Compared at cutoff dates (90 days = DR90, 180 days = DR180, 365 days = DR365). For healthy LatAm vertical, DR90 is 14%-22% and DR365 is 50%-70%. It allows comparing projects of different sizes and zones on a common base.
9What does a seller's market mean in real estate?
A market where demand exceeds supply: monthly absorption above 20%, under 6 months of inventory. Prices rise, discounts disappear, buyers compete. The opposite — a buyer's market — happens with absorption below 15% and more than 9 months of inventory: downward price pressure and long sales cycles.
10How do you accelerate sales in a stalled project?
No diagnosis, no recipe. Alert signals: 3 months of absorption below 60% of the base corridor. Typical diagnosis: price out of market, misaligned product, slow closing process, damaged reputation, suboptimal sales force. Solutions ordered by cost: selective reprice, phased release, express bank agreement, amenities investment, external broker with overrides.

Tools from the same topical cluster. Use them together to close the loop on your analysis.

Last updated: April 30, 2026 · Reviewed by the Simúlalo editorial team. Figures and benchmarks are indicative; verify with your own data before deciding.

View methodology