Магистратура
2022/2023
Финансовое моделирование в фирме
Лучший по критерию «Полезность курса для Вашей будущей карьеры»
Статус:
Курс по выбору (Стратегическое управление финансами фирмы)
Направление:
38.04.08. Финансы и кредит
Кто читает:
Школа финансов
Где читается:
Факультет экономических наук
Когда читается:
1-й курс, 3 модуль
Формат изучения:
без онлайн-курса
Охват аудитории:
для своего кампуса
Прогр. обучения:
Стратегическое управление финансами фирмы
Язык:
английский
Кредиты:
3
Контактные часы:
32
Course Syllabus
Abstract
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
Learning Objectives
- 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
Expected Learning Outcomes
- 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.
Course Contents
- 1. Introduction to financial modelling
- 2. Building a model. Financial statements
- 3. Forecasting. Financing, discount rate and DCF
- 4. Model analysis and auditing
- 5. Best practices of financial modelling applications
Interim Assessment
- 2022/2023 3rd module0.2 * Home assignment + 0.2 * Case 2 + 0.4 * Final case + 0.2 * Case 1
Bibliography
Recommended Core Bibliography
- 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
Recommended Additional Bibliography
- 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.