Budgeting and Forecasting Tools and Techniques

Course Details

Date

Monday, November 30, 2015

7:30am – 3:00pm (Registration: 7:10am)

Location

Online

Field of Study

Accounting & Audit

CPE Credit

8 hours CPE credit

Level of Knowledge

Intermediate

Vendor

CalCPA

Prerequisites

Basic familiarity with Excel.

Description

Make sure you are maximizing the effectiveness of your budgeting and forecasting processes. Since many organizations report that budgeting and forecasting activities consume tremendous amounts of time and yield only marginal benefits, learning the best budgeting and forecasting tools and techniques will help put you and your organization ahead. In this course, you will learn how to achieve a greater return on your budgeting and forecasting activities by taking advantage of various tools and techniques easily accessible in today’s business environment.

Highlights

  • 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
  • Handling risk and uncertainty in budgets and forecasts

Objectives

  • Describe processes for obtaining budget data and collaborating with others in the budget process including: sharing workbooks; accessing Excel’s audit trail; merging workbooks; controlling and validating user input; collaborating with others on the web; and querying data from the web. 
  • Define and describe various Excel techniques for interacting with the accounting system, such as office data connections, importing text files, manipulating accounting data imported from various software applications, importing access data and open database connectivity. 
  • Identify situations in which various Excel techniques, such as using data tables for sensitivity analysis, working with Excel’s goal seek function, using SOLVER to maximize scarce resources, working with scenario manager, forecasting with regression analysis, and analyzing risk with Monte Carlo simulations, are appropriate and describe how to execute each of these techniques.
  • Describe how to use Excel in capital budgeting situations, including Excel’s present value and internal rate of feturn functions and various methods by which Excel computes depreciation.
  • Compare and contrast Excel with other applications used for budgeting and forecasting activities and describe situations in which other solutions should be used to reduce the dependency on Excel as a budgeting and forecasting solution.

Designed For

Accountants and business professionals involved in budgeting and forecasting activities.

Registration for this course has passed.

Course Pricing

WYOCPA Member Fee
$275.00

Non-Member Fee
$375.00

Your Price
$375.00

View All Professional Development Courses