Financial Modelling Essentialweekend 28th & 29th May 2016 Melbourne
weekend 19th & 20th November 2016 Melbourne
由于课程非常火爆，本周末 Terry 老师在
悉尼的课堂将为墨尔本学员
开放 Online 学习端口，
同步进行培训。
具体时间为 2nd & 3rd July
9:30 am - 4:30 pm。
下面是「Financial Modeling Essential」
培训内容介绍，
请感兴趣的学员详细阅读。
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 CourseFinancial Modelling Introduction
- What is financial modelling- Best practice in financial modelling- Art in an effective Excel modelExcel Skills Needed for Financial Modelling- Absolute & relative cell reference- Switch row & column of chart- 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- How to deal with blank record- How to deal with duplicate records- How to find & replace certain value- How to get data from PDF filesMaintaining Financial Model- Techniques to reduce error- Common Excel error types- How to correct and suppress error- How to set up error checking moduleFinancial 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- 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
下面是上次「Financial Modelling Essentials」的培训回顾。
希望能帮大家进一步了解课程。
欢迎大家在结尾的联系方式中
联系我们进行报名和咨询。
更高能的内容来了，在5月份的「Financial Modelling Essential」课堂上，Terry老师为学员们详解了20多个财务模型的奥秘与建模原理。下面小编帮大家总结了一个重点内容，希望能对大家有所帮助。
1. Financial Modelling
建模原理财务建模的大块关键点分为三个部分：Input, Calculation 和 Output。Terry老师为大家非常详细的讲解了三个步骤需要注意的要点，以及一些常用的calculation原理。
现在，你的 AR Aging Report 可能是这样的：
通过学习更丰富的Excel技能后，你的report将变成这样：
没错，每选中一个区间，对应的数据都会自动体现出来。原本死气沉沉的数据，转眼非常生动地体现出来。老师在教大家这个部分的时候，课堂上不断传来wow的赞叹声。单纯的数据表格是AR做的，拥有这项吧数据整合成生动图标的技能，摇身一变成AA。
3. Contractor 的 Payroll 自动化外部 Contractor 的 Payroll 对于越大的企业就会越复杂。Contractor 处理起来比较关键几个点是「做什么的，属于哪个department」，「rate 多少」，「不同工作时间的rate不同」，「public holiday rate又是多少」等等，总之 contractor 对于 Payroll 都是件头疼的事情。
首先，Terry老师建议大家总是给自己保留一个原始数据库，随时有机会回去调用数据。
然后就是让contractor 的payroll部分自动化起来。一旦建立起正确的模型，再复杂的contractor状况都可以自动化的来处理。
比如下图数据中的Invoice状态，一旦我们把状态改成Received，Accrued额度会自动变成0。即快速，又准确。
这个模型尤其对有不同rate的工种非常有用，比如Nurse类型的工作。对于经常处理库存的行业也能有效提高工作的效率和准确性。折旧，又一个工作量大而且繁琐的task。尤其对于公司assets项目和类型多的行业，建立一劳永逸的模型就更加重要。下面是完成后的模型，改变任何一个asset的原始数据，后面的折旧额度都会随之变化。只要建模原理正确，自动生成的数据即快速又可信。maintain起来也轻松得多。
需要做B/S的时候，折旧总数直接抓去近balance sheet。
几款高大上的模型过后，Terry老师还传授给大家一个小trick作为课堂调剂，能够成功恢复别人弄乱或意外删除掉的数据。
学员们课后对培训的评价非常高：
