OUR GALLERY
It is truly a beautiful artform when financial models and visual reports inform strategic decision making.
These are some examples of the types of deliverables produced for clients.
(Figures and labels have been fictionalised to protect confidentiality)
SCENARIO ("WHAT-IF") MODELLING
This interactive dashboard is the control centre of the financial model for this business.
Countries and Products can be switched on and off using buttons at the top, key drivers can be changed down the left, and the results seen in real-time in the form of charts, maps and a mini Income Statement showing revenue, cost and profit. The complex underlying model includes monthly reconcialtion to accounting systems, revenue by product and country, staffing, cashflow, balance sheet and full P&L.
​
​
Note: All figures and labels have been fictionalised to protect confidentiality.
PRICING MODEL
By modelling out all key components of revenue and cost, and building in factors such as utilisation and efficiency, our client could do "what-if" scenarios on pricing, ultimately finding the balance that produced a target EBIT of 25%.
​
Note: All figures and labels have been fictionalised to protect confidentiality.
GLOBAL EXPANSION MATRIX
The Board used this interactive matrix to discuss the relative importance of the factors on the left to be changed and see how the countries move on the chart.
​
We compare market attractiveness (based on 10 factors) with our ability to compete (based on 4 factors). In this (fictionalised) case, Canada, Indonesia and Japan are our 3 key markets for expansion. Russia and Germany are attractive, but we may need to find a partner to help enter those markets.
WHERE ARE OUR HIGH-VALUE CUSTOMERS?
We overlaid maps of where customers live against factors such as income, average land size, where families live, the presence of swimming pools, and more, to visually identify patterns of data that bring the underlying statistics to life.​
SCENARIO ("WHAT-IF") MODELLING
This what-if model was used to analyse scenarios and impact on EBIT of a change in product, pricing, discounting and global expansion.
​​
​
Note: All figures and labels have been fictionalised to protect confidentiality.
NEW-FORMAT STORE PLANNING
("WHAT-IF" MODELLING)
The complexity of 30 tabs in this model is hidden by the simplicity of a single simulator.
The challenge was to find a workable balance of pricing, product mix and costs that produced profitable stores in a format new to the group.
​​​
​
Note: All figures and labels have been fictionalised to protect confidentiality.
MARKET SIZING
Based on readily data sets from the Austrakian Bureau of Statistics, Reserve Bank of Australia, APRA and others, a model pulled together the Total Addressable Market, Service Obtainable Market and Target Market as the basis for this company's strategy.
​​​
​
Note: All figures and labels have been fictionalised to protect confidentiality.
FINANCIAL PLANNING & ANALYTICS
This is the summary dashboard of the FP&A function in this company. Annual budgets are set by strategising on the key drivers (top/left), with results seen in the mini P&L on the right. Within the other 50 tabs of the file, monthly actuals and rolling reforecasts show deep analytics including Saas metrics, product P&L, balance sheet, cashflow, product profitability, staffing, cost reduction projects, growth project analysis, M&A activity and more. Actuals are integrated monthly from regional accounting systems and board reports generated automatically.​​
​
Note: All figures and labels have been fictionalised to protect confidentiality.
