26 2012 .

On May 26-27, 2012, CFA Association (Russia) and F1F9 Academy (London, UK) will run the two-day comprehensive course for investment banking practitioners and financial analysts:

Intensive Financial Modelling Course

Venue: 15 Kalanchevskaya street, Moscow (map -- http://maps.yandex.ru/-/CBGbRLmg )

You will learn
HOW TO CREATE COMPLETE, USER-FRIENDLY AND
ERROR-FREE FINANCIAL MODELS IN EXCEL

This is the only authorised FAST standard modelling
training course being run in Russia

Registration link -- modelling.qrickets.ru
To pay by wire transfer on invoice, please contact Kirill Murakhtanov at Kirillm@cfarussia.ru or call +7-495-761-31-07

The course will be delivered in English by a certified F1F9 tutor, with the help of an experienced Russian-speaking CFA Russia member, to provide summaries and translate the most difficult parts into Russian. You will receive completion certificates signed by both CFA Association (Russia) and F1F9 Academy.

FEATURES:

  • Two day intensive financial modelling course: Focus on skill development without distractions
  • Course fee is inclusive of pre-course and 3 months of post course access to the Financial Modelling Academy our support to you continues beyond our 2 days together
  • Practical and hands on course: Build a complete model from scratch
  • Expert tuition from experienced instructors: Learn real world modelling
  • Access preparatory and follow up tutorials online: Maximize benefit of in class time
  • Based on the most advanced FAST Modelling Standard http://www.fast-standard.org/: Learn a systematic financial modelling methodology

OUTLINE

CFA Russia's new Intensive Financial Modelling Course by F1F9 Academy is a 2-day in-person financial modelling course for people who need to build, modify, or run financial models. It teaches the core financial model design and construction techniques that every modeller should know. It is appropriate to financial modellers in the corporate, business modelling, banking, treasury, financial advisory, government and infrastructure sectors.

Each participant will be taught to apply the techniques rigorously, as he or she models a business acquisition case study. All of the calculations required to forecast the three primary financial statements - profit and loss, balance sheet, and cash flow - are modelled step-by-step, and the target company is valued based upon the present value of forecast dividends.

The course also includes debt financing, inflation indexation, modelling depreciation, and deferred tax. The course de-emphasises theory in favour of detailed instruction and hands-on practice with good model design and modelling techniques. Pre-course tutorials are made available online to make best use of in-class time.

TARGET AUDIENCE

This financial modelling course is aimed at those people who need to build or run financial models. For experienced modelers, this course will increase the quality and productivity of your modelling. For those with no modelling experience, this course provides a solid introduction to real-world financial modelling.

TEACHING APPROACH

This is a highly practical and hands-on financial modelling course with limited lecturing or speaking to PowerPoint slides. Attendees follow the instructor, while building their own financial models on their own computers; in this way they immediately practice what they have been taught.

AGENDA

The course covers elements of model design, Excel modelling techniques, and some basic financial accounting principles. Participants will rigorously apply FAST modelling principles to improve their modeling design, style, structure, and productivity.

As participants incrementally construct their models, they will avoid using the mouse in favor of keystroke techniques that will improve both their modelling speed and accuracy. All the while we will progress towards producing a fully-functioning financial model, accommodating subjects such as capital expenditure and modelling straight-line depreciation, deferred tax, the primary financial statements, basic term debt calculations and valuing forecast dividends.

PRE-WORK

It will greatly help you to have completed the 31 days to better financial modelling course, which covers the basics of the FAST modelling standard. You can get started now by signing up here -- http://www.f1f9academy.com/free-31-day-course 

As soon as we receive your booking we will send you an invitation to an exclusive pre-course online classroom in the Financial Modelling Academy where all of this material will be available as well as course joining instructions and course files.

POST-COURSE SUPPORT

Our objective is not to get you through a two day course and then leave you to it. Our objective is to transform your financial modelling skills. For that reason, your course fee includes post course access to the F1F9 Academy. This gives you access to video tutorials covering all the course material that we cover in class, plus lots of additional tuition that we dont have time to cover in class. All your post course questions will be answered within 24 hours, usually much quicker. You will be invited to our regular modelling webinars where we look at applied financial modelling problems.

In short, we dont just give you two days of tuition and leave you to it were by your side as you put your new learning into practice.

CLASS SESSIONS

Day 1 includes three specific sessions focused on:

  • Introducing timing flags and indexation factors through modelling of operating revenues and expenses; purpose of relative anchoring to allow re-use of calculation blocks
  • Setting up primary balance corkscrews via modeling of fixed asset capital expenditure and depreciation and simple term debt interest and principal calculations
  • Review of interim P&L, balance sheet, and cash flow using placeholders and introduction to alternative modelling sign conventions; whats the remaining road map for Day 2?


Day 2 continues to implement FAST modelling techniques through specific sessions focused on:

  • Introducing timing flags and indexation factors through modelling of operating revenues and expenses; purpose of relative anchoring to allow re-use of calculation blocks
  • Setting up primary balance corkscrews via modeling of fixed asset capital expenditure and depreciation and simple term debt interest and principal calculations
  • Review of interim P&L, balance sheet, and cash flow using placeholders and introduction to alternative modelling sign conventions; whats the remaining road map for Day 2?
  • Structured approach to reliable indexation factors; forecast price indices vs. contract reference price levels.
  • Taxation: actual cash tax paid vs. P&L tax charge and deferred tax; simple introduction of concepts (see T301 Advanced Tax Modeling for detailed implementations).
  • Working capital: Accounts receivable and accounts payable
  • Share capital account; calculating profit-constrained dividends.
  • Present value of shareholder distributions as primary DCF valuation methodology; model flexing and wrap-up on ancillary points raised and topics of interest to participants.


REQUIREMENTS

Attendees should have a basic understanding of MS Excel (e.g. syntax of IF statement, purpose of $s for anchoring cell references). They will also need to bring a laptop with them, ideally one they are accustomed to using, with a Microsoft Windows operating system and Microsoft Excel loaded with Analysis Toolpak available. Laptops may be rented from Financial Mechanics for an additional charge. Attendees are required to complete a short online pre-course.

NOTEBOOKS WILL BE PROVIDED ON-SITE THOUGH YOU MAY FEEL FREE TO BRING YOURS

Registration link -- modelling.qrickets.ru
To pay by wire transfer on invoice, please contact Kirill Murakhtanov at Kirillm@cfarussia.ru or call +7-495-761-31-07








  Discuss in the forum
« back to list
Video Library
SUBSCRIBE TO OUR NEWSLETTER

to be the first to know about all CFA news, events an programms

CFA Association Russia. CFA () - CFA. , CFA (Levels I, II, III) info@cfainstitute.org.

Ceorooms A2 Comcity
Kiyevskoye Shosse, 6/1,
Moscow 108811 Russia

Copyright 2024 CFA Association Russia | , .