Skip to content

KapitalBiz Consulting Course

Financial Analysis & Forecasting

Share
Thorough forecasting of the financial performance of a business is key to its success. Both established companies and small enterprises depend on financial forecasting and analysis to determine the allocation of their resources in addressing expected expenditures ahead. This intense 3- day interactive masterclass goes beyond the typical financial analysis courses. It uses both the principles of analysis and the power of Excel to identify the strategic drivers that can enhance the shareholder value of your organization.

Using Excel, delegates will learn how to master the tools and techniques it provides to apply the latest financial analysis techniques, understand what the numbers are revealing, and be better able to make strategic and tactical decisions and predict the outcome of these decisions. The masterclass proceeds from basic financial analysis to more advanced techniques for determining the cost of capital, methods of projecting the benefit of capital projects, Also, using Excel, delegates will learn how to evaluate organizations with which they are planning to do business, and determine if they are able to provide strategic strength to their companies.

Participants are encouraged to ask as many questions as possible, to develop their knowledge by enquiry. The presentation will be delivered online, in an intensive, inclusive, and informal manner. It will be a combination of the instructor’s presentations, interspersed with case study material, tutorial videos, and exercise files so you can practice what you would have learnt.

Local Fee R 13,999

International Fee $ 900

What it’s all about

Why you should attend

On completion of this masterclass delegates should be able to:

  • Understand the principles forming the foundation of financial analysis
  • Use the powerful tools in Excel such as the Financial and Statistical functions and tools such as the Data Analysis toolbox, and Sensitivity analysis tools and Scenario’s
  • Analyse a company’s annual report identifying key performance indicators to understand what the numbers are really saying and make projections of future performance and benchmark corporate performance against peer groups and industry statistics
  • Analyse risks using scenarios and sensitivity analysis
  • Analyse time series data and develop forecasts
  • Use Excel with more confidence and flexibility, thus saving large amounts of time and enhancing productivity
  • Learn about future trends in forecasting
  • Know the purpose of forecasting and its role in strategic planning

▪ Financial Statement Elements
▪ Analysis of Financial Statements
▪ Classification of Expenses and Break-even Analysis
▪ Allocation of Overhead and Indirect Costs
▪ Activity-based Costing and Activity-based Budgeting
▪ Budgeting Techniques and Budget Variances

▪ Relevant Costing for Decision-Making
▪ Transfer Pricing
▪ Time Value of Money
▪ Capital Budgeting and Sensitivity Analysis
▪ Managing Working Capital

▪ Financing Assets (Short-term vs Long-term)
▪ Equity vs Debt
▪ Forecasting Techniques
▪ Risk and Return
▪ Alignment to Strategic Plan
▪ Economy, Efficiency and Effectiveness

Ideal Participants for This Program

Who should attend

All financial professionals including those who are responsible for ensuring the effective use and management of corporate funds. Also, sales and marketing professionals, research professionals, and anyone who needs to understand the short and long-term financial impact of key decisions. Participants should have a basic understanding of financial statements and may bring their own laptop with a full installation of Excel, including the complete “Toolbox”.

  • CFOs / Financial Directors / Executives
  • Financial Accountants
  • Financial Managers
  • Financial Controllers
  • Financial Analysts
  • Business Analysts
  • Credit Analysts
  • Equity Analysts
  • Accounts Officers
  • Treasurers
  • Commercial Bankers
  • Project Managers
  • Internal & External Auditors

Book Your Spot

Financial Analysis & Forecasting

Recommended Courses

Project Portfolio Management

3 – 6 June

NH Hotel Sandton / Live Online

Predictive Maintenance & Reliability Course

12 – 14 June

Live Online Training

Finance for Engineers & Technical Managers

24 – 26 April

Live Online Training