Skip to content

Mastering timing flags in an Excel financial model

How timing flags give a financial model transparent, flexible logic for financial close, construction, operations and regular events such as maintenance.

Webinar · Recording · Presented by Brett Crockett · 17 December 2018

Timing logic that holds up

Almost every financial model has important logic tied to timing events. Common ones are the financial close date in project finance, the transaction date in M&A, construction start on a greenfield project and recurring events such as maintenance capex.

Working in a structured way with timing flags makes this logic transparent and flexible. Decision makers can trust the forecasts more, and modellers can build more functionality faster and with fewer errors.

What you will learn

  • A reusable structure for setting up timing phases quickly, such as construction and operations
  • The flow of logic from assumptions to timing, calculations and outputs
  • Regular events, using maintenance capex as the example (a set spend every few years)
  • How timing phases add flexibility to a model, for planning, delays and earn-outs
  • How to control timing events with a scenario manager, to compare commercial outputs quickly

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

Tips and tricks to work smarter in Excel

Excel techniques that make model work faster: formula tracing, Go To Special, the settings worth changing, quick charts and aligning objects to grid.

Managing circular references in financial models

The circular references that appear in financial models, the errors they cause and the best practice ways to keep them out of a model without VBA.

Services

Financial Model Development

Transaction and operational models built to one modelling standard, documented for lenders and investors and handed over with the logic explained.

Financial Model Audit

An independent opinion on the model behind your transaction, with a red flag report on any show-stopper issues in under 5 working days.

Learn to build these models yourself

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