Financial Modeling for Financial Analysis, Forecasting and Budgeting in Excel

Course details

The ever changing landscape of financial management demands that professionals entrusted with such duties equip themselves with the advanced working knowledge of financial models as a means to facilitate smoother financial analysis, forecasting and budgeting. The move to Excel financial modeling has become a globally embraced journey that has empowered thousands of leading and small businesses alike, becoming the cornerstone of both short and long term business decisions that dictate a company’s financial future.

Led by Dr. Liam Bastick, one of the Most Valuable Professionals (MVPs) in Excel bestowed by Microsoft , thisFinancial Modeling for Financial Analysis, Forecasting and Budgeting in Excel executive program is woven in a manner that is both engaging and vastly instrumental, placing emphasis on delegates gaining solid, practical experience in designing and constructing financial models in MS Excel. By turning historical data into future management information, you will be able to identify revenue opportunities, reduce or reallocate costs, explain variances, identify key drivers and ratify Key Performance Indicators (KPIs), and subsequently produce objective budgets and forecasts understood by senior management and bought into by operational and divisional heads.

This interactive two-day executive program is launched concurrently with the Strategic Financial Planning: Financial Analysis, Forecasting and Budgeting program. As both programs are designed to help you establish the right finance capabilities for your organization to pursue growth, you are encouraged to send in multiple participants to these two highly popular finance programs.

What You Can Expect

• Provide a thorough understanding of data forecasting and budgeting
• Quantify the risks and rewards of estimating future assumptions
• Explore different forecasting and trending methods
• Teach you several practical and effective ways to analyze and present key outputs
• Provide a practical process for undertaking ratio and other financial analysis

Who Will Benefit Most

CEOs, CFOs, VPs, MDs, GMs, Chief Accountants, Cost Controllers, Directors, Managers and Analysts, involved in:

• Financial Planning / Finance Business Partners / Capital Planning
• Management Accounting
• Product Control
• Planning & Budgeting
• Costing
• Forecasting & Financial Analysis
• Auditing & Internal Control
• Risk & Compliance
• Statutory & Regulatory Reporting / Policy Planning
• Business Planning / Strategic Planning / Business Development
• Operations
• Portfolio Management

and anyone with vested interests in forecasting trends at the strategic, tactical, operational and planning levels

Program Outline

DAY ONE

• Preamble
• Budgeting
• Budget management
• Variance analysis
• Risk management
• Quantification
• Forecasting in context

DAY TWO

• Getting the basics right
• Key outputs of a budget model
• Considering financing requirements
• Data analysis
• Reporting and charting
• Analyzing financials
• Further application