Skip to content

Working capital and the average balance approach

Where working capital arises, how it affects cash flow and the balance sheet, and how to model it with the average balance approach and corkscrews.

Webinar · Recording · Presented by Brett Vandepol · 11 May 2023

Working capital workbook

The files for this topic are on our working capital tutorial page. Request them there and we send them to you by email.

Go to the tutorial

Working capital is often overlooked, but it can have a large effect on project cash flows, so any thorough analysis needs it. Modelling it accurately avoids surprises later.

This webinar explains what working capital is, where it arises and how it affects the financial statements. A worked example shows best practice for modelling it, how to apply the average balance approach and how to pick out the lines the financial statements need.

What you will learn

  1. Where working capital arises

    An introduction to working capital and where it comes from.

  2. Cash flow and balance sheet

    The effect working capital has on cash flow and on the balance sheet.

  3. The average balance approach

    The main methods for calculating working capital, with a demonstration of the average balance approach using debtor and creditor days.

  4. Corkscrew accounts

    How corkscrew accounts manage working capital and pick out the lines for your financial statements.

Learn financial modelling in a room

Hands-on courses in person and online, taught to more than 20,000 people on one modelling standard.

Best Practice Project Finance Modelling

Build and sensitise robust cashflow models from scratch, faster in Excel. Hands-on, practitioner-led, in person or online. See dates and book your place.

View full course details: Best Practice Project Finance Modelling

Advanced Project Finance Modelling

Debt sizing, covenant monitoring, DSRAs and integrated three-way statements. Hands-on, practitioner-led training, in person or online. See dates and book.

View full course details: Advanced Project Finance Modelling

Financial Model Review

Error classes, testing technique and where AI-assisted financial model review earns its place. 1-day course from our award-winning Model Audit team.

View full course details: Financial Model Review

Browse all training courses

More on this topic

Webinars

Integrated financial statements in project finance

How to build integrated three-way financial statements in a project finance model, test them as you go and keep the balance sheet balancing.

The cash flow waterfall in project finance models

How to structure the cash flow waterfall in a project finance model, add new items cleanly and see how a sensitivity moves each level of seniority.

Services

Financial Modelling Support

Modelling capacity when your team needs it, from a single rebuild to a season of refinancing runs, from the team that builds and audits these models.

Financial Model Development

Transaction and operational models built to your specification, lender-ready and documented, then handed over to your team with the logic explained.

Learn to build these models yourself

We run public and in-house courses across the full financial modelling curriculum.