Debt Fund Financial Model – Direct Lending & Private Credit Excel Template
The Debt Fund Financial Model is a fully integrated Excel template for direct lending funds, private credit funds and closed-ended debt funds that use a leverage / credit facility. Built on a 10-year monthly timeline with annual roundup columns (2027–2036), it takes a fund from first close through deployment, interest income, principal repayments, harvesting and final liquidation. Whether you are a fund manager raising a new private debt vehicle, an investor running due diligence, or an analyst building an LP presentation, the model gives you a lender- and investor-ready view of how a credit fund makes money.
Debt Fund Financial Model Template
At its core is a loan-by-loan engine. Every loan on the loan tape gets its own monthly schedule covering drawdowns, delayed-draw commitments, cash interest on a base-rate-plus-spread basis with floors, PIK interest, arrangement, upfront, OID, exit and prepayment fees, amortisation, prepayments, defaults and recoveries. These roll up into a portfolio summary, an IFRS 9-style expected credit loss provision, a borrowing-base credit facility, and a full set of linked financial statements: cash flow, P&L, balance sheet and NAV.
The model ends with what investors care about most: a European distribution waterfall (return of capital, preferred return, GP catch-up and carried interest) and investor returns, including gross and net IRR, XIRR, MOIC, DPI, RVPI and TVPI at fund, LP, GP and individual-investor level. A one-cell scenario selector runs 51 pre-built cases through the whole model, and a dedicated checks tab reconciles every tab to a PASS / REVIEW status. Change the start date and every date, header and flag in the workbook updates automatically.
Tab-by-Tab Overview
01. Dashboard
The Dashboard summarises the debt fund’s performance on one screen. KPIs cover fundraising, investments, portfolio yield, credit performance, the credit facility, fund financials, returns and key ratios, all as at a reporting date you choose. Eight charts show deployment, outstanding balances, yield, maturities, facility use, NAV, distributions and IRR.
- Fund overview, fundraising, investment and portfolio KPIs
- Credit, facility, financial, return and ratio panels
- Eight dynamic charts, including Gross vs Net IRR
- Shows the active scenario and the overall model check status
02. Timeline
The Timeline is the model’s master calendar. A single start date input drives every date in the debt fund model: closings, investment period, fund maturity, extensions and final liquidation. Monthly flags mark each lifecycle phase, quarter-ends, distribution dates and loan events, so the whole forecast re-dates automatically.
- One input re-dates the entire workbook
- Fund dates, investment period and fundraising period
- Forecast month, quarter and year counters
- Lifecycle phase and timing flags, plus a selectable reporting date
Debt Fund Model Loan Summary
03. Assumptions
Assumptions holds every global driver of the private credit fund in one place: fund size, GP commitment, investment pacing, loan pricing, credit risk, management fees, a detailed expense budget, waterfall terms, tax and the base rate curve. Colour coding separates inputs from formulas and links, and key drivers are highlighted.
- General, fundraising and investment assumptions
- Loan pricing, portfolio and credit assumptions
- Management fee, operating expense and portfolio expense inputs
- Waterfall, tax and macroeconomic (base rate curve) assumptions
04. Fundraising
Fundraising models investor commitments and capital calls. An investor register tracks each LP and the GP across three closings. Each month, capital calls fund whatever cash requirement remains after facility drawings, allocated pro-rata to each admitted investor’s uncalled commitment, with call fees, defaulting-investor memo lines and reconciliation checks.
- Investor register with closing dates and investor status
- Commitment summary and admitted commitments over time
- Monthly capital calls by investor, with cumulative contributions
- Call fees, a defaulting-investor section and fundraising checks
05. Pipeline
The Pipeline tab tracks future direct lending opportunities. Each deal records borrower, sector, status, proposed terms, pricing, credit assessment and expected deployment. A probability of completion weights the pipeline value, producing expected monthly, quarterly and annual deployment forecasts and a pipeline conversion rate.
- Deal register with status, source and deal lead
- Proposed commitment, drawdown and maturity
- Expected pricing and credit assessment
- Probability-weighted pipeline value and deployment by year
06. Loan Tape
The Loan Tape is the loan-level register behind the whole model. One row per loan captures identification, dates, commitments, pricing, repayment terms, credit rating, PD, recovery rate, collateral, LTV and borrowing-base eligibility. Effective terms automatically pick up any scenario changes, and the tape drives every loan cash flow.
- 16 illustrative loans across sectors, countries and seniority
- Base-rate-plus-spread pricing, PIK toggle and fee terms
- Exit route per loan: maturity, prepayment or default
- Collateral, LTV, advance rate and eligibility tests
07. Loan Schedule
The Loan Schedule builds every loan month by month. Each block calculates drawdowns, undrawn commitments, interest accrued on an Act/365 basis, PIK capitalisation, fees, amortisation, prepayments, statistical and identified defaults, write-offs and recoveries. Per-loan IRR, MOIC, yield, LTV and status sit alongside built-in loan checks.
- Separate monthly block for each loan
- Opening and closing principal, PIK, accrued interest and undrawn balances
- Interest, fees, amortisation, prepayments and credit events
- Loan IRR, MOIC, yield, LTV and status, plus integrity checks
08. Portfolio Summary
The Portfolio Summary consolidates the loan book. It shows the principal roll-forward, commitments, gross and net portfolio income, annualised yields and weighted average spread. Composition by sector, geography, currency and seniority, together with risk metrics, maturity buckets and portfolio valuation, gives a complete view of the credit portfolio.
- Portfolio balance roll-forward, including PIK
- Gross, cash, PIK and net portfolio yields
- Sector, geography, seniority and top-five concentrations
- Weighted average LTV, loan life, maturity, PD and recovery rate
09. Credit Losses
Credit Losses models defaults, write-offs and recoveries. Defaulted balances go into a recovery pool collected over the recovery period, with a haircut applied at liquidation. An IFRS 9-style expected credit loss provision (Stage 1 12-month ECL plus Stage 3 lifetime ECL on non-performing loans) drives impairment charges and reversals.
- Expected (PD-based) and identified (actual) defaults
- Principal and interest write-offs, and net credit losses
- Recovery pool, recovery rate and recovery timing
- ECL provisioning, impairments and credit stress rates
Debt Fund Model Financial Statements
10. Facility Assumptions
Facility Assumptions sets the terms of the fund’s leverage facility: commitment, availability period, maturity, SOFR-based pricing with a floor and margin, fees, utilisation targets, borrowing-base advance rates by seniority, concentration limits, eligibility criteria, financial covenants and repayment mechanics such as mandatory repayments and cash sweeps.
- Facility commitment, availability and maturity dates
- Base rate, floor, margin and fees
- Advance rates for first lien, senior, second lien and junior loans
- Eligibility criteria, covenants and repayment terms
11. Facility Schedule
The Facility Schedule runs the credit facility month by month. It calculates the borrowing base after concentration limits, haircuts and reserves, then the drawdowns, repayments, interest (Act/360), commitment fees and deferred fee amortisation. Covenant tests (debt to equity, asset coverage, interest coverage and LTV) are monitored every period.
- Borrowing base with single-borrower, sector and geographic limits
- Drawdowns, voluntary and mandatory repayments, cash sweeps and borrowing-base cures
- Facility interest and fees, with deferred fee amortisation
- Covenant compliance and facility checks
12. Fees & Expenses
Fees & Expenses models every cost of running the fund: management fees (on commitments during the investment period, then on invested capital), waivers and discounts, a memo carried interest accrual, fund administration, professional and operating expenses, investment expenses and taxes. Expenses are indexed for inflation and paid quarterly.
- Management fee basis, rate, accrual and payment
- Fee waivers, discounts, offsets and step-down
- Fund administration, professional, operating and investment expenses
- Tax expenses, inflation indexation and payables mechanics
13. Fund Cash Flow
The Fund Cash Flow is the treasury engine. It tracks capital contributions, loan fundings, portfolio collections, facility flows, expenses, taxes and distributions. A clear funding order (facility first, then capital calls to protect the minimum cash balance) runs without circular references, and surplus cash is distributed quarterly.
- Opening and closing cash, restricted and unrestricted
- Investment outflows and portfolio collections
- Facility, operating expense and tax cash flows
- Funding requirement, capital call trigger and distributable cash
14. P&L
The P&L presents the debt fund’s income statement on an accruals basis. Portfolio income, portfolio expenses, net credit losses, financing costs, management fees and fund operating expenses build up to operating profit, profit before tax and net profit after tax, with fair value movements and other income shown separately.
- Interest, PIK and fee income
- Net credit loss expense, including ECL movements
- Facility interest and fee amortisation
- Operating profit through to net profit after tax
15. Balance Sheet
The Balance Sheet shows the fund’s month-end financial position: cash, the gross and net loan portfolio, accrued interest, PIK, recovery receivables and deferred facility fees, against facility debt and payables. An equity roll-forward of contributions, retained earnings and distributions proves that NAV equals equity every month.
- Assets, portfolio assets and other assets
- Facility, operating and tax liabilities
- Equity roll-forward by LP and GP
- Balance sheet reconciliation (difference = 0)
16. NAV
The NAV tab builds net asset value from portfolio valuation, adjustments, cash and liabilities, and reconciles it to the balance sheet. NAV movements separate net investment income, realised and unrealised gains and losses, expenses, fees, tax and distributions. Gross NAV, net NAV after accrued carry, the LP and GP split, and NAV per unit are all included.
- Portfolio valuation and adjustments
- Gross and net NAV
- NAV movement bridge
- LP / GP NAV split and NAV per unit
Debt Fund Model Portfolio Returns
17. Distribution Waterfall
The Distribution Waterfall applies a European (whole-of-fund) structure to distributable cash: return of capital, a compounding preferred return, GP catch-up and carried interest. Each tier is tracked with cumulative balances, LP and GP allocations, and checks that confirm the carried interest never exceeds the agreed share of profit.
- Fund obligations paid before distributions
- Return of capital and preferred return accrual
- GP catch-up and carried interest tiers
- Cumulative waterfall balances and waterfall checks
18. Investor Returns
Investor Returns measures performance for every stakeholder. Using monthly cash flows, it calculates IRR, XIRR, MOIC, DPI, RVPI and TVPI for the fund, LPs, the GP and each individual investor, alongside gross portfolio IRR, gross fund IRR and net IRR, so you can see the impact of leverage, fees and carried interest.
- Investor-by-investor performance table
- LP and GP returns, including carried interest
- Gross portfolio, gross fund and net fund IRR
- DPI, RVPI and TVPI time series
19. Sensitivities
Sensitivities lets you stress-test the debt fund with a single input. Choose any of 51 cases, from upside, downside, severe downside, interest rate, credit and liquidity stress to individual sensitivities, and the full model recalculates. A stored results table compares IRR, MOIC, NAV, credit losses and liquidity across every case.
- 7 combined scenarios and 44 single-variable sensitivities
- One-cell case selector runs the whole model
- Stored outputs table with changes vs the base case
- Covers rates, yield, credit, leverage, deployment, prepayment, expenses and fundraising
20. Checks
The Checks tab is the model’s audit layer. More than 100 reconciliations across fundraising, loans, portfolio, credit, facility, cash flow, P&L, balance sheet, NAV, waterfall and investor returns roll up into section and overall PASS / REVIEW statuses, which also appear on the dashboard.
- Section-by-section reconciliation checks
- Model integrity checks (negative cash, investment after the investment period, facility overdraws)
- Status for every monthly period plus a life-of-fund status
- Overall “All Checks Passing” flag linked to the dashboard
Why Buy This Model?
Building a debt fund model from scratch takes weeks and is easy to get wrong. Loan-level interest and PIK, borrowing-base leverage, capital calls, ECL provisioning and a distribution waterfall all have to tie together without circular references. This model does that work for you. It is fully formula-driven across 20 integrated tabs, uses lender-style formatting with colour-coded inputs, carries 100+ built-in checks, and has a scenario engine that runs 51 cases through the whole model. You get a professional, transparent, editable tool you can adapt to your own fund terms, loan tape and investors, saving you time and giving investors and lenders confidence in your numbers.
Debt Fund Direct Lending Frequently Asked Questions (Faq)
Q: What type of fund is this model designed for?
A: It is designed for closed-ended private credit and direct lending funds that lend to companies, typically senior, unitranche, second lien or junior loans, and that may use a credit facility for leverage. It also works as a training and analysis tool for private debt investors and analysts.
Q: Can I change the start date of the fund?
A: Yes. Enter a new Fund Inception Date in the yellow cell on 02. Timeline and every date, year header, month label, loan date and flag in the workbook updates automatically.
Q: How many loans can the model handle?
A: The template comes with 16 fully modelled loans, each with its own monthly schedule. You can change any loan’s terms on the Loan Tape, such as size, timing, pricing, tenor, seniority and exit route. Adding more loans means extending the loan schedule blocks, which follow a consistent, repeatable structure.
Q: Does the model include a credit facility or leverage?
A: Yes. It includes a revolving, borrowing-base leverage facility with advance rates by seniority, concentration limits, eligibility tests, interest reserves, commitment fees, mandatory repayments, cash sweeps and covenant testing.
Q: How are capital calls calculated?
A: Each month the model works out the cash the fund needs. It draws on the facility first, up to the borrowing base and target utilisation, and then calls capital from investors for any remaining shortfall below the minimum cash balance. Calls are allocated pro-rata to each admitted investor’s uncalled commitment.
Q: What distribution waterfall does it use?
A: A European (whole-of-fund) waterfall: return of capital, a compounding preferred return, GP catch-up, then carried interest. The preferred return, catch-up percentage and carry percentage are all inputs.
Q: Which return metrics does it calculate?
A: Gross portfolio IRR, gross fund IRR, net fund IRR, LP net IRR, GP IRR, XIRR, MOIC, DPI, RVPI, TVPI, cash yield and annualised return, including a performance table for each individual investor.
Q: How does the model handle defaults and credit losses?
A: It combines two approaches. Statistical defaults are driven by each loan’s probability of default, and specific loans can be given an identified credit event. Defaulted balances move to a recovery pool collected over a set period, and an IFRS 9-style expected credit loss provision captures forward-looking losses.
Q: Can I run scenarios and sensitivities?
A: Yes. Enter a case number on 19. Sensitivities to run any of 51 pre-built cases through the full model, including upside, downside, severe downside, interest rate, credit and liquidity stress. You can also edit the flex values or create your own cases.
Q: Does it include financial statements?
A: Yes. It includes a monthly fund cash flow, P&L, balance sheet and NAV statement, all fully linked, with annual totals and a balance sheet that balances every month.
Q: Are there circular references or macros?
A: No. The model is built without circular references and without macros, so it calculates cleanly in standard Excel.
Q: How do I know the model is working correctly?
A: The Checks tab runs more than 100 reconciliations across every part of the model and reports a PASS or REVIEW status for every month and overall. The overall status also appears on the dashboard.
Q: Is it easy to customise for my own fund?
A: Yes. Inputs are clearly colour-coded (blue on yellow), formulas are black and links are green. Fund size, fees, waterfall terms, facility terms, expenses and loan details can all be changed without touching the formulas.
Q: Which currency does it use?
A: It is set up in USD, but because all values are inputs you can relabel it for any currency.
Q: Can I use it to present to investors or lenders?
A: Yes. The dashboard, charts, waterfall and investor returns are designed for LP presentations, credit committee papers and lender discussions, and the professional formatting and visible checks help build credibility.
Final Notes on the 10 Year Financial Model Integration
This structured model helps Debt Fund investors have a broad market spectrum, offering the right balance between cost, and investment support.
Further Reading
Merger & Acquisitions Model: Download a professional M&A financial model. Dynamic valuation, accretion/dilution analysis, synergies, and debt schedules.
- Real Estate Private Equity Fund Financial Projection Model: Professional-grade Real Estate Private Equity (REPE) fund financial model in Excel.
- Leveraged Buyout Financial Model: Master your LBO finances minutes. Download this fully customizable financial model template with clear dashboard reports.
