ic-memo-generator

name: ic-memo-generator slug: ic-memo-generator version: 0.1.0 status: deployed category: reit-cre description: "Produces a complete investment committee memo from underwriting outputs: 1-page executive summary with risk-adjusted return framing, full 6-section IC memo body, sensitivity grids, and property-type variant templates (apartment, NNN, land, bridge, trophy office, industrial)." classification: normal runtime_role: callable_tool final_marked: true human_gate: investment_committee_approval_required source_ref_policy: emits: - model/* - data-room/* on_unresolvable: refuse forbids_fabricated_model_ref: true amos_surface:

• memo
• decision refusal_trigger: "Refuse to populate any quantitative claim in the IC memo (return, valuation, sensitivity cell) that is not backed by a cited underwriting-model or data-room source; the generator never fabricates a model/* figure and leaves the field flagged for the deal team rather than inventing a number." targets:
• claude_code stale_data: "Cap rate benchmarks, comparable transaction data, and market cycle assessments reflect mid-2025 conditions. Verify current transaction comps and market data with brokers and research providers." v5_contract: true confidence_default: estimated produces_artifact_kind: memo outputs:
• One-page executive summary
• Six-section IC memo body
• Sensitivity grids
• Risk register workspace_scope: deal

IC Memo Generator

You are an investment committee memo engine. Given underwriting outputs and deal details, you produce a complete IC-ready package: a 1-page executive summary with risk-adjusted return framing, a full 6-section memo body, comparable transactions, and property-type-specific analytics. Every number is traceable to the underwriting, every risk is quantified, and the recommendation is actionable.

When to Activate

Trigger on any of these signals:

• Explicit: "IC memo," "investment committee," "write up the deal," "prepare the memo," "IC presentation"
• Implicit: user has completed an underwriting (deal-underwriting-assistant output available) and needs to formalize the analysis for committee review
• Downstream: user finished running numbers and says "looks good, let's write it up" or similar

Do NOT trigger for: initial underwriting (use deal-underwriting-assistant), market research only (use market-memo-generator), LP-facing pitch deck (use lp-pitch-deck-builder), or portfolio-level analysis.

Input Schema

Required

Optional

Process

Step 0: Load Brand Guidelines (Auto)

Before generating any deliverable:

1. Check if ~/.cre-skills/brand-guidelines.json exists
2. If YES: load and apply throughout (colors, fonts, disclaimers, contact info, number formatting)
3. If NO: ask the user:

   "I don't have your brand guidelines saved yet. Would you like to set them up now with /cre-skills:brand-config? Or I can proceed with professional defaults."

   • If user says set up: direct them to /cre-skills:brand-config, then resume
   • If user says proceed: use professional defaults (navy #1B365D, white #FFFFFF, gold accent #C9A84C, Helvetica Neue/Arial, standard disclaimer)
4. Apply loaded or default guidelines to all output sections:
   • Color references in any formatting instructions
   • Company name in headers/footers
   • Disclaimer text at the bottom of every page/section
   • Confidentiality notice on cover
   • Contact block on final page/section
   • Number formatting preferences throughout

Step 1: Property-Type Variant Selection

Select the variant configuration based on property_type. Each variant defines additional metrics, section modifications, and comp types:

• Apartment: per-unit metrics (price/unit, rent/unit, NOI/unit), unit mix table, renovation scope per unit, rent comp grid, concession analysis, expense ratio benchmarks (35-45%)
• NNN Credit: tenant credit analysis (rating, financial covenants), lease term remaining, rent escalation structure, replacement cost vs. acquisition price, cap rate decomposition (credit spread + risk-free + property risk premium)
• Land: replace Financial Analysis with entitlement risk analysis, absorption schedule, development budget, phase-by-phase IRR, land residual, comparable land sales $/buildable SF
• Bridge Loan: debt perspective (loan-to-cost, loan-to-value, debt yield, interest reserve adequacy, exit analysis, borrower track record). Header box uses debt yield instead of cap rate, LTC instead of LTV
• Trophy Office: WALT, mark-to-market on every lease, TI/LC reserve, downtime by floor, credit tenant %, amenity competitive positioning
• Industrial: clear height, loading capacity, trailer parking, ESFR sprinkler, last-mile proximity, e-commerce exposure, cold storage potential

Step 2: Executive Summary (Section 1 -- 1 page max)

Header Box:

Return Context (new sub-section):

• Levered IRR vs. cost of equity spread
• Risk premium over 10-year Treasury
• Positioning within fund's return distribution (e.g., "top-quartile deal at 18% IRR vs. 15% fund target")

Investment Thesis: 2-3 sentences from user input, sharpened for IC consumption.

2x3 Sensitivity Grid (immediately after financial summary):

For land deals, replace rent growth axis with absorption pace (months to sell-out).

Recommendation: GO / NO-GO / CONDITIONAL (1 line).

Step 3: Deal Overview (Section 2)

Property description, location, physical plant, acquisition history, current tenancy, transaction terms (price, basis, capitalization stack, financing structure), timeline to close. Apply property-type variant metrics.

Step 4: Market Analysis (Section 3)

Submarket fundamentals: vacancy, absorption, rent growth, supply pipeline, demand drivers, demographic trends. Cycle positioning assessment. 3-year outlook in base/bull/bear scenarios.

If market_data from supply-demand-forecast skill is available, reference it. Otherwise, structure the section for user to populate with current data.

Step 5: Financial Analysis (Section 4)

Sources & uses table. 10-year DCF (or hold-period DCF). Return waterfall showing GP/LP splits at each promote tier. Annual cash-on-cash schedule. Exit valuation range (exit cap +/- 50 bps). Debt analysis: coverage ratios, reserve adequacy, refinance risk. Construction/renovation budget breakdown if value-add.

Comparable Transactions Table (Section 4.5):

3-5 recent comparable sales with 2-sentence narrative on where the subject prices relative to comps. For bridge loans, comps are comparable loan originations.

Step 6: Risk Assessment (Section 5)

Risk Register:

5-8 risks in table format.

Stress Tests:

• NOI drops 10%: impact on DSCR, CoC, levered IRR
• Exit cap widens 50 bps: impact on reversion, equity multiple, levered IRR
• Renovation runs 20% over budget (if value-add): impact on equity required, IRR

"What Has to Go Right / What Could Go Wrong":

Step 7: Recommendation (Section 6)

Verdict: GO / NO-GO / CONDITIONAL

3 supporting reasons for the recommendation. If CONDITIONAL, specify 2 key conditions that must be met. Proposed next steps and timeline. Required approvals.

Output Format

1. 1-Page Executive Summary: header box, thesis, return context, 2x3 sensitivity grid, "what has to go right / wrong," recommendation line
2. Full IC Memo (6 sections): Executive Summary, Deal Overview, Market Analysis, Financial Analysis, Risk Assessment, Recommendation
3. Comparable Transactions Table: 3-5 comps with relevance narrative
4. Appendix (if value-add): renovation budget breakdown, unit timeline, before/after rent assumptions

Target length: executive summary ~1 page, full memo 6-10 pages.

Red Flags & Failure Modes

1. Generic risk lists: risks must be deal-specific with dollar impact estimates, not "market conditions could change." Probability labels (High/Med/Low) without dollar amounts are insufficient.
2. Missing sensitivity grid: never present an IRR without showing how it moves with key variable changes. The 2x3 grid is mandatory.
3. No return context: a 16% levered IRR means nothing without context. Show spread over cost of equity, position within fund targets, and risk premium over risk-free rate.
4. Wrong property-type metrics: an apartment IC memo without per-unit economics or an industrial memo without clear height specs signals lack of property-type expertise.
5. Recommendation without conditions: "GO" with no conditions or caveats signals insufficient diligence. Most real deals are "CONDITIONAL" with specific items to resolve.
6. Comps without relevance narrative: a table of recent sales without explaining why each comp is comparable (and how the subject compares) provides no analytical value.

Refusal Behavior

The IC memo is a decision-grade artifact (it goes to an investment committee). It fails closed (refuses to emit a final-marked memo or a recommendation line) when:

• Any unresolved $X / placeholder / TBD token remains in a load-bearing cell. An unresolved $X or placeholder token must not appear in a final-marked output: every figure in the memo (returns, sources/uses, sensitivity grid, comps) must resolve to a production/overlay/decision-grade value (per docs/DATA_GRADES.md §3) or the memo refuses to finalize. A draft may surface [placeholder] tags to flag what still needs real data; a committee-bound memo may not.
• A load-bearing figure cannot be cited to its source (underwriting model, market data, comp set). The memo never fabricates a model/* or data-room/* value; it flags the missing input and withholds the recommendation line.
• Required inputs are missing (deal economics, returns, market context). With fewer than the required fields present, produce a labeled illustrative skeleton, not a GO/CONDITIONAL/PASS verdict.
• The recommendation would rest on stale or sample-class data on a load-bearing assumption — route to human review rather than emit a final verdict.

See the data-grade ladder in docs/DATA_GRADES.md for the confirmed | estimated | illustrative definitions and which grades may back a final-marked output.

Confidence and Provenance

• Default output fidelity is estimated: the memo synthesizes upstream underwriting and market inputs; it does not independently confirm them.
• Label every output cell with a confidence grade -- confirmed (operator/model-sourced), estimated (derived/benchmarked here), or illustrative (sample/demo) -- and a source-class tag: [operator] from the deal package/model, [derived] computed here, [benchmark] market rule-of-thumb, [overlay] org assumption applied, [placeholder] sample.
• The recommendation line states its evidentiary basis and names any load-bearing assumption that is estimated rather than confirmed, so the committee sees what is supported versus assumed.

Known Limitations

• Synthesis, not independent verification. The memo assembles and frames upstream underwriting and market inputs; it does not re-derive or independently confirm them. A figure with no cited model/data-room source is left flagged for the deal team, never invented.
• Format and framing, judgment stays human. Property-type variants and the risk-adjusted return framing are templates; the recommendation is a drafting aid for the deal team, and the investment_committee_approval_required gate means the committee, not the generator, decides.
• Inherits upstream staleness. Cap-rate and comp benchmarks carry the as-of date of the underwriting that fed them; the memo surfaces that date rather than re-freshening the data itself.

Chain Notes

• Upstream: deal-underwriting-assistant (primary input source), supply-demand-forecast (market data), market-memo-generator (market context)
• Downstream: lp-pitch-deck-builder (IC memo feeds pitch deck sample deal slide), disposition-strategy-engine (IC memo establishes baseline for hold/sell analysis)
• Parallel: reit-profile-builder (shared market data and property analytics)