• A
  • A
  • A
  • АБB
  • АБB
  • АБB
  • А
  • А
  • А
  • А
  • А
Обычная версия сайта
2026/2027

Построение финансовых моделей на практике

Статус: Маго-лего
Где читается: Банковский институт
Охват аудитории: для своего кампуса
Язык: русский
Кредиты: 3
Контактные часы: 30

Программа дисциплины

Аннотация

A financial model is an essential tool for understanding and evaluating an investment project – from both quantitative and qualitative perspectives. It brings together all key business assumptions, accounts for opportunities and constraints, and reflects the regulatory and business environment. A good financial model not only helps measure risk and uncertainty but also clearly presents the “base case”—the most likely scenario – for stakeholders. In this course, you’ll learn step-by-step how to build a financial model for your project. We’ll cover the entire process: starting from a blank Excel workbook, you’ll create pro-forma financial statements and key financial ratios commonly used by investors and lenders. Along the way, we’ll explore best practices in financial modeling, as well as the technical and financial principles behind the tools you use. The approach and structure you’ll learn here are practical and adaptable – whether you’re starting a new business, launching a product, or exploring a venture investment. By the end of the course, you’ll have built a universal financial model you can use as a template for your future projects.
Цель освоения дисциплины

Цель освоения дисциплины

  • This course aims to equip you with practical financial modeling skills for investment projects. You’ll learn best practices through interactive discussions with the instructor and by building your own financial models in hands-on exercises
Планируемые результаты обучения

Планируемые результаты обучения

  • After the course, students will have necessary knowledge and skills to build a fully fledged financial model for a project or a company. The model can be used to support investment decisions, raise capital or apply for debt financing
Содержание учебной дисциплины

Содержание учебной дисциплины

  • Basics of financial modelling
  • Sales, OPEX, CAPEX, working capital, taxes
  • Financial reports in the model
  • Financing: loans, lease. Ratios
  • Discounted cash flow analysis
  • Scenario analysis
Элементы контроля

Элементы контроля

  • неблокирующий test 1
  • неблокирующий test 2
  • неблокирующий test 3
  • неблокирующий test 4
  • неблокирующий test 5
  • неблокирующий test 6
  • блокирующий final project
Промежуточная аттестация

Промежуточная аттестация

  • 2026/2027 2nd module
    0.08 * test 6 + 0.08 * test 5 + 0.52 * final project + 0.08 * test 1 + 0.08 * test 3 + 0.08 * test 4 + 0.08 * test 2
Список литературы

Список литературы

Рекомендуемая основная литература

  • Damodaran, A. (2015). Applied Corporate Finance (Vol. Fourth edition). Hoboken, New Jersey: Wiley. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1639191
  • McKinsey & Company Inc, Tim Koller, Marc Goedhart, & David Wessels. (2020). Valuation : Measuring and Managing the Value of Companies, University Edition. Wiley.
  • Rosenbaum, J., & Pearl, J. (2013). Investment Banking : Valuation, Leveraged Buyouts, and Mergers and Acquisitions (Vol. 2nd ed). Hoboken: Wiley. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=981384

Рекомендуемая дополнительная литература

  • Nantell, T. J. (1991). Valuation: Measuring and Managing the Value of Companies. Journal of Finance (Wiley-Blackwell), 46(1), 459–463. https://doi.org/10.2307/2328707

Авторы

  • Ильин Алексей Борисович
  • Елизарова Ирина Николаевна