Finance and Accounting

Training Course: Financial Evaluation and Modeling


Register Now
Quick Inquiry
Discount Group Download Brochure (36)

FI234875

19 - 23 May 2025

Paris (France)

Cost : 5250 € 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

19 - 23 May 2025

Paris (France) -

Cost: 5250 € Euro


  About Paris

Lying on the River Seine, Paris is commonly referred to as the city for lovers, but it's actually a fantastic place for anyone to visit and explore. It's full of history, art, literature and amazing architecture for starters, but is also well known as being home to high fashion, which makes it a popular shopping destination. Visitors to the French Capital will find both high-end designer stores and quirky boutiques. The attractions of Paris range for art museums to shopping to simply taking a walk and soaking up the atmosphere. To top it all off, Paris has plenty of superb food and drink, in case there weren't already enough reasons to travel to Paris.


  Things to do and places to visit in Paris

Anyone who travels to Paris is in for a treat, as it is a beautiful city full of atmosphere. Many of Paris' attractions are world-famous, but it's also a city where you can find hidden gems. Taking a flight to Paris for a short visit is really like visiting a number of different cities, as all of its neighbourhoods, or arrondissements, have their own distinct character. Examples include the medieval Latin Quarter and the bohemian Marais. Each and every one is worth exploring.

Great things to do in Paris include:

  • Checking out the views from the top of the Eiffel Tower.
  • Seeing renowned masterpieces, including the Mona Lisa in the Louvre.
  • Taking a tour of the impressive, albeit slightly creepy, Paris Catacombs.
  • Marvelling at the beautiful Notre Dame Cathedral.
  • Browsing the designer stores around the Champs-Elysees.
  • Munching snails in one of the city's haute cuisine eateries.
  • Visiting the graves of luminaries including Oscar Wilde and Jim Morrison at Pere Lachaise Cemetery.
  • Admiring the imposing Arc de Triomphe.
  • Wandering around the boutiques of the Marais district.
  • Watching the famous Paris St-Germain football team play.
  • Taking in the Impressionist art at the Musee D'Orsay.
  • Watching the world go by from a cafe terrace.
  • Visiting the distinctive Centre Georges Pompidou.
 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