Business and Financial Modelling
Course Info
Length:
Type:
Course ID:
Course Details
Introduction
Objective
Who should attend
Good financial models don’t just crunch numbers — they help you make better decisions. Whether you're deciding on an investment, evaluating a new project, or trying to understand the financial impact of a major move, modeling gives you a way to see the big picture and stress-test your assumptions.
That’s what this Business and Financial Modelling course is built around. It’s not just about using Excel or knowing the formulas (though we’ll cover those too). It’s about building models that hold up under pressure — models that are structured, clear, and built for real-world use.
Across five days, we’ll dig into everything from time value of money and capital budgeting to scenario planning, valuation techniques, and advanced tools like Solver and Goal Seek. You’ll work on practical problems, build models from scratch, troubleshoot issues, and learn how to present your results so they support smart decisions.
Course Outline
Introduction to Financial Modelling and Time Value
- Definition of Financial Model and why companies use financial models
- Describing the process and key steps of creating reliable financial models
- Techniques to improve traditional financial models and the role of Flowcharting
- Introduction to Time Value of Money (TVM): Definitions, principles, and formulas
- Identifying the core applications of the Time value of money concepts in financial models :
- Weighted Average Cost of Capital (WACC) in capital budgeting models
- Net Present Value (NPV) in making capital expenditure decisions
- Internal Rate of Return (IRR) in making capital expenditure decisions
- Guidelines for using the built-in functions for NPV, IRR, and MIRR
