course | Financial Analysis, Modelling & Forecasting
We turn your development needs and aspirations into powerful digital solutions that drive growth
FNBN-1942 | Financial Analysis, Modelling & Forecasting
Course Sector : Finance, Accounting and Banking
| Duration | Date from | Date to | Course Venue | Course fees | Book a course |
|---|---|---|---|---|---|
| 5 Days | 2025-05-05 | 2025-05-09 | Dubai | $4,250 | Book now |
| 5 Days | 2025-07-14 | 2025-07-18 | Los Angeles | $5,950 | Book now |
| 5 Days | 2025-10-26 | 2025-10-30 | Riyadh | $4,250 | Book now |
Course Introduction
In the globally competitive world of the 21st century business decision-makers face unprecedented levels of risk and uncertainty - to survive and flourish in this challenging environment organisations need the right tools with which to analyse problems and anticipate and manage the many opportunities and threats that may emerge.
Traditional forms of financial analysis and forecasting no longer meet these needs and the most progressive firms are using the power of financial models to help them analyse the challenge and take a more powerful approach to managing risk in their planning and forecasting.
This leading-edge training course will focus on the financial analysis and modelling skills that the modern finance professional need to manage the risks and uncertainties in today’s challenging world, providing high-quality business support to the organisation’s key decision-makers.
This training course will highlight:
- The challenge of risk and uncertainty in modern business
- Principles of business planning and performance management
- How financial models can be used to improve business decision-making
- Practical skills in designing financial models using Excel
- The design of financial models for forecasting and decision-making
Course objective
- Plan the design and functionality of financial models in Excel
- Use powerful functions built in to Excel for statistical and financial analysis
- Apply financial analysis techniques to improve investment decision-making
- Design and build financial models for forecasting sales, costs and profit
- Implement up to date techniques for managing risk and uncertainty
- Use financial models to assist in business decision-making
Course Outline | Day 01
TOOLS TO MEET THE CHALLENGES OF THE 21ST CENTURY
- The nature and challenge of competitive business
- Managing risk and uncertainty
- Business planning and performance management
- Measuring the key drivers of business success
- Financial models – what they are and how to use them most effectively
- Best practice in building financial models
- How to get the best results using Excel
Course Outline | Day 02
BUILDING MODELS FOR FINANCIAL STATEMENT AND RATIO ANALYSIS
- The financial analysis tool kit
- Building a company financial database in Excel
- Excel charting basics
- Analysing the cost-volume-profit relationship
- Understanding the drivers of shareholder value
- Modelling and interpreting financial rations
- Using the model to improve business performance
Course Outline | Day 03
BUILDING FORECASTING MODELS
- Understanding the drivers of profit and cash flow
- Designing and building a cash flow forecast model
- Using Excel’s built-in data analysis tools
- Analysing trends in past data – moving averages and regression tools
- Designing and building a sales forecast model
- Designing and building a cost forecast model
- Avoiding common problems in forecasting
Course Outline | Day 04
BUILDING MODELS FOR CAPITAL INVESTMENT DECISIONS
- Principles of capital investment decision-making
- Building a model to calculate company cost of capital
- The time value of money and principles of discounted cash flow (DCF)
- Understanding and using Excel’s built-in DCF functions
- Designing and building a capital investment appraisal model
- Principles of business valuation
- Designing and building a business valuation model
Course Outline | Day 05
BUILDING MODELS FOR MANAGING RISK AND UNCERTAINTY
- The impact of risk on financial performance
- Identifying the key drivers of financial performance and strength
- “What if” forecasts and how they work
- Designing and building a financial statement forecasting model
- How to use Excel Goal Seek tool
- Using Excel’s Scenario Manager tool
- Building rolling forecast models in Excel
BOOST’s Professional Attendance Certificate “BPAC”
BPAC is always given to the delegates after completing the training course,and depends on their attendance of the program at a rate of no less than 80%,besides their active participation and engagement during the program sessions.
Upcoming Courses In This Sector
Since 2001, we have been pioneering the training field in the Middle East, helping individuals, teams, and organizations reach their full potential with integrated solutions.
🔗 Quick Links
Sister Companies to Boost Consulting and Training
most trending
And Recommended Training Courses
We believe in progress for everyone.
We helped more than 10,000 clients over 20 countries on 4 continents in boosting their knowledge, skills, and careers.
Boost Training And Consulting All Copyrights Reserved 2025