Image

Liquidity & Cash Flow Forecasting

The ICAP - Risk Training Institute and the Centre for Lifelong Learning of the University of Piraeus create for the first time an integrated professional Mastering Credit Risk programme for credit risk managers.
 
The thematic areas of the "Mastering Credit Risk" training programme, the training method, examinations, and accreditation by the University of Piraeus guarantee the provision of essential and practical knowledge, with the sole purpose of upgrading the role of credit management executives, which involves better cash flow, collection, and profitability results for companies.
 
The Module "Liquidity & Cash Flow Forecasting" as a part of the broader training programme "Mastering Credit Risk", offers the opportunity to the participants to attend it  as an independent seminar and be awarded the relevant Certificate of Attendance by the Centre for Lifelong Learning of the University of Piraeus. For the attendance of each module, ECVETs are awarded, while corporate participants can also subsidized by OAED-LAEK.

Description

In recent years, financial forecasting models have served as the predominant method for industry professionals, through which, the latter can apply their financial knowledge. After the recent economic crisis, there has been a constantly increasing need for experienced professionals in building forecasting models, since enterprises are required to predict different scenarios about the future, so that they can better adapt to an unstable and uncertain environment. This practical seminar guides the participants through building their own models, by using various forecasting techniques, in order to monitor specific Key Performance Indicators (KPIs). Nowadays, perhaps the most important performance indicator for enterprises is future cash flows, and strong emphasis is placed on forecasting them, and more specifically, their durationsize, and increase, as well as the uncertainty that characterizes them.

Target Audience

The seminar has been designed for Chief Financial Officers, Credit Rating Managers, accountants, financial advisors, financial analysts, and entrepreneurs with moderate experience in the preparation of financial models, who wish to improve their skills in financial decision making.
The participants should have access to Excel and be familiar with its basic functions.

Subject Areas

. GENERATING & Building FINANCIAL MODELS


Introduction

Key principles

  • The 4 steps of developing a financial model,
  • Structural characteristics of a good model
  • Forecast generating mechanism
  • Forecasting variables

Preparing a financial model

  • Defining the Model
  • Configuration of key model parameters & hypotheses
  • Balancing the Balance Sheet: The Debt or Cash Plug
  • Calculating interest by using Circular References of Excel

Forecasting the key figures of the Profit and Loss Account and the Balance Sheet

  • Forecasting techniques (linear regression, non-linear methods).
  • Revenues, expenditure, investments, depreciation and amortization, borrowings.
  • Indirectly building the Cash Flow Statement

Testing the model

  • Sources of errors

CASE STUDY

  • Developing a financial model to forecast cash flows
  1. UNCERTAINTY ANALYSIS METHODS

    Finding out the most critical parameters of a model by using Tornado Charts
  • Using aids off-the-shelf or/and building Tornado Charts

Sensitivity analysis

  • Using one-dimensional and two-dimensional tables

Scenario Analysis (by using Excel Scenario Manager)

  • Developing at least three scenarios

Monte Carlo simulation - (Required, in order to answer questions such as: "What is the probability of the company's borrowing exceeding €15m by the end of this year?")

  • Probability Distributions of the most critical variables
  • Building bar charts (Frequency distribution charts)

CASE STUDY

  • Building sensitivity tables and Scenarios in the model of the Case Study of the first section
  1. Evaluation Methods 

Discounted Cash Flow (DCF) method

  • Fundamental Principles
  • Explicit forecast period
  • Discounting Future Cash Flows
  • Discount Rate
    1. Weighted Average Capital Cost (WACC)
    2. Cost of Equity - CAPM method
    3. The concept of the marginal investor
    4. Beta (b) coefficient
  • Terminal Value
    1. Perpetuity/Gordon Growth Model
    2. Exit multiple

What you will learn

  • You will become familiar with building the three financial statements (Profit and Loss Account, Statement of Financial Position, and Cash Flow Statement) and interlinking them.
  • You will understand the evaluation method of companies and learn the relevant multipliers and (evaluation) models.
  • You will become familiar with uncertainty management methods by building various scenarios about the future.
  • You will improve the ability to make financial decisions
  • You will learn how to evaluate the parameters that are more important for specific financial key performance indicators (KPIs) and make remedial decisions to improve them.

Seminar Timetable

Date
1st & 2nd Teaching Hour
Break
3rd & 4th Teaching Hour
Break
5th Teaching Hour
19th of December
10.30 - 12.00
12.00 - 12.15
12.15 - 13.45
13.45 - 14.00
14.00 - 14.45
11th of January
18.30 - 20.00
20:00 - 20:15
20.15 - 21.45
13th of January
18.30 - 20.00
20:00 - 20:15
20.15 - 21.45
15th of January
18.30 - 20.00
20:00 - 20:15
20.15 - 21.00
Image

Course Start Date
December 2020

Cost of Attendance

€528
  • 16 Hours
  • Synchronous e-Learning
  • Attendance Certificate
  • Subsidized by LAEK

Lecturer

Michael<br/>Samonas
Michael
Samonas
CFO of the SIDMA Group