Магистратура
2022/2023
Финансовое моделирование
Статус:
Курс по выбору (Магистр аналитики бизнеса)
Направление:
38.04.08. Финансы и кредит
Кто читает:
Практико-ориентированные магистерские программы факультета экономических наук
Где читается:
Факультет экономических наук
Когда читается:
1-й курс, 2 модуль
Формат изучения:
с онлайн-курсом
Онлайн-часы:
20
Охват аудитории:
для своего кампуса
Преподаватели:
Тихомиров Дмитрий Викторович
Прогр. обучения:
Магистр аналитики бизнеса
Язык:
английский
Кредиты:
3
Контактные часы:
10
Course Syllabus
Abstract
Course prescription.The Course explores the best practices of financial modelling according the existent modelling guidelines. Students will learn how to build a financial model, how to create a correct system of Pro Forma financial statements and forecast the changes in firm’s future cash flows under different scenarios. Using practical cases, you will find out how to build financial models that are flexible, appropriate, transparent and structured and correspond to the specific financial question. You will also discuss how to make a model user-friendly and audit the quality of the models. Finally, you will get acquainted with the methods of model presentation to the different types of audience. This course is a part of elective courses of the online Master degree program and is designed to ensure the basic professional competences in preparing scenarios for various corporate strategies and valuations.
Learning Objectives
- • development by students of the theoretical foundations of financial modeling, taking into account the peculiarities of planning, management and organization of the financial system in corporations;
- • developing an understanding of the factors that determine industry specifics and their impact on financial planning and financial modeling;
- • development of competencies and skills in data processing, financial calculations, financial planning and modeling;
- • study by students of methodological issues underlying the design, construction and use of financial models of various target orientation and degree of detail;
- • mastering the practical skills of developing financial models, taking into account the organizational structure and industry characteristics of corporations of various types.
Expected Learning Outcomes
- To know the methodology and logic of building and using a financial model, the rules generally accepted in the professional environment, techniques and tools for financial modeling
- Know the areas of financial modeling, types of financial models and the appropriateness of their application depending on business goals, type of corporation and industry specifics
- Know the main approaches to automating financial modeling in the scope of a corporation
- Have the skills of consolidating individual financial models and modeling the prospects for the development of a corporation (company) Have the skills to develop financial models for individual structural units within the corporation, taking into account the types of business and industry specifics
- Be able to apply the acquired knowledge in the design, construction and analysis of the results of financial modeling for models of various types and degrees of complexity
Course Contents
- Introduction to financial modelling
- Drivers for financial models and calculations
- Calculations and results
- Taxation in models
- Special functions in Excel for financial modeling and visualization of results
- Adjusting to different business models. Part 1
- Adjusting to different business models. Part 2
Bibliography
Recommended Core Bibliography
- Financial modeling : a backward stochastic differential equations perspective, Crepey, S., 2013
Recommended Additional Bibliography
- Benninga, S. (2014). Financial Modeling (Vol. Fourth edition). Cambridge, Massachusetts: The MIT Press. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1089520