SECURE, AUDITED, COMPLEX WATERFALL CALCULATIONS

Automated waterfall distributions

Move away from high-risk Excel files by automating complex waterfall calculations in a secure and audited environment.

Decorative lines based on the LemonEdge logo

Automate even the most complex of waterfall distributions

Three ways you can automate waterfall calculations in LemonEdge:

  1. Out-Of-The-Box: Use our lot-level distribution versions with extensive configurable variables.
  2. Excel Models: Work in our native spreadsheets, Algorithms instead of Excel for the ultimate flexibility and transparency.
  3. Proprietary: Model waterfalls too complex for Excel, such as lot-level calculations, by coding through our API into our waterfall engine.
Flexibility Out of The Box

Why Excel waterfalls should be a thing of the past:

  • Black bullet point based on LemonEdge logo

    It struggles with complex calculations you end up with many sheets, all interlinked.

  • Black bullet point based on LemonEdge logo

    Human-error is too easy it increases as spreadsheets get more complicated.

  • Black bullet point based on LemonEdge logo

    There’s no audit history can you be sure nobody has changed anything since last time?

  • Black bullet point based on LemonEdge logo

    Key-person risk dependent on one or only a few people.

  • Black bullet point based on LemonEdge logo

    It doesn’t scale — as your business grows, its flaws become more pronounced.

Control, audit & Report

Benefits of automating your waterfall calculations in LemonEdge

Here are some of the reasons your firm will benefit from calculating distributions in LemonEdge:

Black tick

Improved control

Ensure that intricate calculation rules carefully transcribed from the fund LPA are locked down and can’t be changed, even inadvertently.

Black tick

Reduce manual input

Minimise time spent doing manual and error-prone tasks by automating the pulling in of data and the subsequent posting of results, including any resultant accounting entries

Black tick

Simple reporting

Having everything safely inside LemonEdge means that reporting of; return on capital, preferred returns, catch-ups, clawbacks, recyclables, carry, etc can be done with confidence.

Black tick

Auditability

As with everything in LemonEdge, there is a full audit history, which enables you to view time-stamped changes at any time.

Black tick

No more carried interest processing

As LemonEdge takes care of the waterfall distribution, the consequential carried interest processing is already taken care of — with the results sent directly to the carried interest entities.

Decorative lines based on the LemonEdge logo

See the future of fund accounting

Just some of what we’re excited to show you:

White bullet point based on LemonEdge logo
Collate data from any source with intuitive tools.
White bullet point based on LemonEdge logo
Eliminate multiple-entry bookkeeping.
White bullet point based on LemonEdge logo
Create fund structures in minutes.
White bullet point based on LemonEdge logo
Instant scenario analysis across your portfolio.
White bullet point based on LemonEdge logo
Search and report on any data point.
White bullet point based on LemonEdge logo
Interrogate real-time General Ledgers.
White bullet point based on LemonEdge logo
Integrate custom calculations and waterfalls.

Tell us about you and your firm, and we’ll come straight back to you to schedule a personalised demo.

Thank you! Your submission has been received!
Something went wrong while submitting the form, please try again.
Decorative lines based on the LemonEdge logo

A proven alternative to legacy systems

man standing in office

"LemonEdge has proven market-leading capabilities that will enable the continuing evolution of our operations to become agile, efficient and able to add further value to our investors.”

Guillaume de Malliard, COO and Partner at Astorg Group

Decorative lines based on the LemonEdge logo

ROYC and LemonEdge sign strategic partnership

February 20, 2024
Jamie Nascimento
Successful business partners co-working in office

Frequently asked questions

Will LemonEdge be able to support my waterfall distribution model?

Yes. One of the three different methods LemonEdge has to support waterfalls will meet your needs (without needing to resort to high-risk off-line Excel spreadsheets) — which method is used will depend on your precise requirements.

How does LemonEdge support the extreme level of complexity seen in some waterfall distribution models?

The out-of-the-box lot-level default waterfall functionality is itself capable of supporting a wide range of complex models.  If your method does not operate at lot-level, or if the complexity exceeds the limits of the default offering, then any other method can always be supported using LemonEdge Algorithms. In addition, if you already have some bespoke model you wish to continue to use, then that is also possible using the LemonEdge API.

How is carried interest processed?

The holistic integrated nature of the LemonEdge system means that having completed the processing of a distribution the carried interest element can be automatically processed too, including the bookkeeping of relevant entries in carried interest vehicles.

Are the distribution notices also produced as part of the waterfall process?

The holistic integrated nature of the LemonEdge system means that having completed the processing of a distribution the associated notices can be automatically processed too, including issuing them direct to recipients or to the integrated LemonEdge portal (being a more secure communications method).

How are portal groups managed?

Groups of portal users are managed centrally on the main LemonEdge system.

Still have questions?

Request a demo and we'll answer them.