Building a dynamic, scenario-based forecast

A modern forecast that is dynamic and flexible can significantly improve your ability to account for multiple scenarios and assess the impact of business decisions.

Event Details

Location and date:
Online May 10, 2018 - 12 p.m. - 2 p.m. EST

A modern forecast needs to be dynamic and flexible, considering multiple scenarios so you can predict their impacts on your business in both the short and long run. Unfortunately, today’s budget processes are usually slow and static, and attempting to change most models is a tedious process.

It is a common scenario that upon completion of the upcoming year’s business plan and budget, the leadership team decides to consider two or three major initiatives midway through the year, and wants to see the projected impact of each one on the budget for this year as well as the following fiscal years.

It is a challenge to build the scenarios in a flexible manner, with the ability to include or remove each scenario as required by management. The solution is to build a dynamic scenario-based forecast that allows for this type of flexibility, which is so necessary in today’s fast-paced, constantly changing business environment.

This virtual classroom will use a case study to build a robust rolling forecast model, account for multiple scenarios, and show how to add or remove scenarios easily. The goal is to effectively integrate scenario planning into your forecasting process, allowing you to make effective business decisions using a dynamic and flexible forecast.

The virtual classroom is an online learning platform that allows you to connect with experts and your peers to ask questions, share ideas and participate in real time. It is a premium digital experience, featuring live group work and an interactive case study to reinforce concepts.

Note: Space is limited to the first 25 people who register.

Additional options and pricing may be available. See pricing and registration for more details.



$395.00

3 CPD hour(s)
Pricing & registration

You will learn about:

  • building a high-level baseline forecast
  • creating a dynamic rolling forecast model
  • adding scenarios to a baseline model and incorporating scenarios in the rolling forecast
  • measuring the impact of various business scenarios on the bottom line (or other applicable metric)
  • understanding key steps needed to tailor the template to different situations

Participants will use an Excel-based model for the classroom and will receive a copy of the Excel file(s) as a take-away. This will allow participants to test their own scenarios and build a template that is potentially applicable to their individual situations.

Who should attend?

  • middle management and staff responsible for budgeting and forecasting in a for-profit environment
  • consultants and business advisors

More Details:

Speakers/Presenters
Venue[s] and Accommodation[s]

Venue[s]:

Webinar


Contacts

Please contact:

Member Development and Support
Tel: 1-800-268-3793
Email: customerservice@cpacanada.ca