Investors

Builds a complete, audit-ready funds flow memo for CRE acquisition closings — covering sources and uses, prorations (taxes, rent, CAM), security deposit transfer, existing debt payoff, closing cost allocation, and a wire schedule. Handles all-cash, single-loan, and multi-tranche structures; supports 1031 exchange proceeds. Outputs a settlement statement that balances to the dollar with all buyer and seller credits reconciled.

Models Section 704(b) tax allocations for real estate partnerships and JV structures — from formation through disposition. Builds annual capital account tables, runs minimum gain chargeback and QIO mechanics, reconciles tax vs. economic distributions, and flags provisions requiring counsel review. Also includes a REIT compliance testing module for income, asset, distribution, and prohibited transaction tests. Best used alongside (not as a substitute for) a qualified tax attorney.

Builds complete, structured data request packages for LPs to send to GPs at every stage of the relationship — initial due diligence, quarterly monitoring, annual review, and re-up evaluation. Output includes an itemized request table (with format, benchmark, and red flag trigger per item), a ready-to-send cover letter, a response tracking template, and an ILPA compliance gap analysis. Use it when preparing a new GP commitment, formalizing a monitoring framework, or structuring a re-up data request.

Produces complete quarterly LP update letters for CRE funds and individual assets. Covers executive summary, per-asset NOI vs. plan, NAV methodology with cap rate sensitivity, distribution reconciliation, and an optional returns-education appendix for retail or mixed-sophistication LPs. Use it at quarter-end when you need a formatted, LP-ready letter rather than a raw data dump — works in portfolio mode (multi-asset attribution) or deal-level mode (thesis tracking against original underwriting).

Builds full LP fundraising materials for CRE fund raises: a 16-slide pitch deck with slide-by-slide content, GIPS-consistent track record tables, and a worked fee waterfall, plus an optional investor objection library with scripted responses segmented by investor type. Designed for fund managers preparing for LP meetings or responding to LP feedback on an existing deck.

Drafts complete board approval memos for infrastructure projects, land acquisitions, and major capital expenditures. Produces the full decision package: executive summary, financial impact with NPV/IRR, multi-level risk assessment, formal board resolution language, and compliance checklist. Reach for this skill when preparing any item that requires formal board authorization, ratification, or delegation of authority.

Guides CRE syndicators through the full Reg D compliance lifecycle: choosing between 506(b) and 506(c), designing accredited investor verification processes, preparing and filing Form D, meeting state blue sky notice requirements in all 50 states, and reviewing PPM disclosure adequacy. Outputs include a filing timeline, state-by-state compliance matrix, pre-existing relationship documentation framework, and a violation risk assessment. Reach for this skill when structuring a capital raise, preparing for a first close, or auditing an existing offering for compliance gaps.