Financial Modelling and Risk Analysis Best Practices

Programme Overview

The purpose of this training is to enhance your existing Excel modeling skills and learn how to build and modify financial models faster by learning and applying industry best practices. The seminar highlights the core financial model design and construction techniques that every modeler should know. This seminar will allow participants to adopt a structured and comprehensive design strategy to develop rigorous financial models, in less time and with greater accuracy.
This hands-on workshop will also teach you how to perform risk analysis and apply uncertainty into a model and undertake a more dynamic analysis to improve decision making by developing a risk assessment into an @RISK model.

Requirements

Attendees should bring their own laptop, ideally one they are accustomed to using, with a Microsoft Windows operating system, with Microsoft Excel 2010 or 2013 installed and have a basic understanding of MS Excel (e.g. syntax of IF statement, purpose of $s for anchoring cell references).
The Mac version is radically different and it is not recommended to use during the course.

Key Learning Outcomes

  • • Understand essential steps in designing simple, yet powerful financial models and cope with well-known model complexities by applying best practice modelling principles and techniques
    • Apply core and advanced spreadsheet functions and techniques to construct effective models
    • Master the development of models for project appraisal and decision making
    • Learn to create and compare alternative scenarios – base case, best case, worst case.
    • Identify the importance of uncertainty for model building

Designed for

  • Directors, GMs, VPs, Senior Managers, Managers
  • CFOs &Finance Managers
  • Corporate Finance & Business Development Professionals
  • Business & Financial Analysts
  • Risk Managers and Portfolio Managers
  • Financial Controllers and Accountants
  • MBA’s & Business Undergraduates
  • Heads of Business Units & Business Planners
  • Finance & Accounting staff
  • Project Managers and Risk Analysts
  • Industry Consultants

Programme Focus

Explore and Practice the core Financial Modeling Design and Construction techniques:

  • Effective Model Design & Construction – Best practices overview
  • Separating Inputs, Calculations and Outputs – Key Modeling tips & steps
  • Preventing critical errors
    • Techniques to reduce potential errors, error-check creation
  • Which function or formula is most appropriate in alternative Modeling situations?
  • Review of the most commonly-used Excel functions in financial Modeling
  • Timing Issues (Corkscrews, Base calculations etc)
  • Smart Techniques for quick and efficient Modeling – Use of keyboard shortcuts

Advanced Excel techniques for creating automatically expanding charts and ranges:

  • Sensitivity Analysis & Optimization techniques
  • Reporting and Managing Results/Outputs
  • Adding uncertainty to deterministic models using @RISK environment
  • Select the proper distributions depending on the nature of their model / project
  • Fit distributions to data
  • Perform Simulating and fine-tune simulation settings

Benefits for you

  • Enhance your Financial Modeling skills by learning the latest methods and tools to create solid financial models, following industry best practices.
  • It would be a valuable opportunity to capitalize on the trainer’s well rounded experience and in-depth knowledge on the topic.
  • The case studies will leave you with hands-on experience that will yield immediate benefits to your daily work.

Free Takeaway

Various templates are going to be offered in line with the methodology discussed, that will help participants to apply principles and techniques presented and adjust them to their own operating requirements.

Details


Dates:
20 & 21 October 2020

Time:
9:00 – 17:00

Duration:
14 hours

Venue:
CIIM Limassol, 3-5 Chaidariou Str. (view map)

Language of Instruction:
English

Instructor:
Mr. Dimitris Leimonis

Participation fees


Fee: € 606.90

HRDA Subsidy: € 238

Final Fee: € 368.90

* The programme has been approved by HRDA. Click here to find out more about HRDA and other special discounts

Apply Now

To proceed with your registration, please complete the form below. Participation is subject to availability.

Please enter the details of the person who submits this registration:
*
*
*
*

Please select one of the following options:

*
*

Please select the number of participants who will join this programme. You may register up to 10 participants on the same application.

*
Invoice Details
*
*
*
*

1st Participants Details

*
*
*
*
*

3rd Participants Details

*
*
*
*
*

5th Participants Details

*
*
*
*
*

7th Participants Deatils

*
*
*
*
*

9th Participants Details

*
*
*
*
*

2nd Participants Details

*
*
*
*
*

4th Participants Details

*
*
*
*
*

6th Participants Details

*
*
*
*
*

8th Participants Details

*
*
*
*
*

10th Participants Details

*
*
*
*
*
Terms and Conditions (“Terms”)
Last updated: January 26, 2015

Please read these Terms and Conditions (“Terms”, “Terms and Conditions”) carefully before registering to our programmes (“programmes”) and accessing our online application form (the “Service”), both operated by the Cyprus International Institute of Management (“CIIM”, “Executive Education”, “us”, “we”, or “our”). Your access to the Service is conditioned on your very acceptance of and compliance with these particular Terms. Effectively, these terms apply to all visitors, users and others constituents (“you”, “your”, "persons", “customer”, “participant”, or “company”) who may demonstrate interest in our Service. By accessing this Service, you actually agree to be legally bounded by these Terms. In contrast, if you are in disagreement with these Terms and Conditions, we kindly advise you to exit this Service immediately.

1. Personal Information

By using this Service, you in effect agree that CIIM is empowered with full authority to maintain an internal record of your personal details. Your personal details are collected when registering to the CIIM programmes and enquiry forms.

In particular, for the purpose of promoting CIIM's programmes and activities, you are kindly informed that your personal information including current and former participation to programmes, testimonials, full name, position, company and company logo may be used without your prior concent or consultation with you. If you do not wish CIIM to have your details included in our promotional activities, please notify us of your objections by writing to execedu@ciim.ac.cy or to Cyprus International Institute of Management, 21 Akademias Avenue, Aglandjia, P.O. Box 20378, 2151 Nicosia, Cyprus.

We wish to assure all persons interested in our Service that we will not sell, distribute or lease any of your personal information to third parties unless we have your permission or we are required by law. At the same time, we wish everybody know that we are committed to ensuring that access to personal information in our records is completely secured. Therefore, for the purpose of preventing unauthorised access or disclosure of classified information, we have put in place adequately safe physical, electronic and managerial procedures to control all access to our information databases.

2. Registrations

This Service is intended to collect information for your participation in our programmes. However, we cannot guarantee your automatic participation or seat reservation to our programmes, considering that practical limitations may arise. CIIM reserves the right to change or cancel the dates of the programme, without your consent. In the event of cancellation or modification of the time schedule of the programme, it will be our duty to give you adequate notification for the any schedule changes.

3. Tuition and Programme Fees

Tuition is due upon your acceptance by the CIIM into the programme you have applied for. However, prices are subject to change without notice. Furthermore, if you fail to settle your invoice prior the commencement of the programme, CIIM reserves the right to cancel/withdraw your application and refuse your participation. Additionally, if you fail to settle your invoice,  even after the commencement of the programme, CIIM reserves the right to proceed with legal actions for damages.

4. Cancellation of Registration

Cancellations must be received in writing. Cancellations received more than seven (7) days prior to a program’s start date will not incur penalties. On the other hand, for cancellations received less than seven (7) days prior to a program’s start date, you will incur a charge of 100 percent of the full tuition. In this case though, substitutions may be welcomed considering the service capabilities of CIIM. If a participant or a participating company fails to attend the programme they have applied for without any prior notification, even if a withdrawal occurs on or after a program start date, full tuition may be forfeited.

5. Refunds and Transfers of Registrations

Participants who would like to request a full refund for their participation, or need to transfer their participation to another CIIM programme, may be eligible to do so considering that the start date of the original programme is no less than seven (7) days. Requests to refunds received less than seven (7) days prior to the start date of the programme, will be forfeited. However, in this case though, transfers of registrations may be welcomed considering the service capabilities of CIIM. If a participant or a participating company fails to attend the programme they have applied for without any prior notification, even if a withdrawal occurs on or after a program start date, full tuition may be forfeited.

6. HRDA Subsidy

The Human Resource Development Authority (HRDA) provides a subsidy i.e. partial or full tuition coverage, to organisations participating with their employees in the Authority's programmes, only if they can meet the Authority's criteria. In order to confirm your eligibility to participate in the Authority's programmes, we provide you with the Authority's programme form for which you need to return to CIIM fully completed. If for whatever reason, the HRDA refuses to provide a subsidy for your attendance to our programmes, you and your company will be liable to immediately reimburse CIIM with the gross fees, which were supposed to be covered by the HRDA subsidy. If you fail to meet your legal costs to CIIM, we reserve the right to proceed with legal actions for damages.

Additional Policies

1. Termination of Service

We may terminate or suspend access to our Service immediately, without our prior notice or any liability on our part, for any reason whatsoever, if you breach the Terms included in this agreement. All provisions of the Terms which by their nature should survive termination shall survive termination, including, without limitation, ownership provisions, warranty disclaimers, indemnity and limitations of liability.

2. Governing Law

These Terms shall be governed and construed in accordance with the laws of Cyprus, without regard to its conflict of law provisions. Our failure to enforce any right or provision of these Terms will not be considered a waiver of those rights. If any provision of these Terms is held to be invalid or unenforceable by a court, the remaining provisions of these Terms will remain in effect. These Terms constitute the entire agreement between CIIM and you regarding our Service, and supersede and replace any prior agreements we might have between CIIM and you regarding the Service.

3. Changes

We reserve the right, at our sole discretion, to modify or replace these Terms at any time. What constitutes a material change will be determined at our sole discretion.

4. Insurance Coverage

CIIM requires that all participants maintain their own insurance for medical care, illness, and injury. CIIM is not responsible for medical expenses incurred while attending a program. Please make sure that any private insurance provides valid coverage in Cyprus.

Contact Us

If you have any questions about these Terms, please feel to contact us using the information below:

Telephone: +35722462246
E-mail: execedu@ciim.ac.cy
*