Model Build

Adjaye Associates

We enhanced Adjaye Associates’ daily cashflow model, reducing manual updates, saving time and minimising errors.

Flexible tool

We developed a tool that allows users to move selected cashflows to different days, weeks, or months. This enables easy updates to the model when cashflow changes are identified.

Automated integration

By implementing a process to automatically integrate cashflow data from Xero downloads into the daily timeline using power query, each cashflow is mapped to the right expenditure or income line.

Streamlined Excel ribbon

Adding a new tab on the Excel ribbon has consolidated all the macro buttons, which has made navigating the complex model and daily timeline far easier.

Challenge

Adjaye’s process for updating its daily cashflow model was laborious, inefficient and prone to error. The firm needed an improved model that incorporated automatic cash inflows and outflows based on project and cost descriptions, while maintaining flexibility to accurately reflect its operations.

Solution

We identified an enhanced Excel model was the best way forward and focussed on three key areas:

  1. Fixed payment section: For each specific expenditure, users can now specify the frequency of the cashflow, amount, start date and currency. The model schedules this cashflow to occur on the nearest working day to the specified date.
  2. Payment run section: Users can save payment run downloads from Xero to a designated folder where the model extracts cashflow data using Power Query. The user can then map each cashflow to an income or expenditure, with the model integrating these cashflows into the daily timeline.
  3. Overlay section: This enables users to manually overlay any cashflow on any date to ensure the model retains its flexibility. The user can input cash overlays in any currency, which the model translates to the reporting currency.
Results

The functionality achieved within Excel has created an accurate and effective model that Adjaye continues to use to track and forecast its daily cashflow, updating it with payment runs from Xero.

Related Success Stories
We’re trusted modelling advisors across a wide range of business industries, including 10 FTSE 100 companies and Fund Managers with over £1.75 Trillion of assets under management.
Model Audit

Basalt Infrastructure Partners

Basalt Infrastructure acquired Unilode Aviation Solutions, supported by a Model Audit from Numeritas in time intense circumstances.
Infrastructure Fund Success Story
Model Audit

Infrastructure Fund

Giving confidence to the lenders to a leading Infrastructure Fund regarding the forecasts of an acquisition target.
Model Audit

Stagecoach Rail

Providing a modelling best practice confirmation report for the rail company’s bid for the Thameslink, Southern and Great Northern franchise.

Don't miss our webinar on Tuesday 23 July

TFTCFO posdcast - episode 32 Maria Ghibu - launch graphic
Listen to - The Forward Thinking CFO Podcast
Episode 32 - Maria Ghibu - CFO & NED