www.euromoney.com Open in urlscan Pro
45.60.13.165  Public Scan

Form analysis
2 forms found in the DOM

Name: search — /learning/course-search

<form class="search__form" name="search" action="/learning/course-search">
  <div class="search__button"><button class="main-button main-button_theme_blue main-button_icon_search" data-disabled="true"><span class="main-button__text"></span></button></div>
  <input class="search__input" name="term" placeholder="Course search">
</form>

https://checkout.euromoney.com/

<form class="main-form" action="https://checkout.euromoney.com/">
  <h3 class="course-detail__title">Course details</h3>
  <div class="course-detail__inner-wrapper">
    <div class="course-detail__inner">
      <ul class="course-detail__list">
        <li class="course-detail__item">
          <div class="course-detail__label">Location</div>
          <div class="course-detail__value">London , UK</div>
        </li>
        <li class="course-detail__item" data-select="true">
          <div class="course-detail__label course-detail__label_select">Date</div>
          <div class="date-select">
            <div class="date-select__inner"><button class="date-select__selected" type="button">
                <div class="date-select__dates">03-05 Jul 2023</div>
                <div class="date-select__small-arrow"></div>
              </button>
              <ul class="date-select__unselected">
                <li data-value="200253775"><button class="date-select__item" type="button">
                    <div class="date-select__dates">27-29 Nov 2023</div>
                  </button></li>
              </ul>
            </div>
            <div class="locker-inner"></div>
          </div>
        </li>
        <li class="course-detail__item">
          <div class="course-detail__label">Duration</div>
          <div class="course-detail__value">3 days</div>
        </li>
        <li class="course-detail__item">
          <div class="course-detail__label">Price</div>
          <div class="course-detail__value">£3645 + VAT</div>
        </li>
      </ul>
    </div>
  </div>
  <div class="course-detail__expired-description">Dates are currently being finalised. Get in touch to find out more</div>
  <div class="course-detail__request-button">
    <button class="main-button main-button_theme_blue">
      <span class="main-button__text">Request more information</span>
    </button>
  </div>
  <div class="course-detail__request-more-info">
    <div class="pardot-popup">
      <iframe src="https://bankingfinance.euromoney.com/l/426822/2018-10-22/27dl4v"></iframe>
    </div>
  </div>
  <div class="course-detail__cart-button">
    <button class="main-button main-button_theme_blue"><span class="main-button__text">Book now</span></button>
  </div>
  <a href="#" class="course-detail__brochure-link">
                <span class="course-detail__brochure-link-text">Download course brochure</span>
                <div class="course-detail__pdf-form" data-url="https://bsp.euromoney.com/api/CourseBrochureApi/Post/" data-callurl="//www.euromoney.com/learning/fin755/financial-modelling-school-module-1-best-practice-financial-modelling-in-excel-?utm_medium=email%20marketing&amp;utm_source=marketo&amp;utm_campaign=eml_bb-financialmodellingschool_2023-03-16&amp;utm_content=textlink&amp;mkt_tok=Mzc2LUtWVi0xNzcAAAGKiKJlt8I56tkqVtDje2QLYfW_MGsGhg6FWDgodEfw9V1QVz0JbTLZ9-oeK7Z-8Gmwd5qf924x6jkfnJX8DoV381huhT_amEGvQH53Et90GDHDFg" data-courseurl="//www.euromoney.com/learning/fin755/financial-modelling-school-module-1-best-practice-financial-modelling-in-excel-?utm_medium=email%20marketing&amp;utm_source=marketo&amp;utm_campaign=eml_bb-financialmodellingschool_2023-03-16&amp;utm_content=textlink&amp;mkt_tok=Mzc2LUtWVi0xNzcAAAGKiKJlt8I56tkqVtDje2QLYfW_MGsGhg6FWDgodEfw9V1QVz0JbTLZ9-oeK7Z-8Gmwd5qf924x6jkfnJX8DoV381huhT_amEGvQH53Et90GDHDFg" data-coursetitle="Financial Modelling School: Module 1 - Best Practice Financial Modelling in Excel ">
                    <div class="pdf-form"><iframe src="https://bankingfinance.euromoney.com/l/426822/2018-04-03/23c5w3"></iframe></div>
                </div>
            </a>
  <button type="button" class="course-detail__call-back">
    <span class="course-detail__call-back-text">Arrange a call back</span>
  </button>
</form>

Text Content

 * About
 * Contact


Request A Call


 * Our Expertise
   Topics
   
   With unique access to the latest industry news, insights and analysis, we
   deliver highly relevant and engaging learning programmes with a lasting
   impact. 
   
   Banking & Finance
   
   --------------------------------------------------------------------------------
   
    * Audit, Accounting & Finance
    * Aviation & Shipping Finance
    * Capital Markets & Derivatives
    * Corporate Finance
    * Credit & Corporate Banking
    * Financial Risk Management
    * FinTech
    * Governance, Risk & Compliance (GRC)
    * Investment & Asset Management
    * Islamic Finance
   
    * Project & Infrastructure Finance
    * Real Estate Finance
    * SME & Retail Banking
    * Trade Finance
    * Treasury & ALM
   
   Professional Development
   
   --------------------------------------------------------------------------------
   
    * C-Suite & Board Education
    * Leadership & Management Development
    * Relationship Management
   
   Energy, Metals & Legal
   
   --------------------------------------------------------------------------------
   
    * Energy Training
    * Legal
    * London Metal Exchange Training

 * Corporate Solutions
 * Courses
 * euromoney.com

 * Home
 * Banking & Finance
 * Corporate Finance
 * Financial Modelling School: Module 1 - Best Practice Financial Modelling in
   Excel


COURSE DETAILS

 * Location
   London , UK
 * Date
   03-05 Jul 2023
   
    * 27-29 Nov 2023
   
   
 * Duration
   3 days
 * Price
   £3645 + VAT

Dates are currently being finalised. Get in touch to find out more
Request more information

Book now
Download course brochure

Arrange a call back


EUROMONEY LEARNING ON-DEMAND

Powered by Finance Unlocked



Learn about every aspect of finance, delivered through one-off videos and
in-depth pathways

Learn More

VAT ON VIRTUAL AND ONLINE PROGRAMMES

VAT is applicable on virtual programmes to delegates attending from the UK*. If
participating from the EU, a valid VAT number is required to ensure VAT will not
be charged under the reverse charge mechanism. VAT is not applicable to
attendees from all other countries.
*For virtual courses ran through our Asia office, VAT may be applicable to HK
and Singapore residents only. Find out more by contacting learning@euromoney.com
Claim back your VAT on our In-person Public Courses

 


CLAIMING BACK YOUR VAT

All attendees of a London based course incur VAT as a part of the cost of
attendance.

Euromoney Learning have partnered with VAT IT to allow you the unique
opportunity to recoup the VAT incurred.

Using VAT IT's extensive experience and simple sign-up and refund process, every
invoice can be turned into cash for your business.


Claim the VAT that's rightfully yours in four simple steps:





1. Register your interest



2. Sign a few simple documents



3. VAT IT processes your claim



4. Receive your refund








Why choose VAT IT 

VAT IT have spent two decades identifying, researching and perfecting the
foreign VAT Reclaim process and built the best back end technology in the
industry. By partnering with Euromoney Learning, we can provide you with a fast
and effective way to reclaim your VAT which helps reduce the cost of your
training.

VAT IT will charge a percentage of the VAT refund if/when it is successful. 


Can I claim back the VAT myself?
You can claim back VAT directly from the UK Tax Authority (HMRC) by completing
the following form. 
For European clients, please refer to form VAT 65. 
All other clients, please refer to form VAT 65A.

 * For EU businesses
 * For non-EU businesses

 

You may also be able to claim back your VAT against courses taking place outside
of the UK, and we would recommend contacting VAT IT, our specialist partner, to
discuss how to do this.


FINANCIAL MODELLING SCHOOL: MODULE 1 - BEST PRACTICE FINANCIAL MODELLING IN
EXCEL

Join this comprehensive course on financial modelling from basic to advanced
modules using excel.
 * Overview
 * Agenda
 * Inhouse
 * Why us

 * The Financial Modelling School is made up of 2 individually bookable modules
   
   Financial Modelling School: Module 1 - Best Practice Financial Modelling in
   Excel
   
   Financial Modelling School: Module 2 - Advanced Financial Modelling in Excel
   
    
   
   
   OBJECTIVE
   
   
   
   The course is designed to support junior and middle financial analysts,
   modellers and their managers in creating financial models on a consistent and
   focussed basis.  Some previous use of Excel is assumed, but delegates will
   not need an advanced knowledge.
   
   
   
   
   AIMS
   
   
   
   The principal aim of the course is enable participants to use Microsoft Excel
   to prepare logical and easy-to-use financial models to support transactions,
   forecasts and planning for ongoing business streams. These skills can also be
   used to support credit approvals and reviews by lenders and to support the
   organisation to run or sponsor projects. The course will review best practice
   in model structures and logic, and using tools to highlight areas of risk,
   particularly in sensitivity analysis.
   
   
   METHODOLOGY
   
   
   
   The learning methods used are practical, as practice of newly-learned
   techniques enables a deeper and more effective building of skills. Each
   section will be covered briefly as a module in a traditional class style, but
   the real learning experience will be found in the exercises within each
   module. Suggested solutions to each exercise will be provided and discussed,
   and participants will be encouraged to review their work independently.
   
    


 * DAY 1
   
   
   
   Introduction & Course Objectives
   
    * Overview of course objectives
    * Review of models and their objectives
   
   
   
   Overall Model Structure & Design
   
    * Best financial modelling practice
    * Overall structure of the model
    * Logic flow within the model
    * Separation of inputs, calculations and outputs
    * Defining desired outputs
    * Setting-up required inputs
    * Use of switches to allow option selection
    * Use of flags to control timing factors
    * Set-up for flexibility
    * Consistency in the model
    * Accommodating multiple options
    * Building assumptions off term sheets or other external inputs
    * Using the assumptions sheets as a sign-off document
    * Restricting ranges of inputs and validation criteria
    * Version control
    * Use of the corkscrew technique
    * Tracking changes
    * Documentation
    * Exercise – creating a simple model with an assumptions / input sheet with
      built-in flexibility
   
   
   
   Modelling Techniques for Revenue and Cost Forecasts
   
    * Translating assumptions & inputs into a model forecast:
      * Overall growth
      * Split volume and price
      * Split volume into market growth and market share
      * Top-down market sizing, market share and price
    * Build-up of construction or other capital costs
    * Correct matching of units
    * Modelling pricing & revenue assumptions
    * Use of lookup and INDEX/MATCH functions to change expenditure timings
    * Building in sensitivities into the model
    * Exercises:
      * build-up revenue forecasts with different techniques and granularity
        levels
      * build capex forecast with flexible timing
   
   
   
   
   
   
   DAY 2
   
   
   
   Inflation / Escalation Factors
   
    * Creating inflation indices
    * Controlling start time of inflationary pattern
    * Applying multiple rates to different cost & revenue items
    * Varying inflation rates over life of the model
    * Exercise – model multiple, variable inflation rates, with different
      starting-points and changing rates over the life of the model
   
   
   
   
   
   Cash Flow Modelling
   
    * Differences between income statement and cash flow
    * Organising cash flow statements
    * What is working capital?
    * Modelling changes in receivables, inventory, payables
    * Income statement items that are not cash: adjustments needed
    * Cash items not in the income statement: adjustments needed
    * Financing cash flows: changes in debt & equity
    * Revolving facilities and their role in cash flow forecasting
    * Exercise: create a cash flow model to forecast cash inflows and outflows
      for a trading business, and drawing on revolving facilities as needed.
   
   
   
   
   
   
   
   Comparing a Model to Previous Versions of the Model
   
    * Separate runs and variation of inputs
    * Comparison of actuals to forecast
    * Comparing results of different versions of same model
    * Reviewing future implications of variances
    * Example – from different versions of a modelled forecast, calculate
      variances and review future assumptions
   
   
   
   
   DAY 3
   
   
   
   
   
   Sensitivity Analysis in a Model
   
    * Stress-testing the model
    * Varying inputs to assess effect on results
    * Use of built-in sensitivity inputs
    * Use of goal seek & solver
    * Version control to allow comparison of outputs
    * Use of Excel tools to support sensitivity analysis:
      * watch window function
      * data tables
      * scenario manager
    * Exercise – from a given model of cash flows, P&L and balance sheet,
      calculate effect of varying inputs to a given degree, and stress-test
      model to break-even.
   
   
   
   
   
   Reporting Outputs
   
    * Design techniques to enable optimisation
    * Consolidation techniques:
      * Add-through
      * Sum-through
      * Sum & Group
      * Consolidate function in Excel
    * Use of charts & graphics
    * Using pivot tables:
      * Pivot table wizard
      * Setting-up tables
      * Changing parameters
      * Analyzing pivot table data
      * Drill-down function
    * Exercise – from a given set of outputs, create output tables, pivot tables
      and consolidations to enable flexible reporting
   
   
   
   
   
   Advanced Excel Functions
   
    * Advanced financial mathematics – PMT, PPMT, IPMT,NPER
    * Summation & counting functions in Excel: COUNT, COUNTA, COUNTIF, AVERAGE,
      AVERAGEIF, SUMIF, SUMIFS
    * Statistical functions in Excel
    * Depreciation functions in Excel
    * Date and Time functions in Excel
    * Lookup and Reference formulae: Lookups, OFFSET and MATCH formulae
    * Logical functions – using TRUE, FALSE, IF, AND & OR in combination
    * Text functions in Excel: LEFT, RIGHT, MID, LEN and wildcard
    * Exercises:
      * 1) model a loan using some of the advanced functions learned
      * 2) summarise messy data without cleaning it, using text functions
   
   
   
   
   
   
   WRAP-UP
   
    * Overall review
    * Key points to re-iterate
    * Brief introduction to further exercises & reading
    * Final questions and issues to discuss
   
    
   
    


 * OUR TAILORED LEARNING OFFERING
   
   
   
   Do you have five or more people interested in attending this course? Do you
   want to tailor it to meet your company’s exact requirements? If you’d like to
   do either of these, we can bring this course to your company’s office. You
   could even save up to 50% on the cost of sending delegates to a public course
   and dramatically increase your ROI.
   
   If you want to run this course at a location convenient to you or if you want
   a completely customised learning solution, we can help.
   
   We produce learning solutions that are completely unique to your business.
   We’ll guide you through the whole process, from the initial consultancy to
   evaluating the success of the full learning experience. Our learning
   specialists ensure you get the maximum return on your training investment.
   
   

 * We have a combined experience of over 60 years providing learning solutions
   to the world’s major organisations and are privileged to have contributed to
   their success. We view our clients as partners and focus on understanding the
   needs of each organisation we work with to tailor learning solutions to
   specific requirements.
   
   We are proud of our record of customer satisfaction. Here is why you should
   choose us to help you achieve your goals and accelerate your career:
   
    * Quality – our clients consistently rate our performance ‘excellent’ or
      ‘outstanding’. Our average overall score awarded to us by our clients is
      nine out of ten.
    * Track record – 10/10 of the world’s largest banks have chosen us as there
      training provider and we have delivered training across the largest banks
      and have trained over 25,000 professionals.
    * Knowledge – our 100+ strong team of industry specialist trainers are world
      leading financial leaders and commentators, ensuring our knowledge base is
      second to none.
    * Reliability – if we promise it, we deliver it. We have delivered over
      25,000 events both in person and online, using simultaneous translation to
      delegates from over 99 countries.
    * Recognition – we are accredited by the British Accreditation Council and
      the CPD Certification Service. In an independent review by Feefo we
      scored 4.2/5 on service and 4.7/5 on Coursecheck

This course can be run as an In-house or Tailored Learning programme
Learn More



INSTRUCTOR


 * ALAN BROOKE
   
    * 
   
   
   BIOGRAPHY
   
   I am a professional financial modeller, creating detailed models for
   organisations which need to plan their future. Clients have ranged from mine
   developers to government departments, large-scale gas producers to railway
   companies. My models have been used to support financing rounds (equity
   and/or debt), strategic development, mergers and acquisitions, internal
   restructuring, budgeting, forecasting, initial public offerings (IPOs), new
   business bids and tenders. All are created to a high standard of flexibility,
   consistency and robustness; I am at Developer level in the ICAEW Spreadsheet
   Competency Framework. My experience in this field over the past 20 years
   enables me to teach others; I run training courses in financial modelling
   skills all around the world on behalf of a number of international training
   companies. Specialisms: Financial modelling, financial analysis, model audit,
   model testing, management accounting, financial planning, strategic planning,
   training


VENUE

LONDON

The course will take place at a central London hotel. The map attached details
some of our most frequently used venues.

About us
 * About us
 * Contact us
 * Modern Slavery Act
 * Cancellation Policy

Learning
 * Methodologies
 * Courses


 * 
 * 
 * 


 

Please read our Terms & Conditions, Privacy Policy and Accessibility before
using this site.

All material subject to strictly enforced copyright laws. Delinian Group
Delinian Limited
8 Bouverie Street 
London
EC4Y 8AX
Registered in England & Wales, Company number 00954730
Copyright © Delinian Limited and its affiliated companies 2023


Course Sitemap: Financial | Other




We use cookies to serve you with the most relevant content and ads, and to keep
our websites reliable and secure.
I AGREE