Financial Modeling

What is a Financial Model?

A financial model is simply a tool that’s built-in Excel to forecast a business’ financial performance into the future. 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 as discounted cash flow analysis (DCF model), leveraged-buyout (LBO), mergers and acquisitions (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 practise 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 type 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 company which help us in making informed decision. Understanding 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 (e.g. accounts receivable, pre-payments, etc.)
  • Record financial statement transactions (e.g. 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

This module course demonstrates how a number of financial mathematics formulas can be used to conduct detailed analysis on a set of data and/ or variables.

  • Time value of money
  • Bond pricing and yields
  • Statistics & financial mathematics

Fixed Income Basics

In this module will introduce you to the main product and players in the fixed income markets. it illustrates the point covered using real market data and examples of the most commonly used Bloomberg screens for bonds. Core concept such as bond pricing, duration, and yield curves are covered in detail

Excel Crash Course

  • Designed for financial analysts in investment banking, equity research, FP&A, corporate development advanced functions so experts will learn a lot
  • Teaches excel 2016, 2013 and 2010
  • Review of the basics
  • Advanced functions so experts will learn a lot too

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

Financial Analysis Introduction

By the end of this module, you will have solid understanding of how to use ratio for Financial Analysis

Scenario & Sensitivity Analysis in Excel

How to perform scenario & sensitivity analysis in Excel for FP&A, investment banking and equity research

Financial Statement Modeling

In this course, you will develop a 3-statement model completely from scratch, inputting historical data and assumptions to project out financial statement using step-by-step instruction on selecting, locating, and developing appropriate drivers. At completion, you will have developed a complete and comprehensive three-statement model using various supporting schedules. By the end of the course, trainees will gain skills that lay the foundation for many other modeling methodologies

DCF Modeling 

  • Building 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

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

Business Valuation Modeling Course

This business valuation course provide participants with the skill needed to perform detailed business valuation modeling using three main methods: Comps, Precedents and DCF 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 jobs. Career paths may include accounting, finance, treasury, and corporate development.

Powerpoint & Pitchbooks

By the end of this module, you will have a solid understanding of how to use advanced Power Point Tutorial for Creating an Investment Banking Pitchbook

Leveraged Buyout LBO Modeling 

LBO models are used widely by investment banks and private equity firms to assess investor returns as well as to value a business in the event of a buyout. You will build a real leveraged buyout (LBO) model from scratch

Financial Modeling Using VBA

  • Explain the benefits of using VBA
  • Record macros and use the VBE window
  • See VBA in the context of financial modeling

Real Estate Modeling 

This Excel-based real estate financial modeling course is designed for development professionals, lending/banking analysts, surveyors, and anyone interested in mastering the art of building a real estate development models from scratch

Monte Carlo Simulation

In this Module we will performs 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 values from the probability functions

Linear Regression Model

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

Basic Understanding of Portfolio Management

By the end of this module, you will have a solid understanding of how to perform correlation, Beta, Covariance, Standard deviation using Historical Data

Portfolio Optimization Models

We will implement a portfolio optimization methodology based on capital asset pricing and mean-variance analysis. Our goal are to use consistent, repeatable steps and to construct realistic, optimal portfolios that are stable over time

Financial Modeling Certification