Value, risk and return three of the central concerns of finance all derive from mathematical foundations. Mathematics describes the dynamics of financial markets, it determines the values and risk exposures of financial positions and it connects the performance of financial structures to those structures constituents. In short, mathematics pervades finance.
Mathematics allows us to describe, understand, measure, manage and engineer financial products and positions for our benefit.
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.
This course will be of benefit to those market participants who are seeking to gain an understanding of the mathematical concepts in finance using spreadsheets. It will suit a broad spectrum of participants in financial markets who regularly use spreadsheets.
With a heavy emphasis on utilising the financial functions of spreadsheets, this workshop will explore:
This workshop assumes that you are able to use absolute and relative addressing in Excel and be able to enter mathematical formulae into cells as well as understand and be able to apply the concepts of discounting, present and future value, simple and compound interest.
The practical nature of this course was very useful. Using Excel as we went through the topics was great.
A very good course and presenter.
Its an excellent training course. Very helpful.