Industry Models: Back Catalogue

Retail Models focus on trading intensity drivers. In turn, working capital assumptions are driven by category management as opposed to standard days turnover ratio. Retail models are likely to have additional functionality for freehold vs. leasehold performance and funding of operations footprint

RE Models have a very unique profit and loss accounting based on work-in-progress and expected profit at completion. Capital structure should account for different terms of general borrowings vs. SPV lending related to specific site. Specific attention is given to making construction costs and timeline flexible as time/cost overruns are common

If you have not seen an LBO model in real action you are unlikely to build one. As the underlying objective is to maximise returns with use of leverage LBO models have complex funding boxes similar to layout of our funding Add-on. The new leverage is then fed into elaborate cash waterfall and returns analysis for various classes of capital holders from straight equity to mezzanine warrant holders. Rest of the LBO model would not be that different from our Base Model

Download Demo

Broadly speaking Telco / Internet Models focus on customer acquisition, retention and usage. Acquisition and retention would drive marketing and CRM budgets whilst usage would determine revenues and direct costs associated with products sold. Our Revenue Add-on provides a basic idea. The wildcard - as always - is capital expenditure requirements going forward. As more disruptive technologies come to market every day it is next to impossible to forecast what level of investments is required to support usage.

Irrespective of type of minerals mined mining business is about removing soil (overburden) to get to the right stuff, extracting the right stuff from the ground and then refining the product with a particular yield. Rest is bulk logistics of getting the product to end customers. Hence, mining models deal with stripping ratios, cubes to tons and yield metrics plus costs of labour, energy, water and machinery required. Straightforward for an open pit operation but totally not transparent for an underground mine.

If you are ready to assemble your own Model go to our Main Library

For testing new business ideas try our Tools