LBO Modelling

A route to building buyout models you trust: workspace and conventions, sources and uses, the operating case, debt schedules, returns and sensitivities, review routines, tests and the specialist structures seen on live deals.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for LBO Modelling, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

💹 Private Equity & Venture Capital

LBO Modelling

Building buyout models: sources and uses, operating case, debt schedule, returns and sensitivity tables, and checking the model before it reaches committee.

  1. Modelling workspace and Excel settings set-up
  2. Formatting and colour convention standard for models
  3. How buyout returns are made, from first principles
  4. Paper LBO in fifteen minutes
  5. Transaction assumptions page
  6. Sources and uses table built from scratch
  7. Historical financials spread into model format
  8. Personal clean LBO template
  9. Modelling reading and reference shelf
  10. Weekly timed modelling drills
  11. Model version control and file naming routine
  12. Pre-send model review checklist
  13. Modelling error log and root causes
  14. Rates and debt terms reference refresh
  15. Public precedent multiples file
  16. Live deal model maintenance during a process
  17. Monthly peer model swap
  18. Quarterly rebuild from a blank sheet
  19. Operating case built from revenue drivers
  20. Three-statement linkage inside an LBO
  21. Debt schedule with amortisation and cash sweep
  22. Revolver, minimum cash and circularity switch
  23. Returns calculation with IRR and multiple of money
  24. Sensitivity tables that move correctly
  25. Credit statistics and covenant headroom tab
  26. Tax lines in the buyout model
  27. Returns attribution bridge
  28. Base, upside and downside cases with a scenario switch
  29. Comparing debt structure options in the model
  30. PIK notes and preferred equity in the structure
  31. Management rollover and incentive dilution in returns
  32. Working capital and capex assumptions grounded in history
  33. Fees and financing cost treatment
  34. Buy-side modelling test preparation
  35. Take-home case study with written recommendation
  36. Committee-ready model freeze
  37. Lender case delivered to debt providers
  38. Price capacity model for a final round bid
  39. Post-close rebase to the actual closing balance sheet
  40. Student's first LBO from a public take-private
  41. Moving from banking models to buy-side models
  42. Supervising an analyst's model build
  43. Bolting an add-on acquisition into the platform model
  44. Small company LBO with seller note and earn-out
  45. Return-to-modelling refresh plan
  46. Dividend recapitalisation and refinancing analysis
  47. Carve-out LBO with standalone cost build
  48. Take-private model with public company mechanics
  49. Cross-border LBO with currency in the model
  50. Independent audit of a complex deal model

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Modelling workspace and Excel settings set-up

Half of the slow, error-prone modelling people blame on skill is really a badly set-up machine: automatic calculation switched off by accident, iterative calculation left on so circular errors hide, a mouse doing what the keyboard should. Spending one session fixing settings, add-ins and the ribbon means every model you build afterwards starts from the same reliable base.

First tasks

  • Check calculation mode and iterative calculation settings in Excel options
  • Write a one-page list of the twenty shortcuts you use most
  • Install and test any modelling add-in your firm or course provides
  • Save a default workbook style with your fonts and number formats

Formatting and colour convention standard for models

Reviewers should be able to tell an input from a formula from a link to another sheet without clicking a single cell. Writing down one convention, such as blue hard-codes, black formulas and green cross-sheet links, plus rules for units, signs and timeline headers, makes your models readable to partners, lenders and your future self.

First tasks

  • Ask whether your firm or course already has a house modelling style
  • Write the colour, unit and sign rules on a single page
  • Add a legend tab to your template that shows each convention
  • Reformat one old model to the standard and note what felt awkward

How buyout returns are made, from first principles

Every LBO return comes from three places: growth in earnings, a change in the multiple paid at exit versus entry, and debt repaid from the company's own cash. Students and new associates who can explain those three drivers, and the role equity cheque size plays, build models that answer the right question instead of just balancing.

First tasks

  • Read one standard textbook chapter on how leveraged buyouts create returns
  • Write a one-page summary of the three return drivers in your own words
  • Work a simple two-scenario example by hand showing the effect of more debt
  • Compare IRR and multiple of money for a three-year and a six-year hold

Make it yours.

Install LBO Modelling, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.