Subdivision Profit Calculator Formula

Understand the math behind the subdivision profit calculator. Each variable explained with a worked example.

Use the Subdivision Profit Calculator

Formulas Used

Net Profit

profit = net_profit

Profit Margin

profit_margin = gross_revenue > 0 ? (net_profit / gross_revenue) * 100 : 0

Return on Investment

roi = total_dev_cost > 0 ? (net_profit / total_dev_cost) * 100 : 0

Total Gross Revenue

total_revenue = gross_revenue

Total All-In Costs

total_all_costs = total_costs

Lots Per Month

absorption_rate = lots_per_month

Variables

VariableDescriptionDefault
total_dev_costTotal Development Cost(USD)1500000
num_lotsNumber of Finished Lots25
avg_lot_sale_priceAverage Lot Sale Price(USD)85000
selling_cost_pctSelling Costs (% of revenue)(%)6
absorption_monthsExpected Absorption (months)24
monthly_carry_costMonthly Carry Cost(USD)8000
gross_revenueDerived value= num_lots * avg_lot_sale_pricecalculated
selling_costsDerived value= gross_revenue * selling_cost_pct / 100calculated
carry_costsDerived value= absorption_months * monthly_carry_costcalculated
total_costsDerived value= total_dev_cost + selling_costs + carry_costscalculated
net_profitDerived value= gross_revenue - total_costscalculated
lots_per_monthDerived value= absorption_months > 0 ? num_lots / absorption_months : 0calculated

How It Works

Subdivision Profit Analysis

Subdivision development involves purchasing raw land, improving it with infrastructure, and selling individual lots to builders or homebuyers.

Formula

Net Profit = Gross Revenue - Development Cost - Selling Costs - Carry Costs

Absorption Rate

The absorption rate (lots sold per month) is critical because it determines how long your capital is tied up and how much you spend on carrying costs. A faster absorption means:

  • Lower total carry costs
  • Faster return of capital
  • Reduced market risk

    • Target Returns

  • Most developers target 15-25% profit margin on gross revenue
  • ROI of 20-40% on invested capital is typical for successful projects
  • Higher risk projects (uncertain entitlement, longer timelines) need higher target returns

    • Phasing Strategy

    Larger subdivisions are often developed in phases to reduce risk and capital requirements. Revenue from early phases helps fund later phases.

    Worked Example

    $1,500,000 total development cost, 25 lots at $85,000 each, 6% selling costs, 24-month absorption, $8,000/month carry costs.

    total_dev_cost = 1500000num_lots = 25avg_lot_sale_price = 85000selling_cost_pct = 6absorption_months = 24monthly_carry_cost = 8000
    1. 01Gross revenue: 25 x $85,000 = $2,125,000
    2. 02Selling costs: $2,125,000 x 6% = $127,500
    3. 03Carry costs: 24 x $8,000 = $192,000
    4. 04Total costs: $1,500,000 + $127,500 + $192,000 = $1,819,500
    5. 05Net profit: $2,125,000 - $1,819,500 = $305,500
    6. 06Profit margin: $305,500 / $2,125,000 = 14.4%
    7. 07ROI: $305,500 / $1,500,000 = 20.4%
    8. 08Absorption rate: 25 / 24 = 1.04 lots/month

    Ready to run the numbers?

    Open Subdivision Profit Calculator