Skip to content

Operational models for asset management

How SPV managers, model users and investors build operational models that link to accounting software, take in actuals and support reporting.

Webinar · Recording · Presented by Ajit Chandra · 12 March 2020

This webinar shows special purpose vehicle (SPV) managers, model users and investors how to build and maintain operational financial models that hold up under real reporting demands. It demonstrates the functions needed to link an operational model with management accounting software, walks through practical ways to bring historical financial statements (actuals) into a live model, and covers the challenges SPV teams face as a model moves from forecast to tracking actual performance.

What you will learn

  • A full operational model. A complete SPV operational model in action, with switches, integrity checks and other functions that keep it reliable at scale
  • Common SPV modelling challenges. The recurring problems SPV managers and investors meet when they rely on operational models for day-to-day decisions
  • Linking to accounting software. A practical demonstration of connecting an operational model directly to management accounting systems
  • Reporting from the model. How to structure a model so it supports investor reporting, covenant tracking and management reporting without duplicated work
  • Bringing in actuals. Different ways to bring historical financial statements into a model, with the trade-offs of each

Questions

What is an operational financial model for an SPV?

A model that tracks a special purpose vehicle’s financial performance against forecast, takes in actuals and supports investor and management reporting.

How do you bring actuals into a financial model?

There are several approaches, from manual periodic updates to direct links with accounting software. The webinar compares them.

Learn financial modelling in a room

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

Deal Model to Operational Model Mastery

Transform your understanding of operational models by mastering the deal model to operational model techniques in our intensive training.

View full course details: Deal Model to Operational Model Mastery

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

Browse all training courses

More on this topic

Webinars

Operational models after financial close

Operational models for running assets.

From transaction model to operations model

Turning a transaction model into an operations model.

Services

Financial Modelling Support

Modelling support for your team when you need extra capacity.

Learn to build these models yourself

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