SmartHelping / Hedge Fund Fees / Excel
Hedge Fund Fee Model
Model an annually resetting soft hurdle, optional management fees, and a high watermark across 15 years. Show investors how gains, losses, and loss recovery affect fees and ending net asset value (NAV).
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Follow the fee calculation from NAV to net results.
Watch how the soft hurdle, management fee, and high watermark interact. Open the screenshots to review the model and its visualizations before purchasing.
What the template includes
A clear view of the fees behind the fund's results.
Change the assumptions, follow the fee calculations, and use the charts to explain what investors retain and what the manager earns.
Follow the fee structure over time
Simulate up to 15 years of results. Extend the calculation by dragging the bottom row down when you need a longer horizon.
Test the performance-fee trigger
When the period's gain exceeds the hurdle, the soft-hurdle logic applies the performance fee to the entire gain, subject to the separate high-watermark restriction.
Keep the hurdle period-specific
The hurdle resets each year. It does not accumulate or compound across periods.
Separate new gains from loss recovery
The performance-fee calculation is limited to increases above the most recent high watermark, preventing performance fees on recovery of previous losses.
Include a beginning-NAV fee
The optional asset management fee is based on beginning NAV each period and applies regardless of investment performance.
Deduct management fees before the performance test
The model measures the period's gain or loss after management fees, but before performance fees, relative to the prior period's ending NAV.
Explain the results with charts
Review total fees over time, NAV, cumulative gains and losses from the initial deposit, and the relationship between the high watermark and fees earned.
Change the assumptions and inspect the logic
Update the light yellow input cells to recalculate the fees. The workbook is fully editable and unlocked.
The model was vetted by a practicing hedge fund attorney. It illustrates this specific fee structure; confirm that the calculation matches your fund documents and intended terms.
Management fees, soft hurdle, and high watermark
Two performance-fee rules working together.
The annual soft hurdle determines whether the period's performance qualifies. The high watermark separately limits the gains eligible for a performance fee.
Management fee first
If enabled, the management fee is calculated on beginning NAV. It reduces the period's result before the gain or loss is measured for performance-fee purposes, including in a loss year.
Annual soft hurdle
The period's gain must exceed the hurdle. Under the soft-hurdle approach, the fee can apply to the entire gain, not just the amount above the hurdle, while still respecting the high watermark.
High-watermark protection
Only gains above the latest high watermark can support a performance fee. The model's restriction keeps the fee from taking ending NAV below that mark and avoids fees on recovery of earlier losses.
Starting high watermark
The starting watermark establishes the initial reference level. It may be the investor's initial NAV or another agreed amount; use the starting level defined by the relevant fund agreement.
How to use it
Turn the fee terms into an investor conversation.
Set the starting position and fee assumptions
Update the relevant light yellow cells for the starting NAV, high watermark, hurdle, and fee assumptions. Align them with the structure you want to demonstrate.
Enter the performance scenario
Change the annual assumptions to model gains, losses, and recovery periods across the 15-year schedule.
Review the calculated fees and NAV
Follow the management-fee deduction, annual hurdle test, high-watermark restriction, and resulting ending NAV.
Use the charts to explain the outcome
Compare fees, NAV, cumulative gains and losses, and high-watermark behavior. Change the inputs to demonstrate how a different performance path affects the result.
Who gets value from it
For people explaining or evaluating fund fees.
Fund managers and sponsors
Demonstrate how this soft-hurdle and high-watermark arrangement works across different performance paths.
Investors and allocators
Review the relationship between investment results, management fees, performance fees, and ending NAV.
Attorneys and advisors
Use the model as a numerical illustration when discussing the economic terms of a proposed fee arrangement.
Analysts and finance teams
Inspect the unlocked calculations, change assumptions, and communicate the results through the included charts.
Also available in these bundles
Need more ways to model investor economics?
The Hedge Fund Fee model is included in the Joint Venture and Super Smart collections.
Joint Venture Templates
Explore preferred returns, investor hurdles, catch-up structures, and cash flow waterfall models.
View the Joint Venture bundleSuper Smart Bundle
Explore the broader SmartHelping collection of financial models, accounting tools, and spreadsheet templates.
View the Super Smart BundleRelated joint venture and investment models
Explore other return and distribution structures.
These complementary templates cover preferred returns, IRR hurdles, catch-up provisions, fund tracking, and real estate investment analysis.
Preferred Return with Investor Thresholds
Explore a preferred-return structure with investor-specific thresholds.
Explore the investor threshold modelHybrid IRR / MOIC Waterfall
Explore a preferred-return waterfall with a hybrid IRR and MOIC hurdle in Tier 3.
Explore the hybrid waterfallPreferred Return with GP Catch-Up Options
Compare preferred-return economics with multiple GP catch-up options.
Explore the catch-up modelPreferred Return Model
Explore an Excel framework for preferred-return calculations.
Explore the preferred-return modelPreferred Equity with IRR Hurdles
Explore preferred equity followed by a subordinate IRR-hurdle waterfall.
Explore the preferred equity modelPreferred Equity with Equity-Multiple Hurdles
Review a preferred-equity structure using equity-multiple thresholds.
Explore the equity-multiple modelThree-Tier IRR Waterfall
Explore a general cash flow waterfall with three IRR hurdles.
Explore the three-hurdle waterfallIRR Hurdles with GP Catch-Up
Explore a waterfall combining IRR hurdles and a GP catch-up.
Explore the IRR catch-up modelSimple-Interest Preferred Return
Review a non-compounding preferred-return structure with multiple hurdles.
Explore the simple-interest modelPreferred Return Fund Tracker
Explore a tracking template for a preferred-return investment fund.
Explore the fund trackerCumulative Distribution Waterfall
Explore a joint venture structure based on cumulative distributions.
Explore the distribution modelMixed-Use Real Estate Model
Connect a mixed-use property analysis to financing and joint venture economics.
Explore the mixed-use modelMulti-Family Acquisition Model
Explore a financial model for evaluating a multi-family acquisition.
Explore the acquisition modelJoint Venture IRR Waterfall
Explore an IRR-hurdle framework for allocating joint venture cash flows.
Explore the joint venture modelSelf-Storage Multi-Fund Model
Explore a self-storage investment analysis with a multi-fund structure.
Explore the self-storage modelQuestions before you buy
A few useful details.
Does the hurdle accumulate or compound?
No. This model uses a soft hurdle that resets annually. It is not a cumulative or compounding hurdle model.
Can performance fees be charged just for recovering a loss?
Not under this model's high-watermark logic. Performance fees are limited to gains above the most recent watermark, with the annual hurdle test also applying.
Is the management fee charged during a loss year?
Yes, if the asset management fee is enabled. It is based on beginning NAV and is deducted before the gain or loss used for the performance-fee calculation is measured.
How many years does the template cover?
The template provides a 15-year simulation. The calculation can be expanded by dragging down the bottom row.
Can I edit the inputs and formulas?
Yes. The model is fully editable and unlocked. Change the light yellow input cells to update the fee calculations and review the resulting charts.
Does this cover every hedge fund fee arrangement?
No. It illustrates an annually resetting soft hurdle with a high watermark and optional management fees. Hard hurdles, cumulative hurdles, and other negotiated terms may require different logic. Match the spreadsheet to the applicable agreement with your advisors.
Is it included in a bundle?
Yes. The Hedge Fund Fee model is included in the Joint Venture and Super Smart bundles linked above.
Make the fee structure easier to understand
Show what the manager earns and the investor retains.
Get the unlocked Excel model with a 15-year simulation, annual soft hurdle, high watermark, optional management fee, and eight visualizations. One-time purchase for $75.
