Budgeting & Forecasting using Excel Workshop #2
Tuesday, February 20, 2024 - - - Time: 1 PM - 2 PM - - - 1 Hr. CPE
Speaker: Gaby Lahoud, CFA, CMA, PMP, CSCA, MBA and Co-Founder & CEO at B Certified Pro LLC & Serenity Advisors LLC
Registration link TBD
Gaby Lahoud will be presenting a 3-part workshop to advance your Excel skills for Accountants. Part 2, will focus on Budgeting and Forecasting using Excel.
Gaby frequently coaches IMA members on strategies to pass the CMA exanimation. You can register for his classes at bcertifiedpro.com.
Workshop Description:
You can’t manage what you can’t measure. Budgeting is the art of planning the next step that will get the organization closer to its goals and strategic vision.
Workshop Outcomes:
By the end of this workshop, participants will understand how to:
Ø Meet the organizational goals as well as its relationship with budgeting and forecasting
Ø Identify the budget components and explain the interrelationships among the components
Ø Prepare budgets using different techniques embedded in Excel and sources of information
Ø Evaluate, analyze & challenge quantitative as well as qualitative information
Outline:
Ø Real-life case to be practiced using Excel
Ø Differences between strategic planning, budgeting, and forecasting
Ø Building the budgeted financial model
Ø Understanding the master budget and how it is connected in Excel
Ø Forecast future performance from past relationships using Excel concepts
Ø Data manipulation to account for multiple variables
Ø Scenario and sensitivity analysis using Excel