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
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.