Computerised Financial Modelling and Forecasting

 

Course overview

The Computerised Financial Modelling and Forecasting presents the theory and practice of financial management, emphasizing computer-based modelling and forecasting. It makes use of spreadsheets and other software products to analyse the impacts of financial decisions related to financial statement analysis, cash budgeting, and cost of capital determination, capital budgeting, and capital structure choices. The course covers a variety of techniques, such as sensitivity and scenario analysis, optimization methods and regression analysis.

Who should attend the course?

This course is primarily designed for the following target group in mind

  • All accounting and finance professionals who are currently working, or seeking to work, in the financial planning, analysis, budgeting and forecasting domain that make use of computerised packages.

Course objectives

At the end of this course, Participants will be able:

  • Develop spreadsheet and management skills for creating computer-based models for analysing a variety of decision problems facing today’s financial managers and professionals
  • Learn how to create computer-based models to prepare, analyse, and use financial statements; to conduct financial ratio analysis
  • Learn how to use logical IF statements, to custom format cells, and to conditionally format cells so as to highlight areas where management attention is needed
  • To use spreadsheets to calculate correct answers, the course emphasizes the preparation of spreadsheets in formats that can be easily understood
  • Understand project finance & budgeting

The Learning Model

The trainer uses up-to-date training techniques and a variety of training methods, to give all participants the best opportunities for learning including:

  • Class session
  • Group discussions
  • Simulations exercises
  • Case studies and problem solving exercises
  • Individual assignments
  • Templates and tools

Course Contents

  • Corporate Financial Statements
  • Analysis of Financial Statements
  • Forecasting Annual Revenues
  • Forecasting Financial Statements
  • Forecasting Seasonal Revenues
  • The Time Value of Money
  • Cash Budgeting
  • Cost of Capital
  • Profit, Break Even, and Leverage
  • Capital Budgeting
  • Valuation of Common Stocks

2019
Course Calendar Dates

11 Mar – 29 Apr

15 Apr – 3 May

13 – 31 May

10 – 28 June

15 – 26 July

13 – 30 Aug

16 – 27 Sept

14 – 31 Oct

18 – 30 Nov

03 – 21 Dec

Share this course

 

Cost: $ 3 500

 

Interested in a custom programme?
Beginning with the content of our existing offerings, we’ll work with you to create a program tailored to address the challenges of your organization.

Looking for more?

Let us follow up about more details about this program.