Fundamentals of Financial Modelling

  • Finance & Budgeting

Introduction

In the modern business world, informed decisions are crucial. Financial modelling serves as the cornerstone, enabling professionals to forecast trends, assess opportunities, and drive strategic outcomes. In this course, participants will learn the basics of building robust financial models and gain practical skills to do so. It aims to empower participants with the expertise needed to excel in financial analysis and modelling Participants will learn to construct models that analyse historical data, forecast future performance, and simulate various scenarios to support critical business decisions.

Course Outline

  • Module 1
  • Module 2
  • Module 3
  • Module 4
  • Module 5
  • Course Objectives
  • Target Audience

Financial Modelling

  • Overview of financial modelling.
  • Key financial concepts: NPV, IRR, cash flow, etc.
  • Excel for financial modelling.
  • Basic Excel functions and tools.
  • Common modelling mistakes.

Financial Statements

  • Review of financial statement.
  • Relationships between financial statements.
  • Linking financial statements in Excel.
  • Ratio analysis.
  • Working capital management in models.

Building Financial Model

  • Structuring a financial model.
  • Revenue forecasting techniques.
  • Expense forecasting techniques.
  • Capex and depreciation modelling.
  • Working capital and cash flow forecasting.

Valuation Modelling

  • Basics of valuation models: DCF and multiples.
  • Terminal value calculation.
  • Discount rate and WACC calculation.
  • Sensitivity analysis in valuation models.
  • Comparable company analysis.

Analysis and Model Optimization

  • Scenario analysis.
  • Scenarios in Excel.
  • Sensitivity analysis.
  • Stress testing financial models.
  • Presenting and communicating model results.

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

  • Develop proficiency in building and interpreting financial models using Excel and other tools.
  • Learn how to structure, layout, and document models accurately.
  • Learn how financial models can help you evaluate investments and projects feasibility.
  • Apply appropriate modelling techniques to historical data to improve forecasting accuracy.
  • Provide a solid foundation for topics related to advanced financial modelling.

This course is ideal for:

  • Accountants & auditors.
  • Financial analysts.
  • Investment bankers.
  • Corporate finance officers.
  • Business analysts & consultants.
  • Entrepreneurs & business owners.

Course Schedule & Fees

  • Kuala Lumpur
  • Singapore
  • Amsterdam
  • Online
  • Course Fees

This course will take place in Kuala Lumpur on the following dates:

05/05/202519/05/202502/06/202516/06/2025
30/06/202514/07/202528/07/202511/08/2025
25/08/202508/09/202522/09/202506/10/2025
27/10/202510/11/202524/11/202508/12/2025
22/12/202505/01/202619/01/202602/02/2026

This course will take place in Singapore on the following dates:

26/05/202516/06/202507/07/202528/07/2025
18/08/202508/09/202529/09/202520/10/2025
10/11/202501/12/202522/12/202512/01/2026
02/02/202623/02/2026

This course will take place in Amsterdam on the following dates:

12/05/202502/06/202523/06/202514/07/2025
04/08/202525/08/202515/09/202506/10/2025
27/10/202517/11/202508/12/202529/12/2025
19/01/202619/01/2026

This course will take place Online the following dates:

13/05/202510/06/202508/07/202505/08/2025
02/09/202530/09/202528/10/202525/11/2025
23/12/202520/01/202617/02/2026
Kuala LumpurSingaporeAmsterdamOnline
USD$ 3,580USD$ 5,600USD$ 5,600USD$ 1,920

Register Now
Download Brochure
Course Enquiry
Request In House Proposal
Training Evaluation Form
  • Register Now
  • Download Brochure
  • Course Enquiry
  • Request In House Proposal
  • Training Evaluation Form

    Select a Location

    Select Date

    Salutation

    First Name

    Last Name

    Job Title

    Company Name

    E-mail Address

    Phone Number

    Country

    Invoice to

    Add More Participants?

    Participant Name 1

    Job Title

    Add More Participants?

    Participant Name 2

    Job Title

    Add More Participants?

    Participant Name 3

    Job Title

    Add More Participants?

    Participant Name 4

    Job Title

    Add More Participants?

    Participant Name 5

    Job Title

    Add More Participants?

    Participant Name 6

    Job Title

    Add More Participants?

    Participant Name 7

    Job Title

    Add More Participants?

    Participant Name 8

    Job Title

    Add More Participants?

    Participant Name 9

    Job Title

    Add More Participants?

    Participant Name 1

    Job Title

    Please enter your email address below to send you the brochure.
    Training Experience:
    Trainer:
    Logistics:
    Recommendation:
    Recommendation:
    Register Now

      Select a Location

      Select Date

      Salutation

      First Name

      Last Name

      Job Title

      Company Name

      E-mail Address

      Phone Number

      Country

      Invoice to

      Add More Participants?

      Participant Name 1

      Job Title

      Add More Participants?

      Participant Name 2

      Job Title

      Add More Participants?

      Participant Name 3

      Job Title

      Add More Participants?

      Participant Name 4

      Job Title

      Add More Participants?

      Participant Name 5

      Job Title

      Add More Participants?

      Participant Name 6

      Job Title

      Add More Participants?

      Participant Name 7

      Job Title

      Add More Participants?

      Participant Name 8

      Job Title

      Add More Participants?

      Participant Name 9

      Job Title

      Add More Participants?

      Participant Name 1

      Job Title

      Download Brochure

      Please enter your email address below to send you the brochure.

      Course Enquiry

      Request In House Proposal

      Training Evaluation Form

      Training Experience:
      Trainer:
      Logistics:
      Recommendation:
      Recommendation:

      Course Info
      • Duration: One week
      • Available: Classroom/Online
      Training Locations
      • Kuala Lumpur
      • Singapore
      • Amsterdam
      • Online
      Related Courses

      PITC TRAINING aims to equips private and public workforce with quality training programs designed for real-world success. Covering Leadership, Management, Finance, HR, AI, Project Management, Customer Services, and more, we help organizations upskill their teams and stay ahead in a rapidly evolving market.

      Contact Us

      Quick Links

      Social Networks

      Linkedin Instagram

      location

      Copyright ©2025 Premier International Training Centre | All Right Reserved. 

      Registered and Accredited By