Home / All models

CASE STUDIES

All models

Financial models, dashboards and reporting packs, each with a short video walkthrough. Pick the one closest to your situation and open it.

Cash flow & liquidity

13-Week Cash Flow Forecast & Liquidity Model

A rolling 13-week cash flow model that shows the lowest cash point, revolver need and borrowing-base headroom, week by week.

Open model →

Agency Capacity, Project Profit & Cash Model

Staffing, utilisation and project profitability for a 45-person agency, linked to IFRS 15 revenue, billing and a 13-week cash view.

Open model →

Ecommerce Inventory, Channel Profit & Cash Model

SKU-level demand, CM3 by channel and a purchase plan with deposits and transit time, so every buying and ad decision shows up in cash.

Open model →

Forecasting & planning models

CPG Integrated Planning & Forecasting Model

Monthly plan-to-cash model for a consumer goods company: gross-to-net, SKU and customer profitability, capacity, working capital and cash.

Open model →

Integrated Car Rental & Fleet Forecast Model

A five-year, three-statement model for a leased rental fleet, from vehicles and utilisation to cash, covenants and ROCE.

Open model →

Construction WIP & Project Forecasting Model

A 12-project construction portfolio model covering IFRS 15 WIP, estimate at completion, cash, bonding capacity and covenants.

Open model →

Manpower Planning & Outsourcing Decision Model

Every position costed with its country's allowances and benefits, plus an in-house, hybrid or outsourced comparison for six finance roles.

Open model →

Product-Led Growth Revenue & Cash Model

A freemium SaaS model that follows every workspace from sign-up to paid, dormant or reactivated, and on to MRR, cohorts and cash.

Open model →

Conference P&L, Break-even & Cash Timing Model

Ticket curves, sponsorship and venue deposits for three city conferences, with break-even, sensitivity and the cash timeline of each event.

Open model →

Management reporting & dashboards

CFO Financial Dashboard (Power BI)

An eight-page Power BI report that puts P&L, balance sheet, cash, receivables and payables in one interactive view for the CFO.

Open model →

Retail Management Accounts & KPI Pack

A monthly executive pack that links store, format and region performance to group profit, cash flow and working capital.

Open model →

Function Cost Centre Review: Monthly Budget vs Actual Pack

A month-end pack that shows which support functions and cost lines are over budget, by month and year to date.

Open model →

Retail Management Accounts & KPI Dashboard (Power BI)

A 17-page Power BI pack for a 68-store retailer that ties sales, like-for-like growth, margin, stock, labour and cash back to budget, forecast and last year.

Open model →

Month-End Close & Chart of Accounts Redesign

A 1,200 to 280 account redesign with full mapping, reconciliations and a close calendar that tracks the close from 15 days down to 7.

Open model →

NGO Budget, Grant & Donor Reporting Model

Six grants with their own budgets and rules, shared costs allocated across programmes, and restricted funds tracked through to donor reports and reserves.

Open model →

Deals, valuation & fundraising

Corporate Acquisition & LBO Model

A leveraged buyout model with sources and uses, PPA, debt schedule, covenants, sponsor IRR and MOIC, and a valuation football field.

Open model →

Solar & Storage Project Finance Model

A 25-year project finance model for a solar and battery plant: CFADS, sculpted debt, DSCR, LLCR and sponsor returns.

Open model →

Hotel Feasibility & Investment Model

A 220-key hotel feasibility model from market demand to USALI NOI, development financing, IRR and an LP/GP waterfall.

Open model →

Restaurant Forecast & DCF Valuation Model

A restaurant roll-out forecast with unit economics, three statements, WACC and a DCF valuation of the group.

Open model →

New Store Capital Investment Appraisal with Macro-Free Sensitivity

A 15-year new-store business case with IRR, NPV, payback and seven live sensitivities, built without macros.

Open model →

SaaS Financial Model & Series A Fundraising Plan

A five-year monthly SaaS model that links tiers, channels and cohorts to the three statements and shows runway with and without an $8m Series A.

Open model →

Cap Table, SAFE Conversion & Exit Waterfall

Converts SAFEs and a bridge note at the Series A, prices the round and shows who receives what at exit, from distress sale to strong outcome.

Open model →

NOT SURE WHICH ONE FITS?

Talk it through in 15 minutes.

Tell me what decision you need to make and I will point you to the model, or the version of it, that fits your numbers.

Book a free 15-min call ↗Free call, no obligation.