Hi everyone, I’m preparing for a real estate debt modeling case study as part of an interview with a debt fund, and I’d love some insights from those with experience in lender-side modeling. I come from a real estate equity asset management background, where I’ve worked on some financial modeling but mainly portfolio oversight/investment analysis. However, I’m trying to understand the key differences when modeling from the lender perspective versus the equity investor side.
Maybe I am overthinking it but should I expect an acquisition model/below?
-Model Loan-level metrics – LTV, DSCR, Debt Yield, Loan IRR
-Net loan cash flows – Lender’s perspective (repayment schedules)
-Fund-level modeling – Aggregating loan performance, cost structures, and return calculations Borrower loan modification analysis
-Calculating loan profitability at loan-level
From those of you who’ve gone through similar debt-focused case studies, what should I expect? Are there any major shifts in approach compared to modeling for equity investments? Any specific Excel skills or structuring techniques I should focus on? Would really appreciate any guidance or resources that could help! Also, I found a case study example that I can share and that I am trying to work through.
Thanks!
When transitioning from equity-side modeling to lender-side modeling, there are indeed some key differences to keep in mind. Based on the most helpful WSO content, here’s what you should focus on for your real estate debt modeling case study:
Loan-Level Metrics:
Net Loan Cash Flows:
Fund-Level Modeling:
Borrower Loan Modification Analysis:
Loan Profitability:
Key Shifts in Approach:
Excel Skills to Focus On:
Resources:
Good luck with your preparation! If you need further clarification or specific examples, feel free to ask.
Sources: Lender/Debt Fund Modeling vs Broker Modeling, Real Estate Modelling Test Practice, Investment Sales Vs. Debt/Equity Brokerage, https://www.wallstreetoasis.com/forum/investment-banking/modeling-in-hf-vs-pe-vs-ib?customgpt=1, Private Credit Resources and Prep
You’re on the right track in considering the key differences between lender-side and equity investor modeling. The core distinction lies in how each side views risk and returns. As a lender, you’ll be focusing on securing your principal and ensuring that the debt is serviced properly throughout the life of the loan. Here’s a breakdown of the major shifts:
1. Loan-level metrics: Lenders focus heavily on LTV (Loan-to-Value), DSCR (Debt Service Coverage Ratio), and Debt Yield. These metrics help assess the borrower’s ability to repay the loan and the risk of the loan relative to the asset’s value. Your loan-level model should prioritize these ratios to assess the financial health and repayment ability of the borrower.
2. Net loan cash flows: This is where you’ll need to incorporate repayment schedules, including interest and principal payments. For a lender, cash flows are the most important aspect, as you’ll need to make sure that debt servicing is adequate. Unlike equity models where the focus may be on overall profitability and exit, you’ll be concerned with the timing of cash flows and the potential for default or early repayment.
3. Fund-level modeling: You’re correct to consider aggregating loan performance, as the debt fund will look at the overall portfolio’s performance and risk exposure. Fund-level modeling often includes consolidating cash flows from individual loans, assessing the portfolio’s weighted average cost of debt (WACD), and calculating overall fund-level returns, usually on a net of debt basis.
4. Borrower loan modification analysis: As a lender, you may also need to model for potential loan modifications, especially in distressed or underperforming scenarios. This could include assessing whether to extend loan maturities, reduce interest rates, or alter repayment schedules, which are more likely to happen from a lender’s side than from an equity investor’s.
In terms of approach, the primary shift is moving from focusing on equity value and exit strategies to a more cash flow-centric view that prioritizes risk mitigation, principal preservation, and debt serviceability. For Excel skills, you should be comfortable with sensitivity analysis, scenario modeling, and IRR calculations at the loan level. Debt amortization schedules will be crucial to understand, along with modeling for debt waterfalls if the fund has multiple tranches of debt. Lastly, make sure you’re comfortable using discounted cash flow (DCF) models for debt, similar to how you would for equity but with a focus on ensuring the debt serviceability over time.
If you don’t mind you mind sharing the case study when you have a chance? I can also send some similar debt fund case study with you as well!
Do you mind sharing/DMing the case study when you get a moment? I can send a recent case study I did for a debt fund as well. Thank you!
Same here. If you could please send me the debt fund case study, I'll review with you. same to you @timriggins97
Consequatur quasi omnis id dolores. A laborum harum consequatur numquam quas. Aut rerum omnis velit laboriosam. Quia quam possimus quam illo. Ut aut expedita quia eos. Dolore exercitationem deserunt ab sunt sed hic est ducimus.
Labore excepturi inventore voluptate laudantium sed excepturi voluptate. Voluptatibus quod ea officiis odit ipsa repudiandae. Iure magnam enim quia iste nobis. Aut iste animi culpa rerum. Voluptatem voluptates quia quo nulla. Modi molestiae aut culpa minus esse.
Assumenda aut et quasi consequatur quos. Reiciendis adipisci ut nam cupiditate veritatis unde repudiandae. Cupiditate itaque voluptas repellendus assumenda dolor voluptatem consequatur. Enim illum cumque qui expedita aspernatur odio vero. Quidem nobis repellendus impedit dolore aspernatur tempora omnis. Deserunt voluptates consequatur dolores enim in consequatur voluptatem. Explicabo quis sed consequatur aut autem rerum.
Molestiae laboriosam deserunt in. Aut consectetur reiciendis nesciunt. Dolores excepturi dolorem ea voluptates sit maiores voluptates odit. Maxime et quia laborum harum tenetur cumque est. Consequatur ipsa libero nulla voluptates fugiat. Rerum facilis et dolor explicabo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...