Financial Modelling and Forecasting Using Excel

 In

DESCRIPTION

Financial Modelling & Forecasting Techniques using Excel course will enable delegates to build more powerful and more accurate forecasting models to better analyse financial data, predict revenues and costs, assess risks—and justify critical business decisions. The course will deliver competencies in the use of Financial Tools designed for Account/Finance, Risk Management and Financial Control.

OBJECTIVES:

  • Understanding the structure of financial models.
  • Creating effective financial models that meet your business needs.
  • Designing and Developing simple to sophisticated financial models
  • Integrate financial concepts with accessible but powerful Excel tools to facilitate greater analytical accuracy and rapid investment analysis.
  • Integrate financial concepts with accessible but powerful Excel tools to facilitate greater analytical accuracy and rapid investment analysis.
  • Understand different types of financial models and when each should be applied.
  • Construct flexible and reusable models which can be applied to a wide range of different investment scenarios.
  • Understand how to interpret the results of the excel models to analyse the risks and returns of the investment projects.
  • Create more powerful and accurate forecasting models that steer you to fast-track, business-improving decision making

DURATION:

2 Days

TARGET:

Financial Analysts, Executive-Level Manager, Fund Managers, Financial Managers and Consultants.

COST:

Module One

Microsoft Excel – features and application, at an intermediate level. 

  • Working with text, numeric data and dates
  • Logical functions
  • Lookup functions
  • Array functions
  • Methods of protecting worksheets and workbooks
  • Data validation
  • Data consolidation
  • Data filtering
  • Summarizing with PivotTables and PivotCharts
  • Trend and Estimation

Module Two

Overview of the Balance Sheet, Profit & Loss, Cash Flow Statement and Financial Ratios.
Microsoft Excel’s financial modelling tools & capabilities.

The use of macros & basic VBA scripting. 

  •  Recording and debugging macros
  •  Structure of VB statements
  •  Using VBA for decisions
  •  Assigning macros and VBA codes to Excel objects
  • Financial model design & construction, including Risk, Sensitivity Analysis & Optimization problems.

Module Three:

Targeting & optimization with Goal Seek & Solver

  • Understanding nature of optimization problem
  • Determining decision variables of optimization model
  • Setting goals
  • Identifying constraints
  • Optimization model formulation
  • Implementing optimization models in Excel
  • Solving and analysing optimization models
  • Binding and non-binding constraints
  • Evaluating alternatives using Scenario Manager.

Module Four  

Creating Cash and Capital Budgets using Excel.

  • Setting up cash budgets in Excel
  • Using Excel logical function to determine interest expense or income
  • Measure impact of altering timing of receipts or payments with scenario manager.

Module Five

Articulating Profit Volumes & Break-Even Analysis.

  • Nature and behaviour of costs
  • Determining units and values at break-even points and units and value to
  • Return target profit
  • Business and financial risks of a firm
  • Leverage analysis: DOL, DFL, DCL.

Module Six

Working Capital Applications, Analysis & Sensitivity Testing

  • Working capital adequacy measurement
  • Examining operating circle of a firm.