Financial Modelling in Excel Training Course
| Date | Location | Venue | Investment | Register |
|---|---|---|---|---|
| 23 Jul - 25 Jul, 2008 | HK, Hong Kong | Royal Garden Hotel | US$3998 |  |
| 19 Nov - 21 Nov, 2008 | SG, Singapore | Marina Mandarin Hotel | US$3998 | |
*18 seats only for each public session
What will you get out of this Financial Modelling in Excel training course?
This course provides a sound understanding of both the principles of financial modelling and the practical application of these to real-world situations through the use of spreadsheets.The course then builds upon the financial modelling principles and practices learned to apply these to company valuations. In this, you will improve your mastery of company valuation principles and concepts, and then see how to apply these in practical applications.
Finally, the course describes how to both detect and prevent errors from occurring.
In three days, you will:
- Gain a good working knowledge of the most useful functions in Excel for financial modelling
- Gain a sound understanding of financial modelling and company valuation concepts
- Gain experience in designing solutions to real-world financial modelling challenges
Financial Modelling in Excel Training Course Agenda
Optional Pre-Course Advanced Excel WorkshopFor those that are not familiar with Excel functions needed for this modelling course should also attend the Advanced Excel Workshop.
Part 1: Financial Modelling Principles & Practices
Introduction to Financial Modelling
- What is a model?
- Spreadsheet models
- Types of models
- Steps in model building
- Best practice guidelines and spreadsheet modelling standards
- Designing for flexibility and scalability
- Designing for consistency
- Designing for usability and functionality
- Designing checks and balances
- Using VBA in financial models
Principles of Risk and Return
- Volatility
- Capital Structures
- Weighted Average Cost of Capital (WACC
- Cost of Equity Capital
- Role of valuation
- Approaches to valuation
- Accounting concepts behind balance sheet, income statement and cash flow.
- Free cash flow to the firm and financial statements
- Analysing past performance
- Forecasting future performance
- Discounted cash flow modelling
- Sensitivity analysis and an introduction to Monte Carlo simulation
- Capitalisation of earnings and other valuation methodologies
- Interpreting results
Financial Model Auditing/Review
- Why audit?
- Excel’s auditing tools
- Automated testing tools: role, purpose and limitations
- Demonstration
- Model documentation
- Overview: purpose, advantages, disadvantages
- Demonstration
Who should attend this Financial Modelling in Excel training course?
- Corporate treasury staff
- Finance staff
- Corporate financiers and Investment bankers
- Financial controllers
- Commercial bankers
- Business and financial analysts
Run this course in-house
Consider running this course as an in-house course where you want, when you want and tailor the course to how you want it.
You can gather a group of your colleagues and/or invite your clients.
Find out more about running this course or any other one of our courses in-house.
Why Ethan Hathaway?
- Practical. Learn from experienced industry practitioners and what's being practiced by your peers.
- Applicable. Apply what you learn in your job and your career
- Valuable. Earn more revenue or save your organisation from monetary loss . You and your organisation will quickly earn back your investment on the course fee and more
- Enjoyable. Speakers who have a passion for their topic
- Clear. Turning complex concepts into easy to understand concepts
Learn more about this course
Inside the course information booklet you'll find:
- Detailed course agenda of what you'll learn
- Eligible discounts
- Our course quality guarantee
- Course expert biography
- Course venue details
- Course registration form
- Printer-friendly PDF
- Small file size for fast & easy download
Complete the details to the right and click on "Send me the booklet" to have the course booklet emailed to you immediately.
We will never sell, rent or exchange your details to any 3rd parties. We value your privacy.
Register for the course
You may book your place on the course by any of these methods:
- Online booking - simply click on the "Register Me" button next to the course date you wish to register and it will take you through our quick online registration procedure.
- Email us at:
- please include your full contact details. - Fax us the booking form (included in the brochure) to: UK: +44 87 1715 0414 / Hong Kong: +852 3014-0721
- Or call: +852 2273-4393 during normal office hours
Financial Modelling in Excel Training Course
| Date | Location | Venue | Investment | Register |
|---|---|---|---|---|
| 23 Jul - 25 Jul, 2008 | HK, Hong Kong | Royal Garden Hotel | US$3998 | |
| 19 Nov - 21 Nov, 2008 | SG, Singapore | Marina Mandarin Hotel | US$3998 | |