VALORE REGISTRY
How to use · Tax Abatement Model

How to use the Tax Abatement Model.

Six steps from abatement agreement to 30-year projection + NPV + expiration shock. Plus practitioner tips on PILOT vs statutory programs, HTC recapture risk, NYC 421a/421g version drift, OZ holding-period mechanics, and the year-1-after-expiration shock most operators miss.

Practitioner-built ·Pairs with the AI Team when it ships Q3 2026 ·Human review required on every output

A. Six steps

From download to deliverable
  1. 1

    Download the Tax Abatement Model

    You receive an XLSX with a 30-year projection horizon plus an NPV calculator + abatement expiration shock tab. Save as TaxAbatement_<Deal>_<YYYY-MM>.xlsx. Use alongside the Tax Analysis pack when abatement is the central economic driver.

  2. 2

    Identify the abatement program + its step-down mechanics

    Inputs: program name (HTC · PILOT · 421a · 421g · LIHTC overlay · Opportunity Zone · brownfield · enterprise zone) · base term · step-up schedule · expiration year · post-expiration tax treatment. Pull these from the abatement agreement, not from generalized program descriptions — every PILOT has deal-specific terms.

  3. 3

    Set the no-abatement counterfactual

    Enter what taxes WOULD be without the abatement: full assessed value × full millage rate × year-over-year growth. This is the line the abatement is reducing. Without an honest counterfactual, the value of the abatement is overstated.

  4. 4

    Project the 30-year tax line with step-downs

    The model layers: years 1-N at abatement rate · transition years at step-down rate · post-expiration at full rate. Each transition year is a tax-burden discontinuity — the model auto-shows the year-over-year shock at every step.

  5. 5

    Calculate NPV + expiration shock

    NPV tab: discounts the tax savings stream at a configurable rate (typically 8-10% for CRE). Expiration Shock tab: shows year-of-expiration tax burden as a % of stabilized NOI — frequently 5-15% of NOI absorption depending on program. Bring this number into the IC memo.

  6. 6

    Stress-test the program-survival assumption

    Some abatement programs have political risk (PILOT renegotiation, HTC recapture if compliance lapses, OZ regulatory uncertainty). The Stress tab models scenarios: full program through expiration · early termination · partial recapture. Disclose this in the IC memo when relevant.

B. Practitioner tips

Things the file won't tell you on its own
  • PILOTs are negotiated, not statutory. Every PILOT has bespoke terms — read the actual agreement, not the program overview. Modeling against the generic overview leads to year-2 surprises.
  • HTC compliance period is 5 years (federal) — recapture exposure runs through that window. State HTCs often run 5-10 years. Model the recapture risk separately from the abatement value.
  • 421a / 421g (NYC): the program has changed multiple times; the version of 421a that applies to a deal depends on when the building got its permit. Don't assume current 485-x terms apply to a 421a building from 2018.
  • OZ deals have specific holding-period mechanics (5/7/10 years) tied to capital-gains deferral and step-up. The tax-abatement modeling is one piece; the cap-gains structure is a separate workflow.
  • Brownfield credits: cumulative caps + state-specific timing rules + interaction with federal brownfield credits. If brownfield is central to the deal, get a tax specialist involved before relying on this model alone.
  • Post-expiration tax shock: most operators forget to model the year-1-after-expiration tax increase. Show this number prominently — it's the single biggest hidden variable in abatement-driven underwriting.

C. Scope & limits

What this template is — and is not
  • Not a substitute for a tax-credit specialist or counsel. Abatement-driven deals require specialist diligence; this model frames the economics, not the legal structure.
  • Not for syndication accounting. HTC equity syndication has separate equity-investor mechanics (capital account, suspended losses, exit) not modeled here.
  • Not for jurisdictions with non-standard abatement programs (some California overlays, Puerto Rico Act 60, foreign jurisdictions). The model handles US-domestic standard programs.
  • Does not handle stacking interactions between abatements (e.g., HTC + LIHTC + state credit stacking) where the math gets non-linear. For stacked deals, consult tax counsel + model line-by-line.

D. Pairs with

Components that operate on or alongside this template

  • Tax & Insurance Servicer

    Agent (forthcoming Q4 2026)

    Tracks abatement compliance filings, milestone deadlines, recapture-trigger events through the program life.

  • Tax Analysis Skill

    Skill (forthcoming Q4 2026)

    For deals where abatement is one component, the broader Tax Analysis Skill subsumes this; use this template when abatement is the central economic driver.

  • Tax Analysis

    Template (available now)

    Companion template — Tax Analysis covers baseline projection; this template handles the abatement-driven economics.

  • UW Workbook

    Template (available now)

    The 30-year tax line feeds back into the UW Workbook's operating assumptions. Abatement deals require the 10-year UW horizon to be extended.

  • Cash Flow Projection

    Template (available now)

    For deals where abatement expiration falls within the projection window, the cash-flow model needs the expiration shock built in.

Next step

Build the full stack around it.

This template is the work surface for a specific AI agent + skill workflow. Open the Company Builder and assemble the matching agents when they ship Q3 2026.

Open the Company Builder Back to Tax Abatement Model