Looking for earn-out model
I'm looking for an earn-out model, i.e. M&A with purchase price contingent on the target (or combined entity) reaching a specific milestone at a specified date. Free or paid - anyone can help?
Trending Content - Investment Banking Forum
| +194 | Downfall of Qatalyst | 37 | 2h |
| +166 | UBS IB 26Q2 a Disaster! Advisory Revenue Down 23%, Capital MarketsDown 5% | 22 | 1d |
| +95 | UBS Americas IB: The Kids’ Table of Wall Street | 12 | 2h |
| +81 | Lincoln International Return Offers | 42 | 3h |
| +49 | so confused about 28 SA timeline | 27 | 4d |
| +37 | London IB BB is a challenge | 28 | 10h |
| +35 | Fired during interview | 5 | 1d |
| +33 | [WSO MODS] Please Delete This BS Host Books Spam! | 2 | 4d |
| +33 | momentum of Rx groups | 11 | 4h |
| +26 | What does RX Consulting Ops Turnaround Work Actually Look Like? | 4 | 1h |
Career Resources
Based on the WSO content, the financial modeling training courses include discussions on earnouts, particularly in the context of M&A scenarios. The courses are designed to help students and investment banking professionals understand complex deal structures, including those involving earnouts. These models often feature flexible toggles based on year, size of acquisition, and model out a representative acquisition target which flows into the model in a waterfall structure. This is treated as an asset acquisition for simplification in the balance sheet impact.
For a more detailed and hands-on approach, you might consider accessing the WSO Free Modeling Series, which includes financial modeling lessons and templates. This resource could provide you with the necessary tools and templates to build or adapt an earn-out model to suit your specific needs.
Sources: NEW Financial Modeling Training Courses, Most Strategically Successful M&A deals of the last few years?, On Buyouts, There Ought to Be a Law, Reasonable entry multiple for buyout target?, Is there a website to find specific M&A deals?
No it's not in the WSO courses tf
Check out the PE deals process course, we cover earnouts there
What's the milestone? Revenue, gross profit, etc.?
Wouldn't you just add it to the sources and uses, link it to the balance sheet, and then if the target is met it gets reduced by the payout with a corresponding cash flow impact on the cash flow statement?
Include in S&U and just add a switch to have it flow out of cash flows if metrics are met.
have you heard about the if formula, i heard its pretty dope
Set a probability on the earnout payment. Then discount the midpoint back to the present using a risk-free rate based on Treasury constant maturity rates, using linear interpolation to correspond to the milestone term. The concluded discount rate for the milestone should be equal to the risk-free rate plus option-adjusted spread to capture the credit risk of the payer (i.e. RF+ BBB or B credit risk).
an earn-out is a binary event, it's not like winning a contract where it makes sense to assign a probability to it and then seeing the aggregate impact of different probabilities on multiple contracts. Better off keeping it simple and just have multiple scenarios
Sint et facilis quia facere. Ab vitae velit similique nihil quidem quas odit et.
Tempora molestias nihil alias laborum dolorem architecto accusantium. Reprehenderit consectetur eligendi excepturi excepturi delectus minus aliquid. Et numquam nisi dolores et omnis in non. Officiis voluptates a molestiae.
Et id incidunt velit fuga et. Laudantium quos eum consequatur quis repellat nihil tempora. Qui enim sed et totam fugiat. Quis dolorem molestiae error dolorem sint earum.
Consectetur nesciunt enim eveniet vitae ut est ea. Ut impedit itaque ut rerum voluptate. Rerum itaque molestias occaecati eligendi ut impedit reprehenderit. Nisi illo reprehenderit omnis quo. Exercitationem nulla eius nisi enim qui sunt odio voluptas. Consequatur sint sed officia tenetur. Autem assumenda occaecati et sit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...