Operating Model Work

SELECTED PAST PROJECTS

Unite Group Plc (Property)

Portfolio Analytics / Five year outlook model

Large scale data aggregation exercise across x3 funds holding +180 student accommodation properties
Delivered automated dashboarding systems to Investment and FP&A Teams that provided insight into a large array of themes across the portfolio.
Redesigned the process and modelling for Five Year Planning.
The system delivered an overhaul in the board's ability to visualise its asset base

Amitis Capital (Climate Tech / Venture Capital)

Process design for a VC Fund

Lengthy six month engagement designing and developing the Project Vetting and Due Diligence process for a new investment fund
The process and protocol design was aimed at allowing a small team to manage the vast pipeline of work required in the vetting associated with VC, with a focus on: a) creating an effective filtering system that prioritised the firm's investment mandate and b) using automation to reduce individual workflows
The work delivered: a detailed project management system in Monday.com, a digital questionnaire and automated opportunity filter for the fund, a weighting system for ranking investment opportunities, a ten year corporate model using industry data to project outcome ranges, a detailed DD protocol & procedures document, a template for investment opportunity memos, the marketing prose and an IM for the fund itself

Clients' website tbd

AMITIS CAPITAL

Payaca (Industrials / SAAS)

Five year business plan

Built management a forecasting framework to understand the impact of a large array of different pricing plans for the business
The work delivered a set of forecast management accounts that required a robust understanding of the accounting practices used in SAAS businesses, alongside technically challenging features such as the projection of user account balances
Results were displayed with dashboarding and a multi-variate scenario manager
The work also included an FP&A section that facilitated automated reconciliation between budget and actuals

Sportable (sports technology)

Five year outlook model

Build a 5yr outlook model to support multi-variate scenario analysis for several different market growth strategies – supporting management’s planning initiatives
The model allowed the CEO to review vital project metrics for differing scenarios all at the same time, providing the base for more informed decision making and cash flow planning

Pragma (management consulting / airport retail)

Modelling for Heathrow Expansion Project

Worked as subcontractor on Heathrow Expansion Planning Project. The project was at a critical juncture in terms of delivery requirement and directional decision making. The business was challenged in its efforts to combine ‘revenue maximisation’ and ‘consumer experience’ as independent variables influencing a singular outcome (space allocation at Heathrow).
We helped re-structure the client's approach to the problem and provided them with the mathematic logic and framework needed to solve it

La Coquetta (retail)

Management Accounts Model

Built a set of management accounts to sync with its financial report downloads – with outputs tied into a management report pack.
Audit and reworking of internal coding system

Exane BNP Paribas (banking / IT hardware)

Equity model builds / research & analytics consultancy

Built Ericsson and Nokia models for the Tech Research Team
Models had to pass ratification process by the firm's internal bank of auditors and were used for internal research purposes and for distribution to its clients
The work included: scenario analysis, DCF and earnings metric-based valuation methodology, consulting to improve efficiency around results updating and re-forecasting process (we added a range of integrity and automation solutions)

Royal College of GP's (Healthcare)

Automate the Statutory Accounts Filing Process

Automate the Statutory Accounts Filing Process.
Project involved building a map of the existing coding structure in the financial accounts (a first time initiative for the business).
Using the map in conjunction with array-based schemes in excel to sample a new TB and automatically ‘silo’ entries into categories - that then populated a set of financial statements and notes.

Clients' website

TBN Atlantic Rainforest (Carbon Credits)

Long term planning

Financial modelling with a five year plan
The work included: Multi-variate scenario analysis, DCF valuation to help determine a range of possible outcomes for the business.

TBN Atlantic Rainforest

KAREN MILLEN (Fashion Retail)

Weekly cash flow model

Audit exiting Weekly Cash Flow Model
Redesign and build model
Integrate new model with accounting software / budgeting & forecasting process feeds (COGNOS)
Add more granular detail and control to the forecasting capacity
Ensure modelled outputs were consolidated neatly and fed into a board pack

Royal College of GP's (Healthcare)

Management Accounts Model Rebuild

Management Accounts Model Rebuild - suitable for bank lender's audit
Integrate new model with budget feed and accounting software feed
Add forecasting capacity that facilitated both detailed forecasting as well as being able to flex the model at a higher level
Added a full set of financial statements
Add tool to review debt covenant head room post covenant adjustment