# Direct Lending Fund Model Model a direct lending fund with loan-by-loan origination, yield, defaults, and fund performance without missing accrued interest or covenant breaches. Calculate fund-level cash flows, investor distributions, and tranche-specific returns across the portfolio life. - Canonical: https://finamodel.com/templates/direct-lending-model - Excel download: https://finamodel.com/templates/direct-lending.xlsx - Category: Credit - Model type: Fund / Waterfall - Difficulty: Intermediate - Audiences: Credit & risk, Bankers & advisors, Credit investors, Direct lenders, Fund managers, Credit analysts - Tags: lending, credit, yield, covenant, fund-performance ## Overview A direct lending fund originates individual loans to middle-market companies, managing yield, defaults, and fund-level cash flows to investors. The model tracks each loan's interest income, origination fees, and principal repayment, rolls these up to fund-level cash flows, and computes IRR and MOIC (money multiple on invested capital) across junior and senior tranches. Key variables include the blended yield (interest rate plus upfront fees), the loan term, loss assumptions, and default probability. The workbook separates accrued interest income (which swells the portfolio value) from cash interest (which funds investor distributions), capturing the timing misalignment that causes naive cash flow models to understate returns in the early hold period. Loss provisioning is modeled as a percentage of outstanding principal, with recovery assumed at a later date. The fund-level cash flow includes both original capital deployed (negative) and distributions back to investors as loans are repaid and interest is collected (positive). Direct lending funds are appropriate for credit investors with a tolerance for illiquidity (5–7 year hold periods) and the operational complexity of loan-level tracking. This template is calibrated for institutional fund structures with 10–50 loans in the portfolio at any given time. ## What's included - Individual loan origination with price, rate, and term assumptions - Yield calculation: interest income, OID accretion, and upfront fees - Loss provisions and default scenario analysis - Principal repayment and refinancing schedule - Fund-level cash flows, investor distributions, and fund IRR and MOIC - Yield calculation: interest income, OID, upfront fees - Fund-level cash flows and investor distributions - Fund IRR and MOIC calculation across tranches ## Direct Lending Fund Model: How the Template Works This direct lending fund model template captures the economics of a senior-secured private credit fund. It covers loan origination, interest accrual, defaults, recoveries, and fund-level cash flows over a 7-year life. The outline below explains the key operating drivers, calculation flow, and outputs so you can assess whether it fits your analysis needs. ### Loan Portfolio and Origination Mechanics The template deploys capital over a three-year investment period, with new originations paced from fund size. Each loan enters a principal rollforward: opening balance plus new loans and payment-in-kind interest, minus scheduled amortisation, prepayments, defaults, and a final balloon repayment in year seven. - Defaults are driven by a vintage default curve multiplied by sector-specific default multipliers, while prepayments follow a separate annual curve. Payment-in-kind interest capitalises only on the designated PIK share of the book. - Original issue discount is tracked separately as an unamortised balance, with straight-line amortisation accreted into income each period and written off proportionally on prepayments or defaults. The model also accounts for origination economics: upfront fees and OID are booked on new loans, while exit fees and call protection premiums apply to voluntary prepayments. A half-year interest convention toggle avoids overstating final-year interest on a balloon-repaid book. ### Sector Allocation and Credit Assumptions Four sector buckets—Software, Healthcare, Industrials, and Consumer—drive weighted spread and default behavior. Each sector carries a weight, a spread over the base rate, and a default multiplier. - The fund-level weighted spread and weighted default multiplier are calculated from these inputs, ensuring that shifts in sector mix affect both income and credit losses. A concentration cap limits any single sector's share of the book. - Lien-position recoveries are modelled through book-mix inputs for first lien, second lien, and unsecured loans, each with its own recovery rate. The weighted recovery rate applies to defaults to determine loss given default. These features allow users to explore how portfolio composition influences risk and return without rebuilding the model from scratch. ### Cash Flow Waterfall and Investor Distributions The fund uses a European whole-fund waterfall. Available cash for distribution equals opening cash plus net operating cash minus a minimum cash reserve, but only after the investment period; during the investment period all cash is retained for deployment. - Capital calls fund the gap between cash needs and facility draws, with the asset-based revolver providing working capital up to an advance rate against performing principal. The waterfall allocates returns of capital, then a vintage-weighted preferred return, then GP catch-up, and finally carried interest. - The vintage-weighted preferred return table ensures that later capital contributions do not receive the same compound hurdle as earlier ones. Management fees apply on committed capital during the investment period and switch to invested capital in the harvest period, with a toggle for the fee base and an offset from upfront fee income. The facility schedule tracks draws, repayments, interest, commitment fees, and covenant tests. ### Outputs and Practical Applications The model produces fund-level and investor-level metrics including IRR, MOIC, TVPI, DPI, RVPI, NAV, and yields. A J-curve illustrates the net cash flow profile over time. - Twelve built-in checks validate capital account ties, PIK reconciliation, OID amortisation, covenant compliance, sector concentration, and cash balances. Users can adjust assumptions for fund size, base rate, default and prepay curves, facility terms, management fees, and waterfall parameters to test different scenarios. - The template is designed for evaluating a senior-secured private credit strategy under a documented set of mechanics. The public download is a values-only preview; the underlying model captures the relationships described here. ## Loan-level yield and covenant tracking Model each loan interest, fees, and PIK toggle separately, then track covenants and refinancing scenarios at the individual loan level. ## Loss provisioning and recovery modeling Apply recovery rate assumptions and timing to quantify net loss impact on fund returns and test portfolio resilience under default scenarios. ## Waterfall distribution to capital tranches Distribute fund cash flows by seniority across senior, mezzanine, and junior tranches to show tranche-specific IRR and MOIC for LP reporting. ## Loan-level yield and covenant tracking Model each loan interest, fees, and PIK toggle separately, then track covenants and refinancing scenarios at the individual loan level. ## Loss provisioning and recovery modeling Apply recovery rate assumptions and timing to quantify net loss impact on fund returns and test portfolio resilience under default scenarios. ## Waterfall distribution to capital tranches Distribute fund cash flows by seniority across senior, mezzanine, and junior tranches to show tranche-specific IRR and MOIC for LP reporting. ## Features - **Loan-level yield and covenant tracking:** Model each loan's interest, fees, and PIK toggle, then track covenants and refinancing scenarios. - **Loss provisioning and recovery:** Apply recovery rate assumptions and timing to quantify net loss impact on fund returns. - **Waterfall to capital tranches:** Distribute fund cash flows by seniority (senior, mezzanine, junior) to show tranche-specific returns. ## Use cases - **Fund underwriting and LP materials:** Show expected fund IRR, MOIC, and loss reserve adequacy in investment memorandums. - **Individual loan approval:** Assess how a new loan impacts fund returns, diversification, and concentration risk. - **Refinancing and exit planning:** Model refinance scenarios to evaluate extension versus payoff, and impact on fund maturity. ## Frequently asked questions ### What is a direct lending fund model? It is a model that forecasts loan origination, yield realization, default losses, and fund-level cash flows to calculate IRR and MOIC for a direct lending fund. ### How is direct lending yield calculated? Yield includes stated interest, upfront fees amortized over the loan life, OID accretion, and PIK interest where applicable, all measured as effective yield to maturity. ### What are loan covenants? Covenants are borrower obligations such as maintaining a leverage ratio or interest coverage floor, whose breach triggers acceleration rights or lender protective action. ### How do I model a fund MOIC? MOIC is cumulative cash distributions plus ending residual value divided by cumulative invested capital, and is the primary return metric used in LP reporting. ### Who uses direct lending fund models? Credit investors, direct lenders, fund managers, and credit analysts use them for fund underwriting, LP materials, individual loan approval analysis, and exit planning. ## Related templates - [Loan Portfolio CDR Model](https://finamodel.com/templates/loan-portfolio-cdr-model) - [Mezzanine Debt Funding Model](https://finamodel.com/templates/mezzanine-debt-model) - [Credit Stress Testing Framework](https://finamodel.com/templates/stress-testing-model)