Coming soon
Credit Fund Financial Model Excel Template
Credit fund model for direct lending, CLO, and fixed income portfolio managers. Yield-to-maturity, duration, credit spread, default assumptions, NAV build, fund-level IRR and management economics.
Who it's for
Direct lending fund managers, CLO managers, credit analysts at asset managers, credit hedge funds, insurance company investment teams managing fixed income portfolios, LP investors evaluating credit fund terms.
What's in the model
COVER
Model documentation, credit strategy selector (direct lending / CLO / fixed income).
FUND_INPUTS
Fund size, vintage, fee structure, hurdle, carry terms, investment period.
PORTFOLIO_INPUTS
Loan/bond details: face value, coupon/spread, maturity, credit rating, expected recovery.
YIELD_CALC
Yield-to-maturity, yield-to-call, current yield. Accrued interest. Clean vs dirty price.
DURATION
Macaulay duration, modified duration, convexity. DV01 per position and aggregate.
DEFAULT_MODEL
Default rate assumptions by rating cohort. Recovery rate, LGD, expected credit loss.
NAV
Net Asset Value build: portfolio fair value + accrued income - management fees - carried interest. Monthly NAV roll.
FUND_RETURNS
Gross and net IRR, MOIC, DPI, TVPI. Cash yield vs total return split.
WATERFALL
Management fee and carry calculation. Hurdle rate mechanics for credit fund structure.
SENSITIVITY
Returns sensitivity to default rate, recovery, spread, and reinvestment rate assumptions.
OUTPUTS
LP report format. Portfolio analytics. Performance attribution.
CHECKS
NAV reconciles, yield calculations tie to cash flows, waterfall splits correct.
What makes this different
Direct lending and fixed income
Single model handles both direct lending (floating rate, OID) and fixed income bond portfolios. Toggle on INPUTS.
Duration and DV01
Full duration analytics: Macaulay, modified, convexity, DV01. Not just yield metrics.
Default scenario analysis
Stress default rates by rating category with recovery assumptions. Calculates fund-level impact on IRR.
NAV roll-forward
Monthly NAV build with fee netting. Essential for credit fund reporting.
Reinvestment rate sensitivity
Critical for credit funds with revolving portfolios — built into the returns engine.
Get notified when this launches
Excel (.xlsx) · ~13 tabs · direct lending + fixed income · expected pricing £395 · Q3 2026 launch target
No spam. One email when it ships. Or contact us at sfsmodels362@gmail.com for a custom early build.
Frequently asked questions
When will this be available?
Targeting Q3 2026. Sign up and we'll email when it ships.
Does it cover CLO tranche structuring?
v1 focuses on the equity/GP perspective. CLO tranching model is a separate release on the pipeline.
What about private credit / direct lending?
Yes — the floating rate, OID, PIK mechanics for direct lending are all supported.
Can I commission an early build?
Yes. Use the form below or email sfsmodels362@gmail.com for custom builds.
Related models (live now)
About SFS Models
SFS Models builds institutional-grade Excel financial models for banking and finance professionals. Used by FP&A, Treasury, ALM and Capital teams at US and UK regional banks, by PE firms, and by corporate finance consultancies. Open formulas, no VBA, fully auditable.