Debt Fund Financial Model

Based on the most helpful WSO content, creating a robust financial model for a real estate credit fund requires incorporating several key components. While there isn't a direct template shared in the WSO threads, here are some actionable steps and resources to guide you:

Key Features Your Model Should Include:

1. Loan Types and Recovery Scenarios:

   • Include toggles for different loan types (senior, mezzanine, bridge loans, etc.).
   • Build recovery scenarios with varying assumptions for default rates, recovery percentages, and timelines.

2. Back Leverage:

   • Model the impact of warehouse facilities or note-on-note structures.
   • Use the XIRR function to calculate levered yields, similar to equity waterfall models but tailored to loan economics.

3. Capital Call Timing:

   • Create a schedule for capital calls based on projected funding needs.
   • Include flexibility for timing adjustments to align with deal flow.

4. Returns and Carried Interest:

   • Incorporate LP-GP waterfall structures with preferred returns, catch-up provisions, and carried interest.
   • Ensure the model can handle multiple tiers of profit-sharing.

Suggested Resources:

• WSO Free Modeling Series: This includes lessons on financial statement modeling, DCF, and LBOs, which can be adapted for real estate credit fund modeling.
• REFM Courses: These cover JV waterfalls, preferred returns, and partnership structures, which are essential for your carried interest calculations.
• Adventures in CRE: Known for their real estate-specific modeling templates, they may have resources tailored to debt fund modeling.

Additional Tips:

• Look into Argus for property-level cash flow analysis, which can feed into your fund-level model.
• Consider reaching out to the WSO community directly in the Real Estate Forum for shared templates or advice from experienced professionals.

If you're looking for a specific LP-GP waterfall model or other templates, you might find value in threads like "Debt Fund Modeling in REPE?" or "Real Estate Private Equity - Underwriting Template" on WSO. These discussions often highlight best practices and tools used by industry professionals.

Sources: Debt Fund Modeling in REPE?, Real Estate Asset/Portfolio Management Tips and Tools, REFM Review - Real Estate Financial Modeling Courses 1-3, Lender/Debt Fund Modeling vs Broker Modeling