managing-real-estate-fund-reporting

# Managing Real Estate Fund Reporting

Structures real estate fund reporting with property-level performance, valuation updates, and distribution analysis.

## When To Use

- Preparing quarterly or annual investor reports for open-end or closed-end real estate funds
- Calculating fund-level and property-level returns (gross/net IRR, equity multiple, cash-on-cash)
- Documenting NAV per unit/share with supporting valuation detail
- Summarizing distribution waterfalls, promote calculations, and LP/GP splits
- Reporting on portfolio composition, occupancy trends, and capital deployment status
- Producing REIT-specific metrics (FFO, AFFO, same-store NOI growth) for public or non-traded vehicles

## Inputs To Gather

- **Fund structure details**: fund name, vintage year, fund size, investment period status, vehicle type (open-end, closed-end, REIT)
- **Property-level financials**: rent rolls, operating statements (actual vs. budget), capital expenditure schedules, and debt summaries for each asset
- **Valuation data**: most recent third-party appraisals or internal valuations, cap rate assumptions, discount rate inputs, and comparable sale data
- **Capital account records**: contributions called, unfunded commitments, distributions paid (return of capital vs. income), and current LP/GP account balances
- **Waterfall terms**: preferred return hurdle(s), catch-up provisions, carried interest splits, clawback triggers from the LPA
- **Market data**: submarket vacancy rates, rent growth trends, transaction volume, and macroeconomic indicators relevant to asset class
- **Prior period reports**: previous quarter's NAV, return figures, and any restatements or methodology changes

## Workflow

1. **Validate source data** — Reconcile property-level operating statements to the general ledger. Confirm that appraisal dates are current (within reporting quarter). Cross-check capital account balances against the fund administrator's records. Flag any asset with stale valuation data as [VERIFY].

2. **Calculate property-level performance** — For each asset, compute:
   - Net Operating Income (NOI) actual vs. budget and vs. prior period
   - Occupancy rate (physical and economic)
   - Debt service coverage ratio and loan-to-value
   - Unrealized gain/loss based on current valuation vs. cost basis
   - Capital expenditure spend vs. approved budget

3. **Roll up fund-level metrics** — Aggregate property results into portfolio-level figures:
   - Gross and net asset value (NAV), with a bridge from prior-period NAV (contributions + appreciation + income − distributions − fees − depreciation)
   - Gross and net IRR (since inception and for the reporting period) [VERIFY calculation methodology against LPA]
   - Total value to paid-in capital (TVPI) and distributions to paid-in capital (DPI)
   - For REIT vehicles: FFO, AFFO, and same-store NOI growth

4. **Run distribution waterfall** — Apply the LPA waterfall to determine:
   - Preferred return accrual and whether the hurdle has been met
   - Catch-up allocation status
   - Carried interest earned (realized and unrealized)
   - Projected next distribution amount and composition (return of capital vs. gain vs. income)

5. **Draft narrative sections** — Write a portfolio overview covering:
   - Market conditions and their impact on fund strategy
   - Significant leasing events, dispositions, acquisitions, or refinancings during the period
   - Material risks: lease expirations, tenant credit concerns, floating-rate debt exposure, construction delays
   - Capital deployment pipeline and remaining dry powder

6. **Assemble the report** — Organize into standard sections: executive summary, portfolio summary table, individual property pages, financial statements, capital account statement, waterfall summary, and appendices (glossary, methodology notes).

## Output

A structured fund report containing:

- **Executive summary** with headline metrics (NAV, IRR, equity multiple, distributions paid)
- **Portfolio dashboard** showing each property's NOI, occupancy, valuation, and debt metrics in a comparative table
- **Individual property pages** with operating detail, tenancy schedule highlights, and valuation commentary
- **Capital account statement** showing LP/GP balances, contributions, distributions, and ending balances
- **Waterfall summary** with preferred return status, promote calculation, and projected next distribution
- **Market commentary** section tying macro and submarket trends to fund positioning
- **NAV bridge** reconciling beginning to ending NAV with each component identified

## Quality Checks

- Confirm NAV bridge balances — beginning NAV plus all components must equal ending NAV exactly
- Verify IRR and equity multiple calculations against an independent model or fund administrator output [VERIFY]
- Ensure property valuations are dated within the reporting period; flag any appraisal older than six months
- Check that waterfall calculations conform to the specific LPA terms — preferred return day-count convention, compounding frequency, and hurdle reset provisions vary by fund [VERIFY against LPA]
- Validate that REIT metrics (FFO/AFFO) follow NAREIT definitions if the fund reports under that standard [VERIFY]
- Confirm all distributions are correctly classified (return of capital, capital gains, ordinary income) for tax reporting consistency
- Cross-check that total fund-level NOI equals the sum of individual property NOIs after eliminations
- Review for consistent rounding, date references, and terminology across all sections