info@commonwealthtca.com
Language  
English
French
Spanish
German
Italian
Russina
Arabic
Turkish
Home
Courses
Cities
Associations
Services
About Us
Contact Us
Home
Courses
Course Category
→ Accounting and Finance
→ Administration and Secretarial
→ Auditing and Governance, Risk and Compliance
→ Banking, Insurance and Financial Services
→ Business Continuity and Crisis Management
→ Communication and Writing Skills
→ Construction Management
→ Contracts Management
→ Customer Service
→ Data Management and Business Intelligence
→ Digital Innovation and Transformation
→ Energy and Water Management
→ Financial Technology (FinTech)
→ Health, Safety and Environment
→ Human Resources and Training
→ Interpersonal Skills and Self Development
→ IT Management
→ Leadership and Management
→ Legal
→ Maintenance and Engineering
→ Marketing and Sales
→ Monetary Economics
→ Monitoring and Evaluation
→ Oil and Gas
→ Planning and Strategy Management
→ Port and Shipping Management
→ Procurement and Supply Chain Management
→ Project Management
→ Public Relations
→ Quality and Productivity
→ Security Management
→ Tourism Management
→ Transport and Logistics
More Links
→ Public Training Courses
→ Certified Training Courses
Cities
All Cities
Abu Dhabi
Accra
Addis Ababa
Amsterdam
Arusha
Bali
Bangalore
Barcelona
Beijing
Bujumbura
Cairo
Cape Town
Casablanca
Colombo
Copenhagen
Dar Es Salaam
Doha
Dubai
Geneva
Guangzhou
Hong Kong
Istanbul
Jakarta
Kampala
Kigali
Kingston
Kuala Lumpur
London
Lusaka
Manila
Maputo
Mbabane
Mombasa
Moroni
Mumbai
Muscat
Nairobi
Ottawa
Port Louis
Rome
Sao Paulo
Shanghai
Sharm El-Sheikh
Singapore
Stavanger
Stockholm
Taipei
Victoria
Vienna
Washington DC
Zanzibar
Associations
Services
All Services
Public Courses
Certified Training Courses
In-House Training Courses
Executive Coaching
Individual Training Programs (ITP)
Commonwealth TCA's Leadership Development Program
Consulting
About Us
Contact Us
Course Category
→ Accounting and Finance
→ Administration and Secretarial
→ Auditing and Governance, Risk and Compliance
→ Banking, Insurance and Financial Services
→ Business Continuity and Crisis Management
→ Communication and Writing Skills
→ Construction Management
→ Contracts Management
→ Customer Service
→ Data Management and Business Intelligence
→ Digital Innovation and Transformation
→ Energy and Water Management
→ Financial Technology (FinTech)
→ Health, Safety and Environment
→ Human Resources and Training
→ Interpersonal Skills and Self Development
→ IT Management
→ Leadership and Management
→ Legal
→ Maintenance and Engineering
→ Marketing and Sales
→ Monetary Economics
→ Monitoring and Evaluation
→ Oil and Gas
→ Planning and Strategy Management
→ Port and Shipping Management
→ Procurement and Supply Chain Management
→ Project Management
→ Public Relations
→ Quality and Productivity
→ Security Management
→ Tourism Management
→ Transport and Logistics
More Links
→ Public Training Courses
→ Certified Training Courses

Certificate in Financial Modeling

Why Attend

Organizations cannot afford to make the wrong investments decisions as these decisions have a long-term impact on the business and could make or break the organization. Therefore, it is critical to master financial modeling techniques as they are the main basis for investment decisions. By helping you understand and build effective financial models, this course will have a significant impact on the effectiveness and feasibility of your investment decision.

Overview

Course Outline

Schedule & Fees

Course Methodology

This course uses hands-on applications of financial modeling in Excel in addition to demonstrating theoretical core topics. The course also features real-life case studies and presentations by participants.

Course Objectives

By the end of the course, participants will be able to:

  •  Prepare effective financial models utilizing powerful Excel functions
  •  Use core financial modeling techniques
  •  Forecast investments and calculate valuations of projects and companies in an effective manner
  •  Develop comprehensive financial models to support investments decisions
  •  Recognize special modeling and valuation considerations and best practices


Target Audience

Corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.

Target Competencies

  •  Using advanced Excel
  •  Performing capital budgeting analysis
  •  Forecasting cash flow
  •  Calculating cost of capital
  •  Practicing financial modeling
  •  Understanding scenario analysis
  •  Calculating free cash flow


Advanced Excel for financial modeling

  • Excel tips and tricks that will help you speed up your spread sheet
  • Logical tests
  • Protecting your data
  • Database activities
  • Pivot Tables
  • Grouping data
  • Vertical and horizontal lookup tables
  • The magical choose function
  • Interactive formulas to extract data
  • String functions
  • Data tables
  • Interactive Graphs

Fundamentals of financial modeling

  • Time value of money
    • Present Value (PV) Future Value (FV) and Net Present Value (NPV)
    • Internal Rate of Return (IRR) and Multiple IRR (MIRR)
    • Equity IRR and project IRR
    • Using XNPV and XIRR
    • Contradicting NPV and IRR
  • Amortization of loan schedule
  • Enterprise value, market capitalization, firm value and equity value
  • Effective interest rate
  • Compound Annual Growth Rate (CAGR)
  • Investment assumptions and cash flows
    • What needs to be included?
    • Forecasting revenues
    • Forecasting costs and expenses
    • Focusing on income statement or cash flow?

Valuation techniques

  • Analyzing historical information and developing a projection basis
  • Using ratio analysis to prepare projected financial statements
  • Debt capacity and credit analysis for the acquisition
  • Sensitivity analysis on cash flows
  • Weighted Average Cost of Capital (WACC)
  • Adjusted Present Value (APV)
  • Using Capital Assets Pricing Model (CAPM) to determine cost of equity
  • Implied risk premium in the current Price Earnings (PE) multiple
  • Gordon model to determine cost of equity
  • Using PE multiple to determine cost of equity
  • Accrual accounting valuation
  • Valuation using multiples
  • Transaction multiples

Building real life models

  • How financial models work
  • Modeling income statements
  • Modeling balance sheets
  • Sensitivity analysis
  • Developing an integrated financial model
    • Automotive
    • Hospitality
    • Real estate
    • Education

Special modeling and valuation considerations

  • Structured valuations
  • Financial modeling best practices
  • Return on Investment (ROI) and Return on Equity (ROE)
  • Investment structures
    • Direct ownership
    • Partnership and joint venture
    • Build, Operate and Transfer (BOT)

$5475

Istanbul

Country: Turkey

Duration: Two weeks

Date: 10–21 Nov 2025

Register

$5475

Barcelona

Country: Spain

Duration: Two weeks

Date: 15–26 Jun 2026

Register