Магистратура
2024/2025
Построение финансовых моделей на практике
Статус:
Курс по выбору (Финансовый аналитик)
Направление:
38.04.08. Финансы и кредит
Кто читает:
Банковский институт
Где читается:
Банковский институт
Когда читается:
2-й курс, 2 модуль
Формат изучения:
без онлайн-курса
Охват аудитории:
для своего кампуса
Преподаватели:
Куликов Кирилл Сергеевич
Прогр. обучения:
Финансовый аналитик
Язык:
английский
Кредиты:
3
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.