Financial Analysis with Excel - ONLINE Workshops - Kozminski University

Workshop objective

Overview

During this course in the form of computer workshops, a method of comprehensive assessment of the company's financial condition will be presented.
Participants will also receive ready-made models that will allow them to carry out analyzes themselves.
On the example of data from various enterprises, basic issues related to the analysis of profitability, liquidity, debt and efficiency and operations will be addressed, but each of the areas of analysis will be appropriately expanded to include advanced issues. For example, the profitability assessment will include, among others the possibility of using different types of cost accounting, the analysis of efficiency will present different ways of calculating the same indicator, the debt analysis will cover the issue of financial leverage, and when examining liquidity, attention will be paid to the need to modify the data from the balance sheet, which does not actually reflect the degree of liquidity.

Program highlights

Real life examples

Comprehensive approach to issues

Computer workshops conducted by practitioners

Target group

The course is addressed to people interested in analyzing financial statements and obtaining information on the condition of the enterprise.
It is especially useful for people who want to broaden their skills in order to, e.g. assess the condition of their own enterprise, as well as in the context of selecting business partners, analyzing credit applications and conducting fundamental analysis, e.g. company valuation.
The same addressees of the training are both financial and credit analysts, but also e.g. members of management boards and supervisory boards who want to strengthen their own skills in controlling the enterprise and checking its proper functioning.

Benefits for You & CO.

Knowledge and skills acquired as a result of participating in the training:

Interpreting financial statements,
The use of indicator analysis for the purposes of assessing the company's condition,
Assessment of debt, liquidity, efficiency and profitability of enterprises
Modifying indicators to better illustrate the problem being investigated
Preparation and verification of the content of financial plans
Restrictions on the use of financial analysis in the assessment of enterprises
Comparing enterprises based on financial results,
Identification of symptoms of the company's deteriorating situation.

The training will be conducted in the form of computer workshops. After its completion, each participant will have a tool to conduct financial analysis of the enterprise.

Program

1. Welcome. Discussion of training goals and logic

2. Introduction to the financial statement and its analysis

Objectives of financial analysis
Information content of the balance sheet, profit and loss account and cash flow statement
Accounting policies and their impact on the financial statements
The role of additional information
Creative accounting and its prevention
Qualitative analysis - risk

3. Initial analyzes of the financial statements

Horizontal and vertical balance sheet analysis
Horizontal and vertical analysis of the profit and loss account
Cash flow statement analysis

4. Ratio analysis - profitability

Basic accounting indicators and their modifications
Types of profit included in the profit and loss account
ROA, ROE, ROS

5. Ratio analysis - debt

Basic debt ratios
Financial assessment from the perspective of the owner and creditor
Debt and financial leverage
Principles of business financing

6. Ratio analysis - liquidity

Basic liquidity ratios
Limitations of liquidity analysis based on the balance sheet
Adjusted liquidity analysis

7. Indicator analysis - operational efficiency

Performance indicators
Operating cycle and cash conversion period
The issue of the correctness of the formulas used based on the receivables turnover ratio

8. Additional issues

Financial indicators in the context of financial planning
Combination of indicators in pyramidal analysis
Capital market indicators
Signals of the company's deteriorating situation
Advantages and disadvantages of financial analysis

9. End of training

Dates

Coming soon.

Duration: 2 days = 16 teaching hours (1 teaching hour = 45 minutes)

9 a.m. to 4 p.m.

Instructor

LinkedIn Email

Marcin Ocieszak, Ph.D

Is a practitioner in the field of corporate finance with over 10 years of experience.

In the years 2010-2017 he was associated with ING Bank Slaski S.A. where he was responsible for business relations and providing financing to large enterprises from the Mazowieckie Voivodeship. At that time, he provided financing for nearly PLN 1 billion, both in the form of financing investment projects, commercial real estate and working capital financing. From 2014 I was the Manager of the Corporate Customer Department and was responsible for the portfolio of credit assets worth PLN 1.5 billion.

In 2007-2010 he worked at the Citi Handlowy bank where, among others in the Treasury Department I was a member of the team introducing the first Citi Online Trading currency exchange platform in Poland.

Currently Dr Ocieszak holds a PhD in economics and is employed at the Kozminski University in Warsaw since 2017. His research interests relate to the merger and acquisition market, financing commercial real estate and the video game production market.
In addition to scientific activities, he teaches full-time, extramural and post-graduate studies in the following subjects: Corporate finance, Principles of finance, Fundamental analysis, Modern methods of investment project assessment, Derivative valuation and financial risk management, Ethics in finance and accounting, Financial planning and controlling, Cooperation with financial institutions, Sources of finance, Business valuation.

He gave guest lectures at foreign universities, including Black Sea University in Georgia or the International School of Economics & Management in Lisbon.