My Profile   |   Contact Us   |   Your Cart   |   Sign In
Webcast: Budgeting and Forecasting Tools and Techniques (CABFT15)
Tell a Friend About This EventTell a Friend
 

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.

11/30/2015
When: 11/30/2015
8:30 AM until 4:00 PM
Where: Webcast
Louisiana
United States
Presenter: Thomas G. Stephens, Jr., CPA.CITP


Online registration is closed.
« Go to Upcoming Event List  

Registration Fees
Members $275
Non-Members $375

CPE: 8 hours
Level: Intermediate
Vendor: CalCPA
Category: Accounting & Auditing
Prerequisites: Basic familiarity with Excel.
Advanced prep: None

Who should attend: Accountants and business professionals involved in budgeting and forecasting activities.

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.

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.

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


Community Search
Sign In


Forgot your password?

Not a member? Join now!

News & Tax Alerts
CPE/Events

Society of Louisiana
Certified Public Accountants

2400 Veterans Memorial Blvd., Suite 500
Kenner, LA 70062-4739

504.464.1040
800.288.5272 Map/Directions


Advertise/Exhibit

Classifieds

CPA Locator

Press Room

Staff Directory

Facility Rental

Privacy & Terms

About LCPA