H 4η σειρά των σεμιναρίων μας στη Χρηματοοικονομική Μοντελοποίηση ( Financial Modeling) θα ξεκινήσει το Δεκέμβριο και θα διαρκέσει 2 μέρες για κάθε σεμινάριο. Αναλυτικότερα:
1. “Εισαγωγή στη Χρηματοοικονομική Μοντελοπoιήση / Introduction to Financial Modeling”
- Παρασκευή, 18 Δεκεμβρίου από τις 9:00πμ έως τις 5:00μμ.
- Σάββατο, 19 Δεκεμβρίου από τις 9:00πμ έως τις 4:00μμ.
Συνολική Διάρκεια Σεμιναρίου: 15 ώρες
2. “Advanced Financial Modeling & Risk Analysis”
- Κυριακή 20/12, από 9:00πμ έως 5:00μμ
- Δευτέρα 21/12, από τις 9:00πμ έως 5μμ
Συνολική Διάρκεια Σεμιναρίου: 16ώρες
Εκμεταλλευτείτε την έκπτωση έγκαιρης εγγραφής (έως τις 18 Νοεμβρίου 2015) και εξοικονομήστε 20% ή εναλλακτικά εγγραφείτε στο σεμινάριο μαζί με ένα φίλο/φίλη για να πάρετε συνδυαστική έκπτωση.
Για περιορισμένο αριθμό θέσεων υπάρχει ειδική έκπτωση σε περίπτωση που εγγραφείτε και στα 2 σεμινάρια μας (Introduction to Financial Modeling και Advanced Financial Modeling & Risk Analysis), όπου μπορείτε να παρακολουθήσετε και τα 2 σεμινάρια με συνολική εξοικονόμηση έως και 50%.
Τα σεμινάρια διεξάγονται σε κεντρικό ξενοδοχείο της Αθήνας, κοντά σε σταθμό μετρό.
Για περισσότερες πληροφορίες / παρατηρήσεις μπορείτε να επικοινωνήσετε μαζί μας στο customercare[@]financialarena.gr ή στο info[@]myfinancialmodeling.com
Η σελίδα μας στο Facebook είναι: www.facebook.com/financialmodelingseminars
This seminar builds on your existing financial modeling skills and deals with more sophisticated topics so that participants can use those techniques to better analyze financial data, master their sensitivity analysis and risk modeling skills.
By identifying the factors that could cause variability in a model’s output, users will be able to estimate their likelihood and impact and optimize the decision process. The course is focused on the use of financial modeling in corporate situations like project appraisal, cost of capital estimation and company valuation.
As a result of taking this course, you should be able to:
1. Streamline model building by applying best practices.
2. Incorporate risk and uncertainty by creating scenarios and performing advanced sensitivity analysis.
3. Use advanced Excel formulas and scenario modeling techniques.
4. Minimize manual tasks and automate them by building macros into your models
5. Enhance model structure for more accurate analysis and forecasting and minimization of errors.
Course topics include:
1. a review of logical statements, Text Functions, use of Range Names, Lookup Functions, Scenarios/sensitivity analysis using Data Tables, Goal Seek, core Financial Functions and
2. mastering of Conditional functions , how to Remove Duplicates , Pivot Tables & Charts , Conditional Formatting, how to Import Data into Excel , From a Text or Word File , Using Web Queries to Import Data From the Web , The Spreadsheet Model development Process , Auditing , Error Trapping, Excel Solver tool , how to use excel to Solve Optimization Problems, use of Monte Carlo Simulation.
The seminar is designed for users who are competent in Excel and want to master their financial modeling skills. It is assumed that participants have a very good knowledge of the core functionalities of Excel and use advanced spreadsheet tools and functions on a regular basis.
Mr. Dimitris Leimonis
Application – Software Used
Participants are required to bring their own laptops and have installed Excel 2007 or 2010, Word, Adobe Acrobat Reader and PowerPoint. Mac users need Excel 2011 for the spreadsheet part and can use the respective applications for opening word documents, presentations and pdf files.
Who Should Attend
Financial Analysts, Accountants, Finance Managers, Consultants, Valuation & Budgeting Professionals, Investors, Business Students wishing to develop modeling skills.
Locations / Venues
Our courses in Athens are held in our Training Center at Chalandri while when we run them in other cities (Thessaloniki) are held in centrally located hotels. Registration fees include morning cofee/tea and refreshments. Detailed venue descriptions, times and logistics are included in the material we send after your register for the course.
Instructor – Short Bio
Mr. Dimitris Leimonis has more than 18 years of experience in a wide range of roles in investment management, banking, and professional financial training industry. Dimitris has extensive knowledge of the financial industry, with both practical and analytical experience, which makes him a very successful financial modeling expert. He has built, developed and used financial models to analyse risk, test scenarios, forecast results and optimize business and finance variables.
While working for a major asset management firm in SE Europe, Dimitris acquired extensive investment experience by managing a range of mutual funds and affluent client’s portfolios. He has worked as a mutual fund manager, managing money market, bond and equity mutual funds with AUM around €2billion. He has strong quantitative and analytical skills with an ability to understand complex financial structures and his a passionate financial trainer of advanced finance topics, like Financial Modeling, Portfolio Management, Derivatives, & Fixed Income.
Dimitris started his academic studies in Banking & Finance and continued with post-graduate studies with a Master of Business Administration (MBA) from Lebow College of Business – Drexel University, specializing in Management Information Systems and Investment Management. He has extensive corporate training experience and key involvement in the development of the training program of one of Greece’s largest financial institutions.
Certified by the Hellenic Capital Markets Commission as Portfolio Manager and Investment Consultant.
Specialties/ Key Skills: Financial Modeling, Risk Analysis, Mutual Funds, ETFs, Portfolio Management, Asset Allocation, Financial Analysis, Business Analysis, Financial Education and Training
On June 2014, the Institute for Chartered Accountants in England and Wales (ICAEW) launched its “20 Principles for Good Spreadsheet Practice”, at its headquarters in London. The Principles provide essential guidance across all aspects of effective spreadsheet use. They encapsulate decades of hard-won professional experience. They are a valuable body of work that advances the professionalism, commercial efficiency and effective risk management of spreadsheet modelling.
The FAST Standard Organization has created a short video that gives a good overview of the ICAEW event and introduces the principles.
The ICAEW was founded in 1880 and has offices in London, Brussels, Dubai, Beijing, Hong Kong and Singapore. It has more than 142,000 members worldwide. It provides qualifications and professional development, but also has a strong alumnus that brings thought leadership to the fields of accounting, finance and business.
During the presentation of the principles, Richard Anning, Head of ICAEW IT Faculty, said, “Poorly designed spreadsheets can cost businesses time and money but we believe that use of these principles will help organisations reduce risk and improve efficiency of spreadsheet use”.
Small and large businesses can lose money if they use poorly designed spreadsheets that lack basic components like integrity check, proper structuring and documentation. It is important to follow principles that will help your firm reduce spreadsheet risk and save time and money by avoiding critical errors.
You can download and read the 20 Principles for Good Spreadsheet Practice by clicking here.
ICAEW recommends that firms should adopt a standard and officially recognized FAST modeling Standard in their document. As of January 2016, Financial Arena is of the first accredited training providers globally to provide training for the FAST Modeling Standard Certificate. The FAST Modeling standard is an international recognized methodology in financial modelling that is used by major firms in their modelling assignments. (you download the FAST Standard or visit our page about FAST Standard).