Аналитические инструменты управления финансами предприятия

2022/2023

Статус: Дисциплина общефакультетского пула

Кто читает: Департамент финансов

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

Охват аудитории: для всех кампусов НИУ ВШЭ

Преподаватели: Чуракова Ийя Юрьевна

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

Кредиты: 3

Контактные часы: 28

Full Syllabus Ask Question

Abstract

The purpose of the discipline is to form the student's knowledge of analytical methods of tools in the management of enterprise finances. As part of the course, students will study decision-making methods in various functional areas of enterprise finance, as well as methods and algorithms for quantitative assessments of the processes of providing enterprise activities with financial resources. The main goal of the course is to familiarize with modern approaches to modeling and optimization of financial operations and functions, approaches to the problem of making economically sound decisions in conditions of uncertainty.

Learning Objectives

Introduction to relational database management systems with MS SQL Server as an example
Learning solid basis of SQL querying
Exploring Window Functions
Acquiring bases in Pandas and Numpy for data transformation, including Effective Pandas, as well as simple data visualization

Expected Learning Outcomes

Analyse financial and non-financial statements to select metrics for building the financial model.
Apply Regression Tools to make Predictions, and improve Forecasts with Multiple Regression.

Course Contents

Financial and non-financial statements of the company as sources of information for building financial models.
Accounting and cost models of analysing company performance.
Logic of complex evaluation of business liquidity and financial stability.
Business risks under uncertainty. Assessing the probability of bankruptcy of a company based on classical models.
Concept of company's financial health and financial health diagnostics models.
Financial model of the company as part of general business model. Analysis of internal financial risks.
Case-writing practical session

Assessment Elements

Case writing project
Individual, in-class, open book
In-class activities
Final Written Exam
Final written exam is held during an exam week. The exam is obligatory and cannot be covered by the cumulative grade. The exam lasts 80 minutes and contains 4 problems that includes some problem- solving tasks similar to home assignments and class problems.

Interim Assessment

2022/2023 1st module
0.3 * Case writing project + 0.5 * Final Written Exam + 0.2 * In-class activities

Bibliography

Recommended Core Bibliography

Michael Rees. (2018). Principles of Financial Modelling : Model Design and Best Practices Using Excel and VBA. Wiley.
Rees, M. (2008). Financial Modelling in Practice : A Concise Guide for Intermediate and Advanced Level. Hoboken, NJ: Wiley. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=319172

Recommended Additional Bibliography

Day, A. L. (2012). Mastering Financial Modelling in Microsoft Excel 3rd Edn : A Practitioner’s Guide to Applied Corporate Finance (Vol. Third edition). Harlow: FT Press. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1419889

Authors

Churakova Iiia Iurevna
SOLOVEVA EKATERINA EVGENEVNA

Course Syllabus