Financial Modelling with Excel

Register Now

In-Company, call us for more information

Course Description

You may be interested in our Equity Valuation course in London.

This programme is now available only on in-company basis. If you have a group of 3 or more we can deliver it in any location worldwide. Contact us to find out more. 

Check here the list of our upcoming open public courses.

This 2 day practical course is designed to equip the delegates with a sound financial modelling skills and techniques to prepare and forecast financial statements needed in a modern corporate world. You will gain a firm understanding of the modelling process and financial ratios analysis. 

The course is run in a very small group allowing for a direct interaction with the trainer throughout the whole course and each session is concluded with a practical model building exercise. 

What Will You Learn

 By the end of this course you will be able to:

  • Build a financial model from a scratch using the best structuring techniques
  • Use efficiently key Excel functions to construct sound financial forecasting models
  • Create a forecast income, cash flow statement and balance sheet
  • Interpret and analyse the key ratios used in a financial forecast
  • Apply and analyse more complex issues in financial forecasting such as taxation, provisions, associates and NCIs
  • Develop the analysis of balance sheet structures through a cash waterfall
  • Use the financial ratios in the forecast analysis

Main Topics Covered During This Training

  • Overview of the modelling process
  • The key Excel functions in modelling
  • Model structure: inputs, workings, outputs
  • Key drivers for modelling: revenues and operating costs
  • Forecasting revenues and margins, fixed tangible and intangible assets
  • Creating and analysing cash flow statement from operations, investing and financing activities
  • Calculating tax and dividends
  • Linking up interest
  • Forecasting depreciation, net income and shareholders' equity
  • Creating and analysing cash flow statement from operations, investing and financing activities
  • More complex issues in forecasting: taxation, provisions, associates and non controlling interests
  • Key ratio analysis

Who Should Attend

Participants who want or need to be able to build a sound financial models should attend this course. 

From:

  • Corporates
  • Investment Banks
  • Private Equity companies
  • Analysts
  • M&A Departments
  • Consultant Companies
  • Equity Research, Analysts and Sales
  • Equity Capital Markets
  • Investment Managers
  • Corporate Financial Managers
  • Corporate Development
  • Corporate Finance Lawyers
Register Now

In-Company, call us for more information

  • Financial Modelling and Forecasting  - A Two Day Course
  • Modelling basics
  • Forecasting the income statement 
  • Fixed assets and working capital
  • Net income and shareholders' equity
  • Cash flow statement
  • More complex issues
  • Ratio analysis

 

Eureka Financial Faculty 

* - Fields marked with a star are obligatory.

Your privacy is important to us and we will not share your details with any third-party.

Submit

Thank you for your interest in our company and your enquiry. We will contact you shortly.

In the meantime, did you have a chance to see what our clients say about us?

Follow us on:


* - Fields marked with a star are obligatory.

Your privacy is important to us and we will not share your details with any third-party.

Subscribe

Thank you for your interest in our company and your enquiry. We will contact you shortly.

In the meantime, did you have a chance to see what our clients say about us?

Follow us on:

Financial Modelling with Excel <p>You may be interested in our&nbsp;<a href="http://www.eurekafinancial.com/courses/equity_valuation_and_analysis.html"><strong>Equity Valuation course in London</strong></a><strong>.</strong></p> <p><strong>This programme is now available only on in-company basis.</strong>&nbsp;If you have a group of 3 or more we can deliver it in any location worldwide.&nbsp;<a href="javascript:location.href='m ... In-Company