Deal Lab
Deal Lab
Models for buyouts on proven figures, free: change any assumption and every figure, chart and check follows in the browser. Every input links to the document it comes from.
How It Works
- Open the model of a company, or the screen of every company.
- Move any assumption: the returns, the debt and every chart follow at once, and a question mark beside each term explains it.
- Copy the link to keep the deal, or download the workbook with its live formulas.
Buyout Models
Inputs Still Missing
These companies have a page, and their model runs once the published figures give the inputs below.
- Antofagasta plc: adjusted ebitda
- Arista Networks, Inc.: capital expenditure, borrowings, lease liabilities
- BAE Systems plc: capital expenditure
- BP p.l.c.: capital expenditure
- BT Group plc: capital expenditure
- British American Tobacco p.l.c.: payments of lease liabilities
- CVS Health Corporation: payables
- Coca-Cola Europacific Partners PLC: payables
- Compass Group PLC: adjusted ebitda
- Diageo plc: capital expenditure, borrowings, lease liabilities, payments of lease liabilities
- Diploma PLC: adjusted ebitda
- Eli Lilly and Company: capital expenditure
- Endeavour Mining plc: adjusted ebitda
- Exxon Mobil Corporation: adjusted ebitda
- GE Vernova Inc.: payables
- GSK plc: adjusted ebitda
- General Electric Company (GE Aerospace): adjusted ebitda
- Halma plc: adjusted ebitda
- Informa plc: adjusted ebitda
- Intel Corporation: adjusted ebitda
- Intertek Group plc: adjusted ebitda
- Mastercard Incorporated: adjusted ebitda
- Midea Group Co., Ltd.: payments of lease liabilities
- Netflix, Inc.: receivables
- Next plc: adjusted ebitda
- PT Adaro Andalan Indonesia Tbk: payments of lease liabilities
- PT Amman Mineral Internasional Tbk: adjusted ebitda
- PT Astra International Tbk: adjusted ebitda
- PT Barito Renewables Energy Tbk: receivables, payments of lease liabilities
- PT Bayan Resources Tbk: borrowings, lease liabilities, payments of lease liabilities
- PT DCI Indonesia Tbk: borrowings, lease liabilities, payments of lease liabilities
- PT Hanjaya Mandala Sampoerna Tbk: adjusted ebitda
- PT Indoritel Makmur Internasional Tbk: adjusted ebitda
- PT Kereta Api Indonesia (Persero): adjusted ebitda
- PT Merdeka Gold Resources Tbk: adjusted ebitda
- PT Mineral Industri Indonesia (Persero): receivables
- PT Pantai Indah Kapuk Dua Tbk: adjusted ebitda
- PT Perkebunan Nusantara III (Persero): adjusted ebitda
- PT Pertamina (Persero): adjusted ebitda
- PT Perusahaan Listrik Negara (Persero): payments of lease liabilities
- PT Pupuk Indonesia (Persero): payments of lease liabilities
- PT Rajawali Nusantara Indonesia (Persero): adjusted ebitda
- PT Telkom Indonesia (Persero) Tbk: payments of lease liabilities
- PT United Tractors Tbk: adjusted ebitda
- Palantir Technologies Inc.: borrowings, lease liabilities
- PetroChina Company Limited: payables
- RELX PLC: adjusted ebitda
- RTX Corporation: adjusted ebitda
- Reckitt Benckiser Group plc: borrowings, lease liabilities, payments of lease liabilities
- Rio Tinto plc: capital expenditure
- Rolls-Royce Holdings plc: adjusted ebitda
- SSE plc: payments of lease liabilities
- Schroders plc: adjusted ebitda
- Severn Trent Plc: adjusted ebitda
- Shell plc: adjusted ebitda
- Smith & Nephew plc: capital expenditure, payments of lease liabilities
- Space Exploration Technologies Corp. (SpaceX): adjusted ebitda
- Tesco PLC: capital expenditure, payments of lease liabilities
- Texas Instruments Incorporated: adjusted ebitda
- The Sage Group plc: adjusted ebitda
- Unilever PLC: borrowings, lease liabilities, payments of lease liabilities
- United Utilities Group PLC: borrowings, lease liabilities, payments of lease liabilities
- Vodafone Group Plc: adjusted ebitda
- Zijin Mining Group Co., Ltd.: payments of lease liabilities
Principles
Proven Inputs
Every historical figure is a published value of Annalist with its document. A missing input stops the model, and the page names it; no figure stands in for it.
Named Assumptions
Each assumption shows its origin beside its value: a convention of the model, the company's own figures, or an official rate with its source and date.
No Forecast
A model opens on a steady state: revenue flat, the margin and the shares of revenue of the latest period. Growth is the user's choice.
Reproducible
The address of a deal names the company, the snapshot, the version of the model and every assumption, so it gives the same result in any later year.
One Engine
The page, the screen and the tool for agents run one definition of the model, and the release checks prove that they give the same figures.
Deal Lab computes arithmetic on published figures and on the assumptions of the user. It values no company, recommends no transaction and forecasts no result. Policy rates: Bank for International Settlements, central bank policy rates. Tax rates: OECD Corporate Tax Statistics.