INTRODUCTION
Planning, Forecasting & Budgeting are the most important functions in business. Performed properly they can lead to exceptional success. Yet many people do not use the tools available to them to their best advantage. In this course, we will leverage the power of Excel to demonstrate how to improve your forecasting, planning, and budgeting. By developing better spreadsheets & models, planning is more accurate, forecasting is more precise & budgeting is more attainable. And the time to develop these is dramatically reduced.
Spreadsheet Skills for Planning, Forecasting & Budgeting training course will demonstrate how you can develop spreadsheet models to create a forecast, which can then be utilised to generate business plans and operating budgets with the use of Excel as it is used in practice. The applications will be focused on three crucial aspects of business and financial management - strategic planning, intelligent forecasting, and realistic budgeting
Delegates will learn how accessible the power of Excel is to provide realistic forecasts and prepare flexible budgets. The impact on efficiency in planning and control and therefore return on investment for companies and/or divisions will be startling.
OBJECTIVES
By the end of Spreadsheet Skills for Planning, Forecasting & Budgeting training course delegates will be able to:
Participate effectively in planning, budgeting and forecasting process
Apply advanced Excel spreadsheet skills in business forecasting
Employ leading edge tools for cost analysis and forecasting
Develop financial models to assist in capital investment decisions
Make spreadsheet models for cash flow forecasting
Build powerful what if spreadsheet models for risk sensitivity analysis
WHO SHOULD ATTEND ?
Spreadsheet Skills for Planning, Forecasting & Budgeting training course, is ideal for:
Financial accounting team members
Cost and management accounting staff
Finance managers
Budget managers
Commercial managers
Capital investment and project team members
COURSE OUTLINE
Day 1
Introduction to Spreadsheets using Excel
The power of Excel for building financial models
The Ribbons of Excel with their commands and functions
Using formulae: Copying, anchoring, and special pasting
Using functions: financial, statistical, and mathematical
Review of the financial objectives of business: ROI, ROA, ROE
Overview of Financial Statements
Day 2
Proper Planning:
Introduction to planning
What-if analysis: Scenario analysis techniques
Sensitivity analysis using spinners & scroll bars
Economic Order Quantity (EOQ)
Build out Data tables to see an entire range of options
1-way Data tables
www.lpcentre.com
2-way Data tables
Maximizing vs. optimizing techniques
Utilizing The Goal Seek command to calculate a reverse equation
Using Solver to calculate optimal product mix, distribution problems & capital budgeting
Day 3
Fantastic Forecasting
Forecasting in perspective - the Past vs. the Future
The necessity to apply a range of different forecasting methods:
Qualitative Models used in forecasting
Quantitative Models focussing on time series and regressions methodology
Forecasting growth rates
Recording, applying, and modifying forecast assumptions
Day 4
Beyond Budgeting:
What is a budget?
How to build a simple budget
Build a Flexible Budget Model
Build out a complete budget
Operating budget elements
Financial budget elements
Linking them
What is the Variance Analysis report & why is it important to improve your budget
Calculating variance analysis to see what must be changed
Day 5
Putting it together building the comprehensive model
Considering the financing mix in strategy
Considering the Return to Shareholder as the primary indicator
Build your planning model
Build your forecasting model
Build your budgeting model
Link these together in a review
LPC Training is capable of conducting this training programme exclusively for your delegates. Please e-mail us on admin@lpcentre.com for further information and/or to receive a comprehensive proposal.
www.lpcentre.com
DOCUMENTATION
High-Quality material has been prepared by the LPC team for distribution to delegates. In addition, a special note pad to facilitate note-taking will be provided.
CERTIFICATES
Accredited Certificate of completion will be issued to those who attend & successfully complete the programme.
SCHEDULE
Our Course timings commence at 09:00 and conclude at 13:00.
REGISTRATION & PAYMENT
Please complete the registration form on the course page & return it to us indicating your preferred mode of payment. For Further Information, please get in touch with us.
CANCELLATION AND REFUND POLICY
Delegates have 14 days from the date of booking to cancel and receive a full refund or transfer to another date free of charge. If less than 14 days notice is given then we will be unable to refund or cancel the booking unless on medical grounds. For more details about the Cancellation and Refund policy, please visit www.lpcentre.com/terms-and-conditions/
TRAVEL AND TRANSPORT
We are committed to picking up and dropping off the participants from the airport to the hotel and back.
LONDON
Oxford Street Offices: London - Oxford Street 25 N Row, London W1K 6DJ
+44 (0) 20 36 916 970
West London Office: 47 49 Park Royal Road London NW10 7LQ +44 (0) 20 80 900 464
info@lpcentre.com
DUBAI
Business Bay - Marasi Drive Churchill Tower commercial1, Office 107 +971 4 421 4616
dubai.training@lpcentre.com
KUALA LUMPUR
No. 03-06-05, UOA Business Park, Jalan Pengaturcara U1/51A, Section U1, Kawasan Perindustrian Temasaya, 40150 Shah Alam, Selangor
+60 19-305 5694
www.lpcentre.com
www.lpcentre.com