The leasing-risk stack now covers concessions, rollover, retention, WALT, lease abstract completeness, estoppels, lease administration, tenant credit, credit support, TI burnoff, and sales-reporting and percentage-rent exposure. The next retail and mixed-use lease-risk layer is clause conflict risk: co-tenancy provisions that tie inline tenant rent to the presence of an anchor, operating covenants that require a tenant to keep operating, exclusive-use grants that bar competing uses, and the remedies attached to all three. These clauses do not change the contracted rent until a trigger fires, but when one does the remedy can reduce inline rent, let a tenant go dark or terminate, or block a re-lease, so a pro forma that reads clean on rent can carry latent conflict exposure that none of the numbers show. The underwriting model carries no lease clause text (no co-tenancy conditions, operating covenants, exclusive-use grants, radius restrictions, remedies, or tenant legal positions), and this module never invents any of them: it reads the absence of clause data as a documentation gap rather than confirmed absence, surfaces estimated remedy-exposed rent only as observable scope rather than a legal conclusion, and infers documentation and conflict risk only from observable proxies. An underwriting screen, not legal advice, lease interpretation, a broker opinion, or a property-management recommendation. Gated to commercial, retail, and mixed-use rent-roll deals; residential-only deals with no commercial tenant array and no retail context auto-skip. Estimated remedy-exposed rent is the inline rent a co-tenancy or exclusive remedy could reach: when a dominant anchor is sized (largest-tenant share at 25%-plus or a grocery-anchored format) it is the commercial rent net of that anchor, otherwise the commercial or retail rent base, reported with its share of Y1 NOI and surfaced as scope rather than a legal conclusion. Six weighted drivers summing to one, scored so higher means more complete clause documentation, a benign tenant mix and anchor structure, and lower conflict risk: clause documentation completeness 25% (a structural gap because the model holds no clause text, read from the lease abstract band, option-rights coverage, lease-administration option-tracking posture, and estoppel readiness, capped below fully-documented at 18 to 62), tenant mix and exclusive-use overlap 20% (retail format, small-shop fragility, commercial tenant count, and sales-rent underwrite risk as overlap-likelihood proxies), co-tenancy and anchor dependency 20% (the retail co-tenancy risk tier, anchor durability and quality, largest-tenant share, rollover within the hold, and tenant-loss retention pressure), operating covenant and notice control 15% (lease-administration band and notice-control posture), rent concentration and remedy exposure 10% (tenant concentration risk tier, largest-tenant share, estoppel concentration exposure), income cushion and recovery support 10% (cash conversion band and worst-year conversion, lease-recovery band). Co-tenancy posture classifies none-observed (non-retail), remedy-sensitive (a dominant anchor of high or elevated co-tenancy risk, anchor fragility, or tenant-loss retention), anchor-dependent (a dominant anchor present), else documentation-gap. Operating covenant posture classifies low-friction, monitor-required, covenant-sensitive, or default-remedy-watch from the administration band and notice posture. Exclusive-use posture classifies no-conflict-observed (non-retail), conflict-sensitive (overlap meets a thin lease file), overlap-watch (a discretionary or food-and-beverage mix or many small shops), else documentation-gap. Conflict exposure tiers minimal to high from the remedy-exposed share of NOI, escalated one step by a remedy-sensitive, conflict-sensitive, or default-remedy-watch posture and capped at moderate for non-retail commercial where co-tenancy and exclusive-use conflict is structurally unlikely. Bands: covenant-package-clean (composite 72-plus with no remedy-sensitive co-tenancy or conflict-sensitive exclusive-use posture), clause-documentation-watch (the honest center), co-tenancy-remedy-risk (remedy-sensitive co-tenancy under composite 58, or sub-44 composite with a dominant anchor), exclusive-use-conflict-risk (conflict-sensitive exclusive use under composite 58, or sub-44 composite with overlap), not-assessable. Memo surface: verdict banner with band, score, and the co-tenancy and exclusive-use postures; four-stat headline across remedy-exposed rent, its share of Y1 NOI, the commercial tenant count, and the conflict exposure tier; a posture strip across co-tenancy, operating covenant, and exclusive use; per-tenant rows sorted by rent share with an inferred clause-conflict risk tier (from rent share, escalated on overlap potential and on the dominant anchor) and a read that flags co-tenancy, exclusive-use, and operating-covenant clauses as not in the model, marking the dominant tenant as the condition inline co-tenancy clauses would key off; six-driver weighted score table; operating actions tied to abstracting the clause register from the leases (always), mapping exclusive-use grants against the tenant mix before new leases (always), and tracking operating-covenant compliance in the administration calendar (always), escalating on a dominant anchor and on overlap potential; diligence requests tied to pulling the co-tenancy, exclusive-use, radius, and operating-covenant clauses (always), reconciling an exclusive-use schedule against the rent roll (always), and modeling the inline remedy if a major tenant goes dark (always), plus a clause-rebuild request on a thin lease file and a largest-tenant clause confirmation on high concentration; 2-4 deal implications by band with the explicit framing that on co-tenancy-remedy-risk deals a dominant anchor whose departure inline tenants could invoke meets undocumented co-tenancy terms and the sponsor confirms the conditions and remedies and stresses the inline rent for the anchor going dark. Module auto-skips residential-only deals with no commercial rent roll or retail context, and degrades gracefully when the retail anchor, trade-area, mixed-use, tenant concentration, net effective rent, lease administration, estoppel and audit, abstract completeness, recovery, retention, lease-expiration, sales-reporting, or cash conversion modules are absent (postures default to a documentation gap and drivers to neutral inference). All upstream types matched the spec exactly. Tenant co-tenancy, operating covenant, and exclusive-use conflict risk is a deterministic underwriting screen. It is not legal advice, lease interpretation, a broker opinion, or a property-management recommendation, and it never fabricates co-tenancy clauses, exclusives, operating covenants, remedies, or tenant legal positions.
Product velocity, made reviewable.
A curated day-by-day record of the institutional features that landed in Underwrite. We maintain this by hand instead of dumping git log because shipping velocity is part of the trust signal. Every entry below is a specific thing a real CRE underwriter cares about.
Want to verify? The engine source is public at /methodology/engine and every commit is on GitHub.
Filter the velocity proof by engine, UI, AI, ops, marketing, or fixes.
Phase 3 continues: Tenant Co-Tenancy, Operating Covenant, and Exclusive-Use Conflict Risk Index lands on top of the leasing-risk stack. The memo now reads whether co-tenancy provisions, operating covenants, and exclusive-use grants carry latent conflict or remedy exposure that the rent line does not show. Because the model carries no lease clause text, it never fabricates clauses: it reads their absence as a documentation gap, surfaces remedy-exposed rent as scope rather than a legal conclusion, and infers conflict risk from retail mix, anchor dependency, concentration, lease-admin and abstract gaps, and income cushion. 138 Phase 3 modules cumulative.
- engine
Phase 3 continues: Tenant Sales Reporting, Percentage Rent, and Breakpoint Exposure Index lands on top of the leasing-economics stack. The memo now reads whether retail and mixed-use tenants carry sales-based rent upside, breakpoint risk, or undocumented sales reporting that changes how durable the underwritten income is. Because the model books contractual base rent only, it never fabricates sales or percentage rent: it scopes the retail rent whose sales-reporting status is undocumented, books zero sales-based upside or downside, and infers exposure from retail durability, trade-area capture, concentration, controls, and cushion. 137 Phase 3 modules cumulative.
The memo carries tenant concession economics, TI and LC burnoff, credit and default risk, credit support, lease administration controls, estoppel and audit exposure, abstract completeness, WALT, retention, and rollover. The next commercial-lease-economics layer is sales reporting and percentage rent: whether retail or mixed-use tenants carry sales-based rent upside, breakpoint risk, reporting gaps, or revenue volatility that changes how durable the underwritten income actually is. Percentage rent is rent that steps up once a tenant's sales clear a breakpoint; it can be genuine bonus upside on a productive store or a number the pro forma leans on that never materializes, and either way it depends on the tenant generating, reporting, and being audited on sales. The underwriting model carries no tenant sales, percentage-rent clauses, breakpoints, audit rights, or reporting-compliance fields, and the pro forma books contractual base rent only, so this module never invents any of them: it reads the absence of sales-reporting data as a documentation gap rather than confirmed absence, books no sales-based upside or downside it cannot observe, and infers exposure only from observable proxies. A diligence and underwriting screen, not legal, broker, property-management, accounting, or asset-management advice, and it does not predict tenant sales with certainty. Applies only to retail, mixed-use, or commercial deals with retail-like cues (retail or mixed-use property type, retail SF or rent, an applicable upstream retail module, or retail cues in the deal name, address, notes, or tenant labels); pure office, industrial, and multifamily deals with no retail cues auto-skip. The retail rent base is read from the per-tenant rent roll, else aggregate retail revenue net of vacancy, and reported as estimated sales rent at documentation risk, the scope of rent over which the undocumented sales-reporting question hangs, not observed sales-based rent; the retail-rent share of Y1 NOI surfaces the income dependence. Because the pro forma books base rent only, estimated upside dollars, estimated downside dollars, and modeled NOI drag are all zero by construction, since crediting either side would be fabricating sales projections. Six weighted drivers summing to one, scored so higher means cleaner documentation, more durable retail, and lower sales-based-rent underwriting risk: sales-rent documentation clarity 25% (a structural gap because the model holds no sales fields, read from the lease abstract band, reconciliation control posture, and estoppel readiness and capped below fully-documented at 18 to 62), retail durability and trade-area support 20% (anchor durability band, trade-area capture band and leakage risk, mixed-use synergy band), breakpoint and upside underwriting risk 20% (base 68 because the base-rent-only pro forma carries no overstated percentage-rent line, adjusted for net-effective concession drag, trade-area leakage risk, and anchor fragility), concentration and NOI dependence 15% (tenant concentration risk tier, largest-tenant share, commercial share of NOI), lease administration and reporting controls 10% (administration band, reconciliation posture, estoppel and audit band), cash-flow cushion 10% (cash conversion band and a negative worst-year conversion haircut). Sales reporting posture classifies reporting-controls-adequate (administration controlled, annual reconciled, abstract complete), reporting-controls-weak (admin leakage or unreconciled or informal reconciliation), else reporting-documentation-gap. Percentage rent posture classifies upside-possible-undocumented (strong retail support), fragile-if-underwritten (anchor fragility or leakage risk), else percentage-rent-undocumented. Breakpoint exposure tiers minimal to high from the retail share of NOI (0.40-plus elevated base, 0.15-plus moderate) escalated one step on high concentration or high leakage. Bands: sales-rent-upside-supported (composite 72-plus with strong retail support and not weak), breakpoint-watch (58-71), reporting-documentation-gap (44-57, the honest center), sales-rent-underwrite-risk (under 44, or weak retail support under composite 52), not-assessable. Memo surface: verdict banner with band, score, sales reporting posture, and percentage rent posture; headline stats across retail rent at documentation risk, booked sales-rent upside and downside (both zero), breakpoint exposure tier, retail-rent share of Y1 NOI, modeled sales-rent drag (zero), and percentage rent posture; per-tenant rows sorted by rent share with an inferred sales-reporting risk tier (from rent share, escalated on weak retail support and on the largest tenant under high concentration) and a read that flags sales, percentage rent, breakpoints, and reporting status as not in the model; six-driver weighted score table; operating actions tied to building a sales-reporting register from the leases (always), underwriting percentage rent as bonus upside held outside the base case (always), and tracking sales-reporting and breakpoint compliance in the administration calendar (always), escalating on weak retail support and elevated or high breakpoint exposure; diligence requests tied to pulling the percentage-rent and sales-reporting clauses with breakpoint, overage rate, reporting frequency, and audit rights (always), requesting trailing tenant sales reports and reconciling to collected rent (always), and isolating any sales-based rent in the pro forma (always), plus a reporting-controls confirmation on weak controls and a largest-tenant sales-reporting confirmation on high concentration; 2-4 deal implications by band including the retail rent at documentation risk, its share of NOI, and the three classifications, with the explicit framing that on sales-rent-underwrite-risk deals weak retail durability meets undocumented sales reporting and the sponsor underwrites strictly on contractual minimum rent, holds percentage rent out of the base case, and confirms trailing tenant sales before crediting overage. Module auto-skips deals with no retail context, and degrades gracefully when the retail anchor, trade-area, mixed-use, tenant concentration, net effective rent, lease administration, estoppel and audit, abstract completeness, or cash conversion modules are absent (postures default to a documentation gap and drivers to neutral inference). All upstream types matched the spec exactly. Tenant sales reporting, percentage rent, and breakpoint exposure is a deterministic diligence and underwriting screen. It is not legal, broker, property-management, accounting, or asset-management advice, it never fabricates tenant sales, breakpoints, percentage rent clauses, audit rights, or reporting compliance, and it does not predict tenant sales with certainty.
The IC memo index grows up with the module count. The memo table of contents now routes the leasing-diligence and capital-projects families into their own categories, every category group collapses with a count, and the memo view controls gain a collapse-all action. Navigation only; no engine math moved, and the 136-module count is unchanged.
The memo table of contents categorizes sections by title keywords, and the category map predated the leasing-diligence and capital-projects waves, so the newest modules piled into the generic Rent Roll and Risk groups and the index lost its shape. Two categories join the router: Leasing and Tenant Diligence (concessions, rollover, retention, WALT, lease abstract, estoppels, lease administration, tenant credit, credit support, and allowance burnoff) and Capex and Capital Projects (procurement, draws, closeout, capital project ROI, exit value protection, diligence evidence, and business disruption), routed by specific title keywords so the core rent-roll sections stay where they were. Every category group in the index is now collapsible with a section count, the pattern the Phase 3 live group already used, and filtering always shows matches even inside a collapsed group. The memo view controls gain a collapse-all action beside expand-all, and the stale hardcoded section-count fallback is gone. Navigation chrome stays hidden in print, the printable memo is untouched, and no engine module changed. 136 Phase 3 modules cumulative, unchanged by this entry.
Phase 3 continues: Tenant Improvement Allowance Burnoff and Amortization Recovery Risk Index lands on top of the leasing-economics stack. The memo now reads whether the TI, LC, and free rent the rent roll carries burns off cleanly over the lease term or leaves unrecovered leasing capital at rollover and exit. It surfaces the leasing capital, the recovered and unrecovered split, a recovery ratio, a recovery posture, and a per-tenant leasing-capital table. 136 Phase 3 modules cumulative.
The memo carries tenant credit and default risk, credit support adequacy, lease administration, estoppel and audit exposure, abstract completeness, WALT, retention, rollover, and concession risk. The next leasing-economics layer is tenant improvement and leasing-cost recovery: whether the TI allowances, leasing commissions, free rent, and amortized concession packages burn off cleanly through the hold or leave the sponsor exposed to unrecovered leasing capital. Leasing capital is spent up front to sign or renew a lease and burns off over the lease term through the rent it secures; a long remaining term lets the allowance amortize and recover, while a lease that rolls before payback or a hold that ends first leaves a residual unrecovered. A diligence and underwriting screen, not legal, broker, property-management, accounting, or asset-management advice, and the recovery estimate is an underwriting proxy rather than accounting treatment; where amortization or repayment clauses are absent from the model it reads a documentation gap rather than fabricating repayment obligations, commission structures, tenant reimbursements, or accounting treatment. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. Leasing capital is taken from the concession module total concession exposure, else the sum of per-tenant concession term (free rent plus TI and LC) the Net Effective Rent module carries; leasing capital intensity reads as a multiple of Y1 NOI (light 0.25-or-under, moderate 0.5, elevated 1.0, heavy above). The recovery fraction equals the weighted average lease term over a seven-year standard amortization horizon (clamped 0.15 to 0.95), discounted 0.15 times the rent rolling within the hold above 30%, minus 0.08 on a tenant-loss retention band and 0.06 on a rollover re-tenanting-gap band, re-clamped 0.10 to 0.95. Estimated recovered equals that fraction times the leasing capital; estimated unrecovered is the residual, reported as an average annual NOI drag in bps over the hold; the recovery ratio surfaces the fraction; top-tenant unrecovered is the largest leasing-capital share times one minus recovery. Amortization documentation posture reads through the credit-support module documentation read (documented, standard-inferred, documentation-gap, or unverified). Six weighted drivers, scored so higher means cleaner recovery and lower unrecovered leakage: leasing capital intensity 25% (0.25x-or-under of NOI 80, 0.5x 62, 1.0x 44, above 28), remaining lease term and burnoff runway 20% (WALT 8-plus years 80, 6 64, 4 48, 2.5 34, under 24; null 50), concession drag and NER leakage 20% (NER drag 8pp-or-under 78, 18pp 60, 30pp 42, above 28; concession lease-up-capital-overhang minus 6 or concession-controlled plus 4), rollover and retention pressure 15% (rolling 25%-or-under 78, 45% 60, 65% 42, above 28; tenant-loss-risk or re-tenanting-gap-risk minus 4 each), documentation and recovery clarity 10% (documented 78, standard-inferred 60, documentation-gap 40, unverified 24), reserve and cash cushion 10% (ReserveAdequacy adequate 76, thin 50, under-reserved 30; CashConversion strong plus 6 to thin minus 8; positive late-hold NoiDecomp deltaNOI plus 3). Allowance recovery posture classifies fully-recovering (ratio 0.75-plus with WALT 5-plus or null), amortizing-on-track (0.55-plus), front-loaded (0.40-plus), else leaking-unrecovered. Bands: allowance-recovery-supported (composite 75-plus with fully-recovering or amortizing-on-track posture), amortization-watch (60-74), front-loaded-concession-risk (45-59, or heavy intensity under composite 50), unrecovered-ti-leakage (under 45, or leaking-unrecovered posture under composite 55, or recovery ratio under 0.40 under composite 52), not-assessable. Memo surface: verdict banner with band, score, recovery posture, intensity; seven headline stats across leasing capital, recovered dollars, unrecovered dollars, recovery ratio, NOI drag, top-tenant unrecovered, and amortization documentation; per-tenant rows sorted by leasing capital carried with the dollars, a recovery risk tier (from net-effective drag above 30 or 18 points and whether the lease rolls in hold and a concentration bump), and a read that flags amortization and repayment terms as not in the model; six-driver weighted score table; operating actions tied to tracking the unamortized leasing-capital balance per lease on a net-effective basis (always), tying allowances to term and seeking amortization or repayment-on-early-termination clauses (always), and reserving for the unrecovered balance at exit (always), escalating to face-rent achievability on elevated or heavy intensity and blend-and-extend on a front-loaded or leaking read; diligence requests tied to the executed TI, LC, and free rent terms with the funding schedule and any amortization, repayment, or recapture clause (always), the unamortized balance as of underwriting and the exit treatment (always), and market TI, LC, and free rent comps (always), plus a rolling-lease amortization check above 45% rollover and an unconfirmed-terms follow-up on a documentation gap; 2-4 deal implications by band including leasing capital, recovered and unrecovered dollars, the recovery ratio, and the three postures, with the explicit framing that on unrecovered-TI-leakage deals heavy leasing capital meets a short burnoff runway and the sponsor reprices for the structural leasing-capital cost, secures amortization or repayment terms, or re-underwrites the face rents net of the allowances required to achieve them. Module auto-skips without a commercial rent roll, and degrades gracefully when the credit-support, tenant credit, concession, net effective rent, rollover, WALT, retention, cash conversion, NOI decomposition, or reserve adequacy modules are absent (leasing capital reads from the rent roll and postures default to neutral inference). All upstream types matched the spec exactly. Tenant improvement allowance burnoff and amortization recovery risk is a deterministic diligence and underwriting screen. It is not legal, broker, property-management, accounting, or asset-management advice, the recovery estimate is an underwriting proxy rather than accounting treatment, and it reads a documentation gap rather than fabricating amortization or repayment terms.
Phase 3 continues: Tenant Guaranty, Security Deposit, and Credit Support Adequacy Index lands on top of the tenant-credit layer. The memo now reads whether the deal has enough deposit, guaranty, or letter-of-credit backstop to absorb the inferred tenant default exposure, treating the absence of support fields as a documentation gap rather than confirmed absence. It surfaces a credit-support posture, deposit and guaranty documentation reads, supported and unsecured exposure, a coverage ratio, and a top-tenant unsupported share. 135 Phase 3 modules cumulative.
The memo carries tenant credit and default risk, lease administration controls, estoppel and audit exposure, abstract completeness, WALT, retention, rollover, and concession risk. The next lease-risk layer is credit support: whether the deal has enough deposit, guaranty, letter of credit, or other backstop coverage to absorb tenant default, collection friction, downtime, and replacement cost. The model carries no tenant-level security deposit, letter of credit, guaranty, or parent-credit fields, and this module never invents them; it starts from the inferred default exposure carried by the Tenant Credit module, estimates how much a standard support package would cover under the documentation quality the upstream lease modules imply, and treats the residual as unsecured, classifying a documentation gap rather than confirmed absence where support evidence is missing. A diligence and underwriting screen, not a legal enforceability opinion, a credit rating, a broker opinion, or a property-management recommendation, and it does not predict tenant default with certainty. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. Guaranty documentation posture reads from a documentation-quality blend: the LeaseAbstract band (abstract-package-complete 80, critical-date-watch 60, lease-data-gap-risk 40, abstract-deficiency-risk 22) adjusted by the estoppel module (estoppel-ready plus 4, lease-file-deficiency-risk minus 8) and the lease-administration module (administration-controlled plus 4, lease-admin-leakage-risk minus 8), mapped documented 72-plus, inferred-standard 54-71, documentation-gap 38-53, absent-or-unverified under 38. Inferred support coverage blends a 0.12 base deposit fraction with a guaranty fraction by Tenant Credit posture (credit-anchored 0.30, mixed-credit 0.15, credit-thin 0.05, credit-fragile 0.0), discounted by documentation reliability (documented 1.0, inferred-standard 0.7, documentation-gap 0.4, absent-or-unverified 0.15), capped at 0.9. Estimated supported exposure equals that coverage fraction times the Tenant Credit default exposure; estimated unsecured exposure is the residual, reported as an average annual NOI drag in bps over the hold; the coverage ratio surfaces the supported fraction; top-tenant unsupported equals the largest tenant share times one minus coverage. Six weighted drivers, scored so higher means stronger inferred support and lower unsecured exposure: default exposure severity 25% (Tenant Credit band credit-supported-rent-roll 80, tenant-credit-watch 62, collection-friction-risk 42, default-cure-exposure 26), documentation completeness 20% (documented 80, inferred-standard 60, documentation-gap 40, absent-or-unverified 24), top-tenant concentration 20% (top tenant 15%-or-under 80, 30% 60, 50% 42, above 26; high concentration minus 4), lease administration and estoppel readiness 15% (admin band administration-controlled 78 down to lease-admin-leakage-risk 26; estoppel-ready plus 4 or lease-file-deficiency-risk minus 6), rollover and replacement friction 10% (rollover band rollover-controlled 78 down to re-tenanting-gap-risk 26; rolling above 50% or tenant-loss-risk minus 4 each), reserve and cash cushion 10% (ReserveAdequacy adequate 76, thin 50, under-reserved 30; CashConversion strong plus 6 to thin minus 8). Credit support posture classifies credit-backstopped (score 70-plus with documented or inferred-standard documentation and unsecured share 0.65-or-under), deposit-supported (55-plus), thinly-secured (40-plus), else effectively-unsecured. Security deposit coverage maps from documentation posture (documented to documented-coverage, inferred-standard to standard-deposit, documentation-gap to thin-deposit, absent-or-unverified to undocumented). Bands: credit-support-adequate (composite 75-plus with credit-backstopped or deposit-supported posture), deposit-backstop-watch (60-74), guaranty-documentation-gap (45-59), unsecured-default-exposure (under 45, or effectively-unsecured posture under composite 55, or absent-or-unverified documentation under composite 52, or top-tenant unsupported above 40% under composite 52), not-assessable. Memo surface: verdict banner with band, score, support posture; seven headline stats across top-tenant unsupported, unsecured exposure, coverage ratio, NOI drag, supported exposure, deposit coverage, and documentation posture; per-tenant rows sorted by rent share with an inferred support risk tier (from rent share, bumped one step on a documentation gap) and a support read (concentrated and unverified, documentation gap, or standard support assumed), each framed explicitly as an inference from rent share and lease-file quality to confirm against the lease rather than a statement that support is present or absent; six-driver weighted score table; operating actions tied to building a credit support register from the leases recording deposits, letters of credit, guaranty type and guarantor, and replenishment terms (always), sizing support against the realistic default cost rather than a month or two of rent (always), and tracking deposit and letter-of-credit expirations in the administration calendar (always), escalating to a closing condition on documentation gaps and a largest-tenant package confirmation on a high unsupported share; diligence requests tied to the deposit ledger and letters of credit and guaranty documents with amount, form, guarantor, expiration, and replenishment (always), whether deposits are segregated and transferable and instruments assignable at closing (always), and the default remedies the support actually backstops including caps and burn-down (always), plus a largest-tenant support read on high concentration and a coverage confirmation against the inferred unsecured exposure; 2-4 deal implications by band including default, supported, and unsecured exposure dollars, the coverage ratio, and the three postures, with the explicit framing that on unsecured-default-exposure deals concentrated inferred-fragile rent meets thin or unverified support and the sponsor confirms the actual support package, reprices for the structural exposure, or sizes committed reserves and security to the unsecured rent. Module auto-skips without a commercial rent roll, and degrades gracefully when the tenant credit, lease administration, estoppel, abstract, WALT, retention, rollover, net effective rent, tenant concentration, cash conversion, or reserve adequacy modules are absent (a concentration-based default-exposure proxy and a documentation-gap posture default in). All upstream types matched the spec exactly. Tenant guaranty, security deposit, and credit support adequacy is a deterministic diligence and underwriting screen. It is not a legal enforceability opinion, a credit rating, a broker opinion, or a property-management recommendation, and it does not predict tenant default with certainty.
Phase 3 continues: Tenant Credit Deterioration and Default Cure Risk Index lands on top of the lease-risk stack. The memo now reads whether the rent roll is exposed to tenant weakness, cure-period friction, collection risk, and replacement downtime if a key tenant stops paying, inferred only from observable proxies since the model carries no tenant financials. It surfaces a credit posture, a default-cure posture, a collection risk tier, at-risk rent, and estimated default exposure. 134 Phase 3 modules cumulative.
The memo carries concession risk, rollover, retention, WALT, abstract completeness, estoppel exposure, and lease administration controls. The missing lease-risk layer is tenant credit and default readiness: whether the rent roll is exposed to tenant weakness, cure-period friction, collection risk, replacement downtime, or operating leakage if a key tenant stops paying or needs relief. The model carries no tenant financial statements, payment history, default notices, cure periods, guarantors, or credit ratings, and this module never fabricates them; it reads credit and default exposure only from observable underwriting proxies: rent concentration, rollover exposure, WALT, net effective rent drag, lease administration and estoppel and abstract gaps, cash conversion, and operating margin. An underwriting screen, not a legal default opinion, a credit rating, a broker opinion, or a property-management recommendation, and it does not predict tenant default with certainty. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. Inferred fragility runs 0 to 1 from a 0.3 base adjusted by NetEffectiveRent drag (above 30pp plus 0.2, above 18 plus 0.1, 8-or-under minus 0.1), OperatingMargin trend (compressing plus 0.1, expanding minus 0.05), CashConversion (thin plus 0.15, tight plus 0.08, strong minus 0.1), a replacement-dependent retention posture (plus 0.1), and a rollover re-tenanting gap (plus 0.08). Tenant credit posture maps a 70-base credit read penalized by concentration (high minus 18, moderate minus 8, low plus 6) and fragility (minus up to 40): credit-anchored 70-plus, mixed-credit 54-69, credit-thin 38-53, credit-fragile under 38. Default-cure posture blends a 60-base with CashConversion (strong plus 14 to thin minus 16), the rollover band (rollover-controlled plus 6 to re-tenanting-gap-risk minus 12), and high concentration (minus 10): cure-cushioned 70-plus, standard-cure 54-69, cure-pressured 38-53, replacement-dependent under 38. Collection risk tier reads from cash conversion (thin plus 2, tight plus 1), margin compression (plus 1), heavy NER drag above 25pp (plus 1), and a lease-admin leakage band (plus 1), mapped low to high. At-risk rent equals the top-three concentration times a 0.5-to-1.0 fragility multiplier, capped at 90%, times total commercial rent; estimated default exposure adds a cure-and-downtime fraction (rollover downtime months plus 3, over 12, capped at 1.6) and a half-year re-leasing fraction on the at-risk rent, reported as an average annual NOI drag in bps over the hold. Six weighted drivers, scored so higher means stronger inferred credit and lower exposure: tenant concentration and single-tenant credit exposure 25% (top tenant 15%-or-under 80, 30% 60, 50% 42, above 26; high concentration minus 4), replacement and cure readiness 20% (cure-cushioned 80, standard-cure 62, cure-pressured 42, replacement-dependent 26), rollover and re-credit exposure 15% (rolling 25%-or-under 78, 45% 60, 65% 42, above 28; tenant-loss-risk minus 4), lease economics fragility 15% (NER drag 8pp-or-under 78, 18pp 60, 30pp 42, above 28), operating cushion 15% (CashConversion strong 78, typical 60, tight 42, thin 28; margin expanding plus 4 or compressing minus 4), lease-file and administration opacity 10% (LeaseAbstract band abstract-package-complete 78 down to abstract-deficiency-risk 26; estoppel lease-file-deficiency-risk or lease-admin leakage minus 4 each). Bands: credit-supported-rent-roll (composite 75-plus with credit-anchored or mixed-credit posture), tenant-credit-watch (60-74), collection-friction-risk (45-59), default-cure-exposure (under 45, or credit-fragile posture under composite 55, or replacement-dependent cure posture under composite 52, or top tenant above 50% under composite 55), not-assessable. Memo surface: verdict banner with band, score, credit posture; six headline stats across top-tenant exposure, at-risk rent, default exposure, NOI drag, default-cure posture, and collection risk; per-tenant rows sorted by rent share with an inferred credit risk tier (from rent share, bumped one step when overall fragility is 0.55-plus) and the dominant exposure driver (single-tenant concentration on 30%-plus rent, near-term rollover re-credit on in-hold expirations, concession and economics dependency on fragile rolls, else diversified lower exposure), each framed explicitly as an inference from rent share and lease structure to confirm in credit diligence rather than a credit opinion, since no tenant financials are in the model; six-driver weighted score table; operating actions tied to underwriting the largest tenants on credit and guaranty rather than rent (always), carrying a default and downtime reserve sized to the at-risk rent (always), and tracking collections and aging with an early-warning process (always), escalating to credit diligence and added security on thin or fragile inferred credit and a clean largest-tenant read on 35%-plus concentration; diligence requests tied to tenant credit evidence the leases allow including guaranty structure and deposits (always), the trailing collection and aging history with any abatement or workout or bankruptcy record (always), and the default remedies and cure periods and co-tenancy or kick-out triggers (always), plus a largest-tenant credit review on high concentration and a reserve-carry confirmation on thin cure readiness; 2-4 deal implications by band including top-tenant exposure, at-risk rent, default exposure, and the three postures, with the explicit framing that on default-cure-exposure deals concentrated inferred-fragile rent meets a thin cure cushion and the sponsor reprices for the structural credit exposure, sizes committed reserves and security to the at-risk rent, or re-underwrites the income on a conservative credit basis. Module auto-skips without a commercial rent roll, and degrades gracefully when the lease administration, estoppel, abstract, WALT, retention, rollover, net effective rent, tenant concentration, cash conversion, or operating margin modules are absent (postures and drivers default to neutral inference). All upstream types matched the spec exactly. Tenant credit deterioration and default cure risk is a deterministic underwriting screen. It is not a legal default opinion, a credit rating, a broker opinion, or a property-management recommendation, and it does not predict tenant default with certainty.
Phase 3 continues: Lease Administration Controls and Tenant Notice Workflow Risk Index lands on top of the lease-diligence stack. The memo now reads the operations layer of leasing: whether the operator can track option and renewal notice windows, expiration deadlines, recovery reconciliations, and tenant obligations without leakage. It surfaces a calendar-reliance score, critical-notice exposure, estimated administration leakage, and inferred notice, option, and reconciliation control postures. 133 Phase 3 modules cumulative.
The memo carries lease concession, rollover, retention, WALT, abstract completeness, and estoppel and audit exposure. Those modules read the lease economics and the lease data; this module adds the operations layer: whether the sponsor or manager can run the lease-administration workflow during the hold, tracking option and renewal notice windows, expiration deadlines, recovery and CAM reconciliations, insurance certificates, tenant obligations, and landlord delivery obligations without operational leakage. A clean lease file still loses value if the operator misses a renewal-option notice, lets a below-market lease auto-renew, fails to reconcile CAM, or lets an insurance certificate lapse; the risk is execution, not economics. An underwriting screen, not legal, property-management, broker, or asset-management advice, and it infers control posture from upstream lease data rather than fabricating tenant notices, option dates, audit claims, or estoppel status. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. Calendar reliance is a 0-100 read of how much income depends on disciplined notice and option tracking, floored at 40 and blended from rent rolling within the hold (0.45), the greater of near-term expiration and half the renewal exposure (0.35), and top-tenant concentration (0.20). Three control postures are inferred since the model carries no lease-administration fields: notice control from the LeaseAbstract band (abstract-package-complete maps to calendar-tracked, critical-date-watch to manual-tracked, lease-data-gap-risk to ad-hoc, abstract-deficiency-risk to uncontrolled, capped to ad-hoc when the estoppel module reads file-rebuild-needed); option tracking from the abstract optionRightsCoveragePct crossed with renewal exposure (0.4-plus option-calendar, 0.25 lease-by-lease, renewal exposure 0.4-plus untracked, 0.12 reactive, else untracked); reconciliation control from the LeaseRecovery band (recovery-strong annual-reconciled, recovery-watch periodic, leakage-exposed informal, sponsor-absorbed-opex-risk unreconciled). Critical notice exposure equals the greater of rolling-within-hold and renewal-exposure shares times total commercial rent. Estimated administration leakage blends a notice-leakage factor by notice posture (calendar-tracked 1%, manual-tracked 3%, ad-hoc 6%, uncontrolled 10%) on the critical notice exposure with a reconciliation-leakage factor by reconciliation posture (annual-reconciled 15%, periodic 40%, informal 70%, unreconciled 100%) on the modeled recovery leakage, reported as an average annual NOI drag in bps over the hold. Six weighted drivers, scored so higher means tighter controls and lower leakage: notice and critical-date control 25% (calendar-tracked 80, manual-tracked 60, ad-hoc 40, uncontrolled 24; calendar reliance 75-plus with an ad-hoc or uncontrolled posture minus 6), option and renewal tracking discipline 20% (option-calendar 78, lease-by-lease 60, reactive 42, untracked 26; retention tenant-loss-risk minus 4), recovery reconciliation control 20% (annual-reconciled 78, periodic 60, informal 40, unreconciled 26; high tenant dispute risk minus 4), lease data and abstract foundation 15% (abstract band abstract-package-complete 80 down to abstract-deficiency-risk 26; estoppel lease-file-deficiency-risk minus 6), tenant concentration and obligation complexity 10% (concentration low 76, moderate 56, high 34), operating cushion for administration leakage 10% (CashConversion strong 76, typical 60, tight 42, thin 28). Bands: administration-controlled (composite 75-plus with calendar-tracked or manual-tracked notice control), notice-calendar-watch (60-74), option-workflow-risk (45-59), lease-admin-leakage-risk (under 45, or uncontrolled notice control under composite 55, or unreconciled recovery under composite 55, or NOI drag above 150 bps under composite 52), not-assessable. Memo surface: verdict banner with band, score, notice control posture; six headline stats across calendar reliance, critical notice exposure, administration leakage, NOI drag, option tracking posture, and reconciliation posture; per-tenant rows sorted by rent share listing the standard administration obligations to track (renewal and option notice windows, recovery and CAM reconciliation, insurance certificate tracking, estoppel and SNDA coordination on 20%-plus leases, near-term expiration and renewal decision on in-hold expirations) and a tracking risk tier, presented as workflow items to confirm against the lease rather than tracked dates; six-driver weighted score table; operating actions tied to standing up a critical-date calendar from the abstracts with automated ticklers (always), running an annual CAM and operating-expense reconciliation on a fixed cycle (always), and assigning a named administration owner with an escalation path (always), escalating to rebuilding the calendar before close on weak notice control and reconciling trailing recoveries on weak reconciliation control; diligence requests tied to how the seller tracks critical dates today and whether any notice window is open or recently passed (always), the last two CAM reconciliation cycles with tenant audit correspondence (always), and the current tenant obligation file including insurance certificates and landlord delivery obligations (always), plus a close-the-abstract follow-up below a clean package and a largest-tenant obligation confirmation on high concentration; 2-4 deal implications by band including calendar reliance, critical notice exposure, administration leakage, and the three control postures, with the explicit framing that on lease-admin-leakage-risk deals the controls cannot reliably track the notice, option, and reconciliation obligations the lease file carries and the calendar and reconciliation process are rebuilt before close with the leakage carried in the underwriting. Module auto-skips without a commercial rent roll, and degrades gracefully when the estoppel, abstract, WALT, retention, rollover, lease recovery, net effective rent, tenant concentration, or cash conversion modules are absent (postures and drivers default to neutral inference). All upstream types matched the spec exactly. Lease administration controls and tenant notice workflow risk is a deterministic underwriting screen. It is not legal, property-management, broker, or asset-management advice, and it infers control posture from upstream lease data rather than fabricating tenant notices, option dates, audit claims, or estoppel status.
Phase 3 continues: Lease Audit Exposure and Estoppel Confirmation Risk Index lands on top of the lease-diligence stack. The memo now reads whether the lease file can survive tenant estoppels, audit rights, and reimbursement disputes, surfacing estimated disputed rent, the dollar exposure split across abstract gaps and recovery leakage, top-tenant estoppel concentration, an estoppel readiness posture, and a per-tenant confirmation table. 132 Phase 3 modules cumulative.
The memo carries lease abstract completeness and critical date risk. This module adds the confirmation layer: whether the lease file can survive the confirmation process at sale or financing, where every material lease is certified by the tenant through an estoppel and any gap, leakage, or mismatch in the file becomes an estoppel exception or an audit claim. It translates lease abstract gaps, recovery leakage, tenant concentration, WALT and expiration risk, retention posture, and net effective rent into a read on estoppel and lease-audit exposure. An underwriting screen, not a legal lease review, estoppel advice, or an audit opinion, and it does not fabricate estoppel status, amendments, audit claims, or tenant positions. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. Estoppel exception share is the LeaseAbstract unverified-rent read (0.2 fallback when the abstract module is absent); recovery dispute share reads from LeaseRecovery tenantDisputeRisk (high 0.20, elevated 0.12, moderate 0.05, low 0.02, else 0.04). Estimated disputed rent blends them as a probabilistic union (exception plus dispute times one minus exception), capped at 0.9. Abstract gap exposure equals the exception share times total commercial rent; recovery dispute exposure equals LeaseRecovery.estimatedLeakageDollars; estimated exposure dollars sum the two. Tenant concentration exposure is TenantConcentration.topThreeRentPct, else the computed top-three share. Readiness posture classifies file-rebuild-needed (abstract deficiency band), tenant-confirmation-needed (disputed rent 35%-plus, abstract lease-data-gap, or recovery leakage-exposed or sponsor-absorbed), targeted-confirmation (disputed rent 18%-plus, abstract critical-date-watch, or high concentration), else clean-package. Six weighted drivers, scored so higher means a cleaner file and lower exposure: lease abstract completeness and missing-field exposure 25% (abstract band abstract-package-complete 80, critical-date-watch 62, lease-data-gap-risk 42, abstract-deficiency-risk 26; over 40% unverified minus 6), recovery clause and reimbursement dispute exposure 20% (recovery band recovery-strong 78, recovery-watch 60, leakage-exposed 40, sponsor-absorbed-opex-risk 28; high dispute risk minus 6 or elevated minus 3), tenant concentration requiring estoppel confirmation 20% (concentration low 78, moderate 56, high 34), WALT and expiration and renewal dependency 15% (WALT band term-protected 76, near-term-roll-watch 60, concentrated-expiration-risk 44, walt-compression-risk 30; retention tenant-loss-risk minus 4; rollover re-tenanting-gap-risk minus 4), net effective rent and concession confirmation burden 10% (NER drag 8pp-or-under 76, 18pp 60, 30pp 42, above 28), cash conversion and operating margin cushion 10% (CashConversion strong 76, typical 60, tight 42, thin 28; OperatingMargin expanding plus 4 or compressing minus 4). Bands: estoppel-ready (composite 75-plus with clean-package or targeted-confirmation posture and disputed rent 20%-or-under), confirmation-watch (60-74), audit-exposure-risk (45-59, or disputed rent above 40% under composite 52), lease-file-deficiency-risk (under 45, or file-rebuild-needed posture under composite 55), not-assessable. Memo surface: verdict banner with band, score, readiness posture; six headline stats across disputed rent, estimated exposure, abstract gap exposure, recovery dispute exposure, top-tenant concentration, and readiness posture; per-tenant rows sorted by rent share with a confirmation risk tier (the LeaseAbstract critical-date risk bumped when recovery dispute risk is high or elevated on a 20%-plus lease) and the most likely confirmation item (expiration and critical-date confirmation when term is missing, reimbursement and CAM audit on leakage-exposed recovery, estoppel certification on a material lease at 25%-plus rent, else standard certification), drawn from the abstract per-tenant gaps and never a fabricated tenant position; six-driver weighted score table; diligence requests tied to ordering estoppel certificates for every material lease and reconciling each against the model (always), pulling the full lease file with amendments and prior reconciliations (always), and confirming the recovery and CAM methodology and audit-right provisions (always), escalating to closing abstract gaps before estoppels go out and a clean largest-tenant estoppel with an SNDA on high concentration; estoppel actions tied to issuing estoppel and SNDA packages from the abstracted terms, setting a response deadline and escalation path with a pre-cleared form, and holding the underwriting open on any outstanding or exception-laden estoppel, escalating to reconciling trailing CAM recoveries and carrying a clawback reserve on live reimbursement dispute exposure; 2-4 deal implications by band including disputed rent, exposure dollars split across abstract gap and recovery leakage, and top-tenant concentration, with the explicit framing that on lease-file-deficiency-risk deals the file cannot support clean estoppels as built, the confirmation process is gating, and the file is rebuilt from executed documents and amendments before the leasing reads are trusted. Module auto-skips without a commercial rent roll, and degrades gracefully when the lease abstract, lease recovery, tenant concentration, net effective rent, WALT, retention, rollover, operating margin, or cash conversion modules are absent (exposure and drivers default to observed data and neutral inference). All upstream types matched the spec exactly. Lease audit exposure and estoppel confirmation risk is a deterministic underwriting screen. It is not a legal lease review, estoppel advice, or an audit opinion, and it treats absent lease-file evidence as a diligence gap rather than a known fact.
Phase 3 continues: Lease Abstract Completeness and Critical Date Risk Index lands on top of the leasing-diligence stack. The memo now reads whether the lease abstract package is complete enough to trust the concession, rollover, retention, and WALT reads, surfacing abstract completeness, lease-term and recovery and option coverage, the count of leases missing a usable expiration date, unverified rent, a critical-date posture, and a per-tenant missing-fields table. 131 Phase 3 modules cumulative.
The memo carries concession risk, rollover reserve adequacy, tenant retention risk, and WALT and lease-expiration concentration. Every one of those reads is only as good as the lease data behind it, so this module steps back to the diligence question: is the lease abstract package complete enough to trust those reads, or do missing lease terms, expiration dates, recovery clauses, and option rights leave material rent resting on unverified assumptions. An underwriting screen, not a legal lease review or an abstracting opinion, and it treats absent fields as diligence gaps rather than inferred terms, never fabricating a missing critical date. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. It scores the fields the rent roll carries today (leased area, base rent, lease term and the derivable expiration year, and optional concession terms) and credits the recovery structure and renewal posture that upstream modules infer at the deal level, while treating the fields the TenantLease model never carries per lease (recovery clauses, renewal and option and expansion terms, and critical option-notice dates) as standing diligence gaps. Lease-term coverage is the rent-weighted share of tenants with a usable leaseTermYears; basic-field coverage is the share with leased area and base rent; recovery-clause coverage is 0.6 when LeaseRecovery classifies a structure else 0.2; option-rights coverage is 0.45 when the retention module infers a posture and term coverage is at least 0.6, 0.3 when retention applies with thinner term coverage, else 0.12. Abstract completeness blends lease-term coverage 40%, basic-field coverage 20%, recovery coverage 20%, and option coverage 20%. Critical-date posture reads tracked at 90%-plus term coverage, partially-tracked at 60 to 90%, missing-critical-dates below 60%, not-assessable without a roll; estimated unverified rent is the share in rows missing leased area, base rent, or term, and missing-critical-date count is the number of leases with no usable expiration. Six weighted drivers, scored so higher means a more complete abstract and lower critical-date risk: lease-term and expiration-date coverage 25% (95%-plus 84, 80 68, 60 50, 40 36, under 24), option and renewal and expansion rights coverage 20% (coverage 0.45-plus 60, 0.30 50, 0.15 40, under 30, framed as a standing abstraction gap even when retention infers a posture), recovery clause abstraction coverage 20% (0.6-plus 66, 0.45 56, 0.25 44, under 32, noting per-lease clauses and caps still need confirmation), tenant concentration in unverified rows 15% (unverified rent 15%-or-under 78, 35 60, 55 42, above 28; high concentration with material unverified rent minus 6), WALT and rollover model data dependency 10% (term coverage 80%-plus 76, 60 56, 40 40, under 28; null WALT minus 6), stabilization and lease-up timing sensitivity 10% (stabilized-at-acquisition 76, early 62, mid-hold 46, late 32, since lease-up theses are more exposed to abstract gaps). Bands: abstract-package-complete (composite 73-plus with tracked critical dates and unverified rent 25%-or-under), critical-date-watch (58-72), lease-data-gap-risk (44-57, or unverified rent above 55% under composite 52), abstract-deficiency-risk (under 44, or missing-critical-dates posture under composite 55), not-assessable. Memo surface: verdict banner with band, score, abstract completeness, critical-date posture; six headline stats across abstract completeness, lease-term coverage, unverified rent, missing critical dates, recovery coverage, and option coverage; per-tenant rows sorted by rent share listing the missing abstract fields (detectable per-tenant gaps plus the renewal-and-option terms the model never abstracts, plus recovery clause when not inferred) and a critical-date risk tier; six-driver weighted score table with status, contribution, and interpretation; diligence requests tied to a certified lease abstract for every tenant covering commencement and expiration dates, base and escalated rent, leased area, renewal and expansion and termination options with notice deadlines, and recovery structure with caps or base-year stops (always), building a critical-date calendar reconciled to the modeled rollover and WALT (always), and confirming the largest rent shares first (always), escalating to rebuilding WALT and rollover on confirmed dates when term coverage is incomplete and a full legal abstract of the largest lease on high concentration; operating actions tied to a lease administration system with automated option, notice, and expiration ticklers, treating any unabstracted term as an open item, re-running the leasing modules on confirmed abstracts, and prioritizing abstraction of unverified rent above 35%; 2-4 deal implications by band including abstract completeness, term coverage, the count of leases missing a usable expiration date, and the unverified rent share, with the explicit framing that on abstract-deficiency-risk deals the leasing reads cannot be trusted as built and a complete abstract package becomes a condition of advancing the deal, with WALT, rollover, retention, and concession rebuilt on confirmed terms. Module auto-skips without a commercial rent roll, and degrades gracefully when net effective rent, tenant concentration, the WALT module, the retention module, the rollover module, lease recovery, or stabilization are absent (coverage and drivers default to observed data and neutral inference). All upstream types matched the spec exactly. Lease abstract completeness and critical date risk is a deterministic underwriting screen. It is not a legal lease review or an abstracting opinion, and it treats absent lease fields as diligence gaps rather than inferred terms.
Phase 3 continues: Lease Expiration Concentration and Weighted Average Lease Term Risk Index lands on top of the leasing-economics stack. The memo now reads lease-expiration structure: whether income durability is protected by enough remaining term, or whether too much rent rolls inside the hold. It surfaces WALT, a duration posture, rent rolling within the hold, the largest single-year expiration, near-term expiration, estimated re-leasing exposure, a year-by-year expiration schedule, and a per-tenant lease-term table. 130 Phase 3 modules cumulative.
The memo carries TI, LC, and free rent concession risk, tenant rollover downtime reserve adequacy, and tenant retention risk. This module adds the lease-expiration structure layer: whether income durability is protected by enough remaining lease term, or whether too much rent rolls inside the hold. An underwriting screen, not a broker opinion or a lease audit, and it does not predict renewal outcomes with certainty. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. Weighted average lease term (WALT) is the rent-weighted remaining term across tenants with usable lease-term data, where remaining term equals leaseStartYear plus leaseTermYears minus one (the expiration year from acquisition), capped per lease at 40 years; tenants without usable term are left out of WALT rather than fabricated, and WALT reads null when no usable term exists. WALT posture classifies long-duration at 7-plus years, balanced-duration at 4 to 7, near-term-heavy at 2 to 4, thin-term under 2, not-assessable when null. Rent rolling within hold is the share of rent whose lease expires at or before the hold, largest-expiration-year is the peak single-year expiration share, and near-term expiration covers the first third of the hold capped at three years; the rolling and largest-year reads are cross-checked with the maximum of the computed value and the Rollover module rolloverExposurePct and the TenantConcentration maxAnnualRolloverPct so sparse dates never understate risk. Estimated re-leasing exposure prefers the Rollover module downtimeReserveNeed, else rolling rent times 0.75, reported as an average annual NOI drag in bps. Six weighted drivers, scored so higher means lower expiration risk: WALT and lease-duration protection 25% (8-plus years 82, 6 70, 4 56, 2.5 40, under 26, plus 4 when WALT runs at least one year past the hold; null degrades to 50), rent rolling within hold 25% (25%-or-under 80, 45 62, 65 44, above 28), largest expiration-year concentration 15% (20%-or-under 80, 35 62, 50 44, above 26), tenant concentration and renewal posture 15% (concentration low 76, moderate 56, high 34; retention sticky-income plus 6, replacement-dependent minus 8, tenant-loss-risk band minus 6), concession and re-leasing cost exposure 10% (NetEffectiveRent drag 8pp-or-under 76, 18pp 60, 30pp 42, above 28; rollover re-tenanting-gap or office functional-obsolescence minus 6), stabilization and cash-conversion cushion 10% (Stabilization stabilized-at-acquisition 78, early 64, mid-hold 46, late 30; CashConversion strong plus 6, typical plus 2, tight minus 4, thin minus 8; positive late-hold NoiDecomp deltaNOI plus 3). Bands: term-protected (composite 76-plus with long-duration or balanced-duration posture and rolling 45%-or-under), near-term-roll-watch (60-75), concentrated-expiration-risk (45-59, or any single year above 50% of rent under composite 68), walt-compression-risk (under 45, or thin-term posture under composite 55, or rolling above 70% under composite 52), not-assessable. Memo surface: verdict banner with band, score, WALT, posture; six headline stats across WALT, rent rolling in hold, largest expiration year, near-term expiration, re-leasing exposure, and average annual NOI drag; a year-by-year expiration schedule for dated leases within the hold with rent share, lease count, and a risk tier (high at 40%-plus of rent, elevated 25, moderate 12, else low), never fabricated; per-tenant rows sorted by rent share with lease term and expiration year, or a proxy note where term is missing; six-driver weighted score table with status, contribution, and interpretation; leasing actions tied to tracking WALT as a standing metric and underwriting each expiration year against the reserve and submarket window (always), protecting WALT ahead of exit with early renewals and blend-and-extend (always), and staggering terms to avoid stacking expirations (always), escalating to a leasing-story framing on short WALT, working the cliff first on a concentrated year, and a full leasing-budget confirmation on heavy rolling; diligence requests tied to the certified rent roll for recomputing WALT and the expiration schedule (always), the largest expiration years against submarket absorption (always), and early-termination or contraction rights that shorten effective WALT (always), plus a complete-lease-abstract request when term coverage runs under 60% and a largest-tenant term and intent confirmation on high concentration; 2-4 deal implications by band including WALT, rolling share, single-year concentration, and re-leasing exposure, with the explicit framing that on walt-compression-risk deals the remaining term is too short to protect the hold and the sponsor either reprices for the structural rollover, secures committed leasing capital sized to the heaviest expiration years, or re-underwrites the renewal and downtime assumptions against submarket reality rather than a flat-renewal assumption. Module auto-skips without a commercial rent roll, degrades to concentration and rollover proxies when lease term or dates are missing, and degrades gracefully when tenant concentration, net effective rent, stabilization, cash conversion, operating margin trend, the rollover module, the retention module, office obsolescence, or NOI decomposition are absent (drivers default to neutral 50-58). All upstream types matched the spec exactly. Lease expiration concentration and weighted average lease term risk is a deterministic underwriting screen. It is not a broker opinion or a lease audit, and it does not predict renewal outcomes with certainty.
Phase 3 continues: Renewal Option, Expansion Rights, and Tenant Retention Risk Index lands on top of the leasing-economics stack. The memo now reads whether the existing tenant base is likely to stay economically intact through renewal, expansion, contraction, or option exercise: renewal exposure within the hold, a retention posture, an estimated retention shortfall, replacement-cost exposure, and a per-tenant retention table. 129 Phase 3 modules cumulative.
The memo carries TI, LC, and free rent concession risk and tenant rollover downtime reserve adequacy. This module adds the retention layer: whether the existing tenant base is likely to stay economically intact through renewal, expansion, contraction, or option exercise. Re-leasing risk asks whether a vacated space can be backfilled; retention risk asks the prior question of whether the tenant leaves at all, and on what terms it renews. An underwriting screen, not leasing advice, a broker opinion, a property-management plan, or a lease abstract, and it does not predict renewal outcomes with certainty. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. Renewal exposure is the share of in-place commercial rent facing a renewal or option decision within the hold (lease end at or before the hold), taken from the TenantRollover module rolloverExposurePct when applicable, else computed from the rent roll. Retention posture classifies sticky-income, market-renewal, negotiation-sensitive, or replacement-dependent from a 0-100 stickiness read built from tenant concentration (high minus 12, moderate minus 5, low plus 4), concession intensity via the TenantConcession band (concession-controlled plus 8, concession-drag-risk minus 8, lease-up-capital-overhang minus 14) or NetEffectiveRent drag fallback, office leasing friction (institutional-quality plus 8, selective-demand minus 6, functional-obsolescence-risk minus 14), and OperatingMargin trend (expanding plus 6, compressing minus 8); mapped sticky-income 72-plus, market-renewal 56-71, negotiation-sensitive 40-55, replacement-dependent under 40. A non-retention share keyed to posture (sticky-income 10%, market-renewal 18%, negotiation-sensitive 28%, replacement-dependent 40%) drives the estimated annual retention shortfall (rolling rent times non-retention share times 0.5 for partial backfill) and the one-time replacement-cost exposure (TenantRollover downtimeReserveNeed times non-retention share when applicable, else rolling rent times non-retention share times 0.75). Average annual retention shortfall is reported in bps of Y1 NOI. Six weighted drivers, scored so higher means lower retention risk: tenant concentration and renewal exposure 25% (exposure 25%-or-under 78, 45% 60, 65% 42, above 28; concentration high minus 8 or moderate minus 3), renewal economics and concession pressure 20% (TenantConcession band concession-controlled 80, leasing-cost-watch 62, concession-drag-risk 42, lease-up-capital-overhang 24, with high-intensity minus 4 or low plus 4; NetEffectiveRent drag fallback 8pp-or-under 76 down to above-30pp 28), replacement difficulty and leasing friction 20% (OfficeObsolescence institutional-quality 80, leasing-relevant 64, selective-demand 44, functional-obsolescence-risk 28, non-office 60; TenantRollover downtime 9-months-plus minus 6 or 3-or-under plus 4), income durability and margin trend 15% (OperatingMargin expanding 78, stable 60, compressing 36; CashConversion strong plus 6, typical plus 2, tight minus 4, thin minus 8; positive late-hold NoiDecomp deltaNOI plus 3), stabilization and lease-up timing 10% (Stabilization stabilized-at-acquisition 78, early 66, mid-hold 48, late 30), downtime reserve and recovery offset 10% (TenantRollover band rollover-controlled 78, leasing-watch 60, downtime-reserve-watch 44, re-tenanting-gap-risk 28; LeaseRecovery recovery-strong plus 4, leakage-exposed minus 4, sponsor-absorbed-opex-risk minus 6). Bands: retention-supported (composite 76-plus with sticky-income or market-renewal posture), renewal-watch (60-75), option-friction-risk (45-59), tenant-loss-risk (under 45 or one of the structural floors: replacement-dependent posture under composite 50, or renewal exposure above 65% under composite 48), not-assessable. Per-tenant retention risk tiers low to high from rent share, whether the lease reaches a decision within the hold, net-effective-rent drag above 25 points, and a replacement-dependent posture. Memo surface: verdict banner with band, score, retention posture; four-stat headline (renewal exposure, estimated retention shortfall, replacement-cost exposure, average annual NOI drag); per-tenant rows sorted by rent share showing rent percent, retention risk tier, renewal concession pressure, and downtime exposure if lost, flagging leases reaching a decision within versus beyond the hold; six-driver weighted score table with status, contribution, and interpretation; retention actions tied to mapping every lease to its renewal, expansion, contraction, and termination rights and building a renewal calendar (always), underwriting renewals at net effective rent with a tenant-specific renewal probability (always), and opening early conversations with the largest tenants (always), escalating to a modeled non-renewal downside on negotiation-sensitive or replacement-dependent posture, blend-and-extend on heavy exposure, and a building-competitiveness capital check on office functional obsolescence; diligence requests tied to the lease file for renewal options, expansion and contraction and termination and co-tenancy clauses and option-rent mechanics (always), tenant-by-tenant renewal probability against in-place versus market rent and credit (always), and submarket renewal concessions and replacement cost (always), plus a largest-tenant credit and intent confirmation on high concentration and a reserve-carry confirmation on a re-tenanting gap; 2-4 deal implications by band including renewal share, retention shortfall, replacement-cost exposure, and the explicit framing that on tenant-loss-risk deals the income base is exposed to non-renewal the deal cannot easily absorb and the sponsor either reprices for the structural retention risk, secures committed leasing and concession capital sized to the largest renewals, or re-underwrites the renewal and downtime assumptions against submarket reality rather than a flat-renewal assumption. Module auto-skips without a commercial rent roll, and degrades gracefully when tenant concentration, net effective rent, stabilization, cash conversion, operating margin trend, office obsolescence, the concession module, the rollover module, lease recovery, or NOI decomposition are absent (drivers and posture default to neutral 55-60). All upstream types matched the spec exactly. Renewal option, expansion rights, and tenant retention risk is a deterministic underwriting screen. It is not leasing advice, a broker opinion, a property-management plan, or a lease abstract, and it does not predict renewal outcomes with certainty.
Phase 3 continues: Tenant Rollover Re-Leasing and Downtime Reserve Adequacy Index lands on top of the tenant concession layer. The memo now reads whether upcoming rollover can actually be re-leased without creating downtime, a reserve shortfall, or NOI leakage: rollover exposure within the hold, estimated re-leasing downtime, a downtime and re-leasing reserve need against available reserve capacity, the funding gap, releasing complexity, and a per-tenant rollover table. 128 Phase 3 modules cumulative.
The memo carries tenant-level TI, LC, and free rent concession risk. This module adds the re-tenanting layer: whether upcoming rollover can actually be re-leased without creating downtime, a reserve shortfall, or NOI leakage. A pro forma can roll a lease at flat rent with no gap while in practice the space sits vacant for months and needs fresh concessions to backfill. An underwriting screen, not leasing advice, a broker opinion, a property-management plan, or a lease abstract, and it does not predict re-leasing outcomes with certainty. Renders when purchase price, hold of at least one year, and Y1 NOI are present and a commercial rent roll exists; residential-only deals with no commercial tenant array auto-skip. Rollover exposure is the share of in-place commercial rent whose lease expires within the hold (lease end equals leaseStartYear plus leaseTermYears minus one, at or before the hold), with a peak single-year concentration taken from TenantConcentration.maxAnnualRolloverPct or computed from the rent roll. Estimated re-leasing downtime starts from an asset-class baseline (office 9 months, retail and mixed-use 6, industrial 4, hotel 3, multifamily 2) and is replaced by the OfficeObsolescence estimatedDowntimeMonths read for office when available, then scaled for tenant concentration (high 1.25x, moderate 1.1x), office leasing friction (functional-obsolescence-risk 1.2x, selective-demand 1.1x), and a BusinessDisruption interruption overhang (plus one month), capped at 18. Downtime reserve need sums the rent lost during downtime on the rolling space (rolling rent times downtime months over twelve) plus the re-leasing concession to backfill it (the TenantConcession module total exposure scaled to the rolling share, else half a year of rolling rent). Available reserve capacity is ReserveAdequacy.reservesAvgOverHold across the hold, or a one-percent-of-price-per-year proxy; reserve funding gap is the shortfall of need over capacity. Average annual NOI drag from downtime is reported in bps of Y1 NOI. Six weighted drivers, scored so higher means lower re-tenanting risk: rollover exposure and concentration 25% (exposure 25%-or-under 80, 45% 62, 65% 44, above 28; TenantConcentration high minus 8 or moderate minus 3; peak above 50% minus 6), downtime duration and leasing friction 20% (downtime 3-months-or-under 80, 6 62, 9 44, above 28; OfficeObsolescence functional-obsolescence-risk minus 8, selective-demand minus 4, institutional-quality plus 6), TI, LC, and free rent concession burden 20% (TenantConcession band concession-controlled 80, leasing-cost-watch 62, concession-drag-risk 42, lease-up-capital-overhang 24; high intensity minus 4 or low intensity plus 4), reserve adequacy and cash conversion 15% (ReserveAdequacy adequate 76, thin 50, under-reserved 30; CashConversion strong plus 6, typical plus 2, tight minus 4, thin minus 8; sponsor-gap posture minus 6 or reserve-covered plus 4), stabilization and lease-up timing 10% (Stabilization stabilized-at-acquisition 78, early 66, mid-hold 48, late 30; positive late-hold NoiDecomp deltaNOI plus 3), business disruption and recovery offset 10% (BusinessDisruption low-disruption-plan 76, tenant-coordination-watch 60, downtime-leakage-risk 44, business-interruption-overhang 28; LeaseRecovery recovery-strong plus 4, leakage-exposed minus 4, sponsor-absorbed-opex-risk minus 6). Reserve posture classifies reserve-covered (no gap), partial-reserve (gap under half the need), or sponsor-gap (gap at half the need or more). Releasing complexity classifies low to high from a points sum: office plus 2 or retail and mixed-use plus 1, OfficeObsolescence functional-obsolescence-risk plus 2 or selective-demand plus 1 or institutional-quality minus 1, high concentration plus 1, downtime 9-months-plus plus 1 (high at 4-plus, elevated at 2, moderate at 1, else low). Bands: rollover-controlled (composite 76-plus with low or moderate complexity and exposure 45% or under), leasing-watch (60-75), downtime-reserve-watch (45-59), re-tenanting-gap-risk (under 45 or one of the structural floors: sponsor-gap reserve with high complexity under composite 55, exposure above 65% under composite 50, or high complexity under composite 48), not-assessable. Memo surface: verdict banner with band, score, releasing complexity, reserve posture; headline stats across rollover exposure, estimated downtime, downtime reserve need, reserve funding gap, available reserve capacity, and average annual NOI drag; per-tenant rows sorted by rent share showing rent percent, rollover risk tier, estimated downtime, re-leasing concession, and a per-line read that flags leases rolling within versus beyond the hold; six-driver weighted score table with status, contribution, and interpretation; leasing actions tied to a year-by-year rollover budget with downtime and concession per expiration (always), a reserve sized to the peak rollover year rather than the hold average (always), and net-effective-rent renewal underwriting with a realistic renewal probability (always), escalating to early renewal and blend-and-extend on heavy exposure, a committed funding source on a reserve gap, and early leasing brokerage on high complexity; diligence requests tied to the expiration and renewal-terms schedule reconciled to the model (always), submarket downtime, TI, LC, and free rent comps with leasing velocity (always), and the reserve funding plan sized to the peak year (always), plus a peak-concentration confirmation, an office-obsolescence downtime and TI check, and an under-reserved follow-up; 2-4 deal implications by band including rollover share, downtime months, reserve need, capacity, and gap, with the explicit framing that on re-tenanting-gap-risk deals the rollover schedule threatens downtime and re-leasing cost the reserve cannot carry and the sponsor either reprices for the structural re-tenanting exposure, secures committed leasing capital sized to the peak expiration year, or re-underwrites the renewal and downtime assumptions against submarket reality rather than a flat-renewal assumption. Module auto-skips without a commercial rent roll, and degrades gracefully when tenant concentration, net effective rent, stabilization, cash conversion, office obsolescence, the tenant concession module, business disruption, lease recovery, reserve adequacy, or NOI decomposition are absent (drivers and posture default to neutral 55-58). All upstream types matched the spec exactly. Tenant rollover re-leasing and downtime reserve adequacy is a deterministic underwriting screen. It is not leasing advice, a broker opinion, a property-management plan, or a lease abstract, and it does not predict re-leasing outcomes with certainty.
Phase 3 continues: Tenant Improvement, Leasing Commission, and Free Rent Concession Risk Index lands on top of the full capex and operating-risk stack. The memo now reads the leasing economics: whether tenant improvements, leasing commissions, free rent, rollover timing, downtime, and concession leakage can absorb the NOI story before rent growth ever reaches the sponsor, with total concession exposure, an annualized NOI drag, concession intensity, funding posture, and a per-tenant concession table off the rent roll. 127 Phase 3 modules cumulative.
The memo carries the full capex arc (procurement, draw control, warranty and closeout, capital project ROI, exit value protection, diligence evidence) plus business disruption risk. This module adds the leasing-economics layer: whether tenant improvements, leasing commissions, free rent, rollover timing, downtime, and concession leakage can absorb the NOI story before rent growth ever reaches the sponsor. A pro forma can show clean rent growth while the cost of buying that occupancy quietly consumes the early-hold cash. Not a leasing plan, broker commission schedule, TI budget, or lease abstract. Renders when purchase price, hold of at least one year, and Y1 NOI are present and the Net Effective Rent module surfaces a commercial rent roll with at least one tenant; residential-only deals without tenant-level lease detail auto-skip with a clear not-assessable reason. Total concession exposure sums each tenant's free rent dollars plus TI and LC dollars over the lease term, read directly from the NetEffectiveRent tenant rows (concessionTerm). Annualized concession drag spreads that capital across the hold and is reported in dollars and in bps of Y1 NOI; total concession exposure is also expressed as a multiple of one year of NOI. Concession intensity classifies low, moderate, elevated, or high from the SF-weighted net-effective-rent drag below face (8 points or under low, 18 moderate, 30 elevated, above high), with a one-step bump when concession capital exceeds 1.5x Y1 NOI and a one-step relief under 0.25x. Recovery posture classifies cash-flow-funded, reserve-supported, capex-funded, or sponsor-gap by blending CashConversion band (strong or typical funds from cash flow, tight leans on reserves, thin pushes to capex or a sponsor gap when intensity is elevated or worse; a negative worst-year conversion plus heavy intensity forces sponsor-gap) with the CapitalProjectRoi funding plan as a fallback. Rollover overlap is the maximum share of rent expiring in a single year, taken from TenantConcentration.maxAnnualRolloverPct when applicable, else computed from the raw rent roll by bucketing rent at each lease's end year. Five weighted drivers, scored so higher means lower concession risk: concession intensity vs face rent 25% (drag 8pp-or-under 82, 18pp 64, 30pp 44, above 26), concession capital vs NOI 25% (exposure 0.25x-or-under of NOI 82, 0.5x 66, 1.0x 46, 1.5x 32, above 22; drag 50bps-or-under plus 4 or 200bps-plus minus 6), rollover overlap and timing 20% (overlap 25%-or-under 78, 40% 62, 55% 44, above 28; Stabilization stabilized-at-acquisition plus 6 or late-stabilization minus 8 or mid-hold minus 3; positive late-hold NoiDecomp deltaNOI plus 3), recovery and funding posture 15% (cash-flow-funded 80, reserve-supported 62, capex-funded 44, sponsor-gap 26; negative worst-year conversion minus 4), leasing execution and downtime 15% (PM execution institutional-operator plus 12, controlled plus 4, execution-watch minus 6, management-leakage-risk minus 12; OfficeObsolescence institutional-quality plus 6, selective-demand minus 4, functional-obsolescence-risk minus 8; BusinessDisruption interruption-overhang minus 6 or high downtime minus 3; LeaseRecovery recovery-strong plus 4, leakage-exposed minus 4, sponsor-absorbed-opex-risk minus 6). Bands: concession-controlled (composite 76-plus with low or moderate intensity), leasing-cost-watch (60-75), concession-drag-risk (45-59), lease-up-capital-overhang (under 45), not-assessable. Hard structural floors anchor to lease-up-capital-overhang: sponsor-gap funding with high intensity under composite 55, rollover overlap above 55% under composite 50, or high intensity under composite 48. Memo surface: verdict banner with band, score, concession intensity, recovery posture; four-stat headline (total concession exposure, annualized concession drag dollars, average annual NOI drag bps, rollover overlap); per-tenant rows sorted by concession exposure showing free rent months, TI and LC dollars, exposure dollars, a risk tier, and a net-effective-rent read; five-driver weighted score table with status, contribution, and interpretation; leasing actions tied to underwriting TI, LC, and free rent as a standing capital line keyed to the rollover schedule (always), holding net effective rent rather than face as the underwriting anchor (always), and staging a leasing reserve sized to the peak rollover year (always), escalating to face-rent achievability pressure-testing on elevated or high intensity, blend-and-extend or staggered terms on clustered rollover, and a confirmed funding source on capex-funded or sponsor-gap posture; diligence requests tied to the full rent roll with per-lease face rent, free rent, TI and LC, and expiration reconciled to the pro forma (always), market TI, LC, and free rent confirmation for comparable space (always), and the leasing-capital funding plan (always), plus a peak-rollover window confirmation, an office-obsolescence TI check on functional-obsolescence-risk, and a re-leasing downtime cross-check against the business-disruption window; 2-4 deal implications by band including concession exposure dollars, the NOI multiple and bps drag, and the explicit framing that on lease-up-capital-overhang deals the cost of buying and holding occupancy threatens to consume the NOI story before rent growth reaches the sponsor and the sponsor either reprices for the structural concession load, secures committed leasing capital sized to the peak rollover year, or re-underwrites face rents net of the concessions required to achieve them. Module auto-skips without a commercial rent roll, and degrades gracefully when tenant concentration, stabilization, cash conversion, lease recovery, PM execution, business disruption, capital project ROI, office obsolescence, or NOI decomposition modules are absent (drivers and posture default to neutral 55-60). All upstream types matched the spec exactly. Tenant improvement, leasing commission, and free rent concession risk is a deterministic underwriting overlay. It is not a leasing plan, broker commission schedule, TI budget, or lease abstract.
Phase 3 continues: Capital Improvement Business Disruption and Tenant Downtime Risk Index lands on top of the full capex arc. The memo now reads what the capital work does to the building while it is occupied: the disruption footprint across in-unit-or-suite, common-area, building-systems, and sitewide-or-phased scope, the tenant downtime risk, the mitigation and sequencing posture, an estimated effective downtime in months, and the NOI interruption in dollars and in bps of NOI during the hold. 126 Phase 3 modules cumulative.
The capex family now covers procurement, draws, closeout, ROI prioritization, exit value protection, and buyer-recognition diligence evidence. This module adds the missing operating-risk layer: what the capital work does to the building while it is occupied, and whether the improvements disrupt rent collection, tenant operations, leasing velocity, occupancy, reimbursements, or NOI during the hold. Not a construction schedule, tenant-relations plan, business-interruption insurance opinion, or relocation estimate. Renders when purchase price, hold of at least one year, and Y1 NOI are present and either the Capital Project ROI Prioritization module is applicable or the Implied Capex Yield Curve carries positive capex scope. The capex scope mix is taken from CapitalProjectRoi scope rows when available, else the ImpliedCapexYieldCurve category mix, and each category carries a disruption footprint weight (capital-improvements 0.80, climate 0.70, compliance 0.60, leasing 0.40, insurance 0.40, reserves 0.20). The dollar-weighted footprint crossed with property type sets the disruption scope: in-unit-or-suite, common-area, building-systems, or sitewide-or-phased, with hotels pushed to sitewide-or-phased on any meaningful program (footprint 0.35-plus) and industrial capped at building-systems because crews work around the tenant. Tenant downtime risk classifies low, moderate, elevated, or high from a scope rank (in-unit-or-suite 0, common-area 1, building-systems 2, sitewide-or-phased 3) plus tenant-concentration amplifier (TenantConcentration riskTier high plus 1, moderate plus 0.5) plus asset-type adjustment (hotel plus 1 for rooms offline, multifamily in-unit turn-based minus 0.5, industrial minus 0.5). Mitigation posture blends the PropertyManagementExecution band (institutional-operator 86, controlled-execution 70, execution-watch 46, management-leakage-risk 26) with CapexProcurement (procurement-controlled plus 6, contractor-execution-risk minus 8, capex-delivery-gap minus 12), CapexDrawSchedule (draw-control-strong plus 4, capex-cash-crunch minus 8), and CapexWarranty (closeout-controlled plus 3, retainage-dispute-risk minus 6) into a 0-100 control score mapped to sequenced-and-communicated (80-plus), manager-controlled (60-79), contractor-dependent (40-59), or unmitigated (under 40). Estimated effective downtime in months scales a scope baseline (in-unit-or-suite 1.5, common-area 3, building-systems 5, sitewide-or-phased 9) by a capex-intensity factor against price (0.7x to 1.8x around a 10%-of-price program), a mitigation factor (sequenced-and-communicated 0.7x, manager-controlled 0.9x, contractor-dependent 1.15x, unmitigated 1.4x), an asset-type factor (hotel 1.3x, retail 1.15x, mixed-use 1.1x, office 1.05x, multifamily 0.9x, industrial 0.7x), and a deferred-maintenance factor (RepairMaintenanceShock deferred-maintenance-overhang 1.15x, capex-leakage-risk 1.08x), capped at 18 months. Estimated NOI interruption equals monthly Y1 NOI times downtime months times an interruption share by scope (in-unit-or-suite 8%, common-area 15%, building-systems 25%, sitewide-or-phased 45%) adjusted for tenant concentration (high 1.3x, moderate 1.1x) and asset type (hotel 1.3x, industrial 0.8x), capped at a 70% share; the figure is reported as a total across the hold and as an average annual NOI drag in bps of Y1 NOI. Five weighted drivers, scored so higher means lower disruption risk: disruption scope and footprint 25% (in-unit-or-suite 80, common-area 64, building-systems 46, sitewide-or-phased 28; footprint 0.7-plus minus 4 or 0.35-or-under plus 4), tenant downtime exposure 25% (low 82, moderate 64, elevated 44, high 26, not-assessable 55), mitigation and sequencing posture 20% (the control score above), capex intensity and duration 15% (intensity 3%-or-under of price 78, 7% 62, 12% 46, above 30; downtime 2-months-or-under plus 6 or 8-months-plus minus 8), reimbursement and income continuity 15% (LeaseRecovery recovery-strong 78, recovery-watch 60, leakage-exposed 40, sponsor-absorbed-opex-risk 30, none 58 neutral; ExitValueProtection noiDurabilityScore 70-plus plus 4 or under 45 minus 4; positive late-hold NoiDecomp deltaNOI plus 3). Bands: low-disruption-plan (composite 76-plus with in-unit-or-suite or common-area scope and downtime risk not high), tenant-coordination-watch (60-75), downtime-leakage-risk (45-59), business-interruption-overhang (under 45), not-assessable. Hard structural floors anchor to business-interruption-overhang: high tenant downtime risk with unmitigated posture under composite 58, sitewide-or-phased scope under composite 50, or hotel sitewide work that is not sequenced-and-communicated under composite 60. Memo surface: verdict banner with band, score, tenant downtime risk, disruption scope; four-stat headline (estimated downtime months, NOI interruption dollars, average annual NOI drag bps, mitigation posture); per-category scope rows with risk tier, allocated downtime months, allocated NOI interruption dollars, and a per-line read (the allocation is proportional to each category's share-times-footprint contribution, with the row risk bumped up when the category share is 0.40-plus or the asset is a hotel and down for industrial); five-driver weighted score table with status, contribution, and interpretation; mitigation actions tied to occupancy-aware phasing by stack or floor (always), a tenant-communication protocol with advance notice and a named site contact (always), a budgeted disruption line for concessions and after-hours premiums (always), swing systems and off-peak shutdowns on building-systems or sitewide scope, lease abatement and quiet-enjoyment clause review on elevated or high downtime exposure, a sponsor-side construction manager on contractor-dependent or unmitigated posture, and rooms-offline modeling against the seasonal RevPAR calendar on hotels; diligence requests tied to the per-line construction schedule with occupied-versus-vacant flags (always), the tenant-impact and lease-clause analysis (always), the operator track record running capital work in an occupied asset (always), a disruption stress on the pro forma against the estimated interruption dollars, a deferred-maintenance staging confirmation when R&M flags overhang, and a sponsor-absorbed-opex budget check when lease recovery flags sponsor-absorbed opex; 2-4 deal implications by band including downtime months, interruption dollars, and bps drag, with the explicit framing that on business-interruption-overhang deals the sponsor either re-sequences the work to protect occupied income, secures the operator and occupancy-protection plan the scope requires, or reprices for the interruption the plan implies. Module auto-skips when price, hold, or Y1 NOI is missing, or when neither the ROI prioritization nor a positive Implied Capex Yield Curve is available. Module degrades gracefully when property management, procurement, draw, warranty, R&M, tenant concentration, lease recovery, exit value, or NOI decomposition modules are absent (drivers and reads default to neutral 50-58). All upstream types matched the spec exactly. Capital improvement business disruption and tenant downtime risk is a deterministic underwriting overlay. It is not a construction schedule, tenant-relations plan, business-interruption insurance opinion, or relocation estimate.
The AI assist layer moves to Claude Opus 4.8. The broker-memo parser, the qualitative deal review, and the IC executive summary now run on Anthropic's newest Opus model. Same forced tool use, same structured output, same privacy posture. The deterministic engine is untouched, so every number in the BOE still comes from pure TypeScript with zero model involvement in the math path. 125 Phase 3 modules cumulative.
Three features moved to Claude Opus 4.8: the broker-memo parser that reads a listing or OM and pre-fills the deal form, the qualitative deal review, and the on-demand IC executive summary. Each still runs server-side, with forced tool use and a strict output schema, so the response shape and the privacy posture are unchanged. The math path did not move. The verdict, the grade, the pro forma, the debt schedule, the waterfall, and every exported figure are still produced by deterministic TypeScript, and the model only touches the extraction and qualitative layers that sit outside the engine. The model label in the AI Parser and Deal Review panels now reads claude-opus-4-8, and the rate limit and confidential-mode controls are unchanged. No engine math changed, so the canonical Cherry Street numbers and the 125-module count are exactly as before.
Phase 3 continues: Capital Improvements Buyer Recognition and Diligence Evidence Index lands on top of capital project ROI prioritization and exit value protection. The memo now reads whether a future buyer, lender, or IC reviewer can actually verify the completed capital work through invoices, warranties, permits, lien waivers, before-after documentation, reserve schedules, and NOI attribution, with an estimated recognition discount on productive capex when the documentation trail does not survive institutional diligence. 125 Phase 3 modules cumulative.
The memo carries capital project ROI prioritization and exit value protection. This module adds the evidence-quality layer: whether a future buyer, lender, or IC reviewer can actually verify the completed capital work through invoices, warranties, permits, lien waivers, before-after documentation, reserve schedules, and NOI attribution. Not a diligence checklist, document-management opinion, legal review, or audit. Renders when purchase price, hold of at least one year, and Y1 NOI are present and either the Capital Project ROI Prioritization module is applicable or the Implied Capex Yield Curve has a positive total capex scope. Five per-dimension support reads classified as documented, partial, thin, or not-assessable: invoice and contract support (CapexProcurement procurement-controlled and CapexDrawSchedule draw-control-strong yields documented; capex-delivery-gap or capex-cash-crunch yields thin; mid-band yields partial), warranty and lien-waiver support (CapexWarranty band: closeout-controlled documented, punchlist-watch partial, warranty-recovery-risk or retainage-dispute-risk thin), permit and closeout documentation (closeout-controlled plus procurement-controlled documented; PM management-leakage-risk floors thin; warranty-recovery-risk, retainage-dispute-risk, or capex-delivery-gap yields thin), NOI attribution support (CapitalProjectRoi productive share 50%-plus with positive late-hold NoiDecomp deltaNOI plus ExitValueProtection fully-recognized yields documented; productive share 35%-50% yields partial; low-recognition tier or low productive share yields thin), cost basis substantiation (procurement-controlled documented; capex-delivery-gap or above-band acquisition basis yields thin; below-band acquisition basis or positive ImpliedCapexYieldCurve incremental NOI adds bonus). Evidence package completeness classification across the five reads: strong (4-plus documented; or 3-plus documented with no thin), moderate (2-plus documented with at most 1 thin), thin (2-plus thin), weak (3-plus thin), not-assessable (3-plus not-assessable). Six weighted drivers: evidence package completeness 25% (strong 84, moderate 66, thin 44, weak 26, not-assessable 50), invoice and contract support 15% (documented 84, partial 62, thin 36; procurement-controlled plus 4, draw-control-strong plus 3), warranty and lien-waiver support 15% (documented 84, partial 62, thin 36; closeout-controlled plus 4), permit and closeout documentation 15% (documented 80, partial 60, thin 36; PM institutional-operator plus 4 or management-leakage-risk minus 8), NOI attribution support 20% (documented 82, partial 60, thin 34; roi-prioritized-plan plus 4 or low-yield-capex-drag minus 8; R&M deferred-maintenance-overhang minus 6), cost basis substantiation 10% (documented 80, partial 60, thin 36; below-band acquisition basis plus 4; ImpliedCapexYieldCurve positive incremental NOI plus 2). Bands: evidence-ready (composite 78-plus and completeness strong and warranty read not thin), buyer-recognition-supported (63-77), diligence-package-watch (48-62), recognition-discount-risk (under 48 or CapexWarranty retainage-dispute-risk with score under 65 or weak completeness with score under 60), not-assessable. Hard structural floors: retainage-dispute-risk closeout with weak composite anchors to recognition-discount-risk; weak evidence completeness with weak composite anchors to recognition-discount-risk. Estimated recognition discount dollars equals discount anchor (productive capex from CapitalProjectRoi when available, else ImpliedCapexYieldCurve.totalCapex) times band-driven leakage factor (evidence-ready 0%, buyer-recognition-supported 2.5%, diligence-package-watch 6%, recognition-discount-risk 12%). Memo surface: verdict banner with band, score, evidence completeness, warranty support read; four-stat headline (estimated recognition discount in gold, evidence completeness tier, warranty support read, NOI attribution support read); five-cell per-dimension support strip (invoice and contract, warranty and lien-waiver, permit and closeout, NOI attribution, cost basis); six-driver weighted score table with status, contribution, and interpretation; evidence actions tied to standing up a structured diligence data room with organized folders, AIA G702/G703 pay applications, lien waivers, permit copies, inspection sign-offs, warranty certificates, before-after photos (always), maintaining a per-line capex ledger mapping every dollar to productivity class and NOI line (always), pulling contractor closeout packages at substantial completion (always), reconstructing invoice and payment trail on thin invoice support, opening warranty audit on thin warranty support, confirming AHJ permit closeout on thin permit documentation, preparing per-line NOI attribution memo on thin NOI attribution, pulling all-in cost reports on thin cost basis, dedicated diligence lead on weak completeness; diligence requests tied to the full capex diligence package including line-item invoices, AIA G702/G703 forms, retainage release records, conditional and unconditional lien waivers, building permits with closeout signatures, final inspection records, certificate of occupancy where applicable, and warranty riders per scope (always), per-line NOI attribution evidence with rent roll, occupancy, operating expense, and before-after photos for productive lines (always), contractor performance documentation including contracts, change orders, GMP exhibits, performance bonds, retainage release schedules, and warranty transferability clauses (always), dispute correspondence and mechanic's lien filings on retainage-dispute-risk, bid documentation and three-reference checks on capex-delivery-gap, all-in cost report and stabilized basis memo on above-band acquisition basis, narrative reframe on low buyer recognition; 2-4 deal implications by band including estimated recognition discount dollars and anchor capex dollars, with the explicit framing that on recognition-discount-risk deals the capex story cannot be substantiated to institutional standards and the sponsor either restructures the diligence package well before listing or reprices the deal for the structural recognition discount, and on diligence-package-watch deals a focused pre-exit sprint can move the package to ready. Module auto-skips when purchase price, hold, or Y1 NOI is missing, or when neither Capital Project ROI Prioritization nor a positive Implied Capex Yield Curve is available. Module degrades gracefully when exit value protection, warranty, draw schedule, procurement, R&M, PM execution, acquisition basis, or NOI decomp modules are absent (drivers and reads default to neutral 50-60 or not-assessable). All upstream types matched the spec exactly. Capital improvements buyer recognition and diligence evidence is a deterministic underwriting overlay. It is not a diligence checklist, document-management opinion, legal review, or audit.
Phase 3 continues: Capital Project Exit Value Protection Index lands on top of the full capital-project arc. The memo now reads protected and at-risk exit value, exit cap defense in bps, NOI durability at exit, buyer recognition tier across fully-recognized, partially-recognized, defensive-only, and low-recognition, and marketability read across institutional, financeable, diligence-dependent, and thin-buyer-read by synthesizing capital project ROI prioritization, cap rate persistence, cap rate wave pattern, vintage backtest, transaction liquidity, acquisition basis, YOC, NOI decomp, and capex closeout signals into a single terminal-value read. 124 Phase 3 modules cumulative.
The memo carries capex procurement, draw and payment control, warranty and retainage closeout, and capital project ROI prioritization. This module adds the terminal-value layer: whether the capital plan actually defends buyer confidence, exit cap assumptions, NOI durability, marketability, and lender or buyer diligence at sale. Not an appraisal, broker opinion of value, exit-cap forecast, or buyer-readiness opinion. Renders when purchase price, hold of at least one year, and Y1 NOI are present and either the Capital Project ROI Prioritization module is applicable or the Implied Capex Yield Curve has a positive total capex scope. Underwritten exit value is computed from terminal-year NOI capitalized at the underwritten exit cap rate from inputs.growth.exitCapRate, with fallback to purchase price when the exit cap is missing or out of the 1-20% sanity range. Six weighted drivers: NOI durability at exit 25% (CapitalProjectRoi productive capex share 65%-plus 84, 50% 72, 35% 58, 20% 44, under 30; low-yield-capex-drag minus 10 or defensive-capex-heavy minus 4; late-hold NoiDecomp deltaNOI sustained at 60%-plus of early-hold pace plus 6 or reversing minus 8; YieldOnCostAnalysis exit yield 8%-plus plus 4 or under 5% minus 6), exit cap defense 25% (CapRatePersistenceForecast band: persistent 82, mild-mean-reversion 68, active-mean-reversion 48, reset-risk 28; terminalGapToUnderwriting minus 50 bps plus 4 or 25-plus minus 4 or 75-plus minus 8; CapRateWavePatternDetector band: constructive-reset plus 6 or late-cycle-pressure minus 6 or dislocation-risk minus 12; wave phase late or reset minus 3), buyer recognition of capex value 15% (productive share 60%-plus fully-recognized 82, 40-60% partially-recognized 64, defensive share 50%-plus defensive-only 48, otherwise low-recognition 32; CapexWarranty retainage-dispute-risk minus 12 with downgrade or warranty-recovery-risk minus 8 or closeout-controlled plus 4; CapexProcurement capex-delivery-gap minus 10 with downgrade or procurement-controlled plus 3), marketability and buyer pool depth 15% (TransactionLiquidity liquidityBand: deep 84 institutional, active 68 financeable, thin 42 diligence-dependent, illiquid 24 thin-buyer-read; VintageYearBacktest band: favorable-vintage plus 6 or selective-vintage plus 2 or challenged-vintage minus 10 with marketability downgrade), basis cushion at exit 10% (AcquisitionBasis status: below-band 80, in-band 62, above-band 38; YieldOnCostAnalysis exit yield above entry cap plus 6 or below minus 6), capex closeout quality 10% (CapexWarranty closeout-controlled 84, punchlist-watch 64, warranty-recovery-risk 42, retainage-dispute-risk 24; CapexProcurement procurement-controlled plus 4 or capex-delivery-gap minus 8; CapexDrawSchedule capex-cash-crunch minus 6 or draw-control-strong plus 3). Bands: exit-value-protected (composite 78-plus and buyer recognition not low-recognition and marketability not thin-buyer-read), marketability-supported (63-77), buyer-diligence-watch (48-62), terminal-value-leakage (under 48 or CapRatePersistenceForecast reset-risk with score under 65 or low-recognition buyer tier with score under 60 or thin-buyer-read marketability with score under 55), not-assessable. Hard structural floors: reset-risk cap persistence under composite 65 anchors to terminal-value-leakage; low-recognition buyer tier or thin-buyer-read marketability under their respective composite thresholds anchor to terminal-value-leakage regardless of other signals. Protected exit value equals underwritten exit value times the composite score over 100, further adjusted multiplicatively by CapRatePersistenceForecast.exitValueImpactPct when that signal is negative. At-risk exit value is the residual of underwritten exit value less protected. Memo surface: verdict banner with band, score, buyer recognition tier, marketability read; four-stat headline (protected exit value in gold, at-risk exit value, exit cap defense bps, NOI durability score); two-cell posture strip (buyer recognition tier, marketability read); six-driver weighted score table with status, contribution, and interpretation; exit preparation actions tied to mapping every productive capex line to incremental NOI verifiable on the rent roll at sale (always), carrying warranty riders and retainage release schedule and lien-waiver documentation in the diligence room from the start (always), underwriting the exit cap against live persistence and wave signals rather than flat extrapolation (always), repositioning the IC narrative around cap rate stability on low-recognition or defensive-only buyer tiers, early exit broker engagement and pre-packaged data room on thin or diligence-dependent marketability, hold-period extension or refi-to-distribution or structural haircut on reset-risk cap persistence, resolving open punchlist warranty and lien items before listing on retainage-dispute-risk; diligence requests tied to the full closeout package including warranty certificates, retainage release records, lien waivers, punchlist completion sign-offs, contractor final acceptance (always), per-line incremental NOI capture verification against rent roll, leasing velocity, occupancy, and operating data at exit (always), recent 12-24 month transaction comps validating exit cap against actual buyer trades not brokered listings (always), replacement-cost analysis and recent rebuy comp on above-band acquisition basis, buyer-pool diligence depth confirmation on sub-6% exit YOC, expanded buyer search by adjacent submarkets and 1031-exchange or foreign-capital channels on thin or illiquid transaction liquidity, delayed-sale stress test on challenged vintage; 2-4 deal implications by band including protected and at-risk exit value dollars, buyer recognition tier, marketability read, and the explicit framing that on terminal-value-leakage deals the capex program does not defend the underwritten exit value and the sponsor either restructures scope toward productive lines, reprices the exit assumption for the structural leakage, or accepts that the deal is a defensive hold rather than a value-realization story. Module auto-skips when purchase price, hold, or Y1 NOI is missing or when neither Capital Project ROI Prioritization nor a positive Implied Capex Yield Curve is available. Module degrades gracefully when cap rate persistence, cap rate wave, vintage year, transaction liquidity, acquisition basis, YOC, NOI decomp, capex procurement, draw, or warranty modules are absent (drivers default to neutral 50-60). All upstream types matched the spec exactly. Capital project exit value protection is a deterministic underwriting overlay. It is not an appraisal, broker opinion of value, exit-cap forecast, or buyer-readiness opinion.
The memo carries capex procurement, draw and payment control, warranty and retainage closeout, repair reserve shock, working capital cushion, and property-management execution. This module adds the prioritization layer: which capex dollars are productive, defensive, or low-yield, and how the sponsor should sequence the work across immediate, near-term, defer, and eliminate decisions. Not a construction recommendation, capital plan, scope-of-work design opinion, or contractor selection guide. Renders only when upstream ImpliedCapexYieldCurve is applicable with a positive total capex scope. Scope rows are built from the upstream categoryMix and each category is classified into productivity class: productive (leasing, capital-improvements), defensive (climate, insurance, compliance), low-yield (reserves). Recommended sequencing per category: compliance always immediate; leasing always immediate; reserves near-term, escalated to immediate when RepairMaintenanceShock flags deferred-maintenance-overhang or capex-leakage-risk; capital-improvements immediate when payback at most 4 years, near-term when payback 5-7, defer when implied yield is null or non-positive; climate defer; insurance near-term. Implied ROI on productive scope equals upstream totalIncrementalNoi divided by productive capex dollars, fallback to upstream impliedCapexYield. Six weighted drivers: productive NOI contribution 25% (productive share 65%-plus 84, 50% 70, 35% 54, 20% 38, under 24; implied yield 12%-plus plus 6, 8% plus 2, under 4% minus 6; payback at most 3 plus 4, 8-plus minus 4), payback and yield on cost 20% (payback at most 3 80, 5 66, 7 48, beyond 32; no payback 36; implied yield overlay plus or minus; YieldOnCostAnalysis exit 8%-plus plus 4 or under 5% minus 4), defensive reserve burden 20% (combined defensive plus low-yield share at most 30% 80, 50% 66, 70% 48, beyond 30; R&M deferred-maintenance-overhang minus 8 or capex-leakage-risk minus 4), sequencing and draw-control quality 15% (CapexDrawSchedule band: draw-control-strong 80, payment-sequencing-watch 62, retainage-and-waiver-risk 44, capex-cash-crunch 26; CapexProcurement capex-delivery-gap minus 8 or contractor-execution-risk minus 4 or procurement-controlled plus 4; PropertyManagementExecution institutional-operator plus 4 or execution-watch minus 4 or management-leakage-risk minus 8), warranty and procurement closeout control 10% (CapexWarranty band: closeout-controlled 82, punchlist-watch 64, warranty-recovery-risk 44, retainage-dispute-risk 26; procurement-controlled plus 3 or capex-delivery-gap minus 6), cash conversion and working capital cushion 10% (WorkingCapital band: liquidity-covered 78, reserve-supported 64, working-capital-watch 44, liquidity-gap-risk 28; CashConversionResult strong plus 4 or tight minus 4 or thin minus 8; NoiDecompYear cumulative deltaNOI positive plus 2). Bands: roi-prioritized-plan (composite 78-plus and productive share 50%-plus and payback at most 5 or null), defensive-capex-heavy (defensive share 60%-plus regardless of score), scope-sequencing-watch (48-77), low-yield-capex-drag (under 48 with productive share under 40% and null or low implied yield, or low-yield share 50%-plus with score under 60), not-assessable. Hard structural floors: defensive-heavy is a label applied whenever defensive scope dominates regardless of score quality; low-yield-capex-drag triggers whenever the productive thesis is weak. Memo surface: verdict banner with band, score, productive share, payback; four-stat headline (productive capex in gold, defensive capex, low-yield capex, implied ROI on productive scope); scope rows table by category showing dollars, share, productivity class, recommended sequencing, and per-line interpretation; six-driver weighted score table with status, contribution, and interpretation; underwriting actions tied to tagging every line with productivity class before approving the budget (always), sequencing productive scope ahead of defensive and low-yield (always), carrying productive capex against an explicit incremental NOI target (always), reclassification when productive share runs under 40%, payback pressure-test when payback runs beyond year 7, R&M-driven reserve escalation when deferred-maintenance-overhang is flagged, IC-memo preservation framing when defensive share runs at or above 60%; diligence requests tied to the full capex schedule with line-item dollars and contractor mapping (always), per-line incremental NOI assumptions (always), regulatory or carrier triggers behind defensive scope (always), rent and OpEx comp validation on productive-heavy plans, property condition assessment alignment on reserve-heavy plans, sponsor liquidity and bridge confirmation when draw schedule reads cash-crunch, performance bonds and warranty riders when closeout flags warranty or retainage risk; 2-4 deal implications by band including productive, defensive, and low-yield dollars in absolute and share terms, implied ROI on productive scope, payback year, and the explicit framing that on low-yield-capex-drag deals the underwriting math does not support a value-add and the deal is a preservation hold with extra spend. Module auto-skips when purchase price, hold, Y1 NOI, or upstream ImpliedCapexYieldCurve with positive total capex are missing. Module degrades gracefully when capex procurement, draw schedule, warranty, R&M shock, working capital, PM execution, YOC, NOI decomp, or cash conversion modules are absent (drivers default to neutral 50-60). All upstream types matched the spec exactly. Capital project ROI attribution and scope prioritization is a deterministic underwriting overlay. It is not a construction recommendation, capital plan, scope-of-work design opinion, or contractor selection guide.
The memo reads capex procurement bid coverage and capex draw payment control. This module adds the closeout layer: whether completed capital work converts into durable asset value through warranties, retainage release discipline, lien waivers, punchlist closure, and contractor accountability. Not a punchlist tracker, warranty claim opinion, lien-release legal review, or contractor disputes recommendation. Renders only when upstream CapexProcurementContractorBidCoverageIndex is applicable and surfaces a positive capex scope. Warranty coverage posture inferred from CapexProcurement.procurementRoute, CapexProcurement.retainageOrWarrantyPosture, and cue text: brand-aligned (hospitality brand cues such as Marriott, Hilton, Hyatt, IHG, Wyndham, Choice; brand-standard mandate), extended-multi-yr (roof, MEP, manufacturer-backed warranty cues; defensive procurement posture), extended-2yr (specialist or design-build route, enhanced procurement posture), standard-1yr (default), not-assessable. Retainage release posture maps from CapexDrawSchedule.retainagePosture: phased-release (milestone-release upstream: 50% at substantial completion, 50% at warranty period end), warranty-period-hold (full-hold upstream in baseline contexts; full retainage held until end of warranty period), substantial-completion (standard upstream; institutional baseline release on certificate of substantial completion), full-final-hold (full-hold upstream with CapexProcurement.band capex-delivery-gap or PM management-leakage-risk; held to final acceptance plus warranty expiration plus lien waivers), not-assessable. Punchlist completion risk classifies low / moderate / elevated / high from a composite of procurement route (design-build plus 3, specialist plus 2, multi-bid plus 1), contractor concentration (high plus 3, elevated plus 2, moderate plus 1), CapexDrawSchedule.band severity (capex-cash-crunch plus 2, retainage-and-waiver-risk plus 1), and PM execution overlay (management-leakage-risk plus 2, execution-watch plus 1, institutional-operator minus 1); tiers high 7-plus, elevated 5-plus, moderate 3-plus, low otherwise. Contractor accountability classifies institutional / standard / watch / weak from concentration (low plus 2, moderate plus 1, elevated minus 1, high minus 3), CapexDrawSchedule.contractorPaymentRisk (low plus 2, moderate plus 1, elevated minus 1, high minus 3), and vendor band proxy (contracted-cost-stable plus 1, vendor-reset-risk minus 1); tiers institutional 3-plus, standard 1-plus, watch minus 2-plus, weak otherwise. Closeout reserve sums baseline retainage (phased-release 10%, warranty-period-hold 13%, substantial-completion 7.5%, full-final-hold 18% of capex scope) plus punchlist contingency (low 1%, moderate 2%, elevated 3%, high 5% of capex scope). Expected unresolved closeout dollars equals capex scope times a composite leakage factor blending punchlist (low 0.5%, moderate 1.5%, elevated 3.5%, high 6%), accountability (institutional plus 0%, standard plus 0.5%, watch plus 2%, weak plus 4%), and warranty offset (brand-aligned minus 1.5%, extended-multi-yr minus 1.2%, extended-2yr minus 0.6%, standard-1yr plus 0.5%); floored at 0.5%. Five weighted drivers: warranty coverage strength 20% (brand-aligned 80, extended-multi-yr 76, extended-2yr 64, standard-1yr 56; route mismatch haircut on standard-1yr design-build minus 8 or specialist minus 6), retainage release discipline 20% (phased-release 78, warranty-period-hold 72, substantial-completion 60, full-final-hold 44; PM institutional plus 4 or execution-watch minus 6 or management-leakage-risk minus 10), punchlist completion risk 15% (low 82, moderate 66, elevated 44, high 26), contractor accountability 25% (institutional 82, standard 66, watch 42, weak 22), closeout reserve adequacy 20% (vs institutional 10-15% recommended floor: 18%-plus 80, 12% 68, 8% 52, 5% 36, under 22; working-capital liquidity-gap-risk minus 10, working-capital-watch minus 4, liquidity-covered plus 4; cash thin minus 6 or tight minus 3 or strong plus 2; reserve adequacy under-reserved minus 6, thin minus 3). Bands: closeout-controlled (composite 78-plus and accountability not watch or weak and warranty extended-2yr, extended-multi-yr, or brand-aligned and retainage release phased-release, warranty-period-hold, or substantial-completion), punchlist-watch (63-77 or high punchlist risk with score under 60 cap), warranty-recovery-risk (48-62 or standard-1yr warranty on elevated or high punchlist risk with score under 65), retainage-dispute-risk (under 48 or weak accountability with full-final-hold or high punchlist risk), not-assessable. Memo surface: verdict banner with band, score, warranty posture, contractor accountability; four-stat headline (closeout reserve in gold, expected unresolved leakage, punchlist risk tier, retainage release posture); two-cell posture strip (warranty coverage, contractor accountability); five-driver weighted score table; closeout actions tied to written closeout playbook with substantial-completion criteria and punchlist cycle (always), retainage hold specifics by release posture (always), warranty coverage at the documented level as condition of final draw (always), owner's representative engagement on elevated or high punchlist risk, performance bond plus dual-obligee surety on watch or weak accountability, extended warranty riders on standard-1yr design-build or specialist scope, separate closeout reserve line when need is positive; diligence requests tied to warranty terms for every scope (always), proposed retainage release schedule and lien-waiver triggers (always), closeout sequence and final acceptance triggers (always), AIA A102/A103 warranty schedule on design-build, brand-mandated warranty rider confirmation on brand-aligned posture, jurisdiction retainage cap confirmation on full-final-hold, contractor financials and warranty-claim history on weak accountability, owner's rep confirmation on weak PM execution; 2-4 deal implications by band including capex scope dollars, closeout reserve, expected unresolved leakage, warranty posture, retainage release, contractor accountability, and the explicit framing that on retainage-dispute-risk deals the sponsor either reprices, secures pre-construction warranty riders and performance bonds, or restructures contractor selection toward institutional counterparties before mobilization. Module degrades gracefully when working capital, vendor, PM, reserve adequacy, or cash conversion are absent (drivers default to neutral 55-65). Auto-skips when capex procurement upstream is not applicable. All upstream types matched the spec exactly. Capex warranty, retainage, and punchlist completion is a deterministic underwriting overlay. It is not a punchlist tracker, warranty claim opinion, lien-release legal review, or contractor disputes recommendation.
The memo reads repair reserves, vendor-contract risk, working-capital reserves, property-management execution risk, staffing load, and capex procurement bid coverage. This module adds the payment-timing layer: whether capex draws, retainage, lien waivers, contingency usage, and working capital are sequenced well enough to prevent liquidity stress during execution. Not a draw-administration plan, payment-application review, lien search, or construction-loan opinion. Renders only when upstream CapexProcurementContractorBidCoverageIndex is applicable and returns a positive capex scope. Peak monthly draw need equals capex scope times route-driven peak fraction (routine-maintenance 0.20, multi-bid-capex 0.30, specialist-contractor 0.45, design-build-or-gc 0.30) plus 30% of upstream escalation reserve. Contingency reserve need is route-driven (routine 5%, multi-bid 7%, specialist 10%, design-build 10% of capex scope) with capex-burdened ImpliedCapexYieldCurve band adding 5% and defensive procurement posture adding 2.5%. Retainage posture maps from upstream CapexProcurement.retainageOrWarrantyPosture: standard (5-10% retainage to substantial completion), milestone-release (10-15% with phased release at scope milestones), full-hold (15%-plus held to final completion plus warranty period). Lien-waiver control posture: unconditional-per-payment (full-hold retainage plus PM execution-watch or management-leakage-risk; unconditional waivers required before every payment with sub-tier lien tracking), unconditional-partial (specialist or design-build route, or full-hold retainage; unconditional partial waivers per draw plus unconditional final on release), conditional-partial (institutional baseline; conditional partial per draw plus unconditional final at closeout). Working capital draw gap equals max of zero or peak draw need minus available working capital, where available working capital sums WorkingCapitalOperatingReserveSufficiencyIndex.availableOperatingReserve when applicable, else ReserveAdequacyAnalysis.reservesAvgOverHold times hold, else 1.5% of price fallback. Contractor payment risk maps from upstream contractor concentration crossed with capex band severity: high concentration on capex-delivery-gap auto-classifies as high; high or elevated concentration on contractor-execution-risk classifies as elevated; moderate-low concentration flows through. Five weighted drivers: peak draw exposure vs working capital 25% (coverage 2.0x-plus 84, 1.5x 72, 1.0x 58, 0.7x 38, 0.4x 24, under 14), contingency reserve adequacy 20% (vs route-driven recommended floor: 1.5x-plus 82, equal-to-floor 70, 0.75x 50, 0.5x 32, under 20), retainage and lien-waiver discipline 20% (standard 72, milestone-release 62, full-hold 52; unconditional-partial plus 6, unconditional-per-payment plus 8; PM institutional-operator plus 4 or execution-watch minus 6 or management-leakage-risk minus 12), contractor payment risk 15% (low 80, moderate 62, elevated 42, high 22; vendor service-margin-pressure minus 4, vendor-reset-risk minus 8, vendor contracted-cost-stable plus 2), working capital and reserve cushion 20% (working capital liquidity-covered 80, reserve-supported 64, working-capital-watch 42, liquidity-gap-risk 24; R&M sponsor funding gap minus 6; cash conversion tight minus 6 or thin minus 12 or strong plus 4). Bands: draw-control-strong (composite 78-plus and no draw gap and retainage standard or milestone-release), payment-sequencing-watch (63-77), retainage-and-waiver-risk (48-62), capex-cash-crunch (under 48), not-assessable. Hard floors: working capital draw gap above 50% of available working capital auto-classifies as capex-cash-crunch; upstream capex-delivery-gap with composite under 60 caps at retainage-and-waiver-risk. Memo surface: verdict banner with band, score, retainage posture, contractor payment risk; four-stat headline (peak draw need, contingency reserve need, working-capital draw gap, lien-waiver control in gold); two-cell posture strip (retainage posture, contractor payment risk); five-driver weighted score table with status, contribution, interpretation; payment control actions tied to AIA G702/G703 draw cadence (always), retainage hold specifics by posture (always), lien-waiver protocol specifics by posture (always), bridge mechanism on draw gap, GMP or fixed-price on design-build, owner-rep engagement on weak PM, parallel-bidder reserve on elevated or high contractor payment risk, separate contingency line; diligence requests tied to seller's last-two capex programs (always), proposed draw schedule mapped to capex schedule (always), construction-loan draw mechanics (always), AIA A102/A103 with GMP exhibits on design-build, jurisdiction retainage cap on full-hold, title-company lien search procedure on unconditional-per-payment, sponsor bridge mechanism on draw gap, contractor financials and three-reference checks on high payment risk; 2-4 deal implications by band including peak draw dollars, working-capital draw gap, contingency dollars, retainage posture, lien-waiver posture, contractor payment risk, and the explicit framing that on capex-cash-crunch deals the sponsor either reprices, secures a committed liquidity line sized to peak draw, or restructures the capex schedule to align with reserve replenishment. Module degrades gracefully when working capital, R&M shock, vendor contract, PM execution, reserve adequacy, or cash conversion are absent (cushion driver neutral 55-65). Auto-skips when capex procurement upstream is not applicable. Capex draw schedule and contractor payment control is a deterministic underwriting overlay. It is not a draw-administration plan, payment-application review, lien search, or construction-loan opinion.
Public pricing and paid-beta positioning refreshed across the homepage, pricing page, and thank-you flow: Analyst at $49 per month, Pro at $149 per month, Team at $399 per month, with prior written Founding 100 commitments honored as grandfathered access. Hard access enforcement on /tool, /tool/memo, /tool/compare, and the AI parser, review, and exec-summary endpoints remains held back for a later checkout-gated release; the active deployment keeps those surfaces public so analysts can continue running deals while the gated checkout flow is finished. Methodology inventory metadata refreshed alongside the pricing copy to keep the public module catalog in sync with the engine.
Phase 3 continues: Staffing and Payroll Load Sensitivity Index and Working Capital and Operating Reserve Sufficiency Index both land. The memo now reads direct W-2 payroll exposure against asset-class labor baselines with wage-inflation pressure blended from construction-cost inflation, state minimum-wage regime, union exposure, and migration-driven labor-pool tightness, and ties the full operating-shock stack (R&M sponsor gap, insurance escrow and deductible shock, staffing wage shock, vendor renewal sponsor-absorbed, utility sponsor-absorbed, property tax net uncovered exposure, opex annual variance, and an asset-class operating reserve floor) into a single liquidity-need read against available reserve capacity with coverage ratio, funding gap, months of NOI cushion, and peak cash timing stress. 119 Phase 3 modules cumulative.
The memo reads insurance, utility, tax, lease recovery, opex controllability, repair reserves, property management execution, vendor contracts, and staffing load. This module adds the liquidity timing layer: whether the deal has enough working capital and operating reserve capacity to absorb cash-flow timing gaps before NOI, reimbursements, appeals, insurance recoveries, or operating fixes catch up. Not a cash-management plan, lender reserve requirement, legal opinion, or liquidity guarantee. Renders for any deal with purchase price, hold of at least one year, and Y1 NOI. Liquidity uses table aggregates sponsor-side exposures: RepairMaintenanceShockResult.sponsorFundingGap (immediate when band is deferred-maintenance-overhang or capex-leakage-risk, year-one otherwise; funded from replacement reserve), InsuranceProgramPlacementEscrowStrategy.recommendedEscrowDollars (immediate, escrow), InsuranceDeductibleShockCoverageExclusion.estimatedDeductibleShockDollars (during hold, escrow), StaffingPayrollLoadSensitivityIndex.annualizedShock (during hold, operating reserve), VendorContractInflationServiceRiskIndex.estimatedRenewalShock annualized over hold (during hold, operating reserve), UtilityCostVolatilityReimbursementExposure.sponsorAbsorbedDollars annualized over hold (during hold, operating reserve), PropertyTaxAppealDefenseIndex.netUncoveredTaxExposure (during hold, operating reserve), OpexBudgetVarianceControllabilityIndex.annualVarianceExposure (year-one, operating reserve), and an asset-class operating reserve floor (months of Y1 NOI: hotel 6, mixed-use 4, office 4, multifamily 3, retail 3, industrial 2, default 4; immediate, operating reserve). Each use is timing-tagged immediate, year-one, during-hold, or exit-adjacent and funding-source-tagged operating-reserve, replacement-reserve, escrow, sponsor-equity, or unknown. Available operating reserve sums ReserveAdequacyAnalysis.reservesAvgOverHold times hold plus half of insurance placement escrow; fallback when reserveAdequacy is absent uses 1.5% of purchase price. Reserve coverage ratio equals available reserve divided by total liquidity need. Funding gap equals max of zero or liquidity need minus available reserve. Months of NOI cushion equals available reserve divided by Y1 NOI over twelve. Peak cash timing stress sums immediate and year-one bucket dollars. Five weighted drivers: cash conversion and recurring NOI cushion 25% (CashConversionResult.band: strong 84, typical 64, tight 42, thin 24; worst-year conversion under 0% minus 10 or under 15% minus 4 or 40%-plus plus 4; operatingMarginTrend expanding plus 4 or compressing minus 8), reserve adequacy and operating reserve coverage 25% (status adequate 78, thin 48, under-reserved 24; insurance escrow surfaced as note; composite coverage ratio adjust 1.5x-plus plus 8, 1.25x plus 4, 1.0x neutral, 0.75x minus 8, 0.5x minus 18, below minus 28), shock exposure from operating modules 25% (liquidity need as multiple of Y1 NOI: under 0.25x 84, under 0.5x 64, under 1.0x 42, under 1.5x 28, above 18; immediate-share haircut at 40%-plus minus 12 or 25%-plus minus 6), timing mismatch between recoveries and cash needs 15% (blended recoverable share across opex, vendor band proxy, and staffing recoverable pct: 60%-plus 78, 40-60% 58, 25-40% 38, under 25% 24; property tax appeal-ready 0.5 lag, defensible 0.7, reserve-dependent 0.9, weak 1.1 with score adjustment), distribution coverage and LP cash-flow pressure 10% (DistributionCoverageResult.band: Strong 80, Adequate 60, Weak 32). Bands: liquidity-covered (composite 78-plus and coverage 1.25x-plus and no large immediate funding gap), reserve-supported (63-77 with coverage around 1.0x or better), working-capital-watch (48-62), liquidity-gap-risk (under 48 or coverage under 0.70x or immediate funding gap above 50% of Y1 NOI), not-assessable. Hard floors: any coverage ratio below 0.70x or immediate funding gap above 50% of Y1 NOI auto-classifies as liquidity-gap-risk regardless of composite. Memo surface: verdict banner with band, score, coverage ratio, funding gap; four-stat headline (liquidity need, available reserve highlighted in gold, funding gap, months of NOI cushion); liquidity-uses table with category, dollars, timing tag, funding-source tag, interpretation; five-driver weighted score table with status, contribution, interpretation; diligence requests tied to sponsor reserve balance at close (always), 12-month operating cash forecast (always), distribution policy and waterfall (always), front-loaded liquidity demand framing when immediate share above 40%, funding-gap closure path when gap is positive, sub-1.0x coverage reserve sizing follow-up, deferred-maintenance overhang capital plan when R&M band flags it; operating actions tied to working capital floor maintenance through quarterly replenishment (always), liquidity-use rolling 12-month tracking with timing tags (always), distribution holdback on tight or thin cash conversion, pre-funding the tax escrow on reserve-dependent or weaker appeal posture, structural deductible reserve line on deductible-watch or worse, preferred-return deferral on weak distribution coverage, explicit funding-gap close plan with dollar amount and instrument when gap is positive; 2-4 deal implications by band including liquidity need dollars, available reserve dollars, coverage ratio, funding gap, months of NOI cushion, peak cash timing stress, and the explicit framing that on liquidity-gap-risk deals the sponsor either reprices, sizes additional sponsor equity at close, or accepts a structural distribution holdback, and either secures a committed operating-line backstop or carries the funding gap as a structural underwriting input. Module degrades gracefully when ReserveAdequacyAnalysis is absent (1.5% of price reserve floor), CashConversionResult is absent (cushion driver neutral), DistributionCoverageResult is absent (LP pressure driver neutral), and individual shock modules are absent (their lines drop from the liquidity uses table). All upstream types matched the spec exactly. Working capital and operating reserve sufficiency is a deterministic underwriting overlay. It is not a cash-management plan, lender reserve requirement, legal opinion, or liquidity guarantee.
The memo reads vendor contracts, property management execution, insurance, utility, tax, lease recovery, opex controllability, and repair reserves. This module adds the direct-labor layer: whether the asset's modeled payroll line can absorb wage inflation, scheduled minimum-wage increases, union exposure, and labor-pool tightness without compressing NOI or service quality. It is the operating counterpart to Vendor Contract: vendor contracts cover third-party service labor; this module covers direct W-2 payroll the sponsor carries on the property's books. Not a payroll audit, employment-law opinion, union-negotiation recommendation, or compensation-survey replacement. Renders for any deal with purchase price, hold of at least one year, Y1 NOI, and Y1 operating expense. Asset-class direct labor baselines as percent of EGI: multifamily 3-5%, mixed-use 4-7%, office 2-4%, retail 1-2%, hotel 25-40%, industrial 1-2%, default 3-5%. Six universal labor functions with per-asset-class share splits: on-site management, maintenance and engineering, front desk or leasing, housekeeping and cleaning, security and life-safety, specialty and other. Staffing posture classification from deal-context cues plus PropertyManagementExecutionRiskIndex.managerControlPosture: in-house (owner-operated cues, direct payroll, sponsor-managed), contracted-out (third-party management, outsourced, vendor-staffed), low-labor (automated, lights-out, kiosk-based, remote-managed), mixed (default for multifamily and turnaround postures). Labor intensity tier from asset-class baseline plus specialist cues (hotel brands such as Marriott, Hilton, Hyatt, IHG, Wyndham, Choice; senior housing, assisted living, memory care, skilled nursing, CCRC; student housing; lab, wet lab, life science, biotech, medical office, hospital; food hall, restaurant operations) plus PropertyManagementExecutionRiskIndex.executionComplexity read. Minimum-wage regime from StateTaxBurden.profile.stateAbbr: high-min-wage (CA, NY, WA, MA, NJ, IL, OR, CT, MD, CO, AZ, RI, DC at $15 or higher with scheduled escalators), federal-floor (TX, TN, AL, MS, SC, GA, ID, KS, KY, OK, UT, WY, NC, VA, WI, IN, IA, LA, PA, NH), standard-min-wage for other covered states, not-assessable when state profile is absent. Union exposure by address keyword cross with property type: high (NYC, Manhattan, Brooklyn, Bronx, Queens, Staten Island, Los Angeles, San Francisco, Las Vegas, Chicago, Boston, Honolulu, Washington DC for hotel, office, mixed-use), moderate (Seattle, Philadelphia, Newark, Detroit, Minneapolis, St Paul, Atlantic City, Oakland, San Jose, Portland, Atlanta for hotel and office), low otherwise. Wage inflation factor blends ConstructionCostInflation.yoyInflation minus 100 bps as baseline (clamped 2.5-10%), plus high-min-wage adjust 150 bps or federal-floor minus 50 bps or standard 50 bps, plus union adjust 100 bps high or 50 bps moderate, plus migration adjust 50 bps outflow or minus 30 bps inflow; clamped 1.5-12% composite. Posture shock factor: in-house 1.2x, mixed 1.0x, contracted-out 0.7x, low-labor 0.4x of inflation factor. Excess wage inflation above 3% baseline compounded through hold (trapezoid hold over 2 multiplier) drives the wage shock estimate. Six weighted drivers: direct labor cost exposure vs EGI and NOI 25% (above-band 1.25x 28, above-band 42, in-band 62, below-band 60-78 depending on posture, well-below 56-82 depending on posture; under-scoped flagged), wage inflation and minimum-wage pressure 20% (factor 8%-plus 22, 6.5-8% 36, 5-6.5% 52, 4-5% 64, under 4% 78; high-intensity in high-min-wage state minus 8 additional, elevated in high-min-wage state minus 4; in-house posture minus 4, low-labor plus 6), labor intensity by asset class 15% (low 80, moderate 62, elevated 44, high 26, not-assessable 55), property management execution and labor discipline 15% (institutional-operator 82, controlled-execution 64, execution-watch 42, management-leakage-risk 22; in-house with owner-operated PM caps at 70), recoverability through leases or contracts 15% (blended LeaseRecoveryClauseReimbursementLeakageIndex.estimatedRecoverableOpexPct, OpexBudgetVarianceControllabilityIndex.recoverableSharePct, and Vendor Contract band proxy; in-house posture discounts lease recoverable by 40% and opex by 30%), operating margin and cash cushion 10% (margin expanding plus 6, compressing minus 14; cash strong plus 4, tight minus 8, thin minus 14). Bands: labor-stable (composite 78-plus), payroll-watch (63-77), wage-margin-pressure (48-62), staffing-shock-risk (under 48), not-assessable. Band floors: high-intensity asset in high-min-wage regime with recoverable share under 40% cannot exceed payroll-watch; union-high deal with elevated or high intensity caps at payroll-watch unless cash conversion is strong. Per-function wage risk classifies low-floor (housekeeping, front-desk plus 2), specialist (engineering, security, specialty plus 1), with posture (in-house plus 1), intensity (high plus 2, elevated plus 1), regime (high-min-wage plus 2 for low-floor, plus 1 otherwise), and union (high plus 1) amplifiers; tiers low, moderate, elevated, high. Memo surface: verdict banner with band, score, staffing posture, labor intensity; four-stat headline (estimated direct labor annual, wage shock over hold, annualized NOI drag bps, recoverable share in gold); two-cell context strip (minimum-wage regime, union exposure); six-row labor-function table with function, annual cost, wage shock dollars over hold, wage-risk tier, interpretation; six-driver weighted score table with status, contribution, and interpretation; diligence requests tied to 24-month payroll register (always), staffing model and headcount by function (always), benefits load percentage (always), high-min-wage scheduled trajectory and wage-ladder absorption plan, union CBA expiration and bargaining cycle, in-house supervisory capacity confirmation, contracted vendor labor renewal calendar, peer productivity benchmarking on high-intensity, PM execution flag follow-up when PM band is execution-watch or management-leakage-risk; operating actions tied to wage-inflation trajectory baked into opex line (always), quarterly productivity KPIs by labor function (always), HR infrastructure scale confirmation on high-intensity in-house, wage-ladder step planning on high-min-wage, CBA expiration alignment with hold on union-high, sponsor-absorbed framing on recoverable share under 40%, inflation overrun buffer on wage factor 6%-plus; 2-4 deal implications by band including wage shock dollars over hold, annualized NOI drag bps, and the explicit framing that on staffing-shock-risk deals the sponsor either reprices for the structural labor exposure or restructures the operating model (contracted-out conversion, automation capital plan, brand-standard renegotiation on hotels). Module degrades gracefully when ConstructionCostInflation is absent (4.0% baseline), MigrationOverlayResult covers no market (no labor pool adjustment), StateTaxBurden is absent (minimum-wage regime not-assessable), PropertyManagementExecutionRiskIndex is absent (PM driver neutral, posture falls back to asset-class default), and any operating cushion module is absent (cushion driver neutral). MigrationOverlayResult is a discriminated union (MigrationProfile or covered-false marker); type-guarded on the band field. All other upstream types matched the spec exactly. Staffing and payroll load sensitivity index is a deterministic operating-risk overlay. It is not a payroll audit, employment-law opinion, union-negotiation recommendation, or compensation-survey replacement.
Phase 3 continues: Opex Budget Variance and Controllability Index, Repair and Maintenance Reserve Shock Index, Property Management Execution Risk Index, and Vendor Contract Inflation and Service-Level Risk Index all land. The memo now ties insurance pass-through, lease recovery leakage, tax appeal defense, utility reimbursement exposure, reserve adequacy, cash conversion, margin trend, and operating leverage into a single budget controllability read with dollar exposure per cost bucket, adds the R&M layer that tests whether the modeled repair budget and reserves can absorb age, deferred-maintenance, environmental, inflation, tenant-turnover, and asset-age shock without turning into sponsor-funded capex, adds the execution-risk layer that translates the full cost stack into a manager-control-posture and execution-complexity read with NOI drag from management leakage, and adds the contracted-services layer that translates vendor cost pressure and service-level fragility into renewal shock dollars, NOI drag bps, and a nine-category exposure table across security, cleaning, landscaping, snow removal, trash, R&M, HVAC and elevator, management, and other vendors. 117 Phase 3 modules cumulative.
The memo reads insurance, utilities, tax, lease recovery, opex controllability, repair reserves, and property management execution. This module adds the contracted-services layer: whether security, cleaning, landscaping, snow removal, trash, elevators, HVAC, pest control, payroll-adjacent vendors, and property-management service contracts can absorb inflation without degrading NOI or service quality. Not a vendor contract review, legal opinion, property-management recommendation, or operations audit. Renders for any deal with purchase price, hold of at least one year, Y1 NOI, and Y1 operating expense. Asset-class vendor cost baselines as percent of EGI: multifamily 6-10%, mixed-use 7-11%, office 8-12%, retail 4-8%, hotel 12-18%, industrial 2-4%, default 5-9%. Vendor-contracted spend estimate uses asset-class mid-band share of EGI with proforma R&M plus management as floor. Nine service categories with per-asset-class share splits: security, cleaning, landscaping, snow-removal, trash, repairs-maintenance, hvac-elevator, management, other. Contract posture classification from deal-context cues: locked (multi-year contract, MSA, locked-in cues), renewal-window (renewal, expiring, RFP, rebid cues; default), mark-to-market (monthly, T&M, ad-hoc cues), under-scoped (in-house, no service contract, vendor TBD cues). Service complexity tier from asset-class baseline plus specialist cues plus PropertyManagementExecutionRiskIndex.executionComplexity read. Six weighted drivers: contracted cost exposure vs EGI and NOI 25% (above-band 38, in-band 60, below-band 60 with under-scoped note, well-below 78), inflation pressure and renewal timing 20% (posture base: locked 80, renewal-window 56, mark-to-market 40, under-scoped 30; blended with ConstructionCostInflation: yoyInflation 7%-plus 32, 5%-plus 54, otherwise 70), property management execution read-through 20% (PropertyManagementExecutionRiskIndex.band: institutional-operator 82, controlled-execution 64, execution-watch 42, management-leakage-risk 22), R&M and service complexity 15% (RepairMaintenanceShock band-driven plus complexity haircut: high minus 12, elevated minus 6, moderate minus 2), recoverability through leases or reimbursements 10% (blended across lease, utility, opex modules), cash conversion and margin cushion 10% (margin expanding plus 6, compressing minus 14; cash strong plus 4, tight minus 8, thin minus 14). Renewal shock absorbed factor: locked 0.4x of inflation factor, renewal-window 0.9x, mark-to-market 1.1x, under-scoped 1.25x. Estimated renewal shock equals contracted cost times excess inflation above 3% baseline times hold trapezoid (hold over 2 multiplier). NOI drag bps annualized shock times (1 minus recoverable share) divided by Y1 NOI. Per-category inflation shock equals annual cost times excess inflation times hold. Per-category service risk classifies labor-heavy (security, cleaning, management plus 2), seasonal (landscaping, snow-removal plus 1), specialist (HVAC-elevator, R&M plus 2) plus posture amplifier (mark-to-market plus 1, under-scoped plus 2) plus complexity amplifier (high plus 2, elevated plus 1); bands low, moderate, elevated, high. Bands: contracted-cost-stable (composite 78-plus), renewal-watch (63-77), service-margin-pressure (48-62), vendor-reset-risk (under 48), not-assessable. Memo surface: verdict banner with band, score, contract posture, service complexity; four-stat headline (contracted cost exposure annual, estimated renewal shock over hold, NOI drag bps, service complexity tier); nine-row category table with category, annual cost, inflation shock dollars, service risk tier, interpretation; six-driver weighted score table with status, contribution, and interpretation; diligence requests tied to full vendor schedule pull (always), 24-month variance by category (always), property management contract terms (always), mark-to-market clarification on that posture, under-scoped service identification on that posture, PM execution flag follow-up when PM band is execution-watch or management-leakage-risk; operating actions tied to staged renewal cadence (always), three-quote standard at each renewal (always), specialist coverage on elevated or high complexity, vendor inflation overrun buffer on 5%-plus CCI, recovery-pathway framing when recoverable pct under 40%, next-cycle planning on locked posture; 2-4 deal implications by band including renewal shock dollars, annualized NOI drag bps, and the explicit framing that on vendor-reset-risk deals the wrong renewal cycle on a labor-heavy or specialist category can wipe out a year of NOI growth in a single contract. Module degrades gracefully when any upstream module is absent (drivers default to neutral 55-60 scores). Type-name correction: spec referenced operatingMarginTrend.ts; actual filename is operatingMargin.ts (type OperatingMarginTrend unchanged). All other upstream types matched the spec exactly. Vendor contract inflation and service-level risk index is a deterministic operating-risk overlay. It is not a vendor contract review, legal opinion, property-management recommendation, or operations audit.
The memo carries insurance, utility, tax, lease recovery, opex controllability, and R&M reserve overlays. Those modules answer what the cost stack looks like and what is recoverable in principle. This module answers a different question: can the sponsor and the property manager actually execute on it. Control controllable costs, collect reimbursements, run repairs, manage turnover, and prevent NOI leakage between what the lease says and what hits the bank. Not a property management contract review, operations audit, vendor recommendation, or operator endorsement. Renders for any deal with purchase price, hold period, and Y1 NOI. Manager control posture classified from deal-context cues: owner-operated (owner managed, self-managed, in-house management, sponsor managed cues); turnaround-required (value-add, reposition, renovation, lease-up, distressed, vacant, default, foreclosure, receiver, turnaround cues); specialist-required (hotel flag cues such as Marriott, Hilton, Hyatt, IHG, Wyndham, Choice; data center, hyperscale, colocation, colo cues; lab, wet lab, life science, biotech, medical office cues; skilled nursing, assisted living, senior housing, student housing, self storage, cold storage cues; or hotel property type); third-party-standard otherwise. Execution complexity tier from baseline by asset class (hotel base 3, mixed-use base 2, office base 2, retail base 1, multifamily base 1, industrial base 0) plus cue adders (specialist cues plus 2, turnaround cues plus 3, complex-operations cues plus 1) plus posture amplifier (turnaround plus 2, specialist plus 1) plus rent-roll concentration (max annual rollover above 40% plus 2, above 25% plus 1); composite scored to low (under 2), moderate (2-3), elevated (4-5), high (6-plus). Six weighted drivers: controllable cost execution 25% (opex controllability band: controlled-budget 84, recoverable-variance 64, variance-watch 42, sponsor-absorbed-opex-risk 22), recovery and reimbursement collection 20% (blended recoverable percentage across lease, insurance, and utility modules), repair and capital plan execution 15% (R&M shock band: reserve-supported 82, maintenance-watch 60, capex-leakage-risk 38, deferred-maintenance-overhang 22), tenant management and leasing execution 15% (riskTier: low 78, moderate 56, high 30; max annual rollover above 40% minus 12, above 25% minus 6), operating margin and cash cushion 10% (margin expanding plus 6, compressing minus 14; cashConversion strong plus 4, tight minus 8, thin minus 14), manager posture and execution complexity 15% (posture base: owner-operated 64, third-party-standard 70, specialist-required 50, turnaround-required 30; complexity haircut: high minus 12, elevated minus 6, moderate minus 2). Bands: institutional-operator (composite 78-plus with complexity at most moderate and non-specialist posture), controlled-execution (63-77, or 78-plus with elevated complexity or specialist posture), execution-watch (48-62 or composite 48-plus with turnaround posture or high complexity), management-leakage-risk (under 48 or recovery score under 30), not-assessable. Turnaround-required posture caps at execution-watch even with strong composite (wrong operator is the primary execution risk regardless of cost-stack reads). Controllable cost exposure pulls from OpexBudgetVarianceControllabilityIndexResult.annualVarianceExposure when available; otherwise estimated at 1.5% of price as a conservative annual ceiling. Estimated leakage dollars equals blended sum of LeaseRecoveryClauseReimbursementLeakageIndex.estimatedLeakageDollars, InsuranceExpenseRecoveryPassThroughRisk.cashFlowDragDollars, and UtilityCostVolatilityReimbursementExposure.sponsorAbsorbedDollars from upstream modules. NOI drag bps equals annualized leakage divided by Y1 NOI in bps. Memo surface: verdict banner with band, score, manager control posture, execution complexity; four-stat headline (controllable cost exposure annualized, estimated leakage dollars, NOI drag bps, execution complexity tier); six-driver weighted score table with status, contribution, and interpretation; operating actions tied to kickoff operating review (always), monthly KPI dashboard (always), specialist credentials confirmation on specialist posture, turnaround operator engagement on turnaround posture, 90-day operating runbook on elevated or high complexity, sponsor-absorbed bucket concentration when opex variance is elevated, anchor tenant retention KPIs on concentration moderate or high; diligence requests tied to 24-month operating P&L pull (always), CAM reconciliation file (always), manager portfolio coverage (always), sponsor operating team depth when owner-operated, PCA plus engineering walk on deferred-maintenance-overhang, lease renegotiation roadmap when lease recovery is sponsor-absorbed; 2-4 deal implications by band including NOI drag bps and the explicit framing that on management-leakage-risk deals the sponsor either upgrades the manager (specialist or turnaround-experienced) and confirms capability or reserves the leakage estimate as a structural underwriting input. Module degrades gracefully when any upstream module is absent (drivers default to neutral 55-65 scores; auto-skip only when purchase price, hold, or Y1 NOI is missing). Type-name correction: spec referenced operatingMarginTrend.ts as the filename; actual filename is operatingMargin.ts (type OperatingMarginTrend unchanged). All other upstream types matched the spec exactly. Property management execution risk index is a deterministic underwriting overlay. It is not a property management contract review, operations audit, vendor recommendation, or operator endorsement.
Repair and maintenance lines are often treated as stable operating expense, but older assets can hide capital leakage inside recurring R&M. This module tests whether the modeled repair budget and reserves can absorb age, deferred-maintenance, environmental, inflation, and operating-volatility pressure without turning into unexpected sponsor-funded capex. Not a property condition assessment, engineering report, capital plan, or maintenance estimate. Renders for any deal with purchase price, hold period, Y1 EGI, Y1 NOI, and Y1 operating expense. Asset-class R&M benchmarks as percent of EGI: multifamily 4-7%, mixed-use 5-8%, office 5-8%, retail 3-6%, hotel 8-12%, industrial 2-4%; defaults to 4-7% for unknown asset classes. Routine R&M sufficiency scored against the mid-band benchmark; below-band budget reduces the score. Age and condition inference from deal context: older cues include pre-war, prewar, mid-century decades, historic, landmark, vintage, deferred maintenance, rehab; newer cues include new construction, 2020s, stabilized core; reposition cues include reposition, renovation, rehabilitation, value-add, adaptive reuse, conversion. Capex-heavy flag from constructionCostInflation escalates the age tier. Six shock categories with dollar exposure and funding source per row: routine-rm (under-budget gap vs benchmark mid times hold; funded from opex budget when within budget, sponsor gap when material), deferred-maintenance (age-tier-driven percentage of price: aged 3.0%, older 1.5%, stabilized 0.5%, newer 0%; funded from capex budget or reserve), inflation (Y1 R&M times excess construction inflation above 3% baseline times hold trapezoid; funded from opex budget), environmental (environmentalSiteConditionRiskIndex band: remediation-sensitive 0.5% of price, environmental-watch 0.2%; brownfield funding gap when applicable; funded from capex budget or sponsor gap when brownfield lender escrow is high), tenant-turnover (max annual rollover above 40% scores 1.0% of price, above 25% scores 0.5%; funded from capex budget), asset-age (aged tier 1.5% of price, older 0.8%; funded from capex budget for systemic life-cycle items: HVAC, roof, elevator, facade). Total shock equals sum of category dollars. Reserve coverage ratio equals reserveAdequacy.reservesAvgOverHold times hold divided by total shock; under-reserved status floors at 26, thin at 48. Sponsor funding gap equals max(0, total shock minus available reserve dollars). NOI drag bps equals annualized sponsor gap divided by Y1 NOI in bps. Six weighted drivers: routine R&M sufficiency 25% (band score against asset-class benchmark: in or above band 80, in band 64, below band 42, materially below 26), reserve cushion vs shock 25% (coverage 1.5x-plus 80, 1.0x 62, 0.5x 40, under 0.5x 22; under-reserved floor at 26, thin floor at 48), construction cost inflation pressure 15% (yoyInflation 7%-plus 32, 5%-plus 50, otherwise 70; capex-heavy minus 6), asset age and deferred maintenance signal 15% (newer 82, stabilized 64, older 40, aged 22), environmental and brownfield linkage 10% (env band: clean-site-likely 80, manageable 62, watch 46, remediation-sensitive 28; brownfield remediation-overhang or funding-gap floors at 30, reserve-watch at 56), operating margin and cash cushion 10% (margin expanding plus 6, compressing minus 14; cashConversion strong plus 4, tight minus 8, thin minus 14; operating leverage averageOLC above 2.0x minus 4). Bands: reserve-supported (composite 78-plus and coverage 1.0x-plus and not aged tier), maintenance-watch (63-77 or coverage 0.75-0.99x), capex-leakage-risk (48-62 or coverage 0.5-0.74x), deferred-maintenance-overhang (under 48 or aged tier with coverage under 0.5x), not-assessable. Memo surface: verdict banner with band, score, R&M percent of EGI, reserve coverage ratio; four-stat headline (annual R&M budget, total shock estimate, sponsor funding gap, NOI drag bps); shock-row table with category, estimated dollars, funding source, status, and interpretation; six-driver weighted score table with status, contribution, and interpretation; diligence actions tied to independent PCA commissioning (always), trailing R&M billing reconciliation (always), 10-year capex schedule on older or aged assets, dedicated R&M shock reserve sizing when sponsor funding gap is positive, R&M inflation overrun buffer on elevated construction cost inflation, environmental R&M scope coordination on environmental shock, per-suite turnover standards on rollover concentration; 2-4 deal implications by band including shock dollars, coverage ratio, sponsor funding gap, and the explicit framing that on deferred-maintenance-overhang deals the asset likely requires a capital plan in addition to operating R&M and the sponsor either prices the gap or secures seller R&M credit. Module degrades gracefully when noiDecomp is absent (no cumulative growth signal), reserveAdequacy is absent (coverage cannot be quantified), construction cost inflation is absent (uses 3.5% baseline), environmental and brownfield modules are absent (env driver neutral), tenant concentration has no rent roll (turnover shock not computed). All upstream types matched the spec exactly. No type-name corrections required this cycle. Repair and maintenance reserve shock index is a deterministic underwriting overlay. It is not a property condition assessment, engineering report, capital plan, or maintenance estimate.
The memo carries a deep expense-recovery stack: insurance pass-through, lease recovery leakage, tax appeal defense, utility reimbursement exposure, reserve adequacy, cash conversion, margin trend, and operating leverage. This module answers the IC question that ties the stack together: how controllable is the forward opex budget. It classifies each cost bucket (taxes, insurance, utilities, repairs-maintenance, management, reserves, environmental, other) as management-controllable, tenant-recoverable, reserve-funded, appealable, or structurally sponsor-absorbed, then rolls those classifications into a single budget controllability read with dollar exposure per bucket. Not a budget guarantee, lease abstract, tax counsel opinion, insurance quote, or operations manual. Renders for any deal with purchase price, hold period, Y1 NOI, Y1 operating expense, and a non-empty noiDecomp; auto-skips when noiDecomp surfaces zero cumulative opex growth (budget controllability is not a binding question on those deals). Per-bucket exposure dollars sum cumulative YoY growth from noiDecomp delta fields (deltaRealEstateTaxes, deltaInsurance, deltaUtilities, deltaRepairsMaintenance, deltaPropertyMgmt, deltaReserves, deltaMarketingGA plus deltaHotelFees for other; environmental exposure pulled from BrownfieldRemediationReserveAdequacy.estimatedRemediationReserve divided by hold). Per-bucket controllability and sponsor-absorbed share derived from upstream module bands: taxes from PropertyTaxAppealDefenseIndex.band (appeal-ready 30% absorbed, defensible-with-evidence 45%, reserve-dependent 65%, weak-appeal-posture 85% with structural class); insurance from InsuranceExpenseRecoveryPassThroughRisk.estimatedSponsorAbsorbedPct directly (sponsor-absorbed-risk band reclassifies as structural); utilities from UtilityCostVolatilityReimbursementExposure.recoverablePct or LeaseRecoveryClauseReimbursementLeakageIndex proxy (sponsor-absorbed-utility-risk reclassifies as structural); repairs-maintenance always controllable with ConstructionCostInflation.yoyInflation overlay (above 7% lifts absorbed to 55%, above 5% to 48%; capex-heavy adds 5%); management always controllable with margin trend overlay (compressing lifts to 50%); reserves from ReserveAdequacyAnalysis.status (adequate 15% absorbed, thin 45%, under-reserved 75% with structural class); environmental from BrownfieldRemediationReserveAdequacy.band (reserve-covered 20%, reserve-watch 40%, funding-gap 65%, remediation-overhang 90% with structural class); other defaults to unknown at 65%. Aggregated controllable share, recoverable share, and sponsor-absorbed share are dollar-weighted across populated buckets. Annual variance exposure equals dollar-weighted sponsor-absorbed total; NOI drag bps equals annualized exposure divided by Y1 NOI in bps. Largest risk bucket is the bucket with highest sponsor-absorbed dollars. Six weighted drivers: recovery and pass-through strength 25% (blended recovery pct across insurance, lease, and utility modules), tax appeal posture 15% (PropertyTaxAppealDefenseIndex.band scored: appeal-ready 82, defensible-with-evidence 64, reserve-dependent 42, weak-appeal-posture 22), reserve cushion against shocks 20% (ReserveAdequacyAnalysis status plus BrownfieldRemediationReserveAdequacy band floor: adequate 80, thin 50, under-reserved 26; brownfield remediation-overhang floors at 28, funding-gap at 44, reserve-watch at 60), operating margin trend 15% (margin trend: expanding 78, stable 62, compressing 36; margin expansion pp surfaced as cushion bps), cash conversion resilience 15% (cashConversion band: strong 82, typical 66, tight 44, thin 28; operatingLeverage averageOLC above 2.0x minus 8, above 1.5x minus 4), cost inflation and opex growth pressure 10% (ConstructionCostInflation.yoyInflation above 7% scores 36, above 5% scores 56, otherwise 70; isCapexHeavy minus 6; cumulative opex growth above 40% of Y1 opex minus 8). Bands: controlled-budget (composite 78-plus and sponsor-absorbed share at 30%-or-below), recoverable-variance (63-77 and sponsor-absorbed at 50%-or-below), variance-watch (48-62 and sponsor-absorbed at 70%-or-below), sponsor-absorbed-opex-risk (composite under 48 or sponsor-absorbed above 70%), not-assessable. Memo surface: verdict banner with band, score, recoverable share, sponsor-absorbed share; four-stat headline (annual variance exposure, NOI drag bps, recoverable share highlighted in gold, largest risk bucket); per-bucket exposure table with bucket name, annual exposure dollars, controllability classification, sponsor-absorbed pct, status, and interpretation; six-driver weighted score table with status, contribution, and interpretation; diligence actions tied to line-by-line opex walk (always), largest-bucket concentration framing, tax reserve sizing on weak appeal, insurance NOI drag modeling on sponsor-absorbed, utility price recut or operational tuning on sponsor-absorbed, dedicated capital plan line on thin or under-reserved, margin defense plan on compressing margin trend; 2-4 deal implications by band including recoverable share, sponsor-absorbed share, NOI drag bps, and the explicit framing that on sponsor-absorbed-opex-risk deals the price chip or escrow concentrates on the largest exposure bucket rather than spreading across recoverables. Module degrades gracefully when any upstream module is absent (per-bucket classification falls back to controllability-class defaults; drivers default to neutral 55-60 scores) and when noiDecomp returns zero total growth (not-applicable). All upstream types matched the spec exactly: NoiDecompYear, OperatingMarginTrend, CashConversionResult, OperatingLeverageResult, ReserveAdequacyAnalysis, ConstructionCostInflation, InsuranceExpenseRecoveryPassThroughRiskResult, LeaseRecoveryClauseReimbursementLeakageIndexResult, PropertyTaxAppealDefenseIndexResult, UtilityCostVolatilityReimbursementExposureResult, BrownfieldRemediationReserveAdequacyResult. No type-name corrections required this cycle. Opex budget variance and controllability index is a deterministic underwriting overlay. It is not a budget guarantee, a lease abstract, a tax counsel opinion, an insurance quote, or an operations manual.
Phase 3 continues: five recovery, tax, and utility overlays land today. Insurance Program Placement and Escrow Strategy, Insurance Expense Recovery and NOI Pass-Through Risk, Lease Recovery Clause and Expense Reimbursement Leakage Index, Property Tax Appeal Probability and Reassessment Defense Index, and Utility Cost Volatility and Tenant Reimbursement Exposure Index join the engine. The memo now reads lease-level recovery across all opex categories, reassessment appeal readiness, the utility-specific volatility tier with electric, gas, water-sewer, and CAM exposure by category, and the insurance placement and escrow strategy that ties premium load, carrier posture, coverage architecture, and lender escrow into a single placement route. 113 Phase 3 modules cumulative.
Underwrite covers insurance, lease recovery, and property tax defense. This module adds the utility-cost layer: whether electric, gas, water, sewer, and common-area utility growth is controllable, tenant-recoverable, or sponsor-absorbed NOI drag. Utility costs can move faster than base operating growth, especially for older buildings, mixed-use assets, data centers, hotels, medical office, lab, and high-service retail. The output is a deterministic read on which share of the volatility the sponsor actually carries. Not a utility procurement recommendation, lease legal opinion, energy audit, or tenant reimbursement determination. Renders for any deal with purchase price, hold period, Y1 NOI, and positive Y1 operating expense. Reimbursement structure classification by cue plus property-type default with explicit tenant-direct-metering override: tenant-direct-metered for submeter, sub-meter, tenant-metered, direct-metered cues; triple-net-recoveries when upstream LeaseRecoveryClauseReimbursementLeakageIndex.recoveryStructure is triple-net, or for industrial and retail defaults; modified-gross for upstream modified-gross or RUBS multifamily cues; base-year-stop for office default or upstream base-year-stop; gross-or-capped for residential or hotel default or upstream gross-or-capped; mixed-recovery for mixed-use; not-assessable otherwise. Utility intensity tier classification: industrial low baseline; multifamily, mixed-use, office, and retail moderate; hotel high; cue escalation pushes intensity up one tier for data center, hyperscale, colocation, lab, life science, biotech, medical office, restaurant, food hall, or cold storage cues; dataCenterPowerCapacityTracker.powerCostRisk high forces high tier, elevated forces at least elevated tier. Utility share of opex pulled from energyCostOverlay.utilityShareOfOpEx when available (multifamily 15%, mixed-use 18%, office 12%, retail 10%, hotel 20%, industrial 8% baseline). Recoverable percentage defers to upstream LeaseRecoveryClauseReimbursementLeakageIndex.estimatedRecoverableOpexPct when applicable, then to InsuranceExpenseRecoveryPassThroughRiskResult.estimatedRecoverablePct as proxy, then to structure-based defaults (tenant-direct-metered 92%, triple-net-recoveries 78%, modified-gross 52%, base-year-stop 38%, gross-or-capped 5-12% by asset, mixed-recovery 50%). Utility exposure dollars sized as max of (Y1 utilities times hold years, Y1 utilities times cumulative energy inflation factor where the factor is energy overlay YoY when applicable else 3.5% baseline times hold). Sponsor absorbed dollars equals total exposure times (1 minus recoverable pct). NOI drag bps equals annualized sponsor-absorbed growth divided by Y1 NOI in bps. Six weighted drivers: lease recovery protection 30% (recoverable pct banded: 80%-plus 84, 60% 64, 40% 48, 20% 32, under 20% 22), utility intensity by property type 20% (intensity tier: low 78, moderate 60, elevated 40, high 24; utility share above 20% of opex minus 6, above 15% minus 3), energy or climate volatility signal 15% (energyCostOverlay.currentEnergyInflation at 8%-plus minus 16, 5%-plus minus 8; climateTransitionRisk high or elevated minus 6; dataCenter powerCostRisk high minus 8), operating margin cushion 15% (margin expanding plus 6, compressing minus 14; cashConversion strong plus 4, tight minus 6, thin minus 12), cash conversion resilience 10% (band: strong 80, typical 70, tight 50, thin 32; operating leverage averageOLC above 2.0x minus 6), tenant concentration or dispute risk 10% (riskTier: low 78, moderate 58, high 32). Bands: utility-protected (composite 78-plus and recoverable 70%-plus), reimbursement-watch (63-77 or recoverable 45-69%), margin-sensitive (48-62 or recoverable 25-44%), sponsor-absorbed-utility-risk (under 48 or recoverable under 25% or high volatility tier with thin margin cushion), not-assessable. Memo surface: verdict banner with band, score, recoverable pct, sponsor absorbed dollars; four-stat headline (utility exposure dollars, recoverable share in gold, NOI drag bps, volatility tier); two-cell strip (reimbursement structure, operating margin cushion); four-cell utility category strip (electric, gas, water-sewer, cam-utilities) with intensity tier per category and annualized dollar estimate; six-driver weighted score table with status, contribution, and interpretation; diligence actions tied to two-year utility billing reconciliation (always), utility recovery clause confirmation (always), submeter integrity on tenant-direct-metered structures, energy audit and benchmarking on elevated or high intensity tier, utility tariff schedule pull on 5%-plus energy inflation, jurisdiction emissions mandate alignment on elevated or high climate transition risk, data center PPA review when power cost risk is non-low, sponsor-absorbed NOI drag modeling when recoverable pct under 40%; 2-4 deal implications by band including sponsor-absorbed dollar share, NOI drag bps, and the explicit framing that on sponsor-absorbed-utility-risk deals the sponsor either re-cuts price by the cumulative absorbed share or commits to operational tuning capex inside hold. Module degrades gracefully when energyCostOverlay is absent (uses 3.5% baseline inflation), climate transition is absent (no volatility haircut), data center module is absent (no power-cost escalation), operating margin or cash conversion is absent (cushion driver neutral), tenant concentration has no rent roll (dispute driver neutral). All upstream types matched the spec exactly: LeaseRecoveryClauseReimbursementLeakageIndexResult, InsuranceExpenseRecoveryPassThroughRiskResult, OperatingMarginTrend, CashConversionResult, OperatingLeverageResult, NoiDecompYear, EnergyCostOverlay, ClimateTransitionRisk, DataCenterPowerCapacityTrackerResult, TenantConcentrationResult. EnergyCostOverlay is passed as undefined in MemoView since it requires marketSnapshot (async loaded); module's 3.5% baseline inflation fallback applies. No type-name corrections required this cycle. Utility cost volatility and tenant reimbursement exposure is a deterministic underwriting overlay. It is not a utility procurement recommendation, lease legal opinion, energy audit, or tenant reimbursement determination.
Underwrite already flags property tax reassessment risk through PropertyTaxReassessmentRisk. This module answers the next IC question: given that step, is there a credible appeal or defense path, and how much of the shock is realistically controllable through evidence, jurisdiction practice, lease recovery, and reserves. Not legal advice and not an appeal recommendation. It surfaces whether the record is strong enough to support an appeal strategy, whether the reserve is sized for a failed appeal, and what evidence the analyst should gather before IC. Renders when reassessment risk is meaningful (Y2 uplift at 3%-plus of Y1 tax) and the upstream reassessment module ran; skips when reassessment is essentially zero. Evidence tier classification: strong-income-approach (operating margin under 45% or Y1 vacancy above 15%), comps-supported (acquisition basis below the institutional band), capex-or-vacancy-supported (value-add, repositioning, renovation, or active lease-up posture from leaseUpYears or notes), thin-record (stabilized core asset with above-band or in-band basis and no capex narrative), not-assessable (insufficient context). Appealable fraction by evidence tier: strong-income-approach 65%, comps-supported 50%, capex-or-vacancy-supported 35%, thin-record 15%, not-assessable 20%. Jurisdiction appeal practice classifies probability of partial relief from address text and StateTaxBurden.profile.stateAbbr: Texas 55% (aggressive ARB practice with mass-appeal vendors), Illinois 48% (Cook County BOR), New Jersey 45% (County Boards of Taxation and Tax Court), New York City 40% (BAR petitions through Tax Commission, three-year cycles), New York State 38% (SCAR or Article 7), Massachusetts 38% (Appellate Tax Board), Florida 32% (Value Adjustment Board), California 30% (Proposition 13 caps annual increases; commercial change-of-ownership reassessment is appealable via Assessment Appeals Board but probability is below the national average), default 36% for other covered states or 30% for unknown. Probability adjustment by evidence tier: strong-income-approach plus 12%, comps-supported plus 6%, capex-or-vacancy plus 2%, thin-record minus 10%; final probability clamped to 85%. Six weighted drivers: reassessment severity 25% (PropertyTaxReassessmentRisk.riskBand: low 78, moderate 52, high 30; uplift percent of Y1 tax surfaced in interpretation), appeal evidence strength 25% (evidence tier score: strong-income 84, comps 70, capex-vacancy 56, thin 28, not-assessable 50), jurisdiction appeal practice 20% (probability of relief banded: 50%-plus 80, 40-50% 66, 32-40% 50, 24-32% 38, under 24% 26), reserve adequacy against tax shock 15% (coverage band: 1.5x-plus 78, 1.0x 62, 0.5x 38, under 0.5x 22; reserveAdequacy under-reserved floors at 26, thin at 48), lease recovery for tax expense 10% (recoverable pct from LeaseRecoveryClauseReimbursementLeakageIndex.estimatedRecoverableOpexPct or InsuranceExpenseRecoveryPassThroughRiskResult.estimatedRecoverablePct as proxy: 75%-plus 78, 50% 60, 25% 42, under 25% 24), operating margin and cash conversion cushion 5% (margin trend expanding plus 6, compressing minus 12; cashConversion thin minus 12, tight minus 6, strong plus 4). Estimated tax shock equals reassessment Y2 uplift times hold period. Appealable shock amount equals total shock times evidence-tier appealable fraction. Probability of relief equals jurisdiction baseline plus evidence-tier adjustment, clamped to 85%. Expected relief dollars equals appealable shock times probability of relief. Net uncovered tax exposure equals total shock minus lease-recovered portion (totalShock times recoverable pct) minus expected relief dollars. Bands: appeal-ready (composite 78-plus with strong-income-approach or comps-supported evidence and probability 40%-plus), defensible-with-evidence (63-77 or strong-comp evidence in low-reassessment-risk context), reserve-dependent (48-62 with adequate reserve coverage or thin-record evidence with coverage 0.5x-plus), weak-appeal-posture (under 48 or thin-record evidence with coverage under 0.5x), not-assessable. Memo surface: verdict banner with band, score, evidence tier, jurisdiction probability; four-stat headline (estimated tax shock, appealable amount, expected relief highlighted in gold, net uncovered exposure); three-cell strip (probability of relief, reserve coverage, reassessment risk band); six-driver weighted score table with status, contribution, and interpretation; evidence requests tied to assessor working file pull (always), Y1 income approach assembly when margin or vacancy supports it, three sale comps assembly (always), capex and stabilization documentation on value-add posture, transaction document submission on below-band basis, market-value framing acknowledgment on above-band basis; diligence actions tied to property tax counsel or mass-appeal vendor engagement keyed to jurisdiction (always), reassessment trigger and filing window confirmation (always), tax-reserve sizing when coverage under 1.0x, tax-recovery confirmation when lease recovery is thin, price-recut framing when reassessment is high and evidence is thin; 2-4 deal implications by band including expected relief dollars, net uncovered exposure, and the explicit framing that on weak-appeal-posture deals the sponsor either re-cuts price, secures seller tax indemnity, or accepts the post-reassessment tax line as the underwriting assumption. Module degrades gracefully when stateTaxBurden has no profile coverage (jurisdiction defaults to unknown 30%), acquisitionBasis is absent (evidence tier inference loses the below-band signal), reserveAdequacy is absent (reserve defense driver neutral 45-55), leaseRecoveryLeakage and insuranceRecovery are absent (lease recovery driver neutral 55). All upstream types matched the spec exactly: PropertyTaxReassessmentRisk (with riskBand field), AcquisitionBasis, StateTaxBurden (profile with stateAbbr), OperatingMarginTrend, CashConversionResult, ReserveAdequacyAnalysis, LeaseRecoveryClauseReimbursementLeakageIndexResult, InsuranceExpenseRecoveryPassThroughRiskResult. No type-name corrections required this cycle. Property tax appeal probability and reassessment defense index is a deterministic underwriting overlay. It is not legal advice, a property tax counsel opinion, an appeal recommendation, a jurisdiction-specific procedure, or a relief guarantee.
The Insurance Expense Recovery module exposed a broader operating-diligence gap: whether taxes, insurance, CAM, utilities, management, repairs, and other operating-expense growth are actually recoverable from tenants under the lease language. A pro forma can show stable NOI while silently assuming perfect expense recovery. This module classifies the lease recovery structure, estimates the recoverable share of operating-expense growth across all categories, surfaces cap and base-year exposure, flags tenant-dispute risk, and translates the gap into leakage dollars and an opex drag in bps of Y1 NOI. Not a lease abstract, legal opinion, tenant billing determination, or reimbursement guarantee. Renders for any deal with purchase price, hold period, Y1 NOI, and either commercial property type or explicit recovery cues. Residential and hotel asset classes return not-applicable unless commercial-tenant or recovery cues are present. Recovery structure classification by cue plus property-type default: triple-net for explicit NNN, net lease, absolute net, bondable, ground lease, reimbursable, or CAM recovery cues, or industrial and retail defaults; base-year-stop for explicit base-year or expense-stop cues, or office default; modified-gross for explicit modified-gross or industrial-gross cues; gross-or-capped for explicit gross-lease, full-service, fully-gross, or capped-opex cues; mixed-recovery for Mixed-Use property type; not-assessable when no property type or recovery cue is available. Base recoverable opex percent by structure plus property type: industrial NNN 92%, retail NNN grocery-anchored 85%, retail NNN small-shop or service or restaurant 58-62%, retail NNN default 75%, office NNN 80%, office base-year 38%, office modified-gross 48%, office gross 16%, industrial modified-gross 60%, modified-gross default 52%, mixed-use 50%, gross default 12%, residential gross 5%. Adjustments: cap cue (CAP cues include capped opex, expense cap, CAM cap, controllable cap) minus 10%; one exclusion cue minus 8%, two-plus exclusion cues minus 15% (EXCLUSION cues include excluded insurance, excluded tax, landlord-paid utilities, management fee exclusion); tenant concentration risk tier high minus 12%, moderate minus 5%. Cap or stop exposure classified low / moderate / elevated / high based on cap cue presence, exclusion cue count, and tenant concentration. Tenant dispute risk classified: retail with small-shop or restaurant or local-tenant cues elevated; retail default moderate; office moderate; industrial low; mixed-use moderate; high concentration escalates one tier. Six weighted drivers: recovery structure clarity 30% (structure band: triple-net 84, mixed-recovery 60, modified-gross 54, base-year-stop 44, gross-or-capped 24; recoverable pct dampens via floor and ceiling rules), expense categories recoverable 20% (insurance excluded minus 14, tax excluded minus 14, landlord-paid utilities minus 10, management fee exclusion minus 6, CAM recovery cue plus 6; cross-references upstream insuranceExpenseRecoveryPassThroughRisk band: sponsor-absorbed minus 6, recovery-protected plus 4), cap stop base-year and exclusion exposure 15% (low 80, moderate 60, elevated 38, high 22; base-year-stop structure minus 6 additional), tenant concentration and dispute risk 15% (riskTier: low 78, moderate 56, high 30, n/a 60), operating margin and cash conversion cushion 10% (margin expanding plus 6, compressing minus 14; cashConversion thin minus 14, tight minus 8, strong plus 4; operating leverage averageOLC above 2.0x minus 6, above 1.5x minus 3), opex inflation and tax reassessment exposure 10% (PropertyTaxReassessmentRisk.riskBand: high minus 14, moderate minus 6, low neutral; cumulative opex growth from noiDecomp.deltaTotalOpEx surfaced for context). Estimated leakage dollars equals cumulative opex growth over hold (sum of negative deltaTotalOpEx from noiDecomp) times leakage pct, plus tax reassessment Y2 uplift times hold times leakage pct when applicable. Opex drag bps equals annualized leakage (leakage divided by hold) divided by Y1 NOI in bps. Bands: recovery-strong (composite 78-plus and recoverable 75%-plus), recovery-watch (63-77 or recoverable 55-74%), leakage-exposed (48-62 or recoverable 30-54%), sponsor-absorbed-opex-risk (under 48 or recoverable under 30% or high cap exposure with compressing margin), not-assessable. Memo surface: verdict banner with band, score, recovery structure, recoverable opex percentage; four-stat headline (leakage share, leakage dollars, opex drag bps, cap or stop exposure); four-cell strip (tenant dispute risk plus three-cell recovery waterfall: total opex growth, recoverable share highlighted in gold, leakage share); six-driver weighted score table with status, contribution, and interpretation; lease diligence actions tied to NNN, CAM, tax, insurance, utility, and management-fee clause abstraction (always), caps and stops and base-year and exclusion confirmation (always), anchor or top-tenant side letters when concentration is moderate or high, historical reimbursement billings reconciliation (always), unrecovered opex modeling as NOI drag at the bps level when drag is non-zero, tax reassessment recovery confirmation when reassessment riskBand is moderate or high, historical CAM reconciliation pull when cap exposure is elevated or high; 2-4 deal implications by band including recoverable percentage, cumulative leakage dollars, and the explicit framing that on sponsor-absorbed-opex-risk deals lease renegotiation is the only path out. Module degrades gracefully when tenantConcentration has no rent roll (no concentration adjustment), operatingMarginTrend or cashConversion or operatingLeverage are absent (cushion driver neutral), noiDecomp is absent (no opex growth context, leakage dollars sized from reassessment only), and propertyTaxReassessmentRisk is absent (no Y2 uplift component, inflation driver neutral). Upstream type-name corrections: PropertyTaxReassessmentRisk surfaces the band as `riskBand` not `band`, and the band tier values are low / moderate / high (no severe or elevated tiers). All other upstream types matched the spec: OperatingLeverageResult, CashConversionResult, OperatingMarginTrend, NoiDecompYear, TenantConcentrationResult, NetEffectiveRentResult, InsuranceExpenseRecoveryPassThroughRiskResult. Lease recovery clause and reimbursement leakage index is a deterministic underwriting overlay. It is not a lease abstract, legal opinion, tenant billing determination, or reimbursement guarantee.
The insurance stack now models premium load (insuranceLoad), climate-adjusted drift (climateInsuranceForecast), carrier availability (insuranceCarrierAvailabilityRenewalRisk), deductible shock and coverage exclusions (insuranceDeductibleShockCoverageExclusion), placement route and escrow posture (insuranceProgramPlacementEscrowStrategy). This module adds the operating-income layer: when insurance costs rise, how much pressure is recoverable from tenants under the actual lease structure, and how much remains as NOI drag the sponsor absorbs. Not a lease abstract, legal opinion, insurance quote, or tenant reimbursement determination; inferred recoveries should be confirmed against actual lease documents before any pricing or financing decision. Renders for any deal with purchase price, hold period, Y1 NOI, and at least one source of insurance, climate, peril, lease, or upstream insurance-module context. For residential and hotel asset classes without explicit recovery cues, renders only when insurance shock is material enough to create NOI drag (material or catastrophic deductible, elevated or high carrier renewal shock, or material or severe climate forecast band). Recovery structure classification by cue plus property type default: triple-net for industrial and retail defaults or explicit NNN cues (NNN, triple net, net lease, absolute net, bondable, ground lease); modified-gross for office default or explicit modified-gross or base-year or expense-stop cues; gross-or-capped for explicit gross-lease or full-service or capped-opex cues; mixed-recovery for Mixed-Use property type; residential and hotel default to gross-or-capped unless RUBS or utility-billback cues lift them to modified-gross. Recoverable percentage by structure plus property type: industrial NNN 95%, industrial modified-gross 62%, retail NNN with grocery anchor 88%, retail NNN with small-shop or service or restaurant cues 60-65%, retail NNN default 78%, office NNN 85%, office modified-gross 42%, office gross 18%, residential RUBS 22%, residential gross 0%, mixed-use 52%, NNN baseline 80%. Concentration haircuts: high tenant concentration minus 15% practical recovery, moderate minus 7%; max annual rollover above 40% overlapping elevated or high carrier renewal shock minus 8% (rollover during shock window). Year-one insurance load bps equals Y1 insurance dollars divided by Y1 NOI times 10,000. Renewal shock recovery gap calculated three ways with fallback: when climate forecast has geo coverage, use climateInsuranceForecast.premiumGapDollars times sponsor-absorbed share; when only carrier module is applicable, use carrier-renewal-shock-multiple (high 0.5x, elevated 0.3x, moderate 0.15x, low 0.05x) times Y1 premium times hold times sponsor-absorbed share; final fallback uses cumulative YoY insurance growth from noiDecomp.deltaInsurance times sponsor-absorbed share. Cash-flow drag dollars equals renewal shock recovery gap plus the full deductible event when material or catastrophic (deductible events are conventionally not recoverable from tenants under standard lease language). NOI drag bps equals the annualized recovery gap (gap divided by hold) divided by Y1 NOI in bps. Tenant sensitivity classification: low for triple-net with low or moderate concentration, moderate for triple-net with high concentration, elevated for modified-gross or mixed-recovery, high for gross-or-capped or modified-gross with high concentration. Six weighted drivers: lease recovery structure and pass-through clarity 30% (structure band: triple-net 84, mixed-recovery 60, modified-gross 50, gross-or-capped 24; recoverable pct dampens or amplifies via floor and ceiling rules), tenant concentration and bargaining power 15% (riskTier: low 78, moderate 56, high 30, n/a 60), insurance load and renewal shock 20% (insuranceLoad above-band minus 10, below-band plus 6, in-band neutral; carrier renewal high minus 14 elevated minus 8 moderate minus 3; climate band severe minus 10, material minus 5), vacancy rollover and renewal timing 15% (maxAnnualRolloverPct above 40% minus 18, above 25% minus 8; renewal shock overlap with rollover above 25% minus 8 additional), operating margin and cash conversion cushion 15% (margin trend expanding plus 6, compressing minus 14; cashConversion band thin minus 14, tight minus 8, strong plus 4), deductible and placement complexity 5% (catastrophic-deductible minus 14, material-deductible minus 8; structural-exclusions minus 6; lender-controlled-escrow minus 6, deductible-event-escrow minus 3). Bands: recovery-protected (composite 78-plus and recoverable 75%-plus), partial-pass-through (63-77 or recoverable 50-74%), noi-drag-watch (48-62 or recoverable 25-49%), sponsor-absorbed-risk (under 48 or recoverable under 25% or elevated/high renewal shock with compressing margin), not-assessable. Memo surface: verdict banner with band, score, recovery structure, recoverable percentage, sensitivity tier; four-stat headline (sponsor absorbed percentage, NOI drag bps, cash-flow drag dollars, renewal shock recovery gap); three-cell recovery waterfall strip (gross insurance shock, recovered from tenants percentage, sponsor absorbed percentage); six-driver weighted score table with status, contribution, and interpretation; lease review actions tied to recovery-clause review (always), insurance recovery caps and base-year amounts (always), anchor-tenant caps and side letters when concentration is moderate or high, NOI drag modeling at the bps level when drag is non-zero, deductible event recovery scope on material or catastrophic deductibles, lease renewal calendar alignment on modified-gross or gross-or-capped structures; 2-4 deal implications by band including recoverable percentage, cash-flow drag dollars, and the explicit framing that on sponsor-absorbed-risk deals insurance growth becomes price not recovery. Module degrades gracefully when tenantConcentration has no rent roll (no concentration haircut, neutral driver), climate forecast has no geo coverage (falls back to carrier shock multiple, then noiDecomp), operatingMarginTrend or cashConversion are absent (cushion driver neutral), and deductible or placement modules are absent (complexity driver neutral). Type-name corrections vs spec: rolloverDowntime.ts does not exist (rollover signal lives on TenantConcentrationResult.maxAnnualRolloverPct), operatingCashConversion.ts actual filename is cashConversion.ts with type CashConversionResult, noiDecomposition.ts actual filename is noiDecomp.ts with per-year type NoiDecompYear[] (not aggregate), and rentRoll.ts does not exist (rent roll is inputs.revenue.tenants[]). Insurance expense recovery and NOI pass-through risk is a deterministic lease-recovery overlay. It is not a lease abstract, legal opinion, insurance quote, or tenant reimbursement determination.
The memo now models insurance cost (insuranceLoad, climateInsuranceForecast), carrier availability (insuranceCarrierAvailabilityRenewalRisk), and coverage architecture (insuranceDeductibleShockCoverageExclusion). This synthesis module answers the missing IC question: what placement path and escrow posture should the sponsor pursue before hard money. Insurance risk is now a capital-markets execution issue, not an expense line. The output is a deterministic recommendation on admitted-versus-surplus placement, layered-tower needs, lender escrow posture, and broker engagement timing; it does not produce quotes, replace a broker, or substitute for legal or coverage advice. Renders for any deal with purchase price, hold period, Y1 NOI, and at least one source of insurance, climate, peril, or upstream insurance-module context. Placement route classification (priority order): lender-exception-required when structural exclusions are present, lender covenant reads negative or elevated, brownfield lenderEscrowRisk is high, carrier lenderExceptionRisk is high, or reserve-coverage-against-shock is below 0.70x; surplus-lines-backup when carrier band is constrained-carrier-market or coverage-friction-risk; layered-market when dominant peril is high (wind, flood, or wildfire) or material exclusions are present; admitted-with-conditions when carrier band is monitored-renewal, deductible band is deductible-watch, exclusions are narrow, or renewal shock is elevated or high; admitted-standard otherwise. Escrow posture classification: lender-controlled-escrow when route is lender-exception-required; deductible-event-escrow when deductible band is material or catastrophic or brownfield lenderEscrowRisk is elevated; monitored-renewal-escrow when carrier band is constrained or coverage-friction-risk, renewal shock is elevated or high, or route is admitted-with-conditions or layered-market; no-extra-escrow otherwise. Recommended escrow dollars sized as the maximum of three components: modeled single-event deductible from insuranceDeductibleShockCoverageExclusion.estimatedDeductibleShockDollars, renewal shock reserve sized as a carrier-band-driven multiple of Y1 insurance premium (high 0.5x, elevated 0.35x, moderate 0.2x, low 0.1x, unknown 0.15x), and lender environmental escrow proxy from brownfieldRemediationReserveAdequacy.fundingGap (full gap when escrow risk is high, half when elevated, zero otherwise). Escrow months: monitored-renewal 6, deductible-event 12, lender-controlled 24, no-extra 0. Broker engagement timing classification: immediate-market-check when route is lender-exception-required or surplus-lines-backup; pre-hard-money when route is layered-market or carrier band is constrained-carrier-market or deductible band is insurance-structure-risk; pre-loi when composite score is below 70 or route is admitted-with-conditions; standard-renewal otherwise. Six weighted drivers: carrier availability and renewal market 25% (carrier band: standard-market 82, monitored-renewal 64, constrained-carrier-market 40, coverage-friction-risk 22; renewal shock high minus 8 elevated minus 4; lender exception high minus 6 elevated minus 3), deductible shock and exclusion sensitivity 25% (deductible band: coverage-resilient 82, deductible-watch 64, exclusion-sensitive 40, insurance-structure-risk 22; structural-exclusions minus 8, material-exclusions minus 4; catastrophic-deductible minus 8, material-deductible minus 4), climate and geographic peril severity 20% (geoRiskOverlay.climateRiskBand: low 82, moderate 64, elevated 38, high 22; climate forecast severe minus 6, material minus 3; falls back to climate forecast band when geo overlay not covered), reserve and escrow capacity 15% (reserveAdequacy status: adequate 75, thin 46, under-reserved 24; reserve coverage against shock under 0.70x floors at 22, under 1.0x at 40, under 1.25x at 56; brownfield lender escrow risk high floors at 30, elevated at 50), debt sizing and lender covenant pressure 10% (DSCR-bound minus 14, debt-yield-bound minus 6, LTV-bound neutral; refi maxShiftBps under 100 minus 10, 100-200 minus 4; deductible-shock lender covenant negative minus 12, elevated minus 6), current premium load versus benchmark 5% (below-band 78, in-band 64, above-band 38). Bands: standard-market-program (composite 78-plus, route admitted-standard, no elevated dimension), monitored-renewal-program (63-77 or composite 78-plus with one elevated dimension such as elevated renewal shock or elevated lender exception or elevated lender covenant), structured-placement-needed (48-62 or composite 48-plus with exclusion-sensitive band or material or catastrophic deductible), lender-exception-workout (under 48, route lender-exception-required, structural exclusions, or insurance-structure-risk band), not-assessable. Memo surface: verdict banner with band, score, placement route, escrow posture; four-stat headline (recommended escrow dollars, escrow months, broker timing, lender posture); five-cell placement route strip (admitted-standard, admitted-with-conditions, layered-market, surplus-lines-backup, lender-exception-required) with the active route highlighted in gold; six-driver weighted score table with contribution and interpretation; coverage structure notes tied to dominant peril (wind tower percentage-of-TIV in 3-5% range for coastal markets, flood NFIP plus private excess attachment, wildfire defensible-space and Class A roof requirements, pollution legal liability endorsement scope); placement actions tied to route severity (three-carrier admitted quote on standard, pre-LOI market check on conditions, layered-tower scoping pre-hard-money on layered, surplus-lines parallel placement on backup, lender-exception workout on lender-exception); lender conversation points tied to lender insurance covenant baseline (always), carrier-market exception disclosure on elevated or high carrier risk, deductible escrow conversation on material or catastrophic deductibles, structural exclusions waiver or endorsement conversation, joint insurance-and-environmental escrow conversation on elevated or high brownfield lender escrow risk; 2-4 deal implications by band including escrow dollar sizing and the explicit framing that insurance becomes a structural input on lender-exception-workout deals. Module degrades gracefully when any individual upstream module is absent; drivers default to neutral 55-60 scores with explicit fallback interpretation. Type-name verification: insuranceLoad surfaces premium as y1InsuranceDollars (not annualPremium); annual premium proxy reads from that field. No other type-name corrections vs spec; all eleven upstream types matched exactly. Insurance program placement and escrow strategy is a deterministic underwriting overlay. It is not an insurance quote, broker recommendation, lender approval, legal opinion, or coverage advice.
Phase 3 continues: Insurance Carrier Availability and Renewal Risk Index and Insurance Deductible Shock and Coverage Exclusion Sensitivity land. Memo now classifies whether a deal can actually secure and renew coverage on institutional terms, plus a deterministic deductible-shock and coverage-exclusion screen that turns peril severity into single-event deductible dollars, NOI drag bps, reserve coverage ratio, lender covenant read, and a five-peril coverage-risk strip (wind, flood, wildfire, liability, environmental) on every memo where insurance or peril context is available. 108 Phase 3 modules cumulative.
Premium load tells the IC what insurance costs today. Climate-adjusted forecast tells the IC where premium drifts over hold. Carrier availability tells the IC whether coverage can be secured. This module answers the missing IC question: if deductibles reset higher, named perils are excluded, or lender-required coverage narrows, does the deal still carry enough NOI and reserve capacity. It is not an insurance quote, legal opinion, or coverage recommendation; it translates coverage terms into NOI drag, reserve need, lender compliance risk, and IC diligence actions. Renders for any deal with purchase price, hold period, Y1 NOI, and at least one source of insurance or peril context (insuranceLoad, climateInsuranceForecast, or geoRiskOverlay with covered scores). Coverage risk strip classifies five perils independently with low / moderate / elevated / high tiers: wind from geoRiskOverlay.scores.hurricane and tornado (tornado escalates wind if higher), flood from geoRiskOverlay.scores.flood, wildfire from geoRiskOverlay.scores.wildfire, liability defaulting to low without explicit cues, environmental from environmentalSiteConditionRiskIndex.band (remediation-sensitive high, environmental-watch elevated, manageable-diligence moderate, clean-site-likely low). Single-event deductible shock dollars estimated from the dominant peril tier: high-tier wind 5% of total insured value (TIV approximated at 70% of purchase price), elevated 3%, moderate 1.5%; high-tier wildfire max of $500K or 2% TIV, elevated max of $250K or 1% TIV; high-tier flood max of $500K or 2% TIV, elevated max of $250K or 1% TIV; baseline all-other-perils $50K floor; above-band insuranceLoad amplifies the modeled event 1.1x. Deductible band classification by absolute size and percent of price: catastrophic-deductible at 3% of price or $1M-plus; material-deductible at 1.5% or $500K-plus; elevated-deductible at 0.5% or $150K-plus; standard-deductible otherwise. NOI drag bps equals deductible event divided by Y1 NOI times 10,000. Coverage exclusion band from strip arithmetic (tier weights low 0 / moderate 1 / elevated 2 / high 3 across the five perils): 0-1 broad-coverage, 2-4 narrow-exclusions, 5-8 material-exclusions, 9-plus structural-exclusions. High flood or wildfire alone escalate narrow-exclusions to material-exclusions because those perils typically become named exclusions rather than priced through. Six weighted drivers: deductible shock affordability 25% (noiDragBps banded: under 200 84, 200-500 64, 500-1000 44, 1000-2500 26, 2500-plus 14, with band-specific interpretation), coverage exclusion exposure 20% (broad-coverage 84, narrow-exclusions 64, material-exclusions 40, structural-exclusions 22), climate peril severity 20% (geoRiskOverlay.climateRiskBand: low 82, moderate 64, elevated 38, high 22; climateInsuranceForecast severe minus 8, material minus 4, no-uplift plus 2), reserve capacity 15% (reserveCoverageRatio = reservesAvgOverHold times hold divided by deductible event; 2.0x-plus 82, 1.25x 64, 0.75x 42, under 0.75x 22; reserveAdequacy under-reserved status floors at 30, thin status floors at 50), lender covenant and refi sensitivity 10% (DSCR-bound minus 12 with covenant-test note, debt-yield-bound minus 6, LTV-bound neutral; refi maxShiftBps under 100 minus 12, 100-200 minus 6; carrier lender exception high minus 10, elevated minus 5; covenant read classified supportive / neutral / watch / elevated / negative / not-assessable), carrier availability and renewal posture 10% (insuranceCarrierAvailabilityRenewalRisk.band: standard-market 80, monitored-renewal 64, constrained-carrier-market 42, coverage-friction-risk 22; renewal shock high minus 6, elevated minus 3). Bands: coverage-resilient (composite score 78-plus, no elevated or negative lender covenant read), deductible-watch (63-77 or composite 78-plus with elevated or negative covenant), exclusion-sensitive (48-62 or composite 48-plus with catastrophic deductible or structural exclusions), insurance-structure-risk (under 48 or catastrophic deductible plus structural exclusions), not-assessable. Hard floors prevent coverage-resilient when catastrophic deductibles or structural exclusions are present regardless of composite score. Memo surface: verdict banner with band, score, deductible shock dollars, NOI drag bps, reserve coverage ratio; four-stat headline (deductible band, exclusion band, NOI drag bps, lender covenant read); five-cell coverage risk strip by peril (wind, flood, wildfire, liability, environmental); six-driver weighted score table with status, contribution, and interpretation; diligence actions tied to binder and exclusions schedule request (always), deductible escrow modeling on material or catastrophic deductibles with explicit working-estimate dollars, lender insurance covenant confirmation (always), reserve sizing tested against deductible event when coverage under 1.25x, renewal-conditions review in constrained or coverage-friction carrier markets, layered or surplus-lines placement on high-tier flood or wildfire, pollution legal liability scope on elevated or high environmental tier; 2-4 deal implications by band including the explicit framing that coverage architecture is the underwriting story on insurance-structure-risk deals and that DSCR-bound sizings can breach on a single deductible event. Module degrades gracefully when any individual upstream module is absent; drivers default to neutral scores with explicit fallback interpretation. Type-name corrections vs spec: spec referenced climateAdjustedInsuranceForecastResult and geographicRiskOverlay.ts; live names are ClimateInsuranceForecast (from climateInsuranceForecast.ts) and GeoRiskOverlayResult (from geoRiskOverlay.ts). Insurance deductible shock and coverage exclusion sensitivity is a deterministic underwriting overlay. It is not an insurance quote, legal opinion, or coverage recommendation.
Insurance cost is modeled (insuranceLoad), climate-adjusted insurance is modeled (climateInsuranceForecast), environmental site risk is modeled (environmentalSiteConditionRiskIndex), and brownfield reserve adequacy is modeled (brownfieldRemediationReserveAdequacy). The missing IC question is whether the deal can actually secure and renew coverage on institutional terms. A deal can show acceptable premium load and still face carrier withdrawal, exclusions, deductible resets, lender insurance exceptions, or renewal shock. This module converts climate, insurance, geography, environmental, and operating-margin signals into a deterministic carrier availability and renewal-risk read. Renders for any deal with purchase price, hold period, and at least one source of carrier-market context (insurance load, climate insurance, geo risk overlay, state context, or property type). State carrier-market classification from address text: Florida and Louisiana baseline 24 (constrained-coastal, materially constrained carrier market with named-storm deductibles and state insurer of last resort fallback), California 28 (wildfire-constrained, Proposition 103 rate-filing friction and FAIR Plan fallback exposure), Texas coastal 44 (managed-coastal, TWIA wind tower fallback), Carolina and Georgia coastal 48 (managed-coastal, broader appetite than Florida or Louisiana), Colorado 52 (managed-wildfire, wildland-urban-interface non-renewal risk), Northeast 72 (standard-northeast), Midwest 74 (standard-midwest), neutral fallback 58. Six weighted drivers: current insurance load and benchmark position 20% (insuranceLoad.status: below-band 82, in-band 68, above-band 38; constrained-coastal or wildfire-constrained state amplifier subtracts 4-6), climate-adjusted insurance forecast 20% (climateInsuranceForecast.band: no-uplift 84, modest 64, material 38, severe 22), geographic peril exposure 20% (geoRiskOverlay.climateRiskBand: low 84, moderate 64, elevated 38, high 22), environmental and brownfield friction 15% (clean-site-likely 78, manageable-diligence 60, environmental-watch 40, remediation-sensitive 24; brownfield remediation-overhang floors at 22, funding-gap at 36; lender escrow high subtracts 6), operating margin absorption capacity 15% (expanding 78, stable 62, compressing 36; y1 margin 60%-plus adds 4, under 35% subtracts 6), state and regulatory insurance-market friction 10% (state classification score with neutral fallback). Carrier availability score surfaces independently as a focused blend of geo peril 40%, climate insurance 30%, state friction 30%. Renewal shock risk classification from climateInsuranceForecast.band crossed with insuranceLoad.status: severe forecast equals high regardless; material forecast plus above-band equals high; material alone equals elevated; modest plus above-band equals elevated; modest alone equals moderate; no-uplift equals low. When forecast has no geo coverage, fallback to insuranceLoad.status: above-band reads elevated, otherwise moderate. Deductible reset risk classification from geoRiskOverlay.climateRiskBand crossed with forecast band: high peril equals high; elevated peril plus material or severe forecast equals high; elevated peril alone equals elevated; moderate peril plus material or severe forecast equals elevated; moderate peril alone equals moderate; low peril equals low; no geo coverage defaults to moderate. Lender exception risk classification from environmental and brownfield bands: brownfield remediation-overhang or lenderEscrowRisk high equals high; env remediation-sensitive equals high; brownfield funding-gap or lenderEscrowRisk elevated equals elevated; env environmental-watch equals elevated; geo high climate band equals elevated; env manageable-diligence equals moderate; geo elevated equals moderate; otherwise low. Expected renewal load bps reads from climateInsuranceForecast.climateSurchargePct times 10,000 when forecast has geo coverage, null otherwise. Bands: standard-market (composite score 78-plus, renewal shock at most moderate, no high lender exception or deductible reset risk), monitored-renewal (63-77, or composite 78-plus with elevated renewal shock), constrained-carrier-market (48-62, or composite 48-plus with high renewal shock or deductible reset or lender exception), coverage-friction-risk (under 48, or composite under 48 with any high risk dimension), not-assessable. Hard floors prevent standard-market when any single risk dimension reads high regardless of composite score. Memo surface: verdict banner with band, score, renewal shock risk, and carrier availability score; four-stat headline (expected renewal load bps, deductible reset risk, lender exception risk, renewal shock risk); six-driver weighted score table with status, contribution, and interpretation; diligence actions tied to three-carrier-quote confirmation (always), renewal stress at 1.5x current premium when renewal shock is elevated or high, peril-specific deductible confirmation when deductible reset is elevated or high, lender exception disclosure on day one when lender exception is elevated or high, admitted-vs-surplus-lines market check in constrained coastal states, defensible-space and Class A roof requirements in California, layered tower placement on high peril, margin-cushion sizing on compressing margin trend; 2-4 deal implications by band including the explicit framing that coverage can become a year-by-year procurement exercise on coverage-friction-risk deals and that lender insurance exceptions can affect financing terms directly. Module degrades gracefully when any individual upstream module is absent; drivers default to neutral scores with explicit fallback interpretation. Type-name corrections: spec referenced climateAdjustedInsuranceForecast.ts and operatingMarginTrend.ts filenames; live filenames are climateInsuranceForecast.ts (type ClimateInsuranceForecast, no Adjusted in the name) and operatingMargin.ts (type OperatingMarginTrend, file is operatingMargin.ts not operatingMarginTrend.ts). Insurance carrier availability is a deterministic underwriting screen. It is not an insurance quote, broker recommendation, policy review, lender approval, or legal opinion.
Phase 3 continues: Zoning and Entitlement Constraint Index, Environmental Site Condition Risk Index, and Brownfield Remediation Reserve Adequacy all land. Memo now classifies approval posture, density sensitivity, parking relief need, adaptive reuse fit, and nonconforming-use status from jurisdiction-tier priors and deal-note cues, plus a deterministic environmental diligence triage that surfaces inferred prior-use history, expected review intensity, Phase II probability, vapor intrusion risk, floodplain exposure, brownfield redevelopment risk, and estimated diligence delay months, plus a brownfield reserve sufficiency screen that turns site-condition risk into an estimated remediation reserve, available reserve capacity, funding gap, coverage ratio, expected delay, and lender escrow read on every memo where the deal carries environmental exposure. 106 Phase 3 modules cumulative.
Environmental Site Condition Risk tells the IC whether a site carries environmental diligence exposure. Zoning and Entitlement Constraint Index tells the IC whether approvals may slow execution. This module answers the missing IC question: does the deal have enough reserve capacity to absorb remediation cost, lender escrow, delay, and environmental diligence before the return path breaks. It converts upstream site-condition risk into a deterministic reserve sufficiency read; it is not a cleanup budget, environmental report, legal opinion, or lender requirement. Renders only for deals where the upstream environmental severity is at the assessable threshold (manageable-diligence, environmental-watch, or remediation-sensitive) or the deal context surfaces environmental, redevelopment, adaptive reuse, industrial, mixed-use, prior-use, brownfield, floodplain, vapor, or remediation cues. Clean-site deals return not-applicable; deals without price, hold, or environmental classification also return not-applicable. Reserve need sizing is a deterministic prior keyed on the upstream use-history and review-intensity combination from the environmental module: brownfield-or-heavy-risk plus remediation-plan-needed 8.0% of purchase price; brownfield plus phase-ii-likely 5.0%; brownfield baseline 3.5%; industrial-or-auto-exposure plus remediation-plan-needed 4.0%; industrial plus phase-ii-likely 2.5%; industrial plus enhanced-phase-i 1.5%; industrial baseline 1.2%; adaptive-reuse-or-legacy plus phase-ii-likely 1.5%; adaptive-reuse plus enhanced-phase-i 0.75%; adaptive-reuse baseline 0.5%; standard-commercial plus phase-ii-likely 1.0%; standard plus enhanced-phase-i 0.5%; standard baseline 0.25%; clean-operating-history 0.10%. Adders stack: vapor intrusion elevated plus 1.25%, moderate plus 0.5%; floodplain elevated plus 0.75%, moderate plus 0.25%; brownfield redevelopment elevated plus 1.5%, moderate plus 0.75%. Capacity sizing pulls reserveAdequacy.reservesAvgOverHold times hold period as the operating reserve floor, plus a fraction (25%) of below-band acquisition-basis cushion when acquisitionBasis.status is below-band. Funding gap is the difference between need and capacity, floored at zero. Coverage ratio is capacity divided by need, null when need is zero. Expected delay months reads from environmentalSiteConditionRiskIndex.estimatedDiligenceDelayMonths. Lender escrow risk is classified from upstream environmental severity: high for remediation-sensitive band or brownfield-or-heavy-risk use history or remediation-plan-needed review intensity; elevated for phase-ii-likely or industrial-or-auto-exposure or vapor intrusion elevated; moderate for adaptive-reuse-or-legacy or enhanced-phase-i or vapor moderate; low otherwise. Six weighted drivers: environmental site condition severity 30% (band-driven: clean-site-likely 84, manageable-diligence 68, environmental-watch 44, remediation-sensitive 22), available reserves and capex capacity 25% (reserveAdequacy status: adequate 80, thin 48, under-reserved 24, fallback neutral 50 when module did not run), delay and entitlement interaction 15% (expectedDelayMonths base banded: under 2 months 80, 2-6 months 60, 7-12 months 38, over 12 months 18; zoning band overlay nudges: approval-constrained minus 12 and adds critical-path note, entitlement-sensitive minus 8 and adds public-hearing note, ministerial-review minus 2, as-of-right-likely plus 2), lender escrow and financing friction 15% (escrow risk band: low 82, moderate 64, elevated 42, high 22; interpretation tracks the specific lender environmental review posture), acquisition basis cushion 10% (below-band 78, in-band 58, above-band 32, fallback neutral 55), construction-cost inflation 5% (below 5% YoY 70, 5-7% 56, above 7% 36; capex-heavy minus 8 with overrun-risk note; implied capex curve in capex-burdened or maintenance-drag band minus 6 with compounding-drag note). Bands: reserve-covered (composite score 78-plus, coverage 1.25x or higher, no high escrow risk), reserve-watch (63-77, coverage 1.0x or moderate site risk), funding-gap (48-62 or coverage 0.70-0.99x), remediation-overhang (composite less than 48, coverage less than 0.70x, brownfield-or-heavy-risk plus severe delay over 12 months, or remediation-sensitive band with thin coverage), not-assessable. Hard floors prevent reserve-covered or reserve-watch verdicts when brownfield-or-heavy-risk pairs with thin coverage or severe delay regardless of composite score. Memo surface: verdict banner with band, score, reserve need dollars, coverage ratio percent; four-stat headline (reserve need, reserve capacity, funding gap, expected delay months); two-cell escrow-and-coverage strip (lender escrow risk, coverage ratio); six-driver weighted score table with status, contribution, and interpretation; diligence actions tied to reserve sizing relative to purchase price with explicit working estimate, funding gap remediation (price chip, lender escrow, or LP equity), lender environmental review timing (day-one disclosure when escrow risk elevated or high), state brownfield program enrollment for brownfield use history, environmental diligence runway in the LOI exclusivity period when delay exceeds 6 months, joint zoning and environmental sequencing when zoning is also flagged, basis-above-band re-cut warnings, and construction-cost inflation overrun buffers when YoY inflation is at 5% or above; 2-4 deal implications by band including the explicit framing that the environmental track is the critical path on remediation-overhang deals and the funding gap dollar value when coverage is thin. Module degrades gracefully when reserveAdequacy is not computed (capacity falls back to 1.5% of price as conservative floor; capacity driver scores neutral 50), when acquisitionBasis is absent (cushion driver scores neutral 55), when constructionCostInflation is absent (construction driver scores neutral 55), when zoning is not applicable (delay-interaction driver applies no overlay nudge), and when impliedCapexYieldCurve is absent (no compounding-drag note). Brownfield reserve adequacy is a deterministic underwriting screen. It is not an environmental report, legal opinion, remediation estimate, or lender requirement.
Environmental diligence is one of the few areas where a deal can look attractive in the model and still be unfinanceable, delayed, or repriced after third-party reports. This module is a deterministic early-warning screen, not a Phase I ESA, Phase II investigation, lender environmental review, or counsel opinion. It tells the IC which deals need environmental diligence front-loaded before price, debt, schedule, or insurance assumptions become trusted. Auto-applicable across CRE; renders for any deal with property type plus enough basic context. For clean deals the panel reads as a concise low-risk panel; for legacy or industrial-history deals it surfaces the additional reports the IC should price into the timeline before close. Use-history classification from text cues in property type, deal name, address, notes, and tenant labels: clean-operating-history (multifamily, SFR, BTR, student housing, senior housing with no adverse cues), standard-commercial (office, retail, hotel, mixed-use with no adverse cues), adaptive-reuse-or-legacy-commercial (conversion, change-of-use, adaptive reuse, pre-war or historic building, lab repositioning, industrial property type without explicit contamination cues), industrial-or-auto-exposure (industrial cue, auto repair, body shop, dry cleaner, two-or-more heavy cues), brownfield-or-heavy-risk (brownfield, manufacturing, plating, chemical, refinery, landfill, gas station, UST, AST, leaking tank, petroleum, fuel storage). Heavy cue dictionary: industrial, manufacturing, plating, chemical, dry cleaner, gas station, service station, fuel station, auto repair, body shop, auto shop, storage yard, fuel yard, rail, railyard, port, wharf, landfill, brownfield, former mill, mill site, refinery, warehouse conversion, environmental, remediation, vapor, UST, AST, asbestos, lead paint, PCB, petroleum, diesel spill, leaking tank. Moderate cue dictionary: auto, automotive, service center, laundromat, laundry, printing, print shop, medical, lab, laboratory, life science, biotech, wet lab, research park, former office, office-to-residential, office-to-lab, adaptive reuse, repositioning, change of use, conversion, older building, pre-war, prewar, historic. Flood cue dictionary: floodplain, flood plain, flood zone, waterfront, river, creek, lake, harbor, bayfront, tidal, wetland, marsh, estuary. Six weighted drivers: prior-use and contamination cue risk 25% (use-history banded baseline: clean 82, standard commercial 74, adaptive reuse or legacy 56, industrial or auto 38, brownfield or heavy 22; plus heavy-cue counts and absence-of-cues adjustments), site-history and tenant-use cues 20% (three-or-more high-attention cues like dry cleaner, gas station, auto repair, UST or AST, manufacturing or plating, or lab or biotech scores 24; two cues 38; one cue 50; adaptive-reuse or conversion only 56; historic only 60; clean 74), flood, water, and climate adjacency 15% (overlay-driven: GeoRiskOverlayResult flood score, hurricane score haircut, ClimateTransitionRisk compositeTransitionRisk haircut, plus flood text cues; elevated 32, moderate 52, low 70, unknown 58), adaptive reuse and redevelopment intensity 15% (adaptive reuse or conversion 44, industrial or lab repositioning 42, historic-building 54; tightened when zoning module flags entitlement-sensitive or approval-constrained), zoning and entitlement dependency interaction 10% (zoning module band-driven: as-of-right-likely 78, ministerial-review 64, entitlement-sensitive 40, approval-constrained 24; unknown 65), reserve, capex, and acquisition-basis cushion 15% (ReserveAdequacyAnalysis status: adequate 74, thin 46, under-reserved 28; ImpliedCapexYieldCurveResult band integration: capex-burdened or maintenance-drag floors at 38, self-funding or value-creating raises to 68; AcquisitionBasis status: above-band minus 6, below-band plus 4). Phase II probability classification: high for brownfield or heavy use-history or fuel tank or manufacturing or gas station or brownfield cues, moderate for industrial-or-auto-exposure or dry cleaner or auto or vapor cues or adaptive-reuse-or-legacy with lab or asbestos cues, low otherwise, unknown when use-history is unknown. Remediation reserve need classification: material for brownfield or heavy use-history or manufacturing or fuel tank or gas station or brownfield cues, modest for industrial-or-auto-exposure or dry cleaner or auto or asbestos cues, none otherwise, unknown when use-history is unknown. Vapor intrusion risk classification: elevated when vapor, dry cleaner, fuel tank, or gas station cues hit or use-history is industrial-or-auto-exposure or brownfield-or-heavy-risk; moderate for adaptive-reuse-or-legacy or lab or manufacturing; low otherwise. Floodplain or water risk: elevated above 65 composite from geo and climate scores plus cues, moderate 45-65, low below 45, unknown when no geo or climate overlay coverage and no flood text cues. Brownfield redevelopment risk: elevated when heavy exposure plus either adaptive reuse cue or tough zoning posture, moderate when heavy exposure alone or adaptive reuse plus tough zoning, low otherwise. Estimated diligence delay months computed from review intensity baseline (standard-phase-i 1, enhanced-phase-i 2, phase-ii-likely 3, remediation-plan-needed 6) plus brownfield bumps (elevated plus 3, moderate plus 1). Bands: clean-site-likely (composite score 78-plus with no heavy cues, standard Phase I likely enough), manageable-diligence (63-77, diligence required but normal IC timing), environmental-watch (48-62, enhanced Phase I or targeted consultant work), remediation-sensitive (less than 48, Phase II or remediation plan may affect timing, debt, or price), not-assessable. Hard floors prevent clean-site-likely or manageable-diligence verdicts when heavy contamination cues are present, regardless of upstream cushion. Memo surface: verdict banner with band, score, inferred use history, and review intensity; composite score bar with band threshold ticks at 48, 63, 78; four-stat headline strip (Phase II probability, remediation reserve need, vapor intrusion risk, estimated diligence delay months); two-cell flood-and-brownfield strip (floodplain or water risk, brownfield redevelopment risk); six-driver weighted score table with contribution and interpretation; diligence actions tied to review intensity (standard ASTM E1527-21 Phase I, enhanced Phase I with Sanborn and regulatory database deep-dive, Phase II pre-scope, remediation-experienced consultant and counsel kickoff, state brownfield program enrollment check), to specific cue hits (asbestos and lead paint surveys for pre-1980 buildings, UST and AST documentation, dry-cleaner PCE and TCE plume mapping, soil-vapor sampling, FEMA flood map review, environmental contingency reserve sizing, implied capex curve reconciliation), and to lender environmental review timing; 2-4 deal implications by band including the explicit framing that environmental track can become the critical path on remediation-sensitive deals and the estimated environmental diligence runway in months. Module degrades gracefully when GeoRiskOverlayResult is not covered, ClimateTransitionRisk is not computed, or upstream overlays are absent; drivers default to text-cue and use-history baselines with neutral status. Type-name corrections: spec referenced ReserveAdequacyResult and GeographicRiskOverlayResult upstream types that do not exist in the codebase; the live names are ReserveAdequacyAnalysis (from lib/engine/reserveAdequacy.ts) and GeoRiskOverlayResult (from lib/engine/geoRiskOverlay.ts, a discriminated union with the not-covered branch handled explicitly). Environmental Site Condition Risk Index is a deterministic diligence screen. It is not a Phase I ESA, Phase II ESA, remediation budget, lender environmental approval, legal opinion, or consultant report.
Zoning posture and entitlement risk shape what a deal can actually build, lease, or convert. A pro forma that assumes as-of-right execution reads differently when the asset sits in a high-discretion jurisdiction, requires a special permit or variance, leans on adaptive reuse, or carries a nonconforming use that constrains future redevelopment. This module classifies the approval posture and entitlement constraint from jurisdiction-tier priors and deal-note cues, then surfaces the gap between as-of-right execution and discretionary approval risk. Auto-applicable for any deal with zoning, entitlement, variance, special permit, ZBA, BZA, conditional use, rezoning, upzoning, downzoning, PUD, planned unit development, master plan, specific plan, nonconforming, grandfathered, historic district, landmark, conversion, change of use, FAR, density bonus, inclusionary, as-of-right, by-right, or matter-of-right cues in property type, deal name, address, or notes; also auto-applicable for Mixed-Use deals (operating with both residential and retail components typically involves zoning interaction) and ground-up development plays. Non-applicable deals return the not-applicable verdict and the memo section does not render. Jurisdiction tier classification from address: high-discretion coastal (Manhattan, Brooklyn, Queens, Bronx, Staten Island, San Francisco, Boston, Washington DC, Santa Monica, Berkeley) with baseline 36, approval-time multiplier 1.6x, variance success 38%, community-board influence high, master-plan complexity high; dense urban infill (Seattle, Portland, Oakland, Los Angeles, Philadelphia, Chicago, Brooklyn outer, Queens outer, downtown Austin) baseline 50, 1.3x, 52%, moderate community influence; university town (Ithaca, Ann Arbor, Madison, State College, Chapel Hill, Boulder, Gainesville, College Station, Bloomington, Athens) baseline 52, 1.2x, 55%, moderate community influence; Sunbelt growth (Dallas, Houston, Atlanta, Nashville, Phoenix, Miami, Orlando, Tampa, Charlotte, Raleigh, Austin suburbs) baseline 70, 1.0x, 72%; suburban (strip, suburb, regional, highway, freeway cues) baseline 68, 1.0x, 70%; unknown jurisdiction baseline 55, 1.1x, 60%. Approval posture classification: as-of-right (by-right, as-of-right, matter-of-right cues with no discretionary cues), administrative-approval (site plan, building permit, administrative review cues), special-permit (special permit, conditional use, ZBA, BZA, variance, exception cues), full-discretionary (rezoning, upzoning, downzoning, PUD, planned unit development, master plan, specific plan, comprehensive plan amendment, general plan amendment, community board cues). Adaptive reuse cue detection (conversion, change of use, adaptive reuse, repositioning, repurpose) with stronger penalty in high-discretion coastal jurisdictions. Historic and landmark cue detection (historic, landmark, preservation, designated, contributing, district) penalizes adaptive reuse fit and adds a Section 106 / SHPO callout when triggered. Nonconforming-use cue detection (nonconforming, grandfathered, legal non-conforming) flags rebuild and expansion constraints; nonconforming status drops adaptive reuse fit and limits density bonus availability. Density sensitivity classification: low (Sunbelt suburban, by-right cues), moderate (university town, dense urban infill without density-bonus cue), elevated (high-discretion coastal, community-board cues, downzoning history references), high (heritage district overlay, view-corridor restriction, height-cap cue, density transfer cue). Parking relief need classification: none (by-right cues, suburban parking-rich profile), minor (single-stall relief request, transit-adjacency cue with mild parking ratio shortfall), moderate (multi-stall variance, residential infill with sub-benchmark parking), substantial (transit-zoning overlay reliance, parking-maximum jurisdiction with elevated demand classification, parking-relief explicit in notes). Six weighted drivers: as-of-right execution clarity 30% (approval posture banded: as-of-right 86, administrative-approval 70, special-permit 50, full-discretionary 28; jurisdiction tier nudges plus or minus), density sensitivity and FAR headroom 20% (band: low 80, moderate 64, elevated 44, high 26; density-bonus cue adds 8, downzoning cue subtracts 12), parking and access relief feasibility 15% (need band: none 82, minor 64, moderate 44, substantial 26; parking-friction overlay band integration: access-advantaged plus 8, parking-supported plus 4, manageable-friction minus 4, access-constrained minus 12), adaptive reuse and conversion fit 15% (cue-driven baseline: no-conversion 70, conversion-light 58, full-adaptive-reuse 42; historic-district cue subtracts 14, nonconforming subtracts 10, jurisdiction tier 1.0x to 0.7x), nonconforming-use risk and rebuild constraint 10% (status banded: conforming 80, nonconforming-rebuildable 56, nonconforming-restricted 32, nonconforming-loss-of-rights 18), supply and pipeline context 10% (supply pipeline overlay band-driven: constrained 78, balanced 64, moderate-oversupply 46, heavy-oversupply 28; supply-constrained jurisdictions amplify entitlement value, oversupplied jurisdictions undercut it). Approval-time months estimate computed from posture baseline times jurisdiction multiplier (as-of-right 2 months, administrative 4-6, special-permit 8-14, full-discretionary 14-30; high-discretion coastal multiplies 1.6x). Variance success likelihood from jurisdiction profile with cue adjustments (community board strong subtract 10, neighborhood opposition cue subtract 15, sponsor track-record cue add 8). Community-board influence tier from jurisdiction (high coastal, moderate dense infill and university, low Sunbelt and suburban). Bands: as-of-right-execution (composite score 78-plus and posture is as-of-right or administrative), entitlement-supported (63-77, special permit feasible with manageable approval-time and supportive variance success), discretionary-approval-risk (48-62, special-permit or full-discretionary posture with elevated approval-time and parking or density relief uncertainty), entitlement-blocked (less than 48, full-discretionary posture in high-discretion jurisdiction with nonconforming-loss-of-rights, historic restriction, or substantial parking-relief need that the path does not credibly support), not-applicable, not-assessable. Memo surface: verdict banner with band, score, jurisdiction tier, and approval posture; composite score bar with band threshold ticks at 48, 63, 78; four-cell risk strip (as-of-right likely, density sensitivity, parking relief, adaptive reuse fit); two-cell nonconforming-and-posture strip (nonconforming-use status, community-board influence); six-driver weighted score table; diligence actions tied to posture severity (confirm jurisdiction zoning code and overlay districts at parcel level when posture is special-permit or full-discretionary, identify zoning counsel with track record in the specific jurisdiction, model approval-time months into hold and stabilization timeline, reserve entitlement reserves for legal and consulting fees, surface variance precedent and community-board posture before LOI, validate nonconforming rebuild and expansion rights with zoning officer when status flagged, scope SHPO / Section 106 process when historic district cue triggers, confirm parking-maximum or minimum exposure when relief need is moderate or substantial); deal implications by band including the explicit framing that as-of-right execution is the underwriting baseline and that discretionary approval risk is structurally different from market risk because it cannot be hedged with capital structure alone. Module degrades gracefully when parking-demand and mixed-use synergy overlays are unavailable; drivers default to jurisdiction-tier and cue-derived baselines with neutral status. Type-name corrections: Codex spec referenced TransitOrientedAccessibilityPremium and DevelopmentFeasibilityIndex upstream modules that do not yet exist in the codebase; the transit-adjacency signal is read through the parking-demand-and-access-friction overlay instead, and the development-feasibility cross-check is absorbed into the as-of-right-execution-clarity and density-sensitivity drivers directly. Zoning and Entitlement Constraint Index is a deterministic zoning posture overlay. It is not legal advice, a zoning counsel opinion, a title report, or an entitlement guarantee.
Phase 3 continues: thirteen new specialty and macro overlays land today. Distress-to-Stabilized IRR Path Model, Macroeconomic Regime Switcher, Data Center Power Capacity Tracker, Life Sciences Tenant Demand Tracker, Workforce Housing Premium Tracker, Single Family Rental Yield Index, Healthcare REIT Sub-Sector Analysis, Student Housing Demand Tracker, Retail Anchor Durability Tracker, Retail Trade Area Leakage and Capture Analysis, Mixed-Use Synergy and Conflict Index, Parking Demand and Access Friction Index, and Office Obsolescence and Leasing Friction Index all land. Auto-applicable signal sets across data-center, life-sciences, workforce-housing, SFR / BTR, healthcare, student-housing, retail, mixed-use, parking-sensitive, and office deals join the engine alongside the macro regime transition map. 103 Phase 3 modules cumulative.
Office underwriting is now dominated by functional obsolescence, tenant decision friction, lease-up drag, access quality, and cap-rate reset risk. A conventional pro forma can show an acceptable IRR while the asset is actually fighting weak tenant demand, long downtime, high TI/LC burden, or a building-quality mismatch. This module tells the IC whether an office deal is leasing-relevant or structurally obsolete. Renders only for office-relevant deals (Office property type, Mixed-Use with office cues, or any deal flagged with office, class A, class B, trophy, tower, plaza, corporate park, creative office, or medical office signatures in property type, deal name, address, notes, or tenant labels). Non-office deals without those cues return not-applicable; memo section does not render. Six use cases with seeded priors: CBD trophy (obsolescence resistance 82, tenant demand 78, leasing friction 70, TI/LC reserve 90 per SF, downtime baseline 8 months, stabilized occupancy 90%, amenity 82, cap-rate reset 70), Class A suburban (70 / 64 / 60 / 65 / 12 mo / 88% / 64 / 58), commodity office (44 / 40 / 38 / 50 / 18 mo / 82% / 42 / 36), medical office (76 / 78 / 72 / 80 / 9 mo / 92% / 64 / 72; lower remote-work shock, longer lease tenure), creative office (58 / 56 / 52 / 95 / 14 mo / 86% / 72 / 50; selective demand, amenity dependent, higher capital burden), mixed-use office (62 / 60 / 58 / 70 / 12 mo / 86% / 70 / 56). Inferred class trophy / class-a / class-b / class-c / unknown drives bumps on obsolescence and demand: trophy +8 obsolescence and +6 demand, class-a +4 and +2, class-b -6 and -8, class-c -14 and -16. Six weighted drivers: tenant demand and rent relevance 25% (use-case and class baseline plus net effective rent overlay: 20%+ NER discount -8, 10%-or-below +4), functional quality and class proxy 20%, rollover downtime and lease-up friction 20% (use-case downtime baseline scaled by tenant concentration max-annual rollover: 40%+ rollover scales downtime 1.4x and friction -12; 25-40% scales 1.2x and -6; high-tier risk -6 additional, low-tier +4), TI/LC and capital burden 15% (use-case TI/LC reserve baseline per SF), access and amenity support 10% (parking access friction overlay band-driven adjustment: access-advantaged +10, parking-supported +4, manageable-friction -4, access-constrained -12), cap-rate reset and exit liquidity pressure 10% (cap-rate persistence forecast band-driven: persistent +8, mild +2, active mean reversion -4, reset risk -14). Bands: institutional-quality (score 78+, tenant demand supportive, obsolescence risk low), leasing-relevant (63-77, financeable with active tenant management), selective-demand (48-62, demand exists but pricing and capital plan must reflect leasing-friction reality), functional-obsolescence-risk (less than 48, leasing friction or building mismatch dominates), not-assessable. Memo surface: verdict banner with band, score, use case, and inferred class; four-stat headline (leasing friction score, obsolescence risk score, estimated downtime months, TI/LC reserve per SF); composite score bar with band threshold ticks at 48, 63, 78; three-cell strip (tenant demand, access + amenity, cap-rate reset); six-driver weighted score table; underwriting actions (verify three credible tenant prospects when demand soft, confirm building system condition and modernization capex when obsolescence flagged, reserve estimated downtime months per rollover, size TI/LC reserve into capital plan especially when NER discount elevated, address parking and amenity profile when soft, buffer exit cap when reset risk flagged, special action when class-c is detected); deal implications by band including the institutional bifurcation framing (trophy and Class A absorb demand while commodity and Class C continue to face structural friction). Module degrades gracefully when net effective rent, tenant concentration, cap-rate persistence, or parking access overlays are unavailable; drivers default to use-case baselines with neutral status. Type-name correction: Codex spec referenced a RolloverDowntimeResult upstream module that does not yet exist in the codebase; the rollover-and-downtime driver instead reads tenant-concentration max-annual rollover concentration as the live signal and the use-case downtime baseline as the seeded floor. Office Obsolescence and Leasing Friction Index is a deterministic leasing-friction overlay. It is not a broker opinion, an appraisal, or a tenant demand forecast.
Parking and access friction can make or break retail, mixed-use, medical office, suburban office, student housing, and multifamily deals. The same rent roll can underwrite differently if customers, tenants, patients, or residents cannot easily reach the asset. This module classifies the use case from property type and upstream signals: medical office routes through the healthcare sub-sector module, student housing through the student tracker, mixed-use through mix detection, retail through the anchor tracker or revenue fields, plus office, multifamily, industrial, and hotel fallbacks. Benchmark parking ratios seeded per institutional norms: grocery and daily-needs retail 4.0-5.0 per 1,000 SF, neighborhood retail 3.5-4.5, restaurant-heavy 8.0-12.0, medical office 4.5-5.5, general office 2.5-3.5, multifamily 1.0-1.5 per unit, student housing 0.5-1.0 per bed, hotel 0.7-1.1 per key, industrial 0.5-1.5 per 1,000 SF. Location profile adjusts the benchmark via a multiplier: urban CBD strong transit offset and 0.55x benchmark (Manhattan, Brooklyn, Queens, downtown San Francisco, downtown Boston, Chicago Loop and Near North, downtown Seattle, Washington DC), dense urban infill 0.70x (Oakland, Philadelphia, Baltimore, downtown Austin, downtown Portland, South Lake Union), university town 0.80x (Ithaca, Ann Arbor, Madison, State College, Chapel Hill, Boulder, Gainesville, College Station, Bloomington, Athens), sunbelt suburban 1.00x (Dallas, Houston, Atlanta, Nashville, Phoenix, Miami, Orlando, Tampa, Charlotte, Raleigh, Austin), suburban or regional 1.10x (strip mall, strip center, power center, regional mall, highway, freeway, interstate cues). Sponsor-supplied parking ratio is parsed from deal notes via regex patterns (stalls per 1,000 SF, stalls per unit, spaces per bed, parking ratio explicit); when present, the module scores against the location-adjusted benchmark. When absent, the module scores the benchmark pressure rather than pretending precision and caps the score ceiling at 78 with the supply driver marked watch so the IC sees the missing precision. Six weighted drivers: parking supply versus benchmark or inferred adequacy 30% (ratio versus location-adjusted benchmark band: 86 if clears by 5%-plus, 72 if in band, 50 if 8-25% deficit, 28 if 25%-plus deficit), transit and walkability offset 20% (strong 84, moderate 64, limited 38, none 24), use-case access dependency 15% (low 78, moderate 60, high 38), curb and ingress-egress friction 15% (low 78, moderate 60, high 38; restaurant-heavy retail compounds curb friction with delivery and rideshare congestion), upstream retail or mixed-use conflict signal 10% (mixed-use synergy band-driven: integrated 76 down to operational-friction 30; retail trade-area leakage as fallback), tenant or customer sensitivity 10% (medical office 30 with highest patient sensitivity, retail 38 with customer-routing sensitivity, office 54, mixed-use 48, student housing 64, multifamily 60, hotel 56, industrial 70; strong transit offset adds back 12, moderate adds back 6). Bands: access-advantaged (score 78-plus), parking-supported (64-77), manageable-friction (49-63), access-constrained (less than 49), not-assessable. Industrial and hotel deals auto-skip unless notes mention parking, access, transit, walkability, ingress, curb, or loading-dock cues, since those formats carry property-type-specific access dynamics (industrial prioritizes truck access; hotel uses valet and drive-court). Memo surface: verdict banner with band, score, and use case; four-stat headline (inferred parking ratio, benchmark ratio, transit offset, curb friction); access friction gauge with band threshold ticks at 22, 36, and 51 percent friction; three-cell strip (parking gap, access dependency, transit and curb combination); six-driver weighted score table; underwriting actions tied to missing sponsor ratio, parking deficit, transit absence, curb friction, retail trade area competitiveness, medical office patient sensitivity, and mixed-use operational friction; deal implications by band. Parking demand and access friction are deterministic underwriting proxies. They are not a traffic study, a zoning opinion, or a parking-code compliance review.
Mixed-use is not just multifamily plus retail. The components can reinforce each other (residential demand supports retail foot traffic, retail amenities lift residential renewal velocity, shared expense allocation reads credible) or create internal friction (over-scaled retail program, dominant commercial NOI share, above-market rents, single-tenant concentration, shared parking and loading conflict). This module applies only to deals classified as Mixed-Use or that carry both residential units and retail or commercial SF; single-use deals return not-applicable. Residential and commercial NOI shares computed from Y1 proforma (residential GPR less vacancy versus retail GPR less vacancy plus free-rent abatement plus other income) and approximated via revenue share times Y1 NOI. Retail SF per residential unit serves as the mix-balance proxy. Seven weighted drivers: residential and retail revenue balance 20% (40-60% residential share is the integrated sweet spot scoring 82; 30-75% supports complementary stack at 68; 15-85% leans materially at 50; thinner mixes get 24-36; retail SF per unit nudges plus 4 when below 50, minus 8 when above 200), retail tenant durability and trade-area capture 20% (retail anchor durability band: necessity-anchored 82, durable-neighborhood 66, cyclical 44, fragility 26; plus trade-area leakage adjustment of plus 6 for dominant capture down to minus 10 for leakage risk), NOI diversification and concentration 15% (tenant concentration risk tier: low 78, moderate 60, high 36; commercial-dominant NOI compounds penalty), expense allocation credibility 15% (OpEx benchmark status: in-band 74, below-band 44, above-band 38 against the Mixed-Use 35-50% EGI band), demographic support 10%, vacancy and rollover friction 10% (max annual rollover 25-40% triggers penalty), operational complexity penalty 10% (excess retail SF per unit above 250, commercial-dominant NOI above 70%, above-market rents, OpEx above-band each deduct; necessity or neighborhood retail anchor adds back). Bands: integrated-mixed-use-premium (score 78-plus), complementary-use-stack (63-77), neutral-coexistence (48-62), operational-friction (less than 48), not-assessable. Synergy premium bps and conflict penalty bps are deterministic return-quality nudges per band: premium +35 bps for integrated, +15 bps for complementary, conflict penalty -40 bps for friction (only attached to the IRR sizing conversation, not auto-applied to the math). Memo surface: verdict banner with band, score, and premium or penalty bps; four-stat strip (residential NOI share, commercial NOI share, retail SF per unit, synergy or conflict bps); six-row synergy matrix (resident demand supports retail, retail amenities support residential rent, shared expenses credible, retail vacancy contained, tenant concentration manageable, parking and access and loading conflict limited) with status indicators sourced from the upstream retail anchor durability and trade-area leakage modules when available; seven-driver weighted score table with contribution and interpretation; underwriting actions tied to balance, durability, diversification, expense allocation, friction, and complexity (including a re-underwrite recommendation when revenue split implies a single-use deal with a token secondary component, a dedicated mixed-use property manager requirement when complexity penalty is active, and an external trade-area validation requirement when retail SF per residential unit exceeds 250); deal implications by band with explicit framing that mixed-use deals carry operating-cost complexity single-use deals never face (shared utilities, CAM allocation between residential and commercial tenants, life-safety code overlap, parking ratios, loading dock conflict, operating-hour mismatches). Cherry Street as the canonical mixed-use demo deal now reads through this index directly: a 24-unit residential program over 4,200 SF of retail at 132 Cherry Street will surface its specific synergy and conflict profile in the memo. Mixed-Use Synergy and Conflict Index is a deterministic mixed-use operating overlay. It is not a leasing forecast, an appraisal, a zoning opinion, or a site-planning study.
Retail Anchor Durability classifies tenant-mix durability. This module adds the next layer: whether the asset's trade area can actually support the underwritten retail revenue. It estimates retail demand capture, leakage risk, necessity spend depth, competing-node pressure, and whether the deal is drawing from a defensible local trade area or relying on fragile discretionary traffic. Auto-applicable for Retail and Mixed-Use deals plus any deal with retail SF, retail rent, or retail cues in tenant labels, deal name, or notes. Non-retail deals without those cues return not-applicable. Trade-area radius computed from metro geography tier multiplied by a format multiplier. Six metro tiers seeded: urban infill (Manhattan, Brooklyn, Queens, San Francisco, downtown Boston, Chicago Loop / Near North, Seattle downtown) with 1.0-mile baseline, household depth 86, necessity 82, discretionary 80, elevated competing-node base; university town (Ithaca, Ann Arbor, Madison, State College, Chapel Hill, Boulder, Gainesville, College Station, Bloomington, Athens, Lawrence) with 2.5-mile baseline, household depth 68, necessity 74, discretionary 56, low competing base; dense suburban (Austin, Dallas, Plano, Frisco, Atlanta, Alpharetta, Nashville, Phoenix, Scottsdale, Miami, Fort Lauderdale, Orlando) with 3.5-mile baseline, household depth 74; suburban strip / power center (Denver, Aurora, Portland, Hillsboro, Charlotte, Raleigh, Durham, Columbus, Salt Lake) with 4.5-mile baseline; regional retail hub (King of Prussia, Paramus, Garden State Plaza, mall, power center cues) with 12-mile baseline and high competing-node base; tertiary fallback with 5-mile baseline. Format multipliers: grocery 0.7x for tight local demand, service 0.6x for hyper-local, neighborhood strip 0.8x, restaurant 1.1x, apparel and discretionary 1.4x for regional pull, mixed 1.0x. Capture rates seeded per format (necessity capture midpoints: grocery 70%, service 75%, neighborhood 60%, restaurant 50%, apparel 22%, mixed 52%; discretionary capture midpoints: grocery 40%, service 30%, neighborhood 45%, restaurant 55%, apparel 55%, mixed 50%) and adjusted by household depth factor (capped at 0.6-1.3) and competing-node pressure (capture multiplied by 0.85-0.92 when pressure is elevated or high). Competing-node pressure adjusted by supply pipeline (heavy or moderate oversupply elevates; constrained de-escalates) and by regional retail hub tier (elevates one tier). Leakage risk classification: low when blended capture is 65% or higher and competing pressure is low; moderate at 55%-plus with low or moderate pressure; elevated at 40%-plus; high below 40%. Seven weighted drivers: demographic income and household depth 20% (market baseline plus demographic overlay population growth and median income bumps), necessity retail support 20% (capture rate scaled by necessity-format flag), competing-node and supply pressure 15% (tier-driven with supply pipeline blending), rent comp affordability versus trade-area sales proxy 15% (below-market 76, in-band 64, above-market 36, no-comp 55), retail anchor durability read-through 15% (necessity-anchored 82, durable-neighborhood 66, cyclical 44, fragility 26), exit liquidity and buyer depth 10% (transaction liquidity band-driven), public retail sector read-through 5% (REIT positioning band-driven). Bands: dominant-local-capture (score 78-plus with low or moderate leakage risk), defensible-neighborhood-capture (62-77), competitive-trade-area (45-61), leakage-risk (less than 45), not-assessable. Memo surface: verdict banner with band, score, market, and format; four-stat headline (trade-area radius miles, necessity capture percentage, discretionary capture percentage, competing-node pressure); three-cell strip (leakage risk, demand support, competing-node pressure); seven-driver weighted score table; underwriting actions tied to household depth, necessity penetration, competing-node pressure, rent-vs-sales bar, anchor fragility, exit liquidity, and leakage severity; deal implications by band. Module references upstream retail anchor durability when available so the trade-area and tenant-mix reads are mutually consistent. Auto-skip when purchase price or hold period are missing. Retail Trade Area Leakage and Capture Analysis is a deterministic trade-area proxy. It is not a sales forecast, an appraisal, a traffic study, or a tenant-credit opinion.
Retail real estate is not one asset class. A grocery-anchored neighborhood center carries different risk than an apparel-heavy power center, a restaurant-led food hall, or a service-retail strip. Institutional buyers underwrite each retail format on a different stack of signals: anchor quality and credit, necessity orientation, co-tenancy risk, small-shop fragility, lease rollover exposure, and the durability of consumer demand for the format. This module auto-detects applicability for retail and mixed-use deals with commercial SF or retail-rent fields, plus any deal with retail cues in tenant labels, deal name, address, or notes. Non-retail deals without those cues return not-applicable and the memo section does not render. Format classification: grocery-anchored (grocery, supermarket, market, grocer, pharmacy, drugstore cues), service retail (salon, dental, medical retail, fitness, daycare, bank, cleaners, urgent care, nail), restaurant-heavy (restaurant, cafe, bar, QSR, dining, food hall, kitchen, eatery, tavern, bistro), apparel and discretionary (apparel, boutique, fashion, clothing, furniture, electronics, discretionary), neighborhood strip (strip center, strip mall, neighborhood center, inline retail, local services), mixed retail when cues exist but no single format dominates. Format priors: grocery-anchored carries the most durable institutional retail profile with anchor quality 82, necessity 88, low co-tenancy and small-shop risk; service retail carries direct consumer relationships that resist e-commerce displacement with anchor 64, necessity 72, moderate risk tiers; restaurant-heavy carries higher sales volatility, fit-out and TI exposure, and operator-quality variance with anchor 50, necessity 45, elevated risk tiers; apparel and discretionary carries direct e-commerce substitution risk and cyclical consumer-spend exposure with anchor 44, necessity 32, elevated risk tiers; neighborhood strip carries mixed exposure with anchor 60, necessity 65, moderate risk tiers; mixed retail reflects the weighted blend with anchor 56, necessity 58. Seven weighted drivers: anchor quality and credit proxy 25% (format baseline plus tenant concentration largest-tenant share adjustment; concentration above 40% rent share is penalized for non-anchored formats and rewarded for grocery and service), necessity orientation 20% (format baseline), tenant diversification and HHI 15% (industry HHI band: 82 diversified, 62 moderate, 38 highly concentrated, 24 single-sector; tenant concentration risk-tier adjustment), demographic and traffic support 15% (population growth and median income bumps), rent comp positioning and occupancy cushion 10% (below-market 72, in-band 64, above-market 38, no-comp 50), supply and exit liquidity 10% (supply pipeline overlay blended with transaction liquidity tier), public retail REIT read-through 5% (REIT sector overlay positioning: 78 premium-justified, 60 in-line, 36 underpriced). Risk tier outputs adjusted by upstream signals: co-tenancy risk elevated by single-sector or highly-concentrated industry HHI; small-shop fragility elevated by high tenant concentration risk or above-market rent positioning; rollover sensitivity elevated when max annual rollover exceeds 40% of total rent. Bands: necessity-anchored (score 78-plus with necessity-oriented format like grocery, service, or strong neighborhood strip), durable-neighborhood-retail (62-77), cyclical-tenant-mix (45-61), anchor-fragility (less than 45), not-assessable. Memo surface: verdict banner with band, score, and format; retail format read-through card with anchor quality, necessity orientation, and small-shop fragility one-liner; four-cell metric strip (anchor quality, necessity orientation, co-tenancy risk, rollover sensitivity); seven-driver weighted score table; underwriting actions (diligence anchor tenant credit and lease term, map small-shop sales velocity and foot traffic, stress occupancy under single-industry shock, confirm trade-area fundamentals, stress re-leasing economics when rent is above market, identify institutional retail buyer pool when liquidity thin, reserve for rollover TI and downtime, stress against 200 bp consumer-spend slowdown for cyclical formats); deal implications by band. Module never names specific tenant brands unless they appear in user-provided tenant labels. Auto-skip when purchase price or hold period are missing. Retail anchor durability tracker is a deterministic tenant-mix overlay. It is not a tenant-credit rating, a leasing forecast, a broker opinion, or a sales forecast.
Phase 3 begins: live market data overlay (FRED Treasury / SOFR / CPI / inflation expectations) + 18 more institutional analytics. Live macro frame, deal-vs-market positioning, deterministic engine guarantee preserved (Cherry Street regression byte-identical with seeded fallbacks). 90 modules shipped today.
Capex is often modeled as a reserve line, but institutional committees care about whether each future dollar of capex is actually earning its keep. This module converts forward capex obligations into a yield curve by year and category, then compares the spend against incremental NOI and value creation. The practical IC question: are we funding value creation or just feeding the asset? Six capex categories tracked: reserves (recurring replacement, modeled per proforma reserves line or institutional baseline 2% of EGI / 25 bps of price minimum), leasing (TI/LC on lease commencement, modeled from proforma leasing capex), climate (jurisdiction-mandate retrofit per ClimateMitigationCapex, spread over hold), insurance (mitigation budget triggered when InsuranceLoad above-band), compliance (annual 0.10% of purchase price baseline, 0.25% for jurisdictions with material climate mandate), capital-improvements (value-add improvement budget ~1.5% of purchase price front-loaded over lease-up years). Implied capex yield = total incremental NOI over hold divided by total capex spend. Per-year curve includes total capex, six-category breakdown, incremental NOI, implied yield, cumulative capex, cumulative NOI, and phase label (funding / transition / harvest / steady). Payback year computed as first year cumulative incremental NOI exceeds cumulative capex. Peak funding year identified. Bands: value-creating (≥ 78, yield clears 8% unlevered hurdle and payback inside hold), self-funding (63-77, supportable but not alpha), maintenance-drag (48-62, protects rather than creates value), capex-burdened (< 48, absorbs return), not-assessable. Six drivers weighted: implied yield vs hurdle 30%, payback timing 20%, reserve adequacy + funding smoothness 15%, climate + insurance retrofit burden 15%, stabilization + leasing execution 10%, construction cost inflation 10%. Memo surface: inline SVG bar chart (annual capex) with implied yield line overlay and phase labels; category mix table; year-by-year curve with phase progression; per-driver status table; underwriting actions tied to band. Implied capex yield curve is a deterministic underwriting overlay. It is not an engineering report or construction budget.
Cap rates rarely move in a straight line. They compress, stall, reset, and mean-revert across rate cycles, liquidity windows, sector sentiment, and vintage-year entry points. The IC memo has forward cap forecasts and vintage backtests; this module synthesizes those into a readable pattern diagnosis. Six pattern types: stable-range (entry and exit caps within 75 bps of each other and within 50 bps of long-run anchor), compression-wave (modeled exit cap materially below anchor and cap comps imply below-anchor pricing), expansion-wave (modeled exit above entry by 50+ bps and above anchor), mean-reversion-channel (path trends toward anchor, moderate amplitude, no liquidity stress), rate-shock-reset (Treasury spread pressure plus negative leverage plus widening), liquidity-dislocation (transaction liquidity weak or vintage downside elevated, with cap expansion above 100 bps). Wave phase: early / mid / late / reset / not-assessable. Seeded mid-2026 long-run anchors per Codex spec: Multifamily 5.25%, Industrial 5.75%, Retail 6.25%, Office 7.00%, Hotel 8.00%, Mixed-Use 6.00%, Data Center 6.25%, Life Sciences 6.50%, BTR/SFR 5.75%. Scoring weights: distance from anchor 25%, direction + amplitude 20%, Treasury spread + negative leverage 15%, cap comps support 15%, vintage-year downside read-through 15%, transaction liquidity 10%. Bands: constructive-reset (≥ 78, reset looks priced and path is anchored), range-bound-watch (63-77, visible but contained), late-cycle-pressure (48-62, pricing relies on late-cycle assumptions), dislocation-risk (< 48, reset or liquidity risk), not-assessable. Memo surface: pattern diagnosis card, three-column cap snapshot (entry / exit / anchor), inline SVG forecast path with confidence band and anchor reference, per-driver status table with contribution and interpretation, underwriting actions tied to pattern, deal implications. Confidence score derived from how many drivers are negative or watch. Path rows include year, forecast cap, lower / upper confidence bands, and phase label (entry / ramp / approach / exit). Cap rate wave pattern detector is a deterministic cycle-pattern overlay built from seeded institutional anchors and upstream engine signals. It is not a market forecast or valuation opinion.
META synthesis across seven capital-market drivers into one capital-structure recommendation. The institutional question is no longer "what does this deal support?" but "what capital structure should a sponsor actually pursue in this rate, liquidity, and cycle environment?" Drivers weighted: debt sizing + lender risk 25% (debt sizing headroom vs binding constraint, lender risk band AAA-equivalent to Distressed), DSCR + debt yield + coverage 20% (min DSCR over hold, Y1 debt yield against 8% floor), refinance rate risk 15% (max bps shift the deal tolerates while clearing 1.25x DSCR), bank lending + CMBS conditions 15% (lending conditions band + CMBS spread positioning), Treasury spread + negative leverage 10% (entry cap vs senior rate, stabilized spread vs 10Y), existing capital stack recommender 10% (LTV guidance + structure label), foreign capital appetite + exit liquidity 5%. Output: recommended senior LTV range (asset-class adjusted: Office -5pp, Hotel -3pp, MF/Industrial +3pp), total LTV ceiling with mezz allowance (10pp acceptable when institutional-ready + DSCR >= 1.30, 5pp when bankable + DSCR >= 1.20, 0pp otherwise), fixed-versus-floating preference (fixed-preferred when rates elevated or DSCR thin, floating-acceptable when lease-up or NOI growth provides take-out, floating-only-with-cap when modest cushion, avoid-floating when refi failure or thin cushion), mezz tolerance (none / limited / selective / acceptable), preferred term (5/7/10 years based on refi cushion), covenant posture (standard / tightened / defensive), execution route (relationship-bank / life-company / debt-fund / cmbs / agency-or-bank / mixed-market). MF routes to agency-or-bank; institutional-ready Office/Retail/Industrial route to life-company; selective transition deals route to debt fund; CMBS only when spread + collateral signals supportive. Bands: institutional-ready (≥ 78, clear senior LTV, standard covenants), bankable-with-structure (63-77, tighter structure required), selective-lender-fit (48-62, lender-type dependent), capital-stack-friction (< 48, reduce leverage), not-assessable. Memo surface: per-driver status with contribution and interpretation; structure recommendations; lender conversation points; deal implications. Module never names specific lenders as providers. Capital stack optimizer is a deterministic structure recommendation overlay. It is not a financing commitment, lender quote, or securities recommendation.
Country-level granularity on foreign capital appetite, layered onto the market-level Cross-Border Capital signal. Cross-border capital can materially change exit liquidity, pricing depth, and buyer behavior; this module breaks the appetite down by capital pool of origin. Twelve seeded country-level capital pools spanning North America, Asia, Middle East, Europe, and Pacific: Canada (mixed pension + insurance, MF / Industrial / Mixed-Use favored, low friction, low hedge), Singapore (sovereign, Logistics / Data Centers / gateway trophy / operating platforms, mega-check), UAE (sovereign, trophy / Hotel / Mixed-Use / Logistics, AED-USD peg means zero hedge), Norway NBIM (sovereign + pension-style, core income / sustainability-aligned), Japan (insurance + bank, core income with currency-hedged stability, high yen hedge pressure), South Korea NPS (pension + insurance, Logistics / office recapitalizations / income durability), Germany (insurance + pension, core / sustainability-aligned / EU-friendly governance), United Kingdom (institutional + private, gateway-market mid-market), Qatar QIA (sovereign, trophy / Mixed-Use / hospitality / durable income), Saudi PIF (sovereign + private, growing US allocation in Logistics / hospitality / platform-scale, moderate CFIUS friction), Australia superannuation (income assets / platform strategies, moderate AUD hedge), China (private + institutional, materially higher policy + outbound-capital friction in current regime). Per-country signals: asset-class fit modifier (-20 to +30), check-size fit modifier (-15 to +10), regulatory friction (low / moderate / high CFIUS-sensitivity), currency hedge pressure (low / moderate / high). Scoring weights: asset-class fit 35%, check-size fit 20%, regulatory friction 15%, currency hedge 10%, cross-border tailwind from upstream 10%, exit liquidity Treasury-spread bonus 10%. Bands: global-capital-tailwind (score ≥ 78, three or more strong/moderate fits), selective-cross-border-depth (62-77, two or more credible fits), domestic-led-market (45-61, foreign appetite exists but not central to exit), cross-border-friction (< 45 or friction risks dominate), not-assessable. Memo surface: primary capital origins table with appetite score + fit + friction + hedge + check; watchlist origins (high-friction / constrained); buyer pool read-through narrative; currency and policy risks; underwriting actions tied to band; deal implications. Country-level foreign capital appetite uses deterministic seeded proxies, not a live fund-flow database or buyer list. Module never names specific institutions as bidders.
Frames whether the current deal's entry environment looks favorable, neutral, or adverse against seeded historical vintage cohorts. Institutional investors evaluate real estate through vintage-year discipline: year of entry matters because rate regime, cap-Treasury spread, liquidity, inflation, and capital availability shape forward returns. Eight seeded historical cohorts span 2003 through 2026: 2003-2005 (low-rate expansion, +10.5% median unlevered return, 15% downside frequency, 275 bps typical Treasury spread); 2006-2007 (peak liquidity, tight spreads, +4.0% median, 55% downside, 75 bps spread — the weakest cohort and the warning analog); 2009-2011 (distressed reset, +18.0% median, 8% downside, 500 bps spread — the opportunistic vintage); 2013-2015 (recovery expansion, +12.0%, 12% downside, 350 bps spread); 2018-2019 (mature cycle, +9.0%, 25% downside, 200 bps spread); 2020-2021 (emergency-rate compression, +14.0% nominal, 35% downside, 90 bps spread — the reset-risk setup); 2022-2024 (rate shock reset, +7.0%, 25% downside, 175 bps); 2025-2026 (higher-for-longer normalization, +10.0%, 20% downside, 225 bps spread). Deterministic similarity scoring across cap rate direction, liquidity, macro regime, Treasury spread, and asset-class dispersion modifier (Industrial / Data Center favored in 2020-2021 and 2025-2026; Office penalized 2020-2024). Vintage score 0-100 from weighted blend of top-3 cohort matches plus Treasury spread sufficiency adjustment (+/- 20) plus cap persistence band adjustment (+/- 15). Bands: favorable-vintage (≥ 75), selective-vintage (60-74), neutral-vintage (45-59), challenged-vintage (< 45), not-assessable. Memo surface: closest 3 cohorts with similarity, returns, downside frequency, lesson; current entry profile card with Treasury spread + cap persistence + liquidity + inflation + debt market signals; underwriting actions tied to band; deal implications. All cohort returns and downside frequencies are institutional proxy assumptions, not actual fund performance data.
Monte Carlo, Deal Strength composite score, sensitivity curves, break-even cushions, risk-adjusted returns, tenant concentration, hotel ops overlay, GP coinvest sweep, debt sizing optimizer, NOI decomp, Argus NOI parser, and 15 more analytics. The day the memo went from 'pro forma + waterfall' to 'institutional IC packet.'
New IC memo section (fires on rent-roll deals only): surfaces largest tenant's % of total Y1 rent, top 3 tenants' combined %, and the maximum single-year rollover concentration. Risk tier (low / moderate / high) maps to institutional norms (>50% on either single-tenant share or single-year rollover = high). Pine Tower's 4-tenant office example produces a useful moderate-tier read: Apex Capital carries the biggest rent share and the bunched lease start years concentrate rollover in years 4-8.
New IC memo section: Y1 OpEx % of EGI compared to the typical institutional band for the property type (Multifamily 40-50%, Mixed-Use 35-50%, Office 30-45%, Retail 25-40%, Hotel 60-78%, Industrial 12-25%). Flags in-band, above-band, or below-band with a plain-English interpretation. Below-band can mean efficient operations or under-budgeted; above-band means padding or operationally-heavy management. Quick sanity check that the validation logic doesn't catch on its own.
New IC memo section: Sharpe-like ratio = (project IRR - 5% risk-free) / Monte Carlo stdev, plus raw IRR/stdev and a downside ratio (IRR / |P10 - IRR|). Cherry Street prints Sharpe 3.86 ('Strong'), IRR/stdev 5.73, downside ratio 2.67 — all institutional indicators of a deal with meaningful excess return per unit of variance. Standard portfolio analytics applied to the Monte Carlo distribution; complements the headline IRR with a risk-adjusted view that LPs running Sharpe-aware allocation use.
New IC memo section: measures the year-over-year volatility of operating CF (NOI - leasing capex) via coefficient of variation, mapped to a 0-100 stability score with qualitative band (Very Stable / Stable / Variable / Lumpy). Cherry Street scores 100/100 'Very Stable' — smooth compounding of rent + expenses with no rent-roll lumpiness. Useful framing for LP fit: insurance / pension capital favors high stability, opportunistic LPs accept Lumpy in exchange for upside.
New IC memo section: entry / stabilized / exit caps + spread (exit - entry) with the framing classified in plain English (aggressive / neutral / conservative / very conservative). Cherry Street's -49 bps spread sits right at the neutral / aggressive cusp. Tells the IC at a glance whether the appreciation thesis lives on cap compression (aggressive), rent growth alone (neutral), or has a defensive cushion for rate hardening (conservative).
Methodology, examples, source-quote audit trail
- marketing
Thirteen-section walkthrough of every formula the engine uses to compute the IC memo. Cherry Street worked example end-to-end. Table of contents with deep-link anchors.
Each AI-extracted value pairs with a verbatim quote from the source text, server-validated to be a literal substring. Click any quote to highlight the span in the textarea. Direct answer to 'generic data back, unauditable.'
Splits Project IRR into operating yield (avg NOI / cost), asset appreciation (annualized sale-value growth), and leverage premium (equity IRR minus unlevered IRR). Surfaces WHERE the return comes from across tool + memo + compare + Excel.
Eight institutional threshold tests with pass/miss status pills: Project IRR ≥ 15%, Min DSCR ≥ 1.0x (critical) plus institutional 1.2x, LTV ≤ 75%, Yield on Cost ≥ 6%, positive leverage Y1, exit ≥ entry, hold ≤ term (advisory). Critical highlighted; verdict is exactly the conjunction.
Debt Yield (Y1), Break-Even Occupancy, Occupancy Cushion, Refinance Test at exit. Surfaces the lender's view of the deal — distinct from equity returns. Color-coded passes / misses.