Cash Flow Simulator

Purpose: Explore scenarios and understand the impact of assumptions on cash flow.

Audience:

  • Finance
  • Treasury
  • Leadership
Screenshot of the Cash Flow Simulator showing interactive scenario controls and projected cash flow outputs for different planning assumptions.
Cash Conversion Cycle Simulator — Interactive scenario modelling tool for exploring the impact of changing assumptions on future cash flow and liquidity.

Open the cash simulator in a new tab

FTE Budget Simulator

Purpose: Explore the financial impact of staffing costs before committing to a budget.

Audience:

  • FP&A
  • HR
  • Budget holders

Built with

  • FTE Budget Model (my own)
  • HTML (with JavaScript)
  • VBA Macro to convert the data from my model into the js file for the HTML.

Why I built it Demonstrates how a traditional Excel budgeting model can be transformed into an interactive decision-support tool by separating the calculation engine from the user interface.

Screenshot of the Staff Cost Lever Lab showing interactive staffing and cost assumption controls, summary metrics, cost visualisations, commentary and validation against the source model.
Interactive decision-support tool built from an FTE budget model, allowing finance teams to explore the impact of staffing assumptions, employer costs and external changes.

Open the FTE Decision Lab in a new tab