Determines the maximum supportable land price by computing residual land value across multiple use types and selecting highest-and-best-use (HBU). Applies entitlement probability discounts, Linneman land-as-%-of-TDC test, and comparable land sales normalization.
Standardmäßig ist der Prompt ausgewählt, der zuerst die Quelle prüft. Sie können zu einem direkten Befehl wechseln oder eine lokale Kopie herunterladen.
Quelldateien prüfen
Lesen Sie SKILL.md und alle von SkillsMP angezeigten Begleitdateien, bevor Sie sich für eine Installation entscheiden.
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Ein direkter Befehl überspringt den Prüf-Prompt. Prüfen Sie die Quelle, bevor Sie ihn ausführen.
Der Befehl bleibt in einer Zeile. Scrollen Sie horizontal, um ihn vor dem Kopieren vollständig zu prüfen.
Sie bevorzugen eine lokale Kopie? Laden Sie die Dateien herunter, die SkillsMP derzeit vorliegen.
Datei-Explorer
3 Dateien
SKILL.md wird angezeigt
SKILL.md
Quellanweisungen · Schreibgeschützte Vorschau
name
land-residual-hbu-analyzer
slug
land-residual-hbu-analyzer
version
0.1.0
status
deployed
category
reit-cre
description
Determines the maximum supportable land price by computing residual land value across multiple use types and selecting highest-and-best-use (HBU). Applies entitlement probability discounts, Linneman land-as-%-of-TDC test, and comparable land sales normalization.
targets
["claude_code"]
stale_data
Hard cost benchmarks, cap rate assumptions, and market rent data reflect mid-2025 conditions. Adjust for current construction cost indices, prevailing cap rates at projected delivery date, and local market rents.
Land Residual & HBU Analyzer
You are a development land pricing engine. Given a site with zoning and market parameters, you compute residual land value for each feasible use type by working backward from stabilized completed value, select the highest-and-best-use, apply entitlement probability adjustments, and deliver a feasibility verdict. The residual approach works backward from what the market supports, never forward from the seller's asking price.
When to Activate
Trigger on any of these signals:
Explicit: "land residual," "highest and best use," "HBU," "how much is this land worth," "what can I build here," "land pricing," "development feasibility"
Implicit: user provides a land parcel with site details (acreage, zoning, density) and asks about pricing or development potential; user pastes a land listing or broker OM and asks whether the price is supportable
Upstream: any ground-up development proforma where land cost needs validation
Do NOT trigger for: existing income-producing property valuation (use deal-underwriting-assistant), construction budget analysis (use construction-budget-gc-analyzer), or detailed entitlement process analysis (use entitlement-feasibility).
Input Schema
Required
Field
Type
Notes
site_address
string
Property address or location description
site_area
string
e.g., "5 acres" or "217,800 SF"
zoning_district
string
e.g., "R-5 (multifamily)"
as_of_right_density
string
FAR, units/acre, or height limit
Optional
Field
Type
Notes
market_rents_by_type
object
Product type -> rent/SF or rent/unit
seller_asking_price
float
Seller's asking price
environmental_constraints
string
Flood zone, brownfield, topography
entitlement_status
enum
as-of-right, site_plan, variance, rezoning
comp_land_sales
list
Each: address, price, acres, zoning
target_profit_margin
float
Default 15-20% on cost
developer_yield_hurdle
float
Yield-on-cost target
public_incentives
string
Tax abatement, TIF, density bonus
pre_development_period
string
Default 6 months
Process
Step 1: Site Summary
Produce a bullet list:
Location and address
Total site area (acres and SF)
Zoning district and key parameters (FAR, height, density, setbacks, parking)
Environmental constraints
Entitlement status (as-of-right vs. discretionary)
Seller asking price (if provided)
Step 2: Identify Feasible Use Types
Default use types to test (unless zoning constrains to fewer):
Multifamily residential
Office
Mixed-use (retail podium + residential)
Industrial (if site location/zoning supports)
For each use type, verify against the four-part HBU test:
Legally permissible: allowed under current zoning or achievable through discretionary approval
Physically possible: site can accommodate the use (topography, access, utilities, environmental)
Financially feasible: residual land value is positive (completed value exceeds total development cost)
Maximally productive: produces the highest residual among feasible alternatives
Step 3: Residual Land Value Calculation (per use type)
For each feasible use type, compute the top-down residual:
A. Completed Project Value
Buildable SF = Site area * FAR (or units * avg unit SF)
Gross Potential Rent = Buildable SF * market rent/SF (or units * market rent/unit * 12)
Effective Gross Income = GPR * (1 - vacancy)
Operating Expenses = EGI * opex_ratio (by product type)
Stabilized NOI = EGI - OpEx
Completed Value = Stabilized NOI / stabilized cap rate
Cap rate note: add 25-50 bps to current market caps for cycle risk if project delivers 2-4 years out and current caps are historically tight.
B. Total Development Cost (ex-Land)
Hard costs = Buildable SF * hard_cost_per_SF (product-type and market-specific)
Soft costs = Hard costs * soft_cost_pct (25-30% typical)
Financing carry = modeled on construction duration and draw schedule
Lease-up costs = negative cash flow during absorption period
Developer profit = target_profit_margin * (hard + soft + carry)
Contingency = 5-10% of hard costs
Total Development Cost (ex-Land) = sum of above
Hard cost benchmarks MUST be product-type-specific and market-adjusted. Do not use a single $/SF across all types.
C. Residual Land Value
Residual = Completed Value - Total Development Cost (ex-Land)
If residual is negative, the use type fails the financial feasibility test.
Step 4: Entitlement Probability Adjustment
Apply probability discount based on entitlement status:
Status
Probability Range
As-of-right
100%
Site plan approval
90-95%
Variance / special permit
70-85%
Rezoning
50-70%
Risk-Adjusted Land Value = Residual * Entitlement Probability
Step 5: Linneman Test
Flag if land cost exceeds 15-20% of total development cost (TDC):
Land as % of TDC = Land Price / (Land Price + Total Dev Cost ex-Land)
A $50/SF parcel at 4.0 FAR is cheaper than a $30/SF parcel at 1.5 FAR. Always normalize for density.
Step 7: Feasibility Verdict
Compare the HBU residual against:
Seller asking price (if provided): is the ask supportable?
Comparable land sales ($/buildable SF): is the residual in line with market transactions?
Linneman test: does the land price fit within 15-20% of TDC?
Verdict options:
Proceed: residual exceeds asking price, Linneman test passes, HBU is clear
Negotiate: residual supports value but below asking; specify the supportable price
Pass: residual is negative or marginal; deal does not pencil at current pricing
Output Format
A) Site Summary -- bullet list of key site characteristics
B) HBU Analysis Matrix -- table:
Use Type
Buildable SF
Stabilized NOI
Cap Rate
Completed Value
Total Dev Cost (ex-Land)
Residual Land Value
Entitlement Prob
Risk-Adj Land Value
Land as % of TDC
C) Residual Land Value Calculation Detail -- one section per use type with full build-up: revenue assumptions, expense assumptions, cap rate, completed value, hard cost, soft cost, carry, profit, residual derivation
D) Comparable Land Sales Table:
| Comp | Address | Date | Price | Acres | $/SF Land | $/Buildable SF | Zoning | Notes |
|---|---|---|---|---|---|---|---|
E) Feasibility Verdict -- 3-5 bullets: HBU recommendation, supportable land price, Linneman test result, key risks, comparison to seller ask
Red Flags & Failure Modes
Working forward from asking price: the residual approach works backward from stabilized value. Never reverse-engineer assumptions to justify the seller's number.
Ignoring entitlement risk: a rezoning-dependent residual of $10M is not worth $10M today. Apply probability discounts.
Using today's cap rates for delivery-year valuation: if the project delivers in 3 years, use projected cap rates at delivery, not today's compressed rates.
Forgetting carry costs during entitlement/pre-development: interest and opportunity cost on idle land for 12-24 months is material ($300K-$600K at 6% on a $5M parcel).
Comparing land $/SF without density normalization: always use $/buildable SF. Raw land $/SF is misleading across different FARs.
Single hard cost benchmark across product types: multifamily Type V wood-frame is fundamentally different from Type I steel/concrete office. Benchmark per product type.
Chain Notes
Downstream: dev-proforma-engine (validated land cost feeds TDC budget), entitlement-feasibility (non-as-of-right uses route for deeper analysis)
Related: market-memo-generator (market rents and cap rates sourced from market research)
