Advanced Financial Modelling and Valuation Training Course

This five-day advanced course builds the skill to model valuation, scenarios and transactions to a professional standard. It covers discounted cash flow valuation, scenario and sensitivity modelling, and the models behind mergers, acquisitions and leveraged buyouts. Building on a sound three statement foundation, participants leave able to value businesses and projects, model complex decisions, and produce the analysis that investors and boards rely on.

Once you can build a sound model, the real value lies in what you do with it: valuing a business, weighing an acquisition, testing a decision against a range of futures. These are the models that sit behind the biggest decisions an organisation makes, and the ones where error is most expensive. They demand both technical skill and judgement.

This course builds both. It assumes a working three statement model and moves into discounted cash flow valuation, rigorous scenario and sensitivity analysis, and the specialist models used in mergers, acquisitions and leveraged buyouts. Each is built and stress tested in Excel, with attention to the assumptions that drive results and the judgement needed to interpret them. Participants leave able to value a business or project with confidence, model complex transactions and decisions, and present analysis that stands up to the scrutiny of investors, lenders and boards.

By the end of this program, participants will be able to:

1. 01Build models on a sound three statement foundation.
2. 02Apply discounted cash flow valuation in full.
3. 03Estimate and apply the discount rate and terminal value.
4. 04Build robust scenario and sensitivity analysis.
5. 05Model mergers and acquisitions.
6. 06Build a leveraged buyout model.
7. 07Apply relative and multiples based valuation.
8. 08Stress test models and interpret the results.
9. 09Present valuation and transaction analysis with confidence.

This course is designed for:

•Financial analysts and modellers

•Corporate finance and M&A professionals

•Investment and private equity analysts

•Valuation and transaction advisers

•Treasury and strategy professionals

•Bankers and credit analysts

•Consultants building valuation models

•Experienced analysts deepening their skills

The course is built around constructing advanced models in Excel. Each technique is demonstrated and then applied to a worked case, and participants build valuation and transaction models over the week. The emphasis is on both technical accuracy and the judgement behind the assumptions, with a daily practical session deepening the build.
•Live demonstration of advanced techniques
•Valuation and transaction model building
•Scenario, sensitivity and stress testing
•Worked transaction and valuation cases
•A daily practical session and a final modelling clinic

Organizations that invest in this training for their teams will gain:

•Reliable valuations behind major decisions
•Better assessed investments and transactions
•Risk surfaced through scenarios and stress tests
•Stronger, more credible analysis for boards and investors
•Fewer expensive errors in high stakes models
•More disciplined assumptions and review
•Faster, more confident transaction analysis
•A finance team trusted with the hardest models

Participants who enroll in this training will benefit from:

•Confidence to value businesses and projects
•Command of discounted cash flow and multiples
•The ability to model complex transactions
•Stronger scenario and sensitivity skills
•Sharper judgement on assumptions and drivers
•A scarce, high value analytical specialism
•Greater influence in investment and strategic decisions
•Advanced model templates and a working toolkit

At Strategic Revenue Africa, our certification goes beyond proof of attendance—it represents practical competence and measurable capability. Upon successful completion of our training programs, participants are awarded a Certificate of Completion from Strategic Revenue Africa, recognizing their ability to apply acquired knowledge in real-world settings. As an organization focused on architecting sustainable revenue and strengthening organizational performance, our certifications signal that participants are equipped with skills that drive results, not just theory.

A sound grasp of financial statements and the ability to build or work with a three statement model are assumed. Our financial modelling course is a strong precursor. A laptop with a current version of Excel is required, and a working command of English is sufficient.