Example Models
This page provides examples of best practice models which have been developed using bpmToolbox. They have been provided to demonstrate the implementation of the Best Practice Spreadsheet Modelling Standards, and should not be viewed as in any way limiting the scope of the application of bpmToolbox. The examples have been grouped into the following categories:
Check this page regularly for updated model examples and feel free to contact us for more examples of best practice models, or to discuss any of the example models provided below.
Financial Statements Models
The following workbooks provide examples of selected components used to build whole-of-business financial statements models, as well as a comprehensive whole-of-business model which demonstrates the combined use of these components. These models are forecast-only examples and cover a wide range of components, from basic revenue projections to more comprehensive components including assets, debt, equity and discounted cash flow valuations.
Income Statement Examples
The following models provide examples of operational modelling, revenue, expense and income statement modelling.
| Model | Description | Download | ||
|---|---|---|---|---|
| 1. | Volume Example | • | Forecasts volumes for a number of categories (e.g. cars manufactured, tyres manufactured, etc) allowing for potential relationships between volume categories (e.g. tyres per car manufactured, etc). |  |  |
| 2. | Simple Revenue Example | • | Forecasts sales revenue based on assumed sales prices and volumes. | | |
| 3. | Complex Revenue Example | • | Forecasts sales revenue based on sales prices multiplied by volumes, with both sales prices and volumes being forecast based on assumed amounts and growth rates over time. | | |
| 4. | Revenue Inflation Example | • | Forecasts sales revenue based on assumed real sales prices multiplied by volumes, with both sales prices and volumes being forecast based on assumed amounts and growth rates over time. | | |
| 5. | Gross Margin Example | • | Forecasts the gross margin of a business based on forecast sales revenue and cost of goods sold (COGS). Sales revenue and COGS are both forecast based on forecast prices/costs and volumes, with assumptions being entered as amounts and growth rates over time. | | |
| 6. | Income Statement Example | • | Forecasts the income statement of a business, including revenue, cost of goods sold, operating expenditure, depreciation & amortization, debt interest expense and tax expense. | | |
| 7. | Taxation Example | • | Forecasts corporate tax expense, tax payable and tax paid based on assumed assessable revenues and expenses, allowing for potential tax losses and, deferred tax assets and deferred tax liabilities. Also includes a reconciliation of the financial statement impacts of these elements of the taxation analysis. | | |
Balance Sheet Examples
The following models provide examples of working capital modelling, simple debt and equity schedules and comprehensive book asset examples.
| Model | Description | Download | ||
|---|---|---|---|---|
| 1. | Revenue Working Capital Example | • | Forecasts accounts receivable closing balances on the balance sheet based on forecast revenue and debtor days assumptions which determine the timing of the cash receipt of this revenue. | | |
| 2. | Expense Working Capital Example | • | Forecasts accounts payable closing balances on the balance sheet based on forecast cost of goods sold, operating expenditure and creditor days assumptions which determine the timing of the cash payment of these expenses. | | |
| 3. | Book Assets Example | • | Forecasts the opening balance, capital expenditure, depreciation and closing balance for a number of book assets categories. Capital expenditure assumptions are entered as amounts and growth rates over time, whilst depreciation is calculated based on asset life assumptions including the depreciation method and term. | | |
| 4. | Book Intangibles Example | • | Forecasts the opening balance, capital expenditure, amortisation and closing balance for a number of book intangibles categories. Capital expenditure assumptions are entered as amounts and growth rates over time, whilst amortisation is calculated based on asset life assumptions including the amortisation method and term. | | |
| 5. | Debt Example | • | Forecasts the opening balance, drawdowns, repayments and closing balances for a number of debt categories. Also forecasts interest expense, interest payable and interest paid for each of these categories, whilst allowing for the potential amortisation of debt refinancing fees. | | |
| 6. | Equity Example | • | Forecasts the opening balance, issuances, buy-backs and closing balance of an ordinary equity account. Also forecasts dividends declared, dividends payable and dividends paid for this ordinary equity account. | | |
DCF Valuation Examples
The following models provide a number of comprehensive discounted cash flow (DCF) valuation examples, allowing for both equity and enterprise valuations.
| Model | Description | Download | ||
|---|---|---|---|---|
| 1. | Equity Valuation Example | • | Provides a pre-tax or post-tax equity discounted cash flow (DCF) valuation allowing for either (1) an equity value being calculated based on an assumed discount rate or (2) an internal rate of return (IRR) being calculated based on an assumed equity value. | | |
| 2. | Enterprise Valuation Example | • | Provides a pre-tax or post-tax enterprise discounted cash flow (DCF) valuation allowing for either (1) an enterprise value being calculated based on an assumed discount rate or (2) an internal rate of return (IRR) being calculated based on an assumed enterprise value. | | |
Whole-Of-Business Example
The following model provides a comprehensive example, covering all of the elements demonstrated in the above examples.
| Model | Description | Download | ||
|---|---|---|---|---|
| 1. | Whole-Of-Business Example | • | Comprehensive example model including all the components from the above examples in an integrated financial model. | | |
Business Planning Models
The following models provide examples of best practice business planning models built using bpmToolbox. Business planning models usually include the analysis of financial statements over a number of time series periods, often allowing for both historical and forecast data based on assumptions entered by the managers of the underlying business.
Forecast Business Planning Models
The following models provide examples of forecast best practice business planning models - i.e. models with a single time series over which data is being analyzed, usually for projecting data without allowing for comparisons with historical data:
| Model | Description | Download | ||
|---|---|---|---|---|
| 1. | Forecast Business Planning Model Example (Basic) | • | Basic forecast business planning model demonstrating the creation of dynamic financial statements (i.e. Income Statement, Balance Sheet and Cash Flow Statement) based on a set of forecast assumptions. | | |
Historical & Forecast Business Planning Models
The following models provide examples of best practice business planning models which analyse data on both a historical and forecast basis, with data for all periods also being presented. Most business planning models include both historical and forecast analysis as a means of 'sanity checking' forecast against actual data:
| Model | Description | Download | ||
|---|---|---|---|---|
| 1. | Historical & Forecast Revenue | • | Demonstrates the use of data and projections time series sheets in bpmToolbox to collect historical and forecast revenue assumptions and show the outputs on a single output sheet. | | |
| 2. | Historical & Forecast Business Planning Model Example (Basic) | • | Basic historical and forecast business planning model demonstrating the creation of dynamic historical and forecast financial statements (i.e. Income Statement, Balance Sheet and Cash Flow Statement) based on a historical and forecast assumptions. | | |
Dashboard Outputs
The following models provide examples of dashboard outputs. Dashboard outputs are included within the output section of a best practice model (usually using bpmToolbox presentation sheets and styles) and provide a tabular and/or graphical summary of designated model outputs based on a specific target audience. The Create Dashboard Template tool within bpmToolbox makes it possible to efficiently develop high-quality dashboard outputs.
| Model | Description | Download | ||
|---|---|---|---|---|
| 1. | Business Unit Analysis | • | A4 landscape dashboard displaying revenue and earnings for multiple business units. | | |
| 2. | Current Year Monthly Performance | • | A4 landscape dashboard displaying monthly current year revenue, cost of goods sold, operating expenditure and capital expenditure, differentiating actual, budget, forecast and last year. | | |
| 3. | Merger Overview | • | A3 landscape dashboard displaying consolidated annual financial information segregated by target and acquiror. | | |
| 4. | Project Summary | • | A3 landscape dashboard displaying selected annual financial performance metrics for a project. | | |
| 5. | Regulatory Revenue Analysis | • | A3 landscape dashboard displaying selected performance and efficiently outputs for a regulated business, including building blocks, RAB and out-performance analysis. | | |
6. | Revenues & Expenses by Business Unit | • | A4 portrait generic dashboard displaying divisional revenues and expenses presented via cumulative waterfall charts. | | |
Powerful Charts
The following models contain examples of the sophisticated use of charts within Microsoft Excel. These charts can be included in custom-built dashboard outputs to visually communicate the outputs of best practice models to model users:
| Model | Description | Download | ||
|---|---|---|---|---|
| 1. | Multi-Stack Waterfall Chart | • | Demonstrates the use of a stacked column graph to show the movements in a designated item from one point in time to another - e.g. breaking out the composition of an increase in operating expenses from one year to the next. | | |