Most of accountants were trained how to use Accounting Systems / Excel, but seldom be trained logically how to build a financial model. This course would guide you to explore the fundamental and concept behind financial model. You will learn the essential techniques during different phases: designing, modelling, prototype and testing. And you will also learn how to use models in accounting daily jobs.

Key Modules Covered in the Course

Financial Modelling Introduction

• What is financial modelling

• Best practice in financial modelling

• Art in an effective Excel model

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”

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

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 value

• How to get data from PDF files

Maintaining Financial Model

• Techniques to reduce error

• Common Excel error types

• How to correct and suppress error

• How to set up error checking module

Financial Models for FA daily tasks

• How to use financial models in accounting jobs

• Decode accounting system logic

• Sales & accounts receivable procedure

• Case: Accounts receivable aging report

• Case: Bad debt provision

• Purchase & accounts payable procedure

• Case: Cash reimbursement form

• Case: Rebuild an inherited model

• Payroll procedure

• Case: Time sheet calculation & accrual treatment

• 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