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:
Have a question? Email us at: support@ethanhathaway.com or call us at: (+852) 2376-3330
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
- Agenda highlights
- Who should attend
- Reviews
Advanced Financial Modelling Course Agenda Highlights
Part 1: Building Blocks
Ethan Hathaway Advanced Financial Modelling Digital Badge of Completion – Earn this when you complete the course!
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:
Have a question? Email us at: support@ethanhathaway.com or call us at: (+852) 2376-3330
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. ALL Certified and Non-Certified Delegates get the following:
Video lessons
On-demand video lessons so you may watch at your own convenience.
Downloads
Downloadable PDF notes & slide decks and resources for your future reference.
90-Days Access
You have access to the most updated course for 90-days
Anywhere Access
Access the course with any Internet-enabled device. No software or special requirements needed.
Get Answers
Our online distance learning course sessions include scheduled Question and Answer (Q&A) sessions where you can submit any questions specific to your situation or about anything in the course.
Q&A sessions are recorded for you to view at your leisure.
It's the closest you can get to getting personalised coaching.
Certificate of Completion
After completing the training, you receive a digital & printable Ethan Hathaway 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.
For Corporate Plans (multi-user access), please contact us at: support@ethanhathaway.com
Book Your Seat
Date | Location | Venue | Course Fee: | Early Bird | Register |
|---|---|---|---|---|---|
3 April-31 May 2017 | Online | Distance Learning | USD 999 | Download brochure | |
3 July-31 August 2017 | Online | Distance Learning | USD 999 | Download brochure | |
4 September-31 October 2017 | Online | Distance Learning | USD 999 | Download brochure |
* Venue, dates, course fees, promotions, course content, course instructor are all subject to change
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.