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 PMMorningIntroduction to Financial ModellingMost Common Errors in Financial Modeling
Quick Review of Valuation Standards
Key Stages in Financial Model Building and Learning Roadmap -
12:02 AMComponents of Financial Statement under IFRSUnderstanding 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 AMAfternoonFinance Analysis, Interpreting and Preparing Insights & ForesightsFinancial 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 AMMorningTime Value of MoneyTime Value of Money
Practice Compounding & Discounting
Practice Annuity & Perpetuity -
11:30 AMWorking Capital ManagementImportance & Management
Working Capital Components
Working Capital Management Enablers
Working Capital Management Technique Inventory Management
Receivable Management
Payable Management
Management Info Graph -
11:30 AMAfternoonInvestment Appraisal & Valuation TechniquesPayback 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 AMMorningInvestment Appraisal & Valuation TechniquesBusiness 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 AMAfternoonFinaInvestment Appraisal & Valuation Techniquesncial Modelling Best PracticesWAAC Calculation for Private Co. Case Study
Valuation of Small and New Businesses -
11:30 AM.
-
11:30 AMMorningExcel Spread sheet Practice - Basic and AdvanceData
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 AMAfternoonFinancial Modelling Best PracticesReview 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 |
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.