K2’s Budgeting and Forecasting Tools and Techniques
Overview
Most budgeting and forecasting processes are in dire need of an overhaul. Join us in this session to learn better budgeting and forecasting methods, including using various technologies to get better results quickly.
Highlights
- Budget-centric features in Excel
- Capital budgeting techniques
- Working with Solver and Scenario Manager in budgeting and forecasting environments
- Collaboration issues, version control, and audit history
Prerequisites
Fundamental knowledge of Microsoft Office Excel 2019 or newer
Designed For
Business professionals involved in budgeting and forecasting activities
Objectives
- Utilize processes for obtaining budget data and collaborating with others when using Excel, including Shared and Merged Workbooks, Excel’s Audit Trail, controlling and validating data input, and collaborating with others
- Apply various Excel techniques for interacting with the accounting system, such as Office Data Connections, Open Database Connectivity, importing text files, and linking Internet-based data into budgeting and forecasting models
- Identify situations in which various Excel techniques are appropriately implemented, such as using Data Tables for sensitivity analysis, working with Excel’s Goal Seek feature, using Solver to maximize scarce resources, working with Scenario Manager, forecasting with Regression Analysis, and analyzing risk with Monte Carlo simulations
- Implement various Excel functions – including NPV, IRR, XNPV, and XIRR – in capital budgeting situations and identify different methods by which Excel computes depreciation
- Compare and contrast Excel with other applications used for budgeting and forecasting activities and describe conditions in which you should use other solutions to reduce the dependency on Excel as a budgeting and forecasting solution
Preparation
None
Leader(s):
Leader Bios
Brian Tankersley, K2 Enterprises LLC
Brian Tankersley is a CPA and consultant based in Knoxville, Tennessee. Brian is a frequent speaker at continuing education courses on auditing and technology for the American Institute of CPAs and K2 Enterprises, and is a senior faculty member with Becker Professional Review. Brian writes and publishes a nationally recognized blog on accounting and technology (http://blog.bftcpa.com). Tankersley’s areas of practice include accounting systems, taxation, IT consulting, and general business consulting. Prior to forming his own firm Brian practiced in public accounting with both international and local firms, as well as industry. His financial experience includes accounting & auditing, accounting system implementations, tax returns, financial analysis, inventory costing, and audits of public and private companies. Brian’s non-financial experience includes retail, wholesale, and manufacturing industry experience, technology strategy, technology management, systems implementation, technical training and documentation. Brian is both a Certified Public Accountant and Certified Information Technology Professional, and has bachelors degrees in both Accounting and Finance, cum laude, from the University of Tennessee. Mr. Tankersley has served on numerous board of directors and in leadership roles for both his church and in professional organizations. Brian is a member of the Tennessee Society of CPAs, the American Institute of CPAs, and the Information Technology Section of the American Institute of CPAs. He has also served as an officer and director for numerous area community and professional organizations. Brian, his wife Janette, and their four year old son make their home in Farragut, Tennessee. Entered 06/28/2006
Non-Member Price $415.00
Member Price $305.00