Modelandum has something for everyone

When it comes to financial modelling, people come from many different backgrounds and levels of knowledge. This is why we have created a range of financial modelling products to suit your needs and pocket. From a complete LBO course which will teach you how to build your own model from scratch, to a ready to use LBO modell, or mini products which explain in detail specific topics, or even tools to help you excel in a job interview

Remember, that if you have a particular request, we will be very happy to create a relevant tutorial and publish it for a very small fee

Here is a link to a very good Private Equity Blog: http://www.theprivateequiteer.com/

LBO Financial Model Training

Intermediate to advanced LBO model training
Format: Video eBook

The LBO Financial Model course will allow the user to build a full LBO model from scratch, using our unique step-by-step excel model, in the same way that a Private Equity professional would do on the job.

Whether you are a student interested in entering the Private Equity market, or a professional looking to improve your financial modelling skills, look no further. This is the course that will boost your profile!

We cover all the principles of financial modelling, as well as detailed explanations of what is involved in an LBO model, and how to approach the spreadsheet. Our course is 100% focused on excel, and it has been developed by a team of highly experienced financial modellers from Private Equity and Corporate Finance backgrounds.

The course is delivered as a set of downloadable videos that complement an excel model, which means that you can work anywhere, anytime and at your own pace.

We will also give you 6 months access to an experienced financial modeller who will be able to answer any questions related to the model.

Course Contents*

Chapter 1- Principles of Financial Modelling
Chapter 2- What is an LBO?
Chapter 3- Operating Model and EBITDA
Chapter 4- Revenues and Cost of Goods Sold
Chapter 5- Other Operating Expenses
Chapter 6- Depreciation
Chapter 7- Other Current Assets
Chapter 8- Financial Model - Sources and Uses of Cash
Chapter 9- Senior Debt
Chapter 10- Mezzanine Debt
Chapter 11- Shareholder Loan
Chapter 12- Revolver and Waterfall
Chapter 13- Equity
Chapter 14- Exit Event and LBO Returns

*The course assumes that the user has a basic understanding of accounting and excel

  Price £200

 

Financial modelling test training

  Modelling test training Guide
Format: Excel eBook
     
   

It’s becoming increasingly common for the private equity recruiter to include a financial modelling test as part of the assessment, this will always be in Excel. This guide provides practical examples on concepts that are often missed by candidates when facing a modelling test and will give you the confidence to stand out in this stage of the interview process.

This guide is suitable for those preparing for an interview with a private equity fund or currently in an interview process.

It will cover a number of techniques you’ll find useful in putting together an LBO financial model during the interview including*:

  • How the financial statements are integrated
  • How to create sensitivity tables using the Excel TABLE function
  • Compound interest and inflation as a concept
  • How to convert any rate to annual, quarterly or monthly according to the timeline of the model
  • Compound Annual Growth Rate
  • Calculation of the Internal Rate of Return; and Net- Present- Value using the IRR, XIRR, NPV and XNPV Excel formulas
  • A very simple LBO example

This guide also includes two full financial modelling tests based on real examples from private equity interviews, one for an LBO model and one for a real estate investment, both with detailed solutions.

We’ll also give you six months access to an experienced financial modeller who will be able to answer any questions related to the modelling concepts and tests in this guide.

*The guide assumes that the user has a basic understanding of financial modelling and excel.

 

Price £100

Financial modelling full package

Financial modelling full training package
Format: Video and Excel eBooks

Save money and buy the LBO Financial Modelling Course and the Financial Modelling Test Training Guide in one package

     
 
Price £275

Mini tools : Platinum waterfall chart

Enhanced waterfall chart with
Format: Video and Excel eBooks

Create an impressive Waterfall chart and learn how to understand returns from a different perspective. Watch our video introduction

see video

 Add to Cart Price £10

Mini tools : Private Equity Ratchets

Private Equity Ratchets
Format: Excel eBooks

This is a great example of a Ratchet in action. Our file contains an explanation of what they are, how they work, pros and cons, and it includes a full working example of an exit event with a Ratchet linked to IRR and money multiple returns. Watch the video introduction

see video

 Add to Cart Price £10

Free Resources

Free Resources
Format: Video and Excel eBooks

Our free resources are very quick tutorials that will help you to understand generic concepts related to modelling, or specific explanations to commonly used concepts

Our mini products are based on the same principle, but we ask for a small fee to help us maintain and renew our collection. If there is a concept that you would like to understand, please let us know and we will publish a tutorial on this website

Dilution

Depreciation Tables/Net Fixed Assets

Pre and Post Money Valuation

Waterfall Chart (Value Creation)

Accounts Receivable