Wellington, 14-15 May 2012
This course covers various aspects of best-practice financial modelling including the finance, accounting, spreadsheet and design skills that underlie successful financial modelling.
The high practical content of this course is supported by some theory and discussion, providing a valuable, intensive learning experience. All participants will be provided with their own laptop and software for use in practical exercises.
Key Benefits of Attending:
- Gain best-practice hands-on experience applying excel functions and tools to the financial modelling process
- Discover the finance and accounting concepts that underlie financial modelling
- Learn the objectives, principles and methods of financial modelling
- Learn how to design and construct a set of models that illustrate and apply the techniques of financial modelling
PART 1: Excel functions and tools that are useful in modelling
A broad range of Excel functions and tools are useful in modelling. These are reviewed in this section of the course. Later sections then apply those functions and tools in practical settings.
- Logical, referencing and aggregation functions.
- Arithmetic functions
- Ranking functions
- Error handling functions
- Date functions
- Financial functions
- Other tools and features
PART 2: Accounting and finance concepts that underlie modelling
Financial modelling builds on accounting and finance concepts. This section reviews the accounting and finance theory that is needed for effective financial modelling.
- Balance Sheet
- Income statement
- Cash flow statement
- Inter-relationship between the statements
- Finance concepts
PART 3: An overview of the modelling process
This section reviews the objectives, principles and methods of financial modelling
- Objectives of models
- Design principles
- Layout, structure, formatting and presentation of a good model
- Key design stages
PART 4: Financial modelling: Exercises and applications
This section covers practical exercises in constructing and applying financial models. Topics covered include the following
- Structuring the model.
- Logical organisation of tabs and worksheets.
- Determining appropriate periodicity: e.g. Aligning with calculation dates of debt covenants, dealing with seasonal effects
- Dealing with one-off / irregular or short-term events
- Prioritising and apportioning claims on cash flows: e.g. Debt service, CAPEX, dividend payments
- Planning for sensitivity / scenarios / stress-test analysis.
- Generating summary sheets : High and low level model results
- Model consistency checking and reporting
- Calculation of ratios
- Model versioning, documenting and testing
The course facilitator is: Alex Palfi , Principal, Tykoh Group Pty Limited
Alex Palfi is Principal of Tykoh Group Pty Limited - an Australian-based training provider specialising in tailored one and two day workshops on technical finance and business topics.
Prior to setting up Tykoh in January 2009 Alex was a Division Director at Macquarie Group in Sydney. In that role he developed a range of finance workshops both for Macquarie and non-Macquarie people and presented those workshops internationally in London, New York, Tokyo, Los Angeles, Korea, Hong Kong, Singapore, Taipei, Johannesburg, Bangkok, Sao Paulo, Sydney, Melbourne, Auckland and Wellington. Those workshops focused on Financial modelling, financial spreadsheets, valuation, derivatives, credit risk and Visual Basic programming.
Prior to joining Macquarie in 1994 Alex worked for a number of financial services organisations as a financial software developer and before that lectured at Technical Institutes in New Zealand in programming and electrical engineering.
Alex's university qualifications are in engineering. He obtained Masters and Bachelors degrees in Electrical Engineering from the University of Canterbury in New Zealand.
Please click here to download a copy of the conference brochure and for more information on how to register for this event.
CSNZ confirms that this event qualifies for Structured CPD credits based on 1 credit per hour of attendance.