Risk Assessment

Managing Risk in Revenue Forecasts: Applying Probabilistic Thinking with Excel, Part 2: Using the Revenue Estimating Risk Model


November 23, 2020

4 p.m.-5 p.m. ET

  • Field of Study: Finance
  • Credits: 1.00
  • Prerequisite: understanding of excel
  • Status: This event has availability.

This session performs a deeper dive on the revenue model covered in Part 1. We will analyze the data for such models, and how it may be stored in “libraries” for use by others. The students will learn how to answer questions that would interest local governments, particularly “what is the chance that our total revenue this year will equal or exceed our planned expenditures?” Finally, we will discuss the potential for applying the methods we have learned to other problems in public management.

This webinar is limited to 100 participants.

Who Will Benefit: CFO/Finance Director, Budget Manager, Budget Analyst/Controller/Accountant/Treasurer/Debt Manager

Learning Objectives:
  • Learn the parts of the revenue estimating risk model, particularly data “libraries” and where the data comes from.
  • See how revenue data from your own government can be used to strengthen the data libraries.
  • Load practice libraries into MS Excel and find the chance that total revenue is greater than your proposed expenditures. Also, we will try performing the analysis under different economic periods.
  • Discuss other important uncertainties and risks that should be better managed by local governments. The class will solicit one or two problems that we can use for practice as a group for a possible future session. Students will be asked to gather data that could be used for practice.  

  • Member Price: $35.00
  • Non-member Price: $50.00