Intensive Finance Series: Financial Modelling
Intensive Finance Series: Financial Modelling
This practical hands-on program will show you how financial modelling is performed and how financial models are used.
Registration Options
Register by fax or email
You will need to download this registration form
-
Download fax or email registration form
PDF, 131kB
Downloads
-
Program Outline
PDF, 656kB -
Course Sample
PDF, 119kB
Related links
Program Summary
| TITLE: | Financial Modelling |
| CE: |
Up to 14hrs |
| FEE: | See program outline |
|
Sydney Sept 18 - 19, 2012 |
9:00am - 5:00pm |
|
Melbourne Dec 5 - 6, 2012 |
9:00am - 5:00pm |
About the Speaker
Alex Palfi, Principal, Tykoh Group Pty Ltd
Alex Palfi is a Principal of Tykoh Group Pty Ltd – an Australian based training provider specialising in tailored one and two day workshops on technical finance and business topics.
Prior to setting up Tykoh Alex was a Division Director at Macquarie Group in Sydney. In that role he developed a range of finance workshops and presented those in Australia and at other international locations. Those workshops focused on financial modelling, valuation, derivatives, credit risk and Visual Basic programming.
In earlier roles Alex worked for a number of financial services organisations as a financial software developer and 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.
About this program
Financial modelling is a dynamic creation that represents the present and future states of a financial entity. This two-day program shows you how financial modelling is performed and how it is used. It is ideal for participants that want to learn the principles and practice of designing or maintaining their own models. You’ll need intermediate spreadsheet skills and an understanding of accounting concepts such as balance sheets, cash flow statements and profit and loss.
What will you learn?
On the first day you’ll cover core modelling concepts and practices and extend this knowledge on the second to learn:
- The relationship between discount rates and present and future value;
- Internal rate of return;
- How to perform specific financial functions via spreadsheet;
- How to develop models using spreadsheet tools and features;
- Benefits and outcomes of financial modelling;
- How to design a financial model;
- How to apply the finance concepts of inflation, term structure and the cost of capital;
- How to apply Excel’s Goal-seek and Solver to modelling problems; and
- How Visual Basic can be used in modelling to automate routine or repetitive tasks.
Testimonials
Understanding the complex Excel tips was very beneficial.
I learnt some very useful functions to save time and to make my spreadsheets more efficient.
The DVD will be very helpful!
Alex Palfi is extremely knowledgeable, patient and concise.