16BFT: K2's Budgeting and Forecasting Tools and Techniques
If you have questions about this event, please call us at 952-831-2707.
Monday, June 27, 2016
8:30am - 4:30pm Central Time
8 CPE (8 technical)
Minnesota Society of CPAs, Bloomington
If your budgeting and forecasting processes take too long and only provide minimal benefit, it's time to turn things around. Get the practical, how-to guidance you need to achieve a better return on your budgeting and forecasting activities. Learn how to use Excel more effectively for budgeting and forecasting, and explore other timesaving tools such as Budget Maestro, PROPHIX and Host Analytics. Discover how you can get better results when you reduce your dependency on Excel, learn how to account for risk and uncertainty in your models, and much more.
Find out if this class is right for you. Take the online assessment.
Major subjects
-
How to obtain budget data and collaborate with others -- shared workbooks, audit trail, merged workbooks, and controlling and validating data input
-
Excel techniques for interacting with your accounting system -- Office data connections, open database connectivity, importing text files, and linking Internet-based data to budgeting and forecasting models
-
How to use data tables for sensitivity analysis
-
How to work with the goal seek feature
-
How to use solver to maximize scarce resources
-
How to work with scenario manager
-
How to forecast with regression analysis
-
How to analyze risk with Monte Carlo simulations
-
How to use Excel in capital budgeting situations, including methods to compute depreciation
-
Shortcomings of Excel-based budgeting and forecasting tools
-
Working with dedicated budgeting and forecasting software applications to achieve better results in less time
-
Methods for managing budgeting and forecasting risk and uncertainty
Learning objective(s)
-
Understand tools and techniques in Excel and other software applications to improve your budgeting and forecasting processes
Who should take this program?
CPAs, accountants and financial professionals involved with budgeting and forecasting
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$349.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Standard Member Fee |
$299.00
|
Standard Nonmember Fee |
$349.00
|