Financial Modelling

Course details

What is the financial model?
A financial model is simply a tool that's built-in Excel to forecast a business' financial performance into the ; The forecast is typically based on the company's historical performance, assumptions about the future, and requires preparing an income statement, balance sheet, cash flow statement and supporting schedules (known as a 3-statement model). From there, more advanced types of models can be built such DCF,LBO, M&A, and sensitivity analysis
What You Will Learn in Financial Modeling
•    Excel shortcuts and functions frequently used in financial modeling
•    Excel settings and formatting best practices for financial modeling
•    Creating model plugs via the revolver and cash sweep
•    Dealing with circularities in the model
•    Building a fully integrated 3-statement model using established forecasting and schedule conventions
•    Balancing the model and inserting automated checks
•    Perform sensitivity & scenario analysis
•    How to efficiently check models for errors, accuracy, and integrity
Jobs after Financial Modeling
There are many different types of professionals that build financial ; The most common types of career tracks are investment banking, equity research, corporate development, FP&A, and accounting (due diligence, transaction advisory, valuations, etc).
Accounting Basic
We explore the layout of the balance sheet, income statement, and cash flow statement; and demonstrate how to prepare financial statements from scratch
Understanding Financial Statements
This Module will cover understanding the financial strength of the Company which helps us in making an informed decision. Understand the financial strength of a company and help us to make informed decisions
Constructing an income statement and balance sheet
By the end of this module, you will have a solid understanding of how to construct a balance sheet and income statement.
•    Explain the format of the income statement and balance sheet
•    Define various financial statement terms ( accounts receivable, prepayments, etc.)
•    Record financial statement transactions ( invoicing, raising equity, buying inventory, etc.)
•    Prepare a simple income statement and balance sheet
Constructing a cash flow statement
we explore the layout of the cash flow statement, explain the differences between the cash flow statement and the income statement, and prepare a cash flow statement from scratch. By the end of this module, you will have a solid understanding of how to construct a cash flow statement.
•    Outline the format of the cash flow statement
•    Explain the difference between profit and cash
•    Prepare a simple cash flow statement using the balance sheet and income statement
Financial mathematics course
•    Time value of money
•    Bond pricing and yields
•    Statistics & financial mathematics
Fixed Income Basics
In this Module will introduce you to the main products and players in the fixed income markets. It illustrates the points covered using real market data and examples of the most commonly used Bloomberg screens for bonds. Core concepts such as bond pricing, duration, and yield curves are covered in detail
Introduction to Corporate Finance
In this Module will introduce you to the Understanding of Capital Markets, Business Valuation, Mergers & Acquisitions, Equity Financing, Debt Financing
Advanced Excel Modeling
This module will cover practices in Excel for building models with tips and tricks, better formulas, and scenarios planning
Scenario & Sensitivity Analysis in Excel
How to perform scenario & sensitivity analysis in Excel for FP&A, investment banking, and equity research
Financial Statement modeling
DCF Modeling
•    Build a complete, working discounted cash flow (DCF) model in Excel from scratch, using a real case study, industry best practices, and sensitivity analyses. DCF analysis is both academically respected and widely used as a primary method of valuation
Company case study
      Amazon Case Study: Value AMZN Shares with a Detailed DCF Model and Comps Analysis

Monthly cash flow modeling
This course is critical for anyone working in Financial Planning & Analysis (FP&A), accounting, or finance departments and is required to build monthly financial models in their ; Career paths may include accounting, finance, treasury, and corporate development.

Merger and Acquisition Model
In this course, you'll learn how to build a real M&A (accretion/dilution) model in Excel from scratch. In addition, you will build a contribution, synergy, and exchange ratio analysis, and learn key M&A accounting concepts

Linear regression Model
This Course introduces a simple linear regression model. You will learn to assess the relationship between variables in a data set and a continuous response variable.

Basic understanding of Portfolio management
 
Monte Carlo Simulation
In this Module, we will perform risk analysis by building models of possible results by substituting a range of values—a probability distribution—for any factor that has inherent uncertainty. It then calculates results over and over, each time using a different set of random values from the probability functions
Portfolio Optimization Models Updated on 23 January, 2024