Image
  • Home
  • About us
  • Services
  • Courses
    • MTC Courses
      • Business Skills
      • General Banking, Accounting and Finance
      • Hotel, Health and Safety
      • Human Resources, Training and Development
      • MTC School of Government
      • People Management
      • Personal Development
      • Sales and Marketing
      • Service Skills
      • The Senior Executive Programmes
    • TCL Courses
      • Contract, Project Management and Business Skills
      • Electrical Engineering
      • Health, Safety, Security & Environment
      • Maintenance, Instrumentation & Reliability Engineering
      • Oil, Gas, Corrosion, Process, Gas turbine & Chemical Engineering
    • MTCTCL Energy Services Courses
      • Drilling Technology
      • Field Operations
      • Geology & Geophysics
      • Management & Economics
      • Reservoir Engineering
  • Aviation
  • Certified Courses
  • MTCTCL Energy Services
  • Contact Us

Financial Modelling in Excel

(4 Days)

LOCATIONS DAYS DATES FEE REGISTER
Dubai, UAE 4 October 06 - 09, 2019 £2415.00 Register
Dubai, UAE 4 April 12 - 16, 2020 £2415.00 Register
Kuala Lumpur, Malaysia 4 June 01 - 05, 2020 £2300.00 Register
Kuala Lumpur, Malaysia 4 September 07 - 11, 2020 £2300.00 Register
Nairobi, Kenya 4 Sept.28 - Oct.02, 2020 £2300.00 Register
Dubai, UAE 4 October 04 - 08, 2020 £2415.00 Register

Fee excluding accommodation and meals

PROGRAMME DETAILS Day One Introduction to Financial Modelling What is a model? Spreadsheet models Types of models Principles of Financial Modelling Steps in model building Best practice guidelines and spreadsheet modelling standards Designing for flexibility and scalability Designing for consistency Designing for usability and functionality Designing checks and balances Using VBA in financial models Examples Day Two Principles of Risk Return Volatility Capital Structures Weighted Average Cost of Capital (WACC) Cost of Equity Capital Valuation: Theory and Application Role of valuation Approaches to valuation Accounting concepts behind balance sheet, income statement and cash flow Analysing past performance Discounted cash flow modeling Adding Risk Techniques to financial analyst/valuation model Sensitivity analysis and an introduction to Monte Carlo Simulations Interpreting results Examples Day Three Financial Model Auditing/Review Why is Audit? Excel’s auditing tools Automated testing tools: role, purpose and limitations Model documentation Overview, purpose, advantages, disadvantages Demonstration Day Four Reporting Management Reporting and Forecasting Reporting Consolidations Analysis of company financial data Examples Exercise: Produce a management summary report with charts
← Previous Course
Next Course →

Make an enquiry

2020 Training Catalogue

MTCTCL
Copyright © 2023 All Rights Reserved