Financial Modeling in MS Excel

PwC Academy invites you to participate in seminar «Financial Modeling in MS Excel»

 

Target audience 

The seminar is designed for professionals working in finance, economics, analysts and other specialists responsible for the economic calculations and supporting management decisions.

Participants should have basic proficiency in MS Excel.

 

Objectives of the seminar 

  •  Clearly understand the methodology for effective analytical modeling
  •  Understand the universal tools used in financial modeling
  •  Acquire the skills needed for constructing reliable and transparent financial models

 

PwC Academy methodology is based on the following principles: 

  •  Clearly presenting the material
  •  Re-enforcing acquired skills through practical exercises and analysis of examples in MS Excel

 

Main topics of the seminar

  •  Financial modeling best practices
  •  The structure of financial model in MS Excel
  •  Rules for entering and processing financial data, presentation of analytical results
  •  Working with ranges:

– Required settings

– Restrictions and recommendations for the use of  range names

–  Specifics of using range names in formulas

  •  Step-by-step creation of a model in MS Excel
  •  Quality control and audit of a model
  •  Sensitivity analysis - substitution tables

 

Practical exercises

During the workshop, participants work on a detailed case study in building a financial model for an investment project in MS Excel.

The most useful techniques of financial modeling will be illustrated with additional examples.

Student materials include a compact disk with a sample financial model.

 

Duration of the seminar

18 academic hours / 2 days

 

Dates

Session I - 9, 10 May 2013
Session II - 21, 22 June 2013

 

Fee

350 USD (excluding VAT)

 

Registration deadline

22 April 2013 for May session
31 May 2013 for June session

 

Language

The seminar will be conducted in Georgian using English-language materials

 

Booklet (to be attached here)

The detailed information regarding the Seminar is available in the attached booklet and  via indicated link http://www.jobs.ge/client/pwc

 

To register for the seminar please contact us at below details:

Contact information

Program Management

George Okroashvili, Manager                                             

office.:    +995 32 250 80 50                        

mobile.: +995 577 50 10 15                          

george.okroashvili@ge.pwc.com     

 

Administrative Support

Irma Gogotishvili, Marketing Coordinator

office.:  +995 32 250 80 22

mobile.: +995 577 42 22 09

irma.gogotishvili@ge.pwc.com