Operational Stream
Component 4: Financing
Component 4 models the complete capital structure for operational real estate projects — senior debt, preference shares, and equity. Its key innovation is the dynamic gap-fill equity mechanism, which calculates exactly how much cash equity is needed month-by-month to keep the project solvent, combined with a waterfall payment structure that enforces proper capital priority.
Overview
Component 4 takes inputs from Component 1 (construction costs, land cost, S-curve phasing) and Component 2 (operating cash flows, P&L) and builds the full financing model. It is the most complex component in the Operational Stream, bridging development expenditure with operational returns through a month-by-month cash flow engine.
What This Component Calculates
- •Debt Sizing: Maximum facility size based on LTC and LTV ratios (binding constraint applied)
- •Monthly Loan Drawdowns: Aligned with construction S-curve from Component 1
- •Interest Calculations: Including IDC (Interest During Construction) treatment options
- •Dynamic Equity Gap-Fill: Month-by-month cash equity injections to maintain positive cash position
- •Exit Proceeds: Sale, refinance, or hold scenarios based on terminal value
Step-by-Step Walkthrough
Step 1: Project Summary
The opening step consolidates all inputs from previous components into a single funding overview.
- Consolidated Inputs: Total development cost, land cost, stabilized NOI, and operating period from Components 1–3
- Funding Gap Visualization - Preliminary: Peak funding requirement vs. debt capacity vs. equity required
- Capital Stack: Visual breakdown of debt / preference / equity split
- Key Metrics: Construction period, operating period, and net surplus at stabilization
Step 2: Debt Sizing (LTC & LTV)
The system sizes senior debt using two independent constraints and applies the more restrictive one.
Loan-to-Cost (LTC)
Determines maximum debt as a percentage of total development cost (TDC). Typical range: 60–75% for development finance.
Loan-to-Value (LTV)
Determines maximum debt as a percentage of stabilized property value. Typical range: 55–70% for operational assets.
Where Stabilized Value = Stabilized NOI ÷ Exit Cap Rate
Binding Constraint
The system uses whichever constraint produces the lower amount, ensuring the facility complies with both cost and value tests.
Step 3: Land as Equity
A toggle determines whether land cost is treated as an equity contribution (skin-in-the-game) or refinanced into the senior facility.
Enabled: Land as Equity
- Land cost counts toward equity requirement
- Reduces cash equity needed during construction
- Demonstrates sponsor commitment to lenders
Disabled: Land Refinanced
- Land cost included in TDC for LTC calculation
- Subject to LTC/LTV binding constraint
- Higher cash equity requirement during development
Land Equity Coverage = Land Cost ÷ Total Equity Required
Step 4: Preference Shares (Optional)
An optional mezzanine or preference tranche sits between senior debt and common equity in the capital stack.
- Allocation: Configured as a percentage of cash equity required, after land and senior debt sizing
- Return Types: Fixed dividend (% p.a.) or Islamic target profit (profit-sharing)
- Tenor: Subordinate to senior debt; repaid after bank facility payoff
- Priority: Dividends paid after loan interest and principal; capital repaid before equity distributions
Step 5: Construction Loan Drawdown Structure
Choose how the approved facility is drawn down during the construction period, aligned with cost phasing from Component 1.
Quarterly
Equal draws every 3 months. Simplest approach for early-stage feasibility.
S-Curve (Hybrid Milestones)
Draws follow the construction S-curve profile from Component 1. Recommended for lender presentations.
Custom
User-defined monthly drawdown schedule for project-specific milestone agreements.
A preview table shows monthly draw amounts and cumulative drawdown, with a visual chart of the cumulative drawdown curve.
Step 6: Interest Rate & IDC (Interest During Construction)
Configure the cost of debt and how interest accrued during construction is treated.
- Fixed Rate: Single rate applied throughout the loan life
- Floating Rate: Base rate + margin (e.g., EIBOR + 250 bps)
- Islamic Financing: Profit rate applied to Murabaha, Ijara, or Sukuk structure
IDC Treatment Options
Fully Capitalized
IDC added to loan balance. Increases total debt at conversion but no cash outflow during construction.
Paid Current
Interest paid monthly from equity during construction. Increases equity requirement but keeps loan balance lower.
Hybrid
Split between capitalized and paid current. Common in practice for partial sponsor funding of IDC.
An illustrative IDC mechanics table and DSCR projection table (showing debt service coverage during operations) are generated for review.
Canonical Rule: The 1-Month Offset
FeasiBuild applies a strict 1-month offset to interest calculations to reflect real-world banking lags:
- Construction / RCF Interest: Interest payments at Month t are calculated on the cumulative loan balance at the end of Month t-1.
- IDC (Interest During Construction): Accrued interest follows the same prior-period balance logic.
Step 7: Loan Repayment Terms
Define how the facility converts from construction to term loan and how principal is repaid.
Loan Type Options
- Equal P+I Payment (Annuity): Fixed monthly payment of principal + interest
- Equal Principal Amortization: Fixed principal each period, declining interest
- Bullet Payment (Interest-Only): Interest only during term, full principal at maturity
- Custom Schedule: User-defined repayment schedule
Loan Tenor Structure
- Construction period (auto from Component 1)
- Pre-op buffer (fixed 6 months)
- Interest-only grace period (optional, first N operating years)
- Amortization period (matches hotel operations period)
Prepayment Terms
- Lockout Period: Years where no prepayment is allowed
- Prepayment Penalty Step-Down: Declining % by year (e.g., Y4: 5%, Y5: 4%, Y6: 3%...)
- Yield Maintenance: Alternative to make-whole penalty calculation
A loan preview table shows start balance, interest, principal, and total debt service by fiscal year end.
Step 8: Debt Covenants & Exit Strategy
Debt Covenants
| Covenant | Typical Range | Description |
|---|---|---|
| Minimum DSCR | 1.2x – 2.0x | NOI ÷ Debt Service must exceed threshold |
| Max LTV | 70 – 75% | Outstanding loan ÷ property value must stay below limit |
| Minimum Debt Yield | 8 – 10% | NOI ÷ loan amount must exceed threshold |
| DSCR Test Frequency | Annual / Quarterly | How often covenants are tested during operations |
Exit Strategy Options
Hold
Continue operations; model amortization and covenant DSCRs through hold period.
Refinance
Refinance senior facility at exit year; calculate refi proceeds after payoff.
Sale
Sell asset at exit year; calculate sale proceeds after loan payoff and penalties.
Exit/refi timing is selected via month selector (e.g., M156 = Year 13 year-end month). A covenant status grid shows pass/fail indicators for each operating year, with a validation checklist and monthly debt service & DSCR snapshot.
Monthly Cash Flows Table
The comprehensive monthly cash flow table is the engine output of Component 4. Each row represents one month from M0 through exit, with all inflows, outflows, and financing activities reconciled to a cumulative cash position.
Cash Inflows
Cash Outflows
NCF (Pre-Financing)
Represents project cash flow before any financing activities.
Financing Activities
Equity
NCF (Post-Financing)
End-of-month cash position after all financing activities.
Gap-Fill Equity Mechanism
Critical:This is FeasiBuild's core innovation in project finance modeling. Traditional models assume a fixed equity amount upfront — gap-fill equity calculates the exact cash needed each month.
The Problem
Construction phasing, loan drawdown timing, and operating cash flow volatility mean the actual cash equity needed varies month-by-month. Over-equity wastes capital and depresses IRR; under-equity causes insolvency.
The Solution — Gap-Fill Rules
1. Calculate Pre-Equity Position
+ NCF Pre-Financing
+ Loan Drawdown
− Interest − Principal − Pref Activities
2. Check for Shortfall
- If Pre-Equity Cumulative ≥ 0: No equity needed this month
- If Pre-Equity Cumulative < 0: Equity gap exists
3. Calculate Required Equity Injection
4. Apply Equity
Cumulative NCF Post-Financing = Previous Cumulative + NCF Post-Financing
5. Track Total Equity
Example Walkthrough
| Month | Activity | Pre-Equity | Cash Equity |
|---|---|---|---|
| M0 | Land 210,000 + Construction 220,958. Draw 27,387. | −403,571 | 403,571 |
| M1 | Construction 9,820. No draw. Interest 205. | −10,025 | 10,025 |
| M3 | Construction 1,892 + POWC 1,300. Draw 27,387. | +24,195 | — |
Key Benefits
- •Minimizes equity commitment — only inject when needed
- •Maximizes equity IRR — equity deployed later = higher return
- •Prevents insolvency — cash position never goes negative
- •Reflects real-world practice — matches how sponsors actually fund development
Waterfall Payment Structure
The waterfall ensures proper capital structure hierarchy — senior obligations are always paid before subordinate claims and equity distributions.
Payment Priority Order (Highest to Lowest)
Loan Interest
Senior debt interest has first claim on cash flows. Calculated monthly on outstanding balance. Must be paid to avoid default.
Loan Principal
Senior debt principal per amortization schedule from Step 7. Reduces outstanding loan balance.
Preference Dividends
Fixed return to preference shareholders (% of preference amount). Paid after senior debt service.
Preference Repayment
Return of preference capital, typically at end of preference tenor. After senior debt payoff if subordinate.
Equity Distributions
Residual cash flow to equity holders. Only after all senior obligations met. Represents true levered cash flow.
Waterfall Logic in Monthly Table
Step 1: Pay Interest → Remaining = Available Cash − Interest
Step 2: Pay Principal → Remaining = Step 1 − Principal
Step 3: Pay Pref Dividend → Remaining = Step 2 − Pref Dividend
Step 4: Pay Pref Repayment → Remaining = Step 3 − Pref Repayment
Step 5: Equity Distribution = Remaining (if positive)
OR Equity Injection = |Remaining| (if negative, gap-fill)
Exit Waterfall (at Sale / Refinance)
Step 1: Loan Payoff → Remaining = Gross Proceeds − Outstanding Loan
Step 2: Prepayment Penalty (if applicable) → Remaining = Step 1 − Penalty
Step 3: Preference Repayment → Remaining = Step 2 − Preference Balance
Step 4: Net Exit Proceeds to Equity = Remaining
Example: Exit Proceeds
Key Financing Metrics
The summary section at the top of the financing output displays these metrics:
| Metric | Description | Example |
|---|---|---|
| Total Equity Amount | Sum of Land Equity + Cash Equity injections | AED 288,035,481 |
| Total Cash Injection | Cash equity only (excludes land if treated as equity) | — |
| Total Land Equity Injection | Land cost counted as equity (AED 0 if land refinanced) | — |
| Total Loan Drawdown Amount | Sum of all monthly loan draws | AED 301,252,087 |
| Preference Shares Amount | Mezzanine / preference tranche size | — |
| Total Loan Interest | Sum of all interest payments over loan life | AED 196,566,987 |
| Equity Multiple | Total equity distributions ÷ Total equity invested | 4.07x |
| Equity Payback | Month when cumulative equity distributions = equity invested | M156 |
| Equity IRR | Annualized IRR on equity cash flows | 12.18% |
| DSCR Min / Avg | Minimum and average debt service coverage during operations | — |
Exit Proceeds Calculation
The exit proceeds box summarizes the waterfall at the selected exit month:
Example: AED 75,668,320 ÷ 7% = AED 1,080,975,963