Financial Modelling Essential - Seed Training and Seed Career

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.

OTHER RELEVANT COURSES/PATHWAY

Models for Month-end and Reconciliation

Financial Analysis

Dynamic Business Reports

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