Financial Modeling with Advance Excel

  • June 9 - March 8, 2021

Course overview

Course description

The financial model serves as a very vital decision-making tool in business and its development requires a high level of expertise in various disciplines, understanding of commercial practicalities, accounting and finance knowledge, technical ability, quantitative analysis and logic, financial modelling best practice and methodologies. A financial model lies at the heart of the decision-making process in most business situations.   Over course has been designed under our training methodology and reflects knowledge & practice material from a variety of sources.   We will help you to develop the skill to distil complex business situations, translating and reflecting these into useful financial models that can provide deeper insight and better enable the decision-making process.

Who should Attend

  • Finance managers/ chief financial officers Finance/ business controller
  • Financial analysts Branch managers
  • Employees responsible for planning, budgeting and forecasting.
  • Management consultants Non-finance manager seeking management position Financial modelers

Pricing

Initial price :1800 US$

  • Register one month before and save 15 %
  • Register two months before and save 20%
  • Group registration of 4 students save 25%
  • 12:02 AM — 11:59 PM
    Morning
    Introduction to Financial Modelling
    Most Common Errors in Financial Modeling
    Quick Review of Valuation Standards
    Key Stages in Financial Model Building and Learning Roadmap
  • 12:02 AM
    Components of Financial Statement under IFRS
    Understanding the Components of Financial Statement under IFRS
    IFRS Standard Setting and Framework
    IFRS Key Standards Introduction
    Review of Financial Statements of Multinational Co.
  • 12:02 AM
    Afternoon 
     Finance Analysis, Interpreting and Preparing Insights & Foresights
    Financial Analysis
    Types & Tools of Financial Analysis
    Practice Horizontal or Trend Analysis
    Practice Vertical Analysis or Common-Size Statements
    Practice Ratios (Financial, Profitability, Liquidity, Investment, Solvency, Managerial Efficiency)
    Analyzing, Interpreting and Reporting
    Review of Forward Looking Statement from Canadian Multination Company’s Financial Statemen
  • 12:02 AM
    .
  • 11:30 AM
    Morning
    Time Value of Money
    Time Value of Money
    Practice Compounding & Discounting
    Practice Annuity & Perpetuity
  • 11:30 AM
     Working Capital Management
    Importance & Management
    Working Capital Components
    Working Capital Management Enablers
    Working Capital Management Technique Inventory Management
    Receivable Management
    Payable Management
    Management Info Graph
  • 11:30 AM
    Afternoon
    Investment Appraisal & Valuation Techniques
    Payback Method, ROCE
    Net Present Value (NPV)
    Internal Rate of Return ( IRR)
    Adjusted Present Value
    Valuation by (» Market Approach » Income Approach » Asset Approach)
    Cash Flow Equity and Entity Approach 
  • 11:30 AM
    .
  • 11:30 AM
    Morning
    Investment Appraisal & Valuation Techniques
    Business Valuation Approaches and Real Life Examples
    Due Diligence Check list Review and Application
    Excel Models for Each Method with the Real life Examples Filled out.
  • 11:30 AM
    Afternoon
    FinaInvestment Appraisal & Valuation Techniquesncial Modelling Best Practices
    WAAC Calculation for Private Co. Case Study
    Valuation of Small and New Businesses
  • 11:30 AM
    .
  • 11:30 AM
    Morning
    Excel Spread sheet Practice - Basic and Advance
    Data
    Data Reporting: Pivot Table
    Data Reporting: Power Pivot Table  
    Practice Common Excel Functions used in Modelling
    Solver Installing the solver add-in » Solver parameters » Decision Variables and Constraints.
    Auditing Model in Excel
    What if Analysis Practice in Excel (» Goal Seek Function » Scenario Manager » Data Table)
  • 11:30 AM
    Afternoon
    Financial Modelling Best Practices
    Review of Six steps of Financial Modeling
    Assumption Summary
    Audience Categorization
    Summary to Detail
    Technology & Tools Used for Modelling
  • 11:30 AM
    .

Upcoming Trainings

TIITLE LOCATION DATE
Accounting & Finance UAE Tuesday, 7 July 2020
certified in international financial reporting standards UK Tuesday, 7 July 2020
Finance for Non-finance Professionals SAUDI ARABIA Tuesday, 7 July 2020
Request for inhouse customized training

Email:
nadir.malik@accountaxsquare.co.uk

Nadir Malik

founder & ceo

areas of expertise
  • Performance improvement
  • Planning & Budgeting
  • Digital Transformation
  • IFRS
  • Acquisition & Integration
  • Financial Modeling
education
  • Associate Chartered Accountant from ICAEW, UK
  • Associate Chartered Accountant from ICAP Pakistan
  • Certified Internal Auditor, IIA, USA
  • Master in Business Administration, Leeds Business School, UK
  • Lean Six Sigma Green Belt Certification, IIL USA

With over 15 years of experience in performance improvement, digital transformation (implementation of accounting platforms, management reporting and visualisation tools) data analytics, planning, budgeting & forecasting, change management, financial modelling, acquisition and post-M&A integration, IFRS & management reporting, end-to-end process review and internal control implementation, risk management and business strategy formulation.

Through the experience of working with C-suites, I have acquired an unmatched depth of knowledge and breadth of capabilities to stir businesses in today highly volatile business environment

Nadir has completed his training from Deloitte and afterwards he served KONE, a leading engineering company headquartered in Finland.

Download Brochure

CONTACT Details

  • +971 56 920 7227
  • nadirmalik@accountaxsquare.co.uk