Financial Modelling Essential
current icon CURRENT
camput icon On Campus
Start Anytime
Industry Recognised
Workplace Simulation
Contact Us
DOWNLOAD COURSE BROCHURE
CERTIFICATES
FLEXIBLE DELIVERY
LIVE SUPPORT
INTERNSHIP AVAILABLE

ABOUT THE COURSE

*The course will be delivered in Mandarin (中文授课). Most of the accountants are trained in how to use Accounting Systems / Excel, but seldom be trained in how to build a financial model. This course guides students to explore the fundamental concept behind financial modelling. Students will learn the essential techniques during different phases: designing, modelling, prototype, and testing. Students will also learn how to use models in accounting daily jobs.

UNITS

Module 1 Financial Modelling Introduction

  • What is financial modelling
  • Best practice in financial modelling
  • Art in an effective Excel model

Module 2 Excel Skills Needed for Financial Modelling

  • Conditional format
  • Absolute & relative cell reference
  • Switch row & column of chart
  • Set up secondary axis
  • Group data in pivot table
  • What-if analysis skills
  • Formula dimension to deal with nested if statement
  • How to apply an effective model in Excel
  • How to escape from “excel hell”

Module 3 Steps to Building the Financial Models

  • Where to start to build a model
  • Financial models – logical structure design
  • Financial models – data input
  • Case: Convert data table to data list
  • Financial models – process/calculation
  • Case: Consistent formulas in one area
  • Case: Avoid hard code in formula
  • Case: Running total calculation
  • Financial models – output
  • Case: Report format design

Module 4 Data Cleansing Skills

  • How to deal with blank record
  • How to deal with duplicate records
  • How to deal with text
  • How to find & replace certain values
  • How to get data from PDF files

Module 5 Maintaining Financial Model

  • Techniques to reduce error
  • Common Excel error types
  • How to correct and suppress error
  • How to set up error checking module

Module 6 Financial Models for FA Daily Tasks

  • How to use financial models in accounting jobs
  • Decode accounting system logic
  • Sales & accounts receivable procedures
  • Case: Accounts receivable aging report
  • Case: Bad debt provision
  • Purchase & accounts payable procedures
  • Case: Cash reimbursement form
  • Case: Rebuild an inherited model
  • Payroll procedure
  • Case: Timesheet calculation & accrual treatments
  • Cash management procedure
  • Case: Accrued interest income model
  • Fixed asset management procedure
  • Case: FA & Depreciation model with variety asset categories
  • How to design simple, clear, and readable model to deal with complex business tasks
  • Project accounting procedure
  • Case: Project review model

UPON COMPLETION

This course is eligible for CPD hours.

CAREER OPPORTUNITIES

  • Financial Modeller
  • Financial Accountant
  • Senior Accountant

DURATION

2 days
* Please contact us for the timetable.

FINANCE OPTIONS

FINANCE OPTIONS

Fees must be paid within 5 working days of receiving the confirmation of enrolment and invoice for the enrolment fee.

Seed Training Group may cancel an enrolment or discontinue training if fees are not paid as required.

Both direct deposit and credit card are accepted.

*Please refer to the Student Information Handbook for further details regarding Fees & Refund Policy and Procedure.

Trainer’s Profile

  • 17 Years of Dedicated Best-Practice Financial Modeller Extensive Experience in Building & Reviewing Complex Financial Model
  • Experienced Financial Controller of an ASX listed companies
  • Managing Director of AFMA (Australian Financial Modeller Association)
  • Committee Member of ACAA (Association of Chinese Accountants Australia)
  • Special Guest Trainer of ABC Television (Australian Broadcasting Corporation)
  • Guest BI (Business Intelligence) Lecturer of CPA Australia
  • Lecturer of Shanghai University of Finance and Economics MBA
  • Experienced Financial Analyst and Financial Modeller
TESTIMONIALS
PARTNERSHIP & COLLABORATORS
Call Me Back