Operational Stream
Component 5: Equity Returns (Read-Only)
Component 5 is a read-only analytical view that summarizes the equity investor's returns based on the financing structure configured in Component 4. All metrics are automatically calculated from the post-financing cash flows — no manual inputs are required or allowed on this page.
operational.financingMetrics (Component 4 Financing Preview). To change any equity return metric, adjust the financing parameters in Component 4.Overview
After configuring your financing structure in Component 4, Component 5 provides a clear, visual summary of what the equity investor can expect in terms of returns, payback timing, and distribution priority. The page is organized into four tabs, each focusing on a different dimension of equity performance.
Key Metrics at a Glance
Equity IRR
12.18%
Annualized
Equity Multiple
4.45x
Total Distributions ÷ Total Invested
Equity Payback
M162
Month of full recovery
Tab-by-Tab Walkthrough
Tab 1: Summary
The Summary tab provides a high-level overview of the six key equity return metrics in a clean grid layout, plus two visual charts showing equity multiple and cumulative recovery.
Total Equity Invested
The sum of all equity capital deployed into the project, including both land equity(if "Use Land as Equity" is enabled in Component 4) and cash injections (the gap-fill equity required to keep the project solvent month-by-month).
Total Distributions
The cumulative cash returned to equity investors over the entire hold period, including operating cash flows and the terminal exit proceeds at the end of the hold period.
Equity IRR (Annualized)
The Internal Rate of Return on equity, calculated from the monthly equity cash flow series (negative for injections, positive for distributions). This is the most important metric for equity investors — it represents the annualized return on every dollar of equity invested.
Equity Multiple
Also known as the "Money-on-Money" (MoM) multiple. Calculated as: Total Distributions ÷ Total Equity Invested. A 4.45x multiple means the investor receives 4.45 times their original investment over the hold period.
Equity Payback (Month)
The month in which cumulative equity distributions equal or exceed cumulative equity invested. This is the "break-even" point for the equity investor. In the example, payback occurs at M162 (the exit month), meaning the investor recovers their full investment only at exit.
Preference Shares Amount
If preference shares (mezzanine equity) were configured in Component 4, the amount is displayed here along with the target return rate. If not configured, this shows "—".
Tab 2: Multiple (Tranche Breakdown)
The Multiple tab breaks down the equity investment and returns by tranche, showing how much was invested and returned for each capital source separately.
Land Equity
Shows the land value contributed as equity (if enabled) and the portion of total distributions attributable to the land tranche. Displayed as horizontal bar charts comparing Invested vs Returned.
Cash Equity
Shows the cumulative cash injections (gap-fill equity) and the portion of distributions attributable to the cash tranche. This is typically the smaller tranche when land is used as equity.
Total Equity (Blended)
The combined view of all equity tranches, showing the overall invested vs returned bars and the resulting blended equity multiple.
Tab 3: Payback Analysis
The Payback tab visualizes the cumulative equity recovery over time, showing exactly when the investor recovers their initial investment.
Cumulative Recovery Chart
A line chart showing the cumulative equity position month-by-month. The line starts negative (representing the initial investment) and trends upward as distributions are received. The point where the line crosses zero is the payback month.
Payback Month
Displayed prominently (e.g., M162). This is the first month where cumulative distributions ≥ cumulative invested. For hold assets with exit at the end of the hold period, payback typically occurs at the exit month.
Monthly Cash Flow Table
A detailed table showing each month's equity cash flow (negative for injections, positive for distributions) with a visual bar indicator. This helps identify the timing and magnitude of each equity movement.
Tab 4: Distribution Waterfall
The Waterfall tab shows the priority order in which cash flows are distributed, reflecting the capital structure hierarchy configured in Component 4.
1. Debt Service (Highest Priority)
Senior debt interest and principal payments are made first. This is sourced directly from Component 4's amortization schedule. No equity distributions occur until debt service obligations are met.
2. Preference Shares (If Configured)
If preference shares (mezzanine equity) were enabled in Component 4, their fixed return (e.g., 10% p.a.) is paid next. This tranche sits between senior debt and common equity in the priority stack.
3. Common Equity Distributions (Residual)
All remaining cash flows after debt service and preference shares are distributed to common equity investors. This is the residual claim — it carries the most risk but also captures the upside. The total common equity distributions are displayed (e.g., AED 1,186,466,065.30).
How Metrics Are Calculated
All Component 5 metrics are derived from the monthly equity cash flow series generated by Component 4's financing engine. Here's how each metric is computed:
Equity IRR
Calculated using the Newton-Raphson method on the monthly equity cash flow series (M0 to M162). The monthly IRR is annualized using: (1 + monthly_IRR)^12 - 1.
Equity Multiple
A simple ratio of total cash returned to total cash invested. Unlike IRR, this metric does not account for the timing of cash flows.
Equity Payback Month
The cumulative cash flow starts negative (equal to total equity invested) and increases as distributions are received. The payback month is the first period where the cumulative position turns positive.
Relationship to Component 4
Component 5 is entirely dependent on Component 4. Any change to the financing structure in Component 4 will automatically update all metrics in Component 5. Key dependencies include:
- Debt Structure: LTC/LTV ratios, interest rate, amortization schedule, and IDC treatment all affect the equity cash flow series.
- Land as Equity: Enabling this in Component 4 increases the equity invested (land value) but reduces cash injections, affecting the equity multiple and IRR.
- Preference Shares: If enabled, preference returns are paid before common equity distributions, reducing the common equity IRR.
- Exit Strategy: The exit timing and terminal value (from Component 3's exit cap rate) determine the final equity distribution, which typically represents the majority of total returns.
- Drawdown Schedule: The timing of debt drawdowns affects when equity injections are required, impacting the IRR calculation.
Tips & Best Practices
Target Equity IRR Benchmarks
For operational real estate in the GCC region, target equity IRRs typically range from 12-18% for core/core-plus assets and 18-25% for value-add/opportunistic plays. If your equity IRR is below 10%, consider reducing leverage costs or improving operational assumptions in Component 2.
Payback Timing
For hold assets with exit at the end of the hold period, payback typically occurs at the exit month. If you want earlier payback, consider a refinance strategy in Component 4 or a shorter hold period.
Multiple vs IRR
A high equity multiple with a low IRR may indicate that returns are back-loaded (most cash returned at exit). Conversely, a high IRR with a lower multiple may indicate early cash distributions. Both metrics should be evaluated together.
Sensitivity Analysis
After reviewing Component 5, proceed to Scenario Analysis to test how changes in key assumptions (exit cap rate, interest rate, occupancy) affect your equity returns. This is critical for understanding downside risk.