KapitalBiz Consulting Course
Financial Analysis & Forecasting
- Date 20 – 22 May
- Format Live Online Training
- 12 Lessons
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

Predictive Maintenance & Reliability Course
12 – 14 June
Live Online Training
