Programme Objective
In any organization the budget is a central aspect of the planning and control systems utilized by the organization. Regardless of the organization’s size or complexity, or the product, the market or the service provided by the enterprise, a budget will always feature as a key aspect of financial planning.
This programme is dedicated to solving the problems managers face when preparing budgets and forecasts. It combines accounting, budgeting, and forecasting issues with Excel to provide accountants with practical guidance on how to prepare more accurate budgets and forecasts with less time and effort. By combining both traditional budgeting and forecasting concepts with the power and flexibility of Excel, participants are given the tools and techniques needed to meet the ever increasing demands of management, banks, regulators, and investors.
To enable participants to:
- Apply decision logic to building of complex budgetary model
- Use data functions for what-if analysis - data consolidation, data query, data tables, data import tricks
- Use Excel solver for linear programming
- Standardize spreadsheet design and review to make budgets and forecasts easier create and update
- Use custom views and report manager to automate the report preparation process
- Work with financial functions
- Understand the approach in the preparation of cash and capital budget using spreadsheets
- Apply spreadsheet techniques specific to building of a complete budgetary model.
Programme Outline
- Budgeting Overview
- Budgeting preparation
- Preparing the master budget
- Cash & capital budgeting
- Budgeting case discussions
- Forecasting Techniques
- Forecasting & corporate strategy
- Forecasting financial requirements
- Forecasting case discussions
- Application of Spreadsheet Techniques to Budgeting (I)
- Using decision logic and what-if analysis
- Format of cashflow budget
- Hands-on cash flow analysis case exercise
- Application of Spreadsheet Techniques to Budgeting (II)
- Using time series and regression analysis
- Using Excel solver for linear programming
- Hands-on sales forecasting case exercise
- Application of Spreadsheet Techniques to Budgeting (III)
- Capital budgeting techniques
- Working with financial functions
- Hands-on capital budgeting case exercise
- Application of Spreadsheet Techniques to Budgeting (IV)
- Standardizing spreadsheet design
- Constructing a profit-planning model
- Using simulation in cash budgeting
- Hands-on budgetary model case exercise
To view our full list of Infocomm courses, please click here.
Pre-requisites
Please take note of the following admission requirements:
- Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
- Mandatory for video camera to be turned on throughout the course
- Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
Closing Date for Registration
1 week before programme or until full enrolment
Intended For
Professionals who prepare budgets and forecasts using Excel and want to save time, and do a better job. Users of Excel 2013 or any latest version are welcomed.
Schedule & Fees
Testimonial
Funding
1] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.
NTUC members enjoy 50% *unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2022. *This excludes miscellaneous fees such as GST and registration fee etc.
This course is approved for UTAP support for intakes conducted between 01 April 2021 – 31 March 2022.
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.
- Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
- Course by training provider must be supported under UTAP and training must commence within the supported period and;
- Unfunded course fee must not be fully sponsored by company or other types of funding
- Unfunded course fee must be S$20.00 and above, and;
- Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
- UTAP application must be made within 6 months after course ends.
To submit for UTAP claims, please visit http://skillsupgrade.ntuc.org.sg/. Terms and conditions apply.
Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008
Programme Facilitator(s)
Programme Objective
In any organization the budget is a central aspect of the planning and control systems utilized by the organization. Regardless of the organization’s size or complexity, or the product, the market or the service provided by the enterprise, a budget will always feature as a key aspect of financial planning.
This programme is dedicated to solving the problems managers face when preparing budgets and forecasts. It combines accounting, budgeting, and forecasting issues with Excel to provide accountants with practical guidance on how to prepare more accurate budgets and forecasts with less time and effort. By combining both traditional budgeting and forecasting concepts with the power and flexibility of Excel, participants are given the tools and techniques needed to meet the ever increasing demands of management, banks, regulators, and investors.
To enable participants to:
- Apply decision logic to building of complex budgetary model
- Use data functions for what-if analysis - data consolidation, data query, data tables, data import tricks
- Use Excel solver for linear programming
- Standardize spreadsheet design and review to make budgets and forecasts easier create and update
- Use custom views and report manager to automate the report preparation process
- Work with financial functions
- Understand the approach in the preparation of cash and capital budget using spreadsheets
- Apply spreadsheet techniques specific to building of a complete budgetary model.
Programme Outline
- Budgeting Overview
- Budgeting preparation
- Preparing the master budget
- Cash & capital budgeting
- Budgeting case discussions
- Forecasting Techniques
- Forecasting & corporate strategy
- Forecasting financial requirements
- Forecasting case discussions
- Application of Spreadsheet Techniques to Budgeting (I)
- Using decision logic and what-if analysis
- Format of cashflow budget
- Hands-on cash flow analysis case exercise
- Application of Spreadsheet Techniques to Budgeting (II)
- Using time series and regression analysis
- Using Excel solver for linear programming
- Hands-on sales forecasting case exercise
- Application of Spreadsheet Techniques to Budgeting (III)
- Capital budgeting techniques
- Working with financial functions
- Hands-on capital budgeting case exercise
- Application of Spreadsheet Techniques to Budgeting (IV)
- Standardizing spreadsheet design
- Constructing a profit-planning model
- Using simulation in cash budgeting
- Hands-on budgetary model case exercise
To view our full list of Infocomm courses, please click here.
Pre-requisites
Please take note of the following admission requirements:
- Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
- Mandatory for video camera to be turned on throughout the course
- Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
Closing Date for Registration
1 week before programme or until full enrolment
Intended For
Professionals who prepare budgets and forecasts using Excel and want to save time, and do a better job. Users of Excel 2013 or any latest version are welcomed.
Programme Facilitator(s)
