Private equity modelling
On a private equity Excel modelling course delegates practise pulling all the levers, optimising equity returns and competing in teams to produce the ‘best’ deal.
Here you can find out more about our LBO course.
Search our site
Or you can search our site for more finance training topics.
Note: click on the video below to play or, alternatively, if you prefer you can read the course transcript underneath. Training course provider: We’ve got this first session here – key principles and roles of private equity; introduction to private equity. So...The next stage of the LBO modelling course is to insert a preferred equity instrument (such as loan stock or preference shares) into the buyout structure. Download a copy of the spreadsheet used for this final section of the course: modelling equity....Here are some suggestions as to how returns could be laid out and calculated when LBO modelling. Most of the numbers above we calculated previously. Here we are assuming that: The business could be sold at an enterprise value of 28.0. EBITDA of 4.0 x 7 = 28.0...Now we’ve got this far through the LBO modelling course, and have a rough outline of a possible deal structure, at this next stage we will: Think about what we could sell the business for (say when we expect to exit in 5 years’ time), think about likely returns for...When estimating debt capacity, fleshing out the LBO modelling structure, and determining the equity gap, there are a number of “right” answers. Here is one answer: Debt = say 5 x 2.0 EBITDA = 10.0. Depending on the size and the quality of the business,...