 |
|
|
|
This course provides participants with grounding in advanced spreadsheet modeling techniques that can be effectively implemented, and are easily transferable across a range of models.
At the end of this course participants will be able to:
- Build reliable and robust financial models
- Implement good practice modeling techniques Produce financial forecasts and sensitivity analyses
- Manipulate large amounts of Data using Excel list and pivot table functionality
- Use financial functions where appropriate and know the work around techniques for limitations
- Write VBA macros & the Excel object model
Content includes:
- Overview of the integrated model: basic modeling concepts; 'good practice' style guide.
- Structuring the model: laying out of inputs, workings and outputs, good modeling practice.
- Sensitivity and scenario analysis: techniques for identifying key value drivers and risks for a company
- Data analysis
- Introduction to macros and the Excel object model
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
1 Day Financial Statement and Analysis 
In-depth study of the analysis and interpretation of financial statements by external decision makers. The course includes measures of liquidity, solvency, capital structure, return on investments, and operating performance. The impact of accounting conventions and alternative standards on analytical measures is also explored.
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
Risk Management
2 Days on Risk and Credit Management
This 2-day course will enable participants to understand the key challenges for banks in the implementation of the Accord. The course will examine the Three Pillars of the Accord. Minimum Capital Requirements, Supervisory Review Process, and Market Discipline, and the regulation Credit, Market and Operational Risk. Particular attention will be directed at the regulatory framework in relation to Credit Risk, including the various Standardized and IRB Rating Approaches and impacts on Securitization activities.
The course will also examine the impact of Basel II on management practices; including strategic planning, product pricing and optimal risk profile. The Course makes extensive use of workshop exercises which examine the issues involved in implementing the Accord as well as potential financial and performance implications .
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
2 Days Currency Hedging For Corporate
The demands being made on corporate treasuries are increasing all the time. The globalization of markets and intensified competitive pressure is resulting in an ever larger and more complex field of activity. Exchange rates have experienced erratic fluctuations in recent times; a trend which is unlikely to change in the near future.
An effective hedging programme does not attempt to eliminate all risk. Rather, it attempts to transform unacceptable risks into an acceptable form. The key challenge for the corporate risk manager is to determine the risks the company is willing to bear and the ones it wishes to transform by hedging.
This is the environment in which our 2-days Masterclass workshop is being conducted; offering treasury employees the chance to model corporate hedging according to its risk profile in a practical setting.
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
1 Day Fixed Income and Bonds
The course begins with an examination of the various types of bonds that can be purchased or issued and their characteristics. Calculation of price and yield are covered next. The implied forward curve is examined for indications of the direction interest rates will be moving and identifying the appropriate strategy for the interest rate forecast. The course splits into controlling risk in floating rate notes and then fixed rate notes. Libor based derivatives are applied to controlling interest rate risk. Then credit spread derivatives are applied to control credit premier risk and default risk. Emphasis next turns to the fixed rate bond and how to control interest rate risk using Treasury futures and Futures options. Lastly focuses turns to the possibility of international investments, and the need for currency hedging.
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
1 Day Investment Analysis
A variety of financial instruments and their valuation will be explored. Topics include the basis of financial engineering, dividend discount models, modern portfolio theory, bond valuation, and the management of interest rate risk. Concepts such as no-arbitrage pricing and diversification will be developed and applied.
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
1 Day Advanced Investment Analysis
Security valuation and portfolio management and analysis, empirical evidence, imperfections, and institutional implications. Applicable articles, cases, and problems will be assigned.
Treasury & Capital Markets
1 Day A Primer To Fx & Money Markets
With increased volatility in the currency markets, it is important that bankers as well as non-bank corporate treasurers understands the mechanics driving the foreign exchange markets. This course will provide delegates with a sound understanding of the dynamics of the global foreign exchange markets, factors which impact foreign exchange rates, pricing mechanisms, market practices and application of various products to hedge foreign exchange risks.
This fundamental 1 day programme will provide delegates with a sound understanding of the dynamics will provide delegates with a sound understanding of the dynamics of the international money markets, factors which impact interest rates, pricing mechanisms, market conventions, the array of money market instruments like CD, T-Bill, BA, CP and MAS Statutory reserve requirements.
For more information contact us @ 6887 4190 or: enquiry@aventisgroup.com.sg
Derivatives Market
1 Day
A Primer To The Derivative Markets
The central theme of the program is on trading strategies using options and other derivatives across the full range of asset class. The Course Director will demonstrate various client strategies for yield enhancement and for generating controlled loss management. Trades, investment advisors, hedgers and end-users of derivative products will find this an excellent course which answers product related and pricing issues.
This 1 day intensive Masterclass course will demystify the various product structures and highlight the benefits of derivatives as a core component in every modern portfolio
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
2 Days Credit Derivatives (Structuring, Pricing & Applications)
Credit derivatives, instruments that transfer credit and associated risks on credit assets by derivative contracts, have emerged as the most recent risk management topic for financial professionals throughout the world. Defaults by Enron and Argentina have been followed by other major defaults, including China Aviation Oil and Parmalat, and credit downgrades fro major borrowers, including GM and Ford. All of these events have had an impact on the CD Markets and on the structure of products traded.
This 2-day programme provides delegates with a comprehensive overview of credit derivatives - their evolution, the various types of CD contracts and pricing issues. Delegates will learn about the investors role in structuring CDs and finding the correct risk/reward mix. Some legal issues will be considered in this course as well.
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
Options Markets
1 Day
A Primer To The Options Markets
Study of options, including the following topics: the structure and operation of organized exchanges, investment strategies under different market scenarios, arbitrage pricing, the valuation of options as a mechanism to price corporate securities, portfolio insurance as a trading strategy, and recent developments in the options markets.
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
1 Day Options Trading Simulation
This is a one-day simulation of option trading and investment strategies. It is designed as a means of learning about option pricing, dynamics, combinations and risks by playing an extended game. The players trade against a set scenario, taking note of market and economic information, in a competitive spirit against the others. The game is not time-pressurized, but allows careful thought and analysis at each stage, and well as the opportunity to understand how the profit and loss figure has been derived.
Technical Analysis
3 Days
Identify & Analyze Trading Risks Using
Technical Analysis
This 3-day programme is designed to improve your understanding of technical trading and to provide a framework for its appropriate application in the real world.
The main objective of the course is to provide the tools necessary for traders to be able to identify and analyze the risk profile of financial markets price trends, in order to execute and manage with high confidence trades in the markets. It aims to:
- Refresh the theory behind a number of trading philosophies & methodologies
- Provide a critical analysis of the appropriateness of each of these techniques
- Gives insight into their real world use
Mergers and Acquisitions
2-Days Merger & Acquisition
The second wave of M&A has arrived. Shareholder value conscious, carefully targeted, and with rigorous attention to valuation, due diligence and post merger integration, companies in Asia are finding that entry into difficult markets and quick expansion can often be best served by strategic acquisitions. Often these have been created in new formats, combinations of joint ventures, strategic alliances and minority stakes, as well
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
Behavioral Finance
Masterclass on Behavioral Finance
This intensive introductory day course is designed to meet the contemporary market demand for the latest in this new finance and its implications and applications for fund and product managers, traders and investors. Participants will be introduced and will have the opportunity to analyze and workshop some of the types of irrational dysfunction that often occurs in the financial market and industry environment.
The key focus of the course will be on the recognition, the taking account of, mitigation and finally opportunities of using the principles in behavioral finance in their day-to-day work environment be it as an individual or institutional decision maker.
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg
International Financial Markets
Covers such topics as foreign exchange markets and their role in international movements of funds; Eurocurrency; Eurobonds; international stock markets, interaction among and integration of national and international money and stock markets; and regulation of Eurocurrency markets and flow of funds.
For more information contact us @ 6887 4190 or : enquiry@aventisgroup.com.sg