land-residual-hbu-analyzer

Name: land-residual-hbu-analyzer
Author: mariourquia

36stars12forks

How to install land-residual-hbu-analyzer?

mariourquia/cre-skills-plugin/land-residual-hbu-analyzer

$npx -y skills add mariourquia/cre-skills-plugin --skill land-residual-hbu-analyzer

Installs into the current project.

Summary

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.

Files · 1

View on GitHub

SKILL.md

1	# Land Residual & HBU Analyzer
2
3	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.
4
5	## When to Activate
6
7	Trigger on any of these signals:
8
9	- Explicit: "land residual," "highest and best use," "HBU," "how much is this land worth," "what can I build here," "land pricing," "development feasibility"
10	- 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
11	- Upstream: any ground-up development proforma where land cost needs validation
12
13	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).
14
15	## Input Schema
16
17	### Required
18
19	\| Field \| Type \| Notes \|
20	\|---\|---\|---\|
21	\| `site_address` \| string \| Property address or location description \|
22	\| `site_area` \| string \| e.g., "5 acres" or "217,800 SF" \|
23	\| `zoning_district` \| string \| e.g., "R-5 (multifamily)" \|
24	\| `as_of_right_density` \| string \| FAR, units/acre, or height limit \|
25
26	### Optional
27
28	\| Field \| Type \| Notes \|
29	\|---\|---\|---\|
30	\| `market_rents_by_type` \| object \| Product type -> rent/SF or rent/unit \|
31	\| `seller_asking_price` \| float \| Seller's asking price \|
32	\| `environmental_constraints` \| string \| Flood zone, brownfield, topography \|
33	\| `entitlement_status` \| enum \| as-of-right, site_plan, variance, rezoning \|
34	\| `comp_land_sales` \| list \| Each: address, price, acres, zoning \|
35	\| `target_profit_margin` \| float \| Default 15-20% on cost \|
36	\| `developer_yield_hurdle` \| float \| Yield-on-cost target \|
37	\| `public_incentives` \| string \| Tax abatement, TIF, density bonus \|
38	\| `pre_development_period` \| string \| Default 6 months \|
39
40	## Process
41
42	### Step 1: Site Summary
43
44	Produce a bullet list:
45	- Location and address
46	- Total site area (acres and SF)
47	- Zoning district and key parameters (FAR, height, density, setbacks, parking)
48	- Environmental constraints
49	- Entitlement status (as-of-right vs. discretionary)
50	- Seller asking price (if provided)
51
52	### Step 2: Identify Feasible Use Types
53
54	Default use types to test (unless zoning constrains to fewer):
55	1. Multifamily residential
56	2. Office
57	3. Mixed-use (retail podium + residential)
58	4. Industrial (if site location/zoning supports)
59
60	For each use type, verify against the four-part HBU test:
61	- Legally permissible: allowed under current zoning or achievable through discretionary approval
62	- Physically possible: site can accommodate the use (topography, access, utilities, environmental)
63	- Financially feasible: residual land value is positive (completed value exceeds total development cost)
64	- Maximally productive: produces the highest residual among feasible alternatives
65
66	### Step 3: Residual Land Value Calculation (per use type)
67
68	For each feasible use type, compute the top-down residual:
69
70	A. Completed Project Value
71	```
72	Buildable SF = Site area * FAR (or units * avg unit SF)
73	Gross Potential Rent = Buildable SF * market rent/SF (or units * market rent/unit * 12)
74	Effective Gross Income = GPR * (1 - vacancy)
75	Operating Expenses = EGI * opex_ratio (by product type)
76	Stabilized NOI = EGI - OpEx
77	Completed Value = Stabilized NOI / stabilized cap rate
78	```
79
80	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.
81
82	B. Total Development Cost (ex-Land)
83	```
84	Hard costs = Buildable SF * hard_cost_per_SF (product-type and market-specific)
85	Soft costs = Hard costs * soft_cost_pct (25-30% typical)
86	Financing carry = modeled on construction duration and draw schedule
87	Lease-up costs = negative cash flow during absorption period
88	Developer profit = target_profit_margin * (hard + soft + carry)
89	Contingency = 5-10% of hard costs
90	Total Development Cost (ex-Land) = sum of above
91	```
92
93	Hard cost benchmarks MUST be product

People who liked this also viewed

6 picks

Type

land-residual-hbu-analyzer

36stars12forks

View on GitHub

How to install land-residual-hbu-analyzer?

mariourquia/cre-skills-plugin/land-residual-hbu-analyzer

$npx -y skills add mariourquia/cre-skills-plugin --skill land-residual-hbu-analyzer

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# Land Residual & HBU Analyzer
2
3	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.
4
5	## When to Activate
6
7	Trigger on any of these signals:
8
9	- Explicit: "land residual," "highest and best use," "HBU," "how much is this land worth," "what can I build here," "land pricing," "development feasibility"
10	- 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
11	- Upstream: any ground-up development proforma where land cost needs validation
12
13	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).
14
15	## Input Schema
16
17	### Required
18
19	\| Field \| Type \| Notes \|
20	\|---\|---\|---\|
21	\| `site_address` \| string \| Property address or location description \|
22	\| `site_area` \| string \| e.g., "5 acres" or "217,800 SF" \|
23	\| `zoning_district` \| string \| e.g., "R-5 (multifamily)" \|
24	\| `as_of_right_density` \| string \| FAR, units/acre, or height limit \|
25
26	### Optional
27
28	\| Field \| Type \| Notes \|
29	\|---\|---\|---\|
30	\| `market_rents_by_type` \| object \| Product type -> rent/SF or rent/unit \|
31	\| `seller_asking_price` \| float \| Seller's asking price \|
32	\| `environmental_constraints` \| string \| Flood zone, brownfield, topography \|
33	\| `entitlement_status` \| enum \| as-of-right, site_plan, variance, rezoning \|
34	\| `comp_land_sales` \| list \| Each: address, price, acres, zoning \|
35	\| `target_profit_margin` \| float \| Default 15-20% on cost \|
36	\| `developer_yield_hurdle` \| float \| Yield-on-cost target \|
37	\| `public_incentives` \| string \| Tax abatement, TIF, density bonus \|
38	\| `pre_development_period` \| string \| Default 6 months \|
39
40	## Process
41
42	### Step 1: Site Summary
43
44	Produce a bullet list:
45	- Location and address
46	- Total site area (acres and SF)
47	- Zoning district and key parameters (FAR, height, density, setbacks, parking)
48	- Environmental constraints
49	- Entitlement status (as-of-right vs. discretionary)
50	- Seller asking price (if provided)
51
52	### Step 2: Identify Feasible Use Types
53
54	Default use types to test (unless zoning constrains to fewer):
55	1. Multifamily residential
56	2. Office
57	3. Mixed-use (retail podium + residential)
58	4. Industrial (if site location/zoning supports)
59
60	For each use type, verify against the four-part HBU test:
61	- Legally permissible: allowed under current zoning or achievable through discretionary approval
62	- Physically possible: site can accommodate the use (topography, access, utilities, environmental)
63	- Financially feasible: residual land value is positive (completed value exceeds total development cost)
64	- Maximally productive: produces the highest residual among feasible alternatives
65
66	### Step 3: Residual Land Value Calculation (per use type)
67
68	For each feasible use type, compute the top-down residual:
69
70	A. Completed Project Value
71	```
72	Buildable SF = Site area * FAR (or units * avg unit SF)
73	Gross Potential Rent = Buildable SF * market rent/SF (or units * market rent/unit * 12)
74	Effective Gross Income = GPR * (1 - vacancy)
75	Operating Expenses = EGI * opex_ratio (by product type)
76	Stabilized NOI = EGI - OpEx
77	Completed Value = Stabilized NOI / stabilized cap rate
78	```
79
80	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.
81
82	B. Total Development Cost (ex-Land)
83	```
84	Hard costs = Buildable SF * hard_cost_per_SF (product-type and market-specific)
85	Soft costs = Hard costs * soft_cost_pct (25-30% typical)
86	Financing carry = modeled on construction duration and draw schedule
87	Lease-up costs = negative cash flow during absorption period
88	Developer profit = target_profit_margin * (hard + soft + carry)
89	Contingency = 5-10% of hard costs
90	Total Development Cost (ex-Land) = sum of above
91	```
92
93	Hard cost benchmarks MUST be product

People who liked this also viewed

6 picks

Type