Financial Modelling I: Model Development Technique and MS Excel Capabilities Who should attend • • • • •
Duration 2 days/ 16 academic hours/ 12 CPD-units/ 14 CPE credits Required level of preparation Knowledge in financial statements, ability to prepare a Cash Flow Statement by direct and indirect methods and to use MS Excel
Credit analysts Chief financial officers Financial analysts Managers of all branches of the economy Employees responsible for budget planning, writing company operational and investment plans, making decisions on crediting.
Objectives • To familiarize participants with the key stages of financial model development and the “golden rules” of modelling • To familiarize participants with MS Excel capabilities used in financial modelling • To instruct the efficient use of MS Excel functions for evaluating behaviours pattern of expenses and application of regression analysis • To instruct how to carry out income sensitivity analysis and evaluation of profitability index sensitivity to changes in market conditions using Data Table macros • To exercise practical skills for targeting profitability indexes and solvency indicators using the Goal Seek macros • To familiarize participants with the theory and practice of operational decision optimization: choice of assortment, scheduling, optimization of investment portfolio by application of the Solver tool • To exercise practical skills for computation of investment performance measurements using MS Excel: PV, FV, PMT, NPV, IRR, XNPV, XIRR.
Training methodology Training participants are provided with specially designed training materials in Russian. The theory is illustrated by practical examples on personal computers. Training participants are provided with practical examples studied in electronic format that can be used in their practical work.
Financial Modeling I: Model Development Technique and and MS Excel Capabilities
Training peculiarities •
Application of MS Excel capabilities for their use in meeting tactical objectives in making managerial decisions (computation of break-even points, regression analysis, etc.)
•
Technique of data definition while developing financial models, evaluation of individual factors’ impact on the final result
•
Training customization according to a particular industry at client’s request under a preliminary agreement with the instructor (applicable for corporate clients).
Training outline Day 1 Section 1. Modelling objectives and rules •
Objectives of financial modelling and forecasting, application sphere of models
•
Key stages of modelling (planning, development, testing)
•
Modelling “Golden rules”
•
Practical suggestion. Case Study in minigroups
Section 2. Modelling of operational decisions. Cost and price management. Sales, income and profitability management •
Estimation of expenses’ behaviour pattern. Regression analysis. Case Study: Regression
•
Estimation of profit sensitivity to changes in market conditions. Factor analysis. Case Study: Data Table
•
Analysis of return on equity (ROCE, ROE). Factor analysis. Goal seek. Case Study: Data Table, Goal Seek
2
Day 2 •
Decision optimization by linear programming choice of assortment, scheduling, optimization of investment portfolio, routes optimization. Case Study: SOLVER
Section 3. Investment decision making •
MS Excel application for computation of investment project parameters
•
MS Excel functions and Case Study: PV, FV, PMT, NPV, IRR, XNPV, XIRR. Cash flow adjustment for investment project evaluation
•
Applying SPINNER macros for scenario analysis of investment project.
Certificates Certificate of the EY Academy of Business.
Place Open trainings are conducted at EY Georgia Office Kote Abkhazi street, 44, Tbilisi, 0105, Georgia Big Conference room – “Shkhara”.
Date and time 12-13 December, 2017 from 10:00 till 16:00 in Russian
Price The price of the training programme is - 1,300 GEL + 18% VAT;
Application form Please complete this form and return by e-mail to Giorgi Chaganava: •
Name & Surname:
•
Company name:
•
Address:
•
Mobile:
•
E-mail:
I confirm my attendance to Financial Modelling I: Model Development Technique and MS Excel Capabilities Training Programme
How to apply? Please complete and send the registration form by e-mail to
[email protected]
