Preparing Budgets, Forecasting and Planning Process Course

Preparing Budgets, Forecasting and Planning Process Course

Date:

08-Dec-2022
Image

Introduction

    The importance of training courses is not only limited to professional life, as most of us think but training courses aim to transfer knowledge and practical experiences that enrich the skills of individuals and enhance their self-confidence, which contributes to the preparation of cadres which in turn contributes to the development and progress of institutions. Therefore, Strategic Vision Training Center aims to enhance the skills and experiences of individuals through the strongest training programs to keep pace with every development in the labor market.

 

Objective

  • Understand the role of the company's strategy in building the estimated budget and financial planning
  • Using quantitative methods in financial forecasting and budget building
  • Designing a current budget model using MS Excel, starting with the financial forecasting stage, passing through the preparation of the estimated financial statements, and ending with the analysis of budget deviations.
  • The application of responsibility accounting and performance evaluation
  • Designing an investment budget model using MS Excel, starting with the stage of preparing the project's expected cash flows plan, and then estimating the criteria for evaluating the investment project.
  • The use of quantitative methods in financial forecasting
  • Designing a financial model using Excel to prepare the company's current budget
  • The application of responsibility accounting and performance evaluation
  • Designing a financial model for evaluating investment projects using the Excel program
  • The role of the company's strategy in building the estimated budget and financial planning
  • Using quantitative methods in financial forecasting and budget building
  • The application of responsibility accounting and performance evaluation
     

Who should attend?

  • Chief Financial Officers, Deputy Chief Financial Officers, Controllers and Treasury Officials
  • Corporate Investment Managers
  • Planning managers in institutions
  • Internal auditors
  • Specialists responsible for financial reporting
  • Accountants, project managers and budget analysts
     

Course content:

1st Day
Strategic Planning

  • Formulating the company's strategy
  • Strategic analysis: analysis of the company's internal and external environment SWOT Analysis
  • Strategic Analysis: Porter's five forces
  • Strategic Analysis: PESTLE
  • Translating the company's strategy in the form of a strategy Map and a Balanced Scorecard BSC
  • Strategic objectives and their role in formulating the company's long-term goals

2nd Day
Quantitative methods for financial forecasting with budget estimates

  • Studies on which revenue estimation is based
  • Analysis of actual revenue results
  • Studying the economic conditions of the markets and distribution areas
  • Determine the sales formation
  • Determining the prices of the products that make up the sales formation
  • Estimation of time series
  • Estimation of the general trend
  • Estimation of seasonal changes - cyclical changes - sudden or episodic changes
  • • Practical Case: Forecasting the quarterly revenue of a company of a seasonal nature using MS Excel

3rd Day
Preparing the Estimated financial statements

  • Estimate the production budget
  • Estimate the production cost budget
  • Estimating procurement needs and inventory scheduling
  • Estimation of selling and administrative expenses
  • Preparing the estimated income statement
  • Preparing the cash budget
  • Preparing the estimated statement of financial position
  • Practical case: Designing a model for the planning budget of a hypothetical company using MS Excel

4th Day
Accounting Responsibility and building performance evaluation criteria

  • Quadrilateral analysis of budget deviations
  • Analyze income deviations
  • Investigation of deviations
  • Identification of Responsibility Centers
  • Evaluate the performance of responsibility centers

5nd Day
Financial Planning and long-term investment

  • Time value of money
  • Preparing estimated income statements for the project
  • Cash Flow Layout
  • Determine the appropriate discount rate for the project
  • Calculating the cost of capital
  • Calculating the Net Present Value of the project
  • Calculating the Internal Rate of Return and the Modified Internal Rate of Return
  • Calculating the Discounted Payback Period