im电竞游戏入口官网(im电竞游戏选手2.5.7): Live Online or Classroom

The  classroom dates  are shown below. All other dates shown under 'Book im电竞游戏入口官网(im电竞游戏选手2.5.7)s' on the right hand side will be delivered in a live online format. 

  • London: 24 Oct

im电竞游戏入口官网(im电竞游戏选手2.5.7) Objectives  CPD Certified

This practical course applies Excel within a financial framework to explore how forecast financial models can be efficiently created and modified. The efficient use of Excel is key so the course starts by ensuring participants can quickly and accurately harness Excel’s tools and functionality. We then apply these skills to best practice modeling guidelines to build, and then flex, the structure and modules of a forecast model.
 
Key Learning Outcomes:
  • Optimize their Excels skills when creating financial models
  • Design and construct useful and robust financial modeling applications
  • Apply efficient financial forecasting techniques
  • Create a comprehensive 3 statement financial model
  • Incorporate a debt schedule with a revolver and circularities

Who Should Attend

Professionals in corporates and financial institutions who need to create useful and robust financial models. Attendees should be able to use the basic facilities of Microsoft Excel and have basic accounting knowledge. 

Certificate Option

This course can also be taken alongside Best Practice Financial Modeling to form the  Certificate in Financial Modeling.

Day One
Excel Skills for Modeling

Excel can be used like a calculator. This session converts participants to using Excel in best practice ways for modeling so that repeatable, consistent, flexible and robust formulae and structures can be created.

  • Effective use of keyboard shortcuts
  • Dynamic referencing
  • Formatting data professionally
  • Style basics
Introduction to Modeling

What are the key attributes of a model. Starting the design of a model focused on the required outputs will allow us to work backwards to understand what modules are required to get to this point. However, the structure must allow flex – things change.

  • Effective construction of a model
  • Objective and structure
  • Initial preparation
The Fundamentals of Model Building

Applying best practice approaches we create a model required for analysis, and then add create some forecasts

  • Model set up
    • Consistent sheet and print set-up
    • Input vs formulas
    • Inputting base data
  • Key Excel functions and tools
    • IF (and other logicals) with flags
    • Setting up date flexibility throughout the model using EDATE or EOMONTH
    • Text strings
    • Conditional formatting
  • Adding the financial data
    • Data transfer and links
    • SUMIF and data validation to extract the relevant data
    • Breakdown and grouping of accounting elements
    • Determine drivers of the forecasts
    • Using Excel tools to identify trends
    • Effectively creating assumptions for projections
  • Model diagnostics and checks
    • Identifying what could go wrong and flagging up any errors
Three Statement Model

Learn how to construct a complete 3 statement financial model.

  • Income statement
  • Revenue
  • Cost of sales, distribution costs and administrative costs
  • Interest expense
  • Taxation
  • Balance sheet
  • Intangibles:
    • Internally developed
    • Amortization
  • Property, plant and equipment (PPE):
    • Capex
    • Depreciation
    • Capex/deprecation
  • Working capital:
    • Working capital assumptions
    • Inventories
    • Trade Receivables
    • Other receivables
    • Operating cash
    • Trade payables
  • Equity and Retained Income
  • Equity and share premium        
  • Cash flow statement
  • Balancing the balance sheet
Debt Schedule
  • Beginning cash
  • Cash from operations
  • Dividends
  • Mandatory payments
  • The revolver kicks in if the cash movement is negative
Auditing and Debugging
  • Simple modelling tools to check and audit your, or someone else’s model