Finance and Accounting

Training Course: Financial Evaluation and Modeling


Register Now
Quick Inquiry
Discount Group Download Brochure (36)

FI234875

30 Mar - 3 Apr 2025

Dubai (UAE)

Cost : 4150 € Euro

Introduction

By distilling key information regarding cash flow levels and risks, financial modeling helps decision-makers make informed choices based on data analytics that move their firms forward.

In this training program, learn how to build financial models that can be used in corporate finance, investment banking, commercial banking, and portfolio management. The instructor covers financial statement models, investment banking models, M&A models, buyout models, and DCF models—all using Microsoft Excel.

Methodologies

Throughout the course, the instructor includes exercises—together with case studies—that can provide you with a practical understanding of these key topics.

Training Program Objectives

The main goal of financial modeling is to accurately project a company's future financial performance. Modeling can be useful for valuing companies, and determining whether a company should raise capital or grow the business organically or through acquisitions. It equips you with the fundamental knowledge and practical skills needed in Investment Banking, Equity Research, Portfolio Management, Project Finance, Credit Research, Financial Planning & Analysis, etc.

Training Outlines

Day 1

Financial Modeling Basics

  • What is financial modeling?
  • Why is financial modeling important?
  • Business questions and financial models
  • Data for a model
  • Sources of data
  • Gathering data from FRED for Excel
  • Getting started with the project
  • Excel tips for financial modeling

Corporate Financial Modeling: Three-Statement Financial Model

  • Linking financial statements
  • Setting source parameters
  • Three-statement financial model
  • Assumptions in financial statements
  • Forecasting in financial statements
  • Improving model quality
  • Putting it all together

Day 2

Evaluating Corporate Financial Models: Three-Statement Model

  • Financial modeling strategies
  • Sensitivity analysis and financial models
  • Adding visuals to a financial model

Investment Models: DCF Model

  • Financial valuation models
  • Cash flows in the valuation model
  • Terminal value in a valuation model
  • Interpreting a DCF model

Day 3

Banking Models

  • Beyond the basics in financial models
  • Corkscrews and models
  • Waterfalls and models
  • Adding toggles to a financial model
  • Model outputs
  • Hiding tabs and making models readable
  • Stress testing models

Day 4

Buyout Models

  • Interest rate assumptions in models
  • Discount rates in models
  • Top-down financial models
  • Bottom-up financial models
  • IRR decisions in financial models
  • NPV decisions in financial models
  • Limits of financial models

Financial Modeling across Industries

  • Characteristics of financial models
  • Modeling in banking
  • Modeling in corporate finance
  • Modeling in investments

Day 5

Building and Maintaining Models

  • Applications of financial models
  • Bitcoin and cryptocurrency valuation modeling
  • Updating financial models
  • Maintaining ongoing financial models

Financial Modelling and the International Business Environment

  • Define the Terms Model and Financial Model
  • Learn the 10 steps to create good Financial Models
  • Use Flowcharting Techniques to improve your model
  • Overview of the strategic and operational aspects of a global business entity
  • The Organizational Planning Model
  • The Product/Decision/Information Cycle
  • The Objectives of Financial Analysis
  • Creating wealth by adding value
  • Basic metrics of wealth creation and financial performance

Finance and Accounting

Training Course: Financial Evaluation and Modeling


Register Now
Quick Inquiry
Discount Group Download Brochure (36)

FI234875

30 Mar - 3 Apr 2025

Dubai (UAE) -

Cost: 4150 € Euro


  About Dubai

Dubai, located on the Persian Gulf, is one of the seven United Arab Emirates and one of the most popular tourist destinations in the world. The discovery of oil in the region has made Dubai extremely wealthy, allowing it to build the glittering skyscrapers that it is now famous for. That wealth is strongly in evidence in Dubai and visitors will see luxurious buildings and supercars aplenty. Perfect beaches and endless shopping opportunities are to key to Dubai's attractions. Flights to Dubai open up the city's cultural attractions to tourists, with beautiful mosques, museums and art galleries scattered throughout this ultra-modern metropolis.


  Things to do and places to visit in Dubai

Dubai's wealth has made it famous for building ever taller buildings and creating artificial islands off its shores. The city's hotels are luxurious and shoppers will love its extensive shopping malls which showcase all the world's top brands. Dubai's attractions don't end there. Dubai also caters to adventure lovers, who can jump in a 4x4 or on a board to speed over dunes outside the city. Local culture mustn't be forgotten either, and visitors have wonderful mosques to visit and old districts to explore. All that combined means that a flight to Dubai is sure to lead to an unforgettable holiday.

When visiting Dubai, be sure to:

  • Go to the observation deck of the Burj Khalifa, the tallest building in the world.
  • Admire the intricately beautiful Grand Mosque, which has the tallest minaret in the city.
  • Understand the local history and culture with a visit to the Dubai Museum.
  • Discover objects from the 6th century at Jumeirah Archaeological Site.
  • Go skiing – That's not a joke, the Mall of the Emirates houses a snowdome.
  • Go shopping at the Mall of the Emirates or the Dubai Mall.
  • Explore the desert surrounding the city – either by 4x4 or atop a camel.
  • Eat fantastic seafood at Dubai Marina.
  • Cool off at the Wild Wadi Waterpark.
  • Marvel at gorgeous Arabic calligraphy at Jumeirah Mosque, the biggest in the city.
  • Take a yacht tour around the artificial islands of Palm Jumeirah.
  • Haggle for souvenirs in one of the city's souks.
  • Wander around the traditional building in Bastakiya District.
 22 Portman Square, Marylebone, London W1H 7BG, UK
 3 Oudai street, Aldouki, Giza, Giza Governorate, Egypt
 0020233379764
 00201095004484
 00201102960555
 00201102960666
 19 Mayıs Mahallesi, 19 Mayis Street No 2 Sisli, 34360 Istanbul/Turkey
 00905357839460
 Australia Street, Raouche Beirut, Lebanon .، Beirut, Lebanon
 0096181746278
 811 Massachusetts Avenue, Boston, Massachusetts, 02118, USA
 6 Beirut Street - Fifth Circle Abdoun, P.O. Box 831370, 11183 Amman, Jordan
Copyright Global Horizon Training Center © 2019