Blog · Finance metrics and formulas
Property sales velocity measures net unit sales over a defined period. Use developer exports to reconcile contracts, cancellations and available inventory, then compare project pace and months of supply.
Sales velocity in real estate measures how many property units sell during a defined period. For a developer's contract-based report, use new contracts minus cancellations and state the elapsed time. Keep the remaining unsold inventory beside the pace so commercial teams can see both current movement and remaining exposure.
Net unit sales = New unit contracts − Canceled unit contracts
Net sales velocity = Net unit sales / Elapsed reporting months
This article uses signed sales contracts as the event, cancellations recorded during the month as reversals, and whole calendar months as the time base. A reservation, a signed contract and a closing are separate stages. Choose one stage for each measure and do not switch stages between projects.
The operating report is not a revenue recognition schedule. A signed contract may precede construction completion and closing, so accounting revenue should retain its own recognition rules. The commercial question here is how quickly units become committed, after reversals.
This also differs from the four-factor CRM sales velocity formula, which describes pipeline economics using opportunities, values, win rates and cycle length. The sales velocity glossary provides the broader terminology.
Bring a unit register, contract activity report and available-inventory snapshots. Retain project, building or phase, unique unit identifier, contract identifier, contract date, cancellation date, release-to-market date and availability status. Count physical units rather than contract documents when a contract can cover several units.
Use the contract and cancellation events to construct monthly movement. Use inventory snapshots to prove that movement. A canceled unit re-enters this report's available inventory only when it is available for sale again; units withheld for repair or another reason need a separate adjustment.
The Census Bureau's New Residential Sales report distinguishes houses sold during a period from houses for sale at period end. That stock-versus-flow distinction also belongs in an internal project report, even when your operating definitions differ from the national survey.
Sales operations should own status accuracy, project teams should confirm releases and withdrawals, and finance should reconcile the snapshots. A common month-end cutoff prevents late changes in one file from leaving the others behind.
A fictional US developer reviews Oak and Pine. All numbers below count property units. Released units become available during the month, and all cancellations shown return units to available inventory. There are no other inventory adjustments.
| Month | Project | Opening available | Newly released | New contracts | Cancellations | Net sales | Ending available |
|---|---|---|---|---|---|---|---|
| September 2026 | Oak | 60 | 10 | 14 | 2 | 12 | 58 |
| September 2026 | Pine | 30 | 0 | 8 | 1 | 7 | 23 |
| October 2026 | Oak | 58 | 6 | 15 | 3 | 12 | 52 |
| October 2026 | Pine | 23 | 4 | 10 | 2 | 8 | 19 |
The October portfolio calculation is:
| Step | Calculation | Result |
|---|---|---|
| Sum new contracts | 15 + 10 | 25 units |
| Sum cancellations | 3 + 2 | 5 units |
| Calculate net sales | 25 − 5 | 20 units |
| Divide by the reporting duration | 20 / 1 calendar month | 20 units/month |
Oak's October pace is 12 units per month, and Pine's is 8. Add the projects' net units and divide by the common reporting month. Do not add overlapping project-month durations when calculating the portfolio's sales pace.
For a spreadsheet using the table layout above, net sales in G2 are =E2-F2, and ending available inventory in H2 is =C2+D2-G2. To total October net sales from rows 2:5, with month labels in A, =SUMPRODUCT((A2:A5="October 2026")*G2:G5) returns the period total. Microsoft's SUMPRODUCT documentation explains both summing corresponding products and applying criteria within that calculation.
Ending available units = Opening available units + Newly released units − New contracts + Cancellations returned to availability
October opens with 58 + 23 = 81 available units. Releases add 6 + 4 = 10. New contracts remove 25, and cancellations return 5. The result is 81 + 10 − 25 + 5 = 71 ending units, agreeing with 52 + 19 in the unit register.
September also reconciles: opening inventory is 60 + 30 = 90, releases are 10, new contracts are 14 + 8 = 22, and cancellations are 2 + 1 = 3. Ending inventory is 90 + 10 − 22 + 3 = 81. That ending balance becomes October's opening balance.
If either identity fails, look for a missing release, duplicate unit, withdrawn listing or cancellation that did not return to the market. A plausible sales rate cannot repair an inconsistent unit register.
Velocity tells the commercial manager how quickly units are selling. Months of supply describes the ending inventory relative to that observed pace:
Months of supply = Ending available units / Net units sold per month
| Month | Net units sold | Ending available | Velocity, units/month | Months of supply |
|---|---|---|---|---|
| September 2026 | 19 | 81 | 19 | 4.26 |
| October 2026 | 20 | 71 | 20 | 3.55 |
Months of supply is rounded to two decimals. September is 81 / 19 = 4.26; October is 71 / 20 = 3.55. This is a static coverage calculation at the observed pace, not a promise about when inventory will sell.
For an explicitly defined absorption percentage, use October net sales divided by opening available units plus releases: 20 / (81 + 10) = 21.98%. That denominator represents the period's starting inventory and newly released units; it is not an average daily inventory measure. Keep the label attached whenever you share it.
Gross contracts grew by 25 / 22 − 1 = 13.64%, while net sales grew by 20 / 19 − 1 = 5.26%. Cancellations explain why the gross headline looks stronger. Do not divide cancellations by current contracts and call it a cohort failure rate when some cancellations concern older contracts.
The real estate dashboards guide covers the wider operating view. For unit movement based on stores rather than projects, see the retail sales velocity formula.
Covirage is not affiliated with Microsoft.
Bring a sample of your own contract activity, cancellations and unit-inventory exports to Covirage. Covirage maps the columns, and its tools compute net selling pace and check the inventory reconciliation; the external AI model explains project comparisons with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your files.
See Covirage for forecast analysis for the supporting planning context.
Unit velocity expresses sales per period. An absorption percentage compares sales with a defined inventory population during that period. The measures share sales inputs but have different denominators, so specify whether a report means units per month or a percentage of available units.
Use contracts to track current selling activity and closings to track completed transactions. Maintain both measures when needed, with separate date and status rules. Substituting closings for contracts can make the sales trend reflect construction or settlement timing instead of new commitments.
Net sales become negative for that period. Show the negative result and reconcile the returned units to available inventory. A months-of-supply calculation based on nonpositive net sales is not a useful depletion estimate and should be marked undefined rather than forced into a positive number.