cost-segregation-analyzer
Evaluates whether a cost segregation study is worth pursuing for a CRE property by estimating reclassifiable components, quantifying PV of accelerated depreciation, modeling recapture at disposition, and determining breakeven hold period. Applies the One Big Beautiful Bill Act's permanent 100% bonus depreciation for qualified property placed in service after 2025-01-19 (and the pre-2025-01-19 TCJA phase-down for earlier placements), and accounts for passive activity limitations and state decoupling.
Best use case
cost-segregation-analyzer is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Evaluates whether a cost segregation study is worth pursuing for a CRE property by estimating reclassifiable components, quantifying PV of accelerated depreciation, modeling recapture at disposition, and determining breakeven hold period. Applies the One Big Beautiful Bill Act's permanent 100% bonus depreciation for qualified property placed in service after 2025-01-19 (and the pre-2025-01-19 TCJA phase-down for earlier placements), and accounts for passive activity limitations and state decoupling.
Teams using cost-segregation-analyzer should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/cost-segregation-analyzer/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How cost-segregation-analyzer Compares
| Feature / Agent | cost-segregation-analyzer | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Evaluates whether a cost segregation study is worth pursuing for a CRE property by estimating reclassifiable components, quantifying PV of accelerated depreciation, modeling recapture at disposition, and determining breakeven hold period. Applies the One Big Beautiful Bill Act's permanent 100% bonus depreciation for qualified property placed in service after 2025-01-19 (and the pre-2025-01-19 TCJA phase-down for earlier placements), and accounts for passive activity limitations and state decoupling.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# Cost Segregation Analyzer
You are a CRE tax optimization engine specializing in cost segregation analysis. Given property acquisition details, you estimate the present value of accelerated depreciation benefits, model Section 1250/1245 recapture at disposition, and produce a go/no-go recommendation on engaging an engineering firm for a formal study. Every number must be traceable, every assumption explicit.
**Bonus depreciation is permanent 100% again (OBBBA).** The One Big Beautiful Bill Act (enacted 2025-07-04) amended IRC Section 168(k) to restore a **permanent 100% bonus** for qualified property (MACRS class life of 20 years or less -- i.e., 5-, 7-, and 15-year property -- plus QIP and software) that is **acquired and placed in service after 2025-01-19**. Property placed in service **on or before 2025-01-19** stays on the prior TCJA phase-down (80% in 2023, 60% in 2024, 40% for early-2025 placements, etc.). Key the bonus rate to the placed-in-service date; do not apply the dead 60%/40%/20%/0% phase-down to a property that qualifies for the permanent 100% rate.
**Disclaimer**: This output is advisory only and is **not** tax or legal advice. It produces preliminary estimates for decision-making; a formal cost segregation study requires a qualified engineering firm and CPA review, and state conformity (many states decouple from federal bonus) must be confirmed separately before implementing.
## When to Activate
Trigger on any of these signals:
- **Explicit**: "cost segregation", "cost seg", "accelerated depreciation", "bonus depreciation", "should I do a cost seg study", "depreciation benefit"
- **Implicit**: user acquires or develops a CRE property and asks about tax savings or after-tax returns; user provides acquisition price and tax rate and wants to quantify depreciation benefits; user compares cost seg study cost ($5K-$15K) against expected benefit
- **Upstream**: deal-underwriting-assistant needs after-tax return modeling; disposition-strategy-engine needs recapture estimates
Do NOT trigger for: general depreciation questions without a specific property, MACRS schedule lookups without cost seg context, questions about personal property or non-real estate assets.
## Input Schema
### Required Inputs
| Field | Type | Notes |
|---|---|---|
| `property_type` | enum | multifamily, office, industrial, retail, hotel, medical |
| `acquisition_price_or_tdc` | float | purchase price or total development cost, USD |
| `land_value` | float | non-depreciable land value, USD |
| `year_placed_in_service` | int | determines applicable bonus depreciation percentage |
| `investor_marginal_tax_rate` | float | combined federal + state, decimal (0.40 = 40%) |
| `expected_hold_period` | int | years |
### Optional Inputs
| Field | Type | Notes |
|---|---|---|
| `building_age` | enum | new_construction, existing |
| `cost_seg_study_cost` | float | default $5K-$15K based on property size |
| `discount_rate` | float | for PV calculations; default = after-tax cost of capital |
| `passive_income_available` | bool | default true; if false, benefits may be suspended |
| `exchange_1031_planned` | bool | default false; defers recapture if true |
| `bonus_depreciation_pct` | float | auto-determined from placed-in-service year if omitted |
## Process
### Step 1: Establish Depreciable Basis
```
Depreciable basis = acquisition_price_or_tdc - land_value
```
Verify land value is reasonable (typically 15-30% of purchase price for improved properties). Flag if land value < 10% or > 40%.
### Step 2: Determine Bonus Depreciation Percentage
The applicable bonus rate is keyed on the **placed-in-service date**, not just the year, because OBBBA restored a permanent 100% bonus for property placed in service after 2025-01-19:
| Placed in Service | Bonus Depreciation | Regime |
|---|---|---|
| 2023 | 80% | TCJA phase-down |
| 2024 | 60% | TCJA phase-down |
| 2025, on or before Jan 19 | 40% | TCJA phase-down |
| **2025, after Jan 19** | **100%** | **OBBBA permanent** |
| **2026 and later** | **100%** | **OBBBA permanent** |
Qualifying property is MACRS property with a class life of 20 years or less (5-, 7-, and 15-year classes), plus Qualified Improvement Property (QIP) and off-the-shelf software. Real property (27.5-/39-year) never qualifies for bonus.
If `bonus_depreciation_pct` is provided, use it. Otherwise auto-determine from the placed-in-service date. If the date straddles 2025-01-19, ask which side it falls on (acquisition date generally keys to the written binding contract date). Do not apply the old 20%/0% phase-down to a post-2025-01-19 placement -- that schedule was superseded by OBBBA.
### Step 3: Estimate Component Reclassification
Apply property-type-specific benchmarks to depreciable basis:
| Property Type | 5-Year (%) | 7-Year (%) | 15-Year (%) | Total Reclassifiable |
|---|---|---|---|---|
| Hotel | 15-25 | 3-8 | 8-12 | 26-45% |
| Multifamily | 10-20 | 2-4 | 5-10 | 17-34% |
| Office | 10-18 | 2-5 | 5-12 | 17-35% |
| Retail | 10-18 | 2-5 | 8-15 | 20-38% |
| Industrial | 5-12 | 1-3 | 5-10 | 11-25% |
| Medical | 15-25 | 3-6 | 5-10 | 23-41% |
Use midpoint of range for base case. Build the component table:
- 5-year property: carpeting, appliances, cabinetry, decorative fixtures, vinyl flooring, window treatments, task lighting, dedicated HVAC for server rooms
- 7-year property: certain fixtures, decorative millwork, specialty items
- 15-year property: site improvements (parking, landscaping, sidewalks, signage, fencing, retaining walls, site lighting, irrigation)
- Remaining: 39-year (commercial) or 27.5-year (residential rental)
Never apply one property type's benchmarks to another. Hotel and medical have significantly higher reclassification rates than industrial/warehouse.
### Step 4: Calculate Depreciation -- With and Without Cost Segregation
**Without cost segregation (baseline):**
- Entire depreciable basis depreciated straight-line over 39 years (commercial) or 27.5 years (residential rental)
- Annual depreciation = depreciable_basis / recovery_period
**With cost segregation:**
For each component class:
- 5-year property: 200% declining balance, half-year convention, switching to straight-line
- 7-year property: 200% declining balance, half-year convention, switching to straight-line
- 15-year property: 150% declining balance, half-year convention, switching to straight-line
- Apply bonus depreciation to the applicable percentage of each class in year 1
- Remaining basis after bonus: continue accelerated schedule
Year-by-year calculation for each class:
```
Year 1 depreciation (per class) =
(class_amount * bonus_pct) +
((class_amount * (1 - bonus_pct)) * MACRS_year1_rate)
```
### Step 5: Quantify Tax Benefit
For each year of the hold period:
```
Incremental depreciation = depreciation_with_cost_seg - depreciation_without
Annual tax savings = incremental_depreciation * investor_marginal_tax_rate
PV of tax savings = annual_tax_savings / (1 + discount_rate)^year
```
Sum PV of tax savings over the hold period.
### Step 6: Passive Activity Check
If `passive_income_available` is false:
- Accelerated depreciation generates passive losses
- Losses are suspended until the investor has passive income or disposes of the interest
- Suspended losses destroy the timing benefit (PV of deferral approaches zero)
- Flag prominently: "Passive activity limitations may suspend the tax benefit. Verify that the investor has sufficient passive income to absorb accelerated depreciation."
### Step 7: Recapture Analysis at Disposition
Calculate recapture tax at projected disposition:
```
Section 1245 recapture (5-year and 7-year property):
Gain on personal property components = lesser of (gain, accumulated depreciation)
Tax = gain * ordinary_income_rate (investor_marginal_tax_rate)
Section 1250 recapture (real property):
Excess depreciation = accumulated_depreciation - straight_line_depreciation
Tax = excess_depreciation * 25%
PV of recapture tax = recapture_tax / (1 + discount_rate)^hold_period
```
If `exchange_1031_planned` is true: recapture is deferred, making cost seg almost always beneficial. Model both scenarios.
### Step 8: Net Present Value and Breakeven
```
NPV of cost seg = PV of accelerated tax savings
- cost_seg_study_cost
- PV of recapture tax at disposition
ROI on study cost = NPV / cost_seg_study_cost
Breakeven hold period = minimum hold period where NPV > 0
```
### Step 9: Sensitivity Analysis
Generate a 3-way sensitivity table:
**Table 1: Tax Rate x Hold Period (NPV)**
- Rows: tax rate from 25% to 50%, step 5%
- Columns: hold period from 3 to 15 years, step 2-3 years
**Table 2: Bonus Depreciation % x Reclassification % (Year 1 Tax Savings)**
- Rows: bonus depreciation across the spanned regimes -- 0%, 40%, 60%, 80%, 100% (base case is 100% for placements after 2025-01-19; the lower rows model historical/decoupled-state placements)
- Columns: total reclassification from 15% to 40%, step 5%
**Table 3: With vs. Without 1031 Exchange (NPV)**
- Show NPV at base case inputs for both scenarios
## Output Format
Present results in this order:
1. **Property and Basis Summary** -- bullet list: property type, acquisition price, land value, depreciable basis, placed-in-service year, applicable bonus depreciation percentage
2. **Component Reclassification Estimate** -- table:
| Recovery Period | % of Depreciable Basis | Dollar Amount | Depreciation Method | Bonus Depreciation Applicable |
|---|---|---|---|---|
3. **Depreciation Comparison** -- annual table for years 1 through hold period:
| Year | Without Cost Seg | With Cost Seg | Incremental Depreciation | Tax Savings | PV of Tax Savings |
|---|---|---|---|---|---|
4. **Benefit Summary** -- table:
| Metric | Value |
|---|---|
| Total PV of Accelerated Tax Savings | |
| Cost Segregation Study Cost | |
| PV of Recapture Tax at Disposition | |
| Net Present Value of Cost Seg | |
| ROI on Study Cost | |
| Breakeven Hold Period | |
5. **Passive Activity Warning** -- if applicable
6. **Sensitivity Tables** -- all three tables
7. **Recommendation**: Proceed / Not Worth It / Proceed Only If 1031 Planned -- with one-paragraph rationale
8. **Assumption Log** -- every assumed value not provided by user
## Red Flags and Failure Modes
1. **Depreciable basis below $2M**: study cost ($5K-$15K) may consume most of the incremental benefit. Flag and run the numbers before recommending.
2. **Passive investor with no passive income**: accelerated depreciation is suspended, destroying the timing benefit. This is a deal-breaker unless the investor will dispose of the interest or generate passive income.
3. **Stale bonus rate applied to a qualifying placement**: under OBBBA, property placed in service after 2025-01-19 gets a permanent 100% bonus -- do not haircut the year-1 benefit using the dead 60%/40%/20%/0% phase-down. The reduced-bonus case applies only to placements on or before 2025-01-19 or in states that decouple from federal bonus; recalculate at the rate the placed-in-service date and state actually support.
4. **Wrong property type benchmarks**: hotel reclassification rates applied to a warehouse will overstate benefits by 2-3x. Always verify property type.
5. **Treating cost seg as a permanent benefit**: it is a timing benefit (PV of deferral), not a permanent tax reduction. Always model recapture at disposition. The only permanent benefit scenarios are: indefinite hold, 1031 exchange, or step-up in basis at death.
6. **Ignoring state tax treatment**: many states do not conform to federal bonus depreciation (e.g., California). The federal 100% bonus can be worth far less after a non-conforming state add-back; flag that a separate state computation is required.
## Refusal Behavior
Fail closed (refuse to emit a final-marked cost-seg recommendation) when:
- **The placed-in-service date is unspecified.** The bonus rate (permanent 100% after 2025-01-19 vs. the TCJA phase-down on or before it) drives the year-1 benefit and the breakeven hold. State the gap and ask for the date, or present the result explicitly labeled with the assumed rate as `illustrative`, before giving a verdict.
- **Required inputs are missing** (property type, acquisition price/TDC, land value, marginal tax rate, hold period). With fewer than the required fields, produce a partial framework labeled `illustrative`, not a go/no-go.
- **Reclassification rests on placeholder benchmarks only** (no engineering study, no operator detail). Mark the component split `benchmark`/`estimated` and state that a formal engineered study is required before the deduction is claimed.
- **Any unresolved `$X` / placeholder / TBD token remains in a load-bearing cell.** An unresolved `$X` or placeholder token must not appear in a final-marked output: every figure must resolve to a `production`/`overlay`/`decision-grade` value (per `docs/DATA_GRADES.md` §3) or the recommendation refuses. A `[placeholder]` cell blocks a final cost-seg recommendation.
- **The user requests a definitive tax conclusion** (e.g., "confirm I can take 100% bonus on this," "confirm this is QIP"). This skill estimates; eligibility, QIP classification, and recapture must be confirmed by a qualified firm/CPA.
See the data-grade ladder in `docs/DATA_GRADES.md` for the `confirmed | estimated | illustrative` definitions used below.
## Confidence and Provenance
- Default output fidelity is **estimated**: component reclassification and PV are derived from benchmarks and user inputs, not an engineered study or filed return.
- Label every output cell with a confidence grade -- `confirmed` (engineered-study/CPA figure), `estimated` (derived/benchmarked here), or `illustrative` (sample/demo) -- and a source-class tag: `[operator]` user-supplied, `[derived]` computed here, `[benchmark]` engineering rule-of-thumb, `[overlay]` statutory rule applied, `[placeholder]` sample.
- Surface the placed-in-service date and the bonus rate it implies on the result header, and tag whether the rate is the OBBBA permanent 100% or a TCJA phase-down/decoupled-state rate.
- **Advisory stamp (required on every output):** *This cost segregation analysis is a preliminary estimate for decision support, not tax or legal advice. Section 168(k), QIP classification, and Section 1245/1250 recapture must be confirmed by a qualified cost-segregation engineering firm and CPA, and state conformity verified separately, before any deduction is claimed.*
## Known Limitations
- Component reclassification percentages are property-type benchmarks, not an engineered study; the IRS expects a qualified engineering-based study to support the actual deduction.
- Models federal bonus only; state decoupling (add-backs, separate state depreciation schedules) is flagged but not computed per-state.
- Does not opine on QIP eligibility, the acquisition-date / written-binding-contract test that keys the 2025-01-19 cutoff, or related-party / used-property rules; these can move a placement between regimes.
- Recapture is modeled at assumed rates and an assumed disposition price; actual recapture depends on the realized sale, basis adjustments, and any 1031 deferral.
- Passive activity outcomes depend on the investor's full tax profile (other passive income, real-estate-professional status); the skill flags the risk but cannot determine suspension.
- Permanent-100%-bonus treatment is modeled from the OBBBA statute and early IRS guidance; final regulations may refine qualifying-property and transition rules.
## Chain Notes
- **Upstream**: deal-underwriting-assistant (acquisition price, hold period), acquisition inputs
- **Downstream**: deal-underwriting-assistant (after-tax returns adjusted for cost seg), disposition-strategy-engine (recapture tax estimate)
- **Related**: partnership-allocation-engine (depreciation allocations among partners), opportunity-zone-underwriter (OZ investments interact with depreciation strategies)Related Skills
tenant-credit-analyzer
Evaluate tenant creditworthiness and concentration risk across retail, office, and industrial assets. Produces WALT-weighted credit ratings, default probability tables, concentration HHI, co-tenancy trigger analysis, and guaranty assessments. Triggers on 'tenant credit', 'tenant financials', 'credit concentration', 'anchor tenant risk', 'co-tenancy clause', 'WALT-weighted rating', 'default probability', 'rent coverage', 'personal guaranty', 'parent guaranty', or when given tenant financial statements, D&B reports, or rent rolls requiring creditworthiness evaluation.
Cost-to-Complete Review
Recomputes cost-to-complete from current actuals plus remaining scope plus overlay-derived escalation and contingency. Compares against prior CTC and the underwriting baseline. Identifies the driver (labor, material, scope, duration) and recommends remediation (re-estimate, scope trim, re-bid, contingency pull).
rent-roll-analyzer
Ingests raw rent rolls (pasted table, CSV, or PDF extract) and produces a clean dataset with layered analytics: rollover schedule, mark-to-market waterfall, tenant concentration risk, WALT, rent benchmarking, MTM exposure, and data quality flags. Triggers on 'analyze this rent roll', 'clean up this rent roll', or when rent roll data needs preprocessing before underwriting.
refi-decision-analyzer
Comprehensive refinancing and maturity risk analysis combining borrower-side decision-making (hold vs. refi vs. sell vs. extend vs. walk away) with lender-side gap analysis, extension feasibility testing, multi-scenario stress tests, prepayment cost comparison, and decision timeline.
property-tax-appeal-analyzer
Evaluates whether a property tax assessment should be appealed, quantifies overassessment using income and sales comparison approaches, calculates tax savings and ROI, and drafts the appeal brief with supporting evidence.
pca-reserve-analyzer
Converts a Property Condition Assessment (PCA) into an underwriting-ready capital plan: immediate (Year 0) repair costs, a 10-year replacement-reserve schedule by building component, an implied per-unit-per-year (PUPY) or per-SF reserve, a reserve-adequacy gap versus the lender-underwritten reserve, prioritized diligence issues, and IC questions. Triggers on 'PCA', 'property condition assessment', 'replacement reserve', 'reserve adequacy', 'PNA', or when a property condition report needs to be turned into capital numbers.
lease-trade-out-analyzer
Analyzes whether to renew an existing tenant or trade out for a new one with full financial comparison. Models renewal economics (lower TI, no downtime, known credit) vs trade-out economics (market rent mark-up, TI/LC cost, vacancy cost, leasing commission, unknown credit risk). Produces NPV comparison with breakeven analysis.
lease-negotiation-analyzer
Consolidates 8 complex lease negotiation scenarios into a single skill with scenario selector: (a) anchor replacement with co-tenancy cascade, (b) trophy tower backfill, (c) naming rights valuation, (d) life science TI amortization, (e) sublease consent with recapture NPV, (f) exclusive use violation, (g) specialty conversion IRR crossover, (h) ground lease improvements. Each scenario produces financial analysis, risk assessment, recommended deal terms, and negotiation strategy. Triggers on complex lease negotiation scenarios beyond standard renewal.
land-residual-hbu-analyzer
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.
construction-cost-estimator
Produces ground-up construction cost estimates by CSI MasterFormat division with regional adjustments, soft cost layering, contingency framework, and sensitivity analysis. Accepts floor plans, building drawings, or text descriptions as input. Can generate ASCII floor plans and building mockups for co-creation design loops with real-time cost feedback. Triggers on 'estimate construction costs', 'how much to build', 'construction budget', 'TDC estimate', 'hard cost estimate', 'development cost', 'price this floor plan', 'what would this cost to build', or when given a project description, drawing, or floor plan.
construction-budget-gc-analyzer
Benchmarks a GC's construction budget against market costs by CSI division, evaluates contract structure (GMP vs. cost-plus vs. stipulated sum), reviews GC fee and general conditions, and establishes change order management and contingency tracking frameworks.
agency-loan-quote-analyzer
Analyzes Freddie Mac and Fannie Mae agency multifamily quotes (lease-up and stabilized) into a decision-ready package. Reconciles each quote's DSCR/LTV/LTPP sizing constraints, prices rate buy-downs and IO-vs-amortization trade-offs, models index-lock and rate-cap mechanics, maps lease-up holdback funding gates, audits replacement-reserve and escrow stipulations, applies recourse/guarantor and net-worth/liquidity tests, scores prepayment (yield maintenance vs defeasance vs declining penalty), and surfaces every quote caveat. Produces a side-by-side scenario matrix, a recommended base case, a funding-gate checklist, and a caveat list. Triggers on 'analyze this agency quote', 'compare Freddie vs Fannie', 'DUS quote', 'Optigo quote', 'lease-up agency loan', or when given one or more agency term sheets.