Budgeting & Controlling

Hunter Jiang

IFA Australia Founder
Senior Group Financial Controller

Hunter has designed and delivered many practical hands-on step by step training courses to accelerate the acquisition of financial management skills. As well as identifying key financial concepts in budgeting, reporting and analysis, he supports this knowledge with many simple and sophisticated Excel models. He also has the ability to access complex BI and reporting tools and make them come alive in common sense ways which can be replicated by the learner back in the office environment.

Budgeting & Constrolling

模块一 公司预算流程的制定

案例:为预算会议准备预算手册 流程:预算前、预算中、预算控制 模型:二维预算流程任务分配表

模块二 预算的种类和方法

案例:如何选择适合公司的预算方法 流程:按时间、职能和灵活性分 模型:项目成本效益模型

模块三 预算前期准备

案例:如何进行宏观经济评估 流程:地区、行业和竞争力分析 模型:三变量市场份额分析图表模型

模块四 资本预算和产能分析

案例:为什么要先做资本预算 流程:成本利益-项目回报-决策依据 模型:项目投资回报决策模型

模块五 设定总体假设和参数

案例:如何获得假设和参数 流程:假设和参数的区别 模型:假设和参数数据收集模型

Case Study

Over 200 Corporate real case studies

Procedures

Apply industry benchmark level best practices

Modelling

Combine working knowledge and Excel skills

模块6 销售预算

案例:如何制定销售预算 流程:产、供、存、销的流程 模型:销售预算的四大模型

模块7 工资预算

案例:如何进行工资预算 流程:FTE,工作时间和固定工资 模型:变动工资和固定工资模型

模块8 运营费用预算

案例:如何制订运营费用预算 流程:了解成本驱动原理 模型:成本驱动调节模型

模块9 平衡表和现金预算

案例:如何做出三大报表 流程:现金预算的倒推法则 模型:offset 现金预算模型

模块10 预算审批与版本控制

案例:如何对预算进行微调 流程:预算更改的内控流程 模型:版本控制的差异对比模型

In This Class You'll Get to...

Free Consulting

Our experienced consultant's will help you identify the skill gaps for your next move.

CPD Certificate

A formal company letter will be issued to you after class to help you claim your CPD hours.

Free Resume Edit

Our experienced consultant's will help you edit your resume before you apply for the target role.