2026/2027
Финансовое моделирование в фирме
Статус:
Маго-лего
Кто читает:
Школа финансов
Где читается:
Факультет экономических наук
Онлайн-часы:
20
Охват аудитории:
для своего кампуса
Язык:
русский
Кредиты:
3
Контактные часы:
20
Программа дисциплины
Аннотация
The Financial Modelling in a Firm Course is aimed to provide students with the skills necessary for applying excel as a tool to provide models to make corporate financial decisions. 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 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.Recommended Prerequisites:Corporate Finance-1,2, International Financial Reporting Standards
Цель освоения дисциплины
- How to use financial models in decision support in corporate finance
- To learn best practices of model's design and planning
- The techniques of buidling flexible and intuitive model in Excel
- To learn practices of model testing and auditing, including designing robust and transparent formulae
- To learn how to deal with circularity in the model
- How to incorporate sensitivity and scenario analysis, uncertainties and risks.
- Practice to use VBA macros and ModelRisk Excel add-on to conduct sensitivity and scenario analysis
- The ways of model presenting: dashboards and charts
- How to use valuation techniques and estimate intrinsic value of equity using finanicla models
Планируемые результаты обучения
- Be able to apply models for financial decision-making
- Be able to explain how the valuation technics could help in financial modelling
- Be able to create a template in Excel, that will allow building a model that is flexible and intuitive
- Be able to incorporate scenario analysis in forecasting firm’s future cash flows
- Be able to check that the model is correct
- Be able to audit the model
- Be able to present a model using a dashboard, charts, etc.
Содержание учебной дисциплины
- 1. Introduction to financial modelling
- 2. Building a model. Financial statements
- 3. Forecasting. Financing, discount rate and DCF
- 4. Model analysis and auditingThe experts in financial modelling participate in this block.
- 5. Best practices of financial modelling applicationsThe financial modelling experts participate in this block
Список литературы
Рекомендуемая основная литература
- Financial modeling : with a section on Visual Basic for Applications, Benninga, S., 2000
- Investment valuation : tools and techniques for determining the value of any asset, Damodaran, A., 2012
Рекомендуемая дополнительная литература
- Ian Beaman, Erwin Waldmann, & Peter Krueger. (2005). The impact of training in financial modelling principles on the incidence of spreadsheet errors. Accounting Education, (2), 199. https://doi.org/10.1080/0963928042000229699
- Satran, R. (2013). Breaking Into Wall Street. U.S. News Digital Weekly, 5(17), 8.