?高阶财会系列培训——Comprehensive Budget Model 课程梗概

2016年07月28日 Seed职业培训



预算编制是公司管理层非常重视的工作,也是广大会计人员必备的核心技能之一。预算编制时要根据上层(董事会)战略意图,和一线部门的诉求进行多次调整。用手工方式编制预算费时费力,而且准确性不高。


下个周末, Terry老师将详细为同学们讲解如何编制Driver based budget,从Driver的选择,Build up Revenue / COGS / SW / OPEX,  CAPEX计划和Depreciation计算, 融资计划和现金流预算, 生产计划和Working Capital预算,到预算三大报表的联动,和预算控制。


Terry老师还将在实战模型中拆解预算流程、技术、注意事项, 让您不但拥有一个可以应用到实际工作的预算财务模型,还能完全掌握其背后的设计思路。


Comprehensive Budget Model
weekend 6th & 7th August 2016 Melbourne



Working on a comprehensive driver-based budget model from start to finish, you will evaluate input assumptions, calculate revenue and costs of production to calculate cash requirements.  From this, you will build a full set of budget financial statements with particular emphasis on linking the profit & loss statement, cash flow statement and balance sheet together.

Key Modules Covered in the Course


Budgeting & Forecasting Essential


- Introduce top down and bottom up budgetary
- Introduce activity based budget system
- Introduce incremental budget system
- Introduce Zero ­based budget system
- Select a suitable budgetary system
- Deal with interaction of budget & Rolling forecast
- Introduce Feed forward control

Inputting Historical Statements


- Integrated model for historical income statements
- Integrated model for historical balance sheet
- Prepare Information for budgeting

Analysing Growth Drivers


- Calculate revenue drivers
- Calculate cost drivers
- Analyse FTE and salaries & wages drivers
- Analyse OPEX drivers
- Analyse balance sheet drivers

Forming Growth Assumptions

- Build P&L assumptions
- Build B/S assumptions
- Set management discussion baseline
- Reconcile conflicting objectives that occur in budgeting

Projecting Future P&L


- Revenue build up
- Cost build up
- Payroll build up
- OPEX build up
- Create the project income statement

Creating Asset & Depreciation Schedule


- Create asset schedule
- Build CAPEX schedule
- Project fixed asset and depreciation
- Create the project balance sheet

Projecting Future Cash Flow


- Create financing schedule
- Project debt and interest
- Create the project cash flow statement
- Steps to create integrated budget model
- Layout for integrated budget model

What-if, Scenario And Sensitivity Analysis


- Identify uncertainty as it exists in the business world
- Build scenario for budget model
- Prepare sensitivity analysis of budget model
过往学员反馈:




收藏 已赞