预算编制是公司管理层非常重视的工作,也是广大会计人员必备的核心技能之一。预算编制时要根据上层(董事会)战略意图,和一线部门的诉求进行多次调整。用手工方式编制预算费时费力,而且准确性不高。
下个周末, Terry老师将详细为同学们讲解如何编制Driver based budget,从Driver的选择,Build up Revenue / COGS / SW / OPEX, CAPEX计划和Depreciation计算, 融资计划和现金流预算, 生产计划和Working Capital预算,到预算三大报表的联动,和预算控制。
Terry老师还将在实战模型中拆解预算流程、技术、注意事项, 让您不但拥有一个可以应用到实际工作的预算财务模型,还能完全掌握其背后的设计思路。
Comprehensive Budget Modelweekend 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 controlInputting Historical Statements
- Integrated model for historical income statements- Integrated model for historical balance sheet- Prepare Information for budgetingAnalysing Growth Drivers
- Calculate revenue drivers- Analyse FTE and salaries & wages drivers- Analyse balance sheet driversForming Growth Assumptions- Set management discussion baseline- Reconcile conflicting objectives that occur in budgetingProjecting Future P&L
- Create the project income statementCreating Asset & Depreciation Schedule
- Project fixed asset and depreciation- Create the project balance sheetProjecting 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 modelWhat-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