19 февраля 2015 г.

CFA Association Russia has held a workshop on financial modeling of investment projects


CFA Association Russia held a workshop on financial modeling of investment projects. During this brief course, which took place in the RUSNANO office, specialists in the investment field learned how to create simple, clear, and error-free financial models.


At the beginning of this overview Dmitri Ryabykh (CFA and general director of Alt-Invest) highlighted the main features of project modeling: the general requirements for a financial model, the overall structure of a model, the building blocks for a financial model and the order in which they should be placed, specific aspects of building a model depending on the type of project, financial reporting in modeling an investment project, performance indicators, and bank indicators.


The workshop examined recommended charts: return on investments, cost structure, outstanding debt for credit, sales volume, and EBITDA. Dmitri also spoke about unnecessary indicators for liquidity, turnover, and profitability which should be avoided.


Following the introductory talk, practical training was held on technical methods, including:
  • creating tables and lists using the Data Validation function
  • basic functions, their purpose, and example uses: sumifs (adding arguments that meet certain criteria), vlookup (selecting variables) and hlookup, index and choose, goal seek (finding results), and match (finding positions)
  • conditional formatting and using it to present results
  • creating scenarios and analyzing them with the scenario manager function
  • creating a lookup table (sensitivity table)
  • using summary tables
It is worth noting that this workshop was organized as a condensed version of an intensive two-day course on building financial models which the CFA Association Russia has held over the past several years.  
 

 








  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 ©2026 CFA Association Russia | Используя данный сайт, вы принимаете Пользовательское соглашение и Политику конфиденциальности.