Financial Modelling 04-07-2021

Financial Modelling Training Course in Dubai, UAE

Course overview

Course overview

This course provides an excellent basis for a comprehensive skill set in building financial models in Excel. The three fundamentals are emphasised: building the model, performing the valuation, and assessing the risks. We focus on building a complete corporate model, with the full set of P&L, balance sheet and cash flow statements modelled in detail.

Delegates will learn the analytical method to resolve the circular problem of balancing the P&L and balance sheet. Delegates also learn how to build an acquisition model with detailed timelines for simple, flexible, and dynamic modelling. Valuation modelling is completed for both the corporate and acquisition models. Risk assessment is performed with sensitivity analyses and scenario analysis. We close off the course with the development of the waterfall model for cash flow distribution, which is frequently applied in real estate development projects.

During this course you will be able to master competencies as follows:

  • Learn advanced Excel techniques
  • Create full financial models by yourself
  • Build a complete acquisition model
  • Comprehend how you can use all strengths and limitations of financial models
  • Master risk analysis skills to execute financial model flawlessly
  • Hone the skill to build interactive and dynamic models
Who Should Attend

Who Should Attend

  • Finance directors, managers, analysts, controllers, and account managers
  • Chief accountants
  • Accounting managers
  • Heads of finance departments
  • Corporate financiers
  • Bankers
  • All finance professionals
  • Everyone who wants to improve their financial literacy
What will you gain

What will you gain

  • Understanding of what a model is, and the limitations of financial models
  • Modelling best practices
  • A wide array of advanced Excel skills, which are required to build flexible and dynamic financial models
  • The ability to build a complete corporate model with the full P&L, balance sheet, and cash flow statement
  • The ability to build a complete acquisition model
  • Risk analysis skills for your financial model
  • The ability to build scenarios for your financial model
  • The ability to build dynamic and interactive dashboards
  • Understanding of how to model the waterfall cash flow distribution
Course Content

Key facts

 

Course code:
FI-106

 

Duration:
5 days

 

Course category:

 

Admission requirements:
None

 

Note:

 

Endorsement:
Certificate upon successful completion

Course schedule sample one day

08:30 AM  -  10:00 AM  -  First Training Session
10:00 AM  -  10:15 AM  -  Coffee Break
10:15 AM  -  12:00 PM  -  Second Training Session
12:00 PM  -  12:15 PM  -  Coffee Break
12:15 PM  -  02:00 PM  -  Third Training Session
02:00 PM  -  03:00 PM  -  Lunch and Networking
Fees & whats included

Fees & what is included

Early bird 70 days before course start date Early bird 25 days before course start date Regular Course Fee
USD 3,400.- USD 3,900.- USD 4,400.-
USD 2,050.-
  • For early registrations special prices apply as outlined above.
  • All fees are exclusive of VAT. Tax Registration Number : 100312636200003.
  • Companies - register 2 participants for the same course and date and get one place free.
  • Only one type of discount can be applied to the same course & date registration.
  • For larger corporate clients there are special packages. Contact us for details.

At Atton Institute we do our best to ensure that all our courses and trainings are provided with the highest industry standards, are time efficient and praxis related, and bring the best education results. Our courses have the most up-to date info and secure the excellent course fee to value ratio quality.

Course Fee Includes

  • Extensive Workbook with Course Materials
  • Handouts and other Supporting Materials
  • Practical Examples and Various Case Studies
  • Quick Reference/Top Tips Guide
  • Professional & Experienced Instructor
  • Accelerated and Intensive Learning Techniques
  • Relationship Building within Course
  • Post Course Action Plan
  • Index of Additional Suggested Materials
  • Course Completion Certificate
Free Valet Parking
Coffee Breaks
Lunch
Free WIFI access

Course certificate

Image for: Atton Institute Certificate

When would you like to start

Financial Modelling - 20 Sep 2020 Dubai, UAE
Financial Modelling - 13 Dec 2020 Dubai, UAE
Financial Modelling - 21 Mar 2021 Dubai, UAE
Financial Modelling - 04 Jul 2021 Dubai, UAE
Financial Modelling - 19 Sep 2021 Dubai, UAE
Financial Modelling - 12 Dec 2021 Dubai, UAE
Course Content

Course content

  • What is a model?
    • Models vs reality
    • Models and the future
    • How can models be used
    • The real power of models
    • The spreadsheet as an excellent tool for modelling
  • Modelling best practices
    • Foundation principles
    • The modelling life cycle
    • Structure and practices in spreadsheets
    • Using checks and verification
    • Documentation
  • General spreadsheet modelling tips
  • Macros in modelling
  • Overview of financial model types
  • Corporate models (model of a real publicly listed company: PepsiCo)
    • History
    • Common sizing and trend analysis
    • Projecting the P&L (future projections)
  • Corporate models (continued)
    • Projecting the balance sheet
      • Analysing historical trends and determining the assumptions
      • Creating the input schedule for the balance sheet
      • Analyse PPE requirements and prepare the depreciation schedule
      • Creating the projected balance sheet
    • Resolving the circularity between the P&L and the balance sheet when debt and interest are modelled
      • Complete the P&L and balance sheet
  • Create implied cash flow statement from balance sheet
  • Valuation in the corporate model
    • Dividend discount model
      • Steady state firm
      • Growing firm
      • Determining the cost of equity and WACC
      • Valuing PepsiCo using the dividend discount model
    • Discounted cash flow (DCF)
      • Determining the free cash flow for common equity
      • Applying the Gordon terminal value
      • Valuing PepsiCo using DCF
  • Acquisition model
    • Accessing historical records
    • Making your assumptions
      • Revenue, gross margins, operating cost, working capital, debt, PPE
      • EV/EBITDA multiple
      • Creating the Input tab
    • Creating flexible and dynamic timelines
    • Completing the P&L to determine PAT
    • Running the debt schedule
    • Running the CAPEX and depreciation schedule
    • Determining the free cash flow to equity
    • Completing the valuation and determining investment returns
  • Risk analysis
    • Sensitivity analysis
      • How sensitivity analysis techniques can be used for optimisation
  • Risk analysis
    • Sensitivity analysis (continued)
      • Selecting parameters of concern in the risk analysis
      • Performing sensitivity of outputs to varying levels of the risky input parameters, using 1-way or 2-way data tables in Excel
  • How sensitivity analysis can be used to check your model and uncover major errors
    • Fixing a major error in the corporate model
  • Scenario analysis
    • Considering the input parameters that will constitute the scenario space
    • Determine the scenarios that will reasonably cover the scenario space
    • Incorporating the scenarios into the model
  • Preparing the interactive and dynamic dashboard
    • Dynamic and flexible scenario analysis
    • Dynamic project lengths
    • Setting up dynamic ranges to allow the addition of scenarios with extra effort
  • The waterfall method of cash flow distribution (especially for real estate development projects)
Participant insights

Participant insights

The course was highly beneficial for my job and career. This info will clearly give me the great support for my day-to-day tasks.
Muhammed A. (Senior Auditor)Auditing Company, Dubai.
What I have learned in the course was exactly what I was looking for. Highly clear and pragmatic with perfect guidelines on how to use it at my work.
Antony S. (Manager) Drilling Equipment Company, Abu Dhabi.
A very useful course that provided new insights in the customer behavior and definitely would help me with my communications with customers.
Mario A. (Business Owner) Boutique Shops, Dubai.
Great thanks – one of the best courses I have made.
Brian G. (Projects Coordinator) Events Management Company, Ras Al Khaimah.
Exciting and inspiring course. Helped me to see things differently and re-organize our customer service department.
Abbas H. (Company Manager) Project Engineering, Muscat.
Would really suggest the training to any professional who is in charge of customer care.
Jane A. (General Manager) Real Estate Company, Dubai.
The time spent at course was really enjoyable and useful. Easy to understand and I used part of knowledge the next day after training.
Samira K. (Sales Team) Car Rental, Abu Dhabi.
Was the real great overview on what I shall do to improve in the Customer Service in my business.
Syed H. (Company Owner) Data Storage Solutions, Dubai.
The info I received on the course is the surprise for me. Never though of such simple techniques which help to handle difficult customers conversations.
Gabriela H. (Manager) Call Center, Sharjah.
The training I have chosen was very useful and informative with a number of very useful points. Was well explained by the trainer.
Colin G. (General Manager) Safety Equipment, Riyadh.
The program was very explanatory and gave me a lot of points to re-think. Would sure make a difference to my work approach.
Gabriela Y. (Supervisor) Call Center, Kuwait.
Would recommend to my team members to attend the same course. It would positively help me to do my job better.
Udo C. ( Department Head) Heavy Machinery Maintenance, Abu Dhabi.
The time spent at the course was the excellent investment – a lot of useful and practical info. Exactly what I was looking for.
Idul R. (Supervisor Sales) Construction Materials, Umm Al Quwain.
It was great idea to join such training. Would be a definite backing in my career development. Thinking of taking more courses – on other subjects.
Cristina R. (Sales Coordinator) Retail Company, Dubai.
The training was a great mixture of information and practical aspects. The instructor was highly professional and the course was organized the excellent way.
Samaa J. (Projects Manager) IT Solutions, Oman.
I really liked the scope and the style of the training – very friendly, a lot of communication and highly informative.
Stefan L. (Client Relationships) Insurance Company, Doha.
It was a great idea to join such training. All members of our team shall complete it. A lot of new points and useful hints.
Burcu W. (Marketing Head) Corporate Banking, Abu Dhabi.
Was really pleased by the content of the course and qualifications of the instructors. Got a lot of useful points for my business.
Marty Z. (General Manager) Travel Company, Dubai.
Great trainer and perfect information materials. Was really worth to attend. A lot of insights and ideas on how to improve job performance.
Daniel D. (PR Officer) Private Hospital, Muscat.
As we were in the process of restructuring of our call center this training was just perfect for the time. Remarkable and valuable suggestions and solutions.
Joselito B. (Marketing Department) E-commerce, Dubai.
The course was very beneficial and practical for my duties. Handling complicated customers from now on would be easier. Great instructor. Perfect training venue.
Amira Z. (Sales Manager.) Designer Apparel, Abu Dhabi.
FAQ for Internal Part of the Courses:

FAQ

We use the best and latest educational praxis. All of our courses and trainings are designed using our unique Atton LPI Learning Methodology© which guarantees the delivery of extensive knowledge over a short time period with an easy-to-understand approach. All course materials are absolutely unique and are the combination of fundamental and systematic knowledge, practical studies and real-life implementation elements.

We deliver in our 3- to 5-days trainings knowledge and skills which are commonly delivered over a much longer period of time – thus truly saving our participants time and money.

Each course has a comprehensive description and content breakdown, which means you can easily check how a certain training may fit your expectations and requirements.

If your aim is to obtain the most wide-ranging overview in a certain area of expertise, we commonly suggest that you choose one of our popular trainings in the relevant category. The popular trainings cover the widest scope in each area and for this reason they are greatly valued by our participants.

If you need help in choosing the best course for you, please get in touch with our STUDENTS SUPPORT DEPARTMENT.

There are various payment options – cheque, cash, and bank transfer. It is essential to note that the earlier you register, the larger the applicable discount on your admission fee.

For details on the available discounts and special training admission fees, please see the section “Course fees and discounts” on the course page.

Each course participant obtains the Atton Institute Course Completion Certificate, which is protected by means of several authentication elements. Each Atton Course Certificate can be additionally verified by contacting our administrative office or via the special online authenticity check system on our website.

Professional, up-to-date expertise is one of the most powerful elements of success in the modern business and career environment.

Our Courses and Trainings are highly useful for business owners, management and employees at all levels and provide, in a highly effective way, current and solid professional development qualifications and skills combined with practical real-life essentials.

  • Choose your course (feel free to get in touch with us for support).
  • Select the desired date and location of the course.
  • Proceed with course registration (online or via e-mail or phone).
  • Upon registration, you will receive invoice to finalize the registration.
  • Upon payment of the Admission Fee, your course registration is completed.

Each training is repeated a certain number of times over the year, and thus you have the option to choose the most suitable date for you. If you wish to benefit from the option of a course fee discount, be sure to register in advance.


ATTON News Coverage
Why Choose ATTON