Certificate in Advanced Financial Modeling


Course Calendar

DateLocationFees
14 Jan - 18 Jan 2019London3,800 €
28 Jan - 1 Feb 2019Dublin3,800 €
18 Feb - 22 Feb 2019Istanbul1,500 €
18 Mar - 22 Mar 2019Stockholm2,800 €
8 Apr - 12 Apr 2019Dublin3,800 €
29 Apr - 3 May 2019Munich2,800 €
13 May - 17 May 2019Barcelona2,800 €
3 Jun - 7 Jun 2019Munich2,800 €
24 Jun - 28 Jun 2019Paris4,500 €
8 Jul - 12 Jul 2019Dublin3,800 €
29 Jul - 2 Aug 2019Prague2,800 €
12 Aug - 16 Aug 2019Manchester3,100 €
2 Sep - 6 Sep 2019Kuala Lampur1,900 €
16 Sep - 20 Sep 2019Istanbul1,500 €
14 Oct - 18 Oct 2019Hong Kong3,500 €
4 Nov - 8 Nov 2019Berlin3,800 €
18 Nov - 22 Nov 2019London3,800 €
9 Dec - 13 Dec 2019Munich3,800 €
30 Dec 2019 - 3 Jan 2020Istanbul1,500 €
13 Jan - 17 Jan 2020Stockholm2,800 €

* Price excluding VAT


Outline PDF



  • Accounting Finance

Course Description

 
 
Why Attend
 
Organizations cannot afford to make the wrong investments decisions because such decisions have a long-term impact on the business and could make or break the organization. That is why it is critical to master financial modeling techniques as they are the main basis for investment decisions. By helping you understand and build effective financial models, this course will have a significant impact on the effectiveness and feasibility of your investments decisions.
 
Course Methodology
 
This course uses hands-on applications of financial modeling in Excel in addition to demonstrating theoretical core topics. The course also features real-life case studies and presentations by participants.
 
Course Objectives
 
By the end of the course, participants will be able to:
  • Prepare effective financial models utilizing powerful Excel functions
  • Use core financial modeling techniques
  • Forecast investments, and calculate valuations of projects and companies in an effective manner
  • Develop comprehensive financial models to support investments decisions
  • Recognize special modeling and valuation considerations and best practices
 
Target Audience
 
Corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.
 
Target Competencies
 
Learning advanced Excel
Performing capital budgeting analysis
Forecasting cash flow
Calculating cost of capital
Practicing financial modeling
Understanding scenario analysis
Calculating free cash flow
 
Course Outline
 
Advanced Excel for financial modeling
  • Excel tips and tricks that will help you speed up your spread sheet
  • Logical tests
  • Protecting your data
  • Database activities
  • Pivot Tables
  • Grouping data
  • Vertical and horizontal lookup tables
  • The magical choose function
  • Interactive formulas to extract data
  • String functions
  • Data tables
  • Interactive Graphs
 
Fundamentals of financial modeling
  • Time value of money:
  • Present Value (PV) Future Value (FV) and Net Present Value (NPV)
  • Internal Rate of Return (IRR) and Multiple IRR (MIRR)
  • Equity IRR and project IRR
  • Using XNPV and XIRR
  • Contradicting NPV and IRR
  • Amortization of loan schedule
  • Enterprise value, market capitalization, firm value and equity value
  • Effective interest rate
  • Compound Annual Growth Rate (CAGR)
  • Investment assumptions and cash flows
  • What needs to be included?
  • Forecasting revenues
  • Forecasting costs and expenses
  • Focusing on income statement or cash flow?
 
Valuation techniques
  • Analyzing historical information and developing a projection basis
  • Using ratio analysis to prepare projected financial statements
  • Debt capacity and credit analysis for the acquisition
  • Sensitivity analysis on cash flows
  • Weighted Average Cost of Capital (WACC)
  • Adjusted Present Value (APV)
  • Using Capital Assets Pricing Model (CAPM) to determine cost of equity
  • Implied risk premium in the current Price Earnings (PE) multiple
  • Gordon model to determine cost of equity
  • Using PE multiple to determine cost of equity
  • Accrual accounting valuation
  • Valuation using multiples
  • Transaction multiples
 
Building real life models
 
  • How financial models work
  • Modeling income statements
  • Modeling balance sheets
  • Sensitivity analysis
  • Developing an integrated financial model
  • Automotive
  • Hospitality
  • Real estate
  • Education
 
Special modeling and valuation considerations
 
  • Structured valuations
  • Financial modeling best practices
  • Return on Investment (ROI) and Return on Equity (ROE)
  • Investment structures
  • Direct ownership
  • Partnership and joint venture
  • Build, Operate and Transfer (BOT)

Download PDF Enroll Now


Latest Tweets

Contact Us

  • Address:27 Old Gloucester Street , Monomark House , WC1N 3AX , London , United Kingdom

  • Phone: +44(203)2399994

  • Email: info@informatech.co.uk

  • Company Registered in U.K No. 10532767

Follow Us