Composes executive-grade operating summaries for board, LP, lender, and internal
executive consumption. Synthesizes property, asset, and portfolio outputs into a
narrative-first document with attached KPI dashboard, covenant posture, watchlist
distribution, capex program, lease-up status, and forecast discipline. Every final
submission is gated. Never sends autonomously.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
Executive-level thresholds, board-packet templates, LP narrative tone, lender submission
formats, and investor-report layouts live in overlays. No financial thresholds, time
windows, or target bands live in skill prose.
Composes executive-grade operating summaries for board, LP, lender, and internal
executive consumption. Synthesizes property, asset, and portfolio outputs into a
narrative-first document with attached KPI dashboard, covenant posture, watchlist
distribution, capex program, lease-up status, and forecast discipline. Every final
submission is gated. Never sends autonomously.
Executive Operating Summary Generation
Workflow purpose
Produce the executive layer's operating summary: the document that leaves the operator-owner and goes to a board, an LP, a lender, or an internal executive audience. The summary is narrative-first, grounded in cited metrics, and carries the confidence and audit posture required at the top of the pyramid.
This pack is flagship-depth. It is the last stop before any final-marked submission leaves the org. Approval rows 14 (lender), 15 (investor), and 16 (board) live here. The workflow never sends and never signs.
Final-marked output MUST follow _core/executive_output_contract.md:
verdict-first block (recommendation, 3-bullet rationale, confidence,
materiality, next action), source-class labels on every numeric cell
([operator] / [derived] / [benchmark] / [overlay] /
[placeholder]), and refusal-artifact shape when a required reference
input is absent. See the worked example at
examples/ex01_executive_operating_summary_generation.md for the
canonical structure. Any [placeholder]-tagged cell blocks the
approval-request bundle (rows 14 / 15 / 16).
Decide the audience; load the overlay template. Audience determines tone, depth, required disclosures, and approval row.
Step 2. Inherit layered outputs.
From AM and portfolio workflows. Do not recompute. If the period requires a quarterly portfolio view and one is not closed, refuse to compose until closed.
Step 3. Narrative synthesis.
Compose narrative anchored to cited metrics. Structure per overlay template (typical: headline, operating performance, capital / capex, portfolio posture, risk, forward view).
Reference every claim to a metric slug.
Surface variance drivers.
Cite references with as_of_date and status.
Do not assert improvement or deterioration without a trend window.
Step 4. KPI dashboard compose.
Per template: same-store, market, watchlist, covenant, capex, lease-up, forecast accuracy.
Step 5. Covenant posture.
Loan-by-loan cushion view; trend trailing 3 and 6 months; any runway flag lit.
Step 6. Watchlist posture.
Distribution by color; top movers with drivers; any red asset has an explicit ownership-side plan.
Step 7. Capex and renovation program.
Portfolio-level capex_spend_vs_plan; renovation_yield_on_cost per program; any program off-plan has a plan reference.
Step 8. Lease-up status.
Any asset in lease-up; stabilization_pace_vs_plan.
Step 9. Forecast discipline.
Portfolio forecast_accuracy; bias direction if any; calibration commitment to next cycle.
Step 10. Risk surface-up.
Any fair-housing flag, compliance finding, safety pattern, regulatory exposure, or LP / lender relationship risk surfaced clearly (but without confidential detail in external packets; counsel leads sensitive disclosures).
Step 11. Forward view.
Overlay-defined horizon (3 / 6 / 12 months). What the org is watching, what could change, what decisions are coming up.
Step 12. Draft package assembly.
Board: board packet template. LP: investor narrative + financial statements + distribution commentary. Lender: compliance certificate + NOI normalization + covenant tests + narrative. Internal executive: condensed one-pager with dashboard.
Step 13. Approval routing.
Row 14 for lender submissions.
Row 15 for investor / LP submissions.
Row 16 for board submissions.
Internal executive summaries are draft_for_review but not always gated; overlay governs.
The workflow never releases a submission marked final without an approved row.
Step 14. Fair-housing / compliance echo.
Any child-workflow fair-housing flag surfaced. Detail is counsel-led; workflow does not author public-facing FHA / compliance language.
Step 15. Confidence banner.
Every reference cited with as_of_date and status. Board and LP packets carry a prominent confidence section with source freshness notes.
Headline. Portfolio operating within plan; same-store within overlay band; watchlist distribution acceptable; one asset on refi runway.
Operating performance. Same-store NOI growth within band; noi_margin stable; blended_lease_trade_out within band; economic_occupancy within band.
Capital / capex. Portfolio capex_spend_vs_plan within band; renovation_yield_on_cost at or above underwriting on completed units.
Portfolio posture. Concentration within fund mandate. Watchlist distribution with top two movers explained.
Risk. Covenant cushion adequate across loans; one loan on refi runway with plan. No fair-housing or compliance findings this quarter (echoed from child workflows).
Approvals.approval_request row 16 opened; pending board final submission.
Confidence banner.watchlist_scoring@2026-03-31 (starter), same_store_set@2026-03-31 (starter), board_packet_template@2026-03-31 (starter). External-use notation for any sample-tagged reference.
