Elegant Training Center Financial Modelling Elegant Training Center
Price: USD 544
100% Money Back Guarantee
No questions asked refund With a goal of giving you a worry-free and secure enrollment experience, We offer a 24 hour money-back guarantee. Just send us a refund request via email within 24 hours after first class and we will refund 100% of your payment, no questions asked!
Instructor led live virtual classroom online. Classes may be individual or in group.
  • Duration / Course length: Upto 20 Hours
  • Timings: Enquire

    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 16 July, 2023

    Eligibility / Requirements

    Bachelor Degree 
    Advance Excel
    Accounting knowldege

    Job roles this course is suitable for:

    Financial Analyst , Financial Controller , Chief Financial Officer , CFO , Finance Manager , Portfolio Manager , Wealth Manager , Fund Manager , Head of Finace , Finance Director

    About Elegant Training Center

    Elegant Professional and Management Development is a leading training center in Al Barsha, Dubai, specialized in affordable and effective face-to-face training programs in variety of courses like Engineering & IT, Finance, Sales & Marketing and HR & Administration.
    We design and customize courses and program for people of different walks whether trying to enter into the job market or employees willing to achieve professional development and qualification to secure advancement in their careers and improve their performance level.
    Our training is stretching, motivating and tailored to the individual learner. We develop and deliver training courses for organizations across all sectors. All of our courses can be tailored specifically to your team’s needs and delivered at your site as well

    See all Elegant Training Center courses

    Enquire about this course

    You may add more courses here,
    your list will be saved.

    Rate this page