Financial Modelling Training
Our Excel Financial Modelling courses are hands on, you will discover best practice modelling principles to creating real life, in-depth financial models. You will be guided through the entire model build life-cycle from planning to output. You will learn the skills and techniques required to construct and maintain your own accurate and flexible financial models for a wide range of scenarios.
You will master key financial calculations necessary in the production of powerful financial models. You will cover model construction, assumptions, advanced excel functionality, detection and prevention of errors, sensitivity analysis, presentation of model output and tips and tricks.
Courses can be run daily, half daily or regularly as your team discovers Financial Modelling.
You can choose from our Getting Started; Intermediate; Advanced and Guru courses or we can tailor build a course for you.
Some of the topics we cover are:
- Best Practices
- Accounting Fundamentals
- Excel Tools for Modelling
- Audit and Error Checking
- Building a model from scratch
- Financial Statements
- Balance Sheets
- Discounted Cash Flow
- Profit and Loss Statements
- Dashboard and Sensitivity Analysis
- Dynamic Dashboards
- Three Statement Model
- Mergers and Aquisitions
- Initial Public Offering
- Option Pricing
- IRR, NPV, XNPV, WACC
- Budgets and Planning
5 STAR EXPERT
Juanita was a great very informative and knowledgeable + VERY patient
Belinda Quinn – Trivett
Useful tips and ability of Juanita to interpret our comments to teach RELEVANT items.
Great flexibility to adapt to individual requirements.
Jeanette O’Neill – Georg Jensen
Clear and concise – got what I needed from this course.
Sam Brinton – Joyce Foam Products
Fantastic course, interesting
Louarna Brown – Joyce Foam Products