Blog/Financial Modelling
A Preferred Equity NAV Facility Model should start with the cash-flow priority created by the instrument. The preferred equity sits on top of a private equity portfolio, equity in legal form and debt-like in payoff. It ranks ahead of common equity for distributions and liquidation proceeds, behind secured and unsecured debt, and it carries a stated return, a liquidation preference and redemption triggers that can behave like amortisation.
NAV facilities look down to portfolio investments for credit support, whereas subscription facilities look up to unfunded LP commitments. For that reason, the model has to reproduce a contractual waterfall rather than add a simple debt line. Every material commercial outcome, including when cash reaches the preferred provider and when it is trapped, sits in that waterfall.
Nine linked modules cover the structure and keep the economics tied to the documents:
| Feature | Traditional NAV loan | Preferred equity NAV structure |
|---|---|---|
| Legal form | Debt facility at fund or SPV level | Preferred equity interests, sometimes financed by a NAV facility at a holding vehicle |
| Credit support | Portfolio NAV, portfolio interests, distribution cash flows | Priority distribution rights plus possible pledge of the preferred interests |
| Model treatment | Debt schedule with interest, LTV and covenant tests | Preference roll-forward plus waterfall, redemption events and blockers |
| Ranking | Structurally subordinated to portfolio-company debt | Senior to common equity, junior to debt, without creditor status |
| Model failure point | LTV breach, cross-collateralisation, 100% cash sweep | PIK build-up, redemption pressure, waterfall drafting, protective rights |
| Document to translate | Credit agreement and collateral package | Preferred terms, waterfall, anti-layering covenant, redemption triggers |
Preferred equity structures are used where limited partnership agreements, pledge and transfer restrictions, tax-sensitive investors or debt-incurrence limits make a conventional NAV facility hard to execute. That is a documentation reason, not an economic exemption. The comparison between NAV loans and preferred equity matters for consent and covenant analysis, while the cash-flow model still has to follow the same portfolio-backed economics.
Two structures dominate. In one version, a financing provider holds preferred equity directly at fund or SPV level, with stated dividends, mandatory redemption events and debt-like covenants drafted to mirror NAV facility economics. In another, a back-leverage chain sits behind the preferred instrument.
Under that back-leverage path, the fund forms a Preferred Issuer, the Preferred Issuer issues preferred equity to a Preferred Holder that is often an affiliated or orphan SPV, the Preferred Holder borrows under a private equity NAV facility, and the Preferred Holder pledges the preferred equity interests to the lenders. Facility proceeds fund the Preferred Holder’s purchase of preferred equity, and the Preferred Issuer applies that cash to its intended use.
The modelling consequence is specific. Two linked schedules are needed, one for the preferred instrument and one for the NAV borrowing and pledge, because dividend timing at the Preferred Issuer and debt service at the Preferred Holder are governed by different documents and can fall out of step.
List each investment with ownership percentage, latest mark, valuation date, expected exit window and expected interim distributions. Then apply the lender’s adjustments, including excluded assets, concentration caps, stale-mark haircuts and any asset-specific discount.
Portfolio-company collateral is illiquid and bespoke, priced through models and assumptions rather than observable markets. A model that runs off GP-reported NAV alone will overstate headroom in the scenarios where headroom is most important. Carry three NAV cases from the first tab: base, downside and severe downside.
Private equity NAV facilities reference a smaller and more concentrated pool of portfolio companies than secondaries facilities. Concentration should therefore be a live output, recalculated after every modelled exit.
Facility amount equals eligible NAV multiplied by the advance rate, subject to any hard cap. Opening LTV is the preference balance or drawn amount divided by eligible NAV.
The output that decision-makers need is not the opening ratio. It is the NAV decline required to breach. Solve for the percentage fall in eligible NAV that moves LTV to the sweep trigger and again to the maximum LTV covenant, then report both in percentage terms and in absolute value across the largest three positions.
NAV financing supports follow-on and tack-on acquisitions, capital infusions into existing portfolio companies, refinancing and accelerated distributions to investors. One facility can combine several uses, but each use changes the fund model differently.
Value-accretive uses and distribution acceleration can produce similar early IRR improvements while creating very different terminal outcomes. Show both paths side by side or the model answers the wrong question.
Ending preference equals opening preference, plus accrued return, plus PIK, plus any additional draws, less cash paid and less redemptions.
The preference schedule should include each component that can change the claim before common equity receives cash:
PIK compounds. A deferred coupon that rolls into preference raises the numerator of the LTV test while asset values are already under pressure, which is the mechanism that turns a soft quarter into a covenant problem. Model the toggle explicitly rather than assuming full cash pay. The mechanics mirror PIK interest in leveraged structures, applied to an equity instrument.
Order the tiers in the sequence the drafted terms require. A workable default is:
Preferred equity delivers priority economics through drafted distribution controls, not through creditor remedies. If the waterfall in the model does not match the waterfall in the instrument, the priority the provider paid for does not exist in the output.
Covenant packages on NAV loans include minimum diversity requirements that can trigger a 100% cash-flow sweep and a maximum LTV ratio that becomes an event of default if uncured. Represent each test as a pass or fail flag that drives the waterfall rather than as a disclosure line below it.
Outputs to surface each period include cash trapped, cash swept, cure amount required, distributions permitted or blocked, and mandatory redemption flag. Add the anti-layering restriction so the model cannot silently assume new financing that would prime the instrument.
For each asset, model exit date, gross value, net proceeds, amount applied to redemption, residual to common equity, and remaining eligible NAV. Recalculate LTV and diversity immediately after each exit.
Selling the best asset early repays preference and reduces diversification at the same time. Cross-collateralisation means one impaired company can affect the whole facility, unlike company-level debt where a single failure can be contained. The model should show that a deleveraging exit sometimes tightens the covenant position rather than easing it.
Run the fund with and without the facility and report gross IRR, net IRR where fees and carry are modelled, TVPI, DPI, RVPI, preferred provider IRR and MOIC, residual common value, LTV path, covenant headroom, swept periods and NAV breakeven. Techniques from debt scheduling transfer directly to the preference roll-forward, although the waterfall must still control the timing of cash.
Stress cases worth running include a 20% and 35% NAV haircut, exits delayed by twelve months, one large position distributing nothing, PIK toggle on for four quarters, sweep triggered for the remaining life, and mandatory redemption falling due with insufficient distributable cash.
Most model errors in this structure do not sit in the formatting or output page. They sit in assumptions that let common equity receive cash too early, understate the preferred claim or overstate eligible NAV.
Compare the preferred and common positions at every case, and check the output against the term sheet before it reaches an investment committee or LPAC. Broader context on NAV financing helps frame the disclosure discussion, but the IC model still has to prove the economics case by case.
The underwriting question is whether the priority claim on portfolio cash flows improves total fund outcomes or moves distributions forward while shifting downside risk onto the residual common equity. A model that cannot separate those two effects will approve both.
Build the haircut NAV case and the sweep-triggered case before the base case is finalised. If the facility only works when marks hold and exits land on schedule, the structure is underwriting the valuation assumptions rather than the portfolio.
P.S. If building this kind of structure in Excel is part of the job, check out our Premium Resources for fund and LBO models, Excel skill tests and more tools to help you advance your career.
Join 80,000+ readers
One email a week: markets and finance news, the latest M&A deals and reports, investor biographies and deep dives.
Free forever. Unsubscribe anytime.
