Financial Analysis, Modelling and Forecasting (Using Excel)

ICTD International Centre for Training and Development

What are the topics?

ICTD International Centre for Training and Development


Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Operations

Operations management has recently become a crucial part of any company's framework. This complex process focuses on reducing organizational expenses ...

Read more about Strategy

In order to keep the company that you are managing or your own business competitive, you need to have a clear plan of action, in other words, you must...

Who should attend

  • Management accountants responsible for budget preparation and management reporting
  • Staff from any discipline who require a better understanding of the latest techniques of integrated planning and budgeting
  • Financial planners and cost analysts
  • Line managers with direct planning and budgeting responsibility
  • Professional advisers, accountants, and business consultants

About the course

It provides the skills to build world class standards into your planning, budgeting, performance measurement and reporting system. This course will discuss new techniques, explain how they complement the traditional financial planning tools, and introduce new concepts for measuring and reporting performance and shareholder wealth creation.

It will also show how to make your budgeting process more cost effectively and motivate managers to "buy in” to the budget process. Many case studies and illustrations of real companies will be used to help delegates understand how to apply different planning, forecasting and analysis techniques. Learning will be via lecture, example, discussion and case study. Participants will also be given a detailed set of handouts that will enable them to revise the topics covered at a later date. Delegates will be asked to bring a spreadsheet of their organization’s budget structure to work on during the course.

Key Benefits and Personal Impact

After attending this course you will be able to:

  • Implement the latest practices into your budgeting process
  • Integrate long term strategic vision with budgeting
  • Deliver more timely and useful information to decision makers
  • Successfully build an integrated planning, budgeting and reporting process
  • Forecast costs and revenues more accurately

## Course Objectives

  • Apply management tools to the budgeting process that contribute to strategic goals
  • Learn how to apply new techniques in budgeting and forecasting
  • Better and more cost effective management of the budgeting process
  • Identify key performance indicators for accurate and focused decision making
  • Increase productivity and performance through stream lined planning and reporting

Learning Outcome

  • Better cost control
  • More accurate budgets
  • Greater commitment to budget targets
  • Improved budgeting and forecasting systems

## Course Outline


  • The purpose of planning and budgeting in business
  • Budget timetables and working papers
  • Case study: designing a budgeting system
  • Defining strategy
  • Building a strategic planning model
  • Strategic analysis and decision making models
  • Group exercise and discussion: Mapping and reviewing your existing planning process


  • Zero base budgeting
  • Activity based budgeting
  • Designing and implementing an integrated rolling forecast process
  • Unit budgeting
  • Program budgeting
  • The beyond budgeting principle
  • Case study:
  • Group exercise: Applying new budgeting techniques in your organization


  • Cost behavior and breakeven points
  • Identifying semi-fixed and semi-variable costs
  • Cost estimation and Regression analysis
  • Building a financial simulation model
  • Monte Carlo simulation


  • Linear programming models for planning
  • Learning curves in cost forecasting
  • Cost forecasting for pricing decisions
  • Gap analysis
  • Forecasting in difficult circumstances: maintenance costs, IT costs, projects


  • Techniques for mapping your planning cycle
  • Case study: the effect of changing strategy on budgets
  • Applying the Balanced Scorecard
  • Designing management reports
  • Integrating long and short range planning processes
  • The role of the chief executive and chief financial officer
  • Human aspects of planning and control
  • Presenting the ideas from the course to your colleagues
  • Implementing changes to your budget system
  • Course summary and closure

Videos and materials

Financial Analysis, Modelling and Forecasting (Using Excel) at ICTD International Centre for Training and Development

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.

Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.


Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Operations

When it comes to operations control, whether you’re trying to optimize workflow or marketing and sales operations, you need to impact as many variables at once as possible in order to have a greater effect. However, it's not always that easy. How sho...

Read more about Strategy

Strategy courses contain a large amount of practice. You will be able to analyze the company's performance and make a strategic development plan. All practices are based on real cases that each of you may encounter. The courses will also introduce yo...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.