INTRODUCTION TO FINANCIAL MODELLING
Duration: 2 Days
This course, which we are currently only offering as a private in-house course, is aimed at potential users, developers and reviewers of financial models who wish to improve their modelling capabilities. This two-day course explores the latest financial modelling concepts and guides participants through the end-to-end development of a fully integrated financial model adopting best practice modelling methodology.
The Modular Build-up approach focuses on incrementally building a financial model which results in a clear and transparent model which is easy to understand and manage.
Key topics covered on this course
- Model setup (sections, worksheets, internal checks etc.)
- Inputs, scenario manager and running scenarios
- Dates and flags
- Escalation
- Setting up financial statements with opening balances
- Revenue and operational expenditure drivers
- Working capital
- Capital expenditure and depreciation
- Introduction to debt
- Introduction to corporate tax
- Equity and distributions
- Introduction to valuation methodologies (NPV and IRR)
This course is right for you if you have:
- General familiarity with Excel in a financial environment
- Knowledge of basic Excel functions
- Basic understanding of accounting and finance fundamentals
You don’t need to know:
- VBA
- Advanced Excel functions