Gain the Latest Sophisticated Techniques to Improve Usability, Reliability and Your Effeciency in Your Financial Models
Advanced Financial Modelling & Valuation Training Course
This course is designed to provide you with a range of techniques, ideas, concepts and methodologies that will take your modelling skills to the next level.
Take Your Financial Modelling Skills to the Next Level
This course is designed to provide you with a range of techniques, ideas, concepts and methodologies that will take your modelling skills to the next level.
How You Benefit from this Course
- To provide experienced modellers with a deeper understanding of financial modelling methodologies, techniques and approaches.
- To provide you with a structured approach to modelling that generates models that are reliable, robust, controlled, extendable and easy to use.
- To provide solutions to common modelling problems.
BONUS: As an attendee, you also receive:
- Worked examples
- Suggested Solutions
- Reference Materials
- Large variety of templates
FREE Financial Modelling Toolkit
Download the Course Info Kit below and you'll also receive:
- Excel skills rating tool
- Financial Modelling in Excel Tips Series
- Course Information Booklet
View the detailed course content and the latest discount promotions:
Ready to Enroll?
Click on the button below to enroll
Have a question? Email us at: support@ethanhathaway.com or visit the help center.
Lot of discoveries can relate things effectively...what I liked most about this course was the discovery of significant functions of Excel which was previously I have no interest in making use of it.
DHL, Singapore
- Who should attend
- Reviews
Advanced Financial Modelling Course Agenda Highlights
Part 1: Building Blocks
Financial Modelling in Excel
- Key functions used in modelling
- Advanced range names, including formulas and naming conventions
- Pivot Tables
- Scenarios, sensitivity, data tables
- Best practice guidelines and spreadsheet modelling standards
Financial Modelling Overview
- Modelling fundamentals
- Steps in model building
- Key concepts
Part 2: Advanced Modelling Techniques
Model Components
- Capital budgeting & depreciation modelling
- Debt modelling
- Capital Structure
- Ratio analysis
- Tax considerations
- Inflation
- Reporting considerations: changing timescales, changing currencies, units
Specific Purpose Modelling
- Company valuation & financial statement simulation
- Project evaluation
- Mergers & Acquisitions
- Divestiture
- High-growth companies
Part 3: Advanced Modelling Applications
- Multi-variable Monte Carlo Simulations
- Introduction to VBA Macros: useful functions and macros, and how to apply these to models
- Working with other people’s models
- Tracking and recording model changes
***Note: the online distance learning version may vary from the live course. Download the course information booklet for detailed information.
View the detailed course content and the latest discount promotions:
Ready to Enroll?
Click on the button below to enroll
Have a question? Email us at: support@ethanhathaway.com or visit the help center.
18 Seats Only
Only 18 seats available per session so you get more personal attention.
Reference Package
You also receive a Course Reference Kit to take away for future reference. (Value of $200.00)
Get Answers
All our trainings are built for interaction and for you to get the most out of the training for your job and situation.
Ask questions specific to your situation. It's the closest you can get to getting personalised coaching.
Certificate of Completion
After completing the training, you receive an Ethan Hathaway gold-embossed certificate of completion to mark your achievement.
Digital Badge of Completion
After completing the training, you ALSO receive an Ethan Hathaway digital badge of completion to mark your achievement which you may share on your social media profiles such as LinkedIn, Facebook, Twitter & more.
Online / Distance Learning Available
This course is delivered via online distance learning.
On-Demand lessons
On-demand video & text lessons so you may watch at your own convenience.
Downloads
Downloadable PDF notes & slide decks and resources for your future reference.
Unlimited Access
NEW: You have unlimited access to the most updated course, study at your own pace and schedule.
Anywhere Access
Access the course with any Internet-enabled device. No software or special requirements needed.
Digital Badge of Completion
After completing the training, you ALSO receive an Ethan Hathaway digital badge of completion to mark your achievement which you may share on your social media profiles such as LinkedIn, Facebook, Twitter & more.
Certificate of Completion
After completing the training, you receive a digital & printable Ethan Hathaway certificate of completion to mark your achievement.
For Corporate Plans (multi-user access), please contact us at: support@ethanhathaway.com
Online Self-Study Course
Personal
For personal use & learning only
USD 499
USD 297
Corporate
For multi-team member access
Contact Us
Available for In-House Training
There are currently no scheduled public sessions for this training, however, it is available as an in-house training.
Request an in-house training proposal below or learn more about In-House Training
Accredited By
Ethan Hathaway is accredited by the British Accreditation Council for Independent Further and Higher Education as an International Centre.