• A
  • A
  • A
  • АБВ
  • АБВ
  • АБВ
  • А
  • А
  • А
  • А
  • А
Обычная версия сайта

Магистерская программа «Финансовый аналитик»

Building DCF Models in Practice

2024/2025
Учебный год
ENG
Обучение ведется на английском языке
3
Кредиты
Статус:
Курс по выбору
Когда читается:
2-й курс, 2 модуль

Преподаватель


Куликов Кирилл Сергеевич

Course Syllabus

Abstract

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.