2024/2025

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

Статус: Маго-лего

Кто читает: Банковский институт

Когда читается: 2 модуль

Охват аудитории: для своего кампуса

Преподаватели: Куликов Кирилл Сергеевич

Язык: английский

Кредиты: 3

Course Syllabus

Abstract

The financial model is the most important tool for quantitative, as well as qualitative, analysis of an investment initiative. A model integrates all important business assumptions of a project sponsor, opportunities and restrictions of business, regulatory and other environments. Another feature of a quality financial model is that it provides a tool for measuring uncertainty (risk) and serves as a transparent instrument for presenting a base case (a scenario that appears most likely and acceptable) to key stakeholders of a project.You will learn in this course how to build a financial model for your project, including all pro forma financials and ratios that are used by equity investors and lenders. We will go through the path from a blank Excel workbook, discuss the best practice for financial modeling, dig into technical and financial aspects of the methods and ratios that we use in the model. The structure and principles laid out in this course could be used for any project to create a new business, launch a product or for venture investments. You will see that the approach we use is universal and the model we build in the course can be your template for many future projects.