Course Overview

Unlock the full potential of financial modelling in our comprehensive course, where participants gain proficiency in constructing robust financial models. Through a blend of theoretical insights and hands-on Excel Applications, participants will learn how to analyse financial statements, understand cost of capital analysis, hone relative valuation methodologies, and create a three-statement discounted cash flow (DCF) model to compute intrinsic value. 

 

Prerequisites

  • Proficient in Microsoft Excel
  • Able to communicate in English
  • For in-person training, do bring along a laptop that has Microsoft Excel.

Target Audience

This course is tailored for working professionals in Singapore who seeks to improve their financial literacy. It is suitable for:

  • Financial Analyst
  • Corporate Finance or Accounting professionals
  • Entrepreneurs.
  • Individuals seeking to learn how to perform financial modelling.

Course Highlights

  • Gain proficiency in Excel functions and shortcuts tailored for financial modelling.
  • Learn to build integrated financial statements including Balance Sheet, Income Statement, and Cash Flow Statement.
  • Understand cost of capital components and compute Weighted Average Cost of Capital (WACC).
  • Master relative valuation techniques such as comparable company analysis and precedent transactions analysis.
  • Develop 3-statement discounted cash flow (DCF) models to estimate intrinsic value.
  • Perform sensitivity analysis and scenario modelling to evaluate investment decisions.

Course Objectives

Upon completion of the course, participants will be able to:

  • Understand the principles and applications of financial modelling for decision-making and strategic planning.
  • Identify and utilize Excel functions and shortcuts relevant to financial modelling tasks.
  • Construct integrated financial statements and forecast key financial metrics accurately.
  • Analyse capital structure optimization strategies and compute Weighted Average Cost of Capital (WACC).
  • Apply relative valuation methodologies and interpret valuation results effectively.
  • Develop comprehensive discounted cash flow (DCF) models and perform sensitivity analysis for investment evaluation.

Course Outline

  • Overview of financial modelling principles and applications.
  • Importance of financial modelling in decision-making and strategic planning.
  • Introduction to Excel functions and shortcuts for financial modelling.
  • Understand the main components of the financial statements: Balance Sheet, Income Statement, and Cash Flow Statement.
  • Linking financial statements using formulas and assumptions. 
  • Forecasting revenue, expenses, and other key financial metrics.
  • Capital structure optimization strategies to minimize cost and maximise shareholder value.
  • Understand the different components of cost of capital (debt/equity/preferred stock).
  • Understand the CAPM Model.
  • Compute Weighted Average Cost of Capital (WACC) and explain its importance as a discount rate for evaluating investment projects.
  • Factors Influencing Cost of Capital.
  • Introduction to relative valuation methodologies (comparable company analysis, precedent transactions analysis).
  • Recognize the advantages and disadvantages of relative valuation.
  • Identifying comparable companies and transactions for valuation purposes.
  • Building comparable company analysis (comps) and precedent transactions analysis models.
  • Interpreting and communicating relative valuation results.
  • Overview of DCF methodology and its application in valuation.
  • Building 3 statement DCF models from scratch to estimate intrinsic value.
  • Develop detailed revenue/expense projections based on historical performance, market trends, and growth assumptions.
  • Develop detailed depreciation schedule to capture the timing and impact of asset depreciation on cash flows.
  • Linking the income statement, balance sheet, and cash flow statement to ensure consistency and accuracy in cash flow projections.
  • Perform sensitivity analysis and scenario modelling in DCF.

Certification

A certificate of completion will be awarded upon successful completion of the course.

Course Fees

$788 $488

Financial Modelling

Master Financial Modelling and Drive Informed Business Decisions

Apply Now

Register for the Financial Modelling Course

Master Financial Modelling and Drive Informed Business Decisions.

Oops! We could not locate your form.