Detention Comparison Model

Cash benefit

Civil cost benefit plus schedule savings.

Build and stabilize

Cash benefit plus asset appreciation.

Land-only benefit

Cash benefit plus raw land recovery.

Value impact

Average of the two benefit scenarios over project budget.

Executive Dashboard

Roll-up totals use the Excel workbook's savings convention: positive values are favorable.

Cash and land recoveryValue
Traditional civil cost
Integrated system civil cost
Civil cost benefit
Schedule benefit
Total cash benefit
Raw land recovery value
Asset appreciation benefit

Detention and Civil Cost Comparison

Traditional pond, paving, and contingency compared with the integrated system.

Input / OutputTraditionalIntegrated SystemDelta

Land and Income Value

Recovered constrained land converted into raw land value or incremental income-producing SF.

Land metricValue
Traditional constrained land
Integrated constrained land
Land recovered
Incremental building footprint
Raw land recovery benefit
Lease / cap value engineValue
Annual effective base rent
Annual effective gross income
Annual operating expenses
Annual NOI
Stabilized asset value
Asset value per incremental SF

Schedule and Carry Impact

GC cost savings and interest carry savings from shortening the civil critical path.

Schedule itemTraditionalIntegrated
Civil-driven critical path
Weeks saved0.00
GC cost savings$0
Interest carry savings$0
Total schedule savings$0
Client framingUse financial language around cash savings, schedule compression, and asset value.
Design impactChanging detention rate and pond assumptions updates detention volume and constrained land.
Income upsideSet the conversion factor to 0 if recovered land cannot support more vertical development.

Sensitivity: Civil Cost Delta

Integrated system after contingency minus traditional after contingency. Negative values mean the integrated system is cheaper.