Financial Modelling Essential
current icon CURRENT
camput icon On Campus
Start Anytime
Industry Recognised
Workplace Simulation
Price: $930
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.

FEE INFORMATION

  • Fees must be paid within 5 days of receiving the confirmation of enrolment and invoice for the enrolment fee.
  • Seed Training Group may cancel 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