Real Estate & Private Equity Desk
Commercial real estate acquisition underwriting, institutional private equity LBO models, GP/LP promote waterfall distributions, and debt yield sizing. Engineered for CRE sponsors, private equity general partners, and commercial mortgage originators.
CRE PE LP/GP Equity Waterfall & Promote Model
Underwrite commercial real estate equity syndications and private equity fund waterfalls. Compute multi-tier hurdle IRRs, Equity Multiple (MoIC), European vs. American promote splits, LP/GP distribution checks, and dynamic capital return schedules.
• American (Deal-by-Deal) vs. European (Whole-Fund) Promote Mode
• Dollars-and-Cents LP vs. GP Distribution HUD
• Interactive SVG Waterfall Distribution Stack Chart
• 10-Year Annual Capital Return & Promote Schedule Table
Private Equity & Sponsor LBO Returns Workbench
Institutional leveraged buyout engine. Size purchase enterprise value, balance Sources & Uses, model 5-year operating free cash flow debt paydown waterfalls, calculate Sponsor MoIC and IRR, and perform tripartite value creation attribution.
• Senior Term Loan & Mezzanine Debt Tranche Structuring
• 5-Year Operating Model & 100% Cash Sweep Debt Paydown
• Sponsor Multiple on Invested Capital (MoIC) & IRR Engine
• Tripartite Value Creation: Deleveraging vs. Growth vs. Multiple
• 2D Sensitivity Matrix: Exit Multiple vs. Holding Period
CRE Debt Yield & Tripartite Loan Sizing Underwriter
Simultaneously evaluate commercial mortgages across the three mandatory credit committee covenants: Debt Yield (NOI / Loan), DSCR, and Maximum LTV to pinpoint the governing bottleneck and required equity check.
• Implied Capitalization Rate & Cash-on-Cash Return Analysis
• Property Type Presets (Multifamily, Industrial, Retail, Office)
• Interest Rate Shock & Sizing Sensitivity Matrix
Commercial Real Estate (CRE) Acquisition & Pro Forma Underwriting Engine
Full-scale 10-year institutional CRE cash flow waterfall, sources & uses balancing, senior debt amortization with interest-only periods, levered/unlevered IRR, equity multiple (MoIC), dual 2D sensitivity matrices, and dynamic SVG NOI vs. debt service visualizer.
• 10-Year Dynamic Revenue, Expense & Cash Flow Waterfall
• Senior Debt Amortization Engine (IO Period + P&I Waterfall)
• Dual-Horizon Returns: Unlevered & Levered IRR (Newton-Raphson) + MoIC
• Year 1 Debt Yield, Exit Cap Spread & DSCR Covenant HUD
• Dual 2D Sensitivity Matrices (Exit Cap vs. Hold, Price vs. Rent)
CRE Lease-by-Lease Rent Roll & WALT Underwriter
Institutional "Argus-Lite" lease rollover and tenant risk underwriter. Calculate Weighted Average Lease Term (WALT) by SF and Revenue, model multi-tenant rollover cliffs, project TI/LC capital reserve liabilities, and compute Net Effective Rent (NER).
• WALT by Rentable Area (SF) and Base Rental Revenue ($)
• 10-Year Lease Expiration Cliff Schedule with Risk Threshold Badges
• Tenant Re-Leasing Capital Reserves (TI & LC Sizing Waterfall)
• Net Effective Rent (NER) HUD & SVG Rollover / Concentration Visualizers
Real Estate & Private Equity Desk Quantitative Architecture & Methodology
The Real Estate & Private Equity Desk combines rigorous capital allocation models with commercial property economics. From multi-tiered American waterfall promotes to debt yield sizing and rent roll WALT analysis, every model enforces standard institutional underwriting covenants.
Core Mathematical Formulations
The primary benchmark for pricing commercial real estate assets based on normalized unlevered cash flows and market cap rates.
The lender's primary non-recourse risk metric measuring gross unlevered return on loan principal regardless of interest rates.
Models sequential equity cash distribution hurdles (e.g. 8% preferred return, 80/20 tier 1, 70/30 tier 2) with exact catch-up mechanics.
Quantifies commercial tenant lease rollover risk across office, industrial, and retail portfolios.
Target Institutional Audience & Applications
Real estate operators modeling multi-family, industrial, and retail acquisitions, debt sizing, and LP equity syndication structures.
LBO analysts evaluating debt capacity, sponsor returns (IRR and MoIC), and sensitivity to exit multiples.
Capital advisors packaging debt yield, LTV, and DSCR underwritings for CMBS, agency (Fannie/Freddie), and balance-sheet lenders.
Cross-Asset Concept Guides & Recommended Reading
How lenders size commercial mortgages using debt yield versus loan-to-value.
American vs European waterfalls, catch-up clauses, and promote tier modeling.
Senior debt, mezzanine financing, and free cash flow debt paydown kinetics.