Financial Modeling I - Ernst & Young

77 downloads 301 Views 229KB Size Report
Duration. 2 days / 16 academic hours. 16 CPD-units / 14 CPE credits. Financial Modeling I: Model Development. Technique and MS Excel. Capabilities.
Financial Modeling I: Model Development Technique and MS Excel Capabilities Who should attend  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. Duration 2 days/ 16 academic hours/ 16 CPD-units/ 14 CPE credits

Objectives  To familiarize participants with the key stages of model development and the “golden rules” of Modeling  To familiarize participants with MS Excel capabilities used in financial Modeling

Required level of preparation

 To instruct the efficient use of MS Excel functions for evaluating behaviours pattern of expenses and application of regression analysis

Knowledge in financial statements, ability to prepare a Cash Flow Statement by direct and indirect methods and to use MS Excel

 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. Modeling objectives and rules  Objectives of financial Modeling and forecasting, application sphere of models  Key stages of Modeling (planning, development, testing)  Modeling “Golden rules”  Practical suggestion. Case Study in mini-groups Section 2. Modeling of operational decisions. Cost and price management. Sales, income and profitability management  Estimation of expenses’ behavior 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, Manager Scenarios, Goal Seek

Day 2  Decision optimization by linear programming choice of assortment, scheduling, optimization of investment portfolio, transport route 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 Certificates of the EY Academy of Business.

Place and time Open trainings are conducted at EY Academy of Business from 9:30 to 16:30.

In-company training  Preliminary analysis of clients’ training needs, identification of aims and goals  Training adaptation industry  Flexible approach to training location and schedules  Report on the training results on request.

Recommended training scheme  Cash Flow Statement (IFRS/US GAAP): Compilation with MS Excel  Financial Analysis I-II  Financial Modeling I: Model Development Technique and MS Excel Capabilities  Financial Modeling II: Financial Business Situation Forecasting  Risks of Investment Projects: Assessment and Computer Modeling  Business Valuation

How to apply? Please complete the registration form online at our web site: ey.com/cis/academy

2