Mobile Edition

Budgeting and Forecasting Tools and Techniques (4172978C)

Date:Wednesday, December 20, 2017
Time:9:30 AM - 5:00 PM
(Registration at 9:00 AM)
Facility:Webcast or Webinar, Online
CPE Credit:8.0 Technical Business
Instructor: Thomas G. Stephens
Vendor:California CPA Education Foundation
Course Level:Intermediate
Early Bird Price:$245.00 FICPA Members, $365.00 Non-Members


Learn how to achieve a greater return on your budgeting and forecasting activities by taking advantage of various tools and techniques. In addition to learning about how to utilize Excel more effectively, learn about Budget Maestro, PROPHIX and Host Analytics, and how reducing your dependency on Excel can lead to better results. Additionally, learn how to account for risk and uncertainty in your budgeting and forecasting models.

  • Identify processes for obtaining budget data, collaborating with others, and controlling and validating data input.
  • Identify Excel techniques for interacting with the accounting system and situations, such as sensitivity analysis, risk analysis and Monte Carlo simulations, when Excel can be appropriately implemented.
  • Determine various Excel functions, including NPV, IRR, XNPV and XIRR, in capital budgeting situations.
  • Recognize differences between Excel and other applications used for budgeting and forecasting activities.

Major Topics:
  • Using Excel more effectively as a budgeting and forecasting tool.
  • Identifying shortcomings of Excel-based budgeting and forecasting activities.
  • Implementing and working with dedicated budgeting and forecasting software applications to achieve better results in less time.
  • Managing risk and uncertainty in budgets and forecasts.

Who Should Attend:

Business professionals involved in budgeting and forecasting activities.

Fundamental knowledge of Microsoft Office Excel 2007 or newer.

Advanced Preparation:


If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.